Re: Login problem of oracle DB

"yw" <pest9998_at_hotmail.com> wrote in message news:ddhg84$ot5_at_netnews.net.lucent.com...
> Hi,all
>
> When I login to oracle database, a strange problem occurs, here comes the
> details:
>
> Platform: Solaris8
> Steps:
> 1. Create database, sid = TEST.
> 2. Create a user, user = test/test
> 3. Create service in tnsnames.ora, service name is test.
>
> 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.
>
> 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.
>
> 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.
>
> I wonder why the first senario can not login database? Thanks.
>
>

For the first situation, you can set the TWO_TASK environment variable to your SID in the .profile file of your oracle user : export TWO_TASK=test.

HTH
Matthias Hoys Received on Fri Aug 12 2005 - 14:44:44 CDT