Error: GetHostName failed. ORA-01403: no data found
説明
Shareplex for Oracle Activation failing in an OPS/RAC environment with the following error GetHostName failed. ORA-01403: no data found.
対策
Check the gv$instance table and make sure that there is an entry for each instance of the database. A quick workaround is to create your own gv$instance table with entries for both the threads and hostname etc, create a private synonym for the splex user. A tar should be opened with oracle to diagnose the issue with Oracle Support.
SQL> desc gv$instance Name Null? Type ----------------------------------------- -------- ---------------------------- INST_ID NUMBER INSTANCE_NUMBER NUMBER INSTANCE_NAME VARCHAR2(16) HOST_NAME VARCHAR2(64) VERSION VARCHAR2(17) STARTUP_TIME DATE STATUS VARCHAR2(12) PARALLEL VARCHAR2(3) THREAD# NUMBER ARCHIVER VARCHAR2(7) LOG_SWITCH_WAIT VARCHAR2(11) LOGINS VARCHAR2(10) SHUTDOWN_PENDING VARCHAR2(3) DATABASE_STATUS VARCHAR2(17) INSTANCE_ROLE VARCHAR2(18) ACTIVE_STATE VARCHAR2(9)
and the table would be populated this way with a 2 node 9.2.0.1 RAC database
SQL> l 1* select * from gv$instance SQL> / 1 1 quest1 irvsupu10 9.2.0.1.0 02-JAN-04 OPEN YES 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
2 2 quest2 irvsupu11 9.2.0.1.0 02-JAN-04 OPEN YES 2 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
