Home » SQL & PL/SQL » SQL & PL/SQL » hoststring in sql*plus
hoststring in sql*plus [message #228647] Tue, 03 April 2007 09:49 Go to next message
Messages: 202
Registered: April 2006
Senior Member
What is the host string I should enter to login to my sql*plus

here are my database details I configured datasources I can access database from java but i donot know what host I have to enter in sql*plus
here are my details

now can I derive host string with inforamtion or can I derive host string with tnsnames.ora ?
Re: hoststring in sql*plus [message #228653 is a reply to message #228647] Tue, 03 April 2007 10:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If you are working on a local database (database installed in the machine you work), you no need to worry about hoststring.
just use username and password.
If there are multiple databases in the same machine or you are working on remote database, you need a hoststring (unless you want to set ORACLE_SID every time).
Hoststring is defined in your $ORACLE_HOME/network/admin/tnsnames.ora.
You can have it anything you want.
For this sample entry, SCID1 is the hoststring
   (ADDRESS = (PROTOCOL = TCP)(HOST =xxxx)(PORT = 1534))
     (SERVICE_NAME =xxx)
     (INSTANCE_NAME = xxx)
Re: hoststring in sql*plus [message #228654 is a reply to message #228647] Tue, 03 April 2007 10:02 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


host string with tnsnames.ora ?

Yes, Host string >>> "tns_entry" you can get from TNSNAMES.ORA file.

[B]ORA101[/B] =
    (ADDRESS = (PROTOCOL = TCP)(HOST = alwarid-taj.fakhruddin.local)(PORT = 1521))
      (SERVICE_NAME = ORA101)

Hmmm, too slow...


[Updated on: Tue, 03 April 2007 10:03]

Report message to a moderator

Previous Topic: dbms_random.seed performance issue
Next Topic: SQL query cleanup
Goto Forum:

Current Time: Tue Aug 22 04:04:40 CDT 2017

Total time taken to generate the page: 0.01729 seconds