Install Oracle Apex 19.2 on Windows Server Step by Step

I'm writing this on behalf of my own experience of the installation of Oracle Apex 19.2 on the Oracle 12c database. You can follow the easy steps to complete the installation of Oracle Apex.

• Download the Oracle Apex from the Oracle website.
  https://apex.oracle.com/en/learn/getting-started/

• Copy the apex folder into the C:\Oracle to install. (C:\Oracle\Apex)
• Connect with SQLPLUS where Oracle 12c database already installed
• Make sure you are on the same path of Oracle Apex.

• C:\>CD Oracle\Apex

• C:\Oracle\Apex> Sqlplus /nolog

• SQL> Connect Sys/sys_password as sysdba;
  Connected.

Run the Scripts as following.
SQL> @apexins.sql sysaux sysaux temp /i/

SQL> @apxrtins.sql sysaux sysaux temp /i/

To change the password, run the following script.

SQL> @apxchpwd.sql

User name: admin
password: Apex111$  (Type your own password here)

Set the Port to access the Oracle Apex interface.

SQL> EXEC DBMS_XDB.SETHTTPPORT(8282);

SQL> ALTER USER APEX_PUBLIC_USER account unlock;

Set the password for the Apex Public User.

SQL> ALTER USER APEX_PUBLIC_USER identified by password;
-- password is apex

Set the listener and apex_rest_public_user password

SQL> @apex_rest_config.sql
-- password: apex

Now load all the apex images from the Apex\images directory, do not enter the apex directory.

SQL> @apex_epg_config.sql C:/Oracle
the above script auto-load the images from the c:/oracle/apex/images

Enable the Anonymous and XDB Accounts.

SQL> ALTER USER ANONYMOUS IDENTIFIED BY anonymous;
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
SQL> ALTER USER XDB IDENTIFIED BY xdb;
SQL> ALTER USER XDB ACCOUNT UNLOCK;

Open the Browser to check the installation

By default workspace name: internal
localhost:8282/apex

You can create a Workspace for your own applications.

Workspace name: Your workspace name here.
reuse_existing_schema: no
schema name: workspace_apex (Enter the Workspace name_apex as a schema)
schema pass: apex (Enter the schema access password)

Choose Next to set the Admin account to access the above workspace.

Administrator username: ADMIN
password   : set the password
first name  : enter your first name
Last name  : enter your last name
Email         : enter your email here

Create the workspace

It will display the workspace information.

    Identify Workspace (Completed)
    Identify Schema (Completed)
    Identify Administrator (Completed)
    Confirm Request (Active)

Note the information about the tablespace and schema created for your new workspace.

You can now login to the Apex application Administration using Browser.
localhost:8282/apex/apex_admin

You can access the Apex application
localhost:8282/apex/

Now the installation of Oracle Apex 19.2 has been completed. If you have any questions do share it with us.

Thanks.

Upgrade Your Certification to 12c

If you're certified in the earlier Oracle version 7.3, 8, 8i, you can upgrade your certification with the single exam provided by Oracle to become Oracle Database 12c Administrator Certified Professional

1Z0-060 Upgrade to Oracle Database 12c.

BI Dashboard Vendors

1. Oracle Hyperion
2. IBM Cognos
3. SAP Business Objects (Xcelsius)
4. Microsoft BI
5. Qliktech
6. TableauSoftware
7. MicroStrategy
8. SAS
9. Pentaho
10. JasperSoft

Oracle 10g/11g OCA Preparation Guidelines

The road map which help the people who are looking for Oracle 1og and 11g Certification exam, where to start.
What are the required steps for getting Oracle certified?
1. Select a track
2. Prepare for the test
3. Schedule the test
Step 1. Select the track
Oracle Database Administrator:

• Oracle 11g (OCA, OCP, OCM)
• Oracle 10g DBA (OCA, OCP, OCM)
• Oracle 9i DBA (OCA, OCP, OCM)

Oracle 9i or 10g Forms Developer:

• Oracle PL/SQL Developer Certified Associate
• Oracle Forms Developer Certified Professional

For the complete list, follow the Oracle university website and check where you fit in. http://www.oracle.com/education/certification/index.html?starthere.html
For Oracle 11g OCA, only two exams are required:
1. 1Z0-051 Oracle Database 11g: SQL Fundamentals I
or 1Z0-047 Oracle Database SQL Expert
2. 1Z0-052  Oracle Database 11g: Administration I

Step 2. Prepare for the test.
Recommended Ref. Oracle Books

• Oracle Database 10g OCP Certification All-In-One Exam Guide
• Sybex.Inc.OCA.Oracle.10g.Administration.I
• Oracle.Database.10g.Administration.Workshop.I (from Oracle University)

Read the Oracle Documentation Guides

• 10g Concepts
• 10g DB Admin Guide

