date:20010822

On Wednesday 22 August 2001 09:51, JOE TESTA wrote:
> how about this as a solution:
>
> alter user sys default tablespace tools;
>
> @?/rdbms/admin/Put SCRIPT HERE :)
>
> joe

Kids!

Don't try this at home!

Jared

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

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

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

Re: Oracle 8.1.7 installation and running on RedHet7.0



Cristi,

I suggest going to the archives at http://www.fatcity.com/ListGuru/login.php
and searching for 'linux'.

There's several threads there that you may find helpful.

Jared

On Wednesday 22 August 2001 09:22, Cristi Marius wrote:
> Hi!
>
>   I am an Oracle products user (in fact JDBC applications that use Oracle as
> a backend) but I used them only under Windows platforms. The installation
> on that kind of platform is pretty simple, but I am not so satisfied with
> the performances. I have been told that Oracle products work with better
> results on UNIX platforms. I have an RedHet 7.0 server machine and I tried
> to install Oracle8.1.7 for Linux Enterprise Edition. I followed all the
> steps from the Installation Guide but the following errors occurred:
> 1)not connected to Oracle (when the dbassist run)
> 2)end of communication channel.
>
> If I run a ./tnsping  the response is ok, but if I try to
>
> I dig deeper on some newsgroups and I found out that there are many users
> with this problem, so my questions are:
>
> 1)what is the best open source implementation of linux to use with oracle?
> 2)where can I find a specialized documentation on Oracle Installation
> (8.1.7) on RedHet 7.0? (a list of the steps that I must follow would be
> very helpful to me) 3)can you give some links with advanced issues on the
> problems I told you about?
>
> Best regards,
> Cristi Marius
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

OT - File System to Disk Mapping

2001-08-22 Thread Viraj Luthra


Hello all,

If I want to know from the unix system point of view, which disk is being bombarded by 
a particular data file, how do I come to know. I have used the mount command but that 
gives me the logical volume, but does not give the disk name that it is hitting.

This is on hp11. I can come to know from the mount command that oracle datafiles are 
on /dev/vg00/lvol3

But I want to know which disk does /dev/vg00/lvol3 hit? whether it hits disk c1t2d0 or 
c2t2d0 ?

Any unix guru can tell me what command to see apart from mount which I have used?

thanks.

raja


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

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

RE: Apologies... linux & Oracle

2001-08-22 Thread Gautam_Reddy


All,

For starters, there is a bug in RH 7.1 and some Oracle executables are not
linked correctly at link time.  Here is the workaround:

Workaround:
1.Complete an installation
2. Login as an 'oracle' owner to the installed environment
3. delete '-z defs' from
ldap/lib/ins_ldap.mk
ldap/lib/env_ldap.mk
sqlplus/lib/env_sqlplus.mk
  4. issue the command $ORACLE_HOME/bin/relink all
   5. for RAC, steps 2-4 should be performed on all nodes.

We are working along with Oracle and RedHat to get 9i certified on Redhat.

Thx
Gautam 


-Original Message-
Sent: Tuesday, August 21, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L

Anyone have luck with 9i on RedHat?  I am sure the answer is yes as people
has mentioned trying.
Do they have it documented what is needed to be done to accomplish this?

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Lora, lisa, what ever...
Oracle only supports SUSE 7.1 for Oracle 9i.
 I use RedHat 6.2 with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards.
Works great but not supported. SCO was bought out by RedHat a while back I
believe. ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/01 11:50AM >>>
Sorry everyone, I know you were just discussing this recently.  

What is the most stable combination of Oracle & Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  

Thank you

Lara Croft
Oracle Database Administrator 
Fairfield Resorts, Inc




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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:
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread OraStaff


Come work for this R & D Company in beautiful Coastal Maine that is search
of an ERP Oracle DBA to join it's I.T. staff.
This company is near the ocean, mountains, forrests, lakes, and trails in a
very low cost of living area.
If you love high tech challenges but you're looking for a more
natural environment, this could be the opportunity you've been searching
for. 

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Responsibilities:
Include the installation and administration of Oracle databases
and database products in concert with software engineers and system
administrators.


*Requirements:
- B.S. in C.S. or the equivalent
- At least 2 years of experience as an Oracle DBA on Unix
- ERP experience..Oracle Financials highly desired
- Excellent communication and teamwork skills
- The ability to operate effectively in a fast-paced environment
  are essential
- U.S. citizens or permanent residents only

This position also offers:
* Opportunity to become a key member of the I.T. team
* Base salary up to 80K + excellent benefits
* Excellent relocation package 

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need sponsorship
Email: [EMAIL PROTECTED]
Please use job code: One/Maine//DBA/Page

Note: This is only one of the many opportunities that we have available
across the U.S. 
for candidates with Oracle skills who are U.S. citizens or permanent residents. 
So if this one is not a match for you, we invite you 
to send us your resume- as we quite possibly have the opportunity that you
are seeking.

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law



 



List Server Managed & Maintained by 
BiJTek Solutions   www.bijtek.com
IT Consulting  *  Web Hosting  *  Outsourcing

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

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

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

2001-08-22 Thread Hagedorn, Linda

Title: RE: OT - Vaccines

Paraphrased from http://dailynews.yahoo.com/h/ap/20010821/us/religion_immunizations_1.html

Casper, Wyo.  U.S. District Court Judge William Downes barred the state of Wyoming Dept of Health from holding hearings to determine the level of sincerity about some parents religious convictions in refusing to have their children immunized.  

Wyoming officials had made hepatitis B mandatory for entry into the public school system.  Some parents refused on religious grounds and argued that the administrative hearings held to determine their sincerity about the issue violated their constitutional right to freedom of religion.

The Judge agreed.  
--
So the bottom line is parents can refuse the 'pretend-mandatory' immunizations for their children, and it does have a constitutional underpinning.    

-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 10:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT - Vaccines

Small pox is extinct in the wild.  A few years ago the U.S. and Russia were to destroy their last vials.  Both countries backed off citing  scientific reasons.

I cannot say whether it was the vaccine  which stopped you from getting polio, but I certainly agree that the vaccine is what has made that crippling disease so rare.  That does not mean one should not question some of the vaccine protocols nor the chemicals used a preservatives.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, August 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L

The interesting thing about this thread is the fact that most of the
childhood diseases our children get shots to prevent still exist in most
third-world countries.  The last I heard smallpox has been eliminated from
North America, not the world.  Now, if the shots were doing no good and the
diseases would eventually just disappear it seems to me this would have
already happened in those countries?  I wonder why there always has to be
some conspiracy involved.  My goodness, cloning, bioengineered foods, DNA
evidence, the government and vaccines!?!  What will be next?  I think indoor
plumbing was just a Citywide conspiracy to collect Sewage/Water fees.  We
now know better about a lot of things including the general welfare of kids
that get the vaccines.  Yes, your child could do without them and be just
fine unless they come across some other child who has contracted the
disease.  The reason I didn't have Polio and Smallpox when I was a kid is
because of the vaccinations.  I knew a poor soul that had polio and it's a
horrible disease.

Thank goodness for off-topic Fridays.  It's good to debate :)

ps.  This reflects my opinion, not fact.  Have a heart and take it with a
sense of humor before flaming in public.

--Michael

-Original Message-
Sent: Friday, August 17, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L

sicker? possibly. But the infant mortality rate has dropped.

>From: "Babette Turner-Underwood" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT - Vaccines
>Date: Fri, 17 Aug 2001 05:36:53 -0800
>
>I wonder if there is a link between all of these vaccines
>that are forced upon our children and the increase in
>childhood illnesses, such as asthma and allergies
>and ADHD and ...??
>
>Something has changed. With our new improved health
>care system, I believe on average children are sicker
>than they were 20 or 30 years ago.
>
>- babette
>
>-Original Message-
>Sent: Thursday, August 16, 2001 5:33 PM
>To: Multiple recipients of list ORACLE-L
>
>
>yikes.the immune system is fabulously complexsecond in complexity
>only to the brain itself...and it is still very very much in development
>at early ages...this is why kids -- all kids -- get more colds, etc than
>us older folks...the system is literally "learning" for the first few years
>or more.
>
>Pounding this system with "new" vaccines...before it is developed, or fully
>able
>to defend itself ( vaccines ARE basically hobbled diseases, folks ) is
>really
>scary to me.
>
>Also, remember...you and I may get chicken pox ( i did, and mumps...) but
>we get it by host to host contact...NOT by *intravenous injection*  
>directly
>into the bloodstream where orders of magnitude more of disease vectors are
>introduced into the body than if they had to pass through the skin or
>mucosal linings
>
>just a thought.
>
>-Original Message-
>Sent: Thursday, August 16, 2001 4:45 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Give the kid some baby motrin or baby tylenol prior to the shot.  Works
>wonders.  I've got two who just got a round of vaccinations this week.
>
>Scott Shafer
>San Antonio, TX
>
>
>Kathy Duret wrote:
> >
> > Thanks for the link.   As a new parent of a 4 month old, I am always
>looking for things

RE: linux & Oracle -- best combination

2001-08-22 Thread Molina, Gerardo


Do you mean ORACLE-LINUX-L at [EMAIL PROTECTED] or is there another
Linux-Oracle mailing list?

-Original Message-
Sent: Wednesday, August 22, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


And, above all, they have a very knowledgeable guy helping
people on the Linux-Oracle mailing  list. Michael Hesseltein
is doing a terrific job there!

> -Original Message-
> From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 5:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: linux & Oracle -- best combination
> 
> 
> 
> In a previous job, I was running Red Hat 6.2 and Oracle 
> 8.1.7.  This was
> quite stable.  Keep in mind that we were not supporting 
> hundreds of users.
> 
> I prefer SuSE because of the docs so I was pleased to see 
> them become the
> 'lead' platform for Oracle on Linux.  Still, I have not had a 
> chance to
> test its stability in comparison to Red Hat.  I have a system 
> up, though,
> so we'll see.
> 
> My .005 cents worth...
> 
> 
> 
> __
> Dwayne Cox
> DBA, Development Dept.
> Info Tech, Inc.
> [EMAIL PROTECTED]
> http://www.infotechfl.com
> ___
> The opinions expressed are the author's own unless otherwise stated
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dwayne Cox
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-08-22 Thread Guidry, Chris


Hi Denmark,
Go to:
http://windowsupdate.microsoft.com/

Download and install IE5.5 SP2. Do a custom install to ensure the 
Offline Browsing Pack is selected. I believe it is part of it.


I was just reading some mail from one of the members, Eric Pierce,
who supplied this URL which may be useful:

http://www.ultratech-llc.com/KB/?File=TaskSched.TXT

