oraenv vs .bash_profile in Oracle | Environment Variable

ps -ef|grep smon

su - oracle

. oraenv >>> DEVDB/TESTDB

env |grep ORA

sqlplus / as sysdba

. oraenv -> Works fine in we have proper entry in /etc/oratab file 

[oracle@oraclelab1 ~]$ . oraenv

ORACLE_SID = [oracle] ? DEVDB

The Oracle base has been set to /u01/app/oracle

[oracle@oraclelab1 ~]$

- If not we need manually enter SID and ORACLE HOME 

[oracle@oraclelab1 ~]$ . oraenv

ORACLE_SID = [oracle] ? DEVDB

ORACLE_HOME = [oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1

The Oracle base has been set to /u01/app/oracle

[oracle@oraclelab1 ~]$

oraenv -> Is used to setting environmental variable 

[oracle@oraclelab1 ~]$ env |grep ORA

ORACLE_SID=DEVDB

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

su - oracle

sqlplus / as sysdba

.bash_profile Vs oraenv 

.bash_profile is used to set automatic environmental variable 

/home/oracle/.bash_profile

vi /home/oracle/.bash_profile

export ORACLE_SID=DEVDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

su - oracle

[oracle@oraclelab1 ~]$ env |grep ORA

ORACLE_SID=DEVDB

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

sqlplus / as sysdba

vi /home/oracle/.bash_profile

export ORACLE_SID=TESTDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=+ASM

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/19.0.0.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

lab2:

grid user -> +ASM

++++++++++++++++++++

vi /home/grid/.bash_profile

++++++++++++++++++++

export ORACLE_SID=+ASM

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/19.0.0.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

oracle user -> TESTDB 

++++++++++++++++++++

vi /home/oracle/.bash_profile

++++++++++++++++++++

export ORACLE_SID=TESTDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

lab1:

oracle -> DEVDB

oracle -> UATDB 

oracle -> PRODDB 

vi /home/oracle/.bash_profile

export ORACLE_SID=DEVDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=UATDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=PRODDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

su - oracle 

export ORACLE_SID=DEVDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

sqlplus / as sysdba >>> DEVDB 

export ORACLE_SID=UATDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

sqlplus / as sysdba >>> UATDB

#vismotechnologies #mallik034 #oracle #database #training #onlinetraining #liveclasses #rac #oracledba #oraclecarrers #oracleworld

Regards,

Mallikarjun / Vismo Technologies

WhatsApp: +91 9880616848 / +91 9036478079

Cell: +91 9880616848 / +91 9036478079

Email: mallikarjun.ramadurg@gmail.com / vismotechnologies@gmail.com