Advanced Search
Search Results
27 total results found
Chapter 3 - Creating and Configuring an Oracle Database
To configure Oracle Database Free, you can (optionally) tweak the configuration parameters located at: /etc/sysconfig/oracle-free-23ai.conf But if you’re ok with the defaults, skip right to the main event: sudo /etc/init.d/oracle-free-23ai configure Choose a P...
Chapter 4: Setting Oracle Database Free Environment Variables
export ORACLE_SID=FREE export ORAENV_ASK=NO . /opt/oracle/product/23ai/dbhomeFree/bin/oraenv
Chapter 5: Starting and Stopping Oracle Database 23ai
To Shut Down Using SQL*Plus: su - oracle sqlplus / as sysdba SHUTDOWN IMMEDIATE; To start the database Using SQL*Plus: STARTUP; ALTER PLUGGABLE DATABASE ALL OPEN; Automating Shutdown and Start-Up: run the following commands as root: systemctl daemon-reload s...
Step 6: Enabling GUI Access for DBCA – X11 Forwarding
Sometimes, clicking is better than typing, especially when you're setting up a database and prefer a mouse over a terminal. If that sounds like you, let’s get DBCA (Database Configuration Assistant) running with a full graphical interface using Xming. Download...
Chapter 7: Creating a New PDB with DBCA
Export variablesexport ORACLE_SID=FREE export ORAENV_ASK=NO . /opt/oracle/product/23ai/dbhomeFree/bin/oraenvLaunch DBCAcd $ORACLE_HOME/bin./dbcaThe step-by-step guide with images for creating new PDBs using DBCA.
Chapter 17: Publishing Through Oracle Cloud Network Load Balancer
A Network Load Balancer (NLB) helps distribute traffic across multiple backend servers, ensuring high availability, redundancy, and scalability for your application. In this chapter, you’ll learn how to create a basic NLB setup to forward traffic to a backend ...
Chapter 18: Using Nginx Proxy Manager with a Network Load Balancer
If you’re behind a Network Load Balancer (NLB) and want to manage SSL certificates and reverse proxying with ease, Nginx Proxy Manager (NPM) is a powerful web-based tool that simplifies the process. In this chapter, you’ll learn how to:Upload your SSL certific...
Chapter 8 - Interactive Oracle PDB Selector Script for SQL*Plus (CDB Environment)
This is a Bash script that lets you interactively choose a PDB (Pluggable Database) and jumps you straight into SQL*Plus, already switched to the right container.vi connect_pdb.shPaste the following inside vi#!/bin/bash export ORACLE_HOME=/opt/oracle/produc...
Post - Installing Certbot & Generating SSL Certificate
Sometimes, generating an SSL certificate can be challenging, especially on first attempts. This guide was fully tested on a Debian server, and here are a few helpful tips to avoid common issues and hours of troubleshooting: Create an A record pointing to your ...