Friday, November 10, 2017

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