First create custom ords and plsql gateway user with ADMIN user in OCI ATP. Dockerfile install_ords.sh jdk… Wallet_*.zip Docker File $1 $2 $3 $4 $5 $6 $7 $8 are placeholders for USER_NAME_ADMIN=$1 USER_NAME_ORDS=$2 USER_NAME_GATEWAY=$3 WALLET_LOCATION=$4 #full path SERVICE_NAME=$5 PWD_ADMIN=$6 PWD_ORDS=$7 PWD_PLSQL=$8 install_ords.sh Read more about this syntax Download Target ATP wallet and place it in…
Category: Oralce DB
Database link Between OCI Autonomous Database
Say you would like to create DB link between 2 Autonomous Database in OCI DB1 and DB2. Assume DB1 want to query data from DB2 Create New Database Directory on DB1 Next, we need to create 2 credentials. 1 is used to access Bucket, 1 is used for storing schema@pwd to DB2 Credentials to Access…
Migrate APEX to Autonomous Database with custom ORDS (notes)
Create And Manage Your Custom ORDs credits goes two these two links https://fuzziebrain.com/content/id/2004/ https://www.linkedin.com/pulse/run-your-oracle-apex-apps-autonomous-database-own-domain-kurt-liu/ How to enable web sql-developer https://host/ords/sql-developer two ways to enable it. Go to Apex and enable rest for the parsing schema. make your the alias is in smallcase. or logon to the schema and write this plsql block to enable it….
Run Java Programs in plsql
Java Class login to db server install java sdk sudo yum install java-1.8.0-openjdk‘ check java -v mdkr myJavaFile nano Square_Cube.java javac Square_Cube.java it creates a new file Square_Cube.class loadjava -thin -user db_user/db_pwd@localhost:1521/xepdb1 -resolve -verbose Square_Cube.class this will create a new java class entry in your db Java Source
Use Bastion Service to Connect To Autonomous DB within a private subnet PLSQL Developer
Validate VCN security list ingression rule. Find your database subnet check security list settings if 1522 ingress rule not existing, add it Create A Bastion in the same VCN or existing bastion in the same VCN where your Autonomous DB reside Create Session Open SSH Tunnel “-i <privateKey>” is not needed since we use public…
Oracle 21 XE, APEX, ORDs, Nginx as Load Balancer, PLSQL WS Proxy Installation Notes
High level design Database & APEX installation Linux ORDs Installation Nginx load balancer configuration Nginx PLSQL Webservice Proxy server configuration High level design Database & APEX installation Oracle 21XE installation Oracle APEX installation Database Installation For Oracle 21XE installation, i would suggest to follow this oracle official guide, it is pretty straight forward. (I assume…