Re: SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 01 Jun 2001 12:13:03 -0700
Message-ID: <F001.0031842C.20010601105120@fatcity.com>

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" <ORACLE-L_at_fatcity.com> 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

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: murosa_at_bankinter.es

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: ListGuru_at_fatcity.com (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: rgramolini_at_tax.state.vt.us

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: ListGuru_at_fatcity.com (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).

Received on Fri Jun 01 2001 - 14:13:03 CDT