Re: Logging In

On Dec 7, 7:04 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi,
>
> When you log into a server you usually get a list of default
> environment variables that look like below. Our oracle account does
> not have a .profile. However, I want to change the default ORACLE_SID
> when a user logs in.
>
> Does anyone know what file I'd modify? I get entries like below when
> I log in as any user:
>
> declare -x ORACLE_BASE="/opt/oracle/product"
> declare -x ORACLE_HOME="/opt/oracle/product/ora10"
> declare -x ORACLE_SID="OR00"
> declare -x PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/
> X11R6/bin:/home/oracle/bin"
> declare -x PWD="/home/oracle"
> declare -x SHELL="/bin/bash"
> declare -x SHLVL="1"
> declare -x SSH_CLIENT="::ffff:205.234.192.162 41110 22"
> declare -x SSH_CONNECTION="::ffff:205.234.192.162 41110 ::ffff:
> 205.234.192.188 22"
> declare -x SSH_TTY="/dev/pts/3"
> declare -x TERM="xterm"
> declare -x USER="oracle"
>
> Thanks!!!

Well if you want to the change default ORACLE_SID when someone logs in add in an entry to kick off a script. That script can prompt the user with a list of valid SID's to choose from ... based on the oracle database instance(s) running on that system.

Lots of examples of prompting unix/linux menu systems to set ORACLE_SID if you look around. Received on Fri Dec 07 2007 - 19:14:20 CST