Re: Change parameter without restart db

2001-08-28 Thread murosa

You must check in V$PARAMETER if that parameter you want modified 
it's possible. In that view you have two columns ISSES_MODIFIABLE and 
ISSYS_MODIFIABLE, and they say toy you if you can modify that parameter 
to session or system level. If both are false only it's possible 
modifing initSISçD.ora and restart instance.

HTH.

Regards, Miguel Urosa.

 Hi all,
 
 I have a stupid question for all of you.



begin:vcard
n:Urosa Ruiz;Miguel
fn:Miguel Urosa Ruiz
tel;home:91 477 06 20
org:SMSEuropa, S.A.
adr:;;Santa Julia 5, 2ºC;Madrid;Madrid;28053;España
version:2.1
email;internet:[EMAIL PROTECTED]
end:vcard



Re: Automatic database start in sun solaris

2001-08-24 Thread murosa

Saroj, you must create two files, SXXXOracle and KXXXOracle, 
in /etc/rc2.d, for example, where XXX are numbers. So when your machine 
reboots that files starts Oracle Database and listeners. Well, first, 
because second is to stop database and listener. This is a question of 
Unix start. Due to I'm not really sure how can you do it, it's better 
you see at that directory, /etc/rc2.d, and look any pair of files to 
see it.

Remenber SXXXOracle is to start Oracle and listeners and KXXXOracle 
is to stop its.

HTH




begin:vcard
n:Urosa Ruiz;Miguel
fn:Miguel Urosa Ruiz
tel;home:91 477 06 20
org:SMSEuropa, S.A.
adr:;;Santa Julia 5, 2ºC;Madrid;Madrid;28053;España
version:2.1
email;internet:[EMAIL PROTECTED]
end:vcard



Re: index status

2001-08-09 Thread murosa

In what view do you see that information?.

- Mensaje original -
De: orclbabu [EMAIL PROTECTED]
Fecha: Miércoles, Agosto 8, 2001 7:09 pm
Asunto: index status

 All
 
 What does index status = '
 I have a bunch of Indexes that have a index_status of 
 Babu
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: orclbabu
  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).
 

___
Date de alta en inicia y dispondrás de correo y espacio para tu página 
personal. http://inicia.es

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



List errors of Microsoft ODBC for Oracle

2001-08-08 Thread murosa

Hi folks.

Anybody knows where can I get information about list of error codes 
of Microsoft ODBC for Oracle. We are working with Visual Basic 6.0 with 
Oracle8 and name of dinamic library is MSORCL32.DLL.

Thank you very much in advance.

Regards.

Miguel Urosa.


___
Date de alta en inicia y dispondrás de correo y espacio para tu página 
personal. http://inicia.es

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



Re: Table Fragmentation - Please Help - Urgent

2001-08-08 Thread murosa

SELECT 
   SEGMENT_NAME, 
   SEGMENT_TYPE, 
   BYTES/1024/1024 Kbytes, 
   EXTENTS
FROM
   DBA_SEGMENTS
/


- Mensaje original -
De: Viraj Luthra [EMAIL PROTECTED]
Fecha: Miércoles, Agosto 8, 2001 11:21 am
Asunto: Table Fragmentation - Please Help - Urgent

 Hello All,
 
 Please help in sending me a script for getting to know whether a 
 table is fragmented or not? Also need to know whether I will need 
 to Analyse the table for getting accurate results, and if yes how 
 to do that?
 
 Thanks 
 
 raja
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Viraj Luthra
  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).
 

___
Date de alta en inicia y dispondrás de correo y espacio para tu página 
personal. http://inicia.es

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



Database in archivelog mode

2001-06-21 Thread murosa


 Hi folks.

 I  have  a very strange behavour in a database. I want to put database
inarchivelogmode,   I've   changed   log_archive_start   to   true,
log_archive_dest_1 to a location where I can write and log_archive_start to
true. Then I follow next sequence:

  shutdown immediate;
  startup mount
  alter database archivelog;
  alter database open;
  alter system archive log start;

 In third step I get:

ERROR at line 1:
ORA-01126: database must be mounted EXCLUSIVE and not open for this operation.

 Next two sentence are executed correctly. When I select * from v$instance; I've 
got
SQL select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--- 
HOST_NAME

VERSION   STARTUP_T STATUS  PARTHREAD# ARCHIVE LOG_SWITCH_
- - --- --- -- --- ---
LOGINS SHU DATABASE_STATUS   INSTANCE_ROLE
-- --- - --
  2 webspher2
