@apexins apex apex temp /i/

@apxchpwd.sql


@apex_rest_config.sql >>all Passworda are >>admin_123

--select username,account_status from dba_users where username like 'APEX%'

ALTER USER APEX_LISTENER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_200200 ACCOUNT UNLOCK identified by admin_123;


--select username,account_status from dba_users where username like 'ORDS%'

ALTER USER ORDS_METADATA ACCOUNT UNLOCK identified by admin_123;

ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER ORDSYS ACCOUNT UNLOCK identified by admin_123;

------------------------------------------------------------------
For Oracle Database version 12c or later run the below script:


BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_200200',
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_200200',
principal_type => xs_acl.ptype_db));
END;
/


EXEC DBMS_XDB.sethttpport(0);

--download jdk
https://www.oracle.com/java/technologies/javase-downloads.html

--Download Ords file as you required or support your apex versions....

https://www.oracle.com/database/technologies/appdev/rest-data-services-v192-downloads.html

#unzip ords file

copy images folder from apex directory and past to ords folder.


go to cmd

and enter ords directory

example

CD D:\Oracle\ords

java -jar ords.war------------Apex 20.2 Installation Guide line----------

Create Tablespace apex
logging
datafile 'D:\Oracle\oradata\LIVE\APEX.DBF' size 1024m
autoextend on
next 64m maxsize 5G
extent management local;

@apexins apex apex temp /i/

@apxchpwd.sql


@apex_rest_config.sql >>all Passworda are >>admin_123

--select username,account_status from dba_users where username like 'APEX%'

ALTER USER APEX_LISTENER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_200200 ACCOUNT UNLOCK identified by admin_123;


--select username,account_status from dba_users where username like 'ORDS%'

ALTER USER ORDS_METADATA ACCOUNT UNLOCK identified by admin_123;

ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER ORDSYS ACCOUNT UNLOCK identified by admin_123;

------------------------------------------------------------------
For Oracle Database version 12c or later run the below script:


BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_200200',
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_200200',
principal_type => xs_acl.ptype_db));
END;
/

EXEC DBMS_XDB.SETHTTPPORT(0);
SYSTEM_DRIVE:\ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

@apexins SYSAUX SYSAUX TEMP /i/
@apxchpwd

@apxldimg.sql C:\algoritm\apex
EXEC DBMS_XDB.SETHTTPPORT(8080);
ALTER USER anonymous ACCOUNT UNLOCK;
ALTER USER anonymous IDENTIFIED BY ANONYMOUS;
exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);
@apex_epg_config.sql C:\algoritm\apex