BEQ used for remote connections

[Rahul]

List,
i'm a bit confused when looked at the ps -eaf |grep BEQ in my AIX
one of the connection was using BEQ protocol, but the session was zremote !!

(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)

my understanding of BEQ was that it makes use of unix pipes to connect, and
is
used for local+dedicated connections !!

then i looked at the tnsnames.ora of the client... and found out that the
port was
listed as 1525 (and the listener was NOT listening on that port) 

conclusion 
if the client cannot connect to listed port...it uses BEQ to connect ? 

Regards

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

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

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

Re: Index question ???

[Jared Still]

First off, a disclaimer.

It's late, and I'm tired, and my soon to be
martini is beckoning.  

So I'm worn out, and anxious.

Remember, this advice is a free service.  :)

Forget the 4% number.  It's meaningless.  What you have to
be concerned with is 'will using the index cause me to read
more blocks than if I just do a full table scan?'.

tkprof and explain plan can help you with that.

Personally, I would build the index, analyze all tables
and indexes, and build histograms for cases where I know
the queried data is skewed, such as yours appears to be.

The point is, give the cost based optimizer all the 
information it needs, and let it sort it out.

Jared

On Tuesday 14 August 2001 13:41, Janet Linsy wrote:
> Hi all,
>
> According to Oracle's doc, for a table > 1000 rows, if
> the query returns < 4% of the data, an index can be
> built.
>
> If I have a table, with ID 1,2, 3 return < 4% of the
> row, but ID 4, 5, 6 returns > 4% rows.  Should I build
> an index on ID column?
>
> Also you know any general guildlines for building, not
> building indexes?  OEM generates suggestions too,
> should I follow?
>
> Thanks you!
>
> Janet
>
> __
> 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: 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).

Checking if Oracle Connection still valid

[Yusron Hilmy]

Hi All,

I am using OCI to build my oracle application.
In OCI, how I can check if oracle connection/session is still valid ? like
dbdead() in MSSQL.

Thanks,
Yusron

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 can I get my DB back if I lost one of my rollback segment

[Hermanto P]

Thanks Rachel,
What I meant is, actually I do the cold backup. I do it by the script.
Before the backup processing/running, I made a new rollback segment which I
miss to add the name into the script. So, when I do the backup, this
rollback did not recorded.
Further, I experimenting with other thing in application. Since I got the
problem, I want to restore the old backup. But after I restore, I can not
startup Oracle DB successfully.

svrmgrl
SVRMGR>connect internal
Connected to an idle instance
SVRMGR>startup;
ORACLE instance started.
Total System Global Area17950752 bytes
Fixed Size38987 bytes
Variable Size   111845589 bytes
Database Buffers 65764666 bytes
Redo Buffers   1564323 bytes
Database mounted.
ORA-01122 : database file 14 failed verification check
ORA-01110 : data file 14: '/data_dev/cybprod/rbs02.dbf'
ORA-01207: file is more recent than control file - old control file


Warm Regards,

Hermanto P
Application Engineer
PT Riau Andalan Pulp And Paper - IT/IS Dept.
Phone : (0761) - 491147 / 491354
HP: 0812-752-3092
"Dream as if you'll live forever, live as if you'll die today"




