Tuesday, September 22, 2015

Creating a new ODSM connection

In this post we shall see steps to create a new connection for ODSM and also how to unlock "orcladmin" super user.


PRE - REQUISITES: 


Step 1) Run RCU to create ODS schema.




STEPS TO CREATE NEW CONNECTION:


Step 1) Login to ODSM console:
Check wls_ods1.url @$MW_HOME/user_projects/domains/$DOMAIN_NAME/servers/wls_ods1/data/nodemanager

Step 2) Click on Connect to a directory → Create A New Connection

 

Step 3) Fill in the details as below:

Directory Type : OID
Name : OIDConenction
Server : Physical server details where ODS server is installed(Hostname or IP Address)
Port : Port number for OID
Note: To confirm Port number of OID check below files:

Windows : C:\Oracle\Middleware\asinst_1\config\OPMN\opmn\ports.prop

Solaris: staticports.ini
SSL Enabled : Uncheck it.
Username : cn=orcladmin ( since it is super user)
Password : Password for orcladmin user set at Step 10 

 

Step 4) Click Connect.

Step 5) Logged in and check all available options in ODSM console.

 


ISSUES:


Super user account ( cn=orcladmin) got locked.
We were unable to login with the user cn=orcladmin and  got  the following error in the OID logs.
ERROR : cn=orcladmin : Your account is locked. Contact your OID administrator.]
In order to fix this issue, we need to unlock super user orcladmin in OID server .

SOLUTION: 

 

Step 1) Login to OID Server.

Step 2) Export all environment variables:

export ORACLE_INSTANCE=$MW_HOME/asinst_1
export ORACLE_HOME=$MW_HOME/Oracle_IDM1
export ORACLE_SID=”DBNAME”

Step 3) Navigate to $ORACLE_HOME/ldap/bin
Execute the following command
./oidpasswd connect=connect_string unlock_su_acct=true
where connect_string=SIDName(Database Name)

Example:

$ oidpasswd connect=oiddb unlock_su_acct=true
OID DB user password:
Password of ODS schema created at time of RCU Step 7
OID super user account unlocked successfully.

Forgot ODS schema password??Click Here

Step 4) This will unlock super user orcladmin in OID and we can login to ODSM console with cn=orcladmin user now.

No comments:

Post a Comment

Other Posts