Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database name confusion
Don't know why -- but here is how to change it, if memory is "server" me
right.
alter system set global_name = <db_should_be>;
TurkBear wrote in message <385542d0.4562971_at_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 Tue Dec 14 1999 - 22:39:17 CST