Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to bring up DAC after changing the DAC database password

Received Response
1
Views
1
Comments

We have changed the DAC user password in database. After that we are not able to bring up the DAC services. Below is the error log. Please help on how to resolve the issue


Log:

4 INFO Tue Nov 16 06:40:15 EST 2021 Application booting up...

6 INFO Tue Nov 16 06:40:16 EST 2021 Creating repository pool

7 SEVERE Tue Nov 16 06:40:30 EST 2021 MESSAGE:::ORA-01017: invalid username/password; logon denied


EXCEPTION CLASS::: java.sql.SQLException


oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)

oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)

oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)

oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

java.sql.DriverManager.getConnection(DriverManager.java:579)

java.sql.DriverManager.getConnection(DriverManager.java:190)

com.siebel.etl.database.ConnectionPool.getConnection(ConnectionPool.java:625)

com.siebel.etl.database.ConnectionPool.populate(ConnectionPool.java:655)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:202)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:163)

com.siebel.etl.database.ConnectionManager.init(ConnectionManager.java:198)

com.siebel.etl.database.ConnectionManager.<init>(ConnectionManager.java:133)

com.siebel.etl.database.ConnectionManager.getConnectionManager(ConnectionManager.java:106)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:162)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:231)

com.siebel.etl.bootup.ApplicationManager.doRefresh(ApplicationManager.java:140)

com.siebel.etl.bootup.ApplicationManager.refresh(ApplicationManager.java:130)

com.siebel.etl.bootup.ApplicationManager.initSysProps(ApplicationManager.java:82)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:189)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:199)

com.siebel.etl.bootup.ApplicationManager.lookup(ApplicationManager.java:269)

com.siebel.etl.net.QServer.setSpill(QServer.java:213)

com.siebel.etl.net.QServer.<init>(QServer.java:102)

com.siebel.etl.net.QServer.main(QServer.java:499)

8 SEVERE Tue Nov 16 06:40:30 EST 2021 MESSAGE:::Process failed during creation of connection pool Repository.


ORA-01017: invalid username/password; logon denied


EXCEPTION CLASS::: com.siebel.etl.database.DataBaseInitializationException


com.siebel.etl.database.ConnectionPool.populate(ConnectionPool.java:676)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:202)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:163)

com.siebel.etl.database.ConnectionManager.init(ConnectionManager.java:198)

com.siebel.etl.database.ConnectionManager.<init>(ConnectionManager.java:133)

com.siebel.etl.database.ConnectionManager.getConnectionManager(ConnectionManager.java:106)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:162)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:231)

com.siebel.etl.bootup.ApplicationManager.doRefresh(ApplicationManager.java:140)

com.siebel.etl.bootup.ApplicationManager.refresh(ApplicationManager.java:130)

com.siebel.etl.bootup.ApplicationManager.initSysProps(ApplicationManager.java:82)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:189)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:199)

com.siebel.etl.bootup.ApplicationManager.lookup(ApplicationManager.java:269)

com.siebel.etl.net.QServer.setSpill(QServer.java:213)

com.siebel.etl.net.QServer.<init>(QServer.java:102)

com.siebel.etl.net.QServer.main(QServer.java:499)


::: CAUSE :::

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


EXCEPTION CLASS::: java.sql.SQLException


oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)

oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)

oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)

oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

java.sql.DriverManager.getConnection(DriverManager.java:579)

java.sql.DriverManager.getConnection(DriverManager.java:190)

com.siebel.etl.database.ConnectionPool.getConnection(ConnectionPool.java:625)

com.siebel.etl.database.ConnectionPool.populate(ConnectionPool.java:655)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:202)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:163)

com.siebel.etl.database.ConnectionManager.init(ConnectionManager.java:198)

com.siebel.etl.database.ConnectionManager.<init>(ConnectionManager.java:133)

com.siebel.etl.database.ConnectionManager.getConnectionManager(ConnectionManager.java:106)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:162)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:231)

com.siebel.etl.bootup.ApplicationManager.doRefresh(ApplicationManager.java:140)

com.siebel.etl.bootup.ApplicationManager.refresh(ApplicationManager.java:130)

com.siebel.etl.bootup.ApplicationManager.initSysProps(ApplicationManager.java:82)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:189)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:199)

