OraFAQ Forum: Networking and Gateways » Client install..Listener or TNSnames??

Home » RDBMS Server » Networking and Gateways » Client install..Listener or TNSnames??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Client install..Listener or TNSnames?? [message #235291]

Fri, 04 May 2007 14:30

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,

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #235292 is a reply to message #235291]

Fri, 04 May 2007 14:38

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #235294 is a reply to message #235292]

Fri, 04 May 2007 15:04

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

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #235300 is a reply to message #235294]

Fri, 04 May 2007 15:37

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?

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #235301 is a reply to message #235294]

Fri, 04 May 2007 15:41

Mahesh Rajendran
Messages: 10707
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

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)
)
)

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #236066 is a reply to message #235653]

Tue, 08 May 2007 23:35

Littlefoot
Messages: 21807
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)
    )
  )

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #236068 is a reply to message #236066]

Tue, 08 May 2007 23:50

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...

Report message to a moderator

Re: Client install..Listener or TNSnames?? [message #236069 is a reply to message #236068]

Tue, 08 May 2007 23:52

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

Report message to a moderator