About five years ago I found out this trick the hard way. I say the hard way because there are similar users like ORASSO. The first time I needed the user orasso. I got on the internet and found out where to look, as you can read here. Then I needed the user orasso_[xyz] again. So I looked again. But the password didn’t work. Ok, there are more users here and some times you need a similar one like I did that day. The user orasso_[xyz] looked to me the same but it isn’t.
But now here’s the way to find out the user passwords which Oracle uses to log in to the Repository.
- Start the tool OIDADMIN.
- be sure you have a X-Server application (eg. Kea!X, Exceed etc.) running on you’re pc.
- log on to the Linux box (I mostly use the program putty.exe for this)
- export DISPLAY=[i .p. address of XP machine]:0 (syntax varies for other shells)
- Log on with cn=orcladmin
- In the left frame you need to click trough the following following entries:
cn=IAS Infrastructure Databases
The orclpasswordattribute text box on the OrclResourceName=ORASSO tab contains the schema password.
You can also use ldapsearch to get the password. For more info, you can check the Oracle Application Server Single Sign-On Administrator’s Guideracle site.