-
Originally Posted by muzammil.dba
Dear all,
my db is on Oracle 10g RAC. plz. see following SID's.
ORACLE_SID=arpdb1 (Node1)
ORACLE_SID=arpdb2 (Node2)
db_name=aripdb
please help, hw to set both SID in same invironment.
Best Regards,
what?? how to set sid??? you have already done that - hore a dba, you are a danger
-
Originally Posted by PAVB
Just because poster attempted to "run" tnsnames.ora? wasn't that cute?
Hi Pavb
No offence but people before asking a question and after receiving a reply should put in some effort from thier end .
Sometimes i have too dot net and sometimes storeage but i put in more effort as those are not my feilds before asking a question on a forum.
There are many people here who come and ask on hwo to recover a database or my datafile is lost for such folks i would advise them to HIRE a dba.
regards
Hrishy
-
Hrishy, I have to agrre you have a point there.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
Just because poster attempted to "run" tnsnames.ora? wasn't that cute?
hehehehe.... dude, to set your ORACLE_HOME and ORACLE_SID on windows:
c:\> set ORACLE_SID=
c:\> set ORACLE_HOME=
... to check the environment ...
c:\> set ora
... remember these settings will be lost when you close your command prompt window....
to set it permanently, set it in the advanced properties on "My Computer"
-
Dear Friends,
Thanks for support. now my tnsping is working fine on Oracle RAC DB with 2 instance.
simply I added below path in sqlnet.ora file with same tnsnames.ora.
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
Once again thanks for given time.
Best Regards,
dba
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|