HTH

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Denmark Weatherburne [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 04:25 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Automating or scheduling backups from OEM on NT 4.0
> 
> Thanks Chris,
> 
> I did a search for *scheduler* on my drives but I found no scheduler that 
> came with IE5.5
> What is the name of the executable and where is it installed?
> If I need to downlaod it, what is the downloadable zip filename?
> 
> Thanks,
> 
> Denmark W.
> 
> 
> >From: "Guidry, Chris" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Automating or scheduling backups from OEM on NT 4.0
> >Date: Wed, 22 Aug 2001 12:40:47 -0800
> >
> >Hi,
> >I suggest you try using the Task Scheduler.
> >
> >I've had problems in the past using AT and/or WINAT.
> >For some reason certain batches would not run but
> >when I tried Task Scheduler everything worked as expected.
> >
> >If you have IE5+ then you should already have it installed.
> >If you have IE4 then you can install it as an add-on.
> >
> >The name of the service is Task Scheduler and you can run
> >it from Administrative Tools and/or My Computer.
> >
> >HTH
> >
> >--
> >Chris J. Guidry  P.Eng.
> >ATCO Electric, Metering Services
> >Phone: (780) 420-4142
> >Fax: (780) 420-3854
> >Email: [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Denmark Weatherburne [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wednesday, August 22, 2001 11:12 AM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  Automating or scheduling backups from OEM on NT 4.0
> > >
> > > Hi DBA's,
> > >
> > > I've recently completed several SQL*Plus scripts and Batch files to do
> 
> >Hot
> > >
> > > backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm
> > > daily.
> > > Currently, I have to double click the batch file icon which calls 
> >SQL*Plus
> > >
> > > and executes the backup script.
> > > I tried unsuccessfully to use NT's AT and WINAT.EXE commands to
> schedule
> > > the
> > > execution of the batch jobs. Nothing ran when the scheduled time came.
> > > Following your advice, I recently downloaded "cygwin" and all the
> tools,
> > > but
> > > I'm currently trying to get cron working.
> > > I was advised that OEM for NT has the capability to automate and 
> >schedule
> > > backups, etc.
> > > I've started to look at RMAN, but I'm not sure if RMAN is the tool
> that 
> >I
> > > need to accomplish my backup/restore automation and scheduling needs.
> > > I'm comfortable at the command line and with scripts, because I've 
> >worked
> > > in
> > > the Solaris environment for a few years, but I know that a lot of
> tools
> > > has
> > > been built into OEM for NT.
> > > I'd like to get feedback from DBA's/SA's regarding what
> implementations
> > > you
> > > have in place to schedule and automate Oracle tasks such as backups, 
> >etc.
> > > I would appreciate your suggestions and recomendations.
> > > Please provide provide procedures and scripts if possible.
> > >
> > > Thanks for your help!
> > >
> > > Denmark Weatherburne
> > > "Knowledge is power, but it is only useful if it is shared!"
> > >
> > >
> > >
> > > _
> > > 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: Denmark Weatherburne
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Guidry, Chris
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >---

Re: OT - Vaccines [kidz 'r hell]

2001-08-22 Thread Eric D. Pierce

relax, it will probably get worse!

when my son was about 18 months old, and we were in barcelona on 
vacation, he stuck his head through a very elaborate decorative 
curved wrought iron stair railing (one of the many architectural 
wonders there: http://aleph.kubos.org/AN/img/barca/vicen_gd.jpg , 
http://aleph.kubos.org/AN/img/barca/p223p10s.jpg , 
http://www.jpmoser.com/images/p-vic3.jpg , 
http://www.jpmoser.com/images/p-torto1.jpg , 
http://www.tc.umn.edu/~rybsk001/Barcelona/quadras.jpg , 
http://www.tc.umn.edu/~rybsk001/Barcelona/discordgaudipc.jpg , 
http://www.tc.umn.edu/~rybsk001/Barcelona/discordhouse.jpg , 
http://www.tc.umn.edu/~rybsk001/Barcelona/chimney.jpg , 
http://www.tc.umn.edu/~rybsk001/Barcelona/guellview.jpg , 
http://www.bryceandpalazzola.com/archtours/Barcelona/b21.GIF , etc: 
http://www.rutamodernisme.com ) in an old school we were visiting, 
and the "bombers" (fire department) had to come with one of those 
"jaws of life" type machines, and cut the railing all up to get head 
out. the stair railing was a very intricate floral design, and he 
stuck his head in the rough equivalent of a "v" shaped racoon trap, 
and couldn't get it out.

during all the chaos and screaming, I was asking my wife what the 
hell the EMTs and fire dept rescue people where saying in catalan. in 
the midst of all the noise, one of the EMTs (a woman) looked up, and 
(in pretty good english), said the following very important 
observation to me: "you must be one of those americans that can't 
speak any other languages very well"!!!

comic relief in hindsight. :)

regards,
ep

> Kathy Duret wrote:

> > ...But how can I explain this to him when he is uncontrollably sobbing

...

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

RE: database upgrade policy?

2001-08-22 Thread Paul Drake


Kevin,

What do you mean?
(running 8.1.7.2.1 on the destructo box, 8.1.7.1.5 on the development box,
W2K Pro)

Paul


 Original Message 
Date: Wed, 22 Aug 2001 14:06:39 -0800
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

I have people here who just want to upgrade for the sake of
upgrading...rrggg..ok.:)
KK

-Original Message-
Sent: Wednesday, August 22, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year because it had
been
desupported.  We got most of the machines upgraded except for the main
production machine.  I wanted to upgrade that last September.  I have
finally gotten permission to tentatively schedule the for next month
(one
year later), just in time for the 8.1.6 desupport notice.  Sigh.

-Original Message-
Sent: Wednesday, August 22, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Lisa,
 You need some work to do
Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
ROR mô¿ôm

>>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
Don't upgrade unless there is a very good reason.

All of these are candidates

1.  current oracle version is unstable
2.  specific bug addressed by an upgrade/patch, as identified by support
3.  need to utilize new feature
4.  desupport date coming up.

If it works, don't fix it!

Don't do it just for fun.  Because it can turn into HELL.

Lisa Koivu
Certifiable Gimp Monkey (and DBA)
Ft. Lauderdale, FL, USA

> -Original Message-
> From: Mark Marsden [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 11:45
> To:   Multiple recipients of list ORACLE-L
> Subject:  database upgrade policy?
>
> Hi Listers
>
> I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> as I get the occasional ORA-600/ORA-7445.
>
> Do you upgrade to the latest subversion as a matter of policy
> (and not test very much) to prevent possible errors
> or only upgrade if you have problems?
>
> Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> functionality, cos Oracle are desupporting (the main reason we upgrade)
> or to improve the CV ;-)  with the possible downside of instability.
>
> Mark.
>
>
> **
> **
> Hyde Housing Association - Email Disclaimer
>
> The information in this email is strictly confidential and may be legally
> privileged.
>
> It is intended solely for the addressee only. Access to this email by
> anyone else is unauthorised.
> If you are not the intended recipient and you have recieved this email in
> error you must take no action
> on its contents, nor must you copy or show them to anyone, or make use of
> the information therein.
> Please reply to the email immediately, or forward to
> [EMAIL PROTECTED], highlighting
> the error and confirming that it has been deleted from your system.
>
> SECURITY WARNING: Please note that this email has been created with
> the knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand
> and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and
> attachments are free
> from any virus, we advise that in keeping with good computing practise the
> recipient should ensure
> that they are actually virus free.
> **
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Marsden
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: database upgrade policy?

2001-08-22 Thread Anderson, Brian


Just for the PLEASURE of using OUI!

> -Original Message-
> From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 6:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: database upgrade policy?
> 
> 
> I have people here who just want to upgrade for the sake of
> upgrading...rrggg..ok.:)
> KK
> 
> -Original Message-
> Sent: Wednesday, August 22, 2001 5:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year 
> because it had been
> desupported.  We got most of the machines upgraded except for the main
> production machine.  I wanted to upgrade that last September.  I have
> finally gotten permission to tentatively schedule the for 
> next month (one
> year later), just in time for the 8.1.6 desupport notice.  Sigh.
> 
> -Original Message-
> Sent: Wednesday, August 22, 2001 3:36 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Lisa,
>  You need some work to do
> Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
> ROR mô¿ôm
> 
> >>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
> Don't upgrade unless there is a very good reason.
> 
> All of these are candidates
> 
> 1.  current oracle version is unstable
> 2.  specific bug addressed by an upgrade/patch, as identified 
> by support
> 3.  need to utilize new feature
> 4.  desupport date coming up.
> 
> If it works, don't fix it!
> 
> Don't do it just for fun.  Because it can turn into HELL.
> 
> Lisa Koivu
> Certifiable Gimp Monkey (and DBA)
> Ft. Lauderdale, FL, USA
> 
> > -Original Message-
> > From:   Mark Marsden [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, August 22, 2001 11:45
> > To: Multiple recipients of list ORACLE-L
> > Subject:database upgrade policy?
> >
> > Hi Listers
> >
> > I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> > as I get the occasional ORA-600/ORA-7445.
> >
> > Do you upgrade to the latest subversion as a matter of policy
> > (and not test very much) to prevent possible errors
> > or only upgrade if you have problems?
> >
> > Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> > functionality, cos Oracle are desupporting (the main reason 
> we upgrade)
> > or to improve the CV ;-)  with the possible downside of instability.
> >
> > Mark.
> >
> >
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
  INET: [EMAIL PROTECTED]

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

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

RE: Automating or scheduling backups from OEM on NT 4.0

2001-08-22 Thread Denmark Weatherburne


Thanks Chris,

I did a search for *scheduler* on my drives but I found no scheduler that 
came with IE5.5
What is the name of the executable and where is it installed?
If I need to downlaod it, what is the downloadable zip filename?

Thanks,

Denmark W.


>From: "Guidry, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Automating or scheduling backups from OEM on NT 4.0
>Date: Wed, 22 Aug 2001 12:40:47 -0800
>
>Hi,
>I suggest you try using the Task Scheduler.
>
>I've had problems in the past using AT and/or WINAT.
>For some reason certain batches would not run but
>when I tried Task Scheduler everything worked as expected.
>
>If you have IE5+ then you should already have it installed.
>If you have IE4 then you can install it as an add-on.
>
>The name of the service is Task Scheduler and you can run
>it from Administrative Tools and/or My Computer.
>
>HTH
>
>--
>Chris J. Guidry  P.Eng.
>ATCO Electric, Metering Services
>Phone: (780) 420-4142
>Fax: (780) 420-3854
>Email: [EMAIL PROTECTED]
>
> > -Original Message-
> > From:   Denmark Weatherburne [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, August 22, 2001 11:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Automating or scheduling backups from OEM on NT 4.0
> >
> > Hi DBA's,
> >
> > I've recently completed several SQL*Plus scripts and Batch files to do 
>Hot
> >
> > backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm
> > daily.
> > Currently, I have to double click the batch file icon which calls 
>SQL*Plus
> >
> > and executes the backup script.
> > I tried unsuccessfully to use NT's AT and WINAT.EXE commands to schedule
> > the
> > execution of the batch jobs. Nothing ran when the scheduled time came.
> > Following your advice, I recently downloaded "cygwin" and all the tools,
> > but
> > I'm currently trying to get cron working.
> > I was advised that OEM for NT has the capability to automate and 
>schedule
> > backups, etc.
> > I've started to look at RMAN, but I'm not sure if RMAN is the tool that 
>I
> > need to accomplish my backup/restore automation and scheduling needs.
> > I'm comfortable at the command line and with scripts, because I've 
>worked
> > in
> > the Solaris environment for a few years, but I know that a lot of tools
> > has
> > been built into OEM for NT.
> > I'd like to get feedback from DBA's/SA's regarding what implementations
> > you
> > have in place to schedule and automate Oracle tasks such as backups, 
>etc.
> > I would appreciate your suggestions and recomendations.
> > Please provide provide procedures and scripts if possible.
> >
> > Thanks for your help!
> >
> > Denmark Weatherburne
> > "Knowledge is power, but it is only useful if it is shared!"
> >
> >
> >
> > _
> > 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: Denmark Weatherburne
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Guidry, 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).


_
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: Denmark Weatherburne
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a li

RE: database upgrade policy?

2001-08-22 Thread Kevin Kostyszyn


I have people here who just want to upgrade for the sake of
upgrading...rrggg..ok.:)
KK

-Original Message-
Sent: Wednesday, August 22, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L


Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year because it had been
desupported.  We got most of the machines upgraded except for the main
production machine.  I wanted to upgrade that last September.  I have
finally gotten permission to tentatively schedule the for next month (one
year later), just in time for the 8.1.6 desupport notice.  Sigh.

-Original Message-
Sent: Wednesday, August 22, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Lisa,
 You need some work to do
Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
ROR mô¿ôm

>>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
Don't upgrade unless there is a very good reason.

All of these are candidates

1.  current oracle version is unstable
2.  specific bug addressed by an upgrade/patch, as identified by support
3.  need to utilize new feature
4.  desupport date coming up.

If it works, don't fix it!

Don't do it just for fun.  Because it can turn into HELL.

Lisa Koivu
Certifiable Gimp Monkey (and DBA)
Ft. Lauderdale, FL, USA

> -Original Message-
> From: Mark Marsden [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 11:45
> To:   Multiple recipients of list ORACLE-L
> Subject:  database upgrade policy?
>
> Hi Listers
>
> I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> as I get the occasional ORA-600/ORA-7445.
>
> Do you upgrade to the latest subversion as a matter of policy
> (and not test very much) to prevent possible errors
> or only upgrade if you have problems?
>
> Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> functionality, cos Oracle are desupporting (the main reason we upgrade)
> or to improve the CV ;-)  with the possible downside of instability.
>
> Mark.
>
>
> **
> **
> Hyde Housing Association - Email Disclaimer
>
> The information in this email is strictly confidential and may be legally
> privileged.
>
> It is intended solely for the addressee only. Access to this email by
> anyone else is unauthorised.
> If you are not the intended recipient and you have recieved this email in
> error you must take no action
> on its contents, nor must you copy or show them to anyone, or make use of
> the information therein.
> Please reply to the email immediately, or forward to
> [EMAIL PROTECTED], highlighting
> the error and confirming that it has been deleted from your system.
>
> SECURITY WARNING: Please note that this email has been created with
> the knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand
> and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and
> attachments are free
> from any virus, we advise that in keeping with good computing practise the
> recipient should ensure
> that they are actually virus free.
> **
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Marsden
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

To REMOVE yourself fr

RE: User access within/outside of app

2001-08-22 Thread Larry Hahn


Tony,

8.1.7 EE on Sun Solaris

Larry

--- "Aponte, Tony" <[EMAIL PROTECTED]> wrote:
> What version are you working with?
> 
> -Original Message-
> Sent: Tuesday, August 21, 2001 11:21 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> List,
> 
> We have purchased a system where users login through
> an ODBC connection using a generic Oracle userid.
> This
> userid has full rights to do insert, update, delete,
> select on any table in the schema. The app asks for
> another username and password which checks the
> application security table, which limits what areas
> of
> the apps they can access. 
> 
> Although this may work fine for the app, the users
> also have the ability to use Access and other ODBC
> compliant programs to look at the data. When doing
> so,
> they use the same ODBC DSN and, what do you know,
> they
> have capabilities beyond their wildest imagination. 
> 
> This is obviously not a situation I want to
> implement.
> I am looking for a way to allow a user into the app
> to
> do their normal work, but only allow read access for
> anything outside the app. 
> 
> Any suggestions or ideas would be more than welcome.
> 
> Thanks,
> 
> Larry Hahn
> Journal Sentinel, Inc. 
> 
> __
> 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: Larry Hahn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


=
Larry Hahn
DBA
Journal Sentinel,Inc

__
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: Larry Hahn
  INET: [EMAIL PROTECTED]

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

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

listener problem

2001-08-22 Thread Harvinder Singh


Hi,

I am doing a fresh install of oracle 8.1.6.0.0 on win2k and it hangs at the
Net 8 configuration assistant at this
step :

Done parsing command line arguments.Net8 Configuration:Profile configuration
complete.Net8 Listener Startup:
Running Listener Control: 
  D:\Oracle\Ora81\bin\lsnrctl start LISTENER

when i try to kill this process and try to see the status as:

D:\Oracle\Ora81\BIN>lsnrctl

LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 22-AUG-2001
17:12:
00

(c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01103: Protocol specific component of the address is incorrectly
specified
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory

and listener.ora looks like:

# LISTENER.ORA Network Configuration File:
D:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_machine)(PORT = 1521))
  )
)
(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
  (ADDRESS = (PROTOCOL = TCP)(HOST = my_machine)(PORT = 2481))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = D:\Oracle\Ora81)
  (PROGRAM = extproc)
)
  )

I am not able to start , stop or create listener again...
what might be the problem??

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

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

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

RE: linux & Oracle -- best combination

2001-08-22 Thread Gogala, Mladen


And, above all, they have a very knowledgeable guy helping
people on the Linux-Oracle mailing  list. Michael Hesseltein
is doing a terrific job there!

> -Original Message-
> From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 5:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: linux & Oracle -- best combination
> 
> 
> 
> In a previous job, I was running Red Hat 6.2 and Oracle 
> 8.1.7.  This was
> quite stable.  Keep in mind that we were not supporting 
> hundreds of users.
> 
> I prefer SuSE because of the docs so I was pleased to see 
> them become the
> 'lead' platform for Oracle on Linux.  Still, I have not had a 
> chance to
> test its stability in comparison to Red Hat.  I have a system 
> up, though,
> so we'll see.
> 
> My .005 cents worth...
> 
> 
> 
> __
> Dwayne Cox
> DBA, Development Dept.
> Info Tech, Inc.
> [EMAIL PROTECTED]
> http://www.infotechfl.com
> ___
> The opinions expressed are the author's own unless otherwise stated
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dwayne Cox
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

Re: HDD crashed

2001-08-22 Thread Scott Shafer

You DO have a backup, right?  At least an export?

--Scott

Jan Pruner wrote:
> 
> Hi,
> my hdd (c:) on server running NT4.0 has been corrupted.
> Is it possible to move Oracle db files on other server running linux(!!!),
> create instance and mount -> open all db files (not only system)?.
> 
> Thanks
> 
> Jan Pruner

_
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: Scott Shafer
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread Dwayne Cox



In a previous job, I was running Red Hat 6.2 and Oracle 8.1.7.  This was
quite stable.  Keep in mind that we were not supporting hundreds of users.

I prefer SuSE because of the docs so I was pleased to see them become the
'lead' platform for Oracle on Linux.  Still, I have not had a chance to
test its stability in comparison to Red Hat.  I have a system up, though,
so we'll see.

My .005 cents worth...



__
Dwayne Cox
DBA, Development Dept.
Info Tech, Inc.
[EMAIL PROTECTED]
http://www.infotechfl.com
___
The opinions expressed are the author's own unless otherwise stated
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread Nick Wagner

Title: RE: HELP - How can I limit what program users use to connect?





One thing you can try  


TOAD includes a module name...  so select from v$session where module = 'T.O.A.D.' 


It will give you a list of users... and you could probably create a DBMS_JOB to go around and kill any user with module 'T.O.A.D'  who did not have DBA priv's.   It would be quite intensive to run on your machines... but I think it would get the job done.  I'm not sure what other apps you have... maybe they also have a module associated with them. 

Nick


-Original Message-
From: Shevtsov, Eduard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: HELP - How can I limit what program users use to connect?



Hi Ken,


AFAIR you can limit connections via SQL*+  not sure though
it'll work for TOAD and other 3d party products.
Try to find pubbl.sql(?) (sorry don't remember the exact name).
It's one of the standart scripts you're supposed to run while
db creation. It creates a couple of profile tables and it's available in 7.x 8.x


HTH,
Ed




> List,
>   Does anyone know of a method by which I can prohibit users from connecting 
> into my Oracle 8.0.6.0.0 database by any product other than the 
> application's executable program?  (i.e. - I don't want anyone connecting 
> through TOAD, etc.)  But, I do want to allow anyone with DBA role to be able 
> to connect through TOAD.
> 
> Thank you,
> -Ken Lewin
> 


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


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

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

Reply !Locking issue

2001-08-22 Thread Rakesh Gupta


I had similar problem with my database and that was due to MTS. Disabling MTS resolved 
the locking issue. I think this has been resolved in the newer versions of oracle8.




Thanks
Rakesh

We have an application that, litterally overnight, developed locking issues.

Our users start working just fine.   Then, right now cause unknown, our inserts start 
being blocked.   Usually there are so many so fast that we do not even know what is 
causing the original lock.

The tables the users are being blocked from have multiple triggers and the tables that 
these triggers point to ofen have triggers of their own.


So, the scenario is 
1.  Web Application pointing to an Oracle 8.0.5 database.
2. Things start out just fine.
3. At a variable time later (i.e.  not the same time of day, not the same cumulated 
time since startup, etc.) locks start to appear against our main table.  The users 
getting the locks are trying to insert a record.
4. Locks cascade until the only recourse is to restart the database.

We are having trouble tracing the locks back to their origin.  
There has got to be 1 thing that is causing the start of this cascade.

If anyone has any insights on how to find this one cause ...  I would appreciate 
hearing them.

And , if you happen to have any scripts that would help me trace the locks thru the 
database I would appreciate them also.

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

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

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

2001-08-22 Thread Guidry, Chris


Hi,
I suggest you try using the Task Scheduler.

I've had problems in the past using AT and/or WINAT.
For some reason certain batches would not run but
when I tried Task Scheduler everything worked as expected.

If you have IE5+ then you should already have it installed.
If you have IE4 then you can install it as an add-on.

The name of the service is Task Scheduler and you can run
it from Administrative Tools and/or My Computer.

HTH

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Denmark Weatherburne [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 11:12 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Automating or scheduling backups from OEM on NT 4.0
> 
> Hi DBA's,
> 
> I've recently completed several SQL*Plus scripts and Batch files to do Hot
> 
> backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm
> daily.
> Currently, I have to double click the batch file icon which calls SQL*Plus
> 
> and executes the backup script.
> I tried unsuccessfully to use NT's AT and WINAT.EXE commands to schedule
> the 
> execution of the batch jobs. Nothing ran when the scheduled time came.
> Following your advice, I recently downloaded "cygwin" and all the tools,
> but 
> I'm currently trying to get cron working.
> I was advised that OEM for NT has the capability to automate and schedule 
> backups, etc.
> I've started to look at RMAN, but I'm not sure if RMAN is the tool that I 
> need to accomplish my backup/restore automation and scheduling needs.
> I'm comfortable at the command line and with scripts, because I've worked
> in 
> the Solaris environment for a few years, but I know that a lot of tools
> has 
> been built into OEM for NT.
> I'd like to get feedback from DBA's/SA's regarding what implementations
> you 
> have in place to schedule and automate Oracle tasks such as backups, etc.
> I would appreciate your suggestions and recomendations.
> Please provide provide procedures and scripts if possible.
> 
> Thanks for your help!
> 
> Denmark Weatherburne
> "Knowledge is power, but it is only useful if it is shared!"
> 
> 
> 
> _
> 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: Denmark Weatherburne
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Guidry, 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).

RE: database upgrade policy?

2001-08-22 Thread Miller, Jay


Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year because it had been
desupported.  We got most of the machines upgraded except for the main
production machine.  I wanted to upgrade that last September.  I have
finally gotten permission to tentatively schedule the for next month (one
year later), just in time for the 8.1.6 desupport notice.  Sigh.

-Original Message-
Sent: Wednesday, August 22, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L


Lisa,
 You need some work to do
Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
ROR mô¿ôm

>>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
Don't upgrade unless there is a very good reason.  

All of these are candidates

1.  current oracle version is unstable
2.  specific bug addressed by an upgrade/patch, as identified by support
3.  need to utilize new feature
4.  desupport date coming up.

If it works, don't fix it!

Don't do it just for fun.  Because it can turn into HELL.  

Lisa Koivu
Certifiable Gimp Monkey (and DBA)
Ft. Lauderdale, FL, USA

> -Original Message-
> From: Mark Marsden [SMTP:[EMAIL PROTECTED]] 
> Sent: Wednesday, August 22, 2001 11:45
> To:   Multiple recipients of list ORACLE-L
> Subject:  database upgrade policy?
> 
> Hi Listers
> 
> I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> as I get the occasional ORA-600/ORA-7445.
> 
> Do you upgrade to the latest subversion as a matter of policy
> (and not test very much) to prevent possible errors 
> or only upgrade if you have problems?
> 
> Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> functionality, cos Oracle are desupporting (the main reason we upgrade)
> or to improve the CV ;-)  with the possible downside of instability.
> 
> Mark.
> 
> 
> **
> **
> Hyde Housing Association - Email Disclaimer
> 
> The information in this email is strictly confidential and may be legally
> privileged.
> 
> It is intended solely for the addressee only. Access to this email by
> anyone else is unauthorised. 
> If you are not the intended recipient and you have recieved this email in
> error you must take no action
> on its contents, nor must you copy or show them to anyone, or make use of
> the information therein.
> Please reply to the email immediately, or forward to
> [EMAIL PROTECTED], highlighting
> the error and confirming that it has been deleted from your system.
> 
> SECURITY WARNING: Please note that this email has been created with
> the knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand
> and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and
> attachments are free
> from any virus, we advise that in keeping with good computing practise the
> recipient should ensure
> that they are actually virus free.
> **
> **
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Mark Marsden
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of ma

Re: HELP - How can I limit what program users use to connect?

2001-08-22 Thread Shevtsov, Eduard


Hi Ken,

