Re: Login problem of oracle DB


"yw" <pest9998@xxxxxxxxxxx> wrote in message
news:ddhg84$ot5@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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@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




.

Relevant Pages

  • Setting up db control configuration file in a different directory than ORACLE_HOME
    ... I am using Oracle 10.2.0.3 on HP UNIX 11i. ... In my company Oracle is installed from a different login than the ... installation is ioracle. ... Oracle login for database creation is oracle. ...
    (comp.databases.oracle.server)
  • Login problem of oracle DB
    ... When I login to oracle database, a strange problem occurs, here comes the ... Copyright 2000 Oracle Corporation. ... Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production ...
    (comp.databases.oracle.server)
  • Re: Creating schema in oracle10g express edition
    ... oracle have the concept of one database, where i can create a user (and ... When you create a user in oracle usually it it "not" a schema owner. ... When you login to an oracle database of course you use a database user ...
    (comp.databases.oracle.server)
  • DBD::Oracle and CHLD Signal Handler
    ... I have a strange problem when connecting to an Oracle 10 database: ... connecting to the database meddles with the CHLD signal ...
    (perl.dbi.users)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)