I want to connect to Oracle Portal Schema to perform few database operations. But unfortunately, I forgot the schema password. In order to retrieve the portal schema password I have used the LDAP Search utility as below –ldapsearch -h localhost -p 389 -D “cn=orcladmin” -w Oracle123 -b “cn=IASInfrastructureDatabases,cn=PORTAL,cn=Products,cn=OracleContext” -s sub “orclResourceName=PORTAL” orclpasswordattribute OrclResourceName=PORTAL,orclReferenceName=Oraser-pc.idc.oracle.com,cn=IASInfrastructureDatabases,cn=IAS,cn=Products,cn=OracleContext orclpasswordattribute=R1ko17P0(This is the password in the OID)
But while executing the above command I encountered few errors. One of them is like “LDAP: No object found“.
The solution to find the Oracle Portal schema password is from Oracle Directory Manager.
1. Open the Oracle Directory Manager, which is in the following path –
Start -> All Programs -> Oracle Application Server – OraInfra ->Integrated Management Tools->Oracle Directory Manager
You will see the following screenshot
User: cn=orcladmin (Which is Super User).
Password: Oracle123 (Given while Installation).
Server: localhost (Usually better to use for avoiding few errors while connecting).
Entry Management —> cn=Oracle Context –> cn=Products –> cn = IAS –> cn=IAS Infrastructure Databases –> orclReferenceName=OracInfra.idc.oracle.com
5. Under orclReferenceName=OracInfra.idc.oracle.com mouse double click on “OraResourceName=Portal” as shown below –
7. In the above screen on righ side you will find orclpasswordattribute field, where you will get the Portal Schema Password. Use this to connect and to perform database operations.