AFAIR you can limit connections via SQL*+  not sure though
it'll work for TOAD and other 3d party products.
Try to find pubbl.sql(?) (sorry don't remember the exact name).
It's one of the standart scripts you're supposed to run while
db creation. It creates a couple of profile tables and it's available in 7.x 8.x

HTH,
Ed



> List,
>   Does anyone know of a method by which I can prohibit users from connecting 
> into my Oracle 8.0.6.0.0 database by any product other than the 
> application's executable program?  (i.e. - I don't want anyone connecting 
> through TOAD, etc.)  But, I do want to allow anyone with DBA role to be able 
> to connect through TOAD.
> 
> Thank you,
> -Ken Lewin
> 

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

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

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

2001-08-22 Thread Eric D. Pierce


lk-
sorry no specifics, but here are some pointers you might find useful:

   http://www.ultratech-llc.com/KB/?File=TaskSched.TXT
-
   http://www.ultratech-llc.com/KB/Scripts/?File=!Contents.TXT
-
   http://www.ultratech-llc.com/KB/?File=Scripting.TXT
   
Also, general info:

   http://www.microsoft.com/windows2000/techinfo/reskit

regards,
ep

> [via ORACLE-L Digest -- Volume 2001, Number 234]
> "Koivu, Lisa" <[EMAIL PROTECTED]> on 08/19/2001 05:15:21 PM
> 
> ...I've been digging around for scripting documentation on w2k.  Microsoft's
> website talks about Jscript and vbscript and xml - none of which are my
> strengths and all look like they are much more complicated than I need.  I
> need to find a scripting language that will allow me to do simple things =
> on w2k - fire export, fire backup, send me email/pages, etc.  

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

RE: database upgrade policy?

2001-08-22 Thread Ron Rogers


Lisa,
 You need some work to do
Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
ROR mô¿ôm

>>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
Don't upgrade unless there is a very good reason.  

All of these are candidates

1.  current oracle version is unstable
2.  specific bug addressed by an upgrade/patch, as identified by support
3.  need to utilize new feature
4.  desupport date coming up.

If it works, don't fix it!

Don't do it just for fun.  Because it can turn into HELL.  

Lisa Koivu
Certifiable Gimp Monkey (and DBA)
Ft. Lauderdale, FL, USA

> -Original Message-
> From: Mark Marsden [SMTP:[EMAIL PROTECTED]] 
> Sent: Wednesday, August 22, 2001 11:45
> To:   Multiple recipients of list ORACLE-L
> Subject:  database upgrade policy?
> 
> Hi Listers
> 
> I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> as I get the occasional ORA-600/ORA-7445.
> 
> Do you upgrade to the latest subversion as a matter of policy
> (and not test very much) to prevent possible errors 
> or only upgrade if you have problems?
> 
> Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> functionality, cos Oracle are desupporting (the main reason we upgrade)
> or to improve the CV ;-)  with the possible downside of instability.
> 
> Mark.
> 
> 
> **
> **
> Hyde Housing Association - Email Disclaimer
> 
> The information in this email is strictly confidential and may be legally
> privileged.
> 
> It is intended solely for the addressee only. Access to this email by
> anyone else is unauthorised. 
> If you are not the intended recipient and you have recieved this email in
> error you must take no action
> on its contents, nor must you copy or show them to anyone, or make use of
> the information therein.
> Please reply to the email immediately, or forward to
> [EMAIL PROTECTED], highlighting
> the error and confirming that it has been deleted from your system.
> 
> SECURITY WARNING: Please note that this email has been created with
> the knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand
> and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and
> attachments are free
> from any virus, we advise that in keeping with good computing practise the
> recipient should ensure
> that they are actually virus free.
> **
> **
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Mark Marsden
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Locking Issue




check out $ORACLE_HOME/rdbms/admin/utlockt.sql
 
joe
>>> [EMAIL PROTECTED] 08/22/01 02:46PM 
>>>
Back to the experts 

 
 
We have an 
application that, litterally overnight, developed locking 
issues.
 
Our users 
start working just fine.   Then, right now cause unknown, our inserts 
start being blocked.   Usually there are so many so fast that we do 
not even know what is causing the original lock.
 
The tables 
the users are being blocked from have multiple triggers and the tables that 
these triggers point to ofen have triggers of their own.
 
 
So, the 
scenario is 
1.  Web 
Application pointing to an Oracle 8.0.5 database.
2. Things 
start out just fine.
3. At a 
variable time later (i.e.  not the same time of day, not the same cumulated 
time since startup, etc.) locks start to appear against our main table.  
The users getting the locks are trying to insert a record.
4. Locks 
cascade until the only recourse is to restart the database.
 
We are having 
trouble tracing the locks back to their origin.  
There has got 
to be 1 thing that is causing the start of this cascade.
 
If anyone has 
any insights on how to find this one cause ...  I would appreciate hearing 
them.
 
And , if you 
happen to have any scripts that would help me trace the locks thru the database 
I would appreciate them also.
 
Thanks 

 
Kevin

Locking Issue

2001-08-22 Thread Kevin Lange




Back to the experts 

 
 
We have an 
application that, litterally overnight, developed locking 
issues.
 
Our users 
start working just fine.   Then, right now cause unknown, our inserts 
start being blocked.   Usually there are so many so fast that we do 
not even know what is causing the original lock.
 
The tables 
the users are being blocked from have multiple triggers and the tables that 
these triggers point to ofen have triggers of their own.
 
 
So, the 
scenario is 
1.  Web 
Application pointing to an Oracle 8.0.5 database.
2. Things 
start out just fine.
3. At a 
variable time later (i.e.  not the same time of day, not the same cumulated 
time since startup, etc.) locks start to appear against our main table.  
The users getting the locks are trying to insert a record.
4. Locks 
cascade until the only recourse is to restart the database.
 
We are having 
trouble tracing the locks back to their origin.  
There has got 
to be 1 thing that is causing the start of this cascade.
 
If anyone has 
any insights on how to find this one cause ...  I would appreciate hearing 
them.
 
And , if you 
happen to have any scripts that would help me trace the locks thru the database 
I would appreciate them also.
 
Thanks 

 
Kevin

Re: HELP - How can I limit what program users use to connect?

2001-08-22 Thread Mike J Kurth



You can use a password protected role which is only enabled
in the executable using a stored package that executes
dbms_session.set_role.

The package checks which program name invoked it be querying
v$session.program.

If the role is not enabled, users not granted the role do not have access
to the database objects.

This is described in Oracle Security book in chapter 9.


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

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

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

data modeling processes

2001-08-22 Thread lhoska


Hi,
I am looking for some examples of DFD(data flow diagram), BPM(business
process module), and SOW(statement of work); some web-pages with examples
would be great.  If someone can point those I would appreciate it.
Thanks.

Lyuda Hoska

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

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

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

RE: Delete Alertlog on NT

2001-08-22 Thread Cale, Rick T (Richard)


No you can delete it anytime and Oracle will recreate it.

Rick

-Original Message-
Sent: Wednesday, August 22, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


Is there any problem deleting the alert log on NT while the instance is up
and running?  V7.3.4 - 8.1.6

Ron Smith
-- 
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: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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




a a glutton for punishment.  Dev, sure why not, just dont let the 
developers get to attached to the new features, prod?, i wouldnt update any prod 
database(unless forced to by oracle corp) until 9.1 at earliest, yes there are 
some kewl things, but heck the latest 8.1.7 patchset has 22 pages of "bug 
fixes", i just wouldnt trust the x.0 version with my prod database yet.
 
joe
 
Who has lived thru 6.0, 7.0, 8.0 versions of the database :)
 
>>> [EMAIL PROTECTED] 08/22/01 01:11PM 
>>>We were running 8.1.6.0.0 and just recently encountered the 
ORA-7445 errors,which caused core dumps and invalidated the referential 
integrity of ourdatabase.  Oracle recommended the 8.1.6.3 
patchset.  We decided to skip thatand go for 8.1.7 but for some reason 
Oracle mailed us the 9i CDs.  I guessthey are pushing it on everyone 
now.  Anyway, we are in the process ofupgrading our test databases to 
9i (using Sun SPARC Solaris 8).  If all iswell we will upgrade 
production to 9i.David WagonerOracle 
DBA-Original Message-Sent: Wednesday, August 22, 
2001 11:45 AMTo: Multiple recipients of list ORACLE-LHi 
ListersI'm on 8.1.6.0.0 and wondering about upgrading to 
8.1.6.3.1(?)as I get the occasional ORA-600/ORA-7445.Do you upgrade 
to the latest subversion as a matter of policy(and not test very much) to 
prevent possible errorsor only upgrade if you have problems?Do you 
upgrade to major versions (7 to 8.0 to 8.1) for increasedfunctionality, cos 
Oracle are desupporting (the main reason we upgrade)or to improve the CV 
;-)  with the possible downside of 
instability.Mark.Hyde 
Housing Association - Email DisclaimerThe information in this email is 
strictly confidential and may be legallyprivileged.It is intended 
solely for the addressee only. Access to this email by anyoneelse is 
unauthorised.If you are not the intended recipient and you have recieved 
this email inerror you must take no actionon its contents, nor must you 
copy or show them to anyone, or make use ofthe information 
therein.Please reply to the email immediately, or forward 
to[EMAIL PROTECTED], highlightingthe error and confirming that 
it has been deleted from your system.SECURITY 
WARNING: Please note that this email has been created 
with theknowledge that the Internetis not a 100% secure communications 
medium. We advise that you understandand observethis lack of security 
when e-mailing us.VIRUSES: Although we have taken 
steps to ensure that this email andattachments are freefrom any virus, 
we advise that in keeping with good computing practise therecipient should 
ensurethat they are actually virus 
free.--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Mark 
Marsden  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 the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
David Wagoner  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 the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: HELP - How can I limit what program users use to connect?

2001-08-22 Thread Igor Neyman


I don't think you can do it in 8.0.6.
Starting with 8.1.5 you could use db logon triggers.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 12:16 PM


> List,
>   Does anyone know of a method by which I can prohibit users from
connecting
> into my Oracle 8.0.6.0.0 database by any product other than the
> application's executable program?  (i.e. - I don't want anyone connecting
> through TOAD, etc.)  But, I do want to allow anyone with DBA role to be
able
> to connect through TOAD.
>
> Thank you,
> -Ken Lewin
>
> _
> 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: Fred Smith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Igor Neyman
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread Igor Neyman


You can not move db files between different OSs.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 12:51 PM


> Hi,
> my hdd (c:) on server running NT4.0 has been corrupted.
> Is it possible to move Oracle db files on other server running linux(!!!),
> create instance and mount -> open all db files (not only system)?.
>
>
> Thanks
>
> Jan Pruner
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jan Pruner
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Igor Neyman
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread dgoulet


Jan,

Only if you have a full export of the database.  Moving just the files to Linux
will not work since NT and Linux use different ways of writting to disk.

Dick Goulet

Reply Separator
Author: Jan Pruner <[EMAIL PROTECTED]>
Date:   8/22/2001 8:51 AM

Hi,
my hdd (c:) on server running NT4.0 has been corrupted.  
Is it possible to move Oracle db files on other server running linux(!!!), 
create instance and mount -> open all db files (not only system)?.


Thanks

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

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

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

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

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

Re: A Trigger question

2001-08-22 Thread Jared . Still



Tsk, tsk Andrey, this doesn't even require RTFM.  :)

create table a;
( insert your columns here)
create table b;
( insert your columns here)
create trigger a_insert_b;
( your trigger code here )

alter trigger a_insert_b disable.

insert into a(columns) values(your values).

And, the docs are online in several places.

www.oradoc.com
otn.oracle.com

Jared




   

Andrey Bronfin 


esoft.com>  cc:

Sent by:Subject: A Trigger question

[EMAIL PROTECTED]   

   

   

08/22/01 08:56 AM  

Please respond to  

ORACLE-L   

   

   





Dear gurus !
sorry for this RTFMable question , just don't have the docs in front of me
here .
Assume i have a trigger my_trig that performs an insert into tableB after
an
insert into tableA .
The question is : what happens if the trigger gets broken (either disabled
,
invalid or unable to do what it should do (for example if the tableB has
reached maxextents) ) ?
Does the user that inserts into tableA receive an ORA- error ?
Is there a way to let the user insert into tableA , and capture the inserts
into tableB that the trigger should perform , and do those inserts manually
later ?
Thanks a lot.
Andrey.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Delete Alertlog on NT

2001-08-22 Thread Smith, Ron L.


Is there any problem deleting the alert log on NT while the instance is up
and running?  V7.3.4 - 8.1.6

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

RE: User access within/outside of app

2001-08-22 Thread Aponte, Tony

Title: RE: User access within/outside of app






What version are you working with?


-Original Message-

From: Larry Hahn [mailto:[EMAIL PROTECTED]]

Sent: Tuesday, August 21, 2001 11:21 AM

To: Multiple recipients of list ORACLE-L

Subject: User access within/outside of app



List,


We have purchased a system where users login through

an ODBC connection using a generic Oracle userid. This

userid has full rights to do insert, update, delete,

select on any table in the schema. The app asks for

another username and password which checks the

application security table, which limits what areas of

the apps they can access. 


Although this may work fine for the app, the users

also have the ability to use Access and other ODBC

compliant programs to look at the data. When doing so,

they use the same ODBC DSN and, what do you know, they

have capabilities beyond their wildest imagination. 


This is obviously not a situation I want to implement.

I am looking for a way to allow a user into the app to

do their normal work, but only allow read access for

anything outside the app. 


Any suggestions or ideas would be more than welcome.


Thanks,


Larry Hahn

Journal Sentinel, Inc. 


__

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: Larry Hahn

  INET: [EMAIL PROTECTED]


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

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(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: database upgrade policy?

2001-08-22 Thread David Wagoner


We were running 8.1.6.0.0 and just recently encountered the ORA-7445 errors,
which caused core dumps and invalidated the referential integrity of our
database.  Oracle recommended the 8.1.6.3 patchset.  We decided to skip that
and go for 8.1.7 but for some reason Oracle mailed us the 9i CDs.  I guess
they are pushing it on everyone now.  Anyway, we are in the process of
upgrading our test databases to 9i (using Sun SPARC Solaris 8).  If all is
well we will upgrade production to 9i.


David Wagoner
Oracle DBA



-Original Message-
Sent: Wednesday, August 22, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L

Hi Listers

I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
as I get the occasional ORA-600/ORA-7445.

Do you upgrade to the latest subversion as a matter of policy
(and not test very much) to prevent possible errors
or only upgrade if you have problems?

Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
functionality, cos Oracle are desupporting (the main reason we upgrade)
or to improve the CV ;-)  with the possible downside of instability.

Mark.




Hyde Housing Association - Email Disclaimer

The information in this email is strictly confidential and may be legally
privileged.

It is intended solely for the addressee only. Access to this email by anyone
else is unauthorised.
If you are not the intended recipient and you have recieved this email in
error you must take no action
on its contents, nor must you copy or show them to anyone, or make use of
the information therein.
Please reply to the email immediately, or forward to
[EMAIL PROTECTED], highlighting
the error and confirming that it has been deleted from your system.

SECURITY WARNING: Please note that this email has been created with the
knowledge that the Internet
is not a 100% secure communications medium. We advise that you understand
and observe
this lack of security when e-mailing us.
VIRUSES: Although we have taken steps to ensure that this email and
attachments are free
from any virus, we advise that in keeping with good computing practise the
recipient should ensure
that they are actually virus free.


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

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

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

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

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

2001-08-22 Thread Vikas Kawatra


sorry for the incorrect "subject"! See below :

-Original Message-
Sent: Wednesday, August 22, 2001 9:08 AM
To: '[EMAIL PROTECTED]'


We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use the Index .However ,if we re-write it as below(see 2nd query) - the
index is used :but the query returns incorrect results .Can you suggest any
changes to the original query? 

note :
 1)we have a index on cmm_id,cust_id,friendly_session_id,creation_date
 2)We want to return rows from the table even if all columns in where clause
are NULL 

Thanks 

vikas


SELECT friendly_session_id,
  cmm_id,
  cust_id,
  hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE ( CMM_ID = '101' or  cmm_id IS NULL )
 AND ( CUST_ID =101 or cust_id IS NULL )
 AND ( FRIENDLY_SESSION_ID = 100 or friendly_session_id IS NULL )
 AND (CREATION_DATE is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');



SELECT friendly_session_id,
  cmm_id,
  cust_id,
  hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE cmm_id = nvl(cmm_id,0)
 AND cust_id = nvl(cust_id,0)
 AND friendly_session_id =nvl(friendly_session_id ,0)
 AND (creation_date is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');
-- 
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).

Automating or scheduling backups from OEM on NT 4.0

2001-08-22 Thread Denmark Weatherburne


Hi DBA's,

I've recently completed several SQL*Plus scripts and Batch files to do Hot 
backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm daily.
Currently, I have to double click the batch file icon which calls SQL*Plus 
and executes the backup script.
I tried unsuccessfully to use NT's AT and WINAT.EXE commands to schedule the 
execution of the batch jobs. Nothing ran when the scheduled time came.
Following your advice, I recently downloaded "cygwin" and all the tools, but 
I'm currently trying to get cron working.
I was advised that OEM for NT has the capability to automate and schedule 
backups, etc.
I've started to look at RMAN, but I'm not sure if RMAN is the tool that I 
need to accomplish my backup/restore automation and scheduling needs.
I'm comfortable at the command line and with scripts, because I've worked in 
the Solaris environment for a few years, but I know that a lot of tools has 
been built into OEM for NT.
I'd like to get feedback from DBA's/SA's regarding what implementations you 
have in place to schedule and automate Oracle tasks such as backups, etc.
I would appreciate your suggestions and recomendations.
Please provide provide procedures and scripts if possible.

Thanks for your help!

Denmark Weatherburne
"Knowledge is power, but it is only useful if it is shared!"



_
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: Denmark Weatherburne
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread Vikas Kawatra


We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use the Index .However ,if we re-write it as below(see 2nd query) - the
index is used :but the query returns incorrect results .Can you suggest any
changes to the original query? 

note :
 1)we have a index on cmm_id,cust_id,friendly_session_id,creation_date
 2)We want to return rows from the table even if all columns in where clause
