ORA-01507: database not mounted during the DBUA wizard (Oracle Update)

[joo_migueldimas]

Hello,

SAP: SAP ERP 6.0

DB: Oracle 10.2g

OS: Windows Server 2003 X64

I´m doing an update (Patch Set Update) to our oracle database from the version 10.2.0.2 to 10.2.0.5.

I´m following the readme file that is inside of oracle 10.2.0.5 media. I ran the Oracle Universal Installer and it finished with a successfully message as you can see in the following image:

So... as you may know, the second phase I need to run the DBUA, this is, next to this task I must run the Oracle Database Upgrade Assistant (DBUA) wizard to complete the oracle update activity and is in that specific task/wizard that I´m facing one error... I weird error.

I start well the DBUA wizard, without problems... and it show me the following:

... the error ORA-01507: database not mounted

ORA-01507: database not mounted

DBUA thinks this is a Rerun operation and is trying to connect to the database with oracle home E:\oracle\PRD\102. If you believe this is not a Rerun operation, remove the below file and invoke DBUA again.
E:\oracle\PRD\102\cfgtoollogs\dbua\logs\Welcome_PRD.txt

I tried to find that specific file that is mentioned in the error message (Welcome_PRD.txt) in that specific location but unfortunately I don´t see that file in that specific path . I only see two files, sqls.log and trace.log!

The database services are started:

I went to SQL Plus and I ran some commands (such as select * from v$database; SELECT * from v$version; select status from v$instance;) and this is the output of them:

So... can you help me please in way to understand what´s the problem and how to overcome this error, because I need to run the DBUA to finish the oracle Patchset update (10.2.0.2 to 10.2.0.5)!

Can you help me please? Thank you

Best regards,

João Dimas

[joo_migueldimas · Accepted solution]

Hello again,

More log files:

trace.log

...

[AWT-EventQueue-0] [13:1:48:125] [SQLEngine.done:1960]  Done called

[AWT-EventQueue-0] [13:1:48:234] [DatabasesPage.onDatabaseChanged:835]  OS Auth available for OH:=E:\oracle\PRD\102 for OracleSID :=PRD

[Thread-7] [13:1:50:890] [CompManager.setSelectedDatabase:1270]  setSelectedDatabase::oracleHome=e:\oracle\prd\102 sid=PRD

[Thread-7] [13:1:50:890] [CompManager.setSelectedDatabase:1301]  first run operation

[Thread-7] [13:1:50:890] [Database.checkOPS:2739] 

Inside checkOPS

[Thread-7] [13:1:50:890] [Database.checkOPS:2741]  Check cluster existence

[Thread-7] [13:1:50:890] [CompManager.setSelectedDatabase:1355]  Old home=e:\oracle\prd\102

[Thread-7] [13:1:50:890] [CompManager.setSelectedDatabase:1356]  New home=E:\oracle\PRD\102

[Thread-7] [13:1:50:890] [CompManager.setSelectedDatabase:1389]  To restore=true

[Thread-7] [13:1:50:890] [CompManager.obtainDatabaseInformation:1947]  Logging Dir at this point :=E:\oracle\PRD\102\cfgtoollogs\dbua\logs

[Thread-7] [13:1:50:890] [Database.getStepSQLInterface:678]  OH in database: e:\oracle\prd\102

[Thread-7] [13:1:50:890] [Database.getStepSQLInterface:682]  server manager at this Oracle home: null

[Thread-7] [13:1:50:890] [Database.getStepSQLInterface:706]  sqlplus created with home:=e:\oracle\prd\102 and sid:=PRD

[Thread-7] [13:1:50:890] [SQLEngine.getEnvParams:427]  NLS_LANG: AMERICAN_AMERICA.WE8DEC

[Thread-7] [13:1:50:906] [SQLEngine.initialize:244]  Execing SQLPLUS/SVRMGR process...

[Thread-7] [13:1:50:906] [SQLEngine.initialize:272]  m_bReaderStarted: false

[Thread-7] [13:1:50:906] [SQLEngine.initialize:276]  Starting Reader Thread...

[Thread-7] [13:1:51:296] [CompManager.obtainDatabaseInformation:1973]  validateConnectionToDB using user:=

[Thread-7] [13:1:56:500] [CompManager.obtainDatabaseInformation:1989]  ++++++++++ Checks DB Open Status++++++++++

[Thread-7] [13:1:56:500] [SQLEngine.done:1960]  Done called

