Database name confusion

From: TurkBear <johng_at_mm.com>
Date: Mon, 13 Dec 1999 19:08:08 GMT
Message-ID: <385542d0.4562971@super.news-ituk.to>

Where is the database name set?

I have 2 Oracle databases ( one 7.3.4 on 8.1.5)

In the init<sid>.ora file for the 7.3.4 the database name is set to Oracle, yet when I query global_name it returns HRO1.WORLD ( which is an alias in my tnsnames.ora file)

In the 8.1.5 the database name is set ( in the init file) to myora and the domain is world, yet select * from global_name returns ORACLE -

Help, I'm confused -

This is making the creation of database links in my 8.1.5 system very confusing, since it seems to need the database name as the link name...

John Greco

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Dec 13 1999 - 13:08:08 CST