sábado, 31 de mayo de 2014

Environment Variables Needed to StartOracle (Linux)

To be able to start the listener, upload the database and Enterprise manage, also known as EM; We have to set the following variables in our console every time we log in, we can also configure them in the ~ / .bash_profile file of the Oracle user (see how to do this).

The first variable is ORACLE_HOME this will have the path that they defined in the installation of the database, for example the home of my database is '/oracle/app/oracle/product/11.2.0/db_1' then in my case The commands that I have to execute as an Oracle user will be:

set ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
export ORACLE_HOME

The second variable is ORACLE_SID this will have the sid of the database which is also specified when we installed it, it is usually the same name of the database.
If you do not know the SID execute this command as root: 'ps -ef | Grep -i pmon 'and you'll see something like this' oracle 27161 1 0 Mar07? 00:03:53 ora_pmon_ora11g 'where ora11g is the SID.
In my case the SID is 'ora11g' then the commands that I have to execute as an Oracle user to define the variable would be:

set ORACLE_SID=ora11g
export ORACLE_SID

No hay comentarios.:

Publicar un comentario