Hi Sir,
I am using Apex 19.1 and i want to upgrade it to 20.1 please guide me the steps for that
Thanx in advance
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Follow these steps to upgrade from Oracle Apex 19.1 to Oracle Apex 20.1:
Download the Oracle Apex 20.1 from this link.
After downloading, extract the file to a folder. For example, D:\apex20
Start the SQL Plus:
Connect with the SYS account:
Run the apexins.sql script:
Run the apex_epg_config.sql script:
Run the apxchpwd.sql script:
Now you can start the Oracle Apex in browser:
Upgradation of Oracle Apex 2o.1 complete.
Swarup
Thanjs sir,I will upgrade the application, and let u know if I face any issue ,
If application is there in 19.1 it will effect anything or it will work fine as usual after upgrade
Vinish Kapoor
It should work fine but take the backup of all your applications before the upgrade.
Swarup
Hi Sir,
Gud Morng while installation i am getting this error
Vinish Kapoor
It is clearly showing that you are not connected to Oracle.
After running the SQLPLUS (sqlplus/nolog), you have to connect to Oracle Database using the SYS account as SYSDBA. Please see the steps above, you missed the below step:
Hussain
Hi,
One point i need to understand regarding the Database version which is 11.2.0, is this version supportable for 20.1 apex?
Thanks.
Swarup
Oracle Application Express release 20.1 requires an Oracle Database release 11.2.0.4 or later
Hussain
Thanks.
Swarup
Sorry Sir,My mistake
Swarup
Step 2:
Vinish Kapoor
In which directory, you extracted the installation file?
Give the path of that directory, for example, if you extracted to the D:\apex20, then you should specify the path as D:\apex20\apex.
Swarup
Thanx Sir it successfully upgraded
Hussain
Hi,
I have installed fresh installation of apex 20.1 with DB12c. However, everything got completed but some issue regarding ACL configuration, can you please share the script which need to be executed for the this database.
Vinish Kapoor
For Oracle Database 12c or later, use the following script:
Before running the script, connect using the Sys account with Sysdba privilege.
Hussain
Hi vinish
Thanks for your support.
I have executed you provided command but still getting an error while running the BI report.
apex_error_code: apex.unhadled_error
ora_sqlcode: -22275 invalid lob locator specified
Thanks.
Vinish Kapoor
@Hussan,
This error is not related to ACL.
Hussain
Dear vinish,
Thanks for update.
One thing regarding the error which seem more difficult in term of meaning less . I mean error doesn't give proper meaning full English which can be easily understandable.
Now in my case whatever error i am getting how to find the exact caused of this error.
Thanks.
Sinu
Hello, I want to upgrade Oracle apex to latest 20.2 and my database version is 11.2.0.2.0 ... so can I proceed ?
Vinish Kapoor
Yes, you can upgrade.