RE: URGENT Help on tracking unauthorized login to Oracle Database

[hemantchitale]

Ashoke,

In chapter 24,  go through :
 "Managing Audit Trail Information"
"Setting Auditing Options"
   "Enabling Audit Options"
"Enabling Statement Privilege Auditing"
You will see this text :
To audit all successful and unsuccessful connections to and disconnections
from the database, regardless of user, BY SESSION (the default and only
value for this option), enter the following statement:


AUDIT SESSION;




I use this query  to report failed login attempts from SYS.AUD$ :
select os_username, username, userhost, terminal, timestamp, returncode
from sys.dba_audit_session
where returncode != 0
order by timestamp
/

(DBA_AUDIT_SESSION is a view on AUD$)



Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"Mandal, Ashoke" <[EMAIL PROTECTED]>   12/02/2002 01:18 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: RE: URGENT Help on tracking unauthorized login to Oracle 

 Database  

   

   

   






Hi Revaldi and Joe (Testa),

I went through the following Administrator's guide.
Oracle8i Administrator's Guide
Release 2 (8.1.6)
Part Number A76956-01
I could only see chapter 24 on 'Auditing database Use' and under that the
following sub-sections. I went through these secition and could not find
anything on unsuccessful login to oracle database. Could you please help me
in ponting to the right chapter/section.
 Guidelines for Auditing
 Creating and Deleting the Database Audit Trail Views
 Managing Audit Trail Information
 Viewing Database Audit Trail Information
 Auditing Through Database Triggers
 Thanks,
 Ashoke


 -Original Message-
 From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]
 Sent: Friday, February 08, 2002 1:29 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: URGENT Help on tracking unauthorized login to Oracle
 Database



 Administrators guide.
 Chapter on auditing.
 Audit session.


 Rivaldi


 -Original Message-
 From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]
 Sent: Friday, February 08, 2002 12:54 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: URGENT Help on tracking unauthorized login to Oracle
 Database





 Joe,


 We referred the auditing option. My understanding is that you can
 track the oracle users using database auditing feature once the users
 are logged into the database.


 But my requirement is to track the users who tried to login to the
 database but could not login due to wrong password.


 For example, somebody may know the connect string for an oracle
 database and trying to login to the database as system user and with
 various combination of password. We like to know who are these users.


 Thanks,
 Ashoke


 -Original Message-
 Sent: Friday, February 08, 2002 11:54 AM
 To: Multiple recipients of list ORACLE-L
 Database





 Administrators guide


 chapter on auditing.


 joe


 Mandal, Ashoke wrote:


 >>Greetings,
 >>
 >>We have a database with very sensitive data. Our management wants me
 to find out the way to secure this data from unauthorized login and
 track these users who tried to login to this database.


 >>
 >>Is there any way we can track the unauthorized users, who try to
 login to an oracle database with invalid userid or password but with
 valid connect string.


 >>
 >>If there is no options under oracle then is there any 3rd party
 software for this purpose.
 >>
 >>Any help is appreciated
 >>
 >>Thanks,
 >>Ashoke
 >>





 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Joseph S Testa
   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 spell

RE: my boss wants a report !!!

[Peter . McLarty]

You might like to try and explain that they might be in perfect health 
today but when someone  next runs some progam module that you have that 
they will not be in "perfect" heath and would need maintenance.

Still I suppose you could do as so many before you have done Yes they are 
in perfect health as of today, and if they do let you go, when they come 
calling for your assistance then make sure you give then consultant rates 
as a big thank you for their past support.

By the way have you had a look at Orasnap it will give you a good set of 
values to put together for them to peruse as  good values today

Cheers 
and have  a good weekend

--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=







"Khedr, Waleed" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
15/02/2002 03:43 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Fax to: 
Subject:RE: my boss wants a report !!!


 Any plans for layoff?!

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/14/02 11:13 PM

list, 
the management has asked me to report the activities i do to make sure
that all the DB's are in perfect health.!! Without being technical the
report
should somehow show the status of the DB's . 

I have decided to devide the report into the following sections

- performance
 how to show the performance of the DB ??? without using 
any
stats .

- storage
 occupied / available

- security
 unauthorized access 

- backup and recovery

 status of the hot standby database. 


could anyone point out some more information to include showing the
"performance" of the DB ?

Regards

Rahul


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  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: Khedr, Waleed
  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).





-- 
This transmission is for the intended addressee only and is confidential information.  
If you have received this transmission in error, please delete it and notify the 
sender.  The contents of this e-mail are the opinion of the writer only and are not 
endorsed by the Mincom Group of companies unless expressly stated otherwise.

-- 
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: my boss wants a report !!!

[Khedr, Waleed]

 Any plans for layoff?!

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/14/02 11:13 PM

list, 
the management has asked me to report the activities i do to make sure
that all the DB's are in perfect health.!! Without being technical the
report
should somehow show the status of the DB's . 

I have decided to devide the report into the following sections

- performance
how to show the performance of the DB ??? without using any
stats .

- storage
occupied / available

- security
unauthorized access 

- backup and recovery

status of the hot standby database. 


could anyone point out some more information to include showing the
"performance" of the DB ?

Regards

Rahul


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  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: Khedr, Waleed
  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).

my boss wants a report !!!

[Rahul]

list, 
the management has asked me to report the activities i do to make sure
that all the DB's are in perfect health.!! Without being technical the
report
should somehow show the status of the DB's . 

I have decided to devide the report into the following sections

- performance
how to show the performance of the DB ??? without using any stats .

- storage
occupied / available

- security
unauthorized access 

- backup and recovery

status of the hot standby database. 


could anyone point out some more information to include showing the
"performance" of the DB ?

Regards

Rahul


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  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: DB sizing - whitepaper

[rpapnoi]

Bjørn & David
Thanks for your replies.
In reply to the question "How you plan the Database sizing for a given
application?", I answered and explained about the application development
from preliminary study to final implementation. which covered creation of
schema,tablespaces,objects,storage parameters, access rights etc. Do you
think I was wrong somewhere?
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet["Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>]

Ramesh,

I still don't know exactly what you mean by 'database sizing'.  If what
you really mean is 'disk capacity', the most important factor today is
the number of I/O's available on your most active tablespaces and the
redo log files.  Frequently, you end up with a situation, that your disk
capacity measured in GB is easily fulfulled using just a few physical
drives, but your I/O requirements cannot be fulfilled with such a setup.
 Disks of 50 or even 100 Gb, which are getting common these days are
simply too big as you end up with too few of them, but it can be really
hard to argue with your purchising division that you need 1Tb of disk if
you are only storing 100Gb.  So you need to argue that you need 500
I/O's per second and lie about the number of GBs you get.

And again - you are back to the application, and the only real way to
get to a number of necessary I/O's is testing.  If your application is
very well written, you should have good chance of extrapolating from a
small test setup to a large production environment, but unfortunately,
applications are not always well written...

Thanks, Bjørn.

[EMAIL PROTECTED] wrote:

>Bjørn
>What you say is true. Now my question is What should be the answer to the
>question "How you plan the Database sizing for a given application?". I faced
>it in a DBA interview. I did mention about the requied tablespaces, storage
>parameters etc depending on Application size. Am I missing something?
>Seniors, please advice.
>
>Regards,
>Ramesh D Papnoi
>Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
>(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
>http://www22.Brinkster.com/rpapnoi
>
>-- Original Text --
>
>To: internet["Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>]
>
>Ramesh,
>
>I presume you are looking for something to tell you how to configure a
>database server, and such a thing does not exist.  Period.
>
>The real answer is, that this is far too application dependent, and that
>only the application developers can provide anything of this kind.  And
>even in this case, such configuration guides are often more misleading
>than guiding.  There have been attempts at making rules like "this
>application is like X tpc-c transactions", but they also fail to be of
>any actual value.
>
>Also, if what you really were looking for was something to tell you the
>size (in GB) of the required disk to store schema with a certain
>definition, you could create some rough estimates.  However, with todays
>typical disksizes, you run out of spindles much before you run out of GB.
>
>Thanks, Bjørn.
>
>[EMAIL PROTECTED] wrote:
>
>>Hi Gurus,
>>Can anybody mail me the the whitepaper/policy document on database sizing?
>>Thanks in advance.
>>
>>Regards,
>>Ramesh D Papnoi
>>Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
>>(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
>>http://www22.Brinkster.com/rpapnoi
>>
>
>



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

Oracle 9i SQL Exam

[ltiu]

Hello,

Can anybody give me tips on what to study for the Intro to 9i SQL Exam (first 
exam in the OCA track). I've read through the exam objectives and it seems 
that 90% of the exam will be questions about "select statements". Is this 
really all that the exam has?

Thanks.

ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  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: RE: Rollback Segment Problem

[K Gopalakrishnan]

Gogala,

THe column you are looking is not the actual one. I have overlooked your
post and thought you are right. Now I have decided to test myself and here 
is the result.


SQL> select max(ktuxesqn) from X$KTuxe;

MAX(KTUXESQN)
-
  956

SQL> startup force pfile=c:\orawin\admin\test\pfile\init.ora
ORACLE instance started.

Total System Global Area   97283948 bytes
Fixed Size   282476 bytes
Variable Size  62914560 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select max(ktuxesqn) from X$KTuxe;

MAX(KTUXESQN)
-
  956

It is not getting changed by startup force.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L


Number of wraps gets reset with the instance. Below is the proof.
May be after the death of a rollback segment, when can have it's 
resurrection? What would we name it? A vampire rollback segment?
May be we should use documented V$ tables instead of the undocumented
X$ ones.


pdev3-a:dev:/oracle> sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 14 17:26:02 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SQL>
SQL>
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  2
 3  3
 4  3
 5  2
 6  2

6 rows selected.

SQL> sshutdown immediate
SP2-0734: unknown command beginning "sshutdown ..." - rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  114231784 bytes
Fixed Size   104936 bytes
Variable Size  80039936 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  0
 3  0
 4  0
 5  0
 6  0

6 rows selected.

SQL>

-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number is not very accurate.. okay,, some number)
> transactions.
> THis is the only case I need to drop and recreate them.
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mohammad
> Rafiq
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Multiple recipients of list ORACLE

RE: Rows Locked

[K Gopalakrishnan]

There is no simple way unless the some other process is waiting for those
rows. In that case that is visible in V$SESSION.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mascranghe
Sent: Thursday, February 14, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L



Is there a way to find out what rows are being locked ?

Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alroy Mascranghe
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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).

Rows Locked

[Alroy Mascranghe]

Is there a way to find out what rows are being locked ?

Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alroy Mascranghe
  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: RE: Rollback Segment Problem

[K Gopalakrishnan]

Thanks Waleed,

I have decided to test myself.

Here is the result:

SQL> select max(ktuxesqn) from X$KTuxe;

MAX(KTUXESQN)
-
  956

SQL> startup force pfile=c:\orawin\admin\test\pfile\init.ora
ORACLE instance started.

Total System Global Area   97283948 bytes
Fixed Size   282476 bytes
Variable Size  62914560 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select max(ktuxesqn) from X$KTuxe;

MAX(KTUXESQN)
-
  956

So it is not cleared by doing a shutdown.



Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Waleed
Sent: Thursday, February 14, 2002 6:23 PM
To: Multiple recipients of list ORACLE-L


The wrap# you're both talking about are completely different.

The wrap# that K Gopal means (that sequence number in the X$) is a
sequence number that keeps incrementing for every transaction happening in
that transaction slot.

It never gets reset.

I remember reading when it reaches the higher limit, the RBS needs to be
dropped.

It's easy to test:

Get the segment number for  one of the rollback segments.
List the sequence numbers for all the slots in that RBS
using:
select ktuxesqn from x$ktuxe where ktuxeusn = the segment_number_for_the_RBS

SET transaction use rollback segment 
DO some inserts , updates
Commit;

select ktuxesqn from x$ktuxe where ktuxeusn = the segment_number_for_the_RBS

You will see that one of the numbers got incremented.

restart the database.

select ktuxesqn from x$ktuxe where ktuxeusn = the segment_number_for_the_RBS

Nothing changed.


Regards,

Waleed

-Original Message-
Sent: Thursday, February 14, 2002 7:13 PM
To: Multiple recipients of list ORACLE-L


Thanks for the correction. I was looking some other column.
I am sorry for the mistake.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L


Number of wraps gets reset with the instance. Below is the proof.
May be after the death of a rollback segment, when can have it's
resurrection? What would we name it? A vampire rollback segment?
May be we should use documented V$ tables instead of the undocumented
X$ ones.


pdev3-a:dev:/oracle> sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 14 17:26:02 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SQL>
SQL>
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  2
 3  3
 4  3
 5  2
 6  2

6 rows selected.

SQL> sshutdown immediate
SP2-0734: unknown command beginning "sshutdown ..." - rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  114231784 bytes
Fixed Size   104936 bytes
Variable Size  80039936 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  0
 3  0
 4  0
 5  0
 6  0

6 rows selected.

SQL>

-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is lim

Optimizer and function based index

[Seefelt, Beth]

Hi everybody,

I'm hoping someone can help me understand this.

I have this query -

SELECT ORDERID FROM WWW_SHOPCART 
WHERE UPPER(MEMBERNAME) ='19891' ;

I added an index on the column UPPER(MEMBERNAME) and it works great.

I have another query -

SELECT ORDERID FROM WWW_SHOPCART 
WHERE UPPER(MEMBERNAME) ='19891'  OR UPPER(MEMBERNAME)='198915';

and this query will not use the index at all.  

I can't understand why the optimizer won't choose to use the function based index when 
there is an OR clause.  I've tried the same query with just MEMBERNAME= and using an 
index on MEMBERNAME, and the optimizer will use the  index if I OR my criteria 
together.

Any ideas?

Thanks,

Beth

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  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: DBA-Database Storage using Net Appliance

[DENNIS WILLIAMS]

Rich - We use Net Appliance as additional storage on our test system (Compaq
Tru64 / Oracle 8.1.6). I believe the Net Appliance has a dedicated 100-meg
Ethernet connection. It seems to work pretty good, but my experience is that
you can overload the I/O channel. Once, I set a large database up to rebuild
6 or so indexes. Both the indexes and the tables were on the NetApp. On our
regular RAID-5 drives, I estimated that would have taken 4-5 hours. I
started this before I went home. Imagine my surprise the next morning when
none of the indexes had finished. Since then, I have tended to move the
table or index to regular disk, and build one index at a time. Performance
seems to be fine if I do that. Our users haven't complained about
performance, but they haven't subjected it to heavy usage. 
From my admittedly meager experience, I would say that if you are
planning to use the Net Appliance for your test system or for some type of
low-activity storage, it would probably be fine. I wouldn't plunge in and
bet my job on the Net Appliance performance on high-activity OLTP tables
until I had a chance to test it thoroughly.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, February 14, 2002 4:41 PM
To: Multiple recipients of list ORACLE-L


NetApp Filers use WAFL (Write Anywhere File Layout.  WAFL is similar to
other Unix filesystems like FFS in that it's a block-based file system
using inodes to describe files.  It uses 4K blocks with no
fragmentation.  Each WAFL inode has 16 block pointers that point to data
blocks.  Unlike FFS, all the block pointers in a WAFL inode refer to
blocks at the same level.  For files smaller than 64K the 16 inode
blocks point to data blocks.  Larger files use indirect pointers (inode
blocks point to other inode blocks).  Very large files use double
inderect pointers (inode -> inode -> inode -> data).  Very small files
use the inode blocks themselves instead of the block pointers.

WAFL stores file system metadata in files (inode file, block-map file,
and inode-map file.  Keeping this data in files allows the Filer to
write the data anywhere on the disk (rather than to a "superblock" like
FFS), which is where the WAFL name comes from.  This also allows the
Filer to schedule writes to the same RAID stripe to avoid the 4-1 write
penalty you usually incur when you update a single block in a stripe.

Other nice features from a sysadmin point of view are the fact that the
Filer will automatically increase the size of your filesystem when you
add another disk, and the use of snapshots.  Snapshots are really cool
if you haven't seen them before.  Basically from the point in time the
snapshot is taken, the filesystem has to write all new data (including
meta-data) to new locations on the disk instead of overwriting the old
data.  If WAFL used a superblock like FFS, this wouldn't be possible.
If data is changed, the Filer uses a copy-on-write technique to keep the
old block avialable for any snapshots which reference it.

I've never used a Filer for Oracle applications; I've only used EMC due
to the size & availability requirements of the implementations I've
worked on, but I know it's been done by others.

If you poke around at http://www.netapp.com/ you can probably find Dave
Hitz' original white papers on WAFL and the design of the filer
(formerly called FAServer) if this sort of thing interests you.

Rich
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of
Berkmeyer,
> Sue
> Sent: Thursday, February 14, 2002 10:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: DBA-Database Storage using Net Appliance
> 
>   Hi Everyone,
> 
>   I am getting pressure from the system guys to use a Net
Appliance
> filer for Oracle Applications databases.  I currently have the Apps
> Release
> 11.0.3 production database on a Sun E4500, 4G RAM, 6CPU@400Mhz and a
Sun
> storage array with a mix of 4 and 9G drives.  The production datafiles
are
> on Raid 0+1.  The production software is mirrored only.  Sequential
files
> are not "raided".  I have gone out to the Net Appliance web site and
have
> download papers about how to implement Oracle on the filer.  I would
like
> to
> hear from real users rather than the vendor about how this works.
> Therefore
> I am curious to find out anyone's experience with this storage
technology
> -
> good or bad.  If anyone has any insights about the Net Appliance
> technology
> itself i.e. raid level, etc. that would be great too.  We are also
> considering a new Sun direct attached storage solution.  Thanks for
your
> time.
> 
> National Renewable Energy Laboratory
> Sue Ellen Berkmeyer
> Database Administrator
> Phone:  303-275-4143
> Fax:  303-275-3603
> E-mail:   [EMAIL PROTECTED]
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Berkmeyer, Sue
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  F

RE: RE: Rollback Segment Problem

[Khedr, Waleed]

The wrap# you're both talking about are completely different.

The wrap# that K Gopal means (that sequence number in the X$) is a
sequence number that keeps incrementing for every transaction happening in
that transaction slot.

It never gets reset.

I remember reading when it reaches the higher limit, the RBS needs to be
dropped.

It's easy to test:

Get the segment number for  one of the rollback segments.
List the sequence numbers for all the slots in that RBS
using:
select ktuxesqn from x$ktuxe where ktuxeusn = the segment_number_for_the_RBS

SET transaction use rollback segment 
DO some inserts , updates
Commit;

select ktuxesqn from x$ktuxe where ktuxeusn = the segment_number_for_the_RBS

You will see that one of the numbers got incremented.

restart the database.

select ktuxesqn from x$ktuxe where ktuxeusn = the segment_number_for_the_RBS

Nothing changed.


Regards,

Waleed

-Original Message-
Sent: Thursday, February 14, 2002 7:13 PM
To: Multiple recipients of list ORACLE-L


Thanks for the correction. I was looking some other column.
I am sorry for the mistake.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L


Number of wraps gets reset with the instance. Below is the proof.
May be after the death of a rollback segment, when can have it's 
resurrection? What would we name it? A vampire rollback segment?
May be we should use documented V$ tables instead of the undocumented
X$ ones.


pdev3-a:dev:/oracle> sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 14 17:26:02 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SQL>
SQL>
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  2
 3  3
 4  3
 5  2
 6  2

6 rows selected.

SQL> sshutdown immediate
SP2-0734: unknown command beginning "sshutdown ..." - rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  114231784 bytes
Fixed Size   104936 bytes
Variable Size  80039936 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  0
 3  0
 4  0
 5  0
 6  0

6 rows selected.

SQL>

-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number

RE: looking for job

[Randy Kirkpatrick]

Surendra,

Sorry, I don't know of any jobs for you ... Do you live in the New Jersey
area?I'm looking myself, actually.

I have a question about Sony in New Jersey ... I "hear" they're doing some
SAP work, and I was wondering if you know of any positions either available
or opening up for SAP Basis or SAP Basis/APO Contractors. Do you know
anything about the project?

Randy Kirkpatrick
home: (303)772-7467
cell: (303)885-2102




-Original Message-
Surendra
Sent: Thursday, February 14, 2002 8:29 AM
To: Multiple recipients of list ORACLE-L


Hi List,

I am sorry to post this OT request.But considering the job market outside, I
am tempted to give a try.
I will be coming out of my project by the end of this month.
Please mail me at [EMAIL PROTECTED], if you have any Oracle DBA
openings.

Thanks,
Surendra
Consultant DBA
Sony, NJ-USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tirumala, Surendra
  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: Randy Kirkpatrick
  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: ERR: ORA-04031 unable to allocate

[Jared . Still]

see 
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=146599.1

Jared







"Baker, Barbara" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/14/02 04:03 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:ERR:  ORA-04031 unable to allocate


Oracle 8.0.5
Solaris 2.6

List:
One of our users is getting this error message running a query:

ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory ("shared
pool","unknown object","cursor work he","KKRH Hash Table")

The query is very simple (see below).  Happens consistently.  Error occurs
after about 1 minute of execution.  No other problems in the database (no
errors in alert, etc.)

I'm seeing latch wait this for the sid involved:





  SID EVENTP1TEXT  P1 P2TEXT P2 P3TEXT
P3
-  -- ---   
--
  409 latch free   address 2147519876 number 59 tries
0
1 pmon timer   duration   300 0
0
6 smon timer   sleep time 300 failed  0
0



and then I see this for the same sid in v$lock (resource is type+id1+id2,
query is from Steve Adams' site)




RESOURCE  NSID  SID HOLDING WANTINGSECONDS
 -  --- --- --
CU--1595636348-0   409  409   X  0
RT-1-0   4 LGWR   X  0
TS-1-8388610 6 SMON  SX  55604



According to Anjo Kolk's description, a CU is a Bind enqueue.  Does this
mean I'm running out of open_cursors?? (And if so, why are no other
processes affected?)

Anyone seen this one before?

Thanks for any help!
Barb


Here's the query:

select distinct
v.sales_id,
a.receiver,
a.adno,
a.unet,
a.vno,
a.enddate
from advdb.ad a,
 advdb.pub p,
 advdb.voluntary_reps v
where a.adno = p.adno
and a.vno = p.vno
and a.receiver = v.name
and p.state = 'VAR'
and p.vnoflag = 'Y'

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  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: 
  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: ORA-04031 unable to allocate

[Vergara, Michael (TEM)]

Barbara:

You need to:
1)  Have the user log out, log back on, and try again.  If that
fails ...
2)  Bounce the instance.  Before you restart, you should ...
3)  Increase the size of your shared pool, and maybe ...
4)  Increase the open_cursors parameter value.  The Open_Cursors
parameter is a *session* parameter, not an *instance* 
parameter, so this user may really be running out of cursors.

The message seems to indicate that it's trying to allocate
space for a hash join, and it cannot.  You might check the
value of hash_area_size, and maybe increase that, too.

HTH,
Mike

-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Oracle 8.0.5
Solaris 2.6

List:
One of our users is getting this error message running a query:

ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory ("shared
pool","unknown object","cursor work he","KKRH Hash Table")

The query is very simple (see below).  Happens consistently.  Error occurs
after about 1 minute of execution.  No other problems in the database (no
errors in alert, etc.)

I'm seeing latch wait this for the sid involved:





  SID EVENTP1TEXT  P1 P2TEXT P2 P3TEXT
P3
-  -- ---   
--
  409 latch free   address 2147519876 number 59 tries
0
1 pmon timer   duration   300 0
0
6 smon timer   sleep time 300 failed  0
0



and then I see this for the same sid in v$lock (resource is type+id1+id2,
query is from Steve Adams' site)




RESOURCE  NSID  SID HOLDING WANTINGSECONDS
 -  --- --- --
CU--1595636348-0   409  409   X  0
RT-1-0   4 LGWR   X  0
TS-1-8388610 6 SMON  SX  55604



According to Anjo Kolk's description, a CU is a Bind enqueue.  Does this
mean I'm running out of open_cursors?? (And if so, why are no other
processes affected?)

Anyone seen this one before?

Thanks for any help!
Barb


Here's the query:

select distinct
v.sales_id,
a.receiver,
a.adno,
a.unet,
a.vno,
a.enddate
from advdb.ad a,
 advdb.pub p,
 advdb.voluntary_reps v
where a.adno = p.adno
and a.vno = p.vno
and a.receiver = v.name
and p.state = 'VAR'
and p.vnoflag = 'Y'
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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).

Oracle Advanced Replication

[Peter Barnett]

We are looking at Advanced Replication as a fail over
option for a web site.  Straight forward installation,
both boxes on the same subnet on their own dmz. The
servers will be located on the same rack in the
computer room. Very few tables storing data from an
application that is tracking click through data.

Does anyone see any flaws with the basic plan?  Any
hidden 'features' that we may run into?

Thanks



=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  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: ora -01122

[Hamid Alavi]

also this one from alert.log

CKPT: terminating instance due to error 1242
Instance terminated by CKPT, pid = 3130
Thu Feb 14 10:21:05 2002


-Original Message-
Sent: Thursday, February 14, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


[Hamid Alavi]
> Database shutdown by itseld(don't know why) then I try to started get the
> error for datafile.

Anything helpful in the alert log?  Like, I/O errors during archiving
so once all online redo logs needed archiving, the instance stopped
accepting transactions?  Just a guess
-- 
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  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).
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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).

