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
env
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.
You can view your current settings by running the following from the command prompt
env
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