To reduce the used space in SYSAUX tablespace, you can uninstall the older APEX version before you install the new version.
-
Download Oracle Application Express to c:\tmp.
-
Extract apex_20.1.zip to your hard drive.
-
Open a Command Prompt window.
-
Change your working directory to the apex directory where you unzipped the installation software, for example, c:\tmp\apex.
-
Set the following Oracle parameters (replace <ORACLE_HOME> with the path of your Oracle home directory):
set ORACLE_HOME=<ORACLE_HOME>
For example:
set ORACLE_HOME=C:\oracle\19c_Sta\db
-
Launch SQL*Plus and connect to the database with sys as sysdba.
-
In case of multitenant architecture (CDB/PDB), perform the following:
-
Sqlplus /nolog
-
connect sys/<password>@<CDB instance> as sysdba
-
Alter session set container = <PDB instance>
-
-
In case of a single instance, perform the following:
-
Sqlplus /nolog
-
connect sys/<password>@<SID> as sysdba
-
-
-
Execute:
@apexins.sql SYSAUX SYSAUX TEMP /i/
It takes a while.
-
To change the password for the admin account, do the following:
-
Launch SQL*Plus and connect to the database as SYS specifying the SYSDBA role.
Sqlplus /nolog
connect sys/<password>@<PDB instance> as sysdba
-
Run the apxchpwd.sql script.
-
When prompted, enter a password for the ADMIN account.
If you enter a password that does not match the complexity rules, get you an error. With a correct password the procedure will succeed.
-
-
Configure the user APEX_PUBLIC_USER as follows:
-
Launch SQL*Plus and connect to the database as SYS specifying the SYSDBA role.
sqlplus /nolog
connect sys/<password>@<PDB instance> as sysdba
-
Enter the following commands to unlock the user and change the password (replace <new_password> with your password):
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <new_password>;
Remember the new password. In case of using special characters enclose the password in quotes.
-
-
Install the current APEX 20.1 hotfix as follows:
-
Download the Patch Set Bundle for Oracle APEX 20.1 (30990551) from
https://www.oracle.com/tools/downloads/apex-downloads.html
-
Check the Readme.txt for installation notes
-
Extract p30990551_2010_Generic.zip to your hard drive.
-
In <Patch Set Bundle> folder, launch Sql*Plus as SYSDBA.
-
Sqlplus /nolog
-
connect sys/<password>@<CDB instance> as sysdba
-
Alter session set container = <PDB instance>
-
-
Execute:
@catpatch.sql
-