Home » RDBMS Server » Server Administration » host string
host string [message #62278] Sat, 10 July 2004 03:41 Go to next message
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 Go to previous message
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
Previous Topic: How to reduce the extended system.dbf
Next Topic: ora -08103 error & not able to retirive rows
Goto Forum:
  


Current Time: Fri Sep 20 14:17:06 CDT 2024