Oracle ENvironment variables

[Massimo_37]

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

[Steven E. Protter · Accepted solution]

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

[harry d brown jr]

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

[Nicolas Dumeige]

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

[Massimo_37]

Thank you all for your help- I think I traced all the variables now

[Nicolas Dumeige]

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

[Indira Aramandla]

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