B14 wrote:
> 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.
>
> Thanks for all the replys everyone,
>
> Marky Boy...
Great. Now if you can't upgrade to a version of the database supported
this century ... at least get yourself to 8.1.7.4.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jan 11 2007 - 18:57:04 CST
