| Connecting to an instance [message #144617] |
Thu, 27 October 2005 07:27  |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi
While connecting to an oracle 9i instance, in the connect descriptor iam using INSTANCE_NAME and SERVICE_NAME. Is there are any other alternatives to connect to an oracle instance.
Thanx in advance
With Regards
Vara Prasad
|
|
|
|
| Re: Connecting to an instance [message #144641 is a reply to message #144617] |
Thu, 27 October 2005 09:18  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
If you are logged in the server hosting the database ,
you can Set your ORACLE_SID in your environment
export ORACLE_SID=mysid #(in unix. in windows set ORACLE_SID=mysid)
sqlplus scott/tiger # will connect to the instance defined by ORACLE_SID
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
