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).