Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle ENvironment variables

SOLVED
Go to solution
Massimo_37
Frequent Advisor

Oracle ENvironment variables

Where should I set up the intial Oracle Environment variables? On our current server (HP UX 10.2 and Oracle7) I can see a list of variables (like ORACLE_HOME, ORACLE_SID etc)defined in /etc/profile. Can I do the same on the new server (also with HP UX 10.2) before installing Oracle 7.
Also , there are other Oracle env variables like ORACRT(which echoes value wy120) and ORALIST( which echoes my home directory). How can I find out where it is set. It is not under my .profile. How can I set this for users on the new server to get their respective terminal types, login names etc. Many Thanks in advance
6 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: Oracle ENvironment variables

You will need all of the big oracle variables like ORACLE_HOME, ORACLE_SID.

Your current scripts for setting them will probably work with little modification.

terminal types and such have not really evolved, so the users .profile can probably be copied, at least the relavent sections. If there is an oracle section of /etc/profile, copy it.

Oracles database doc is very explicit, at least on the subject of environment variables. I also recommend checking the OS patch list and kernel modifications required at http://technet.oracle.com or http://metalink.oracle.com

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
harry d brown jr
Honored Contributor

Re: Oracle ENvironment variables

Wow, and unsupported Operating system running an unsupported Database release.

Copy your /etc/profile to the new machine. Carefully check your home .profile and /etc/profile, making sure they aren't "sourcing" other profiles. If they are then they also need to be copied to the "new" machine.

live free or die
harry
Live Free or Die
Nicolas Dumeige
Esteemed Contributor

Re: Oracle ENvironment variables

Oracle environnement variable are used by serveral users : oracle installer, the user which run the RDBMS, application user, production team account, ...
So if you have multiple env file, you'll have to maintain all by hand.

=> If you have only version of Oracle and not you don't plan to add another, and if you have only one instance, all users can source a unique file.
Put all the environnnement variable in a file (ex :/var/opt/oracle/env_ora.sh ) and source it in /etc/profile.

=> Normaly, this is not was is done because there might be multiple Oracle installation and because if there's various instances, you need to set the ORACLE_SID variable accordingly.

Classics Oracle variables :
ORACLE_HOME
ORACLE_SID
TNS_ADMIN
NLS_...

Don't forget also to add all needed to the path and library path, if not, you'll have some error messages.

Cheers

Nicolas



All different, all Unix
Massimo_37
Frequent Advisor

Re: Oracle ENvironment variables

Thank you all for your help- I think I traced all the variables now
Nicolas Dumeige
Esteemed Contributor

Re: Oracle ENvironment variables

Also check oraenv and coraenv utilities : these tool facilitates the environnement management, they can be found under $ORACLE_HOME/bin.
You'll find a lot of information on this on the net.

Cheers

Nicolas
All different, all Unix
Indira Aramandla
Honored Contributor

Re: Oracle ENvironment variables

Hi,

As others mentioned, environment variables for the user that installs the oracle RDBMS which would be (Oracle belonging to dba group) and the other users that access the oracle databases are

ORACLE_BASE
ORACLE_HOME
ORACLE_SID
TNS_ADMIN
PATH
TERM
ORACLE_OWNER
ORACLE_PATH
TWO_TASK
NLS_

. oraenv and .coraenv utilities,

Also check if there were variables to define the location of the parameter file (init.ora) , ORACLE_HOME/dbs directory.

And for the users check if LD_LIBRARY_PATH or SHLIB_PATH is set.

To get their respective terminal types, login names, you can define the PS1 int eh individual user profiles like

PS1=`echo ${LOGNAME}`:'$PWD:($ORACLE_SID)>'

Where you get the logname, from UNIX variable LOGNAME, terminal from TERM
And verify your "INSTALLATION AND CONFIGURATION GUIDE" for each product full description and list of variables.

Attached is a document that details about the Oracle and UNIX environemtn variables that are required.


Indira A
Never give up, Keep Trying