Oracle Apex Installations in windows

Installation link

http://o7planning.org/en/10341/installing-and-configuring-oracle-apex


http://www.oracle.com/technetwork/developer-tools/apex/downloads/download-085147.html

sqlplus "/ as sysdba"

https://community.oracle.com/thread/347053

@apexins sysaux sysaux temp /i/

https://www.youtube.com/watch?v=JGnkPVq7V98

@apxldimg D:\Softwares\Apex\apex_5.1\apex

@apxconf

username:  anand
password:  Amma$123
email:  sattianandreddy@gmail.com
Port:  8080

alter user apex_public_user account unlock;
alter user anonymous account unlock;

Remove apex
@apxremov

https://www.youtube.com/watch?v=oHwxbZ_jB5A

https://www.youtube.com/watch?v=klYZ8QWXbbQ



Ords(Oracle rest full data services)for apex installations

http://o7planning.org/en/10493/install-oracle-rest-data-services-ords-for-oracle-apex

Download to ords

http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html

Create conf empty folder in ords

Run unlock to those appers to connect sql.

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

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Amma$123 ACCOUNT UNLOCK;

ALTER USER APEX_050100 identified by Amma$123  ACCOUNT UNLOCK;

Those type of  "locked and expired " instance to open mode run on queries.

--  Disable Oracle APEX on Oracle XML DB HTTP Server.

EXEC DBMS_XDB.SETHTTPPORT(0);

-- Note: You can enable it with command:

EXEC DBMS_XDB.SETHTTPPORT(8080)

java -jar ords.war

Enter the location to store configuration data -- Newly created conf folder path
Enter the static resource location -- Apex images folder and enter port settings

Apex listener installations

http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/apex-listener-download-v205-2135981.html

java -jar apex.war

Enter the static resource location -- Apex images folder and enter port settings


Open apex in command prompt and go to sql.

@apex_rest_config.sql

after that validate the querry