Home » RDBMS Server » Networking and Gateways » Client install..Listener or TNSnames??
Client install..Listener or TNSnames?? [message #235291] Fri, 04 May 2007 14:30 Go to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
Hi ,

I wanted to know when you install Oracle10g Client, do you need to have both a listener and TNSnames file or just TNSnames? Also, what about the sqlnet file?

Do we just add the TNS entry?

Thanks,
Re: Client install..Listener or TNSnames?? [message #235292 is a reply to message #235291] Fri, 04 May 2007 14:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Listener is serverside.
>>? Also, what about the sqlnet file?
Depends on the options you use.
>>Do we just add the TNS entry
Must for all sql*net based connections.
Re: Client install..Listener or TNSnames?? [message #235294 is a reply to message #235292] Fri, 04 May 2007 15:04 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
How come when I do tnsping db_name it works and when I try to connect it gives the:

12154:TNS could not resolve service name

Re: Client install..Listener or TNSnames?? [message #235300 is a reply to message #235294] Fri, 04 May 2007 15:37 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
What changes would I have to make on the server side (sqlnet.ora, TNS, or listener) to allows Oracle Clients to connect using TNSnames?
Re: Client install..Listener or TNSnames?? [message #235301 is a reply to message #235294] Fri, 04 May 2007 15:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Apparantly you are making a mistake somewhere.
Are you sure the tnsentries are right? beaware that the 'blanks' in your tnsnames.ora is very important.
Try this (just copy and paste.
Meanwhile, are you sure fprcdev.rh-development.fprc.ophth.wisc.edu is your sid/correct global name?
Also try with just fprcdev
fprcdev =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rh-development.fprc.ophth.wisc.edu)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = fprcdev.rh-development.fprc.ophth.wisc.edu)
    )
  )



And are you sure there is no firewall?
Are you sure you have NO entries in both sqlnet.ora?

[Updated on: Fri, 04 May 2007 15:58]

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #235653 is a reply to message #235291] Mon, 07 May 2007 10:32 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
Ok, my developer is having connection problems.

He has installed Oracle10g client and has added the appropriate TNS entries to the TNSnames file but he still cannot connect. Below is a list of the commands I ran and his TNSnames file.

H:\>tnsping rctest.japan.fprc.ophth.wisc.edu

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-MAY-2
007 10:20:24

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME
= rctest.japan.fprc.ophth.wisc.edu)))
OK (30 msec)

H:\>tnsping rctest

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-MAY-2
007 10:20:35

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME
= rctest.japan.fprc.ophth.wisc.edu)))
OK (30 msec)

H:\>set ORACLE_SID=rctest.japan.fprc.ophth.wisc.edu

H:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 7 10:21:37 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect ctms/ctms@rctest.japan.fprc.ophth.wisc.edu
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> connect ctms/ctms@rctest.japan.fprc.ophth.wisc.edu
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> exit

H:\>set ORACLE_SID=rctest

H:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 7 10:23:05 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect ctms/ctms@rctest
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

****************
TNS NAMES File
****************
RCTEST.JAPAN.FPRC.OPHTH.WISC.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rctest.japan.fprc.ophth.wisc.edu)
)
)

RCTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rctest.japan.fprc.ophth.wisc.edu)
)
)







Re: Client install..Listener or TNSnames?? [message #236066 is a reply to message #235653] Tue, 08 May 2007 23:35 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you post SQLNET.ORA as well?

BTW, there's no need for you to have TWO TNSNAMES.ORA entries for the same database - make it one, and separate aliases with a comma:
RCTEST, RCTEST.JAPAN.FPRC.OPHTH.WISC.EDU =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rctest.japan.fprc.ophth.wisc.edu)
    )
  )
Re: Client install..Listener or TNSnames?? [message #236068 is a reply to message #236066] Tue, 08 May 2007 23:50 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
You can also try this version ....
RCTEST, RCTEST.JAPAN.FPRC.OPHTH.WISC.EDU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ***yoursid***)
)
)

use your SID instead of the service name , hope your sid is rctest. let us know whether this works...
Re: Client install..Listener or TNSnames?? [message #236069 is a reply to message #236068] Tue, 08 May 2007 23:52 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
test.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = japan.fprc.ophth.wisc.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ***yoursid***)
)
)


when you call , use test.world

like username /password@test.world
Re: Client install..Listener or TNSnames?? [message #236340 is a reply to message #235291] Wed, 09 May 2007 12:10 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
We just did a fresh install and got it to work.

Thanks
Re: Client install..Listener or TNSnames?? [message #236361 is a reply to message #236340] Wed, 09 May 2007 13:47 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, if it won't budge, use a larger hammer.
Previous Topic: Listner Config.
Next Topic: how to use database link on the remote database?
Goto Forum:
  


Current Time: Sun Dec 11 00:46:54 CST 2016

Total time taken to generate the page: 0.10224 seconds