Home » RDBMS Server » Enterprise Manager » Oracle Client Configuration (HostString)
Oracle Client Configuration (HostString) [message #68090] Wed, 30 October 2002 23:07 Go to next message
Reena D
Messages: 3
Registered: October 2002
Junior Member
Question is where do I set host string on server for client

SQL PLUS works on server but doesn't work on client.

I tried configuring hostname for client from Net8 Easy Config but test failed. Where do I get reqd.knowledge like host name,sid, etc. to configure client. It gives error related to TNS.
Re: Oracle Client Configuration (HostString) [message #68091 is a reply to message #68090] Thu, 31 October 2002 05:24 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. edit your tnsnames.ora file available at
   $ORACLE_HOME/network/admin
say for this entry,

STAFFA_CPUB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = *******)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cpub)
    )
  )

staffa_cpub = is the connec string
host        = name of your machine or IP
sid         = your datbase sid

for this tnsnames.ora config,
i would connect like
SQL*Plus: Release 8.1.6.0.0 - Production on Thu Oct 31 08:08:17 2002

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> connect dbadmin@staffa_cpub
Enter password: *********
Connected.
SQL> 

Previous Topic: Displaying active services
Next Topic: 2 orcle servers - 1 OEM
Goto Forum:
  


Current Time: Fri May 20 12:46:25 CDT 2022