Installation Of OID 11.1.1.9 On RHEL7 Fails With 2 error dialogs in linking phase (ins_asha.mk, ins_sqlplus.mk)

New DocumentInstallation Of OID 11.1.1.9 On RHEL7 Fails With 2 error dialogs in linking phase (ins_asha.mk, ins_sqlplus.mk) (Doc ID 2190467.1)
Advertisements

OID – ODS Password Resets

# Issue : OID cannot restart, logs show the following messages :


[2016-05-04T04:02:02-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: Connecting to database, connect string is oiddb

[2016-05-04T04:02:02-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: [gsdsiConnect] ORA-28002, ORA-28002: the password will expire within 7 days
[2016-05-04T04:02:02-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: [oidmon]: Unable to connect to database,
will retry again after 10 sec

[2016-05-04T04:02:12-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: Connecting to database, connect string is oiddb

[2016-05-04T04:02:12-07:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost] [pid: 4984] [tid: 0] Guardian: [gsdsiConnect] ORA-28002, ORA-28002: the password will expire within 7 days

Solution :

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 4 04:08:34 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect ODS/Welcome1
ERROR:
ORA-28002: the password will expire within 7 days
Connected.
SQL> PASSWORD
Changing password for ODS
Old password:
New password:
Retype new password:
Password changed