ORA-01017: invalid username/password when starting up OID 11g

Problem

When trying to startup the OID OPMN processes:

${ORACLE_HOME}/asinst_1/bin/opmnctl startall

In this file /u01/app/oracle/middleware/asinst_1/diagnostics/logs/OID/oid1/oidmon-0000.log, you see the following error:

[2017-04-26T21:39:25.10925+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oamhost1.raastech.com] [pid: 17029] [tid: 0] Guardian: Connecting to database, connect string is oiddb 

[2017-04-26T21:39:26.57778+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oamhost1.raastech.com] [pid: 17029] [tid: 0] Guardian: [gsdsiConnect] ORA-1017, ORA-01017: invalid username/password; logon denied

Solution

1. The DBA should unlock the ODS account:

ALTER USER ods ACCOUNT UNLOCK;

2. Connect as ODS and see if this query works:

CONN ods/**********;

SELECT instance_name FROM v$instance WHERE instance_number IN (SELECT MIN(instance_number) FROM v$instance);

3. If the query returns an ORA-00942 error, then log in as SYSTEM and grant these permissions:

SELECT * FROM sys.dba_role_privs WHERE grantee = "ODS";

ALTER USER ods DEFAULT ROLE SELECT_CATALOG_ROLE, RESOURCE, CONNECT;

Applicable Versions

• Oracle Internet Directory (OID) 11g