global_name

[mrvajrala]

Hello All,
I am finidng a problem in my database.....
Global_Name and v$thread are showing different , why is that ???

I did
ALTER DATABASE RENAME GLOBAL_NAME TO "blah";

Now both are showing the same database name. but would like to know why it was showing different

Thanks,
Madhu

[raghud]

V$thread shows the instance name ,but not the global name . You can set instance name and global name as same . If you set globalname = true . You have to use the same name to connect to database via database links ..May be emaster's can explain this better than me ..

[mrvajrala]

Thanks Raghu,
I have another instance , i excuted the following scripts...
1) select name,value from v$parameter where name
like 'global_names';

2) select instance,status from v$thread;

3) select * from global_name;

results are :
1. FALSE
2. BLAH
3. BLAH

so what do u say now..... even without setting the gloabal_name as TRUE , i am able to see GLOBAL_NAME and INSTANCE name as same,

But in some other instance i was not able to ???

May be some GURU can explian this ???

Thanks again,
Madhu

[mrvajrala]

Can somebody look at this plz ????

[marist89]

http://metalink.oracle.com/metalink/...NOT&id=15390.1