Quote:
Originally Posted by
duke0001
So how to update env variables permanently.
That depends on the shell you are using and eventually on the OS too, e.g. if your default shell is the bourne sh or bash, you should be able to modify that variable in the $HOME/.profile file. If your shell is csh, then you should check the $HOME/.cshrc file. At least these are the appropriate files on my FreeBSD system.
Quote:
Originally Posted by
duke0001
I only can login as oracle super user, but don't have root user privileges. Is this because Unix admin create oracle user with that env variable so that I couldn't update it permanently?
Oracle user does not necessarily need root privileges.
Simply check if the files I've mentioned above exist and check the file permissions for them. Take a look into them and see if you can find the DBA_LIST variable.
Quote:
Originally Posted by
duke0001
I have to ask Unix admin with root privilege to make permanent change?
I can't tell that... not necessarily... though it's probably the best idea, to simply avoid any potential conflicts with him.
---------- Post updated at 07:13 ---------- Previous update was at 07:08 ----------
Update regarding root privileges for oracle user:
IMHO that's less a matter of setting env variables than powering off the machine, manipulating logfiles and the like...