Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSTANCE_NAME shows empty

ABU JAMANOct 11 2022

Hi all,
Good morning. We are in WIN 2016R2 ,RAC 18C 2-NODES ASM . I am getting below output while trying to get instance_name from v$instance. However show parameter instance_name shows the instance name. May i know why i am not able to see instance name on gv$instance?
SYS@*******> select instance_name from gv$instance
2 /

Comments
Post Details
Added on Oct 11 2022
2 comments
242 views