B Obtaining the Single Sign-On Schema Password

The single sign-on schema password is randomized when the Oracle Application Server infrastructure is installed. You can use either the command-line tool ldapsearch or Oracle Directory Manager to obtain the password.

B.1 Using the Command Line

Use this syntax to obtain the schema password with ldapsearch:

ldapsearch  -h directory_host_name
             -p directory_ssl_port
             -D directory_bind_dn
             -w directory_bind_dn_password
             -b "orclReferenceName=infrastructure_database"
                "orclresourcename=ORASSO"
                orclpasswordattribute
             -u 1

The table that follows defines the parameters passed to ldapsearch.

Parameter	Description
directory_host_name	Host name of the directory server.
directory_ssl_port	Port number of the directory server.
directory_bind_dn	Distinguished name of the user authenticating to the directory.
directory_bind_dn_password	Password of the user authenticating to the directory.
infrastructure_database	Distinguished name of the directory entry under which the password attribute (orclpasswordattribute) is located.
-u	Changes the directory port to an SSL port globally.

Here is an example:

ldapsearch -h oid.acme.com
           -p 636
           -D "cn=orcladmin"
           -w welcome1
           -b "orclReferenceName=disco.us.acme.com,cn=IAS Infrastructure
              Databases,cn=IAS,cn=Products,cn=oraclecontext"
              "orclresourcename=ORASSO"
              orclpasswordattribute
           -u 1

B.2 Using Oracle Directory Manager

Follow these steps to obtain the schema password with Oracle Directory Manager:

1. Launch the tool:

   ORACLE_HOME/bin/oidadmin
   
   

2. In the System Objects frame, expand in succession the following entries:

   • Entry Management

   • cn=OracleContext

   • cn=Products

   • cn=IAS

   • cn=IAS Infrastructure Databases

   • orclReferenceName=database_service_name_for_infrastructure_database

   • OrclResourceName=ORASSO

The orclpasswordattribute text box on the OrclResourceName=ORASSO tab contains the schema password.