Friday, January 18, 2013

Setting permanent environmental variables and user profile file

When you initially connect to the server, before you set your environmental variables by running .oraenv, your environmental variables such as ORACLE_SID and ORACLE_HOME populated by default by the values from .profile. You can change those temporarily by running .oraenv but more permanent ones are stored in the user profile file.

You can view your current settings by running the following from the command prompt


In order to view or edit .profile, you need to go to either /home/oracle or ORACLE_BASE and run

ls -la

to see all the files, including hidden ones - the ones preceded by the dot (.).

Then use

vi .profile

and look for a line where ORACLE_SID, ORACLE_BASE, and ORACLE_HOME are being set. Change it to the name of the database you want by default and your base and home directories.

No comments:

Post a Comment