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).
