Re: ORA-01031 Hell...

B14 wrote:

> Valentin Minzatu wrote:
> > Is your ORACLE_SID set to TEST?
>
> I think that this will answer your question:
>
> OraTEST >echo $ORACLE_SID
> TEST
> OraTEST >echo $ORACLE_HOME
> /u02/oracle/testdb/8.1.7
> OraTEST >
>
> I looked at that, and a few other things as well. But alas no joy, I
> ran through the metalink guide to resolving connect "/ as sysdba" but
> that didn't get me anywhere....
>
> thanks again for the posts though,
>
> Marky Boy...

I found that unsetting the $TWO_TASK variable sorted this:

You have new mail.
root_at_sundevlunx003#su - oratest
Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001

OraTEST >echo $TWO_TEST

OraTEST >echo $TWO_TASK
TEST
OraTEST >unset TWO_TASK
OraTEST >echo $TWO_TASK

OraTEST >sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 11 05:36:34 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> exit
Disconnected
OraTEST >sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 11 05:36:50 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> exit
Disconnected

Not sure why... I found this out from metalink note: Note:69642.1 Received on Thu Jan 11 2007 - 07:40:36 CST