RE: what happens if a remove a job that is running?

[Scott . Shafer]

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

RE: Oracle SCN Question

[Scott . Shafer]

I thought Bass and Rap were synonymous?  Or am I out of touch with the
current music scene?

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Nick Wagner [SMTP:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 4:24 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle SCN Question
 
 Thanks...   I think...  except I'm not sure how to calculate that?  
 
 
 
 Nick
 
 -Original Message-
 Sent: Thursday, July 31, 2003 2:00 PM
 To: Multiple recipients of list ORACLE-L
 
 Hi,
 
 It is just combination of Base and Wrap. So your number will be
 8589934593
 
 KG
 
 
-- 
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).

RE: STATSPACK in Oracle 8.1.6.0

[Scott . Shafer]

Metalink, Technet, Google, or at the scripts themselves (which all have
explanatory headers).

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Richard Foote [SMTP:[EMAIL PROTECTED]
 Sent: Friday, July 18, 2003 5:34 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: STATSPACK in Oracle 8.1.6.0
 
 Hi Scott,
 
 Although the recommendation of RTFM often has it's merits, where precisely
 do you suggest Seema should look for the above mentioned FM within the
 *8.1.6* doco set for the sp* statspack scripts ?
 
 Cheers
 
 Richard Foote
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, July 18, 2003 5:59 AM
 
 
  RTFM, which will point you to the sp*.sql scripts in the ?/rdbms/admin
  directory.
 
  Scott Shafer
  San Antonio, TX
  210.581.6217
 
 
   -Original Message-
   From: Seema Singh [SMTP:[EMAIL PROTECTED]
   Sent: Thursday, July 17, 2003 2:49 PM
   To: Multiple recipients of list ORACLE-L
   Subject: STATSPACK in Oracle 8.1.6.0
  
   Hi,
   I want to delete all old records of statspack from perfstat schema.
   What would be best way to do this either by truncating all tables or
   remove
   and recreate ?
   Pl advice.
   thx
   -Seema
  
   _
   Add photos to your e-mail with MSN 8. Get 2 months FREE*.
   http://join.msn.com/?page=features/featuredemail
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Seema Singh
 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: Richard Foote
   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).

RE: Recent reports on outages caused by DB2 and 9iRAC issues

[Scott . Shafer]

That's funny, I thought SAC's motto was SAC eats it's young. 

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Goulet, Dick [SMTP:[EMAIL PROTECTED]
 Sent: Friday, July 18, 2003 1:35 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Recent reports on outages caused by DB2 and 9iRAC issues
 
 Raj,
  
 My previous boss's attitude was:
  
 To error is Human.
 To forgive is not SAC policy.
  
 SAC= Starategic Air Command.
  
 
 Dick Goulet
 Senior Oracle DBA
 Oracle Certified 8i DBA 
 
 -Original Message-
 From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
 Sent: Friday, July 18, 2003 2:00 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues
 
 
 
 Dick, 
 
 we don't share the same boss ... do we? 
 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: Goulet, Dick [ mailto:[EMAIL PROTECTED]] 
 Sent: Friday, July 18, 2003 1:39 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues 
 
 
 I prefer my bosses attitude on the subject of mistakes: 
 Admit that you did it  then go fix it.  We'll crucify you later, if we
 have the time. 
 For some reason, known only to the Devil himself, they never find the
 time. 
 
-- 
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).

RE: Interview Questions for a Unix Solaris System Admin

[Scott . Shafer]

question #1:  Do you realize that your DBA is a God, and you will obey
his/her edicts without question?

question #2:  Are you aware of the daily offering of food/beer required to
keep in your God's (DBA's) good graces?

etc...

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: M.Godlewski [SMTP:[EMAIL PROTECTED]
 Sent: Tuesday, July 15, 2003 1:30 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Interview Questions for a Unix Solaris System Admin
 
 I've been asked to interview a system admin candidate for our Solaris
 shop.  I've search Google and altavista, but haven't come up with any
 after 1999 interview questions.  Does anyone have a list of interview
 question or a link to some?
 
  
 
 tia
 
 M
 
   _  
 
 Do you Yahoo!?
 The New Yahoo! Search
 http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster.
 Easier. Bingo.
-- 
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).

RE: Interview Questions for a Unix Solaris System Admin

[Scott . Shafer]

You only spend time on the technical stuff if they pass this round.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: M.Godlewski [SMTP:[EMAIL PROTECTED]
 Sent: Tuesday, July 15, 2003 2:20 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Interview Questions for a Unix Solaris System Admin
 
 These are nice questions.  I'm not sure how I would identify if they are
 technical enough to handle the job though.
 
 [EMAIL PROTECTED] wrote: 
 
   question #1: Do you realize that your DBA is a God, and you will
 obey
   his/her edicts without question?
   
   question #2: Are you aware of the daily offering of food/beer
 required to
   keep in your God's (DBA's) good graces?
   
   etc...
   
   Scott Shafer
   San Antonio, TX
   210.581.6217
   
   
-Original Message-
From: M.Godlewski [SMTP:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Interview Questions for a Unix Solaris System Admin

I've been asked to interview a system admin candidate for our
 Solaris
shop. I've search Google and altavista, but haven't come up with
 any
after 1999 interview questions. Does anyone have a list of
 interview
question or a link to some?



tia

   !  M

_ 

Do you Yahoo!?
The New Yahoo! Search
- Faster.
Easier. Bingo.
   -- 
   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).
 
   _  
 
 Do you Yahoo!?
 The New Yahoo! Search
 http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster.
 Easier. Bingo.
-- 
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).

RE: log for transaction

[Scott . Shafer]

We use a similiar method which involves inserting periodic rows into a log
table, which is dumped to a file at end-of-job.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED]
 Sent: Tuesday, June 24, 2003 2:05 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: log for transaction
 
 Oracle does not have any ready-made logging process to assist you. 
 Some of our developers have utilized 'utl_file' to track the progress of
 their long running jobs.
 Entries are made to the job log file at proper intervals to tell them what
 happened in case the
 job aborted. 
 
 - Kirti 
 
 --- [EMAIL PROTECTED] wrote:
  Hi there,
  
  I got a question on log. If my program crashes, can I check some log to
 see what
  recent transaction is? It will give me a big help on trouble shooting.
  
  Thanks,
  Jin
 
-- 
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).

RE: Re: Passwords and authentication

[Scott . Shafer]

HIPAA Auditing for Oracle Database Security  Nice.

Well, Arup, Get to publishing!

;-)

--Scott


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 3:19 PM


http://www.dba-oracle.com/bp/bp_titles.htm

Look about in the middle of the page.

 -Original Message-
 what will be the name of your book? when will it be out? you 
 have an extract of what it will cover yet? 
-- 
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).

RE: copy a datafile to a raw device

[Scott . Shafer]

You left out, ...and why is there a goat in the corner? 

Sounds like a fun way to have at my duhvelopers (not the good ones).


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 4:49 PM


Concerning my speculation about error messages in the Oracle kernel, the
following is an actual error message in an app here.  Of course, the
error
is never supposed to occur -- so says the programmer when I asked about
it.

SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that
laying
next to me? Oh my God is that a marriage license?!';

Just in case you developers out there have any creative urges.
-- 
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).

RE: World premier performance of the BAARF party logo

[Scott . Shafer]

And the satanic redeye is a nice effect for a dba.  Could this be the
start of oracle pr0n?


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/12/03 6:19 PM

Hey, 

Who cares about that RAID thing.  Whose the cutie in the pictures -
hehe. 

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Thursday, June 12, 2003 2:50 PM 
To: Multiple recipients of list ORACLE-L 


Here are pics if interested. 

http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg
http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg  
http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg
http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg  

I too do not understand why vendors push RAID 5 when 
RAID 10 is clearly more profitable.  I speculate that they 
may be afraid of being accused of overselling when 
PHB's discover the RAID 10's they just purchased could 
have been RAID 5's for less money. 


Jared 





Niall Litchfield [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
 06/12/2003 10:04 AM 
 Please respond to ORACLE-L 

  
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] 
cc: 
Subject:RE: World premier performance of the BAARF party
logo 


Jared writes 
 At the meeting last week I wore my 'No RAID 5' hat. 
 
 Those of you at IOUG 99 in Denver may have seen it, I 
 wore it every day there.  ;) 

I'm curious now. Pictures required. 

Meanwhile I have never understood why storage vendors would prefer 
selling RAID5 over RAID10. More disks=more profit surely? Also 10  5 
therefore self evidently twice as good for all applications. Meanwhile 
we have this strange situation where performance consultants are 
publicising the fact that you have less need for performance consultants

with RAID10 than with RAID5. 

Niall 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
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
http://www.orafaq.net  
-- 
Author: 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
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).

RE: why SAN ? why not external storage ?

[Scott . Shafer]

Oh, Gods forbid the sysadmins would have to gulp do their job...

HAHAHAHAHA!!!

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]
 Sent: Thursday, March 13, 2003 5:25 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: why SAN ? why not external storage ?
 
 There are many things I don't get in this life. One of them is the 
 statements about disk storage being an admin nightmare and way too 
 expensive. Aren't disks very cheap these days?!
 
 Mogens
 
 [EMAIL PROTECTED] wrote:
 
 Rahul,
 
 This is personal opinion, but it looks to me like your concerned
 about the
 database your creating for the client and may not have the total or
 corporate
 wide view your client has.  We're heading down the SAN road not because
 of any
 specific database requirements but because disk storage has become an
 administrative nightmare as well as way too expensive.
 
 Dick Goulet
 
 Reply Separator
 Author: Arun Annamalai [EMAIL PROTECTED]
 Date:   3/13/2003 12:24 PM
 
 Usaually SAN and NAS is used for several good reasons...the two main
 are...
 1) High availability - When you have your database files on SAN/NAS then
 you can
 bring ur database on another server when the primary goes down. Obviously
 you
 have to use a cluster or Big IP (F5) on the front.
 2) reduce redundancy -A unix userid with home directory attached to a
 paticular
 NFS drive on NAS/SAN, will  able to see all his files when he logs into
 other
 servers.
 
 so far I heard Net App is low cost including with Raid 5.
 
 -Arun.
 Sr oracle dba
   - Original Message - 
   From: Rahul 
   To: Multiple recipients of list ORACLE-L 
   Sent: Wednesday, March 12, 2003 9:38 PM
   Subject: Re: why SAN ? why not external storage ?
 
 
   my reasons to recommend an external storage was..
   1) the database size is 36GB, and according to many documents i have
 read, SAN
 is not cost effevtive unless populated 
   by a large numbers of drives !!, now for the client the cost is not the
 factor.. given the situation.. wouldnt a SAN be an overkill ? 
 
   2) NO DBA or SYS ADMIN skills to manage the SAN !! 
 
 - Original Message - 
 From: Tim Gorman 
 To: Multiple recipients of list ORACLE-L 
 Sent: Wednesday, March 12, 2003 8:33 PM
 Subject: Re: why SAN ? why not external storage ?
 
 
 Can you share some of the reasons related to your decision in
 choosing a
 direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
 much
 smarter choice than DAS.
   - Original Message - 
   From: Rahul 
   To: Multiple recipients of list ORACLE-L 
   Sent: Wednesday, March 12, 2003 1:33 AM
   Subject: why SAN ? why not external storage ?
 
 
   list, one of our clietns are going to by SAN, the current oracle
 databases
 take around 
   36GB of storage i dnt understand there reason to go for SAN, i
 sugguested to buy an external storage 
   box instead. How can i justify my desicion ? (cost of not the
 factor) 
 
   TIA
   rahul
 
 
 
 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
 HTMLHEAD
 META http-equiv=Content-Type content=text/html; charset=iso-8859-1
 META content=MSHTML 6.00.2800.1106 name=GENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=#ff
 DIVFONT face=Arial size=2Usaually SAN and NAS is used for several
 good 
 reasons...the two main are.../FONT/DIV
 DIVFONT face=Arial size=21) High availability - When you have your
 database 
 files on SAN/NAS then you can bring ur database on another server when
 the 
 primary goes down. Obviously you have to use a cluster or Big IP (F5) on
 the 
 front./FONT/DIV
 DIVFONT face=Arial size=22) reduce redundancy -/FONTFONT
 face=Arial 
 size=2Anbsp;unix useridnbsp;with home directory attached to a
 paticular 
 NFSnbsp;drive on NAS/SAN,nbsp;willnbsp; able to see allnbsp;his files
 when 
 he logs into othernbsp;servers./FONT/DIV
 DIVFONT face=Arial size=2/FONTnbsp;/DIV
 DIVFONT face=Arial size=2so far I heard Net App is low cost
 including with
 
 Raid 5./FONT/DIV
 DIVFONT face=Arial size=2/FONTnbsp;/DIV
 DIVFONT face=Arial size=2-Arun./FONT/DIV
 DIVFONT face=Arial size=2Sr oracle dba/FONT/DIV
 BLOCKQUOTE dir=ltr 
 style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
 BORDER-LEFT:
 #00 2px solid; MARGIN-RIGHT: 0px
   DIV style=FONT: 10pt arial- Original Message - /DIV
   DIV 
   style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
 blackBFrom:/B 
   A [EMAIL PROTECTED]
 href=mailto:[EMAIL PROTECTED]Rahul/A 
   /DIV
   DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] 
   href=mailto:[EMAIL PROTECTED]Multiple recipients of list
 ORACLE-L/A 
   /DIV
   DIV style=FONT: 10pt arialBSent:/B Wednesday, March 12, 2003
 9:38 
   PM/DIV
   DIV style=FONT: 10pt arialBSubject:/B Re: why SAN ? why not
 external 
   storage ?/DIV
   DIVBR/DIV
   DIVFONT face=Arial size=2my reasons

RE: RE: why SAN ? why not external storage ?

[Scott . Shafer]

All of the places I've worked its been sysadmins fat-fingering that has
hosed or cross mounted disks.  Then again, we've never had EMC...  HP arrays
are enough trouble.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
 Sent: Friday, March 14, 2003 12:36 PM
 To:   [EMAIL PROTECTED]; Multiple recipients of list
 ORACLE-L
 Subject:  Re:RE: why SAN ? why not external storage ?
 
 Humm, must of missed this one on the rebound.  Anyway, here Disk space is
 an
 admin nightmare.  Each time we want to reassign disks from one server to
 another
 here comes EMC to re-program the Symmetrix array otherwise the SA has the
 possibility of assigning 2 servers to the same disk.  OOPS I really did
 not wnat
 to do a newfs on that disk!!!?!??!  And at $4000 per disk (72GB) I would
 not say
 that their cheap.  IDE drives have gotten real cheap, when will SCSI
 follow
 suit??
 
 Dick Goulet
 
 Reply Separator
 Subject:RE: why SAN ? why not external storage ?
 Author: [EMAIL PROTECTED]
 Date:   3/14/2003 10:03 AM
 
 Oh, Gods forbid the sysadmins would have to gulp do their job...
 
 HAHAHAHAHA!!!
 
 Scott Shafer
 San Antonio, TX
 210.581.6217
 
 
  -Original Message-
  From: Mogens Norgaard [SMTP:[EMAIL PROTECTED]
  Sent: Thursday, March 13, 2003 5:25 PM
  To:   Multiple recipients of list ORACLE-L
  Subject:  Re: why SAN ? why not external storage ?
  
  There are many things I don't get in this life. One of them is the 
  statements about disk storage being an admin nightmare and way too 
  expensive. Aren't disks very cheap these days?!
  
  Mogens
  
  [EMAIL PROTECTED] wrote:
  
  Rahul,
  
  This is personal opinion, but it looks to me like your concerned
  about the
  database your creating for the client and may not have the total or
  corporate
  wide view your client has.  We're heading down the SAN road not because
  of any
  specific database requirements but because disk storage has become an
  administrative nightmare as well as way too expensive.
  
  Dick Goulet
  
  Reply Separator
  Author: Arun Annamalai [EMAIL PROTECTED]
  Date:   3/13/2003 12:24 PM
  
  Usaually SAN and NAS is used for several good reasons...the two main
  are...
  1) High availability - When you have your database files on SAN/NAS
 then
  you can
  bring ur database on another server when the primary goes down.
 Obviously
  you
  have to use a cluster or Big IP (F5) on the front.
  2) reduce redundancy -A unix userid with home directory attached to a
  paticular
  NFS drive on NAS/SAN, will  able to see all his files when he logs into
  other
  servers.
  
  so far I heard Net App is low cost including with Raid 5.
  
  -Arun.
  Sr oracle dba
- Original Message - 
From: Rahul 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, March 12, 2003 9:38 PM
Subject: Re: why SAN ? why not external storage ?
  
  
my reasons to recommend an external storage was..
1) the database size is 36GB, and according to many documents i have
  read, SAN
  is not cost effevtive unless populated 
by a large numbers of drives !!, now for the client the cost is not
 the
  factor.. given the situation.. wouldnt a SAN be an overkill ? 
  
2) NO DBA or SYS ADMIN skills to manage the SAN !! 
  
  - Original Message - 
  From: Tim Gorman 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, March 12, 2003 8:33 PM
  Subject: Re: why SAN ? why not external storage ?
  
  
  Can you share some of the reasons related to your decision in
  choosing a
  direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
  much
  smarter choice than DAS.
- Original Message - 
From: Rahul 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, March 12, 2003 1:33 AM
Subject: why SAN ? why not external storage ?
  
  
list, one of our clietns are going to by SAN, the current oracle
  databases
  take around 
