Oidpasswd Fails with "[gsldpp_GetDBInstName] ORA-942 ORA-00942: table or view does not exist" (Doc ID 2014264.1)

Last updated on AUGUST 29, 2019

Applies to:

Symptoms

Attempting to use oidpasswd causes the following failure:

<ORACLE_HOME>/ldap/bin/oidpasswd connect=OIDDB create_wallet=true
  password:
confirm password:
[gsldpp_GetDBInstName] ORA-942 ORA-00942: table or view does not exist
encountered
gsldpwdcPwdChang: Get SID from DB failed .
Unable to Connect to Database: Incorrect location for tnsnames.ora (derived from ORACLE_INSTANCE) or Incorrect TNS Connect string or Invalid Password

OR

<ORACLE_HOME>/ldap/bin/oidpasswd connect=OIDDB change_oiddb_pwd=true
current password:
   new password:
confirm password:
[gsldpp_GetDBInstName] ORA-942 ORA-00942: table or view does not exist
encountered
gsldpwdcPwdChang: Get SID from DB failed .
Unable to Connect to Database: Incorrect location for tnsnames.ora (derived from ORACLE_INSTANCE) or Incorrect TNS Connect string or Invalid Password

Testing query as ODS results in the following:

SQL> SELECT instance_name FROM v$instance WHERE   instance_number IN (SELECT MIN(instance_number) FROM v$instance)
 2  ;
SELECT instance_name FROM v$instance WHERE   instance_number IN (SELECT MIN(instance_number) FROM v$instance)
                         *
ERROR at line 1:
ORA-00942: table or view does not exist

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.