are NULL 

Thanks 

vikas


SELECT friendly_session_id,
  cmm_id,
  cust_id,
  hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE ( CMM_ID = '101' or  cmm_id IS NULL )
 AND ( CUST_ID =101 or cust_id IS NULL )
 AND ( FRIENDLY_SESSION_ID = 100 or friendly_session_id IS NULL )
 AND (CREATION_DATE is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');



SELECT friendly_session_id,
  cmm_id,
  cust_id,
  hold_amount,
  virtual_balance_amount,
  creation_date,
  session_id
 FROM sals_session
 WHERE cmm_id = nvl(cmm_id,0)
 AND cust_id = nvl(cust_id,0)
 AND friendly_session_id =nvl(friendly_session_id ,0)
 AND (creation_date is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');
-- 
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).

Re: A Trigger question (LENGTHY!)

2001-08-22 Thread Brian McGraw


Yes.  I was curious, so I did a little test:

Create 3 tables.  Note the different datatypes.

  SQL> create table dbm_1
2  (a varchar2(5) not null);

  Table created.

  SQL> create table dbm_2
2  (a number not null);

  Table created.

  SQL> create table dbm_3
2  (a varchar2(5) not null);

  Table created.

Now create a trigger to populate dbm_2 with the values from dbm_1.
Note that the trigger will fail if the datatypes mismatch:

  SQL> create or replace trigger dbm_1_ariu
2  after insert or update
3  on dbm_1
4  for each row
5  begin
6insert into dbm_2(a) values (:NEW.a);
7  end;
8  create trigger dbm_1_ariu
9  after insert or update
   10  on dbm_1
   11  for each row
   12  begin
   13insert into dbm_2(a) values (:NEW.a);
   14  exception
   15when others then
   16  raise;
   17  end;
   18  /

  Trigger created.

Test the trigger:

  SQL> insert into dbm_1 values (1);

  1 row created.

  SQL> select count(*) from dbm_1;

COUNT(*)
  --
   1

  SQL> select count(*) from dbm_2;

COUNT(*)
  --
   1

  SQL> insert into dbm_1 values ('A');
  insert into dbm_1 values ('A')
  *
  ERROR at line 1:
  ORA-01722: invalid number
  ORA-06512: at "DBM.DBM_1_ARIU", line 5
  ORA-04088: error during execution of trigger 'DBM.DBM_1_ARIU'


  SQL> rollback;

  Rollback complete.

Now, modify the trigger to insert values into dbm_3 if the insert fails.

  SQL> create or replace trigger dbm_1_ariu
2  after insert or update
3  on dbm_1
4  for each row
5  begin
6insert into dbm_2(a) values (:NEW.a);
7  exception
8when others then
9  insert into dbm_3(a) values (:NEW.a);
   10  end;
   11
   12  /

  Trigger created.

  SQL> insert into
2
  SQL> insert into dbm_1(a) values (1);

  1 row created.

  SQL> select count(*) from dbm_1;

COUNT(*)
  --
   1

  SQL> select count(*) from dbm_2;

COUNT(*)
  --
   1

  SQL> select count(*) from dbm_3;

COUNT(*)
  --
   0

  SQL> insert into dbm_1(a) values ('Brian');

  1 row created.

  SQL> select count(*) from dbm_1;

COUNT(*)
  --
   2

  SQL> select count(*) from dbm_2;

COUNT(*)
  --
   1

  SQL> select count(*) from dbm_3;

COUNT(*)
  --
   1


Notice that the trigger handled the exception perfectly.  Of
course, you'd want to code the exception more accurately, but
I think this example proves that it is possible.

Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


Andrey Bronfin wrote:

> Dear gurus !
> sorry for this RTFMable question , just don't have the docs in front of me
> here .
> Assume i have a trigger my_trig that performs an insert into tableB after an
> insert into tableA .
> The question is : what happens if the trigger gets broken (either disabled ,
> invalid or unable to do what it should do (for example if the tableB has
> reached maxextents) ) ?
> Does the user that inserts into tableA receive an ORA- error ?
> Is there a way to let the user insert into tableA , and capture the inserts
> into tableB that the trigger should perform , and do those inserts manually
> later ?
> Thanks a lot.
> Andrey.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrey Bronfin
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Drill-thru question

2001-08-22 Thread Bala, Prakash


Hi,

I am a newbie to this OLAP area. 

I have this table (company_dimension) where every company has a parent,
which in turn can be a child to another parent and so on. It is about 10
levels deep.

TEST@D0MARS> desc company_dimension
 NameNull?Type
 --- 

 COMPANY_CODENOT NULL VARCHAR2(50)
---> primary key
 COMPANY_DESC
VARCHAR2(100)
 PARENT_COMPANY_CODE  VARCHAR2(50)
---> foreign key pointing to company_code


The following table maintains the mobile phone numbers for every company.

TEST@D0MARS> desc DLY_TRANSACTION_DETAIL
 NameNull?Type
 --- 

 ACTIVITY_DATEDATE
 COMPANY_CODE  VARCHAR2(10)
---> foreign key to the company_dimension table
 MOBILE_NUMBER  NUMBER(10)

The requirement is to get all the phone numbers for a given company and its
children for a given day. Since I cannot join these 2 tables using the
'connect by' clause, how can I accomplish it, without using a sub-query?
(actually 2 other dimensions play a role in the above table and I have
simplified the structure)

Created a dimension on the company_dimension table and used the
dbms_olap.validate_dimension procedure to validate it. Everything looks
good, but none of the manuals explains how to use the dimension in a query.

This is Oracle 8.1.7 on Sun Solaris.


Thanks in advance.

Prakash

 application/ms-tnef

HDD crashed

2001-08-22 Thread Jan Pruner


Hi,
my hdd (c:) on server running NT4.0 has been corrupted.  
Is it possible to move Oracle db files on other server running linux(!!!), 
create instance and mount -> open all db files (not only system)?.


Thanks

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

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

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




granted $60 is not much but its A LOT more than free :)
 
joe
>>> [EMAIL PROTECTED] 08/22/01 11:56AM 
>>>Joe,It's cheap.  $60-70 for the pro 
version.Even though I've been a long time RH user, I prefer 
SuSEsimply for the documentation and admin utils.JaredOn 
Wednesday 22 August 2001 04:50, Joe Testa wrote:> I've not really checked 
out Suse, you have to buy it versus being able> to get RH for 
free?>> joe>> Scott wrote:> > I believe 
that Oracle has decided that when porting to> > linux all products 
will be ported to SuSE and then> > perform post release certifications 
on Redhat. I> > believe stability and support of multiple 
Linux> > distributions was a factor in this decision. I run> 
> both Redhat and SuSE and I actually perfer SuSE. SuSE> > has a 
lot of packages it distributes with there> > product. The only thing 
is the SuSE wont create ISO> > images for download and Redhat 
will.> >> > Scott> >> > --- Brian McGraw 
<[EMAIL PROTECTED]>> >> > 
wrote:> > > Correct me if I'm wrong, but wasn't Red Hat 
Oracle's> > > preferred Linux> > > distribution, right 
up until the time they announced> > > the availability of the 
Red> > > Hat Database (PostgreSQL)?> > >> > 
> Brian> > >> > > Christopher Spence wrote:> 
> > > I would be curious to see these tests going> > 
>> > > forward, seeing as RedHat> > >> > 
> > support is difficult to do with 9i and such.  And> > 
>> > > suse now being Oracle's> > >> > 
> > perfered linux.  I wonder if these results have> > 
>> > > changed.  I never really> > >> 
> > > played with Oracle on Linux, but if I ever had to,> > 
>> > > I would be curious.> > >> > > 
> "Do not criticize someone until you walked a mile> > >> 
> > in their shoes, that way> > >> > > > when 
you criticize them, you are a mile a way and> > >> > > 
have their shoes."> > >> > > > Christopher R. 
Spence> > > > Oracle DBA> > > > Phone: (978) 
322-5744> > > > Fax:    (707) 885-2275> 
> > >> > > > Fuelspot> > > > 73 
Princeton Street> > > > North, Chelmsford 01863> > 
> >> > > >> > > > -Original 
Message-> > > > Sent: Tuesday, August 21, 2001 1:53 
PM> > > > To: Multiple recipients of list ORACLE-L> > 
> >> > > > Lisa and others,> > > >> 
> > >  About a year ago, I was working for 
a company> > >> > > as a Linux systems> > 
>> > > > engineer (Read as: Tech guy doing sales 
support).> > >> > > Most of our customers> > 
>> > > > wanted Linux systems, and it was my 
responsibility> > >> > > to provide them the> 
> >> > > > correct combination of Linux and hardware to 
meet> > >> > > their needs.  I had an ISO> 
> >> > > > 9002 compliance to maintain as I provided 
testing> > >> > > and supporting data to our> 
> >> > > > clients.> > > >> > 
> > My first test was RedHat linux 6.1 with Oracle> > 
>> > > 8.1.5.  I don't have the> > >> 
> > > benchmarks any more, but it worked the best.> > > 
>> > > > SCO Unix was bought by Caldera Linux and is 
not> > >> > > yet being implemented to the> 
> >> > > > full capability (IMHO).> > > 
>> > > > Mandrake, SuSe, Storm were all tested as 
well,> > >> > > And had less satisfactory> > 
>> > > > performance and reliability.> > > 
>> > > > Slackware 7 was the next best solution, 
followed> > >> > > by TurboLinux 6.> > 
>> > > > All of these configurations were tested on 
the> > >> > > same machine, completely> > 
>> > > > formatted and the same installation performed 
on> > >> > > each test cycle.> > 
>> > > > I hope this is helpful information.> > 
> >> > > > Daniel Curry> > > > Systems 
Administrator> > > > CGtime, Inc.> > > > 625 
Second Street> > > > Suite 201> > > > San 
Francisco, CA 94107> > > > ph: 415-348-6516> > > 
> fx: 415-348-6505> > > > cell: 510-304-7889> > 
> >> > > > -Original Message-> > > 
> Sent: Tuesday, August 21, 2001 9:36 AM> > > > To: Multiple 
recipients of list ORACLE-L> > > >> > > > 
Lisa> > > >> > > > SuSe is the best so I have 
been told. I am about> > >> > > to install 8i on 7.1 
and> > >> > > > another guy here is installing 9i 
on 7.2.> > > >> > > > Totally untested on my 
behalf as I haven't started> > >> > > yet but that is 
the best> > >> > > > I have been told.> > 
> >> > > > Probably of no use whatsoever !!!> > 
> >> > > > Lee> > > > -Original 
Message-> > > > Sent: 21 August 2001 16:51> > > 
> To: Multiple recipients of list ORACLE-L> > > > Sorry 
everyone, I know you were just discussing> > >> > > 
this recently.> > >> > > > What is the most stable 
combination of Oracle &> > >> > > Linux?  
What would you> > >> > > > recommend?  I want 
to say the consensus was SCO> > >> > > Linux but I 
don't quite> > >> > > > remember.> > > 
> Thank you> > > > Lara Croft> > > > Oracle 
Database Administrator> > > > Fairfield Resorts, Inc> 
> > >> > > >> > > > The information 
contained in this communication is> > >> > > 
confidential, is intended> > >> > > > only for the 
use of the recipient named above, and> > >> > > may be 
legally> > >> > > > privileged. If the 
reader> > > > of this message is not the intended re

RE: linux & Oracle -- best combination

2001-08-22 Thread Koivu, Lisa

Title: RE: linux & Oracle -- best combination





Have you tried an index hint on the first query yet? 


Have you tried NVL(cmm_id,101) = 101,
NVL(cust_id,101) = 101
NVL(Friendly_session_id,100) = 100
loc_to_utc(NVL(creation_date,21-jun-2001')) between ?


-Original Message-
From:   Vikas Kawatra [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, August 22, 2001 13:12
To: Multiple recipients of list ORACLE-L
Subject:    RE: linux & Oracle -- best combination


We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use the Index .However ,if we re-write it as below(see 2nd query) - the
index is used :but the query returns incorrect results .Can you suggest any
changes to the original query? 


note :
 1)we have a index on cmm_id,cust_id,friendly_session_id,creation_date
 2)We want to return rows from the table even if all columns in where clause
are NULL 


Thanks 


vikas



SELECT friendly_session_id,
  cmm_id,
      cust_id,
  hold_amount,
      virtual_balance_amount,
      creation_date,
      session_id
 FROM sals_session
 WHERE ( CMM_ID = '101' or  cmm_id IS NULL )
 AND ( CUST_ID =101 or cust_id IS NULL )
 AND ( FRIENDLY_SESSION_ID = 100 or friendly_session_id IS NULL )
 AND (CREATION_DATE is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');




SELECT friendly_session_id,
  cmm_id,
      cust_id,
  hold_amount,
      virtual_balance_amount,
      creation_date,
      session_id
 FROM sals_session
 WHERE cmm_id = nvl(cmm_id,0)
 AND cust_id = nvl(cust_id,0)
 AND friendly_session_id =nvl(friendly_session_id ,0)
 AND (creation_date is NULL OR loc_to_utc(creation_date) between
'21-JUN-2001' and '21-AUG-2001');
-- 
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).

RE: database upgrade policy?

2001-08-22 Thread Koivu, Lisa

Title: RE: database upgrade policy?





Don't upgrade unless there is a very good reason.  


All of these are candidates


1.  current oracle version is unstable
2.  specific bug addressed by an upgrade/patch, as identified by support
3.  need to utilize new feature
4.  desupport date coming up.


If it works, don't fix it!


Don't do it just for fun.  Because it can turn into HELL.  


Lisa Koivu
Certifiable Gimp Monkey (and DBA)
Ft. Lauderdale, FL, USA


-Original Message-
From:   Mark Marsden [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, August 22, 2001 11:45
To: Multiple recipients of list ORACLE-L
Subject:    database upgrade policy?


Hi Listers


I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
as I get the occasional ORA-600/ORA-7445.


Do you upgrade to the latest subversion as a matter of policy
(and not test very much) to prevent possible errors 
or only upgrade if you have problems?


Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
functionality, cos Oracle are desupporting (the main reason we upgrade)
or to improve the CV ;-)  with the possible downside of instability.


Mark.





Hyde Housing Association - Email Disclaimer


The information in this email is strictly confidential and may be legally privileged.


It is intended solely for the addressee only. Access to this email by anyone else is unauthorised. 
If you are not the intended recipient and you have recieved this email in error you must take no action
on its contents, nor must you copy or show them to anyone, or make use of the information therein.
Please reply to the email immediately, or forward to [EMAIL PROTECTED], highlighting
the error and confirming that it has been deleted from your system.


SECURITY WARNING: Please note that this email has been created with the knowledge that the Internet
is not a 100% secure communications medium. We advise that you understand and observe
this lack of security when e-mailing us.
VIRUSES: Although we have taken steps to ensure that this email and attachments are free
from any virus, we advise that in keeping with good computing practise the recipient should ensure
that they are actually virus free.


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


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

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




how about this as a solution:
 
alter user sys default tablespace tools;
 
@?/rdbms/admin/Put SCRIPT HERE :)
 
joe
>>> [EMAIL PROTECTED] 08/22/01 12:02PM 
>>>SYSTEM objects don't matter, but I wonder how the 
SYSobjects ended up in the TOOLS tablespace.Audit tables 
perhaps?JaredOn Tuesday 21 August 2001 09:16, Kumanan 
Balasundaram wrote:> I was bitten but this badly and thanks to all those 
people who> helped me. This may some of you, so I'm posting 
it.>> Scenario:> I wanted to extract one table as of a time 
the previous day. So I decided> to recover to the closest time as 
possible before the unwanted change> was made.> This meant that I 
only wanted two application tablespaces (data and> index) out of 
many.>> As I was told its possible, I assumed it would be OK if I 
went with the> basics - system TS data files, RBS (3 out of 4 files), the 
datafiles of the> application TS's and even member of each redo-logs 
group .>> I recreated the control file, did the recovery to the 
point in time and> opened it.> Now when I did a select on any 
object, I was hit with the following:>> ORA-00604: error occurred 
at recursive SQL level 1> ORA-00376: file 2 cannot be read at this 
time> ORA-0: name for data file 2 is unknown - rename to correct 
file> ORA-01110: data file 2: 
'/emc/vol1/oracle/product/8.1.6/dbs/MISSING2'>> I tried 
recovering again with all the RBS files as the last one also had> 
online> public rollback segments.> That also didn't help and file2 
was constantly being a pain - checking> dba_data_files showed that it was 
belonging to the TOOLS tablespace.> On closer examination I discovered it 
had 237 SYS and SYSTEM> objects.>> Another DBA must have 
loaded these objects in TOOLS t/s.> Recovering DB with tools and the 
other essentials resolved the problem.>> So, watch out for this in 
the future.>> Kumanan Balasundaram> Database Administrator, 
IT> QXL ricardo plc> www.qxl.com> P: +44 (0)208 962 
7409>> > QXL ricardo plc Registered Office Landmark House, 
Hammersmith Bridge> > Road, London W6 9DP> > Registered in 
England No 3430894 VAT number - GB 701 8915 43> >> > The 
information transmitted is intended only for the person or entity to> 
> which it is addressed and may contain confidential and/or 
privileged> > material.  Any review, retransmission, 
dissemination or other use of, or> > taking of any action in reliance 
upon, this information by persons or> > entities other than the 
intended recipient is prohibited.   If you> > received  
this in error, please contact the sender and delete the> > material 
from any computer>> 
**> 
This email and any files transmitted with it are confidential and> 
intended solely for the use of the individual or entity to whom they> are 
addressed. If you have received this email in error please notify> 
[EMAIL PROTECTED]>> This footnote also confirms that this email 
message has been swept by> MIMEsweeper and Nortons Anti-Virus, for the 
presence of computer viruses.>> 
**-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jared 
Still  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 the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Disaster recovery

2001-08-22 Thread Anderson, Brian


I need to do some documenting too.

Person probably driving the bus ;-) (That person thats been stalking
you)
Oracle Versions
Patches installed
File system layout
Instances mapped to Oracle Homes
log files (methods for checking/trimming)
scripts/tools (what/where/when/why)
listener info (name/port)
passwords (available from a secure location)
backup practices


