Apex Migration 19.2 to 20.0.1 (Version Oracle 11.2.0 DB / Tomcat 9.0)

-

Apex Migration 19.2 to 20.0.1  (Version Oracle 11.2.0 DB / Tomcat 9.0)

 1) Download the 20.1
  
 2) Unzip the Downloaded folder

 3) Go to Command Prompt and go to location of unzip folder and perform sqlplus

 4) Connect  Sys as sysdba

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

Entire Phase will take 15 to 20 minute time. Make sure Phase 3 complete successfully.

5) Run the apex_rest_config command
SQL> @apex_rest_config.sql

)       6) Stop the tomcat Server

 7) Copy Images folder data from apex_20.1_en/apex/images  and Past to apache-tomcat-version/webapps/i (before take the backup of  “I” folder)


 8)  Copy Images folder  from apex_20.1_en /apex/images   and past to ORDS/ Images folder
(before take the backup of Images folder of ORDS)

  9) Connect Sqlplus as sys user Perform Attached Script


DECLARE

  ACL_PATH  VARCHAR2(4000);

BEGIN

  -- Look for the ACL currently assigned to '*' and give APEX_200100

  -- the "connect" privilege if APEX_200100 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_200100,
     'connect') IS NULL THEN
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
     'APEX_200100, 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_200100, TRUE, 'connect');

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');

END;

/
COMMIT


10)   Validate ORDS.War file  (Go to Folder where ORDS has installed and perform the -Jar Validate Command in Command prompt)


 C:\> java -jar  C:\ORDS\ords.war validate
                


Useful URL
https://dgielis.blogspot.com/2020/04/oracle-apex-201-installed-with-only-2.html
https://dgielis.blogspot.com/2018/05/safely-upgrading-to-oracle-apex-181.html

Comments

Post a Comment

Popular posts from this blog

Telegram Integration with Oracle

-
 How to Integrate Telegram with Oracle Apex 1) create Telegram Account in your Mobile like whatsapp 2) Ones you register in telegram apps serach for BotFather 3) To Create New Bot u need to enter below command  /newbot  Alright, a new bot. How are we going to call it? Please choose a name for your bot. Macsbot Good. Now let's choose a username for your bot. It must end in `bot`. Like this, for example: TetrisBot or tetris_bot. MacsOmanBot Done! Congratulations on your new bot. You will find it at t.me/MacsOmanBot. You can now add a description, about section and profile picture for your bot, see /help for a list of commands. By the way, when you've finished creating your cool bot, ping our Bot Support if you want a better username for it. Just make sure the bot is fully operational before you do this. Use this token to access the HTTP API:<Here you will prompt with your api> 4) /mybots (this command will return the list of bots which you have created) ...
Read more

The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

-
  1. Execute the following command from SQL Plus as the SYS user:  Conn sys/Pass@xe as sysdba  (connect as container if 12c then  ALTER SESSION SET container = CDB$ROOT;) Alter user ords_public_user identified by xxxx; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; Connect as PDB Conn sys/Pass@xepdb1 as sysdba (if 12c  ALTER SESSION SET container = PDB1;) Alter user APEX_PUBLIC_USER identified by xxxx; Alter user APEX_REST_PUBLIC_USER identified by xxxx; Alter user APEX_LISTENER identified by xxxx; 2. Unlock the users: ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_LISTENER ACCOUNT UNLOCK; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; 3. Now create a profile for the APEX related users: Create profile apex_public_profile limit password_life_time unlimited; 4. Assign the profile to the APEX users: alter user apex_public_user profile apex_public_profile; alter user apex_rest_public_user profile apex_public_pr...
Read more

Row Initialization event on the IG region (Set Default value for column of Row)- Oracle Apex

-
1)  Create a dynamic action for the Row Initialization event on the IG region. 2) Event :- Row Initialization    Action :- Execute Java Script code     Set Fire on Initialization to No' var val,     model = this.data.model,     rec = this.data.record,     erec =  $v("P404_ITEM_CODE"),     erec1=$v("P404_COMPCD"),     meta = model.getRecordMetadata(this.data.recordId); if ( meta.inserted ) {     val = model.getValue(rec, "ITEM_CODE")     if ( val.v === val.d )       { model.setValue(rec,"ITEM_CODE", {d:apex.item("ITEM_CODE").displayValueFor(erec), v: erec});     }     val = model.getValue(rec, "COMPCD");     if ( val.v === val.d ) {         model.setValue(rec,"COMPCD", {d:apex.item("COMPCD").displayValueFor(erec1), v:erec1});     }     }
Read more