36GB of storage i dnt understand there reason to go for SAN,
 i
  sugguested to buy an external storage 
box instead. How can i justify my desicion ? (cost of not the
  factor) 
  
TIA
rahul
  
  
  
  !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
  HTMLHEAD
  META http-equiv=Content-Type content=text/html; charset=iso-8859-1
  META content=MSHTML 6.00.2800.1106 name=GENERATOR
  STYLE/STYLE
  /HEAD
  BODY bgColor=#ff
  DIVFONT face=Arial size=2Usaually SAN and NAS is used for several
  good 
  reasons...the two main are.../FONT/DIV
  DIVFONT face=Arial size=21) High availability - When you have your
  database 
  files on SAN/NAS then you can bring ur database on another server when
  the 
  primary goes down. Obviously you have to use a cluster or Big IP (F5)
 on
  the 
  front./FONT

RE: POLL: Database to DBA ratio

[Scott . Shafer]

139 remote production servers/instances (30 are large to VLDB, the rest
small), 5 development instances, 1 9iAS test instance, 3 dba's.  Mostly
reporting with batch ETL jobs run nightly.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Robin Ilardi [SMTP:[EMAIL PROTECTED]
 Sent: Tuesday, March 11, 2003 12:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: POLL: Database to DBA ratio
 
 I currently have 5 development databases and 1 beta production database
 that I administer, so that's 6:1, but I'm also the Sys Admin for these
 servers as well.   These are also very small databases.
 
 robin
 
 
 -Original Message-
 Sent: Tuesday, March 11, 2003 11:44 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 We have 10 development databases that I support directly plus 5
 implementation/testing databases that I support as second level and one
 production snapshot datamart.
 
 16:1
 
 However, there are also DBAs who support each project.  That would make
 the
 ratio closer to 4:1 or 3:1.
 
 
 
 
   Chuck Hamilton
   chuckh  To:  Multiple
 recipients
 of list ORACLE-L [EMAIL PROTECTED]
   @softhome.net   cc:
   Sent by: rootSubject: POLL: Database to
 DBA ratio
 
 
   03/11/2003 09:59
   AM
   Please respond
   to ORACLE-L
 
 
 
 
 
 
 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: 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: 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: 
  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: Teradata baned from IOUG???

[Scott . Shafer]

Soon you too will be assimilated.  The TUSC Collective will add your
distinctiveness to its own.

--Seven of Nine-Hundred Ninety-Nine



 -Original Message-
 From: Daniel W. Fink [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, February 18, 2003 12:59 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Teradata baned from IOUG???
 
 I know Stan Yellott is not a TUSC employee. He is the President of RMOUG
 and a great guy who has worked behind the scenes at many IOUG conferences.
 He is a tremendous calming influence (as many of us recall from San
 Diego).
 
 I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless
 they have changed jobs recently.
 
 Henry Poras wrote:
 
 
   Anyone know if any of the 10 people running for the Board of
 Directors for
   IOUG is a TUSC employee? Noone claims it in their statements.
   
   Henry
   
   
   -Original Message-
   Sent: Tuesday, February 18, 2003 12:24 PM
   To: Multiple recipients of list ORACLE-L
   
   
   me too...
   
   Igor Neyman, OCP DBA
   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
   
   
   
   - Original Message -
   To: Multiple recipients of list ORACLE-L  [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
   Sent: Tuesday, February 18, 2003 11:11 AM
   
   
 
 
   evidently i'm not the only one who thinks that, interesting.
   
   joe
   
   
   
 
   It seems to me that IOUG has become a wholly owned
   subsidiary of TUSC.  TUSC in turn has an incestuous
   relationship with Oracle.  All very cozy.
   
   No real complaint about the arrangements.  Someone
 has
   to step up to the plate if IOUG is going to continue
   to be a viable organization and in this economic
   climate few can afford to do it.
   
   Should IOUG be able to survive without Oracle?
   Probably.  Will it be able to survive without
 Oracle?
   I doubt it.
   
   
   --- Jonathan Lewis  [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
   wrote:
 
 
   It should be possible for the IOUG to live without
   Oracle's support.  Obviously it would be better
   for all concerned if there is some measure of
   co-operation, and there's clearly no need for
   bloody-minded conflict.  But if the IOUG just
   keeps doing things that the users want, then
   the users should be able to support it in the
   complete absence of any input from Oracle.
   
   
   Regards
   
   Jonathan Lewis
   http://www.jlcomp.demon.co.uk
   
   Coming soon one-day tutorials:
   Cost Based Optimisation
   Trouble-shooting and Tuning
   Indexing Strategies
   (see  http://www.jlcomp.demon.co.uk/tutorial.html
 )
   
   UK___March 19th
   USA_(FL)_May 2nd
   
   
   Next Seminar dates:
   (see  http://www.jlcomp.demon.co.uk/seminar.html )
   
   USA_(CA, TX)_August
   
   
   The Co-operative Oracle Users' FAQ
   http://www.jlcomp.demon.co.uk/faq/ind_faq.html
   
   
   MacGregor, Ian A. wrote:
   
 
   The IOUG cannot live without Oracle's support, but
 
 
   Oracle can survive
   without the IOUG.
   
 
   --
   Please see the official ORACLE-L FAQ:
   http://www.orafaq.net
   --
   Author: Jonathan Lewis
 INET:  [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
   
   Fat City Network Services-- 858-538-5051
   http://www.fatcity.com
   San Diego, California-- Mailing list and web
   hosting services
   
   
 
  

RE: AIX Oracle 9.2

[Scott . Shafer]

How about relink all from the $OH/bin directory?  Or is this utility gone
in 9i?

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, February 13, 2003 10:14 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: AIX  Oracle 9.2
 
 At least you're going to want to relink everything in Oracle on the
 server.
 Go to $OH/rdbms/lib and make -f ins_rdbms.mk install.  Also go to
 $OH/network/lib and make -f ins_netserver.mk install.  In fact, do a
 find for all files named ins_*.mk and consider whether to do similar
 steps...
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, February 13, 2003 8:03 AM
 
 
 
  If I have Oracle 9.2 on AIX 4.3.3 and we upgrade to AIX 5.1, do I need
 to
 re-install the Oracle 9.2 software or will it all just work after the
 upgrade?  Anybody know?
 
  Keith H.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Henry, Keith
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: 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: 
  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: STATSPACK

[Scott . Shafer]

See:

http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html

and related articles.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Stephen Andert [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, January 29, 2003 3:49 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: STATSPACK
 
 Ruth, 
 
 I've heard people talk about downgrading the statspack scripts to
 earlier versions, but I've never done it.  Try searching downgrade
 STATSPACK on Metalink and OTN for starters.
 
 Good luck
 Stephen
 
  [EMAIL PROTECTED] 01/29/03 12:59PM 
 I believe that an 8.1.7 statspack can run on an Oracle8 or higher
 database.
 
 Dave
 
 -Original Message-
 Sent: Wednesday, January 29, 2003 12:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
  Hello everyone,
 
 I hope this is a quick question.  Can you run 8.1.7 Statspack on an
 8.0.6.3
 instance?
 
 Thanks in advance,
 Ruth
 
 -- 
 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: Farnsworth, Dave
   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: 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: 
  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: AUTORAID and VA7100 disk arrays for rp7400

[Scott . Shafer]

We are using the VA7100's and VA7400's.  They are several orders of
magnitude faster than the old 12H AutoRAID arrays if configured properly.
I'm no expert, but I know the VA7X00's combine some caching technology with
faster IO channels.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: david hill [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, January 23, 2003 4:56 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: AUTORAID and VA7100 disk arrays for rp7400
 
 Yep I have same thing to say 
 We have a HP N class with 3 HP AutoRaid's 
 I recently did a test to import our 50 gig database 
 On the HP it took 4 hours to do a Full export of DB and 12+ hours to
 import 
 I then proceeded to import the exact same dump file on a little Linux Xeon
 test box with IDE HD's just 2 120 Gig mirrored yes that right IDE.
 
 And to import the full DB took 4 Hours!!! 
 Those IDE HD's cost $300 each 
 And those AutoRaids are costing us $1000 a month in support alone. 
 So we will soon changing out IO subsystem that  cost's a lot less, has
 more storage, and better performance. 
 
 
 
 -Original Message- 
 From: Vergara, Michael (TEM) [ mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, January 23, 2003 4:40 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 
 
 I'm not sure what a VA7100 is, so I don't want to tell you 
 to avoid it.  The AutoRaid I used just said AutoRaid on the 
 front.  It had 12 disks...I think they were 9G or 18G each. 
 It had only 96M of cache, not expandable.  Only 2 SCSI 
 channels - not expandable. 
 
 What happened was that our whole database was on this array. 
 Yes, even on-line and archived redo logs.  The array did so 
 much internal thrashing that the disk response times were 
 abysmal. 
 
 RANT 
 The boss got it cause he didn't want to pay the extra $$$ 
 for a 'real' array from EMC, Hitachi, or IBM.  It had the 
 magic word 'Raid' in the name so he went for it, and then 
 was all over me because the system was so slow.  I should'a 
 known what was up when a JBOD D-370 2-way did stuff faster 
 than our K570 6-way and the AutoRaid. 
 /RANT 
 
 Take my advice - don't go with an AutoRaid. 
 
 Cheers, 
 Mike 
 
 -Original Message- 
 Sent: Thursday, January 23, 2003 12:45 PM 
 To: Multiple recipients of list ORACLE-L 
 
 
 Michael, 
 
 a dumb question. does this stops me from using VA7100 with 0+1 or are u
 talking about going some other disk array product?
 
 Thanks 
 Mandar 
 
  -Original Message- 
  From: Vergara, Michael (TEM) [ mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, January 23, 2003 12:00 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 
  
  
  Apologies to all for shouting, but ... 
  
  DO NOT USE AUTORAID! 
  ** *** *** * 
  
  I used an AutoRaid system when I was at Petco.  Performance was 
  el-sucko.  There was more I/Os happening in the disk array 
  (by observing the disk lights) than was being caused by the 
  application and database. 
  
  Plus, when the AR system Raid 0+1/5 mode, where some blocks are 
  kept in a RAID 0+1 area and some are kept in a RAID 5 area, the 
  array got so busy swapping one for another that it was virtually 
  useless. 
  
  Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, 
  heck, even JBOD works better than AutoRaid. 
  
  Just my 2¢ worth. 
  
  Cheers, 
  Mike 
  
  
  -Original Message- 
  Sent: Thursday, January 23, 2003 11:35 AM 
  To: Multiple recipients of list ORACLE-L 
  
  
  Hi, 
  
  i am in the process of defining the specs for a rp7400. a lil 
  overwhelmed by the storage offerings from HP. 
  i wanted to know if any of ull hv any inputs regarding a disk array. 
  we currently hv a Model 30/FC disk array with 9gig drives. 
  I am looking for a similar or the next higher configuration 
  disk array from HP. 
  
  Any inputs regarding VA7100 disk array or corresponding 
  competetive disk aray from HP/competitor? 
  
  cache size 256/512/1024 MB? dont know which to go. 
  thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. 
  faster smaller drives. 
  
  the va7100 product specs on HP site mention more about 
  AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). 
  any inputs on AutoRAID for Oracle database files. 
  hv ull used 0+1 h/w configuration on VA7100? am i talking sense? 
  
  a good article to read, especially page 4 
  http://www.hp.com/products1/storage/products/disk_arrays/infol 
 ibrary/hp_va_and_san_virtualization.pdf 
 
 
 any inputs related to configuring a rp7400 are invited. my initial specs
 based on my current k570 is below. 
 
 current k570 (7.3.4) 
 4 * 200Mhz 
 2 gn ram 
 
 specs for rp7400 (8i/9i) 
 4 * 550MHz 
 6 Gb ram 
 
 and i thought it was easy. 
 take a few procs 
 add ram 
 add few disks, 
 (Baaam!) make sound and license 
 and u hv a server. 
 
 but look into a detailed partlist

RE: Slightly OT - Who would you take with you...

[Scott . Shafer]

Well, there's Schlitz, King Cobra, Olde English, Mickey's Big Mouth, et al.
Single Malt Liquor at its finest!

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Hand, Michael T [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, November 26, 2002 12:17 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Slightly OT - Who would you take with you...
 
 
 And everything I've learned about single malts, I've learned from this
 list.
 And save in my Teetotaller folder ;)
 
-- 
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).

RE: Oracle you have just received a card from .

[Scott . Shafer]

What is this, flippin' Virii Day or what?

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Jay Earle (DBA) [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, November 25, 2002 12:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Oracle you have just received a card from .
 
   http://www.hkg3.com/f.gif 
 
 Oracle,
 
 recently sent you a postcard.
 
 Retrieve your postcard by using this URL.
 
 http://www.FriendGreetings.com/pickup.aspx?code=Oracle
 http://www.hkg3.com/pickup.html?code=Oracleid=2511021 id=2511021
 
 Comment-
 Oracle,
 View the card just created.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jay Earle (DBA)
   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).

RE: Data Purging Strategy

[Scott . Shafer]

Burnt mud?  Isn't that all scotch?

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Steve McClure [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, November 06, 2002 4:34 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Data Purging Strategy
 
 Sherry Finish?  I thought you liked scotch that tasted like burnt mud?
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Wednesday, November 06, 2002 10:55 AM
 To: Multiple recipients of list ORACLE-L
 
 
 That reminds me:
 
 Mark, your annual stipend is due.
 
 Make it a case of Glenmorangie this time, Sherry finish.  :)
 
 Jared
 
 
 
 
 
 
 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  11/06/2002 07:56 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Data Purging Strategy
 
 
 Hey Dennis,
 Mark Leith is the only person on this list allowed to mention 3rd party
 products.
 I am sure he bought the franchise from Jared :)
 
 John
 
 -Original Message-
 Sent: 06 November 2002 14:15
 To: Multiple recipients of list ORACLE-L
 
 
 Prem - You are receiving some excellent advice from Tom and Tim. I would
 mention two items in addition:
   - If you ever hope to re-use the data you archive off-line, you must 
 also
 archive all the related tables, because after all, this is a RELATIONAL
 database.
   - PrincetonSoftech has a product Active Archiving that looks pretty good
 from the demos I've seen. I haven't used it myself.
 
 
 
 Dennis Williams 
 DBA, 40%OCP 
 Lifetouch, Inc. 
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Wednesday, November 06, 2002 6:54 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Prem,
  
 I would re-visit the requirement.  Why do you feel the need to delete the
 data from the database?  What is the purpose for this type of requirement?
 It would be far easier to modify the requirement than to do what you are
 thinking of doing.
  
 Adding columns to database tables indicating that a record has passed it's
 retention policy and thus, is not included in queries, would be a much
 easier solution.
  
 Or, simply moving these records to historical tables in the database - and
 NOT deleting them from the system - is a much better solution.  The data 
 is
 always accessible and not available in the current tables.  And you will 
 not
 be playing the get the data from tape and reload it game with all of 
 it's
 problems (writing an offload program, table structure changes  offload
 program versions).
  
 Try and keep this as simple as possible.
  
 Hope this helps
  
 Tom Mercadante 
 Oracle Certified Professional 
 
 -Original Message-
 Sent: Wednesday, November 06, 2002 4:13 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 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: 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: 
   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

RE: Installing iAS 9.0.2.0.1

[Scott . Shafer]

No, 1.0.2 is a leaner product - no infrastructure required.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Gene Sais [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, October 29, 2002 10:24 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Installing iAS 9.0.2.0.1
 
 Thanks for all the replies.  It makes me rethink going to iAS 9.0.2.0.1.
 Does iAS 1.0.2 require all the same dependencies, i.e. infrastructure
 install?
 
 Gene
 
  [EMAIL PROTECTED] 10/29/02 07:53AM 
 made the same experiences with iAS 92 and ended up
 using 9iAS 1.0.2.2 for various reasons.
 
 but we will try again, when oracle - hopefully - does provide a more
 comfortable way of installation. we use portal, single sign on in
 connection with novel ldap. was quite a toil to get it up and running but
 now it works fine. 
 did the same with iAS 9.2.0 but response time and performance were
 horrible so we removed it again and ...see above.
 
 good luck 
 
 
-- 
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).

RE: Installing iAS 9.0.2.0.1

[Scott . Shafer]

Gene,

We tried it on HPUX and it was not pretty.  We ended up going back to 9iAS
1.0.2.2 for various reasons.  Good luck.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Gene Sais [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, October 25, 2002 2:34 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Installing iAS 9.0.2.0.1
 
 Has anyone installed iAS 9.0.2.0.1 on Intel Linux?  I have downloaded the
 reams of documentation and this is a beast, much different than OAS 4.0.8.
 It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/
 port 1521 free for iAS, etc.  So many dependencies for iAS and I haven't
 even looked at deploying forms yet :).  I can't wait til 10i when DBA's
 are no longer required, *HA!*
 
 Gene
 
-- 
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).

RE: CodeNotes for Oracle9i...

[Scott . Shafer]

Yeah, hearing the Goddess describe massaging the 'data' in sultry detail
would surely be a distraction...  grin

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, October 15, 2002 5:03 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: CodeNotes for Oracle9i...
 
 There's always some idiot who wants to rain on the
 parade, so it may as well be me.  I can't remember the
 specifics but a recent test in London showed that
 people on (hands-free) phones in their cars were 'x'%
 more likely to crash ('x' was somewhere like 50%!),
 the test being designed to show that its not the phone
 in your hand, its the fact that you're
 talking/listening that ends up killing you...
 
 I can't begin to imagine the traffic carnage when the
 CD DBA101: The sensual sultry sounds of Carmichael
 hits the charts!
 
 Does Rachel really want that kind of responsbility :-)
 
 Cheers
 Connor
 
-- 
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).

RE: Oracle list for developers ??

[Scott . Shafer]

Forgot the smiley ;-) - it was a rough day.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: [EMAIL PROTECTED]
 [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 7:24 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle list for developers ??
 
 http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.databases.or
 ac
 le.tools
 
 I know Scott, you were being sarcastic... :-)
 
 Dave
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 6:04 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Oracle list for developers ??
  
  
  No there isn't.  
  And a google search certainly wouldn't turn up any.  
  Give up the quest and read your manuals.  
  That is all.
 
-- 
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).

RE: Thanks - Oracle list for developers ??

[Scott . Shafer]

Who'd a thunk it?  LOL!

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Johnston, Tim [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, October 11, 2002 10:39 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Thanks -  Oracle list for developers ??
 
 Thanks to all who responded helpfully.  SY.
  ^^
 
 Hey Scott, I think he was excluding you...
 
 :-)
 
 -Original Message-
 Sent: Friday, October 11, 2002 8:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Thanks to all who responded helpfully.  SY.
 
 
-- 
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).

RE: cpu on AIX

[Scott . Shafer]

Henry,

I had a similiar situation occur recently on HPUX, Oracle 817.  CPU was
pegged out and users were complaining of taking over 5 minutes to quey one
record (usually took 5 seconds).  It was a matter of statistics not being
present on certain schema.  A quick analyze cleared it all up.  Just an
idea...

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Henry Poras [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 09, 2002 6:35 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: cpu on AIX
 
 Dennis,
 Users are complaining, and at least this time the guilty process seems to
 be
 an import from a database out of my control. What I am trying to do is
 control how often this happens. It seems a bit strange that one moderate,
 single threaded import should drain both CPUs on the server, so I was
 trying
 to see how much could be pinned on those processes (imp and associated
 oracle shadow process)and how much was due to other use and poor
 configuration.
 
 As I mentioned, both %wio (wa on vmstat AIX) and %idle were ~0. Everything
 was split (kind of evenly 50-50 to 40-60) between %usr and %sys. Using ps
 -o
 pcpu I could pin about 30% of %CPU on the import. I am not sure if this
 includes the associated system calls (io) from this process. I don't think
 so. (I wasn't seeing my %CPU adding up to 100% earlier because I was
 leaving
 out the kernal processes. I needed a ps -k flag).
 
 Now I am seeing some other funky stuff (maybe related, maybe not. I
 haven't
 looked carefully for this before so I don't know) on the same machine. The
 import ended and the %usr %sys breakdown was still 40-60. There are two
 kproc processes (async IO???) each using 44.4%CPU. That's been unchanged
 for
 hours and the machine is not being heavily used. Also, some other
 processes
 are using 10-20%CPU which puts me up over 100% (I guess it really can give
 120%).
 
 I'll let you know what I find.
 
 Henry
 
-- 
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).

RE: Oracle list for developers ??

[Scott . Shafer]

No there isn't.  
And a google search certainly wouldn't turn up any.  
Give up the quest and read your manuals.  
That is all.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Droogendyk, Harry [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 5:44 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Oracle list for developers ??
 
 Listers:
 
 While I certainly appreciate the great range of experience and knowledge
 by
 the subscribers on this list, if my rudimentary knowledge is to be
 trusted,
 I think 95% of the postings are DBA type stuff.
 
 Since I'm interested in developer questions / answers I'm asking, again!!,
 if an Oracle list exists that is developer oriented rather than DBA
 oriented.
 
 TIA for your answers.
 
-- 
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).

RE: svrmgrl echo v$database in script

[Scott . Shafer]

echo $ORACLE_SID  logfile

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, October 02, 2002 6:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl echo v$database in script
 
 
 Oracle 8.0.5
 Solaris 2.6
 
 List:
 I've created a script (ksh) called from elsewhere that shuts down the
 database.  I REALLY want to echo the name of the database into my log file
 before I shut down.While select name from v$database works fine from
 svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
 is
 screwing it up.  (I can get other commands to work within the script.)
 However, I don't know what to do about it.
 
 Any ideas?
 
 Thx!!!
 
 Barb
 
 $ svrmgrl
 
 SVRMGR connect internal
 Connected.
 SVRMGR select name from v$database;
 NAME
 -
 TADENT
 1 row selected.
 
 
 #!/usr/bin/ksh
 # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
 # Name: stop_db.sh
 # Author:   Barb Baker
 # Purpose:  execute shutdown immediate on current database
 #   (i.e., database pointed to by current value of ORACLE_SID)
 
 echo Stop oracle instance \${ORACLE_SID}\  at `date` 
${ORACLE_HOME}/bin/svrmgrl  EOF
connect internal
select name from v_$database;
 EOF
 
 
 $  ./stop_db.sh
 Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
 
 
 SVRMGR Connected.
 SVRMGRselect name from v_
   *
 ORA-00942: table or view does not exist
 SVRMGR
 Server Manager complete.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Baker, Barbara
   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).

RE: svrmgrl echo v$database in script

[Scott . Shafer]

A)  Change your unholy methods to use the light side of the force.
or
B)  Just use a different variable to hold the tnsnames.ora entry of wherever
you happen to be connecting to.  Or initialize the $ORACLE_SID variable to
whatever you want it to be.  This allows you to iterate through a list of
SIDs to perform ops on multiple db's if needed, i.e., 

sqlplus user@current_sid
 ...
 exit
 echo $current_sid  logfile

in your script.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Fink, Dan [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 12:34 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: svrmgrl echo v$database in script
 
 What happens if the ORACLE_SID is set to one value and the caller uses
 SQL*Net to access a different database? While this is not usually the case
 in scripts, it could be a problem if the script is parted of a called
 function. 
 ORACLE_SID=DEV
 sqlplus scott/tiger@PROD  -- I'm not connected to DEV anymore.
 
 I realize this is nit-picking, but I've done far too many recoveries
 because
 someone thought they were in DEV when they actually connected to PROD. I'd
 rather know EXACTLY which db I'm connected to, not which one the O/S
 thinks
 I should be in.
 
 My $.02
 
 Dan Fink
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 9:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 echo $ORACLE_SID  logfile
 
 Scott Shafer
 San Antonio, TX
 210.581.6217
 
 
  -Original Message-
  From:   Baker, Barbara [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, October 02, 2002 6:28 PM
  To: Multiple recipients of list ORACLE-L
  Subject:svrmgrl echo v$database in script
  
  
  Oracle 8.0.5
  Solaris 2.6
  
  List:
  I've created a script (ksh) called from elsewhere that shuts down the
  database.  I REALLY want to echo the name of the database into my log
 file
  before I shut down.While select name from v$database works fine
 from
  svrmgrl interactively, it throws up in the script.  I'd guess the $ sign
  is
  screwing it up.  (I can get other commands to work within the script.)
  However, I don't know what to do about it.
  
  Any ideas?
  
  Thx!!!
  
  Barb
  
  $ svrmgrl
  
  SVRMGR connect internal
  Connected.
  SVRMGR select name from v$database;
  NAME
  -
  TADENT
  1 row selected.
  
  
  #!/usr/bin/ksh
  # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
  # Name: stop_db.sh
  # Author:   Barb Baker
  # Purpose:  execute shutdown immediate on current database
  #   (i.e., database pointed to by current value of
 ORACLE_SID)
  
  echo Stop oracle instance \${ORACLE_SID}\  at `date` 
 ${ORACLE_HOME}/bin/svrmgrl  EOF
 connect internal
 select name from v_$database;
  EOF
  
  
  $  ./stop_db.sh
  Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
  
  
  SVRMGR Connected.
  SVRMGRselect name from v_
*
  ORA-00942: table or view does not exist
  SVRMGR
  Server Manager complete.
 
-- 
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).

RE: svrmgrl echo v$database in script

[Scott . Shafer]

Or a here document that allows you to iterate through a list of SID's if
necessary.  Env variables don't have to be static on *nix...

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 03, 2002 12:44 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: svrmgrl echo v$database in script
 
 If fyou want to do it from within a script, you either need to code the
 select into a .sql file that you run OR you need to escape the $ with
 a \ in your ksh script
 
 
 --- [EMAIL PROTECTED] wrote:
  echo $ORACLE_SID  logfile
  
  Scott Shafer
  San Antonio, TX
  210.581.6217
  
  
   -Original Message-
   From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
   Sent: Wednesday, October 02, 2002 6:28 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  svrmgrl echo v$database in script
   
   
   Oracle 8.0.5
   Solaris 2.6
   
   List:
   I've created a script (ksh) called from elsewhere that shuts down
  the
   database.  I REALLY want to echo the name of the database into my
  log file
   before I shut down.While select name from v$database works
  fine from
   svrmgrl interactively, it throws up in the script.  I'd guess the $
  sign
   is
   screwing it up.  (I can get other commands to work within the
  script.)
   However, I don't know what to do about it.
   
   Any ideas?
   
   Thx!!!
   
   Barb
   
   $ svrmgrl
   
   SVRMGR connect internal
   Connected.
   SVRMGR select name from v$database;
   NAME
   -
   TADENT
   1 row selected.
   
   
   #!/usr/bin/ksh
   # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
   # Name: stop_db.sh
   # Author:   Barb Baker
   # Purpose:  execute shutdown immediate on current database
   #   (i.e., database pointed to by current value of
  ORACLE_SID)
   
   echo Stop oracle instance \${ORACLE_SID}\  at `date` 
  ${ORACLE_HOME}/bin/svrmgrl  EOF
  connect internal
  select name from v_$database;
   EOF
   
   
   $  ./stop_db.sh
   Stop oracle instance tadent  at Wed Oct  2 16:24:59 MDT 2002
   
   
   SVRMGR Connected.
   SVRMGRselect name from v_
 *
   ORA-00942: table or view does not exist
   SVRMGR
   Server Manager complete.
   
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: Baker, Barbara
 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).
 
 
 __
 Do you Yahoo!?
 New DSL Internet Access from SBC  Yahoo!
 http://sbc.yahoo.com
 -- 
 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: 
  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

RE: RE: MIcrosoft Blackmail

[Scott . Shafer]

Then there's OpenOffice.  Very nice.  http://www.openoffice.org - I use it
regularly and have had no problems.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, September 26, 2002 4:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re:RE: MIcrosoft Blackmail
 
 Dennis,
 
 Actually migrating to StarOffice is pretty simple.  We would have done
 so a
 year ago, but the mail package we're using would not budge.  Damn Lotus.
 
 Dick Goulet
 
 Reply Separator
 Author: DENNIS WILLIAMS [EMAIL PROTECTED]
 Date:   9/26/2002 12:37 PM
 
 Yeah, I saw that one and thought how hard can that be?. Just raise
 license
 fees again. What are corporations going to do? Switch to StarOffice? Do
 that
 and all the users will insist that they much have pure MS.
  
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Thursday, September 26, 2002 1:57 PM
 To: Multiple recipients of list ORACLE-L
 
 Speaking of RD, what about the eWeek article about how M$ is going to
 pump
 $3,000,000,000.00 into MS Office? They want to achieve $20,000,000,000.00
 per year in revenue on MSOffice alone. Seems like they want to dominate
 the
 desktop with more that just the O/S and browser. Can't anyone slay this
 beast?
  
 It's an evil world in which we live...
 
-- 
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).

RE: How long did job run?

[Scott . Shafer]

SQL desc dba_jobs;
 NameNull?Type
 ---  
 JOB NOT NULL NUMBER
 LOG_USERNOT NULL VARCHAR2(30)
 PRIV_USER   NOT NULL VARCHAR2(30)
 SCHEMA_USER NOT NULL VARCHAR2(30)
 LAST_DATEDATE
 LAST_SEC VARCHAR2(8)
 THIS_DATEDATE
 THIS_SEC VARCHAR2(8)
 NEXT_DATE   NOT NULL DATE
 NEXT_SEC VARCHAR2(8)
 TOTAL_TIME   NUMBER
 BROKEN   VARCHAR2(1)
 INTERVALNOT NULL VARCHAR2(200)
 FAILURES NUMBER
 WHAT VARCHAR2(4000)
 NLS_ENV  VARCHAR2(4000)
 MISC_ENV RAW(32)
 INSTANCE NUMBER

SQL 

You need to look more carefully.  There is a column called LAST_DATE.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Vladimir Barac [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, September 05, 2002 3:43 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  How long did job run?
 
 Hello to everyone
  
 Is it possible to find LAST execution time of a job?
  
 DBA_JOBS has column TOTAL_TIME, but I need something like last time.
  
 Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ssh client for Windoze

[Scott . Shafer]

TeraTerm (does not support ssh2)
Hummingbird
Reflection
PuTTY  (current fave)

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Peter Barnett [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, September 04, 2002 11:48 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  ssh client for Windoze
 
 We are looking for an ssh client for our desktops. 
 Our early testing has been with a product from
 F-Secure which has some major configuration issues
 when used in an environment connecting to multiple
 Unix servers and multiple instances.  
 
 Open source is out of the question.  
 
 Has anyone used an Windows ssh client in a large
 environment (50 +/- Unix servers, 300+ instances) that
 they would recommend?
 
 
 
 =
 Pete Barnett
 Lead Database Administrator
 The Regence Group
 [EMAIL PROTECTED]
 
 __
 Do You Yahoo!?
 Yahoo! Finance - Get real-time stock quotes
 http://finance.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Peter Barnett
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Temp problem

[Scott . Shafer]

add space to the temp tablespace.  ALTER TABLESPACE...

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Peter R [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, September 04, 2002 4:28 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Temp problem
 
 
 Hi friends,
 
 My temp tablespace is showing full!! I try to wakeup smon thru
 oradebug wakeup 6; but getting error..I also used
 alter tablespace temp storage(pctincrease 0);..But it could't release 
 space...any ideas to avoid bouncing the database???
 
 
 tia
 peter.
 
 
 _
 MSN Photos is the easiest way to share and print your photos: 
 http://photos.msn.com/support/worldwide.aspx
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Peter R
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating Scott/Tiger

[Scott . Shafer]

I don't know about the user scott/tiger, but the scripts to build the tables
(emp, dept, etc) are in $ORACLE_HOME/sqlplus/demo

/opt/oracle/product/9.0.2/sqlplus/demo ll
total 16
-rw-r--r--   1 oracle oinstall  3565 May 13  2001 demobld.sql
-rw-r--r--   1 oracle oinstall   573 May 13  2001 demodrop.sql

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Jonathan Gennick [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, August 30, 2002 11:53 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Creating Scott/Tiger
 
 I need to create the Scott/Tiger schema in Oracle9i. Does anyone
 recall off the top of their head just where the script to do this is
 located? 
 
 Jonathan Gennick --- Brighten the corner where you are
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com *
 http://ValleySpur.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jonathan Gennick
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: basic Unix question ???

[Scott . Shafer]

uname -a will give you OS version and machine type on most *nixes.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Janet Linsy [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, August 29, 2002 6:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  basic Unix question ???
 
 Hi all,
 
 I have two questions.  First, how to find out
 information about my unix box, like version, etc.
 
 In my box, I can use hostname to get the machine name.
  I remember there is a command called version, but I
 got Ksh: version: not found.  Any other useful
 commands to know about my machine?
 
 Actually when I use top, it also returns ksh: top: 
 not found.  My second question is where does ksh
 usually reside, which value should I set for PATH.
 
 Thank you in advance.
 
 Janet
 
 __
 Do You Yahoo!?
 Yahoo! Finance - Get real-time stock quotes
 http://finance.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Janet Linsy
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unix question: how to display SID and path in prompt

[Scott . Shafer]

Obviously.  If you had worked on VMS, why would you want to emulate it?
evil grin

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, August 26, 2002 7:13 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Unix question: how to display SID and path in prompt
 
 Mladen,
 
 Your magnificent intuition and superior powers of reasoning
 have finally failed you.
 
 I've never touched VMS.  ;)
 
 Jared
 
 
 
 
 
 
 Gogala, Mladen [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 08/26/2002 01:28 PM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Unix question: how to display SID and path in
 prompt
 
 
 Jared, the alias cd='go' line immediately betrays you as a
 former VMS person. Next thing you know and your aliases will 
 be like set_def
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: Monday, August 26, 2002 3:08 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Unix question: how to display SID and path in prompt
  
  
   Also be aware that when using backticks in your PS1 
  variable,  you are
   influencing $? as a result. 
  
  I don't find that to be true with pdksh - PD KSH v5.2.14 99/07/13.2
  
  function go {
 \cd $1
 typeset -Z2 _h; typeset -Z2 _m  # 2 
  digits, zero padded
 _hh=(SECONDS/3600)%24 _mm=(SECONDS/60)%60   # hours, minutes
 _time='${_x[(_m=_mm)==(_h=_hh)]}$_h:$_m'
 typeset bold=$(tput bold)
 typeset shy=$(tput rmso)
 PS1=[ `pwd` ]
 PS1=$PS1`echo 
  \n\n${bold}$_time-${UMACHINE}:${ORACLE_SID}${shy}:${LOGNAME}-
  $TTY  `
 # need to be able to turn xtitle off when using 'go'
 if [ $TERM = xterm2 -o $TERM = xterm ] ;then
# don't do xtitle if NO_CD_TITLE is set or in SCREEN
#[ $NO_CD_TITLE -o $WINDOW -ge 1 ] || xtitle 
  ${MACHINE}:${PWD}
:
 fi
  }
  
  alias cd='go '
  
  
  10:2-rsysdevdb:dv01:jkstill-3  rm this_file_does_not_exist
  rm: cannot remove `this_file_does_not_exist': No such file or 
  directory
  [ /home/jkstill/tmp ]
  
  10:2-rsysdevdb:dv01:jkstill-3  echo $?
  1
  [ /home/jkstill/tmp ]
  
  10:2-rsysdevdb:dv01:jkstill-3  echo $?
  0
  [ /home/jkstill/tmp ]
  
  10:2-rsysdevdb:dv01:jkstill-3 
  
  Jared
  
  
  
  
  
  Curiel, David [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
  08/26/2002 08:23 AM
  Please respond to ORACLE-L
  
  
  To: Multiple recipients of list ORACLE-L 
  [EMAIL PROTECTED]
  cc: 
  Subject:RE: Unix question: how to display SID 
  and path in prompt
  
  
  
  
  Also be aware that when using backticks in your PS1 variable,  you are
  influencing $? as a result. 
  
  What happens, is that when you run a command (i.e. rm
  some_file_that_doesnt_exist) and then say echo $?, you 
  are getting 
  the
  return code ($?) of your PS1 execution (which is likely to 
  always be 0) -
  NOT the $? of the rm command.
  
  David Curiel
  
  
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gogala, Mladen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L

RE: Unix question: how to display SID and path in prompt

[Scott . Shafer]

Oh I agree - it was a rock solid platform, but the syntax was annoying and
tedious at best.

Scott Shafer
San Antonio, TX
210.581.6217


 -Original Message-
 From: Steven Lembark [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 27, 2002 11:13 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Unix question: how to display SID and path in prompt
 
 
 
 -- [EMAIL PROTECTED]
 
  Obviously.  If you had worked on VMS, why would you want to emulate it?
 
 Actually the platform had a number of virtues -- file
 versions not the least, along with separate system access.
 DCL itself had some nice features, if they'd only added
 pipes it would've been equivalent to most *NIX shells w/
 the added benefit of lexical var's.
 
 
 
 --
 Steven Lembark   2930 W. Palmer
 Workhorse Computing   Chicago, IL 60647
 +1 800 762 1582
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Steven Lembark
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cannot start database (already running)

[Scott . Shafer]

Or go into svrmgrl, connect internal, issue a shutdown abort, then startup.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Hately Mike [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, August 21, 2002 2:04 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Cannot start database (already running)
 
 Barb,
 check for an LKdbname file in your $ORACLE_HOME/dbs directory too. If
 it's
 there, delete it. 
 Just another thing to try.
 
 Regards,
 Mike Hately
 
 -Original Message-
 Sent: Wednesday, August 21, 2002 11:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Oracle 8.0.5
 Solaris 2.6
 HA Cluster 2.1
 
 This is wacky.
 Any ideas on this one (other than reboot the box)???
 I cannot start up this database (claims it's already running).
 Clearly it is not.  No background processes for this instance.  The only
 process I see even remotely related to this database is the oracledesi
 process.  (I don't know what that process is.)
 
 I do have a semaphore set for oracle.  Should I remove it? (I normally
 have
 other databases on this box, but I've shut them all down.)
 
 This database worked fine till a network device was ripped out from under
 it, and the HA stuff kicked in and failed it over.
 
 Any ideas?  Thanks for any help
 
 Barb
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
  
 __
 __
  
 
 This email and any attached to it are confidential and intended only for
 the
 individual or 
 entity to which it is addressed.  If you are not the intended recipient,
 please let us know 
 by telephoning or emailing the sender.  You should also delete the email
 and
 any attachment 
 from your systems and should not copy the email or any attachment or
 disclose their content 
 to any other person or entity.  The views expressed here are not
 necessarily
 those of 
 Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
 you. 
 Churchill Insurance Group plc.  Company Registration Number - 2280426.
 England. 
 Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
 1DP. 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Hately Mike
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SSO - and nothing else

[Scott . Shafer]

Nope.  To get SSO in 9.0.2 you have to install the _entire_ Infrastructure.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, August 15, 2002 10:29 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: SSO - and nothing else
 
 in ias 1.0.2 you cannot avoid to install portal to do that you need to use
 ias 9.0.2 where the SSO (to my knowledge) is a separate product.
 regards 
 torben
 
 -- Original Message --Date: Thu, 15 Aug 2002 02:38:18 -0800To: Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]Reply-To:
 [EMAIL PROTECTED]From:
 Markus Reger [EMAIL PROTECTED]Subject: RE: SSO - and nothing elsethx
 for replying - to make it more precise: we were looking for a way
 toinstall
 an oracle product - called iAS-1.0.2.2.2-portal's SingleSignOn -without
 installing the portal features. This would be even less than theminimum
 installation of the iAS 1.0.2.2.2. Actually we thought about a
 webbasedtool
 to grant access to certain oracle applications. As we use novell forldap
 services and later on OID, and as OID and NOVELL can cooperate via
 aninterface
 we meant everything could be fine, if here was just one way (-sso) to
 authenticate for users (students and staff) via a webbased
 application.Other
 applications means some are webbased, oracle forms (not yet but lateron
 webbased), oracle reports (n.y.b.l.o.w.).sorry for the imprecise
 question
 and thx for any further replies, even ifthey would show me that my wish
 was nonsense. bye marcus  [EMAIL PROTECTED] 08/14/02 16:37 PM
 Markus - I'm not sure quite what you are asking, but since no one
 hasreplied,
 I will make a stab and maybe you can clarify your objectives. SSOmeans
 different things to different people. If you are a Microsoft shop,with
 everybody's email on Outlook, then SSO means Microsoft ActiveDirectory.
 I understand that Active Directory complies with the LDAPstandard and
 Oracle
 also complies with that. If your Oracle users log intoaUnix system, I
 understand that Active Directory can control security on theUnix server,
 and then you can use the Unix security to control access toOracle. Does
 this address the issues you are interested in?Dennis
 WilliamsDBALifetouch,
 Inc.[EMAIL PROTECTED]   -Original Message-Sent:
 Wednesday,
 August 14, 2002 7:54 AMTo: Multiple recipients of list ORACLE-Lhello
 listmateshas anyone ever checked out if there is a possibility to
 install
 single signon only? if so: please drop me a line.kind regards mr --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:
 Markus Reger  INET: [EMAIL PROTECTED]Fat City Network Services--
 (858)
 538-5051  FAX: (858) 538-5051San Diego, California-- Public
 Internet
 access / Mailing
 Lists
 To
 REMOVE yourself from this mailing list, send an E-Mail messageto:
 [EMAIL PROTECTED]
 (note EXACT spelling of 'ListGuru') and inthe message BODY, include a
 line
 containing: UNSUB ORACLE-L(or the name of mailing list you want to be
 removed
 from).  You mayalso 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  FAX: (858) 538-5051San Diego, California--
 Public Internet access / Mailing
 Lists
 To
 REMOVE yourself from this mailing list, send an E-Mail messageto:
 [EMAIL PROTECTED]
 (note EXACT spelling of 'ListGuru') and inthe message BODY, include a
 line
 containing: UNSUB ORACLE-L(or the name of mailing list you want to be
 removed
 from).  You mayalso send the HELP command for other information (like
 subscribing).--Please
 see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Markus
 Reger
  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051San Diego, California-- Public Internet access
 / Mailing
 Lists
 To
 REMOVE yourself from this mailing list, send an E-Mail messageto:
 [EMAIL PROTECTED]
 (note EXACT spelling of 'ListGuru') and inthe message BODY, include a
 line
 containing: UNSUB ORACLE-L(or the name of mailing list you want to be
 removed
 from).  You mayalso send the HELP command for other information (like
 subscribing).
 
 Torben Holm
 Miracle A/S
 
 Mobil : +45 2527 7104
 [EMAIL PROTECTED]
 http://miracleAS.dk
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists

RE: PL/SQL Editor.

[Scott . Shafer]

vi or vim.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Place for oracle [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, August 15, 2002 10:09 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  PL/SQL Editor.
 
 Hello,
 
 I need a nice PL/SQL editor any advice ?
 
 Thx for any advice
 
 Regards
 W.B
 
 __
 Do You Yahoo!?
 HotJobs - Search Thousands of New Jobs
 http://www.hotjobs.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Place for oracle
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: PL/SQL Editor.

[Scott . Shafer]

You should see me trying to type a word document.  vi command syntax doesn't
go over to well...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, August 15, 2002 11:43 AM
 To:   [EMAIL PROTECTED]; Multiple recipients of list
 ORACLE-L
 Subject:  Re:RE: PL/SQL Editor.
 
 Scott,
 
 vi, your dinosaur side is showing!! *-)
 
 Dick Goulet
 
 Reply Separator
 Subject:RE: PL/SQL Editor.
 Author: [EMAIL PROTECTED]
 Date:   8/15/2002 8:38 AM
 
 vi or vim.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From: Place for oracle [SMTP:[EMAIL PROTECTED]]
  Sent: Thursday, August 15, 2002 10:09 AM
  To:   Multiple recipients of list ORACLE-L
  Subject:  PL/SQL Editor.
  
  Hello,
  
  I need a nice PL/SQL editor any advice ?
  
  Thx for any advice
  
  Regards
  W.B
  
  __
  Do You Yahoo!?
  HotJobs - Search Thousands of New Jobs
  http://www.hotjobs.com
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Place for oracle
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: PL/SQL Editor.

[Scott . Shafer]

Hehehe, this'll really get you - I take 1 part command-line SCCS for
versioning to 2 parts vi for editing.  Serve on the rocks.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Ron Rogers [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, August 15, 2002 1:51 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re:RE: PL/SQL Editor.
 
 Scott,
  Dinosaur? When you have a good product it stays around for lng
 time.
 The complaints that I have with TOAD is that the pl/sql packages when
 converted to text have a lot of white space due to the formatting.
 Designer is not as bad but still has white space. I like to have the
 developers give me a text copy of the pl/sql package so I can keep it on
 the source disk incase there is a disaster and I have to start from
 scratch and also I use it for documentation purposes. So far the
 auditors have been happy when I show them the disk location for all of
 the creation scripts used on the server.
 Ron
 ROR mª¿ªm
 
  [EMAIL PROTECTED] 08/15/02 01:48PM 
 Scott,
 
 vi, your dinosaur side is showing!! *-)
 
 Dick Goulet
 
 Reply Separator
 Author: [EMAIL PROTECTED] 
 Date:   8/15/2002 8:38 AM
 
 vi or vim.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From: Place for oracle [SMTP:[EMAIL PROTECTED]] 
  Sent: Thursday, August 15, 2002 10:09 AM
  To:   Multiple recipients of list ORACLE-L
  Subject:  PL/SQL Editor.
  
  Hello,
  
  I need a nice PL/SQL editor any advice ?
  
  Thx for any advice
  
  Regards
  W.B
  
  __
  Do You Yahoo!?
  HotJobs - Search Thousands of New Jobs
  http://www.hotjobs.com 
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- 
  Author: Place for oracle
INET: [EMAIL PROTECTED] 
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: 
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: 
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ron Rogers
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command

RE: Oracle9i Installation Error

[Scott . Shafer]

Read your Release Notes Addendum from http://technet.oracle.com  - there
are some links in /usr/lib that need to be created (among other things).
Also, ensure that your RAM is sufficient _or_ that the sysadmins have
swapping turned on.  This from Oracle Support:  Remove all references to
ORACLE_HOME from your environment (PATH, LD_LIBRARY_PATH, etc).  Hopefully
this gives you some ideas to try.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 13, 2002 10:35 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Oracle9i Installation Error
 
 
 Hello All, 
 We are trying to install Oracle9i on HP-UX and getting following message: 
 
   Error in invoking target install of makefile: 
 /oracle/product/9.0.1/ctx/lib/ins_ctx.mk 
 
 I have looked through metalink but could not find anything satisfying. I
 would like to hear from someone who has an idea about overcoming this
 error. 
 
 Regards. 
 
 
 M.Emre HANCIOGLU
 Masterfoods Services GmbH
 ISI Application Support
 Tel : +49 2162 500-576
 Fax: +49 2162 41497
 E-Mail: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Apple rack-mounted servers

[Scott . Shafer]

mach kernel, IIRC.  The old NeXTStep unix.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 13, 2002 1:13 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Apple rack-mounted servers
 
 It is based on some *NIX variant...was it FreeBSD?
 
 -Original Message-
 Sent: Tuesday, August 13, 2002 1:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 No longer OT!  Oracle says 9I will run on Apple's new servers?
 
 http://www.apple.com/xserve/reaction.html
 
 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)
 
 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique 
 Maritimes Region, DFO  | Région des Maritimes, MPO
 
 E-Mail: [EMAIL PROTECTED]
 
 
  -Original Message-
 Sent: Tuesday, August 13, 2002 12:45 PM
 To:   '[EMAIL PROTECTED]'
 Subject:  OT:  Apple rack-mounted servers
 
 My brother just sent me this link...
 
 http://www.apple.com/xserve/
 
 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Boivin, Patrice J
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Grabowy, Chris
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Apple rack-mounted servers

[Scott . Shafer]

Cool.  Sound like it may be worth checking out, at least for home use.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 13, 2002 5:06 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Apple rack-mounted servers
 
 From my Mac OS X Advanced Quickpro guide: it's a combination of the Mach
 kernel and FreeBSD. 
 
  -Original Message- 
  From: [EMAIL PROTECTED] 
  
  mach kernel, IIRC.  The old NeXTStep unix. 
  
  
   -Original Message- 
   From:   Grabowy, Chris [SMTP:[EMAIL PROTECTED]] 
   
   It is based on some *NIX variant...was it FreeBSD? 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: missed Anjo's webcast..

[Scott . Shafer]

Ditto.  Put me down for at least one copy!  

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, August 09, 2002 3:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: missed Anjo's webcast..
 
 Cary,
 
 I'd like to place my pre-order on that book right now please.
 
 Rachel
 
 --- Cary Millsap [EMAIL PROTECTED] wrote:
  * * *
  
  Within the next few months, I hope to have completed my book project
  (Oracle Response Time Optimization or some-such). The questions on
  this list are exceptionally good inspiration for such a project, by
  the
  way. When the book is finished, if I still haven't convinced you,
  then I
  simply won't have done my job.
  
  
  Cary Millsap
  Hotsos Enterprises, Ltd.
  http://www.hotsos.com
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Ids and passwords for application users

[Scott . Shafer]

--Create roles for the possible user types.
--Grant permissions to the roles.
--Create induhvidual lusers in the database.
--Assign the appropriate role to the appopriate luser.

Anything else can quickly become a maintenance/monitoring nightmare.  This
is why roles were rolled out.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Schauss, Peter [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 29, 2002 3:59 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Ids and passwords for application users
 
 I am in the process of designing a small database which may have
 as many as 250 to 300 users.  We are reaching a stage where we need
 to decide how we will control access to this database.  As I see it
 we have two options:
 
 1.  Provide a single hidden login for the entire application and control
 access to the applicaiton itself either by roll your own security or
 using the operating system (UNIX) controls.
 
 2.  Create ids for the users in Oracle and grant them access
 to the necessary tables using roles.
 
 Any opinions or alternate suggestions?
 
 thanks,
 
 Peter Schauss
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Schauss, Peter
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Myers-Briggs

[Scott . Shafer]

The C is for Sales-Critter.  The High part?  Well, remember, the rule
is: puff, puff, pass.  Don't bogart the good stuff, 'kay?

;-)

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Mark Leith [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, July 23, 2002 11:28 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Myers-Briggs
 
 We used to use these at my last company, and I turned out to be a High
 C..
 Which actually meant that I was a classic sales person profile.. Funny.. I
 always thought of myself as more of a techie in a sales persons role.. ;)
 
 -Original Message-
 Carmichael
 Sent: 23 July 2002 16:18
 To: Multiple recipients of list ORACLE-L
 
 
 do a search for Meyers-Briggs and there are sites
 
 A lot of companies use this as a way of finding out what type a
 person is so you can learn how to deal with the people you work with.
 It's supposed to help with management styles etc
 
 
 --- Rodd Holman [EMAIL PROTECTED] wrote:
  Where do you take this profile to find out what you are?  I'm curious
  now.  Is there someplace on-line that will let you do this?
 
  Rodd Holman
  On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote:
 
  That's very funny.  INFP DBA... Wow! You do what you want with
  verve and to
  Hell the consequences whenever you blow up.  Being a P, you are
  pragmatic
  about your outbursts... ?
 
  I am an INTJ most of the time.
 
  I - I am stubborn
  N - I follow my own inner sense of direction
  T - I mull things over before I act
  J - I have an opinion about everything.
 
  E-Mail: [EMAIL PROTECTED]
 
 
   -Original Message-
  Sent:   Monday, July 22, 2002 5:49 PM
  To: Multiple recipientsBoth my parents are psychologists, go
  figure.
 
  Regards,
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
 
  Systems Admin  Operations | Admin. et Exploit. des systhmes
  Technology Services| Services technologiques
  Informatics Branch | Direction de l'informatique
  Maritimes Region, DFO  | Rigion des Maritimes, MPO
 
   of list ORACLE-L
  Subject:RE: Rant-Rant
 
  FYI:  SJs make up about 40% of the population (app. 10% for each
  sub-division).
 
  Jay Miller
  infp (yeah, I know, what's an infp doing in a technical job... :)
 
  -Original Message-
  Sent: Monday, July 22, 2002 1:23 PM
  To: Multiple recipients of list ORACLE-L
 
 
 
  That is why I use the
  machinist analogy: somebody who is satisfied with a career
  spending 25
  years doing essentially the same thing. If you are into
  Myers-Briggs type
  indicator, I think the personality dimension is SJ and roughly
  25% of the
  population fits this profile.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Miller, Jay
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858)
  538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
 
  (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: Boivin, Patrice J
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858)
  538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
 
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
  in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You
  may
  also send the HELP command for other information (like
  subscribing).
 
  --
  Rodd Holman
  Enterprise Data Systems Engineer
  LodgeNet Entertainment Corporation
  [EMAIL PROTECTED]
  (605) 988-1373
 
 
 
 
 __
 Do You Yahoo!?
 Yahoo! Health - Feel better, live better
 http://health.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 -- 
 Please see the official ORACLE-L

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

Good luck.  The smooth install is at a grinding halt at the moment, with
half the components throwing java exceptions all over the place.  Did I
mention java sucks?

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, July 18, 2002 3:10 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
 
 I will see what I can do. Thanks Scott!
 
 RF
 
 Robert G. Freeman - Oracle OCP
 Oracle Database Architect
 CSX Midtier Database Administration
 Author
 Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
 Oracle9i New Features (Oracle Press)
 Mastering Oracle8i  (Sybex)
 
 Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
 Cousin Eddie: Those were my mother's dying words. But I
 guess if your body's covered in third degree burns, and 
 your foot's caught in a bear trap, you tend to start talkin' 
 crazy.
 
 
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 5:29 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Robert, 
 
 After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
 get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
 and
 it seems to be a lot smoother, albeit more bloated and slower - at least
 the
 install portion.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, July 17, 2002 4:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
  
  This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
  So, I'm guessing this is iAS. I have a hard enough time keeping
  up with Oracle marketing's changing the names/version of Oracle Net,
  parallel server, and MTS every opportunity they get!!
  
  RF
  
  
  
  Robert G. Freeman - Oracle OCP
  Oracle Database Architect
  CSX Midtier Database Administration
  Author
  Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
  Oracle9i New Features (Oracle Press)
  Mastering Oracle8i  (Sybex)
  
  Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
  Cousin Eddie: Those were my mother's dying words. But I
  guess if your body's covered in third degree burns, and 
  your foot's caught in a bear trap, you tend to start talkin' 
  crazy.
  
  
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 1:24 PM
  To: Multiple recipients of list ORACLE-L
  
  
  It really OAS and not iAS?  If it is, you need to upgrade your software.
  There is  a published exploit against  the version of Apache used by
  Oracle's latest iAS release.  Oracle has released a patch which stops
 the
  exploit
  
  I have built Oracle web servers for years, but I am now of the mind that
  these things should not be built by DBA's but by webmasters. 
  
  I am undecided whether to one should go with iAS or construct your own
  with
  Apache.  The mod_plsql module for instance was not created by Oracle.
 It
  and things  such as forms server and reports server will run against
 such
  a
  construction. 
  
  However, we were advised last week that the  Windows NT machines will be
  converted to XP  this year.  As a result, I  started to look at  the 9i
  Internet Developer Suite.  About every third line is a statement to the
  effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
  I
  haven't figured out what one is giving up if one builds their own web
  server
  and also installs components for the 9 iAS distribution.  Is it just
  convenience?
  
  One reason for giving up the convenience is security.  An exploit is
  discovered and possibly published.  Apache fixes the problem.  If I have
  built my own I can get the patch from Apache and  rebuild the web
 server.
  If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
  into its offering.  This could be a matter days to over a week.  However
  weighing-in on the 9 iAS side is the ease of installing a fix.  The
 Apache
  fix  for the aforementioned problem required  a rebuild; you need
 someone
  wise in the ways of make files and such.   The 9 iAS fix was a simple
 file
  replacement.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 9:18 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Folks,
   
  I'm a DBA who is really an old developer at heart. I know a little Java,
 a
  little Asp
  (enough, as they say, to be really dangerous!), I used to do C code that
  now
  makes 
  my head swim to look at. (I think to myself, what the devil was I
 doing??)
   
  Anyway, I've finally found some time and a machine here at work to start
  playing with
  OAS just to see what it's all about. Anyone have any good suggestions
 with
  regards 
  to:
   
  1

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

Gene, I dunno anymore.  9.0.2 came out in May '02, according to the cd.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Gene Sais [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, July 18, 2002 9:18 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
 
 Now I am confused.  Supposedly, I just received the latest 9iAS from
 Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
 release 1.0.2, etc?
 
 Gene
 
  [EMAIL PROTECTED] 07/17/02 05:28PM 
 Robert, 
 
 After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
 get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
 and
 it seems to be a lot smoother, albeit more bloated and slower - at least
 the
 install portion.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
  Sent:   Wednesday, July 17, 2002 4:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
  
  This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
  So, I'm guessing this is iAS. I have a hard enough time keeping
  up with Oracle marketing's changing the names/version of Oracle Net,
  parallel server, and MTS every opportunity they get!!
  
  RF
  
  
  
  Robert G. Freeman - Oracle OCP
  Oracle Database Architect
  CSX Midtier Database Administration
  Author
  Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
  Oracle9i New Features (Oracle Press)
  Mastering Oracle8i  (Sybex)
  
  Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
  Cousin Eddie: Those were my mother's dying words. But I
  guess if your body's covered in third degree burns, and 
  your foot's caught in a bear trap, you tend to start talkin' 
  crazy.
  
  
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 1:24 PM
  To: Multiple recipients of list ORACLE-L
  
  
  It really OAS and not iAS?  If it is, you need to upgrade your software.
  There is  a published exploit against  the version of Apache used by
  Oracle's latest iAS release.  Oracle has released a patch which stops
 the
  exploit
  
  I have built Oracle web servers for years, but I am now of the mind that
  these things should not be built by DBA's but by webmasters. 
  
  I am undecided whether to one should go with iAS or construct your own
  with
  Apache.  The mod_plsql module for instance was not created by Oracle.
 It
  and things  such as forms server and reports server will run against
 such
  a
  construction. 
  
  However, we were advised last week that the  Windows NT machines will be
  converted to XP  this year.  As a result, I  started to look at  the 9i
  Internet Developer Suite.  About every third line is a statement to the
  effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
  I
  haven't figured out what one is giving up if one builds their own web
  server
  and also installs components for the 9 iAS distribution.  Is it just
  convenience?
  
  One reason for giving up the convenience is security.  An exploit is
  discovered and possibly published.  Apache fixes the problem.  If I have
  built my own I can get the patch from Apache and  rebuild the web
 server.
  If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
  into its offering.  This could be a matter days to over a week.  However
  weighing-in on the 9 iAS side is the ease of installing a fix.  The
 Apache
  fix  for the aforementioned problem required  a rebuild; you need
 someone
  wise in the ways of make files and such.   The 9 iAS fix was a simple
 file
  replacement.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED] 
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 9:18 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Folks,
   
  I'm a DBA who is really an old developer at heart. I know a little Java,
 a
  little Asp
  (enough, as they say, to be really dangerous!), I used to do C code that
  now
  makes 
  my head swim to look at. (I think to myself, what the devil was I
 doing??)
   
  Anyway, I've finally found some time and a machine here at work to start
  playing with
  OAS just to see what it's all about. Anyone have any good suggestions
 with
  regards 
  to:
   
  1. Sites, books, white papers and the like with good install tips,
 hints,
  warnings and the like.
  2. Sites, books, white papers and the like Quick getting started tips.
  3. Your own getting started experiences of things to do or not to do.
  5. Anything I should do before I mess with OAS.
   
  Optimistically hopeful that this will all just go really smooth and I'll
  have a cool
  web page that I can bring up soon!
   
  RF
  
  Robert G. Freeman - Oracle OCP
  Oracle Database Architect
  CSX Midtier Database Administration
  Author
  Oracle9i RMAN Backup

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

The 9.0.2 differs significantly from the 1.0.2.2 at least for HPUX.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, July 18, 2002 10:38 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
 
 I believe, about 95% confident, that they are the same.  I think Oracle
 applications customers receive the  the 1.0.2X numbered versions. 
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Thursday, July 18, 2002 7:18 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Now I am confused.  Supposedly, I just received the latest 9iAS from
 Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
 release 1.0.2, etc?
 
 Gene
 
  [EMAIL PROTECTED] 07/17/02 05:28PM 
 Robert, 
 
 After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
 get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
 and
 it seems to be a lot smoother, albeit more bloated and slower - at least
 the
 install portion.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
  Sent:   Wednesday, July 17, 2002 4:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
  
  This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
  So, I'm guessing this is iAS. I have a hard enough time keeping
  up with Oracle marketing's changing the names/version of Oracle Net,
  parallel server, and MTS every opportunity they get!!
  
  RF
  
  
  
  Robert G. Freeman - Oracle OCP
  Oracle Database Architect
  CSX Midtier Database Administration
  Author
  Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
  Oracle9i New Features (Oracle Press)
  Mastering Oracle8i  (Sybex)
  
  Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
  Cousin Eddie: Those were my mother's dying words. But I
  guess if your body's covered in third degree burns, and 
  your foot's caught in a bear trap, you tend to start talkin' 
  crazy.
  
  
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 1:24 PM
  To: Multiple recipients of list ORACLE-L
  
  
  It really OAS and not iAS?  If it is, you need to upgrade your software.
  There is  a published exploit against  the version of Apache used by
  Oracle's latest iAS release.  Oracle has released a patch which stops
 the
  exploit
  
  I have built Oracle web servers for years, but I am now of the mind that
  these things should not be built by DBA's but by webmasters. 
  
  I am undecided whether to one should go with iAS or construct your own
  with
  Apache.  The mod_plsql module for instance was not created by Oracle.
 It
  and things  such as forms server and reports server will run against
 such
  a
  construction. 
  
  However, we were advised last week that the  Windows NT machines will be
  converted to XP  this year.  As a result, I  started to look at  the 9i
  Internet Developer Suite.  About every third line is a statement to the
  effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
  I
  haven't figured out what one is giving up if one builds their own web
  server
  and also installs components for the 9 iAS distribution.  Is it just
  convenience?
  
  One reason for giving up the convenience is security.  An exploit is
  discovered and possibly published.  Apache fixes the problem.  If I have
  built my own I can get the patch from Apache and  rebuild the web
 server.
  If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
  into its offering.  This could be a matter days to over a week.  However
  weighing-in on the 9 iAS side is the ease of installing a fix.  The
 Apache
  fix  for the aforementioned problem required  a rebuild; you need
 someone
  wise in the ways of make files and such.   The 9 iAS fix was a simple
 file
  replacement.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED] 
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 9:18 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Folks,
   
  I'm a DBA who is really an old developer at heart. I know a little Java,
 a
  little Asp
  (enough, as they say, to be really dangerous!), I used to do C code that
  now
  makes 
  my head swim to look at. (I think to myself, what the devil was I
 doing??)
   
  Anyway, I've finally found some time and a machine here at work to start
  playing with
  OAS just to see what it's all about. Anyone have any good suggestions
 with
  regards 
  to:
   
  1. Sites, books, white papers and the like with good install tips,
 hints,
  warnings and the like.
  2. Sites, books, white papers and the like Quick getting started tips.
  3. Your own getting started experiences of things to do or not to do

RE: Cognos

[Scott . Shafer]

Conos cube builds = database performance killer, especially if users are
allowed to build data cubes on the fly.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: John Weatherman [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, July 18, 2002 11:08 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Cognos
 
 Anybody have any experience with Cognos?  We've got a bhb that thinks
 its
 the solution for giving every end user access to the raw data
 (groan...loudly!)...  I've argued every which-a-way against the concept,
 now
 I have to fight the specifics
 
 HELP!
 
 John P Weatherman
 Database Administrator
 Replacements Ltd.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: John Weatherman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS

[Scott . Shafer]

Thanks, mkb.  I'm installing 9.0.2 now on HPUX.  Good info.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: mkb [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 12:49 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: A DBA looks at OAS
 
 No books or tips.  Just my recent experience *trying*
 to install 9iAS R2 (I hope that's what you meant when
 you wrote OAS).
 
 I downloaded 9iAS J2EE and Web Cache for Solaris and
 HP-UX.
 
 Oracle recommends about 1GB ram, 1GB swap and lots of
 free disk space.  Anyway, my target Solaris box had
 500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
 the ideal platform.  On the HP-UX box, I had 3GB ram,
 a 2 CPU L class machine, lots of swap and lots of
 disk.
 
 In any case, what I learned is that root privs are
 vital.  Had them on the Solaris box but not on the
 HP-UX machine.  The installs in both cases where
 fairly standard.  I had ran through them quite a few
 times on both servers.  On Solaris becuase of resource
 issues and HP-UX because of root permission issues.
 
 There are two types of installs.  A mid-tier (less
 config, easier, fewer components) and an
 infrastructure (more config, more components, needs a
 database repoistory).  I did the mid-tier install in
 both cases.
 
 Make sure you have JDK 1.3 or later installed.
 
 Before the install for mid-tier in particular, export
 ORACLE_SID=iasdb even if you do not intend to use a
 repository or have a database.
 
 I created a separate ORACLE_HOME for my install.
 
 Also, Oracle recommends that you use hostnames, so
 naming methods should reflect hostname.com instead of
 123.45.67.8.  
 
 During the install, you will be asked for a password
 for the Eterprise Manager website.  NOTE IT DOWN!!! 
 You'll need it to start and stop the EM website. 
 Oracle recommends that you start and stop services via
 the EM website and not the command line and I'll go
 along with this since I had trouble shutting down
 services via the command line (sometime it worked and
 sometime it did'nt).
 
 Also, during the install when prompted to run the
 root.sh script, run as root since this script starts
 the Apache httpd daemons.  These need to be started as
 root.  It does a bunch of other config things aswell. 
 See root.sh.  This is vital since after the install is
 complete, the installer then configures the components
 such web cache, OC4J components, Apache config etc. 
 This is the problem I was having on HP-UX, late in the
 day, govt client, sysadmin has left the building.
 
 Ok, after the install has completed and started all
 the services (hoepfully), you need to apply all
 relevant patches.  For the mid tier install, install
 the patch in the following order:
 
 9.0.1.3 patch set
 RDBMS bundled patch
 Oracle Internet Directory path
 Oracle HTTP server patch
 
 You'll see this in the install notes for the patch. 
 Note that the RDBMS bundled patch is slightly
 different on HP-UX versus Solaris.  Just read the
 instructions carefully if you are on HP-UX.  Solaris
 was a little easier.
 
 After the patch, you can login to the EM website at
 http://myhostname.com:1810.  If the website does not
 come up, you can start it from the prompt using emctl
 start|stop|status.  Stopping requires password which
 was entered earlier during install.  Password can also
 be changed using emctl set password pwd.
 
 Using the website, you can/start stop other services
 such as web cache, BC4J, OC4J containers etc.
 
 The default website can be accessed (hopefully) at
 http://myhostname.com:
 
 Also, you can start|stop the httpd daemons from the
 command line from $ORACLE_HOME/dcm/bin/dcmctl
 start|stop -ct ohs if the EM website is inaccessible
 for some reason.  Again, Oracle recommends that you do
 all admin through EM the website.
 
 Similarly, web cache can be started/stopped from the
 prompt by webcachectl start|stop|status.
 
 Finally, just a couple days ago, we seemed to have
 trouble starting 9iAS.  Seems like some log files had
 their ownership changed.  Don't know how this
 happened.  My guess is some sort of bug.  The way I
 tracked this is tailing the logs while trying to start
 the server.  Since I could'nt get the EM website up, I
 had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.
 
 Useful logs were:
 $ORACLE_HOME/opmn/logs/ons.log and ipm.log
 $ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
 and of cource
 $ORACLE_HOME/Apache/Apache/logs/error_log and
 access_log
 
 hth
 
 mkb
 
 --- Freeman, Robert [EMAIL PROTECTED] wrote:
  Folks,
   
  I'm a DBA who is really an old developer at heart. I
  know a little Java, a
  little Asp
  (enough, as they say, to be really dangerous!), I
  used to do C code that now
  makes 
  my head swim to look at. (I think to myself, what
  the devil was I doing??)
   
  Anyway, I've finally found some time and a machine
  here at work to start
  playing with
  OAS just to see what it's all about. Anyone have any
  good

RE: RE: (Fwd/2)

[Scott . Shafer]

With any luck, they'll all have the privilege of meeting Ray-Ray on Cell
Block D.  Maybe we should move this to OT, eh?

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, July 16, 2002 1:59 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re:RE: (Fwd/2)
 
 Gary,
 
 Well if you know almost nothing about accounting, I'm about 200 ft
 deeper
 into the waters than you and still know almost nothing about accounting
 as it
 turns out.  What is more, I don't even want to get acquainted with the
 bottom
 feeders in this here ocean!  We've always had the saying about Lier's,
 damned
 lier's , and statistics well you had better add accountants to the end
 cause it
 sure is one heck of a mess.  As for politicains, honest politician I
 believe is
 still an oxymoron.  SO the politicians and crooked  CEO's and accountants
 should
 be in good company.
 
 Dick Goulet
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9iAS Application Server: Win2k vs. Linux?

[Scott . Shafer]

I'm fighting with 9iAS 9.0.2 on HP at the moment.  This is one lng
install on an underpowered machine (2 cpu's, 2G mem).

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, July 16, 2002 2:45 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: 9iAS Application Server: Win2k vs. Linux?
 
 Gene,
 
 If it helps any, I had the privilege of setting up OAS ( several names ago
 
 )
 on both NT and Solaris 2.6.
 
 Solaris was by far easier.  I can't emphasize enough how much simpler
 it was on *nix than on Windoze. 
 
 Windoze:
 
 Step 1: do something
 Step 2: reboot
 Step 3: try something else
 Step 4: reboot
 
 Solaris:
 
 Step 1: Install
 Step 2: Configure
 Step 3: implement.
 
 Jared
 
 
 
 
 
 Gene Sais [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/16/2002 12:18 PM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:9iAS Application Server: Win2k vs. Linux?
 
 
 I am not looking for an OS war, but has anyone on the list had experience 
 in setting up/administering 9iAS rel 2. (1.0.2.2.2a) on Win2k or Red Hat 
 Linux?  I have the option of selecting the OS on this one.  All of my 
 oracle databases are on AIX (sort of like unix).  I have 1 OAS 4.0.8.2 App
 
 Server running on NT.  I am not sure if I should continue the NT track for
 
 App Servers or go Linux?  Any opinions, experiences would be appreciated. 
 Thanks,
 
 Gene
 
 PS. I will also be running the Forms Server w/ this.
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gene Sais
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: runInstaller

[Scott . Shafer]

*** inline...

 -Original Message-
 From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
 
 All this ranting is nice but consider the following:
 
 1) You do not install oracle on a server so much.
 In fact, in our shop this is done by the technical
 people, not the DBA. The DBA got the machine with
 oracle already installed and just build the database.
 
*** In your shop, maybe.  Not here.  Its up to the DBA's to do all
installs.

 2) When you have to do cross platform development
 Java is the tool to save on resources.
 
*** Anyone heard of Perl?  Java, save resources?  I don't think so.
Java is mostly marketing hype.

 3) Any machine that's need to run a production database
 should be strong enough to run Java ok.
 
*** Glad you have huge budgets to work with.  I wouldn't mind it so
much if the java _did_ run OK, but it doesn't.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: runInstaller

[Scott . Shafer]

Yeah!  Andy/Jared.  I'm pimpin' you guy's Perl stuff pretty hard.  How 'bout
some scoobie-snacks for yer boyz?

grin

Scott Shafer
San Antonio, TX


 -Original Message-
 From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
 
 2/3) Yes, Java is everywhere for a reason.  But real cross platform
 developmentPerl(hoping for that free book from Jared..(grin))
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

runInstaller

[Scott . Shafer]

What I wouldn't give for ./orainst /c right now.

RANT

Where is the productivity and ease of use of the #$%^#@ OUI when it takes
hours and hours just to load up all the java crap!  Piece of garbage is
enough to make me want to go back to 7.3.4 - and shoot the idiot who thought
up java...

/RANT

Thankyou.  I feel better about hating 9iAS now.


Scott Shafer
San Antonio, TX
210-581-6217


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: runInstaller

[Scott . Shafer]

Oh the system does.  That's a given.  There is no need to java-fy
everything.  There was a perfectly good working installer.  Not everyone
wants to jump through the hoops of setting up xservers and watching all your
RAM consumed by the JRE.

Perl and Perl TK are multi-platform, small footprint, etc.  OEM 1.6 still
had mostly Tcl/TK pieces and parts and ran fast and reliably.  Not so for
OEM 2.x.  Give me a command line back for installs.  That's not too much to
ask, right?

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Ray Stell [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, July 09, 2002 4:48 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: runInstaller
 
 
 
 You might look at silent mode install, Note:73510.1
 
 I have found that on really hot machines oui is a screamer.  It could be 
 your system needs a facelift.
 
 
 
 
 On Tue, Jul 09, 2002 at 12:47:19PM -0800, [EMAIL PROTECTED]
 wrote:
  What I wouldn't give for ./orainst /c right now.
  
  RANT
  
  Where is the productivity and ease of use of the #$%^#@ OUI when it
 takes
  hours and hours just to load up all the java crap!  Piece of garbage is
  enough to make me want to go back to 7.3.4 - and shoot the idiot who
 thought
  up java...
  
  /RANT
  
  Thankyou.  I feel better about hating 9iAS now.
  
  
  Scott Shafer
  San Antonio, TX
  210-581-6217
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 -- 
 ===
 Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ray Stell
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 2003 IOUG Meeting

[Scott . Shafer]

If you have the money...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, July 05, 2002 11:18 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: 2003 IOUG Meeting
 
 I NEVER get to see every presentation I want to see there. For my
 money, IOUG is the BEST conference around and more than worth the money
 
 Rachel
 --- Stephen Andert [EMAIL PROTECTED] wrote:
  Add to that the cost of getting there (Orlando FL for 2003), 
  transportation to/from the airport
  hotel (4-6 nights at around $200/night depending on what hotel you
  stay
  at)
  some meals (lunch is usually provided, some evening events include
  enough food for dinner)
   
  That said, I hope that doesn't scare your company off.  IMHO, this is
  the best investment you can make in your DBA's.  (I can't speak for
  developers.)  Both years I've gone, I was frustrated because there
  were
  more sessions that I wanted to attend that I could since they were at
  the same time.  This year, there were no sessions that I attended
  that I
  didn't learn something from.  Many of the sessions generated a list
  of
  to do as soon as I get back to the office.  
   
  Hope to see you there.
   
  Stephen
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Applications Development Database Refresh

[Scott . Shafer]

Jared, we do that here, but just:
take a cold backup of the production db, 
lay it down over the old dev db (via scp or tape), 
and open it renaming with a backup cpontrolfile script.  

Works like a charm, though I'm not sure what applmgr steps are required.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, July 05, 2002 5:43 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Oracle Applications Development Database Refresh
 
 Fellow listers,
 
 In addition to the usual SAP system that runs most of our company, we have
 Oracle Apps 10.7 HR.  For some reason the HR folks didn't like the SAP HR
 module, so I have SAP and Oracle Apps.
 
 The problem is a request I have to refresh the Dev database from the 
 Production database.
 
 If you can point me to the correct documentation for this, I'll take a 
 look at it.
 
 There's a lot of stuff to wade through in the docs and MetaLink, and I'd 
 rather just
 read documentation that's actually relevant.
 
 Thanks,
 
 Jared
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 2003 IOUG Meeting

[Scott . Shafer]

That wasn't a dig at anyone, Rachel.  It may be worth it, but if you don't
have the means to begin with, you can't very well write it off.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 08, 2002 2:19 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: 2003 IOUG Meeting
 
 I realize that it helps that I don't have kids so I have spare cash
 (no cash is ever really spare and I have very old, very expensive cats)
 
 but it IS tax-deductible, at least in part and it's worth it. At least
 to me. and yes, I have gone and paid all costs myself
 
 
 --- [EMAIL PROTECTED] wrote:
  If you have the money...
  
  Scott Shafer
  San Antonio, TX
  210-581-6217
  
  
   -Original Message-
   From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
   Sent: Friday, July 05, 2002 11:18 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  RE: 2003 IOUG Meeting
   
   I NEVER get to see every presentation I want to see there. For my
   money, IOUG is the BEST conference around and more than worth the
  money
   
   Rachel
   --- Stephen Andert [EMAIL PROTECTED] wrote:
Add to that the cost of getting there (Orlando FL for 2003), 
transportation to/from the airport
hotel (4-6 nights at around $200/night depending on what hotel
  you
stay
at)
some meals (lunch is usually provided, some evening events
  include
enough food for dinner)
 
That said, I hope that doesn't scare your company off.  IMHO,
  this is
the best investment you can make in your DBA's.  (I can't speak
  for
developers.)  Both years I've gone, I was frustrated because
  there
were
more sessions that I wanted to attend that I could since they
  were at
the same time.  This year, there were no sessions that I attended
that I
didn't learn something from.  Many of the sessions generated a
  list
of
to do as soon as I get back to the office.  
 
Hope to see you there.
 
Stephen
   
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 __
 Do You Yahoo!?
 Sign up for SBC Yahoo! Dial - First Month Free
 http://sbc.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Applications Development Database Refresh

[Scott . Shafer]

Gotchya.  Thanks, that's why I wasn't sure what had to be done there.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: John Kanagaraj [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 08, 2002 2:14 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle Applications Development Database Refresh
 
 Scott S - In many cases, the Apps SysAdmin performs the work on the
 'applmgr' and related APPS/APPLSYS accounts after the Db/Appltop copy and
 the DBA is not involved. 
 
 John Kanagaraj
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Applications Development Database Refresh

[Scott . Shafer]

My apps person tells me that they just restore the db and the applmgr stuff
works fine with 10.7.  Its sloppier than restoring the appl_top as well, but
works.  11/11i being an entirely different animal.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 08, 2002 5:06 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle Applications Development Database Refresh
 
 Thanks Scott, but the applmgr stuff is where the details are.
 
 
 
 
 
 
 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/08/2002 11:23 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Oracle Applications Development Database
 Refresh
 
 
 Jared, we do that here, but just:
 take a cold backup of the production db, 
 lay it down over the old dev db (via scp or tape), 
 and open it renaming with a backup cpontrolfile script. 
 
 Works like a charm, though I'm not sure what applmgr steps are required.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:  [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
  Sent:  Friday, July 05, 2002 5:43 PM
  To:Multiple recipients of list ORACLE-L
  Subject:   Oracle Applications Development Database Refresh
  
  Fellow listers,
  
  In addition to the usual SAP system that runs most of our company, we 
 have
  Oracle Apps 10.7 HR.  For some reason the HR folks didn't like the SAP 
 HR
  module, so I have SAP and Oracle Apps.
  
  The problem is a request I have to refresh the Dev database from the 
  Production database.
  
  If you can point me to the correct documentation for this, I'll take a 
  look at it.
  
  There's a lot of stuff to wade through in the docs and MetaLink, and I'd
 
 
  rather just
  read documentation that's actually relevant.
  
  Thanks,
  
  Jared
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Count rows in textfile

[Scott . Shafer]

Roland,

Just go ahead and open the file.  You know you want to.  We both know that
it would be soo satisfying to just take a peek inside, right?  That way
you can count lines.  I'm sure you can handle up to ~20 or so with your
zipper up, right?  No one needs to know...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 03, 2002 3:43 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Count rows in textfile
 
 Anyone whom has a good example on how to check how many rows (without
 opening the file) does a text file consists of?
 What is the command?
 
 
 Thanks in advance
 
 
 Roland
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Scott . Shafer]

And then you could have a background like mine which made it rather
painful...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, June 27, 2002 2:55 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Oracle DBA with TS SCI Clearance Needed in Dayton,
 Ohio..
 
 If your background is clean these clearances should be no big deal.  When
 I was driving submarines for a living I had TS, Crypto and COMSUBPAC
 Special Intelligence clearances.  SI is above TS.
  
 Ken Janusz, CPIM
 Former U.S.N. Submariner
 
   - Original Message - 
   From: Khedr, Waleed mailto:[EMAIL PROTECTED] 
   To: Multiple recipients of list ORACLE-L
 mailto:[EMAIL PROTECTED] 
   Sent: Thursday, June 27, 2002 2:30 PM
   Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton,
 Ohio..
 
   Another certification!
 
   -Original Message-
   From: Jesse W. Asher [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, June 27, 2002 3:15 PM
   To: Multiple recipients of list ORACLE-L
   Subject: Re: Oracle DBA with TS SCI Clearance Needed in
 Dayton, Ohio..
   
   
 
   Very good question!  I've wondered the same thing myself!
   
   Michael Cupp wrote:
   
 
   How would one begin the process of getting one?  Or
 does it have to be government sponsored?
   
   -Original Message-
   Sent: Thursday, June 27, 2002 2:35 PM
   To: Multiple recipients of list ORACLE-L
   
   
   It is my understanding that it currently takes 1.5
 to 2 years to get this clearence mainly due to events of 9/11. So, if you
 have one, it behooves you to keep it current.
   
   They used to estimate these clearences were worth
   an additional $10K a year for salary.   Im thinking
   at least $25K now.Alot of  my friends that have
   these clearances , whether they be DBAs,
 programmers,
   Sys. Ads. etc, have standing offers for work in many
   places around the world due to the fact these
 clearances
   are very hard to get.
   
   Also,  the companies will not foot the bill for this
   delay.  The government usually has to approve all
 hires
   where the individual is not cleared.  From what I
 have
   seen the government is in no mood to do this as of
   late.
   
   FWIW !
   
   Mike
   
   -Original Message-
   Sent: Wednesday, June 26, 2002 4:54 PM
   To: Multiple recipients of list ORACLE-L
   
   
   
   I don't understand the large number of positions
 coming out that require 
   a CURRENT Secret or Top Secret clearance.  How can
 all these positions 
   be filled unless these company/entities start
 footing the bill for 
   people getting the clearances?!?
   
   Johnson, Michael wrote:
   
 
 
   That is not my understanding.
   
   FWIW.  Mike
   
   -Original Message-
   Sent: Wednesday, June 26, 2002 1:35 PM
   To: Multiple recipients of list ORACLE-L
   
   
   Actually no one who has been holds any SCI tickets
 can admit to doing 
   so :) One can say you have been the subject of a
 Special Backgroud 
   Investigation, and Extensive Background
 Investigation, a Full Field 
   Investigation even though 99. times out of 100
 these investigations 
   are done for just such access.
   
   Ian MacGregor
   Stanford Linear Accelerator Center
   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
   
   
   -Original Message-
   Sent: Wednesday, June 26, 2002 9:24 AM
   To: Multiple recipients of list ORACLE-L
   
   
   I suspect

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Scott . Shafer]

Don't.  Its not worth the hassle.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Michael Cupp [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, June 27, 2002 1:53 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle DBA with TS SCI Clearance Needed in Dayton,
 Ohio..
 
 How would one begin the process of getting one?  Or does it have to be
 government sponsored?
 
 -Original Message-
 Sent: Thursday, June 27, 2002 2:35 PM
 To: Multiple recipients of list ORACLE-L
 
 
 It is my understanding that it currently takes 1.5 to 2 years to get this
 clearence mainly due to events of 9/11. So, if you have one, it behooves
 you to keep it current.
 
 They used to estimate these clearences were worth
 an additional $10K a year for salary.   Im thinking
 at least $25K now.Alot of  my friends that have
 these clearances , whether they be DBAs, programmers,
 Sys. Ads. etc, have standing offers for work in many
 places around the world due to the fact these clearances
 are very hard to get.
 
 Also,  the companies will not foot the bill for this
 delay.  The government usually has to approve all hires
 where the individual is not cleared.  From what I have
 seen the government is in no mood to do this as of
 late.
 
 FWIW !
 
 Mike
 
 -Original Message-
 Sent: Wednesday, June 26, 2002 4:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 I don't understand the large number of positions coming out that require 
 a CURRENT Secret or Top Secret clearance.  How can all these positions 
 be filled unless these company/entities start footing the bill for 
 people getting the clearances?!?
 
 Johnson, Michael wrote:
 
 That is not my understanding.
 
 FWIW.  Mike
 
 -Original Message-
 Sent: Wednesday, June 26, 2002 1:35 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Actually no one who has been holds any SCI tickets can admit to doing 
 so :) One can say you have been the subject of a Special Backgroud 
 Investigation, and Extensive Background Investigation, a Full Field 
 Investigation even though 99. times out of 100 these investigations 
 are done for just such access.
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 
 -Original Message-
 Sent: Wednesday, June 26, 2002 9:24 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I suspect that this position will be at Wright-Patterson Air Force 
 base.
 
 OraStaff wrote:
   
 
 Position: Oracle DBA with Top Secret SCI Clearance
   (Please do not send your resume unless you have the required
 
 
 
 -- 
 Jesse W. Asher
 
 They that can give up essential liberty to purchase a little temporary
 safety, deserve neither liberty or safety.  - Benjamin Franklin
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jesse W. Asher
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
 message BODY, include a line containing: UNSUB ORACLE-L (or the name of
 mailing list you want to be removed from).  You may also send the HELP
 command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Johnson, Michael 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
 message BODY, include a line containing: UNSUB ORACLE-L (or the name of
 mailing list you want to be removed from).  You may also send the HELP
 command for other information (like subscribing).
 
 
 This message originated from the internet.  Its originator may not be who
 they claim to be and the information contained herein my or may not be
 Accurate.
 
 All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Michael Cupp
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

[Scott . Shafer]

Get a job requiring the clearance, either as a direct government employee or
as a contractor.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, June 27, 2002 4:39 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle DBA with TS SCI Clearance Needed in Dayton,
 Ohio..
 
 For the curious around, does anyone know how one would do such a thing?
 
 RF
 
 Robert G. Freeman - Oracle8i OCP
 Oracle Database Architect
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
 Cousin Eddie: Those were my mother's dying words. But I
 guess if your body's covered in third degree burns, and 
 your foot's caught in a bear trap, you tend to start talkin' 
 crazy.
 
 
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 27, 2002 4:51 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Don't.  Its not worth the hassle.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:   Michael Cupp [SMTP:[EMAIL PROTECTED]]
  Sent:   Thursday, June 27, 2002 1:53 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Oracle DBA with TS SCI Clearance Needed in Dayton,
  Ohio..
  
  How would one begin the process of getting one?  Or does it have to be
  government sponsored?
  
  -Original Message-
  Sent: Thursday, June 27, 2002 2:35 PM
  To: Multiple recipients of list ORACLE-L
  
  
  It is my understanding that it currently takes 1.5 to 2 years to get
 this
  clearence mainly due to events of 9/11. So, if you have one, it behooves
  you to keep it current.
  
  They used to estimate these clearences were worth
  an additional $10K a year for salary.   Im thinking
  at least $25K now.Alot of  my friends that have
  these clearances , whether they be DBAs, programmers,
  Sys. Ads. etc, have standing offers for work in many
  places around the world due to the fact these clearances
  are very hard to get.
  
  Also,  the companies will not foot the bill for this
  delay.  The government usually has to approve all hires
  where the individual is not cleared.  From what I have
  seen the government is in no mood to do this as of
  late.
  
  FWIW !
  
  Mike
  
  -Original Message-
  Sent: Wednesday, June 26, 2002 4:54 PM
  To: Multiple recipients of list ORACLE-L
  
  
  
  I don't understand the large number of positions coming out that require
 
  a CURRENT Secret or Top Secret clearance.  How can all these positions 
  be filled unless these company/entities start footing the bill for 
  people getting the clearances?!?
  
  Johnson, Michael wrote:
  
  That is not my understanding.
  
  FWIW.  Mike
  
  -Original Message-
  Sent: Wednesday, June 26, 2002 1:35 PM
  To: Multiple recipients of list ORACLE-L
  
  
  Actually no one who has been holds any SCI tickets can admit to doing 
  so :) One can say you have been the subject of a Special Backgroud 
  Investigation, and Extensive Background Investigation, a Full Field 
  Investigation even though 99. times out of 100 these investigations
 
  are done for just such access.
  
  Ian MacGregor
  Stanford Linear Accelerator Center
  [EMAIL PROTECTED]
  
  
  -Original Message-
  Sent: Wednesday, June 26, 2002 9:24 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I suspect that this position will be at Wright-Patterson Air Force 
  base.
  
  OraStaff wrote:

  
  Position: Oracle DBA with Top Secret SCI Clearance
(Please do not send your resume unless you have the required
  
  
  
  -- 
  Jesse W. Asher
  
  They that can give up essential liberty to purchase a little temporary
  safety, deserve neither liberty or safety.  - Benjamin Franklin
  
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Jesse W. Asher
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
  message BODY, include a line containing: UNSUB ORACLE-L (or the name of
  mailing list you want to be removed from).  You may also send the HELP
  command for other information (like subscribing).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Johnson, Michael 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E

RE: Oracle 9.0.1.3 or 9.2.0?

[Scott . Shafer]

Yep.  We just upgraded to 8.1.7.x.  v9.x isn't even on the radar screen,
yet...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, June 13, 2002 9:48 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle 9.0.1.3 or 9.2.0?
 
 We are toying with the idea of crafting a policy that we only upgrade
 to a terminal release of a given version (e.g. 8.1.7, 9.0.1.3) in most
 cases, unless a different version is required by a vendor. It seems
 that these terminal release versions tend to be the most stable. Anyone
 else doing that?
 
 RF
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features 
 Mastering Oracle8i
 
 Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
 Cousin Eddie: Those were my mother's dying words. But I guess if your
 body's covered in third degree burns, and your foot's caught in a bear
 trap, you tend to start talkin' crazy.
 
 
 
 -Original Message-
 Sent: Thursday, June 13, 2002 7:01 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I thought the original question was what is more
 stable 9.0 or 9.2.
 
 If that is the basis for your decission stick with
 9.0.1.3 or better until 9.2 gets a couple dot releases
 on it. 
 
 With all the problems we have had with 9.0.1.x, I have
 not had one support person recommend we go to 9.2 to
 solve problems. In fact, they are backporting a bug
 found during internal testing of 9.2 beta to 9.0.1.3
 instead of asking us to upgrade. The basis for these
 decissions being (in my opinion) that 9.2 is not as
 stable as our current release.
 
 Bill
 
 --- Connor McDonald [EMAIL PROTECTED] wrote:
  Thats what Metalink has to say ( dunno what the note
  id is)..Expect '10i' sometime next year I'd say. 
  For
  similar reasons, 8.1.7 is supported longer than 9.0
  (since 9.2 is the terminal release)
  
  hth
  connor
  
   --- Grabowy, Chris [EMAIL PROTECTED] wrote: 
  Hello?  9.2 is the terminal release for Oracle9?  So
   Oracle10 is next, aside
   from patches, etc. to 9?
   
   -Original Message-
   Sent: Wednesday, June 12, 2002 1:33 PM
   To: Multiple recipients of list ORACLE-L
   
   
   I'd go 9.2 - its the terminal release so will
   supported for longer and removes Oracle's standard
   reply of 'please move to 9.2 and see if the
  problem
   disappears'
   
   hth
   connor
   
--- Raj Gopalan
   [EMAIL PROTECTED]
   wrote:  Hi DBAs

We are upgrading from 8.1.5 to 9.x. I thought of
finding out which release
of 9i is more stable. As We have got 9.2 couple
  of
weeks back, I was just
wondering what is  worth going for 9.2 instead
  of
9.0.1.3?

TIA,

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

Fat City Network Services-- (858) 538-5051 
   FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
   
  
 
 
To REMOVE yourself from this mailing list, send
  an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing:
  UNSUB
ORACLE-L
(or the name of mailing list you want to be
   removed
from).  You may
also send the HELP command for other information
(like subscribing). 
   
   =
   Connor McDonald
   http://www.oracledba.co.uk
   http://www.oaktable.net
   
   Some days you're the pigeon, some days you're the
   statue
   
   __
   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 
  FAX:
   (858) 538-5051
   San Diego, California-- Public Internet
   access / Mailing Lists
  
 
 
   To REMOVE yourself from this mailing list, send an
   E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
   'ListGuru') and in
   the message BODY, include a line containing: UNSUB
   ORACLE-L
   (or the name of mailing list you want to be
  removed
   from).  You may
   also send the HELP command for other information
   (like subscribing).
   -- 
   Please see the official ORACLE-L FAQ:
   http://www.orafaq.com
   -- 
   Author: Grabowy, Chris
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
  FAX:
   (858) 538-5051
   San Diego, California-- Public Internet
   access / Mailing Lists

RE: off topic: anyone form Amsterdam, Holland / other major europ

[Scott . Shafer]

Cost of living will largely depend on how much time you spend in the Red
Light District...  ;-)

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, June 11, 2002 5:13 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  off topic: anyone form Amsterdam, Holland / other major
 european 
 
 Hi !
 Sorry for this off topic posting.
 
 I will probably be offered a Solaris sys admin / Oracle DBA position in
 Amsteram, the Netherlands.
 Unfortunately , i have no idea of what order of magnitude salary should i
 get / request. 
 I have 6 years of experience in the field.
 So i wanted to ask the list memebers ( who are from Amsterdam or other
 major
 European cities , which is compatible to Amsterdam in terms of costs of
 living / salaries) a couple of questions:
 
 what would be a reasonable salary for a relocating person of my
 qualifications ?
 
 What is the living cost there , i.e. an appartment to rent , food ,
 leisure,
 travel , taxes ,etc.. ?
 
 How does Amsterdam compares price-wise to other Dutch cities and to other
 European capitals ?
 
 Thanks a lot in advance to everybody who will respond either directly to
 me
 or to the list.
 
 Cheers.
 
 P.S : Please forgive me if this off topic question bothers you ;-)
 
 
 
 DBAndrey
 
 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Andrey Bronfin
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM

[Scott . Shafer]

http://www.oracle.com

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, June 10, 2002 3:44 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  OEM
 
 
 Hi
 Does somone tell me how to check price information about Oracle enterprise
 
 manager product?
 Is OEM available on Unix box also?
 How to setup email with OEM?
 Thx
 -Seema
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[Scott . Shafer]

Typing on a keyboard can accomplish this.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, June 06, 2002 9:48 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Sqlloader
 
 Hallo,
 
 Anyone whom can tellme how to rename the field names everytime a text file
 is inserted in a table. The new field names are specified in the sqlloader
 script.
 
 Thanks in advance
 
 
 Roland
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sqlloader

[Scott . Shafer]

Then place your thumb squarely atop the fine manual...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Suzy Vordos [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, June 06, 2002 4:48 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Sqlloader
 
 
 First, take a hammer
 
 Stephane Faroult wrote:
 
  Can you give an example of how to type on a keyboard ? The Oracle
  manuals are unclear on this.
  
  TIA.
  
  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  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Suzy Vordos
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Jr.DBA, Mid level DBA, Sr.DBA

[Scott . Shafer]

So that's why the Gods died out...

Hehehe...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Weaver, Walt [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, May 31, 2002 2:39 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: RE: Jr.DBA, Mid level DBA, Sr.DBA
 
 You guys are rookies. The Gods all use Linux.
 
 --Walt
 
 -Original Message-
 Sent: Friday, May 31, 2002 1:17 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Better run like WIND!!  All Real DBA's use HP.
 
 Dick Goulet
 
 Reply Separator
 Author: Rachel Carmichael [EMAIL PROTECTED]
 Date:   5/31/2002 11:01 AM
 
 AIX? Come on all really senior DBAs work on SUN
 
 (ducking and running broken field pattern :)  )
 
 
 
 --- Freeman, Robert  [EMAIL PROTECTED] wrote:
  A few thoughts...
  
  Jr. DBA: Asks the Mid or Sr. DBA where to look.
  Mid DBA: Kind of knows where the answer is, but takes a bit to find
  it.
  Sr. DBA: Answer is dog eared in one or more of his office full of
  books.
  Really Sr. DBA: Answer is dog eared in his own book or paper.
  
  Jr. DBA: Feels a lot of fear with every change of the database he has
  to
  make.
  Mid DBA: Looks forward to the experience of making the changes.
  Sr. DBA: Suggests improvements when reviewing changes, helps
  implement those
  improvements and
   then monitors the Mid. DBA as he/she makes the change.
  Really Sr. DBA: Is busy installing the latest version of Oracle on
  AIX, and
  updating the current Oracle
  standards manual for the department, when the change is requested.
  Opens
  another window, quickly realizes that the change will end up causing
  all
  sorts of data inconsistencies,
  redesigns the entire change while at the same time flipping out CD 3
  of 5 of
  Oracle9iR2 for AIX, Implements
  the redesigned change after the developer reviews and approves. Then
  flips
  in CD 4 of 5.
  
  Jr. DBA: Checks with the Mid-tier DBA before making a change to make
  sure
  it's ok.
  Mid DBA: Checks with the Sr. DBA before making a change to make sure
  it's
  ok.
  Sr. DBA: Comfortable with making the change in his own right, but for
  more
  complicated changes
  or new architectural implementations, checks with the Sr. DBA to make
  sure
  it is ok.
  Really Sr. DBA: Talks with anyone who will listen and wonders why he
  is
  considered the grand-pobah
  DBA because he really doesn't feel like one.
  
  Jr. DBA: 3 Books on his desk.
  Mid DBA: 7 Books on his desk.
  Sr. DBA: 10-20 books on his desk.
  Really Sr. DBA: You can't find because he is buried under the books
  on his
  desk OR he is writing
  his latest book. 
  
  Jr. DBA: 2 weeks vacation, all taken.
  Mid DBA: 3 weeks vacation, 1 week taken and occasional Fridays. All
  made up
  by long weekend and holiday changes.
  Sr. DBA: 4 Weeks vacation, 1 week taken with pager going off three
  times,
  occasional Friday off too. All made up for by long weekend and
  holiday
  changes.
  Really Sr. DBA: 6 weeks vacation, none taken in 6 years (and of
  course the
  company doesn't accrue vacation time) and all those long weekend and
  holiday
  changes. Pager of cell phone always going off.
  
  
  
  
  
  
  Robert G. Freeman - Oracle8i OCP
  Oracle DBA Technical Lead
  CSX Midtier Database Administration
  Author: Oracle9i New Features 
  Mastering Oracle8i
  
  Clark Griswold http://us.imdb.com/Name?Chase,+Chevy : Eddie, has
  anyone ever told you that you're bad luck?
  Cousin Eddie http://us.imdb.com/Name?Quaid,+Randy : Those were my
  mother's dying words. But I guess if your body's covered in third
  degree
  burns, and your foot's caught in a bear trap, you tend to start
  talkin'
  crazy.
  
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Freeman, Robert
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E

RE: 64 BIT ORACLE FOR SOLARIS 64 BIT

[Scott . Shafer]

http://metalink.oracle.com

click on Patches.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, May 23, 2002 5:50 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  64 BIT ORACLE FOR SOLARIS 64 BIT
 
 Thanks for respond, Now I want to know which Patch of Oracle 8.1.7 is 64
 bit
 for solaris 64 ?
 
 Thanks again
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly

[Scott . Shafer]

No.  Get some downtime, quickly(!) before data does get written to that
file.  Go through the export/drop tablespace/recreate.  BTW, do you know
_why_ the file header is corrupted?  Is there a disk hardware problem?  You
are gonna have downtime sooner or later.  Tell damagement to get over it.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Xie, Tom [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  How to drop a datafile from a tablespace quickly
 
 Dear gurus:
 
 I just added a data file to a big tablespace (11GB) that has only one
 table. Unfortunately, when it was being backed up, the file head head 
 corrupted. I don't have any backup of this file. I found that there is 
 no data in this file yet. So I want to drop the file from the 
 tablespace. As I know, to drop a data file, I have to export the data,
 drop the tablespace and recreate it, and then import data back to 
 the tablespace. However, since our users can't stop using the table,
 I won't have enough down time to do that. 
 
 Is there anyway I can quickly drop a data file from a tablespace?
 
 Don't tell me using alter database datafile '...' offline drop command.
 It won't work.
 
 I am working on Oracle 7.3.4.
 
 Thanks,
 
 Tom Xie
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Xie, Tom
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly

[Scott . Shafer]

Not that I'm aware of.  Sounds like an interesting idea, but one I've never
tried.  I just told the users there was a hardware problem that necessitated
oracle coming down (whether there was one or not).  Dishonest?  Maybe, but
it bought me the brief, immediate downtime necessary to prevent more serious
problems in the future.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 12:58 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: How to drop a datafile from a tablespace quickly
 
 Scott - I agree with your advice. Could he take the bad datafile offline
 to
 prevent Oracle from writing to it (until he rebuilds the table)? Would
 that
 cause any other problems that I am overlooking?
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 
 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 12:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 No.  Get some downtime, quickly(!) before data does get written to that
 file.  Go through the export/drop tablespace/recreate.  BTW, do you know
 _why_ the file header is corrupted?  Is there a disk hardware problem?
 You
 are gonna have downtime sooner or later.  Tell damagement to get over it.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:   Xie, Tom [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, May 15, 2002 11:58 AM
  To: Multiple recipients of list ORACLE-L
  Subject:How to drop a datafile from a tablespace quickly
  
  Dear gurus:
  
  I just added a data file to a big tablespace (11GB) that has only one
  table. Unfortunately, when it was being backed up, the file head head 
  corrupted. I don't have any backup of this file. I found that there is 
  no data in this file yet. So I want to drop the file from the 
  tablespace. As I know, to drop a data file, I have to export the data,
  drop the tablespace and recreate it, and then import data back to 
  the tablespace. However, since our users can't stop using the table,
  I won't have enough down time to do that. 
  
  Is there anyway I can quickly drop a data file from a tablespace?
  
  Don't tell me using alter database datafile '...' offline drop
 command.
  It won't work.
  
  I am working on Oracle 7.3.4.
  
  Thanks,
  
  Tom Xie
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Xie, Tom
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other

RE: How to drop a datafile from a tablespace quickly

[Scott . Shafer]

Exactly my point.  The answer is 42.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED]
 [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 2:19 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: How to drop a datafile from a tablespace quickly
 
 
 
 there is a hardware problem that necessitated Oracle coming down. the only
 question is does the database come down cleanly when YOU want it to or
 does it
 come down with a crash, time undetermined, when the file is accessed?
 
 
 
 
 |+---
 ||   |
 ||   |
 ||  [EMAIL PROTECTED]|
 ||  ms.osd.mil   |
 ||   |
 ||  05/15/2002 02:39 PM  |
 ||  Please respond to|
 ||  ORACLE-L |
 ||   |
 |+---
   |
   ||
   |   To: [EMAIL PROTECTED] |
   |   cc: (bcc: Rachel Carmichael) |
   |   Subject: RE: How to drop a datafile from |
   |   a tablespace quickly |
   |
 
 
 
 
 Not that I'm aware of.  Sounds like an interesting idea, but one I've
 never
 tried.  I just told the users there was a hardware problem that
 necessitated
 oracle coming down (whether there was one or not).  Dishonest?  Maybe, but
 it bought me the brief, immediate downtime necessary to prevent more
 serious
 problems in the future.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
  Sent: Wednesday, May 15, 2002 12:58 PM
  To:   Multiple recipients of list ORACLE-L
  Subject:   RE: How to drop a datafile from a tablespace quickly
 
  Scott - I agree with your advice. Could he take the bad datafile offline
  to
  prevent Oracle from writing to it (until he rebuilds the table)? Would
  that
  cause any other problems that I am overlooking?
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
 
 
  -Original Message-
  [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, May 15, 2002 12:33 PM
  To: Multiple recipients of list ORACLE-L
 
 
  No.  Get some downtime, quickly(!) before data does get written to that
  file.  Go through the export/drop tablespace/recreate.  BTW, do you know
  _why_ the file header is corrupted?  Is there a disk hardware problem?
  You
  are gonna have downtime sooner or later.  Tell damagement to get over
 it.
 
  Scott Shafer
  San Antonio, TX
  210-581-6217
 
 
   -Original Message-
   From:   Xie, Tom [SMTP:[EMAIL PROTECTED]]
   Sent:   Wednesday, May 15, 2002 11:58 AM
   To: Multiple recipients of list ORACLE-L
   Subject: How to drop a datafile from a tablespace quickly
  
   Dear gurus:
  
   I just added a data file to a big tablespace (11GB) that has only one
   table. Unfortunately, when it was being backed up, the file head head
   corrupted. I don't have any backup of this file. I found that there is
   no data in this file yet. So I want to drop the file from the
   tablespace. As I know, to drop a data file, I have to export the data,
   drop the tablespace and recreate it, and then import data back to
   the tablespace. However, since our users can't stop using the table,
   I won't have enough down time to do that.
  
   Is there anyway I can quickly drop a data file from a tablespace?
  
   Don't tell me using alter database datafile '...' offline drop
  command.
   It won't work.
  
   I am working on Oracle 7.3.4.
  
   Thanks,
  
   Tom Xie
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Xie, Tom
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author:
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail

RE: Deadlock ORA-60

[Scott . Shafer]

kick the power cable to your server...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 2:19 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Deadlock ORA-60
 
 Hi
 I am getting ORA-60: Deadlock detected error.I know this is the 
 deadlock situation.But my question is how to correct this problem.
 Thx
 -Seema
 
 
 _
 Join the world's largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly

[Scott . Shafer]

I did not know that.  

Didn't Douglas Adams recently adjourn to the right hand of Hubble, there to
claim his 42 virgins in Paradise?

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 3:38 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: How to drop a datafile from a tablespace quickly
 
 Scott,
 
 Did you hear that Douglas Adams was asked recently (i.e. a few years ago)
 how he knew the Hubble Constant was (roughly) 42, back when he wrote the
 Hitchhiker's Guide To The Galaxy series back in the 60s and 70s?  The
 Hubble Constant (having to do with the rate of expansion of the universe,
 I
 think) had just been discovered to be 42, sometime in the mid-90s, I
 believe...
 
 His response was something along the lines of Well, actually I didn't
 know,
 of course.  It's just that I needed an answer to the question 'What is the
 meaning of life, the universe, and everything?' and 42 seemed like an
 appropriate answer.  Just an ordinary, sort of smallish number...
 
 I have to go back and re-read those...
 
 -Tim
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, May 15, 2002 2:03 PM
 
 
  Exactly my point.  The answer is 42.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Deadlock ORA-60

[Scott . Shafer]

Bad week.  Extra cranky today.  You do have to admit, it would solve the
problem...

--Scott


 -Original Message-
 From: Ray Stell [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 3:44 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Deadlock ORA-60
 
 On Wed, May 15, 2002 at 12:03:22PM -0800, [EMAIL PROTECTED]
 wrote:
  kick the power cable to your server...
 
 whoa, talk about attack of the clones...take a break, man.
 ===
 Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Datawarehousing help

[Scott . Shafer]

Come on, Rachel!  Zero Experence has never stopped anyone from publishing.
Just look at academia and MCSE study guides...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED]
 [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, May 07, 2002 8:19 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Datawarehousing help
 
 you people are soo funny.  Writing a book takes time, hard work and
 more
 energy than I care to commit to the project.. especially on a subject with
 which
 I have zero experience
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB Size

[Scott . Shafer]

Physical size (disk) or logical size (bytes of actual data)?

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Simon Waibale [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, May 03, 2002 9:53 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  DB Size
 
 Hi all,
 How could one collect data from an Oracle Server to respond to the
 question: 
 How big is (what is the size of your) Database ?
 
 Thaking you,
 
 ---
 CSW
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Simon Waibale
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Can't Connect to DB

[Scott . Shafer]

Start the database and listener services.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, May 02, 2002 9:43 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Can't Connect to DB
 
 Oracle 9i on XP Prof.  
 DB is on a single PC.
  
 When I try to do a DB connection I get this error.  Yesterday I created a
 second DB on my PC and was able to connect successfully to either of them.
 This morning I rebooted my PC and now I cannot connect.  
  
 Any idea what the problem is?
  
 TIA,
 Ken Janusz, CPIM
  
 -
  
 ORA-12541: TNS:no listener
 
 Details:
 Building Oracle HOMES List  
 HOME Name OraHome90 added to list.  
 Found multiple homes, searching each HOMEx for valid PATH  
 searching in SOFTWARE\ORACLE\HOME0  
 Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!  
 oci.dll found  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SIMPLE QUESTION

[Scott . Shafer]

What OS?  Oracle version?   

Oh yeah, stop SHOUTING.  We can hear you just fine here on the Good Ship
Lollipop.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 01, 2002 12:18 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  SIMPLE QUESTION
 
 HI AGAIN,
 
 JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO
 RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY
 ORACLE.
 HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT?
 THANKS FOR HELP.
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*NET VERSION

[Scott . Shafer]

You can't unless you read the documentation that came with your database.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Sinardy Xing [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, April 29, 2002 2:13 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  SQL*NET VERSION
 
 Hi all,
 
 How can I know my SQL*net (Oracle 8i w/ Solaris 7) Version number
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PATCH?

[Scott . Shafer]

At least you got it.  Tell Brian to squeeze...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, April 29, 2002 3:54 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  PATCH?
 
 How to give birth?  Please advise.
 
 Thx.  --Lisa
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unix - Writing stderr to a file and stdout

[Scott . Shafer]

command 21  logfile

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED]
 [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, April 26, 2002 1:31 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Unix - Writing stderr to a file and stdout
 
 Hi,
 
 Is it possible to write stderr to stdout and to another file
 simultaneously..?
 
 Thanks in advance.
 
 Mohammed Ahsanuddin
 Oracle DBA
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How come I don't get postings

[Scott . Shafer]

Please send jpgs.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, April 25, 2002 8:03 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: How come I don't get postings
 
 I can not see you on the list!
 
   -Original Message-
   From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, April 25, 2002 8:43 PM
   To: Multiple recipients of list ORACLE-L
   Subject: How come I don't get postings
   
   
 
   Guys, 
 
   Please someone tell me if you can see me on this list.  I just
 subscribed and got the welcome message but no messages from this list.
 
   Thanks, 
   Paula 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How come I don't get postings

[Scott . Shafer]

You ain't popped out that litter yet?  Get to walking, girl!

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, April 26, 2002 10:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  OT: How come I don't get postings
 
 Simon, if you don't know Scott, he's a huge joker and a source of many
 laughs...
 
 He was kidding!
 
 But seriously there is a whole slew of pics of OT list members on Yahoo.
 There's even one of me pre-pregnancy.  (I can barely remember what that
 was
 like.)
 
 Lisa Koivu
 Oracle Database Baby Oven
 Fairfield Resorts, Inc.
 5259 Coconut Creek Parkway
 Ft. Lauderdale, FL, USA  33063
 
  -Original Message-
  From:   [EMAIL PROTECTED]
 [SMTP:[EMAIL PROTECTED]]
  Sent:   Friday, April 26, 2002 11:28 AM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: How come I don't get postings
  
  
  
  .jpgs ?!*!
  
  
  Luckily for those of us of a sensitive disposition, I think jpgs (and
  other
  picture formats) would be filtered out by the list software, so we are
  safe from
  the threat of being suddenly confronted by images of our less-photogenic
  colleagues.  The best we could manage would be ascii representations,
 I'm
  sure
  someone could convert photo-to ascii if needed.-)
  
  Seriously though, I seem to remember a set of helpfull commands
 available
  from
  the other list address (not the posting address, the list-control one
 you
  get
  sent in your welcome message) - You could be stuck in 'Digest' mode,
 which
  would
  mean you have to wait a week for the whole list to arrive at once.
 Sorry
  that
  this is a RTFM, but it's been so long since I turned off digest mode I
  can't
  remember exactly how I did it...
  
  Simon Anderson
  
  
  
  
  Please respond to [EMAIL PROTECTED]
  
  To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  cc:(bcc: Simon Anderson/SSplc)
  
  
  
  
  Please send jpgs.
  
  Scott Shafer
  San Antonio, TX
  210-581-6217
  
  
   -Original Message-
   From:   Khedr, Waleed [SMTP:[EMAIL PROTECTED]]
   Sent:   Thursday, April 25, 2002 8:03 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: How come I don't get postings
  
   I can not see you on the list!
  
  -Original Message-
  From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, April 25, 2002 8:43 PM
  To: Multiple recipients of list ORACLE-L
  Subject: How come I don't get postings
  
  
  
  Guys,
  
  Please someone tell me if you can see me on this list.  I just
   subscribed and got the welcome message but no messages from this list.
  
  Thanks,
  Paula
  
  
  
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Koivu, Lisa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: AUDIT_ACTIONS

[Scott . Shafer]

read ?/rdbms/admin/cataudit.sql 

insert into audit_actions values (102, 'LOGOFF BY CLEANUP');
insert into audit_actions values (103, 'SESSION REC');
insert into audit_actions values (104, 'SYSTEM AUDIT');

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Charlie Mengler [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, April 25, 2002 9:43 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  AUDIT_ACTIONS
 
 103 SESSION REC
 
 I see entries in one of my AUD$ tables with a ACTION = 103
 I'd like to know exactly what this action references.
 I've searched my 8i online doc set but got no hits.
 
 I'm willing to RTFM is somebody will point me at which FM
 I should use in this case.
 
 TIA  HAND!
 
 -- 
 Charlie Mengler   Maintenance Warehouse  
 [EMAIL PROTECTED]  10641 Scripps Summit Ct.
 858-831-2229  San Diego, CA 92131
 Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: single clustered tables

[Scott . Shafer]

Objection 1) Most Oracle docs recommend: don't store data in
clusters
if it's going to be updated frequently. Updating clustered tables is
bad.

If its being updated, its not a true data warehouse.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Bill Becker [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, April 25, 2002 3:22 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  single clustered tables
 
 Hello,
 
 Env: Oracle 8.1.6 on Solaris 2.7
 
 Someone has suggested the following idea, and I'm wondering
 if this is good/bad. Any comments, pro or con, are appreciated.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: AUDIT_ACTIONS

[Scott . Shafer]

And Note:99137.1 details how to drill down through system_privilege_map, et
al. to find out what's going on.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Godlewski, Melissa [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, April 25, 2002 4:21 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: AUDIT_ACTIONS
 
 Below explanation from Metalink. 
 
 If something is being audited by session, then there are four values 
 that determine if the same record is updated or a new record is inserted. 
 
 Two of these values are the session id and the object id of the object the
 action is against. The third value is the constant action code 103 - this
 is used to show that this is a session record. The final value is the
 privs used. This has to match with the record already in the audit trail -
 i.e. if it is null, then the existing record must also be null. If it is
 non-null, then the existing record must have the same non-null value. 
 
 So, assuming the privs remain the same, all actions on one object go into
 one record. This includes insert, update, delete etc. Hence we can now see
 why the action name can't be anything other than SESSION REC as the record
 has to represent all the actions possible on the object. 
 
 -Original Message- 
 From: Suzy Vordos [ mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, April 25, 2002 1:49 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: Re: AUDIT_ACTIONS 
 
 
 
 select * from audit_actions where action=103; shows SESSION REC but not 
 sure what that means 
 
 Charlie Mengler wrote: 
  
  103 SESSION REC 
  
  I see entries in one of my AUD$ tables with a ACTION = 103 
  I'd like to know exactly what this action references. 
  I've searched my 8i online doc set but got no hits. 
  
  I'm willing to RTFM is somebody will point me at which FM 
  I should use in this case. 
  
  TIA  HAND! 
  
  -- 
  Charlie Mengler   Maintenance Warehouse 
  [EMAIL PROTECTED]  10641 Scripps Summit Ct. 
  858-831-2229  San Diego, CA 92131 
  Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now! 
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- 
  Author: Charlie Mengler 
INET: [EMAIL PROTECTED] 
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
  San Diego, California-- Public Internet access / Mailing Lists 
   
  To REMOVE yourself from this mailing list, send an E-Mail message 
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
  the message BODY, include a line containing: UNSUB ORACLE-L 
  (or the name of mailing list you want to be removed from).  You may 
  also send the HELP command for other information (like subscribing). 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Suzy Vordos 
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
 San Diego, California-- Public Internet access / Mailing Lists 
  
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L 
 (or the name of mailing list you want to be removed from).  You may 
 also send the HELP command for other information (like subscribing). 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: single clustered tables

[Scott . Shafer]

I'm going with the Kimball-ian definition of a DW showing changes over time
(temporal).  You don't want to go back and update historical data - unless
you're Enron grin - as this will skew results and trend analysis.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, April 25, 2002 4:20 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: single clustered tables
 
 Not true.  Many folks think a data warehouse is read only.  There is a
 huge difference between being designed to optimize reading and being
 read-only...
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, April 25, 2002 2:40 PM
 
 
  Objection 1) Most Oracle docs recommend: don't store data in
  clusters
  if it's going to be updated frequently. Updating clustered tables is
  bad.
 
  If its being updated, its not a true data warehouse.
 
  Scott Shafer
  San Antonio, TX
  210-581-6217
 
 
   -Original Message-
   From: Bill Becker [SMTP:[EMAIL PROTECTED]]
   Sent: Thursday, April 25, 2002 3:22 PM
   To: Multiple recipients of list ORACLE-L
   Subject: single clustered tables
  
   Hello,
  
   Env: Oracle 8.1.6 on Solaris 2.7
  
   Someone has suggested the following idea, and I'm wondering
   if this is good/bad. Any comments, pro or con, are appreciated.
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author:
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Tim Gorman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cronjob

[Scott . Shafer]

man kill

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, April 24, 2002 9:29 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Cronjob
 
 Anyone whom can tell me how to delete a job that  is  created by  crontab.
 
 Thanks in advance
 
 
 Roland
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cronjob

[Scott . Shafer]

Come on, Jared, its more fun to:

crontab  /dev/null

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, April 24, 2002 4:19 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Cronjob
 
 crontab -e is bad!
 
 1000 points if you can figure out why.
 ( guess I'm watching too much 'Whose Line Is It Anyway? )
 
 Jared
 
 
 
 
 
 Alex [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 04/24/2002 10:07 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: Cronjob
 
 
 crontab -e
 
 On Wed, 24 Apr 2002, bill thater wrote:
 
  [EMAIL PROTECTED] wrote:
  
   Anyone whom can tell me how to delete a job that  is  created by 
 crontab.
   
   Thanks in advance
   
   
   Roland
   
   
  
  man crontab
  
  
  -- 
  --
  Bill Shrek Thater  ORACLE DBA
   [EMAIL PROTECTED]
  
  You gotta program like you don't need the money,
  You gotta compile like you'll never get hurt,
  You gotta run like there's nobody watching,
  It's gotta come from the heart if you want it to work.
  
  Your e-mail has been returned due to insufficient voltage.
  
  
  
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: bill thater
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Alex
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Materilized view?

[Scott . Shafer]

Beer is a very good refreshment option.

Seriously, have you configured your job_queue_processes parameter in your
init.ora?  Are there any ora_snpx_SID processes running for your database?

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, April 23, 2002 2:19 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Materilized view?
 
 Hi
 8.1.6.0
 I used materialized view and used following query
 create materialized view vname
 refresh fast with primary key
 start with sysdate next sysdate+ 1/(24*60)
 as (select * from xxx.abc@test);
 I want to refresh materialized view every hour.Is above query correct?But
 i 
 am not looking refreshment.
 Let me know what things i check and correct to do for refreshment.
 Thx
 -seema
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: executing a stored procedure at a certain time

[Scott . Shafer]

dbms_job.  See the SQL guide for your particular version of Oracle at
http://technet.oracle.com   

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Nelson  Flores [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, April 19, 2002 2:53 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  executing a stored procedure at a certain time
 
 Hello everyone, 
 i was wondering if someone could tell me how set up an oracle internal
 mechanism that allows me 
 to execute an oracle stored proc. at a certain time every day. 
 
 thanks. 
 
 Atte. 
 Nelson Flores P. 
 Intec Project Manager 
 [EMAIL PROTECTED] 
 --
 - 
 Centro de tecnologías de Información  http://cti.intec.cl 
 Corporación de investigación Tecnológica - Intec http://www.intec.cl 
 --
 - 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Number of CPUs vs. Speed of CPUs

[Scott . Shafer]

How many CPU's will the box hold?  This # should be your requirement, as
you can always negotiate down...

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: YTTRI  Lisa [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, April 18, 2002 10:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Number of CPUs vs. Speed of CPUs
 
 We are in the process of sizing a new server for multiple Oracle
 instances.
 What factors are useful as input in determining how many CPUs and the
 relative speed of them?  For example, do we want fewer, faster CPUs or do
 we
 want more, slower CPUs?  Are there any good guidelines to determine what
 the
 number of CPUs should be?
 
 Thanks in advance -
 Lisa
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).