(Download from Oracle full documentation http://tahiti.oracle.com)
Practice test

• Self-Test Software (250-300 questions)

http://www.selftestsoftware.com.
3. Schedule the test.

• Check your nearest Sylvan Prometric testing center

http://www.prometric.com

Change the Table Column Datatype with data using SQL

Follow the simple steps to change the column datatype which is also having a data inside.
Normally, it’s not possible to change the column datatype with the existing data.
Steps:
1. Add New temp Column with desired datatype.
SQL> Alter Table
Add temp datatype(size);

2. Update the data into new column.
SQL> Update
set temp =
where is not null;

3. Drop the original Column.
SQL> Alter table
Drop column ;

4. Rename the new column to original Name.
SQL> Alter table
rename column temp to ;


Note:- change the table_name, datatype, Original_columnname and size

Oracle Database Performance Tuning

For many people, Oracle database performance tuning is a hard thing and difficult to achieve. Actual user will not see any change done by the experts after the application deployment, So, I will start writing some articles on the Oracle performance tuning, required by any Application built on Oracle Database.

Most of issues of performance tuning will auto resolved, if the database design is properly done.
We will start with the database design improvements.

Close Oracle Reporting Engine Procedure

In the Application development, during running the oracle report engine every time you run the report.
Below is the code to close the reporting engine, if required by the application.



You can make this procedure using Oracle Forms Builder 6i

———————————————-
PROCEDURE close_rbe IS

  v_win_handle NUMBER;

  timer_id TIMER;

 

BEGIN

  v_win_handle := win_api_session.findAppwindow(’Reports Background Engine’, ‘rwrbe60.exe’, ‘WINDOW’, WIN_API.WINCLASS_REPORTSSERVER_V6, FALSE);

–  MESSAGE(TO_CHAR(v_win_handle), acknowledge);

  IF v_win_handle > 0 THEN

    IF win_api_session.Find3rdPartyApp (’Reports Background Engine’, ‘rwrbe60.exe’, ‘WINDOW’, TRUE, WIN_API.WINCLASS_REPORTSSERVER_V6, FALSE) THEN

      win_api_shell.sendkeys(v_win_handle, ‘%{F4}’, true);

    END IF;

  END IF;

  timer_id := Find_Timer(’Delay’);

  IF NOT Id_Null(timer_id) THEN

            Delete_Timer(timer_id);

  END IF;

  timer_id := CREATE_TIMER(’Delay’, 100, NO_REPEAT);

END;
——————————————————-

Step2: call  this procedure in the application to close oracle background reporting engine.
make sure, your application has such requirements.

DBMS_METADATA Error

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.7 Information in this document applies to any platform. 

SQL> select dbms_metadata.get_ddl(’TABLE’,’mytable‘,’myuser‘) from dual;

ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3688
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4544
ORA-06512: at "SYS.DBMS_METADATA", line 466
ORA-06512: at "SYS.DBMS_METADATA", line 629
ORA-06512: at "SYS.DBMS_METADATA", line 1246
ORA-06512: at line 1

Prior to 9.2.0.6, this situation is caused by:Bug.3361288 (80) AFTER
REGISTERING XML SCHEMA IN AL32UTF8 DATABASE, EXPORT FAILS WITH ORA-24324 

Solution # 1:

The recommendations are documented in:

Note.279065.1 Ext/Mod Full Export of Database fails with EXP-00056 ORA-06502 ORA-31605 ORA-22921

Solution#1. The solution is to reload the XML API:
 

Step 1. SQL> alter system enable restricted session;

No Body can login or start a new session while running the scripts

Step 2. run: (from $ORACLE_HOME/rdbms/admin):
 

catnomet.sql
rmxml.sql
to remove the xml subsystem

After that recreate it by running following scripts:
catxml
utlcxml.sql
prvtcxml.plb
catmet.sql 

 All the scripts can be run only on testing environment and run in production at your own risk.

ORA-19206: Invalid value for query or REF CURSOR parameter

Today, while i import the schema into testing db (oracle 9i), it gives me following error,then i realize that i didn't run the catalog scripts after the db creation.

So, if you create the database by yourself, then always run these scripts under the sys schema. see the solution below:

ORA-19206: Invalid value for query or REF CURSOR parameter

What causes this error?
The queryString argument passed to DBMS_XMLGEN.newContext was not a valid query, or REF CURSOR.

Solution:
Steps to fix this:

1. connect sys/change_on_install as sysdba
2. Run the script catalog.sql, catproc.sql, catmeta.sql

@c:\oracle\ora92\rdbms\admin\catalog.sql
@c:\oracle\ora92\rdbms\admin\catproc.sql
@c:\oracle\ora92\rdbms\admin\catmeta.sql

Oracle BI Forum in Dubai

Oracle Business Intelligence Forum

Learn More About Oracle’s Business Intelligence Applications

At this event you will:

• Learn how Oracle Business Intelligence delivers intuitive, role-based intelligence for everyone in an organization—from frontline employees to senior management—and enables better decisions, actions, and business processes
• Get an overview of how Oracle’s hot-pluggable BI architecture addresses the challenges of heterogeneous Oracle and non-Oracle IT environments
• Gain knowledge on how to enhance the value of your business intelligence solution with Oracle Data Warehousing and Oracle Data Integrator

Click on the links of your country to register now. Or call +97143909220 for assistance

Monday, May 5, 2008 8:30 a.m. – 12:45 p.m. Crowne Plaza Hotel Sheikh Zayed Al Nahyan Road Dubai Register Now!

Monday, May 12, 2008 8:30 a.m. – 12:45 p.m. Sheraton Hotel Olaya and Mecca Road Riyadh 11623 Register Now!