another security issue with Oracle 9.x

[Jacques Kilchoer]

Title: another security issue with Oracle 9.x





I hate to seem overly "alarmist", but in addition to the SNMP security issue mentioned already, I have read of this problem discovered by Next Generation Security Software Ltd. in Sutton, England:

http://www.nextgenss.com/advisories/oraplsextproc.txt


<<>

(more details at the link)

RE: ora -01122

[Hamid Alavi]

Here is the result of all trace file & log file:

/u01/app/oracle/admin/HNCMS/bdump/hncms_ckpt_3130.trc
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /u01/app/oracle
System name:SunOS
Node name:  hollywood
Release:5.7
Version:Generic_106541-11
Machine:sun4u
Instance name: HNCMS
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 3130, image: oracle@hollywood (CKPT)

*** 2002-02-14 10:11:57.677
*** SESSION ID:(4.1) 2002-02-14 10:11:57.635
error 1242 detected in background process


-

Really appreciate your help.
I just want to open the database, then I can restore the file from full
export.


-Original Message-
Sent: Thursday, February 14, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


[Hamid Alavi]
> Database shutdown by itseld(don't know why) then I try to started get the
> error for datafile.

Anything helpful in the alert log?  Like, I/O errors during archiving
so once all online redo logs needed archiving, the instance stopped
accepting transactions?  Just a guess
-- 
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  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).
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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).

ERR: ORA-04031 unable to allocate

[Baker, Barbara]

Oracle 8.0.5
Solaris 2.6

List:
One of our users is getting this error message running a query:

ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory ("shared
pool","unknown object","cursor work he","KKRH Hash Table")

The query is very simple (see below).  Happens consistently.  Error occurs
after about 1 minute of execution.  No other problems in the database (no
errors in alert, etc.)

I'm seeing latch wait this for the sid involved:





  SID EVENTP1TEXT  P1 P2TEXT P2 P3TEXT
P3
-  -- ---   
--
  409 latch free   address 2147519876 number 59 tries
0
1 pmon timer   duration   300 0
0
6 smon timer   sleep time 300 failed  0
0



and then I see this for the same sid in v$lock (resource is type+id1+id2,
query is from Steve Adams' site)




RESOURCE  NSID  SID HOLDING WANTINGSECONDS
 -  --- --- --
CU--1595636348-0   409  409   X  0
RT-1-0   4 LGWR   X  0
TS-1-8388610 6 SMON  SX  55604



According to Anjo Kolk's description, a CU is a Bind enqueue.  Does this
mean I'm running out of open_cursors?? (And if so, why are no other
processes affected?)

Anyone seen this one before?

Thanks for any help!
Barb


Here's the query:

select distinct
v.sales_id,
a.receiver,
a.adno,
a.unet,
a.vno,
a.enddate
from advdb.ad a,
 advdb.pub p,
 advdb.voluntary_reps v
where a.adno = p.adno
and a.vno = p.vno
and a.receiver = v.name
and p.state = 'VAR'
and p.vnoflag = 'Y'

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  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: Re[2]: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

[Peter . McLarty]

As I have done a bit of networking and set up stuff to monitor equipment 
with SNMP I will confirm that SNMP uses a port that the snmpd or 
equivalent listens to and then passes the request to the appropriate 
process depending on what is registered with the snmpd. This is usually 
done on unix if I remember using /etc/.snmp/conf. If really interested 
start looking in man snmpd 

Yes Oracle itself may not be vunerable but depending on the OS and system 
patches snmpd on that system may be vunerable so if your network engineers 
that did your firewalling are less than you hoped for you probably will 
have trouble. If your firewall is sound then I cant see this being a 
problem. your biggest worry in any site is the perimeter router as it 
nearly always has SNMP turned on for monitoring purposes and tools such as 
HP Openview to manage these. and you will have snmp open  over the 
firewall between this router and the monitoring station /Openview system. 
Good firewall rules should protect you, but that is for your network 
engineers to decide.

HTH

Cheers


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=







[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
15/02/2002 08:41 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Fax to: 
Subject:Re[2]: [[EMAIL PROTECTED]: SANS FLASH ALERT: Widespread SNMP Vul


Ray,

No, but I do have a SA who believes that to be true.  I'll try to 
explain it
as he did. 

The DBSNMP agent registers a MIB with the snmp agent.  It is the snmp 
agent
that has the interface to the world.  As he put it, it's not the back end 
that
has the problem, but the front end that faces the network, namely the snmp
agent.

As to your nervousness, our facilities folks are using the back of my 
chair
as a paint shaker.

Dick Goulet

Reply Separator
Author: Ray Stell <[EMAIL PROTECTED]>
Date:   2/14/2002 12:18 PM



Dick, does this mean that you have firsthand knowledge that 
the oracle's snmp code is free from the underlying vulnerabilities?
There was no mention of Oracle in the advisory.  This could mean 
that they did not respond or they are not vulnerable.

I posted to the Oracle Networking Technical Forum yesterday on this
issue, but there has been no Oracle Corp response.  You can search
for SNMP to follow their response.

Joan, Dick is certainly correct here with respect to the the system snmp
agent.  The sysadmins need to address this by either patching or disabling
snmpd.  However, unless Oracle confirms they did not use the old flawed 
code, 
I don't see any reason to assume their product is not vulnerable.  Until
they do, I will:

1) be nervous, 
2) bug oracle corp, 
3) confirm ip filter rules,
4) study dbsnmp






On Thu, Feb 14, 2002 at 09:53:37AM -0800, [EMAIL PROTECTED] wrote:
> Joan,
> 
> The Oracle intelligent agent which uses dbsnmp is not the problem 
here. 
The
> real problem is the snmp agent that is running on the computer and owned 
by
> root.  Therefore your SA needs to do something, not you.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Joan Hsieh <[EMAIL PROTECTED]>
> Date:   2/14/2002 7:48 AM
> 
> Hi Ray,
> 
> We use dbsnmp on the production server. How it will affect us? Our
> system people sent us the same article to us and very concerned the
> security.
> 
> Joan
> 
> Ray Stell wrote:
> > 
> > Oracle does not seem to be listed, but you got to wonder what code
> > they based their snmp stuff on.  You may want to nudge you sysadmin
> > in the ribs, also.
> > 
> > - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> > 
> > Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> > To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> > 
> > SANS FLASH ALERT: Widespread SNMP Vulnerability
> > 1:30 PM EST 12 February, 2002
> > 
> > To: Ray Stell (SD569668)
> > 
> > Note: This is preliminary data! If you have additional information,
> > please send it to us at [EMAIL PROTECTED]
> > 
> > In a few minutes wire services and other news sources will begin
> > breaking a story about widespread vulnerabilities in SNMP (Simple
> > Network Management Protocol).  Exploits of the vulnerability cause
> > systems to fail or to be taken over.  The vulnerability can be found 
in
> > more than a hundred 

RE: ora -01122

[DBarbour]

Just thinking out loud here (anybody feel free to jump in on this) - if
you've still got your redo logs, you might be able to try a datafile
recovery.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
- Forwarded by David Barbour/CAC/AISD on 02/14/2002 04:51 PM -
   

David Barbour  

 To: [EMAIL PROTECTED]  

02/14/2002   cc:   

03:50 PM Subject: RE: ora -01122(Document link: 
David Barbour) 
   

   




Did you make the export before or after the crash?  What does your alert
log say?  Any trace files generated in cdump, udump, bdump?  Any system
error messages generated?  Without being in archivelog mode, given the
information you've provided, your only course may be to restore the export.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
 
Hamid Alavi
 
   
ovadx.com>cc:  
 
Sent by:  Subject: RE: ora -01122  
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
02/14/2002 
 
02:38 PM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi,
Database shutdown by itseld(don't know why) then I try to started get the
error for datafile.
We are running oracle 8.1.6 on unix the only backup which i have is full
export from the instance(including all schema's).
We are in development phase and not running archivelog mode.
My last backup was at 10:00 AM today.
Thanks all for your help.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L



Well, looks like you have a recovery scenario on your hands.  What version
of Oracle are you on?  What is your Operating System/platform?  In what
manner did the database stop that now requires you to start it up?  Are you
in archivelog mode?  When was you last backup?  Was it hot or cold?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




Hamid Alavi


ovadx.com>cc:

Sent by:  Subject: ora -01122

[EMAIL PROTECTED]

m





02/14/2002

01:03 PM

Please respond

to ORACLE-L









Hi list,
I have an urgent problem for startup database when I try to stratup
database
I get this error:
ora-01122 database file 29 failed verification check
ora-01110 data file 29 databaseQDX.dbf
ora-01251 unknown file header version read for file 29

Please if any  body have any idea is very very urget
Thanks


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error

RE: RE: Rollback Segment Problem

[K Gopalakrishnan]

Thanks for the correction. I was looking some other column.
I am sorry for the mistake.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L


Number of wraps gets reset with the instance. Below is the proof.
May be after the death of a rollback segment, when can have it's 
resurrection? What would we name it? A vampire rollback segment?
May be we should use documented V$ tables instead of the undocumented
X$ ones.


pdev3-a:dev:/oracle> sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 14 17:26:02 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SQL>
SQL>
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  2
 3  3
 4  3
 5  2
 6  2

6 rows selected.

SQL> sshutdown immediate
SP2-0734: unknown command beginning "sshutdown ..." - rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  114231784 bytes
Fixed Size   104936 bytes
Variable Size  80039936 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  0
 3  0
 4  0
 5  0
 6  0

6 rows selected.

SQL>

-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number is not very accurate.. okay,, some number)
> transactions.
> THis is the only case I need to drop and recreate them.
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mohammad
> Rafiq
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback Segment Problem
>
>
> In many cases you will have to take RB segments offline
> and drop them, then
> re-create
>


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
  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 m

RE: ora -01122

[Hamid Alavi]

I have a dump file before the crash, but the problem is I can not even open
the database, I just need to open it that's it.


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L



Did you make the export before or after the crash?  What does your alert
log say?  Any trace files generated in cdump, udump, bdump?  Any system
error messages generated?  Without being in archivelog mode, given the
information you've provided, your only course may be to restore the export.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

Hamid Alavi

   
ovadx.com>cc:

Sent by:  Subject: RE: ora -01122

[EMAIL PROTECTED]

m

 

 

02/14/2002

02:38 PM

Please respond

to ORACLE-L

 

 





Hi,
Database shutdown by itseld(don't know why) then I try to started get the
error for datafile.
We are running oracle 8.1.6 on unix the only backup which i have is full
export from the instance(including all schema's).
We are in development phase and not running archivelog mode.
My last backup was at 10:00 AM today.
Thanks all for your help.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L



Well, looks like you have a recovery scenario on your hands.  What version
of Oracle are you on?  What is your Operating System/platform?  In what
manner did the database stop that now requires you to start it up?  Are you
in archivelog mode?  When was you last backup?  Was it hot or cold?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




Hamid Alavi


ovadx.com>cc:

Sent by:  Subject: ora -01122

[EMAIL PROTECTED]

m





02/14/2002

01:03 PM

Please respond

to ORACLE-L









Hi list,
I have an urgent problem for startup database when I try to stratup
database
I get this error:
ora-01122 database file 29 failed verification check
ora-01110 data file 29 databaseQDX.dbf
ora-01251 unknown file header version read for file 29

Please if any  body have any idea is very very urget
Thanks


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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:
  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).
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538

RE: HOW TO MAKE FAST EXPORT

[Jacques Kilchoer]

Title: RE: HOW TO MAKE FAST EXPORT





You're right (someone else had made the same comment.) I missed the word "reorganising" in the original e-mail. My apologies.

> -Original Message-
> From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
> 
> I used transportable tablespace to do this. It is fast, however, it
> didn't serve the reorg purpose. It rebuild all the objects exactly as
> same structure as original.

RE: wrong result from select

[Alexander . Feinstein]

Title: RE: wrong result from select





Thanks everyone.
Bug# 2225065 Assigned to Development.
Alex.


-Original Message-
From: Alexander Feinstein 
Sent: Friday, February 08, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: wrong result from select



Hi, 
Can anybody try this on 9i? 
set echo on 
alter session set optimizer_mode=choose; 
alter session set cursor_sharing=force; 
create table tb1 (f1 number(4)); 
insert into tb1 values (1999); 
insert into tb1 values (2000); 
insert into tb1 values (2001); 
insert into tb1 values (2002); 
commit; 
select * from tb1; 
analyze table tb1 compute statistics; 
select f1 from tb1 where f1 between 2000 and 2000; 
select f1 from tb1 where f1 between 2000 and 2001; 
select f1 from tb1 where f1 between 2001 and 2000; 
drop table tb1; 
Here is what I got on 8.1.7.2.1 64bit on HP-UX 11.0: 
SQL> select * from tb1; 
    F1 
-- 
  1999 
  2000 
  2001 
  2002 
SQL> select f1 from tb1 where f1 between 2000 and 2000; 
    F1 
-- 
  2000 
SQL> select f1 from tb1 where f1 between 2000 and 2001; 
    F1 
-- 
  2000 
SQL> select f1 from tb1 where f1 between 2001 and 2000; 
    F1 
-- 
  2001 
TIA 
Alex. 
PS. What about cursor_sharing=similar ? 

RE: RE: Rollback Segment Problem

[Gogala, Mladen]

Number of wraps gets reset with the instance. Below is the proof.
May be after the death of a rollback segment, when can have it's 
resurrection? What would we name it? A vampire rollback segment?
May be we should use documented V$ tables instead of the undocumented
X$ ones.


pdev3-a:dev:/oracle> sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 14 17:26:02 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

SQL>
SQL>
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  2
 3  3
 4  3
 5  2
 6  2

6 rows selected.

SQL> sshutdown immediate
SP2-0734: unknown command beginning "sshutdown ..." - rest of line ignored.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  114231784 bytes
Fixed Size   104936 bytes
Variable Size  80039936 bytes
Database Buffers   33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> select usn,wraps from v$rollstat;

   USN  WRAPS
-- --
 0  0
 2  0
 3  0
 4  0
 5  0
 6  0

6 rows selected.

SQL>

-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number is not very accurate.. okay,, some number)
> transactions.
> THis is the only case I need to drop and recreate them.
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mohammad
> Rafiq
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback Segment Problem
>
>
> In many cases you will have to take RB segments offline
> and drop them, then
> re-create
>


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
  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 

Re: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

[Ray Stell]

I hadn't seen this text, where did you get it?
They still have not responded to Doc ID: 189174.995




On Thu, Feb 14, 2002 at 01:26:57PM -0800, Joan Hsieh wrote:
> Hello,
> 
> This is what oracle responsed;
> 
> 1. EM does not use SNMP at all for its own functionality -- therefore
> EM
> proper is not affected by these findings.
> 
> 2. The EM agent can be optionally used as an SNMP subagent that
> services
> the public and Oracle-specific database MIBs. 
> 
> 3. Intensive testing on this vulnerability has determined that there
> is
> minimal
> risk involved to EM users. EM does not require SNMP out-of-box -- use
> of
> SNMP with the agent is optional. The worst case scenario is a denial
> of
> service attack against the Agent, resulting in an Agent core dump.
> This
> risk is
> only apparent when the Agent is configured to use SNMP. 
> 
> Please note that the Agent installation is typically behind a
> firewall
> and the Agent does not listen
> to Internet traffic, further reducing the likelihood of external
> tampering.
> Additionally, there does not seem to be any potential for
> unauthorized
> privilege access, any capability to run external code, or an affect
> on
> other services on the node.
> 
> Oracle will be releasing a formal Oracle Security Alert this week
> with
> information regarding patching, backporting, etc. 
> 
> Ray Stell wrote:
> > 
> > Dick, does this mean that you have firsthand knowledge that
> > the oracle's snmp code is free from the underlying vulnerabilities?
> > There was no mention of Oracle in the advisory.  This could mean
> > that they did not respond or they are not vulnerable.
> > 
> > I posted to the Oracle Networking Technical Forum yesterday on this
> > issue, but there has been no Oracle Corp response.  You can search
> > for SNMP to follow their response.
> > 
> > Joan, Dick is certainly correct here with respect to the the system snmp
> > agent.  The sysadmins need to address this by either patching or disabling
> > snmpd.  However, unless Oracle confirms they did not use the old flawed code,
> > I don't see any reason to assume their product is not vulnerable.  Until
> > they do, I will:
> > 
> > 1) be nervous,
> > 2) bug oracle corp,
> > 3) confirm ip filter rules,
> > 4) study dbsnmp
> > 
> > On Thu, Feb 14, 2002 at 09:53:37AM -0800, [EMAIL PROTECTED] wrote:
> > > Joan,
> > >
> > > The Oracle intelligent agent which uses dbsnmp is not the problem here.  The
> > > real problem is the snmp agent that is running on the computer and owned by
> > > root.  Therefore your SA needs to do something, not you.
> > >
> > > Dick Goulet
> > >
> > > Reply Separator
> > > Author: Joan Hsieh <[EMAIL PROTECTED]>
> > > Date:   2/14/2002 7:48 AM
> > >
> > > Hi Ray,
> > >
> > > We use dbsnmp on the production server. How it will affect us? Our
> > > system people sent us the same article to us and very concerned the
> > > security.
> > >
> > > Joan
> > >
> > > Ray Stell wrote:
> > > >
> > > > Oracle does not seem to be listed, but you got to wonder what code
> > > > they based their snmp stuff on.  You may want to nudge you sysadmin
> > > > in the ribs, also.
> > > >
> > > > - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> > > >
> > > > Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> > > > To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> > > >
> > > > SANS FLASH ALERT: Widespread SNMP Vulnerability
> > > > 1:30 PM EST 12 February, 2002
> > > >
> > > > To: Ray Stell (SD569668)
> > > >
> > > > Note: This is preliminary data! If you have additional information,
> > > > please send it to us at [EMAIL PROTECTED]
> > > >
> > > > In a few minutes wire services and other news sources will begin
> > > > breaking a story about widespread vulnerabilities in SNMP (Simple
> > > > Network Management Protocol).  Exploits of the vulnerability cause
> > > > systems to fail or to be taken over.  The vulnerability can be found in
> > > > more than a hundred manufacturers' systems and is very widespread -
> > > > millions of routers and other systems are involved.
> > > >
> > > > As one of the SANS alumni, your leadership is needed in making sure that
> > > > all systems for which you have any responsibility are protected. To do
> > > > that, first ensure that SNMP is turned off. If you absolutely must run
> > > > SNMP, get the patch from your hardware or software vendor. They are all
> > > > working on patches right now. It also makes sense for you to filter
> > > > traffic destined for SNMP ports (assuming the system doing the filtering
> > > > is patched).
> > > >
> > > > To block SNMP access, block traffic to ports 161 and 162 for tcp and
> > > > udp.  In addition, if you are using Cisco, block udp for port 1993.
> > > >
> > > > The problems were caused by programming errors that have been in the
> > > > SNMP implementations for a long time, but only recently discovered.
> > > >
> > > > CERT/CC is taking the lead on the process

RE: DBA-Database Storage using Net Appliance

[Rich Holland]

NetApp Filers use WAFL (Write Anywhere File Layout.  WAFL is similar to
other Unix filesystems like FFS in that it's a block-based file system
using inodes to describe files.  It uses 4K blocks with no
fragmentation.  Each WAFL inode has 16 block pointers that point to data
blocks.  Unlike FFS, all the block pointers in a WAFL inode refer to
blocks at the same level.  For files smaller than 64K the 16 inode
blocks point to data blocks.  Larger files use indirect pointers (inode
blocks point to other inode blocks).  Very large files use double
inderect pointers (inode -> inode -> inode -> data).  Very small files
use the inode blocks themselves instead of the block pointers.

WAFL stores file system metadata in files (inode file, block-map file,
and inode-map file.  Keeping this data in files allows the Filer to
write the data anywhere on the disk (rather than to a "superblock" like
FFS), which is where the WAFL name comes from.  This also allows the
Filer to schedule writes to the same RAID stripe to avoid the 4-1 write
penalty you usually incur when you update a single block in a stripe.

Other nice features from a sysadmin point of view are the fact that the
Filer will automatically increase the size of your filesystem when you
add another disk, and the use of snapshots.  Snapshots are really cool
if you haven't seen them before.  Basically from the point in time the
snapshot is taken, the filesystem has to write all new data (including
meta-data) to new locations on the disk instead of overwriting the old
data.  If WAFL used a superblock like FFS, this wouldn't be possible.
If data is changed, the Filer uses a copy-on-write technique to keep the
old block avialable for any snapshots which reference it.

I've never used a Filer for Oracle applications; I've only used EMC due
to the size & availability requirements of the implementations I've
worked on, but I know it's been done by others.

If you poke around at http://www.netapp.com/ you can probably find Dave
Hitz' original white papers on WAFL and the design of the filer
(formerly called FAServer) if this sort of thing interests you.

Rich
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of
Berkmeyer,
> Sue
> Sent: Thursday, February 14, 2002 10:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: DBA-Database Storage using Net Appliance
> 
>   Hi Everyone,
> 
>   I am getting pressure from the system guys to use a Net
Appliance
> filer for Oracle Applications databases.  I currently have the Apps
> Release
> 11.0.3 production database on a Sun E4500, 4G RAM, 6CPU@400Mhz and a
Sun
> storage array with a mix of 4 and 9G drives.  The production datafiles
are
> on Raid 0+1.  The production software is mirrored only.  Sequential
files
> are not "raided".  I have gone out to the Net Appliance web site and
have
> download papers about how to implement Oracle on the filer.  I would
like
> to
> hear from real users rather than the vendor about how this works.
> Therefore
> I am curious to find out anyone's experience with this storage
technology
> -
> good or bad.  If anyone has any insights about the Net Appliance
> technology
> itself i.e. raid level, etc. that would be great too.  We are also
> considering a new Sun direct attached storage solution.  Thanks for
your
> time.
> 
> National Renewable Energy Laboratory
> Sue Ellen Berkmeyer
> Database Administrator
> Phone:  303-275-4143
> Fax:  303-275-3603
> E-mail:   [EMAIL PROTECTED]
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Berkmeyer, Sue
>   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: Rich Holland
  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[2]: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

[dgoulet]

Ray,

No, but I do have a SA who believes that to be true.  I'll try to explain it
as he did.  

The DBSNMP agent registers a MIB with the snmp agent.  It is the snmp agent
that has the interface to the world.  As he put it, it's not the back end that
has the problem, but the front end that faces the network, namely the snmp
agent.

As to your nervousness, our facilities folks are using the back of my chair
as a paint shaker.

Dick Goulet

Reply Separator
Author: Ray Stell <[EMAIL PROTECTED]>
Date:   2/14/2002 12:18 PM



Dick, does this mean that you have firsthand knowledge that 
the oracle's snmp code is free from the underlying vulnerabilities?
There was no mention of Oracle in the advisory.  This could mean 
that they did not respond or they are not vulnerable.

I posted to the Oracle Networking Technical Forum yesterday on this
issue, but there has been no Oracle Corp response.  You can search
for SNMP to follow their response.

Joan, Dick is certainly correct here with respect to the the system snmp
agent.  The sysadmins need to address this by either patching or disabling
snmpd.  However, unless Oracle confirms they did not use the old flawed code, 
I don't see any reason to assume their product is not vulnerable.  Until
they do, I will:

1) be nervous, 
2) bug oracle corp, 
3) confirm ip filter rules,
4) study dbsnmp






On Thu, Feb 14, 2002 at 09:53:37AM -0800, [EMAIL PROTECTED] wrote:
> Joan,
> 
> The Oracle intelligent agent which uses dbsnmp is not the problem here. 
The
> real problem is the snmp agent that is running on the computer and owned by
> root.  Therefore your SA needs to do something, not you.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Joan Hsieh <[EMAIL PROTECTED]>
> Date:   2/14/2002 7:48 AM
> 
> Hi Ray,
> 
> We use dbsnmp on the production server. How it will affect us? Our
> system people sent us the same article to us and very concerned the
> security.
> 
> Joan
> 
> Ray Stell wrote:
> > 
> > Oracle does not seem to be listed, but you got to wonder what code
> > they based their snmp stuff on.  You may want to nudge you sysadmin
> > in the ribs, also.
> > 
> > - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> > 
> > Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> > To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> > 
> > SANS FLASH ALERT: Widespread SNMP Vulnerability
> > 1:30 PM EST 12 February, 2002
> > 
> > To: Ray Stell (SD569668)
> > 
> > Note: This is preliminary data! If you have additional information,
> > please send it to us at [EMAIL PROTECTED]
> > 
> > In a few minutes wire services and other news sources will begin
> > breaking a story about widespread vulnerabilities in SNMP (Simple
> > Network Management Protocol).  Exploits of the vulnerability cause
> > systems to fail or to be taken over.  The vulnerability can be found in
> > more than a hundred manufacturers' systems and is very widespread -
> > millions of routers and other systems are involved.
> > 
> > As one of the SANS alumni, your leadership is needed in making sure that
> > all systems for which you have any responsibility are protected. To do
> > that, first ensure that SNMP is turned off. If you absolutely must run
> > SNMP, get the patch from your hardware or software vendor. They are all
> > working on patches right now. It also makes sense for you to filter
> > traffic destined for SNMP ports (assuming the system doing the filtering
> > is patched).
> > 
> > To block SNMP access, block traffic to ports 161 and 162 for tcp and
> > udp.  In addition, if you are using Cisco, block udp for port 1993.
> > 
> > The problems were caused by programming errors that have been in the
> > SNMP implementations for a long time, but only recently discovered.
> > 
> > CERT/CC is taking the lead on the process of getting the vendors to get
> > their patches out.  Additional information is posted at
> > http://www.cert.org/advisories/CA-2002-03.html
> > 
> > A final note.
> > 
> > Turning off SNMP was one of the strong recommendations in the Top 20
> > Internet Security Threats that the FBI's NIPC and SANS and the Federal
> > CIO Council issued on October 1, 2001.  If you didn't take that action
> > then, now might be a good time to correct the rest of the top 20 as well
> > as the SNMP problem.  The Top 20 document is posted at
> > http://www.sans.org/top20.htm
> > 
> > - End forwarded message -
> > 
> > --
> > ===
> > Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ray Stell
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > --

RE: RE: Rollback Segment Problem

[Mohammad Rafiq]

That was my question also. I am agree with Gogala, after bouncing database 
no of wraps goes to 0(zero). This is normal behaviour with 7.3.4 to 8.1.7 
databases. Unfortunately our databases are bounced everyday for snapshot 
backup and I saw this behaviour everyday...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 14 Feb 2002 13:03:40 -0800

Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
 > You never need to recreate the rollback segments (DROP
 > and CREATE) unless
 > the rollback segment dies. THe rollback segment will
 > die after approx 4M
 > (the number is not very accurate.. okay,, some number)
 > transactions.
 > THis is the only case I need to drop and recreate them.
 >
 > Best Regards,
 > K Gopalakrishnan
 > Bangalore, INDIA
 >
 >
 >
 > -Original Message-
 > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
 > Behalf Of Mohammad
 > Rafiq
 > Sent: Wednesday, February 13, 2002 9:54 AM
 > To: Multiple recipients of list ORACLE-L
 > Subject: RE: Rollback Segment Problem
 >
 >
 > In many cases you will have to take RB segments offline
 > and drop them, then
 > re-create
 >


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
   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: Gogala, Mladen
   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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
   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 PRO

RE: ora -01122

[DBarbour]

Did you make the export before or after the crash?  What does your alert
log say?  Any trace files generated in cdump, udump, bdump?  Any system
error messages generated?  Without being in archivelog mode, given the
information you've provided, your only course may be to restore the export.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
 
Hamid Alavi
 
   
ovadx.com>cc:  
 
Sent by:  Subject: RE: ora -01122  
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
02/14/2002 
 
02:38 PM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi,
Database shutdown by itseld(don't know why) then I try to started get the
error for datafile.
We are running oracle 8.1.6 on unix the only backup which i have is full
export from the instance(including all schema's).
We are in development phase and not running archivelog mode.
My last backup was at 10:00 AM today.
Thanks all for your help.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L



Well, looks like you have a recovery scenario on your hands.  What version
of Oracle are you on?  What is your Operating System/platform?  In what
manner did the database stop that now requires you to start it up?  Are you
in archivelog mode?  When was you last backup?  Was it hot or cold?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




Hamid Alavi


ovadx.com>cc:

Sent by:  Subject: ora -01122

[EMAIL PROTECTED]

m





02/14/2002

01:03 PM

Please respond

to ORACLE-L









Hi list,
I have an urgent problem for startup database when I try to stratup
database
I get this error:
ora-01122 database file 29 failed verification check
ora-01110 data file 29 databaseQDX.dbf
ora-01251 unknown file header version read for file 29

Please if any  body have any idea is very very urget
Thanks


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---

'index only' table vs. 'index organized' table

[Pardee, Roy E]

Greetings all,

Can anybody enlighten me as to whether these things are the same or
different?  In Designer (v 6.0), I'm seeing a spot to specify a 'percent
threshold' and 'overflow tablespace' for my table, under the heading "Index
Only Tables".  I've heard of index-organized tables, but never 'index only'
tables.  The help file has been unavailing.

Thanks!

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pardee, Roy E
  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: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

[Joan Hsieh]

Hello,

This is what oracle responsed;

1. EM does not use SNMP at all for its own functionality -- therefore
EM
proper is not affected by these findings.

2. The EM agent can be optionally used as an SNMP subagent that
services
the public and Oracle-specific database MIBs. 

3. Intensive testing on this vulnerability has determined that there
is
minimal
risk involved to EM users. EM does not require SNMP out-of-box -- use
of
SNMP with the agent is optional. The worst case scenario is a denial
of
service attack against the Agent, resulting in an Agent core dump.
This
risk is
only apparent when the Agent is configured to use SNMP. 

Please note that the Agent installation is typically behind a
firewall
and the Agent does not listen
to Internet traffic, further reducing the likelihood of external
tampering.
Additionally, there does not seem to be any potential for
unauthorized
privilege access, any capability to run external code, or an affect
on
other services on the node.

Oracle will be releasing a formal Oracle Security Alert this week
with
information regarding patching, backporting, etc. 

Ray Stell wrote:
> 
> Dick, does this mean that you have firsthand knowledge that
> the oracle's snmp code is free from the underlying vulnerabilities?
> There was no mention of Oracle in the advisory.  This could mean
> that they did not respond or they are not vulnerable.
> 
> I posted to the Oracle Networking Technical Forum yesterday on this
> issue, but there has been no Oracle Corp response.  You can search
> for SNMP to follow their response.
> 
> Joan, Dick is certainly correct here with respect to the the system snmp
> agent.  The sysadmins need to address this by either patching or disabling
> snmpd.  However, unless Oracle confirms they did not use the old flawed code,
> I don't see any reason to assume their product is not vulnerable.  Until
> they do, I will:
> 
> 1) be nervous,
> 2) bug oracle corp,
> 3) confirm ip filter rules,
> 4) study dbsnmp
> 
> On Thu, Feb 14, 2002 at 09:53:37AM -0800, [EMAIL PROTECTED] wrote:
> > Joan,
> >
> > The Oracle intelligent agent which uses dbsnmp is not the problem here.  The
> > real problem is the snmp agent that is running on the computer and owned by
> > root.  Therefore your SA needs to do something, not you.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: Joan Hsieh <[EMAIL PROTECTED]>
> > Date:   2/14/2002 7:48 AM
> >
> > Hi Ray,
> >
> > We use dbsnmp on the production server. How it will affect us? Our
> > system people sent us the same article to us and very concerned the
> > security.
> >
> > Joan
> >
> > Ray Stell wrote:
> > >
> > > Oracle does not seem to be listed, but you got to wonder what code
> > > they based their snmp stuff on.  You may want to nudge you sysadmin
> > > in the ribs, also.
> > >
> > > - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> > >
> > > Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> > > To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> > >
> > > SANS FLASH ALERT: Widespread SNMP Vulnerability
> > > 1:30 PM EST 12 February, 2002
> > >
> > > To: Ray Stell (SD569668)
> > >
> > > Note: This is preliminary data! If you have additional information,
> > > please send it to us at [EMAIL PROTECTED]
> > >
> > > In a few minutes wire services and other news sources will begin
> > > breaking a story about widespread vulnerabilities in SNMP (Simple
> > > Network Management Protocol).  Exploits of the vulnerability cause
> > > systems to fail or to be taken over.  The vulnerability can be found in
> > > more than a hundred manufacturers' systems and is very widespread -
> > > millions of routers and other systems are involved.
> > >
> > > As one of the SANS alumni, your leadership is needed in making sure that
> > > all systems for which you have any responsibility are protected. To do
> > > that, first ensure that SNMP is turned off. If you absolutely must run
> > > SNMP, get the patch from your hardware or software vendor. They are all
> > > working on patches right now. It also makes sense for you to filter
> > > traffic destined for SNMP ports (assuming the system doing the filtering
> > > is patched).
> > >
> > > To block SNMP access, block traffic to ports 161 and 162 for tcp and
> > > udp.  In addition, if you are using Cisco, block udp for port 1993.
> > >
> > > The problems were caused by programming errors that have been in the
> > > SNMP implementations for a long time, but only recently discovered.
> > >
> > > CERT/CC is taking the lead on the process of getting the vendors to get
> > > their patches out.  Additional information is posted at
> > > http://www.cert.org/advisories/CA-2002-03.html
> > >
> > > A final note.
> > >
> > > Turning off SNMP was one of the strong recommendations in the Top 20
> > > Internet Security Threats that the FBI's NIPC and SANS and the Federal
> > > CIO Council issued on October 1, 2001.  If you didn't take that action
> > 

RE: HOW TO MAKE FAST EXPORT

[Miller, Jay]

If you know of a way to set direct=y with an import I'd love to hear it :)
 
However I suppose that if there are some especially large tables they could
be spooled to a text file and loaded with a sql loader script.
 
Jay Miller

-Original Message-
Sent: Thursday, February 14, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L



Check the Utilities manual for the 
DIRECT=Y parameter 

 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
I've been so downhearted ever since the day we met. 
You're love ain't nothin' but the blues. Baby how blue can you get? 
  - Jonny Moore and the Blazers 

-Original Message- 
 ] 
Sent: Wednesday, February 13, 2002 6:20 PM 
To: Multiple recipients of list ORACLE-L 


Hi 
How to make import fast except BUFFER size increase and big rollback segment

if I am reorganising the database. 
Thanks 
-Seema 



_ 
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
 . 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Seema Singh 
  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: Miller, Jay
  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: ora -01122

[James Manning]

[Hamid Alavi]
> Database shutdown by itseld(don't know why) then I try to started get the
> error for datafile.

Anything helpful in the alert log?  Like, I/O errors during archiving
so once all online redo logs needed archiving, the instance stopped
accepting transactions?  Just a guess
-- 
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  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: FRAGMENTATION ISSUE?

[Miller, Jay]

Shaibal is right on target.  If you're going to go to the trouble to
defragment then you may as well switch to uniform extent sizing so you don't
have the problem in the future.
 
If you have the room you can do it in stages.  First create an index
tablespace and rebuild all your indexes in that.  Then create a table
tablespace(s), then you can export all the tables, drop them and recreate
the table structures with uniform extents or locally managed and import
them.
 
If you have tables of widely varying size then you could set up multiple
tablespaces (ts_small, ts_medium, etc).
 
Jay Miller

-Original Message-
Sent: Thursday, February 07, 2002 8:03 PM
To: Multiple recipients of list ORACLE-L



Seema,

>From your posting, it is not clear to me about the content of the mentioned
tablespace. If it contains all of one users schema you can just take export
for that particular schema. The step when you are recreating the tablespace,
create it with pct increase 0 and do create initial and next extents same
size or you can create the tablespace as a locally managed tablespace - this
is where your fragmentation is going to be stopped. The rest looks fine to
me.

Slightly off topic, it is not good practice to create everything belong to a
owner in the same tablespace. For sure tables and indexes should have their
seperate tablespaces. 

Shaibal



>From: "Seema Singh" 
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L 
>Subject: FRAGMENTATION ISSUE? 
>Date: Thu, 07 Feb 2002 13:07:10 -0800 
> 
>Hi 
>one of my tablespace is highly fragmented and that tablespace 
>contains 
>almost all objects and its default tablespace of one of users .I 
>want to 
>correct it thru export/import.Let me correct if any thing missing 
>please. 
>-Full export of current instance. 
>-Drop that tablespace including contents.(Drop only one tablespace) 
>-Create that tablespace 
>-import the data thru fromuser touser option. 
>-compile the object if required 
>Is anything missing in this list.The above are overall steps.Let me 
>know 
>this will remove the fragmentation of that tablespace or not?What is 
>the 
>risk factor to do this? 
>Thx 
>-sEEMA 
> 
> 
> 
>_ 
>Chat with friends online, try MSN Messenger: 
>http://messenger.msn.com 
> 
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>-- 
>Author: Seema Singh 
> 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). 

  _  

Send and receive Hotmail on your mobile device: Click Here
 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
Shaibal Talukder 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: Miller, Jay
  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: RE: Rollback Segment Problem

[K Gopalakrishnan]

Gogala,

Not quite true.A simple restart will NOT cure that disease. The WRAP# is
visible as KTUXESQN in the X$KTUXE. You can check that value by restating
the instance. You can simply drop the rollback segment and force the
instance to use the other rollback segements, but not by restarting..:)


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Mladen
Sent: Thursday, February 14, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


How long does a database have to remain running in order for a rollback
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number is not very accurate.. okay,, some number)
> transactions.
> THis is the only case I need to drop and recreate them.
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mohammad
> Rafiq
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback Segment Problem
>
>
> In many cases you will have to take RB segments offline
> and drop them, then
> re-create
>


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
  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: Gogala, Mladen
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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: ora -01122

[Hamid Alavi]

Hi,
Database shutdown by itseld(don't know why) then I try to started get the
error for datafile.
We are running oracle 8.1.6 on unix the only backup which i have is full
export from the instance(including all schema's).
We are in development phase and not running archivelog mode.
My last backup was at 10:00 AM today.
Thanks all for your help.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L



Well, looks like you have a recovery scenario on your hands.  What version
of Oracle are you on?  What is your Operating System/platform?  In what
manner did the database stop that now requires you to start it up?  Are you
in archivelog mode?  When was you last backup?  Was it hot or cold?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

Hamid Alavi

   
ovadx.com>cc:

Sent by:  Subject: ora -01122

[EMAIL PROTECTED]

m

 

 

02/14/2002

01:03 PM

Please respond

to ORACLE-L

 

 





Hi list,
I have an urgent problem for startup database when I try to stratup
database
I get this error:
ora-01122 database file 29 failed verification check
ora-01110 data file 29 databaseQDX.dbf
ora-01251 unknown file header version read for file 29

Please if any  body have any idea is very very urget
Thanks


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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: 
  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).
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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: UNIX Performance Issues

[Fedock, John (KAM.RHQ)]

Get a copy of Oracle High Performance Tuning with Statspack by Donald
Burlson.  He has many scripts on doing exactly what you are asking for.

Good Luck.


John Fedock
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 14, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L


DBAs,

This might be littlebit (or completely!) UNIX related... But I am told
to do the performance analysis of some 10-15 machines and generate
some statistical data to find out bottlenecks and identify areas of
tuning...

Operating System : Solaris 2.6

I have been using sar, iostat, top...
I actually plan to script these things and run these scripts at certain
intervals and put the data in database (Oracle 8i) and then do the
crunching...
Inputs are appreciated...

1. I/O
   What is current I/O status. Is there a lot of I/O going on?

2. Paging
   Is there lot of swapping / paging happening?
   Which processes are getting swapped in/out continuously?
   Are the I/O waits due to swapping / paging or regular stuff
   like DB waiting to read from DB files?

3. CPU
   What is the CPU utulization? Which processes are using lot of CPU?

4. Memory
   What is the current picture of Real and Virtual Memory?
   What processes are using how much memory? Which processes
   are in real memory and which are in virtual memory?
   Which processes are swapped in and out from/to real/virtual memory
   and how many times?

5. Network
   What is the percentage utilization of network pipe?
   What is the capacity (bandwidth) of the network device?
   What percentage of that bandwidth is getting used?
   Is the system waiting for data from outside network I/O?
   In short, is there any bandwidth problem with network device
   or network traffic.

Thanks,

  ___   ______   ___   ___
 /  /\ /  /\  /  /\ /  /\ /  /\
/  /::\   /  /::\/  /://  /://  /:/
   /  /:/\:\ /  /:/:|   /  /://  /://  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
|  |:|::/ \__\::|  \__\::/   \  \:\  /:/   \  \:\
|  |:|\/   |  |:|  /  /:/ \  \:\/:/ \  \:\
|__|:| |__|:| /__/:/   \  \::/   \  \:\
 \__\|  \__\| \__\/ \__\/ \__\/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  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: Fedock, John (KAM.RHQ)
  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: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

[Ray Stell]

Dick, does this mean that you have firsthand knowledge that 
the oracle's snmp code is free from the underlying vulnerabilities?
There was no mention of Oracle in the advisory.  This could mean 
that they did not respond or they are not vulnerable.

I posted to the Oracle Networking Technical Forum yesterday on this
issue, but there has been no Oracle Corp response.  You can search
for SNMP to follow their response.

Joan, Dick is certainly correct here with respect to the the system snmp
agent.  The sysadmins need to address this by either patching or disabling
snmpd.  However, unless Oracle confirms they did not use the old flawed code, 
I don't see any reason to assume their product is not vulnerable.  Until
they do, I will:

1) be nervous, 
2) bug oracle corp, 
3) confirm ip filter rules,
4) study dbsnmp






