For setup details, refer: It-dba/omegadb oid registration
Replace with the following:
OID location in ldap.ora
DIRECTORY_SERVERS= (finssodir.thefacebook.com:636:636)
OMSPRD_PRN password expired in the OAM as per the security policies. Executed the below commands to validate the existing password.
Error: DB-OID bind credentials failed.
Metalink ID : 340559.1 ( for the commands reference)
On the db node xd05dbadm01/02
./mkstore -wrl /u01/app/oracle/product/db_omsprd/admin/OMSPRD_PRN/wallet -viewEntry ORACLE.SECURITY.DN
./mkstore -wrl /u01/app/oracle/product/db_omsprd/admin/OMSPRD_PRN/wallet -viewEntry ORACLE.SECURITY.PASSWORD
[oracle@xd05dbadm01 bin]$ ./mkstore -wrl /u01/app/oracle/product/db_omsprd/admin/OMSPRD_PRN/wallet -viewEntry ORACLE.SECURITY.DN
Oracle Secret Store Tool : Version 12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.
Enter wallet password:
ORACLE.SECURITY.DN = cn=OMSPRD_PRN,cn=OracleContext,dc=thefacebook,dc=com
[oracle@xd05dbadm01 bin]$ ./mkstore -wrl /u01/app/oracle/product/db_omsprd/admin/OMSPRD_PRN/wallet -viewEntry ORACLE.SECURITY.PASSWORD
Oracle Secret Store Tool : Version 12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.
Enter wallet password:
ORACLE.SECURITY.PASSWORD = encrypted string.
- To change the password, please execute the below steps.
Login to the odsm
http://prn-finoamprd01.thefacebook.com:7005/odsm
username: orcladmin, password : xxxxx
Navigate to "Data Browser" tab and search for the "OMSPRD_PRN", Then in the result click on it.
Then go to the password attribute at the bottom of the page and change the password and click on apply on the top right hand side.
Change the password in the wallet on the db servers xd05dbadm01/02
./mkstore -wrl /u01/app/oracle/product/db_omsprd/admin/OMSPRD_PRN/wallet -modifyEntry ORACLE.SECURITY.PASSWORD newpassword
To validate new credentaials use the following command.
./ldapbind -h prn-finoamprd01.thefacebook.com -p 3060 -D "cn=OMSPRD_PRN,cn=OracleContext,dc=thefacebook,dc=com" -w "newpassword"