ebkppr02
8.1.6.3.0 21-JUN-01 OPENYES  2 STARTED
ALLOWEDNO  ACTIVEPRIMARY_INSTANCE

in both instance, because is an OPS.

 Initalization parameter remote_login_password is exclusive. I know that I have an 
error but I don't  know which and why,
but it doesn't work in archivelog mode.

 Anybody can help me?.

 Thank you very much in advance.

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



Database in archivelog mode THANX

2001-06-21 Thread murosa

 I've got solution from 1062786.6 note of Metalink.

 Thank you very much to all who reply to me.

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



Latchs

2001-06-19 Thread murosa


 Hi folks.

 I'd  like  to  know  about  different  latchs,  wait events and locks.
Meaning  of  willing to wait and immediate ratio and all anothers things in
relation with that.

 Anybody  knows  about  documents,  books, notes in Metalink, etc about
that?.

 Thank you very much in advence.

 Regards.

 Miguel.

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



RE: Oracle 8i database ER diagram

2001-06-12 Thread murosa


 What about to use Oracle Designer?.

 Regards.

 Miguel Urosa.




12/06/2001 11.00
magesh
[EMAIL PROTECTED]
12/06/2001 11.01



 Por favor, responda a [EMAIL PROTECTED] 



Remitente [EMAIL PROTECTED]



Hi

We are exploring the possibility of generating ER diagram from the
Oracle 8i database. We want to know how it can be done.

Thanks  Regards
Magesh



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: magesh
  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).
|--|
| Destinatario Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |
| Copia|
|--|





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



GV$ views

2001-06-08 Thread murosa

 Hi folks.

 We  have  installed  four OPS on a Solaris 2.6 cluster. In one of that
instances  we  have problems with GV$ views because it returns same results
than  V$  views.  Anybody  knows what nappens?. We have Oracle 8.1.6.3 over
Solaris 2.6 and all instances are working well.

 Thank you very much in advance.

 Miguel.

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



Re: GV$ views

2001-06-08 Thread murosa






08/06/2001 13.16
Stephane Faroult
[EMAIL PROTECTED]
08/06/2001 13.11



 Por favor, responda a [EMAIL PROTECTED] 



Remitente [EMAIL PROTECTED]



[EMAIL PROTECTED] wrote:

  Hi folks.

  We  have  installed  four OPS on a Solaris 2.6 cluster. In one of
that
 instances  we  have problems with GV$ views because it returns same
results
 than  V$  views.  Anybody  knows what nappens?. We have Oracle 8.1.6.3
over
 Solaris 2.6 and all instances are working well.

  Thank you very much in advance.

  Miguel.

Miguel,

   How can you manage it ? GV$ view are the same as V$ views, plus one
column giving the instance id (apart from one or two exceptions where
they are strictly synonyms). V$ are in fact built on GV$ using a
condition on the instance id based on userenv('INSTANCEID'). If your
instances do not recognize that they are different instances it's very
serious because your are heading, fast, for data corruption. Check that
all our instances actually share ALL the files which they are supposed
to share.

 Hi Stephane. I agree with you but in some differents views, like
v$session, you can see process for both instances, for instance. That's
our problem. In other hand, don't worry about files in database because
is working well.

 Thank you very much any way.

 Best regards.

 Miguel.

--
Regards,

  Stephane Faroult
  Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  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).
|--|
| Destinatario Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |
| Copia|
|--|





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



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

2001-06-04 Thread murosa


 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
[EMAIL PROTECTED]
01/06/2001 20.06



 Por favor, responda a [EMAIL PROTECTED] 



Remitente [EMAIL PROTECTED]



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).
|--|
| Destinatario Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |
| Copia|
|--|





   
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 

RE: Database writer

2001-06-04 Thread murosa


 You can see that at operating system level using next sentence:

  ps -ef | grep dbwr





04/06/2001 17.55
Kevin Kostyszyn
[EMAIL PROTECTED]
04/06/2001 18.10



 Por favor, responda a [EMAIL PROTECTED] 



Remitente [EMAIL PROTECTED]



Hi all,
 I added db writer processes last week to try and improve performance
of one
of my 8.1.7 db's on NT.  Does anyone know if there is a way to see if
Oracle
actually started the additional db writer processes?  I added
db_writer_processes to the init file, the instance started so I am assuming
that the db writer processes are working.  But we all know what happens
when
we assume something.  Any ideas would be appreciated.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  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).
|--|
| Destinatario Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |
| Copia|
|--|





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



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

2001-06-01 Thread murosa

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