-Original Message-
Sent: Tuesday, August 14, 2001 08:41 PM
To: Multiple recipients of list ORACLE-L
segment (rb


Hermanto,

some more information would be helpful -- why are you restoring? are you 
restoring from a cold or hot backup?

if it was from a cold backup, you can comment out the rollback_segments 
parameter in the init.ora and start the database. Then I would drop the 
rollback tablespace and recreate it, with the rollback segments you want. 
Then change the init.ora and shutdown and restart the database

Rachel

>From: Hermanto P <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: How can I get my DB back if I lost one of my rollback segment (rb
>Date: Tue, 14 Aug 2001 00:35:21 -0800
>
>Hi gurus,
>Recently, I have forgotten to backup one of rollback segment file
>(rbs02.dbf).
>When I want to restore..the db can not startup normally.
>Anyone can give me advise..
>Thanks in advance.
>
>Warm regards,
>Hermanto
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hermanto P
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Hermanto P
  INET: [EMAIL PROTECTED]

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

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

Re: RMAN cold backup?

[JOE TESTA]

Sure:  run {   and last line of }  
required parts
  allocate channel ch1 type disk;  <-  you 
must tell rman what media to put backups, and allocate it
  set limit <-  tell how big each piece should 
be, 1.9G here
  backup <- do a backup, incremental level 0  
<= type of backup incremental, level 0, meaning do all data 
blocks
  tag <- internal name that you can query the rman 
catalog with.
  format <-  where to put the files and what to 
call them
  database <- end of backup keyword
 
look at docs for backup/recovery, this is one of the most 
elementary scripts, there is alot motre to it.
 
joe
 
  
run {allocate channel ch1 type disk;set limit channel 
ch1 kbytes = 190;backup incremental level 0tag = 
'dssmnt02_inc_0'format 
'/ora_export/export/tmp/dssmnt02_inc_0_%U'database;}
 
>>> [EMAIL PROTECTED] 08/14/01 09:35PM 
>>>Hi Joe,I'm currently looking at RMAN as a backup and 
recovery tool to automate backups to disk. I would appreciate it very much 
if you could describe what each line of your script does.I'd have to do 
Hot Backups though.Would this script have to change?Thanks in 
advance,Denmark Weatherburne"Knowledge is power, but it is only 
useful if it is shared">From: "JOE TESTA" 
<[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: 
Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>>Subject: Re: RMAN cold backup?>Date: 
Tue, 14 Aug 2001 14:51:42 -0800>>cold backup in the respect that 
the db has to be mounted but not open.>>here is an example(since 
we're in noarchivelogmode, its our only choice).  >this is an 
incremental level 0, which is all.>>hth, joe>>run 
{>allocate channel ch1 type disk;>set limit channel ch1 kbytes = 
190;>backup incremental level 0>tag = 
'dssmnt02_inc_0'>format 
'/ora_export/export/tmp/dssmnt02_inc_0_%U'>database;>} 
>>> [EMAIL PROTECTED] 08/14/01 05:53PM 
>I'm frantically R'ing TFM, but I can't find the 
answer to a simple >question:  Can I use RMAN to perform a cold 
backup?  If so, how?  TIA!>>Paul 
Baumgartel>MortgageSight Holdings, 
LLC>[EMAIL PROTECTED]_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-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).

rman/standby

[Ravindra Basavaraja]

I have configured a standby database operating in "manual mode" for our
production database.
I will have to apply the archive logs manually for the standby database.

The Archive logs that are genarated on the production server is backed up by
RMAN/netbackup and deleted after the backup.I have the stopped the deletion
of archive files from the RMAN script.

I want to find the best way of getting both RMAN/netbackup to happen and
also delete
the archive logs.But before they are deleted they need to be copied to a
seperate
directory so that I can apply those backed up files to the standby
database.I want to
make sure that I don't loose any of the archive files that the standby
database needs
to be in sync with the production database inclucing the current archive
logs that
may be backed up on the production database.

The rman script is like this
run {
allocate channel t1 type 'SBT_TAPE';
backup
  incremental level 1
  tag Dialy_Incremental_Backup_Level1
  filesperset 5
  format 'Data_%d_%s_%p_%t'
(database);
  sql 'alter system archive log current';
backup
  filesperset 20
  format 'Arch_%d_%s_%p_%t'
#  (archivelog all delete input);
   (archivelog all);
}

How do I do it.?

Thanks
Ravindra

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

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

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

Re: RMAN cold backup?

[Denmark Weatherburne]

Hi Joe,

I'm currently looking at RMAN as a backup and recovery tool to automate 
backups to disk. I would appreciate it very much if you could describe what 
each line of your script does.
I'd have to do Hot Backups though.
Would this script have to change?

Thanks in advance,

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


>From: "JOE TESTA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: RMAN cold backup?
>Date: Tue, 14 Aug 2001 14:51:42 -0800
>
>cold backup in the respect that the db has to be mounted but not open.
>
>here is an example(since we're in noarchivelogmode, its our only choice).  
>this is an incremental level 0, which is all.
>
>hth, joe
>
>run {
>allocate channel ch1 type disk;
>set limit channel ch1 kbytes = 190;
>backup incremental level 0
>tag = 'dssmnt02_inc_0'
>format '/ora_export/export/tmp/dssmnt02_inc_0_%U'
>database;
>}
>
>
>
> >>> [EMAIL PROTECTED] 08/14/01 05:53PM >>>
>
>I'm frantically R'ing TFM, but I can't find the answer to a simple 
>question:  Can I use RMAN to perform a cold backup?  If so, how?  TIA!
>
>Paul Baumgartel
>MortgageSight Holdings, LLC
>[EMAIL PROTECTED]


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

NYOUG

[Rachel Carmichael]

wish we could... we are not setup to record the presentations. One of these 
years, when we become a rich users group (or is that an oxymoron?)

Hey, I'm lucky I can persuade people to give me the slides and papers... 
there are a few people on this list who still owe me one or the other or 
both of those (You know who you are, don't make me send the cats out after 
you!)

Rachel


>From: "Post, Ethan" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 14:31:06 -0800
>
>Can someone encode the audio... :)
>
> >-Original Message-
> >From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, August 14, 2001 1:27 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: OT -- training
> >
> >
> >Each Presenter gets a 45-60 minute slot. Okay, Gaja gets two,
> >he needs that
> >much :)
> >
> >Papers (if I can coerce, er, persuade the presenters to create
> >one) go up on
> >the website. Slides will definitely be there.
> >
> >Should be lots of fun... I do love living in NY!
> >
> >>From: "Ron Rogers" <[EMAIL PROTECTED]>
> >>Reply-To: [EMAIL PROTECTED]
> >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >>Subject: RE: OT -- training
> >>Date: Tue, 14 Aug 2001 11:41:41 -0800
> >>
> >>Rachel,
> >>I hope you have a lot of time set aside for the presentors.
> >It sounds like
> >>a great cast to listen to and a hard act to follow. A small note:  I
> >>attended a seminar presented by Mike Ault and Rich Niemiec
> >about the new 9i
> >>database. There was not enough time in the evening to cover
> >it completely.
> >>Both speakers lived up to expectations and could have filled
> >an additional
> >>3 hours if given time.
> >>  I only wish that I was closer and able to attend. Will
> >their papers be on
> >>the website after the meeting?
> >>Thanks,
> >>ROR mª¿ªm
> >>
> >> >>> [EMAIL PROTECTED] 08/14/01 02:37PM >>>
> >>Yep, I got lucky, and called on a lot of people I know.
> >>
> >>For those of you lost in this semi-private conversation, the
> >NYOUG meeting
> >>on September 12th (and yes, non-members are welcome) is being
> >called the
> >>"Literary Lights" meeting.
> >>
> >>presenters include: our own Gaja Krishna Vaidyanatha and Ari
> >Kaplan, Rich
> >>Niemiec, Kevin Loney, Marlene Theriault, Douglas Scherer, John
> >>Beresniewicz,
> >>Ulka Rodgers and Paul Dorsey.
> >>
> >>oh yeah, I'll be hanging out there. But I had so many great
> >presenters I
> >>had
> >>to bump myself off the agenda :)
> >>
> >>check it out, www.nyoug.org
> >>
> >>
> >>
> >>
> >> >From: "Miller, Jay" <[EMAIL PROTECTED]>
> >> >Reply-To: [EMAIL PROTECTED]
> >> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >> >Subject: RE: OT -- training
> >> >Date: Tue, 14 Aug 2001 09:00:37 -0800
> >> >
> >> >Pretty amazing actually.  I won't feel so bad about missing
> >the cruise
> >>this
> >> >year :-( If I get get to attend this one.
> >> >
> >> >Jay Miller
> >> >
> >> >
> >> >-Original Message-
> >> >Sent: Monday, August 13, 2001 10:21 PM
> >> >To: Multiple recipients of list ORACLE-L
> >> >
> >> >
> >> >
> >> > >On the other hand, I can take the day off for the NY
> >Users Group when
> >> >there
> >> >
> >> > >aren't any emergencies (about 50% of the time).
> >> > >
> >> > >
> >> > >Jay Miller
> >> > >
> >> >
> >> >
> >> >try not to have any emergencies on September 12th :)   it's
> >gonna be a
> >>good
> >> >one!
> >> >
> >> >Rachel
> >> >
> >> >_
> >> >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: 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 cont

RE: OT -- training

[Rachel Carmichael]

yes it qualifies. but as pointed out earlier in this thread, it goes into 
the Schedule A AFTER you have deducted a percentage of your income from the 
total of expenses.

In general, you need a LOT of business expenses to make it worth trying to 
deduct them as an individual


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 13:41:04 -0800
>
>Speaking about progressing in your current field wouldn't technical 
>training
>of dba qualify for a tax break under the same category as training for FAA
>ground instructor?  Otherwise, your FAA ground instructor registered as a
>private business (and we're back to the beginning of our discussion).
>Doesn't surprise me neither does it make me jealous.  There are so many
>different career decisions you can make.  I like being a dba..
>Btw, I am pretty sure you can write off your technical book fees even as an
>individual..
>-Original Message-
>Sent: Tuesday, August 14, 2001 4:54 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Appearances to the contrary, Canada is a separate country with their own
>tax laws.
>
>However, the tax dodge that you mention is common here too.
>
>Here's a really good one -- become a Certified FAA Ground Instructor.  You
>teach people how to pass the FAA ground exam.  Since it's not life
>threatening, it's relatively simple to get this certificate.  Then get a
>student or two.  After that you can buy an airplane.  The airplane, the gas
>to fly it, the maintenance and hangering of the airplane, the cost of
>getting the experience necessary to become a Certified Flight Instructor
>(CFI), books, aircraft simulator software, landing fees, even the cost of
>overnight lodging in some cases, instructors' fees (in short, a whole ton
>of things that make flying a hobby for the rich) become tax deductable
>because they are helping you progress in your field as an instructor.  The
>IRS does not allow you to deduct training that qualifies you for a new
>field but it does allow you to deduct training that allows you to progress
>in your current field.  Because of the FAA requirements for becoming a CFI
>almost anything having to do with flying will count as "training".
>
>
>
>
>
> "Boivin, Patrice
>
> J"   To: Multiple recipients 
>of
>list ORACLE-L
> <[EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> mpo.gc.ca>   cc:
>
> Sent by: Subject: RE: OT -- 
>training
>
> [EMAIL PROTECTED]
>
>
>
>
>
> 08/14/2001 04:17
>
> PM
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>I know in Canada that some high-paid executives have "farms" in rural areas
>(ahem, cottages really) where they grow forage, seed, or raise a couple of
>sheep, rabbits, a few pigs, some chickens, or one cow.  All for tax
>deductions of course.  It helps if the farm is near a lake.
>
>Another good one is "horse farm".  There is a particularly big one in
>Ontario that specializes in horse racing... and never makes a profit.  Ha
>ha
>ha ha ha ha...
>
>This is my opinion, of course.  But I saw many of these when I used to
>enter
>farm tax records for Statistics Canada years ago.
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>  -Original Message-
>  From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
>  Sent: Tuesday, August 14, 2001 3:44 PM
>  To:  Multiple recipients of list ORACLE-L
>  Subject:  RE: OT -- training
>
>  I guess that we'll let the IRS sort this one out.  Your friend is
>probably
>  right and I was probably overly emphatic when I said that you MUST
>show a
>  profit sometime.  But I would rather not leave it up to the IRS to
>decide
>  whether it is a business or a hobby.
>
>
>
>
>  "Post, Ethan"
>
>  <[EMAIL PROTECTED]To: Multiple recipients
>of list ORACLE-L
>  m>   <[EMAIL PROTECTED]>
>
>  Sent by: cc:
>
>  root@fatcity.Subject: RE: OT --
>training
>  com
>
>
>
>
>
>  08/14/2001
>
>  01:17 PM
>
>  Please
>
>  respond to
>
>  ORACLE-L
>
>
>
>
>
>
>
>
>
>  Actually I talked to a friend who is pretty knowlegable about this
>stuff
>  and
>  he says that what it will really come down to is intent.  The IRS is
>not
>  going to call your business a hobby if it is in fact unquestionably
>a
>  business, even if it has lost money for a period of years. - E
>
>  >-Original Message-
>  >Fro

Set-up layout config to impl PeopleSoft on Oracle HP platform

[Townsend Willie]

Guru List,

Does anyone have any documentation or recommendations for setting up Oracle
to run the PeopleSoft application on HP9000 64 bit, such as layout of files,
init parms, initial and next extents, tuning parameters etc?

Any help is appreciated!

Willie 

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

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

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

Re: Datafile Migration Tool

[Scott Shafer]

> Sounds good.  I should have written "export, ftp, import" instead of just
> import.  I can see the mount point issues being a real problem.
> 
> --Scott
> 
> - Original Message -
> From: "K Gopalakrishnan" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 14, 2001 4:53 PM
> Subject: Re: Datafile Migration Tool
> 
> 
> > FTP just transfers the file (either binary or text) to the target OS
> > and that file can not be opened by the Oracle running in the target
> > machine.
> >
> > Beacuse each OS will have different file formats and Oracle running in
> > differenct OSs will use  differnet system calls /APIs to CRUD (Create
> > Replace Update Delete) the files.
> >
> > Here if you take an NT-oracle  data file to Unix oracle , this file is
> > a junk data according to unix-oracle. But if you covert that file to
> > unix format using the tool, your unix-oracle will/can/may read that
> > file and straight away you can open the database..
> >
> > Hope this clarifiesd the confusion..!!
> >
> >
> > --- Scott Shafer <[EMAIL PROTECTED]> wrote:
> > > Not to be a smartass, but don't most OS's already have ftp built in?
> > > What kind of value-added are you proposing?  Just curious...
> > >
> > > Scott Shafer
> > > San Antonio, TX



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

Set-up layout config to impl PeopleSoft on Oracle HP platform

[Townsend Willie]

Guru List,

Does anyone have any documentation or recommendations for setting up Oracle
to run the PeopleSoft application on HP9000 64 bit, such as layout of files,
init parms, initial and next extents, tuning parameters etc?

Any help is appreciated!

Willie 

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

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

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

Re: Netbackup with Oracle 817

[Stephen Andert]

Nbir, 
 
Well I'm no expert on backups, but we are in the process of rolling out 
rman and Veritas Netbackup across our company.  This includes several 
databases that are well over 200GB.  We have an ATL (Automated Tape 
Library) with around 300 slots and currently 10 drives.  We are having 
some, as yet undetermined, "issues" with NetBackup taking drives 
offline.  The rman piece seems to be working when the NetBackup piece 
cooperates.  
 
We are also working out differences between different dbas with regards to 
backup philosophy.  For example, rman does not need to shut the database 
down to get a "good" backup.  For some of us, this was difficult to 
comprehend how you can get a consistent backup while the database is up and 
running.  Also, different groups have different practices on how many 
archived redo logs to keep.  With rman, we are trying to standardize on 
length of time to keep them after they are backed up.
 
I haven't been involved with the script-writing pice, so I can't help you 
there, but I hope to get my hands a bit more dirty with B&R after I pass my 
performance tuning test.
 
Good Luck
Stephen>>> [EMAIL PROTECTED] 08/14/01 02:53PM 
>>>Hi Experts,Can somebody guide me towards Oracle database 
backupof around 200G with Netbackup and I really appreciateany document 
for Rman Scripts/Backup document likerestore or other test scenario. 
I know lots of big company has implemented it and I amtold to submit 
mine document in a week and sodesperately need all of ur advice and very 
greatfullif someone can help me all test scenario plus scriptThanks 
a ton in advanceNbir

Splitting a database: pro and cons

[Djordje Jankovic]

Hi list,

I have two applications running against one database (in fact I have a few
but for the sake of this question two are enough).  The two apps have
different upgrade patterns and I would like to split them in two databases
that will be on the same unix server.  There are some views that are used
extensively that join data from both apps/schemas, and after the split those
should be made using db links.  I did some tests and comparisons of queries
going through links versus running them directly on the database, and did
not see a lot of difference. 

Does anybody see or know of any downside in splitting the database in two
:-(.  And any advantage :-).  What is the general strategy when installing
different apps (from different vendors) - put them on separate databases or
combining them.

Thanks.

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

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

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

RE: Splitting a database: pro and cons

[Djordje Jankovic]

Just to add, something I forgot to say - there are no foreign keys across
apps (one app is just reading other app's data) - so that is not the
problem.

Thanks.

Djordje

> -Original Message-
> From: Djordje Jankovic 
> Sent: Tuesday, August 14, 2001 5:52 PM
> To: '[EMAIL PROTECTED]'
> Subject: Splitting a database: pro and cons
> 
> 
> Hi list,
> 
> I have two applications running against one database (in fact 
> I have a few but for the sake of this question two are 
> enough).  The two apps have different upgrade patterns and I 
> would like to split them in two databases that will be on the 
> same unix server.  There are some views that are used 
> extensively that join data from both apps/schemas, and after 
> the split those should be made using db links.  I did some 
> tests and comparisons of queries going through links versus 
> running them directly on the database, and did not see a lot 
> of difference. 
> 
> Does anybody see or know of any downside in splitting the 
> database in two :-(.  And any advantage :-).  What is the 
> general strategy when installing different apps (from 
> different vendors) - put them on separate databases or combining them.
> 
> Thanks.
> 
> Djordje
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djordje Jankovic
  INET: [EMAIL PROTECTED]

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

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

[Jonathan Lewis]

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




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 14 August 2001 22:36


|I am currently attempting to tune an ERP batch job for processing EDI
sales
|orders.  We have a very powerful machine and the assumption is if one
|process can handle 200 lines per minute then 20 processes all running
a
|different data selection can process 4000 lines per minute.  The
bottlenecks
|at the moment are log file sync and enqueue.  I have trace files for
3 of
|the processes that all do pretty much the same thing.  One thing I
know is I
|need to reduce contention on the objects by increasing freelist and
|initrans.  How much I don't know yet.  I think Gaja's book said 2*CPU
is
|about as good as your get but there can be drawbacks to having to
many
|freelist.
|
|Logs are on separate devices, no mirroring just Oracle multiplexing.
|
|I can see from the trace file the objects F42UI11 and F42UI130 have
some
|problems.
|
|
|Charts tracking various metrics during testing requires free MS
Snapshot
|Viewer (http://www.microsoft.com/accessdev/prodinfo/snapshot.htm)
|
|http://www.freetechnicaltraining.com/docs/2001-08-14_TEST01.snp
|
|Trace file from one of the sessions:
|http://www.freetechnicaltraining.com/docs/52750.txt
|
|Log buffer size is 256K at the moment, we have tried smaller and
larger.
|Don't know what else I can really do to reduce log file sync.  The
job
|create about 4 GB of redo in 50 minutes.  Disk sub system is suppose
to be
|fast (SHARK) I think, so the admin tells me.  The system is remote so
I
|havn't really dug down into it yet.
|
|As far as the enqueues I ran on of Steve's scripts and they were TX
related
|so I am assuming the are coming from all the DML contention which
hopefully
|will be reduced significantly when change table parameters.  Feel
feel to
|give the files a look and let me know what you think.
|
|Thanks,
|Ethan
|http://www.geocities.com/epost1
|
|>-Original Message-
|>From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
|>Sent: Tuesday, August 14, 2001 1:27 PM
|>To: Multiple recipients of list ORACLE-L
|>Subject: Re: Performance analysis (enqueue and buffer busy waits)
|>
|>
|>
|>Enqueue waits cannot cause buffer busy waits,
|>but the absence of indexes (and you point out
|>missing FK indexes) can result in excessive
|>tablescanning, and tablescanning can result
|>in buffer busy waits.
|>
|>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
|
|-
-
|This e-mail is intended for the use of the addressee(s) only and may
contain privileged, confidential, or proprietary information that is
exempt from disclosure under law.  If you have received this message
in error, please inform us promptly by reply e-mail, then delete the
e-mail and destroy any printed copy.   Thank you.
|
|=
=
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Post, Ethan
|  INET: [EMAIL PROTECTED]
|
|Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing
Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be 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
-- 
Auth

Re: RE: UNCUT ORACLE-L The Motion Picture

[Charles Wolfe]

Title: OT: RE: UNCUT ORACLE-L The Motion Picture



Don't you mean "rogue" college 
intern?    :)

  - Original Message - 
  From: 
  Bowes, 
  Chris 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, August 14, 2001 10:47 
  AM
  Subject: OT: RE: UNCUT ORACLE-L The 
  Motion Picture
  
  UNCUT ORACLE-L  
  
  Coming to theaters near you.   Oracle-L, the UNCUT 
  version is rated NC-17. 
  Directed by Bruce. Produced by Jared 
  Still. 
  Starring: 
  Lisa Koivu.  Watch as she machetes a user who left his 
  userid and password on a post-it on his PC allowing a rouge college intern to 
  hack the system and destroy data.
  /Clip Lisa: "YOU'VE USED THAT PASSWORD 
  FOR THE LAST TIME MISTER",  User: "NOo!"  Hack hack 
  slice slice  Lisa: "Now where's that intern..."
  /Clip 
  Ross Mohan as her feisty sidekick. (envision Joe Pesci) 
  /Clip "Nice Cutting Lisa.  So 
  l-user, is it funny now?  Does she make you laugh?  Like a 
  clown?  Looks like we'll have to rewrite that song.  'The ankle 
  bone's connected to the spinal cord...'"
  /Clip 
  Rachel Carmichel, as the goddess of manager destruction. Watch 
  as she stuffs a chair down the throat of a manager for his really stupid 
  ideas.
  /Clip Manager:  "But Rachel, 
  don't you think that we could eliminate that 450g worth of data and save a lot 
  of money in training, dba costs and license fees if we converted everything to 
  Excel Spreadsheets?  Why are you looking at me like that?  No, now 
  put down that chair that could be an OHSA recordable.  Open Wide?  
  Oh, you silly.  I've already had brunch with the steering 
  committee.  That's where this excellent excel idea came from.  We 
  can do this right?  I figure 450 g isn't that much is it?  All we 
  have to do is get some PC's and a couple secretaries and...  No, back 
  away.  N."  Stuff, cram, cram.
  /Clip 
  Eric Pierce as Master Po giver of infinite knowledge. 
  /Clip "Grasshopper.  You will 
  find all you need at these links." /Clip 
  Director Jared Still, in a special appearance.  He 
  dispatches another developer for bad locking practices: /Clip "Six table locks?  For a three table 
  select?  I asked for code and you bring me this.  What have I done 
  to deserve this disrespect.    To the acid baths with 
  him..."
  /Clip 
  Christopher Bowes as the thoroughly confused rookie: 
  /Clip: "HELP!...  Am I an 
  idiot?  Well, no I don't think so. What's an idiot?   RTFM? 
  What's an RTFM?  Read the what?  What's a concepts manual.  
  What's a concept?  That's nice, but what is a database?  I've got to 
  build one for my boss today.  I told him I would and my performance 
  review is at 3pm...  Is 15 minutes enough time to build a 40 terabyte 
  base?  But I thought DBA's did nothing but get in the way of us 
  developers...  What's a tablespace?  What's a table"
  /Clip 
  Other special appearances by Steve Adams, Christopher Spence, 
  Joe Testa and lots of others from the Oracle-L.  See them all as you've 
  never seen them before.
  See Oracle-L, the UNCUT version.  Coming this 
  fall. 
  Sorry, folks, slow day... 

Re: RMAN cold backup?

[JOE TESTA]

cold backup in the respect that the db has to be mounted but 
not open.
 
here is an example(since we're in noarchivelogmode, its our 
only choice).  this is an incremental level 0, which is all.
 
hth, joe
 
run {allocate channel ch1 type disk;set limit channel 
ch1 kbytes = 190;backup incremental level 0tag = 
'dssmnt02_inc_0'format 
'/ora_export/export/tmp/dssmnt02_inc_0_%U'database;}
>>> [EMAIL PROTECTED] 08/14/01 05:53PM 
>>>
I'm frantically 
R'ing TFM, but I can't find the answer to a simple question:  Can I use 
RMAN to perform a cold backup?  If so, how?  TIA!
 
Paul Baumgartel MortgageSight Holdings, 
LLC [EMAIL PROTECTED] 
 

RE: OT -- training

[Rachel Carmichael]

Each Presenter gets a 45-60 minute slot. Okay, Gaja gets two, he needs that 
much :)

Papers (if I can coerce, er, persuade the presenters to create one) go up on 
the website. Slides will definitely be there.

Should be lots of fun... I do love living in NY!

>From: "Ron Rogers" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 11:41:41 -0800
>
>Rachel,
>I hope you have a lot of time set aside for the presentors. It sounds like 
>a great cast to listen to and a hard act to follow. A small note:  I 
>attended a seminar presented by Mike Ault and Rich Niemiec about the new 9i 
>database. There was not enough time in the evening to cover it completely. 
>Both speakers lived up to expectations and could have filled an additional 
>3 hours if given time.
>  I only wish that I was closer and able to attend. Will their papers be on 
>the website after the meeting?
>Thanks,
>ROR mª¿ªm
>
> >>> [EMAIL PROTECTED] 08/14/01 02:37PM >>>
>Yep, I got lucky, and called on a lot of people I know.
>
>For those of you lost in this semi-private conversation, the NYOUG meeting
>on September 12th (and yes, non-members are welcome) is being called the
>"Literary Lights" meeting.
>
>presenters include: our own Gaja Krishna Vaidyanatha and Ari Kaplan, Rich
>Niemiec, Kevin Loney, Marlene Theriault, Douglas Scherer, John 
>Beresniewicz,
>Ulka Rodgers and Paul Dorsey.
>
>oh yeah, I'll be hanging out there. But I had so many great presenters I 
>had
>to bump myself off the agenda :)
>
>check it out, www.nyoug.org
>
>
>
>
> >From: "Miller, Jay" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: OT -- training
> >Date: Tue, 14 Aug 2001 09:00:37 -0800
> >
> >Pretty amazing actually.  I won't feel so bad about missing the cruise 
>this
> >year :-( If I get get to attend this one.
> >
> >Jay Miller
> >
> >
> >-Original Message-
> >Sent: Monday, August 13, 2001 10:21 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > >On the other hand, I can take the day off for the NY Users Group when
> >there
> >
> > >aren't any emergencies (about 50% of the time).
> > >
> > >
> > >Jay Miller
> > >
> >
> >
> >try not to have any emergencies on September 12th :)   it's gonna be a 
>good
> >one!
> >
> >Rachel
> >
> >_
> >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: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
>
>_
>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: Ron Rogers
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California--

extended ascii codes

[Bill Becker]

Hello,

We are running Oracle 8.1.6 on Solaris 2.7.
The characterset for our database is US7ASCII,
as evidenced by:
TS1>SELECT * FROM NLS_DATABASE_PARAMETERS;

PARAMETER  VALUE
-- 
NLS_LANGUAGE   AMERICAN
NLS_TERRITORY  AMERICA
NLS_CURRENCY   $
NLS_ISO_CURRENCY   AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET   US7ASCII
NLS_CALENDAR   GREGORIAN
NLS_DATE_FORMATDD-MON-
NLS_DATE_LANGUAGE  AMERICAN
NLS_SORT   BINARY
NLS_TIME_FORMATHH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT   DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY  $
NLS_COMP   BINARY
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_RDBMS_VERSION  8.1.6.3.0

Now, when using US7ASCII, I don't understand how I can do this:

TS1>desc biltmp
 Name Null?Type
-  
GENDERVARCHAR2(1)
AGE   NUMBER(3)

TS1>insert into biltmp (gender)
 values (CHR(176));

1 row created.

TS1>insert into biltmp (gender)
 values (CHR(248));

1 row created.

TS1>commit;

Commit complete.

TS1>SELECT GENDER, ASCII(GENDER) FROM BILTMP;

G ASCII(GENDER)
- -
ø   248
°   176

The symbols seen above in the first column are not what I see
in sqlplus, but cutting and pasting into this msg apparently
converts them to the symbols above. My mail app is Windows-based,
and the codeset used is apparently the same as the WE8ISO8859P1
codeset. What I see in sqlplus are the symbols that the extended
ascii IBM codeset uses (248 is the small circle, 176 is a vertical
rectangle filled with dots - hope I'm not getting too technical).
Don't know what they will display as when I send this to oracle-l.

Anyway, why can I insert ascii values above 127 into an US7ASCII
database? 
In a US7ASCII database, does (server-side) sqlplus actually 
interpret all 8 bits for values above 127 as the extended ascii
IBM codeset?

Interestingly, from client sqlplus (8.0.6);

TS1>SELECT GENDER, ASCII(GENDER) FROM BILTMP;

G ASCII(GENDER)
- -
x   248
0   176

Here, it apparently ignores the 8th bit (248 - 128 = 120, lower-case x).
(176 - 128 = 48, zero), so I conclude that net80 somehow knows
that the database characterset is 7-bit, and ignores the 8th bit.
Is that conclusion correct?
Is net80 responsible for this conversion, and is there any way
I can tell it to interpret all 8 bits, short of changing the
characterset of the database?

To everyone who has read this far, thanks.
To all who respond, even greater thanks.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: [EMAIL PROTECTED]

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

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

RE: OT: RE: UNCUT ORACLE-L The Motion Picture

[Mohan, Ross]

remove a Dedekind cut?  It's like finding out
there *is* no such thing as the "number next to zero"

-Original Message-
Sent: Tuesday, August 14, 2001 2:08 PM
To: Multiple recipients of list ORACLE-L


Momento - No.  Not likely to see it.  I might go to the movies once a year
and the next three years are already reserved.

Dedekind - Yes.  Many years.  All brain cells no longer functional.  If you
uncut a Dedekind cut, what would happen?  Does it matter since it's
irrational or imaginary anyway?


 

"Mohan, Ross"

<[EMAIL PROTECTED]>

Sent by: cc:

root@fatcity.Subject: RE: OT: RE: UNCUT
ORACLE-L The   
com  Motion Picture

 

 

08/14/2001

11:50 AM

Please

respond to

ORACLE-L

 

 





ROFL

But, reallywhy do I have to be Joe Pesci?  I really
must cut down on my delivery speed

Oh well...reminds me of my first shamanic journey to
the middle worldturns out my power animal was a
squirrel.

A friggin' squirrel.

LoL

Ah well, I am an oracle dba...I *do* have to compensate

Ross

p.s. It's Dedekind Cut. He was brilliantwow.

-Original Message-
Sent: Tuesday, August 14, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L


The unkindest uncut of all - the Dedican uncut.

LOL





"Bowes,

Chris"   To: Multiple recipients of
list
ORACLE-L


kosa.com>cc:

Sent by: Subject: OT: RE: UNCUT
ORACLE-L
The Motion
root@fatcity.Picture

com





08/14/2001

10:47 AM

Please

respond to

ORACLE-L











UNCUT ORACLE-L




Coming to theaters near you.   Oracle-L, the UNCUT version is rated NC-17.

Directed by Bruce.
Produced by Jared Still.

Starring:

Lisa Koivu.  Watch as she machetes a user who left his userid and password
on a post-it on his PC allowing a rouge college intern to hack the system
and destroy data.

/Clip
Lisa: "YOU'VE USED THAT PASSWORD FOR THE LAST TIME MISTER",  User:
"NOo!"  Hack hack slice slice  Lisa: "Now where's that
intern..."

/Clip

Ross Mohan as her feisty sidekick. (envision Joe Pesci)
/Clip
"Nice Cutting Lisa.  So l-user, is it funny now?  Does she make you laugh?
Like a clown?  Looks like we'll have to rewrite that song.  'The ankle
bone's connected to the spinal cord...'"

/Clip

Rachel Carmichel, as the goddess of manager destruction. Watch as she
stuffs a chair down the throat of a manager for his really stupid ideas.

/Clip
Manager:  "But Rachel, don't you think that we could eliminate that 450g
worth of data and save a lot of money in training, dba costs and license
fees if we converted everything to Excel Spreadsheets?  Why are you looking
at me like that?  No, now put down that chair that could be an OHSA
recordable.  Open Wide?  Oh, you silly.  I've already had brunch with the
steering committee.  That's where this excellent excel idea came from.  We
can do this right?  I figure 450 g isn't that much is it?  All we have to
do is get some PC's and a couple secretaries and...  No, back away.
N."  Stuff, cram, cram.

/Clip

Eric Pierce as Master Po giver of infinite knowledge.
/Clip
"Grasshopper.  You will find all you need at these links."
/Clip

Director Jared Still, in a special appearance.  He dispatches another
developer for bad locking practices:
/Clip
"Six table locks?  For a three table select?  I asked for code and you
bring me this.  What have I done to deserve this disrespect.    To the acid
baths with him..."

/Clip

Christopher Bowes as the thoroughly confused rookie:
/Clip:
"HELP!...  Am I an idiot?  Well, no I don't think so. What's an idiot?
RTFM? What's an RTFM?  Read the what?  What's a concepts manual.  What's a
concept?  That's nice, but what is a database?  I've got to build one for
my boss today.  I told him I would and my performance review is at 3pm...
Is 15 minutes enough time to build a 40 terabyte base?  But I thought DBA's
did nothing but get in the way of us developers...  What's a tablespace?
What's a table"

/Clip

Other special appearances by Steve Adams, Christopher Spence, Joe Testa and
lots of others from the Oracle-L.  See them all as you've never seen them
before.

See Oracle-L, the UNCUT version.  Coming this fall.

Sorry, folks, slow day...



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

out of process memory while doing full DB import

[ef 8454]

I am doing full DB import and have following error message:
IMP-00017: following statement failed with ORACLE error 4030: "CREATE PACKAGE BODY    dbms_repcat_auth wrapped " "0"    "abcd" "abcd" "abcd" "abcd" "abcd" "abcd" "abcd" "abcd" "abcd" "abcd" "abcd" "abcd"
..
IMP-3: ORACLE error 4030 encounteredORA-04030: out of process memory when trying to allocate 452224 bytes (PLSnon-lib hp,PAR.C:parchk:ptb)
 
Anyone know why?
Thanks
 Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ef 8454
  INET: [EMAIL PROTECTED]

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

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

RE: RE: UNCUT ORACLE-L The Motion Picture

[Mohan, Ross]

Title: OT: RE: UNCUT ORACLE-L The Motion Picture



naw. 
just a cry for help. 

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 1:32 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  RE: UNCUT ORACLE-L The Motion Picture
  That 
  was too funny and too creative!:)
  KK
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
Tuesday, August 14, 2001 12:45 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: RE: UNCUT ORACLE-L The Motion 
Picture
btw, Can I meet this "rouge" college intern before Lisa machetes 
her?
 

 
I 
want to justify the NC-17 rating. 
 
- 
Hannibal

  -Original Message-From: Bowes, Chris 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 
  10:47 AMTo: Multiple recipients of list 
  ORACLE-LSubject: OT: RE: UNCUT ORACLE-L The Motion 
  Picture
  UNCUT ORACLE-L  
  
  Coming to theaters near you.   Oracle-L, the 
  UNCUT version is rated NC-17. 
  Directed by Bruce. Produced by 
  Jared Still. 
  Starring: 
  Lisa Koivu.  Watch as she machetes a user who left 
  his userid and password on a post-it on his PC allowing a rouge college 
  intern to hack the system and destroy data.
  /Clip Lisa: "YOU'VE USED THAT 
  PASSWORD FOR THE LAST TIME MISTER",  User: 
  "NOo!"  Hack hack slice slice  Lisa: "Now where's 
  that intern..."
  /Clip 
  Ross Mohan as her feisty sidekick. (envision Joe 
  Pesci) /Clip "Nice Cutting 
  Lisa.  So l-user, is it funny now?  Does she make you 
  laugh?  Like a clown?  Looks like we'll have to rewrite that 
  song.  'The ankle bone's connected to the spinal cord...'"
  /Clip 
  Rachel Carmichel, as the goddess of manager destruction. 
  Watch as she stuffs a chair down the throat of a manager for his really 
  stupid ideas.
  /Clip Manager:  "But Rachel, 
  don't you think that we could eliminate that 450g worth of data and save a 
  lot of money in training, dba costs and license fees if we converted 
  everything to Excel Spreadsheets?  Why are you looking at me like 
  that?  No, now put down that chair that could be an OHSA 
  recordable.  Open Wide?  Oh, you silly.  I've already had 
  brunch with the steering committee.  That's where this excellent 
  excel idea came from.  We can do this right?  I figure 450 g 
  isn't that much is it?  All we have to do is get some PC's and a 
  couple secretaries and...  No, back away.  N."  
  Stuff, cram, cram.
  /Clip 
  Eric Pierce as Master Po giver of infinite 
  knowledge. /Clip "Grasshopper.  You will find all you need at these 
  links." /Clip 
  Director Jared Still, in a special appearance.  He 
  dispatches another developer for bad locking practices: /Clip "Six table locks?  For a three 
  table select?  I asked for code and you bring me this.  What 
  have I done to deserve this disrespect.    To the acid 
  baths with him..."
  /Clip 
  Christopher Bowes as the thoroughly confused 
  rookie: /Clip: "HELP!...  Am I an idiot?  Well, no I don't think so. 
  What's an idiot?   RTFM? What's an RTFM?  Read the 
  what?  What's a concepts manual.  What's a concept?  That's 
  nice, but what is a database?  I've got to build one for my boss 
  today.  I told him I would and my performance review is at 
  3pm...  Is 15 minutes enough time to build a 40 terabyte base?  
  But I thought DBA's did nothing but get in the way of us 
  developers...  What's a tablespace?  What's a table"
  /Clip 
  Other special appearances by Steve Adams, Christopher 
  Spence, Joe Testa and lots of others from the Oracle-L.  See them all 
  as you've never seen them before.
  See Oracle-L, the UNCUT version.  Coming this 
  fall. 
  Sorry, folks, slow day... 

RE: OT -- training

[Post, Ethan]

Can someone encode the audio... :)

>-Original Message-
>From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 1:27 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: OT -- training
>
>
>Each Presenter gets a 45-60 minute slot. Okay, Gaja gets two, 
>he needs that 
>much :)
>
>Papers (if I can coerce, er, persuade the presenters to create 
>one) go up on 
>the website. Slides will definitely be there.
>
>Should be lots of fun... I do love living in NY!
>
>>From: "Ron Rogers" <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: RE: OT -- training
>>Date: Tue, 14 Aug 2001 11:41:41 -0800
>>
>>Rachel,
>>I hope you have a lot of time set aside for the presentors. 
>It sounds like 
>>a great cast to listen to and a hard act to follow. A small note:  I 
>>attended a seminar presented by Mike Ault and Rich Niemiec 
>about the new 9i 
>>database. There was not enough time in the evening to cover 
>it completely. 
>>Both speakers lived up to expectations and could have filled 
>an additional 
>>3 hours if given time.
>>  I only wish that I was closer and able to attend. Will 
>their papers be on 
>>the website after the meeting?
>>Thanks,
>>ROR mª¿ªm
>>
>> >>> [EMAIL PROTECTED] 08/14/01 02:37PM >>>
>>Yep, I got lucky, and called on a lot of people I know.
>>
>>For those of you lost in this semi-private conversation, the 
>NYOUG meeting
>>on September 12th (and yes, non-members are welcome) is being 
>called the
>>"Literary Lights" meeting.
>>
>>presenters include: our own Gaja Krishna Vaidyanatha and Ari 
>Kaplan, Rich
>>Niemiec, Kevin Loney, Marlene Theriault, Douglas Scherer, John 
>>Beresniewicz,
>>Ulka Rodgers and Paul Dorsey.
>>
>>oh yeah, I'll be hanging out there. But I had so many great 
>presenters I 
>>had
>>to bump myself off the agenda :)
>>
>>check it out, www.nyoug.org
>>
>>
>>
>>
>> >From: "Miller, Jay" <[EMAIL PROTECTED]>
>> >Reply-To: [EMAIL PROTECTED]
>> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>> >Subject: RE: OT -- training
>> >Date: Tue, 14 Aug 2001 09:00:37 -0800
>> >
>> >Pretty amazing actually.  I won't feel so bad about missing 
>the cruise 
>>this
>> >year :-( If I get get to attend this one.
>> >
>> >Jay Miller
>> >
>> >
>> >-Original Message-
>> >Sent: Monday, August 13, 2001 10:21 PM
>> >To: Multiple recipients of list ORACLE-L
>> >
>> >
>> >
>> > >On the other hand, I can take the day off for the NY 
>Users Group when
>> >there
>> >
>> > >aren't any emergencies (about 50% of the time).
>> > >
>> > >
>> > >Jay Miller
>> > >
>> >
>> >
>> >try not to have any emergencies on September 12th :)   it's 
>gonna be a 
>>good
>> >one!
>> >
>> >Rachel
>> >
>> >_
>> >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: Miller, Jay
>> >   INET: [EMAIL PROTECTED]
>> >
>> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>> >San Diego, California-- Public Internet access / 
>Mailing Lists
>> >
>> >To REMOVE yourself from this mailing list, send an E-Mail message
>> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> >the message BODY, include a line containing: UNSUB ORACLE-L
>> >(or the name of mailing list you want to be removed from).  You may
>> >also send the HELP command for other information (like subscribing).
>>
>>
>>_
>>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 cont

RE: RMAN cold backup?

[Glasrot, Nechama]

yes using netbackup and rman ...

cold_backup.rcv
#
# Shutdown the database for cold backup
#
shutdown immediate;
startup mount;
#
# Backs up the whole database cold - consistent -.
# Weekly occurence in our strategy.
#
run {
allocate channel t1 type 'SBT_TAPE';
setlimit channel t1 kbytes 2097150 maxopenfiles 32 readrate 200;
backup
filesperset 12
format 'C_df_i0_t%t_s%s_p%p'
database;
alter database open;
release channel t1;
}
#


cold_backup.sh
#!/bin/ksh
# Sample script which is run from the target database
. ~oracle/.profile

ORACLE_SID=mydb
RMAN_SRC=/u01/app/oracle/admin/mydb/rman
RMANLOG=/u01/app/oracle/admin/mydb/rman/rman_cold_`date '+%y%m%d'`.log

rman rcvcat userid/password@rcat target / cmdfile
${RMAN_SRC}/cold_backup.rcv msglog ${RMANLOG}


hope this helps ...

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd. 
Boca Raton, Florida 33487 
[EMAIL PROTECTED] 
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695

-Original Message-
Sent: Tuesday, August 14, 2001 5:54 PM
To: Multiple recipients of list ORACLE-L


I'm frantically R'ing TFM, but I can't find the answer to a simple question:
Can I use RMAN to perform a cold backup?  If so, how?  TIA!
 
Paul Baumgartel 
MortgageSight Holdings, LLC 
[EMAIL PROTECTED] 
 


This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you


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

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

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

[Mohan, Ross]

Someone here was interested in vaccines. 

http://www.aapsonline.org/aaps/

Go to "Vaccines: A Look at the Risks and Benefits" on the left...

Then, the last item in the right frame is "More Vaccine Information".

That pops a list of AAPS actions/statements regarding vaccines. 

See the mail from 11/2/2000. Amazing!

Basically, AAPS thinks vaccines should NOT be *mandated*, but
merely suggested to the physician, and then presented to
the patient on a case-by-case basis. 

Interesting stuff. 

- Ross 

-Original Message-
Sent: Tuesday, August 14, 2001 5:41 PM
To: Multiple recipients of list ORACLE-L



Joe,

Take a look at the encryption arcticle on my website at
www.cybcon.com/~jkstill/util

I use an external process for one of the examples and detail the setup.

Also found at:


http://www.kbaseonline.com/Topics/Articles/databasemain.asp?basecatid=1&type
=1

Jared




 

"JOE TESTA"


erger.com>   cc:

Sent by: Subject: external proc listener

[EMAIL PROTECTED]

om

 

 

08/14/01 10:25

AM

Please respond

to ORACLE-L

 

 





Ok i know i'm doing something wrong here in working with external proc
listener as i can even get the stupid demo to work right.

here is my listener.ora

LISTENER_EXTPROC=
(ADDRESS = (PROTOCOL = IPC) (KEY = extproc))


SID_LIST_LISTENER_EXTPROC
  (SID_LIST =
(SID_DESC =
 (SID_NAME = plsextproc)
 (ORACLE_HOME = /u151/oracle/product/8.1.7)
 (PROGRAM = EXTPROC)
  )
 )
on startup i get this(which lends me to believe i've got something messed
up):

 and

Listener Trace File
/u151/oracle/product/8.1.7/network/log/listener_extproc.trc
The listener supports no services
The command completed successfully


tnsnames.ora
extproc_connection_data=
 (description=
   (address=(protocol=ipc)(key=extproc))
   (connect_data=
(sid=plsextproc)))

So what am i missing, i've RTFM, metalink, used what I thought were good
examples from multiple places, yet when running the demo in
$ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.

thanks, joe




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

RE: Performance analysis (enqueue and buffer busy waits)

[Post, Ethan]

I am currently attempting to tune an ERP batch job for processing EDI sales
orders.  We have a very powerful machine and the assumption is if one
process can handle 200 lines per minute then 20 processes all running a
different data selection can process 4000 lines per minute.  The bottlenecks
at the moment are log file sync and enqueue.  I have trace files for 3 of
the processes that all do pretty much the same thing.  One thing I know is I
need to reduce contention on the objects by increasing freelist and
initrans.  How much I don't know yet.  I think Gaja's book said 2*CPU is
about as good as your get but there can be drawbacks to having to many
freelist.

Logs are on separate devices, no mirroring just Oracle multiplexing. 

I can see from the trace file the objects F42UI11 and F42UI130 have some
problems.


Charts tracking various metrics during testing requires free MS Snapshot
Viewer (http://www.microsoft.com/accessdev/prodinfo/snapshot.htm)

http://www.freetechnicaltraining.com/docs/2001-08-14_TEST01.snp

Trace file from one of the sessions:
http://www.freetechnicaltraining.com/docs/52750.txt

Log buffer size is 256K at the moment, we have tried smaller and larger.
Don't know what else I can really do to reduce log file sync.  The job
create about 4 GB of redo in 50 minutes.  Disk sub system is suppose to be
fast (SHARK) I think, so the admin tells me.  The system is remote so I
havn't really dug down into it yet.  

As far as the enqueues I ran on of Steve's scripts and they were TX related
so I am assuming the are coming from all the DML contention which hopefully
will be reduced significantly when change table parameters.  Feel feel to
give the files a look and let me know what you think.

Thanks,
Ethan
http://www.geocities.com/epost1

>-Original Message-
>From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 1:27 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Performance analysis (enqueue and buffer busy waits)
>
>
>
>Enqueue waits cannot cause buffer busy waits,
>but the absence of indexes (and you point out
>missing FK indexes) can result in excessive
>tablescanning, and tablescanning can result
>in buffer busy waits.
>
>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

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

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

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

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

Re: Datafile Migration Tool

[K Gopalakrishnan]

FTP just transfers the file (either binary or text) to the target OS
and that file can not be opened by the Oracle running in the target
machine.

Beacuse each OS will have different file formats and Oracle running in
differenct OSs will use  differnet system calls /APIs to CRUD (Create
Replace Update Delete) the files.

Here if you take an NT-oracle  data file to Unix oracle , this file is
a junk data according to unix-oracle. But if you covert that file to
unix format using the tool, your unix-oracle will/can/may read that
file and straight away you can open the database..

Hope this clarifiesd the confusion..!!


--- Scott Shafer <[EMAIL PROTECTED]> wrote:
> Not to be a smartass, but don't most OS's already have ftp built in? 
> What kind of value-added are you proposing?  Just curious...
> 
> Scott Shafer
> San Antonio, TX
> 
> 


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

Re:RE: Re[2]: How can I get my DB back if I lost one of my r

[Riyaj_Shamsudeen]

Hi all
        I did some research in my test database and here is what I found
out: I had events 10500,10221 and 10218 set in the database to trace the
instance recovery. 10218 was particularly useful since it was dumping the
uba of applied undo.
        a. Shutdown abort did not rollback any transactions( as expected).
Shutdown immediate signalled  smon and smon rolled back all the uncommitted
transactions. I could see that the smon was applying uba in the trace file:
-

uba: 0x0100010d.0003.11
uba: 0x0100010d.0003.10
uba: 0x0100010d.0003.0f
uba: 0x0100010d.0003.0e
uba: 0x0100010d.0003.0d
uba: 0x0100010d.0003.0c

        b. Inserted few thousands rows, did a shutdown immediate, renamed
the rollback segment data file and tried to open the database. Of course
DBW was not happy, created a backup control file to trace and offline
dropped the datafile. Still complained about the rollback entries from the
init.ora file, so commented out those entries and was able to open the
database.
        c. Inserted few thousands rows again, did a shutdown abort this
time, renamed the rollback segment data file and tried to open the
database. Did the same steps as in step (b). Even after commenting out
rollback segments, still smon was complaining about "unable to access the
rollback segment" and database did not open at all.

SMON: about to recover undo segment 2
SMON: mark undo segment 2 as needs recovery
SMON: about to recover undo segment 3
SMON: mark undo segment 3 as needs recovery
SMON: about to recover undo segment 4
SMON: mark undo segment 4 as needs recovery

        Recreated the control file with the roll back segment datafile and
now database opens fine..This explains Dick's experience. In my case, the
database crashed and the rollback segment file was corrupted and had to use
_corrupted_rollback_segments to solvage the data. If you shutdown clean
(immediate or normal), losing rollback segment is no big deal, otherwise
say your prayers...

HTH,
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com
|++|
||   [EMAIL PROTECTED] ||
||   Sent by: |           To:  |
||   [EMAIL PROTECTED] |   Multiple recipients  |
|||   of list ORACLE-L |
||   08/14/01 01:27 PM|   <[EMAIL PROTECTED]|
||   Please respond to|   >|
||   ORACLE-L |           cc:  |
|||           Subject: |
|||   Re:RE: Re[2]: How can|
|||   I get my DB back if I|
|||   lost one of my r |
|++|






Lisa,

   I believe that is why using "shutdown abort" is not truly endorsed by
Oracle, except as a last resort.  What I've noticed on the list is the
desire by
some to over use this method of shutting down the DB.  Now I will admit
that
"shutdown normal" is a real pain in the back side since every one HAS to
log off
before the DB will shutdown.  And "shutdown immediate" does have a tendency
to
hang around way too long on occasion.  Using abort though as the fix all is
a
really bad thing to do.  One item I've taken is to allow the DB to stay in
the
"shutdown immediate" state for at least 10 minutes before aborting it.  The
reason is that during that time the background processes have the
opportunity to
rollback/commit all of the transactions that were taking place thereby
cleaning
out the rollback segments.  If by the time 10 minutes has expired your DB
has
not shutdown, you can be 99% confident that the problem is a truly dead
process/client who is no longer talking to Oracle and who's transactions
have
been handled.  It's just a matter that Oracle cannot handshake with the
client
anymore that's holding up the shutdown.  Then one can abort the instance
with
every confidence that it will restart later.  Experience here has proved
that
the startup in this case will occur 5 times faster than just firing off a
"shutdown abort" without the time period.  Therefore to my SA's chagrin,
all of
my scripts call "shutdown immediate" and "shutdown abort" is left to a
manual
process.

In my last response, privately, to Riyaj I stated that I had repaired a DB
that
lost it's rollback tablespace to a disk failure.  The problem arose on db
startup after a normal cold backup.  Since the DB was shutdown with the
immediate vs. abort option all of the rollback was cleaned out before
Oracle
shutdown, and it did so normally.  When the restart failed it was just a
matter
of dumping the datafile offline and the tablespace 

RE: Datafile Migration Tool

[Ron Thomas]

Actually, this could be an interesting tool.  Our production database is on HP.  But I 
would like to
setup several test instances on linux or other platforms for the developers.  Moving 
30-40Gb of data
around via export/import would be a real pain.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"Either lead by example, or become a terrible warning"


   
 
kaygopal@yaho  
 
o.comTo: [EMAIL PROTECTED]  
 
Sent by: cc:   
 
root@fatcity.Subject: RE: Datafile Migration Tool  
 
com
 
   
 
   
 
08/14/01   
 
02:41 PM   
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




Kirti,

Frankly speaking , (as of now) I have to support the database and I
don't think Oracle will support. But if you have luxury..you can always
reorgaze the database and oracle HAS to suport the database.

Initially I can give this tool for learning oracle and playing with
oracle databases, I can pack this tool with a custom block editor where
you can edit the databases, and an unloader tool (like DUL) which gives
you the data in text format from the data files.

But I don;t think Oracle will support any of these tools. :(

--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> Gopal,
>
> So who do we call if there is a problem in the converted datafile
> later down
> the road and the database is down? The Tool Supplier or Oracle
> Support?
>
> Thanks.



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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




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

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

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

RMAN cold backup?

[Paul Baumgartel]

I'm frantically 
R'ing TFM, but I can't find the answer to a simple question:  Can I use 
RMAN to perform a cold backup?  If so, how?  TIA!
 
Paul Baumgartel MortgageSight Holdings, 
LLC [EMAIL PROTECTED] 
 

Netbackup with Oracle 817

[Navtej B]

Hi Experts,

Can somebody guide me towards Oracle database backup
of around 200G with Netbackup and I really appreciate
any document for Rman Scripts/Backup document like
restore or other test scenario. 

I know lots of big company has implemented it and I am
told to submit mine document in a week and so
desperately need all of ur advice and very greatfull
if someone can help me all test scenario plus script

Thanks a ton in advance

Nbir

__
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: Navtej B
  INET: [EMAIL PROTECTED]

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

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

RE: Datafile Migration Tool

[Yexley Robert D SSgt AFIT/SCA]

Sounds to me like it could potentially save a considerable amount of time
for someone who may be migrating their database across platforms.
Especially if you're one of those shops out there that has a significantly
large database.  That can get to be a pretty big hassle (in just time
consumption if nothing else) to have to do a full database export and then
full database import to migrate your data.

-::YEX::-
<)))><

-Original Message-
Sent: Tuesday, August 14, 2001 5:27 PM
To: Multiple recipients of list ORACLE-L


I'm not trying to be mean about it.  I am honestly curious as to what
kind of benefit is expected from the tool or how it will work to make my
life easier.

--Scott


Rachel Carmichael wrote:
> 
> it doesn't sound like an ftp type tool. If I am reading this correctly, he
> is proposing to provide a tool that copies datafiles directly from one OS
to
> another.
> 
> While this is an interesting trick, I'm not sure there's a large market
for
> it.
> 
> >From: Scott Shafer <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Datafile Migration Tool
> >Date: Tue, 14 Aug 2001 12:00:53 -0800
> >
> >Not to be a smartass, but don't most OS's already have ftp built in?
> >What kind of value-added are you proposing?  Just curious...
> >
> >Scott Shafer
> >San Antonio, TX
> >
> >
> >K Gopalakrishnan wrote:
> > >
> > > Hi ,
> > >
> > > Will there be a market if I give a tool which migrates Oracle database
> > > from One OS to another OS. (Data file migration at Operating System
> > > Level.)
> > >
> > > i.e it will convert from  Oracle data files on NT to Oracle Datafiles
> > > on Solaris and vice versa.  In the target database you need to
recreate
> > > the control files and you are done. You can startup the database. You
> > > don't need to export/import or CTAS over dblink..
> > >
> > > Send your replies directly to me..
> > >
> > > Thanks Yong..for bringing the cat out of the basket ;)
> > >
> > > =
> > > Have a nice day !!
> > > 
> > > Best Regards,
> > > K Gopalakrishnan,
> > > Bangalore, INDIA.
> >
> >_
> >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).
> 
> _
> 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).

_
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yexley Robert D SSgt AFIT/SCA
  INET: [EMAIL PROTECTED]

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

To REMOVE 

Re: external proc listener

[Jared . Still]

Joe,

Take a look at the encryption arcticle on my website at
www.cybcon.com/~jkstill/util

I use an external process for one of the examples and detail the setup.

Also found at:


http://www.kbaseonline.com/Topics/Articles/databasemain.asp?basecatid=1&type=1

Jared




   
 
"JOE TESTA"
 

erger.com>   cc:   
 
Sent by: Subject: external proc listener   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
08/14/01 10:25 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Ok i know i'm doing something wrong here in working with external proc
listener as i can even get the stupid demo to work right.

here is my listener.ora

LISTENER_EXTPROC=
(ADDRESS = (PROTOCOL = IPC) (KEY = extproc))


SID_LIST_LISTENER_EXTPROC
  (SID_LIST =
(SID_DESC =
 (SID_NAME = plsextproc)
 (ORACLE_HOME = /u151/oracle/product/8.1.7)
 (PROGRAM = EXTPROC)
  )
 )
on startup i get this(which lends me to believe i've got something messed
up):

 and

Listener Trace File
/u151/oracle/product/8.1.7/network/log/listener_extproc.trc
The listener supports no services
The command completed successfully


tnsnames.ora
extproc_connection_data=
 (description=
   (address=(protocol=ipc)(key=extproc))
   (connect_data=
(sid=plsextproc)))

So what am i missing, i've RTFM, metalink, used what I thought were good
examples from multiple places, yet when running the demo in
$ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.

thanks, joe




-- 
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: Copy of redo

[Diego Cutrone]

Hi Aldi:

I would definitively not place redo logs over RAID5, this would decrease
performance, why
don't you try to place them in a dedicated disk or over RAID 1.

For the database using disk mirror I would just create one copy of my redo,
and mirror it using the disk mirror.
Under some circunstances Oracle writes one redo log member first and then to
the other (I mean secuentially, not in parallel)

HTH


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 5:53 PM


> Hi.
> I'm running 3 databases : 1 using disks mirror and 2 using raid-5.
> I just want your opinion on this : do I need to have the copy of redo log
> files (2 redo for each redo group) or not (because it's redundant and
> decreasing performance) ?
> Tia
>
> Aldi
>
> _
> 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: Aldi Barco
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Diego Cutrone
  INET: [EMAIL PROTECTED]

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

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

Price

[Christopher Spence]

Title: Price





Under unix, it is $40,000 per cpu fixed as I understand it.  Does this hold true for NT?
Anyone know the NT price?


"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
 

RE: OT -- training

[lhoska]

