RE: Connect Thru Listener for NEWLY Converted RAC DB Failing ......Basic Qs

Thanks Shreeni



Ans embedded below.



Also sent you an SEPARATE DIRECT e-mail containing the Init.ora,
tnsnames.ora, listener.ora files



Cheers



________________________________

From: Shreeni [mailto:shreeni@xxxxxxxxxxxxx]
Sent: Thursday, December 21, 2006 9:36 PM
Subject: RE: Connect Thru Listener for NEWLY Converted RAC DB Failing
......Basic Qs



It could be couple of issues.... The most basic one being the
ORACLE_SID. I assumed your oracle SID to be PNBRAC. Try with the SID...



Ans:-

ORACLE_SIDs are PNBRAC1, PNBRAC2

DB_NAME = PNBRAC

Connect using SID VIA Listener is Failing i.e. sqlplus
system/<pwd>@PNBRAC1



NOTE - sqlplus system/<pwd> is successful



The second is check the log file in
$ORACLE_CRS_HOME/<node_name>/racg/ora.*.db.log



Ans:-

Contents of  "$ORACLE_CRS_HOME/log/spesuns4p-2<node 1>/racg"

ora.spesuns4p-2.ons.log   ora.spesuns4p-2.vip.log
ora.spesuns4p-4.vip.log   ora.TSTRAC.db.log      racgeut/
racgevtf/                 racgmain/



Contents of  "$ORACLE_CRS_HOME/log/spesuns4p-2<node 1>/racg"

ora.spesuns4p-2.vip.log   ora.spesuns4p-4.ons.log
ora.spesuns4p-4.vip.log   ora.TSTRAC.db.log    racgeut/
racgevtf/                 racgmain/



Cheers



Shreeni

________________________________

From: VIVEK_SHARMA [mailto:VIVEK_SHARMA@xxxxxxxxxxx]
Sent: Thursday, December 21, 2006 9:55 AM

Following is the Output on BOTH Nodes:-



$ srvctl status service -d PNBRAC

PRKR-1001 : cluster database PNBRAC does not exist

PRKO-2005 : Application error: Failure in getting Cluster Database
Configuration for: PNBRAC



Cheers



________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shreeni
Sent: Thursday, December 21, 2006 9:23 PM

Qs Is registering of this RAC database and its instance-to-node mapping
using SRVCTL needed? If so, How?



u can chek to see the status first by "srvtcl status service -d PNBRAC".
If this does not show ur TNSEntries, then srvtcl start service -d PNBRAC



Thanks and have a good day.



Shreeni





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts: