Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 11G RAC 2 node

908578Jan 3 2012 — edited Jan 3 2012
Hi,
I'm bringing up an Oracle 11.2.0- 2 node RAC setup on Oracle linux5.
I have successfully installed Oracle clusterware files(11.2 grid infrastruture installation) and Oracle RAC DB on a 2 node cluster. I have installed all Clusterware files, DB files on sameASM disk- SDISK and Fast Recovery files on FRA. (had chosen automatic DB creation during DB installation)

My problem is:
1) when i try connecting to DB with SYSDBA, it connects to an idle instance and for any query it says:
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number:

Also, when i try to startup my DB, i see the error
sqlplus "/ AS SYSDBA"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 3 03:24:59 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'

I wonder why it looks for this file bacuase I've 'initorcl1.ora' for node1 and 'initorcl2' for node2 in the above path. I also have an 'spfile.ora' file successfully created in my ASM disk

P.S
1)Contents under '/u01/app/oracle/product/11.2.0/dbhome_1/dbs in node1
hc_DBUA0.dat, hc_orcl.dat , initorcl1.ora, oldspfileorcl.ora, peshm_DBUA0_0, peshm_orcl_1, snapcf_orcl1.f
hc_orcl1.dat, init.ora, initorcl.orappp , orapworcl1 , peshm_orcl_0 , peshm_orcl_2

2)Cat initorcl1.ora
SPFILE='+SDISK/orcl/spfileorcl.ora'

3): If I try connecting through DBSNMP or SYSTEM accounts, it connects to the DB fine. I'm able to run queries.

I don't understand why i see a problem only with SYSDBA and not any other account. Does this mean i can go ahead with account creation etc. I need to use this DB to install my zenworks application. I've been struggling with all of this for a month now.
Please help!

Thanks so much
Megha

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 31 2012
Added on Jan 3 2012
4 comments
1,814 views