Speaking about progressing in your current field wouldn't technical training
of dba qualify for a tax break under the same category as training for FAA
ground instructor?  Otherwise, your FAA ground instructor registered as a
private business (and we're back to the beginning of our discussion).
Doesn't surprise me neither does it make me jealous.  There are so many
different career decisions you can make.  I like being a dba..
Btw, I am pretty sure you can write off your technical book fees even as an
individual..
-Original Message-
Sent: Tuesday, August 14, 2001 4:54 PM
To: Multiple recipients of list ORACLE-L


Appearances to the contrary, Canada is a separate country with their own
tax laws.

However, the tax dodge that you mention is common here too.

Here's a really good one -- become a Certified FAA Ground Instructor.  You
teach people how to pass the FAA ground exam.  Since it's not life
threatening, it's relatively simple to get this certificate.  Then get a
student or two.  After that you can buy an airplane.  The airplane, the gas
to fly it, the maintenance and hangering of the airplane, the cost of
getting the experience necessary to become a Certified Flight Instructor
(CFI), books, aircraft simulator software, landing fees, even the cost of
overnight lodging in some cases, instructors' fees (in short, a whole ton
of things that make flying a hobby for the rich) become tax deductable
because they are helping you progress in your field as an instructor.  The
IRS does not allow you to deduct training that qualifies you for a new
field but it does allow you to deduct training that allows you to progress
in your current field.  Because of the FAA requirements for becoming a CFI
almost anything having to do with flying will count as "training".



 

"Boivin, Patrice

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

mpo.gc.ca>   cc:

Sent by: Subject: RE: OT -- training

[EMAIL PROTECTED]

 

 

08/14/2001 04:17

PM

Please respond to

ORACLE-L

 

 





I know in Canada that some high-paid executives have "farms" in rural areas
(ahem, cottages really) where they grow forage, seed, or raise a couple of
sheep, rabbits, a few pigs, some chickens, or one cow.  All for tax
deductions of course.  It helps if the farm is near a lake.

Another good one is "horse farm".  There is a particularly big one in
Ontario that specializes in horse racing... and never makes a profit.  Ha
ha
ha ha ha ha...

This is my opinion, of course.  But I saw many of these when I used to
enter
farm tax records for Statistics Canada years ago.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 14, 2001 3:44 PM
 To:  Multiple recipients of list ORACLE-L
 Subject:  RE: OT -- training

 I guess that we'll let the IRS sort this one out.  Your friend is
probably
 right and I was probably overly emphatic when I said that you MUST
show a
 profit sometime.  But I would rather not leave it up to the IRS to
decide
 whether it is a business or a hobby.




 "Post, Ethan"

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

 Sent by: cc:

 root@fatcity.Subject: RE: OT --
training
 com





 08/14/2001

 01:17 PM

 Please

 respond to

 ORACLE-L









 Actually I talked to a friend who is pretty knowlegable about this
stuff
 and
 he says that what it will really come down to is intent.  The IRS is
not
 going to call your business a hobby if it is in fact unquestionably
a
 business, even if it has lost money for a period of years. - E

 >-Original Message-
 >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 >Sent: Tuesday, August 14, 2001 7:41 AM
 >To: Multiple recipients of list ORACLE-L
 >Subject: RE: OT -- training
 >
 >
 >Check with your tax advisor again or get a new tax advisor.  I
don't
 >remember the exact details but you MUST show some tax-able profit
for a
 >certain number of years out of every so many years (eg, 1 year
 >out of the
 >last 4 - I'm not sure that those are the right numbers) or the IRS
will
 >decide that your "business" is just a "hobby" and force you to
 >go back and
 >give up all your business deductions. It doesn't

RE: Datafile Migration Tool

[K Gopalakrishnan]

Kirti,

Frankly speaking , (as of now) I have to support the database and I
don't think Oracle will support. But if you have luxury..you can always
reorgaze the database and oracle HAS to suport the database.

Initially I can give this tool for learning oracle and playing with
oracle databases, I can pack this tool with a custom block editor where
you can edit the databases, and an unloader tool (like DUL) which gives
you the data in text format from the data files.

But I don;t think Oracle will support any of these tools. :(

--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> Gopal,
> 
> So who do we call if there is a problem in the converted datafile
> later down
> the road and the database is down? The Tool Supplier or Oracle
> Support? 
> 
> Thanks.



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

RE: Simultaneously Patch Multiple DBs on same Server?

[David Wagoner]

Thanks to
those of you who emailed me offline.

 

 

Best,

 

david

 

 

-Original
Message-
From: David Wagoner 
Sent: Tuesday, August 14, 2001
4:00 PM
To: Multiple recipients of list
ORACLE-L
Subject: Simultaneously Patch
Multiple DBs on same Server?

 

Hi,

 

I plan to install an Oracle patchset (from 8.1.6.0.0
to 8.1.6.3.0) on a server that has four databases and I’m wondering if I have
to run the patch 4 times or is there a way to make it update all 4 SIDs
simultaneously?

 

Anyone have similar experiences?

 

 

TIA,

 

David Wagoner

Oracle DBA

Re: Datafile Migration Tool

[Scott Shafer]

I'm not trying to be mean about it.  I am honestly curious as to what
kind of benefit is expected from the tool or how it will work to make my
life easier.

--Scott


Rachel Carmichael wrote:
> 
> it doesn't sound like an ftp type tool. If I am reading this correctly, he
> is proposing to provide a tool that copies datafiles directly from one OS to
> another.
> 
> While this is an interesting trick, I'm not sure there's a large market for
> it.
> 
> >From: Scott Shafer <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Datafile Migration Tool
> >Date: Tue, 14 Aug 2001 12:00:53 -0800
> >
> >Not to be a smartass, but don't most OS's already have ftp built in?
> >What kind of value-added are you proposing?  Just curious...
> >
> >Scott Shafer
> >San Antonio, TX
> >
> >
> >K Gopalakrishnan wrote:
> > >
> > > Hi ,
> > >
> > > Will there be a market if I give a tool which migrates Oracle database
> > > from One OS to another OS. (Data file migration at Operating System
> > > Level.)
> > >
> > > i.e it will convert from  Oracle data files on NT to Oracle Datafiles
> > > on Solaris and vice versa.  In the target database you need to recreate
> > > the control files and you are done. You can startup the database. You
> > > don't need to export/import or CTAS over dblink..
> > >
> > > Send your replies directly to me..
> > >
> > > Thanks Yong..for bringing the cat out of the basket ;)
> > >
> > > =
> > > Have a nice day !!
> > > 
> > > Best Regards,
> > > K Gopalakrishnan,
> > > Bangalore, INDIA.
> >
> >_
> >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).
> 
> _
> 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).

_
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: Copy of redo

[Mohammad Rafiq]

Yes, definately...You can not rely on hardware mirroring as far as logs are 
concerned. Also make sure these are mirrored on different mount points with 
2 different controllersEven if it is on one controller and that 
controller gives any problem your database will be crashed.
One more suggestion for logs, if your resources allow, move log files out of 
RAID5 and put it on other drives which are not using RAID5...to improve your 
sequential writing...
Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 14 Aug 2001 12:53:44 -0800

Hi.
I'm running 3 databases : 1 using disks mirror and 2 using raid-5.
I just want your opinion on this : do I need to have the copy of redo log
files (2 redo for each redo group) or not (because it's redundant and
decreasing performance) ?
Tia

Aldi

_
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: Aldi Barco
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Copy of redo

[DBarbour]

My opinion - Yes, BECAUSE it's redundant.  If you ever have a corrupted
redo log, and it's the only member of the group, you'll wish you had
mirrored the sucker.

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


   
   
"Aldi Barco"   
   
  
com> cc:   
   
Sent by: Subject: Copy of redo 
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
08/14/2001 
   
03:53 PM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Hi.
I'm running 3 databases : 1 using disks mirror and 2 using raid-5.
I just want your opinion on this : do I need to have the copy of redo log
files (2 redo for each redo group) or not (because it's redundant and
decreasing performance) ?
Tia

Aldi

_
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: Aldi Barco
  INET: [EMAIL PROTECTED]

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

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

[Glenn Travis]

Title: RE: Personal Top 3 Oracle titles



Don't 
believe everything you read.  There are trolls 
everywhere...
 
I 
always visit my local Barnes and Noble or Borders bookstore and scan the book 
for myself.  Unless the review comes from someone I know or 
respect.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Tuesday, August 14, 2001 3:42 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Personal Top 3 Oracle 
  titles
  Yup.  Very favorable reviews and 
  the chapter list is there.  It looks very helpful. 
  
-Original Message- From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:   Tuesday, August 
14, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Subject:    Re: Personal Top 3 Oracle titles 
Before I buy a book I always check Amazon.com's 
reader reviews.  They can be very 
helpful. 
Ken Janusz, CPIM > Guy Harrison's High Performance SQL Tuning Book > Steven Feuernstein's PL/SQL books (O'Reilly) 
> > 
Both of these books taught me a lot of what I know.  I read Harrison's 
book > cover to cover.  
> > Don't forget the Oracle Documentation... ! > > I haven't 
purchased a DBA book that I thought was incredibly worthwhile 
> (yet).  I'll be buying Jonathan Lewis' 
book after the discussion on the list > though.  > 
> > > -Original Message- > > From:   Steve Armijo 
[SMTP:[EMAIL PROTECTED]] > > 
Sent:   Tuesday, August 14, 2001 1:07 
PM > > To: Multiple recipients of 
list ORACLE-L > > 
Subject:    Re: RAID or NOT to RAID?  What's the 
diff??? > > > > On Mon, Aug 13, 2001 at 11:45:20PM -0800, 
Robertson Lee - lerobe wrote: > > 
> and very nice they are too. > 
> > > > > Great book by 
the way. > > > > Hmmm, so what would folks consider their 
essential Oracle books?  maybe > 
> your > > personal top 2 or 
3? > > > > -s > > 
> > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > -- > > Author: Steve Armijo > >   INET: [EMAIL PROTECTED] > > > > Fat 
City Network Services    -- (858) 538-5051  FAX: (858) 
538-5051 > > San Diego, 
California    -- Public Internet 
access / Mailing Lists > > 
 
> > To REMOVE yourself from this mailing 
list, send an E-Mail message > > 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line 
containing: UNSUB ORACLE-L > > (or 
the name of mailing list you want to be 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: Datafile Migration Tool

[Deshpande, Kirti]

Gopal,

So who do we call if there is a problem in the converted datafile later down
the road and the database is down? The Tool Supplier or Oracle Support? 

Thanks.

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 14, 2001 2:22 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Datafile Migration Tool
> 
> Hi ,
> 
> Will there be a market if I give a tool which migrates Oracle database
> from One OS to another OS. (Data file migration at Operating System
> Level.)
> 
> i.e it will convert from  Oracle data files on NT to Oracle Datafiles
> on Solaris and vice versa.  In the target database you need to recreate
> the control files and you are done. You can startup the database. You
> don't need to export/import or CTAS over dblink..
> 
> Send your replies directly to me..
> 
> Thanks Yong..for bringing the cat out of the basket ;)
> 
> 
> 
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> 
> __
> 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: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Re[2]: Datafile Migration Tool

[dgoulet]

Rachel,

I can see what he is proposing, but I'm not sure anyone would care.  I know
I can't take the datafiles from one of our HP-UX servers and use them to create
a database on NT for instance.  Wish I could for our Support Magic junk.  In
that case they do a bunch of things (like create objects) as SYS which never get
included in an export.  The problem that I see is that there is a toolset that
currently exists, namely export & import, that work cross platform with no
problems.  Just not at the datafile level.  And although that type of tool would
be interesting to me it would not be of much value since I've only the one
problem.

Dick Goulet

Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   8/14/2001 12:41 PM

it doesn't sound like an ftp type tool. If I am reading this correctly, he 
is proposing to provide a tool that copies datafiles directly from one OS to 
another.

While this is an interesting trick, I'm not sure there's a large market for 
it.


>From: Scott Shafer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Datafile Migration Tool
>Date: Tue, 14 Aug 2001 12:00:53 -0800
>
>Not to be a smartass, but don't most OS's already have ftp built in?
>What kind of value-added are you proposing?  Just curious...
>
>Scott Shafer
>San Antonio, TX
>
>
>K Gopalakrishnan wrote:
> >
> > Hi ,
> >
> > Will there be a market if I give a tool which migrates Oracle database
> > from One OS to another OS. (Data file migration at Operating System
> > Level.)
> >
> > i.e it will convert from  Oracle data files on NT to Oracle Datafiles
> > on Solaris and vice versa.  In the target database you need to recreate
> > the control files and you are done. You can startup the database. You
> > don't need to export/import or CTAS over dblink..
> >
> > Send your replies directly to me..
> >
> > Thanks Yong..for bringing the cat out of the basket ;)
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
>
>_
>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).


_
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-- Public Internet access / Mailing Lists

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

[Pablo ksksksk]

Hi Deepak:
thanks for answering, I've already identified the
objects incurring into BBW but I also know that the p3
parameter for the BBW is "0" !! (this means that the
session A had to wait because the block that session A
needed, was being read from disk to Buffer Cache by
session B). 

I don't see how can it help to add more freelists to
this table?
I think this would have sense if p3=1016 or 1012
maybe.
I think that in this case there's no contention in the
segment header.

what do you think?
anyone else has any ideas?

thanks

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: [EMAIL PROTECTED]

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

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

Copy of redo

[Aldi Barco]

Hi.
I'm running 3 databases : 1 using disks mirror and 2 using raid-5.
I just want your opinion on this : do I need to have the copy of redo log 
files (2 redo for each redo group) or not (because it's redundant and 
decreasing performance) ?
Tia

Aldi

_
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: Aldi Barco
  INET: [EMAIL PROTECTED]

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

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

RE: Substitute for Materialized Views/Snapshots?

[Ron Rogers]

Thanks Paul,
 I remember better that I type. The error message show me to look up the correct 
spelling.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/14/01 04:06PM >>>
I ordinarily wouldn't correct a misspelling, but in this case, it matters:
it's "CONSISTENT", not "CONSISTANT".

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED] 


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


Chris,
 If you can do an export of the data you need in a short period of time you
could use the CONSISTANT=Y clause to get a "shapshot" of your tables.
ROR mª¿ªm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED] 

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

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

[tday6]

Appearances to the contrary, Canada is a separate country with their own
tax laws.

However, the tax dodge that you mention is common here too.

Here's a really good one -- become a Certified FAA Ground Instructor.  You
teach people how to pass the FAA ground exam.  Since it's not life
threatening, it's relatively simple to get this certificate.  Then get a
student or two.  After that you can buy an airplane.  The airplane, the gas
to fly it, the maintenance and hangering of the airplane, the cost of
getting the experience necessary to become a Certified Flight Instructor
(CFI), books, aircraft simulator software, landing fees, even the cost of
overnight lodging in some cases, instructors' fees (in short, a whole ton
of things that make flying a hobby for the rich) become tax deductable
because they are helping you progress in your field as an instructor.  The
IRS does not allow you to deduct training that qualifies you for a new
field but it does allow you to deduct training that allows you to progress
in your current field.  Because of the FAA requirements for becoming a CFI
almost anything having to do with flying will count as "training".



   

"Boivin, Patrice   

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

mpo.gc.ca>   cc:   

Sent by: Subject: RE: OT -- training   

[EMAIL PROTECTED]   

   

   

08/14/2001 04:17   

PM 

Please respond to  

ORACLE-L   

   

   





I know in Canada that some high-paid executives have "farms" in rural areas
(ahem, cottages really) where they grow forage, seed, or raise a couple of
sheep, rabbits, a few pigs, some chickens, or one cow.  All for tax
deductions of course.  It helps if the farm is near a lake.

Another good one is "horse farm".  There is a particularly big one in
Ontario that specializes in horse racing... and never makes a profit.  Ha
ha
ha ha ha ha...

This is my opinion, of course.  But I saw many of these when I used to
enter
farm tax records for Statistics Canada years ago.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 14, 2001 3:44 PM
 To:  Multiple recipients of list ORACLE-L
 Subject:  RE: OT -- training

 I guess that we'll let the IRS sort this one out.  Your friend is
probably
 right and I was probably overly emphatic when I said that you MUST
show a
 profit sometime.  But I would rather not leave it up to the IRS to
decide
 whether it is a business or a hobby.




 "Post, Ethan"

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

 Sent by: cc:

 root@fatcity.Subject: RE: OT --
training
 com





 08/14/2001

 01:17 PM

 Please

 respond to

 ORACLE-L









 Actually I talked to a friend who is pretty knowlegable about this
stuff
 and
 he says that what it will really come down to is intent.  The IRS is
not
 going to call your business a hobby if it is in fact unquestionably
a
 business, even if it has lost money for a period of years. - E

 >-Original Message-
 >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 >Sent: Tuesday, August 14, 2001 7:41 AM
 >To: Multiple recipients of list ORACLE-L
 >Subject: RE: OT -- training
 >
 >
 >Check with your tax advisor again or get a new tax advisor.  I
don't
 >remember the exact details but you MUST show some tax-able profit

Index question ???

[Janet Linsy]

Hi all,

According to Oracle's doc, for a table > 1000 rows, if
the query returns < 4% of the data, an index can be
built.

If I have a table, with ID 1,2, 3 return < 4% of the
row, but ID 4, 5, 6 returns > 4% rows.  Should I build
an index on ID column?

Also you know any general guildlines for building, not
building indexes?  OEM generates suggestions too,
should I follow?

Thanks you!

Janet

__
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: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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

Re: Datafile Migration Tool

[Rachel Carmichael]

it doesn't sound like an ftp type tool. If I am reading this correctly, he 
is proposing to provide a tool that copies datafiles directly from one OS to 
another.

While this is an interesting trick, I'm not sure there's a large market for 
it.


>From: Scott Shafer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Datafile Migration Tool
>Date: Tue, 14 Aug 2001 12:00:53 -0800
>
>Not to be a smartass, but don't most OS's already have ftp built in?
>What kind of value-added are you proposing?  Just curious...
>
>Scott Shafer
>San Antonio, TX
>
>
>K Gopalakrishnan wrote:
> >
> > Hi ,
> >
> > Will there be a market if I give a tool which migrates Oracle database
> > from One OS to another OS. (Data file migration at Operating System
> > Level.)
> >
> > i.e it will convert from  Oracle data files on NT to Oracle Datafiles
> > on Solaris and vice versa.  In the target database you need to recreate
> > the control files and you are done. You can startup the database. You
> > don't need to export/import or CTAS over dblink..
> >
> > Send your replies directly to me..
> >
> > Thanks Yong..for bringing the cat out of the basket ;)
> >
> > =
> > Have a nice day !!
> > 
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
>
>_
>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).


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

RE: New (sort of) Oracle parameters

[Smith, Ron L.]

I am trying to get sql*net to trace my connection to the database from my
desktop.  Oracle says I can set trace_level_client to 16 and I will see the
userid and password in the trace file.  I tried it but I don't get either
one.  I get a lot of other stuff in the trace file but no userid or
password.  Anyone tried this?
 
Ron

-Original Message-
Sent: Tuesday, August 14, 2001 1:55 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


absolutely, just tried it
 
create user testuser identified by xx;
grant create session, select any table to testuser;
connect testuser/xx
select password from sys.link$;
 
shows it all.
 
joe
 


>>> [EMAIL PROTECTED] 08/14/01 03:27PM >>>
If what I have read is true then you are telling me that anyone with
select_any_table permissions can read your sys.link$ view and get the userid
and passwords for any database links.  Also, the passwords are not encrypted
when using database links.  The ORA_ENCRYPT_LOGIN is a client parameter that
says to send the password encrypted.

Ron

-Original Message-
Sent: Tuesday, August 14, 2001 12:18 PM
To: Multiple recipients of list ORACLE-L


Ron,

Hp_UX 11.0.32   Database 8.1.6.2

We are running with following settings for couple of months without having 
any problem. No 1. parameter default is TRUE...
1- O7_DICTIONARY_ACCESSIBILITYTRUE

2- dblink_encrypt_login   FALSE

3- ORA_ENCRYPT_LOGIN   -Not found in v$parameters


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 14 Aug 2001 06:25:23 -0800

Is anyone using any of the folowing Oracle parameters?  Are there any
problems associated with using them?

07_DICTIONARY_ACCESSIBILITY

DBLINK_ENCRYPT_LOGIN

ORA_ENCRYPT_LOGIN

Ron Smith
Database Administrator
[EMAIL PROTECTED]
--
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).


_
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: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

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

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

[Jonathan Lewis]

Enqueue waits cannot cause buffer busy waits,
but the absence of indexes (and you point out
missing FK indexes) can result in excessive
tablescanning, and tablescanning can result
in buffer busy waits.

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






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

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

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

[Boivin, Patrice J]

I know in Canada that some high-paid executives have "farms" in rural areas
(ahem, cottages really) where they grow forage, seed, or raise a couple of
sheep, rabbits, a few pigs, some chickens, or one cow.  All for tax
deductions of course.  It helps if the farm is near a lake.

Another good one is "horse farm".  There is a particularly big one in
Ontario that specializes in horse racing... and never makes a profit.  Ha ha
ha ha ha ha...

This is my opinion, of course.  But I saw many of these when I used to enter
farm tax records for Statistics Canada years ago.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 14, 2001 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT -- training

