Tuesday, May 17, 2016

Install APEX 4.2 in OLS 6


Helo guys, Now we are going to install APEX 4.02  in OLS 6

There are two ways to install it.

1.- When you have install the database with this option.
2.- When you don't.

Here we are going to use the first option.

The database:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options

1.- Locate the database home, in my case:

/u01/app/oracle/product/12c/db_1

2.- Search if you have de apex folder

[oracle@alexdb db_1]$ ls
addnode      dbs            javavm   odbc         precomp       sqlpatch
apex         dc_ocm         jdbc     olap         QOpatch       sqlplus
assistants   deinstall      jdk      OPatch       R             srvm
bin          demo           jlib     opmn         racg          suptools
ccr          diagnostics    ldap     oracore      rdbms         sysman
cdata        dmu            lib      oraInst.loc  relnotes      ucp
cfgtoollogs  dv             log      ord          rest          usm
clone        has            md       oui          root.sh       utl
crs          hs             mgw      owm          scheduler     wwg
css          install        network  perl         slax          xdk
ctx          instantclient  nls      plsql        sqldeveloper

If you don't have it, you must download it from:

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

3.- Run script 
@apex_epg_config.sql /u01/app/oracle/product/12c/db_1

4.- Run script
@apxconf.sql

Voilá!


Notes:
Please be sure you have this users unlocked and not expired: Example: If EXPIRED - Change password for following users : ANONYMOUS,XDB,APEX_PUBLIC_USER
,FLOWS_FILES,APEX_040200.
IF LOCKED - Unlock: ALTER USER ANONYMOUS ACCOUNT UNLOCK; ALTER USER XDB ACCOUNT UNLOCK; ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER FLOWS_FILES ACCOUNT UNLOCK; ALTER USER APEX_040200 ACCOUNT UNLOCK; 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;
That's because APEX is going to prompt you about XDB Credentials if something is wrong

=)


No comments:

Post a Comment