> -Original Message-
> From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 5:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Disaster recovery
> 
> 
> >>I have to document our Oracle databases for the case where 
> I'm e.g. hit by
> the proverbial bus.  So if you DBA folk were to >>come on 
> site to pick up
> the tab and start managing our databases what information 
> would you like to
> be able to refer to, to >>allow you get up to speed as 
> quickly as possible
> with our set-up.
> 
> Rachel and Bruce, thanx for your input on this.  Some points 
> ya'll made I
> had not considered.  I'm sure there are more.  Come on folks 
> let's hear your
> input on this.  I'll publish a list to the list when it looks 
> as though all
> avenues have been explored!.
> 

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

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

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

RE: checkpoint message

2001-08-22 Thread Hand, Michael T



These messages will show up in your 8.0.x database if you have set
log_checkpoints_to_alert=TRUE.  This gives you an easy way of seeing how
long it takes to complete a checkpoint and if any are happening between log
switches.

Mike Hand
Polaroid Corp

-Original Message-
Sent: Tuesday, August 21, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L


I get the same kind of message, anyone knows what it means?

Saludos, 
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: checkpoint message 


Hi all

I think there is some wait in our checkpointing.please correct me.I received

the following message in alert.log file

Beginning log switch checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Please advice me for correction.
Thanks in advance.

Mala
DBA-USA
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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




and its only 2.3K :)  
 
guess i'm spoiled being able to grab darn near anything that oracle has 
from technet.
 
joe
>>> [EMAIL PROTECTED] 08/22/01 11:00AM 
>>>True, but now RedHat pushes it as the 'Red Hat 
Database'...http://www.redhat.com/products/software/database/Christopher 
Spence wrote:> PostGresSQL has been out for years, and is not RedHat 
specific, all> distributions have included it.>> "Do not 
criticize someone until you walked a mile in their shoes, that way> when 
you criticize them, you are a mile a way and have their shoes.">> 
Christopher R. Spence> Oracle DBA> Phone: (978) 322-5744> 
Fax:    (707) 885-2275>> Fuelspot> 73 
Princeton Street> North, Chelmsford 01863>>> 
-Original Message-> Sent: Tuesday, August 21, 2001 5:36 
PM> To: Multiple recipients of list ORACLE-L>> Correct me 
if I'm wrong, but wasn't Red Hat Oracle's preferred Linux> distribution, 
right up until the time they announced the availability of the> Red Hat 
Database (PostgreSQL)?>> Brian>> Christopher Spence 
wrote:>> > I would be curious to see these tests going forward, 
seeing as RedHat> > support is difficult to do with 9i and such.  
And suse now being> > Oracle's perfered linux.  I wonder if these 
results have changed.  I> > never really played with Oracle on 
Linux, but if I ever had to, I> > would be curious.> 
>> > "Do not criticize someone until you walked a mile in their 
shoes, that> > way when you criticize them, you are a mile a way and 
have their> > shoes."> >> > Christopher R. 
Spence> > Oracle DBA> > Phone: (978) 322-5744> > 
Fax:    (707) 885-2275> >> > Fuelspot> 
> 73 Princeton Street> > North, Chelmsford 01863> 
>> >> > -Original Message-> > Sent: 
Tuesday, August 21, 2001 1:53 PM> > To: Multiple recipients of list 
ORACLE-L> >> > Lisa and others,> >> 
>  About a year ago, I was working for a company 
as a Linux systems> > engineer (Read as: Tech guy doing sales 
support).  Most of our> > customers wanted Linux systems, and it 
was my responsibility to> > provide them the correct combination of 
Linux and hardware to meet> > their needs.  I had an ISO 9002 
compliance to maintain as I provided> > testing and supporting data to 
our clients.> >> > My first test was RedHat linux 6.1 with 
Oracle 8.1.5.  I don't have> > the benchmarks any more, but it 
worked the best.> >> > SCO Unix was bought by Caldera Linux 
and is not yet being implemented> > to the full capability 
(IMHO).> >> > Mandrake, SuSe, Storm were all tested as 
well,  And had less> > satisfactory performance and 
reliability.> >> > Slackware 7 was the next best solution, 
followed by TurboLinux 6.> >> > All of these configurations 
were tested on the same machine,> > completely formatted and the same 
installation performed on each test> > cycle.> >> 
> I hope this is helpful information.> >> > Daniel 
Curry> > Systems Administrator> > CGtime, Inc.> > 
625 Second Street> > Suite 201> > San Francisco, CA 
94107> > ph: 415-348-6516> > fx: 415-348-6505> > 
cell: 510-304-7889> >> > -Original Message-> 
> Sent: Tuesday, August 21, 2001 9:36 AM> > To: Multiple recipients 
of list ORACLE-L> >> > Lisa> >> > SuSe 
is the best so I have been told. I am about to install 8i on 7.1> > 
and another guy here is installing 9i on 7.2.> >> > Totally 
untested on my behalf as I haven't started yet but that is the> > best 
I have been told.> >> > Probably of no use whatsoever 
!!!> >> > Lee> > -Original 
Message-> > Sent: 21 August 2001 16:51> > To: Multiple 
recipients of list ORACLE-L> > Sorry everyone, I know you were just 
discussing this recently. What is> > the most stable combination of 
Oracle & Linux?  What would you> > recommend?  I want to 
say the consensus was SCO Linux but I don't> > quite remember. Thank 
you> > Lara Croft> > Oracle Database Administrator> 
> Fairfield Resorts, Inc> >> >> > The 
information contained in this communication is confidential, is> > 
intended only for the use of the recipient named above, and may be> > 
legally privileged. If the reader of this message is not the intended> 
> recipient, you are hereby notified that any dissemination,> > 
distribution or copying of this communication is strictly prohibited.> 
> If you have received this communication in error, please> > 
re-send this communication to the sender and delete the> > original 
message or any copy of it from your computer> > system.> > 
--> > Please see the official ORACLE-L FAQ: http://www.orafaq.com> > --> 
> Author: Daniel Curry> >   INET: 
[EMAIL PROTECTED]> >> > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051> 
> San Diego, California    -- Public 
Internet access / Mailing Lists> > 
> 
> To REMOVE yourself from this mailing list, send an E-Mail message> 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the> 
> name of mailing list y

RE: checkpoint message

2001-08-22 Thread Khedr, Waleed


I still think it's redo block address!

-Original Message-
Sent: Wednesday, August 22, 2001 12:50 AM
To: Multiple recipients of list ORACLE-L


 Kevin, 

Thanksclarity is always preferable. 

As for the acronym inflationI guess when I wrote "block" instead of
"byte", I simply hadn't smoked enough DBA crack. (That's Data Block Address,
I think, but...where *did* i leave that mushroom tea...darnit...)

:)

Ross

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/21/2001 10:55 PM

Ross:

I believe that RBA is referred to Redo Byte Address (Checkpoint RBA).
The checkpoint RBA is stored in the control file. When recovery is
required,
the checkpoint RBA determines the location in the redo stream from which
to
start applying recovery.

kevin

-Original Message-
Sent: Tuesday, August 21, 2001 7:21 PM
To: Multiple recipients of list ORACLE-L


smacks of incremental checkpointing...new implemented
in 8i i thinkthe RBA is a redo block address.

More than that, and you'll have to smoke some DBA crack,
make some guru mushroom tea, hack the internals, write a
book, and then become highly enigmatic and largely helpful.

-Original Message-
Sent: Tuesday, August 21, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L


I get the same kind of message, anyone knows what it means?

Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua


-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: checkpoint message


Hi all

I think there is some wait in our checkpointing.please correct me.I
received

the following message in alert.log file

Beginning log switch checkpoint up to RBA [0x55.3.11], SCN:
0x.000505b1

Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1

Please advice me for correction.
Thanks in advance.

Mala
DBA-USA

_
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: database upgrade policy?

2001-08-22 Thread Ray Stell


On Wed, Aug 22, 2001 at 07:45:27AM -0800, Mark Marsden wrote:
> Hi Listers
> 
> I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> as I get the occasional ORA-600/ORA-7445.


Doc ID:  Note:123178.1

Product / Platform: Oracle8i, Release 2 (8.1.6)

Error Correction Support ends on:   31 October 2001

Oracle8i, Release 2 (8.1.6.) = 8.1.6.3.1


One the upside, all my ORA-600/ORA-7445 went away
with 8.1.6.3.1 (which after you apply your version
says 8.1.6.3.0, but that is another weasel altogether)



> Do you upgrade to the latest subversion as a matter of policy
> (and not test very much) to prevent possible errors 
> or only upgrade if you have problems?
> 
> Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
> functionality, cos Oracle are desupporting (the main reason we upgrade)
> or to improve the CV ;-)  with the possible downside of instability.
> 
> Mark.
> 
> 
> 
>
> Hyde Housing Association - Email Disclaimer
> 
> The information in this email is strictly confidential and may be legally privileged.
> 
> It is intended solely for the addressee only. Access to this email by anyone else is 
>unauthorised. 
> If you are not the intended recipient and you have recieved this email in error you 
>must take no action
> on its contents, nor must you copy or show them to anyone, or make use of the 
>information therein.
> Please reply to the email immediately, or forward to [EMAIL PROTECTED], 
>highlighting
> the error and confirming that it has been deleted from your system.
> 
> SECURITY WARNING: Please note that this email has been created with the 
>knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and attachments 
>are free
> from any virus, we advise that in keeping with good computing practise the recipient 
>should ensure
> that they are actually virus free.
> 
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mark Marsden
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

Re: OT: Unix - performance tuning (vmstat 5)

2001-08-22 Thread Stephen Andert




Try this:
var_pid=`echo $var_grep_vmstat | grep -v grep | (read u v w x 
y z; echo ${v} )`kill $var_pid
the grep -v grep will remove any lines with the word 
grep.  
 
HTH
Stephen
>>> [EMAIL PROTECTED] 08/22/01 05:05AM >>>Hi 
Unix Gurus,I submit a job to monitor the CPU utilization etc every 15 
mins using thecommand vmstat 5.How do I kill the submitted unix 
process of the batch job ? I tried to kill the submitted process using a 
batch job using the followingcommand :var_pid=`echo $var_grep_vmstat | 
(read u v w x y z; echo ${v} )`kill $var_pidThis works if the output 
is $ ps -ef | grep vmstat   orahrms 11271 11263  0 
17:30:00 ?    0:00 vmstat 
5   orahrms 11612 11576  0 18:50:53 pts/11   0:00 
grep vmstatIf the output is as below, the program will not work $ ps 
-ef | grep vmstat   orahrms 11612 11576  0 18:50:53 
pts/11   0:00 grep vmstat   orahrms 11271 11263  0 
17:30:00 ?    0:00 vmstat 5Please 
help. Thanks in advance.Regds,New Bee-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: CHAN 
Chor Ling Catherine (CSC)  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 the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: OCP Test timeframe

2001-08-22 Thread Tirumala, Surendra


I think only restriction is you have to wait for sometime(30 days?) before
you can
re-take a failed exam.

Surendra

-Original Message-
Sent: Wednesday, August 22, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Hi Traci,

There is no time frame from start to finish and as of yet Oracle has no
plans in retiring the Oracle 8i track.

Rick

-Original Message-
Sent: Wednesday, August 22, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L


Hello, does anyone know if there is a time limit on exams taken for the OCP
DBA 8i track?  More specifically, from when the first test is taken, do you
have to complete the others in a specified amount of time, say within 1
year?

Thanks
Traci


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

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

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

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

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

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

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

RE: TNSPING Test Script for NT

2001-08-22 Thread Haskins, Ed


Tom,

Thanks!!

Ed

-Original Message-
Sent: Tuesday, August 21, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L


Ed,

how about:


tnsping {sid} 1000 > ping.lis

will tnsping the {sid} 1000 times, with the result being placed in a file
created named ping.lis

changing it to

***  file name pingtest.bat
tnsping %1 1000 > ping.lis

Can be executed as   pingtest {sid}


Another way to do this using a loop within the .bat file follows.
This would execute the tnsping command 1000 times:

***  file name pingtest1.bat
echo TnsPing Test > ping.lis
echo date /T  >> ping.lis
for /L %I in (1,1,1000) do tnsping r816 >> ping.lis


And a third way, using goto looping:

***  file name pingtest2.bat
@rem
@rem  Loop through a counter searching for the RunDaily.{seq} file
@rem

@set /A ctr=0

:again

echo TnsPing Test > ping.lis
echo date /T  >> ping.lis
set /A ctr=ctr+1

if (%ctr%) == (1000) goto endloop
tnsping r816 >> ping.lis
goto again

:endloop

hope these help.


Tom Mercadante
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L


Can anyone help me with a simple .bat script for NT that will run a TNSPING
against a certain connect descriptor and write the results to a file.  I
need to have the TNSPING run for say 1000 loops.  Once complete, I can
search through the file for errors.

Thanks,
Ed
-- 
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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

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

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

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



Joe,

It's cheap.  $60-70 for the pro version.

Even though I've been a long time RH user, I prefer SuSE
simply for the documentation and admin utils.

Jared


On Wednesday 22 August 2001 04:50, Joe Testa wrote:
> I've not really checked out Suse, you have to buy it versus being able
> to get RH for free?
>
> joe
>
> Scott wrote:
> > I believe that Oracle has decided that when porting to
> > linux all products will be ported to SuSE and then
> > perform post release certifications on Redhat. I
> > believe stability and support of multiple Linux
> > distributions was a factor in this decision. I run
> > both Redhat and SuSE and I actually perfer SuSE. SuSE
> > has a lot of packages it distributes with there
> > product. The only thing is the SuSE wont create ISO
> > images for download and Redhat will.
> >
> > Scott
> >
> > --- Brian McGraw <[EMAIL PROTECTED]>
> >
> > wrote:
> > > Correct me if I'm wrong, but wasn't Red Hat Oracle's
> > > preferred Linux
> > > distribution, right up until the time they announced
> > > the availability of the Red
> > > Hat Database (PostgreSQL)?
> > >
> > > Brian
> > >
> > > Christopher Spence wrote:
> > > > I would be curious to see these tests going
> > >
> > > forward, seeing as RedHat
> > >
> > > > support is difficult to do with 9i and such.  And
> > >
> > > suse now being Oracle's
> > >
> > > > perfered linux.  I wonder if these results have
> > >
> > > changed.  I never really
> > >
> > > > played with Oracle on Linux, but if I ever had to,
> > >
> > > I would be curious.
> > >
> > > > "Do not criticize someone until you walked a mile
> > >
> > > in their shoes, that way
> > >
> > > > when you criticize them, you are a mile a way and
> > >
> > > have their shoes."
> > >
> > > > Christopher R. Spence
> > > > Oracle DBA
> > > > Phone: (978) 322-5744
> > > > Fax:(707) 885-2275
> > > >
> > > > Fuelspot
> > > > 73 Princeton Street
> > > > North, Chelmsford 01863
> > > >
> > > >
> > > > -Original Message-
> > > > Sent: Tuesday, August 21, 2001 1:53 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > > Lisa and others,
> > > >
> > > >  About a year ago, I was working for a company
> > >
> > > as a Linux systems
> > >
> > > > engineer (Read as: Tech guy doing sales support).
> > >
> > > Most of our customers
> > >
> > > > wanted Linux systems, and it was my responsibility
> > >
> > > to provide them the
> > >
> > > > correct combination of Linux and hardware to meet
> > >
> > > their needs.  I had an ISO
> > >
> > > > 9002 compliance to maintain as I provided testing
> > >
> > > and supporting data to our
> > >
> > > > clients.
> > > >
> > > > My first test was RedHat linux 6.1 with Oracle
> > >
> > > 8.1.5.  I don't have the
> > >
> > > > benchmarks any more, but it worked the best.
> > > >
> > > > SCO Unix was bought by Caldera Linux and is not
> > >
> > > yet being implemented to the
> > >
> > > > full capability (IMHO).
> > > >
> > > > Mandrake, SuSe, Storm were all tested as well,
> > >
> > > And had less satisfactory
> > >
> > > > performance and reliability.
> > > >
> > > > Slackware 7 was the next best solution, followed
> > >
> > > by TurboLinux 6.
> > >
> > > > All of these configurations were tested on the
> > >
> > > same machine, completely
> > >
> > > > formatted and the same installation performed on
> > >
> > > each test cycle.
> > >
> > > > I hope this is helpful information.
> > > >
> > > > Daniel Curry
> > > > Systems Administrator
> > > > CGtime, Inc.
> > > > 625 Second Street
> > > > Suite 201
> > > > San Francisco, CA 94107
> > > > ph: 415-348-6516
> > > > fx: 415-348-6505
> > > > cell: 510-304-7889
> > > >
> > > > -Original Message-
> > > > Sent: Tuesday, August 21, 2001 9:36 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > > Lisa
> > > >
> > > > SuSe is the best so I have been told. I am about
> > >
> > > to install 8i on 7.1 and
> > >
> > > > another guy here is installing 9i on 7.2.
> > > >
> > > > Totally untested on my behalf as I haven't started
> > >
> > > yet but that is the best
> > >
> > > > I have been told.
> > > >
> > > > Probably of no use whatsoever !!!
> > > >
> > > > Lee
> > > > -Original Message-
> > > > Sent: 21 August 2001 16:51
> > > > To: Multiple recipients of list ORACLE-L
> > > > Sorry everyone, I know you were just discussing
> > >
> > > this recently.
> > >
> > > > What is the most stable combination of Oracle &
> > >
> > > Linux?  What would you
> > >
> > > > recommend?  I want to say the consensus was SCO
> > >
> > > Linux but I don't quite
> > >
> > > > remember.
> > > > Thank you
> > > > Lara Croft
> > > > Oracle Database Administrator
> > > > Fairfield Resorts, Inc
> > > >
> > > >
> > > > The information contained in this communication is
> > >
> > > confidential, is intended
> > >
> > > > only for the use of the recipient named above, and
> > >
> > > may be legally
> > >
> > > > privileged. If the reader
> > > > of this message is not the intended recipient

Oracle 8.1.7 installation and running on RedHet7.0

2001-08-22 Thread Cristi Marius


Hi! 
 
