kuali - ORA-01017: invalid username/password; logon denied

3
votes

When I Execute the below command:

mvn -X validate -Pks-db,oracle -Dks.impex.url=jdbc:oracle:thin:@kuali.localdomain:1521:DB11G -Dks.impex.dba.password=Oracle123

I get the below exception:

Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.4:execute (validate-dba-config) on project ks-bundled-db: ORA-01017: invalid username/password; logon denied -> [Help 1] org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.4:execute (validate-dba-config) on project ks-bundled-db: ORA-01017: invalid username/password; logon denied

1
oraclemavenkuali
sqlplus sys/Oracle123 as sysdba and sqlplus KSBUNDLED/KSBUNDLED Works fine. This user is configured in POM.xml file. – Gaurav Bhaskar
"invalid username/password", can you access the db with the credentials you pass to Maven via the -D options? – A_Di-Matteo
Are you assuming it will default to a particular username? Or do you need -Dks.impex.dba.username="SYS AS SYSDBA"? – Alex Poole
Thanks all for suggestion. – Gaurav Bhaskar

1 Answers

3
votes

According to this document, you should be supplying the user name as well; their example is:

mvn validate -Pks-db,oracle -Dks.impex.url=jdbc:oracle:thin:@localhost:1521:XE -Dks.impex.dba.username="SYS AS SYSDBA" -Dks.impex.dba.password=<SYS password>

So you need to add to your command:

-Dks.impex.dba.username="SYS AS SYSDBA"

It isn't clear what you have set in your properties file or which value is needed/used; but it may be picking up your KSBUNDLED username, or the legacy MASTER name.