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 LazyDBA home page