I am an Oracle products user (in fact JDBC applications that use Oracle as a 
backend) but I used them only under Windows platforms. The installation on that kind 
of platform is pretty simple, but I am not so satisfied with the performances.
I have been told that Oracle products work with better results on UNIX
platforms. I have an RedHet 7.0 server machine and I tried to install
Oracle8.1.7 for Linux Enterprise Edition. I followed all the steps from the
Installation Guide but the following errors occurred:
1)  not connected to Oracle (when the dbassist run)
2)  end of communication channel.   

If I run a ./tnsping  the response is ok, but if I try to  
 
I dig deeper on some newsgroups and I found out that there are many users with this 
problem, so my questions are: 
 
1)  what is the best open source implementation of linux to use with oracle? 
2)  where can I find a specialized documentation on Oracle Installation (8.1.7) on 
RedHet 7.0? (a list of the steps that I must follow would be very helpful to me) 
3)  can you give some links with advanced issues on the problems I told you about? 
 
Best regards, 
Cristi Marius 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cristi Marius
  INET: [EMAIL PROTECTED]

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

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

HELP - How can I limit what program users use to connect?

2001-08-22 Thread Fred Smith


List,
  Does anyone know of a method by which I can prohibit users from connecting 
into my Oracle 8.0.6.0.0 database by any product other than the 
application's executable program?  (i.e. - I don't want anyone connecting 
through TOAD, etc.)  But, I do want to allow anyone with DBA role to be able 
to connect through TOAD.

Thank you,
-Ken Lewin

_
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: Fred Smith
  INET: [EMAIL PROTECTED]

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

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

Title: Message

Also a
lock will be established on deletes.
"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."
Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73 Princeton Street North, Chelmsford 01863

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001
2:22 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Index question ???
Andrea,
It is recommended, not
required. Anytime the db needs to verify the fk constraint, if there
isn't an index there to support it, a full table scan will happen.
Performance killer.
What do you mean your indices
disappeared? Can you elaborate?

-Original Message- From: Andrea Oracle [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 14:06 To: Multiple recipients of list ORACLE-L Subject: Index question ???
Hi, all
I got couple of indices questions:
Is it REQUIRED or just recommended to build an
index on FK column/s?
I used Alter Table ... Move and Alter Index
... Rebulid to move the table into
differenct block and then rebuild
index. Table Move works fine, but after index rebuilt, some indices disappeared! How come?
Thanks!
Andrea
__ 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: 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).

A Trigger question

2001-08-22 Thread Andrey Bronfin


Dear gurus !
sorry for this RTFMable question , just don't have the docs in front of me
here .
Assume i have a trigger my_trig that performs an insert into tableB after an
insert into tableA .
The question is : what happens if the trigger gets broken (either disabled ,
invalid or unable to do what it should do (for example if the tableB has
reached maxextents) ) ?
Does the user that inserts into tableA receive an ORA- error ?
Is there a way to let the user insert into tableA , and capture the inserts
into tableB that the trigger should perform , and do those inserts manually
later ?
Thanks a lot.
Andrey.
-- 
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).

Re: OCP Test timeframe

2001-08-22 Thread kjanusz


I have not seen anything of a time frame for the OCP 
exams.  The only time frame is when the next release 
comes out and the previous release becomes obscolete.  I 
am APICS CPIM certified and APICS has a time limit of 
about 3 years (?).

Ken Janusz, CPIM
> Hello, does anyone know if there is a time limit on exams taken for the OCP DBA 
> 8i track?  More specifically, from when the first test is taken, do you have to 
> complete the others in a specified amount of time, say within 1 year?
> 
> Thanks
> Traci
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Traci Rebman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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).

database upgrade policy?

2001-08-22 Thread Mark Marsden


Hi Listers

I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
as I get the occasional ORA-600/ORA-7445.

Do you upgrade to the latest subversion as a matter of policy
(and not test very much) to prevent possible errors 
or only upgrade if you have problems?

Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
functionality, cos Oracle are desupporting (the main reason we upgrade)
or to improve the CV ;-)  with the possible downside of instability.

Mark.



Hyde Housing Association - Email Disclaimer

The information in this email is strictly confidential and may be legally privileged.

It is intended solely for the addressee only. Access to this email by anyone else is 
unauthorised. 
If you are not the intended recipient and you have recieved this email in error you 
must take no action
on its contents, nor must you copy or show them to anyone, or make use of the 
information therein.
Please reply to the email immediately, or forward to [EMAIL PROTECTED], 
highlighting
the error and confirming that it has been deleted from your system.

SECURITY WARNING: Please note that this email has been created with the knowledge 
that the Internet
is not a 100% secure communications medium. We advise that you understand and observe
this lack of security when e-mailing us.
VIRUSES: Although we have taken steps to ensure that this email and attachments 
are free
from any virus, we advise that in keeping with good computing practise the recipient 
should ensure
that they are actually virus free.

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

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

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



SYSTEM objects don't matter, but I wonder how the SYS
objects ended up in the TOOLS tablespace.

Audit tables perhaps?

Jared


On Tuesday 21 August 2001 09:16, Kumanan Balasundaram wrote:
> I was bitten but this badly and thanks to all those people who
> helped me. This may some of you, so I'm posting it.
>
> Scenario:
> I wanted to extract one table as of a time the previous day. So I decided
> to recover to the closest time as possible before the unwanted change
> was made.
> This meant that I only wanted two application tablespaces (data and
> index) out of many.
>
> As I was told its possible, I assumed it would be OK if I went with the
> basics - system TS data files, RBS (3 out of 4 files), the datafiles of the
> application TS's and even member of each redo-logs group .
>
> I recreated the control file, did the recovery to the point in time and
> opened it.
> Now when I did a select on any object, I was hit with the following:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00376: file 2 cannot be read at this time
> ORA-0: name for data file 2 is unknown - rename to correct file
> ORA-01110: data file 2: '/emc/vol1/oracle/product/8.1.6/dbs/MISSING2'
>
> I tried recovering again with all the RBS files as the last one also had
> online
> public rollback segments.
> That also didn't help and file2 was constantly being a pain - checking
> dba_data_files showed that it was belonging to the TOOLS tablespace.
> On closer examination I discovered it had 237 SYS and SYSTEM
> objects.
>
> Another DBA must have loaded these objects in TOOLS t/s.
> Recovering DB with tools and the other essentials resolved the problem.
>
> So, watch out for this in the future.
>
> Kumanan Balasundaram
> Database Administrator, IT
> QXL ricardo plc
> www.qxl.com
> P: +44 (0)208 962 7409
>
> > QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge
> > Road, London W6 9DP
> > Registered in England No 3430894 VAT number - GB 701 8915 43
> >
> > The information transmitted is intended only for the person or entity to
> > which it is addressed and may contain confidential and/or privileged
> > material.  Any review, retransmission, dissemination or other use of, or
> > taking of any action in reliance upon, this information by persons or
> > entities other than the intended recipient is prohibited.   If you
> > received  this in error, please contact the sender and delete the
> > material from any computer
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> [EMAIL PROTECTED]
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper and Nortons Anti-Virus, for the presence of computer viruses.
>
> **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread Igor Neyman




Try to add this entry to DESCRIPTION_LIST in your 
listener configuration file:
 

(ADDRESS = (PROTOCOL = IPC)(KEY = PLNT))
So:
 
LISTENER =  (DESCRIPTION_LIST 
=    (DESCRIPTION =  
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 1521))    
)    (DESCRIPTION =  
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 2481))    
)    (DESCRIPTION =  
(ADDRESS = (PROTOCOL = IPC)(KEY=UYAPBUN))    )  )
 
SID_LIST_LISTENER =  (SID_LIST 
=    (SID_DESC =  
(GLOBAL_DBNAME = UYAPBUN.havelsan.com.tr)  
(ORACLE_HOME = D:\ORACLE\ORA817)  (SID_NAME = 
UYAPBUN)    )  ) 
 
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]  


  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, August 22, 2001 10:11 
  AM
  Subject: tns service error
  
   I am getting the below error where I run 
  STAT or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is 
  also below.
  Why is that ?
  Note : I can remotely connect to this database 
  from client.
   
   
  Connecting to 
  (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no 
  listener TNS-12560: TNS:protocol adapter error  TNS-00511: 
  No listener   32-bit Windows Error: 2: No such file or 
  directoryConnecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))TNS-12545: 
  Connect failed because target host or object does not 
  exist TNS-12560: TNS:protocol adapter error  TNS-00515: 
  Connect failed because target host or object does not exist   
  32-bit Windows Error: 49: Unknown error
   
  In My listener file  below are 
  written.
  LISTENER =  (DESCRIPTION_LIST 
  =    (DESCRIPTION =  
  (ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 
  1521))    )    (DESCRIPTION 
  =  (ADDRESS = (PROTOCOL = TCP)(HOST = 
  bunyamin)(PORT = 2481))    )  )
   
  SID_LIST_LISTENER =  (SID_LIST 
  =    (SID_DESC =  
  (GLOBAL_DBNAME = UYAPBUN.havelsan.com.tr)  
  (ORACLE_HOME = D:\ORACLE\ORA817)  (SID_NAME = 
  UYAPBUN)    )  
)

RE: checkpoint message

2001-08-22 Thread Greg Solomon


Which as we all know courtesy of Mike Hately, stands for redo trace file
manager, now a discontinued feature ...

greg
-Original Message-
Sent: Wednesday, 22 August 2001 03:50
To: Multiple recipients of list ORACLE-L


Or just be like me and spend most of the time saying "rtfm" :)

joe
"Mohan, Ross" wrote:
> 
> smacks of incremental checkpointing...new implemented
> in 8i i thinkthe RBA is a redo block address.
> 
> More than that, and you'll have to smoke some DBA crack,
> make some guru mushroom tea, hack the internals, write a
> book, and then become highly enigmatic and largely helpful.
> 
> -Original Message-
> Sent: Tuesday, August 21, 2001 10:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> I get the same kind of message, anyone knows what it means?
> 
> Saludos,
> Veronica Levin Enriquez
> Administrador AIX
> Compañía Cervecera de Nicaragua
> 
> -Mensaje original-
> De: mala singh [mailto:[EMAIL PROTECTED]]
> Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
> Para: Multiple recipients of list ORACLE-L
> Asunto: checkpoint message
> 
> Hi all
> 
> I think there is some wait in our checkpointing.please correct me.I
received
> 
> the following message in alert.log file
> 
> Beginning log switch checkpoint up to RBA [0x55.3.11], SCN:
0x.000505b1
> 
> Completed checkpoint up to RBA [0x55.3.11], SCN: 0x.000505b1
> 
> Please advice me for correction.
> Thanks in advance.
> 
> Mala
> DBA-USA
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at
> http://profiles.msn.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --


-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

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

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

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

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


Highly depends.

I tend to stay back from the latest versions for some time.
I also tend to upgrade for functionality, and upgrade when I have existing
problems that are told to be fixed.

Sometimes if I start falling back versions and have no reason either way, I
will upgrade my development database and slowly trickle them to production
if things work well.

A lot of it depends on the environment, if it is a 24/7 very large system,
then you only really want to upgrade when you have a good reason to.  Or a
good maintenance window.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Wednesday, August 22, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


Hi Listers

I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) as I get the
occasional ORA-600/ORA-7445.

Do you upgrade to the latest subversion as a matter of policy (and not test
very much) to prevent possible errors 
or only upgrade if you have problems?

Do you upgrade to major versions (7 to 8.0 to 8.1) for increased
functionality, cos Oracle are desupporting (the main reason we upgrade) or
to improve the CV ;-)  with the possible downside of instability.

Mark.




Hyde Housing Association - Email Disclaimer

The information in this email is strictly confidential and may be legally
privileged.

It is intended solely for the addressee only. Access to this email by anyone
else is unauthorised. 
If you are not the intended recipient and you have recieved this email in
error you must take no action on its contents, nor must you copy or show
them to anyone, or make use of the information therein. Please reply to the
email immediately, or forward to [EMAIL PROTECTED], highlighting
the error and confirming that it has been deleted from your system.

SECURITY WARNING: Please note that this email has been created with the
knowledge that the Internet
is not a 100% secure communications medium. We advise that you understand
and observe this lack of security when e-mailing us.
VIRUSES: Although we have taken steps to ensure that this email and
attachments are free
from any virus, we advise that in keeping with good computing practise the
recipient should ensure that they are actually virus free.


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

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

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

RE: linux & Oracle -- best combination




6000 files, what a pita, guess i'll stay with hacking rh to run oracle 
:)
 
 
joe
>>> [EMAIL PROTECTED] 08/22/01 10:16AM >>>You 
can download Suse, but you have over 6,000 files to download.  It's 
allin a specific directory on there FTP server.On the other hand, 
for RH you can just download a few ISO files and burnthem into CDs.  
Easy.I believe that Suse Personal, with CD and manuals, is 30 
bucks.  I amassuming that the personal version will run Oracle, since 
its seems thePro(70 bucks) version is for clustering, 
etc.Chris-Original Message-Sent: Wednesday, August 
22, 2001 7:51 AMTo: Multiple recipients of list ORACLE-LI've not 
really checked out Suse, you have to buy it versus being ableto get RH for 
free?joeScott wrote:> > I believe that Oracle has 
decided that when porting to> linux all products will be ported to SuSE 
and then> perform post release certifications on Redhat. I> 
believe stability and support of multiple Linux> distributions was a 
factor in this decision. I run> both Redhat and SuSE and I actually 
perfer SuSE. SuSE> has a lot of packages it distributes with 
there> product. The only thing is the SuSE wont create ISO> images 
for download and Redhat will.> > Scott> > --- Brian 
McGraw <[EMAIL PROTECTED]>> wrote:> > 
Correct me if I'm wrong, but wasn't Red Hat Oracle's> > preferred 
Linux> > distribution, right up until the time they announced> 
> the availability of the Red> > Hat Database (PostgreSQL)?> 
>> > Brian> >> > Christopher Spence 
wrote:> >> > > I would be curious to see these tests 
going> > forward, seeing as RedHat> > > support is 
difficult to do with 9i and such.  And> > suse now being 
Oracle's> > > perfered linux.  I wonder if these results 
have> > changed.  I never really> > > played with 
Oracle on Linux, but if I ever had to,> > I would be curious.> 
> >> > > "Do not criticize someone until you walked a 
mile> > in their shoes, that way> > > when you criticize 
them, you are a mile a way and> > have their shoes."> > 
>> > > Christopher R. Spence> > > Oracle 
DBA> > > Phone: (978) 322-5744> > > 
Fax:    (707) 885-2275> > >> > > 
Fuelspot> > > 73 Princeton Street> > > North, 
Chelmsford 01863> > >> > >> > > 
-Original Message-> > > Sent: Tuesday, August 21, 2001 1:53 
PM> > > To: Multiple recipients of list ORACLE-L> > 
>> > > Lisa and others,> > >> > 
>  About a year ago, I was working for a 
company> > as a Linux systems> > > engineer (Read as: 
Tech guy doing sales support).> > Most of our customers> > 
> wanted Linux systems, and it was my responsibility> > to provide 
them the> > > correct combination of Linux and hardware to 
meet> > their needs.  I had an ISO> > > 9002 
compliance to maintain as I provided testing> > and supporting data to 
our> > > clients.> > >> > > My first test 
was RedHat linux 6.1 with Oracle> > 8.1.5.  I don't have 
the> > > benchmarks any more, but it worked the best.> > 
>> > > SCO Unix was bought by Caldera Linux and is not> 
> yet being implemented to the> > > full capability 
(IMHO).> > >> > > Mandrake, SuSe, Storm were all 
tested as well,> > And had less satisfactory> > > 
performance and reliability.> > >> > > Slackware 7 was 
the next best solution, followed> > by TurboLinux 6.> > 
>> > > All of these configurations were tested on the> 
> same machine, completely> > > formatted and the same 
installation performed on> > each test cycle.> > 
>> > > I hope this is helpful information.> > 
>> > > Daniel Curry> > > Systems 
Administrator> > > CGtime, Inc.> > > 625 Second 
Street> > > Suite 201> > > San Francisco, CA 
94107> > > ph: 415-348-6516> > > fx: 
415-348-6505> > > cell: 510-304-7889> > >> > 
> -Original Message-> > > Sent: Tuesday, August 21, 2001 
9:36 AM> > > To: Multiple recipients of list ORACLE-L> > 
>> > > Lisa> > >> > > SuSe is the best 
so I have been told. I am about> > to install 8i on 7.1 and> 
> > another guy here is installing 9i on 7.2.> > >> 
> > Totally untested on my behalf as I haven't started> > yet 
but that is the best> > > I have been told.> > 
>> > > Probably of no use whatsoever !!!> > 
>> > > Lee> > > -Original Message-> 
> > Sent: 21 August 2001 16:51> > > To: Multiple recipients 
of list ORACLE-L> > > Sorry everyone, I know you were just 
discussing> > this recently.> > > What is the most stable 
combination of Oracle &> > Linux?  What would you> 
> > recommend?  I want to say the consensus was SCO> > 
Linux but I don't quite> > > remember.> > > Thank 
you> > > Lara Croft> > > Oracle Database 
Administrator> > > Fairfield Resorts, Inc> > >> 
> >> > > The information contained in this communication 
is> > confidential, is intended> > > only for the use of 
the recipient named above, and> > may be legally> > > 
privileged. If the reader> > > of this message is not the intended 
recipient, you> > are> > > hereby notified that any 
dissemination,> > distribution or> > > copying of this 
communication is strictly> > prohibited.> > > If you have 
received

Re: sql query

2001-08-22 Thread Jon Walthour


Seema:

Here's my crack at it:

select   x.userid
   , x.superid
   , nvl(y.count, 0) as count
from mytable x
   , (select   a.userid
 , a.superid
 , count(*) as count
  from mytable a
 , mytable b
 where a.userid=b.superid
  group by a.userid, a.superid) y
   where x.userid = y.userid(+)
order by 1, 2;

