TNS Issue
I'm having an issue with a database link from one server to another. I'm able to TNSPING the remote instance from the destination server, but anytime I try to connect to it, I get a ORA-12514 error.
[code]
<user>@<server>:/opt/oracle/ora10.1/network/admin> tnsping orcl
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 07-MAY-2009 09:22:39
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <xx.xx.xx.xx>)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (20 msec)
<user>@<server>:/opt/oracle/ora10.1/network/admin> sqlplus user/<pwd>
[code]
<user>@<server>:/opt/oracle/ora10.1/network/admin> tnsping orcl
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 07-MAY-2009 09:22:39
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <xx.xx.xx.xx>)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (20 msec)
<user>@<server>:/opt/oracle/ora10.1/network/admin> sqlplus user/<pwd>
0