How to find out Schema Passwords in a 10gAS Application Server

There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:-

A) Steps (through the ODM tool):-

1) Log onto the host that hosts the infrastructure tier (e.g. host is – ausable) using x-windows like Hummingbird.

2) Log on as user “oracle” – the user that did the install.

3) Source the infrastructure tier environment file (if you have one created that sets all the env. vars) as below:-

a. $ cd bin – location of the environment file.

b. $ . <as_infra> – environment file name.

4) Open up oidadmin – Oracle Directory Manager tool as:-

a. $ oidadmin

b. Log in as orcladmin/<pwd> user.

5) Follow the navigation path as below:-

Oracle Internet Directory Services -> orcladm@ausable.rfsuny.org:389 -> Entry Management -> Cn=OracleContext -> Cn=Products ->Cn=IAS -> Cn=IAS Infrastructure Databases -> OrclReferenceName=<infra.rfsuny.org> -> OrclResourceName=<PORTAL> – The schema name you want the password for.

6) On the right hand side window-pane, you should see a property called “orclpasswordattribute” on the “Properties” tab.

7) The Properties Tab would contain the password for the schema as shown in Figure A below:-

Figure A

8) When logging in through SQL*Plus, the password is case in-sensitive as usual.

B) Steps (through the command line):-

1)Log onto the host that hosts the infrastructure tier (ausable).

2)Log on as user “oracle” – the user that did the install.

3) Source the infrastructure tier environment file as below:-

a. $ cd bin – location of the environment file.

b. $ . <as_infra> – environment file name.

4) $ ldapsearch -D cn=orcladmin -w inadm02 -p 389 -h ausable -b “cn=IAS,cn=Products,cn=OracleContext” -s sub -v OrclresourceName=<Schema Name>

5) You should see the O/P like this below on the host:-

ldap_init( ausable, 389 )filter pattern: OrclresourceName=PORTAL

returning: ALL

filter is: (OrclresourceName=PORTAL)

OrclResourceName=PORTAL,orclReferenceName=infra.rfsuny.org,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext

orclflexattribute1=true

orclresourcename=PORTALobjectclass=orclResourceDescriptor

objectclass=top orclpasswordattribute=<Schema Password>

OrclResourceName=PORTAL,orclReferenceName=infra2.rfsuny.org,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContextorclpasswordattribute=<Schema Password>orclflexattribute1=trueorclresourcename=PORTALobjectclass=orclResourceDescriptorobjectclass=top

2 matches

6) From the above pick the password from the instance you are interested in finding out the password.

About the Author Atul Kumar

Leave a Comment:

3 comments

dp_singh says December 15, 2009

fine

i have a doubt about sso users resource password

i have 10gAS 10.2.1 and 10g forms running through portal. i have configured 763 sso user with RAD . database user is single. Now i need to change the password of that database user. sqlplus or other back-end has been ruled out according to oracle. I am using form services as recommended . Now when i change the password through form services after expiring current password. Only one sso user is got validated. not all the user. It is suppose to be change the password in all the sso users in one go.

SR — OTN documents throughly scanned line by line . Expert advice is solicited. treat as SOS.

Atul Kumar says December 15, 2009

@ dp_singh,

What is RAD ?

Q. Now i need to change the password of that database user .
Do you mean orasso ?

Q. I am using form services, What do you mean by forms services ?
Is this via Ias console or directory manager or API ?

Q. Which document you are using to change password ?

dp_singh says December 15, 2009

Dear Atul

1. RAD –>OracleAS Forms Services applications on the Web use SQL*Net to connect an
application to the database. This also is true for Forms applications that run in single sign-on mode. To connect a single sign-on Forms application to the database, the user’s database connect information is read from a named entry in Oracle Internet Directory by the Forms Servlet.

2. not orasso but the production database user in used to connect in RAD(Resource access descriptor)

3. using ias console

4. document used–> http://www.oracle.com/technology/products/forms/pdf/10g/frm10gsso.pdf

Add Your Reply