Connection problem [message #496341] |
Sun, 27 February 2011 02:10 |
ultgnp
Messages: 106 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 #496352 is a reply to message #496348] |
Sun, 27 February 2011 03:41 |
|
Michel Cadot
Messages: 68729 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Did you try what is in the "Action' section? It is the FIRST step to solve your problem.
Regards
Michel
|
|
|