I guess that we'll let the IRS sort this one out.  Your friend is
probably
right and I was probably overly emphatic when I said that you MUST
show a
profit sometime.  But I would rather not leave it up to the IRS to
decide
whether it is a business or a hobby.




"Post, Ethan"

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

Sent by: cc:

root@fatcity.Subject: RE: OT --
training   
com





08/14/2001

01:17 PM

Please

respond to

ORACLE-L









Actually I talked to a friend who is pretty knowlegable about this
stuff
and
he says that what it will really come down to is intent.  The IRS is
not
going to call your business a hobby if it is in fact unquestionably
a
business, even if it has lost money for a period of years. - E

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 7:41 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: OT -- training
>
>
>Check with your tax advisor again or get a new tax advisor.  I
don't
>remember the exact details but you MUST show some tax-able profit
for a
>certain number of years out of every so many years (eg, 1 year
>out of the
>last 4 - I'm not sure that those are the right numbers) or the IRS
will
>decide that your "business" is just a "hobby" and force you to
>go back and
>give up all your business deductions. It doesn't have to be a
>huge profit,
>but it does have to be a positive number.
>
>
>
>
>lhoska@calibr
>
>esys.com To: Multiple
>recipients of list ORACLE-L
>Sent by:
><[EMAIL PROTECTED]>
>root@fatcity.cc:
>
>com  Subject: RE: OT
>-- training
>
>
>
>
>08/13/2001
>
>06:05 PM
>
>Please
>
>respond to
>
>ORACLE-L
>
>
>
>
>
>
>
>
>
>I've heard from my tax adviser your business doesn't have to show
any
>profit
>for number of years after opening.  I suspect even then it is
>not required.
>What if you having hard time making profit?  It doesn't mean
>you have to
>close your business...I assume in that case you can also register
as a
>non-profit organization.  Are tax breaks better for
>non-profits?  I don't
>know..
>Also, if you don't already know.. some training companies
>(Learning Tree
>International per example) won't even register you for class
>if you're an
>individual.  You have to be a corporation.
>Lyuda
>
>-Original Message-
>Sent: Monday, August 13, 2001 3:42 PM
>To: Multiple recipients of list ORACLE-L
>
>
>You could create a web site that features some technical
>materials and use
>it to advertise your services if you are willing to moonlight on a
few
>jobs,
>just enough to turn a profit within a couple years.  Then I
>would presume
>you would have no trouble writing the training off as a legitimate
biz
>exp

Re:RE: Re[2]: How can I get my DB back if I lost one of my r

[Rachel Carmichael]

>From: [EMAIL PROTECTED]



>
>Now the original post stated that they had forgotten to backup this 
>datafile.
>The reasons for doing so vary a lot, but there is a common and failsafe 
>method
>to prevent this.  It's just a matter of laying out your filesystem in such 
>a way
>that you cannot miss a datafile.

or you could use the data dictionary to create the script of datafiles to 
backup. Hard to miss one when you are selecting the names of the database's 
datafiles from within the database.


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

RE: OT -- training

[Kevin Kostyszyn]

I'm definatley going to that one.
KK

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


Rachel,
I hope you have a lot of time set aside for the presentors. It sounds like a
great cast to listen to and a hard act to follow. A small note:  I attended
a seminar presented by Mike Ault and Rich Niemiec about the new 9i database.
There was not enough time in the evening to cover it completely. Both
speakers lived up to expectations and could have filled an additional 3
hours if given time.
 I only wish that I was closer and able to attend. Will their papers be on
the website after the meeting?
Thanks,
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/14/01 02:37PM >>>
Yep, I got lucky, and called on a lot of people I know.

For those of you lost in this semi-private conversation, the NYOUG meeting
on September 12th (and yes, non-members are welcome) is being called the
"Literary Lights" meeting.

presenters include: our own Gaja Krishna Vaidyanatha and Ari Kaplan, Rich
Niemiec, Kevin Loney, Marlene Theriault, Douglas Scherer, John Beresniewicz,
Ulka Rodgers and Paul Dorsey.

oh yeah, I'll be hanging out there. But I had so many great presenters I had
to bump myself off the agenda :)

check it out, www.nyoug.org




>From: "Miller, Jay" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 09:00:37 -0800
>
>Pretty amazing actually.  I won't feel so bad about missing the cruise this
>year :-( If I get get to attend this one.
>
>Jay Miller
>
>
>-Original Message-
>Sent: Monday, August 13, 2001 10:21 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
> >On the other hand, I can take the day off for the NY Users Group when
>there
>
> >aren't any emergencies (about 50% of the time).
> >
> >
> >Jay Miller
> >
>
>
>try not to have any emergencies on September 12th :)   it's gonna be a good
>one!
>
>Rachel
>
>_
>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: Miller, Jay
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
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: 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: Kevin K

RE: Substitute for Materialized Views/Snapshots?

[Paul Baumgartel]

I ordinarily wouldn't correct a misspelling, but in this case, it matters:
it's "CONSISTENT", not "CONSISTANT".

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]


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


Chris,
 If you can do an export of the data you need in a short period of time you
could use the CONSISTANT=Y clause to get a "shapshot" of your tables.
ROR mª¿ªm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

Re: Datafile Migration Tool

[Scott Shafer]

Not to be a smartass, but don't most OS's already have ftp built in? 
What kind of value-added are you proposing?  Just curious...

Scott Shafer
San Antonio, TX


K Gopalakrishnan wrote:
> 
> Hi ,
> 
> Will there be a market if I give a tool which migrates Oracle database
> from One OS to another OS. (Data file migration at Operating System
> Level.)
> 
> i.e it will convert from  Oracle data files on NT to Oracle Datafiles
> on Solaris and vice versa.  In the target database you need to recreate
> the control files and you are done. You can startup the database. You
> don't need to export/import or CTAS over dblink..
> 
> Send your replies directly to me..
> 
> Thanks Yong..for bringing the cat out of the basket ;)
> 
> =
> Have a nice day !!
> 
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.

_
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: New (sort of) Oracle parameters

[JOE TESTA]

absolutely, just tried it
 
create user testuser identified by xx;
grant create session, select any table to 
testuser;
connect testuser/xx
select password from sys.link$;
 
shows it all.
 
joe
 
>>> [EMAIL PROTECTED] 08/14/01 03:27PM >>>If 
what I have read is true then you are telling me that anyone 
withselect_any_table permissions can read your sys.link$ view and get the 
useridand passwords for any database links.  Also, the passwords are 
not encryptedwhen using database links.  The ORA_ENCRYPT_LOGIN is a 
client parameter thatsays to send the password 
encrypted.Ron-Original Message-Sent: Tuesday, August 
14, 2001 12:18 PMTo: Multiple recipients of list 
ORACLE-LRon,Hp_UX 11.0.32   Database 
8.1.6.2We are running with following settings for couple of months 
without having any problem. No 1. parameter default is TRUE...1- 
O7_DICTIONARY_ACCESSIBILITY    TRUE2- 
dblink_encrypt_login   
FALSE3- ORA_ENCRYPT_LOGIN   -Not found in 
v$parametersMOHAMMAD RAFIQReply-To: 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>Date: Tue, 14 Aug 2001 06:25:23 -0800Is 
anyone using any of the folowing Oracle parameters?  Are there 
anyproblems associated with using 
them?07_DICTIONARY_ACCESSIBILITYDBLINK_ENCRYPT_LOGINORA_ENCRYPT_LOGINRon 
SmithDatabase Administrator[EMAIL PROTECTED]--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-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)._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: 
Mohammad Rafiq  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: 
Smith, Ron L.  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: OEM: Shutdown database

[JOE TESTA]

1. you need to have an external password file 
created.
2.  you need to add the userid you want to shutdown the 
database to that password file by  grant sysdba to username
3.  you might have to change the init.ora file, the 
remote_login_passwordfile entry.
 
joe
 
>>> [EMAIL PROTECTED] 08/14/01 02:56PM 
>>>I am using OEM and have connected to my database, a test DB 
I justcreated (my first actually). I can't seem to shut it down.  
Theoptionsto SHUTDOWN are grayed out.  I have connected as SYSTEM 
and SYS andtheuser I created the DB with!  I went to the enable 
roles option andenabled the roles that I could, such as DBA. Would someone 
explainwhatI am missing, even if it is where to go and RTFM.  I 
don't have anyRealmanuals but can find the virtual ones 
online.When I try changing connect as to SYSOPER or SYSDBA I get 
"invalidpassword/user name"TIA - 
  Arich H.-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Arich 
Henneman  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).

Simultaneously Patch Multiple DBs on same Server?

[David Wagoner]

Hi,

 

I plan to install an Oracle patchset (from 8.1.6.0.0 to 8.1.6.3.0) on a
server that has four databases and I’m wondering if I have to run the patch 4
times or is there a way to make it update all 4 SIDs simultaneously?

 

Anyone have similar experiences?

 

 

TIA,

 

David Wagoner

Oracle DBA

RE: OT -- training

[Ron Rogers]

Rachel,
I hope you have a lot of time set aside for the presentors. It sounds like a great 
cast to listen to and a hard act to follow. A small note:  I attended a seminar 
presented by Mike Ault and Rich Niemiec about the new 9i database. There was not 
enough time in the evening to cover it completely. Both speakers lived up to 
expectations and could have filled an additional 3 hours if given time.
 I only wish that I was closer and able to attend. Will their papers be on the website 
after the meeting?
Thanks,
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/14/01 02:37PM >>>
Yep, I got lucky, and called on a lot of people I know.

For those of you lost in this semi-private conversation, the NYOUG meeting 
on September 12th (and yes, non-members are welcome) is being called the 
"Literary Lights" meeting.

presenters include: our own Gaja Krishna Vaidyanatha and Ari Kaplan, Rich 
Niemiec, Kevin Loney, Marlene Theriault, Douglas Scherer, John Beresniewicz, 
Ulka Rodgers and Paul Dorsey.

oh yeah, I'll be hanging out there. But I had so many great presenters I had 
to bump myself off the agenda :)

check it out, www.nyoug.org 




>From: "Miller, Jay" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 09:00:37 -0800
>
>Pretty amazing actually.  I won't feel so bad about missing the cruise this
>year :-( If I get get to attend this one.
>
>Jay Miller
>
>
>-Original Message-
>Sent: Monday, August 13, 2001 10:21 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
> >On the other hand, I can take the day off for the NY Users Group when 
>there
>
> >aren't any emergencies (about 50% of the time).
> >
> >
> >Jay Miller
> >
>
>
>try not to have any emergencies on September 12th :)   it's gonna be a good
>one!
>
>Rachel
>
>_
>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: Miller, Jay
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
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: 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: Urgent Help Required. ORA-65535

[DBarbour]

Mantri,

Not sure, but all the Fatal NI connect errors I've ever experienced had to
do with my listener configuration.

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


   
 
kamesh.mantri@or   
 
ange.co.uk To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
Sent by:   cc: 
 
[EMAIL PROTECTED]   Subject: Urgent Help Required. 
ORA-65535 
   
 
   
 
08/14/2001 01:01   
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 






Hi All,
   I am facing a very different problem.
I am using Oracle as a XA Resouce Manager for Encina.

The Encina applications built using Oracle 8.0.6 are working fine. When we
moved
the Oracle version to
Oracle 8.0.6.3 the applications are not able to connect to the database.

It gives the following error:

ORA-65535 ( No description)

I was not able to find the description for the same anywhere in Oracle
documentation.

The SQLNet Log has entries like

