Have you checked the ORACLE_SID parameter?
-----Original Message-----
From: Sami Seerangan [mailto:[Email Address Removed] Monday, March 31, 2003 5:54 PM
To: LazyDBA.com Discussion
Subject: SERVICE_NAME with domain name in tnsnames.ora file
Hi All DBAs,
I have TWO exactly similar DBs(CLONEDB is cloned from
TESTDB) running on the same machine.
I have a question in SERVICE_NAME in tnsnames.ora
file.
If i specify SERVICE_NAME = CLONEDB.i2.com it is
working fine(meaning i'm able to connect from client)
but the same time if i specify SERVICE_NAME =
TESTDB.i2.com then it is giving me the following error
while tring to connect from client.
SQL> connect system/[Email Address Removed] TNS:listener could not resolve SERVICE_NAME
given in connect descriptor
SQL> connect system/[Email Address Removed] is working fine
Could some one explain me the reason?
==========
WOkring TNS entry
==========
CLONEDB.mydomain.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MY_HOST)(PORT
= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CLONEDB.mydomain.com)
)
)
==========
NON WOkring TNS entry
==========
TESTDB.mydomain.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MY_HOST)(PORT
= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB.mydomain.com)
)
)
I guess this is something to do with global name, but
not sure how to make it consistent
In both DBs i have executed
"alter database rename global_name to
<dbname>.<domain>"
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page