connectivity problem from DEV.SERVER to PROD SERVER [message #234523] |
Wed, 02 May 2007 00:32 |
sajut
Messages: 69 Registered: January 2007
|
Member |
|
|
Dear All
I have a development database (oracle 9i Rel2) under Suse Linux and a production database (oracle 9i rel2) again under Suse linux. Both under same network. while I try to connect from the development to production database using SqlPlus, I throws me with the following error.sqlplus
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 2 10:56:08 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: edis@prod
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name
Please help
my tnsnames.ora in development server is
EXTPROC_CONNECTION_DATA.yyyy.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
testdb.site=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.134)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb)
)
)
PROD.xxx.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)
|
|
|
|
|
|
|
|