Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Solutions › Topic Id: 2373 | Permalink

find ORASSO password

Topic ID: 2373
Created By: 2007-MAY-09 17:06:26 [Vitaliy]
Updated By: 2007-MAY-09 17:08:04 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
7828
2007-MAY-09 17:06:26
Moderator
 
 
Registered On: Mar 2006
Total Posts: 233
Here's how to find ORASSO password using ldapsearch:

ldapsearch -h infra-box.company.com -p 389  \
  -D cn=orcladmin -w orcladmin-password \
  -b "cn=IAS Infrastructure Databases, cn=ias, cn=Products, cn=OracleContext" \
  -s sub "orclResourceName=ORASSO" orclpasswordattribute

example:

   infra-box.XYZP-> ldapsearch -h infra-box.company.com -p 389  \
     -D cn=orcladmin -w somepassword \
     -b "cn=IAS Infrastructure Databases, cn=ias, cn=Products, cn=OracleContext" \
     -s sub "orclResourceName=ORASSO" orclpasswordattribute
   >   -D cn=orcladmin -w somepassword \
   >   -b "cn=IAS Infrastructure Databases, cn=ias, cn=Products, cn=OracleContext" \
   >   -s sub "orclResourceName=ORASSO" orclpasswordattribute
   OrclResourceName=ORASSO,orclReferenceName=XYZP.company.com,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext
   orclpasswordattribute=ETXx8521

NOTE:
   Oracle documentation has an error for this syntax
   which will prevent you getting the password:

PRODUCTION_INFRA_HOME/bin/ldapsearch -h production_oid_host 
-p production_oid_port -D cn=orcladmin -w production_orcladmin_passwd 
-b "orclreferencename=metadata_rep_global_db_name, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" 
-s base "(orclresourcename=orasso)" orclpasswordattribute

REFERENCE:
   Staging a Test Environment from a Production Environment
[edited by: Vitaliy at 17:08 (CST) on May. 09, 2007]