UNIX for Advanced & Expert Users

I would suggest dropping the .profile in oracle's home directory and starting again. Generally speaking, /etc/profile should be relatively simple. I have come across too many systems where /etc/profile has been used to code up all sorts of wonderful things that make sense to one person and cause a nightmare elsewhere. The way we get around that is to add the following code ONLY to the default /etc/profile:-

Code:

if [ -r /usr/loca/bin/`id -gn`.startup ]
then
   . /usr/local/bin/`id -gn`.startup
fi

Basically it determines if there is a startup file for your primary group and you can use that to set some general things for that group there. You can also then add in a few lines to a personal .profile, such as:-

Code:

#!/bin/ksh
set -o vi
umask 002

ORACLE_BASE=/data/oracle/ora11g
ORACLE_HOME=${ORACLE_BASE}/product/11.2.0/dbhome_1
ORACLE_DOC=${ORACLE_HOME}/doc
ORA_NLS33=${ORACLE_HOME}/ocommon/nls/admin/data

PATH=$PATH:${ORACLE_HOME}/bin:/usr/ccs/bin:/usr/bin:/usr/sbin:/etc:/usr/lbin:/usr/openwin/bin:/usr/ucb:/sbin
LIBPATH=${ORACLE_HOME}/lib32

export PATH ORACLE_BASE ORACLE_HOME ORACLE_DOC ORA_NLS33 LIBPATH LD_LIBRARY_PATH=$LIBPATH

Does this help at all? If it runs through normally, then each login (assuming you are using ksh (or a varient that also reads the .profile) should get it all set up. It might be worth putting in a quick echo "Hello!" somewhere in .profile to make sure it really is being called at all.


It's always better to enable segragation of environments with relative variable names rather that have to some how unpick it all later. I'm having that trouble myself with an inherited set of Cobol applications all on the one server with the "Development/Production support/Test/DR/anything else" environement all blended on the other server. We onely have the two HP-UX server, so we're a bit limited on how to split them up for a Cobol & Informix upgrade project, especially as the software is not used together and we want to separate the upgrades to production.





Robin
Liverpool/Blackburn
UK