Rishikesh
Installation/Up gradation of APEX 4.2.1
Download the software from OTN
apex_4.2.1_en.zip (Size 82.2 MB)
ords.3.0.0.121.10.23 (Size 53.2 MB)
Note: There is no specific setup available for either windows or Linux.
Just go for the simple download for these software.
######################################################################
Copy the software to the below location on OracleEBS Server
[oraebsinstance@sym01 apex]$ pwd
/tmp/apex
[oraebsinstance@sym01
apex]$ ls -ltr
total 99732
drwxr-xr-x 3 root root 4096 May 1 10:23 docs
drwxr-xr-x 2 root root 4096 May 1 10:28 params
-rw-r--r-- 1 root root 23806 May 1 10:28 readme.html
drwxr-xr-x 6 root root 4096 May 1 10:28 examples
-rw-r--r-- 1 root dba
55850624 Jun 12 13:36 ords.3.0.0.121.10.23.zip
-rw-r--r-- 1 root root
46105873 Jun 15 07:18 ords.war
drwxrwxr-x 7 oraebsinstance oinstall 4096 Jun 15 10:46 apex
drwxr-xr-x 2 root root 4096 Jun 15 14:39 logs
-rw-r--r-- 1 root root
0 Jun 15 17:07 derby.log
-rw------- 1 root root 6993 Jun 15 17:08 nohup.out
Unzip the software using the below command
Unzip apex_4.2.1_en.zip
Unzip ords.3.0.0.121.10.23.zip
Move
the Existing APEX folder from $ORACLE_HOME/apex directory.
Copy
the apex folder from /tmp/apex to $ORACLE_HOME/apex
Need to set SHARED_SERVERS parameter as below:
The embedded PL/SQL gateway uses the shared server
architecture of the Oracle database. For a small group of concurrent users,
Oracle recommends a value of 5 for SHARED_SERVERS.
ALTER
SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;
Note: When EBS is installed, the APEX is installed by default with the
lower version.
Here we are upgraded the APEX Version from 3.0 to
4.2.1.
Run the below command from $ORACLE_HOME/apex for upgrading the APEX
from 3.0 to 4.2.1
Here the location on the server is as below
/u01/app/oraebsinstance/db/tech_st/11.1.0/apex
SQL> @apexins.sql SYSAUX SYSAUX TEMP5 /i/
Below is the spool for the command
Completing registration process. 15:15:37
Validating installation. 15:15:37
...Database user "SYS", database schema
"APEX_040200", user# "637" 15:15:37
...Compiled 0 out of 2994 objects considered, 0
failed compilation 15:15:37
...263 packages
...255 package bodies
...452 tables
...11 functions
...16 procedures
...3 sequences
...457 triggers
...1320 indexes
...207 views
...0 libraries
...6 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence check 15:15:37
...Completed key object existence check 15:15:37
...Setting DBMS Registry 15:15:37
...Setting DBMS Registry Complete 15:15:37
...Exiting validate 15:15:37
PL/SQL procedure successfully completed.
timing for: Validate Installation
Elapsed: 00:00:00.39
old 1:
alter session set current_schema = ^APPUN
new 1:
alter session set current_schema = APEX_040200
Session altered.
Timing
for: Complete Installation
Elapsed:
00:15:54.54
PL/SQL procedure successfully completed.
1 row selected.
Disconnected from Oracle Database 11g Enterprise
Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real
Application Testing options
[oraebsinstance@sym01 apex]$
Command
to check the status of the product.
SQL> select COMP_NAME, VERSION, STATUS from dba_registry;
COMP_NAME VERSION STATUS
------------------------------ --------------------------------------------------------
Oracle Application Express 4.2.1.00.08 VALID
After
upgrade, the following users are expired and locked, we have to open it and
unlock.
SQL> SELECT username,account_status FROM
dba_users WHERE username LIKE 'APEX%';
USERNAME ACCOUNT_STATUS
------------------------------
--------------------------------
APEX_PUBLIC_USER EXPIRED & LOCKED
APEX_040200 EXPIRED & LOCKED
######################################################################
SQL> @apxldimg.sql
PL/SQL procedure successfully completed.
Enter value for 1: /u01/app/oraebsinstance/
old 1: create directory
APEX_IMAGES as '&1/apex/images'
new 1:create directory APEX_IMAGES as '/u01/app/oraebsinstance/db/tech_st/11.1.0/apex/images
Directory created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Commit complete.
timing for: Load Images
Elapsed: 00:00:39.18
Directory dropped.
SQL>
ALTER USER APEX_PUBLIC_USER account UNLOCK;
ALTER
USER APEX_040200 account UNLOCK;
ALTER
USER APEX_040200 IDENTIFIED BY apex1234;
ALTER
USER APEX_PUBLIC_USER IDENTIFIED BY apex1234;
User
altered.
######################################################################
Command to check the HTTP port
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
GETHTTPPORT
-----------
0
######################################################################
Command
to Set the port.
SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);
PL/SQL procedure successfully completed.
######################################################################
Unlock
and open the XDB User.
SQL> select USERNAME,ACCOUNT_STATUS from
dba_users where USERNAME like 'XDB%';
USERNAME ACCOUNT_STATUS
------------------------------
--------------------------------
XDB EXPIRED &
LOCKED
SQL> alter user XDB account unlock;
User altered.
SQL>
alter user XDB identified by XDB;
User altered.
######################################################################
Unlock
and open the FLOWS_FILES user as below
SQL> select
USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE from dba_users where username
like 'FLOWS%';
USERNAME ACCOUNT_STATUS
------------------------------
--------------------------------
LOCK_DATE
EXPIRY_DATE
------------------ ------------------
FLOWS_030000 LOCKED
05-SEP-07
FLOWS_020000 LOCKED
01-DEC-05
FLOWS_010500 LOCKED
29-SEP-04
USERNAME ACCOUNT_STATUS
------------------------------
--------------------------------
LOCK_DATE
EXPIRY_DATE
------------------ ------------------
FLOWS_FILES EXPIRED & LOCKED
12-JUN-15
12-JUN-15
SQL> set lines 150
SQL> /
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
------------------------------
-------------------------------- ------------------ ------------------
FLOWS_030000 LOCKED 05-SEP-07
FLOWS_020000 LOCKED 01-DEC-05
FLOWS_010500 LOCKED 29-SEP-04
FLOWS_FILES
EXPIRED &
LOCKED 12-JUN-15 12-JUN-15
SQL> alter user FLOWS_FILES account unlock;
User altered.
SQL> alter user FLOWS_FILES identified by
FLOWS_FILES;
User altered.
######################################################################
Unlock
and Open the user as below ANONYMOUS
SQL> select USERNAME, ACCOUNT_STATUS, LOCK_DATE,
EXPIRY_DATE from dba_users where username like 'ANONY%';
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
------------------------------
-------------------------------- ------------------ ------------------
ANONYMOUS LOCKED 18-DEC-05
SQL> alter user ANONYMOUS account unlock;
User altered
Check
the users in one query
SQL> select USERNAME, ACCOUNT_STATUS from
dba_users where username in
('ANONYMOUS','FLOWS_FILES','XDB','APEX_040200','APEX_PUBLIC_USER');
USERNAME ACCOUNT_STATUS
------------------------------
--------------------------------
XDB OPEN
ANONYMOUS OPEN
APEX_040200 OPEN
APEX_PUBLIC_USER OPEN
FLOWS_FILES OPEN
######################################################################
Change
the parameter job_queue_processes from 2 to 20 as below.
Before:
SQL> SHOW PARAMETER job_queue_processes
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
Job_queue_processes integer 2
After:
SQL> ALTER system SET job_queue_processes=20
scope=both;
System altered.
SQL> SHOW PARAMETER job_queue_processes
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
Job_queue_processes integer 20
######################################################################
Check
which version is currently installed:
SQL> COL comp_name FOR A30
SELECT comp_name, version, status FROM dba_registry
WHERE comp_id='APEX';
SQL>
COMP_NAME VERSION STATUS
------------------------------
------------------------------ --------------------------------------------
Oracle Application Express 4.2.1.00.08 VALID
######################################################################
Run the below script to change the Admin Password
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.
SQL>
Password : Welcome@123$
######################################################################
SQL> !pwd
/u01/app/oraebsinstance/apex
SQL> @apex_epg_config.sql
Enter value for 1: /u01/app/oraebsinstance/
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
old 1: create directory
APEX_IMAGES as '&1/apex/images'
new 1: create directory
APEX_IMAGES as '/u01/app/oraebsinstance/db/tech_st/11.1.0/apex/images’
Directory created.
old 47: if '&IMGUPG' != '' then
new 47: if '' != '' then
old 48: l_mv_folder := '&IMGUPG';
new 48: l_mv_folder := '';
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:00:30.36
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.
SQL>
SQL> @apex_rest_config.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
...create APEX_LISTENER user
PL/SQL procedure successfully completed.
Enter
a password for the APEX_LISTENER user []
User created.
...create APEX_REST_PUBLIC_USER user
Enter
a password for the APEX_REST_PUBLIC_USER user []
User created.
Grant succeeded.
Grant succeeded.
.
Session altered.
Synonym created.
Session altered.
PL/SQL procedure successfully completed.
Commit
complete.
Set
the below workaround
exec dbms_xdb.setlistenerlocalaccess(l_access =>
false);
Enable Network Services in 11g
By default, the ability to interact with network services is disabled
in Oracle Database 11g release 1 or 2. Therefore, if you are running Oracle
Application Express with Oracle Database 11g release 1 or 2, you must use the
new DBMS_NETWORK_ACL_ADMIN package to grant connect privileges to any host for
the APEX_040200 database user.
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for
the ACL currently assigned to '*' and give APEX_040200
-- the
"connect" privilege if APEX_040200
-- does not
have the privilege yet.
SELECT ACL
INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST
= '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF
DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_040200', TRUE, 'connect');
END IF;
EXCEPTION
-- When no
ACL has been assigned to '*'.
WHEN
NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that
lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;
Check
the Listner Status as below
SQL> !lsnrctl status
Apex
URL and Verification check:
Related Posts :
Oracle REST Data Services (ORDS) Installation on Linux Server and Configuration with Oracle EBS
Oracle EBS - SFDC Integration using Oracle REST Data Services (ORDS) and Oracle Apex
Oracle REST Data Services (ORDS) Installation on Linux Server and Configuration with Oracle EBS
Oracle EBS - SFDC Integration using Oracle REST Data Services (ORDS) and Oracle Apex
Posted in: ORDS
1 comments:
Thanks man, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your ideas...
oracle course in chennai
Post a Comment