Oracle-L: RE: ORA-03113: end-of-file on communication channel. HELP !

From: kkennedy <kkennedy_at_firstpoint.com>
Date: Thu, 25 Jul 2002 09:48:36 -0800
Message-ID: <F001.004A287B.20020725094836@fatcity.com>

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

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: arul.kumar_at_bt.com

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: ListGuru_at_fatcity.com (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: kkennedy_at_firstpoint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------