Friday, October 30, 2020

How to Install Oracle Apex 20.2 Old

 ------------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);

--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

https://youtu.be/P77Yt8GvLi4

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...