I am finidng a problem in my database.....
Global_Name and v$thread are showing different , why is that ???
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
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 ..
I have another instance , i excuted the following scripts...
1) select name,value from v$parameter where name
2) select instance,status from v$thread;
3) select * from global_name;
results are :
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 ???
Can somebody look at this plz ????
Click Here to Expand Forum to Full Width