host string [message #62278] |
Sat, 10 July 2004 03:41 |
syed umair ali shah
Messages: 8 Registered: July 2004
|
Junior Member |
|
|
salam to all ... i need help regarding host string ... can any one tell me how to find the host string and default database that oracle uses ... also i need to ask how can i know my SID ... during the installation i used it but later on i forgot ...
thanks in advance for helping me ...
|
|
|
Re: host string [message #62284 is a reply to message #62278] |
Mon, 12 July 2004 02:41 |
K. Prakash babu
Messages: 46 Registered: July 2001
|
Member |
|
|
Host string is the name that you configure while connecting to the server from client. U can see the host string in Oracle_HomeNetworkadmintnsnames.ora file.
To get the sid, run this query by connecting as sys or system user..
select value from v$parameter where name='db_name';
-Prash
|
|
|