com.siebel.etl.bootup.ApplicationManager.lookup(ApplicationManager.java:269)

com.siebel.etl.net.QServer.setSpill(QServer.java:213)

com.siebel.etl.net.QServer.<init>(QServer.java:102)

com.siebel.etl.net.QServer.main(QServer.java:499)

9 SEVERE Tue Nov 16 06:40:30 EST 2021  

ANOMALY INFO::: 

 An exception occurred. Shutting down server...

MESSAGE:::SERVER CANNOT BOOT WITHOUT SERVER CONFIG VALUES 

EXCEPTION CLASS::: java.lang.RuntimeException


com.siebel.etl.bootup.ApplicationManager.doRefresh(ApplicationManager.java:157)

com.siebel.etl.bootup.ApplicationManager.refresh(ApplicationManager.java:130)

com.siebel.etl.bootup.ApplicationManager.initSysProps(ApplicationManager.java:82)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:189)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:199)

com.siebel.etl.bootup.ApplicationManager.lookup(ApplicationManager.java:269)

com.siebel.etl.net.QServer.setSpill(QServer.java:213)

com.siebel.etl.net.QServer.<init>(QServer.java:102)

com.siebel.etl.net.QServer.main(QServer.java:499)


::: CAUSE :::

MESSAGE :::Process failed during creation of connection pool Repository.


ORA-01017: invalid username/password; logon denied


EXCEPTION CLASS::: com.siebel.etl.database.DataBaseInitializationException


com.siebel.etl.database.ConnectionPool.populate(ConnectionPool.java:676)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:202)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:163)

com.siebel.etl.database.ConnectionManager.init(ConnectionManager.java:198)

com.siebel.etl.database.ConnectionManager.<init>(ConnectionManager.java:133)

com.siebel.etl.database.ConnectionManager.getConnectionManager(ConnectionManager.java:106)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:162)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:231)

com.siebel.etl.bootup.ApplicationManager.doRefresh(ApplicationManager.java:140)

com.siebel.etl.bootup.ApplicationManager.refresh(ApplicationManager.java:130)

com.siebel.etl.bootup.ApplicationManager.initSysProps(ApplicationManager.java:82)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:189)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:199)

com.siebel.etl.bootup.ApplicationManager.lookup(ApplicationManager.java:269)

com.siebel.etl.net.QServer.setSpill(QServer.java:213)

com.siebel.etl.net.QServer.<init>(QServer.java:102)

com.siebel.etl.net.QServer.main(QServer.java:499)


::: CAUSE :::

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


EXCEPTION CLASS::: java.sql.SQLException


oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)

oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)

oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)

oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

java.sql.DriverManager.getConnection(DriverManager.java:579)

java.sql.DriverManager.getConnection(DriverManager.java:190)

com.siebel.etl.database.ConnectionPool.getConnection(ConnectionPool.java:625)

com.siebel.etl.database.ConnectionPool.populate(ConnectionPool.java:655)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:202)

com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:163)

com.siebel.etl.database.ConnectionManager.init(ConnectionManager.java:198)

com.siebel.etl.database.ConnectionManager.<init>(ConnectionManager.java:133)

com.siebel.etl.database.ConnectionManager.getConnectionManager(ConnectionManager.java:106)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:162)

com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:231)

com.siebel.etl.bootup.ApplicationManager.doRefresh(ApplicationManager.java:140)

com.siebel.etl.bootup.ApplicationManager.refresh(ApplicationManager.java:130)

com.siebel.etl.bootup.ApplicationManager.initSysProps(ApplicationManager.java:82)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:189)

com.siebel.etl.bootup.ApplicationManager.getInstance(ApplicationManager.java:199)

com.siebel.etl.bootup.ApplicationManager.lookup(ApplicationManager.java:269)

com.siebel.etl.net.QServer.setSpill(QServer.java:213)

com.siebel.etl.net.QServer.<init>(QServer.java:102)

com.siebel.etl.net.QServer.main(QServer.java:499)

10 SEVERE Tue Nov 16 06:40:30 EST 2021  

 Shutting down server...

Answers

  • Did you change the password only in the database? Because DAC can't really dream about you changing the password somewhere else, and the message "ORA-01017: invalid username/password" sounds quite explicit.

    You maybe want to look for a document explaining the process so you will see where else the password should be changed other than in the database.