CONN HRMS/H@ORCLPDB
https://drive.google.com/drive/folders/1-MwPKp-KvKH0ODcF9zz3m7qr1d8hDTb9
SERVICES.MSC
E:\app\db_home\bin\sqlplus.exe /NOLOG
How to Install Oracle Apex 23.1 in Oracle 19C DB.
Windows + R
> CMD
E:
CD apex_23.1
CD apex
E:\apex_23.1\apex
E:\app\db_home\bin\sqlplus.exe /nolog
conn SYS/SYS@ORCL AS SYSDBA
---- ALTER SYSTEM SET MEMORY_TARGET='5000M' SCOPE=spfile;
SELECT name,open_mode FROM v$pdbs;
conn SYS/SYS@ORCLPDB AS SYSDBA
STARTUP
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE;
CD
conn SYS/SYS@ORCL AS SYSDBA
shutdown immediate;
CREATE PFILE FROM SPFILE;
startup;
SHOW pdbs;
ALTER SESSION SET CONTAINER = ORCLPDB;
---- creating tablespace :
CONN SYS/SYS@ORCLPDB AS SYSDBA
To Uninstall Apex run this script :
------------------------------------
---- @apxremov.sql
DROP TABLESPACE apex;
CREATE TABLESPACE apex DATAFILE 'E:\App\Administrator\oradata\ORCL19\orcl19pdb\apex.dbf' SIZE 1000M AUTOEXTEND ON NEXT 1M;
CONN SYS/SYS@ORCLPDB AS SYSDBA
@apexins sysaux sysaux temp /i/
@apxchpwd.sql
User : ADMIN
Aassword : Apex*123
CONN SYS/SYS@ORCLPDB AS SYSDBA
@apex_rest_config.sql
--select username,account_status from dba_users where username like 'APEX%'
ALTER USER APEX_LISTENER ACCOUNT UNLOCK identified by Apex123;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK identified by Apex123;
ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK identified by Apex123;
ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK identified by Apex123;
ALTER USER APEX_230100 ACCOUNT UNLOCK identified by Apex123;
CONN SYS/SYS@ORCL AS SYSDBA
ALTER USER ORDSYS ACCOUNT UNLOCK identified by Apex123;
------------------------------------------------------------------
For Oracle Database version 12c or later run the below script:
CONN SYS/SYS@ORCLPDB AS SYSDBA
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_230100',
principal_type => xs_acl.ptype_db));
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => 'localhost',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_230100',
principal_type => xs_acl.ptype_db));
END;
/
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
conn SYS/SYS@ORCLPDB AS SYSDBA
ALTER USER anonymous IDENTIFIED BY Apex123 ACCOUNT UNLOCK CONTAINER=ALL;
CONN SYS/SYS@ORCLPDB AS SYSDBA
SELECT DBMS_XDB.gethttpport FROM DUAL;
EXEC DBMS_XDB.sethttpport(0);
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Apex123 ACCOUNT UNLOCK;
Install Java .. (jdk-15.0.1_windows-x64_bin)
Install ORDS Version .. (ords-22.1.0.105.1723)
CD ords
--- Rename ords.war to apps.war
"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war install
---Install Tomcat9
copy Images of e:\apex_23.1\apex\images to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\
rename folder images to i
in C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\
Environment Variable :
JAVA_TOOL_OPTIONS
-Dconfig.url=E:\ORDS
---------------------------------------------------------------- the end
Go http://127.0.0.1:9091/apex/
Workspace : INTERNAL
Username : ADMIN
Password : Apex*123
sql :
Username : SYSTEM
Password : SYS
Unistal Ords
"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war uninstall
USER NAME:SYS
PWS:SYS
Enter the administrator username: sys as sysdba
Enter the database password for sys as sysdba:SYS
