from:"MacGregor, Ian A."

 
  with the same ID number for different records. Is there ever a case 
  when this roll-your-own approach makes sense, and is workable?
  
  * Stored sequences. I worked on one app that used a separate 
  sequence for each automatically generated primary key. I worked on 
  another app, a smaller one, that used the same sequence for more 
  than one table. The only issue that I recall is that sometimes 
  numbers would be skipped. But end users really didn't care, or even 
  notice.
  
  * The SYS_GUID approach. I've never used SYS_GUID as a primary key 
  generator. I wonder, was that Oracle's motivation for creating the 
  function? Has anyone used it for primary keys in a production app? 
  What's the real reason Oracle created this function?
  
  * Similar to SYS_GUID, I once worked on an obituary-tracking 
  application that built up a primary key from, as best I can recall 
  now: date of death, part of surname, part of first name, and a 
  sequence number used only to resolve collisions, of which there were 
  few. The approached worked well, actually, because whatever fields 
  we munged together to generate a primary key gave us a unique key 
  the vast majority of the time.
  
  The SYS_GUID approach is interesting, but if you need an ID number 
  that users will see, and that users might type in themselves (e.g. 
  social security number), is SYS_GUID really all that viable?
  
  Best regards,
  
  Jonathan Gennick --- Brighten the corner where you are 
  http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
  
  Join the Oracle-article list and receive one
  article on Oracle technologies per month by
  email. To join, visit
  http://four.pairlist.net/mailman/listinfo/oracle-article, 
  or send email to [EMAIL PROTECTED] and 
  include the word subscribe in either the subject or body.
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  
  -
  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.net
  -- 
  Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]

__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard 
http://antispam.yahoo.com/whatsnewfree
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 do you genrate primary keys?

 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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: TOMPKINS, MARGARET
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: How do you generate primary keys?

 and delete this e-mail message from your computer, 
Thank you.

**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: How do you generate primary keys?

 concurrency 
 issues, though.
 
 
 2. Stored sequences.
 Although I prefer not to use a Sequence as a PK in itself  [preferring
 natural column/s which are Unique keys, with the NOT NULL, of course], 
 I have used a Sequence in an Advanced Replication implementation that 
 had no Primary Key and I needed a PK for Conflict Resolution [this was 
 years ago and, if you ask me, I can't remember all the details]
 
 3. SYS_GUID
 SYS_GUID I've never used.  It doesn't generate a NUMBER value so it is
 not really similar to a Sequence. Can user's key in a 
 SYS_GUID-generated value ?  Is it really human readable or 
 recallable as a plain NUMBER, Security Security Number,
 ZIP Code ??
 
 4. Similar to SYS_GUID ..
 You hit on a fortuitous combination of columns.
 
 
 Hemant
 
 At 05:19 AM 05-11-03 -0800, you wrote:
 The recent article that mentioned sequences got me to thinking. I
 might pitch a more detailed article on sequences to Builder.com. But 
 a more interesting article might be one that explored various ways to 
 automatically generate primary keys. So, in the name of research, let 
 me throw out the following questions:
 
 What mechanisms have you used to generate primary keys? Which ones
 worked well, and why? Which mechanisms worked poorly?
 
 I've run up against the following approaches:
 
 * Hit a table that keeps a counter. This is the roll your own
 sequence method. The one time I recall encountering this approach, I 
 helped convert it over to using stored sequences. This was because of 
 concurrency problems: with careful timing, two users could end up 
 with the same ID number for different records. Is there ever a case 
 when this roll-your-own approach makes sense, and is workable?
 
 * Stored sequences. I worked on one app that used a separate sequence
 for each automatically generated primary key. I worked on another 
 app, a smaller one, that used the same sequence for more than one 
 table. The only issue that I recall is that sometimes numbers would 
 be skipped. But end users really didn't care, or even notice.
 
 * The SYS_GUID approach. I've never used SYS_GUID as a primary key
 generator. I wonder, was that Oracle's motivation for creating the 
 function? Has anyone used it for primary keys in a production app? 
 What's the real reason Oracle created this function?
 
 * Similar to SYS_GUID, I once worked on an obituary-tracking
 application that built up a primary key from, as best I can recall 
 now: date of death, part of surname, part of first name, and a 
 sequence number used only to resolve collisions, of which there were 
 few. The approached worked well, actually, because whatever fields we 
 munged together to generate a primary key gave us a unique key the 
 vast majority of the time.
 
 The SYS_GUID approach is interesting, but if you need an ID number
 that users will see, and that users might type in themselves (e.g. 
 social security number), is SYS_GUID really all that viable?
 
 Best regards,
 
 Jonathan Gennick --- Brighten the corner where you are
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Antw: RE: I wanna know how Oracle uses file organization in

2003-10-31 Thread MacGregor, Ian A.

A B-Tree is not a binary structure, but an n-ary one.  A true binary tree bifurcates, 
By that I mean
Root node A connects to branch nodes C  and D, Branch node C connects to branch nodes 
E and F.  Branch Node D connects to branch nodes  G and H  and so forth.  Each node is 
directly connected to two other nodes progressing from the root to the leaves.  

This just is not true in a B-Tree.  In a B-Tree the branching is not always two-way.  
Root node A may  directly connect to nodes B, C and D.  B may connect to E, F, G, H 
and I, C  to J, K, and L, ands D to M, N, O, P, Q, R and S.   The 7 connects form D to 
its child nodes are the most in this example.  This tree is said to be of order 7.  

See The Art of Computer Programming  (Vol. 3 Sorting and Searching) by Donald Knuth.

The real mark of a B-Tree is that all leaves are at the same level.  This is not 
usually true for a binary tree.  You should understand the basic inserting and 
splitting process which makes the first statement possible.

I used to think that perhaps the B meant balanced. But the term balanced-tree refers 
to a structure first  defined by two Russian mathematicians in a paper published 1962. 
 The true  B-tree was defined in 1970 and its structure published in 1972.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  

-Original Message-
Sent: Thursday, October 30, 2003 10:49 PM
To: Multiple recipients of list ORACLE-L


Hi Sinardy,

one little correction: you forgot the winking smiley
at the end of your last sentence ;-)

Greetings,
Guido

 [EMAIL PROTECTED] 31.10.2003  05.39 Uhr 
Hi Thai,

