================================================================================================================================================
Installing Oracle Apex 20.1 as like the previous version.
1> First download the the Oracle apex 20.1 apex software from the below link
https://www.oracle.com/tools/downloads/apex-v191-downloads.html
2> After downloading extract the zip file
3> Open the command prompt on windows to change the directory
4> Now take the location just like
D:\apex
5> On the command prompt write the command :cd the the location
D:\apex
6> Now run the oracle apex 20.1 all scripts from this software .So login to the sys user.
# sqlplus sys/sys as sysdba
After login to the sys user run the script
# @apexins SYSAUX SYSAUX TEMP /i/
8> Now run the password change script for the admin user.
Login the sys user
sqlplus sys/sys as sysdba
@apxchpwd.sql
9> Configure Apex RESTful Services as follows:
Connect to Oracle Using SQL*PLUS if disconnected
# sqlplus sys/syspsw@orcl as sysdba
#@apex_rest_config.sql
9> To copy the Oracle Apex 20.1 images to the apex/images folder .Run the script.
@apex_epg_config.sql D:\
10> Unlock the APEX_PUBLIC_USER account and specify the password.Don’t forget to connect to Oracle using SQL *PLUS not cmd if disconnected.
# ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
# ALTER USER APEX_PUBLIC_USER IDENTIFIED BY rony;
# alter user anonymous identified by oracle account unlock;
12> Set the HTTP Port if using HTTP server as follows
Connect to oracle using SQL PLUS if disconnected
#sqlplus sys/syspsw@orcl as sysdba
#EXEC DBMS_XDB.SETHTTPPORT(8181);
Enabling Network Services for Oracle Database 12C or later version:
/* First connect as the SYS user with SYSDBA role from sqlplus not cmd */
sqlplus sys/syspsw@orcl as sysdba
/* Then execute 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_200100',
principal_type => xs_acl.ptype_db));
End;
/
Now your Installation and configuration are complete for Oracle Apex 20.1.You can open the Oracle Apex in a browser using the following URL:
http://localhost:8181/apex/apex_admin
No comments:
Post a Comment