This discussion is archived
2 Replies Latest reply: Oct 22, 2012 8:04 AM by SherrieK RSS

Oracle Restart 11.2 using Grid Infrastructure does not start database.

SherrieK Newbie
Currently Being Moderated
Database version: 11.2.0.3
Grid Infrastructure 11.2.0.3
ASM 11.2.0.3
Listener version 11.2.0.3
Enterprise Manager 12cc

The GI, ASM and Listener are running under one Oracle Home.
We use TNS_ADMIN to reference the listener location.
The database is installed under another Oracle Home.
EM and its OMS are installed under another Oracle Home.

My goal is to have a standalone server supporting a repository database using ASM, running EM 12c.
To use ASM, GI must be installed. One of the benefits of using GI is that an Oracle Restart should cleanly shutdown and startup all that is needed on a reboot, intentional or otherwise.

All of these components work when started manually and individually.

On a restart: ASM, Listener, and Agent come up cleanly.
The database does not start.
Because the database does not start, opmn is not correct.

So the first order of business is to address why the database does not start.

The idea of Oracle High Availability (oha) is a little confusing because this is not a cluster.
However, crs commands are used in some places, so there is a registry someplace.

Using srvctl to start the database displays the same error as does restart, so if I can get the db up with srvctl I think we'd be good:

srvctl start database -d repo
PRCR-1079 : Failed to start resource ora.repo.db
CRS-5017: The resource action "ora.repo.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_GRID02'
. For details refer to "(:CLSN00107:)" in "/oracle/OracleHomes/11.2/grid/log/bkvlnxgrid02/agent/ohasd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.repo.db' on 'bkvlnxgrid02' failed

This log shows:
ASM Dedicated Thread {
CrsCmd::ClscrsCmdData::stat entity 1 statflag 32 useFilter 0
checkCrsStat 2 CLSCRS_STAT ret: 200
checkCrsStat 2 clscrs_res_get_op_status CLSCRS_STAT status 210 err_msg CRS-0210: Could not find resource 'ora.LISTENER.lsnr'.
CrsCmd::ClscrsCmdData::stat entity 1 statflag 33 useFilter 0
checkCrsStat 2 CLSCRS_STAT ret: 200
checkCrsStat 2 clscrs_res_get_op_status CLSCRS_STAT status 210 err_msg CRS-0210: Could not find resource 'ora.LISTENER.lsnr'.
AsmCommonAgent::setLocalListener cls::Exception CRS-0210: Could not find resource 'ora.LISTENER.lsnr'.
ASM Dedicated Thread }
Thread:ASM DedicatedThreadisRunning is reset to false here

It is looking for LISTENER, when my name is LISTENER_GRID02

crsstat shows the correct listener name.
crsstat


Resource Name Resource Type Target State Node FC RC State Details
---------------------------------------- ---------------- ---------- ------------ --------------- -- -- ---------------
ora.ASM_DATA.dg diskgroup L ONLINE ONLINE bkvlnxgrid02 0 0
ora.ASM_FRA.dg diskgroup L ONLINE ONLINE bkvlnxgrid02 0 0
ora.LISTENER_GRID02.lsnr Listener L ONLINE ONLINE bkvlnxgrid02 0 0
ora.asm ASM L ONLINE ONLINE bkvlnxgrid02 0 0 Started
ora.cssd cssd C ONLINE ONLINE bkvlnxgrid02 0 0
ora.diskmon diskmon C OFFLINE OFFLINE (bkvlnxgrid02) 0 0
ora.evmd evm C ONLINE ONLINE bkvlnxgrid02 0 0
ora.ons Ora Notif Svc L OFFLINE OFFLINE (bkvlnxgrid02) 0 0
ora.repo.db database C ONLINE OFFLINE (bkvlnxgrid02) 0 0 Instance Shutdown


I have been working with Oracle support for 16 days on this issue with no solution.

I'd appreciate any suggestions or comments.

Legend

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