[Thread-7] [13:1:56:609] [Database.isDBStarted:1903]  Exception during check for DB Started->assuming db down

[Thread-7] [13:1:56:609] [CompManager.startUpDBifDown:9534]  Database not up. Starting the database....

[Thread-7] [13:1:56:609] [CompManager.startUpDBifDown:9553]  no need to start the ASM

[Thread-7] [13:1:56:609] [CompManager.startUpDBifDown:9563]  Start the instance in UPGRADE mode.

[Thread-7] [13:1:56:609] [SQLEngine.reInitialize:605]  Reinitializing SQLEngine...

[Thread-7] [13:1:56:609] [SQLEngine.getEnvParams:427]  NLS_LANG: AMERICAN_AMERICA.WE8DEC

[Thread-7] [13:1:56:609] [SQLEngine.initialize:244]  Execing SQLPLUS/SVRMGR process...

[Thread-7] [13:1:56:609] [SQLEngine.initialize:272]  m_bReaderStarted: false

[Thread-7] [13:1:56:625] [SQLEngine.initialize:276]  Starting Reader Thread...

[Thread-7] [13:1:56:625] [SQLEngine.initialize:325]  Waiting for m_bReaderStarted to be true

[Thread-7] [13:2:2:234] [SQLEngine.done:1960]  Done called

[Thread-7] [13:2:2:453] [CompManager.startUpDBifDown:9577]  Error in starting datbase with default init file

[Thread-7] [13:2:2:453] [SQLEngine.reInitialize:605]  Reinitializing SQLEngine...

[Thread-7] [13:2:2:453] [SQLEngine.getEnvParams:427]  NLS_LANG: AMERICAN_AMERICA.WE8DEC

[Thread-7] [13:2:2:453] [SQLEngine.initialize:244]  Execing SQLPLUS/SVRMGR process...

[Thread-7] [13:2:2:453] [SQLEngine.initialize:272]  m_bReaderStarted: false

[Thread-7] [13:2:2:453] [SQLEngine.initialize:276]  Starting Reader Thread...

[Thread-7] [13:2:2:453] [SQLEngine.initialize:325]  Waiting for m_bReaderStarted to be true

[Thread-7] [13:2:4:750] [CompManager.obtainDatabaseInformation:1994]  ++++++++++Database is Running ++++++++++

[Thread-7] [13:2:4:750] [CompManager.obtainDatabaseInformation:1995]  executeQuery: SELECT VALUE FROM V$PARAMETER where name='db_name'

[Thread-7] [13:2:4:812] [CompManager.obtainDatabaseInformation:2007]  executeQuery: SELECT VALUE FROM V$PARAMETER where name='db_unique_name'

[Thread-7] [13:2:4:828] [CompManager.obtainDatabaseInformation:2012]  The db_unique_name is PRD

[Thread-7] [13:2:4:828] [CompManager.obtainDatabaseInformation:2127]  executeQuery: select value from v$parameter where name='cpu_count';

[Thread-7] [13:2:4:843] [CompManager.obtainDatabaseInformation:2142]  executeQuery: select log_mode from v$database;

[Thread-7] [13:2:4:875] [SQLEngine.done:1960]  Done called

[Thread-7] [13:2:4:984] [CompManager.obtainDatabaseInformation:3469]  oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1476)

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:697)

oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:2145)

oracle.sysman.assistants.dbma.ui.DatabasesPage.doProcessing(DatabasesPage.java:733)

oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:184)

java.lang.Thread.run(Thread.java:595)

[Thread-7] [13:2:4:984] [CompManager.obtainDatabaseInformation:3479] 

DBUA thinks this is a Rerun operation and is trying to connect to the database with oracle home E:\oracle\PRD\102. If you believe this is not a Rerun operation, remove the below file and invoke DBUA again.

E:\oracle\PRD\102\cfgtoollogs\dbua\logs\Welcome_PRD.txt

[Thread-7] [13:2:4:984] [SQLEngine.done:1960]  Done called

Thank you,

João Dimas

[joo_migueldimas · Accepted solution]

Hello again SCN,

I already solved this error.

I follow this instructions in the following SCN thread:

What I done was start the database as "upgrade", I mean, first I shutdown the database (SQL> shutdown immediate;) and then I start the database with the following command:

SQL> startup upgrade;

After that I re-run the DBUA and everything works fine.

Thank you,

João Dimas