Jon Walthour
> 
> From: "Seema Singh" <[EMAIL PROTECTED]>
> Date: 2001/08/22 Wed AM 09:00:28 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: sql query
> 
> Hi
> One table has following information
> userid  superid
> 14-1
> 4 0
> 8 2
> 9 2
> 152
> 244
> 164
> 254
> 6 5
> 7 5
> 265
> 2 16
> 1816
> 1018
> 1118
> 1 24
> 5 24
> 1324
> I want the output in following format
> userid  superidCOUNT
> 14-10
> 4 0 3
> 8 2 0
> 9 2 0
> 152 0
> 244 3
> 164 2
> 254 0
> 6 5 0
> 7 5 0
> 265 0
> 2 163
> 18162
> 10180
> 11180
> 1 240
> 5 243
> 13240
> Where userid =xx , select count  where Superid=xx
> Please suggest the query.
> THANKS
> -Seema
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


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

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

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

2001-08-22 Thread Cale, Rick T (Richard)


Hi Traci,

There is no time frame from start to finish and as of yet Oracle has no
plans in retiring the Oracle 8i track.

Rick

-Original Message-
Sent: Wednesday, August 22, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L


Hello, does anyone know if there is a time limit on exams taken for the OCP
DBA 8i track?  More specifically, from when the first test is taken, do you
have to complete the others in a specified amount of time, say within 1
year?

Thanks
Traci


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

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

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

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

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

2001-08-22 Thread Paul Drake


Mark Marsden wrote:
> 
> Hi all
> 
> If I run dbverify on the system ts (or rbs ts AND on different dbs) I get
> the following:
> 
> DBVERIFY - Verification starting : FILE = /dpp/test01/HOUR/HOURsystem01.dbf
> Block Checking: DBA = 67108867, Block Type = Undo data block
> ERROR: Undo Block Corrupted.  Error Code = 2005
> ktu4ubck: Undo Record addr did not aligned to boundary
>   record number=1, addr=080d6392, aligned addr=080d6394
> UNDO BLK HEADER:
> xid: 0x.02f.0166  seq: 0x1c5 cnt: 0x24  irb: 0x24  icl: 0x0   flg:
> 0x
> 

see Note:118008.1 on Metalink.
DBV Report UNDO Corruption after Migrating V7.X to V8.X using Mig
Utility

the solution is to shrink the rollback segs, run u0703040.sql and force
DML to touch RBS's.

Paul

> Looks serious but the summary looks ok and the dbs seems ok.
> I tried it on a newly created db and don't get it and the dbverify docs say
> nothing.
> Should I be worried about this?
> 
> DBVERIFY - Verification complete
> 
> Total Pages Examined : 51200
> Total Pages Processed (Data) : 20271
> Total Pages Failing   (Data) : 0
> Total Pages Processed (Index): 7773
> Total Pages Failing   (Index): 0
> Total Pages Processed (Other): 4951
> Total Pages Empty: 18205
> Total Pages Marked Corrupt   : 0
> Total Pages Influx   : 0
> 
> Cheers for any feedback
> 
> Mark Marsden.
> 
> 
>
> Hyde Housing Association - Email Disclaimer
> 
> The information in this email is strictly confidential and may be legally privileged.
> 
> It is intended solely for the addressee only. Access to this email by anyone else is 
>unauthorised.
> If you are not the intended recipient and you have recieved this email in error you 
>must take no action
> on its contents, nor must you copy or show them to anyone, or make use of the 
>information therein.
> Please reply to the email immediately, or forward to [EMAIL PROTECTED], 
>highlighting
> the error and confirming that it has been deleted from your system.
> 
> SECURITY WARNING: Please note that this email has been created with the 
>knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and attachments 
>are free
> from any virus, we advise that in keeping with good computing practise the recipient 
>should ensure
> that they are actually virus free.
> 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Marsden
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Paul Drake
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread Brian McGraw


True, but now RedHat pushes it as the 'Red Hat Database'...

http://www.redhat.com/products/software/database/

Christopher Spence wrote:

> PostGresSQL has been out for years, and is not RedHat specific, all
> distributions have included it.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
> -Original Message-
> Sent: Tuesday, August 21, 2001 5:36 PM
> To: Multiple recipients of list ORACLE-L
>
> Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
> distribution, right up until the time they announced the availability of the
> Red Hat Database (PostgreSQL)?
>
> Brian
>
> Christopher Spence wrote:
>
> > I would be curious to see these tests going forward, seeing as RedHat
> > support is difficult to do with 9i and such.  And suse now being
> > Oracle's perfered linux.  I wonder if these results have changed.  I
> > never really played with Oracle on Linux, but if I ever had to, I
> > would be curious.
> >
> > "Do not criticize someone until you walked a mile in their shoes, that
> > way when you criticize them, you are a mile a way and have their
> > shoes."
> >
> > Christopher R. Spence
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> >
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >
> >
> > -Original Message-
> > Sent: Tuesday, August 21, 2001 1:53 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Lisa and others,
> >
> >  About a year ago, I was working for a company as a Linux systems
> > engineer (Read as: Tech guy doing sales support).  Most of our
> > customers wanted Linux systems, and it was my responsibility to
> > provide them the correct combination of Linux and hardware to meet
> > their needs.  I had an ISO 9002 compliance to maintain as I provided
> > testing and supporting data to our clients.
> >
> > My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have
> > the benchmarks any more, but it worked the best.
> >
> > SCO Unix was bought by Caldera Linux and is not yet being implemented
> > to the full capability (IMHO).
> >
> > Mandrake, SuSe, Storm were all tested as well,  And had less
> > satisfactory performance and reliability.
> >
> > Slackware 7 was the next best solution, followed by TurboLinux 6.
> >
> > All of these configurations were tested on the same machine,
> > completely formatted and the same installation performed on each test
> > cycle.
> >
> > I hope this is helpful information.
> >
> > Daniel Curry
> > Systems Administrator
> > CGtime, Inc.
> > 625 Second Street
> > Suite 201
> > San Francisco, CA 94107
> > ph: 415-348-6516
> > fx: 415-348-6505
> > cell: 510-304-7889
> >
> > -Original Message-
> > Sent: Tuesday, August 21, 2001 9:36 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Lisa
> >
> > SuSe is the best so I have been told. I am about to install 8i on 7.1
> > and another guy here is installing 9i on 7.2.
> >
> > Totally untested on my behalf as I haven't started yet but that is the
> > best I have been told.
> >
> > Probably of no use whatsoever !!!
> >
> > Lee
> > -Original Message-
> > Sent: 21 August 2001 16:51
> > To: Multiple recipients of list ORACLE-L
> > Sorry everyone, I know you were just discussing this recently. What is
> > the most stable combination of Oracle & Linux?  What would you
> > recommend?  I want to say the consensus was SCO Linux but I don't
> > quite remember. Thank you
> > Lara Croft
> > Oracle Database Administrator
> > Fairfield Resorts, Inc
> >
> >
> > The information contained in this communication is confidential, is
> > intended only for the use of the recipient named above, and may be
> > legally privileged. If the reader of this message is not the intended
> > recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited.
> > If you have received this communication in error, please
> > re-send this communication to the sender and delete the
> > original message or any copy of it from your computer
> > system.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Daniel Curry
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from).  You may also send
> > the HELP command for other information (like subsc

RE: Unix - performance tuning (vmstat 5)

2001-08-22 Thread Robertson Lee - lerobe


Thats certainly the way I would do it Iain.

Lee


-Original Message-
Sent: 22 August 2001 14:51
To: Multiple recipients of list ORACLE-L


Can't you just change your grep to additionally pipe into a "grep -v grep"
to exclude the "grep vmstat".

I'm sure all the unix gurus will give you a much better way but this should
work

-Original Message-
Sent: 22 August 2001 13:05
To: Multiple recipients of list ORACLE-L


Hi Unix Gurus,

I submit a job to monitor the CPU utilization etc every 15 mins using the
command vmstat 5.

How do I kill the submitted unix process of the batch job ? 

I tried to kill the submitted process using a batch job using the following
command :
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
kill $var_pid

This works if the output is 
$ ps -ef | grep vmstat
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat

If the output is as below, the program will not work 
$ ps -ef | grep vmstat
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5

Please help. Thanks in advance.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

RE: How do they get the answer?

2001-08-22 Thread kjanusz


I want to thank everyone who gave me input on this 
question.  It was most helpful.

Ken Janusz, CPIM
> um, I can see possible answers to this question being 2 teachers, 3 teachers 
> or 4 teachers.
> 
> however, since that isn't one of the multiple choice answers, then it has to 
> be "at least 4" since "only 2" is wrong
> 
> 
> >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: How do they get the answer?
> >Date: Tue, 21 Aug 2001 09:27:46 -0800
> >
> >two subjects in the "in" clause, times at least two teachers per subject
> >equals at least four records updated.
> >
> >sometimes it is easier to eliminate answers first.
> >like, you can throw out d) syntax will occur. and b) all teachers will get
> >an increase.
> >you are then left with a) two teachers and c). at least four teachers.
> >
> >Since the "where" clause is looking at the 'subject_id' column, rather than
> >the 'teacher_id' column, you can almost guess that it is c).
> >
> >hope this helps.
> >
> >Tom Mercadante
> >Oracle Certified Professional
> >
> >
> >-Original Message-
> >Sent: Tuesday, August 21, 2001 12:26 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I am taking the Self-Test software test for the SQL exam
> >and don't see how they get the answer to this problem.
> >They don't explain how it is arrived at.
> >
> >Any help you can give me will be appreciated.
> >
> >Thanks,
> >Ken Janusz, CPIM
> >
> >--
> >
> >Examine the structure of the TEACHER table:
> >
> >Name Null?   Type
> >ID   NOT NULLNUMBER(9)
> >SALARY   NUMBER
> >(7,2)
> >SUBJECT_ID   NOT NULLNUMBER(3)
> >SUBJECT_DESCRIPTION  VARCHAR2(2)
> >
> >There are 200 teachers and 15 subjects.  Each subject is
> >taught
> >by at least 2 teachers.
> >
> >Evaluate this PL/SQL block:
> >
> >DECLARE
> > v_pct_raise number := 1.10;
> >BEGIN
> > UPDATE  teacher
> > SET salary = salary * 1.10
> > WHERE   subject_id IN (102, 105);
> > COMMIT;
> >END;
> >
> >Which result will the PL/SQL block provide?
> >
> >(A) Only two teachers will receive a 10% salary increase.
> >(B) All of the teachers will receive a 10% salary
> >increase.
> >(C) At least four teachers will receive a 10% salary
> >increase.
> >(D) A syntax error will occur.
> >
> >Answer:
> >(C)
> >
> >
> >--
> >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: Mercadante, Thomas F
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> 
> 
> _
> 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: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

OK I HAVE DONE IT.........Re: URGENT PLEASE ! tns service deletion and recreation

2001-08-22 Thread Bunyamin K. Karadeniz




OK IU have done it . THANK YOU SO MUCH GURUS. 


Bunyamin 
.

  - Original Message - 
  From: 
  Danisment Gazi Unal (Unal Bilisim) 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, August 22, 2001 4:35 
  PM
  Subject: Re: URGENT PLEASE ! tns service 
  deletion and recreation
  Selam Bunyamin, 
  If you don't want to remove them by installer, you can remove by manually. 
  to remove( as I remember ), go to 
  registry: 
  - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services - 
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services - 
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services 
  to create: 
  - it's simple. just run "lsnrctl start" or "lsnrctlxx start". it will be 
  automacticly create your listener services. 
  "Bunyamin K. Karadeniz" wrote: 
  

OS: NT 4.0 I need to delete the TNS Listener service . and 
create a new one .How can I do that ? TIABunyamin

RE: Unix - performance tuning (vmstat 5)

2001-08-22 Thread Jaouich . Cyril

Title: RE: Unix - performance tuning (vmstat 5)





    I am not sure I understand you question correctly, but here is what I use when I want to kill some jobs ($BATCHJOB = name of the job to kill):

kill -9 `ps -ef|grep $BATCHJOB|awk '{print $2}'`


    If I want to kill all of one user's jobs:
su - user
kill -9 -1


    Cheers!


Cyril Jaouich (Conseiller Unix)
---
Centre de support informatique CSI
--
Tél 514-289-1122 x6237


--
De :    CHAN Chor Ling Catherine (CSC)[SMTP:[EMAIL PROTECTED]]
Répondre à :    [EMAIL PROTECTED]
Date :  mercredi 22 août 2001 08:05
A : Multiple recipients of list ORACLE-L
Objet : OT: Unix - performance tuning (vmstat 5)


Hi Unix Gurus,


I submit a job to monitor the CPU utilization etc every 15 mins using the
command vmstat 5.


How do I kill the submitted unix process of the batch job ? 


I tried to kill the submitted process using a batch job using the following
command :
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
kill $var_pid


This works if the output is 
$ ps -ef | grep vmstat
   orahrms 11271 11263  0 17:30:00 ?    0:00 vmstat 5
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat


If the output is as below, the program will not work 
$ ps -ef | grep vmstat
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
   orahrms 11271 11263  0 17:30:00 ?    0:00 vmstat 5


Please help. Thanks in advance.


Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]


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

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

RE: Performance analysis (enqueue and buffer busy waits)


To keep the rollback segments in buffer, so that rolling around the rollback
segments happens before blocks are written to disk.  Which will increase
snapshot to old, but increase performance.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 20, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L


I am curious.
What are you trying to accomplish by 
decreasing rollback segment size??

- Babette

-Original Message-
Lewis
Sent: Tuesday, August 14, 2001 6:52 PM
To: Multiple recipients of list ORACLE-L


Looking at your trace file, most of your lost time appears
to be in an update of F4211.

  UPDATE CRPDTA.F4211
SET SDRSDJ=:BND1,SDPPDJ=:BND2,
SDCARS=:BND3,SDMOT=:BND4,
SDFRTH=:BND5,SDUSER=:BND6,SDPID=:BND7,
SDJOBN=:BND8,SDUPMJ=:BND9,SDTDAY=  :BND10
WHERE  ( SDCDCD = :KEY1 )

9 seconds CPU, 283 seconds elapsed.

I doubt if freelists are your problem, but possibly the
lost time is initrans.  NB from 8.1.6 you can change
initrans  without rebuilding the table - which is good
if you don't have to go back to the old data and keep
doing the same concurrent updates.

There is no point in going above initrans = 20, but
you might push it up to 10. This may improve the
enqueue (TX mode 4?) problem, but if it does it
will probably make the log sync problem worse.

Try and swing more resources into DBWn -
increase LRU latches to start with, and
check whether async I/O, I/O slaves, or
multiple db_writers works best for you.

You may also want to review the size of
your log files (upwards), and your rollback
segments (downwards).


Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html


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

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

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

RE: sql query

2001-08-22 Thread Rooy van, Marco


select t1.userid, t1.superid, nvl(t2.count, 0) AS COUNT
  from onetable t1,
  (select superid, count(*) as count
 from onetable
group by superid) t2
 where t1.userid = t2.superid(+)
 order by superid;

Best regards,

Marco 

