1.@apexins.sql sysaux sysaux temp /i/
2.@apxchpwd.sql
3.@apex_rest_config.sql
4. Unlock All Locked User :
select
username,account_status from dba_users where username like 'APEX%';
select username,account_status from dba_users where
username like 'ORDS%';
or
select username,account_status from dba_users where lock_date is not null and username like 'APEX%'; )
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_210100',
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_210100',
principal_type => xs_acl.ptype_db));
END;
/
EXEC DBMS_XDB.sethttpport(0);
#unzip ords file :
copy the images folder from the apex directory and paste it to ords folder.
Download Link :
jdk-https://www.oracle.com/java/technologies/javase-downloads.html Ords-https://www.oracle.com/database/technologies/appdev/rest-data-services-v192-downloads.html
java -jar ords.war serve
