My Oracle Support Banner

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

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Attempting to use oidpasswd causes the following failure:


/ora/mw_idm_int/Oracle_IDM/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

 /ora/mw_idm_int/Oracle_IDM/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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.