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

From: <murosa_at_bankinter.es>
Date: Mon, 04 Jun 2001 01:53:16 -0700
Message-ID: <F001.00319E33.20010604011524@fatcity.com>

Thank you very much, Ruth, but it doesn't our problem. We have same tnsnames in our server and client machines.

Best regards.

Miguel.

01/06/2001 20.51
"Ruth Gramolini"
rgramolini_at_tax.state.vt.us
01/06/2001 20.06

                                                                            
                 Por favor, responda a ORACLE-L_at_fatcity.com

Remitente root_at_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

|--------------------------------------------------------------------------|
| Destinatario Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> |
| Copia                                                                    |
|--------------------------------------------------------------------------|





                   ____________________________________

--

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