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

Archive for the ‘Oracle Application Express 3.2’ Category

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

Posted in Oracle Application Express 3.2 | Leave a Comment »

Change Admin password in Apex

Posted by Hendry chinnapparaj on June 24, 2010

apex11g:/u01/oracle/product/11.2/apex> pwd

/u01/oracle/product/11.2/apex

apex11g:/u01/oracle/product/11.2/apex> ls -lrt apxchpwd.sql

-rw-r–r–    1 ofsad2   dba            1549 Jan  8 2009  apxchpwd.sql

apex11g:/u01/oracle/product/11.2/apex> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 24 17:20:56 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn sys as sysdba

Enter password:

Connected.

SQL>

SQL>

SQL> show user

USER is “SYS”

SQL> @apxchpwd

Enter a value below for the password for the Application Express ADMIN user.

Enter a password for the ADMIN user              []

Session altered.

…changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

Then login to

http://devu0777.hiroshima.com:8080/apex/

and change the password for “admin” user as requested by the application.

Posted in Oracle Application Express 3.2 | Leave a Comment »

Create Oracle Application Express Workspace

Posted by Hendry chinnapparaj on June 2, 2010

Create Oracle Application Express Workspace

http://lap6467.rtdomau.local:8080/apex/apex_admin

admin

apex123?

Manage workspace à create workspace à

Workspace Name à apollo

Description à This is a test workspace à

Schema name à apollo

Password à apollo à

Administrator username à admin

Administrator password à apex123?

Email à Hendry@oracle.com

Create à done

Workspace successfully provisioned.

Workspace apollo provisioned with administrator ADMIN.

Database user APOLLO created with default tablespace FLOW_1048601238028425 using datafile H:\APP\ORACLE\ORADATA\ORACLE11G\FLOW_1048601238028425.DBF

Logout

You are now logged out.

Login

Wokspace à apollo

username à apollo

password à apollo

Posted in Oracle Application Express 3.2 | Leave a Comment »

Configure the Embedded PL/SQL Gateway in oracle11Gr2

Posted by Hendry chinnapparaj on June 2, 2010

Configure the Embedded PL/SQL Gateway in oracle11gR2

C:\app\oracle\product\11.2.0\dbhome_1\apex>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 31 16:06:26 2010

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect sys as sysdba

Enter password:

Connected.

SQL> show user

USER is “SYS”

Running the apxconf.sql Configuration Script

SQL> @apxconf

PORT

———-

8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN

user.

Default values are in brackets [ ].

Press Enter to accept the default value.

Enter a password for the ADMIN user              [] apex123

Enter a port for the XDB HTTP listener [      8080]

…changing HTTP Port

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Session altered.

…changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

Verifying the Oracle XML DB HTTP Server Port

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT

———–

8080

If the port number returns 0, the Oracle XML DB HTTP Server is disabled.

SQL> show parameter compatible

NAME                                 TYPE        VALUE

———————————— ———– ——————————

compatible                           string      11.2.0.0.0

Posted in Oracle Application Express 3.2 | Leave a Comment »

Getting Error ‘Invalid Login Credentials’ After Creating A New Workspace

Posted by Hendry chinnapparaj on June 2, 2010

Problem

When trying to login as the new user, getting the Invalid login credentials in the browser

Cause

User attributes for the workspace are not modified correctly under the option “Manage Application Developers” under heading “Manage Workspaces”.

Fix

Follow the steps mentioned below after creating the workspace with a new user.

1. Login as “Admin” user.

http://lap45365787.stdomau.local:8080/apex/apex_admin
2. On the “Home” page, you can see the option “Manage Developers and users” under heading
“Manage Workspaces”.
3. Click on the option “Manage Developers and users”.
4. Click on the “Edit” link for the user “Apollo”.
5. Edit “User Attributes” -> Set User Name to Apollo, add the “Web Password” as Apollo (Passwords
are case sensitive) and set the Developer privileges.

Then try logging into workspace “apollo” with “apollo/apollo” and it will login successfully.

http://lap45365787.stdomau.local:8080/apex/

workspace – Apollo

username – Apollo

password – Apollo

Posted in Oracle Application Express 3.2 | Leave a Comment »