On Thu, Feb 14, 2002 at 09:53:37AM -0800, [EMAIL PROTECTED] wrote:
> Joan,
> 
> The Oracle intelligent agent which uses dbsnmp is not the problem here.  The
> real problem is the snmp agent that is running on the computer and owned by
> root.  Therefore your SA needs to do something, not you.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Joan Hsieh <[EMAIL PROTECTED]>
> Date:   2/14/2002 7:48 AM
> 
> Hi Ray,
> 
> We use dbsnmp on the production server. How it will affect us? Our
> system people sent us the same article to us and very concerned the
> security.
> 
> Joan
> 
> Ray Stell wrote:
> > 
> > Oracle does not seem to be listed, but you got to wonder what code
> > they based their snmp stuff on.  You may want to nudge you sysadmin
> > in the ribs, also.
> > 
> > - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> > 
> > Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> > To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> > 
> > SANS FLASH ALERT: Widespread SNMP Vulnerability
> > 1:30 PM EST 12 February, 2002
> > 
> > To: Ray Stell (SD569668)
> > 
> > Note: This is preliminary data! If you have additional information,
> > please send it to us at [EMAIL PROTECTED]
> > 
> > In a few minutes wire services and other news sources will begin
> > breaking a story about widespread vulnerabilities in SNMP (Simple
> > Network Management Protocol).  Exploits of the vulnerability cause
> > systems to fail or to be taken over.  The vulnerability can be found in
> > more than a hundred manufacturers' systems and is very widespread -
> > millions of routers and other systems are involved.
> > 
> > As one of the SANS alumni, your leadership is needed in making sure that
> > all systems for which you have any responsibility are protected. To do
> > that, first ensure that SNMP is turned off. If you absolutely must run
> > SNMP, get the patch from your hardware or software vendor. They are all
> > working on patches right now. It also makes sense for you to filter
> > traffic destined for SNMP ports (assuming the system doing the filtering
> > is patched).
> > 
> > To block SNMP access, block traffic to ports 161 and 162 for tcp and
> > udp.  In addition, if you are using Cisco, block udp for port 1993.
> > 
> > The problems were caused by programming errors that have been in the
> > SNMP implementations for a long time, but only recently discovered.
> > 
> > CERT/CC is taking the lead on the process of getting the vendors to get
> > their patches out.  Additional information is posted at
> > http://www.cert.org/advisories/CA-2002-03.html
> > 
> > A final note.
> > 
> > Turning off SNMP was one of the strong recommendations in the Top 20
> > Internet Security Threats that the FBI's NIPC and SANS and the Federal
> > CIO Council issued on October 1, 2001.  If you didn't take that action
> > then, now might be a good time to correct the rest of the top 20 as well
> > as the SNMP problem.  The Top 20 document is posted at
> > http://www.sans.org/top20.htm
> > 
> > - End forwarded message -
> > 
> > --
> > ===
> > Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ray Stell
> >   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: Joan Hsieh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, Califo

RE: RE: Rollback Segment Problem

[Gogala, Mladen]

How long does a database have to remain running in order for a rollback 
segment to go to the happy hunting grounds? Have you ever seen such an
event? A simple instance restart will cure that disease. Anyway, the only 
thing that I can envision to cause this is to have an OLTP database with
something
like 100 online users doing more then 4000 transactions a day and the
instance is configured with a single rollback segment. In that case the
DBA deserves to be executed by the ways of the weight watchers!

-Original Message-
Sent: Thursday, February 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L


Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number is not very accurate.. okay,, some number)
> transactions.
> THis is the only case I need to drop and recreate them.
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mohammad
> Rafiq
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback Segment Problem
>
>
> In many cases you will have to take RB segments offline
> and drop them, then
> re-create
>


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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: Gogala, Mladen
  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: LMT to DMT

[Jared . Still]

Why bother with WinZip?

www.gzip.org







àãø éçéàì <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/14/02 10:56 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: LMT to DMT


Command Line Support Add-On 
 
 Note: at the time of this writing, the command line support add-on has
still not been officially  released, but a pre-release beta test version 
is
available as a free download from the web  page
http://www.winzip.com/wzcline.cgi . 
  The WinZip Command Line Support Add-On lets you use WinZip's® power 
within
batch files,  macros, and other situations where you have a specific task
and would prefer to accomplish it  quickly or automatically, without using
the usual WinZip graphical user interface. 
 
 Copyright © 1991-2000 by WinZip Computing, Inc.  All rights reserved.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From:  Joan Hsieh [SMTP:[EMAIL PROTECTED]]
> Sent:  Thu, February 14, 2002 4:34 PM
> To:Multiple recipients of list ORACLE-L
> Subject:   Re: LMT to DMT
> 
> Thanks, I don't have pkzip, just winzip. Don't worry, I got it from 
> http://www.winzip.com/xcmdline.htm
> 
> Joan
> 
> aao eceai wrote:
> > 
> > Hello Joan
> > 
> > Try : pkzip -add zipfilename *.txt
> > 
> > Yechiel Adar, Mehish Computer Services
> > [EMAIL PROTECTED]
> > 
> > > -Original Message-
> > > From: Joan Hsieh [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wed, February 13, 2002 10:32 PM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  LMT to DMT
> > >
> > > Hi listers,
> > >
> > > How to convert the locally management tablespace back to dictionary
> > > management tablespace? I used dbms_space_admin migrated all the
> > > tablespaces to LMT. Now I want convert back on some tablespaces, I
> > > remember I read the notes indicate step to step how to do this. Just
> > > can't find it anymore. Could you please give me some light on this?
> > >
> > > Another question I posted yesterday, but no replied so far. I post
> here
> > > again.  Thanks,
> > >
> > > JOan
> > >
> > >
> > > I am looking for a solution to zip all the backup files into one
> > >  backupset.zip file on NT. I have trouble to find the dos command
> > > line to
> > >  do this.(pkzip or winzip command line? should executed in a batch
> > > file
> > >  after backup) Can you share this info with us? This should be a
> > > very
> > > easy thing to do. NT comand compact /C is not what I want. Thanks,
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Joan Hsieh
> > >   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).
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > >  This e-mail was scanned by the eSafe Mail Gateway
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> >   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: Joan Hsieh
>   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 th

Oracle.exe memory usage keeps going up.

[Chen, Brian]

Hi,
  We have an Oracle database 8.1.6.3.7 running in NT. We use Oracle Client
8.1.7.3 with OLE DB connect to database. There are two Web server connect to
this database. First Web server have 20 constant connections to the
database. The second Web Server makes vary connections and always drop
connect after the application finish. The memory usage of Oracle.exe process
increases when the Second Web server make connections. But after those
connections drop, the memory decrease very little. 

For example, before the second Web server make connections, Oracle.exe uses
200M virtual memory. When the Web server make 20 connections, Oracle.exe
uses 300M virtual memory. After those 20 connections drop, the Oracle.exe
still uses 260M virtual memory.  Over some period, Oracle.exe will run out
of memory.

Any idea what went wrong? How to solve this problem?

Brian Chen
(212)-931-1878


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chen, Brian
  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: ora -01122

[DBarbour]

Well, looks like you have a recovery scenario on your hands.  What version
of Oracle are you on?  What is your Operating System/platform?  In what
manner did the database stop that now requires you to start it up?  Are you
in archivelog mode?  When was you last backup?  Was it hot or cold?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
 
Hamid Alavi
 
   
ovadx.com>cc:  
 
Sent by:  Subject: ora -01122  
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
02/14/2002 
 
01:03 PM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi list,
I have an urgent problem for startup database when I try to stratup
database
I get this error:
ora-01122 database file 29 failed verification check
ora-01110 data file 29 databaseQDX.dbf
ora-01251 unknown file header version read for file 29

Please if any  body have any idea is very very urget
Thanks


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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: 
  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: RE: Rollback Segment Problem

[K Gopalakrishnan]

Hi G_DBA ,

The transaction id (which is recorded in the ITL) consists of 3 components.
Undo Segment Number, Slot Number and Wrap Number.
THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in
numbers) and once it reaches the MAXVAL the rollback segment is considered
as DEAD. i.e. it can not hold undo information for any transactions.,

THis condition is called as DEATH of a Rollback segment. THis is true for
SMU also.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Thursday, February 14, 2002 2:35 AM

Hi Ganesh,
Could u please elaborate, i did not get what u said.
What do u mean by Rollback segment dying.
I did not pick up the earlier mails so maybe thats why.
thanks and reg
Guru


On Thu, 14 Feb 2002 K Gopalakrishnan wrote :
> You never need to recreate the rollback segments (DROP
> and CREATE) unless
> the rollback segment dies. THe rollback segment will
> die after approx 4M
> (the number is not very accurate.. okay,, some number)
> transactions.
> THis is the only case I need to drop and recreate them.
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mohammad
> Rafiq
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback Segment Problem
>
>
> In many cases you will have to take RB segments offline
> and drop them, then
> re-create
>


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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: Extent grab ...

[Jamadagni, Rajendra]

you'll have to capture that information manually. Of course if you need a
shortcut, use DBA module of TOAD, when you view tablespaces, it can create
scripts and dbms_job to activate space monitoring. It can then show you
space usage in a graphical manner for tablespaces and datafiles. It doesn't
work for individual tables, but the idea is you take their idea and extend
it.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


***1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

Re: Extent grab ...

[Anjan Thakuria]

I guess I should be more specific.

I am trying to find out the growth rate of a table on a 7.3.4 database. I
did not get any info from the previous DBA. Can somebody tell me if there
is a was to find out from the data dictionary how many extents by which
this table has extended and when; the rate of growth.

Any help/input will be greatly appreciated.

Thanks in advance.

Anjan

Anjan Thakuria wrote:

> Gurus,
>
> Is there any way to fond out the rate of extent grab by a segment from
> the data dictionary.
>
> Thanks in advance.
>
> Anjan


begin:vcard 
n:Thakuria;Anjan
tel;work:817-963-3291
x-mozilla-html:TRUE
url:www.eds.com
org:EDS;Midrange Database Engineering
adr:;;;Fort Worth;Texas;76155;U.S.A
version:2.1
email;internet:[EMAIL PROTECTED]
title:Infrastructure Specialist
fn:Anjan Thakuria
end:vcard

ora -01122

[Hamid Alavi]

Hi list,
I have an urgent problem for startup database when I try to stratup database
I get this error:
ora-01122 database file 29 failed verification check
ora-01110 data file 29 databaseQDX.dbf
ora-01251 unknown file header version read for file 29

Please if any  body have any idea is very very urget
Thanks


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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: Performance Tuning

[cjgait]

Okay, I'll plug my own list of recommendations on Amazon. It 
should come up from this URL:
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-
/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-
6595843

If it doesn't, just enter 'Oracle performance tuning' in a search on 
Amazon.com and look to the right. My list usually pops up.

If you just get one book on performance, go with Performance 101. 
If you're getting two books, get 101 and Tom Kyte's book.

Regards,
Chris Gait

On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:

Date sent:  Wed, 30 Jan 2002 02:25:19 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> Hi Everyone
> 
>   I am interested in purchasing some exceptionally good book on Oracle
> Performance Tuning. Can anyone suggest me some very good book on Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> -- 
> 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: 
  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: LMT to DMT

[אדר יחיאל]

Command Line Support Add-On 
  
 Note: at the time of this writing, the command line support add-on has
still not been officially  released, but a pre-release beta test version is
available as a free download from the web  page
http://www.winzip.com/wzcline.cgi . 
  The WinZip Command Line Support Add-On lets you use WinZip's® power within
batch files,  macros, and other situations where you have a specific task
and would prefer to accomplish it  quickly or automatically, without using
the usual WinZip graphical user interface. 
  
 Copyright © 1991-2000 by WinZip Computing, Inc.  All rights reserved.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Joan Hsieh [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, February 14, 2002 4:34 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: LMT to DMT
> 
> Thanks, I don't have pkzip, just winzip. Don't worry, I got it from 
> http://www.winzip.com/xcmdline.htm
> 
> Joan
> 
> aao eceai wrote:
> > 
> > Hello Joan
> > 
> > Try : pkzip -add zipfilename *.txt
> > 
> > Yechiel Adar, Mehish Computer Services
> > [EMAIL PROTECTED]
> > 
> > > -Original Message-
> > > From: Joan Hsieh [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wed, February 13, 2002 10:32 PM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  LMT to DMT
> > >
> > > Hi listers,
> > >
> > > How to convert the locally management tablespace back to dictionary
> > > management tablespace? I used dbms_space_admin migrated all the
> > > tablespaces to LMT. Now I want convert back on some tablespaces, I
> > > remember I read the notes indicate step to step how to do this. Just
> > > can't find it anymore. Could you please give me some light on this?
> > >
> > > Another question I posted yesterday, but no replied so far. I post
> here
> > > again.  Thanks,
> > >
> > > JOan
> > >
> > >
> > > I am looking for a solution to zip all the backup files into one
> > >  backupset.zip file on NT. I have trouble to find the dos command
> > > line to
> > >  do this.(pkzip or winzip command line? should executed in a batch
> > > file
> > >  after backup) Can you share this info with us? This should be a
> > > very
> > > easy thing to do. NT comand compact /C is not what I want. Thanks,
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Joan Hsieh
> > >   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).
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > >  This e-mail was scanned by the eSafe Mail Gateway
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> >   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: Joan Hsieh
>   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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?&alef;&dalet;&resh;_&yod;&het;&yod;&alef;&lamed;?  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX

RE: Unidata DB

[Vergara, Michael (TEM)]

Yeah...I forgot about GIRLS!  There was also a series of companies
called Ultimate (used DEC LSI and Honeywell hardware), General
Automation (the Zebra line), and others.  Revelation was a PC-based
product initially published by Cognos if I remember correctly.  It
required the 8087 numeric processor be added to your 8088 or 8086
system.

I seem to recall the Stauffer name from Pick conventions of years
past.  Did you do work with Pick and it's variants?

Mike

-Original Message-
Sent: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Different product:

>From a posting on comp.databases:

it actually started life as a system called GIRLS. Meant for tracking 
helicopter parts. It then split into two - owned by two companies called
Pick 
Systems and Microdata. Pick Systems then licenced their version which became

Reality, D3, and a variety of others. Pick Systems has now bought back
nearly 
all of its licencees and through various machinations is now a company
called 
Raining Data.

The Microdata developers split up as well, leading to Revelation, Open
Insight, Prime Information, UniVerse, Unidata, ... IBM has now swallowed
up the last-named three as part of its takeover of Informix.

End Quote

You can take a look at the IBM website for more information on the Unidata 
database - the IBM U2 product family:

"IBM UniData® is an extended relational database designed for embedding in 
vertical applications. This nested relational data model allows for rapid, 
intuitive data modeling and fewer resulting tables. UniData simplifies data 
management and query logic, providing more power for on-line, 
high-transaction applications."

--Glenn

On Thursday 14 February 2002 10:13 am, you wrote:
> Um...  Are you sure it's not Universal DB?  AFAIK, that's really just
> DB2... More a marketing thing...
>
> Tim
>
> -Original Message-
> Sent: Thursday, February 14, 2002 8:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Has anyone heard of Unidata DB.  It's relational and from IBM.
>
> Thanks,
> Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Stauffer
  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: Vergara, Michael (TEM)
  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: MsAccess calling PL/SQL

[Seefelt, Beth]

Check Microsoft's web site for documents on using ADO to call stored
procedures from VBA.  There will be alot of examples there.

Beth

-Original Message-
Sent: Thursday, February 14, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone whom can give me an example onhow to write an MsAccess procedure
which make a call to a pl/sqlprocedure. I want the MsAccess procedure
send 5 parametsrs through to pl/sql.

Thanks in advance


Roland


-- 
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: Seefelt, Beth
  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: ORA-600 [1158] on 8.1.7

[Mohammad Rafiq]

With every parchset they provide list of fixes in readme file. You can check 
it before downloading or applying patches...However, it is better to go to 
8.1.7.2 which has lot of fixes...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 14 Feb 2002 08:23:34 -0800

Hi,

We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently
crashes with an
ORA-600 [1158] error. Oracle's "ORA-600 lookup" tool did not have any hits.
There was no specific
resolution from Oracle support for this error - just a general suggestion to
upgrade to the latest
patch  levels.  This is something we are reluctant to do without specific 
patch
information addressing
our problem.

Has anyone seen this error on 8.1.7 before?

Regards,

Martin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Martin Vasas
   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).




MOHAMMAD RAFIQ


_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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: Unidata DB

[Vergara, Michael (TEM)]

Unidata is a clone of the PICK operating system from a 
long
way back.  PICK's biggest asset was the notion of 
'multivalues'.
Instead of a row-and-column view of things, individual data 
elements
could have multiple values in the same row.  It makes for a 
single
table ('file' in PICK/Unidata/UniVerse) where you'd need 
multiple
tables in Oracle, or you'd need to define a 'nested object' in 

the newer Oracle releases.
 
My first job was on a Microdata 1600, which ran the REALITY 
o/s.
Dick Pick worked for Microdata in the early days.  The 
opening
page of the manuals always said "Welcome to Reality".  
Ahh...the
good old days.

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 5:44 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Unidata DB
  Has anyone heard of Unidata DB.  It's relational and 
  from IBM.  
   
  Thanks,
  Ken Janusz, CPIM

Re[2]: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

[dgoulet]

Joan,

The Oracle intelligent agent which uses dbsnmp is not the problem here.  The
real problem is the snmp agent that is running on the computer and owned by
root.  Therefore your SA needs to do something, not you.

Dick Goulet

Reply Separator
Author: Joan Hsieh <[EMAIL PROTECTED]>
Date:   2/14/2002 7:48 AM

Hi Ray,

We use dbsnmp on the production server. How it will affect us? Our
system people sent us the same article to us and very concerned the
security.

Joan

Ray Stell wrote:
> 
> Oracle does not seem to be listed, but you got to wonder what code
> they based their snmp stuff on.  You may want to nudge you sysadmin
> in the ribs, also.
> 
> - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> 
> Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> 
> SANS FLASH ALERT: Widespread SNMP Vulnerability
> 1:30 PM EST 12 February, 2002
> 
> To: Ray Stell (SD569668)
> 
> Note: This is preliminary data! If you have additional information,
> please send it to us at [EMAIL PROTECTED]
> 
> In a few minutes wire services and other news sources will begin
> breaking a story about widespread vulnerabilities in SNMP (Simple
> Network Management Protocol).  Exploits of the vulnerability cause
> systems to fail or to be taken over.  The vulnerability can be found in
> more than a hundred manufacturers' systems and is very widespread -
> millions of routers and other systems are involved.
> 
> As one of the SANS alumni, your leadership is needed in making sure that
> all systems for which you have any responsibility are protected. To do
> that, first ensure that SNMP is turned off. If you absolutely must run
> SNMP, get the patch from your hardware or software vendor. They are all
> working on patches right now. It also makes sense for you to filter
> traffic destined for SNMP ports (assuming the system doing the filtering
> is patched).
> 
> To block SNMP access, block traffic to ports 161 and 162 for tcp and
> udp.  In addition, if you are using Cisco, block udp for port 1993.
> 
> The problems were caused by programming errors that have been in the
> SNMP implementations for a long time, but only recently discovered.
> 
> CERT/CC is taking the lead on the process of getting the vendors to get
> their patches out.  Additional information is posted at
> http://www.cert.org/advisories/CA-2002-03.html
> 
> A final note.
> 
> Turning off SNMP was one of the strong recommendations in the Top 20
> Internet Security Threats that the FBI's NIPC and SANS and the Federal
> CIO Council issued on October 1, 2001.  If you didn't take that action
> then, now might be a good time to correct the rest of the top 20 as well
> as the SNMP problem.  The Top 20 document is posted at
> http://www.sans.org/top20.htm
> 
> - End forwarded message -
> 
> --
> ===
> Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
>   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: Joan Hsieh
  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: 
  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: Create Database ... really dumb question

[Lord, David - CSG]

April,

The 'size 1m reuse' should be outside the parentheses: -

logfile ('/admin04/cc1test/redo01.log',
'/admin05/cc1test/redo02.log',
'/admin06/cc1test/redo03.log') size 1m reuse

HTH
--
David Lord

> -Original Message-
> From: April Wells [mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2002 16:33
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Create Database ... really dumb question
> 
> 
> Not per the LESS than Friendly manuals...  
> 
> Admin guide, 2-12
> 
> -Original Message-
> Sent: Thursday, February 14, 2002 10:23 AM
> To: '[EMAIL PROTECTED]'
> Cc: April Wells
> 
> 
> Shouldn't your dbname be in double quotes
> 
> create database "testcc1"
> etc.
> etc...
> 
> 
> HTH
> 
> Lee
> 
> 
> -Original Message-
> Sent: 14 February 2002 14:29
> To: Multiple recipients of list ORACLE-L
> 
> 
> create database testcc1
> controlfile reuse
> logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
> '/admin05/cc1test/redo02.log' size 1m reuse,
> '/admin06/cc1test/redo03.log' size 1m reuse)
> datafile '/data10/cc1test_system.dbf' size 100m reuse
> /
> 
> 
> SQL> @afiedt.buf
> logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
>*
> ERROR at line 3:
> ORA-00907: missing right parenthesis


**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - CSG
  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: Create Database ... really dumb question

[Gogala, Mladen]

Yes. You call your local oracle office and get yourself a support contract.
WARNING:  YOU MAY BE REQUIRED TO SIGN A CHECK IN THE PROCESS 

-Original Message-
Sent: Thursday, February 14, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L


[SARKAR, Samir]
> Check Metalink Note : 56016.999

Is there any way to get access to metalink for those of us not fortunate
enough to have an Oracle support contract?  (Startup life is fun!)
-- 
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  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: Gogala, Mladen
  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).

Call PL/SQL from MsAccess

[Pardee, Roy E]

Here's some code that sends two parameters--you should be able to adapt it
to your needs.  I'm using ADO 2.6.

==
S u b RunOracleSP()
Dim cmd As ADODB.Command
Dim con As ADODB.Connection
Dim prm As ADODB.Parameter

Dim Network As Object

Set cmd = New ADODB.Command
Set con = New ADODB.Connection

Set Network = CreateObject("WScript.Network")

   With con
  .ConnectionString = "Provider=MSDAORA.1;" _
& "Password=***;" _
& "User ID=rpardee;" _
& "Data Source=devl;" _
& "Persist Security Info=False"
  .Open
   End With

   With cmd
  Set .ActiveConnection = con
  .CommandType = adCmdStoredProc
  .CommandText = "RPARDEE.LOGLOGIN"
  Set prm = .CreateParameter("M_NAME" _
  , adVarChar _
  , adParamInput _
  , 4000)
  .Parameters.Append prm
  Set prm = .CreateParameter("U_NAME" _
  , adVarChar _
  , adParamInput _
  , 4000)
  .Parameters.Append prm
  .Parameters("M_NAME").Value = Network.ComputerName
  .Parameters("U_NAME").Value = Network.UserName
  .Execute , , adAsyncExecute
   End With

   Set Network = Nothing
   Set cmd = Nothing
   con.Close
   Set con = Nothing

End Sub
==

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Thursday, February 14, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone whom can give me an example onhow to write an MsAccess procedure
which make a call to a pl/sqlprocedure. I want the MsAccess procedure send 5
parametsrs through to pl/sql.

Thanks in advance


Roland



-- 
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: Pardee, Roy E
  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: DB sizing - whitepaper

[david . m . harris]

   > "How you plan the Database sizing for a given application?"

 Ramesh,

  They may have been looking for a more obvious response, like starting with the 
type of
application rather than its size; I'm familiar with transaction processing systems 
(ie, an ATM)
and decision support systems (mainly read only quering systems).  It appears to me 
the way they
phrased the question is that they are trying to find out your step-by-step process 
of deciding on the
required space for an application, so this may not be a direct answer such as 
referring to the tablespace syntax.
However, I agree with your logic, and Bjorn's reply because there are several 
factors and
I/O efficiency is one of them.  Just my 2 cents.

   HTH,

  David Harris
  Web Technology
  Verizon Communications






[EMAIL PROTECTED]@fatcity.com on 02/14/2002 04:58:21 AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:


Bjørn
What you say is true. Now my question is What should be the answer to the
question "How you plan the Database sizing for a given application?". I
faced
it in a DBA interview. I did mention about the requied tablespaces, storage
parameters etc depending on Application size. Am I missing something?
Seniors, please advice.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet["Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>]

Ramesh,

I presume you are looking for something to tell you how to configure a
database server, and such a thing does not exist.  Period.

The real answer is, that this is far too application dependent, and that
only the application developers can provide anything of this kind.  And
even in this case, such configuration guides are often more misleading
than guiding.  There have been attempts at making rules like "this
application is like X tpc-c transactions", but they also fail to be of
any actual value.

Also, if what you really were looking for was something to tell you the
size (in GB) of the required disk to store schema with a certain
definition, you could create some rough estimates.  However, with todays
typical disksizes, you run out of spindles much before you run out of GB.

Thanks, Bjørn.

[EMAIL PROTECTED] wrote:

>Hi Gurus,
>Can anybody mail me the the whitepaper/policy document on database sizing?
>Thanks in advance.
>
>Regards,
>Ramesh D Papnoi
>Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
>(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
>http://www22.Brinkster.com/rpapnoi
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig
  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:
  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:
  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: Create Database ... really dumb question

[Mercadante, Thomas F]

April,

Sorry about that - I looked at the docs again, and I don't think you can do
it the way you had it originally.

I created my last db like so:

create database WTWU
maxinstances 1
maxlogfiles  32
maxdatafiles 99
noarchivelog
character set WE8ISO8859P1 
datafile
'L:\u0002\WTWU\system\system_01.dbf'  size   100M
logfile
group 1 ('N:\u0010\WTWU\log\redo01a.log',
   'J:\u0011\WTWU\log\redo01b.log') size 10M,
group 2 ('N:\u0010\WTWU\log\redo02a.log',
   'J:\u0011\WTWU\log\redo02b.log') size 10M,
group 3 ('N:\u0010\WTWU\log\redo03a.log',
   'J:\u0011\WTWU\log\redo03b.log') size 10M;

I think you need the "log file group 1" commands for multiple redo logs.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L


create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/


SQL> @afiedt.buf
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL> 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


April,

I think you need parens around the logfiles like:

logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
 '/admin05/cc1test/redo02.log' size 1m reuse,
 '/admin06/cc1test/redo03.log' size 1m reuse)

Your syntax is correct for one log file.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971Uhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  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: Mercadante, Thomas F
  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 w

RE: Create Database ... really dumb question

[Babich , Sergey]

Try this:


create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log') size 1m reuse,
('/admin05/cc1test/redo02.log') size 1m reuse,
('/admin06/cc1test/redo03.log') size 1m reuse

datafile '/data10/cc1test_system.dbf' size 100m reuse
/

First thing it encounters is the right parenthesis missing, and it shows you
where.
Best,
Sergey


/-Original Message-
Sent: Thursday, February 14, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L

create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/


SQL> @afiedt.buf
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL> 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


April,

I think you need parens around the logfiles like:

logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
 '/admin05/cc1test/redo02.log' size 1m reuse,
 '/admin06/cc1test/redo03.log' size 1m reuse)

Your syntax is correct for one log file.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971Uhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  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: Babich , Sergey
  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: Create Database ... really dumb question

[James Manning]

[SARKAR, Samir]
> Check Metalink Note : 56016.999

Is there any way to get access to metalink for those of us not fortunate
enough to have an Oracle support contract?  (Startup life is fun!)
-- 
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  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: Unidata DB

[Farnsworth, Dave]

There 
is a database called UniData and it is now owned by IBM.  They bought 
Informix, which owned UniData.  UniData is a real pig to work with 
especially in a multi database platform environment where you need to migrate 
data between different database systems.
 
Dave

  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 
  9:13 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Unidata DB
  Um...  Are you sure it's not Universal DB?  AFAIK, 
  that's really just DB2...  More a marketing thing...
   
  Tim
  
-Original Message-From: KENNETH JANUSZ 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 8:44 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Unidata DB
Has anyone heard of Unidata DB.  It's relational and 
from IBM.  
 
Thanks,
Ken Janusz, 
CPIM

RE: Unidata DB

[Johnston, Tim]

Ah...  It looks like it related to the IBM takeover of Informix...

UniData

UniData is an extended-relational, ODBC-compliant database that supports
repeating groups, hierarchies, and arrays. UniData offers both best-of-breed
native interfaces with ActiveX, Java and C interfaces as well as industry
standard
interfaces such as ODBC, OLEDB, and HTTP.
UniData 6.0, targeted for 2H of 2002, will include enhancements to openness,
security, robustness and scalability. This release will provide a native
JDBC
driver as well as support for XML input and output from the database engine.
Security improvements come from the added support of Secure Socket Layer
(SSL) for the HTTP and Socket interfaces as well as encryption options for
the
U2 clients. UniData 6.0 will include real-time replication functionality as
part of
the core database features as well as SQL optimization and additional data
type
support for Microsoft tool access to UniVerse. Finally, an updated Java
applet-based
administration tool will allow administration of multiple U2 systems either
through the included client or any Java-enabled web browser.

IBM intends to continue to enhance, sell and support UniData and to fulfill
Informix's intention to deliver UniData 6.0 and beyond.

-Original Message-
Sent: Thursday, February 14, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L



I have not heard of it but for info you can start at
http://www-4.ibm.com/software/data/u2/unidata/

Rick


 

"KENNETH

JANUSZ"  To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>   
 Subject: Unidata DB

Sent by:

root@fatcity.

com

 

 

02/14/2002

08:43 AM

Please

respond to

ORACLE-L

 

 





Has anyone heard of Unidata DB.  It's relational and from IBM.

Thanks,
Ken Janusz, CPIM



-- 
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: Johnston, Tim
  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: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vulnerability]

[Joan Hsieh]

Hi Ray,

We use dbsnmp on the production server. How it will affect us? Our
system people sent us the same article to us and very concerned the
security.

Joan

Ray Stell wrote:
> 
> Oracle does not seem to be listed, but you got to wonder what code
> they based their snmp stuff on.  You may want to nudge you sysadmin
> in the ribs, also.
> 
> - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> -
> 
> Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
> To: Ray Stell <[EMAIL PROTECTED]>(SD569668)
> 
> SANS FLASH ALERT: Widespread SNMP Vulnerability
> 1:30 PM EST 12 February, 2002
> 
> To: Ray Stell (SD569668)
> 
> Note: This is preliminary data! If you have additional information,
> please send it to us at [EMAIL PROTECTED]
> 
> In a few minutes wire services and other news sources will begin
> breaking a story about widespread vulnerabilities in SNMP (Simple
> Network Management Protocol).  Exploits of the vulnerability cause
> systems to fail or to be taken over.  The vulnerability can be found in
> more than a hundred manufacturers' systems and is very widespread -
> millions of routers and other systems are involved.
> 
> As one of the SANS alumni, your leadership is needed in making sure that
> all systems for which you have any responsibility are protected. To do
> that, first ensure that SNMP is turned off. If you absolutely must run
> SNMP, get the patch from your hardware or software vendor. They are all
> working on patches right now. It also makes sense for you to filter
> traffic destined for SNMP ports (assuming the system doing the filtering
> is patched).
> 
> To block SNMP access, block traffic to ports 161 and 162 for tcp and
> udp.  In addition, if you are using Cisco, block udp for port 1993.
> 
> The problems were caused by programming errors that have been in the
> SNMP implementations for a long time, but only recently discovered.
> 
> CERT/CC is taking the lead on the process of getting the vendors to get
> their patches out.  Additional information is posted at
> http://www.cert.org/advisories/CA-2002-03.html
> 
> A final note.
> 
> Turning off SNMP was one of the strong recommendations in the Top 20
> Internet Security Threats that the FBI's NIPC and SANS and the Federal
> CIO Council issued on October 1, 2001.  If you didn't take that action
> then, now might be a good time to correct the rest of the top 20 as well
> as the SNMP problem.  The Top 20 document is posted at
> http://www.sans.org/top20.htm
> 
> - End forwarded message -
> 
> --
> ===
> Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
>   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: Joan Hsieh
  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: Unidata DB

[Farnsworth, Dave]

Yes 
:o)

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 7:44 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Unidata DB
  Has anyone heard of Unidata DB.  It's relational and 
  from IBM.  
   
  Thanks,
  Ken Janusz, CPIM

Re: Call PL/SQL from MsAccess

[Jared . Still]

Roland,

Believe it or not, the best place to find this is at 
support.microsoft.com.

There are a number of papers there detailing how to use Oracle with
MS products.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/14/02 03:43 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Call PL/SQL from MsAccess


Hallo,

anyone whom can give me an example onhow to write an MsAccess procedure 
which make a call to a pl/sqlprocedure. I want the MsAccess procedure send 
5 parametsrs through to pl/sql.

Thanks in advance


Roland



-- 
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: 
  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: Importing SQL 7.0 tables

[Jared . Still]

If you know the table names already, this Perl script will dump the tables
into CSV format for you.  From there you can build SQL*Loader scripts
to load the data.

For anyone wondering why I didn't just suggest using the Oracle utilities
for migrating from SQL Server to Oracle, it doesn't always work, 
especially
when the SQL Server database has not been managed properly.

Jared



use DBI;

my $dbh =  DBI->connect("dbi:ADO:SERVER NAME HERE","sa",SA PASSWORD 
HERE');

die "could not connect to rsysweb\n" unless $dbh;

my @tables = qw{
dtproperties EVENTS AdminLevel CATEGORIES CONTACTS ...
};

foreach my $table ( @tables ) {
print "Table: $table\n";
my $filename = lc($table) . '.dmp';
open(FILE, ">$filename") || die "could not create $filename - 
$!\n";
my $sql = "select * from $table";
my $sth = $dbh->prepare($sql);
$sth->execute;
print FILE join('|', @{$sth->{NAME_uc}}), "\n";
while ( my $ary = $sth->fetchrow_arrayref ) {
print FILE '<<<' , join('|', @{$ary} ),">>>\n";
}
 
close FILE;
}

$dbh->disconnect;






"Ferry Situmorang" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/13/02 08:58 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Importing SQL 7.0 tables


I need to import into Oracle my SQL 7.0 tables.
How could I complete this?

Thanks,

Ferry Situmorang: 
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ferry Situmorang
  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: 
  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: HOW TO MAKE FAST EXPORT

[Adams, Matthew (GEA, 088130)]

Title: RE: HOW TO MAKE FAST EXPORT





Check the Utilities manual for the 
DIRECT=Y parameter



Matt Adams - GE Appliances - [EMAIL PROTECTED]
I've been so downhearted ever since the day we met.
You're love ain't nothin' but the blues. Baby how blue can you get?
  - Jonny Moore and the Blazers


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 6:20 PM
To: Multiple recipients of list ORACLE-L
Subject: HOW TO MAKE FAST EXPORT



Hi
How to make import fast except BUFFER size increase and big rollback segment 
if I am reorganising the database.
Thanks
-Seema




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Create Database ... really dumb question

[April Wells]

Not per the LESS than Friendly manuals...  

Admin guide, 2-12

-Original Message-
Sent: Thursday, February 14, 2002 10:23 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


Shouldn't your dbname be in double quotes

create database "testcc1"
etc.
etc...


HTH

Lee


-Original Message-
Sent: 14 February 2002 14:29
To: Multiple recipients of list ORACLE-L


create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/


SQL> @afiedt.buf
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL> 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


April,

I think you need parens around the logfiles like:

logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
 '/admin05/cc1test/redo02.log' size 1m reuse,
 '/admin06/cc1test/redo03.log' size 1m reuse)

