Setting Oracle Environment Variables

-

🐧 Setting Oracle Environment Variables on Linux

1. Open Terminal and Switch to the Oracle User:

            su - oracle

2. Set Environment Variables:

            export ORACLE_BASE=/u01/app/oracle
            export ORACLE_HOME=$ORACLE_BASE/product/23.0.0/dbhome_1
            export ORACLE_SID=orcl
            export PATH=$ORACLE_HOME/bin:$PATH

These variables define the base directory for Oracle software (ORACLE_BASE), the location of the Oracle home directory (ORACLE_HOME), the Oracle System Identifier (ORACLE_SID), and update the system PATH to include Oracle binaries.

3. Make Variables Persistent:

To ensure these settings persist across sessions, add them to the Oracle user's profile script:

            vi ~/.bash_profile

Add the export lines mentioned above, save, and exit. Then, apply the changes:

            source ~/.bash_profile


🪟 Setting Oracle Environment Variables on Windows

1. Access Environment Variables:

  • Right-click on This PC or My Computer and select Properties.
  • Click on Advanced system settings.
  • In the System Properties window, click on Environment Variables

2. Set ORACLE_HOME:

  • Under System variables, click New
  • Enter ORACLE_HOME as the variable name.
  • Set the variable value to your Oracle installation path, e.g., C:\oracle\product\23.0.0\dbhome_1.
  • Click OK.

3. Set ORACLE_SID:

  • Click New again under System variables.
  • Enter ORACLE_SID as the variable name.
  • Set the variable value to your database SID, e.g., orcl.
  • Click OK.

4. Update PATH Variable:

  • In the System variables section, find and select the Path variable, then click Edit.
  • Click New and add the path to the Oracle bin directory, e.g., C:\oracle\product\23.0.0\dbhome_1\bin
  • Click OK to close all dialog boxes.

🔍 Verifying Environment Variables

On Linux:

              echo $ORACLE_HOME
              echo $ORACLE_SID
              which sqlplus

On Windows:

Open Command Prompt and run:

              echo %ORACLE_HOME%
              echo %ORACLE_SID%
              where sqlplus

Comments

Post a Comment

Popular posts from this blog

Managing Oracle Data Files – Resizing and Adding

-
In Oracle databases, proper management of data files is essential to ensure performance, availability, and scalability. This guide explains how to view , resize , and add data files using SQL*Plus, SQL Developer, TOAD, and command-line tools. 🔍 When to Resize Data Files? Resize a data file when available free space is less than 500MB . Use caution: only resize files that are not already at their maximum size (typically 32GB for most configurations). Always connect using a privileged user like SYS or SYSTEM . 🔧 Monitor via Alert Log You should always monitor changes in the alert log :           # Connect as Oracle OS user                su - oracle           # Monitor the alert log in real-time                tail -900f /u01/.../trace/alert_<SID>.log 📘 Using SQL*Plus or SQL Developer View Existing Data Files    ...
Read more

Oracle Database Basic Consepts (Start / Stop / Check Database Status)

-
🟢 Starting the Oracle Database                SQL> STARTUP; This command initiates the Oracle instance, mounts the database, and opens it for use. For environments using pluggable databases (PDBs), you may need to open them separately:                SQL>  ALTER PLUGGABLE DATABASE ALL OPEN; 🔴 Shutting Down the Oracle Database                SQL> SHUTDOWN IMMEDIATE; This command performs a clean shutdown, rolling back uncommitted transactions and disconnecting users. For emergency situations where immediate shutdown is required, you can use:                SQL> SHUTDOWN ABORT; 🔍 Checking Database Status 1. Verify Oracle Processes: On Unix/Linux:                ps -ef | grep pmon If the pmon process is running, the database instance is act...
Read more

Kubernetes Administration – Essential Commands for IFS Cloud

-
This guide covers practical Kubernetes (K8s) administration tasks including managing namespaces , pods , deployments , PVCs , and PVs . Ideal for teams working with IFS Cloud deployments on Kubernetes . 📁 Namespace Management 🔥 Delete a Namespace                kubectl delete namespace hypdev --force 🧱 Pod Operations ❌ Delete or Recreate a Pod                kubectl delete pod <pod-name> --grace-period=0 --force -n <namespace> Example:                kubectl delete pod ifsapp-reporting-86b484b7cc-zws87 --grace-period=0 --force -n hypprd 🔍 Describe a Pod                kubectl describe pod <pod-name> -n <namespace> Examples:                kubectl describe pod ifsapp-proxy-xxxxxxxx-8k4ph -n hypprd          ...
Read more