| Oracle names server [message #58300] |
Wed, 13 August 2003 04:20  |
Naveen
Messages: 75
Registered: June 2001
|
Member |
|
|
Hi all,
I have host name,instance name, username and password with me and I am supposed to connect to the server thro' VPN and access the database. The server is configured for Oracle names. Our DBA says that information is enough for me to connect to the server. But when i am giving username, password and instancename(as connect string in sql*plus) i am unable to connect. I have tried to discover the Oracle names server through net8 from my client but no sucess. Do i need to know some more information. I dont have any other information with me. Please help.
Thank you.
Nav
|
|
|
|
| Re: Oracle names server [message #58317 is a reply to message #58300] |
Wed, 13 August 2003 16:34  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
if you are logged directly into the server where the database is running:
set ORACLE_SID variable = instance_name
sqlplus username/password -- you dont need a host string
if you are connecting to the database remotely, you need to have the connect string.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
