Archive for April, 2009
SRVCTL fails to start RAC resources:CRS-0215
After upgrading RAC database to 10204 and applying CRS bundle patch-1 for 10204 crs home, srvctl command fails to startup resources on rac nodes. While starting up RAC resources using SRVCTL following error occurs in CRSD.log file: $ srvctl start instance -d rac -i rac2 [Read More]
ORA-1078 ORA-1565 Errors while starting database with SPFILE on ASM
I was getting following error’s while starting a database using spfile on ASM. Actually this was a cloned RAC environment. SQL> create SPFILE='+ASM_GROUP/PORTALDB/spfileportaldb.ora' from pfile; File created. SQL> shut immediate; ORA-01109: database not open [Read More]
Grid Control Fails to Start
The link for Grid Control was not Working and it failed to show the login page. In this situation checked the following things: 1. The repository database was up and running 2. The listener was up. 3. OMS server was down. Tried to stratup the OMS server using opmnctl [Read More]
Connections to DataBase Hang Including “/ as sysdba”
Recently I faced one issue where all the connection to database hung and it was also not possible to login to database using “/ as sysdba”. To get access of sqlplus I used the following syntax: $ sqlplus -prelim / as sysdba With “prelim” option we [Read More]
