============ Option 01 =============
–>>>>>>>>>>> How to Install Oracle Database 12c on Windows 10
https://www.youtube.com/watch?v=uS1nLECyQRw&list=PL6dR9qqdUVLRSCnOwol3XNdIlhS9Ka5nb&index=6
–>>>>>>>>>>> How to Install Oracle Apex 21.2
https://www.youtube.com/watch?v=OnNGryf_b04&t=502s
Create Directory
=======================================================================================
* c:\apex_home\apex
* c:\ords_home\ords
* c:\ords_home\ords\config
* Install Java
======================== Install Oracle Database 12c on Windows 10 =====================================
1. Download 12c [Enterprise version] https://edelivery.oracle.com/osdc/faces/SoftwareDelivery
2. Install setup.exe
========================================== Install Graphical Mode ==========================================================
-> I wish to recieve… : Check off
-> Create and configure a database : Check
-> Desktop Class : Check
-> Use Virtual Account : Check
-> Oracle Base: C:\Oracle Global Database name: LIVE pass: zafims@123
-> Create as Container DB : Check off POP UP: Yes
============================================================================================================================
============================================= Install Apex 21.2 =========================================
1. Extract apex21.2 in C:\apex_home\apex\
2. Open CMD
3. cd c:\apex_home\apex
4. c:\apex_home\apex> sqlplus / as sysdba
SQL>
Create Tablespace apex
logging
datafile ‘C:\oracle\oradata\LIVE\APEX.DBF’ size 1024m
autoextend on
next 64m maxsize 5G
extent management local;
5. SQL> @apexins.sql apex apex temp /i/
6. SYS> @apxchpwd.sql
Enter
007zafar@gmail.com
zafims@123
7. SYS> @apex_rest_config.sql
zafims@123
zafims@123
[Check DB open or locked] SYS> select username,account_status from dba_users where username like ‘APEX%’;
8. SYS>
ALTER USER APEX_LISTENER IDENTIFIED BY zafims@123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY zafims@123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY zafims@123 ACCOUNT UNLOCK;
ALTER USER APEX_210200 IDENTIFIED BY zafims@123 ACCOUNT UNLOCK;
[Check DB open or locked] SYS> select username,account_status from dba_users where username like ‘ORDS%’;
ALTER USER ORDS_METADATA ACCOUNT UNLOCK identified by zafims@123;
ALTER USER ORDSYS ACCOUNT UNLOCK identified by zafims@123;
9. SYS>
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => ‘*’,
ace => xs$ace_type(privilege_list => xs$name_list(‘connect’),
principal_name => ‘APEX_210200’,
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_210200’,
principal_type => xs_acl.ptype_db));
END;
/
SYS> commit;
10. SYS> EXEC DBMS_XDB.sethttpport(0);
11. SYS> exit;
12. copy “c:\apex_home\apex\images” –images– folder to “c:\ords_home\ords”
13. run cmd
14. cd C:\ords_home\ords
15. C:\ords_home\ords> java -jar ords.war
16. location: C:\ords_home\ords\config
Enter
Enter
Press: 1
Service Name: LIVE
ORDS_Public_User : zafims@123
Admin Username: sys
pass: zafims@123
Press: 1
APEX_Public_User : zafims@123
Press: 1
APEX_Listener_User : zafims@123
APEX_Rest_Public_User : zafims@123
Press: 1
Press: 1
–> Apex static resources location : C:\ords_home\ords\images
Press: 1
17. localhost:8080 INTERNAL/admin/zafims@123
Workspace:iFDR , Schema Name: ifdr , Schema pass: zafims@123
Admin User: admin/ zafims Admin Pass: zafims@123
C:/ORACLE/ORADATA/LIVE/APEX_XXX.DBF
to restart
1. Create apex-autorun.bat
@echo [off]
cd\ords_home\ords\
java -jar ords.war
2.
[Show Hidden files] C:\ProgramData\Microsoft\Windows\Start Menue\Programs\Startup
–> Paste “apex-autorun.bat”
Create Task Scheduler
======================================== Login Info ==============================================
OS info: iOracle/iOracle123
INTERNAL/admin/zafims@12323
zafar/zafar zafims/zafims@123
============= SQL Dev. info ===========
User: SYS Pass: zafims@123
Connection Name: iOracle
Username: ifdr
password: zafims@123
Connection Type: Basic Role: Default
Hostname: localhost or 103.120.223.124 or 192.168.203.30
port: 1521
Service Name: LIVE
192.168.203.30
=================================
Schema:IFDR
Pass: ieel@spaceBox
Schema: ifdr
Pass: zafims@123
Schema:ideal
Pass: zafims@123
Tablespace:system
Workspace:IFDR
ifdr/ifdr/ieel@spaceBox
=================================== Troubleshoot ===================================================
1. The connection pool named: |apex|| is not correctly configured, due to the following error(s): ORA-28001: the password has expired
Reason: User Account Locked
Solve: 1. Connect as SYS
sqlplus /nolog
conn sys as sysdba [user:sys pass: zafims@123]
SQL> SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE ‘%EXPIRED%’;
SQL> select * from dba_users
SQL> ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY zafims@123;
SQL> ALTER USER APEX_LISTENER IDENTIFIED BY zafims@123;
SQL> ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY zafims@123;
SQL> ALTER USER APEX_210200 IDENTIFIED BY zafims@123;
—-> To make Password lifetime <—
create profile apex_profile
limit password_life_time unlimited;
alter user apex_public_user profile apex_profile ;
alter user apex_rest_public_user profile apex_profile ;
alter user apex_listener profile apex_profile ;
alter user ords_public_user profile apex_profile ;
============ Option 02 =============
============================= Install Oracle 12c ====================================
1. Download 12c [Enterprise version] https://edelivery.oracle.com/osdc/faces/SoftwareDelivery
2. Install setup.exe
================================ Install Graphical Mode =======================================
-> I wish to recieve… : Check off
-> Install Database software only : Check
-> Single instance database inst. : Check
-> Enterprise Edition : Check
-> Use Virtual Account : Check
-> Next
-> Install
==========================================================================================================
3. Create listener and Service name with netca
-> Goto Start -> Oracle – OraDB12Home1 -> Net Configuration Assistant
-> Listener Configuration -> Next -> Add -> Next -> Listener name(LISTENER) -> Next
-> TCP -> 1521 -> No -> Next
-> Select > Local Net Service Name Configuration -> Add -> Service Name: orcl -> TCP
-> Hostname [This PC – Rightclick – properties – Full Computer name] -> Next -> Next-> Next-> Next -> Finish
4. Create Database
-> Goto Start -> Oracle – OraDB12Home1 -> Database Configuration Assistant
-> Create a database
-> Advanced Configuration
-> Database Type: Oracle Single Instance database Gentral Purpose : Check
-> Global database name: orcl SID: orcl Create as Container database : Checkoff
-> Next
-> Next
-> Check that Listener is UP
-> Next
-> From Character sets Choose “Use OS character set”
-> Configure Enterprise Manager : Check off
-> Apex123#
-> Next
-> Finish
CMD-> c:\ sqlplus / as sysdba
SQL> select instance_name,version from v$instance;
===================================== Install Apex 21.2 ===================
Create Directory
=======================================================================================
* Install Java
* c:\apex_home\apex
* c:\ords_home\ords
* c:\ords_home\ords\conf
* Extract apex21.2 in C:\apex_home\apex\
* Extract ords in c:\ords_home\ords\
* Copy “images” folder from c:\apex_home\apex\ and paste c:\ords_home\ords\
=====================================================================================
1.Install Oracle Database
2. Open CMD
3. cd c:\apex_home\apex
4. c:\apex_home\apex> sqlplus / as sysdba
5. SQL> create tablespace apex datafile ‘C:\APP\Oracle_Apex\VIRTUAL\ORADATA\ORCL\APEX_DATA.DBF’ size 1024M autoextend on next 10M;
6. SQL> cl scr
7. SQL> @apexins.sql APEX APEX TEMP /i/
8. SYS>
ALTER USER ANONYMOUS IDENTIFIED BY Apex123# ACCOUNT UNLOCK;
ALTER USER XDB IDENTIFIED BY XDB ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Apex123# ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES IDENTIFIED BY Apex123# ACCOUNT UNLOCK;
9. SYS> exit;
10. c:\apex_home\apex> sqlplus / as sysdba
11. SQL> @apex_rest_config.sql
-> Apex123#
-> Apex123#
SYS/ SQL> alter user sys identified by Apex123#;
SYS/ SQL> alter user apex_public_user identified by Apex123# account unlock;
SYS/ SQL> exit;
12. cd.. cd..
13. cd c:\ords_home\ords
14. c:\ords_home\ords> java -jar ords.war
–> Enter locaton: c:\ords_home\ords\conf
–> Enter
–> Enter
–> database service name: orcl
–> [pass for ORDS_PUBLIC_USER] Apex123#
–> Enter the administrator username: sys as sysdba
–> EnterDB Pass for sys as sysdba: sys
–> Enter
–> Enter the database password for APEX_Public_User: Apex123#
–> Enter
–> Enter the database password for APEX_LISTENER: Apex123#
–> Enter
–> Enter the database password for APEX_REST_Public_User: Apex123#
–> Enter
–> Enter
–> Enter the APEX static resources location: c:\ords_home\ords\images
–> Enter
—> Goto Browser: localhost:8080/ords internal/admin/Apex123#
15. Open CMD
16. cd c:\apex_home\apex
17. c:\apex_home\apex> sqlplus / as sysdba
18. SQL> @apxchpwd.sql
–> Enter
–> Enter
–> Apex123#
19. —> Goto Browser: localhost:8080/ords internal/admin/Apex123#
Ref:
https://www.youtube.com/watch?v=Ewpbr7rlLrw&t=1488s
https://www.youtube.com/watch?v=8R-ILJswr5g