Oracle ORDS Pool User Password Changes
Below Error occurs when, DB Pool user's passwords expires or locked. Way Out 1. Find out your Pool Users, by directly going into the ORDS conf. folder where you have configured it (Drive:\Oracle\ords\ords\conf), you will find Pool User's in those files. 2. Open These files to find out user name and set you password in PLAN TEXT in password TAG. Note : Do not Forget to Add ! <---- This Sign before your password, it will instructs ORDS.war service to encrypt this password, if not added as I left in this example, it will not convert this plain text to encrypted form The Plain Text Password Will Automatically Encrypt into Encrypted Form like below, once we Run ORDS.war 3. Repeat Step#2 with all other Files. 4. Now change Password at DB level for these cited users (APEX_PUBLIC_USER & OTHERS) by connecting to database as sysdba and issue alter user APEX_PUBLIC_USER identified by MYPASSWORD account unlock; 5.Run ORDS Service ...