It has nothing to do with the Gklobal Name.

Your Service Name is nothing but the DB_NAME + the DB_DOMAIN.

Check these parameers in the Init.ora.

HTH

Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Monday, March 31, 2003 9:23 PM
To: LazyDBA.com Discussion
Subject: RE: SERVICE_NAME with domain name in tnsnames.ora file


Just a shot:

Try lsnrctl RELOAD after the change.

gr. Gw.

Raviraj <Ravi.[Email Address Removed] wrote:

>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]
>Visit 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 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
>
>

__________________________________________________________________
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promos=380455

--------
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