-
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
-
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 ..
Raghu
-
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
-
Can somebody look at this plz ????
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|