Home » RDBMS Server » Networking and Gateways » Connection problem (win 2003, 10.2.0.1)
Connection problem [message #496341] Sun, 27 February 2011 02:10 Go to next message
ultgnp
Messages: 105
Registered: May 2010
Location: Germany
Senior Member
Hi,

I want to connect to other machine (ACCTS) from my server. I tried the following settings in tnsnames.ora. It's giving me


SQL> SELECT BANNER FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> CONN ULTGNP/TEST@ACCTS
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


*Tnsnames.ora file*

ACCTS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 134.50.0.253)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )


*PING is working.*
C:\Documents and Settings\Administrator>TNSPING ACCTS

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-FEB-2
011 10:47:33

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

Used parameter files:
E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 134.50.0
.253)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL)))

OK (60 msec)


*sqlnet.ora*

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


Please suggest where else do i need to make changes.

Thank You
Re: Connection problem [message #496345 is a reply to message #496341] Sun, 27 February 2011 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67466
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: Connection problem [message #496347 is a reply to message #496345] Sun, 27 February 2011 03:22 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How many TNSNAMES.ORA files are there on your computer? If more than one, are you sure you are using the one you think you are? Perhaps you should consider using a TNS_ADMIN environment variable (which points to a TNSNAMES.ORA you use and maintain).
Re: Connection problem [message #496348 is a reply to message #496347] Sun, 27 February 2011 03:27 Go to previous messageGo to next message
ultgnp
Messages: 105
Registered: May 2010
Location: Germany
Senior Member
I have only 2 TNSNAMES.ORA file. One is a sample file and the other is the required one.
Re: Connection problem [message #496352 is a reply to message #496348] Sun, 27 February 2011 03:41 Go to previous message
Michel Cadot
Messages: 67466
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try what is in the "Action' section? It is the FIRST step to solve your problem.

Regards
Michel
Previous Topic: Cant open tnsnames.ora file .
Next Topic: Listener
Goto Forum:
  


Current Time: Mon Oct 26 11:37:27 CDT 2020