-Oorspronkelijk bericht-
Van: Seema Singh [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 22 augustus 2001 15:00
Aan: Multiple recipients of list ORACLE-L
Onderwerp: sql query


Hi
One table has following information
userid  superid
14  -1
4   0
8   2
9   2
15  2
24  4
16  4
25  4
6   5
7   5
26  5
2   16
18  16
10  18
11  18
1   24
5   24
13  24
I want the output in following format
userid  superidCOUNT
14  -10
4   0 3
8   2 0
9   2 0
15  2 0
24  4 3
16  4 2
25  4 0
6   5 0
7   5 0
26  5 0
2   163
18  162
10  180
11  180
1   240
5   243
13  240
Where userid =xx , select count  where Superid=xx
Please suggest the query.
THANKS
-Seema

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

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

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

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

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

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

RE: Unix - performance tuning (vmstat 5)

2001-08-22 Thread CHAN Chor Ling Catherine (CSC)


Hi Jaouich,

The command
kill `ps -ef | grep vmstat |awk '{print $2}'` 
works. Thanks a million.

Peter has also solved the problem for me by advising me to use vmstat 5 5
instead.

Regds,
New Bee in Unix
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 08/22/2001 10:21 PM

I am not sure I understand you question correctly, but here is
what I use when I want to kill some jobs ($BATCHJOB = name of the job to
kill):

kill -9 `ps -ef|grep $BATCHJOB|awk '{print $2}'` 

If I want to kill all of one user's jobs: 
su - user 
kill -9 -1 

Cheers! 

Cyril Jaouich (Conseiller Unix) 
--- 
Centre de support informatique CSI 
-- 
Tél 514-289-1122 x6237 

-- 
De :CHAN Chor Ling Catherine (CSC)[SMTP:[EMAIL PROTECTED]] 
Répondre à :[EMAIL PROTECTED] 
Date :  mercredi 22 août 2001 08:05 
A : Multiple recipients of list ORACLE-L 
Objet : OT: Unix - performance tuning (vmstat 5) 

Hi Unix Gurus, 

I submit a job to monitor the CPU utilization etc every 15 mins
using the 
command vmstat 5. 

How do I kill the submitted unix process of the batch job ? 

I tried to kill the submitted process using a batch job using
the following 
command : 
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )` 
kill $var_pid 

This works if the output is 
$ ps -ef | grep vmstat 
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5 
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat 

If the output is as below, the program will not work 
$ ps -ef | grep vmstat 
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat 
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5 

Please help. Thanks in advance. 

Regds, 
New Bee 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: CHAN Chor Ling Catherine (CSC) 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(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: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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

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

2001-08-22 Thread CHAN Chor Ling Catherine (CSC)


Thanks, Peter. U've just solved my problem.

Regds,
New Bee in Unix
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 08/22/2001 9:51 PM

Hi

Have a look at setting the second value with the vmstat command so you
use 
something like vmstat 5 5 instead. This runs vmstat 5 times with a 5
second 
interval
Try it on the command line and see if that  is the result you require


HTH

Peter

At 10:05 PM 22/08/2001, you wrote:
>Hi Unix Gurus,
>
>I submit a job to monitor the CPU utilization etc every 15 mins using
the
>command vmstat 5.
>
>How do I kill the submitted unix process of the batch job ?
>
>I tried to kill the submitted process using a batch job using the
following
>command :
>var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
>kill $var_pid
>
>This works if the output is
>$ ps -ef | grep vmstat
>orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
>orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
>
>If the output is as below, the program will not work
>$ ps -ef | grep vmstat
>orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
>orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
>
>Please help. Thanks in advance.
>
>Regds,
>New Bee
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Peter McLarty
  INET: [EMAIL PROTECTED]

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

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

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

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

Freeable memory Chunks

2001-08-22 Thread Dave Leach


Hi all,

When querying the view X$KSMSP can anyone tell me whether memory chunks with
a value in KSMCHCLS of 'freeabl' can be used immediately.  We currently have
an application running against our database which is causing the ORA-4031
error.  The app does not make use of shared sql and after flushing the
shared pool within a few minutes the shared pool summary looks like this:

CONTENTSCHUNKS RECREATABLE  FREEABLE TOTAL

 - --- - -

KGFF heap91336  4564  5900

KGK contexts 2  2376  2376

KGK heap 3   16996   560 17556

KGL handles  11305 2050328 2050328

KQLS heap   80   35360 45368 80728

LISTEN ADDRESS   2  1188  1188

PLS cca hp desc  1   164   164

PLS non-lib hp   120962096

character set m  6 31196 31196

dictionary cach 87127776127776

fixed allocatio 20 640 640

free memory   5126 1736532

joxs heap19292

kzull   28  1456  1456

library cache11695 1131164   4434300   5565464

listener addres  11616

permanent memor  8 5829368

row cache lru   2310121012

session param v 26 93288 93288

sql area 20517  842020  11812896  12654916

table columns   18   15736   15736 

In a few minutes the sql area has risen from 200 chunks to 20517.  It
appears that approx 12Mb of chunks associated to slq area are freeable, so
are these chunks usable in which case the error must be caused by the size
of the available chunks?

Many thanks for any replies,

Dave Leach


**
The above information is confidential to the addressee and may be 
privileged.  Unauthorised access and use is prohibited.

Internet communications are not secure and therefore this Company does
not accept legal responsibility for the contents of this message.

If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on
it, is prohibited and may be unlawful.

Claybrook Computing Limited is a subsidiary of 
Claybrook Computing (Holdings) Limited
Registered Office: Abbey House. 282 Farnborough Road, Farnborough,
Hampshire GU14 7NJ
Registered in England and Wales No 1287205

A Hogg Robinson plc company
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Leach
  INET: [EMAIL PROTECTED]

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

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


Yeah, the other thing, 6000 files which consist of 500Mb is about 10x slower
to download than 1 file which is 600Mb

The TCP protocol, ramps, which means, it gets up to speed within the first
few seconds of delivery, when your downloading many small files, your
bandwidth is cut down by 10 fold if not more.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Wednesday, August 22, 2001 10:17 AM
To: Multiple recipients of list ORACLE-L


You can download Suse, but you have over 6,000 files to download.  It's all
in a specific directory on there FTP server.

On the other hand, for RH you can just download a few ISO files and burn
them into CDs.  Easy.

I believe that Suse Personal, with CD and manuals, is 30 bucks.  I am
assuming that the personal version will run Oracle, since its seems the
Pro(70 bucks) version is for clustering, etc.

Chris

-Original Message-
Sent: Wednesday, August 22, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L


I've not really checked out Suse, you have to buy it versus being able to
get RH for free?

joe
Scott wrote:
> 
> I believe that Oracle has decided that when porting to
> linux all products will be ported to SuSE and then
> perform post release certifications on Redhat. I
> believe stability and support of multiple Linux
> distributions was a factor in this decision. I run
> both Redhat and SuSE and I actually perfer SuSE. SuSE
> has a lot of packages it distributes with there
> product. The only thing is the SuSE wont create ISO
> images for download and Redhat will.
> 
> Scott
> 
> --- Brian McGraw <[EMAIL PROTECTED]>
> wrote:
> > Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
> > distribution, right up until the time they announced
> > the availability of the Red
> > Hat Database (PostgreSQL)?
> >
> > Brian
> >
> > Christopher Spence wrote:
> >
> > > I would be curious to see these tests going
> > forward, seeing as RedHat
> > > support is difficult to do with 9i and such.  And
> > suse now being Oracle's
> > > perfered linux.  I wonder if these results have
> > changed.  I never really
> > > played with Oracle on Linux, but if I ever had to,
> > I would be curious.
> > >
> > > "Do not criticize someone until you walked a mile
> > in their shoes, that way
> > > when you criticize them, you are a mile a way and
> > have their shoes."
> > >
> > > Christopher R. Spence
> > > Oracle DBA
> > > Phone: (978) 322-5744
> > > Fax:(707) 885-2275
> > >
> > > Fuelspot
> > > 73 Princeton Street
> > > North, Chelmsford 01863
> > >
> > >
> > > -Original Message-
> > > Sent: Tuesday, August 21, 2001 1:53 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > Lisa and others,
> > >
> > >  About a year ago, I was working for a company
> > as a Linux systems
> > > engineer (Read as: Tech guy doing sales support).
> > Most of our customers
> > > wanted Linux systems, and it was my responsibility
> > to provide them the
> > > correct combination of Linux and hardware to meet
> > their needs.  I had an ISO
> > > 9002 compliance to maintain as I provided testing
> > and supporting data to our
> > > clients.
> > >
> > > My first test was RedHat linux 6.1 with Oracle
> > 8.1.5.  I don't have the
> > > benchmarks any more, but it worked the best.
> > >
> > > SCO Unix was bought by Caldera Linux and is not
> > yet being implemented to the
> > > full capability (IMHO).
> > >
> > > Mandrake, SuSe, Storm were all tested as well,
> > And had less satisfactory
> > > performance and reliability.
> > >
> > > Slackware 7 was the next best solution, followed
> > by TurboLinux 6.
> > >
> > > All of these configurations were tested on the
> > same machine, completely
> > > formatted and the same installation performed on
> > each test cycle.
> > >
> > > I hope this is helpful information.
> > >
> > > Daniel Curry
> > > Systems Administrator
> > > CGtime, Inc.
> > > 625 Second Street
> > > Suite 201
> > > San Francisco, CA 94107
> > > ph: 415-348-6516
> > > fx: 415-348-6505
> > > cell: 510-304-7889
> > >
> > > -Original Message-
> > > Sent: Tuesday, August 21, 2001 9:36 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > Lisa
> > >
> > > SuSe is the best so I have been told. I am about
> > to install 8i on 7.1 and
> > > another guy here is installing 9i on 7.2.
> > >
> > > Totally untested on my behalf as I haven't started
> > yet but that is the best
> > > I have been told.
> > >
> > > Probably of no use whatsoever !!!
> > >
> > > Lee
> > > -Original Message-
> > > Sent: 21 August 2001 16:51
> > > To: Multiple recipients of list ORACLE-L
> > > Sorry everyone, I know you were just discussing
> > this recently.
> > > What is the most stable combination of Oracle &
> >

RE: High DML Table - Suggestions??


Partitioning, Parallel Query.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L


I have a big table too, about 16GB.
It is a vert static one(customer table), will add data

once in it, but queried all the time, and do the
segmentations against it all the time.

It also has 12 indexes. Right now , the performance is
ok. Any special consideration for such a big table.

Thanks,

Harvest.

--- Christian Trassens <[EMAIL PROTECTED]> wrote:
> Don't put it in a buffer keep because of the amount
> of
> consistent gets the table could have. It seems to be
> a
> high volatile table.
> 
> Maybe it is too late but you should look on the
> initrans, freelist of the table. Also if the table
> has
> foreign keys, talk with Development to leave the
> table
> without them. I should consider to partition the tablemaybe a hash 
> one.
> 
> Regards.
> 
> 
> --- Walter K <[EMAIL PROTECTED]> wrote:
> > Hi,
> > 
> > I have a table that is going to have a large
> amount
> > of
> > inserts, updates and deletes performed against it
> > daily. Approximately 1,000,000 transactions per
> day
> > (some single-record, some multi-record). The table
> > is
> > ~100Mb in size.
> > 
> > I'm looking for some suggestions on what I can do
> to
> > have the most optimal I/O for the table. I've been
> > doing a little reading about buffer pools. Is
> > assigning this table to a KEEP pool a practical
> > approach or is that not going to buy me anything
> > because DML is involved? Does anyone have any
> other
> > suggestions?
> > 
> > Unfortunately, I can't put the table on a
> dedicated
> > disk and I am stuck with Raid-5 currently.
> > 
> > Any suggestions would be appreciated.
> > 
> > Thanks in advance!
> > -w
> > 
> > __
> > 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: Walter K
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

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

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

OCP Test timeframe

2001-08-22 Thread Traci Rebman


Hello, does anyone know if there is a time limit on exams taken for the OCP DBA 8i 
track?  More specifically, from when the first test is taken, do you have to complete 
the others in a specified amount of time, say within 1 year?

Thanks
Traci


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

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

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

2001-08-22 Thread Farnsworth, Dave




http://technet.oracle.com/index.html
 
Also 
get the book Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James 
Viscusi.  It is an excellent book to start with!
 
 
Dave

  -Original Message-From: Ha Duy Thien 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 9:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Please help me to become DBA
  Hi Gurus 
   
  Thanks you so much for reading my 
  problem.
   
  I am a new oracle user and I really interested in 
  exploring this product.
   
  In fact I want to know it clearly and can control 
  it in the future. 
  Someone has said to me that it's better 
  to become a DBA but it seems very difficult for me
   
  If you don't mind, please show me which steps I 
  should take first and which books or which websites I can read.
   
  In this forum I find many thing interesting. You 
  are very experienced
   
  Best regards,
   
  ThienHD

RE: linux & Oracle -- best combination

2001-08-22 Thread Grabowy, Chris


You can download Suse, but you have over 6,000 files to download.  It's all
in a specific directory on there FTP server.

On the other hand, for RH you can just download a few ISO files and burn
them into CDs.  Easy.

I believe that Suse Personal, with CD and manuals, is 30 bucks.  I am
assuming that the personal version will run Oracle, since its seems the
Pro(70 bucks) version is for clustering, etc.

Chris

-Original Message-
Sent: Wednesday, August 22, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L


I've not really checked out Suse, you have to buy it versus being able
to get RH for free?

joe
Scott wrote:
> 
> I believe that Oracle has decided that when porting to
> linux all products will be ported to SuSE and then
> perform post release certifications on Redhat. I
> believe stability and support of multiple Linux
> distributions was a factor in this decision. I run
> both Redhat and SuSE and I actually perfer SuSE. SuSE
> has a lot of packages it distributes with there
> product. The only thing is the SuSE wont create ISO
> images for download and Redhat will.
> 
> Scott
> 
> --- Brian McGraw <[EMAIL PROTECTED]>
> wrote:
> > Correct me if I'm wrong, but wasn't Red Hat Oracle's
> > preferred Linux
> > distribution, right up until the time they announced
> > the availability of the Red
> > Hat Database (PostgreSQL)?
> >
> > Brian
> >
> > Christopher Spence wrote:
> >
> > > I would be curious to see these tests going
> > forward, seeing as RedHat
> > > support is difficult to do with 9i and such.  And
> > suse now being Oracle's
> > > perfered linux.  I wonder if these results have
> > changed.  I never really
> > > played with Oracle on Linux, but if I ever had to,
> > I would be curious.
> > >
> > > "Do not criticize someone until you walked a mile
> > in their shoes, that way
> > > when you criticize them, you are a mile a way and
> > have their shoes."
> > >
> > > Christopher R. Spence
> > > Oracle DBA
> > > Phone: (978) 322-5744
> > > Fax:(707) 885-2275
> > >
> > > Fuelspot
> > > 73 Princeton Street
> > > North, Chelmsford 01863
> > >
> > >
> > > -Original Message-
> > > Sent: Tuesday, August 21, 2001 1:53 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > Lisa and others,
> > >
> > >  About a year ago, I was working for a company
> > as a Linux systems
> > > engineer (Read as: Tech guy doing sales support).
> > Most of our customers
> > > wanted Linux systems, and it was my responsibility
> > to provide them the
> > > correct combination of Linux and hardware to meet
> > their needs.  I had an ISO
> > > 9002 compliance to maintain as I provided testing
> > and supporting data to our
> > > clients.
> > >
> > > My first test was RedHat linux 6.1 with Oracle
> > 8.1.5.  I don't have the
> > > benchmarks any more, but it worked the best.
> > >
> > > SCO Unix was bought by Caldera Linux and is not
> > yet being implemented to the
> > > full capability (IMHO).
> > >
> > > Mandrake, SuSe, Storm were all tested as well,
> > And had less satisfactory
> > > performance and reliability.
> > >
> > > Slackware 7 was the next best solution, followed
> > by TurboLinux 6.
> > >
> > > All of these configurations were tested on the
> > same machine, completely
> > > formatted and the same installation performed on
> > each test cycle.
> > >
> > > I hope this is helpful information.
> > >
> > > Daniel Curry
> > > Systems Administrator
> > > CGtime, Inc.
> > > 625 Second Street
> > > Suite 201
> > > San Francisco, CA 94107
> > > ph: 415-348-6516
> > > fx: 415-348-6505
> > > cell: 510-304-7889
> > >
> > > -Original Message-
> > > Sent: Tuesday, August 21, 2001 9:36 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > Lisa
> > >
> > > SuSe is the best so I have been told. I am about
> > to install 8i on 7.1 and
> > > another guy here is installing 9i on 7.2.
> > >
> > > Totally untested on my behalf as I haven't started
> > yet but that is the best
> > > I have been told.
> > >
> > > Probably of no use whatsoever !!!
> > >
> > > Lee
> > > -Original Message-
> > > Sent: 21 August 2001 16:51
> > > To: Multiple recipients of list ORACLE-L
> > > Sorry everyone, I know you were just discussing
> > this recently.
> > > What is the most stable combination of Oracle &
> > Linux?  What would you
> > > recommend?  I want to say the consensus was SCO
> > Linux but I don't quite
> > > remember.
> > > Thank you
> > > Lara Croft
> > > Oracle Database Administrator
> > > Fairfield Resorts, Inc
> > >
> > >
> > > The information contained in this communication is
> > confidential, is intended
> > > only for the use of the recipient named above, and
> > may be legally
> > > privileged. If the reader
> > > of this message is not the intended recipient, you
> > are
> > > hereby notified that any dissemination,
> > distribution or
> > > copying of this communication is strictly
> > prohibited.
> > > If you have received this communication in error,
> > please
> > > re-se

tns service error

2001-08-22 Thread Bunyamin K. Karadeniz




 I am getting the below error where I run STAT 
or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is also 
below.
Why is that ?
Note : I can remotely connect to this database from 
client.
 
 
Connecting to 
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no 
listener TNS-12560: TNS:protocol adapter error  TNS-00511: No 
listener   32-bit Windows Error: 2: No such file or 
directoryConnecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))TNS-12545: 
Connect failed because target host or object does not exist TNS-12560: 
TNS:protocol adapter error  TNS-00515: Connect failed because target 
host or object does not exist   32-bit Windows Error: 49: Unknown 
error
 
In My listener file  below are 
written.
LISTENER =  (DESCRIPTION_LIST 
=    (DESCRIPTION =  
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 1521))    
)    (DESCRIPTION =  
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 2481))    
)  )
 
SID_LIST_LISTENER =  (SID_LIST 
=    (SID_DESC =  
(GLOBAL_DBNAME = UYAPBUN.havelsan.com.tr)  
(ORACLE_HOME = D:\ORACLE\ORA817)  (SID_NAME = 
UYAPBUN)    )  )

Re: OT: Unix - performance tuning (vmstat 5)

2001-08-22 Thread Peter McLarty


Hi

Have a look at setting the second value with the vmstat command so you use 
something like vmstat 5 5 instead. This runs vmstat 5 times with a 5 second 
interval
Try it on the command line and see if that  is the result you require


HTH

Peter

At 10:05 PM 22/08/2001, you wrote:
>Hi Unix Gurus,
>
>I submit a job to monitor the CPU utilization etc every 15 mins using the
>command vmstat 5.
>
>How do I kill the submitted unix process of the batch job ?
>
>I tried to kill the submitted process using a batch job using the following
>command :
>var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
>kill $var_pid
>
>This works if the output is
>$ ps -ef | grep vmstat
>orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
>orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
>
>If the output is as below, the program will not work
>$ ps -ef | grep vmstat
>orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
>orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
>
>Please help. Thanks in advance.
>
>Regds,
>New Bee
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Peter McLarty
  INET: [EMAIL PROTECTED]

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

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

RE: Unix - performance tuning (vmstat 5)

2001-08-22 Thread Nicoll, Iain (Calanais)


Can't you just change your grep to additionally pipe into a "grep -v grep"
to exclude the "grep vmstat".

I'm sure all the unix gurus will give you a much better way but this should
work

-Original Message-
Sent: 22 August 2001 13:05
To: Multiple recipients of list ORACLE-L


Hi Unix Gurus,

I submit a job to monitor the CPU utilization etc every 15 mins using the
command vmstat 5.

How do I kill the submitted unix process of the batch job ? 

I tried to kill the submitted process using a batch job using the following
command :
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
kill $var_pid

This works if the output is 
$ ps -ef | grep vmstat
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat

If the output is as below, the program will not work 
$ ps -ef | grep vmstat
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5

Please help. Thanks in advance.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-08-22 Thread Ray Stell




the STIME is always earlier for the command then for the grep, unless
I haven't had any coffee.



On Wed, Aug 22, 2001 at 04:05:24AM -0800, CHAN Chor Ling Catherine (CSC) wrote:
> Hi Unix Gurus,
> 
> I submit a job to monitor the CPU utilization etc every 15 mins using the
> command vmstat 5.
> 
> How do I kill the submitted unix process of the batch job ? 
> 
> I tried to kill the submitted process using a batch job using the following
> command :
> var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
> kill $var_pid
> 
> This works if the output is 
> $ ps -ef | grep vmstat
>orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
>orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
> 
> If the output is as below, the program will not work 
> $ ps -ef | grep vmstat
>orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
>orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
> 
> Please help. Thanks in advance.
> 
> Regds,
> New Bee
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

RE: linux & Oracle -- best combination