Re: Logging In

On Dec 7, 8:04 pm, "ame...@xxxxxxx" <ame...@xxxxxxx> 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!!!

Try modifying what is below...

sids=`cat /etc/oratab | grep -v "#" | grep -v '*' | cut -f1 -d: |
sort`
PS3="Please select an ORACLE environment from the list above: "
select sid in $sids; do
export ORACLE_SID="$sid"
export ORACLE_HOME=`grep "$sid": /etc/oratab | cut -f2 -d:`
export PS1=`uname -n`':$LOGNAME:$ORACLE_SID:$PWD>'
export PATH=/bin:/usr/bin:/usr/local/bin:$ORACLE_HOME/bin
break
done

As others have mentioned, you could just rely on oraenv once you set
the ORACLE_SID.

HTH,

Steve
.

Relevant Pages

  • RE: Menu Show Delay for all profiles
    ... Hi, i need the solution for all user profiles, meaning that the setting ... should apply through the Default user profile whenever a new user logs on. ... That will bring up the first instance. ... Modify it as you wish. ...
    (microsoft.public.windowsxp.customize)
  • Re: determine what workstation a user logs onto
    ... There's no built in, ... LimitLogon. ... Even if you don't use it as it's intended, you can modify the ... you need to record the workstation name when a user logs on. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Environment variables
    ... typed it in myself instead of pasting so what file do i ... modify to make sure it gets loaded when any user logs on ... which there shouldn't be in a filename anyway. ...
    (linux.redhat)
  • Re: Debian Downgrade question
    ... Downgrades are not supported, so you are on your own. ... > What will happen if I just modify the sources.list and issue an ... I switched from sid to stable shortly after ... packages and manually installed them with dpkg. ...
    (Debian-User)
  • Re: Changing Registry Settings For Users Not Logged In
    ... USERNAME is the user's logon name or SID). ... So modify that section. ... as they have logged on prior to your modification, ...
    (microsoft.public.win2000.registry)
Loading