How to setup environment for Database Tier at linux terminal?

Use following commands

1. Setup Oracle Home and run the environment file

ORACLE_HOME=/u01/apps/[hostname]/db/tech_st/11.1.0
cd /u01/apps/[hostname]/db/tech_st/11.1.0
. [SID]_[hostname].env

2. Setup Oracle SID for your environment and set the path
export ORACLE_SID=VIS
export PATH=$ORACLE_HOME/bin:$PATH

 

Where

  • [SID] stands for System ID, and is from your Oracle EBS Installation
  • [hostname] is the hostname from your Oracle EBS Installation

 

Assumptions

  • Oracle E Business Suite have been installed

 

Environment used for demonstration

  • Oracle E Business Suite Release 12i
  • Oracle Enterprise Linux 5.7
How to use adadmin utility for enabling maintenanc...
How to setup environment for Application Tier at l...