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_at_sbcglobal.net] 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_at_infosys.com] 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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*** -- http://www.freelists.org/webpage/oracle-l