Re: DISK IO?

[Rocky Welch]

Hi Seema,
In Unix use the sar program (type: man sar at the unix prompt for
instructions) Win2K go to START  PROGRAMS  ADMINISTRATIVE TOOLS 
PERFORMANCE

HTH,
-Rocky

--- Seema Singh [EMAIL PROTECTED] wrote:
 Hi
 How to monitor disk IO on Unix AND Win2000 platform?
 Thanks
 -Seema
 
 _
 Get your FREE download of MSN Explorer at
 http://explorer.msn.com/intl.asp
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: User Processes Taking 200 Megs of RAM Upon Connecting

[Rocky Welch]

!! Please do not post Off Topic to this List !!

Hi Todd,
How many users are there and what is the nature of their database access
and are you running Multi-threaded server?

-Rocky

--- [EMAIL PROTECTED] wrote:
 !! Please do not post Off Topic to this List !!
 
 
 What are your hard and soft ulimits?
 
 David A. Barbour
 Oracle DBA, OCP
 AISD
 512-414-1002
 
 
 
  
 tcarlson@tripo  
  
 s.comTo: Multiple recipients of
 list ORACLE-L [EMAIL PROTECTED]  
 Sent by: cc:
  
 [EMAIL PROTECTED]   Subject: User Processes
 Taking 200 Megs of RAM Upon Connecting   
 om  
  
 
  
 
  
 09/12/2001  
  
 09:20 PM
  
 Please respond  
  
 to ORACLE-L 
  
 
  
 
  
 
 
 
 
 Hey gang. New job, new problems. I have just been handed a 8.1.7.0.0
 database on solaris 5.8 with a little problem.
 Everything time a client connects, regardless of type, the OS dedicates
 over 200+ Megs of RAM (as shown by Top) to the user process. Naturally,
 this is running the box out of memory. The init.ora has the following
 parameters:
 db_block_size = 8192
db_block_buffers = 9652
large_.pool_size = 200
 sort_area_size=65342
 sort_area_retained_size=65342
 
 There is nothing from any logs or trace files that helps. Plus, I am new
 to
 
 UNIX.
 Any help you could offer would be greatly appreciated.
 
 Todd Carlson
 www.tripos.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).
 
 
 
 
 -- 
 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).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: awk, sed, windoze, sql*loader, other fun stuff

[Rocky Welch]

Hi Lisa,
MKS Toolkit or Unix Utilites for Windows (Microsoft). Both work very well.

-Rocky

--- Koivu, Lisa [EMAIL PROTECTED] wrote:
 Hello all, 
 
 I'm working on sql*loader scripts and I realize that I'd probably be
 DONE by
 now if I had awk and sed to use.  Of course, as unix-deficient as I am,
 I
 don't have it.  Does anyone know of a windows version of these
 utilities?  
 
 Also I seem to remember someone had created a dynamic
 create-control-file-based-on-a-table script in the past and shared it
 with
 the list.  Does anyone remember where that was?  
 
 Gracias
 
 Lisa Koivu
 The Bootylicious DBA
 Ft. Lauderdale, FL, USA
 
 


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Deep Doo-Doo

[Rocky Welch]

Hi Dave,
Are you in archive log mode?

-Rocky

--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
 I have a very bad situation.  When I got in this morning I saw that the
 nightly backup was hung up.  I do a cold backup to another server and
 then
 the network admins backup my backup to tape.  I did a shutdown abort and
 then restarted my database.  But during the startup I got this in my
 SIDalrt.log
 
 EMN0 started with pid=19
 Mon Aug 13 06:46:23 2001
 KCF: write/open error block=0x1c75 online=1
  file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF
  error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write
 to
 file
 O/S-Error: (OS 5) Access is denied.'
 DBW0: terminating instance due to error 1242
 Instance terminated by DBW0, pid = 457
 Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG
 
 I also had a oradim.txt file created with this info;
 
 ORA-01113: file 10 needs media recovery
 ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
 
 ORA-01113: file 10 needs media recovery
 ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
 
 ORA-01113: file 8 needs media recovery
 ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'
 
 ORA-01113: file 10 needs media recovery
 ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'
 
 Now comes the good part.  Guess what part of the backup process was not
 scheduled as it should have been.  That's right, the tape backups!!  The
 network admins never scheduled my data for backup to tape.  All I have
 is
 last nights backups which are no good.  I opened a TAR but if any of you
 have any ideas I can try, I'm open for anything.  My database is down.
 I also just heard that my father is hospitalized.  Today really sucks!!
 
 Thanks,
 
 Dave
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Farnsworth, Dave
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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!?
Send instant messages  get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: (Fwd) Oracle8i Database Administration Boot camp

[Rocky Welch]

DBAs don't go to the bathroom. We're above that kind of thing. BARKEEP!
Get me another cold one!

--- April Wells [EMAIL PROTECTED] wrote:
 You HAVE to add another 30 seconds for bathroom break from the beer...
 maybe
 said lunch hour... meant lunch min (1 min 7.395 seconds)???
 
 -Original Message-
 Sent: Tuesday, July 31, 2001 2:31 PM
 To: Multiple recipients of list ORACLE-L
 
 
 http://wearables.stanford.edu/
 -
 
 the campus *does* have a 40 foot high training wall and rope
 suspension tower complex built by the ROTC, so when they
 say boot camp, maybe they really mean it?
 
 btw, what dbas take one hour to eat? i thought it only takes,
 on average, 37.395 seconds for a typical dba to swallow a 
 jumbo pack of MMs and drink a beer (add one second to that
 if the dba is doing a hotbackup of OPS during the lunch break).
 
 --
 
  From: Page, Bruce [EMAIL PROTECTED]
  Date: Mon, 30 Jul 2001 16:26:00 -0400
  Subject: RE: (Fwd) Oracle8i  Database Administration Boot camp 
 [small/Sacr
 
  A USB port connection wired straight to earphones and special eye
  wear. 
 
  I would be curious how one can obtain to be amoung the best 
  after a single
  7.5 hour course which I assume has an 1 hour lunch when most 
  training does
  similar in about 80-180 hours.
 
 
 --
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Eric D. Pierce
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 
 
 The information contained in this e-mail is strictly confidential and
 for the intended use of the addressee only; it may also be legally
 privileged and/or price sensitive.  Notice is hereby given that any
 disclosure, use or copying of the information by anyone other than the
 intended recipient is prohibited and may be illegal.  If you have
 received this message in error, please notify the sender immediately by
 return e-mail.
 
 Corporate Systems, Inc. has taken every reasonable precaution to ensure
 that any attachment to this e-mail has been swept for viruses.  We
 accept no liability for any damage sustained as a result of software
 viruses and advise you carry out your own virus checks before opening
 any attachment.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: April Wells
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Off Topic - Anybody know how to copy a DVD?

[Rocky Welch]

Just feed the analog output from the dvd player to the input of the VCR.

--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
 How do you do that?  Is that even possible, wouldn't you need some sort
 of
 converter or something like that?   What would the sound be like?
 
 -Original Message-
 Chris
 Sent: Tuesday, July 31, 2001 4:06 PM
 To: Multiple recipients of list ORACLE-L
 
 
 E...how about just copying the DVD to a VCR tape??  VCR tapes are a
 bit
 more durable.
 
 -Original Message-
 Sent: Tuesday, July 31, 2001 3:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Need a DVD Ram
 
 Walking on water and developing software from a specification are easy
 if
 both are frozen.
 
 Christopher R. Spence
 Oracle DBA
 Fuelspot
 
 
 
 -Original Message-
 Sent: Tuesday, July 31, 2001 3:11 PM
 To: Multiple recipients of list ORACLE-L
 
 
 My kids keep breaking their DVD movies.  Does anyone know a way to make
 a
 backup copy of a DVD?
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Smith, Ron L.
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
 message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Looking for a tool

[Rocky Welch]

Hi Andrey,
Try Cognos.
http://www.cognos.com/

HTH,

-Rocky

--- Andrey Bronfin [EMAIL PROTECTED] wrote:
 Dear friends !
 
 I'm desperately looking for a reporting tool with the following
 characteristics.
 
 It should be able to deploy various types of charts (Bar, Column, Line,
 Pie
 etc.) to a web environment.
 It should be able to extract its raw data from an Oracle (or other)
 RDBMS ,
 using SQL.
 It should have some kind of a graph design tools, so new reports could
 be
 easily deployed through the help of report templates.
 Different filters should be applied to a report (i.e.: Specific ISP on
 specific date range).
 Aggregation reports should be available (Could be done by SQL
 aggregation).
 It should support displaying the data as both graph and tables.
 It should be platform independent (i.e. Could run on NT, Win2000,
 Solaris).
 The component should be database independent (Should be able to extract
 data
 from  RDBMS like Oracle, DB2, MS-SQL).
 The component should be able to run from Tomcat/Apache as well as
 Macromedia
 JRun and BEA Weblogic.
 The component could be integrated and called from a web system 
 Preferably, the component could have a Java API.
 
 I have tried to search all the known serach engines with no results.
 Please advice !
 
 Thanks a lot 
 -- 
 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).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Oracle Applications 11i Help Files

[Rocky Welch]

Hi Gang,
When you click on the help icon of Applications 11i does it take you to
metalink or does it reference a file on the host machine?

TIA,
-Rocky

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 search all tables for a particular field?

[Rocky Welch]

Hi Igor,
Try:

Select table_name 
from all_tab_columns
where column_name = 'name of column';

HTH,

-Rocky

--- igor z [EMAIL PROTECTED] wrote:
 Hi,
 
 I am looking for a particular field if it exists in a database.  How to 
 search all tables for a particular field?
 
 Thanks in advance.
 Igor
 
 _
 Get your FREE download of MSN Explorer at
 http://explorer.msn.com/intl.asp
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: igor z
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 help ???

[Rocky Welch]

Hi Andrea,
Look for the oraInventory file. The installer reads this file for
information on installed products. Find the file then delete the OEM
entries. There are probably some registry entries that need to be removed
so search the registry for references to OEM.

HTH,
-Rocky

--- Andrea Oracle [EMAIL PROTECTED] wrote:
 Hi all,
 
 I installed OEM816 on NT40, database server is 815 on
 Sun 5.6. The OEM doesn't run since OMS NT service
 cannot be started for some reason.  I tried to
 deinstalled OEM using installer, the deinstalling only
 runs for 2% and jumpped out.  So I manually removed
 all the OEM files, and tried to install again.  Now
 the installer told me that you cannot install this
 since it's already in oem home directory.  and the
 Installed Products still shows all the OEM products,
 even though I already got rid off the whole oem home. 
 
 Are there anything log in the registry or some other
 places that I should clean out?  And does OEM816 works
 well with 815 database??  Thanks. 
 
 Andrea
 
 
 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Andrea 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).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Heads Up: Virus coming from list - Venkata Apparao

[Rocky Welch]

Lisa,
I'm sure he meant: Phat.
;o)

-Rocky

--- Kimberly Smith [EMAIL PROTECTED] wrote:
 Sometimes being called Fat is a complement.  I really am not sure why
 but
 its those same people who think stupid is a complement.
 
 -Original Message-
 Sent: Wednesday, June 27, 2001 10:42 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Looks like Venkata Apparao has a virus.  This person called me fat! 
 
 -Original Message- 
 Sent:   Wednesday, June 27, 2001 12:46 PM 
 To: Koivu, Lisa 
 The infected attachment was deleted. 
 
 Sender of the infected attachment:  Venkata Apparao N 
 Subject of the message:  Re: RE: Intermedia Questions, Any Gurus on This
 Subject?  
 One or more attachments were deleted. 
   Attachment YOU_are_FAT!.TXT.pif was Deleted for the following reasons:
 
 Virus W32.Badtrans.13312@mm was found. 
 
 


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Interesting query

[Rocky Welch]

Hi David,
Can you have them write the query with a variable then populate the
variable with the function?

-Rocky

--- David Turner [EMAIL PROTECTED] wrote:
 My users are writing many of their own functions and it is causing
 performance to suffer
 on a few simple queries. For example, I have a query that just selects
 count(*) from a
 table. With the function
 
 select count(*) from a_table where a_column = cdk(1234567890);
 
 It takes 5 minutes
 
 By plugging in the result of the cdk function into the query
 
 select count(*) from a_table where a_column = 0987654321;
 
 It take .18 of a second.
 
 How can I tell the optimizer that the result of the function will be the
 same every
 time so you don't need to call it for every row?  I can do this in the
 app but it would
 be cool to know if I can do this on the database side also.
 
 Thanks, Dave
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: David Turner
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Query help !!!

[Rocky Welch]

Hi Leslie,
This will be crude but it's a start. Gang, feel free to correct/improve:

select customer_id
from table_name
where 
customer_id in (select customer_id from table_name where status = 'F')
and
customer_id in (select customer_id from table_name where status = 'A')
and
customer_id in (select customer_id from table_name where status = 'B');

Pretty messy and resource intensive but it should work.

HTH,
-Rocky

--- Leslie Lu [EMAIL PROTECTED] wrote:
 Just to clearfy my previous question (as follow):
 
 if 1 has F and A and B, that what I want.
 
 If 1 has F all the time, that's not what I want.
 If 1 has A, B, C, but never F, that's not what I want
 either.
 
 --- Leslie Lu [EMAIL PROTECTED] wrote:
  Hi,
  
  If I have this:
  Customer_id  Status
  -- ---
  1   F
  1   A
  1   B
  2   F
  2   F
  3   A
  3   B
  
  How do I found out a customer who has both F and not
  F
  for them.  (If he only gets F, or gets other than F,
  that's fine).  In this case, I should get 1.  Thank
  you!  I need this badly!
  
  __
  Do You Yahoo!?
  Get personalized email addresses from Yahoo! Mail
  http://personal.mail.yahoo.com/
  
 
 
 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Leslie Lu
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Query help !!! - Rewrite

[Rocky Welch]

How about:

select f.customer_id
from table_name f, table_name a, table_name.b
where f.customer_id = a.customer_id and
  f.customer_id = b.customer_id and
  a.customer_id = b.customer_id and
  f.status = 'F' and
  a.status = 'A' and
  b.status = 'B';

Much cleaner than the one below.

--- Rocky Welch [EMAIL PROTECTED] wrote:
 Hi Leslie,
 This will be crude but it's a start. Gang, feel free to correct/improve:
 
 select customer_id
 from table_name
 where 
 customer_id in (select customer_id from table_name where status = 'F')
 and
 customer_id in (select customer_id from table_name where status = 'A')
 and
 customer_id in (select customer_id from table_name where status =
 'B');
 
 Pretty messy and resource intensive but it should work.
 
 HTH,
 -Rocky
 
 --- Leslie Lu [EMAIL PROTECTED] wrote:
  Just to clearfy my previous question (as follow):
  
  if 1 has F and A and B, that what I want.
  
  If 1 has F all the time, that's not what I want.
  If 1 has A, B, C, but never F, that's not what I want
  either.
  
  --- Leslie Lu [EMAIL PROTECTED] wrote:
   Hi,
   
   If I have this:
   Customer_id  Status
   -- ---
   1   F
   1   A
   1   B
   2   F
   2   F
   3   A
   3   B
   
   How do I found out a customer who has both F and not
   F
   for them.  (If he only gets F, or gets other than F,
   that's fine).  In this case, I should get 1.  Thank
   you!  I need this badly!
   
   __
   Do You Yahoo!?
   Get personalized email addresses from Yahoo! Mail
   http://personal.mail.yahoo.com/
   
  
  
  __
  Do You Yahoo!?
  Get personalized email addresses from Yahoo! Mail
  http://personal.mail.yahoo.com/
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Leslie Lu
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rocky Welch
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[Rocky Welch]

Make sure you grant select from dual to public.

HTH,
-Rocky

--- Shirish Khapre [EMAIL PROTECTED] wrote:
 hi
 i accidentally  dropped duel table from sys..then recreated it.
 now when i am using rman during running the catrman.sql for
 recovery_catalog
 it is flashing error
 
 select '08.00.05' from dual
 *
 ERROR at line 2:
 ORA-00942: table or view does not exist
 
 u'r help is highly appreciated
 
 Shirish Khapre, SE Rolta India Ltd.
 Off Ph No. (+91) (022) 832,826,8300568
 Ext'n 2730
 Minds are like parachutes. They only function when they are open
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Shirish Khapre
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Digestive

[Rocky Welch]

SET   ORACLE-L  DIGESTIVE

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sun Solaris 8 - Listener failed to start a dedicated server proce

[Rocky Welch]

Hi Jacques,
You need to increase the processes parameter in the init.ora file then
restart the listener and database.

HTH,

-Rocky

--- Jacques Kilchoer [EMAIL PROTECTED] wrote:
 On one of our Sun (development) servers, we have 8 databases running for
 different versions of Oracle (7.3.4, 8.0.6, 8.1.6). I am able to connect
 with SQL*Plus on the server, but I can't connect from a client. I get
 the
 following error
 
 ERROR:
 ORA-12500: TNS:listener failed to start a dedicated server process
 
 The server's listener.log shows the following error:
 22-MAY-2001 10:26:25 * service_died * 0
 22-MAY-2001 10:27:26 * service_died * 0
 22-MAY-2001 10:28:18 *

(CONNECT_DATA=(SID=dbname)(CID=(PROGRAM=C:\Oracle\Ora81\BIN\SQLPLUSW.EXE)(HO
 ST=mypc)(USER=Jacques_Kilchoer))) *
 (ADDRESS=(PROTOCOL=tcp)(HOST=xx.x.xx.xx)(PORT=4949)) * establish *
 dbname *
 12500
 TNS-12500: TNS:listener failed to start a dedicated server process
  TNS-12540: TNS:internal limit restriction exceeded
   TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
 Solaris Error: 12: Not enough space
 22-MAY-2001 10:28:28 * service_died * 0
 
 
 I would think that Solaris Error: 12 corresponds to this error number
 from
 /usr/include/sys/errno.h
 #define ENOMEM  12  /* Not enough core  */
 
 The Sun server has 4 processors / 4GB of ram.
 
 ipcs shows that there should be plenty of RAM available (about 680MB
 being
 used). swap -s shows that there is plenty of swap space available (4GB).
 I
 don't have an X-windows emulator on my machine so I don't think I can
 run
 admintool (is that right?)
 
 A search on Metalink find a forum entry with the following suggestions
 (1
 through 5). I tried 1 (increase processes in init.ora) and 4 (disable
 otrace
 by deleting .dat files). I don't really want to run MTS so I am
 discounting
 option 5 for now. I think the answer lies in 2 (increase Unix kernel
 parameters).
 
 What can I do? The System Administrator is busy so he gave me the root
 password and said have at it.
 
 -- From Metalink
 Intermittent TNS-12500 errors are caused by a lack of  resources on the
 server. Finding which resource is  depleted may be difficult. 
 
 1. The TNS-12500 can be a result of the 'processes'  parameter in the
 initsid.ora file being too low. 
 
 2. If the init.ora 'processes' parameter seems ok then you may need to
 increase the Unix kernel parameters for the maximum number of processes
 or
 users (for example, nproc or maxuprc). Check the manuals for the Unix
 operating system for more information on these parameters. 
 
 3. Check that you have adequate swap space. 
 
 4. Disable OTRACE. OTRACE is a tracing feature that can cause many
 problems.
 OTRACE is enabled by default. To disable OTRACE: 
 
 a. Stop the Oracle database. 
 b. Go to the $ORACLE_HOME/otrace/admin directory. 
 c. Delete all files with a '.dat' extension. 
 d. Restart the Oracle database. 
 
 5. Use the Multi-Threaded Server (MTS) option. 
 --
 Jacques R. Kilchoer
 (949) 754-8816
 Quest Software, Inc.
 8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 http://www.quest.com
 


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

RE: OT: RE: job offer from SAUDI ARABIA

[Rocky Welch]

I'm not upset, Ross. Being from the most powerful (thanks to our fine
people in the military), and generous (thanks to everyone), nation on
earth we are used to being critizied by the nations we help (the dog that
bites the hand that feeds it). I'm simply pointing out a fact that you
seem to have overlooked. No one is forcing you to stay here and there
certainly was no national vote to invite you to come. This is obviously a
better place to be than your own country, for whatever reason, otherwise
you wouldn't be here.
Enjoy the freedoms and luxury given to you by the great people of this
nation this weekend and keep your head down! 

AMERICA THE BEAUTIFUL!

--- Mohan, Ross [EMAIL PROTECTED] wrote:
 Not sorry if I touched a nerve, Rocky. 
 
 That's what it's all about. It's democracy, 
 suck it up, or spit it out. 
 
 
 || -Original Message-
 || From: Rocky Welch [mailto:[EMAIL PROTECTED]]
 || Sent: Thursday, May 17, 2001 4:36 PM
 || To: Multiple recipients of list ORACLE-L
 || Subject: Re: OT: RE: job offer from SAUDI ARABIA
 || 
 || 
 || And freedom to leave the country any time you wish. Have a 
 || nice flight.
 || 
 || --- Mohan, Ross [EMAIL PROTECTED] wrote:
 ||  rant on
 ||  
 ||  ep, 
 ||  
 ||  Any idiot can see we're the freest country in the world! 
 ||  Free to do what is expected, or get thrown in jail at a 
 ||  rate exceeding most other civilized nations. Free to 
 ||  subsidize tobacco and alcohol (and related deaths) and 
 ||  throw dangerous criminals in jail for using cannabis. 
 ||  Free to have almost the highest teenage pregnancy rate 
 ||  in the world. Free to fight for your rights just as long 
 ||  as your money lasts! Free to buy as much of whatever you
 ||  want until the money, environment, or patience of the
 ||  less fortunate runs out. 
 ||  
 ||  So much freedom, you could almost choke on it. 
 ||  
 ||  Come on, you commie, admit it: you just stay here for 
 ||  the Burgers and Coca-Cola!
 ||  
 ||  You have no chance to survive make your time
 ||  
 ||  rm
 ||  
 ||  p.s. If you want to reach me, I'll be in the prayer meeting 
 ||  John Ashcroft, the Attorney General, now holds each morning 
 ||  inside the Department of Justice. 
 ||  
 ||  rant off
 ||  
 ||  || -Original Message-
 ||  || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
 ||  || Sent: Thursday, May 17, 2001 3:07 PM
 ||  || To: Multiple recipients of list ORACLE-L
 ||  || Subject: Re: job offer from SAUDI ARABIA
 ||  || 
 ||  || 
 ||  || Many professional women in the USA have found it necessary to 
 ||  || purchase handguns to protect themselves from criminal 
 || elements in 
 ||  || public places. Children are constantly under 
 || psychological assault 
 ||  || being exposed to media violence. The liberal 
 || education system is 
 ||  || devoted to indoctrinating children with mindless PC 
 || relativism, 
 ||  || materialism/consumerism and hatred of God (or at least arrogant 
 ||  || dismissal).  
 ||  || 
 ||  || Western freedoms can be seen from a variety of perspectives.  
 ||  || 
 ||  || 
 ||  -- 
 ||  Please see the official ORACLE-L FAQ: http://www.orafaq.com
 ||  -- 
 ||  Author: Mohan, Ross
 ||INET: [EMAIL PROTECTED]
 ||  
 ||  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 ||  San Diego, California-- Public Internet access / 
 || Mailing Lists
 ||  
 || 
 ||  To REMOVE yourself from this mailing list, send an E-Mail message
 ||  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 ||  the message BODY, include a line containing: UNSUB ORACLE-L
 ||  (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! Auctions - buy the things you want at great prices
 || http://auctions.yahoo.com/
 || -- 
 || Please see the official ORACLE-L FAQ: http://www.orafaq.com
 || -- 
 || Author: Rocky Welch
 ||   INET: [EMAIL PROTECTED]
 || 
 || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 || San Diego, California-- Public Internet access / 
 || Mailing Lists
 || 
 || To REMOVE yourself from this mailing list, send an E-Mail message
 || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 || the message BODY, include a line containing: UNSUB ORACLE-L
 || (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: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists

Re: Event ID 1008 in NT - Oracle 8.0.5

[Rocky Welch]

Hi Pat,
Check the Oracle performance worksheet (which, I believe uses that dll) to
see if it's running. You may have it scheduled to collect data every 15
minutes.

HTH,

-Rocky

--- Piper, Pat [EMAIL PROTECTED] wrote:
 Good morning,
 
 I am getting the following error in the application event log. It occurs
 every hour and there are four instances of the error every hour. The
 error
 is as follows:
 
 Event ID 1008
 Source: Perflib
 The Open Procedure for service Oracle80 in DLL oraperf.dll failed.
 Performance data for the service will not be available. Status code
 returned
 is DWORD 0.
 
 I have no scheduled tasks on the database that may be causing the error.
 
 
 Any ideas?
 
 TIA,
 
 Pat
 ***
 Pat Piper CAT HAIKU
 Administrative Information Services  The rule for the day
 Keene State College   Touch my tail, I shred
 your hand
 Keene, NH 03435-2615New rule tomorrow
 (603) 358-2172
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Piper, Pat
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:adding columns to system tables

[Rocky Welch]

Could you create a new and seperate view based on the code from the old
one then add what you need?

--- [EMAIL PROTECTED] wrote:
 Greg,
 
 USER_TAB_COLUMNS is NOT a table but a complex view of several SYS
 tables. 
 Consequently adding a column requires redefining the view (owner by sys
 to boot)
 and then if you ever have to re-run catalog.sql your change is gone. 
 Not
 something I would do.
 
 Dick Goulet
 
 Reply Separator
 Author: Greg Schraiber [EMAIL PROTECTED]
 Date:   5/18/2001 8:25 AM
 
 Does anyone know if it is 'safe' to add additional columns
 to user_tab_columns? I am running 8.1.5. I would use the new
 columns to tell the application software which columns on
 any one table are user editable by a dynamically generated
 dialog form.
 
 Thanks,
 Greg
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Greg Schraiber
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: OT: RE: job offer from SAUDI ARABIA

[Rocky Welch]

Thanks for this response. I rest my case.

-Rocky

--- Mohan, Ross [EMAIL PROTECTED] wrote:
 || -Original Message-
 || From: Rocky Welch [mailto:[EMAIL PROTECTED]]
 || Sent: Friday, May 18, 2001 10:57 AM
 || To: Multiple recipients of list ORACLE-L
 || Subject: I am such a freaking ignorant redneck!
 || 
 || 
 || I'm not upset, Ross. Being from the most powerful (thanks to 
 || our fine people in the military), 
 
 Might makes Right is that it, Rocky? I think we're 
 powerful due to our ideas, noble efforts at protection 
 of human rights, and intellectual freedoms. 
 
 || and generous (thanks to everyone), nation on earth 
 || we are used to being critizied 
 
 Feeling put upon this morning, are we?
 
 || by the nations we help 
 
 I strongly suspect you couldn't quote foreign aid figures if 
 the WWF went off the air for two weeks and your neighbor's 
 newspaper blew into your home theater. You personally spent 
 about $30 last year in taxes on foreign aid; probably one 
 night's bar tab for you unless they were having a Two for One 
 Budweiser special in your trailer park. 
 
 
 || (the dog that bites the hand that feeds it). I'm simply 
 || pointing out a fact that you seem to have overlooked. No 
 || one is forcing you to stay here 
 
 Quite correct. As you have noted, it is the free-est of all 
 possible free countries. Unless, of course, I am in jail on
 an FBI case where they are holding back documents from the 
 prosecution. (That was in the newspapers, too.) 
 
 || and there certainly was no national vote to invite you to come. 
 
 ROFL!!!  As if a national vote would make a difference!  
 Based on recent events, I could get the popular vote and 
 still lose. For example, your guy actually lost, and still got
 installed.
 
 || This is obviously a better place to be than your own country, 
 
 Oops, yet another sadly uninformed opinion. Didn't Rush Limbaugh 
 cover my nationality on his talk show? Maybe you missed it 
 while you were watching Dr. Laura's special with Oliver North, 
 your Brother in Spirit?
 
 || for whatever reason, otherwise you wouldn't be here. Enjoy the 
 || freedoms and luxury given to you by the great people of this nation 
 
 I'll be sure to pat myself on the back, Rocky. chuckling
 
 || this weekend and keep your head down! 
 
 Oh? Are you related to Dylan Klebold? Planning to lynch someone?
 (That was in the paper, too. You might have missed it during your 
 Klan Rally. ) 
 
 Tell me something, Rocky. Are you one of those guys who proudly 
 fights for our freedom as long as he agrees with you? Or, are 
 you the onestep over the line, and POW! vigilante justice type 
 of guy?  
 
 Well, I have to go now, Rocky. I have a bunch of fish to shoot in
 a barrel -- a significantly harder task than finding the flaws in
 your screed.  You have a nice day. 
 
 
 || 
 || AMERICA THE BEAUTIFUL!
 
 p.s.  Yes, She is beautiful. Just think of what a glory She could 
be like if people like you were better informed. 
 
 
 
 
 
 
 
 http://www.cdi.org/adm/transcripts/950/
 http://www.rushlimbaugh.com/home/subscribe2.guest.html
 http://www.drlaura.com/main/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 drop schema script ??

[Rocky Welch]

How about:

drop user username cascade;


--- Luis DeUrioste [EMAIL PROTECTED] wrote:
 All mighty and powerful DBA supremes !
 
 Do any of you have a drop schema script that would be willing to share
 ??
 It'll be greatly appreciated
 
 T I A
 
  begin:vcard 
 n:de Urioste;Luis Octavio
 tel;fax:850.455.0673
 tel;work:850.457.3218
 x-mozilla-html:FALSE
 org:Raytheon Aerospace;IT
 version:2.1
 email;internet:[EMAIL PROTECTED]
 title:Systems Analyst
 adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 -
 UNFO;Pensacola;Florida;32534;U.S.A.
 fn:Luis Octavio de Urioste
 end:vcard
 


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: OT: RE: job offer from SAUDI ARABIA

[Rocky Welch]

And freedom to leave the country any time you wish. Have a nice flight.

--- Mohan, Ross [EMAIL PROTECTED] wrote:
 rant on
 
 ep, 
 
 Any idiot can see we're the freest country in the world! 
 Free to do what is expected, or get thrown in jail at a 
 rate exceeding most other civilized nations. Free to 
 subsidize tobacco and alcohol (and related deaths) and 
 throw dangerous criminals in jail for using cannabis. 
 Free to have almost the highest teenage pregnancy rate 
 in the world. Free to fight for your rights just as long 
 as your money lasts! Free to buy as much of whatever you
 want until the money, environment, or patience of the
 less fortunate runs out. 
 
 So much freedom, you could almost choke on it. 
 
 Come on, you commie, admit it: you just stay here for 
 the Burgers and Coca-Cola!
 
 You have no chance to survive make your time
 
 rm
 
 p.s. If you want to reach me, I'll be in the prayer meeting 
 John Ashcroft, the Attorney General, now holds each morning 
 inside the Department of Justice. 
 
 rant off
 
 || -Original Message-
 || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
 || Sent: Thursday, May 17, 2001 3:07 PM
 || To: Multiple recipients of list ORACLE-L
 || Subject: Re: job offer from SAUDI ARABIA
 || 
 || 
 || Many professional women in the USA have found it necessary to 
 || purchase handguns to protect themselves from criminal elements in 
 || public places. Children are constantly under psychological assault 
 || being exposed to media violence. The liberal education system is 
 || devoted to indoctrinating children with mindless PC relativism, 
 || materialism/consumerism and hatred of God (or at least arrogant 
 || dismissal).  
 || 
 || Western freedoms can be seen from a variety of perspectives.  
 || 
 || 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Link Between Prod and Test?

[Rocky Welch]

How about creating a user that only has read-only rights?

--- [EMAIL PROTECTED] wrote:
 One of our development DBAs suggested today to build a private database
 link between production and test database so that he can run some
 queries against both at the same time. I am a little concerned because
 he
 might make a mistake and accidentally corrupt the prod database. Anybody
 out there who is doing the same thing? Are there any other potential
 ramifications?
 TIA
 Dennis Meng
 Database Administrator
 Focal Communications
 847-954-8328
 
 -- 
 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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: OT: a bit of a brag...

[Rocky Welch]

Congrats! now if you can post a cigar for each of us. ;o)

--- Thater, William [EMAIL PROTECTED] wrote:
 My eldest graduated from college Saturday.  A double major in Spanish
 and German, cum laude, and a Fullbright scholar.  I'm proud of the
 boy!;-)
 
 Follow the link below for a nice picture and a little blurb.
 
 http://www.naz.edu/academics/fulbright/scholars.cfm
 
 
 --
 Bill Thater Certifiable ORACLE DBA
 Telergy, Inc.[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.
 ~~
 Microwave:  Signal from a friendly micro...
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Thater, William
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cool way to crash an Oracle database, any time, any place

[Rocky Welch]

: UNSUB ORACLE-L
 (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: Vikas Kawatra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Off Topic: Unix shell script problem - Urgent advise needed

[Rocky Welch]

Hi Viraj,

It looks to me like your clearing the value of $SHLIB_PATH (unset
SHLIB_PATH) then using $SHLIB_PATH to set the value of SHLIB_PATH. Since
it is empty to begin with the value will be null. In a shell script if you
run it from a user's current shell (in your case by executing tst) the
script picks up your current environment (therefore SHLIB_PATH is whatever
initial value is set from the user's .profile). But if you run . tst the
script gets it's environment from the script itself with all variables set
to null until initialized. You must make $SHLIB_PATH equal to some value
within the script before it can be used.

HTH,
Rocky

--- Viraj Luthra [EMAIL PROTECTED] wrote:
 Hello all,
 
 Ihave the following script, called as tst. When the script is executed
 as, 
 
 tst, then every thing is okay, but when it is executed as . tst, then I
 get the error:-
 
  sh: SHLIB_PATH: Parameter not set.
 
 I need to use the following format that is 
 . .profile, as in above case as . tst
 
 The reason why I am doing above is because the SHLIB_PATH is not set
 properly, I get heaps of problems. If the SHLIB_PATH is not set, I just
 want to set it to say $HOME.
 
 Please reply as this is urgent.
 
 Thanks and Regards,
 
 Raja
 
 ==
 
 The script follows:-
 
 #!/bin/sh  
 #  
 echo   
 echo   
 echo Start Test
 echo   
 echo uname -a = `uname -a` 
 echo First check what happens if you try and set SHLIB_PATH
 echo and there is no initial setting   
 unset SHLIB_PATH   
 echo First what is its value?  
 echo SHLIB_PATH = $SHLIB_PATH  
 echo Now lets set it to default:123
 SHLIB_PATH=$SHLIB_PATH:123   
 echo OK what is the value now? 
 echo SHLIB_PATH = $SHLIB_PATH  
 echo   
 echo Now lets reset the value to nothing   
 unset SHLIB_PATH   
 echo Check value   
 echo SHLIB_PATH = $SHLIB_PATH  
 echo Now do what is in our script  
 if [ -z ${SHLIB_PATH} ]; then
echo It has no current default value  
SHLIB_PATH=${HOME}  
 else 
 echo It has a default path of $SHLIB_PATH
 SHLIB_PATH=${HOME}:${SHLIB_PATH}   
 fi   
 echo So what is our final result?
 echo SHLIB_PATH = $SHLIB_PATH
 
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Viraj Luthra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

RE: OT: Reading the Oracle Tea Leaves

[Rocky Welch]

Of course, Patrice, we know there is only one of those goals you've listed
that you haven't met. We're just not sure which one. ;o)

--- Boivin, Patrice J [EMAIL PROTECTED] wrote:
 I think these are just statements of direction...
 
 I set goals for myself all the time, setting them is a lot easier than
 reaching them!
 
 If I had met my goals, by now I would be a millionaire, perfectly fit,
 pleasant to everyone, intelligent, perceptive, street wise, useful to
 everyone who comes in contact with me, etc. etc.
 
 I am way behind where I should be!
 
 : )
 
 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] mailto:[EMAIL PROTECTED] 
 
 
 
   -Original Message-
   From:   Jack C. Applewhite [SMTP:[EMAIL PROTECTED]]
   Sent:   Thursday, April 26, 2001 10:56 AM
   To: Multiple recipients of list ORACLE-L
   Subject:RE: OT: Reading the Oracle Tea Leaves
 
   Ian,
 
   Past history forces me to disagree.  If it takes Oracle as long to
 perfect
   AutoTuning as it has to perfect the Cost Based Optimizer, DBAs
 will
   continue to be in demand for decades to come!
 
   Jack
 
   
   Jack C. Applewhite
   Database Administrator/Developer
   OCP Oracle8 DBA
   iNetProfit, Inc.
   Austin, Texas
   www.iNetProfit.com
   [EMAIL PROTECTED]
   (512)327-9068
 
[EMAIL PROTECTED] 04/25/01 06:36PM 
   I foresee the database being sold as a turn key product configured
 by Oracle
   at a reduced price.   In order to receive the discount the purchaser
 would
   have to agree not to mess with the initSID.ora parameters, nor
 take any
   action which would enable or disable any database options.  What?!,
 not
   change init.ora parameters, you scoff.  Remember that Oracle 9i has
 some
   autotuning capability.  I expect, at first, autotuning will not work
 as
   advertised, but over time will mature into a powerful product.
 
   Ian MacGregor
 
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: Jack C. Applewhite
 INET: [EMAIL PROTECTED]
 
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing
 Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Off Topic: Unix shell problem

[Rocky Welch]

Hi Viraj,
Who is going to be running this script? Will it run from a crontab or
command line by multiple users? Can you please give more detail on what yu
are trying to accomplish.

-Rocky

--- Viraj Luthra [EMAIL PROTECTED] wrote:
 Hello all,
 
 Ihave the following script, called as tst. When the script is executed
 as, 
 
 tst, then every thing is okay, but when it is executed as . tst, then I
 get the error:-
 
  sh: SHLIB_PATH: Parameter not set.
 
 I need to use the following format that is 
 . .profile, as in above case as . tst
 
 The reason why I am doing above is because the SHLIB_PATH is not set
 properly, I get heaps of problems. If the SHLIB_PATH is not set, I just
 want to set it to say $HOME.
 
 Please reply as this is urgent.
 
 Thanks and Regards,
 
 Raja
 
 ==
 
 The script follows:-
 
 #!/bin/sh  
 #  
 echo   
 echo   
 echo Start Test
 echo   
 echo uname -a = `uname -a` 
 echo First check what happens if you try and set SHLIB_PATH
 echo and there is no initial setting   
 unset SHLIB_PATH   
 echo First what is its value?  
 echo SHLIB_PATH = $SHLIB_PATH  
 echo Now lets set it to default:123
 SHLIB_PATH=$SHLIB_PATH:123   
 echo OK what is the value now? 
 echo SHLIB_PATH = $SHLIB_PATH  
 echo   
 echo Now lets reset the value to nothing   
 unset SHLIB_PATH   
 echo Check value   
 echo SHLIB_PATH = $SHLIB_PATH  
 echo Now do what is in our script  
 if [ -z ${SHLIB_PATH} ]; then
echo It has no current default value  
SHLIB_PATH=${HOME}  
 else 
 echo It has a default path of $SHLIB_PATH
 SHLIB_PATH=${HOME}:${SHLIB_PATH}   
 fi   
 echo So what is our final result?
 echo SHLIB_PATH = $SHLIB_PATH
 
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Viraj Luthra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Standard vs Enterprise

[Rocky Welch]

Are you sure? I read that the data dictionaries are not compatible. I know
to go from standard to enterprise you must take an export, load the
software, create a new instance, then import.

--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
 Hi !
 
 
 The downgrade (if you call it) is pretty simple
 and straight forward.
 
 Just shutdown the database (and take backups!!)
 Remove the EE and Install the SE and create the service and 
 restart the database .
 
 
 
 
 
 -Original Message-
 Sent: Friday, April 20, 2001 9:26 PM
 To: Multiple recipients of list ORACLE-L
 
 
 We had a customer who are using Oracle8i Enterprise
 now , and they try to use Oracle8i Standard instead. I
 don't know why they try to do this(maybe standard cost
 less??). Anyway, is it easy to accomplish?
 
 TIA.
 
 Chris.
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - buy the things you want at great prices
 http://auctions.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: CC Harvest
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Standard vs Enterprise

[Rocky Welch]

Great! Thanks for the info!

--- CC Harvest [EMAIL PROTECTED] wrote:
 I got the following answers from Oracle support:
 
 You can convert from Enterprise Edition to standard
 edition.
 You need to shutdown and backup the database and
 software.
 -- De-install 817 Enterprise Edition.
 -- install 817 Standard Editon
 -- start the database and run catalog.sql and
 catproc.sql
 
 
 --- Rocky Welch [EMAIL PROTECTED] wrote:
  Are you sure? I read that the data dictionaries are
  not compatible. I know
  to go from standard to enterprise you must take an
  export, load the
  software, create a new instance, then import.
  
  --- K Gopalakrishnan [EMAIL PROTECTED] wrote:
   Hi !
   
   
   The downgrade (if you call it) is pretty simple
   and straight forward.
   
   Just shutdown the database (and take backups!!)
   Remove the EE and Install the SE and create the
  service and 
   restart the database .
   
   
   
   
   
   -Original Message-
   Sent: Friday, April 20, 2001 9:26 PM
   To: Multiple recipients of list ORACLE-L
   
   
   We had a customer who are using Oracle8i
  Enterprise
   now , and they try to use Oracle8i Standard
  instead. I
   don't know why they try to do this(maybe standard
  cost
   less??). Anyway, is it easy to accomplish?
   
   TIA.
   
   Chris.
   
   __
   Do You Yahoo!?
   Yahoo! Auctions - buy the things you want at great
  prices
   http://auctions.yahoo.com/
   -- 
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
   -- 
   Author: CC Harvest
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
  FAX: (858) 538-5051
   San Diego, California-- Public Internet
  access / Mailing Lists
  
 
 
   To REMOVE yourself from this mailing list, send an
  E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
   the message BODY, include a line containing: UNSUB
  ORACLE-L
   (or the name of mailing list you want to be
  removed from).  You may
   also send the HELP command for other information
  (like subscribing).
   
  
 
 _
   Do You Yahoo!?
   Get your free @yahoo.com address at
  http://mail.yahoo.com
   
   -- 
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
   -- 
   Author: K Gopalakrishnan
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
  FAX: (858) 538-5051
   San Diego, California-- Public Internet
  access / Mailing Lists
  
 
 
   To REMOVE yourself from this mailing list, send an
  E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
   the message BODY, include a line containing: UNSUB
  ORACLE-L
   (or the name of mailing list you want to be
  removed from).  You may
   also send the HELP command for other information
  (like subscribing).
  
  
  __
  Do You Yahoo!?
  Yahoo! Auctions - buy the things you want at great
  prices
  http://auctions.yahoo.com/
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Rocky Welch
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 
 
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (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! Auctions - buy the things you want at great prices
 http://auctions.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: CC Harvest
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL

Re: How to break into DBA/Systems work without going broke doing it?

[Rocky Welch]

I was a scuba instructor for 13 years then designed a database for classes
using Alpha 4 on an XT. After looking it over with one of my former
students who is an IT director, he hired me the next day. So just learn to
teach diving and WHAMO! 13 years later you're an Oracle DBA!

--- "Eric D. Pierce" [EMAIL PROTECTED] wrote:
 
 On 29 Mar 2001, at 8:31, Dasko, Dan wrote:
 
 Date sent:Thu, 29 Mar 2001 08:31:09 -0800
 To:   Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 
  OK, now I have to ask a question.  How did you(general) break into the
 DBA
  business?  
 
 ...
 
 
 I just used a standard sized crow-bar and sledge hammer.
 
 If there isn't likely to be one handy, or nearby at the DBA site, 
 also bring a broom and dust pan to dispose of any resuting debris.
 
 regards,
 ep
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Eric D. Pierce
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=====
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Opinions on this book...

[Rocky Welch]

Hi Gang,
Happy Wednesday! Has anyone read this book? I'm interested in what you
thought of it.

Thanks,

-Rocky

--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
 Rocky !
 
 I guess you are talking about his OCP TEst prepration guide.
 I think it is published by new riders.
 
 A quick search on AMAZON.com will give you more
 detaiils
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, March 28, 2001 2:45 AM
 
 
  Hi Gang,
  Anyone know of a book by Willard Baird? I'd like to like to know the
 title
  and any thoughts you may have.
 
  TIA,
 
  Rocky
 
  __
  Do You Yahoo!?
  Get email at your own domain with Yahoo! Mail.
  http://personal.mail.yahoo.com/?.refer=text
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Rocky Welch
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: What is best practice - differenet schema/different dbs

[Rocky Welch]

Hi Maheswara,
I would think seperate databases would be the way to go, if for no other
reason, you can bring one customer offline without affecting the others.

-Rocky

--- "Rao, Maheswara" [EMAIL PROTECTED] wrote:
 List,
 
 I would like to have your opinion on the following scenario.
 
 We are having an application which is used by different customers
 (around 15
 customers).  On an average each customer will have around 1,000
 transactions
 per 5 minutes.  Now, is it better to have a separate database for each
 customer on the same machine or to create all the customers as different
 schema in one single database?  
 
 What are the pros and cons.  I am specifically looking at performance
 and
 security issues.  
 
 Environment:
 
 This application is a 24x7 environment, OLTP application. Sun 6500
 Solaris 7
 with 4 CPUS. Raid 10.  Memory 4 GB (memory can be increased if
 required).
 Oracle 816.
 
 Thanks,
 
 Rao
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rao, Maheswara
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Trying to find a book...

[Rocky Welch]

Hi Gang,
Anyone know of a book by Willard Baird? I'd like to like to know the title
and any thoughts you may have.

TIA,

Rocky

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: DBA Job at a Chocolate Factory

[Rocky Welch]

I had a short gig setting up a database in Tallahassee State prison. They
had the prisoners entering data for underground utility lines. I had to
train the DBA who was in for 10 years for 3 counts of assault and battery.
That was like being on another, very bad, planet.
If anyone has any intrest in commiting crimes (unless you're a certain
recent former President then you can do whatever you want without fear of
justice) I urge you to tour such a facility. You'll never have an intrest
in commiting crime again.

-Rocky

--- Steve Orr [EMAIL PROTECTED] wrote:
 Seven years ago I was offered an Oracle DBA job at a chocolate factory
 and
 turned it down. (Please don't tell Rachel, she already thinks I'm
 crazy.) I
 had two simultaneous offers for the same salary and took the one closer
 to
 home. While on the interview they gave me the full tour of the factory
 starting with the bags of cocoa beans on the docks. The smell was
 intoxicating and even wafted into the office area where I would have
 worked.
 They had unlimited stashes of chocolate in every cubicle. I asked the
 employees if they ever got sick of chocolate and the answer was a
 resounding
 NO. Now my kids will never forgive me for not having taken the job at
 the
 chocolate factory.
 
 This begs the question... Where and what are some of the most
 interesting
 Oracle DBA jobs out there? I heard of one deep underground at a mining
 operation in the middle of the Nevada desert. Database is a basic
 technology
 that can be applied to just about any business anywhere. Any interesting
 stories? Personal experiences?
 
 
 Steve Orr
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Steve Orr
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

RE: DBA Job at a Chocolate Factory

[Rocky Welch]

Ang man...ugh...ers.

--- Steve Orr [EMAIL PROTECTED] wrote:
  DBA who was in for 10 years for 3 counts of assault and battery...
 He must have been working with a lot of duhvelopers. ;-)
 
 
 -Original Message-
 Sent: Wednesday, March 21, 2001 9:56 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I had a short gig setting up a database in Tallahassee State prison.
 They
 had the prisoners entering data for underground utility lines. I had to
 train the DBA who was in for 10 years for 3 counts of assault and
 battery.
 That was like being on another, very bad, planet.
 If anyone has any intrest in commiting crimes (unless you're a certain
 recent former President then you can do whatever you want without fear
 of
 justice) I urge you to tour such a facility. You'll never have an
 intrest
 in commiting crime again.
 
 -Rocky
 
 --- Steve Orr [EMAIL PROTECTED] wrote:
  Seven years ago I was offered an Oracle DBA job at a chocolate factory
  and
  turned it down. (Please don't tell Rachel, she already thinks I'm
  crazy.) I
  had two simultaneous offers for the same salary and took the one
 closer
  to
  home. While on the interview they gave me the full tour of the factory
  starting with the bags of cocoa beans on the docks. The smell was
  intoxicating and even wafted into the office area where I would have
  worked.
  They had unlimited stashes of chocolate in every cubicle. I asked the
  employees if they ever got sick of chocolate and the answer was a
  resounding
  NO. Now my kids will never forgive me for not having taken the job at
  the
  chocolate factory.
  
  This begs the question... Where and what are some of the most
  interesting
  Oracle DBA jobs out there? I heard of one deep underground at a mining
  operation in the middle of the Nevada desert. Database is a basic
  technology
  that can be applied to just about any business anywhere. Any
 interesting
  stories? Personal experiences?
  
  
  Steve Orr
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Steve Orr
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: import/export

[Rocky Welch]

System is fine.

--- "Leyden, Joseph" [EMAIL PROTECTED] wrote:
 Should I be SYS or SYSTEM user
 when exporting the entire database?
 
 Help!
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Leyden, Joseph
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: ORA-24371

[Rocky Welch]

Thanks, Tim. I checked the message and saw the same as you sent. I'm just
wondering if anyone has seen this before. The front end app is accessing
the data using java. Is it possible that and init.ora parameter is not set
correctly?

--- Tim Sawmiller [EMAIL PROTECTED] wrote:
  oerr ora 24371
 24371, 0, "data would not fit in current prefetch buffer"
 // *Cause:  An internal OCI error has occurred.
 // *Action: Please contact Oracle customer support.
 
 
 
  [EMAIL PROTECTED] 03/13/01 05:15PM 
 Hi Gang,
 One of the developers came to me with this error. There is nothing in
 the
 alert log or no trace files were generated. I'm at a complete loss. He
 was
 executing a query from a front-end API.
 
 This is running on 8.1.6, Solaris 8 on a Sun 450.
 
 TIA,
 
 -Rocky
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great prices.
 http://auctions.yahoo.com/ 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Rocky Welch
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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 Sawmiller
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

ORA-24371

[Rocky Welch]

Hi Gang,
One of the developers came to me with this error. There is nothing in the
alert log or no trace files were generated. I'm at a complete loss. He was
executing a query from a front-end API.

This is running on 8.1.6, Solaris 8 on a Sun 450.

TIA,

-Rocky

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Max Extents Error

[Rocky Welch]

Hi Sanjay,
Issue this command as the table owner:

alter table A maxextents unlimited;

Check the max extents for the table and use an appropriate value for your
application. Unlimited will allow the table to grow to the size of free
space in the tablespace.

HTH,
Rocky

--- Sanjay Kumar [EMAIL PROTECTED] wrote:
 Hi,
 
 I have a table which consists of Long Raw column in addition to other
 columns of Number and Varchar2 datatypes.
 
 I have the datafile size set to 2GB. The average length of the messages
 goes up to 100M, sometimes more than that.
 
 I have now added three datafiles to that tablespace each greater than
 the first datafile. But I still keep getting the
 ORA-01631 Max extents reached for table "A" error.
 
 What do I do resolve this error?
 
 I am using 8K as the DB block size on SOlaris with Oracle 816. It is not
 a prod environment instead a dev environment.
 
 Thanks
 Sanjay
 


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: bitmap index problem

[Rocky Welch]

Hi Leslie,
What is your COMPATIBLE parameter set to in the init.ora file?

-Rocky

--- Leslie Lu [EMAIL PROTECTED] wrote:
 Hi all,
 
 When I tried to build a bitmap index (8.1.5), I got
 this:
 ERROR at line 1:
 ORA-00439: feature not enabled: Bit-mapped indexes
 
 The error desc is:
 SQL !oerr ora 439
 00439, 0, "feature not enabled: %s"
 // *Cause:  The specified feature is not enabled.
 // *Action: Do not attempt to use this feature.
  
 May I know how to enable the feature?  Thank you.
 
 
 
 Leslie
 
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail. 
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Leslie Lu
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Oracle Data Guard

[Rocky Welch]

Hi Gang,
Can anyonepoint me to some documentation for this product? Technet seems
pretty limited.

TIA,

-Rocky

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Re: ora 27146 error ?

[Rocky Welch]

Hi Leslie,
I just ran into this about a month ago. I bet you're on Unix. The
/etc/system settings are too low. It's the same situation as when you get
a semephore no space left on device error. Raise them and reboot the
machine then yu should be ok. (The values you use will depend on machine
memory, etc.)

HTH,

-Rocky

--- Leslie Lu [EMAIL PROTECTED] wrote:
 Hi all,
 
 When I try to startup an instance, I got this:
 ORA-27146: post/wait initialization failed
 
 And this is what the document suggests:
 27146, , "post/wait initialization failed"
 // *Cause:  OS system call failed
 // *Action: check errno and contact Oracle Support
 
 Anybody has any solution?  Thank you.
 
 
 Leslie
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail. 
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Leslie Lu
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=====
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Newbie question on Packages

[Rocky Welch]

Hi Rakesh,
The Oracle user you are logged in as does not have select permission on
V$SESSION. Log in as sys and issue the command:

grant select on SYS.V_$SESSION to oracle user name;

HTH,

-Rocky

--- Rakesh Dinger [EMAIL PROTECTED] wrote:
 Hi, I a newbie in Oracle and am trying to create a package body in
 PL/SQL, so please bear with me.
 
 The statements are:
 SQL create or replace package body RA_GET_TX_INFO_
   2  as
   3  begin
   4  select SID from V$SESSION;
   5  end RA_GET_TX_INFO_;
  /
 Warning: Package Body created with compilation errors.
 SQL show errors package body RA_GET_TX_INFO_;
 Errors for PACKAGE BODY RA_GET_TX_INFO_:
  
 LINE/COL ERROR
 
 -
 3/10 PL/SQL: SQL Statement ignored
 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared
 
 
 How can I select from V_$SESSION inside the body? The user account has
 dba role granted and I can select from V_$SESSION from a normal PL/SQL
 session.
 
 Any help greatly appreciated.
 
 Thanks
 Rakesh
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rakesh Dinger
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: EXPORT PROBLEM

[Rocky Welch]

Hi Mala,
If you're on 8.1.6 it's a bug. If you do your export without the
consistent parameter it should finish okay but you should patch your
current installation.

--- mala singh [EMAIL PROTECTED] wrote:
 Hi DBAs
 
 I have problem at time of full export of Database.The following are the 
 error message at end of full export.
 EXP-8: ORACLE error 1403 encountered
 ORA-01403: no data found
 ORA-06512: at "SYS.DBMS_IJOB", line 450
 ORA-06512: at "SYS.DBMS_IJOB", line 482
 ORA-06512: at line 1
 EXP-0: Export terminated unsuccessfully
 Please help.
 Thanks in advance.
 
 -Mala
 
 

_
 Get Your Private, Free E-mail from MSN Hotmail at
 http://www.hotmail.com.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: mala 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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: EXPORT PROBLEM

[Rocky Welch]

I hate to say it but consult the metalink. That's how I found out about it
on 8.1.6.

--- mala singh [EMAIL PROTECTED] wrote:
 I am using 8.1.7.I think this is bug.What isur view
 -Mala
 
 From: Rocky Welch [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: EXPORT PROBLEM
 Date: Wed, 28 Feb 2001 11:45:51 -0800
 
 Hi Mala,
 If you're on 8.1.6 it's a bug. If you do your export without the
 consistent parameter it should finish okay but you should patch your
 current installation.
 
 --- mala singh [EMAIL PROTECTED] wrote:
   Hi DBAs
  
   I have problem at time of full export of Database.The following are
 the
   error message at end of full export.
   EXP-8: ORACLE error 1403 encountered
   ORA-01403: no data found
   ORA-06512: at "SYS.DBMS_IJOB", line 450
   ORA-06512: at "SYS.DBMS_IJOB", line 482
   ORA-06512: at line 1
   EXP-0: Export terminated unsuccessfully
   Please help.
   Thanks in advance.
  
   -Mala
  
  
  

_
   Get Your Private, Free E-mail from MSN Hotmail at
   http://www.hotmail.com.
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: mala 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).
 
 
 =
 Rocky Welch
 Senior Consultant - Internet Services Group
 Arthur Andersen
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail.
 http://personal.mail.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Rocky Welch
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

_
 Get Your Private, Free E-mail from MSN Hotmail at
 http://www.hotmail.com.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: mala 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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

Fwd: RE: Callout...SOLVED!

[Rocky Welch]

--- "Mohan, Ross" [EMAIL PROTECTED] wrote:
 From: "Mohan, Ross" [EMAIL PROTECTED]
 To: Rocky Welch [EMAIL PROTECTED]
 Subject: RE: Callout...NOT SOLVED!
 Date: Mon, 26 Feb 2001 12:48:11 -0500
 
 BINGO.
 
 congrats on the fix!
 
 (don't forget to tell the list the compiler was broken...)
 
 thanks, and take care.
 
 -Original Message-
 From: Rocky Welch [mailto:[EMAIL PROTECTED]]
 Sent: Monday, February 26, 2001 12:46 PM
 To: Mohan, Ross
 Subject: RE: Callout...NOT SOLVED!
 
 
 Hi Ross,
 Just fixed it. The cc compiler, although being reported as installed,
 was
 not. I installed Forte with the demo license, compiled the extproc.so
 library and all seems to be well now. Thanks alot for your input. Have a
 great week!
 
 -Rocky
 
 --- "Mohan, Ross" [EMAIL PROTECTED] wrote:
  what's the status on this?  I vote for
  inconsistent/incomplete compiler/C 
  environment, but w/o more info, cannot 
  be sure
  
  in any case, love to hear your solution, 
  when/if it appears
  
  -Original Message-
  From: Rocky Welch [mailto:]
  Sent: Friday, February 23, 2001 2:40 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Callout...NOT SOLVED!
  
  
  Thanks, Ross.
  I issued the command you suggested (the which cc comand) and it found
  the
  compiler just fine. If I relink the oracle executables it works fine.
  Any other thoughts?
  
  --- "Mohan, Ross" [EMAIL PROTECTED] wrote:
   did you install the c compiler? 
   
   ( You'd think Scott would put one there, but 
   he might be too busy getting fitted for a custom 
   Hannibal mask to cover his fat mouth yapping about
   Microsoft.) 
   
   If so, which one?  where is it located?
   Do a "which cc" and if it doesn't find your
   compiler, you need to either install it, or
   edit the mk file to redirect to an extant compiler.
   
   solaris seems to know about, but doesn't appear 
   to find /usr/ucb/cc
   
   amazing.the "dot in dot com"
   
   
   -Original Message-
   Sent: Friday, February 23, 2001 1:36 PM
   To: Multiple recipients of list ORACLE-L
   
   
   Hi Gang,
   I'm trying to compile the callout shared library under Solaris 2.8
 and
   Oracle 8.1.6. I'm receiving the message below. Any ideas?
   
   TIA,
   
   Rocky
   
   
   ptcprodb  cd $ORACLE_HOME/plsql/demo
   ptcprodb  cp $ORACLE_HOME/rdbms/demo/demo_rdbms.mk
   $ORACLE_HOME/plsql/demo
   ptcprodb  make -f demo_rdbms.mk extproc_callback \
SHARED_LIBNAME=extproc.so OBJS=extproc.o
   /export/oracle/product/8.1.6/bin/echodo cc -c -K PIC
   -I/export/oracle/product/8.1.6/rdbms/demo
   -I/export/oracle/product/8.1.6/rdbmsc
   cc -c -K PIC -I/export/oracle/product/8.1.6/rdbms/demo
   -I/export/oracle/product/8.1.6/rdbms/public
   -I/export/oracle/product/8.1.6/pc
   /usr/ucb/cc:  language optional software package not installed
   *** Error code 1
   make: Fatal error: Command failed for target `extproc.o'
   ptcprodb  
   
   __
   Do You Yahoo!?
   Yahoo! Auctions - Buy the things you want at great prices!
   http://auctions.yahoo.com/
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   -- 
   Author: Rocky Welch
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing
 Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (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! Auctions - Buy the things you want at great prices!
  http://auctions.yahoo.com/
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Rocky Welch
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail. 
 http://personal.mail.yahoo.com/
 


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__

Callout...

[Rocky Welch]

Hi Gang,
I'm trying to compile the callout shared library under Solaris 2.8 and
Oracle 8.1.6. I'm receiving the message below. Any ideas?

TIA,

Rocky


ptcprodb  cd $ORACLE_HOME/plsql/demo
ptcprodb  cp $ORACLE_HOME/rdbms/demo/demo_rdbms.mk
$ORACLE_HOME/plsql/demo
ptcprodb  make -f demo_rdbms.mk extproc_callback \
 SHARED_LIBNAME=extproc.so OBJS=extproc.o
/export/oracle/product/8.1.6/bin/echodo cc -c -K PIC
-I/export/oracle/product/8.1.6/rdbms/demo
-I/export/oracle/product/8.1.6/rdbmsc
cc -c -K PIC -I/export/oracle/product/8.1.6/rdbms/demo
-I/export/oracle/product/8.1.6/rdbms/public
-I/export/oracle/product/8.1.6/pc
/usr/ucb/cc:  language optional software package not installed
*** Error code 1
make: Fatal error: Command failed for target `extproc.o'
ptcprodb  

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Callout...NOT SOLVED!

[Rocky Welch]

Thanks, Ross.
I issued the command you suggested (the which cc comand) and it found the
compiler just fine. If I relink the oracle executables it works fine.
Any other thoughts?

--- "Mohan, Ross" [EMAIL PROTECTED] wrote:
 did you install the c compiler? 
 
 ( You'd think Scott would put one there, but 
 he might be too busy getting fitted for a custom 
 Hannibal mask to cover his fat mouth yapping about
 Microsoft.) 
 
 If so, which one?  where is it located?
 Do a "which cc" and if it doesn't find your
 compiler, you need to either install it, or
 edit the mk file to redirect to an extant compiler.
 
 solaris seems to know about, but doesn't appear 
 to find /usr/ucb/cc
 
 amazing.the "dot in dot com"
 
 
 -Original Message-
 Sent: Friday, February 23, 2001 1:36 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi Gang,
 I'm trying to compile the callout shared library under Solaris 2.8 and
 Oracle 8.1.6. I'm receiving the message below. Any ideas?
 
 TIA,
 
 Rocky
 
 
 ptcprodb  cd $ORACLE_HOME/plsql/demo
 ptcprodb  cp $ORACLE_HOME/rdbms/demo/demo_rdbms.mk
 $ORACLE_HOME/plsql/demo
 ptcprodb  make -f demo_rdbms.mk extproc_callback \
  SHARED_LIBNAME=extproc.so OBJS=extproc.o
 /export/oracle/product/8.1.6/bin/echodo cc -c -K PIC
 -I/export/oracle/product/8.1.6/rdbms/demo
 -I/export/oracle/product/8.1.6/rdbmsc
 cc -c -K PIC -I/export/oracle/product/8.1.6/rdbms/demo
 -I/export/oracle/product/8.1.6/rdbms/public
 -I/export/oracle/product/8.1.6/pc
 /usr/ucb/cc:  language optional software package not installed
 *** Error code 1
 make: Fatal error: Command failed for target `extproc.o'
 ptcprodb  
 
 __
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great prices!
 http://auctions.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rocky Welch
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: System Tablespace

[Rocky Welch]

 Be sure you use the compress=y variable if you want to consolidate the system tablespace extents.
-Rocky
 "Armstead, Michael A" [EMAIL PROTECTED] wrote: 
I also believe that you need to rebuild the database to defrag SYSTEM.Michael Armstead Database Administrator, OCP-CertifiedCorporate  Finance Information SystemsGlaxo SmithKline -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 7:25 AMM To: Multiple recipients of list ORACLE-L Subject: Re: System Tablespace   Hi   Export entire database recreate database import entire database  I believe is the only way to defrag system tablespace   Jack david hill   hateau.ca cc:  Sent by: Subject: System Tab!
lespace  [EMAIL PROTECTED]  m  20-02-2001  10:50  Please respond  to ORACLE-L Uhoh just noticed that someone here had created some users wiht their temporary tablespace as the system tablespace and now i have some big chunks of free space in there.  Is it a good idea for me to defrag my sytem tablespace now? if so could i just run the catproc.sql and the other sql's or would i have to do an export import. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED]  Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists !
 To REMOVE yourself from this mailing list, send  an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst  Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en volledige overbrenging van de inhoud v!
an een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.  Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen.  Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the!
 individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst  Young. Ernst  Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst  Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference.  If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies.  In carrying out its engagements, Ernst  Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. !
=  --  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: Armstead, Michael AINET: [EMAIL PROTECTED]Fat C!
ity Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing 

Re: automatic startup and shutdown of LISTENER

[Rocky Welch]

 Hi Van,
Looks like you have a space between the path and lsnrctl. That might be the problem.
HTH,
-Rocky
 "Van M. Etheridge" [EMAIL PROTECTED] wrote: 
I would like to be able tostartup and shutdown the listener when my SA shutsdown and brings the Unix box back up. What happens when my SA brings upthe OS is that he gets the lsnrctl prompt rather than listener starting. He can then type the start command and listerner starts. But it should start without him having to key in the command.I have the following in both the /etc/init.d/dbstart and/etc/rc2.d/s99dbstart files:su - oracle -c $ORACLE_HOME/bin/ lsnrctl start(I use the default listener name "LISTENER")Sun SPARC Solaris OS 2.4Oracle7 ServerRelease 7.3.4.0.1 - ProductionWith thedistributed, parallel query and Spatial Data optionsPL/SQL Release 2.3.4.0.0 - Production-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Van M. EtheridgeINET: [EMAIL PROTECTED]Fat City Network Serv!
!
ices -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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).Do You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address  - only $35 
a year!

Re: !!**** Urgent HELP (Table Deleted In Production )

[Rocky Welch]

 Hi Saroj,
If the table data isn't updated too often you can go back to an older export and import the table. If not, are you in archive log mode? Check your alert.log file for errors on the system datafile and let us know the status of your database to provide an accurate answer.
-Rocky
 "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: 
Dear Friends In product databace one of the developer had deleted a table and commited it,database is in online backup but no export backup or table backup Please tell me how can the table be recovered please guide me the exact detaied steps torecover the table After getting the reply i will start itThanks and Best regardsI tried this command recover database until time '2001-02-09:22:00:00' ;it gived the following error recovery session canceled due to errorsORA-01124: cannot recover data file 1 - file is in use or recoveryORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'SVRMGR recover databaseORA-00283: recovery session canceled due to errorsORA-01124: cannot recover data file 1 - file is in use or recoveryORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'SVRMGR rec!
!
over database until time '2001-02-09:22:00:00' ;ORA-00283: recovery session canceled due to errorsORA-01124: cannot recover data file 1 - file is in use or recoveryORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'SVRMGR select * from v$backup ;then again i shut down the database then up it again i tried but same errorsPlese reply soon saroj dash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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 t!
!
he name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address  - only $35 
a year!

Re: Strange command coming up when running sqlplus from Unix server...

[Rocky Welch]

 Hi Natasha,
Looks like an install problem. Check your /etc/system directory.
 Natasha Batson [EMAIL PROTECTED] wrote: 
A customer of mine, whenever he logs into sqlplus on his Unix server he getsthe following:"oracle817 sqlplusinst emulated pid=28337 va=0x14005b9b8 pc=0x1200fda40inst=0x3be6SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 8 09:25:04 2001(c) Copyright 2000 Oracle Corporation. All rights reserved.Enter user-name:BUTwhy does this line come up?inst emulated pid=28337 va=0x14005b9b8 pc=0x1200fda40inst=0x3be6Is it because of a problem with the installation?This problem, however does not occur when I logging to SQL from a PC."Hope someone can give me some feedback!RegardsNatashaBEGIN:VCARDVERSION:2.1N:Batson;NatashaFN:Natasha BatsonEMAIL;PREF;INTERNET:[EMAIL PROTECTED]REV:20010208T133151ZEND:VCARDRocky WelchSenior Consultant - Internet Services GroupArthur AndersenDo You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address  - only $35 
a year!

RE: OT NT2K vs Unix.

[Rocky Welch]

You’re right about that, Ross. People can use Microsoft products, businesses cannot. Of course the world does need organized recipes and an animated paper clip to remind them of cousin Tilly’s wedding so in that regard I guess Microsoft products are useful. :o)
 "Mohan, Ross" [EMAIL PROTECTED] wrote: 


Reboots:

Did you realize you DO have to reboot after some Solaris package installs? Maybe
not "all" and maybe not "Solaris 8", but.certainly some of them with kernel hooks
in 2.5.

Crashes:

Most of them due to poor third party driver authoring -- MS, a software company, gave
too much MoJo to developers. Imagine that. Same reason most of their software
swamps the market. People can USE it. Shocking Development! G

-----Original Message-From: Rocky Welch [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 20001 3:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT NT2K vs Unix.
From the URL:
http://www.microsoft.com/windows2000/guide/professional/solutions/overview/reliable/default.asp
PCs Stay Up and Running
Memory conflicts and missing or altered system files caused many of the system crashes prior to Windows 2000. To put an end to these problems, we changed Windows 2000 memory management to reduce the chance that software applications will interfere with one another. 
Applications runing in a seprate memory area...HMM Unix did that 15 years ago.
Fewer Reboots
Performing routine maintenance on your system requires significantly fewer reboots, therefore less downtime, with Windows 2000. In addition, with its support for Plug and Play, Windows 2000 automatically recognizes and adapts to hardware changes. This means users can easily add hardware devices such as scanners, DVD players, and speakers without rebooting, and with less potential for user error.
Reboots are also reduced-and reliability increased-through the Microsoft hardware device driver certification program. This program helps ensure that hardware drivers are compatible with Windows 2000, and do not require a reboot after installation. Certified drivers are tested and digitally signed by Microsoft. If Windows 2000 detects a driver that Microsoft has not digitally signed, it warns users about the risk before they install it on their system
Not having to reboot after installing an applicationUnix from it's beginings. 
How Much More Reliable Is Windows2000Professional?
Third-party studies that assess reliability from three different perspectives-lab-based testing, customer-site measurement, and user perceptions-conclude that Windows2000Professional is the most reliable desktop operating system.
Highest Reliability in Production Environments
NSTL collected uptime data in the real-world environment of several customer sites and concluded that the average system uptime between failures of Windows2000Professional is 13 times more than that of Windows98 and three times more than that of WindowsNTWorkstation4.0.
Notice no comparison to Unix. It's like people that hangout with socially unacceptable people to make themselves look better (Hey! Wait a minute! Is that why alot of people want to hang out with me? ). I guess you're right they aren't the same. Unix posts much higher numbers. 
Sorry, it's sarcastic Thursdsay here. I love the debate about Windows and Unix. ;o) 
 Kevin Kostyszyn [EMAIL PROTECTED] wrote: 


I would disagree with that, how is Windows becoming like Unix?

-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky WelchSennnt: Thursday, February 01, 2001 2:01 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT NT2K vs Unix.
The same prediction was made at least 5 years ago. At the rate Microsoft is going, Windows will be a direct form of Unix. It becomes more like it with every release. 
-Rocky 
 "Mohan, Ross" [EMAIL PROTECTED] wrote: 


Yea, but.. 
Win2K Datacenter will just decimate Unix. I predict that, in 5 years, there will be two or three Unix vendors, fighting over the 45% of the market that DataCenter hasn't eaten. 
-Original Message- From: Steve Orr [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT_RE:_Réf._:_Re:_asyn_i/o_on_sun_ 
Close. It's Dave Cutler. There's too much old DOS/Windows backward compatibility for WinNT/2000 to achieve stability like VMS despite Cutler's leadership. 
I knew VMS and you, Mr. NT, are no VMS! 
With apologies to Senator Bentsen, Steve Orr 
-Original Message- stephane Sent: Thursday, February 01, 2001 9:22 AM& To: Multiple recipients of list ORACLE-L 
NT is based on VMS (talk about a real OS) and if my memory is good the guy's name is Cutter. 
Do I win a toaster ? a microwave oven ? a palm-pilot ? 
--- "Mohan, Ross" [EMAIL PROTECTED] a écrit:  "...Standing, corrected, and  sniggering."  Odd picture, that..Anyways, pop quiz:   On what OS kernel technology i

RE: OT NT2K vs Unix.

[Rocky Welch]

 Air Bag? Windows Crash? The next generation of PC I can see it now. LOL This is a debate that will continue for years but it is entertaining. Thanks to all for theinteresting reading. =(True.Not sarcastic or mean.)
 Kevin Kostyszyn [EMAIL PROTECTED] wrote: 


Good points and don't worry about the sarcasm, at least you are honest about it. Sometimes I can't tell if people are being mean, or sarcastic. 
Anyway, back to the argument. 
 What it would seem like to me is that because Microsoft is trying to improve their platform you are arguing that they are moving more towards Unix. That's not right. They are trying to improve their system. Just because the Unix OS already had some of the functions that made it more stable doesn't mean that MS is copying Unix. For the love of goodness, if I think that way everyone is copying everyone else in some form or another! When air bags came out and car manufacturers starting putting them in their vehicles standard, did anyone walk around pointing fingers and saying "Hey, that was our idea come up with your own precautionary measures to avoid disaster!!!" 
 hehehhehehe Kev

-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky WelchSennt: Thursday, February 01, 2001 3:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT NT2K vs Unix.
From the URL:
http://www.microsoft.com/windows2000/guide/professional/solutions/overview/reliable/default.asp
PCs Stay Up and Running
Memory conflicts and missing or altered system files caused many of the system crashes prior to Windows 2000. To put an end to these problems, we changed Windows 2000 memory management to reduce the chance that software applications will interfere with one another. 
Applications runing in a seprate memory area...HMM Unix did that 15 years ago.
Fewer Reboots
Performing routine maintenance on your system requires significantly fewer reboots, therefore less downtime, with Windows 2000. In addition, with its support for Plug and Play, Windows 2000 automatically recognizes and adapts to hardware changes. This means users can easily add hardware devices such as scanners, DVD players, and speakers without rebooting, and with less potential for user error.
Reboots are also reduced-and reliability increased-through the Microsoft hardware device driver certification program. This program helps ensure that hardware drivers are compatible with Windows 2000, and do not require a reboot after installation. Certified drivers are tested and digitally signed by Microsoft. If Windows 2000 detects a driver that Microsoft has not digitally signed, it warns users about the risk before they install it on their system
Not having to reboot after installing an applicationUnix from it's beginings. 
How Much More Reliable Is Windows2000Professional?
Third-party studies that assess reliability from three different perspectives-lab-based testing, customer-site measurement, and user perceptions-conclude that Windows2000Professional is the most reliable desktop operating system.
Highest Reliability in Production Environments
NSTL collected uptime data in the real-world environment of several customer sites and concluded that the average system uptime between failures of Windows2000Professional is 13 times more than that of Windows98 and three times more than that of WindowsNTWorkstation4.0.
Notice no comparison to Unix. It's like people that hangout with socially unacceptable people to make themselves look better (Hey! Wait a minute! Is that why alot of people want to hang out with me? ). I guess you're right they aren't the same. Unix posts much higher numbers. 
Sorry, it's sarcastic Thursdsay here. I love the debate about Windows and Unix. ;o) 
 Kevin Kostyszyn [EMAIL PROTECTED] wrote: 


I would disagree with that, how is Windows becoming like Unix?

-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky WelchSennnt: Thursday, February 01, 2001 2:01 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT NT2K vs Unix.
The same prediction was made at least 5 years ago. At the rate Microsoft is going, Windows will be a direct form of Unix. It becomes more like it with every release. 
-Rocky 
 "Mohan, Ross" [EMAIL PROTECTED] wrote: 


Yea, but.. 
Win2K Datacenter will just decimate Unix. I predict that, in 5 years, there will be two or three Unix vendors, fighting over the 45% of the market that DataCenter hasn't eaten. 
-Original Message- From: Steve Orr [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT_RE:_Réf._:_Re:_asyn_i/o_on_sun_ 
Close. It's Dave Cutler. There's too much old DOS/Windows backward compatibility for WinNT/2000 to achieve stability like VMS despite Cutler's leadership. 
I knew VMS and you, Mr. NT, are no VMS! 
With apologies to Senator Bentsen, Steve Orr 
-Original Message- stephane Sent: Thursday, February 01, 2001 9:22 AM&