Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
Subject: ora 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
Subject: Re: ORA 01722 invalid number
 
AW: [suse-oracle] Different environment in initscripts?

AW: [suse-oracle] Different environment in initscripts?

2007-12-05       - By Silviu Marin-Caea

 Back
Reply:     1     2  

On Wednesday 05 December 2007 01:40:07 pm Klier, Martin (A.T.U) wrote:
> Hi,
>
> the /etc/profile construct is not sourced by init scripts.

It does not appear to be that.  su - oracle will actually
run /etc/profile.d/oracle.sh

from info:/su
`-'
`-l'
`--login'
     Make the shell a login shell.  This means the following.  Unset all
     environment variables except `TERM', `HOME', and `SHELL' (which
     are set as described above), and `USER' and `LOGNAME' (which are
     set, even for the super-user, as described above), and set `PATH'
     to a compiled-in default value.  Change to USER's home directory.
     Prepend `-' to the shell's name, intended to make it read its
     login startup file(s).

from man:/bash
When bash is invoked as an interactive login shell, or as a non-interactive
shell with the --login option, it first reads and executes commands from the
file /etc/profile, if that file exists. After reading that file, it looks for
~/.bash_profile, ~/.bash_login, and ~/.profile, in that order, and reads and
executes commands from the first one that exists and is readable.
The --noprofile option may be used when the shell is started to inhibit this
behavior.


And I have added some "echo" debugging lines to some scripts, to verify the
process is working as I expect.  This is the output, over a reboot cycle,
with added comments.

reboot

# this is su - oracle -c "echo shutdown immediate | sqlplus"
oracle_db stop 15:16:09
 running /etc/profile.d/oracle.sh 15:16:09

# this is env from inside su - oracle
ORA_NLS10=/opt/oracle/product/10gR2/db/nls/data
ORACLE_SID=prod2
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/10gR2/db

# this is supposed to completely halt CRS
init.crs stop 15:17:13
 running /etc/profile.d/oracle.sh 15:17:13

# this unsets the environment
oracle_kparm stop 15:17:31
 running /etc/profile.d/oracle.sh 15:17:31

# these are processes that CRS should have stopped
 PID TTY          TIME CMD
29617 ?        00:00:00 ons
29618 ?        00:00:00 ons
# shutdown completed

# after boot.local the services will start
/etc/init.d/boot.local 15:21:14
oracle_kparm start 15:21:40
 running /etc/profile.d/oracle.sh 15:21:40
init.crs start 15:21:41
 running /etc/profile.d/oracle.sh 15:21:42
 running /etc/profile.d/oracle.sh 15:21:42
 running /etc/profile.d/oracle.sh 15:21:42
 running /etc/profile.d/oracle.sh 15:21:42
 running /etc/profile.d/oracle.sh 15:22:26
 running /etc/profile.d/oracle.sh 15:22:44
 running /etc/profile.d/oracle.sh 15:22:46


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting