Re: Login problem of oracle DB

Hi,

yw schrieb:
> Hi,all
>
> [...]
> Problems:
> 1. login operation system with user:test
> (SVR) /export/home/test (392)$ sqlplus test/test
> SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 12 12:40:48 2005
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
> ERROR:
> ORA-03113: end-of-file on communication channel
> Enter user-name:
>
> Result: Failed, prompt to enter user name and password.
>

is yout environment set correctly?
if you want to connect directly at least ORACLE_HOME and ORACLE_SID must be set correctly.
> 2. login operation system with user:test
> (SVR) /export/home/test (393)$ sqlplus test/test_at_test
> SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 12 12:41:54 2005
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> SQL>
>
> Result: Log in succesfull.
>

this works via sql*net, so ORACLE_SID is not as essential. ORACLE_HOME I expect to be set correctly.
> 3. (SVR) /export/home/oracle (525)$ sqlplus test/test
> SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 12 12:42:25 2005
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> SQL>
>
> Result: Log in succesfull.
>

user oracle as owner of the database installation will have environment set.
> I wonder why the first senario can not login database? Thanks.
>
>

hth

Matthias Received on Fri Aug 12 2005 - 14:57:08 CDT