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

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

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: