Setting the ORACLE environment variables in solaris

[Former Member]

Hi,

For the ORACLE database Upgrade from 9i to 10g, I need to set few environment variables for 10g like

DISPLAY ;

ORACLE_BASE ;

ORACLE_SID ;

NLS_LANG ;

ORANLS10 AND SAPDATA_HOME

in the Solaris System, how can I change the environment variables, please guide me and do the needful.

regards,

Madhu

[stefan_koehler]

Hello Madhu,

the environment is set with the following files:

• <HOME>/.dbenv_<hostname>.sh

• <HOME>/.dbenv_<hostname>.csh

• <HOME>/.sapenv_<hostname>.sh

• <HOME>/.sapenv_<hostname>.csh

You have to check these files and edit them - please check sapnote #602843 for more information about the variables and its values.

Regards

Stefan