Your syntax is correct for one log file.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971U3L@:70@;6%Y(&%L
M2!P2!A;GEO
M;F4@;W1H97(@=&AA;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!);F,N(&AA2!R96%S;VYA8FQE('!R
M96-A=71I;VX@=&\@96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI
M6]U(&-A
Mhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  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: April Wells
  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: [EM

RE: whitespaces

[Steven Monaghan]

update mytable
set myfield = rtrim(myfield)
;

That's the simple answer.  If most of your fields do not have trailing
spaces, then:
update mytable
set myfield = rtrim(myfield)
where myfield like '% '
;

If your table is large, you'll need to watch out for rollback issues, etc.
I'm sure there are mails in the archive that address ways to do massive
updates in chunks.

HTH,
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-

-Original Message-
Sent: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Hi,

What query can i run to to eliminate trailing whitespaces. e.g. i have
'abc  ' and want to update the table so any such data is set without the
whitespace, in this case 'abc'

the fiels is varchar2
8.1.7.

cheers



This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
copies of it.  Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Monaghan
  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: Create Database ... really dumb question

[April Wells]

Sorry... really bad day... another script is eating huge amounts of paging
space on prod server... 

turns out that there was corrupt blocks on disk where control file was...
move control file... rerun script... runs fine.

Thank you!

8-)
April

-Original Message-
Sent: Thursday, February 14, 2002 10:29 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


erm... highly embarrassed, slinks off into the corner. That was a total
brain fart...

Here is one of mine that works OK

create database "BRIT"
maxdatafiles 5000
maxinstances 8
maxlogfiles  32
character set "US7ASCII"
national character set "US7ASCII"
datafile
'/oracle01/oradata/BRIT/system001.dbf'  size 100M
logfile
'/oracle03/oradata/BRIT/redoBRIT01.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT02.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT03.log' size 25M;

HTH

Lee


-Original Message-
Sent: 14 February 2002 16:23
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Shouldn't your dbname be in double quotes

create database "testcc1"
etc.
etc...


HTH

Lee


-Original Message-
Sent: 14 February 2002 14:29
To: Multiple recipients of list ORACLE-L


create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/


SQL> @afiedt.buf
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL> 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


April,

I think you need parens around the logfiles like:

logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
 '/admin05/cc1test/redo02.log' size 1m reuse,
 '/admin06/cc1test/redo03.log' size 1m reuse)

Your syntax is correct for one log file.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971U3L@:70@;6%Y(&%L
M2!P2!A;GEO
M;F4@;W1H97(@=&AA;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!);F,N(&AA2!R96%S;VYA8FQE('!R
M96-A=71I;VX@=&\@96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI
M6]U(&-A
Mhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- P

RE: whitespaces

[Kevin Lange]

Try
  update table_name
  set field_name = rtrim(field_name);

I think the Right Trim should clear off the trailing spaces.

-Original Message-
Sent: Thursday, February 14, 2002 8:08 AM
To: Multiple recipients of list ORACLE-L


Hi,

What query can i run to to eliminate trailing whitespaces. e.g. i have
'abc  ' and want to update the table so any such data is set without the
whitespace, in this case 'abc'

the fiels is varchar2
8.1.7.

cheers

-- 
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: Kevin Lange
  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: Unidata DB

[Janke, Mark]

UniData and UniVerse 
are extended relational databases that were acquired as part of the Informix 
buyout. UniData was originally developed by the UniData Company and UniVerse was 
developed by VMark; VMark also developed Data Stage, using the UniVerse DB. The 
two companies merged to form Ardent, which then merged with Informix. Then 
Informix split itself in two, with the various Informix databases, including 
UniData, being bought by IBM while Data Stage and other data warehouse stuff 
remained with Informix, which was renamed Ascential 
Software.
 
Here's a link. 
UniData and UniVerse together are referred to as U2 by IBM.
 
http://www-3.ibm.com/software/data/u2/
 
Mark 
Janke
American Trans 
Air
 
-Original Message-From: KENNETH JANUSZ 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 8:44 
AMTo: Multiple recipients of list ORACLE-LSubject: Unidata 
DB
Has anyone heard of Unidata DB.  It's relational and from 
IBM.  
 
Thanks,
Ken Janusz, CPIM

RE: whitespaces

[Jon Baker]

Title: RE: whitespaces





use the rtrim function.


rtrim(char[,set])   - char, with final characters removed after the last character not in set.  set defaults to ' '.


i.e.:


update  set =rtrim();




Jon Baker   
Database Architect
<[EMAIL PROTECTED]>
www.netsec.net


 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: whitespaces



Hi,


What query can i run to to eliminate trailing whitespaces. e.g. i have
'abc  ' and want to update the table so any such data is set without the
whitespace, in this case 'abc'


the fiels is varchar2
8.1.7.


cheers


-- 
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: Unidata DB

[Glenn Stauffer]

Different product:

>From a posting on comp.databases:

it actually started life as a system called GIRLS. Meant for tracking 
helicopter parts. It then split into two - owned by two companies called Pick 
Systems and Microdata. Pick Systems then licenced their version which became 
Reality, D3, and a variety of others. Pick Systems has now bought back nearly 
all of its licencees and through various machinations is now a company called 
Raining Data.

The Microdata developers split up as well, leading to Revelation, Open
Insight, Prime Information, UniVerse, Unidata, ... IBM has now swallowed
up the last-named three as part of its takeover of Informix.

End Quote

You can take a look at the IBM website for more information on the Unidata 
database - the IBM U2 product family:

"IBM UniData® is an extended relational database designed for embedding in 
vertical applications. This nested relational data model allows for rapid, 
intuitive data modeling and fewer resulting tables. UniData simplifies data 
management and query logic, providing more power for on-line, 
high-transaction applications."

--Glenn

On Thursday 14 February 2002 10:13 am, you wrote:
> Um...  Are you sure it's not Universal DB?  AFAIK, that's really just
> DB2... More a marketing thing...
>
> Tim
>
> -Original Message-
> Sent: Thursday, February 14, 2002 8:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Has anyone heard of Unidata DB.  It's relational and from IBM.
>
> Thanks,
> Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Stauffer
  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: Create Database ... really dumb question

[April Wells]

Rick

It was similar to two manuals, a book, and metalink... thus the TREMENDOUS
frustration...

I moved the first control file... and it worked... corrupt block... I AM NOT
AN idiot!!!

Thank you!
April

-Original Message-
Sent: Thursday, February 14, 2002 9:21 AM
To: [EMAIL PROTECTED]; April Wells



April,

Your script sure looks good, you already know that.  The only thing I can
suggest is to specify
character set.  Just guessing

Rick

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse
character set ;




 

April Wells

   
e.com>   cc:

Sent by: Subject: Create Database ...
really dumb question 
root@fatcity.

com

 

 

02/14/2002

08:23 AM

Please

respond to

ORACLE-L

 

 






Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with
this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

(See attached file: InterScan_Disclaimer.txt)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
  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).



begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  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: Create Database ... really dumb question

[Blake Wilson]

I had a similar error to this. What my error turned out to be was the
rollback_segments parameter was not commented out in the initdb.ora
parameter file. The private rollback segments had not been created yet
and oracle could not find them to start the database. I commented out
this parameter until I had created the rollback segments and all was
fine.

Blake

April Wells wrote:
> 
> Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
> life of me see it.  I know there is something REALLY simple wrong with this,
> but I can't find it... ANYWHERE... and the error manual is ever so helpful
> on the errors...  >:\
> 
> THESE are my errors..
> 
> create database testcc1
> *
> ERROR at line 1:
> ORA-01501: CREATE DATABASE failed
> ORA-02084: database name is missing a component
> 
> THIS is my script...
> 
> create database testcc1
> controlfile reuse
> logfile '/admin04/cc1test/redo01.log' size 1m reuse,
> '/admin05/cc1test/redo02.log' size 1m reuse,
> '/admin06/cc1test/redo03.log' size 1m reuse
> datafile '/data10/cc1test_system.dbf' size 100m reuse
> 
> WHAT is wrong with it.  I am really not this inept... really... but I can't
> see what is wrong with the database name.
> 
> Thanks in advance for there not being GAILS of laughter... but tiredness is
> getting to me.
> 
> April Wells
> Corporate Systems
> Amarillo Texas
> 
> begin 666 InterScan_Disclaimer.txt
> M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I M=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L M>2!P M:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I M;W!Y:6YG(&]F('1H92!I;F9O2!A;GEO;F4@;W1H97(@=&AA
> M;B!T:&4@:6YT96YD960@ M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@ M86=E(&EN(&5R M871E;'D@8GD@7-T96US+"!)
> M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
> M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI M(&)E96X@ M:71Y(&9O M;V9T=V%R92!V:7)U6]U(&-A M(&]W;B!V:7)U %;G0N#0H
> end
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: April Wells
>   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).

begin:vcard 
n:Wilson;Blake
tel;fax:(519) 661-3486
tel;work:(519) 661-2111 ext 85549
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Blake Wilson
end:vcard

MsAccess calling PL/SQL

[Roland . Skoldblom]

Hallo,

anyone whom can give me an example onhow to write an MsAccess procedure which make a 
call to a pl/sqlprocedure. I want the MsAccess procedure send 5 parametsrs through to 
pl/sql.

Thanks in advance


Roland


-- 
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: Create Database ... really dumb question

[Kevin Bass]

I would think that the database name of testccl would need to be in double
quotes.

Kevin Bass
Senior Manager, I.D.E.
Americal Corporation
Phone: (252) 762-2144
E-mail: [EMAIL PROTECTED]


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  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: Kevin Bass
  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: Create Database ... really dumb question

[Robertson Lee - lerobe]

Shouldn't your dbname be in double quotes

create database "testcc1"
etc.
etc...


HTH

Lee


-Original Message-
Sent: 14 February 2002 14:29
To: Multiple recipients of list ORACLE-L


create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/


SQL> @afiedt.buf
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL> 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


April,

I think you need parens around the logfiles like:

logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
 '/admin05/cc1test/redo02.log' size 1m reuse,
 '/admin06/cc1test/redo03.log' size 1m reuse)

Your syntax is correct for one log file.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971Uhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  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: Robertson Lee - lerobe
  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: Create Database ... really dumb question

[Robertson Lee - lerobe]

erm... highly embarrassed, slinks off into the corner. That was a total
brain fart...

Here is one of mine that works OK

create database "BRIT"
maxdatafiles 5000
maxinstances 8
maxlogfiles  32
character set "US7ASCII"
national character set "US7ASCII"
datafile
'/oracle01/oradata/BRIT/system001.dbf'  size 100M
logfile
'/oracle03/oradata/BRIT/redoBRIT01.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT02.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT03.log' size 25M;

HTH

Lee


-Original Message-
Sent: 14 February 2002 16:23
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Shouldn't your dbname be in double quotes

create database "testcc1"
etc.
etc...


HTH

Lee


-Original Message-
Sent: 14 February 2002 14:29
To: Multiple recipients of list ORACLE-L


create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/


SQL> @afiedt.buf
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL> 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


April,

I think you need parens around the logfiles like:

logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
 '/admin05/cc1test/redo02.log' size 1m reuse,
 '/admin06/cc1test/redo03.log' size 1m reuse)

Your syntax is correct for one log file.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971Uhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  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: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City N

RE: View for Procedure/Function SQL Code

[אדר יחיאל]

Hello Aleem

I did a trace from toad and here are the results:

14/02/2002 6:06:10 PM

select /*+ CHOOSE */
 CREATED, LAST_DDL_TIME, 
 OBJECT_ID, STATUS, TIMESTAMP
from ALL_OBJECTS
 where object_name = :objname 
 and object_type = :objtype
 and owner = :ownere 

:OBJNAME = PSTUB
:OBJTYPE = PROCEDURE
:OWNERE = SYS
14/02/2002 6:06:11 PM

select /*+ CHOOSE */ TEXT from ALL_SOURCE where OWNER= :lOWNER and
NAME=:NAME and type = :BTYPE order by LINE

:BTYPE = PROCEDURE
:LOWNER = SYS
:NAME = PSTUB
14/02/2002 6:06:11 PM

select PRIVILEGE, GRANTEE, GRANTABLE, GRANTOR  
 from all_tab_privs
 where table_name = :tname
 and table_schema=:lowner
 order by grantee

:LOWNER = SYS
:TNAME = PSTUB
14/02/2002 6:06:14 PM

Select  /*+ CHOOSE */ Line, Position, substr(text,1,200) text From
All_Errors where owner=:owner  and name=:ObjName and type=:objType order by
sequence

:OWNER = SYS
:OBJNAME = PSTUB
:OBJTYPE = PROCEDURE
14/02/2002 6:06:15 PM

Select /*+ CHOOSE */ distinct 
  owner uses_owner,
  name object_used, 
  type 
from ALL_DEPENDENCIES
where 
 referenced_owner=:owner and 
 referenced_name=:name and 
 ( referenced_type<>'NON-EXISTENT') and 
 ( referenced_type=:type 
 ) 

:NAME = PSTUB
:TYPE = PROCEDURE
:OWNER = SYS
14/02/2002 6:06:17 PM

Select /*+ CHOOSE */ distinct 
  referenced_owner uses_owner,
  referenced_name object_used, 
  referenced_type 
from ALL_DEPENDENCIES
where 
 owner=:owner and 
 name=:name and 
 ( type=:type 
 ) 

:NAME = PSTUB
:TYPE = PROCEDURE
:OWNER = SYS
14/02/2002 6:06:19 PM

select /*+ CHOOSE */ argument_name Argument, data_type,  in_out,
data_length, data_precision, default_value 
 from all_arguments where (owner=:lowner) and 
 (data_level=0) and 
 (object_name=:objName) 
 and (package_name is null) 
and object_id = ( 
 select object_id from 
 all_objects where (owner=:lowner) and 
 object_name =:objName
 andobject_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION'))
 order by position

:LOWNER = SYS
:OBJNAME = PSTUB
14/02/2002 6:06:34 PM

select /*+ CHOOSE */ TEXT from ALL_SOURCE where OWNER= :lOWNER and
NAME=:NAME and type = :BTYPE order by LINE

:BTYPE = PROCEDURE
:LOWNER = SYS
:NAME = ODCISTATSOPTIONSDUMP


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Abdul Aleem [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, February 14, 2002 9:13 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  View for Procedure/Function SQL Code
> 
> Hi!
> Is there a view to see the code written in the procedure/function code,
> the
> parameters, return types etc.
> TIA!
> 
> Aleem
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Abdul Aleem
>   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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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: Create Database ... really dumb question

[April Wells]

Okay... so it wasn't such a dumb question... there is bad block on the disk
where the contolfile is... changing where I put it fixed the problem...

Thank you all.

-Original Message-
Sent: Thursday, February 14, 2002 7:23 AM
To: Multiple recipients of list ORACLE-L



Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971Uhttp://www.orafaq.com
-- 
Author: April Wells
  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: April Wells
  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).

DBA-Database Storage using Net Appliance

[Berkmeyer, Sue]

Hi Everyone,

I am getting pressure from the system guys to use a Net Appliance
filer for Oracle Applications databases.  I currently have the Apps Release
11.0.3 production database on a Sun E4500, 4G RAM, 6CPU@400Mhz and a Sun
storage array with a mix of 4 and 9G drives.  The production datafiles are
on Raid 0+1.  The production software is mirrored only.  Sequential files
are not "raided".  I have gone out to the Net Appliance web site and have
download papers about how to implement Oracle on the filer.  I would like to
hear from real users rather than the vendor about how this works.  Therefore
I am curious to find out anyone's experience with this storage technology -
good or bad.  If anyone has any insights about the Net Appliance technology
itself i.e. raid level, etc. that would be great too.  We are also
considering a new Sun direct attached storage solution.  Thanks for your
time.

National Renewable Energy Laboratory
Sue Ellen Berkmeyer
Database Administrator
Phone:  303-275-4143
Fax:  303-275-3603
E-mail:   [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Berkmeyer, Sue
  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: LMT to DMT

[Joan Hsieh]

Thanks, I don't have pkzip, just winzip. Don't worry, I got it from 
http://www.winzip.com/xcmdline.htm

Joan

àãø éçéàì wrote:
> 
> Hello Joan
> 
> Try : pkzip -add zipfilename *.txt
> 
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From: Joan Hsieh [SMTP:[EMAIL PROTECTED]]
> > Sent: Wed, February 13, 2002 10:32 PM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  LMT to DMT
> >
> > Hi listers,
> >
> > How to convert the locally management tablespace back to dictionary
> > management tablespace? I used dbms_space_admin migrated all the
> > tablespaces to LMT. Now I want convert back on some tablespaces, I
> > remember I read the notes indicate step to step how to do this. Just
> > can't find it anymore. Could you please give me some light on this?
> >
> > Another question I posted yesterday, but no replied so far. I post here
> > again.  Thanks,
> >
> > JOan
> >
> >
> > I am looking for a solution to zip all the backup files into one
> >  backupset.zip file on NT. I have trouble to find the dos command
> > line to
> >  do this.(pkzip or winzip command line? should executed in a batch
> > file
> >  after backup) Can you share this info with us? This should be a
> > very
> > easy thing to do. NT comand compact /C is not what I want. Thanks,
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Joan Hsieh
> >   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).
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >  This e-mail was scanned by the eSafe Mail Gateway
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   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: Joan Hsieh
  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).

SOLVED: URGENT: need help by point in time recovery

[v . schoen]

Hi Ray,

the instance has only one data and one index tablespace. Hole database is
only 1.5 gig.

I solved my problem. I restored a cold backup to another instance and then I
recreated my controlfile and recoverd my database in time. Then I've
exported my lost table and imported it to production. Everything works fine.

Thanks to all who replied

Regards

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Ray Stell [mailto:[EMAIL PROTECTED]] 
Gesendet: Donnerstag, 14. Februar 2002 14:14
An: Multiple recipients of list ORACLE-L
Betreff: Re: URGENT: need help by point in time recovery



This reminds me of something I always wanted to try to work out.  It seems
like you should be able to rebuild part of a 
db, so that the recovery of a certain tables data would be faster.  That way
you don't spend the time reading all the datafiles for all the TS you don't
need to recover.  

Could you just edit the trace control file to change the structure of the
db, so that the only user TS is the one of interest?



On Wed, Feb 13, 2002 at 12:32:09PM -0800, [EMAIL PROTECTED] wrote:
> Hi list,
> 
> I have a urgent problem. One of our developers has deleted all rows of 
> a table on production database (database of a customer from us). We 
> have a nightly cold backup and database is running in archivelog mode. 
> On same server we have a test instance which has same structure as 
> prod instance, only the folders are others. What I like to do is:
> 
> 1. go to production and backup controlfile to trace
> 2. copy the cold backup (production) from last night into this test 
> instance folders (datafiles, controlfiles...) 3. copy archive logs of 
> production to archive log folders from test 4. startup testinstance 
> nomaount 5. create new controlfile with backuped controlfile from 
> trace 6. recover database until '-dd-mm hh:
> 7. export deleted table and import it in production database
> 
> My question is, if I make a clone of a database from a nightly cold 
> backup, can I recover the database with newer archivelogs. Or is there 
> any other method to get my data back (I don't have a actual export of 
> database)?
> 
> TIA
> 
> 
> Volker Schoen
> E-Mail: [EMAIL PROTECTED] 
> http://www.inplan.de  
> 
> 

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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:
  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 parallel server

[Joe Raube]

Basically, from what I recall Reading in The Fine Manual,
(also do a search on OPS and pinging):

In a nutshell,

If you have two nodes in your OPS setup,
you should dedicated one to doing Selects,
and the other to doing inserts, updates, and deletes.

Disclaimer -- I am not an OPS expert.  ;-)

-Joe

On Thu, 14 Feb 2002 06:18:31 -0800
"Sathish Tatikonda" <[EMAIL PROTECTED]> wrote:

> hi all,
> 
> we are using oracle 8i as our database server. So we have to user OPS
> and not RAC version which comes with 9i. So in light of the above could
> you please give me any pointers for application planning and data
> partitioning. I have some documents on OPS which says this is the most
> important aspect of implementation.
> 
> thanks in advance,
> Sathish.
> 
> -Original Message-
> Sent: Thursday, February 14, 2002 6:48 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sathish,
> 
> Under Oracle's RAC in 9i you don't need to do any of this.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Sathish Tatikonda" <[EMAIL PROTECTED]>
> Date:   2/14/2002 12:33 AM
> 
> Hi all,
> 
> Have you implemented or worked with oracle parallel server. If yes could
> you please point or me some resources about application planning and
> partitioning. 
> 
> thanks in advance,
> Sathish.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Sathish Tatikonda
>   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: 
>   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: Sathish Tatikonda
>   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).

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  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: Create Database ... really dumb question

[Rick_Cale]

April,

Your script sure looks good, you already know that.  The only thing I can
suggest is to specify
character set.  Just guessing

Rick

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse
character set ;




   

April Wells

   
e.com>   cc:   

Sent by: Subject: Create Database ... really dumb 
question 
root@fatcity.  

com

   

   

02/14/2002 

08:23 AM   

Please 

respond to 

ORACLE-L   

   

   






Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
life of me see it.  I know there is something REALLY simple wrong with
this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors...  >:\

THESE are my errors..

create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

(See attached file: InterScan_Disclaimer.txt)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
  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).





