![]() ![]() Set a password for the APEX admin user (for the APEX sudo su „“ sql script can be used to change the password of an Application Express If using Oracle Application Express or migrating from mod_plsql then you must enter 1 :Įnter the PL/SQL Gateway database user name :Įnter the database password for APEX_PUBLIC_USER:Įnter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step : 1Įnter the database password for APEX_LISTENER:Įnter the database password for APEX_REST_PUBLIC_USER: Password for the Database APEX_REST_LISTENER: refer to Chapter „Configuring RESTful Services for Oracle APEX“ in this cd java -jar ords.war setupĮnter the location to store configuration data:/home/apexuser/ORDSĮnter the name of the database server :Įnter 1 to specify the database service name, or 2 to specify the database SID : 2Įnter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step : 2Įnter 1 if you want to use PL/SQL Gateway or 2 to skip this step: 2.Password for the Database User APEX_LISTENER: refer to Chapter „Configuring RESTful Services for Oracle APEX“ in this Blogpost.Password for the Database User APEX_PUBLIC_USER: refer to Chapter „Configuring RESTful Services for Oracle APEX“ in this Blogpost.Database SID and Listener Port: refer to Chapter „Test the DB Connection“ in Part 2: Create the Oracle APEX Database in Amazon Relation Data Service (RDS). ![]() Database Hostname: Database Endpoint: refer to Chapter „Test the DB Connection“ in the.ords-18.4.0.īefore you start the ORDS configuration get following data: bnekeypair.pem the EC2 Container change to OS user root and install sudo cp /home/ec2-user/ords-18.4.0. chmod 777 su „“ mkdir cd unzip. bnekeypair.pem ords-18.4.0. to the EC2 Container and install the ORDS: Now download the Oracle REST Data Services: bnekeypair.pem to root and install APEX in the EC2 sudo cp /home/ec2-user/apex_18.1.zip chmod 777 su „“ cd unzip apex_18.1.zipĪPEX is in the EC2 Container now installed bnekeypair.pem apex_18.1.zip the EC2 Container: SQL> alter user APEX_PUBLIC_USER account unlock Ĭopy APEX from the local PC to the EC2-Container: SQL> alter user APEX_PUBLIC_USER identified by SQL> exec rdsadmin.rdsadmin_run_apex_rest_config("šapex_listener_password"˜,"™apex_rest_public_user_password"˜) When you run the stored procedure, you provide passwords for the following users: To configure RESTful services in APEX, use SQL*Plus to connect to your DB instance as the master user, and then run the rdsadmin.rdsadmin_run_apex_rest_config stored procedure. bnekeypair.pem sqlcl-19.1.0. installed the Tool under cp /home/ec2-user/sqlcl-19.1.0. chmod 777 su – unzip export alias export PATH=$JAVA_HOME/bin:$PATHĬonfiguring RESTful Services for Oracle APEX I copied the SQLcl installation zip file on my Laptop and copied it to the EC2 Container Then I installed the Tool Oracle SQL Developer Command Line (SQLcl): is a free command line interface for Oracle Database. OpenJDK 64-Bit Server VM (build 25.201-b09, mixed mode) OpenJDK Runtime Environment (build 1.8.0_201-b09) I used the new Tool SQLCLI for the connect to the database. The following command creates a new user named useradd -d /home/apexuser passwd apexuserĬonfigure and check the connectivity from the EC2 Container to the Database bnekeypair.pem to root and start the OS sudo yum updateĬreate a nonprivileged OS user to own the APEX Listener installation. cd /drives/d/Documents/Job/OC/KnowHow/Cloud/AWS/Netzwerke Navigate to the directory with saved private SSH key and connect to the VM in AWS: I downloaded the SSH Key Pair in the directory on my laptop: /drives/d/Documents/Job/OC/KnowHow/Cloud/AWS/NetzwerkeĬonnect to the already created ec2 container: AMI: Amazon Linux 2 AMI (HVM), SSD Volume Type – ami-09def150731bdbcc2.Installing and Configuring the VM for the APEX Listener ![]() We will build the separate VM (EC2 Container) in AWS and configure following components: ORDS, Apache Tomcat und Nginx Server. In this post, I will explain the configuration of Middleware components needed to present apex content in web.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |