Home » RDBMS Server » Networking and Gateways » connectivity problem from DEV.SERVER to PROD SERVER
connectivity problem from DEV.SERVER to PROD SERVER [message #234523] Wed, 02 May 2007 00:32 Go to next message
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)
)
)
Re: connectivity problem from DEV.SERVER to PROD SERVER [message #234548 is a reply to message #234523] Wed, 02 May 2007 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-12154: TNS:could not resolve service name
 *Cause:  The service name specified is not defined correctly in the
 TNSNAMES.ORA file.
 *Action:  Make the following checks and correct the error:
           - Verify that a TNSNAMES.ORA file exists and is in the proper
             place and accessible. See the operating system specific manual
             for details on the required name and location.
           - Check to see that the service name exists in one of the
             TNSNAMES.ORA files and add it if necessary.
           - Make sure there are no syntax errors anywhere in the file.
             Particularly look for unmatched parentheses or stray characters.
             Any error in a TNSNAMES.ORA file makes it unusable. See
             Chapter 4 in the SQL*Net V2 Administrator's Guide. If
               possible, regenerate the configuration files using the Oracle
               Network Manager.

In tnsnames.ora service name is "PROD.xxx.COM" not "prod".
Check if you have a default_domain defined in sqlnet.ora.

Regards
Michel
Re: connectivity problem from DEV.SERVER to PROD SERVER [message #234551 is a reply to message #234548] Wed, 02 May 2007 02:00 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
Thanks Michael for the reply
My sqlnet.ora looks
# SQLNET.ORA Network Configuration File: /opt/oracle/920/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.


SQLNET.AUTHENTICATION_SERVICE=NONE
Re: connectivity problem from DEV.SERVER to PROD SERVER [message #234560 is a reply to message #234551] Wed, 02 May 2007 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you don't have a default domain and you have to give it in your service name (your instance domain is xxx.COM).

Regards
Michel
Re: connectivity problem from DEV.SERVER to PROD SERVER [message #234576 is a reply to message #234523] Wed, 02 May 2007 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Alternatively you could modify tnsname.ora to contain following entry:

PROD.xxx.COM,prod =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)

You can specify multiple alias names to the left of the 1st equal sign by seperating them with commas as I have done above.
Re: connectivity problem from DEV.SERVER to PROD SERVER [message #235330 is a reply to message #234576] Sat, 05 May 2007 01:35 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
Thanks anacedent for the reply. It worked with your suggestion
Previous Topic: How many listeners can we have in one server
Next Topic: connecting to Oracle 10G using SQLPLUS and LDAP from OS390
Goto Forum:
  


Current Time: Wed Apr 24 17:22:17 CDT 2024