InterScan_Disclaimer.txt
Description: Binary data

ORA-600 [1158] on 8.1.7

[Martin Vasas]

Hi,

We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently
crashes with an 
ORA-600 [1158] error. Oracle's "ORA-600 lookup" tool did not have any hits. 
There was no specific 
resolution from Oracle support for this error - just a general suggestion to
upgrade to the latest 
patch  levels.  This is something we are reluctant to do without specific patch
information addressing
our problem.  

Has anyone seen this error on 8.1.7 before?

Regards,

Martin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Martin Vasas
  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).

Extent grab ...

[Anjan Thakuria]

Gurus,

Is there any way to fond out the rate of extent grab by a segment from
the data dictionary.

Thanks in advance.

Anjan


begin:vcard 
n:Thakuria;Anjan
tel;work:817-963-3291
x-mozilla-html:TRUE
url:www.eds.com
org:EDS;Midrange Database Engineering
adr:;;;Fort Worth;Texas;76155;U.S.A
version:2.1
email;internet:[EMAIL PROTECTED]
title:Infrastructure Specialist
fn:Anjan Thakuria
end:vcard

RE: V_$SESSION question

[אדר יחיאל]

SELECT NAME FROM SYS.GV_$DATABASE;

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Ghadge,Sameer [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, February 12, 2002 11:53 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  V_$SESSION  question
> 
> Hi,   
> my problem is as follows:
> I want do determine the machine name (and other info) from pl/sql,of the
> client from which i have logged in
> e.g. suppose i have logged from  machine 'power_machine' as  user 'puser'
> my pl/sql has info. that  the current user 'puser'
> 
> How do i retrive my sid for this session,
> which is in V_$SESSION.
> 
> so basically i want the SID of the current session
> Thx
> Sameer
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ghadge,Sameer
>   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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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).

OT:looking for job

[Tirumala, Surendra]

Hi List,

I am sorry to post this OT request.But considering the job market outside, I
am tempted to give a try.
I will be coming out of my project by the end of this month.
Please mail me at [EMAIL PROTECTED], if you have any Oracle DBA
openings.

Thanks,
Surendra
Consultant DBA
Sony, NJ-USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tirumala, Surendra
  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).

Fw: Limiting RMAN backups-Please help

[Ruth Gramolini]

- Original Message -
To: "Sona" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 9:20 AM


> You could move the file and change the entry in the recovery catalog, I
> quesss. I have never tried this so I'm not sure if it would work.   The
> directory and name of the backupset piece is in rc_backup_piece.handle.
>
> HTH,
> Ruth
> - Original Message -
> From: "Sona" <[EMAIL PROTECTED]>
> To: "Ruth Gramolini" <[EMAIL PROTECTED]>
> Sent: Wednesday, February 13, 2002 6:09 PM
> Subject: Re: Limiting RMAN backups-Please help
>
>
> > Thanks Ruth.
> > Can you tell me how to change the backup location.for e.g if I have
taken
> > backup at location /ora/backup and it is recorded the recovery catalog.
> Now
> > if I want to move the backup to /ora/backup1 .
> > How should i change it in the recovery catalog?
> >
> > TIA
> >
> >
> > - Original Message -
> > From: "Ruth Gramolini" <[EMAIL PROTECTED]>
> > To: "Sona" <[EMAIL PROTECTED]>
> > Sent: Wednesday, February 13, 2002 5:33 AM
> > Subject: Re: Limiting RMAN backups-Please help
> >
> >
> > > Exactly!  I doesn't create extra backupsets but it creates them
faster.
> > > HTH, Ruth
> > > - Original Message -
> > > From: "Sona" <[EMAIL PROTECTED]>
> > > To: "Ruth Gramolini" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, February 12, 2002 4:19 PM
> > > Subject: Re: Limiting RMAN backups-Please help
> > >
> > >
> > > > Ruth,
> > > > Thanks for replying. Does using multiple channels but just one
backup
> > > space
> > > > parallelize the backup operation?
> > > >
> > > > Thanks
> > > > Sona
> > > >
> > > >
> > > >
> > > > - Original Message -
> > > > From: "Ruth Gramolini" <[EMAIL PROTECTED]>
> > > > To: "Sona" <[EMAIL PROTECTED]>
> > > > Sent: Thursday, February 07, 2002 11:32 AM
> > > > Subject: Re: Limiting RMAN backups-Please help
> > > >
> > > >
> > > > > I only have one backup space and use two channels.  It creates
files
> > of
> > > > only
> > > > > 2 gig on backup space.  Rman takes care of all the underlying
stuff.
> > > > >
> > > > > Ruth
> > > > > - Original Message -
> > > > > From: "Sona" <[EMAIL PROTECTED]>
> > > > > To: "Ruth Gramolini" <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, February 07, 2002 2:19 PM
> > > > > Subject: Re: Limiting RMAN backups-Please help
> > > > >
> > > > >
> > > > > > Ruth,
> > > > > > Thanks fro your reply.
> > > > > >
> > > > > > This code will limit the size of each backup set to 2GB.Is there
> any
> > > way
> > > > > we
> > > > > > can limit the backup size in each of the volumes depending on
how
> > much
> > > > > space
> > > > > > is available in those volumes.
> > > > > >
> > > > > > For e.g if i want to limit
> > > > > > /disk1 to 40GB
> > > > > > /disk2 to 10GB
> > > > > > /disk3 to 10GB
> > > > > > /disk4 to 10Gb
> > > > > > I guess what i'm trying to do is the total size of the backup
> serts
> > > > going
> > > > > to
> > > > > > a particaluar location for e.g. /disk1 should be limited to
40GB.
> > > > > >
> > > > > > Can we do this?
> > > > > >
> > > > > > Also how do I paralleilize backups if I have only 1 backup
> > > destination.
> > > > > > For e.g if i have 2 channels with the same destination /disk1
then
> > > will
> > > > > the
> > > > > > 2 channels work in parallel or the paralllization happens only
if
> > the
> > > > > > destination is different.
> > > > > >
> > > > > > allocate channel c1 type disk format /disk1
> > > > > > allocate channel c2 type disk format /disk1
> > > > > > backup
> > > > > > archivelog all;
> > > > > >
> > > > > >
> > > > > > Will the backup happen in parallel or serial and will both the
> > > channels
> > > > do
> > > > > > the stuff?
> > > > > > The reason I'm asking this is because I did the backups of my
> > > > archivelogs
> > > > > > yesterday (about 15 GB) and it took about 50 --55 mins for the
> > > backup.I
> > > > > used
> > > > > > only one channel.
> > > > > > How do I parallelize this operation?
> > > > > >
> > > > > > Appreciate your help.
> > > > > >
> > > > > > Sona
> > > > > >
> > > > > > - Original Message -
> > > > > > From: "Ruth Gramolini" <[EMAIL PROTECTED]>
> > > > > > To: "Sona" <[EMAIL PROTECTED]>
> > > > > > Sent: Thursday, February 07, 2002 6:45 AM
> > > > > > Subject: Re: Limiting RMAN backups-Please help
> > > > > >
> > > > > >
> > > > > > > Here is the code I use to set the limit for each backup set to
2
> > > gig.
> > > > > It
> > > > > > is
> > > > > > > a limit on the channel(s). These code creates two channels for
> > > backups
> > > > > of
> > > > > > > our production database.
> > > > > > >
> > > > > > > replace script alloc_pa1_disk {
> > > > > > > #
> > > > > > > #  Modified  By   Reason
> > > > > > > #  981002rg   created
> > > > > > > #
> > > > > > >   allocate channel diskprdar201 type disk;
> > > > > > >   setlimit channel diskprdar201 kbytes 2097150 maxopenfiles 4;
> > > > > > >   allocate channel diskprdar202 type disk;
> > > > > > >   setlimit channel diskprdar202 kbytes 2097150 max

INFORMIX 7.3 to ORACLE 8.1.7 (New info)

[Sonja Šehović]

Since I said I'll tell you how it went here it is. 

We used Oracle Migration Workbench, and it really works but...(there is
always at least one but). 
In our case, it was amount of tables (more than 800) and data which we had
to put into Oracle. Time effect was also very important. After extensive
testing, we discovered that our scripts are the fastest way.

HTH,
Sonja

>  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  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: Unidata DB

[Rick_Cale]

I have not heard of it but for info you can start at
http://www-4.ibm.com/software/data/u2/unidata/

Rick


   

"KENNETH   

JANUSZ"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: Unidata DB   

Sent by:   

root@fatcity.  

com

   

   

02/14/2002 

08:43 AM   

Please 

respond to 

ORACLE-L   

   

   





Has anyone heard of Unidata DB.  It's relational and from IBM.

Thanks,
Ken Janusz, CPIM



-- 
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 and Apache Web server bottleneck

[Vergara, Michael (TEM)]

Hm...a 12x36 disk array.  Is that an AutoRAID?

I had one of those hooked up to a 6-way K570 running PeopleSoft
over Oracle 8.0.5.  Yuck.  P**s-poor performance all the way 
around.  Especially when the disks started to fill up.  The 
problem was that the array got so busy internally swapping 
stuff from the RAID 5 area to the RAID 0 area that it could 
not service the I/O requests from the database.  We went to 
a fiber array and most of the problems disappeared.

If you are using an AutoRAID, check your internal statistics
to see if you're swapping like mad in there.

HTH,
Mike

-Original Message-
Sent: Wednesday, February 13, 2002 6:38 PM
To: Multiple recipients of list ORACLE-L


We have a single HP 9000 with 2-360Mhz CPU, 4G ram and a 12 x 36G disk
array.

We were running Oracle Apps 11.0.3 on Oracle 8.0.5, but recently upgraded 
to Oracle 8.1.7.2 so that we could provide web access to purchasing 
(iProcurement) and later to HR (employee self service).

Oh, but do we have a problem.

In testing, with a single instance, we found that the Apache web server was 
able to service 1-10 users very well, 10 - 14 was poor with 1-3 minute 
response time, and above 16, the web browser sessions timed out after 10 
minutes.  The CPUs peg at 100% around the 12 user and stay there.  With 150 
Purchashing users, we have delayed go-live until we get this Apache 
bottleneck solved.

The boss is talking to HP about getting a second server.  Server A will 
have the DB and server B will have apps, Oracle web server and Apache web 
servers.

I'm a thinking that we need to get that Apache web server onto a different 
box of some kind.

Any ideas on dealing with the Apache server problem?


Thx.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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: Vergara, Michael (TEM)
  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: Create Database ... really dumb question

[Ruth Gramolini]

The db_domain=world should be in the init.ora.   $0.02 more,Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 8:53 AM


> db_domain = .world same error
> db_domain = ".world" same error
> db_domain = world same error...
>
> Oracle Version 8.1.7.0
>
> -Original Message-
> Sent: Thursday, February 14, 2002 7:45 AM
> To: '[EMAIL PROTECTED]'
> Cc: April Wells
>
>
> Check Metalink Note : 56016.999
>
> Samir
>
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
>
>
> -Original Message-
> Sent: 14 February 2002 13:23
> To: Multiple recipients of list ORACLE-L
>
>
>
> Okay... I am at a loss.  There is SOMETHING wrong, and I can not for the
> life of me see it.  I know there is something REALLY simple wrong with
this,
> but I can't find it... ANYWHERE... and the error manual is ever so helpful
> on the errors...  >:\
>
> THESE are my errors..
>
> create database testcc1
> *
> ERROR at line 1:
> ORA-01501: CREATE DATABASE failed
> ORA-02084: database name is missing a component
>
> THIS is my script...
>
> create database testcc1
> controlfile reuse
> logfile '/admin04/cc1test/redo01.log' size 1m reuse,
> '/admin05/cc1test/redo02.log' size 1m reuse,
> '/admin06/cc1test/redo03.log' size 1m reuse
> datafile '/data10/cc1test_system.dbf' size 100m reuse
>
> WHAT is wrong with it.  I am really not this inept... really... but I
can't
> see what is wrong with the database name.
>
> Thanks in advance for there not being GAILS of laughter... but tiredness
is
> getting to me.
>
> April Wells
> Corporate Systems
> Amarillo Texas
>
>
>
>
___
> This email is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented are
> solely those of the author and do not necessarily represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised that you have received
> this
> email in error and that any use, dissemination, forwarding, printing, or
> copying of this email is strictly prohibited.
>
> If you have received this email in error please notify the
SchlumbergerSema
> Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
>
>
>






>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: April Wells
>   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: April Wells
>   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).