Do you have a tnsnames file on the server you are using to access sqlplus?
If not, put a copy of your tnsnames file and set you ORACLE_SID before
trying sqlplus.
Just a thot...
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 9:45 AM
Hi folks, again. I was subscribed two years ago and I'm stay here again.
I'm facing to a curious problem with Oracle 8.1.6.3 over Solaris 2.6.
When I connect to sqlplus via tnsnames.ora
I'm getting following errors:
SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jun 1 10:08:58 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-01012: not logged on
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning and Parallel Server options
JServer Release 8.1.6.3.0 - Production
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01012: not logged on
SQL>
But when I connect from same machine where reside Oracle, I have no
problems.
¿Anybody knows something about that?.
Thank you very mucha in advance.
Regards.
Miguel Urosa.
____________________________________
"Este mensaje y los documentos que, en su caso, lleve anexos, pueden
contener información confidencial. Por ello, se informa a quien lo reciba
por error que la información contenida en el mismo es reservada y su uso no
autorizado está prohibido legalmente, por lo que en tal caso le rogamos
que nos lo comunique por la misma vía o por teléfono (901 113 113) , se
abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra
persona y proceda a borrarlo de inmediato."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
