CREATE TABLESPACE APEXTS DATAFILE '/u01/app/oracle/oradata/ntest/apexts/apexts01.dbf' SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE 1024M;
@apexins.sql sysaux sysaux temp /i212/
alter session set "_oracle_script"=true;
drop user APEX_210200 cascade;
SQL> select dbms_xdb.gethttpport from dual;
GETHTTPPORT
-----------
0
SQL> EXEC dbms_xdb.sethttpport(8089);
PL/SQL procedure successfully completed.
@apex_rest_config.sql
ABCD1234
[oracle@BAMISDB ORDS]$ which java
/usr/bin/java
/u01/ORDS/conf_ords
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//10.xx.1.xxx:1521/misapex
[oracle@BAMISDB ORDS]$ which java
/usr/bin/java
[oracle@BAMISDB ORDS]$
[oracle@BAMISDB ORDS]$ /usr/bin/java -jar mis.war install
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data: /u01/ORDS/conf_ords
Enter the name of the database server [localhost]:10.88.1.112
Enter the database listen port [1521]:1521
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:misapex
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//10.xx.1.xx:1521/misapex
Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:1
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:1
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Enter a number to select a feature to enable:
[1] SQL Developer Web (Enables all features)
[2] REST Enabled SQL
[3] Database API
[4] REST Enabled SQL and Database API
[5] None
Choose [1]:
2021-11-22T09:03:54.347Z INFO reloaded pools: []
Installing Oracle REST Data Services version 21.3.1.r3012050
... Log file written to /home/oracle/ords_install_core_2021-11-22_150354_00509.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /home/oracle/ords_install_datamodel_2021-11-22_150414_00405.log
... Log file written to /home/oracle/ords_install_apex_2021-11-22_150417_00351.log
Completed installation for Oracle REST Data Services version 21.3.1.r3012050. Elapsed time: 00:00:26.6
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
[oracle@BAMISDB ORDS]$
[oracle@BAMISDB apex]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 22 17:23:03 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter session set container=misapex;
Session altered.
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" does not yet exist and will be created.
Enter ADMIN's email [ADMIN] info@bankasia-bd.com
Enter ADMIN's password []
--------------------------------------------------------------------------------
Password does not conform to this site's password complexity rules.
* Password must contain at least one punctuation character
(!"`'#$%&()[]{},.*+-/|\:;?_~).
* Password must contain at least one lower-case alphabetic character.
--------------------------------------------------------------------------------
declare
*
ERROR at line 1:
ORA-20001: Password validation failed.
ORA-06512: at line 30
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" does not yet exist and will be created.
Enter ADMIN's email [ADMIN] info@bankasia-bd.com
Enter ADMIN's password []
Created instance administrator ADMIN.
SQL>
SQL>
SQL>
