-
Open a Command Prompt window as an administrator.
-
Set the following Oracle parameters (replace <ORACLE_HOME> with the path of your Oracle home directory, and <SID> with the name (sid) of your database):
set ORACLE_HOME=<ORACLE_HOME>
set ORACLE_SID=<SID>
-
Type sqlplus /nolog and press ENTER to launch a SQL Plus session.
-
Connect to the database as SYS:
Connect sys/<sys_password>@<connect_string> as sysdba
-
Select username from sys.all_users au where au.Username like 'APEX%';
‘No rows selected’ appears as displayed above if Oracle Application Express (Apex) is not installed yet.
In some cases, you will see the following two users:
-
APEX_030200
-
APEX_PUBLIC_USER
They have been created with a previous version, installed with a standard database installation from Oracle.
If Apex is installed, make sure that the version is 19.1.0.00.12.
-