***
Fatal NI connect error -1, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=sysfep))(CONNECT_DATA
=(SID=sysfep)(CID=(PROGRAM=)(HOST=fbm

ntfp2)(USER=poise

  VERSION INFORMATION:
TNS for HPUX: Version 8.0.6.3.0 - Production
  Time: 13-AUG-2001 16:14:43
  Tracing to file: /tmp/stu_client.log_24465.trc


***


I also creates a XA trace file with its entries like:


161443.24465.0:
xaolog: Could not open file in directory
/opt/oracle/product/8.0.6.3/rdbms/log


ORACLE XA: Version 8.0.6.0.0. RM name = 'Oracle_XA'.


161443.24465.0:
ORA-65535: Message 65535 not found;  product=RDBMS; facility=ORA
*


I would be really great if any of you'all can help me ASAP.

Regards
Kamesh.





***

Important. This E-mail is intended for the above named person and may be
confidential and/or legally privileged. If this has come to you in error
you
must take no action based on it, nor must you copy or show it to anyone;
please
inform the sender immediately.
***


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

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

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




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

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

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

Statspack question - Execute to Parse %

[Louis Avrami]

Hello all,

I recently created some Level 5 Statspack snapshots for an Oracle
8.1.7.0 database.  Here's a portion of a snapshot report:

Instance Efficiency Percentages (Target 100%)
~
Buffer Nowait %:  100.00   Redo NoWait %:  100.00
Buffer  Hit   %:   99.94In-memory Sort %:   99.46
Library Hit   %:   99.37Soft Parse %:   99.53
Execute to Parse %:1.59  Latch Hit %:   97.47


The particular stat that I am unsure about is "Execute to Parse
%".  Can anyone share with me what exactly this maps back to,
and what might be tuned to improve this number?

Thanks,
Lou Avrami ( [EMAIL PROTECTED] )





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

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

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

sqlplus and substr command

[Yttri, Lisa]

Title: sqlplus and substr command





Hi -


Can someone tell me if sqlplus functionality has changed between version 8.1.5 and 8.1.7 (on Sun Solaris)?  I have a couple of queries that used the substr function on some longer columns.  When I run it against my 8.1.5 database, the substr works fine.  It appears to be ignored when I run the same query against my 8.1.7 database.

How do I get around this?  If I define a fixed-length column, will that do it?


Thanks for any assistance you can give me -
Lisa

Re: Substitute for Materialized Views/Snapshots?

[Ron Rogers]

Chris,
 If you can do an export of the data you need in a short period of time you could use 
the CONSISTANT=Y clause to get a "shapshot" of your tables.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/14/01 03:21PM >>>
Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle
- there is no materialized view functionality for SE.

Chris - Alas, transportable tablespaces are not available for SE either.

I'm still looking for suggestions.  The tables need to be
read-consistent down to the second.  Is there a way I can do a CREATE AS
SELECT or COPY for all five tables in a way that ensures this?

Chris


"A. Bardeen" wrote:
> 
> Chris,
> 
> Read-only and updatable snapshots/materialized views
> are available with the Standard Edition starting with
> 8.1.5; SE can also be used for the master site for
> snapshots/MV's.  EE is required only for multi-master
> replication and the data warehousing features of MV's
> (e.g. summary management, etc...)
> 
> The following metalink doc has the differences:
> 
> Note: 112591.1 "Differences Between Standard Edition
> and Enterprise Edition in 8i"
> 
> HTH,
> 
> -- Anita
> 
> --- Chris Rezek <[EMAIL PROTECTED]> wrote:
> > We are running 8.1.6 Standard Edition on Solaris
> > hardware.  We are
> > building a reporting system and would have liked to
> > use materialized
> > views (snapshots) but this feature is not available
> > in Standard
> > Edition.  We need to create read-consistent copies
> > of several
> > million-row tables each night at midnight.  How can
> > we do this without
> > Oracle's auto-updating materialized views?
> >
> > Chris Rezek
> > Oracle DBA
> > http://www.dmn.com 
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com 
> > --
> > Author: Chris Rezek
> >   INET: [EMAIL PROTECTED] 
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (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: Chris Rezek
  INET: [EMAIL PROTECTED] 

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

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

Datafile Migration Tool

[K Gopalakrishnan]

Hi ,

Will there be a market if I give a tool which migrates Oracle database
from One OS to another OS. (Data file migration at Operating System
Level.)

i.e it will convert from  Oracle data files on NT to Oracle Datafiles
on Solaris and vice versa.  In the target database you need to recreate
the control files and you are done. You can startup the database. You
don't need to export/import or CTAS over dblink..

Send your replies directly to me..

Thanks Yong..for bringing the cat out of the basket ;)



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
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: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

RE: Personal Top 3 Oracle titles

[Koivu, Lisa]

Title: RE: Personal Top 3 Oracle titles





Yup.  Very favorable reviews and the chapter list is there.  It looks very helpful. 


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 14, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: Personal Top 3 Oracle titles


Before I buy a book I always check Amazon.com's reader 
reviews.  They can be very helpful.


Ken Janusz, CPIM
> Guy Harrison's High Performance SQL Tuning Book
> Steven Feuernstein's PL/SQL books (O'Reilly)
> 
> Both of these books taught me a lot of what I know.  I read Harrison's book
> cover to cover.  
> 
> Don't forget the Oracle Documentation... !
> 
> I haven't purchased a DBA book that I thought was incredibly worthwhile
> (yet).  I'll be buying Jonathan Lewis' book after the discussion on the list
> though.  
> 
> 
> > -Original Message-
> > From:   Steve Armijo [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 14, 2001 1:07 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:    Re: RAID or NOT to RAID?  What's the diff???
> > 
> > On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote:
> > > and very nice they are too.
> > > 
> > > Great book by the way.
> > 
> > Hmmm, so what would folks consider their essential Oracle books?  maybe
> > your
> > personal top 2 or 3?
> > 
> > -s
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Steve Armijo
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California    -- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be 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: New (sort of) Oracle parameters

[Smith, Ron L.]

If what I have read is true then you are telling me that anyone with
select_any_table permissions can read your sys.link$ view and get the userid
and passwords for any database links.  Also, the passwords are not encrypted
when using database links.  The ORA_ENCRYPT_LOGIN is a client parameter that
says to send the password encrypted.

Ron

-Original Message-
Sent: Tuesday, August 14, 2001 12:18 PM
To: Multiple recipients of list ORACLE-L


Ron,

Hp_UX 11.0.32   Database 8.1.6.2

We are running with following settings for couple of months without having 
any problem. No 1. parameter default is TRUE...
1- O7_DICTIONARY_ACCESSIBILITYTRUE

2- dblink_encrypt_login   FALSE

3- ORA_ENCRYPT_LOGIN   -Not found in v$parameters


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 14 Aug 2001 06:25:23 -0800

Is anyone using any of the folowing Oracle parameters?  Are there any
problems associated with using them?

07_DICTIONARY_ACCESSIBILITY

DBLINK_ENCRYPT_LOGIN

ORA_ENCRYPT_LOGIN

Ron Smith
Database Administrator
[EMAIL PROTECTED]
--
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).


_
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: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

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

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

[Bowes, Chris]

Title: RE: OT -- MS SQL Server is putting Oracle to shame,





True, but one line he had that was truthful was "Our database business is one of the best places you could wish to be right now".  I know of a lot of people changing from Oracle to Sqlserver.  We are.  As Lisa Koivu put it, I'm slipping to the Dark Side (but my heart will always be Oracle so I can come back to the light).  My CIO, like a lot of them, has the sqlserver bug and has ordered all projects rewritten in vb/sqlserver company wide. In the next few years/decades Oracle and Sqlserver will be bumping each other like crazy.  There will be truck loads of cash to be made in migrations from one to the other (and then back probably). And I'm not talking those piddly S-10 or 4x4 sized trucks.  We're talking the megaton sized gravel trucks or maybe even C10 plane sized...  I welcome the sqlserver challenge.  Bring it on M$soft.  The more they and Oracle fight, the more money/job security we can have.

--Chris
[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:OT -- MS SQL Server is putting Oracle to shame,



Patrice,


    Thanks for the message, we all over here had one heck of a good laugh.  It
just shows that MS is still running around with there heads in the ground and
phony sales figures.  Bet you did not know that every one who buys Windows
Server gets a SQL*server license right along with it.  It's a built in.  And
we're looking at migrating from Windows as our network server to Red Hat along
with some others I know, and a couple of VERY big players who have.  Why,
because it's cheaper to run Red Hat than Windows in both terms of hardware and
software.  Sure we'll keep Windows on the desk top, but it's likely out of here
in the computer room.


BTW: since MS has been declared a monopoly, and that portion of the anti-trust
suit has been affirmed, a break up of MS is still in the cards so some of those
statements about not porting may have to be retracted.  OH also, watch out when
someone, even Oracle, starts throwing bench marks around, they all lie.


Dick Goulet


Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   8/14/2001 8:21 AM


http://www.theregister.co.uk/content/53/21003.html
 


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services    | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED]  


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


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

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


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


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

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

[Page, Bruce]

I can.  My wife, daughter, and sister-in-law have me a the point of doing what ever I 
can to put Beanie Babies under.  And don't forget the EMC disk storage with all its 
bells too.

> Although any day of the week I would rather have a $1,000,000 unix box
> running Oracle.   But I cannot with a straight face tell 15 
> person company
> selling Beanie babies on Ebay to buy that setup.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  INET: [EMAIL PROTECTED]

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

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

Size of Oracle binaries of Oracle 8i vs 8.0 on Windows

[Cale, Rick T (Richard)]

Hi,

I have searched the Oracle 8i EE getting started for how much larger the
Oracle 8i binaries are bigger than version 8. It said it was 3
times larger than Oracle 7 but I am curious how much larger than Oracle8.0.x

Also, since MetaLink is down once again does anyone know when Oracle 8.0
will be desupported.

Thanks
Rick





-- 
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: Performance analysis (enqueue and buffer busy waits)

[Deepak Thapliyal]

Hi pablo,

try identifying the segments that are being contended
for using information of p1,p2 for buffer busy waits
and add more freelists for these segments. This
assumes that you have already separated your data and
indexes appropriately overe separate mount points. 

As for enqueues leading to bbw .. my guesstimate would
be that oracle would not do this .. but instead wait
on another enqueue in this case .. correct me if i am
wrong here guys ..


hth
Deepak


--- Pablo ksksksk <[EMAIL PROTECTED]> wrote:
> Hi list:
> I've been analyzing an instance's performance
> for
> some time. I found a lot of enqueue and a lot of
> buffer busy waits.
> 
> Tracing the instance's sessions for some time I
> found
> that enqueue waits are mostly because of FK not
> being
> indexed. This of course generated shared locks
> (level
> 4) over child tables when a parent row was updated,
> deleted or inserted. I can solve this by creating
> the
> missing indexes.
> 
> In reference to the Buffer busy waits, mostly of
> these
> waits takes place over TABLES and p3=0 in all cases.
> I think that p3=0 indicates that a session wants a
> block that is being read from disk by another
> session.
> Keeping the object in memory will solve this
> problem,
> but unfortunately this is not an option as I'm
> working
> with Oracle 7.3.4. and the tables are big. I think
> that a lot of queries are using these TABLES.
> 
> The question is what can I do to solve this BBW?
> 
> And another curiosity question, can enqueue waits
> generate buffer busy waits ? (as a session is
> waiting
> for some buffer that another session is holding in
> an
> incompatible mode)
> 
> 
> TIA
> 
> 
> 
> 
> 
> 
> 
>
___
> Do You Yahoo!?
> Yahoo! Messenger: Comunicación instantánea gratis
> con tu gente -
> http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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

RE: having select from db link problems from 8.0.5.2.1

[lhoska]

did you try to recreate the link?

-Original Message-
Sent: Tuesday, August 14, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L


already did that , doesn't work, funny thing is I can tnsping that foreign
database but doesn't work through db link.
Thanks
Sandesh


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L



Add the foreign host name to your local /etc/hosts file.

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


 

"Naik, Sandesh

S"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>  
   Subject: having select from db
link problems from 8.0.5.2.1  
Sent by:

[EMAIL PROTECTED]

om

 

 

08/14/2001

12:06 PM

Please respond

to ORACLE-L

 

 





Dear List,
 I have 8.0.5.2.1(32bit) database on HP-UX 11.0 server.
 I have a database link connecting to other database.  I get following
error
while trying to access objects thorough db link ( db link goes to 8.1.6.2.0
(64bit) database on HP-UX 11.0

" ORA-12545: Connect failed because target host or object does not exist "

There is work around to put IP address for this host in tnsnames.ora which
fixes the problems. Is there any other good solution to this problem?
 All your suggestions are always welcome.

Thank you

Sandesh Naik
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naik, Sandesh S
  INET: [EMAIL PROTECTED]

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

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




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

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

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

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

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

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

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

Re: Re[2]: How can I get my DB back if I lost one of my

[Rachel Carmichael]

rollback segs will be used in INSTANCE recovery... not in media recovery

shutdown abort does not flush anything from the SGA, remember? it forces 
instance recovery.

if you do a clean shutdown, you will not need the rollback segments.

>From: "JOE TESTA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Re[2]: How can I get my DB back if I lost one of my
>Date: Tue, 14 Aug 2001 09:40:53 -0800
>
>Well there must be something to the statement, back in v7 days, i did a 
>shtdown abort, when i had a lrage RBS online(and not in the init.ora file), 
>well when i tried to bring the db backup, it refused until i put the rbs in 
>the init.ora file and oracle could then do recovery, short of an instance 
>crash or shutdown abort, i'm with you.
>
>
>joe
>
>
>
> >>> [EMAIL PROTECTED] 08/14/01 12:26PM >>>
>Riyaj,
>
> Rollback segments are needed for recovery?  I think your confused with 
>the
>online redo logs.  When a DB shuts down the rollback segments are emptied 
>out
>either because the transactions have been rolled back or committed.  Once 
>you
>start the recovery process the rollback segments are no longer required as 
>the
>data therein is in the on-line redo logs.
>
>Dick Goulet
>
>Reply Separator
>Author: [EMAIL PROTECTED]
>Date:   8/14/2001 6:41 AM
>
>Hermanto
> Rollback segment data files are *needed* for recovery. Rollback
>segments are the key component for consistent media/instance recovery. If
>you lose any of the rollback segment files and if any extents from that
>datafile are needed then the database can not do the recovery consistently
>and will give you errors. Is it the only data file associated with the
>rollback segment tablespace. If that is the case, there will be extents
>from the rollback segments. If there are no extents from the rollback
>segments then you could potentially offline drop the datafile, do the
>media recovery and do open resetlogs. What errors are you getting ? Stuck
>recovery ? Errors will tell you whether the recovery process is looking
>for rollback segments or the data file.
> Please contact Oracle support if there are any rollback extents in
>this datafile. _offline_rollback_segments and _corrupted_rollback_segments
>parameters can be used to hard open the database. But DO expect data
>consistency errors. In fact, only thing you should do is open this way,
>extract the data out and import in to a new database. Contact Oracle
>Support before you do this since there are serious consequences of doing
>this.
>
>Thanks
>Riyaj "Re-yas" Shamsudeen
>Certified Oracle DBA
>i2 technologies   www.i2.com
>
>
>
>
>Hermanto P <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
>08/14/01 03:35 AM
>Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L 
><[EMAIL PROTECTED]>
> cc:
> Subject:How can I get my DB back if I lost one of my 
>rollback
>segment (rb
>
>
>Hi gurus,
>Recently, I have forgotten to backup one of rollback segment file
>(rbs02.dbf).
>When I want to restore..the db can not startup normally.
>Anyone can give me advise..
>Thanks in advance.
>
>Warm regards,
>Hermanto
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hermanto P
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>Hermanto
>        Rollback 
>segment
>data files are *needed* for recovery. Rollback segments are the key 
>component
>for consistent media/instance recovery. If you lose any of the rollback 
>segment
>files and if any extents from that datafile are needed then the database 
>can not
>do the recovery consistently and will give you errors. Is it the only data 
>file
>associated with the rollback segment tablespace. If that is the case, there 
>will
>be extents from the rollback segments. If there are no extents from the 
>rollback
>segments then you could potentially offline drop the datafile, do the media
>recovery and do open resetlogs. What errors are you getting ? Stuck 
>recovery ?
>Errors will tell you whether the recovery process is looking for rollback
>segments or the data file.
>        Please 
>contact
>Oracle support if there are any rollback extents in this datafile.
>_offline_rollback_segments and _corrupted_rollback_segments parameters can 
>be
>used to hard open the database. But DO expect data consistency errors. In 
>fact,
>only thing you shou

OEM: Shutdown database

[Arich Henneman]

I am using OEM and have connected to my database, a test DB I just
created (my first actually). I can't seem to shut it down.  The
options
to SHUTDOWN are grayed out.  I have connected as SYSTEM and SYS and
the
user I created the DB with!  I went to the enable roles option and
enabled the roles that I could, such as DBA. Would someone explain
what
I am missing, even if it is where to go and RTFM.  I don't have any
Real
manuals but can find the virtual ones online.

When I try changing connect as to SYSOPER or SYSDBA I get "invalid
password/user name"

TIA - 
  Arich H.

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

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

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

[tday6]

I guess that we'll let the IRS sort this one out.  Your friend is probably
right and I was probably overly emphatic when I said that you MUST show a
profit sometime.  But I would rather not leave it up to the IRS to decide
whether it is a business or a hobby.


   

"Post, Ethan"  

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

m>   <[EMAIL PROTECTED]>

Sent by: cc:   

root@fatcity.Subject: RE: OT -- training   

com

   

   

08/14/2001 

01:17 PM   

Please 

respond to 

ORACLE-L   

   

   





Actually I talked to a friend who is pretty knowlegable about this stuff
and
he says that what it will really come down to is intent.  The IRS is not
going to call your business a hobby if it is in fact unquestionably a
business, even if it has lost money for a period of years. - E

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 7:41 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: OT -- training
>
>
>Check with your tax advisor again or get a new tax advisor.  I don't
>remember the exact details but you MUST show some tax-able profit for a
>certain number of years out of every so many years (eg, 1 year
>out of the
>last 4 - I'm not sure that those are the right numbers) or the IRS will
>decide that your "business" is just a "hobby" and force you to
>go back and
>give up all your business deductions. It doesn't have to be a
>huge profit,
>but it does have to be a positive number.
>
>
>
>
>lhoska@calibr
>
>esys.com To: Multiple
>recipients of list ORACLE-L
>Sent by:
><[EMAIL PROTECTED]>
>root@fatcity.cc:
>
>com  Subject: RE: OT
>-- training
>
>
>
>
>08/13/2001
>
>06:05 PM
>
>Please
>
>respond to
>
>ORACLE-L
>
>
>
>
>
>
>
>
>
>I've heard from my tax adviser your business doesn't have to show any
>profit
>for number of years after opening.  I suspect even then it is
>not required.
>What if you having hard time making profit?  It doesn't mean
>you have to
>close your business...I assume in that case you can also register as a
>non-profit organization.  Are tax breaks better for
>non-profits?  I don't
>know..
>Also, if you don't already know.. some training companies
>(Learning Tree
>International per example) won't even register you for class
>if you're an
>individual.  You have to be a corporation.
>Lyuda
>
>-Original Message-
>Sent: Monday, August 13, 2001 3:42 PM
>To: Multiple recipients of list ORACLE-L
>
>
>You could create a web site that features some technical
>materials and use
>it to advertise your services if you are willing to moonlight on a few
>jobs,
>just enough to turn a profit within a couple years.  Then I
>would presume
>you would have no trouble writing the training off as a legitimate biz
>expense.
>
>- Ethan
>- http://www.geocities.com/epost1
>
>>-Original Message-
>>From: Ron Rogers [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, August 13, 2001 11:42 AM
>>To: Multiple recipients of list ORACLE-L
>>Subject: Re: OT -- training
>>
>>
>>Patrice,
>> There is "resistance" to any training that I feel is
>>necessary to further my knowledge and/or enhance my
>>understanding of the Oracle processes. Even though I have
>>money in the budget for such items I have to submit a business
>>case defining the gains to the company and after completing
>>the course with a passing grade the company will reimburse me
>>the expenses for the course only. I also have to sign a waver
>>that I will pay the company back the full cost of the course
>>if I leave their e

NT/W2K Services - Thanks

[Koivu, Lisa]

Title:  NT/W2K Services - Thanks 





Patrice, thank you so much for sending this to me (and the list).  This explains a lot.  
Also, thanks to Kevin Lange.   


Now I need to get over my initial nauseous feeling from running an oracle database on Windows. 


LK


-Original Message-
From:   Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 14, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: I admit this is dumb.  NT/W2K Services?


I haven't worked on Windows2000, but if it's like NT, you have two things to
worry about when starting Oracle in the Windows environment:


The background service has to be running, to provide a context.
The instance has to be started otherwise it is in shutdown mode.


On NT 4, there is an NT Service that runs like a daemon in the background.
When you start the service it automatically tries to start the instance like
when we issue startup open at the svrmgrl prompt in UNIX.


On Windows2000 it must be trying to do the same thing.


Usually on NT if the service hasn't started and you try to access the db
from svrmgrl, it tells you there has been a protocol error.  This is
misleading, in fact the problem is that there is no context for Oracle to
run in, i.e. the NT Service hasn't been started.


In Oracle 7.3. you can tell that Oracle hadn't finished porting their rdbms,
because there were two separate NT services - one to provide the context,
one to issue startup open.  In Oracle 8I there is only one NT service that
tries to do both.


I suspect that if you are low on memory, the NT / Win2K service may be able
to "create" a context for Oracle to run in, but not have enough memory
available to effectively start the Oracle instance.  So you may end up with
Win2K service showing up as started, when in fact the db is half opened and
therefore not usable.  You can try opening a DOS box and shutting it down
then re-starting it from the command prompt if that happens, DK if it will
work.


HTH
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services    | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED]  




    -Original Message-
    From:   Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
    Sent:   Tuesday, August 14, 2001 2:22 PM
    To: Multiple recipients of list ORACLE-L
    Subject:    I admit this is dumb.  NT/W2K Services?


    I'm playing with Oracle on w2k out of sheer boredom.  So now I'm
forced to learn a little bit about w2k.  


    I was looking at oradim and it has starttype and shuttype with
options srvc and inst.  OK, I understand the instance part.  But what on
earth are services?  Below is what the help says about it.  So to translate
this into Unix-speak, is this similar to a daemon?  I guess I'm confused
because as far as I know there's nothing additional that needs to be running
on Unix to just start up a database.  


    If that's the case, then why would you want to shut down an instance
and not services?  For RMAN?  I guess I'm at a loss here.  Can someone give
me an example of when you'd want to do this?  


    Plus, there's notes on Metalink about recreating services.  Why/when
would you want to do that?  


    Here's the overly-generic definition I found. 
    A program, routine, or process that performs a specific system
function to support other programs, particularly at a low (close to the
hardware) level. When services are provided over a network, they can be
published in Active Directory, facilitating service-centric administration
and usage. Some examples of Windows 2000 services are Security Accounts
Manager service, File Replication Service, and Routing and Remote Access
Service.


    Any descriptions or web sites that can describe this would be
appreciated.  


    Lisa Koivu 
    Oracle Database Administrator and Self-Professed W2K Idiot. 
    Fairfield Resorts, Inc. 
    954-935-4117 
    
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]


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

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

Re: Personal Top 3 Oracle titles

[kjanusz]

Before I buy a book I always check Amazon.com's reader 
reviews.  They can be very helpful.

Ken Janusz, CPIM
> Guy Harrison's High Performance SQL Tuning Book
> Steven Feuernstein's PL/SQL books (O'Reilly)
> 
> Both of these books taught me a lot of what I know.  I read Harrison's book
> cover to cover.  
> 
> Don't forget the Oracle Documentation... !
> 
> I haven't purchased a DBA book that I thought was incredibly worthwhile
> (yet).  I'll be buying Jonathan Lewis' book after the discussion on the list
> though.  
> 
> 
> > -Original Message-
> > From:   Steve Armijo [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 14, 2001 1:07 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: RAID or NOT to RAID?  What's the diff???
> > 
> > On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote:
> > > and very nice they are too.
> > > 
> > > Great book by the way.
> > 
> > Hmmm, so what would folks consider their essential Oracle books?  maybe
> > your
> > personal top 2 or 3?
> > 
> > -s
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Steve Armijo
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be 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: Substitute for Materialized Views/Snapshots?

[Chris Rezek]

Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle
- there is no materialized view functionality for SE.

Chris - Alas, transportable tablespaces are not available for SE either.

I'm still looking for suggestions.  The tables need to be
read-consistent down to the second.  Is there a way I can do a CREATE AS
SELECT or COPY for all five tables in a way that ensures this?

Chris


"A. Bardeen" wrote:
> 
> Chris,
> 
> Read-only and updatable snapshots/materialized views
> are available with the Standard Edition starting with
> 8.1.5; SE can also be used for the master site for
> snapshots/MV's.  EE is required only for multi-master
> replication and the data warehousing features of MV's
> (e.g. summary management, etc...)
> 
> The following metalink doc has the differences:
> 
> Note: 112591.1 "Differences Between Standard Edition
> and Enterprise Edition in 8i"
> 
> HTH,
> 
> -- Anita
> 
> --- Chris Rezek <[EMAIL PROTECTED]> wrote:
> > We are running 8.1.6 Standard Edition on Solaris
> > hardware.  We are
> > building a reporting system and would have liked to
> > use materialized
> > views (snapshots) but this feature is not available
> > in Standard
> > Edition.  We need to create read-consistent copies
> > of several
> > million-row tables each night at midnight.  How can
> > we do this without
> > Oracle's auto-updating materialized views?
> >
> > Chris Rezek
> > Oracle DBA
> > http://www.dmn.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Chris Rezek
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
> 
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (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: Chris Rezek
  INET: [EMAIL PROTECTED]

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

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

JRE link question

[Joan Hsieh]

We installed 8.17 on the production machine. We have 2 different
oracle_home, 8.1.6 and 8.1.7. After runinstaller, it comes the error
message, cannot find file on /oracle/jre. I checked the whole jre bin
directory is created on /tmp dir.

I set all the environment variable, (except JRE_HOME)
but in the middle of installation. The JRE always pointed to one
obsolete directory. Do you know how this link created? 

HRPROD:/oracle/product/8.1.7> ls -ltr
total 328
drwxrwx---   2 root system   512 Aug 09 12:20 lost+found
drwxrwsr-x   5 oracle   dba  512 Aug 13 15:33 jdbc
drwxrwsr-x   3 oracle   dba  512 Aug 13 15:33 slax
drwxrwsr-x   8 oracle   dba  512 Aug 13 15:34 precomp
drwxrwsr-x   3 oracle   dba  512 Aug 13 15:34 ocommon
drwxrwsr-x   7 oracle   dba  512 Aug 13 15:35 otrace
drwxrwsr-x   4 oracle   dba  512 Aug 13 15:35 svrmgr
drwxrwsr-x   4 oracle   dba  512 Aug 13 16:02 owm
drwxrwsr-x   7 oracle   dba  512 Aug 13 16:04 sqlplus
drwxrwsr-x  12 oracle   dba  512 Aug 13 16:09 ldap
drwxrwsr-x   2 oracle   dba  512 Aug 13 16:10 jlib
drwxrwsr-x   5 oracle   dba  512 Aug 13 16:13 classes
drwxrwsr-x  10 oracle   dba  512 Aug 13 16:14 sysman
-rwxr-xr-x   1 oracle   dba   10 Aug 14 12:47 root.sh.old
lrwxrwxrwx   1 oracle   dba   25 Aug 14 13:03 JRE ->
/u01/app/oracle/jre/1.1.8
drwxrwsr-x   2 oracle   dba  512 Aug 14 13:08 jar

Thanks,

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

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

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

RE: lost control file..

[Rachel Carmichael]

I don't even have the excuse of it being too early and before I've had 
coffee... especially since I've done the copy route a number of times.

sigh.  thanks Tom!


>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: lost control file..
>Date: Tue, 14 Aug 2001 07:01:57 -0800
>
>
>Rachel says:
>
>"Oracle has to have at least ONE controlfile to open. If you have more than
>one, and deleted only one, you can edit the init.ora and change the
>controlfiles parameter to remove the one that is missing."
>
>
>OR, if you have another control file available, simply copy and rename it 
>to
>the one that is missing and re-start your database.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Tuesday, August 14, 2001 10:00 AM
>To: Multiple recipients of list ORACLE-L
>
>
>recreate the control file from the trace one.
>
>Oracle has to have at least ONE controlfile to open. If you have more than
>one, and deleted only one, you can edit the init.ora and change the
>controlfiles parameter to remove the one that is missing.
>
>
> >From: "Saurabh Sharma" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: lost control file..
> >Date: Tue, 14 Aug 2001 04:50:27 -0800
> >
> >hi all,
> >i was experimenting with my test db, and trying to recover the control
> >file.
> >i taken backup of control file as
> >ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
> >and also
> >ALTER DATABASE BACKUP CONTROLFILE TO 'NEW LOCATION';
> >
> >i then shutdown normal, removed the controlfile from its original 
>location
> >and tried STARTUP
> >it gave me this error..
> >ORA-00205: error in identifying controlfile, check alert log for more 
>info.
> >
> >after i done shutdown normal and tried another restart
> >but agin error is..
> >ORA-01102: cannot mount database in EXCLUSIVE mode
> >
> >how can i recover my control file now. should i need be in mount stage, 
>or
> >should i recreate controlfile using backup from trace.
> >
> >pls throw some light on what are different options available now.
> >
> >Saurabh Sharma
> >
> >[EMAIL PROTECTED]
> >http://www.geocities.com/saurabh00pc/stride.html
>
>
>_
>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: 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).

Re: external proc listener

[Jonathan Lewis]

Not my speciality - but

a) is it possible the PROGRAM=EXTRPROC needs to
have extproc in lower case ?

b) Do you have an sqlnet.ora with a
names.default_domain=something
in which case your
extproc_connection_data=
should be
extproc_connection_data.something=


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




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 14 August 2001 18:49


Ok i know i'm doing something wrong here in working with external proc
listener as i can even get the stupid demo to work right.

here is my listener.ora

LISTENER_EXTPROC=
(ADDRESS = (PROTOCOL = IPC) (KEY = extproc))


SID_LIST_LISTENER_EXTPROC
  (SID_LIST =
(SID_DESC =
 (SID_NAME = plsextproc)
 (ORACLE_HOME = /u151/oracle/product/8.1.7)
 (PROGRAM = EXTPROC)
  )
)

on startup i get this(which lends me to believe i've got something
messed up):

 and

Listener Trace File
/u151/oracle/product/8.1.7/network/log/listener_extproc.trc
The listener supports no services
The command completed successfully


tnsnames.ora
extproc_connection_data=
(description=
   (address=(protocol=ipc)(key=extproc))
   (connect_data=
(sid=plsextproc)))


So what am i missing, i've RTFM, metalink, used what I thought were
good examples from multiple places, yet when running the demo in
$ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.

thanks, joe


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

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

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

[Rachel Carmichael]

last I heard it was 1 year in 5


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 06:41:02 -0800
>
>Check with your tax advisor again or get a new tax advisor.  I don't
>remember the exact details but you MUST show some tax-able profit for a
>certain number of years out of every so many years (eg, 1 year out of the
>last 4 - I'm not sure that those are the right numbers) or the IRS will
>decide that your "business" is just a "hobby" and force you to go back and
>give up all your business deductions. It doesn't have to be a huge profit,
>but it does have to be a positive number.
>
>
>
> lhoska@calibr
> esys.com To: Multiple recipients of 
>list ORACLE-L
> Sent by: <[EMAIL PROTECTED]>
> root@fatcity.cc:
> com  Subject: RE: OT -- training
>
>
> 08/13/2001
> 06:05 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>I've heard from my tax adviser your business doesn't have to show any
>profit
>for number of years after opening.  I suspect even then it is not required.
>What if you having hard time making profit?  It doesn't mean you have to
>close your business...I assume in that case you can also register as a
>non-profit organization.  Are tax breaks better for non-profits?  I don't
>know..
>Also, if you don't already know.. some training companies (Learning Tree
>International per example) won't even register you for class if you're an
>individual.  You have to be a corporation.
>Lyuda
>
>-Original Message-
>Sent: Monday, August 13, 2001 3:42 PM
>To: Multiple recipients of list ORACLE-L
>
>
>You could create a web site that features some technical materials and use
>it to advertise your services if you are willing to moonlight on a few
>jobs,
>just enough to turn a profit within a couple years.  Then I would presume
>you would have no trouble writing the training off as a legitimate biz
>expense.
>
>- Ethan
>- http://www.geocities.com/epost1
>
> >-Original Message-
> >From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, August 13, 2001 11:42 AM
> >To: Multiple recipients of list ORACLE-L
> >Subject: Re: OT -- training
> >
> >
> >Patrice,
> > There is "resistance" to any training that I feel is
> >necessary to further my knowledge and/or enhance my
> >understanding of the Oracle processes. Even though I have
> >money in the budget for such items I have to submit a business
> >case defining the gains to the company and after completing
> >the course with a passing grade the company will reimburse me
> >the expenses for the course only. I also have to sign a waver
> >that I will pay the company back the full cost of the course
> >if I leave their employment before 365 days. Needless to say I
> >pay for everything myself and hope to write it off on taxes if
> >they ever get the bill signed into law.
> >ROR mª¿ªm
> >
>  [EMAIL PROTECTED] 08/13/01 11:46AM >>>
> >Just out of curiosity, how many days / weeks of real training did your
> >employer provide you with in the last couple of years?
> >
> >"real" is in quotes, I don't mean the little 1 - 3 day
> >seminars given by
> >CareerTrack and other "training" companies, or
> >management-related stuff like
> >little MBA-flavoured certificates from universities.
> >
> >Oh, and did the amount of training you received match what you
> >were told
> >during your job interview?
> >
> >Regards,
> >Patrice Boivin
> >Systems Analyst (Oracle Certified DBA)
> >
> >Systems Admin & Operations | Admin. et Exploit. des systèmes
> >Technology Services| Services technologiques
> >Informatics Branch | Direction de l'informatique
> >Maritimes Region, DFO  | Région des Maritimes, MPO
> >
> >E-Mail: [EMAIL PROTECTED] 
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Boivin, Patrice J
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Ron Rogers
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public I

RE: external proc listener

[JOE TESTA]

thanks a bunch that was it.  and to think i trusted the 
oracle docs for an example, doh, i should know better.
 
someone smack me, i'm sure there are enough of you out there 
who'd like to :)
 
joe
>>> [EMAIL PROTECTED] 08/14/01 02:27PM 
>>>
Joe;
  Shouldn't the KEY match 
the SID_NAME ???

  EXTERNAL_PROCEDURE_LISTENER=  
  (ADDRESS_LIST=    
  (ADDRESS=  
  (PROTOCOL=IPC)  
  (KEY=extproc)<==   
      )  
  )SID_LIST_EXTERNAL_PROCEDURE_LISTENER=  
  (SID_LIST=    (SID_DESC=  
  (SID_NAME=extproc)<===  
  (ORACLE_HOME=/u03/home/oracle/product/8.0.5)  
  (PROGRAM=extproc)

   
  Your key is extproc and your sid_name is  
  plsextproc
  -Original 
  Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 12:26 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  external proc listener
  Ok i know i'm doing something wrong here in working with 
  external proc listener as i can even get the stupid demo to work 
  right.
   
  here is my listener.ora
   
  LISTENER_EXTPROC=    (ADDRESS = (PROTOCOL 
  = IPC) (KEY = extproc))
   
  SID_LIST_LISTENER_EXTPROC  (SID_LIST =    
  (SID_DESC 
  = 
   (SID_NAME = 
  plsextproc) (ORACLE_HOME = 
  /u151/oracle/product/8.1.7) (PROGRAM = 
  EXTPROC)  )  )
  on startup i get this(which lends me to believe i've got something messed 
  up):
   
   and
   
  Listener Trace File   
  /u151/oracle/product/8.1.7/network/log/listener_extproc.trcThe listener 
  supports no servicesThe command completed successfully
   
   
  tnsnames.ora
  extproc_connection_data=    
   (description= 
     
  (address=(protocol=ipc)(key=extproc))  
     (connect_data=    (sid=plsextproc))) 
  
  So what am i missing, i've RTFM, metalink, used what I thought were good 
  examples from multiple places, yet when running the demo in 
  $ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.
   
  thanks, joe
   

RE: OT -- training

[Rachel Carmichael]

no, first you need to write a book, then you PRAY for royalties


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 06:47:21 -0800
>
>Of course first you need some royalties!!
>
>LOL
>
>
>
>
> "Rachel
> Carmichael"  To: Multiple recipients of 
>list ORACLE-L
> 
> mail.com>cc:
> Sent by: Subject: RE: OT -- training
> root@fatcity.
> com
>
>
> 08/13/2001
> 10:20 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>
>the other way to deduct the full amount of conferences/training is to write
>it off against royalties :)
>
>
>
> >From: "Bowes, Chris" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: OT -- training
> >Date: Mon, 13 Aug 2001 14:05:26 -0800
> >
> >You can deduct them on Line 20 of your schedule A for itemized 
>deductions.
> >
> >This is subject to some  HOWEVER's.
> >
> >You must take your 2% of your adjusted gross income and deduct it from
>that
> >deduction.  So if it cost you 2500 dollars to go to openworld and your
> >adjusted gross income (w2's, tips, ira deduction, student loan interest
> >deduction all factored) on line 34 of form 1040 is 50K then 2% of 50K is
> >1000 dollars.  So you can only deduct 1500 of the 2500 dollars.
> >
> >And if your standard deduction (4400 for single/ 7350 for married) is
> >higher
> >than your sched A, you won't write off any of it.
> >
> >
> >Joe gets that deduction off the top.  Before it ever hits his 1040.  So 
>he
> >gets the full 2500 plus all his other business deductions with no 2%
> >adjustment,  THEN he still gets any personal deductions of his standard
> >deduction.
> >
> >
> >So, yes, you can usually deduct it, but not entirely and at the expense 
>of
> >the standard deduction that you would already get.
> >
> >
> >--Chris
> >[EMAIL PROTECTED]
> >
> >
> >
> >-Original Message-
> >Sent: Monday, August 13, 2001 4:01 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Either to don't need to incorporate, or my
> >tax accountant lied to me,  I don't know
> >which, but I have written off training
> >and IOUG-A trips (that were paid for 100% by
> >me) while I was an employee of
> >a consulting firm.
> >
> >(Is that the IRS I hear knocking?)
> >
> >
> >
> >Matt Adams - GE Appliances - [EMAIL PROTECTED]
> >Doing linear scans over an associative array is like
> >   trying to club someone to death with a loaded Uzi.
> >  - Larry Wall (creator of Perl)
> >
> >
> >
> >-Original Message-
> >Sent: Monday, August 13, 2001 3:42 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >You can't write off training.  you need to get incorporated.  I'm a
> >business
> >entity and if/when the company i work for won't pay for training, you can
> >bet it will get written off on my taxes, that includes all of the oracle
> >books, OCP exams, you name it, it gets deducted as a legitimate company
> >expense.
> >
> >2 years ago the company i was working for didnt want to send me to
> >openworld(and I knew i'd be leaving in less than 2months anyways), so i
>ate
> >the cost and wrote the entire trip off.
> >
> >joe
> >
> >
> >
> >
> >
> > >>> [EMAIL PROTECTED] 08/13/01 02:41PM >>>
> >Patrice,
> >There is "resistance" to any training that I feel is necessary to further
> >my
> >knowledge and/or enhance my understanding of the Oracle processes. Even
> >though I have money in the budget for such items I have to submit a
> >business
> >case defining the gains to the company and after completing the course
>with
> >a passing grade the company will reimburse me the expenses for the course
> >only. I also have to sign a waver that I will pay the company back the
>full
> >cost of the course if I leave their employment before 365 days. Needless
>to
> >say I pay for everything myself and hope to write it off on taxes if they
> >ever get the bill signed into law.
> >ROR mª¿ªm
> >
> > >>> [EMAIL PROTECTED] 08/13/01 11:46AM >>>
> >Just out of curiosity, how many days / weeks of real training did your
> >employer provide you with in the last couple of years?
> >
> >"real" is in quotes, I don't mean the little 1 - 3 day seminars given by
> >CareerTrack and other "training" companies, or management-related stuff
> >like
> >little MBA-flavoured certificates from universities.
> >
> >Oh, and did the amount of training you received match what you were told
> >during your job interview?
> >
> >Regards,
> >Patrice Boivin
> >Systems Analyst (Oracle Certified DBA)
> >
> >Systems Admin & Operations | Admin. et Exploit. des systèmes
> >Technology Services| Services technologiques
> 

RE: OT: RE: UNCUT ORACLE-L The Motion Picture

[Rachel Carmichael]

he's not bad on the eyes in and of himself... think Tim Everett Scott


>From: "Koivu, Lisa" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: RE: UNCUT ORACLE-L The Motion Picture
>Date: Tue, 14 Aug 2001 09:11:45 -0800
>
>OK, ok.  You can be Keanu Reeves or David Duchovny.  If you are going to be
>my sidekick you better be easy on the eyes !
>
>Believe it or not a friend of mine cast me in his "movie" being shot next
>month - I am the bitchy bride who catches her fiancee cheating with another
>man, wallops him with a nasty hook and the next scene seconds later, I have
>taken out everyone in the bar and am the only one left standing.  Now where
>do people get this idea that I am violent and bitchy ?   :)
>
>Chris should be up for an award for this one !!
>
>
> > -Original Message-
> > From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 14, 2001 11:51 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: OT: RE: UNCUT ORACLE-L The Motion Picture
> >
> > ROFL
> >
> > But, reallywhy do I have to be Joe Pesci?  I really
> > must cut down on my delivery speed
> >
> > Oh well...reminds me of my first shamanic journey to
> > the middle worldturns out my power animal was a
> > squirrel.
> >
> > A friggin' squirrel.
> >
> > LoL
> >
> > Ah well, I am an oracle dba...I *do* have to compensate
> >
> > Ross
> >
> > p.s. It's Dedekind Cut. He was brilliantwow.
> >
> > -Original Message-
> > Sent: Tuesday, August 14, 2001 11:10 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > The unkindest uncut of all - the Dedican uncut.
> >
> > LOL
> >
> >
> >
> >
> >
> > "Bowes,
> >
> > Chris"   To: Multiple recipients of
> > list
> > ORACLE-L
> > 
> >
> > kosa.com>cc:
> >
> > Sent by: Subject: OT: RE: UNCUT
> > ORACLE-L
> > The Motion
> > root@fatcity.Picture
> >
> > com
> >
> >
> >
> >
> >
> > 08/14/2001
> >
> > 10:47 AM
> >
> > Please
> >
> > respond to
> >
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > UNCUT ORACLE-L
> > 
>--
> > --
> >
> >
> > Coming to theaters near you.   Oracle-L, the UNCUT version is rated 
>NC-17.
> >
> > Directed by Bruce.
> > Produced by Jared Still.
> >
> > Starring:
> >
> > Lisa Koivu.  Watch as she machetes a user who left his userid and 
>password
> > on a post-it on his PC allowing a rouge college intern to hack the 
>system
> > and destroy data.
> >
> > /Clip
> > Lisa: "YOU'VE USED THAT PASSWORD FOR THE LAST TIME MISTER",  User:
> > "NOo!"  Hack hack slice slice  Lisa: "Now where's that
> > intern..."
> >
> > /Clip
> >
> > Ross Mohan as her feisty sidekick. (envision Joe Pesci)
> > /Clip
> > "Nice Cutting Lisa.  So l-user, is it funny now?  Does she make you 
>laugh?
> > Like a clown?  Looks like we'll have to rewrite that song.  'The ankle
> > bone's connected to the spinal cord...'"
> >
> > /Clip
> >
> > Rachel Carmichel, as the goddess of manager destruction. Watch as she
> > stuffs a chair down the throat of a manager for his really stupid ideas.
> >
> > /Clip
> > Manager:  "But Rachel, don't you think that we could eliminate that 450g
> > worth of data and save a lot of money in training, dba costs and license
> > fees if we converted everything to Excel Spreadsheets?  Why are you
> > looking
> > at me like that?  No, now put down that chair that could be an OHSA
> > recordable.  Open Wide?  Oh, you silly.  I've already had brunch with 
>the
> > steering committee.  That's where this excellent excel idea came from.  
>We
> > can do this right?  I figure 450 g isn't that much is it?  All we have 
>to
> > do is get some PC's and a couple secretaries and...  No, back away.
> > N."  Stuff, cram, cram.
> >
> > /Clip
> >
> > Eric Pierce as Master Po giver of infinite knowledge.
> > /Clip
> > "Grasshopper.  You will find all you need at these links."
> > /Clip
> >
> > Director Jared Still, in a special appearance.  He dispatches another
> > developer for bad locking practices:
> > /Clip
> > "Six table locks?  For a three table select?  I asked for code and you
> > bring me this.  What have I done to deserve this disrespect.To the
> > acid
> > baths with him..."
> >
> > /Clip
> >
> > Christopher Bowes as the thoroughly confused rookie:
> > /Clip:
> > "HELP!...  Am I an idiot?  Well, no I don't think so. What's an idiot?
> > RTFM? What's an RTFM?  Read the what?  What's a concepts manual.  What's 
>a
> > concept?  That's nice, but what is a database?  I've got to build one 
>for
> > my boss today.  I told him I would and m

Re:RE: Re[2]: How can I get my DB back if I lost one of my r

[dgoulet]

Lisa,

I believe that is why using "shutdown abort" is not truly endorsed by
Oracle, except as a last resort.  What I've noticed on the list is the desire by
some to over use this method of shutting down the DB.  Now I will admit that
"shutdown normal" is a real pain in the back side since every one HAS to log off
before the DB will shutdown.  And "shutdown immediate" does have a tendency to
hang around way too long on occasion.  Using abort though as the fix all is a
really bad thing to do.  One item I've taken is to allow the DB to stay in the
"shutdown immediate" state for at least 10 minutes before aborting it.  The
reason is that during that time the background processes have the opportunity to
rollback/commit all of the transactions that were taking place thereby cleaning
out the rollback segments.  If by the time 10 minutes has expired your DB has
not shutdown, you can be 99% confident that the problem is a truly dead
process/client who is no longer talking to Oracle and who's transactions have
been handled.  It's just a matter that Oracle cannot handshake with the client
anymore that's holding up the shutdown.  Then one can abort the instance with
every confidence that it will restart later.  Experience here has proved that
the startup in this case will occur 5 times faster than just firing off a
"shutdown abort" without the time period.  Therefore to my SA's chagrin, all of
my scripts call "shutdown immediate" and "shutdown abort" is left to a manual
process.

In my last response, privately, to Riyaj I stated that I had repaired a DB that
lost it's rollback tablespace to a disk failure.  The problem arose on db
startup after a normal cold backup.  Since the DB was shutdown with the
immediate vs. abort option all of the rollback was cleaned out before Oracle
shutdown, and it did so normally.  When the restart failed it was just a matter
of dumping the datafile offline and the tablespace including contents (which
cleans undo$ in the process) and rebuilding the messed up rollback space else
where.  Had "shutdown abort" been used I have no experience on what would have
happen, but I sure can imagine.

Now the original post stated that they had forgotten to backup this datafile. 
The reasons for doing so vary a lot, but there is a common and failsafe method
to prevent this.  It's just a matter of laying out your filesystem in such a way
that you cannot miss a datafile.  Around here we use /ora1 as Oracle's $HOME
mount point and then a second directory off of the root as the starting point
for each instance such as our ODS where all of the files for the instance are on
/TEST//.dbf.  This includes the control files and on-line
redo logs although I know you really should not back them up IAW Oracle's
suggestions but I do anyway.  Now when my SA wants to do a backup he just
backups /TEST/* and we're 100% confident he got everything.

I think one of the tasks of a DBA is to try and anticipate everything that
Murphy can unleash on you.  To that point I truly believe in the KISS principle,
namely Keep It Simple, Stupid.

Dick Goulet

Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   8/14/2001 12:01 PM

Hi Dick, 

I see your point.  What about when the db does something similar to a
shutdown abort?  Then you do need your rollback segments to perform a full
recovery.   

LK

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 14, 2001 12:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re[2]: How can I get my DB back if I lost one of my rollback
> 
> Riyaj,
> 
> Rollback segments are needed for recovery?  I think your confused with
> the
> online redo logs.  When a DB shuts down the rollback segments are emptied
> out
> either because the transactions have been rolled back or committed.  Once
> you
> start the recovery process the rollback segments are no longer required as
> the
> data therein is in the on-line redo logs.
> 
> Dick Goulet
> 
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date:   8/14/2001 6:41 AM
> 
> Hermanto
> Rollback segment data files are *needed* for recovery. Rollback 
> segments are the key component for consistent media/instance recovery. If 
> you lose any of the rollback segment files and if any extents from that 
> datafile are needed then the database can not do the recovery consistently
> 
> and will give you errors. Is it the only data file associated with the 
> rollback segment tablespace. If that is the case, there will be extents 
> from the rollback segments. If there are no extents from the rollback 
> segments then you could potentially offline drop the datafile, do the 
> media recovery and do open resetlogs. What errors are you getting ? Stuck 
> recovery ? Errors will tell you whether the recovery process is looking 
> for rollback segments or the data file.
> Please conta

RE: OT -- training

[Rachel Carmichael]

Yep, I got lucky, and called on a lot of people I know.

For those of you lost in this semi-private conversation, the NYOUG meeting 
on September 12th (and yes, non-members are welcome) is being called the 
"Literary Lights" meeting.

presenters include: our own Gaja Krishna Vaidyanatha and Ari Kaplan, Rich 
Niemiec, Kevin Loney, Marlene Theriault, Douglas Scherer, John Beresniewicz, 
Ulka Rodgers and Paul Dorsey.

oh yeah, I'll be hanging out there. But I had so many great presenters I had 
to bump myself off the agenda :)

check it out, www.nyoug.org




>From: "Miller, Jay" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- training
>Date: Tue, 14 Aug 2001 09:00:37 -0800
>
>Pretty amazing actually.  I won't feel so bad about missing the cruise this
>year :-( If I get get to attend this one.
>
>Jay Miller
>
>
>-Original Message-
>Sent: Monday, August 13, 2001 10:21 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
> >On the other hand, I can take the day off for the NY Users Group when 
>there
>
> >aren't any emergencies (about 50% of the time).
> >
> >
> >Jay Miller
> >
>
>
>try not to have any emergencies on September 12th :)   it's gonna be a good
>one!
>
>Rachel
>
>_
>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: Miller, Jay
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

Re: RAID or NOT to RAID? What's the diff???

[Rachel Carmichael]

do I have to limit it to 3?  besides, the list varies with the sort of work 
I happen to be doing but...

(please, no offence to anyone I've left out)

Performance Tuning 101
Practical Oracle8i
Oracle8i DBA Handbook

there are others... but you said 3




>From: Steve Armijo <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: RAID or NOT to RAID?  What's the diff???
>Date: Tue, 14 Aug 2001 09:06:54 -0800
>
>On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote:
> > and very nice they are too.
> >
> > Great book by the way.
>
>Hmmm, so what would folks consider their essential Oracle books?  maybe 
>your
>personal top 2 or 3?
>
>-s
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve Armijo
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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).

RE: Personal Top 3 Oracle titles

[Kevin Lange]

Title: Personal Top 3 Oracle titles



Lisa;
  
Over the past 4 years the two best books I have found for work on Oracle are the 
Steven Feuernstein's books (O'Reilly) 
 
Oracle 
PL/SQL Programming
Oracle 
Build-in Packages
 
These 
two books have taught me so much on the programming side of the 
house.
 
I 
truely wish there was a DBA book with that much 
quality.  

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 
  1:16 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Personal Top 3 Oracle titles
  Guy Harrison's High Performance SQL 
  Tuning Book Steven 
  Feuernstein's PL/SQL books (O'Reilly) 
  Both of these books taught me a lot 
  of what I know.  I read Harrison's book cover to cover.  
  Don't forget the Oracle 
  Documentation... ! 
  I haven't purchased a DBA book that I 
  thought was incredibly worthwhile (yet).  I'll be buying Jonathan Lewis' 
  book after the discussion on the list though.  
  
-Original Message- From:   Steve 
Armijo [SMTP:[EMAIL PROTECTED]] Sent:   Tuesday, August 
14, 2001 1:07 PM To: Multiple recipients of list ORACLE-L Subject:    Re: RAID or NOT to RAID?  What's the diff??? 

On Mon, Aug 13, 2001 at 11:45:20PM -0800, 
Robertson Lee - lerobe wrote: > and 
very nice they are too. > 
> Great book by the way. 
Hmmm, so what would folks consider their 
essential Oracle books?  maybe your personal top 2 or 3? 
-s 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve 
Armijo   INET: 
[EMAIL PROTECTED] 
Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051 San Diego, California    -- 
Public Internet access / Mailing Lists  
To REMOVE yourself from this mailing list, send 
an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: 
UNSUB ORACLE-L (or 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 -- MS SQL Server is putting Oracle to shame,

[Christopher Spence]

The same statement I use for Unix, I will use for SQL Server.

Give me $40,000 and I will build an NT box, take $40,000 and build a unix
(Solaris, HP-UX, AIX type) and see who wins.  

Same thing works for SQL Server and Oracle.

Granted $40,000 is a small budget, but there are a lot of people who would
spend about $80,000 for their database in hardware and software, that is a
very big market.  Oracle and Unix cannot hold that entire market.

And that is probably the only reason SQL Server and NT are alive and
kicking.
They are good products if used for the right job.  Once you try to do much,
then you find the advantages of Oracle and Unix.  

Although any day of the week I would rather have a $1,000,000 unix box
running Oracle.  But I cannot with a straight face tell 15 person company
selling Beanie babies on Ebay to buy that setup.

Nothing is perfect for every solution, and Oracle is far from it, and SQL
Server is even further.  While Oracle's costs are high, and Unix hardware
stays well above the intel market (which is going to change greatly with the
I64) there will be a large market share that Oracle will have a tough time
competing in.

Although Win2000 has many bugs and compatibility issues, it is pretty solid
with the right hardware and properly tested software.  

For a anti-m$/anti-win32 this is a tough email to write, but I believe it in
its entirety.
Blanket policy M$, SQL Server, Win32 sucks,  period end of story is just
being naive.

"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 14, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L


Patrice,

Thanks for the message, we all over here had one heck of a good laugh.
It just shows that MS is still running around with there heads in the ground
and phony sales figures.  Bet you did not know that every one who buys
Windows Server gets a SQL*server license right along with it.  It's a built
in.  And we're looking at migrating from Windows as our network server to
Red Hat along with some others I know, and a couple of VERY big players who
have.  Why, because it's cheaper to run Red Hat than Windows in both terms
of hardware and software.  Sure we'll keep Windows on the desk top, but it's
likely out of here in the computer room.

BTW: since MS has been declared a monopoly, and that portion of the
anti-trust suit has been affirmed, a break up of MS is still in the cards so
some of those statements about not porting may have to be retracted.  OH
also, watch out when someone, even Oracle, starts throwing bench marks
around, they all lie.

Dick Goulet

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   8/14/2001 8:21 AM

http://www.theregister.co.uk/content/53/21003.html
 

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

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

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

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

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

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

RE: external proc listener

[Kevin Lange]

Joe;
  Shouldn't the KEY match 
the SID_NAME ???

  EXTERNAL_PROCEDURE_LISTENER=  
  (ADDRESS_LIST=    
  (ADDRESS=  
  (PROTOCOL=IPC)  
  (KEY=extproc)<==   
      )  
  )SID_LIST_EXTERNAL_PROCEDURE_LISTENER=  
  (SID_LIST=    (SID_DESC=  
  (SID_NAME=extproc)<===  
  (ORACLE_HOME=/u03/home/oracle/product/8.0.5)  
  (PROGRAM=extproc)

   
  Your key is extproc and your sid_name is  
  plsextproc
  -Original 
  Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 12:26 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  external proc listener
  Ok i know i'm doing something wrong here in working with 
  external proc listener as i can even get the stupid demo to work 
  right.
   
  here is my listener.ora
   
  LISTENER_EXTPROC=    (ADDRESS = (PROTOCOL 
  = IPC) (KEY = extproc))
   
  SID_LIST_LISTENER_EXTPROC  (SID_LIST =    
  (SID_DESC 
  = 
   (SID_NAME = 
  plsextproc) (ORACLE_HOME = 
  /u151/oracle/product/8.1.7) (PROGRAM = 
  EXTPROC)  )  )
  on startup i get this(which lends me to believe i've got something messed 
  up):
   
   and
   
  Listener Trace File   
  /u151/oracle/product/8.1.7/network/log/listener_extproc.trcThe listener 
  supports no servicesThe command completed successfully
   
   
  tnsnames.ora
  extproc_connection_data=    
   (description= 
     
  (address=(protocol=ipc)(key=extproc))  
     (connect_data=    (sid=plsextproc))) 
  
  So what am i missing, i've RTFM, metalink, used what I thought were good 
  examples from multiple places, yet when running the demo in 
  $ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.
   
  thanks, joe
   

Re:external proc listener

[dgoulet]

Joe,

Extproc's are a pain until you get them figured out the first time.  Here is
a copy of the listener file we use on one of the instances where it does work:


SQLNET.AUTHENTICATION_SERVICES = (NONE)
LOGGING_LISTENER = OFF
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =
(ADDRESS=
  (PROTOCOL=IPC)
  (KEY= milton2.world)
)
(ADDRESS=
  (PROTOCOL=IPC)
  (KEY= 02)
)
  )
callout_listener=
( ADDRESS_LIST =
   (ADDRESS=
 (PROTOCOL = IPC)
 (KEY = extproc_key)
)
 )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (GLOBAL_DBNAME = milton2.world)
  (SID_NAME = 02)
  (ORACLE_HOME = /ora1/81632)
  (PRESPAWN_MAX = 10)
)
sid_list_callout_listener =
( SID_LIST =
(SID_DESC =
  (SID_NAME = 11)
  (PROGRAM = /ora1/81632/bin/extproc)
)
)

The tnsnames entry looks like:

extproc_connection_data.world =
  (DESCRIPTION =
(ADDRESS =
  (PROTOCOL = IPC)
  (KEY = extproc_key)
)
(CONNECT_DATA = (SID = 11))
  )

Hope it helps.

Dick Goulet
Reply Separator
Author: "JOE TESTA" <[EMAIL PROTECTED]>
Date:   8/14/2001 9:25 AM

Ok i know i'm doing something wrong here in working with external proc listener
as i can even get the stupid demo to work right.

here is my listener.ora

LISTENER_EXTPROC=
(ADDRESS = (PROTOCOL = IPC) (KEY = extproc))


SID_LIST_LISTENER_EXTPROC
  (SID_LIST =
(SID_DESC = 
 (SID_NAME = plsextproc)
 (ORACLE_HOME = /u151/oracle/product/8.1.7)
 (PROGRAM = EXTPROC)
  ) 
 )

on startup i get this(which lends me to believe i've got something messed up):

 and

Listener Trace File  
/u151/oracle/product/8.1.7/network/log/listener_extproc.trc
The listener supports no services
The command completed successfully


tnsnames.ora
extproc_connection_data=
 (description= 
   (address=(protocol=ipc)(key=extproc))  
   (connect_data=
(sid=plsextproc))) 


So what am i missing, i've RTFM, metalink, used what I thought were good
examples from multiple places, yet when running the demo in
$ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.

thanks, joe






Ok i know i'm doing something wrong here in working with 
external proc listener as i can even get the stupid demo to work 
right.
 
here is my listener.ora
 
LISTENER_EXTPROC=    (ADDRESS = (PROTOCOL =

IPC) (KEY = extproc))
 
SID_LIST_LISTENER_EXTPROC  (SID_LIST =    
(SID_DESC 
= &
nbsp;   
 (SID_NAME = plsextproc)

(ORACLE_HOME = /u151/oracle/product/8.1.7) (PROGRAM 
= EXTPROC)  )  )
on startup i get this(which lends me to believe i've got something messed 
up):
 
 and
 
Listener Trace File   
/u151/oracle/product/8.1.7/network/log/listener_extproc.trcThe listener 
supports no servicesThe command completed successfully
 
 
tnsnames.ora
extproc_connection_data=&nb
sp;   
 (description= &nb
sp;   
   
(address=(protocol=ipc)(key=extproc))   &
nbsp;&nb
sp; 
   (connect_data=    (sid=plsextproc))) 

So what am i missing, i've RTFM, metalink, used what I thought were good 
examples from multiple places, yet when running the demo in 
$ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.
 
thanks, joe
 

-- 
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: OT: RE: UNCUT ORACLE-L The Motion Picture

[Rachel Carmichael]

OH man, THANK YOU for the giggles I've needed these.

Rachel


>From: "Bowes, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT: RE: UNCUT ORACLE-L  The Motion Picture
>Date: Tue, 14 Aug 2001 06:47:22 -0800
>
>UNCUT ORACLE-L
>
>
>Coming to theaters near you.   Oracle-L, the UNCUT version is rated NC-17.
>
>Directed by Bruce.
>Produced by Jared Still.
>
>Starring:
>
>Lisa Koivu.  Watch as she machetes a user who left his userid and password
>on a post-it on his PC allowing a rouge college intern to hack the system
>and destroy data.
>
>/Clip
>Lisa: "YOU'VE USED THAT PASSWORD FOR THE LAST TIME MISTER",  User:
>"NOo!"  Hack hack slice slice  Lisa: "Now where's that
>intern..."
>/Clip
>
>Ross Mohan as her feisty sidekick. (envision Joe Pesci)
>/Clip
>"Nice Cutting Lisa.  So l-user, is it funny now?  Does she make you laugh?
>Like a clown?  Looks like we'll have to rewrite that song.  'The ankle
>bone's connected to the spinal cord...'"
>/Clip
>
>Rachel Carmichel, as the goddess of manager destruction. Watch as she 
>stuffs
>a chair down the throat of a manager for his really stupid ideas.
>
>/Clip
>Manager:  "But Rachel, don't you think that we could eliminate that 450g
>worth of data and save a lot of money in training, dba costs and license
>fees if we converted everything to Excel Spreadsheets?  Why are you looking
>at me like that?  No, now put down that chair that could be an OHSA
>recordable.  Open Wide?  Oh, you silly.  I've already had brunch with the
>steering committee.  That's where this excellent excel idea came from.  We
>can do this right?  I figure 450 g isn't that much is it?  All we have to 
>do
>is get some PC's and a couple secretaries and...  No, back away.
>N."  Stuff, cram, cram.
>/Clip
>
>Eric Pierce as Master Po giver of infinite knowledge.
>/Clip
>"Grasshopper.  You will find all you need at these links."
>/Clip
>
>Director Jared Still, in a special appearance.  He dispatches another
>developer for bad locking practices:
>/Clip
>"Six table locks?  For a three table select?  I asked for code and you 
>bring
>me this.  What have I done to deserve this disrespect.To the acid baths
>with him..."
>/Clip
>
>Christopher Bowes as the thoroughly confused rookie:
>/Clip:
>"HELP!...  Am I an idiot?  Well, no I don't think so. What's an idiot?
>RTFM? What's an RTFM?  Read the what?  What's a concepts manual.  What's a
>concept?  That's nice, but what is a database?  I've got to build one for 
>my
>boss today.  I told him I would and my performance review is at 3pm...  Is
>15 minutes enough time to build a 40 terabyte base?  But I thought DBA's 
>did
>nothing but get in the way of us developers...  What's a tablespace?  
>What's
>a table"
>/Clip
>
>
>Other special appearances by Steve Adams, Christopher Spence, Joe Testa and
>lots of others from the Oracle-L.  See them all as you've never seen them
>before.
>
>See Oracle-L, the UNCUT version.  Coming this fall.
>
>
>Sorry, folks, slow day...
>


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

RE: I admit this is dumb. NT/W2K Services?

[Boivin, Patrice J]

I haven't worked on Windows2000, but if it's like NT, you have two things to
worry about when starting Oracle in the Windows environment:

The background service has to be running, to provide a context.
The instance has to be started otherwise it is in shutdown mode.

On NT 4, there is an NT Service that runs like a daemon in the background.
When you start the service it automatically tries to start the instance like
when we issue startup open at the svrmgrl prompt in UNIX.

On Windows2000 it must be trying to do the same thing.

Usually on NT if the service hasn't started and you try to access the db
from svrmgrl, it tells you there has been a protocol error.  This is
misleading, in fact the problem is that there is no context for Oracle to
run in, i.e. the NT Service hasn't been started.

In Oracle 7.3. you can tell that Oracle hadn't finished porting their rdbms,
because there were two separate NT services - one to provide the context,
one to issue startup open.  In Oracle 8I there is only one NT service that
tries to do both.

I suspect that if you are low on memory, the NT / Win2K service may be able
to "create" a context for Oracle to run in, but not have enough memory
available to effectively start the Oracle instance.  So you may end up with
Win2K service showing up as started, when in fact the db is half opened and
therefore not usable.  You can try opening a DOS box and shutting it down
then re-starting it from the command prompt if that happens, DK if it will
work.

HTH
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  



-Original Message-
From:   Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 14, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject:I admit this is dumb.  NT/W2K Services?

I'm playing with Oracle on w2k out of sheer boredom.  So now I'm
forced to learn a little bit about w2k.  

I was looking at oradim and it has starttype and shuttype with
options srvc and inst.  OK, I understand the instance part.  But what on
earth are services?  Below is what the help says about it.  So to translate
this into Unix-speak, is this similar to a daemon?  I guess I'm confused
because as far as I know there's nothing additional that needs to be running
on Unix to just start up a database.  

If that's the case, then why would you want to shut down an instance
and not services?  For RMAN?  I guess I'm at a loss here.  Can someone give
me an example of when you'd want to do this?  

Plus, there's notes on Metalink about recreating services.  Why/when
would you want to do that?  

Here's the overly-generic definition I found. 
A program, routine, or process that performs a specific system
function to support other programs, particularly at a low (close to the
hardware) level. When services are provided over a network, they can be
published in Active Directory, facilitating service-centric administration
and usage. Some examples of Windows 2000 services are Security Accounts
Manager service, File Replication Service, and Routing and Remote Access
Service.

Any descriptions or web sites that can describe this would be
appreciated.  

Lisa Koivu 
Oracle Database Administrator and Self-Professed W2K Idiot. 
Fairfield Resorts, Inc. 
954-935-4117 

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

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

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

RE: having select from db link problems from 8.0.5.2.1

[Naik, Sandesh S]

already did that , doesn't work, funny thing is I can tnsping that foreign
database but doesn't work through db link.
Thanks
Sandesh


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L



Add the foreign host name to your local /etc/hosts file.

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


 

"Naik, Sandesh

S"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>  
   Subject: having select from db
link problems from 8.0.5.2.1  
Sent by:

[EMAIL PROTECTED]

om

 

 

08/14/2001

12:06 PM

Please respond

to ORACLE-L

 

 





Dear List,
 I have 8.0.5.2.1(32bit) database on HP-UX 11.0 server.
 I have a database link connecting to other database.  I get following
error
while trying to access objects thorough db link ( db link goes to 8.1.6.2.0
(64bit) database on HP-UX 11.0

" ORA-12545: Connect failed because target host or object does not exist "

There is work around to put IP address for this host in tnsnames.ora which
fixes the problems. Is there any other good solution to this problem?
 All your suggestions are always welcome.

Thank you

Sandesh Naik
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naik, Sandesh S
  INET: [EMAIL PROTECTED]

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

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




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

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

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

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

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

Re: OT: RE: UNCUT ORACLE-L The Motion Picture

[JOE TESTA]

Bill, besides the part, you know how to kick people's butts 
:)
 
Joe
>>> [EMAIL PROTECTED] 08/14/01 01:31PM 
>>>"Koivu, Lisa" wrote:> > OK, ok.  You can be 
Keanu Reeves or David Duchovny.  If you are going> to be my sidekick 
you better be easy on the eyes !can i have the jackie chan part?  
i'm good at humor.  gotta have somecomic relief.  and believe me, 
i look the comic relief part.;-)--Bill "Shrek" 
Thater  
ORACLE 
DBATelergy,Inc.   
[EMAIL PROTECTED]One 
ping to rule them all,One ping to find them,One ping to bring them 
all,And in the MUTX bind 
them.I 
came, I saw, I deleted all your files.-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Thater, William  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-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: Re[2]: How can I get my DB back if I lost one of my rollback

[Koivu, Lisa]

Title: RE: Re[2]: How can I get my DB back if I lost one of my rollback





Hi Dick, 


I see your point.  What about when the db does something similar to a shutdown abort?  Then you do need your rollback segments to perform a full recovery.   

LK


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 14, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re[2]: How can I get my DB back if I lost one of my rollback


Riyaj,


    Rollback segments are needed for recovery?  I think your confused with the
online redo logs.  When a DB shuts down the rollback segments are emptied out
either because the transactions have been rolled back or committed.  Once you
start the recovery process the rollback segments are no longer required as the
data therein is in the on-line redo logs.


Dick Goulet


Reply Separator
Author: [EMAIL PROTECTED]
Date:   8/14/2001 6:41 AM


Hermanto
    Rollback segment data files are *needed* for recovery. Rollback 
segments are the key component for consistent media/instance recovery. If 
you lose any of the rollback segment files and if any extents from that 
datafile are needed then the database can not do the recovery consistently 
and will give you errors. Is it the only data file associated with the 
rollback segment tablespace. If that is the case, there will be extents 
from the rollback segments. If there are no extents from the rollback 
segments then you could potentially offline drop the datafile, do the 
media recovery and do open resetlogs. What errors are you getting ? Stuck 
recovery ? Errors will tell you whether the recovery process is looking 
for rollback segments or the data file.
    Please contact Oracle support if there are any rollback extents in 
this datafile. _offline_rollback_segments and _corrupted_rollback_segments 
parameters can be used to hard open the database. But DO expect data 
consistency errors. In fact, only thing you should do is open this way, 
extract the data out and import in to a new database. Contact Oracle 
Support before you do this since there are serious consequences of doing 
this.


Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com





Hermanto P <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/14/01 03:35 AM
Please respond to ORACLE-L


 
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    How can I get my DB back if I lost one of my rollback
segment (rb



Hi gurus,
Recently, I have forgotten to backup one of rollback segment file
(rbs02.dbf).
When I want to restore..the db can not startup normally.
Anyone can give me advise..
Thanks in advance.


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


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

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





Hermanto
        Rollback segment
data files are *needed* for recovery. Rollback segments are the key component
for consistent media/instance recovery. If you lose any of the rollback segment
files and if any extents from that datafile are needed then the database can not
do the recovery consistently and will give you errors. Is it the only data file
associated with the rollback segment tablespace. If that is the case, there will
be extents from the rollback segments. If there are no extents from the rollback
segments then you could potentially offline drop the datafile, do the media
recovery and do open resetlogs. What errors are you getting ? Stuck recovery ?
Errors will tell you whether the recovery process is looking for rollback
segments or the data file.
        Please contact
Oracle support if there are any rollback extents in this datafile.
_offline_rollback_segments and _corrupted_rollback_segments parameters can be
used to hard open the database. But DO expect data consistency errors. In fact,
only thing you should do is open this way, extract the data out and import in to
a new database. Contact Oracle Support before you do this since there are
serious consequences of doing this.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






Hermanto P
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/14/01 03:35 AM
Please respond to ORACLE-L

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

Re: OT: RE: UNCUT ORACLE-L The Motion Picture

[Thater, William]

JOE TESTA wrote:

>  Bill, besides the part, you know how to kick people's butts :) Joe
>
> who? me?;-)  i don't do that for a living anymore, but
> today i'd like to delete some users.  we have 25% less people, 50%
> more work and they want it done 100% faster.;-)
>

--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]


One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.


I came, I saw, I deleted all your files.

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

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

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