This discussion is archived
4 Replies Latest reply: Apr 30, 2013 1:44 PM by user12116782 RSS

upgrade error

925887 Newbie
Currently Being Moderated
Hi,

We tried to upgrade from 11.2.0.1 to 11.2.0.3 on aix machine.It is a ASM instance.We have 3 databases(PROD5,PROD6,PROD7) on that machine.We upgrade GRID Infrastructure first successfully.

We did db upgrade sucessfully on PROD5,PROD6.but We got the error while invoke the DBUA in PROD7.

It is hanging at UPGRADING TIMEZONE.

We found the follwing errors from *"/u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1*"

CRS-5017: The resource action "ora.DD55.db start" encountered the following error:
CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initDD55.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log".

CRS-2674: Start of 'ora.DD55.db' on 'tslm-ax08' failed
[Thread-323] [ 2012-08-11 15:28:00.558 UTC ] [UpgradeTimezoneStep.executeStepImpl:171] Exception while upgrading TZ PRCR-1079 : Failed to start resource ora.DD55.db
CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initDD55.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
CRS-5017: The resource action "ora.DD55.db start" encountered the following error:


Can i abort the upgradation and restart it from first?

Is there any logs for DBUA?
Is there any suggestions?


Thanks.

Edited by: 922884 on Aug 11, 2012 9:45 AM
  • 1. Re: upgrade error
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    >
    ...
    For details refer to "(:CLSN00107:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log".
    ...
    >

    Pl post the contents of this log file. You can abort the upgrade, restore the database from backups and restart the upgrade - but there is no guarantee that the error will not occur again.

    If this is a production system/database, pl also open an SR with Support

    HTH
    Srini
  • 2. Re: upgrade error
    925887 Newbie
    Currently Being Moderated
    Hi,

    Thanks for your reply.

    [Thread-323] [ 2012-08-11 15:22:43.683 UTC ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:22:43.683 UTC ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...
    [Thread-323] [ 2012-08-11 15:22:43.841 UTC ] [SQLEngine.initialize:362] m_bReaderStarted: false
    [Thread-323] [ 2012-08-11 15:22:43.853 UTC ] [SQLEngine.initialize:366] Starting Reader Thread...
    [Thread-323] [ 2012-08-11 15:22:43.886 UTC ] [SQLEngine.initialize:415] Waiting for m_bReaderStarted to be true
    [Thread-323] [ 2012-08-11 15:26:42.421 UTC ] [SQLPlusEngine.executeScript:345] Spool after script run = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1/PostUpgrade.log
    [Thread-323] [ 2012-08-11 15:26:42.421 UTC ] [SQLEngine.done:2189] Done called
    [Thread-323] [ 2012-08-11 15:26:42.421 UTC ] [SQLEngine.spoolOff:2032] Setting spool off = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1/PostUpgrade.log
    [Thread-323] [ 2012-08-11 15:26:42.423 UTC ] [SQLEngine.setSpool:1967] old Spool = null
    [Thread-323] [ 2012-08-11 15:26:42.423 UTC ] [SQLEngine.setSpool:1968] Setting Spool = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1/PostUpgrade.log
    [Thread-323] [ 2012-08-11 15:26:42.423 UTC ] [SQLEngine.setSpool:1969] Is spool appendable? --> true
    [Thread-323] [ 2012-08-11 15:26:42.424 UTC ] [SQLEngine.reInitialize:738] Reinitializing SQLEngine...
    [Thread-323] [ 2012-08-11 15:26:42.424 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.424 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.424 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.425 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.425 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.425 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.425 UTC ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:26:42.426 UTC ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
    [Thread-323] [ 2012-08-11 15:26:42.426 UTC ] [OsUtilsBase.getBaseFromOrabase:651] oraBaseUtility /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:26:42.426 UTC ] [OsUtilsBase.getBaseFromOrabase:660] cmds: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:26:42.427 UTC ] [OsUtilsBase.getBaseFromOrabase:664] envs: ORACLE_HOME=/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:26:42.646 UTC ] [OsUtilsBase.getBaseFromOrabase:669] baseLocation from orabase
    /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:26:42.647 UTC ] [OsUtilsBase.getBaseFromOrabase:694] orabaseLocation= /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:26:42.649 UTC ] [SQLEngine.getEnvParams:555] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:26:42.649 UTC ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:26:42.649 UTC ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...
    [Thread-323] [ 2012-08-11 15:26:42.802 UTC ] [SQLEngine.initialize:362] m_bReaderStarted: false
    [Thread-323] [ 2012-08-11 15:26:42.804 UTC ] [SQLEngine.initialize:366] Starting Reader Thread...
    [Thread-323] [ 2012-08-11 15:26:42.812 UTC ] [SQLEngine.initialize:415] Waiting for m_bReaderStarted to be true
    [Thread-323] [ 2012-08-11 15:26:42.953 UTC ] [SQLEngine.spoolOff:2032] Setting spool off = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1/PostUpgrade.log
    [Thread-323] [ 2012-08-11 15:26:42.954 UTC ] [SummarizableStep.executeImpl:184] execute impl:Post Upgrade = DONE Sucessfully
    [Thread-323] [ 2012-08-11 15:26:42.955 UTC ] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@3b723b72
    [Thread-323] [ 2012-08-11 15:26:42.955 UTC ] [StepContext$ModeRunner.run:2698] ---- Progress Needed:=true
    [Thread-323] [ 2012-08-11 15:26:43.014 UTC ] [BasicStep.execute:202] Executing Step : UPGRADE_TZ
    [Thread-323] [ 2012-08-11 15:26:43.014 UTC ] [BasicStep.configureSettings:304] messageHandler being set=null
    [Thread-323] [ 2012-08-11 15:26:43.014 UTC ] [SummarizableStep.executeImpl:178] Set Error Listener in SummarizableStep...
    [Thread-323] [ 2012-08-11 15:26:43.014 UTC ] [CompManager.isModeSet:9822] DB Upgrade Mode Setting := 1
    [Thread-323] [ 2012-08-11 15:26:43.015 UTC ] [CompManager.isModeSet:9823] Mode := 4 is not set
    [Thread-323] [ 2012-08-11 15:26:43.015 UTC ] [UpgradeTimezoneStep.executeStepImpl:127] clear all errors before upgrade TZ operation
    [Thread-323] [ 2012-08-11 15:26:43.015 UTC ] [CompManager.isModeSet:9822] DB Upgrade Mode Setting := 1
    [Thread-323] [ 2012-08-11 15:26:43.015 UTC ] [CompManager.isModeSet:9823] Mode := 1 is set
    [Thread-323] [ 2012-08-11 15:26:43.016 UTC ] [SQLEngine.setSpool:1967] old Spool = null
    [Thread-323] [ 2012-08-11 15:26:43.016 UTC ] [SQLEngine.setSpool:1968] Setting Spool = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1/UpgradeTimezone.log
    [Thread-323] [ 2012-08-11 15:26:43.016 UTC ] [SQLEngine.setSpool:1969] Is spool appendable? --> true
    [Thread-323] [ 2012-08-11 15:27:10.196 UTC ] [SQLEngine.done:2189] Done called
    [Thread-323] [ 2012-08-11 15:27:10.197 UTC ] [SQLEngine.spoolOff:2032] Setting spool off = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base/cfgtoollogs/dbua/PROD7/upgrade1/UpgradeTimezone.log
    [Thread-323] [ 2012-08-11 15:27:10.200 UTC ] [CompManager.isModeSet:9822] DB Upgrade Mode Setting := 1
    [Thread-323] [ 2012-08-11 15:27:10.200 UTC ] [CompManager.isModeSet:9823] Mode := 1 is set
    [Thread-323] [ 2012-08-11 15:27:10.200 UTC ] [SQLEngine.reInitialize:738] Reinitializing SQLEngine...
    [Thread-323] [ 2012-08-11 15:27:10.201 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.201 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.201 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.201 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.201 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.201 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.202 UTC ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:10.202 UTC ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
    [Thread-323] [ 2012-08-11 15:27:10.203 UTC ] [OsUtilsBase.getBaseFromOrabase:651] oraBaseUtility /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:27:10.203 UTC ] [OsUtilsBase.getBaseFromOrabase:660] cmds: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:27:10.203 UTC ] [OsUtilsBase.getBaseFromOrabase:664] envs: ORACLE_HOME=/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:27:10.414 UTC ] [OsUtilsBase.getBaseFromOrabase:669] baseLocation from orabase
    /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:27:10.415 UTC ] [OsUtilsBase.getBaseFromOrabase:694] orabaseLocation= /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:27:10.416 UTC ] [SQLEngine.getEnvParams:555] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:27:10.416 UTC ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:27:10.417 UTC ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...
    [Thread-323] [ 2012-08-11 15:27:10.493 UTC ] [SQLEngine.initialize:362] m_bReaderStarted: false
    [Thread-323] [ 2012-08-11 15:27:10.495 UTC ] [SQLEngine.initialize:366] Starting Reader Thread...
    [Thread-323] [ 2012-08-11 15:27:10.573 UTC ] [SQLEngine.initialize:415] Waiting for m_bReaderStarted to be true
    [Thread-323] [ 2012-08-11 15:27:10.712 UTC ] [Database.databaseShutdown:1705] In shutdown database: Checking if Db started
    [Thread-323] [ 2012-08-11 15:27:10.721 UTC ] [Database.databaseShutdown:1709] Db is STARTED, need to shutdown
    [Thread-323] [ 2012-08-11 15:27:25.613 UTC ] [Database.databaseShutdown:1724] DB is brought down
    [Thread-323] [ 2012-08-11 15:27:25.613 UTC ] [CompManager.isModeSet:9822] DB Upgrade Mode Setting := 1
    [Thread-323] [ 2012-08-11 15:27:25.613 UTC ] [CompManager.isModeSet:9823] Mode := 1 is set
    [Thread-323] [ 2012-08-11 15:27:25.613 UTC ] [Database.databaseStartup:1640] Connecting to the engine with sid:=PROD7
    [Thread-323] [ 2012-08-11 15:27:25.680 UTC ] [SQLEngine.done:2189] Done called
    [Thread-323] [ 2012-08-11 15:27:25.682 UTC ] [Database.isDBStarted:2254] Exception during check for DB Started->assuming db down
    [Thread-323] [ 2012-08-11 15:27:25.682 UTC ] [Database.databaseStartup:1650] Db is not running, bring it up
    [Thread-323] [ 2012-08-11 15:27:25.682 UTC ] [Database.databaseStartup:1659] Start db with clause: [UPGRADE] and pfile = /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora
    [Thread-323] [ 2012-08-11 15:27:25.682 UTC ] [SQLEngine.reInitialize:738] Reinitializing SQLEngine...
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:25.683 UTC ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
    [Thread-323] [ 2012-08-11 15:27:25.684 UTC ] [OsUtilsBase.getBaseFromOrabase:651] oraBaseUtility /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:27:25.684 UTC ] [OsUtilsBase.getBaseFromOrabase:660] cmds: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:27:25.684 UTC ] [OsUtilsBase.getBaseFromOrabase:664] envs: ORACLE_HOME=/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:27:25.804 UTC ] [OsUtilsBase.getBaseFromOrabase:669] baseLocation from orabase
    /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:27:25.805 UTC ] [OsUtilsBase.getBaseFromOrabase:694] orabaseLocation= /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:27:25.805 UTC ] [SQLEngine.getEnvParams:555] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:27:25.806 UTC ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:27:25.806 UTC ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...
    [Thread-323] [ 2012-08-11 15:27:25.857 UTC ] [SQLEngine.initialize:362] m_bReaderStarted: false
    [Thread-323] [ 2012-08-11 15:27:25.859 UTC ] [SQLEngine.initialize:366] Starting Reader Thread...
    [Thread-323] [ 2012-08-11 15:27:25.922 UTC ] [SQLEngine.initialize:415] Waiting for m_bReaderStarted to be true
    [Thread-323] [ 2012-08-11 15:27:44.751 UTC ] [Database.databaseStartup:1667] Startup of the database is successful
    [Thread-323] [ 2012-08-11 15:27:44.751 UTC ] [Database.bounceDBForTZUpgrade:1506] after startup upgrade
    [Thread-323] [ 2012-08-11 15:27:49.891 UTC ] [SQLEngine.done:2189] Done called
    [Thread-323] [ 2012-08-11 15:27:49.893 UTC ] [CompManager.isModeSet:9822] DB Upgrade Mode Setting := 1
    [Thread-323] [ 2012-08-11 15:27:49.893 UTC ] [CompManager.isModeSet:9823] Mode := 1 is set
    [Thread-323] [ 2012-08-11 15:27:49.894 UTC ] [SQLEngine.reInitialize:738] Reinitializing SQLEngine...
    [Thread-323] [ 2012-08-11 15:27:49.894 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.894 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.894 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.894 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.3.0
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [OsUtilsBase.getBaseFromOrabase:651] oraBaseUtility /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [OsUtilsBase.getBaseFromOrabase:660] cmds: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/bin/orabase
    [Thread-323] [ 2012-08-11 15:27:49.895 UTC ] [OsUtilsBase.getBaseFromOrabase:664] envs: ORACLE_HOME=/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:27:50.045 UTC ] [OsUtilsBase.getBaseFromOrabase:669] baseLocation from orabase
    /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:27:50.046 UTC ] [OsUtilsBase.getBaseFromOrabase:694] orabaseLocation= /u01/app/oracle/11.2.0.3/product/rdbms/oracle_base
    [Thread-323] [ 2012-08-11 15:27:50.047 UTC ] [SQLEngine.getEnvParams:555] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:27:50.047 UTC ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
    [Thread-323] [ 2012-08-11 15:27:50.047 UTC ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...
    [Thread-323] [ 2012-08-11 15:27:50.163 UTC ] [SQLEngine.initialize:362] m_bReaderStarted: false
    [Thread-323] [ 2012-08-11 15:27:50.165 UTC ] [SQLEngine.initialize:366] Starting Reader Thread...
    [Thread-323] [ 2012-08-11 15:27:50.168 UTC ] [SQLEngine.initialize:415] Waiting for m_bReaderStarted to be true
    [Thread-323] [ 2012-08-11 15:27:50.276 UTC ] [Database.databaseShutdown:1705] In shutdown database: Checking if Db started
    [Thread-323] [ 2012-08-11 15:27:50.284 UTC ] [Database.databaseShutdown:1709] Db is STARTED, need to shutdown
    [Thread-323] [ 2012-08-11 15:27:58.368 UTC ] [Database.databaseShutdown:1724] DB is brought down
    [Thread-323] [ 2012-08-11 15:27:58.368 UTC ] [Database.bounceBackDBForTZUpgrade:1525] after shutdown db
    [Thread-323] [ 2012-08-11 15:27:58.368 UTC ] [HAUtils.getCurrentOracleHome:366] Oracle home from system property: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:27:58.369 UTC ] [GETCRSHOMEUtil.<init>:88] Toolname: getcrshome --- Tool location: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/srvm/adminTool dependencies: [Ljava.lang.String;@5b105b10
    [Thread-323] [ 2012-08-11 15:27:58.369 UTC ] [NativeSystem.isCmdScv:499] isCmdScv: cmd=[]
    [Thread-426] [ 2012-08-11 15:27:58.483 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-425] [ 2012-08-11 15:27:58.484 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-425] [ 2012-08-11 15:27:58.535 UTC ] [StreamReader.run:65] OUTPUT>/u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-323] [ 2012-08-11 15:27:58.539 UTC ] [UnixSystem.dorunRemoteExecCmd:3198] retval = 0
    [Thread-323] [ 2012-08-11 15:27:58.540 UTC ] [UnixSystem.dorunRemoteExecCmd:3222] exitValue = 0
    [Thread-323] [ 2012-08-11 15:27:58.540 UTC ] [HAUtils.getConfiguredGridHome:783] Configured Grid Infrastructure home: /u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-323] [ 2012-08-11 15:27:58.540 UTC ] [HAUtils.getCurrentOracleHome:366] Oracle home from system property: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:27:58.541 UTC ] [GETCRSHOMEUtil.<init>:88] Toolname: getcrshome --- Tool location: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/srvm/adminTool dependencies: [Ljava.lang.String;@5b105b10
    [Thread-323] [ 2012-08-11 15:27:58.541 UTC ] [NativeSystem.isCmdScv:499] isCmdScv: cmd=[]
    [Thread-427] [ 2012-08-11 15:27:58.658 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-428] [ 2012-08-11 15:27:58.658 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-427] [ 2012-08-11 15:27:58.703 UTC ] [StreamReader.run:65] OUTPUT>/u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-323] [ 2012-08-11 15:27:58.706 UTC ] [UnixSystem.dorunRemoteExecCmd:3198] retval = 0
    [Thread-323] [ 2012-08-11 15:27:58.706 UTC ] [UnixSystem.dorunRemoteExecCmd:3222] exitValue = 0
    [Thread-323] [ 2012-08-11 15:27:58.707 UTC ] [HAUtils.getConfiguredGridHome:783] Configured Grid Infrastructure home: /u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-323] [ 2012-08-11 15:27:58.707 UTC ] [Version.isPre:528] version to be checked 11.2.0.3.0 major version to check against10
    [Thread-323] [ 2012-08-11 15:27:58.707 UTC ] [Version.isPre:539] isPre.java: Returning FALSE
    [Thread-323] [ 2012-08-11 15:27:58.707 UTC ] [Version.isPre:528] version to be checked 11.2.0.3.0 major version to check against10
    [Thread-323] [ 2012-08-11 15:27:58.707 UTC ] [Version.isPre:539] isPre.java: Returning FALSE
    [Thread-323] [ 2012-08-11 15:27:58.708 UTC ] [UnixSystem.isCRSConfigured:2596] configFile=/etc/oracle/ocr.loc
    [Thread-323] [ 2012-08-11 15:27:58.708 UTC ] [Utils.getPropertyValue:241] keyName=ocrconfig_loc props.val=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/local.ocr propValue=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/local.ocr
    [Thread-323] [ 2012-08-11 15:27:58.708 UTC ] [Utils.getPropertyValue:301] propName=ocrconfig_loc propValue=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/local.ocr
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [UnixSystem.isCRSConfigured:2603] ocrconfig_loc=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/local.ocr
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [Utils.getPropertyValue:241] keyName=ocrconfig_loc props.val=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/local.ocr propValue=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/local.ocr
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [Utils.getPropertyValue:301] propName=local_only propValue=TRUE
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [Version.isPre:528] version to be checked 11.2.0.3.0 major version to check against11
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [Version.isPre:539] isPre.java: Returning FALSE
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [Version.isPre112:414] version to be checked 11.2.0.3.0 minor version to check against2
    [Thread-323] [ 2012-08-11 15:27:58.709 UTC ] [Version.isPre112:425] isPre112 : Returning FALSE for minor version check
    [Thread-323] [ 2012-08-11 15:27:58.710 UTC ] [UnixSystem.isHAConfigured:2660] olrFileName = /etc/oracle/olr.loc
    [Thread-323] [ 2012-08-11 15:27:58.710 UTC ] [UnixSystem.isHAConfigured:2696] configFile=/etc/oracle/olr.loc
    [Thread-323] [ 2012-08-11 15:27:58.710 UTC ] [Utils.getPropertyValue:241] keyName=olrconfig_loc props.val=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/tslm-ax08.olr propValue=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/tslm-ax08.olr
    [Thread-323] [ 2012-08-11 15:27:58.710 UTC ] [Utils.getPropertyValue:241] keyName=crs_home props.val=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home propValue=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-323] [ 2012-08-11 15:27:58.710 UTC ] [Utils.getPropertyValue:301] propName=olrconfig_loc propValue=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/tseelm-ax2008.olr
    [Thread-323] [ 2012-08-11 15:27:58.710 UTC ] [UnixSystem.isHAConfigured:2704] olrconfig_loc=/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/cdata/localhost/tslm-ax08.olr
    [Thread-323] [ 2012-08-11 15:27:58.711 UTC ] [HAUtils.getCurrentOracleHome:366] Oracle home from system property: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home
    [Thread-323] [ 2012-08-11 15:27:58.711 UTC ] [GETCRSHOMEUtil.<init>:88] Toolname: getcrshome --- Tool location: /u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/srvm/adminTool dependencies: [Ljava.lang.String;@5b105b10
    [Thread-323] [ 2012-08-11 15:27:58.711 UTC ] [NativeSystem.isCmdScv:499] isCmdScv: cmd=[]
    [Thread-429] [ 2012-08-11 15:27:58.828 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-430] [ 2012-08-11 15:27:58.828 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-429] [ 2012-08-11 15:27:58.874 UTC ] [StreamReader.run:65] OUTPUT>/u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-323] [ 2012-08-11 15:27:58.877 UTC ] [UnixSystem.dorunRemoteExecCmd:3198] retval = 0
    [Thread-323] [ 2012-08-11 15:27:58.877 UTC ] [UnixSystem.dorunRemoteExecCmd:3222] exitValue = 0
    [Thread-323] [ 2012-08-11 15:27:58.877 UTC ] [HAUtils.getConfiguredGridHome:783] Configured Grid Infrastructure home: /u01/app/oracle/11.2.0.3/product/ginfra/grid_home
    [Thread-431] [ 2012-08-11 15:27:59.005 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-432] [ 2012-08-11 15:27:59.005 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-431] [ 2012-08-11 15:27:59.199 UTC ] [StreamReader.run:65] OUTPUT>CRS-4638: Oracle High Availability Services is online
    [Thread-434] [ 2012-08-11 15:27:59.401 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-433] [ 2012-08-11 15:27:59.402 UTC ] [StreamReader.run:61] In StreamReader.run
    [Thread-433] [ 2012-08-11 15:27:59.646 UTC ] [StreamReader.run:65] OUTPUT>CRS-212: Resource 'ora.crsd' is not registered.
    [Thread-323] [ 2012-08-11 15:27:59.798 UTC ] [Version.isPre:528] version to be checked 11.2.0.3.0 major version to check against11
    [Thread-323] [ 2012-08-11 15:27:59.799 UTC ] [Version.isPre:539] isPre.java: Returning FALSE
    [Thread-323] [ 2012-08-11 15:27:59.799 UTC ] [Version.isPre11202:448] version to be checked 11.2.0.3.0 minor version to check against2, patchset to check against 2
    [Thread-323] [ 2012-08-11 15:27:59.799 UTC ] [Version.isPre11202:467] isPre11202 : Returning FALSE for patchset version check
    [Thread-323] [ 2012-08-11 15:27:59.829 UTC ] [DatabaseFactoryImpl.getDatabase:768] Checking for version mismatch
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [DatabaseFactoryImpl.getDatabase:774] dbVersion4 = 11.2.0.3
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [DatabaseFactoryImpl.getDatabase:789] db type SINGLE
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [Version.isPre:528] version to be checked 11.2.0.3.0 major version to check against11
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [Version.isPre:539] isPre.java: Returning FALSE
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [Version.isPre112:414] version to be checked 11.2.0.3.0 minor version to check against2
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [Version.isPre112:425] isPre112 : Returning FALSE for minor version check
    [Thread-323] [ 2012-08-11 15:27:59.830 UTC ] [DatabaseFactoryImpl.getSingleInstanceDatabase:1285] Getting single instance database for PROD7
    [Thread-323] [ 2012-08-11 15:27:59.895 UTC ] [DatabaseImpl.crsResource:3415] calling parent's crsResource
    [Thread-323] [ 2012-08-11 15:27:59.949 UTC ] [Database.bounceBackDBForTZUpgrade:1544] isDBExists true
    [Thread-323] [ 2012-08-11 15:28:00.548 UTC ] [CRSNative.internalStartResource:389] Failed to start resource: Name: ora.PROD7.db, node: null, filter: null, msg CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
    CRS-5017: The resource action "ora.PROD7.db start" encountered the following error:
    CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
    . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log".

    CRS-2674: Start of 'ora.PROD7.db' on 'tslm-ax08' failed
    [Thread-323] [ 2012-08-11 15:28:00.558 UTC ] [UpgradeTimezoneStep.executeStepImpl:171] Exception while upgrading TZ PRCR-1079 : Failed to start resource ora.PROD7.db
    CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
    CRS-5017: The resource action "ora.PROD7.db start" encountered the following error:
    CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
    . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log".

    CRS-2674: Start of 'ora.PROD7.db' on 'tslm-ax08' failed
    [Thread-323] [ 2012-08-11 15:28:00.558 UTC ] [UpgradeTimezoneStep.executeStepImpl:172] PRCR-1079 : Failed to start resource ora.PROD7.db
    CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
    CRS-5017: The resource action "ora.PROD7.db start" encountered the following error:
    CRS-5010: Update of configuration file "/u01/app/oracle/11.2.0.3/product/rdbms/oracle_home/dbs/initPROD7.ora" failed: details at "(:CLSN00014:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log"
    . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/log/tslm-ax08/agent/ohasd/oraagent_grid/oraagent_grid.log".

    CRS-2674: Start of 'ora.PROD7.db' on 'tslm-ax08' failed



    I got metalink id (985743.1). I tried but no use.

    Thanks,
  • 3. Re: upgrade error
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl see if this MOS Doc can help

    Oracle Restart: srvctl fails to start database with error CRS-5010 if RDBMS and Grid under different users [ID 1335607.1]

    As suggested, pl open an SR for this issue

    HTH
    Srini
  • 4. Re: upgrade error
    user12116782 Newbie
    Currently Being Moderated
    I resolved same problem.
    Connect as oracle and
    $ srvctl config database -d orcl

    You will see your spfile location: Spfile: +DATA/orcl/spfileorcl.ora

    Then check your init.ora file
    $ cat $ORACLE_HOME/dbs/initorcl.ora
    SPFILE='+DATA/orcl/spfileorcl.ora'

    Make sure content of your init.ora file EXACTLY match output from "srvctl config database -d orcl". It IS CASE SENSATIVE.

    Mine has wrong case. Corrected.
    srvctl start database -d orcl - working now.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points