Skip to Main Content
Forums

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

Billy Verreynne
905575 wrote:

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'
This means that the ORACLE_SID is set to orcl - and that would be invalid for a RAC instance as there are multiple instances per database and identified by an instance number in addition (e.g. orcl1, orcl2 and so on).
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
Fix the ORACLE_SID in the environment, prior to firing up a sqlplus session.
908578
Great! I just exported the ORACLE_SID=orcl1 for node1 and it worked.
Thanks a ton for the quick reply.

Cheers
Megha
Billy Verreynne
905575 wrote:
Great! I just exported the ORACLE_SID=orcl1 for node1 and it worked.
Good. Keep in mind that for policy managed RAC instances, the sid would be orcl_1 and not orcl1.

And it is always a good idea to have a current and correctly setup +.bash_profile+ in Oracle $HOME for creating a valid and sane environment for running Oracle s/w. Get the dba to do this - else if you're wearing that cap, consider spending some time creating a proper +.bash_profile+ (you can create a single one that can be used across all RAC nodes - so even when running 10+ nodes, there's only a single copy of the profile script to maintain).
908578
Thanks for the inputs :)
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 31 2012
Added on Jan 3 2012
#performance-availability, #real-application-clusters
4 comments
1,813 views