B-tree is short for binary tree, Indexing method make use of Binary search function to 
fast retrieve your records, therefore require sorted records.
B+ tree (I don't know this one, never heard)

Go to www.Oracle.com download the document for free.

Reading order:
1. Concept
2. SQLPlus
3. DB Admin
4. Backup and Recovery
5. Network

After you finish all of these you have basic skill, you can be an Oracle DBA.


Good luck.

Sinardy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guido Konsolke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread MacGregor, Ian A.

Title: Message

Theexploit involves passing a large argv[1] argument to
the oracle or oracle0 binary. Credit for discovering
thevulnerability goes to [EMAIL PROTECTED]. The error was
first discovered on a LINUX box but I have seen notes that AIX is vulnerable as
well. What is not published in North America yet, is the Oracle alert you
mention. The first security note I saw on this was published on 19
October. Yes there are people who know how to exploit
the vulnerability. The vulnerability was shown to Oracle
over a month ago, according to the comments in a proof of concept
exploit.

One
workaround is to take off the setuid bit from the Oracle
binary Isit really necessary to set this. How many
places still have users log into the database
server? Oracle has recommended putting its databases behind
firewalls for some time.

Ian
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 6:25 AMTo: Multiple
recipients of list ORACLE-LSubject: [SPAM:#] Do not connect Oracle
DB to the Internet. Oracle Alert #59Important:
Please read the following Oracle Alert.We
strongly recommend that you do not connect the Oracle Databasedirectly to
the Internet.Got your attention? That is what is in
the Alert. These alerts are beginning to come all too often.
Sounds just like Microsoft's software, yeah?Buffer Overflow in
Oracle Database Server BinariesThis is with the Oracle
kernel/binary itself ie 'oracle' or 'oracleO' filein
$ORACLE_HOME/bin.DescriptionA potential buffer
overflow has been discovered in the "oracle" and "oracleO" (the letter O)
binariesof the Oracle Database. A knowledgeable and malicious local user
can exploit this buffer overflowto execute code on the operating system
hosting the Oracle Database server.Products Affected Oracle 9i Database Release 2, Version 9.2.x Oracle 9i Database Release 1, Version
9.0.xPlatforms AffectedAll supported UNIX and Linux operating
system variants.Patch only available for Linux right
now. So who found out this vulnerability? David Litchfield?
Aaron Newman?I know it is a bit silly to ask but does anyone know how
to exploit this vulnerability? Send it to me directly if you dont
want to reply publiclytatony

RE: Data Transfer between two instances

2003-10-20 Thread MacGregor, Ian A.

Title: Message



On the 
application which needs the data,can you use CTAS with nologging? This is 
a pretty fast way of transfering data. Have you investigated 
transportable tablespaces. How current does the data have to be? 


Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  
  -Original Message-From: Gunnar Berglund 
  [mailto:[EMAIL PROTECTED] Sent: Sunday, October 19, 2003 
  10:39 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Data Transfer between two instances
  Hi all,
  
  we have an application which needs data from other environment (which is 
  actually SAP db). Currently we have implemented it the way we create flat 
  files and put them in using pl/sql -procedures but I don't like this because 
  the data in the flat files are "visible" and it is somehow "secret".
  
  What other options we might have if we do not want to use db links 
  (because of its slowness.
  
  I very much appreciate all your suggestions...
  
  TIA
  gb
  
  
  Want to chat instantly with your online 
  friends?Get 
  the FREE Yahoo! Messenger

RE: anyone have opinions on the future of the 'grid'?

2003-10-16 Thread MacGregor, Ian A.

The grid is presently at version 1.0, and like any 1.0 release is fraught with 
problems.  One doesn't just install the grid, but installs several packages which have 
interdependencies to the extent that upgrading one will almost certainly cause 
failures somewhere else.  

I digress...
A developer wanted to use a materialized view for data aggregation.  I explained what 
he needed had to be done on the database containing the data to be summarized, that he 
would need to have a count of the records as part of the aggregation, and added that 
the wind must be due west at a steady 10 knots, and there must be exactly five clouds 
visible in the sky.

This has become known here as the five-cloud rule.  The grid today is very much 
governed by the five-cloud rule.

However, like anything new technology with proper effort it will improve.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


 

-Original Message-
Sent: Thursday, October 16, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L


Current issue of ComputerWorld has an article on Grid, but I enjoyed the fantastic 
cartoon  :)


- Kirti 


--- Jared Still [EMAIL PROTECTED] wrote:
 Here's a recently curmudgeonly reply to a friend that
 asked the same question.
 
 -
 
 As for 10g itself: the 'g' stands for 'grid' as you probably know.
 
 The 'grid' is really the infrastructure for 'utility computing', the 
 latest plot to make IT folks obsolete.  Personally I see it being 
 useful in large organizations where large numbers of servers can be 
 used in a grid, and computing power being doled out to apps as needed.  
 It's still very much vaporware, as the tools to effectively administer 
 and monitor this aren't available yet.
 
 I don't agree with the prognostications that businesses will begin 
 buying computing power from a utility computing company on an as 
 needed basis, much as they do electricity.
 
 The whole 'utility' part of the moniker is a pretty poor analogy IMO.
 
 Oracle's last big push was RAC.  Reading the news makes it pretty 
 obvious why they're pushing it: revenue is down, few new customers, 
 gotta sell new stuff to existing ones.  The hype for RAC was/is really 
 overblown, not many people actually need it, nor can afford to 
 purchase and maintain it.
 
 10g will help Larry run in the America's Cup again.  :)
 
 On Thu, 2003-10-16 at 08:04, [EMAIL PROTECTED] wrote:
  I was at the Wash DC Oracle conference yesterday and the key note 
  address was about the future
 direction of Oracle. It was pretty positive about Grid technology and 
 blade servers. Anyone out there have any opinions?
  
  It seems like this technology is probably several years away from 
  being used in the business
 and government contracting world. Most places you see it are in 
 academia.
  




__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

BROKEN_PIPE during Weblogic J2EE deployment

2003-10-06 Thread MacGregor, Ian A.

As Weblogic is not an Oracle product, it is not surprising that Metalink  returned 
nothing.  Try your query on Google.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, October 06, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


Our web administrator was deploying a new J2EE application to production and received 
the error broken_pipe. We are using the thin client. Apparently Weblogic tries to 
verify existence the tables the application uses. The deployment was otherwise 
successful in that the error occurred several times when deployment was retried but 
testing the app worked fine. They feel it was a database error, but I don't see 
anything on my end. Naturally they are nervous about this error just going into a 
critical new application. Apparently if the database was down, this is the error 
returned on the Weblogic side, but the database was fine and I couldn't find any 
errors. I searched for broken_pipe on Metalink and the search returned empty. Has 
anyone had any experience with this Weblogic error?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Separate Indexes and Data

2003-10-01 Thread MacGregor, Ian A.

Part of the problem is self-inflicted.  We currently use separate tablespaces for each 
 major project.  For instance:  chemical inventory  gets its own data and index 
tablespaces,  dosimeter data gets the same,  network configuration data as well.  For 
many projects once the design has matured new segment creation is rare.   The holes  
remain.  Also data segments cannot be moved willy-nilly, users do not like getting 
unusable index errors.  There are also tables which cannot be easily moved such as 
tables with longs.  These were created before LOBs were available.  Moving data also 
entails a certain amount of risk. Inside a project, we let developers create the 
tables and indexes which are specific to that project.  Very few actually create 
indexes in their proper tablespaces.  Corrective action creates more  holes.  This is 
one reason why I am looking at index and data segments in the same tablespace.   

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]   
-Original Message-
Sent: Tuesday, September 30, 2003 4:25 PM
To: Multiple recipients of list ORACLE-L


But those holes of exactly the right size for new objects to fit into. Since you'll 
presumably move it once it gets about 1,000 extents or so that isn't a huge amount of 
space that's being wasted.



Jay Miller
Sr. Oracle DBA


-Original Message-
Sent: Tuesday, September 30, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


My criticism of the defrag paper was that it did not address what to do when a segment 
grew  large enough to belong in a tablespace with a larger uniform extent size.  
Moving the segment creates  holes in its original tablespace which may close only in 
the fullness of time.  Physical backups of the files comprising the original 
tablespace include this wasted space, this is compounded by how many days backup you 
keep available, and the number of copies of backups. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Security presentation from OracleWorld

2003-10-01 Thread MacGregor, Ian A.

Our security folks just sent me this.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, September 30, 2003 1:35 PM
To: [EMAIL PROTECTED]


I've posted the presentation I gave at OracleWorld last month. This
presentation covers writing secure code in Oracle databases and Oracle
Application Server. The topics covered include:

Managing state
Query parameters
Hidden fields
Cookies
Cross-site scripting
SQL Injection
PL/SQL Injection
Buffer overflows in EXTPROC
Resources

You can download the presentation at
http://www.appsecinc.com/techdocs/presentations.html under the heading
Writing Secure Code in Oracle Presentation.

I welcome comments and criticisms.

Regards,
Aaron
___
Aaron C. Newman
CTO/Founder
Application Security, Inc.
www.appsecinc.com
Phone: 212-420-9270
Fax: 212-420-9680
- Securing Business by Securing Enterprise Applications -

** Attend AppSecInc's FREE Webinars **
- Learn about the latest Database Attacks!
- Learn about the latest data security regulations!

Reserve Your Spot Today at:
http://www.appsecinc.com/webinar


Are You Certifiable? Summer's Hottest Certification Just Got HOTTER!

With a growth rate exceeding 110%, the TICSA security practitioner
certification is one of the hottest IT credentials available.  And now, for
a limited time, you can save 33% off of the TICSA certification exam! To
learn more about the TICSA certification, and to register as a TICSA
candidate online, just go to

http://www.trusecure.com/offer/s0100/


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Separate Indexes and Data

2003-09-30 Thread MacGregor, Ian A.

 starts to touch on the real reason for separating them (i.e. 
different types of I/O, different recovery requirements, etc).  Tables and indexes do 
belong in different tablespaces, but not for reasons of performance.

Cary first designed and implemented OFA in the early 90s and formalized it into a 
paper in 1995.  Quite frankly, it is a brilliant set of rules of how Oracle-based 
systems should be structured, and a breath of fresh air from the simplistic way that 
Oracle installers laid things out at the time. It took several years for Oracle 
Development to see the light and become OFA-compliant, and not a moment too soon 
either.  Just imagine if everything were still installed into a single directory tree 
under ORACLE_HOME? All of things you mention here have nothing to do with OFA.

Please read the paper.

Hope this helps...

-Tim

P.S.By the way, multiple block sizes are not intended for
performance
optimization;  they merely enable transportable tablespaces between
databases with different block sizes.


on 9/25/03 11:04 AM, Thomas Day at [EMAIL PROTECTED] wrote:


 I would love to have a definitive site that I could send all RAID-F 
 advocates to where it would be laid out clearly, unambiguously, and 
 definitively what storage types should be used for what purpose.

 Redo logs on RAID 0 with Oracle duplexing (y/n)?
 Rollback (or undo) ditto?
 Write intensive tablespaces on RAID 1+0 (or should that be 0+1)? Read 
 intensive tablespaces on RAID ? (I guess 5 is OK since it's
cheaper
 than 1+0 and you won't have the write penalty)

 While we're at it could we blow up the OFA myth?  Since you're
tablespaces
 are on datafiles that are on logical volumns that are on physical
devices
 which may contain one or many actual disks, does it really make sense
to
 worry (from a performance standpoint) about separating tables and
indexes
 into different tablespaces?

 We have killed the everything in one extent myth haven't we?
Everybody's
 comfortable with tables that have 100's of extents?

 And while we're at it, could we include the Oracle 9 multiple
blocksizes
 and how to use them.  The best that I've seen is indexes in big
blocks,
 tables in small blocks --- uh, oh, time to separate tables and
indexes.

 Maybe we will never get rid of the OFA myth.

 Just venting.

 Tired of arguing in front of management with Oracle certified DBAs
that
 RAID 5 is not good, OFA is unnecessary, and uniform extents is the
only
way
 to go.  Looking for a big stick to catch their attention with.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

RE: RE: Separate Indexes and Data

2003-09-30 Thread MacGregor, Ian A.

My criticism of the defrag paper was that it did not address what to do when a segment 
grew  large enough to belong in a tablespace with a larger uniform extent size.  
Moving the segment creates  holes in its original tablespace which may close only in 
the fullness of time.  Physical backups of the files comprising the original 
tablespace include this wasted space, this is compounded by how many days backup you 
keep available, and the number of copies of backups. 

You have chosen to get around the segment migration problem by using one very large 
extent size for everything.  Don't you find 5M extents wasteful?  What is your block 
size and the median number of used blocks for your segments outside of the system 
tablespace?  How many such segments are there?.  

Also many of us use a single backup system to support multiple databases.  The number 
of segments outside the system tablespace here is over 125,.  Making all segments 
at least 5M in size would have a major impact on file sizes, which in turn would have 
a major impact on backup times, and possibly the size of the  tape library needed.

I'm interested in the flaws in autoallocate. Does it allocate the wrong amount of 
space?  


Ian MacGregor
[EMAIL PROTECTED]  

-Original Message-
Sent: Tuesday, September 30, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L


the defrag paper was written back in 1998 I believe. Uniform extents were a good 
solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m 
extent size even though I have tables that can fit into 128k extents, but feel that 
the overall time savings by using 1 extent size makes up for this.

unfortunately unlike most systems we cannot break up our tables into different 
tablespaces. We use transportable tablespaces to batch publish data to data marts. New 
tablespaces mean additional transportable tablespaces and more places for stuff to go 
wrong. 

I saw some posts on dejanews recently from some pretty experienced DBAs stating that 
there may be 'flaws' in auto-allocate leading to poor extent sizes that leads to 
fragmentation. I believe Rachel Carmichael made a post on here a few months back with 
the similiar experience(could be wrong). Due to even the 'small' chance of flaws in 
auto-allocate, Im thinking of waiting for version 10g before using it. Just to be 
safe. Not worth risking a defrag on a production system. 
 
 From: MacGregor, Ian A. [EMAIL PROTECTED]
 Date: 2003/09/30 Tue PM 01:34:28 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Separate Indexes and Data
 
 I'd be very interested to know how many people have their index 
 tablespaces on a different backup schedule from their data tablespaces.  If so how 
 different?  What happens when a media  failure occurs and you must restore from 
 backup?  You would need to have on hand  and apply more redo logs to make the 
 database current.
 
 I understand the argument proffered is separating indexes and data can 
 mean that when physical corruption of the file happens to an index 
 tablespace then all one needs do is to offline, drop, drop and rebuild  
 the index tablespace.  I admit I have not tried off-lining the 
 tablespace first, but you cannot normally drop a tablespace which is 
 being used to enforce referential integrity.  If off-lining the 
 tablespace first does work, I can see someone trying to do the rebuild 
 with the database available and having duplicate records in the parent 
 tables and records without parents in the child tables.
 
 On the size of the segments:  The paper entitled How To Start 
 Defragmenting and Start Living  or something like that strongly advocated uniform 
 extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall.  However 
 the paper Never mentioned what to do when an object that used  to fit nicely into  
 the 128k extent category now  more properly belongs to the 4M category.  If you move 
 the  data, large holes are left in the other tablespace, and while this does not 
 impact Oracle performance, it does mean that your physical backups are larger than 
 necessary.  I am in the process of migrating from uniform to autoallocated extents.  
 This means extents of different sizes share the same tablespace.  The extent sizes 
 being multiples of each other.  This removes the argument about not having indexes 
 and data in the same tablespaces due to their different sizes.
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Monday, September 29, 2003 8:10 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Thomas,
 
 It *is* a good idea to separate index data from heap data into 
 different tablespaces. But the reason isn't solely to eliminate I/O 
 competition. Even if I/O competition isn't an issue for you (and the 
 OFA Standard doesn't say that it will be), then it's *still* a good 
 idea to separate your index data from your heap data

RE: Storage Frust....

2003-09-24 Thread MacGregor, Ian A.

Garth Gibson, one of the original inventors of RAID 
(http://www.panasas.com/bio_gibson.html), and currently CTO of Panasas Inc, will be 
here [at SLAC] tomorrow to talk about his research into Object file systems.  The talk 
will be Thursday (tomorrow) at 10:30 in the SCS conference room. 

I wonder if he's heard of BAARF, and what a coup if he would join.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, September 24, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L


Sir Visser,

It would be my honour to enroll you in the BAARF party as party member # 
43 if you like.

Also, if you enroll, I'll send you the whole BAARF.zip file (33 K) which 
contains the story, the dialogues, and the song texts of the BAARF 
musical which we'll do at the Database Forum Gala Dinner on Friday night.

But only if you promise me to give me harsh critique in return!

And that goes for all you other members (or possible members) of the 
BAARF Party, too. Except, of course, the ones going to the Database 
Forum. They'll have to wait.

Mogens

Piet de Visser wrote:

Group,

After another run-in with Storage,
need to Vent Some frustrations:

BAARF 

Thank you.

While I'm at it,
let me add some other RAD ideas:

Frustrated by vendors and manuals,
we were about to turn BAARF into: 
battle against any Raw Filesystems 
(Yes, Yes, I know, a raw-dev is not a FS).

But, not wanting to thread on other ppls turf, we thought

CCCP:
for Compulsory use of a Clustered Computing Platform, 
whose mission should be to elimiate all usage of 
Mulitple, In-duh-vidual, ORACLE_BASE/HOMEs 
and to enforce the use of single-installed Oracle software 
on Clustered file systems.

And to stay in the same retro-atmosphere, we looked at:

USSR:
for Usage of Single System Rollout: 
to proclaim the use of sinle-installed ORACLE_BASE/HOMEs, 
partly inspired by OpenSSI.org

More ideas anyone ?

Don't start me on:
the RAC party : Ridiculous Acronym Creators 
followed by 
the RAW devices: Ridiculous Acronym Worshippers 
or just plain: 
FAD : Funny Acronym Department ? 

No harm, no offence intended anywhere
(except for some storage ppl, maybe)

Getting Late...
Tomorrow is 10G lanch-Europe, 
and all these ideas will be legacy.

Regards,

PdV

  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Hiding passwords

2003-09-23 Thread MacGregor, Ian A.

Identified globally is if you are using  LDAP.  Identified externally is for external 
authentication without LDAP. Kerberos authentication also requires the advanced 
security option or whatever they are calling it.

If you have been successful, Mladen, whose KDC and krb5 software are you using; what 
is the version of that software. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  


-Original Message-
Sent: Tuesday, September 23, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


That is not a problem! Use advanced security and accounts identified globally. As 
long as you're able to authenticate the process with RADIUS, Kerberos or something 
like that, you can work with oracle. 

--
Mladen Gogala
Oracle DBA 



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of O'Neill, Sean
 Sent: Tuesday, September 23, 2003 10:25 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Hiding passwords
 
 
 So the story goes like this.  We're a NT/W2K shop.  We have
 various scripts that run DB related jobs but these are in 
 plain text and we'd like to hide these passwords in some 
 way to allow scripts to run but the passwords not be 
 visible to potential prying eyes.  Has anyone cracked this 
 one yet.  I've had a trawl around MetaLink but found nothing 
 of substance.
 
 -
 Seán O' Neill
 Organon (Ireland) Ltd.
 [subscribed: digest mode]
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: O'Neill, Sean
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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).
 



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Error [Possible Data Loss]

2003-09-22 Thread MacGregor, Ian A.

  DATE
  NANOSECS   NUMBER(9)
  STAT   NUMBER(8)
  SEVR   NUMBER(8)
  OSTAT  NUMBER(16)
  VALUE
CHANARCH_NLC.INT_VALUES
 
  The last column is a varray.  I can retrieve any of the other 
  columns from
 that partition.
  I can also retrieve the value column from any partition before 
  September
 11, 2003.
  Any partition after that fails with the 0ra-600 error  when  the 
  value
 column is selected.
 
  DBV at first gave errors along the lines of
 
  BV-00102: File I/O error on FILE
  (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op 
  eration (-1)
 
  The file is 2018 MB in size.  But resizing the files downwards and 
  back up
 again  fixed
  That problem.  The files are allowed to autoextend with 2018 being 
  the
 maximum size.
 
  This is not the same database which had the  RAID problem.
 
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  
  -
  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.net
 -- 
 Author: Tanel Poder
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
 -- 
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Stuck Query

2003-09-22 Thread MacGregor, Ian A.

Good catch.  It was showing  Waited Known Time, and  the seconds_in_wait  kept 
increasing.  I was fooled by the latter being incremented each time v$session_event 
was queried.  I did run a trace on it to track the waits, but had to kill the session. 
 I've never gotten dbms_system session traces to  work.  They never return anything 
even on newly rebooted machines.  

Ian MacGregor

-Original Message-
Sent: Saturday, September 20, 2003 4:05 AM
To: Multiple recipients of list ORACLE-L


Hi!

How do you verify that your session is still waiting on sequential read? From 
v$session_event? Is the status column saying WAITING there? (if it says WAITED%, then 
your CPU is doing something else already, and this record in session wait just shows 
the last wait).

Tanel.
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, September 20, 2003 12:54 AM


 SQL describe chanarch_nlc.archive_wave_i
  Name  Null?Type
  -  
 --

  PV_ID  NUMBER(38)
  TIMESTAMP  DATE
  NANOSECS   NUMBER(9)
  STAT   NUMBER(8)
  SEVR   NUMBER(8)
  OSTAT  NUMBER(16)
  VALUE
CHANARCH_NLC.INT_VALUES

 SQL describe chanarch_nlc.arch_wave_i
  Name  Null?Type
  -  
 --

  PV_ID  NUMBER(38)
  TIMESTAMP  DATE
  NANOSECS   NUMBER(9)
  STAT   NUMBER(8)
  SEVR   NUMBER(8)
  OSTAT  NUMBER(16)
  VALUE
CHANARCH_NLC.INT_VALUES




 SQL describe chanarch_nlc.int_values
  chanarch_nlc.int_values VARRAY(16384) OF NUMBER(38)

 Select * from chanarch_nlc.arch_wave_i
 Where pv_id = 433 and
 Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00' 
 ORDER BY TIMESTAMP, NANOSECONDS /

 Returns 1 row plus the associated varray data in one second

 Select * from chanarch_nlc.archive_wave_i
 Where pv_id = 433 and
 Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00' 
 ORDER BY TIMESTAMP, NANOSECONDS

 Returns 0 rows in  about a second

 Select * from chanarch_nlc.arch_wave_i
 Where pv_id = 433 and
 Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00' 
 Union all Select * from chanarch_nlc.archive_wave_i
 Where pv_id = 433 and
 Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'

 Returns a single row with the varray data in a second

 However

 Select * from chanarch_nlc.arch_wave_i
 Where pv_id = 433 and
 Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00' 
 Union all Select * from chanarch_nlc.archive_wave_i
 Where pv_id = 433 and
 Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'
 Order by 2,3

 Never returns.  It waits forever on a sequential dbfile read event of 
 one
the files used by the lob  segment which contains the varray data for the value column 
of chanarch_nlc.arch_wave_i.  Nothing appears to be blocking the session.  The query 
plan is as one would expect.

 Similar queries  against different  tables with the same structure 
 proceed
without incident.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

Stuck Query

2003-09-19 Thread MacGregor, Ian A.

SQL describe chanarch_nlc.archive_wave_i
 Name  Null?Type
 -  --
 PV_ID  NUMBER(38)
 TIMESTAMP  DATE
 NANOSECS   NUMBER(9)
 STAT   NUMBER(8)
 SEVR   NUMBER(8)
 OSTAT  NUMBER(16)
 VALUE  CHANARCH_NLC.INT_VALUES

SQL describe chanarch_nlc.arch_wave_i
 Name  Null?Type
 -  --
 PV_ID  NUMBER(38)
 TIMESTAMP  DATE
 NANOSECS   NUMBER(9)
 STAT   NUMBER(8)
 SEVR   NUMBER(8)
 OSTAT  NUMBER(16)
 VALUE  CHANARCH_NLC.INT_VALUES




SQL describe chanarch_nlc.int_values
 chanarch_nlc.int_values VARRAY(16384) OF NUMBER(38)

Select * from chanarch_nlc.arch_wave_i
Where pv_id = 433 and
Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'
ORDER BY TIMESTAMP, NANOSECONDS 
/

Returns 1 row plus the associated varray data in one second

Select * from chanarch_nlc.archive_wave_i
Where pv_id = 433 and
Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'
ORDER BY TIMESTAMP, NANOSECONDS 

Returns 0 rows in  about a second

Select * from chanarch_nlc.arch_wave_i
Where pv_id = 433 and
Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'
Union all
Select * from chanarch_nlc.archive_wave_i
Where pv_id = 433 and
Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'

Returns a single row with the varray data in a second

However 

Select * from chanarch_nlc.arch_wave_i
Where pv_id = 433 and
Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'
Union all
Select * from chanarch_nlc.archive_wave_i
Where pv_id = 433 and
Timestamp between '18-SEP-2003:13:48:00' AND '18-SEP-2003:13:49:00'
Order by 2,3

Never returns.  It waits forever on a sequential dbfile read event of one the files 
used by the lob  segment which contains the varray data for the value column of 
chanarch_nlc.arch_wave_i.  Nothing appears to be blocking the session.  The query plan 
is as one would expect.

Similar queries  against different  tables with the same structure proceed without 
incident.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Error [Possible Data Loss]

2003-09-18 Thread MacGregor, Ian A.

The error was first discovered when we tried to move a partition. ( alter table 
archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA).   The 
table was renamed to OLD_archive_wave_i once it was determined that no new varray data 
was accessible. My theory is that this is logical corruption of the data dictionary, 
but I have not worked out the particulars.

Selecting via an index or FTS does not matter.  What type of error do you believe 
koxsisz1 to be?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Thursday, September 18, 2003 4:13 AM
To: Multiple recipients of list ORACLE-L


Hi!

If even Oracle hasn't seen this error, then probably we can't help much here either. 
Just a wild guess, try to move this partition to another location and select from it 
then (although koxsisz1 isn't a data layer error as far as I understand). Try to read 
using index if available, then using full hint etc..

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 3:04 AM


 This is not my week ...

 Has anyone seen anything like this

 select value from chanarch_nlc.old_archive_wave_i partition (SEP1603)
where pv_id =
*
 ERROR at line 1:
 ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], 
 [],
[], [],
 []

 I have Oracle support working on the problem.They say they have never
seen such an error before.  Oracle though often tells me that. The table looks like

 Name  Null?Type
 -  
 ---
-
 PV_ID  NUMBER(38)
 TIMESTAMP  DATE
 NANOSECS   NUMBER(9)
 STAT   NUMBER(8)
 SEVR   NUMBER(8)
 OSTAT  NUMBER(16)
 VALUE  CHANARCH_NLC.INT_VALUES

 The last column is a varray.  I can retrieve any of the other columns 
 from
that partition.
 I can also retrieve the value column from any partition before 
 September
11, 2003.
 Any partition after that fails with the 0ra-600 error  when  the value
column is selected.

 DBV at first gave errors along the lines of

 BV-00102: File I/O error on FILE
 (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op 
 eration (-1)

 The file is 2018 MB in size.  But resizing the files downwards and 
 back up
again  fixed
 That problem.  The files are allowed to autoextend with 2018 being the
maximum size.

 This is not the same database which had the  RAID problem.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Error [Possible Data Loss]

2003-09-18 Thread MacGregor, Ian A.

The varray data is stored in a LOB.   So I expect direct export will not work.  But 
I'll give it a try.


Ian



-Original Message-
Sent: Thursday, September 18, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Ian,

I was going to recommend to try exporting your problematic partition with direct=y, 
that way normal SQL query processing layer is bypassed in Oracle kernel  all data 
belonging to segment is read directly (thus hopefully avoiding the koxsisz1 crash) ... 
but I'm not sure whether varrays don't turn exp to conventional as is the case with 
objects and LOBs...

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 8:29 PM


 The error was first discovered when we tried to move a partition. ( 
 alter
table archive_wave_i move partition SEP1103 tablespace
CHANARCH_NLC_2003_09_DATA).   The table was renamed to OLD_archive_wave_i
once it was determined that no new varray data was accessible. My theory is that this 
is logical corruption of the data dictionary, but I have not worked out the 
particulars.

 Selecting via an index or FTS does not matter.  What type of error do 
 you
believe koxsisz1 to be?

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]



 -Original Message-
 Sent: Thursday, September 18, 2003 4:13 AM
 To: Multiple recipients of list ORACLE-L


 Hi!

 If even Oracle hasn't seen this error, then probably we can't help 
 much
here either. Just a wild guess, try to move this partition to another location and 
select from it then (although koxsisz1 isn't a data layer error as far as I 
understand). Try to read using index if available, then using full hint etc..

 Tanel.

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, September 18, 2003 3:04 AM


  This is not my week ...
 
  Has anyone seen anything like this
 
  select value from chanarch_nlc.old_archive_wave_i partition 
  (SEP1603)
 where pv_id =
 *
  ERROR at line 1:
  ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], 
  [],
 [], [],
  []
 
  I have Oracle support working on the problem.They say they have
never
 seen such an error before.  Oracle though often tells me that. The 
 table
looks like
 
  Name  Null?Type
  - 
  ---
 -
  PV_ID  NUMBER(38)
  TIMESTAMP  DATE
  NANOSECS   NUMBER(9)
  STAT   NUMBER(8)
  SEVR   NUMBER(8)
  OSTAT  NUMBER(16)
  VALUE
CHANARCH_NLC.INT_VALUES
 
  The last column is a varray.  I can retrieve any of the other 
  columns from
 that partition.
  I can also retrieve the value column from any partition before 
  September
 11, 2003.
  Any partition after that fails with the 0ra-600 error  when  the 
  value
 column is selected.
 
  DBV at first gave errors along the lines of
 
  BV-00102: File I/O error on FILE
  (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op 
  eration (-1)
 
  The file is 2018 MB in size.  But resizing the files downwards and 
  back up
 again  fixed
  That problem.  The files are allowed to autoextend with 2018 being 
  the
 maximum size.
 
  This is not the same database which had the  RAID problem.
 
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  
  -
  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.net
 -- 
 Author: Tanel Poder
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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

ORA-600 Error [Possible Data Loss]

2003-09-17 Thread MacGregor, Ian A.

This is not my week ...

Has anyone seen anything like this

select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id =
   *
ERROR at line 1:
ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [],
[]

I have Oracle support working on the problem.They say they have never seen such an 
error before.  Oracle though often tells me that. The table looks like

Name  Null?Type
-  
PV_ID  NUMBER(38)
TIMESTAMP  DATE
NANOSECS   NUMBER(9)
STAT   NUMBER(8)
SEVR   NUMBER(8)
OSTAT  NUMBER(16)
VALUE  CHANARCH_NLC.INT_VALUES

The last column is a varray.  I can retrieve any of the other columns from that 
partition.
I can also retrieve the value column from any partition before September 11, 2003.  
Any partition after that fails with the 0ra-600 error  when  the value column is 
selected.

DBV at first gave errors along the lines of 

BV-00102: File I/O error on FILE
(/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op
eration (-1)

The file is 2018 MB in size.  But resizing the files downwards and back up again  fixed
That problem.  The files are allowed to autoextend with 2018 being the maximum size.

This is not the same database which had the  RAID problem. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: [SPAM:#] Re: Raid Arrays and Power Loss

2003-09-16 Thread MacGregor, Ian A.

The OS is Solaris 5.8.  The file systems is Veritas. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, September 16, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L


Hi, what is your OS and filesystem?

Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 12:34 PM


 Last Friday was hot here, and rumor has it our  230 KV  power line 
 sagged
and touched some tree branches.  The local power company shut it off. Leaving our 
systems to depend on UPS.  About 30 minutes afterwards one system produced these  
errors.  This was jus before the system went dead

 Fri Sep 12 12:58:40 2003
 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc:
 ORA-00206: error in writing (block 3, # blocks 1) of controlfile
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 
 Error: 5: I/O error Additional information: -1
 Additional information: 8192
 Fri Sep 12 12:58:42 2003
 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc:
 ORA-00221: error on write to controlfile
 ORA-00206: error in writing (block 3, # blocks 1) of controlfile
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27063: skgfospo: number of bytes read/written is incorrect
 SVR4 Error: 5: I/O error
 Additional information: -1
 Additional information: 8192
 Fri Sep 12 12:58:42 2003
 CKPT: terminating instance due to error 221
 Instance terminated by CKPT, pid = 1420
 --
---
 Things look pretty shaky here.  When things were restarted the 
 following
error was produced.
 Fri Sep 12 13:32:01 2003
 ORA-00204: error in reading (block 1, # blocks 1) of controlfile
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27091: skgfqio: unable to queue I/O
 SVR4 Error: 6: No such device or address
 Additional information: 1

 The raid array had not been powered on
 --
 
-
 However
 Fri Sep 12 15:33:08 2003
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27037: unable to obtain file status
 SVR4 Error: 2: No such file or directory
 Additional information: 3
 Fri Sep 12 15:33:11 2003
 ORA-205 signalled during: alter database  mount...

 Now the file system is available, but the file itself has disappeared. 
 It
was not corrupted, just disappeared.  We duplex a copy to an internal disk. So 
recovery was easy.

 However once this was fixed

 Fri Sep 12 16:18:58 2003
 Thread recovery: start rolling forward thread 1
 Fri Sep 12 16:18:58 2003
 Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc:
 ORA-00313: open failed for members of log group 3 of thread 1
 ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log'
 ORA-27037: unable to obtain file status
 SVR4 Error: 2: No such file or directory
 Additional information: 3
 ORA-313 signalled during: ALTER DATABASE OPEN...
 --
 
---
 These files are on a RAID  1 LUN.  Both copies of the file are gone.
Again not corrupted but gone.  I don't know if using duplexing rather than RAID 1 
would have mattered here, but I am changing things so that one group of redo logs is 
on internal disk and written via the duplexing method.




 Ian MacGregor
 Stanford linear Accelerator Center
 [EMAIL PROTECTED]



 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: zhu chao
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

RE: Raid Arrays and Power Loss

2003-09-16 Thread MacGregor, Ian A.

The Raid Array is a Sun  A1000.  I'm not sure the vintage, but the disks are 18 GB. 
The Raid array did not lose its configuration.  The storage is still there.  Neither 
affected file system was every empty, but a couple of files were lost.  One on each 
file system.

The box is located at one of our interaction regions (IR's).  some additional 
information [results truncated]

[EMAIL PROTECTED] $ last reboot  

rebootsystem boot   Fri Sep 12 15:32
rebootsystem boot   Mon Aug 25 14:24

When the 

  Fri Sep 12 13:32:01 2003
 ORA-00204: error in reading (block 1, # blocks 1) of controlfile
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27091: skgfqio: unable to queue I/O
 SVR4 Error: 6: No such device or address
 Additional information: 1

Error occurred the raid box was off.  I had thought that the unix box had already been 
rebooted but that turns out to be false.

After the box was rebooted with the raid array on

Fri Sep 12 15:33:08 2003
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27037: unable to obtain file status
 SVR4 Error: 2: No such file or directory
 Additional information: 3
 Fri Sep 12 15:33:11 2003

The other files on /u1 were fine.  Also concerning 

The other error

Fri Sep 12 16:18:58 2003
 Thread recovery: start rolling forward thread 1
 Fri Sep 12 16:18:58 2003
 Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc:
 ORA-00313: open failed for members of log group 3 of thread 1
 ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log'
 ORA-27037: unable to obtain file status
 SVR4 Error: 2: No such file or directory
 Additional information: 3

The other files are /u2 were fine.  The files in question just disappeared.  I know 
this is not normal and raid boxes do not normally lose files, but it's hard to argue 
against the empirical evidence here that they can.  It may be that either I or the 
folks down an IR-2 induced the problems.  But files were indeed lost on two different 
LUN's.

My current thinking is that the two files were being written when the power was turned 
off on the raid array or there was not enough to keep the disks spinning because the 
UPS had been drained.  The battery for the cache was reporting  low, but based on the 
number of hours it operation.  Should it not have maintained the cache?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 








  
 



-Original Message-
Sent: Tuesday, September 16, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L



Okay, core questions:

-as someone asked, what's the make/model of storage?
-has your raid array lost its config?  In other words, is the storage there, just with 
an empty vtoc/volume table/partition table (insert your particular OS nomenclature) 
-Is the filesystem good, just empty?  When you say the file is gone, is the /u1 
directory empty, or is the filesystem structure there, just that file is gone?

Okay, I just saw your message that shows its solaris 8 + veritas.  Here's what 
probably happened.  The box was powered on without the RAID array powered on and 
consequently veritas doesn't see the disk groups/volumes that are on the RAID array.  
Have you tried doing (as root):

vxconfigd -km enable

This will cause a rescan of the existing volume groups.  Afterwards, what does a 
vxprint -hrt look like?

In general, power loss to a RAID array will not produce the results you describe - I 
think its far more likely that a system-array interaction is preventing proper access 
to your storage.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of MacGregor, Ian A.
 Sent: Tuesday, September 16, 2003 12:34 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Raid Arrays and Power Loss
 
 
 Last Friday was hot here, and rumor has it our  230 KV  power
 line sagged and touched some tree branches.  The local power 
 company shut it off.  Leaving our systems to depend on UPS.  
 About 30 minutes afterwards one system produced these  
 errors.  This was jus before the system went dead
 
 Fri Sep 12 12:58:40 2003
 Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc:
 ORA-00206: error in writing (block 3, # blocks 1) of controlfile
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27063: skgfospo: number of bytes read/written is
 incorrect SVR4 Error: 5: I/O error Additional information: -1 
 Additional information: 8192 Fri Sep 12 12:58:42 2003 Errors 
 in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc:
 ORA-00221: error on write to controlfile
 ORA-00206: error in writing (block 3, # blocks 1) of controlfile
 ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
 ORA-27063: skgfospo: number of bytes read/written is 
 incorrect SVR4 Error: 5: I/O error Additional information: -1

RE: Raid Arrays and Power Loss

2003-09-16 Thread MacGregor, Ian A.

Thanks.  I'll keep this in mind, if it happens again.

-Original Message-
Sent: Tuesday, September 16, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L


My Veritas-trained co-worker says they ran into the same situation in the class and 
fsck was able to find the missing inodes and repair the damage. We were thinking that 
it could be Solaris not flushing the writes that could be your problem.  I was warned 
about that for HP/UX's syncer during training and am told there's a similar function 
on Solaris.

I'm just the messenger...

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 16, 2003 2:05 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Raid Arrays and Power Loss
 
 
 The Raid Array is a Sun  A1000.  I'm not sure the vintage,
 but the disks are 18 GB. The Raid array did not lose its 
 configuration.  The storage is still there.  Neither affected 
 file system was every empty, but a couple of files were lost. 
  One on each file system.
 
 The box is located at one of our interaction regions (IR's).
 some additional information [results truncated]
 
 [EMAIL PROTECTED] $ last reboot
 
 rebootsystem boot   Fri Sep 12 15:32
 rebootsystem boot   Mon Aug 25 14:24
 
 When the
 
   Fri Sep 12 13:32:01 2003
  ORA-00204: error in reading (block 1, # blocks 1) of controlfile
  ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
  ORA-27091: skgfqio: unable to queue I/O
  SVR4 Error: 6: No such device or address
  Additional information: 1
 
 Error occurred the raid box was off.  I had thought that the
 unix box had already been rebooted but that turns out to be false.
 
 After the box was rebooted with the raid array on
 
 Fri Sep 12 15:33:08 2003
  ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
  ORA-27037: unable to obtain file status
  SVR4 Error: 2: No such file or directory
  Additional information: 3
  Fri Sep 12 15:33:11 2003
 
 The other files on /u1 were fine.  Also concerning
 
 The other error
 
 Fri Sep 12 16:18:58 2003
  Thread recovery: start rolling forward thread 1
  Fri Sep 12 16:18:58 2003
  Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc:
  ORA-00313: open failed for members of log group 3 of thread 1
  ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log'
  ORA-27037: unable to obtain file status
  SVR4 Error: 2: No such file or directory
  Additional information: 3
 
 The other files are /u2 were fine.  The files in question
 just disappeared.  I know this is not normal and raid boxes 
 do not normally lose files, but it's hard to argue against 
 the empirical evidence here that they can.  It may be that 
 either I or the folks down an IR-2 induced the problems.  But 
 files were indeed lost on two different LUN's.
 
 My current thinking is that the two files were being written
 when the power was turned off on the raid array or there was 
 not enough to keep the disks spinning because the UPS had 
 been drained.  The battery for the cache was reporting  low, 
 but based on the number of hours it operation.  Should it not 
 have maintained the cache?
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Raid Arrays and Power Loss

2003-09-15 Thread MacGregor, Ian A.

Last Friday was hot here, and rumor has it our  230 KV  power line sagged and touched 
some tree branches.  The local power company shut it off.  Leaving our systems to 
depend on UPS.  About 30 minutes afterwards one system produced these  errors.  This 
was jus before the system went dead

Fri Sep 12 12:58:40 2003
Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
Fri Sep 12 12:58:42 2003
Errors in file /opt/oracle/admin/BBRO/bdump/bbro_ckpt_1420.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
Fri Sep 12 12:58:42 2003
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 1420
-
Things look pretty shaky here.  When things were restarted the following error was 
produced.
Fri Sep 12 13:32:01 2003
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
ORA-27091: skgfqio: unable to queue I/O
SVR4 Error: 6: No such device or address
Additional information: 1

The raid array had not been powered on
---
However 
Fri Sep 12 15:33:08 2003
ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Fri Sep 12 15:33:11 2003
ORA-205 signalled during: alter database  mount...

Now the file system is available, but the file itself has disappeared. It was not 
corrupted, just disappeared.  We duplex a copy to an internal disk.  So recovery was 
easy.

However once this was fixed

Fri Sep 12 16:18:58 2003
Thread recovery: start rolling forward thread 1
Fri Sep 12 16:18:58 2003
Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-313 signalled during: ALTER DATABASE OPEN...
-
These files are on a RAID  1 LUN.  Both copies of the file are gone.  Again not 
corrupted but gone.  I don't know if using duplexing rather than RAID 1 would have 
mattered here, but I am changing things so that one group of redo logs is on internal 
disk and written via the duplexing method.




Ian MacGregor
Stanford linear Accelerator Center
[EMAIL PROTECTED]

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: alter system reset

2003-09-03 Thread MacGregor, Ian A.

Is the want to read the spfile just a curiosity?  One should not rely on either the 
init.ora or the spfile to determine which parameters are set, but should query the 
database.  

Now that we have both init.ora and an spfile someone is going to get caught.  For 
instance a patch requirement requires 150 MB shared_pool and java_pool sizes and warns 
about an unrecoverable memory error if the pools are undersized.  The person dutifully 
makes the changes to the init.ora and starts the database, but forgets that an spfile 
is being used with the database  He then starts the patch and it fails with the 
unrecoverable memory error.

I would have been caught by this if my patchset installation procedure did not include 
show parameter  to verify their settings.

Ian MacGregor  
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, September 01, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Prem,

The SPFILE should never be opened to be modified; opening a file to see the contents 
are acceptable and that's what I said. Sometimes opening the file in an editor may not 
be needed; type in Windows command prompt or cat in unix will let us achive the 
same objective.

Talking about the SPFILE modification, you can't effectively modify it with accuracy. 
The file is binary (actually binary in the beginning and then text towards the bottom 
part), so even if you open it in notepad and save it, there is no guarantee that the 
file will be accurately saved with all contents intact.

By the way, I have edited the SPFILE in some cases, only in development, though; but I 
wouldn't advise it to be done that way; always use ALTER SYSTEM ... SCOPE=SPFILE to 
modify it or edit the init.ora file and then create the SPFILE from it. You can create 
the spfile from pfile even when the instance is down.

HTH.

Arup

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 10:49 PM


 Arup Bhai, i remember oracle docs saying NOT to open a spfile and that 
 it
may even
 corrupt the file.

 Is that always true ?
 Can the spfile be opened ?
 can you kindly explain me ?

 Thanks  Regards,
 Prem Khanna J.


 02-09-2003 04:14:26, Arup Nanda [EMAIL PROTECTED] wrote:
 Does the entry even exist in the SPFILE? Open up the spfile in 
 notepad
and
 check the existence of the parameter in there. Do the following:
 SQL alter system set undo_suppress_errors = false scope=spfile
sid='ananda';
 System altered.
 SQL ALTER SYSTEM RESET undo_suppress_errors scope=spfile 
 SQL sid='ananda';
 System altered.
 Arup



 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Prem Khanna J
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

OKINIT

2003-08-29 Thread MacGregor, Ian A.

I'm getting the following response back from  okinit.

okinit: Password incorrect
okinit: Decrypt integrity check failed.

The password is correct.  Has anybody seen this?  I have some indication, a paper from 
U. of Mich. that this is due to corruption of the keytab file.  But kinit continues to 
work and we have recreated the pricipal many times to no avail.  Any ideas?

Oracle support has been very cooperative, but has not been able to solve the problem 
  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Grid

2003-08-28 Thread MacGregor, Ian A.

2.3 GB from California to Switzerland  is fast, damned fast.   
http://www.cenic.org/CENIC2003/NGIAwards/winners/slac.htm

We are part of several test beds having to do with future networking capabilities.  

Ian MacGregor

-Original Message-
Sent: Wednesday, August 27, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L


i havent seen much about internet 2. i didnt realize there was anything in production 
yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a 
connect anymore. its not that expensive to get 10GB connections or more.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 5:44 PM


  We've been talking of Grid computing here since either late 1999 or
early
 2000.  The computing for our main experiment was designed before the 
 Grid was contemplated.  Still we have implemented some of the 
 middleware
needed,
 and build methods of authentication and authorization, and 
 participated in Grid experiments. We have also been pushing the 
 ability to transfer large amounts of data.  The latest effort: 2.3 GB 
 per second between the local internet hub and Geneva Switzerland over 
 Internet 2.  This is vital to
make
 the Grid work.

 Yep, you'll probably have huge amounts of data coming in when CERN 
 gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're 
 using Oracle...

 Tanel.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Tanel Poder
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Ryan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Grid

2003-08-27 Thread MacGregor, Ian A.

  communication  cannot be guaranteed and the BGS 
accepts no liability  for claims arising as a result of the use of this medium to  
transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Kerberos OKINIT , OKLIST, ORA-12699

2003-08-22 Thread MacGregor, Ian A.

I'm trying to get Kerberos authentication to work.  I am not using LDAP at all.  I 
just want to authenticate  with Kerberos.

Kerberos itself is working fine. kinit and klist work as expected.  I had our 
security admin create a service principle.  Does there have to be one per machine or 
one per database?  Does the service principle need to match the sql*net service name?  
When one issues okinit username what is the format of the username?  No matter what 
I use okinit does not request a password and oklist shows no credentials.

After configuring sqlnet.ora.  I am testing now on the database machine itself any 
connects which employ that version fail with ora-12699 whether or not they are 
identified externally or via the database. 

Being old school, I don't like using aids such as netmgr. Nearly all these types of 
tools are awful when they first come out.  But I tried to use them to setup Kerberos 
authentication.  I save the network configuration, but when I go back into the tool 
nothing appears to be saved.  Is this normal?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Nature of Oracle-l has changed

2003-08-22 Thread MacGregor, Ian A.

We are in the middle of a development revolution here.  It is being driven by a desire 
to allow greater access to the Peoplesoft databases.  The Peoplesoft folks want to 
continue using those tools.  But the folks that are responsible for the application 
server which will connect to Psoft want to use Web Logic or possibly .net.  As we are 
considering J2EE environments, I've asked them to consider Jbuilder, Jdeveloper, and 
IBM's WebSphere stuff.


It will be interesting to see how this plays out.  There is a sect who wants whatever 
is chosen to be the sole development platform here.

Ian


-Original Message-
Sent: Thursday, August 21, 2003 11:19 PM
To: Multiple recipients of list ORACLE-L



Has anyone else noticed?

Not so long ago, we saw quite a few more questions about
such things as data modeling, application security architecture, physical database 
design, and Oracle Designer

Not so much anymore.  

Do you think it's because there are so few development projects taking place?  Seems 
like in house development died with the dot bomb and has not begun to recover.

I know at my place of employment there is very little development, but that is due 
more to the size and nature of this place, as 
well as the management. ( they don't like in house development :( )

Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP 
all over the place and keeping things running.

Not that we haven't always done those things, but I miss some not having a good 
development project.  Ah, to do some real 
data modeling again.

Just some food for thought.

Jared






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Kerberos OKINIT , OKLIST, ORA-12699

2003-08-22 Thread MacGregor, Ian A.

I'm using externally because I am not using a directory service.  

Ian

-Original Message-
Sent: Friday, August 22, 2003 12:42 PM
To: Multiple recipients of list ORACLE-L


With kerberos, you shouldn't do identified externally, you should do identified 
globally. And yes, gooey tools are just for wimps. Real programmers use ed.

--
Mladen Gogala
Oracle DBA 



-Original Message-
MacGregor, Ian A.
Sent: Friday, August 22, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


I'm trying to get Kerberos authentication to work.  I am not using LDAP at all.  I 
just want to authenticate  with Kerberos.

Kerberos itself is working fine. kinit and klist work as expected.  I had our 
security admin create a service principle.  Does there have to be one per machine or 
one per database?  Does the service principle need to match the sql*net service name?  
When one issues okinit username what is the format of the username?  No matter what 
I use okinit does not request a password and oklist shows no credentials.

After configuring sqlnet.ora.  I am testing now on the database machine itself any 
connects which employ that version fail with ora-12699 whether or not they are 
identified externally or via the database. 

Being old school, I don't like using aids such as netmgr. Nearly all these types of 
tools are awful when they first come out.  But I tried to use them to setup Kerberos 
authentication.  I save the network configuration, but when I go back into the tool 
nothing appears to be saved.  Is this normal?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks. Any views expressed in this 
message are those of the individual sender, except where the message states otherwise 
and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

BEA's WebLogic vs. Jdeveloper and iAS

2003-08-16 Thread MacGregor, Ian A.

We are highly interested in having all our Peoplesoft access which does not use 
screens created via Peoplesoft tools to pass through an applications server.  One 
group invited the folks from BEA out, and my thought was, Hey, we are already 
licensed for enterprise iAS, Jdeveloper and the like. Why pay for yet another 
development system.?  However BEA's tool produces modules which invoke the Peoplesoft 
API to put data into Peoplesoft.  This is a major issue with us.  Does any know if 
Oracle has anything that does the same?  


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: possible Bug in Oracle 9.2.0.2

I've no experience with Peoplesoft and Oracle 9, but  ..

Try setting the following parameters

optimizer_features_enable = 8.1.6

As I recall this prevented Oracle from incorrectly tossing out some subselects.  I'm 
not sure if it is even valid in 9iR2

_ignore_desc_in_index = TRUE

Not setting this can result in horrendous performance problems.

Ian MacGregor

-Original Message-
Sent: Wednesday, August 06, 2003 9:19 PM
To: Multiple recipients of list ORACLE-L


Can you please list select emplid, empl_rcd, effdt, effseq,  empl_status 
from ps_job where emplid = '3442'

At 03:34 PM 8/6/2003 -0800, you wrote:
While I am waiting for oracle support to respond to my tar update (2nd
callback) I am just wondering if anybody has found this problem.

We have the following select query (from a peoplesoft implementation)

SELECT a.emplid, a.effdt
FROM PS_JOB A
WHERE A.EFFDT = (SELECT MAX(A1.EFFDT)  FROM PS_JOB A1 WHERE A.EMPLID = 
A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD  AND A1.EFFDT = SYSDATE) AND 
A.EFFSEQ =  (SELECT MAX(A2.EFFSEQ)  FROM PS_JOB A2  WHERE A.EMPLID = 
A2.EMPLID  AND A.EMPL_RCD = A2.EMPL_RCD  AND A.EFFDT = A2.EFFDT) AND 
A.EMPL_STATUS = 'A' and a.emplid='3442'

when we run the query we get one row back, but when we replace the 
field names with count(*), the resulting answer back is 2. We have 
tested it in 8.0.5.1.1 and we get the correct results, 1 row, and a 
count of 1.

Darren

---
-
--
Darren Browett P.EngThis
message was transmitted
Data Administrator  using
100% recycled electrons
Information and Communication Technology
City of Coquitlam
P:(604)927 - 3614
E:[EMAIL PROTECTED]

---



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Browett, Darren
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Merge patches

You should not have to worry unless each of the patches contains the same object file. 
 In that case the second patch will overwrite that part of the first.  But, check the 
patch note before requesting the patch merge.  It may have words to the effect that 
the second patch contains all the changes belonging to the first.

Of course, only apply necessary patches.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, August 11, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L


OK, maybe I'm going crazy or senile, but I seem to recall Oracle stating that if you 
needed to apply more than 1 patch, you would need to request a merge patch.  I think 
this was about a year ago and caused us to downgrade a database to resolve a problem 
since the turn-around time for the merge patch was not going to beet our requirements. 
 

Does anyone else remember this?  Are they still doing this or can multiple 1-off 
patches be applied now?

Stephen 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: what happens if a remove a job that is running?

That will not kill a job which is currently executing.  It simply removes it from the 
queue.  The only way I know to kill a running job is to kill the associated job queue 
process on the server.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

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


Yep. That sounds like your MO :)

Henry

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L


Yes.  If you really want to kill the job, the graceful way is to break it first 
(dbms_job.broken) and then remove it (dbms_job.remove).

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
 Sent: Thursday, August 14, 2003 10:00 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  what happens if a remove a job that is running?
 
 If I run dbms_job.remove on a job that is in dba_jobs_running it 
 remains in that table.
 
 it runs to completion correct?
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: [EMAIL PROTECTED]
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Limits on PL/SQL block?

Title: Message

From the Oracle Docs.
PL/SQL is based on the
programming language Ada. As a result, PL/SQL uses a variant of Descriptive
Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured
intermediate language. It is defined using a meta-notation called Interface
Definition Language (IDL). DIANA provides for communication internal to
compilers and other tools. A DIANA node is
simply a node on this parse tree. For a full defintionof a
DIANAtree see
http://citeseer.nj.nec.com/rosenblum95anna.html
Ian
MacGregor

-Original Message-From:
Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent:
Friday, August 08, 2003 9:59 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Limits on PL/SQL block?

You want more cryptic answer ??
pl/sql block is limited by 64K Diana nodes. my guess is each
node is a token. No one will tell you what a Diana node is, but it is used to
parse pl/sql (after all it is modeled after ADA).
Only solution, instead of testing the limits, break the long
code into manageable chunks. The people who will maintain it will speak fondly
about you.
Raj
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art
!
-Original Message- From: Rudy
Zung [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 08, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject: Limits on PL/SQL block?
I'm seeing a "PLS-00123 program too large" error. Oracle's
documentation says that the actual limit on the size
of the block is dependant on the mix of statements in
the PL/SQL block. Does anyone know how Oracle
determines this limit? Is it a pure size of PL/SQL
block in bytes, or is it number of unique statements
in the block, or is it dependant on how much redo that
the block may generate?
(I know the recommended solution is to modularize and
break up the statements into multiple blocks, but I'd
like to know what are the limits to give us a better
idea of determining where to break up the blocks
dynamically, so the answer I'm really looking for is
what is the limit or how Oracle determines the size
limit, and not workarounds, which we're exploring
anyway.)
TIA
..Rudy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Author: Rudy Zung INET:
[EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
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: OT -- Boston Globe job listings

Deepak The Disemboweler has a nice ring.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, August 14, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L




--
Mladen Gogala
Oracle DBA 



-Original Message-
KENNETH JANUSZ
Sent: Thursday, August 14, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L


 Dennis:

 With respect to sending production DBA positions to India, et al.  I 
 don't
think companies 
 are very included to do
 this because of security concerns

Companies run MS Windows, regardless of the security concerns.

 and the confidentiality of the information stored in the DB.   It's not a
 good idea to open your DB's to the entire world.

Well, technically speaking, India is not the whole world. Populationwise, it's only 
about 20%. As far as I know, there is no Indian mob. We have Italian, Irish, Russian, 
Chinese, Japanese, Polish and other gangs, but I've never heard of an Indian gang. So, 
with respect to security, you might be better off in India then anywhere else in the 
world. You cannot have Bonnie and Clyde, Baby face Nelson or machine gun Kelly with 
the Indian names. Machine gun Deepak just doesn't sound right.




Note:
This message is for the named person's use only.  It may 
contain confidential, proprietary or legally privileged 
information.  No confidentiality or privilege is waived 
or lost by any mistransmission.  If you receive this 
message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or 
indirectly, use, disclose, distribute, print, or copy 
any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries 
each reserve the right to monitor all e-mail 
communications through its networks.

Any views expressed in this message are those of the 
individual sender, except where the message states 
otherwise and the sender is authorized to state them 
to be the views of any such entity.
-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Opatch

2003-08-11 Thread MacGregor, Ian A.

I'm trying to use opatch and receive the following error

[EMAIL PROTECTED] $ opatch apply
PERL5LIB=; export PERL5LIB
/usr/local/bin/perl
/opt/oracle/admin/general/patchsets/opatch/patch2617419/OPat
ch/opatch.pl apply
Can't call method build_option_details on an undefined value at
/opt/oracle/admin/general/patchsets/opatch/patch2617419/OPatch/opatch_modules/Apply.pm 
line 2299.

ORACLE_HOME is correctly set, PATH is correct as well.  Any idea what the problem may 
be.

Every opatch command fails with the above error including such things as opatch 
-version.

Ian MacGregor
Stanford Linear Accelerator Center
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Opatch

2003-08-06 Thread MacGregor, Ian A.

I've now gotten opatch to report its version.  I had to get the right combination of 
the perl executable and perl5 libraries.  I expect the patch will install tomorrow.  I 
too ended up using  per5005_03.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Tuesday, August 05, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


Ian,

what is your Perl version ?

I have that same problem with Perl 5.6 on Aix.
but not with Perl 5005_03  the version
Oracle installed with Oracle HTTP Server.

Contacting OWS, they told me that it didn't reproduced
with Perl 5.8
I didn't have time to upgrade so I sticked with Perl 5005_03.

HTH

Gilles Parc

carpe diem !!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gilles PARC
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Another UNION question

2003-07-31 Thread MacGregor, Ian A.

If the union performed index lookups, but the table example performed a full table 
scan it might.  Of course with iterative index usage the point is deprecated.  However 
before they were introduced the first query would perform an FTS even if emp_type was 
the primary key.  Even with  iterative index usage the union statement is often faster.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, July 31, 2003 5:54 PM
To: Multiple recipients of list ORACLE-L


I'm getting back to work on my union article, and I have yet another union question. 
Are there ever cases where a UNION might be used for performance reasons? For example, 
I could
write:

SELECT *
FROM emp
WHERE emp_type='HOURLY'
   OR emp_type='CONTRACT';

or I could write:

SELECT *
FROM emp
WHERE emp_type='HOURLY'
UNION
SELECT *
FROM emp
WHERE emp_type='CONTRACT';

This is probably too simple of an example, but are there
ever cases where using a UNION like this makes sense from a performance point-of-view?

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 
906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: 10G

2003-07-21 Thread MacGregor, Ian A.

We're already doing grid computing.  My part is infinitesimal.  We keep or MCAT 
database in Oracle
See http://www.npaci.edu/DICE/SRB/, and I try to keep that database healthy.  


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 21, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


Ron,

Still have read them.  :)

From what I already know, this sounds correct.

Fits right in with Sun's N1 technology. 

Jared





Ron Rogers [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 07/21/2003 12:49 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: 10G


Jared,
 Thanks for the articles.
 It looks like to grid concept would require the idle computers in the office to be 
connected to a fiber net and available to pick up part of the load when demand 
increased. Or did I miss-understand the article and each computer has it's own area of 
expertice and answers the request for info only if the data resides on it's local disk?

The grid fits in rather snuggly with the RAC from what I gathered from the articles. 
Ron

 [EMAIL PROTECTED] 07/21/03 03:14PM 
On more serious note:

Here's are links to a couple Oracle grid computing documents.

The first is a newsletter I receive from our local Oracle office.

The second is an OTN document.


http://www.cybcon.com/~jkstill/Jul2003.pdf 

http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCookbook.html



Jared





Daniel Fink [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 
 07/18/2003 01:19 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: 
Subject:10G


I just realized what the upgraded name for 9ias will be...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Microsoft VS Oracle (again)

2003-07-07 Thread MacGregor, Ian A.

Title: Message

Due to
budget constraints, we shutdown last week, and everyone who works here was given
four days off without pay. This was done instead of laying people
off. It was a great vacation, and the family will need to eat beans for a
few days. Anyway, I was just catching up on my mail
...

It is
not just Exchange, but Microsoft Project, the MS Collaboration
Software, MS Operating System Administration tools, and many others
which can introduce SQL*Server to a site.

It's
not just SQL*Server either. One of our Remedy systems is used by a
group which primarily uses LINUX and Sun clients. However Remedy
cannot seem to deliver a system which works with aMozilla browser.
Hence, the users are looking a Bugzilla and MySql.

Ian
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-From: Johnston, Tim
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:41
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Microsoft VS Oracle (again)
"Also, yes they are the "fastest growing" database on
the market, take a look at that copy of Windows 2000 Advanced Server you've
got."

And,
I think all the exchange servers now have Sql*Server as a back end...
Considering they almost own that corner of the market, I bet that adds up to a
license or two...

Tim

-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 4:11
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Microsoft VS Oracle (again)
Well, I'll be a little more forgiving than Raj has
been. Basically MicroSoft is just the "pot calling the kettle
black".

On the issue of price, well yes MicroSoft does
have an edge, but that's just how they've eliminated all of their other
competition over the years. The product does not cost less than Oracle
or DB2, it's just that MicroSoft can leverage the tremendous amounts of cash
they have to offset the giveaway they're into. I believe that was one
of the points of the Antitrust suit they were embroiled in.

On RAC they really have a long way to
go.If you want to do a federated database setup like
MicroSoft states, just buy standard edition Oracle licenses toss in a
pile of database links. Works the same way you don't have to pay
extra for it. The whole idea of RAC is that when one node dies, for
whatever reason, the data that node was hosting is not offline till you get
it repaired. And actually you really do not need to do anything to your
application to take advantage of RAC, except adjust your error handling to
understand that a transaction needed to be resubmitted.

Overall I think MicroSoft's Achilles heel is
Windows. Their a one OS horse. Oracle is a multi OS horse that runs
the same whatever the platform. And BTW, Oracle runs RAC on Red Hat
without any additional software, never mind that it runs on Linux in the
first place. Similar things can also be said for DB2, Sybase, and
Informix. When, if ever, Microsoft has a version of Sql*Server that
runs as multiple independent processes on Linux then I'll give them a second
look. As long as their a single multi-threaded Windows only process
they can stay in Redmond. Also, yes they are the "fastest growing"
database on the market, take a look at that copy of Windows 2000 Advanced
Server you've got. There's a copy of Sql*Server 2000 in there, and you
can't uninstall it. Billy G is still up to his old tricks. The
only solution to MicroSoft is forced divestiture. Too bad that judge
could not stand up to King George.

Dick GouletSenior Oracle DBAOracle Certified 8i DBA

-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003
1:40 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Microsoft VS Oracle
(again)
Aargh ...
you must be very brave telling a Oracle cult to move to SQL
Server ...
How do we know you are not Billy G using an alias ...

8)
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
personal. QOTD: Any clod can have facts, having an
opinion is an art !
-Original Message- From:
Gabriel Aragon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: Microsoft VS Oracle (again)
FYI
One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a "present",
it's a 4 cd's kit called "SQL Server 2000 for the
Oracle Customer", the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of
stuff showing why sql

RE: Re[2]: Online tech books

2003-07-07 Thread MacGregor, Ian A.

Stanford is currently contracting with Books24X7 http://library.books24x7.com/home.asp 
to provide this service.  I'm sure there is a fee, but as the university takes care of 
it, I don't know how  much.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, July 03, 2003 5:26 AM
To: Multiple recipients of list ORACLE-L


here's a practical question:

is there a way to put tech books online?  what about a web site you'd pay a fee to 
use?  i'd really like to have such a thing. [can't grep dead trees.;-)]  is this 
possible?

--
Bill Shrek Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

If you don't know where you're going, any road will take you there.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: salary question

2003-07-07 Thread MacGregor, Ian A.

://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Bewildered by RMAN

2003-06-19 Thread MacGregor, Ian A.

/oracle/admin/NLCO/arch/NLCO_9642_1.ARC
 957019643A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9643_1.ARC
 957119644A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9644_1.ARC

 However

 List backup of archivelog all;

 RMAN list backup of archivelog all;


 List of Backup Sets
 ===

 BS Key  Device Type Elapsed Time Completion Time
 --- ---  ---
 9612SBT_TAPE00:01:37 10-JUN-03
 BP Key: 9613   Status: AVAILABLE   Tag:
 Piece Name: df_496342230_2_1

   List of Archived Logs in backup set 9612
   Thrd Seq Low SCNLow Time  Next SCN   Next Time
    --- -- - -- -
   196451570637555 10-JUN-03 1570654513 10-JUN-03
   196461570654513 10-JUN-03 1570683560 10-JUN-03
   196471570683560 10-JUN-03 1570695830 10-JUN-03
   196481570695830 10-JUN-03 1570708498 10-JUN-03
   196491570708498 10-JUN-03 1570713009 10-JUN-03
   196501570713009 10-JUN-03 1570715177 10-JUN-03

 BS Key  Device Type Elapsed Time Completion Time
 --- ---  ---
 9703SBT_TAPE00:00:50 10-JUN-03

   List of Archived Logs in backup set 9703
   Thrd Seq Low SCNLow Time  Next SCN   Next Time
    --- -- - -- -
   196511570715177 10-JUN-03 1570731894 10-JUN-03
   196521570731894 10-JUN-03 1570738219 10-JUN-03

   Backup Set Copy #1 of backup set 9703
   Device Type Elapsed Time Completion Time Tag
   ---  --- ---
   SBT_TAPE00:00:50 10-JUN-03

 List of Backup Pieces for backup set 9703 Copy #1
 BP Key  Pc# Status  Piece Name
 --- --- --- --
 97041   AVAILABLE   df_496343070_4_1
 97052   AVAILABLE   df_496343070_4_2

 BS Key  Device Type Elapsed Time Completion Time
 --- ---  ---
 9715SBT_TAPE00:00:31 10-JUN-03
 BP Key: 9716   Status: AVAILABLE   Tag:
 Piece Name: df_496346412_5_1

   List of Archived Logs in backup set 9715
   Thrd Seq Low SCNLow Time  Next SCN   Next Time
    --- -- - -- -
   196531570738219 10-JUN-03 1570755025 10-JUN-03
   196541570755025 10-JUN-03 1570784000 10-JUN-03



--
--
 Selecting from rc_backup_redolog is successful as well

  1* select * from rc_backup_redolog where db_key = 6411
 SQL /


 DB_KEY  DBINC_KEY DB_NAME BRL_KEY  RECID  STAMP
BS_KEY
 -- --  -- -- --
--
  SET_STAMP  SET_COUNT B COMPLETIOTHREAD#  SEQUENCE#
RESETLOGS_CHANGE#
 -- -- - - -- --
-
 RESETLOGS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME BLOCKS
BLOCK_SIZE S
 - - -  - --
--
 -
   BS_RECID   BS_STAMP PIECES
 -- -- --
   6411   6412 NLCO   9717  9  496346443
9715
  496346412  5 L 10-JUN-03  1   9653
1
 10-MAR-021570738219 10-JUN-03   1570755025 10-JUN-03 204800
512 A
  4  496346443  1



 DB_KEY  DBINC_KEY DB_NAME BRL_KEY  RECID  STAMP
BS_KEY
 -- --  -- -- --
--
  SET_STAMP  SET_COUNT B COMPLETIOTHREAD#  SEQUENCE#
RESETLOGS_CHANGE#
 -- -- - - -- --
-
 RESETLOGS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME BLOCKS
BLOCK_SIZE S
 - - -  - --
--
 -
   BS_RECID   BS_STAMP PIECES
 -- -- --
   6411   6412 NLCO   9718 10  496346443
9715
  496346412  5 L 10-JUN-03  1   9654
1
 10-MAR-021570755025 10-JUN-03   1570784000 10-JUN-03  27678
512 A
  4  496346443  1


--
--





 That doesn't look good.  I've just started a  restore database
validate.
It may be my ignorance but not everything seems to jibe.  I must have left out a step.


 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services

RE: RMAN FILESPERSET

2003-06-19 Thread MacGregor, Ian A.

The question has to do with backup sets not pieces.  A backup set can comprise many 
pieces.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, June 17, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


You have the maxpiecesize set to 2048.  It will fill the backup piece and then start 
another.  Have the datafile sized changed alot from one day to the next?

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 6:25 PM


 I'm a bit confused by the default for filesperset.  I ran the 
 following
yesterday 

 run
 {
 allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
 PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
 ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
 backup database;
 backup current controlfile;
 release channel c1;
 }

 There were 245 datafiles in the database.  RMAN made the following 
 backup
sets

BS_KEY COUNT(B.FILE#)
 -- --
   9623 63
   9727 64
   9810 64
   9892 35
   9893  4
   9894  4
   9895  6
   9896  5
--
 sum   245


 As I understand it the default for filesperset is the lesser of 64 or 
 the
number of input files / the number of channels.
 As there was only one channel I would have expected  3 backup sets of 
 64
files and one of 53 channels.

 Today I ran  against  the same target database

 run
 {
 allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
 PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
 ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
 allocate channel c2 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
 PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
 ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
 backup database skip readonly;
 backup current controlfile;
 release channel c1;
 release channel c2;
 }

 There are 92 read write datafiles.  I would have expected the job to 
 be
divided into two backup sets with 46 files each.

 Instead I got

 BS_KEY COUNT(B.FILE#)
 -- --
  10704  2
  10705  2
  10721  2
  10722  2
  10723  2
  10724  2
  10725  2
  10726  2
  10727  2
  10728  2
  10765 33
  10766  4
  10767  2
  10768  1
  10769  1
  10770  1
  10771  1
  10772  1
  10773  1
  10774  1
  10775  1
  10776  1
  10777  1
  10778  1
  10779  1
  10780  2
  10781  1
  10782 18
--
 sum92
 --
 
---

 Any guesses as to why so many backup sets are being created.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: [SPAM:#] Re: SYS not able to GRANT -- Strange !

2003-06-13 Thread MacGregor, Ian A.

System can definitely grant privileges in another schema before 9.  It just takes some 
preparation.

As system create a procedure in  the other schema

CREATE OR  REPLACE procedure  other_schema.grantit
(privilege in varchar2, object in varchar2, grantee in varchar2) is
begin
execute immediate ('grant ' ||privilege ||' on ' ||object ||' to ' ||grantee);
end;
/

Then as system invoke it as

exec other_schema.grantit(privilege, object, grantee)

This works beause the  procedure runs under the security domain of the other user,  
and of course because system has the ability to create and execute privileges  in 
other schemas.

Are you on 9.0.1 or 9.2?  I thought the ability to do the granting without using a 
procedure was available beginning with 9.2.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, June 13, 2003 3:55 AM
To: Multiple recipients of list ORACLE-L


haven't tried it with SYS but in 9i SYSTEM (maybe any account with DBA privs -- have 
to try it) can definitely grant privileges on other owner's objects.

Makes my scripts that have to pass through a hosting company easy now... they have the 
system password, and I don't have to tell anyone the schema owner password

Rachel

--- Joe Testa [EMAIL PROTECTED] wrote:
 its always been that way, its not strange, sys has NEVER been able to 
 grant privs on other owner's objects.
 
 i think that has changed in 9i but its late and my brain is fuzzy.
 
 joe
 
 
 Prem Khanna J wrote:
 
 Guys,
 
 CONNECT SYS AS SYSDBA;
 
  create user testuser1 identified by testuser1 ;
  grant connect, resource to testuser1;
 
  create user testuser2 identified by testuser2 ;
  grant create session to testuser2;
 
  create table testuser1.table1 ( a int ) ;
 
  grant select on testuser1.table1 to testuser2;
  error at line 1:
  ora-01031: insufficient privileges
 
 WHERE AS :
 
  connect testuser1/testuser1;
 
  grant select on testuser1.table1 to testuser2;
 
  grant succeeded.
 
 
 why is it so ?
 why sys is not able to GRANT ?
 seems to be strange !
 
 the env. is 8.1.6.0./win2k.
 
 Jp.
 
 
   
 
 
 --
 Joseph S Testa
 Chief Technology Officer
 Data Management Consulting
 614-791-9000
 It's all about the CACHE
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). 
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Bewildered by RMAN

2003-06-12 Thread MacGregor, Ian A.

  Thrd Seq Low SCNLow Time  Next SCN   Next Time
   --- -- - -- -
  196451570637555 10-JUN-03 1570654513 10-JUN-03
  196461570654513 10-JUN-03 1570683560 10-JUN-03
  196471570683560 10-JUN-03 1570695830 10-JUN-03
  196481570695830 10-JUN-03 1570708498 10-JUN-03
  196491570708498 10-JUN-03 1570713009 10-JUN-03
  196501570713009 10-JUN-03 1570715177 10-JUN-03

BS Key  Device Type Elapsed Time Completion Time
--- ---  ---
9703SBT_TAPE00:00:50 10-JUN-03

  List of Archived Logs in backup set 9703
  Thrd Seq Low SCNLow Time  Next SCN   Next Time
   --- -- - -- -
  196511570715177 10-JUN-03 1570731894 10-JUN-03
  196521570731894 10-JUN-03 1570738219 10-JUN-03

  Backup Set Copy #1 of backup set 9703
  Device Type Elapsed Time Completion Time Tag
  ---  --- ---
  SBT_TAPE00:00:50 10-JUN-03

List of Backup Pieces for backup set 9703 Copy #1
BP Key  Pc# Status  Piece Name
--- --- --- --
97041   AVAILABLE   df_496343070_4_1
97052   AVAILABLE   df_496343070_4_2

BS Key  Device Type Elapsed Time Completion Time
--- ---  ---
9715SBT_TAPE00:00:31 10-JUN-03
BP Key: 9716   Status: AVAILABLE   Tag:
Piece Name: df_496346412_5_1

  List of Archived Logs in backup set 9715
  Thrd Seq Low SCNLow Time  Next SCN   Next Time
   --- -- - -- -
  196531570738219 10-JUN-03 1570755025 10-JUN-03
  196541570755025 10-JUN-03 1570784000 10-JUN-03


Selecting from rc_backup_redolog is successful as well

 1* select * from rc_backup_redolog where db_key = 6411
SQL /


DB_KEY  DBINC_KEY DB_NAME BRL_KEY  RECID  STAMP BS_KEY
-- --  -- -- -- --
 SET_STAMP  SET_COUNT B COMPLETIOTHREAD#  SEQUENCE# RESETLOGS_CHANGE#
-- -- - - -- -- -
RESETLOGS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME BLOCKS BLOCK_SIZE S
- - -  - -- -- -
  BS_RECID   BS_STAMP PIECES
-- -- --
  6411   6412 NLCO   9717  9  496346443   9715
 496346412  5 L 10-JUN-03  1   9653 1
10-MAR-021570738219 10-JUN-03   1570755025 10-JUN-03 204800512 A
 4  496346443  1



DB_KEY  DBINC_KEY DB_NAME BRL_KEY  RECID  STAMP BS_KEY
-- --  -- -- -- --
 SET_STAMP  SET_COUNT B COMPLETIOTHREAD#  SEQUENCE# RESETLOGS_CHANGE#
-- -- - - -- -- -
RESETLOGS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME BLOCKS BLOCK_SIZE S
- - -  - -- -- -
  BS_RECID   BS_STAMP PIECES
-- -- --
  6411   6412 NLCO   9718 10  496346443   9715
 496346412  5 L 10-JUN-03  1   9654 1
10-MAR-021570755025 10-JUN-03   1570784000 10-JUN-03  27678512 A
 4  496346443  1



That doesn't look good.  I've just started a  restore database validate.  It may be 
my ignorance but not everything seems to jibe.  I must have left out a step.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: RMAN FILESPERSET

2003-06-12 Thread MacGregor, Ian A.

   10782 18
 --
  sum92
  
  --
  
 ---
 
  Any guesses as to why so many backup sets are being created.
 
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Binley Lim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

RMAN FILESPERSET

2003-06-11 Thread MacGregor, Ian A.

I'm a bit confused by the default for filesperset.  I ran the following yesterday 

run
{
allocate channel c1 device type sbt format 'df_%t_%s_%p' maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup database;
backup current controlfile;
release channel c1;
}

There were 245 datafiles in the database.  RMAN made the following backup sets

   BS_KEY COUNT(B.FILE#)
-- --
  9623 63
  9727 64
  9810 64
  9892 35
  9893  4
  9894  4
  9895  6
  9896  5
   --
sum   245


As I understand it the default for filesperset is the lesser of 64 or the number of 
input files / the number of channels.
As there was only one channel I would have expected  3 backup sets of 64 files and one 
of 53 channels.

Today I ran  against  the same target database 

run
{
allocate channel c1 device type sbt format 'df_%t_%s_%p' maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
allocate channel c2 device type sbt format 'df_%t_%s_%p' maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup database skip readonly;
backup current controlfile;
release channel c1;
release channel c2;
}

There are 92 read write datafiles.  I would have expected the job to be divided into 
two backup sets with 46 files each.

Instead I got

BS_KEY COUNT(B.FILE#)
-- --
 10704  2
 10705  2
 10721  2
 10722  2
 10723  2
 10724  2
 10725  2
 10726  2
 10727  2
 10728  2
 10765 33
 10766  4
 10767  2
 10768  1
 10769  1
 10770  1
 10771  1
 10772  1
 10773  1
 10774  1
 10775  1
 10776  1
 10777  1
 10778  1
 10779  1
 10780  2
 10781  1
 10782 18
   --
sum92
-

Any guesses as to why so many backup sets are being created.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: RMAN FILESPERSET

2003-06-11 Thread MacGregor, Ian A.

]
Sent: Thursday, June 12, 2003 10:25 AM


 I'm a bit confused by the default for filesperset.  I ran the 
 following
yesterday 

 run
 {
 allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
 PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
 ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
 backup database;
 backup current controlfile;
 release channel c1;
 }

 There were 245 datafiles in the database.  RMAN made the following 
 backup
sets

BS_KEY COUNT(B.FILE#)
 -- --
   9623 63
   9727 64
   9810 64
   9892 35
   9893  4
   9894  4
   9895  6
   9896  5
--
 sum   245


 As I understand it the default for filesperset is the lesser of 64 or 
 the
number of input files / the number of channels.
 As there was only one channel I would have expected  3 backup sets of 
 64
files and one of 53 channels.

 Today I ran  against  the same target database

 run
 {
 allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
 PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
 ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
 allocate channel c2 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
 PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
 ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
 backup database skip readonly;
 backup current controlfile;
 release channel c1;
 release channel c2;
 }

 There are 92 read write datafiles.  I would have expected the job to 
 be
divided into two backup sets with 46 files each.

 Instead I got

 BS_KEY COUNT(B.FILE#)
 -- --
  10704  2
  10705  2
  10721  2
  10722  2
  10723  2
  10724  2
  10725  2
  10726  2
  10727  2
  10728  2
  10765 33
  10766  4
  10767  2
  10768  1
  10769  1
  10770  1
  10771  1
  10772  1
  10773  1
  10774  1
  10775  1
  10776  1
  10777  1
  10778  1
  10779  1
  10780  2
  10781  1
  10782 18
--
 sum92
 --
 
---

 Any guesses as to why so many backup sets are being created.

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Binley Lim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: RMAN - Remote vs Local Backups

2003-05-31 Thread MacGregor, Ian A.

 WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: exp, dbms_stats, RMAN and rollback segments

2003-05-30 Thread MacGregor, Ian A.

When one runs dbms_stats how often is the data committed?  Before Oracle exports a 
table it needs to gather information about it such as the columns comprising it.  I 
wonder if this information also includes data changed by dbms_stats and/or RMAN.

We used to have similar problems when exporting while an application was doing quite a 
few drop tables and CTAS's.  However that pretty much went away with 8.1.7.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 29, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


Oh yeah, for the export consistent=N

-Original Message-
Sent: Thursday, May 29, 2003 9:14 AM
To: '[EMAIL PROTECTED]'


A certain alignment of the planets occurred creating a good ole ORA-01555 error... A 
user level export received the snapshot too old error and terminated. Concurrent to 
this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on 
the same schema being backed up via the user level export. There was no other end user 
access to the schema data. Since exp got the error I assume it was reading from the 
rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any 
significant undo generated by dbms_stats or RMAN which could create this problem? 

(Of course we need to improve our job scheduling but that's another issue, the timing 
of the user level export is application driven and out of our control). 


Befuddled in Bozeman,
Walt and Steve
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: POLL: Database to DBA ratio

2003-03-11 Thread MacGregor, Ian A.

We currently have twenty-one databases, thirteen production and eight  which are 
either test or development.   Of the thirteen production databases five need to be up 
on a 24 X 7 basis; physics experiments and or accelerator monitoring depend on them.   
Nine of the production databases are Oracle back ends for third-party products 
including Peoplesoft and Remedy.  All the above databases all administered  by one 
DBA. 

We do have Peoplesoft Administrators, Remedy Administrators, System Administrators  to 
take some of the load off, but I am responsible for the installation, upgrade, 
maintenance, tuning, and backup of all databases and Oracle software.  This includes 
Internet Developer Suite and Internet Application Server, although as to the latter, 
I'm in the process of unloading it.

This all works quite well most of the time.  A problem can arise when  I must devote 
my attention to fixing  a pressing problem.  In which case the reading of some reports 
on the non-24x7 databases may be postponed and the database then pages me about 
trouble which I could of fixed proactively had I read the reports. 

Larry E. talks of having a single database with third party certifications to consider 
and with multiple applications requiring 24 X 7 service this is impossible.  We do of 
course have to negotiate down times for even the 24 X 7 applications, but their 
operational schedules make it impossible to have them all down at once.

I do get vacations.  A cell phone and a wide-area pager is a necessity, and  I don't 
necessarily have to be at work from eight to five.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, March 11, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L


Chuck,
 At this location we have a total of 5 databases and 1 DBA.  Time off without an 
electronic teather is a thing of the past. My last location was 4 production databases 
with 1 DBA and a backup DBA from the development arena of 2 development databases and 
1 DBA. Ron

 [EMAIL PROTECTED] 03/11/03 09:59AM 
I'm trying to build a case for management that we need additional DBAs so I'd like to 
take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your 
shop? This includes development and production databases. At our shop it's 33:1.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Chuck Hamilton
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 position on hints

2003-03-10 Thread MacGregor, Ian A.

, 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.net
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 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.net
 -- 
 Author: Khedr, Waleed
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Internet File System -- Oracle Taketh Away?

2003-03-06 Thread MacGregor, Ian A.

 able to confirm it.  There is certainly no iFS 
option.  Am I correct here or not?  Can anyone point me to an Oracle 
document saying it is free.

We are looking at collaboration tools such as SharePoint which takes a
SQL
Server back end.  Oracle is pushing Collaboration Suite, but I am wary of any 
first release from Oracle especially in an area where their success 
as been non-existent. I have not seen any specifications for what is 
needed and iFS may be satisfactory.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Hemant K Chitale
My personal web site is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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   message,  and  any  files  transmitted   with  it, are
confidential  and intended  solely for the  use of the  addressee. If this message was 
not addressed to  you, you have received it in error and any  copying,  distribution  
or  other use  of any part  of it is strictly prohibited. Any views or opinions 
presented are solely those of the sender and do not  necessarily represent  those of 
the British Geological  Survey. The  security of e-mail  communication  cannot be 
guaranteed and the BGS  accepts no liability  for claims arising as a result of the 
use of this medium to  transmit messages from or to the BGS. The BGS cannot accept any 
responsibility  for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Snapshot refreshes are failing

2003-03-04 Thread MacGregor, Ian A.

--- -- 
fixed_sga70,620
db_block_buffers245,760,000
log_buffer   66,560
shared pool free memory   9,421,968
shared pool miscellaneous38,363,336
shared pool joxs heap init1,108
shared pool State objects   268,056
shared pool KQLS heap   562,552
shared pool transactions231,028
shared pool table columns18,760
shared pool DML locks   120,176
shared pool KGK heap  9,800
shared pool db_files185,516
shared pool db_block_hash_buckets   371,160
shared pool PLS non-lib hp2,096
shared pool long op statistics array103,840
shared pool KGFF heap20,244
shared pool enqueue_resources   112,896
shared pool trigger defini5,968
shared pool table definiti1,972
shared pool db_handles  105,000
shared pool SYSTEM PARAMETERS62,576
shared pool dictionary cache  3,758,100
shared pool PL/SQL DIANA  1,130,864
shared pool PL/SQL MPCODE 1,073,460
shared pool fixed allocation callback   640
shared pool library cache 8,558,760
shared pool sql area 26,839,020
shared pool processes   168,000
shared pool sessions503,152
shared pool trigger inform1,676
shared pool ktlbk state objects 110,852
shared pool event statistics per sess   792,960
shared pool db_block_buffers  2,040,000
shared pool message pool freequeue  231,152
large pool  free memory   6,144,000
java pool   free memory  20,758,528
java pool   memory in use   212,992
   
sum 368,189,388



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Internet File System

2003-03-04 Thread MacGregor, Ian A.

I believe this is free with the Enterprise Edition of the database server, but I have 
not been able to confirm it.  There is certainly no iFS option.  Am I correct here 
or not?  Can anyone point me to an Oracle document saying it is free.

We are looking at collaboration tools such as SharePoint which takes a SQL Server back 
end.  Oracle is pushing Collaboration Suite, but I am wary of any first release from 
Oracle especially in an area where their success as been non-existent. I have not seen 
any specifications for what is needed and iFS may be satisfactory.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: corrupted block

2003-02-27 Thread MacGregor, Ian A.

Ome of our sys admins once assigned two file systems to the same area of disk which as 
you might expect caused a multitude of problems.  I don't believe the I/O system 
complained at all when  one file system would overwrite  blocks written by another. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, February 27, 2003 7:10 AM
To: Multiple recipients of list ORACLE-L


it's not a hardware problem. the fact that the filesystem failed at 6AM this morning 
is merely a collective hallucination

yes, it went down hard. My database was not on it, I had insisted they move all the 
files. They didn't move the Oracle binaries though (there is no hardware problem) so 
we are down anyway, while they reinstall Oracle to a different filesystem

I'm getting tired of recovering this database. Over and over and over again. I've got 
this recovery scenario down pat, let's move on to a new one to try


--- Stephen Lee [EMAIL PROTECTED] wrote:
  -Original Message-
  Of course, we took the EXACT SAME BACKUP, restored it to another 
  filesystem and have NO corruption in the database. But it can't 
  possibly be hardware problems.  It's just Oracle playing games with
 my
  mind.
 --
 
 Sunspots.
 
  
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Self-correcting Oracle Error

2003-02-19 Thread MacGregor, Ian A.

Thanks, for clarification the database is 9.0.1.3 and when I wrote, bitmap 
tablespaces I was speaking of LMTs.  I'll certainly try the analyze the next time 
this occurs.

Ian

-Original Message-
Sent: Wednesday, February 19, 2003 4:01 PM
To: Multiple recipients of list ORACLE-L


Ian,

I'm not sure if this is appropriate or not but working in Oracle 8.1.5 (and I think it 
followed us to 8.1.6 and maybe even 8.1.7) we could generate ora-600 errors relating 
to partitioned tables which had bitmap indexes on them.  It seemed to be related to 
removing all instances of a bitmap indexed value (or something similar).  Large 
delete's used to create the problem.

Attempting to analyze the table also created the error.  However analyzing just the 
table (ie: for data clause) and then analyzing the indexes in a subsequent statement 
(ie: for all indexes) would resolve the problem until the next time a large delete was 
performed.

Perhaps this is a similar scenario to what you have encountered.  If it appears again 
try the analyze statements.

Regards,
 Mark.



   

MacGregor,

Ian A.  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
[EMAIL PROTECTED]   cc:   

ford.EDUSubject: Self-correcting  Oracle  Error   

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

20/02/2003 

10:06  

Please respond 

to ORACLE-L

   

   





A developer called to  report the Ora-600 error

Errors in file /opt/oracle/admin/NLCO/udump/nlco_ora_16455.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [266008], [1024], [1], [], [], 
[], []

When issuing select count(*) against a partition table.  He then tried renaming the 
table which also produced the same error.

The alert_log shows

Wed Feb 19 09:34:23 2003
Errors in file /opt/oracle/admin/NLCO/udump/nlco_ora_18469.trc:
ORA-00600: internal error code, arguments: [ktehwugen1], [246907], [266008], [], [], 
[], [], [] Wed Feb 19 09:35:01 2003 Errors in file 
/opt/oracle/admin/NLCO/udump/nlco_ora_18469.trc:
ORA-00600: internal error code, arguments: [klapush_10], [201], [], [], [], [], [], [] 
Wed Feb 19 09:35:06 2003 Errors in file 
/opt/oracle/admin/NLCO/udump/nlco_ora_18469.trc:
ORA-00600: internal error code, arguments: [26084], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [klapush_10], [201], [], [], [], [], [], [] 
Wed Feb 19 09:35:54 2003 Errors in file 
/opt/oracle/admin/NLCO/udump/nlco_ora_16274.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [266008], [1024], [1], [], [], 
[], [] Wed Feb 19 09:40:39 2003 Errors in file 
/opt/oracle/admin/NLCO/udump/nlco_ora_16455.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [266008], [1024], [1], [], [], 
[], [] Wed Feb 19 09:45:36 2003 Errors in file 
/opt/oracle/admin/NLCO/udump/nlco_ora_16580.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [266008], [1024], [1], [], [], 
[], []

The kcbgtr_4 error keeps repeating

It seemed that any attempt to access the table or a partition of the table produced 
the kcbgtr_4  error.  DBV was run and the files reported no corruption.  I did this 
for both the table's table space and the system tablespace.  The table's structure was 
verified.  I saw something on metalink where  a kcbgtcr_4 error had to do with bitmap 
tablespaces and trying to read dba_segments while a segment was being dropped.  
Although  a completely different problem I

RE: Teradata baned from IOUG???

2003-02-13 Thread MacGregor, Ian A.

The IOUG cannot live without Oracle's support, but Oracle can survive without the 
IOUG.  IOUG may cause the rare stink, but it always does as Oracle instructs.  

Michael Corey,  erstwhile IOUG president, was going to force Oracle to change the date 
of its first OOW in the U.S. as it was scheduled at the same time as the IOUW.  The 
latter had been scheduled for well over a year.  The groundwork had not even started 
for OOW, but guess which one was moved.

Teradata would not be the first product banned.  Way back in olden-times the maker of 
SQR were banned, but I cannot remember why.  

The idea of the exhibit hall is for vendors to provide information on  their products 
in respect to Oracle.  Now  a company  wants to use the forum to convince people to 
stop using Oracle, or so Oracle apparently dreads.  But, who goes to the conferences?  
Mainly DBA's and developers who have such a stake in Oracle that even if Teradata did 
everything that Oracle did, made breakfast, and washed the dishes, they would not 
recommend it.  Oracle is risking bad public relations over nothing.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, February 12, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


I'm sorry but I thought that IOUG was independant from Oracle? If Larry is afraid of a 
little competition then perhaps he should get out of the market. If not then he should 
battle it out in every venue possible and show why Oracle is better. 

If Rich and the guys do this they will be setting a dangerous precedant.

-Original Message-
Sent: Wednesday, February 12, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


DBA's

Check the article's comment on Oracle trying to ban Teradata from IOUG

Teradata Steals Oracle's Data Mart Users ...

Teradata pushes consolidation and woos away Oracle customers. But Oracle strikes back. 
Sort of. Will bean counters surf the Web with Excel? Will Steve Ballmer and Larry 
Ellison become immortal?

http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: James Howerton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Tony Johnson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

RMAN Feedback

2003-02-11 Thread MacGregor, Ian A.

RMAN reports its progress provinding such information as 

channel c1: starting piece 1 at 11-FEB-03
channel c1: finished piece 1 at 11-FEB-03
piece handle=df_485669402_63_1 comment=API Version 2.0,MMS Version 2.2.1.0
channel c1: starting piece 2 at 11-FEB-03
channel c1: finished piece 2 at 11-FEB-03
piece handle=df_485669402_63_2 comment=API Version 2.0,MMS Version 2.2.1.0

Is there anyway to have it rpeort the time as well as the date?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: HISTOGRAMS , CBO and OLTP

2003-02-11 Thread MacGregor, Ian A.

, 
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: utf8

2003-02-11 Thread MacGregor, Ian A.

Title: Message



How 
about

insert 
into TABLE_NAME (FIELD_NAME) values 
(CHR(2122));

Ian 
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

  
  -Original Message-From: Steve Main 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 2:44 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  utf8
  Hello 
  List,
  
  I have 
  built a database with a character set of UTF8 and I'm 
  trying
  to 
  insert character code 2122 "(TM) Trademark". I'm 
  having
  trouble 
  coming up with a way to do this.
  
  anyone 
  had to deal with this before?
  
  Thanks
  
  Steve

RE: Re[2]: Americas Cup

2003-01-21 Thread MacGregor, Ian A.

Most fighters are equipped with a 20-mm  gun.  They need something to use once they 
have fired all their AAM's.  The Mach 2.? rating is for a completely clean bird devoid 
of anything which would cause drag.  You mentioned 900 mph; I would guess the plan 
lands at a speed of somewhere between 125 and 150 knots and that  dirtied would have 
no problem flying  at 200 knots.  No problem to get a few shots off.  One also doesn't 
need an antiship weapon to take out a yacht.  A radar guided AIM would do considerable 
damage.

A plane traveling at 900 knots just off the water is mesmerizing.  It appears to have 
an aurora surrounding it.  The concussion of the sonic boom would certainly get the 
yachtsmen's attention as well. 

-Original Message-
Sent: Tuesday, January 21, 2003 7:15 AM
To: Multiple recipients of list ORACLE-L




 -Original Message-
 From: Robert Eskridge [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 20, 2003 6:39 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re[2]: Americas Cup
 
 
 Mladen, have you ever seen video of what a Coast Guard .50cal can do 
 to a fishing boat?  I don't know what armament Ellison's interceptor 
 could carry, but I suspect the mounts would support something that 
 could easily turn a racing yacht into toothpicks.
 

No, I haven't seen that video, but I imagine that the problem would be 
to slow the plane sufficiently to have at least a second to aim. There is a plane 
moving with a speed of 900MP/H and it has to hit a boat with a speed of 20 MP/H. How 
much time will the pilot have for aiming? MiG-25 is not a 
dive bomber.
Coast guard, on the other hand, is using boats to catch boats and then .50cal becomes 
a killer.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Passwords and Web Servers.

2003-01-16 Thread MacGregor, Ian A.

It was demonstrated to me recently  that if one used NT authentication with a non-IE 
browser one's NT password  was available to the writer of the ASP script.  Encryption 
between the browser and server is inmaterial.  The password has already been 
decrypted.  If one used IE then credentials rather than passwords are sent.  If 
harvesting passwords is available with IIS, why can it not be done with 9iAS?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Was 8.1.6 certified on Solaris 8?

2003-01-14 Thread MacGregor, Ian A.

We are running 8.1.6 against Solaris 8 patch level Generic_108528-15.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, January 13, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


We're upgrading from Solaris 2.6 to Solaris 8 and 8.1.6 to 8.1.7 on one of our boxes.

I want to know if it's possible to do the OS upgrade first and then the database 
upgrade (e.g., I'd be running 8.1.6 on Solaris 8 for a day or so).

The Oracle certification matrix only says that 8.1.6 is desupported and therefore 
doesn't list any certified OS versions for it.

Did anyone run 8.1.6 on Solaris 8 or remember if it was ever certified?


TIA,
Jay Miller

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Replicating Replicated Data.

2003-01-13 Thread MacGregor, Ian A.

Some of our data is stored in Oracle databases dedicated to Peoplesoft.  We have other 
databases which require a subset of this information.  These other databases are not 
all on the same machine.  They are either directly tied to physics experiments or they 
are subject to certification requirements  from other third-party vendors.  The 
separation is to prevent requirements specific to one database from affecting the 
upgrade of others.

Security's dream would be to have none of these databases communicate with our 
Peoplesoft databases, but they realize that won't fly.  They have vouchsafed that one 
such server be capable.  All other servers would  get their data from this sainted 
one.  If I use materialized views to replicate the data from Peoplesoft to the 
venerated server, any further use of matrialized views from that server to the others 
requires complete refreshes.   It would seem the best course to use something other 
than matrialized views to get the data out of Peoplesoft.   This method would use 
homegrown log tables so only the changed data would be replicated.  I have done this 
to overcome the inability of Oracle to handle longs in materialized views.  

I wonder however if I am overlooking something?  Why does Oracle have  the complete 
refresh restriction in the first place?


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Orawomen

2003-01-08 Thread MacGregor, Ian A.

]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Orawomen

2003-01-08 Thread MacGregor, Ian A.

).



__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Robin Ilardi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: encrypted user/passwd connection

2003-01-07 Thread MacGregor, Ian A.

ORA_ENCRYPT_LOGIN is a sqlnet.ora parameter.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, January 07, 2003 12:11 PM
To: Multiple recipients of list ORACLE-L


Thanks Raj. 

I would think that the default being set to 'always encrypt' would be more reasonable, 

In checking the parameters via 

select
   a.KSPPINM NAME,
   a.KSPPDESC DESCRIPTION,
   b.KSPPSTVL VALUE,
   b.KSPPSTDF ISDEFAULT
from X$KSPPI a, X$KSPPCV b
where a.indx = b.indx
and a.KSPPINM like '%crypt%'
order by name;

.. I found that only the dblink_encrypt_login parm was available.

This is on 7.3.4, 8.0.6, 8.1.7 and 9.2.0.

Where does ORA_ENCRYPT_LOGIN get applied?

Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/07/2003 07:03 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: encrypted user/passwd connection



All oracle passwords are encrypted is not a true statement. Failed login attempts, 
are retried by sending the password in an unencrypted format. Atleast, until 8.1.7. To 
avoid which, ORA_ENCRYPT_LOGIN variable and DBLINK_ENCRYPT_LOGIN parameter (for 
retried attempts across database link) should be set to TRUE.

I could stand corrected though.

Raj




  
Sony kristanto   
Sony@polyfincaTo: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED] 
nggih.com cc:   
Sent by:   Subject: RE: encrypted 
user/passwd connection 
[EMAIL PROTECTED]   
m  
  
  
January 07,  
2003 01:53 AM   
Please respond   
to ORACLE-L  
  
  




You're right Jared, all oracle password is encrypted. Btw Andrey if it is possible how 
to do it ?

 -Original Message-
 From: Jared Still [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 11:04 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:   Re: encrypted user/passwd connection


 Andre,

 Oracle does not send passwords across the network
 in clear text, they are encrypted by default.

 Jared

 On Monday 06 January 2003 05:43, Andrey Bronfin wrote:
  Dear list !
  I have just been asked the following question:
  is it possible to make a connection from an Oracle client to an 
  Oracle instance (both are 8.1.7) in an encrypted way. I.e. if 
  someone is sitting with a sniffer between the server and the client, 
  then i don't want him to be able to see the user/passwd i'm 
  connecting with. Again , i am NOT asking how store the data in the 
  DB
in
 an
  encrypted way, but how to connect to an instance without showing 
  my passwd. Thanks a lot!
  Andrey.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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-00600: [2662]

2003-01-06 Thread MacGregor, Ian A.

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1

Can be used to look up such errors and also examine the stack trace.  The lookup  
function does not return information on all the 600 error codes, it does not return 
any for yours. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Monday, January 06, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I hit by this error

ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], 
[54173017], [16781180], [], []


Can you help me where to find info about this error 




Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Direct Path Inserts and Partition Splits

2002-12-18 Thread MacGregor, Ian A.

 of list ORACLE-L [EMAIL PROTECTED]
Date: 17 December 2002 23:14


A program inserts via OCI DirectPath telemetry data into a time-based partition every 
30 seconds, each insert acquiring an exclusive lock on the table.  The users decided 
to further split the partition receiving the inserts by time.  Each of the new 
partitions is stale, by that I
mean their high values are all previous to the present data.   The
split was done on December 4th carved out partitions for November 26, 27, 28, 29, and 
30.  While the split is going on, the program buffered the next inserts.  Once the 
split is done the program continues its inserts into the original partition.  (During 
the split Oracle acquires locks which  prevent data manipulation)

I realize that splitting a partition on the fly like this is a silly thing to do.  It 
was never going to be part of the production system. However I was not sure if doing 
so would work.  We tried it and the result may have been  data dictionary corruption; 
i.e.,  ORA-8103 errors.  Data in the November 26, November 27, about 22.5 hours of 
November 28, November 29, November 30  and the input partition remain visible.  It's 
only the 1/5 hours of the November 28th partition which is inaccessible.  In a way 
it's very much like a block corruption
problem.Some additional information:  all objects in the database
are valid, all indexes are usable, besides there were no indexes involved in the split 
operation.  DBV  reports no problem with any of the database files.


Oracle support also blames it on the split activity.  I am anxious because there is a 
big push to put this system into production.  I need to be sure the corruption was 
caused by the split.  We won't be that silly again.  Unfortunately the corruption was 
not discovered
immediately afterwards.   The split as the cause is really just a
guess.   Has anyone else seen unexplained 8103 errors after partition
management?


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Direct Path Inserts and Partition Splits

2002-12-17 Thread MacGregor, Ian A.

A program inserts via OCI DirectPath telemetry data into a time-based partition every 
30 seconds, each insert acquiring an exclusive lock on the table.  The users decided 
to further split the partition receiving the inserts by time.  Each of the new 
partitions is stale, by that I mean their high values are all previous to the present 
data.   The split was done on December 4th carved out partitions for November 26, 27, 
28, 29, and 30.  While the split is going on, the program  buffered the next inserts.  
Once the split is done the program continues its inserts into the original partition.  
(During the split Oracle acquires locks which  prevent data manipulation)

I realize that splitting a partition on the fly like this is a silly thing to do.  It 
was never going to be part of the production system.  However I was not sure if doing 
so would work.  We tried it and the result may have been  data dictionary corruption; 
i.e.,  ORA-8103 errors.  Data in the November 26, November 27, about 22.5 hours of 
November 28, November 29, November 30  and the input partition remain visible.  It's 
only the 1/5 hours of the November 28th partition which is inaccessible.  In a way 
it's very much like a block corruption problem.Some additional information:  all 
objects in the database are valid, all indexes are usable, besides there were no 
indexes involved in the split operation.  DBV  reports no problem with any of the 
database files.


Oracle support also blames it on the split activity.  I am anxious because there is a 
big push to put this system into production.  I need to be sure the corruption was 
caused by the split.  We won't be that silly again.  Unfortunately the corruption was 
not discovered immediately afterwards.   The split as the cause is really just a 
guess.   Has anyone else seen unexplained 8103 errors after partition management?


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

 

 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB Segments

2002-12-14 Thread MacGregor, Ian A.

Was the prohibitition on placing LOB's into tablespaces with automatic segment space 
management only a bug.  I ask because  the description of  auto segment space 
management includes the following restrictions

Restrictions on AUTO:

* You can specify this clause only for permanent, locally managed tablespace.

* You cannot specify this clause for the SYSTEM tablespace.

* You cannot store LOBs in AUTO segment-managed tablespaces.

The above is from the 9.0.1 SQL manual.

One usually associates a bug  with something the manual says one can do, but one 
cannot.  I've not seen the 9.0.2 manual.  Are the restrictions lifted?

In a single instance environment unless you are doing something out of the ordinary, 
use of the clause will probably be detrimental.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

 

-Original Message-
Sent: Friday, December 13, 2002 7:19 PM
To: Multiple recipients of list ORACLE-L




The first time we tried importing our 8.1.5 [OPS] database
into 9.0.1 and  9.2.0.1 with
EXTENT_MANAGEMENT  Local   for ALL tablespaces
SEGMENT_SPACE_MANAGEMENT   Auto
we found that tables with LOB segments could not be created. This was a 9.0.1 bug 
which was expected to have been fixed in 9.2 [I believe it was Bug 1626182, referenced 
in Note 159078.1]

However, after going to 9.2.0.2, I WAS able to create
such tables in the database.
[the Patchset Notes include a reference to Bug 2326066. Unfortunately, I can't see 
either bug on MetaLink to verify if both are the same issue]

9iRAC strongly recommends SEGMENT_SPACE_MANAGEMENT Auto
instead of using Free_Lists and Free_List_Groups.  [Part 3, Appendix B of the 9iRAC 
Deployment and Performance manual].

Are there any real-life experiences / gotchas with LOB Segments in Locally Managed 
Tablespaces and Segment_Space_Management Auto ? There seem to be a number of bug-fixes 
for Segment_Space_Management=AUTO in the 9.2.0.2 PatchSet Release Notes.


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

ORA-8103 Error

2002-12-05 Thread MacGregor, Ian A.

I have a user who was in essence moving partitions from one table to another.   The 
partitions are date based, one per day  She was moving November's data.  All went 
well, until the NOV2802 partition.  At that point she received an 8103 error

08103, 0, object no longer exists
// *Cause:  the object has been deleted by another user since the operation
//  began
// *Action:


On a partition she had  not altred.  Indeed all the remaining partitions except 
FIRST  are reporting this error.

Has anybody else run into this.  A tar has been opened.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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-8103 Error

2002-12-05 Thread MacGregor, Ian A.

Curioser and Curioser

If I run the following query

select timestamp from table_which_reports ora-8103  where
timestamp  than sysdate.  

The last rows returned  look like

IMESTAMP

28-NOV-2002:22:36:39
28-NOV-2002:22:36:39
28-NOV-2002:22:36:42
28-NOV-2002:22:36:42
28-NOV-2002:22:36:42
28-NOV-2002:22:36:49
28-NOV-2002:22:36:49
28-NOV-2002:22:36:49
28-NOV-2002:22:36:49
28-NOV-2002:22:36:52
28-NOV-2002:22:36:52
28-NOV-2002:22:36:52
28-NOV-2002:22:35:00
28-NOV-2002:22:35:50
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00
28-NOV-2002:22:35:59
28-NOV-2002:22:35:00



ERROR:
ORA-08103: object no longer exists
104880 rows selected

As if some type of move operation were in progress.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, December 05, 2002 2:14 AM
To: Multiple recipients of list ORACLE-L


I have a user who was in essence moving partitions from one table to another.   The 
partitions are date based, one per day  She was moving November's data.  All went 
well, until the NOV2802 partition.  At that point she received an 8103 error

08103, 0, object no longer exists
// *Cause:  the object has been deleted by another user since the operation
//  began
// *Action:


On a partition she had  not altred.  Indeed all the remaining partitions except 
FIRST  are reporting this error.

Has anybody else run into this.  A tar has been opened.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: image storage confusion ?? -- UUDECODE

2002-12-03 Thread MacGregor, Ian A.

://www.orafaq.com
  --
  Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
  San Diego, California-- Mailing list and
 web hosting services
 

-
  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: Arup Nanda
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 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
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????

2002-12-03 Thread MacGregor, Ian A.

-
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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: image storage confusion ?? -- UUDECODE

2002-12-03 Thread MacGregor, Ian A.

 and
 web
   hosting services
  
 

-
   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).
  
 
  =
  Connor McDonald
  http://www.oracledba.co.uk
  http://www.oaktable.net
 
  GIVE a man a fish and he will eat for a day. But
 TEACH him how to fish,
 and...he will sit in a boat and drink beer all day
 
  __
  Do You Yahoo!?
  Everything you'll ever need on one web page
  from News and Sport to Email and Music Charts http://uk.my.yahoo.com
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
  San Diego, California-- Mailing list and
 web hosting services
 

-
  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: Arup Nanda
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 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
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list

RE: Oracle OS level security

2002-11-27 Thread MacGregor, Ian A.

 
Materialized Views on sensitive tables, and create them on a server that admins are 
guaranteed to not have access to.

Of course, I may be missing something.  I'm not always one to 
catch all the details right off.  Input, comments, suggestions, far out ideas are all 
welcome.

If you've read this far, thanks!

Jared





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Slightly OT - Who would you take with you...

2002-11-26 Thread MacGregor, Ian A.

-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Autoextend WAIT statistic?

2002-11-26 Thread MacGregor, Ian A.

://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Klez Worm Info

2002-11-25 Thread MacGregor, Ian A.

The Klez worm fakes its from address.  Try checking the offending message's header to 
see whom it  is actually from.  

Things are not always simple.  A short time ago, I was asked if I had a virus as 
someone was receiving multiple copies of mail I sent to either this list or lazydba.  
I made the usual protestations of living a good life and having protected mail.  The 
person replied they received six copies of my denial.  That same day maintenance was 
being done and our mail gateway was temporarily closed.  I received a message saying 
an outgoing mail message was blocked by this closure; the   one saying, No way is it 
I.  Before I apologized, many times over :), I queried our postmaster about  the 
problem.  She explained that the site which was receiving multiple copies was running 
a mail program with a bug.  The bug kept the system from sending an acknowledgement of 
receipt to our system.  Having received no receipt, our system was resending the 
message  over and over again.  She contacted their postmaster and I trust all is well. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, November 25, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L


Martin Kendall wrote:
 
 My Norton Antivirus reports that Stephane's  email re. How to pass 
 value from SQL*Plus to Unix scripts? contains the W32.Klez.H@mm virus 
 in an item called stars-bkgrd.
 
 Anyone else had same alert ?
 
 Martin
 
   
 Name: smime.p7s
smime.p7sType: PKCS7 Signature (application/x-pkcs7-signature)
 Encoding: 7bit


Sorry for the trouble, folks, but I have trouble understanding. When I am answering 
the list, it is either from a Linux machine (and netscape)
- not infected by W32.Klez.H@mm according to the Symantec site - or from a mail web 
interface. I sent the e-mail mentioned above on October 22nd or October 23rd (two 
answers to the same question) more than one month ago, and from Linux. I hope that 
somebody is not harvesting the list ... If anybody has any hint about how to check for 
viruses on a Linux machine, BTW ...

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Slightly OT - Who would you take with you...

2002-11-25 Thread MacGregor, Ian A.

You are taking a poll to find out which messages are most important and worth saving?  
 How does that work?   I keep messages containing helpful scripts, messages which 
eloquently and precisely explain and  or demonstrate Oracle concepts and programming,  
messages on areas of which I am ignorant, and messages which disprove beliefs I have 
long held.   Even if we all used the same criteria we would save different messages.  
Our levels of expertise on  different aspects of Oracle are eclectic.  


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  


-Original Message-
Sent: Monday, November 25, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L


Board - 

If you had to choose the 10 top posters here at Oracle-L who provided the biggest 
input and 
knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group?  
I'm asking because my mailbox is FULL, and I have to trash a large amount of the 
stored stuff thats here. I'm going to archive some of it to CD, but I have limited 
space, so I want to archive those people who are constantly offering the most 
insightful advice (I know it's available online, but I'm not always online and it's 
nice to be able to search these emails for targeted content).

Anyone want to take a crack at a list? You are welcome to email me private if you are 
afraid you would hurt someone's feelings. I'd be happy to compile the lists and report 
back to the group the overall answers, but all email to me will be treated as strictly 
confidential.


Robert


Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of 
you. 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: partitioning questions

2002-11-22 Thread MacGregor, Ian A.

As of when?  It's still listed as a costly option on the Oracle Store web page.  
The perpetual license is $10,000.00 per CPU for the U.S. market.

Oracle 9i comes with lots of options  many of which cost extra.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, November 22, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L


That was not a good buy. Partitioning comes with Oracle 9, partitioning option is no 
longer sold separately.

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]]
 Sent: Friday, November 22, 2002 8:44 AM
 To: Multiple recipients of list ORACLE-L
 Subject: partitioning questions
 
 
 
 Hello,
 
 We are planning to move to Oracle 9.2 on as-yet-undecided platform 
 (probably red hat linux on ibm hardware).
 
 We finally pursuaded management to purchase the partitioning license, 
 and I have some questions on partitioning:
 
 Scenario:
 Range-Partition tableA on a service_date field by year; 
 Range-Partition tableB on a posted_date field by year; These tables 
 are frequently joined using a separate field called charge_id, a 
 surrogate key.
 
 Queries against these tables usually include some sort of date filter, 
 join on the charge_id field, and are done in parallel.
 
 1) Would this configuration promote the use of partition-wise
joins between tableA and tableB by the optimizer?
 2) Would it be better to partition the tables (either range or hash)
by the join field, charge_id?
 3) If we range-partition by date, subpartition by hash (charge_id),
would queries that do not reference the date field, but do join
the tables by charge_id still benefit?
 4) Is it more expensive, less expensive, or about equal to do a
full table scan on a partitioned table vs the same table
 non-partitioned? 
 
 As always, thanks to any responders. [EMAIL PROTECTED]
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

ASO Checksumming Parameters

2002-11-19 Thread MacGregor, Ian A.

I'm looking at configuring ASO.  I have sqlnet.ora file on both the client and the 
server which looks like

trace_level_client=16
sqlnet.encryption_server=accepted
sqlnet.encryption_client=requested
sqlnet.encryption_types_server=(RC4_40)
sqlnet.encryption_types_client=(RC4_40)
sqlnet.crypto_seed = -kdje83kkep39487dvmlqEPTbxxe70273
sqlnet.crypto_checksum_server=accepted
sqlnet.crypto_checksum_client=requested
sqlnet.crypto_checksum_types_server = (MD5)
sqlnet.crypto_checksum_types_client = (MD5)
SQLNET.AUTHENTICATION_SERVICES=(NONE)
SQLNET.AUTHENTICATION_REQUIRED=FALSE
sqlnet.fips_140 = true
---
I've been getting  12645 , parameter not  found errors.  The trace file has been very 
helpful specifiying the missing parameter until now.  Now all that 
seems relevant is 

nacomdp: exit
nacomus: exit
nacomus: entry
nacomus: servicecrypto-checksumming
 # of fields6
 ORACLE error   12645.


and

nacomer: error 12645 received from crypto-checksumming service
nacomer: failed with error 12645
snauicomparehash: failed with error 12645
snauicomparehash: exit
na_client: returning status: connection in progress


any idea what is wrong or missing?

The client is 9.0.1.3 and the server is 9.0.1.4 both on Solaris 8

Ian MacGregor
Stanford Linear Accelerator  Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: ASO Checksumming Parameters

2002-11-19 Thread MacGregor, Ian A.

Thanks. I had run adapters  and things look okay.  I had not run a trace on the 
server, but connecting via sql*net on the server worked.  However, for  a remote 
client, the listener.trc file complained about missing  parameters.  I did some 
digging  and located info about the ENVS parameter for listener.ora e.g.

ENVS = 'TNS_ADMIN=/opt/oracle/dbserver/9.0.1/network/admin'


Once this was set the remote connections began working as well.

Ian MacGregor 
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, November 19, 2002 3:34 PM
To: Multiple recipients of list ORACLE-L


Ian,

I would turn on server tracing to see if you get more info about what is 
failing; also check what adapters on installed the server.

Debi

At 03:04 PM 11/19/2002 -0800, you wrote:
I'm looking at configuring ASO.  I have sqlnet.ora file on both the client 
and the server which looks like

trace_level_client=16
sqlnet.encryption_server=accepted
sqlnet.encryption_client=requested
sqlnet.encryption_types_server=(RC4_40)
sqlnet.encryption_types_client=(RC4_40)
sqlnet.crypto_seed = -kdje83kkep39487dvmlqEPTbxxe70273
sqlnet.crypto_checksum_server=accepted
sqlnet.crypto_checksum_client=requested
sqlnet.crypto_checksum_types_server = (MD5)
sqlnet.crypto_checksum_types_client = (MD5)
SQLNET.AUTHENTICATION_SERVICES=(NONE)
SQLNET.AUTHENTICATION_REQUIRED=FALSE
sqlnet.fips_140 = true
---
I've been getting  12645 , parameter not  found errors.  The trace file 
has been very helpful specifiying the missing parameter until now.  Now 
all that
seems relevant is

nacomdp: exit
nacomus: exit
nacomus: entry
nacomus: servicecrypto-checksumming
  # of fields6
  ORACLE error   12645.


and

nacomer: error 12645 received from crypto-checksumming service
nacomer: failed with error 12645
snauicomparehash: failed with error 12645
snauicomparehash: exit
na_client: returning status: connection in progress


any idea what is wrong or missing?

The client is 9.0.1.3 and the server is 9.0.1.4 both on Solaris 8

Ian MacGregor
Stanford Linear Accelerator  Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Deborah Lorraine
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Changing column format

-- Mailing list and web hosting services
 -
 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!?
U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Data Purging Strategy

 being that if it's online somewhere, it will be maintained.

 Don't purge it till Finance, HR, the IRS and any other stakeholder 
 says it's ok.  Only then purge it and archive it to offline tape with 
 the knowledge that you may never see that data again.

 Jared





 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  11/06/2002 01:13 AM
  Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc:
 Subject:Data Purging Strategy



 Dear List,

 I need some inputs from you all regarding purging data from the 
 database.

 This is the requirement


 We define a retention period for all the data in the system. When the 
 retention period is reached,  the data should be deleted, but

 then at a later time, some user might request for this purged data. So 
 it must be possible to retrieve this data.

 This is the strategy we have designed for this.

 When the retention period is reached, move the data from the main 
 database to an offline database. Then delete the data from the main 
 database.

 In the offline database, we cannot again keep it from long, so it has 
 to moved to tapes. Now my question, how can we move this data to tapes 
 and at
 the same time retrieve data from the tapes based on dates.
 i.e, the user will ask for the data on a particular date, so it must be

 possible to retrieve data from the tapes based on a date and load it 
 to

 the database tables.

 Regards
 Prem
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 10i

, California-- Mailing list and web hosting services
 -
 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 10i new releases