Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-28001: the password has expired Error-Code:28001 in Apex URL

Posted by Hendry chinnapparaj on August 18, 2010

Problem

————

You try to access the APEX 3.2 Application URL, fails with

Database Log In Failed

TNS is unable to connect to destination. Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Verify that the TNS name in the connectstring entry of the DAD for this URL is valid and the database listener is running.

ORA-28001: the password has expired Error-Code:28001 Error TimeStamp:Wed, 18 Aug 2010 00:48:12 GMT

Diagnosis

————

And you check the database and confirm the account APEX_PUBLIC_USER is expired

Solution

———-

Go to the Server where Apex apps http server is running and get the password

———

devu025>pwd

/u01/oracle/product/apex/Apache/modplsql/conf

View dads.conf

PlsqlPathAliasProcedure portal.wwpth_api_alias.process_download

</Location>

<Location /pls/apex>

SetHandler pls_handler

Order deny,allow

Allow from all

AllowOverride None

PlsqlDatabaseUsername APEX_PUBLIC_USER

PlsqlDatabasePassword hello

PlsqlDatabaseConnectString devu024:1521:ofsad1.greatwest.com ServiceNameFormat

PlsqlDefaultPage apex

PlsqlDocumentTablename wwv_flow_file_objects$

PlsqlDocumentPath docs

PlsqlDocumentProcedure wwv_flow_file_mgr.process_download

PlsqlAuthenticationMode Basic

———-

Here the APEX_PUBLIC_USER password is “admin”

Now connect to the apex oracle database and alter the user and change the password as it is

SQL> alter user APEX_PUBLIC_USER identified by hello;

User altered.

Now you can access the URL again

cheers

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: