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

Shreeni, Salem, folks

Finally Connect thru Listener was successful thanks to the great support from you folks. Thanks indeed.

ACTIONS:- Added the service thru "NETCA" Tool

Another mistake - Both the initPNBRAC1.ora & PNBRAC2.ora has by Oversight the parameter value instance_name = PNBRAC. Deleted the same

Cheers

Vivek

From: VIVEK_SHARMA
Sent: Friday, December 22, 2006 4:50 AM

Following Command gave Error because I had just successfully issued the Command "srvctl add database -d PNBRAC -o /ora/rac10gr2/ product" before receipt of your e-mail. Hope it is ok.

$ srvctl add database -d PNBRAC -o /ora/rac10gr2/product -r PRIMARY -n
PNBRAC PRKP-1073 : Cannot create database PNBRAC because a database named PNBRAC already exists.

Following 2 Commands were also successful:-

$ srvctl add instance -d PNBRAC -i PNBRAC1 -n spesuns4p-2

$

$ srvctl add instance -d PNBRAC -i PNBRAC2 -n spesuns4p-4

$

$ srvctl config database

TSTRAC EBRAC PNBRAC

From: Shreeni [mailto:shreeni_at_sbcglobal.net] Sent: Friday, December 22, 2006 4:11 AM
To: VIVEK_SHARMA; oracle-l_at_freelists.org Subject: RE: Connect Thru Listener for NEWLY Converted RAC DB Failing ......Basic Qs

OK...This clears up a bit I guess. Using srvctl in this order, I guess u will be set :- ( srvctl -h gives you all possible syntax combos )

srvctl add database -d PNBRAC -o <oracle_home> -r PRIMARY -n PNBRAC srvctl add instance -d PNBRAC -i PNBRAC1 -n spesuns4p-2 srvctl add service -d PNBRAC -s PNBRAC.ad.infosys.com -P BASIC srvctl add nodeapps -n spesuns4p-2 -o <oracle_home> srvctl config database

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