How to get the Portal Schema Password

Subject: How to get the Portal Schema Password of the Infrastructure database
Doc ID: 198800.1 Type: HOWTO
Modified Date : 16-JUN-2009 Status: PUBLISHED


Checked for relevance on 05-Apr-2007

Problem Description
-------------------
How to get the Portal schema password of the Infrastructure database?


Solution Description
--------------------
1. Start up the Oracle Internet Directory administration tool from
infrastructure machine.

At Unix prompt> $ORACLE_HOME/bin/oidadmin
Or
Windows: Start -> Programs -> 9iAS midtier home -> Integrated Management Tools -> Oracle Directory Manager

1.1. If you are using it for the first time, the following message will be
displayed:
"To use this too you must first connect to a Server.
Click on the OK Button to select a Server..."

1.2. Click the OK button.

1.3. Click on the Add button and type in the following:
Servername:
Port : 4032 (the default port for OID - without SSL).

Click on OK... and Select button.

2. To gain access to the Oracle Directory Manager Connect
User : cn=orcladmin
Password:
Server : host running Oracle Internet Directory and port number
where Oracle Internet Directory is listening

The default port for Oracle Internet Directory is 4032(without SSL)

3. Navigate the Single Sign-On schema (orasso)or Portal schema entry using the administration
tool (9.0.2.x).
=> cn=orcladmin@OID_hostname:OID_port
(for example: cn=orcladmin@infra.acme.com:4032)
=> Entry Management
=> cn=OracleContext
=> cn=Products
=> cn=IAS
=> cn=Infrastructure Databases
=> ReferenceName=:
=> ResourceName=Portal

->For Portal 9.0.4.x, 10.1.2.x and 10.1.4.x this is under:
=> cn=orcladmin@OID_hostname:OID_port
(for example: cn=orcladmin@infra.acme.com:4032)
=> Entry Management
=> cn=OracleContext
=> cn=Products
=> cn=IAS
=> cn=IAS Infrastructure Databases
=> orclReferenceName=asdb.
=> OrclResourceName=PORTAL

Navigate backwards to that in oidadmin gui to look for the orclpasswordattribute.

->Portal 10.1.4.x. You will need to use the ldapsearch command line utility to retrieve the password.
The syntax is similar to this:
ldapsearch -h -p -D cn=orcladmin -w -b "cn=IAS,cn=Products,cn=OracleContext" -s sub -v OrclresourceName=PORTAL| grep orclpasswordattribute

4. Click the above entry and look for the orclpasswordattribute attribute value
on the right panel. This value is the password for the Portal schema.