I'm not sure what operating system you are working on and I'm not precisely sure why
you get your particular symptom, but I do know what you are missing.
When you use "su - user", "the environment will be changed to what would be expected
if the user actually logged in as the specified user" (from Solaris8 man page). If
you omit the - argument, the new shell uses the current environment -- which, in your
case, probably is not exactly the right environment for starting Oracle. To see the
differences, save the output from env|sort after "su - oracle" then again after "su
oracle" and use diff to compare them.
I recommend that you always use the "su - oracle" login when starting oracle --
working under ksh while starting the database shouldn't be too painful even for a csh
type person 8-)
Note, on Solaris, "su -u user" seems to work the same as "su - user". The u is not a
documented parameter but it may have some relevance on your version of unix.
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What can this mean?
-----Original Message-----
Sent: Thursday, July 25, 2002 5:23 AM
To: Multiple recipients of list ORACLE-L
Hi,
We have a Unix user dcclive ( oracle database user ops$dcclive - os
authentication ).
I am able to connect my database using TNS Alias but not directly.
when i start the database in the following way :
After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and
started the database, exit from oracle login , connect from dcclive login
using os authentication ( using / in sqlplus ), it connects to the database.
But when i logging in as dcclive ( C Shell ), su oracle and started the
database, exit from oracle login , connect from dcclive login using os
authentication ( using / in sqlplus ), it DOES NOT connects to the database.
To connect now, i have to use TNS Alias as seen below.
uid=1037(dcclive) gid=101(dba)
kitchen% sqlplus /
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-03113: end-of-file on communication channel
Enter user-name: / @dcclive
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Why ?
Please note that Oracle login has Korn shell. Does the change of shell
matters ? or am i missing something ? I have checked all the necessary env.
variables. All r set properly.
How exactly su -u and su matters to oracle ?
Thanks in advance.
Arul.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
