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.


Step 1) Run RCU to create ODS schema.


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.



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 .



Step 1) Login to OID Server.

Step 2) Export all environment variables:

export ORACLE_INSTANCE=$MW_HOME/asinst_1

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)


$ 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