Re: Wait for TC Enqueue.
I believe it has to with the fact that PQO uses direct reads bypassing the SGA to read the object blocks and that requires to flush (checkpoint) all committed changes in the SGA (dirty buffers) of that object to make sure the PQ slaves will access the most recent version of that object. Regards, Waleed Khedr > Hi, > > I ask this on another forumbut unfortunately got no response > > I am trying to find out what 'TC' enqueue are. And why a select would would > wait for TC enqueue. I beleieve they have something to do with PQO and > checkpointing...but I could not find any more details. > > Any help appreciated. > > Thanks. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Heng > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Online Index Rebuild Tuning
Compressing indexes has been an option since 8i, and Jonathan Lewis has done some interesting presentations on this (I witnessed it at our Database Forum in Middelfart this year - very impresive). In short, it changes the way you should think of concatenated indexes, ie you should put the least selective column first, then compress it. That way you'll end up with very small indexes compared to the old days and ways. I don't see any drawbacks to this approach except that you of course has to unlearn what you have learned (Yoda?)... Other index things Jonathan adresses include: It is actually better to index small tables, even one-row tables. Mogens Rachel Carmichael wrote: http://www.tusc.com/oracle/download/author.html#loneyk --- John Kanagaraj <[EMAIL PROTECTED]> wrote: Mark, Also, I have heard about compressing indexes, but it is something I have never used before. Can anyone shed some light on the topic? Are there any drawbacks (ie: reduced IO but increased processing)? Kevin Loney presented a paper on this at IOUG 2002 - should be in the archives at www.ioug.org. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
Wait for TC Enqueue.
Hi, I ask this on another forumbut unfortunately got no response I am trying to find out what 'TC' enqueue are. And why a select would would wait for TC enqueue. I beleieve they have something to do with PQO and checkpointing...but I could not find any more details. Any help appreciated. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Heng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Did you check it with dump() ? select dump(unit_cost,16) from tablewhatever; for Hex. Check for unprintables that way. Try inserting the bad values into a look-aside table for later analysis i.e. create table look_aside (rownum rowid, bad_val varchar2(20), dump_val varchar2(200)); declare bad_num exception; numval number(10,2); pragma exception_init(bad_num,-1722); Cursor C1 is select rowid,unit_cost from yourtable; begin for x in C1 loop declare -- inner block will allow exception trap begin -- trim and change o's to zeroes numval := to_number(rtrim(replace(x.unit_cost,'O','0'))); exception when bad_num then insert into look_aside values (x.rowid,x.unit_cost, substr(dump(unit_cost,16),1,200)); end; end loop; commit; exception when others then dbms_output.put_line(sqlerrm); end; / You can use the rowids in the look-aside table to zap the bad values later. HTH Jeff Herrick On Thu, 5 Dec 2002, Burton, Laura L. wrote: > Since we don't have that many 3rd party software packages I did make the > mistake of asking 'Why??' and received 'Because!' so I too am trying to jump > in and 'fix it'. As I responded to another email earlier, the RTrim worked > because there were spaces after the amount which was causing the problem. > The only problem now is I have one record (so far) that has a unit cost that > looks like any other unit cost, yet I receive 'invalid number' for it. The > only thing I can figure is that there must be an unprintable character in > the field that I cannot see and rtrim is not deleting since it isn't a > space. > > Laura > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Laura, you can try to figure out what is wrong with that one row by using the dump function to get the octal or hex values of the bytes. the example from the SQL reference manual: SELECT DUMP('abc', 1016) FROM DUAL; DUMP('ABC',1016) -- Typ=96 Len=3 CharacterSet=WE8DEC: 61,62,63 By the way, "because" is only a valid answer if you are a parent talking to a child. :) --- "Burton, Laura L." <[EMAIL PROTECTED]> wrote: > Since we don't have that many 3rd party software packages I did make > the > mistake of asking 'Why??' and received 'Because!' so I too am trying > to jump > in and 'fix it'. As I responded to another email earlier, the RTrim > worked > because there were spaces after the amount which was causing the > problem. > The only problem now is I have one record (so far) that has a unit > cost that > looks like any other unit cost, yet I receive 'invalid number' for > it. The > only thing I can figure is that there must be an unprintable > character in > the field that I cannot see and rtrim is not deleting since it isn't > a > space. > > Laura > > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 05, 2002 5:34 PM > To: Multiple recipients of list ORACLE-L > > > Rachel, > > We have two Third Party apps here for Finance and Student Information > that > do ridiculous stuff like this so often, I just immediately jumped > into "fix > it" mode without even questioning. "Don't even ask why" is our > motto.; > -) > > Jack C. Applewhite > Database Administrator > Austin Independent School District > Austin, Texas > 512.414.9715 (wk) > 512.935.5929 (pager) > [EMAIL PROTECTED] > > > > > > Rachel > > Carmichael To: Multiple recipients > of list > ORACLE-L > > > AHOO.COM>cc: > > Sent by: Subject: Re: To_Number > > [EMAIL PROTECTED] > > om > > > > > > 12/05/2002 > > 03:49 PM > > Please respond > > to ORACLE-L > > > > > > > > Am I the only one wondering why an obviously numeric field > (unit_cost???) is being stored as varchar? > > --- [EMAIL PROTECTED] wrote: > > > > Laura, > > > > Are those really zeros in $34,000.05 or are they letter Os? If so > > use > > Replace. (Beware of letter l being used instead of numeral 1 as > > well.) > > > > Any leading or trailing spaces? If so use Trim(unit_cost). > > > > Just a couple of quick suggestions. > > > > Jack C. Applewhite > > > > > >Burton, Laura > > > > I have a table which contains a Unit_Cost varchar2(16) which > contains > > $34,000.05. I can enter select > > to_number('$34,990.08','$999,999,999.99') > > from dual; and the results is 34990.08. However when I enter > select > > to_number(unit_cost,'$999,999,999.99') from elas.qdr I get > ora-01722: > > invalid number. > > > > Is there any other way to do this? I am trying to add a varchar2 > > field > > that contains $ and commas. I thought the to_number function would > > convert > > the data to a number field. > > > > Thanks, > > > > Laura > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online Index Rebuild Tuning
http://www.tusc.com/oracle/download/author.html#loneyk --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > Mark, > > >Also, I have heard about compressing indexes, but it is > >something I have > >never used before. Can anyone shed some light on the topic? > >Are there any > >drawbacks (ie: reduced IO but increased processing)? > > Kevin Loney presented a paper on this at IOUG 2002 - should be in the > archives at www.ioug.org. > > John Kanagaraj > Oracle Applications DBA > DB Soft Inc > Work : (408) 970 7002 > > Listen to great, commercial-free christian music 24x7x365 at > http://www.klove.com > > ** The opinions and facts contained in this message are entirely mine > and do not reflect those of my employer or customers ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rename and BMC backup
No, backups do not lock anything inside the database; it has absolutely nothing to do with backups or BMC. A user's database session was performing DML or DDL on the table, plain and simple. Database sessions can persist after the user session has been killed, detected by querying V$SESSION. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 3:14 PM > Hi all. > > Yeaterday we were tyring to rename a table. The rename > command failed with > > ORA-00054: resource busy and acquire with NOWAIT > specified > > Could that error somewhow be a result of a hot backup > running at the same time via BMC. I know that the hot > backup doesn't lock table for DML, but this is a DDL > command. Is there any scenario that can explain this > error by the BMC backup? Our version of Oracle is > 8.1.7. Afaik no transactions after the table being > renamed have been running at the time > > thanks > > Gene > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gurelei > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Title: RE: To_Number Since we don't have that many 3rd party software packages I did make the mistake of asking 'Why??' and received 'Because!' so I too am trying to jump in and 'fix it'. As I responded to another email earlier, the RTrim worked because there were spaces after the amount which was causing the problem. The only problem now is I have one record (so far) that has a unit cost that looks like any other unit cost, yet I receive 'invalid number' for it. The only thing I can figure is that there must be an unprintable character in the field that I cannot see and rtrim is not deleting since it isn't a space. Laura -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: To_Number Rachel, We have two Third Party apps here for Finance and Student Information that do ridiculous stuff like this so often, I just immediately jumped into "fix it" mode without even questioning. "Don't even ask why" is our motto. ; -) Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Rachel Carmichael To: Multiple recipients of list ORACLE-L AHOO.COM> cc: Sent by: Subject: Re: To_Number [EMAIL PROTECTED] om 12/05/2002 03:49 PM Please respond to ORACLE-L Am I the only one wondering why an obviously numeric field (unit_cost???) is being stored as varchar? --- [EMAIL PROTECTED] wrote: > > Laura, > > Are those really zeros in $34,000.05 or are they letter Os? If so > use > Replace. (Beware of letter l being used instead of numeral 1 as > well.) > > Any leading or trailing spaces? If so use Trim(unit_cost). > > Just a couple of quick suggestions. > > Jack C. Applewhite > > >Burton, Laura > > I have a table which contains a Unit_Cost varchar2(16) which contains > $34,000.05. I can enter select > to_number('$34,990.08','$999,999,999.99') > from dual; and the results is 34990.08. However when I enter select > to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: > invalid number. > > Is there any other way to do this? I am trying to add a varchar2 > field > that contains $ and commas. I thought the to_number function would > convert > the data to a number field. > > Thanks, > > Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Enqueue Waits in Oracle Financials
Jay, Does this come from the alert manager? Do you have any of those new-fangled 11i modules (or should I call the 'mangled'!!). You could use the script below (adapted from Govind who posted this a few days back) set pages 100 column sid_serial format a10 heading "Sid/Ser#" column username format a15 heading "DB/OSUser" column start_time format a18 heading "StartTime" column mins_pending format 999 heading "Mins" column used_ublk format heading "Blks" column name format a10 heading "Rbs Name" column status format a12 heading "Status" select sid || '/' || serial# sid_serial, username || '/' || osuser username, substr(t.start_time,1,18) start_time, round( ( sysdate - TO_DATE( start_time, 'MM/DD/YY HH24:MI:SS') ) *24*60 ,0 ) mins_pending, r.name, t.used_ublk , decode(t.space, 'YES', 'SPACE TX', decode(t.recursive, 'YES', 'RECURSIVE TX', decode(t.noundo, 'YES', 'NO UNDO TX', t.status))) status from v$transaction t, v$rollname r, v$session s where t.xidusn = r.usn and t.ses_addr = s.saddr order by t.start_time / If the OS user turns out to be 'applmgr' for any waiting TXN then pursue this from the CM side. Otherwise, you can look at the Forms users. In any case, are you using OAM (Oracle Applications Manager)? John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: Jay Hostetter [mailto:[EMAIL PROTECTED]] >Sent: Thursday, December 05, 2002 8:25 AM >To: Multiple recipients of list ORACLE-L >Subject: Enqueue Waits in Oracle Financials > > >I noticed a lot of enqueue wait events in our 11i database. I >ran some queries and was able to determine the process that is >incurring these waits. I dutifully did a set event 10046 and >examined the trace file. I've also queried v$lock. I've >figured out that this is a UL (user defined) wait. Now I'm >stuck. I haven't figured out exactly what we are waiting for. > Although by monitoring the current SQL statement for the >offending process, I see that it does a SELECT FOR UPDATE in >the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS >tables. This creates a TM lock, which I see, but I don't >think it explains the UL lock. I've seen examples on how to >interpret p1 for an enqueue lock, but not p2. I would >appreciate a little guidance. I believe that the offending >process is the Internal manager, but I would like to >understand a little more about what is occurring. Is this a >typical problem in 11i? I guess the ICM may issue user >defined locks, then just waits for a certa! >in! > amount of time. I would guess that all 11i databases have a >high number of enqueue waits if this is the case. I am >running 11.5.6 against 8.1.7 on Tru64. > >Thank you, >Jay > >Sample output from the trace: >WAIT #114: nam='enqueue' ela= 102 p1=1431044098 p2=1073807913 p3=0 >WAIT #114: nam='enqueue' ela= 103 p1=1431044098 p2=1073807914 p3=0 >WAIT #114: nam='enqueue' ela= 102 p1=1431044098 p2=1073807915 p3=0 > >So if I check out p1 I see a UL lock mode 2: >SQL> run > 1 SELECT chr(bitand(1431044098,-16777216)/16777215)|| > 2 chr(bitand(1431044098, 16711680)/65535) "Lock", > 3 to_char( bitand(1431044098, 65535) )"Mode" > 4* from dual > >Lo M >-- - >UL 2 > >Sample output from v$lock for SID 14 (not at the exact same >time as the lock shown above): > >ADDR KADDR Sid TYID1 >ID2 LMODEREQUEST CTIME BLOCK > - -- -- >-- -- -- -- -- >00040147E578 00040147E5A014 TM 130213 >0 2 0 78 0 >000400B1B430 000400B1B45014 UL 1073741851 >0 6 0 33188 0 >000400B16340 000400B1636014 UL 1073807990 >0 6 0 33158 0 > >I can see that there are quite a few UL waits: >SQL> run > 1 SELECT ksqsttyp "Lock", > 2 ksqstget "Gets", > 3 ksqstwat "Waits" > 4* FROM X$KSQST where KSQSTWAT > 0 > >Lo Gets Waits >-- -- -- >TX 170144 59 >UL 7275 6011 > >Other info: >SQL> SELECT * > FROM v$sysstat > WHERE cla 23 ss=4; > >STATISTIC# NAME > CLASS VALUE >-- >--- >- -- -- >22 enqueue timeouts > 4 6729 >23 enqueue waits > 4 6297 >24 enqueue deadlocks
RE: Online Index Rebuild Tuning
Mark, >Also, I have heard about compressing indexes, but it is >something I have >never used before. Can anyone shed some light on the topic? >Are there any >drawbacks (ie: reduced IO but increased processing)? Kevin Loney presented a paper on this at IOUG 2002 - should be in the archives at www.ioug.org. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Online Index Rebuild Tuning
I tried using compress in the past and ran into a bug with "and_equal" access paths. You'd get ORA-600's. I think it was 8.1.7.2 on Win2k. don't know if it's been fixed. steve - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 3:35 PM > Connor, > > That's a good point - something which I really hadn't thought about. > Unfortunately many of the indexes relate to foreign keys and primary keys, > which are an ever increasing value here. I've already tried rebuilding one > or two small indexes and they shrunk from ~180MB to ~70MB. > > Also, I have heard about compressing indexes, but it is something I have > never used before. Can anyone shed some light on the topic? Are there any > drawbacks (ie: reduced IO but increased processing)? > > Thanks, > Mark. > > > > > Connor > McDonald To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > co.uk> Subject: Re: Online Index Rebuild Tuning > Sent by: > [EMAIL PROTECTED] > om > > > 05/12/2002 > 20:24 > Please respond > to ORACLE-L > > > > > > > The first question is whether you really need to > rebuild them. If the indexes columns are such that > the values are likely to be reused, then I wouldn't > bother - since that deleted space will get reused as > required. > > Cheers > Connor > > --- Mark Richard <[EMAIL PROTECTED]> wrote: > > Folks, > > > > I know that when creating indexes a couple of > > settings such as > > SORT_AREA_SIZE can have a big impact on duration. > > What settings apply > > during online rebuilds? Are the rules the same? > > What tips do you have? > > > > Basically we have some very large indexes in an OLTP > > system (several > > indexes are across ~250m rows, several GB in > > physical storage) which have > > fairly low density due to deletes and updates. In > > looks like the time has > > come to rebuild then to gain some performance. Any > > other suggestions > > regarding tricks to avoid this, etc would be greatly > > appreciated. > > > > Thanks, > > Mark. > > > > PS: If you going to suggest things which are > > version specific we're > > dealing with 8.1.7.4 on Solaris. > > > > > <<>> > > >Privileged/Confidential information may be > > contained in this message. > > If you are not the addressee indicated in > > this message > >(or responsible for delivery of the message > > to such person), > > you may not copy or deliver this message > > to anyone. > > In such case, you should destroy this message and > > kindly notify the sender > >by reply e-mail or by telephone on (61 3) > > 9612-6999. > >Please advise immediately if you or your employer > > does not consent to > > Internet e-mail for messages of this > > kind. > > Opinions, conclusions and other information > > in this message > > that do not relate to the official > > business of > > Transurban City Link Ltd > > shall be understood as neither given nor > > endorsed by it. > > > <<<> > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Mark Richard > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and web > > hosting services > > > - > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > > = > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, > and...he will sit in a boat and drink beer all day" > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > -
Re: To_Number
Rachel, We have two Third Party apps here for Finance and Student Information that do ridiculous stuff like this so often, I just immediately jumped into "fix it" mode without even questioning. "Don't even ask why" is our motto.; -) Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Rachel Carmichael To: Multiple recipients of list ORACLE-L AHOO.COM>cc: Sent by: Subject: Re: To_Number [EMAIL PROTECTED] om 12/05/2002 03:49 PM Please respond to ORACLE-L Am I the only one wondering why an obviously numeric field (unit_cost???) is being stored as varchar? --- [EMAIL PROTECTED] wrote: > > Laura, > > Are those really zeros in $34,000.05 or are they letter Os? If so > use > Replace. (Beware of letter l being used instead of numeral 1 as > well.) > > Any leading or trailing spaces? If so use Trim(unit_cost). > > Just a couple of quick suggestions. > > Jack C. Applewhite > > >Burton, Laura > > I have a table which contains a Unit_Cost varchar2(16) which contains > $34,000.05. I can enter select > to_number('$34,990.08','$999,999,999.99') > from dual; and the results is 34990.08. However when I enter select > to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: > invalid number. > > Is there any other way to do this? I am trying to add a varchar2 > field > that contains $ and commas. I thought the to_number function would > convert > the data to a number field. > > Thanks, > > Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB corruption question
These errors are from the second database. It's normal to get them. I do not think there is any corruptions. As long the first one is running without errors then do not worry. To make sure try to restart the database. Regards, Waleed > Try, recreate the controlfile > - Original Message - > From: Nick Wagner > To: Multiple recipients of list ORACLE-L > Sent: Wednesday, December 04, 2002 10:09 PM > Subject: DB corruption question > > > > With Oracle 8.1.7, Solaris 8 OS. > > I have a shared storage device for storing all my datafiles, control files, > redo logs, archive logs, etc.. everything except for the ORACLE_HOME and Oracle > binaries. > > If I have the file system and database mounted to one machine, and have a > fully open, available database running. What happens if someone else tries to > mount the same files to another machine and start up the same database on it. > (No OPS or RAC involved) > > I get the following error on the on the second machine... > > > SVRMGR> ORACLE instance started. > Total System Global Area 272359584 bytes > Fixed Size 73888 bytes > Variable Size 88678400 bytes > Database Buffers 183427072 bytes > Redo Buffers 180224 bytes > Database mounted. > SVRMGR> ORA-00283: recovery session canceled due to errors > ORA-01122: database file 1 failed verification check > ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' > ORA-01207: file is more recent than controlfile - old controlfile > SVRMGR> alter database open > * > ORA-01122: database file 1 failed verification check > ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' > ORA-01207: file is more recent than controlfile - old controlfile > SVRMGR> Server Manager complete. > EXITING 1 > Unable to start Oracle instance > > Will this corrupt the database? Will it harm/corrupt the original instance? > What happens if someone tries to recover it at this point? Does it make a > difference whether its a RAW or cooked file system? > > Any help is appreciated! > > Nick > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Yes, yes you are. -Original Message- Sent: Thursday, December 05, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Am I the only one wondering why an obviously numeric field (unit_cost???) is being stored as varchar? --- [EMAIL PROTECTED] wrote: > > Laura, > > Are those really zeros in $34,000.05 or are they letter Os? If so > use > Replace. (Beware of letter l being used instead of numeral 1 as > well.) > > Any leading or trailing spaces? If so use Trim(unit_cost). > > Just a couple of quick suggestions. > > Jack C. Applewhite > Database Administrator > Austin Independent School District > Austin, Texas > 512.414.9715 (wk) > 512.935.5929 (pager) > [EMAIL PROTECTED] > > > > > > "Burton, Laura > > L." To: Multiple recipients > of list ORACLE-L > > > plus.com>cc: > > Sent by: Subject: To_Number > > [EMAIL PROTECTED] > > om > > > > > > 12/05/2002 > > 01:24 PM > > Please respond > > to ORACLE-L > > > > > > > > > > I have a table which contains a Unit_Cost varchar2(16) which contains > $34,000.05. I can enter select > to_number('$34,990.08','$999,999,999.99') > from dual; and the results is 34990.08. However when I enter select > to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: > invalid number. > > > Is there any other way to do this? I am trying to add a varchar2 > field > that contains $ and commas. I thought the to_number function would > convert > the data to a number field. > > > Thanks, > > > Laura > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rename and BMC backup
Hi all. Yeaterday we were tyring to rename a table. The rename command failed with ORA-00054: resource busy and acquire with NOWAIT specified Could that error somewhow be a result of a hot backup running at the same time via BMC. I know that the hot backup doesn't lock table for DML, but this is a DDL command. Is there any scenario that can explain this error by the BMC backup? Our version of Oracle is 8.1.7. Afaik no transactions after the table being renamed have been running at the time thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Title: To_Number Your guess is correct !! Thank you very much. It worked even without the rtrim, but I am leaving it in just in case. Thanks again, Laura -Original Message- From: Toepke, Kevin M [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: To_Number My guess is that you have leading or trailing spaces. try select to_number(LTRIM(RTRIM(unit_cost)),'$999,999,999.99') from elas.qdr -Original Message- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: sys login -probably a dumb question
You probably have the sys password incorrect on instance2. If you specify "as sysdba" it basically ignores the password if you are authorized as an OS user (belong to group oracle, for example). Adam -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sys login -probably a dumb questionNope - they are both 9.2.0.2 solaris 9>>> [EMAIL PROTECTED] 12/05/02 02:08PM >>> Any chance that instance 2 is 9i, and instance 1 isn't? -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: sys login -probably a dumb question I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why?
Re: Online Index Rebuild Tuning
Connor, That's a good point - something which I really hadn't thought about. Unfortunately many of the indexes relate to foreign keys and primary keys, which are an ever increasing value here. I've already tried rebuilding one or two small indexes and they shrunk from ~180MB to ~70MB. Also, I have heard about compressing indexes, but it is something I have never used before. Can anyone shed some light on the topic? Are there any drawbacks (ie: reduced IO but increased processing)? Thanks, Mark. Connor McDonald To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Online Index Rebuild Tuning Sent by: [EMAIL PROTECTED] om 05/12/2002 20:24 Please respond to ORACLE-L The first question is whether you really need to rebuild them. If the indexes columns are such that the values are likely to be reused, then I wouldn't bother - since that deleted space will get reused as required. Cheers Connor --- Mark Richard <[EMAIL PROTECTED]> wrote: > Folks, > > I know that when creating indexes a couple of > settings such as > SORT_AREA_SIZE can have a big impact on duration. > What settings apply > during online rebuilds? Are the rules the same? > What tips do you have? > > Basically we have some very large indexes in an OLTP > system (several > indexes are across ~250m rows, several GB in > physical storage) which have > fairly low density due to deletes and updates. In > looks like the time has > come to rebuild then to gain some performance. Any > other suggestions > regarding tricks to avoid this, etc would be greatly > appreciated. > > Thanks, > Mark. > > PS: If you going to suggest things which are > version specific we're > dealing with 8.1.7.4 on Solaris. > > <<>> >Privileged/Confidential information may be > contained in this message. > If you are not the addressee indicated in > this message >(or responsible for delivery of the message > to such person), > you may not copy or deliver this message > to anyone. > In such case, you should destroy this message and > kindly notify the sender >by reply e-mail or by telephone on (61 3) > 9612-6999. >Please advise immediately if you or your employer > does not consent to > Internet e-mail for messages of this > kind. > Opinions, conclusions and other information > in this message > that do not relate to the official > business of > Transurban City Link Ltd > shall be understood as neither given nor > endorsed by it. > <<<> > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Connor McD
Re: To_Number
Am I the only one wondering why an obviously numeric field (unit_cost???) is being stored as varchar? --- [EMAIL PROTECTED] wrote: > > Laura, > > Are those really zeros in $34,000.05 or are they letter Os? If so > use > Replace. (Beware of letter l being used instead of numeral 1 as > well.) > > Any leading or trailing spaces? If so use Trim(unit_cost). > > Just a couple of quick suggestions. > > Jack C. Applewhite > Database Administrator > Austin Independent School District > Austin, Texas > 512.414.9715 (wk) > 512.935.5929 (pager) > [EMAIL PROTECTED] > > > > > > "Burton, Laura > > L." To: Multiple recipients > of list ORACLE-L > > > plus.com>cc: > > Sent by: Subject: To_Number > > [EMAIL PROTECTED] > > om > > > > > > 12/05/2002 > > 01:24 PM > > Please respond > > to ORACLE-L > > > > > > > > > > I have a table which contains a Unit_Cost varchar2(16) which contains > $34,000.05. I can enter select > to_number('$34,990.08','$999,999,999.99') > from dual; and the results is 34990.08. However when I enter select > to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: > invalid number. > > > Is there any other way to do this? I am trying to add a varchar2 > field > that contains $ and commas. I thought the to_number function would > convert > the data to a number field. > > > Thanks, > > > Laura > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are There any way of calling NT OS Commands like print, del e
On Thu, 5 Dec 2002, Bishop Lewis wrote: > Shiva, > > Attached is an email from Ankur Shah from another posting - have not tried > it myself but this may help. > > Lewis Bishop > --- The email was instructional but it's only good for Unix. There is no equivalent for 'system()' in the Win32 world unless you write your own. The code below has been tested and it works. ;) WARNING *** WARNING * The code below will workbut it is not secure in that it only does what it is told to do. If somebody sends the proc a disk 'format' command it will run it...you have been warned. Make sure the PL/SQL wrapper procedure that calls the external is SECURE. Also think about running the external procedure listener under a different user id that can't do any damage. The following code can be placed in a DLL --- begin code -- ORACMD_API void RunCommand(char *cmd) { STARTUPINFO lpStartupInfo; PROCESS_INFORMATION lpProcessInfo; DWORD Derr; BOOL pid; DWORD Stat; LPDWORD lpStat = &Stat; char script[1024]; char str[1024]; char msg[1024]; char buf[1024]; char cwd[256]; strcpy(script,cmd); getcwd(cwd,255); cwd[255] = '\0'; // // run the script // Set up the STARTUPINFO Structure...this structure // determines what the window is going to look like lpProcessInfo.dwProcessId = -1; lpProcessInfo.dwProcessId = -1; lpStartupInfo.cb = sizeof(STARTUPINFO); // struct size lpStartupInfo.lpReserved = NULL; // Reserved for Bill lpStartupInfo.lpDesktop = NULL; // WinNT Desktop lpStartupInfo.lpTitle = NULL; // for GUI processes lpStartupInfo.dwX = 0; lpStartupInfo.dwY = 0; lpStartupInfo.dwXSize = 800; lpStartupInfo.dwYSize = 600; lpStartupInfo.wShowWindow = SW_SHOW; lpStartupInfo.cb = 0; // Reserved must be zero lpStartupInfo.lpReserved2 = NULL; // Reserved must be NULL // Call ::CreateProcess to create a new threadInfo about // the new thread will be returned in the PROCESS_INFORMATION // structure lpStartupInfo.dwFlags = STARTF_USESHOWWINDOW | STARTF_USEPOSITION | STARTF_USESIZE; //MessageBox(NULL,script,NULL,MB_OK); if((pid = ::CreateProcess(NULL, // Application Name (executable or bat file) (char *) script, // command Line NULL, // Process Security Attributes NULL, // Thread Security Attributes TRUE, // Handle Inheritance Flag CREATE_SUSPENDED,// Creation Flags NULL, // Process Environment (use Parent's) cwd, // Current directory (use DLL's dir) &lpStartupInfo, // Start up information &lpProcessInfo)) == 0) { Derr = GetLastError(); sprintf(buf," Unable to start process <%s> Error Code = %d", str,Derr); //MessageBox(NULL,buf,"ERROR",MB_OK); } else { sprintf(msg,"Created Pid %08x",lpProcessInfo.dwProcessId); //MessageBox(NULL,msg,NULL,MB_OK); // // The Thread was created suspended...now we // activiate it. ::ResumeThread(lpProcessInfo.hThread); } } -- end code - Notes... 1) The external procedure listener must be configured and running...you should be able to 'tnsping EXTPROC_CONNECTION_DATA' and get a reply. See Metalink or the manuals for setup 2) Create a Visual C++ project named 'oracmd' and then the type entered above will work. Use the Win32 DLL template with the option that exports functions 3) disable name-mangling (name decoration) for the exported function by putting extern "C" ORACMD_API void RunCommand(char *); in the exported function declarion section of the oracmd.h Also make sure you include direct.h (for getcwd()) and good old stdio.h for the strcpy()/sprintf() calls 4) Compile/build the .dll and copy it to a location that is in the server's PATH (%SYSTEMROOT%\System32 or %ORACLE_HOME%\bin) 5) Issue the CREATE LIBRARY command pointing at the DLL location and issue the CREATE PROCEDURE AS EXTERNAL command using the name from the code above i.e. RunCommand 6) Test execution of the procedure. The process runs in the current directory of the DLL The only way to make sure that it is working is to create a test '.bat' file which will do something fairly harmless and that also logs information to disk. Then you can look for the logfile. Do not put a 'pause' statement in the .bat file or you will be left with orphaned CMD.EXE processes...I kn
RE: sys login -probably a dumb question
Nope - they are both 9.2.0.2 solaris 9>>> [EMAIL PROTECTED] 12/05/02 02:08PM >>> Any chance that instance 2 is 9i, and instance 1 isn't? -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: sys login -probably a dumb question I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why?
Re: To_Number
Laura, Are those really zeros in $34,000.05 or are they letter Os? If so use Replace. (Beware of letter l being used instead of numeral 1 as well.) Any leading or trailing spaces? If so use Trim(unit_cost). Just a couple of quick suggestions. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] "Burton, Laura L." To: Multiple recipients of list ORACLE-L plus.com>cc: Sent by: Subject: To_Number [EMAIL PROTECTED] om 12/05/2002 01:24 PM Please respond to ORACLE-L I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to script or document jobs defined to the NT/MS2000 T
Do you map the other computers Scheduled Task drive to make the copy? I tried just copy and past between two sessions and it didn't like that. Ron -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Task Ron, Saw your memo and fooled around with Task Scheduler a bit. All it is is Windows Explorer pointed at the Scheduled Tasks folder in Control Panel. To back up your Scheduled Tasks, simply single click on one or more of them (or use the Edit / Select All menu item, then de-select Add Scheduled Task), then choose the Edit / Copy To Folder menu item. A single *.job file is created for each Scheduled Task in the target folder. You can then copy those files into another Server's or PC's Scheduled Tasks folder in Control Panel. Those copied-in Scheduled Tasks then appear in the target's Task Scheduler with all their info. Glad you brought this up, since we have a Win2k server with LOTS of Scheduled Tasks. Now I know how to back them up. I just now followed the above procedure and now have all the Scheduled Tasks from that server in my own Task Scheduler on my PC. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] "Smith, Ron L." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]<[EMAIL PROTECTED]> om> cc: Sent by: Subject: Any way to script or document jobs [EMAIL PROTECTED]defined to the NT/MS2000 Task om 12/05/2002 08:24 AM Please respond to ORACLE-L We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Title: RE: To_Number Very Possible. I'm 8.1.7.2 W2K sp2 -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: To_Number Lisa; I wonder if it depends on the DB version. I did this on an 8.0.5 and got the invalid number error running the exact query that succeeded on yours. I had to do a replace on both the commas and the dollar sign. -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: To_Number Laura are you sure you aren't trying this with the quotes? See below SQL> select * from testnum; COL1 --- $24,990.09 SQL> select to_number('col1','$999,999,999.99') from testnum; select to_number('col1','$999,999,999.99') from testnum * ERROR at line 1: ORA-01722: invalid number SQL> select to_number(col1,'$999,999,999.99') from testnum; TO_NUMBER(COL1,'$999,999,999.99') - 24990.09 Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: To_Number
Title: To_Number My guess is that you have leading or trailing spaces. try select to_number(LTRIM(RTRIM(unit_cost)),'$999,999,999.99') from elas.qdr -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 2:24 PMTo: Multiple recipients of list ORACLE-LSubject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: To_Number
Title: To_Number Laura, Works for me: SQL> select unit_cost, to_number(unit_cost,'$999,999.99') from tomtest; UNIT_COST TO_NUMBER(UNIT_COST,'$999,999.99') --$34,100.50 34100.5$34,000.05 34000.05 $9.25 9.25 SQL> What version of sqlplus are you using? Tom Mercadante Oracle Certified Professional -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 2:24 PMTo: Multiple recipients of list ORACLE-LSubject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: To_Number
Title: RE: To_Number Lisa; I wonder if it depends on the DB version. I did this on an 8.0.5 and got the invalid number error running the exact query that succeeded on yours. I had to do a replace on both the commas and the dollar sign. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: To_Number Laura are you sure you aren't trying this with the quotes? See below SQL> select * from testnum; COL1 --- $24,990.09 SQL> select to_number('col1','$999,999,999.99') from testnum; select to_number('col1','$999,999,999.99') from testnum * ERROR at line 1: ORA-01722: invalid number SQL> select to_number(col1,'$999,999,999.99') from testnum; TO_NUMBER(COL1,'$999,999,999.99') - 24990.09 Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: sys login -probably a dumb question
Title: RE: sys login -probably a dumb question Any chance that instance 2 is 9i, and instance 1 isn't? -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: sys login -probably a dumb question I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why?
Oracle Designer book
Does anyone know of a good Oracle Designer book published in the past year or two? Something relevant to iDS9iR2 or equivalent. 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]
RE: To_Number
Title: To_Number I believe its the $ and , in the data. I got the same error until I did select to_number(replace(replace(unit_cost,'$',''),',','')) from elas.qdr -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 1:24 PMTo: Multiple recipients of list ORACLE-LSubject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
Re: Any way to script or document jobs defined to the NT/MS2000 Task
Ron, Saw your memo and fooled around with Task Scheduler a bit. All it is is Windows Explorer pointed at the Scheduled Tasks folder in Control Panel. To back up your Scheduled Tasks, simply single click on one or more of them (or use the Edit / Select All menu item, then de-select Add Scheduled Task), then choose the Edit / Copy To Folder menu item. A single *.job file is created for each Scheduled Task in the target folder. You can then copy those files into another Server's or PC's Scheduled Tasks folder in Control Panel. Those copied-in Scheduled Tasks then appear in the target's Task Scheduler with all their info. Glad you brought this up, since we have a Win2k server with LOTS of Scheduled Tasks. Now I know how to back them up. I just now followed the above procedure and now have all the Scheduled Tasks from that server in my own Task Scheduler on my PC. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] "Smith, Ron L." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]<[EMAIL PROTECTED]> om> cc: Sent by: Subject: Any way to script or document jobs [EMAIL PROTECTED]defined to the NT/MS2000 Task om 12/05/2002 08:24 AM Please respond to ORACLE-L We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Title: RE: To_Number Laura are you sure you aren't trying this with the quotes? See below SQL> select * from testnum; COL1 --- $24,990.09 SQL> select to_number('col1','$999,999,999.99') from testnum; select to_number('col1','$999,999,999.99') from testnum * ERROR at line 1: ORA-01722: invalid number SQL> select to_number(col1,'$999,999,999.99') from testnum; TO_NUMBER(COL1,'$999,999,999.99') - 24990.09 Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: Database up longer that host?
OK, since it's virtual anyway, >>> <[EMAIL PROTECTED]> 12/04/02 06:18PM >>> Thanks, but I'd rather have a nice shot of Scotch. :) Jared "Stephen Andert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/04/2002 03:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Database up longer that host? Give the man a cigar. (virtual one of course :) That is what I was looking for and makes unix uptime and db_uptime.sql report a compatible time frame. Thanks Jared. Stephen >>> [EMAIL PROTECTED] 12/03/02 04:02PM >>> Try: col uptime format a40 head 'UPTIME' select to_char(sysdate,'hh:miam') || ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, ' || trunc( (sysdate - trunc(sysdate)) *24 ,0) || ':' -- hours || trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', ' -- minutes || s.user_count || ' users' uptime from v$instance i, ( select count(*) user_count from v$session where username is not null ) s / "Stephen Andert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/02/2002 07:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Database up longer that host? Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example "up 4 days, 21:08 hours". In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen >>> [EMAIL PROTECTED] 12/02/02 07:43PM >>> You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: > Stephen Andert wrote: > > > > I use a script named db_uptime.sql (I think I got it from the list here) > > to calculate how long the database has been up. The output compares > > nicely to the unix uptime command. > >I hope that the query doesn't come from the list, because it is > wrong. The error is to apply floor() before multiplying by 24 or 60 - > you have tremendous rounding errors. > My own database has not been up long enough to be 100% sure about it but > I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---
Re: DB corruption question
Try, recreate the controlfile - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 04, 2002 10:09 PM Subject: DB corruption question With Oracle 8.1.7, Solaris 8 OS. I have a shared storage device for storing all my datafiles, control files, redo logs, archive logs, etc.. everything except for the ORACLE_HOME and Oracle binaries. If I have the file system and database mounted to one machine, and have a fully open, available database running. What happens if someone else tries to mount the same files to another machine and start up the same database on it. (No OPS or RAC involved) I get the following error on the on the second machine... SVRMGR> ORACLE instance started. Total System Global Area 272359584 bytes Fixed Size 73888 bytes Variable Size 88678400 bytes Database Buffers 183427072 bytes Redo Buffers 180224 bytes Database mounted. SVRMGR> ORA-00283: recovery session canceled due to errors ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile SVRMGR> alter database open * ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile SVRMGR> Server Manager complete. EXITING 1 Unable to start Oracle instance Will this corrupt the database? Will it harm/corrupt the original instance? What happens if someone tries to recover it at this point? Does it make a difference whether its a RAW or cooked file system? Any help is appreciated! Nick
sys login -probably a dumb question
I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abcbut on instance def I can't connect by sys/not_default2@def it gives a ERROR:ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why?
RE: ORA-1653: unable to extend table - Why?
I came across the param in my Internals handbook (I'd never heard of it before). It could be different for the release/platform. The concept is probably the same. (?) -Original Message- Sent: Thursday, December 05, 2002 11:59 AM To: Multiple recipients of list ORACLE-L I think you may have meant _walk_insert_threshold which by default is set to 0 (not set). Waleed > Dan, I think you nailed it! > > It will be interesting to see the # of blocks and # of rows in this table. > > - Kirti > > -Original Message- > Sent: Thursday, December 05, 2002 9:44 AM > To: Multiple recipients of list ORACLE-L > > > Vitals: > Average Row Length = 1895 > Block Size = 4096 > pct_free = 10% > Threshold to put block off freelist = 3686 > pct_used = 75% > Threshold to put block on freelist = 3072 > Average free space = 3895 > > Working with averages, there could be at most 2 rows per block. The Average > free space is also very close to the block size, which indicates to me that > the blocks on the free list are probably empty. > > Will a transaction insert a row into a block when it knows that the insert > will push the block above the pct_free threshold? I can see logic on both > sides. Don't insert because an update is more likely to cause row migration. > Do insert because the space is wasted otherwise. > > After deleting 2 million rows, the # of blocks on the freelist is slightly > over 2 million. Is this a coincidence? I'll take a guess and say that the > insert processes are probably trying to acquire 1 block per 2 rows. Add in > the other processes doing inserts, each one needs its own block if it is > reusing it. > > I'm wondering if the insert transaction started walking the freelist, could > not find an open block (because they were being used by other transactions) > within a certain period (# of blocks checked or timeout) and decided to > simply allocate another extent in order to enable the transaction to > complete. In reviewing my notes/docs from the Internals Seminar (8i), there > is a threshold (_release_insert_threshold) that will cause a new extent to > be allocated even when there are blocks on the master free list. This seems > a very likely scenario, given the large row size in comparison to the block > size. > > Dan Fink > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
To_Number
Title: To_Number I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number. Is there any other way to do this? I am trying to add a varchar2 field that contains $ and commas. I thought the to_number function would convert the data to a number field. Thanks, Laura
RE: ORA-1653: unable to extend table - Why?
I think you may have meant _walk_insert_threshold which by default is set to 0 (not set). Waleed > Dan, I think you nailed it! > > It will be interesting to see the # of blocks and # of rows in this table. > > - Kirti > > -Original Message- > Sent: Thursday, December 05, 2002 9:44 AM > To: Multiple recipients of list ORACLE-L > > > Vitals: > Average Row Length = 1895 > Block Size = 4096 > pct_free = 10% > Threshold to put block off freelist = 3686 > pct_used = 75% > Threshold to put block on freelist = 3072 > Average free space = 3895 > > Working with averages, there could be at most 2 rows per block. The Average > free space is also very close to the block size, which indicates to me that > the blocks on the free list are probably empty. > > Will a transaction insert a row into a block when it knows that the insert > will push the block above the pct_free threshold? I can see logic on both > sides. Don't insert because an update is more likely to cause row migration. > Do insert because the space is wasted otherwise. > > After deleting 2 million rows, the # of blocks on the freelist is slightly > over 2 million. Is this a coincidence? I'll take a guess and say that the > insert processes are probably trying to acquire 1 block per 2 rows. Add in > the other processes doing inserts, each one needs its own block if it is > reusing it. > > I'm wondering if the insert transaction started walking the freelist, could > not find an open block (because they were being used by other transactions) > within a certain period (# of blocks checked or timeout) and decided to > simply allocate another extent in order to enable the transaction to > complete. In reviewing my notes/docs from the Internals Seminar (8i), there > is a threshold (_release_insert_threshold) that will cause a new extent to > be allocated even when there are blocks on the master free list. This seems > a very likely scenario, given the large row size in comparison to the block > size. > > Dan Fink > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Dan, I think you nailed it! It will be interesting to see the # of blocks and # of rows in this table. - Kirti -Original Message- Sent: Thursday, December 05, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Vitals: Average Row Length = 1895 Block Size = 4096 pct_free = 10% Threshold to put block off freelist = 3686 pct_used = 75% Threshold to put block on freelist = 3072 Average free space = 3895 Working with averages, there could be at most 2 rows per block. The Average free space is also very close to the block size, which indicates to me that the blocks on the free list are probably empty. Will a transaction insert a row into a block when it knows that the insert will push the block above the pct_free threshold? I can see logic on both sides. Don't insert because an update is more likely to cause row migration. Do insert because the space is wasted otherwise. After deleting 2 million rows, the # of blocks on the freelist is slightly over 2 million. Is this a coincidence? I'll take a guess and say that the insert processes are probably trying to acquire 1 block per 2 rows. Add in the other processes doing inserts, each one needs its own block if it is reusing it. I'm wondering if the insert transaction started walking the freelist, could not find an open block (because they were being used by other transactions) within a certain period (# of blocks checked or timeout) and decided to simply allocate another extent in order to enable the transaction to complete. In reviewing my notes/docs from the Internals Seminar (8i), there is a threshold (_release_insert_threshold) that will cause a new extent to be allocated even when there are blocks on the master free list. This seems a very likely scenario, given the large row size in comparison to the block size. Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-1653: unable to extend table - Why?
Dan, I think you're right: There's exactly one row in each block and the rest of the space is wasted. No wonder the table is growing. So make it possible for Oracle to put more than one row into a block (or rather: to pack data more tightly into the blocks) either by changing the storage parameters or by changing the block size. I'm not sure fiddling with the _-parameter would help any. Mogens Fink, Dan wrote: Vitals: Average Row Length = 1895 Block Size = 4096 pct_free = 10% Threshold to put block off freelist = 3686 pct_used = 75% Threshold to put block on freelist = 3072 Average free space = 3895 Working with averages, there could be at most 2 rows per block. The Average free space is also very close to the block size, which indicates to me that the blocks on the free list are probably empty. Will a transaction insert a row into a block when it knows that the insert will push the block above the pct_free threshold? I can see logic on both sides. Don't insert because an update is more likely to cause row migration. Do insert because the space is wasted otherwise. After deleting 2 million rows, the # of blocks on the freelist is slightly over 2 million. Is this a coincidence? I'll take a guess and say that the insert processes are probably trying to acquire 1 block per 2 rows. Add in the other processes doing inserts, each one needs its own block if it is reusing it. I'm wondering if the insert transaction started walking the freelist, could not find an open block (because they were being used by other transactions) within a certain period (# of blocks checked or timeout) and decided to simply allocate another extent in order to enable the transaction to complete. In reviewing my notes/docs from the Internals Seminar (8i), there is a threshold (_release_insert_threshold) that will cause a new extent to be allocated even when there are blocks on the master free list. This seems a very likely scenario, given the large row size in comparison to the block size. Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ECM / BCV / hot backup
I agree with that. Unfortunately, that is the only way because RMAN doesn't support BCV's just yet. The problem with BCV is that the database on the "Business Continuity Volume" is the same as the original, including the DBID. As you know, RMAN uses DBID for registration purposes and you cannot register the resulting database. What would be needed is for RMAN to start time-finder itself and copy (used to be "SRDF") the original database to the "BCV" version, but we aren't there yet. What is that "ECO alliance" doing, anyway (ECO = EMC, Cisco, Oracle). Be sure to have large MAXHISTORY value so that your control file contains sufficient number of redo logs. -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ECM / BCV / hot backup Do backup controlfile before step #1 and make sure that it is swept up by Omniback during step #6. There is no need for step #2. Don't forget that step #6 also has to back up archivelogs as well as datafiles and the controlfile backup. --- Better yet, do use RMAN instead. The RMAN user's guide describes exactly this scenario... - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 5:03 AM Subject: ECM / BCV / hot backup Good morning/afternoon/evening to everyone... I'm about to "configure" oracle backup policy using ECM storgae and HP OmniBack. My idea is as follows 1. put all tablespaces into backup mode (db is in arch. mode), 2. sleep 3. do the split 4. take out tablespaces of backup mode, 5. alter system switch logfile, 6. let the Omni Back do it's job. Anu do's and don't's regarding EMC/Oracle combination?
RE: Enqueue Waits in Oracle Financials
Jay, You may want to refer to Metalink Doc Id #29787.1 and 34566.1. Those will explain what p2, p3 are in an enqueue wait. Unfortunately, those will not discuss p2, p3 for UL :( I know nothing about Oracle Apps (11i). May be John K. could comment on that. - Kirti -Original Message- Sent: Thursday, December 05, 2002 10:25 AM To: Multiple recipients of list ORACLE-L I noticed a lot of enqueue wait events in our 11i database. I ran some queries and was able to determine the process that is incurring these waits. I dutifully did a set event 10046 and examined the trace file. I've also queried v$lock. I've figured out that this is a UL (user defined) wait. Now I'm stuck. I haven't figured out exactly what we are waiting for. Although by monitoring the current SQL statement for the offending process, I see that it does a SELECT FOR UPDATE in the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS tables. This creates a TM lock, which I see, but I don't think it explains the UL lock. I've seen examples on how to interpret p1 for an enqueue lock, but not p2. I would appreciate a little guidance. I believe that the offending process is the Internal manager, but I would like to understand a little more about what is occurring. Is this a typical problem in 11i? I guess the ICM may issue user defined locks, then just waits for a certain! ! ! amount of time. I would guess that all 11i databases have a high number of enqueue waits if this is the case. I am running 11.5.6 against 8.1.7 on Tru64. Thank you, Jay Sample output from the trace: WAIT #114: nam='enqueue' ela= 102 p1=1431044098 p2=1073807913 p3=0 WAIT #114: nam='enqueue' ela= 103 p1=1431044098 p2=1073807914 p3=0 WAIT #114: nam='enqueue' ela= 102 p1=1431044098 p2=1073807915 p3=0 So if I check out p1 I see a UL lock mode 2: SQL> run 1 SELECT chr(bitand(1431044098,-16777216)/16777215)|| 2 chr(bitand(1431044098, 16711680)/65535) "Lock", 3 to_char( bitand(1431044098, 65535) )"Mode" 4* from dual Lo M -- - UL 2 Sample output from v$lock for SID 14 (not at the exact same time as the lock shown above): ADDR KADDR Sid TYID1ID2 LMODEREQUEST CTIME BLOCK - -- -- -- -- -- -- -- 00040147E578 00040147E5A014 TM 130213 0 2 0 78 0 000400B1B430 000400B1B45014 UL 1073741851 0 6 0 33188 0 000400B16340 000400B1636014 UL 1073807990 0 6 0 33158 0 I can see that there are quite a few UL waits: SQL> run 1 SELECT ksqsttyp "Lock", 2 ksqstget "Gets", 3 ksqstwat "Waits" 4* FROM X$KSQST where KSQSTWAT > 0 Lo Gets Waits -- -- -- TX 170144 59 UL 7275 6011 Other info: SQL> SELECT * FROM v$sysstat WHERE cla 23 ss=4; STATISTIC# NAME CLASS VALUE -- -- -- 22 enqueue timeouts 4 6729 23 enqueue waits 4 6297 24 enqueue deadlocks 4 1 25 enqueue requests 4 852617 26 enqueue conversions 4 27889 27 enqueue releases 4 845696 SQL> run 1 SELECT * 2FROM v$system_event 3* WHERE event = 'enqueue' EVENTTOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- -- --- enqueue 6881 6520 732348 106.430461 >From a long query that joins v$process, v$session, v$session_event, >fnd_concurrent_processes, fnd_concurrent_queues_vl and looks for enqueue wait events: DB_PROCESS Sid MANAGER_OS P USER_CONCURRENT_QUEUE_NAME EVENT TWS TT TW AVGW -- - -- - -- --- -- -- -- -- 1175422 92 1098457A Workflow Manager (D&E) enqueue 1 0 1 1 1122160 13 1120706A PO Document Approval Manager enqueue 6 4 1341 223.5 1121613 25 1121812A INV Remote Procedure Manager enqueue 6 4 1424 237.33 1119743 24 1122331A INV
RE: Something that might be of use
|> -Original Message- |> > GUI's are evil. |> |> Sure, blinking LEDs are much more better. | |Especially when the admins are epileptic. Hopefully none of us are looking for the Andromeda strain... |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Stephen Lee | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
> -Original Message- > ( background sound of DBA frantically riffling through > stacks of papers on his desk) -- You've obviously not come up to date on the most reliable of storage methods: A refrigerator covered with magnets. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recipe for application design to run on RAC
Hey Tim... In case we haven't said it lately, we appreciate all the effort you put forth on the list... This is a fantastic thread... Thanks again Tim -Original Message- Sent: Wednesday, December 04, 2002 11:34 PM To: Multiple recipients of list ORACLE-L comments inline... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 8:53 AM > Whoa! Tim, thanks a lot for sharing this. Quite an > insight. > > So SELECTs are not a concern. > Well, not directly. They do not directly cause buffers to move around. But they can cause a PCM lock to be downgraded from "exclusive" to "shared", thus forcing the instance which had the lock in exclusive-mode to request that it be returned to "exclusive". Thus, while the block doesn't leave the Buffer Cache while it's lock is downgraded, it still induces some fiddling back and forth between the instances... > > INSERTs are a "come and see DBA" thing (physical design issue). > Yes. Prior to 9i, the mechanisms to use are FREELIST GROUPS. Very much eliminates inter-instance contention during INSERTs in OPS... Though I haven't had a chance to play with it yet, the bitmap-oriented 9i replacement for freelists and freelist groups, called "automated segment-space mgmt" or ASSM, is apparently still only half-baked, purportedly producing all kinds of unexpected results in space wastage and other things. So, in 9iRAC, you might still want to consider using FREELIST GROUPS over ASSM. Again, just my uninformed opinion based on hearsay... > > DELETEs are relatively infrequent and many get > translated into UPDATE (logical as opposed to physical delete). > Well, both DELETEs and UPDATEs have the same characteristics from a "cache-coherency" perspective, so it's six-of-one, half-dozen-the-other... > > Application "partitioning" as you clearly explained in > your email... Would it be closer to a logical or > physical design? > I've always tried to use the word "segregation" as opposed to "partitioning", though I slip up occasionally. The word "partitioning" makes people think about the Partitioning option, which is definitely not intended. There is no relationship between Oracle's Partitioning option and the type of "application segregation" I'm trying to describe. There are two ways to avoid the latency resulting from OPS "pinging" or RAC "cache-fusion": by happenstance or by planning. Well, actually there are three ways: use OPS/RAC on OpenVMS and neither OPS "pinging" nor RAC "cache-fusion" will result in latency. But let's assume that is not an option for you and consider just the other two ways... By "happenstance", I mean just hoping that relatively random activity from multiple instances against the same datafiles avoids two (or more) instances wanting the same block for insert, update, or delete. This is pretty rare, but I'm sure it can happen. After all, even a blind dog finds a bone occasionally... By "planning", essentially you want your application to somehow enforce that sessions on a database instance only UPDATE or DELETE rows that were INSERTed by that instance. That way, the block buffers are never "pinged" or "cache-fusion shipped" to another database instance. There may be some fiddling of the parallel cache-management (PCM) locks if other instances want to read those blocks, but that is less of a concern. So, however your application logic or business practices can ensure that blocks are UPDATEd or DELETEd by the instance from which they were INSERTed, that is what is necessary. Perhaps you can dedicate certain database sessions to specific groups of data (i.e. application module or groups of customers). That doesn't necessarily work all the time; take Oracle Apps as an example, where all application modules inevitably meet in the Application Object Library (AOL) and Foundation (FND) schemas. The surest way I've seen to "segregate" parts of an application is by making use of "data routing" capabilities in the middle-tier application-server or transaction-processing monitor layer. If the middle-tier is capable of data-routing, then you can identify each user transaction by the data values and route the transaction to a session connected to one database instance or the other. This is the surest way to accomplish perfect "segregation" of different database blocks to different instances, when the end-users can't do it. This is usually the case with interactive, OLTP environments. Of course, another way to route transactions is by forcing such rules of "application segregation" during INSERT, UPDATE, and DELETE by careful data-routing during batch processing. This is the way that it can be implemented for data warehouses... > > Seems like something that data modeler/architect > should be aware of. So in a sense all modeler needs to > worry about is UPDATEs as far as future physical > implementation for RAC is concerned? > Both should be aware, but th
Re: io error on alert file
Thank Jeff, your answer is much productive than oracle support. My question is if this is permission problem, then we should have the error everyday. This error bothered us for quite a long time. sometimes can be quiet a month and happened again. Thanks, joan Jeff Herrick wrote: > > If the W2K box was a converted NT box, I have heard of > authentication issues within services. The credentials > have to be re-created through the services control panel. > The Access-denied error is usually due to a service's > logon use not having the proper rights. If you are just > using LocalSystem then I'm not sure this would be an issue > butI would switch it temporarily to a user account and then > back to LocalSystem to regenerate the security identifier. > > Also...check the NTFS permissions on the D: drive for who > has write access. > > HTH > > Jeff Herrick > > On Thu, 5 Dec 2002, Joan Hsieh wrote: > > > Hi Listers, > > > > We had a portal database with some other schemas on the win2000 box. we > > got error so often and needs to recover that datafile. It hits different > > datafiles each time. We created the tar with oracle, they pointed to > > Microsoft problem. Our nt group insisted they didn't see any error log. > > db version is 8.1.7.2 . Since we had the problem so often, I migrated > > the whole database and portal to UNIX box. I am curious if someone can > > give me light why this io "access denied" comes from? > > > > Joan > > > > Completed: alter database open > > Wed Dec 04 09:12:12 2002 > > KCF: write/open error block=0x8ba7 online=1 > > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write > > to file > > O/S-Error: (OS 5) Access is denied.' > > Automatic datafile offline due to write error on > > file 14: D:\ORACLE\ORADATA\ORCL\SISDW.DBF > > KCF: write/open error block=0x8bd6 online=0 > > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write > > to file > > O/S-Error: (OS 5) Access is denied.' > > KCF: write/open error block=0x8ba6 online=0 > > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write > > to file > > O/S-Error: (OS 5) Access is denied.' > > KCF: write/open error block=0x8d5c online=0 > > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Joan Hsieh > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeff Herrick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Something that might be of use
> -Original Message- > I saw an article last night, apparently Sun is planning to > make Gnome its > gui of choice on solaris. But REAL Unix guys will still use fvwm2. And don't confuse GUI with a window manager; i.e. merely a desktop where one does work from a collection of xterm command line interfaces. (Pick up mouse: "Computer Oh Computer? A keyboard? How quaint!") -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Archived logs backup
if it's not just running ... ... bur i agree it's MOST portable yr way kr mr >>> [EMAIL PROTECTED] 12/05/02 15:48 PM >>> more portable to query V$ARCHIVED_LOG after runninig ARCHIVE LOG ALL instead of using OS utilities... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 5:18 AM > must be currently reserved/open for writing. try lsof to find out yr file to be excluded. > kr mr > > >>> [EMAIL PROTECTED] 12/05/02 12:32 PM >>> > Hi! > > I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... > > Within script how do I skip archived log file that is being written by oracle? > > Thanks, > Vladimir Barac > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Markus Reger > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9iR2 on Red Hat 8.0/Kernel settings
read the installation guide for linux - and find hints there. kr >>> [EMAIL PROTECTED] 12/05/02 14:44 PM >>> Hi, I'm to install Oracle9i R2 on RH linux soon as well. I have read the install guide about the kernel settings but they seem to only mention the correct settings for a single instance on LINUX. I have not had the privilege before to work on systems I had to set the kernel parameters (not needed on AIX) so I could use a little help on this. RH linux 8.0 Oracle 9i R2 2 instances on one machine (about 25 concurrent users per db) buffer cache approx. 300MB (based on the old databases that is migrating plus some extra for upgrade) Shared pool 25-35Mb (based on the old databases that is migrating plus some extra for upgrade) What would my kernel settings be looking like, or could anybody point me to ocumentation that explains this??? TIA Jack -Original Message- Sent: donderdag 5 december 2002 10:44 To: Multiple recipients of list ORACLE-L installed O92010 on rh 8.0. went fine so far until I tried to connect via "oemapp console" - whatever connectdescripter I chose it resulted in the error "connection string not properly terminated". same connect descriptors in the CLI worked fine - made them available in the "oemapp console" and got the error message. didn't investigate any further into this - experienced it twice on two different machines. changed back to rh7.2 and things were fine again. don't forget to make the kernel settings for memory - otherwise the database installation will fail - maybe you have to correct the entry in the ORACLE_HOME/ctx/lib/env_ctx.mk file for INSO_LINK and add $(LINKLDLIBS) at the end. installing the patch to make 9.2.0.2.0 out of it may require some tweaking. or if this is a new installation just drop the typical database and create a new one after applying the patch to the other files. be careful with oid - experienced you cannot install it after applying the patch. in general the same hints and points as on SunOS apply on RH 7.2/7.3/8.0. have a lot of fun thats all I can contribute. kr >>> [EMAIL PROTECTED] 12/04/02 23:52 PM >>> Thanks Sean. I installed 9iR2 on both my laptop and a desktop, both running RH 8.0. Pretty straightforward, except for the usual failure in linking intermedia. I would have thought they would fix that by now. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Oracle 9iR2 on Red Hat 8.0 > If you've installed Oracle 9i on RH 8.0, please let me know. > > Also, please let me know of any difficulties and workarounds > you may have encountered. > > Just put a new 40Gig HD in my laptop, and wondering if I > can install RH 8.0, or should use 7.2. Jared: I put together some notes when I installed 9.2.0 on RH7.3. I think that RH8 is probably similar. http://iheavy.com/~shull/files/ora9i_inst_notes.txt HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORAC
Enqueue Waits in Oracle Financials
I noticed a lot of enqueue wait events in our 11i database. I ran some queries and was able to determine the process that is incurring these waits. I dutifully did a set event 10046 and examined the trace file. I've also queried v$lock. I've figured out that this is a UL (user defined) wait. Now I'm stuck. I haven't figured out exactly what we are waiting for. Although by monitoring the current SQL statement for the offending process, I see that it does a SELECT FOR UPDATE in the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS tables. This creates a TM lock, which I see, but I don't think it explains the UL lock. I've seen examples on how to interpret p1 for an enqueue lock, but not p2. I would appreciate a little guidance. I believe that the offending process is the Internal manager, but I would like to understand a little more about what is occurring. Is this a typical problem in 11i? I guess the ICM may issue user defined locks, then just waits for a certain! amount of time. I would guess that all 11i databases have a high number of enqueue waits if this is the case. I am running 11.5.6 against 8.1.7 on Tru64. Thank you, Jay Sample output from the trace: WAIT #114: nam='enqueue' ela= 102 p1=1431044098 p2=1073807913 p3=0 WAIT #114: nam='enqueue' ela= 103 p1=1431044098 p2=1073807914 p3=0 WAIT #114: nam='enqueue' ela= 102 p1=1431044098 p2=1073807915 p3=0 So if I check out p1 I see a UL lock mode 2: SQL> run 1 SELECT chr(bitand(1431044098,-16777216)/16777215)|| 2 chr(bitand(1431044098, 16711680)/65535) "Lock", 3 to_char( bitand(1431044098, 65535) )"Mode" 4* from dual Lo M -- - UL 2 Sample output from v$lock for SID 14 (not at the exact same time as the lock shown above): ADDR KADDR Sid TYID1ID2 LMODEREQUEST CTIME BLOCK - -- -- -- -- -- -- -- 00040147E578 00040147E5A014 TM 130213 0 2 0 78 0 000400B1B430 000400B1B45014 UL 1073741851 0 6 0 33188 0 000400B16340 000400B1636014 UL 1073807990 0 6 0 33158 0 I can see that there are quite a few UL waits: SQL> run 1 SELECT ksqsttyp "Lock", 2 ksqstget "Gets", 3 ksqstwat "Waits" 4* FROM X$KSQST where KSQSTWAT > 0 Lo Gets Waits -- -- -- TX 170144 59 UL 7275 6011 Other info: SQL> SELECT * FROM v$sysstat WHERE cla 23 ss=4; STATISTIC# NAME CLASS VALUE -- -- -- 22 enqueue timeouts 4 6729 23 enqueue waits 4 6297 24 enqueue deadlocks 4 1 25 enqueue requests 4 852617 26 enqueue conversions 4 27889 27 enqueue releases 4 845696 SQL> run 1 SELECT * 2FROM v$system_event 3* WHERE event = 'enqueue' EVENTTOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- -- --- enqueue 6881 6520 732348 106.430461 >From a long query that joins v$process, v$session, v$session_event, >fnd_concurrent_processes, fnd_concurrent_queues_vl and looks for enqueue wait events: DB_PROCESS Sid MANAGER_OS P USER_CONCURRENT_QUEUE_NAME EVENT TWS TT TW AVGW -- - -- - -- --- -- -- -- -- 1175422 92 1098457A Workflow Manager (D&E) enqueue 1 0 1 1 1122160 13 1120706A PO Document Approval Manager enqueue 6 4 1341 223.5 1121613 25 1121812A INV Remote Procedure Manager enqueue 6 4 1424 237.33 1119743 24 1122331A INV Remote Procedure Manager enqueue 5 4 1523 304.6 1116804 14 1084357A Internal Manager enqueue 6307 6289 644107 102.125733 **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information
RE: Are There any way of calling NT OS Commands like print, del e
What commands aren't working for you. Some of the commands are not external executables but rather part of cmd, i.e. internal commands. So you need to invoke cmd with the command. HTH Richard Ji -Original Message-From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 10:10 AMTo: Multiple recipients of list ORACLE-LSubject: Are There any way of calling NT OS Commands like print, del etc. Hi Gurus I am looking for easy of calling OS commands like print, del, etc. from PL/SQL on a NT4 system running Oracle 8.1.7. I tried the Java approach from oracle web site, it works for few commands and not all. Any insight, direction and help to achieve is very much appreciated. Thanks in advance Regards Shiva Baswannappa Senior Developer Digital Consulting and Software Services Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
RE: Something that might be of use
I found the URL re. Gnome and Solaris 10. http://www.gnomedesktop.org/article.php?sid=792 Regards, Pat. -Original Message- Sent: Thursday, December 05, 2002 10:44 AM To: Multiple recipients of list ORACLE-L > -Original Message- > it has GUI interface and a lot finer control over the GUI's are evil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to script or document jobs defined to the NT/MS2000 T
Jt.exe Download here: http://www.jsiinc.com/subf/tip2600/rh2621.htm Or here: ftp://ftp.microsoft.com/reskit/. See the "C:\>jt /se p" example near the bottom of the page. Also looks like you might be able to put all your tasks in a command file and execute to recover any lost jobs. (I haven't tried this yet...) HTH Ed -Original Message- Sent: Thursday, December 05, 2002 9:24 AM To: Multiple recipients of list ORACLE-L We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Something that might be of use
> -Original Message- > > GUI's are evil. > > Sure, blinking LEDs are much more better. Especially when the admins are epileptic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Are There any way of calling NT OS Commands like print, del etc.
To issue OS commands from PL/SQL for NT, there is no other option. Now if your PL/SQL was an anonymous block then you could issue OS commands via SQL Plus. Otherwise , you will have to use C or Java. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Thanks everyone for pointing out the value of the original test certificate. I'm sitting here is stunned bafflement at how inconsistent this is with the idea of "high tech". ( background sound of DBA frantically riffling through stacks of papers on his desk) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 05, 2002 6:34 AM To: Multiple recipients of list ORACLE-L Dennis, When i was taking the initial OCP exams I received a score sheet from the testing orginization the day I passed each test. The only time I received any thing related to Oracle was after I passed all tests and then I received a certification suitable for framing. I also received an email that directed me to the Oracle site where the "Certified Professional" logo image is stored and a password to download the image (suitable for business cards and letterheads). Ron >>> [EMAIL PROTECTED] 12/04/02 04:13PM >>> Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > My instructor in a recent Oracle Education class said that there were a > couple of smart alecs that caused quite a stir within Oracle. After > receiving their OCP, they couldn't log into a database, and claimed it was > because they had never actually used Oracle. The instructor indicated that > the new requirement (9i I believe) would require you to take at least one > class. I asked "do you mean everyone that takes a class from you will be > logging on". He just grinned. > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, December 04, 2002 11:25 AM > To: Multiple recipients of list ORACLE-L > > > Hey people! > > A friend of mine was just asking me about getting Oracle certified (I > completed the Oracle 8i cerfication exams last year), > he told me that to his knowledge Oracle requires that you've done Oracle > courses before you can be certified now. > I knew nothing about this, but can't believe Oracle would so blatantly make > you take their over-priced courses. > > But maybe I'm just naive. > > Cheers, > Kieran Murray > CardBASE Technologies Limited® > BIM House > Crofton Road > Dun Laoghaire > Co Dublin > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kieran Murray > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network
RE: Are There any way of calling NT OS Commands like print, del e
Shiva, Attached is an email from Ankur Shah from another posting - have not tried it myself but this may help. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] "Enabling Competitive Advantage for Barclays in IT and Business Processing" -Original Message- From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 15:10 To: Multiple recipients of list ORACLE-L Subject: Are There any way of calling NT OS Commands like print, del etc. This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi Gurus I am looking for easy of calling OS commands like print, del, etc. from PL/SQL on a NT4 system running Oracle 8.1.7. I tried the Java approach from oracle web site, it works for few commands and not all. Any insight, direction and help to achieve is very much appreciated. Thanks in advance Regards Shiva Baswannappa Senior Developer Digital Consulting and Software Services Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you. Sent: 30 September 2002 13:46 To: LazyDBA.com Discussion This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Many tasks have been automated using shell scripting languages. Frequently, these shell scripts need to be called from an Oracle stored procedure, but no direct interface to call shell scripts is provided. Oracle does, however, provide a method for calling C and Java programs via external procedures. Since many shell programmers have never programmed in C or Java, converting shell scripts or writing new tasks in either of these languages is difficult and time consuming. This solution provides a C routine that will make OS calls, and these calls can be commands, shell scripts, or other application programs. Using this method, no C programming experience is required, but does allow existing and new tasks to be written as shell scripts. This article does not provide information to setup the database or environment for external procedures. Refer to How to Configure a UNIX Oracle Server to Use External Procedures for information on setting up the Oracle Server machine. The external procedure is written in C and compiled with the Oracle makefile, and hence, an Oracle supported compiler for the specific UNIX platform is required. See Certified Compilers >From the Oracle server machine: 1. Create a file for the external procedure code: shell.c === #include #include #include void sh(char *); void sh( char *cmd ) { int num; num = system(cmd); } 2. Compile and link the C code into a shared library: make -f $ORACLE_HOME/rdbms/demo/demo_rdbms.mk extproc_nocallback \ SHARED_LIBNAME=shell.so OBJS=shell.o Log into SQL*Plus to perform the remaining steps. 3. Define the shared library in Oracle: CREATE LIBRARY shell_lib IS '/shell.so'; / 4. Create the PL/SQL wrapper procedure: CREATE OR REPLACE PROCEDURE shell (cmd IN CHAR) AS EXTERNAL NAME "sh" LIBRARY shell_lib LANGUAGE C PARAMETERS ( cmd STRING); / 5. Call a shell script: SQL> exec shell('sh myscript.sh'); PL/SQL procedure successfully completed. === HTHU Ankur Shah Oracle DBA DHR-GA - Original Message - To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 3:08 AM But i want to call the shell script or the file from a stored procedure. -Original Message- Sent: Monday, September 30, 2002 12:33 PM To: Dibyendu Kole-VP there are cron jobs in unix, just like schedulers e.g. dbms_jobs in oracle. hope this would solve your problem. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html
RE: Something that might be of use
I saw an article last night, apparently Sun is planning to make Gnome its gui of choice on solaris. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 05, 2002 10:44 AM To: Multiple recipients of list ORACLE-L > -Original Message- > it has GUI interface and a lot finer control over the GUI's are evil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Saving MSTask Scheduler Commands
I just tried this and it seems to work. It looks like you can copy/paste the task scheduler items to a backup folder. When they're pasted they show up as 1K binary files named 'whatever.job'. I looked at the file with a binary editor and it has the source of the script along with other schtuff =8-) To restore just select them from the backup directory and paste them into the scheduled tasks folder. NOTE ... don't try to right-click the task folder...there is no paste option therebut the Edit/Paste menu option will work. Standard warnings apply re: recreation of the user security identifier (SID) if you're moving to a new server. As a minimum I would think that you would have to open each task in the tool and re-authenticate. HTH Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Something that might be of use
On Thursday 05 December 2002 15:43, you wrote: > > -Original Message- > > it has GUI interface and a lot finer control over the > > > > GUI's are evil. Sure, blinking LEDs are much more better. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to script or document jobs defined to the NT/MS2000 T
Ron, The only way I have found is to manually copy (through the GUI) the jobs to another location. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] "Enabling Competitive Advantage for Barclays in IT and Business Processing" -Original Message- Sent: 05 December 2002 14:24 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-8103 Error
Curioser and Curioser If I run the following query select timestamp from where timestamp < than sysdate. The last rows returned look like IMESTAMP 28-NOV-2002:22:36:39 28-NOV-2002:22:36:39 28-NOV-2002:22:36:42 28-NOV-2002:22:36:42 28-NOV-2002:22:36:42 28-NOV-2002:22:36:49 28-NOV-2002:22:36:49 28-NOV-2002:22:36:49 28-NOV-2002:22:36:49 28-NOV-2002:22:36:52 28-NOV-2002:22:36:52 28-NOV-2002:22:36:52 28-NOV-2002:22:35:00 28-NOV-2002:22:35:50 28-NOV-2002:22:35:00 28-NOV-2002:22:35:59 28-NOV-2002:22:35:00 28-NOV-2002:22:35:59 28-NOV-2002:22:35:00 28-NOV-2002:22:35:59 28-NOV-2002:22:35:00 28-NOV-2002:22:35:59 28-NOV-2002:22:35:00 ERROR: ORA-08103: object no longer exists 104880 rows selected As if some type of move operation were in progress. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 05, 2002 2:14 AM To: Multiple recipients of list ORACLE-L I have a user who was in essence moving partitions from one table to another. The partitions are date based, one per day She was moving November's data. All went well, until the NOV2802 partition. At that point she received an 8103 error 08103, 0, "object no longer exists" // *Cause: the object has been deleted by another user since the operation // began // *Action: On a partition she had not altred. Indeed all the remaining partitions except "FIRST" are reporting this error. Has anybody else run into this. A tar has been opened. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Vitals: Average Row Length = 1895 Block Size = 4096 pct_free = 10% Threshold to put block off freelist = 3686 pct_used = 75% Threshold to put block on freelist = 3072 Average free space = 3895 Working with averages, there could be at most 2 rows per block. The Average free space is also very close to the block size, which indicates to me that the blocks on the free list are probably empty. Will a transaction insert a row into a block when it knows that the insert will push the block above the pct_free threshold? I can see logic on both sides. Don't insert because an update is more likely to cause row migration. Do insert because the space is wasted otherwise. After deleting 2 million rows, the # of blocks on the freelist is slightly over 2 million. Is this a coincidence? I'll take a guess and say that the insert processes are probably trying to acquire 1 block per 2 rows. Add in the other processes doing inserts, each one needs its own block if it is reusing it. I'm wondering if the insert transaction started walking the freelist, could not find an open block (because they were being used by other transactions) within a certain period (# of blocks checked or timeout) and decided to simply allocate another extent in order to enable the transaction to complete. In reviewing my notes/docs from the Internals Seminar (8i), there is a threshold (_release_insert_threshold) that will cause a new extent to be allocated even when there are blocks on the master free list. This seems a very likely scenario, given the large row size in comparison to the block size. Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB corruption question
-Original Message- ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile Will this corrupt the database? Will it harm/corrupt the original instance? What happens if someone tries to recover it at this point? Does it make a difference whether its a RAW or cooked file system? --- I don't think it will corrupt anything, but you won't be able to open the database. Apparently somebody smoked at least one control file and restored it from a backup. So now the control file(s) is/are behind the data file. If only one control file was smoked, and you have another that is up to date, replace the smoked one with a copy of the good one. If you can't do that (i.e. ALL your control files are old) AND if the database was shut down clean (why do I have the feeling it wasn't?), then move what control file you have off somewhere else; and see if you can recreate a new control file; then recover the database using backup control file. This will require an open resetlogs (You DO have a good backup of what you currently have right?). If the database was not shut down clean and you only have old control files, then I think you have no choice but to restore the entire database back to your last backup. If you are in this situation, you still might try recreating the contol files. If the database had no activity prior to the disruption, you might get lucky and have all your headers up to date even without a clean shutdown. As long as you are planning a complete restore, I don't think it would hurt to give it a try. It's time to get out that Oracle backup and restore manual. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
re RAC -- patches ---- was RE: Recipe for application design
Raj, Could you list the patches you applied on top of 9.2.0.2 I've upgraded my test RAC environment from 9.2.0.1 to 9.2.0.2. Hemant At 05:48 AM 05-12-02 -0800, you wrote: Boris, the example I gave you is 9012 RAC and I have 5 other production systems that are 9202 RAC. BTW remember if you have cluster_database is true, then no matter how many instances, you will see GC traffic and boy those numbers are crooked .. it is a generic problem hopefully there will be patch for it to fix the GC timing.. I think that advise should have been prefixed with something like ... "Following statement is issued so that in case your application fails to scale contrary to our well publicized claim that RAC is extensible and scalable, we can always blame on your not-so-well-thought-rac-incompatible design. This way we will be safe and no one in media can blame us." I am pretty sure it is hidden somewhere ... BTW 9202 ... make sure you get all the patches ... this upgrade is a painful story (at-least for us). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recipe for application design to run on RAC On a more serious note the following guidelines look interesting: http://download-west.oracle.com/docs/cd/A97630_01/rac.920/a96600/migrate.htm#1013313 "Migrate to RAC ... unless your application was specifically designed to not use cluster database processing". I wonder why would somebody do that? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ECM / BCV / hot backup
Thanks a lot! These advices will give me touch of seriousness at client's site... Regards, Vladimir Barac - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 14:48 Subject: Re: ECM / BCV / hot backup Do backup controlfile before step #1 and make sure that it is swept up by Omniback during step #6. There is no need for step #2. Don't forget that step #6 also has to back up archivelogs as well as datafiles and the controlfile backup. --- Better yet, do use RMAN instead. The RMAN user's guide describes exactly this scenario... - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 5:03 AM Subject: ECM / BCV / hot backup Good morning/afternoon/evening to everyone... I'm about to "configure" oracle backup policy using ECM storgae and HP OmniBack. My idea is as follows 1. put all tablespaces into backup mode (db is in arch. mode), 2. sleep 3. do the split 4. take out tablespaces of backup mode, 5. alter system switch logfile, 6. let the Omni Back do it's job. Anu do's and don't's regarding EMC/Oracle combination?
Re: ECM / BCV / hot backup
What do you mean by make sure that it is swept up by Omniback during step #6. ? - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 14:48 Subject: Re: ECM / BCV / hot backup Do backup controlfile before step #1 and make sure that it is swept up by Omniback during step #6. There is no need for step #2. Don't forget that step #6 also has to back up archivelogs as well as datafiles and the controlfile backup. --- Better yet, do use RMAN instead. The RMAN user's guide describes exactly this scenario... - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 5:03 AM Subject: ECM / BCV / hot backup Good morning/afternoon/evening to everyone... I'm about to "configure" oracle backup policy using ECM storgae and HP OmniBack. My idea is as follows 1. put all tablespaces into backup mode (db is in arch. mode), 2. sleep 3. do the split 4. take out tablespaces of backup mode, 5. alter system switch logfile, 6. let the Omni Back do it's job. Anu do's and don't's regarding EMC/Oracle combination?
RE: Archived logs backup
-Original Message- I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... Within script how do I skip archived log file that is being written by oracle? --- Here is my crontab entry (paste it back together). The "70" means start a backup if the archive directory hits 70% full. This does NOT run around the time when the normal backup is running. 0,30 1-18 * * * /oracle/app/oracle/admin/dbascripts/rman/check_arch_dir.ksh 70 >> /oracle/app/oracle/admin/dbascripts/rman/arch_debug 2>&1 Here is my script (which calls the backup script) - Snip -- #!/bin/ksh PERCENT1=`/usr/bin/df -k /z01 | /usr/bin/nawk 'NR == 2 {print substr($5,1,match($5,"%")-1)}'` PERCENT2=`/usr/bin/df -k /z02 | /usr/bin/nawk 'NR == 2 {print substr($5,1,match($5,"%")-1)}'` PERCENT3=`/usr/bin/df -k /z03 | /usr/bin/nawk 'NR == 2 {print substr($5,1,match($5,"%")-1)}'` PERCENT4=`/usr/bin/df -k /z04 | /usr/bin/nawk 'NR == 2 {print substr($5,1,match($5,"%")-1)}'` PERCENT1=`echo "$PERCENT1" | /usr/bin/sed 's/[^0-9]*//g'` PERCENT2=`echo "$PERCENT2" | /usr/bin/sed 's/[^0-9]*//g'` PERCENT3=`echo "$PERCENT3" | /usr/bin/sed 's/[^0-9]*//g'` PERCENT4=`echo "$PERCENT4" | /usr/bin/sed 's/[^0-9]*//g'` if [ -z "$PERCENT1" ]; then PERCENT1=0; fi if [ -z "$PERCENT2" ]; then PERCENT2=0; fi if [ -z "$PERCENT3" ]; then PERCENT3=0; fi if [ -z "$PERCENT4" ]; then PERCENT4=0; fi if [ $PERCENT1 -gt $PERCENT2 ]; then PERCENT=$PERCENT1 else PERCENT=$PERCENT2 fi if [ $PERCENT3 -gt $PERCENT ]; then PERCENT=$PERCENT3 fi if [ $PERCENT4 -gt $PERCENT ]; then PERCENT=$PERCENT4 fi THRESHOLD="$1" if [ -z "$THRESHOLD" ]; then THRESHOLD=50 fi if [ $PERCENT -gt $THRESHOLD ]; then /oracle/app/oracle/admin/dbascripts/rman/backup.ksh ARCH ALL >> /oracle/app/oracle/admin/dbascripts/rman/debug 2>&1 fi exit 0 -- Snip -- The backup.ksh script is a 1559 line big boy I wrote to automate a lot of stuff and do a lot checking and verifying. I don't think you want to see it. One thing that might be of interest is a C (not PERL!) frontend I wrote to make SUID oracle so a non-oracle operator can start a backup by hand if needed without us opening the permissions on any of our security-sensitive areas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: io error on alert file
If the W2K box was a converted NT box, I have heard of authentication issues within services. The credentials have to be re-created through the services control panel. The Access-denied error is usually due to a service's logon use not having the proper rights. If you are just using LocalSystem then I'm not sure this would be an issue butI would switch it temporarily to a user account and then back to LocalSystem to regenerate the security identifier. Also...check the NTFS permissions on the D: drive for who has write access. HTH Jeff Herrick On Thu, 5 Dec 2002, Joan Hsieh wrote: > Hi Listers, > > We had a portal database with some other schemas on the win2000 box. we > got error so often and needs to recover that datafile. It hits different > datafiles each time. We created the tar with oracle, they pointed to > Microsoft problem. Our nt group insisted they didn't see any error log. > db version is 8.1.7.2 . Since we had the problem so often, I migrated > the whole database and portal to UNIX box. I am curious if someone can > give me light why this io "access denied" comes from? > > Joan > > Completed: alter database open > Wed Dec 04 09:12:12 2002 > KCF: write/open error block=0x8ba7 online=1 > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write > to file > O/S-Error: (OS 5) Access is denied.' > Automatic datafile offline due to write error on > file 14: D:\ORACLE\ORADATA\ORCL\SISDW.DBF > KCF: write/open error block=0x8bd6 online=0 > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write > to file > O/S-Error: (OS 5) Access is denied.' > KCF: write/open error block=0x8ba6 online=0 > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write > to file > O/S-Error: (OS 5) Access is denied.' > KCF: write/open error block=0x8d5c online=0 > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joan Hsieh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Archived logs backup
-Original Message- Within script how do I skip archived log file that is being written by oracle? - I took another look at this and figured out what you were really asking. The commands: "ls -1rt" or "ls -1t" will list the files in the directory and sort according to time. Note that the "1" is a one. This will allow you to see the most recent files. If you would like to keep the two most recent then something like: #!/bin/ksh COUNT=0 for i in `ls -1t *.dbf`; do COUNT=$(( $COUNT + 1 )) if [ $COUNT -gt 2 ]; then SEND $i TO TAPE if [ $? -ne 0 ]; then print "SOMETHING BROKE" else rm $i (or maybe safer to move it to a pre-delete filesystem, then delete it later) fi fi done -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Are There any way of calling NT OS Commands like print, del etc.
Hi Gurus I am looking for easy of calling OS commands like print, del, etc. from PL/SQL on a NT4 system running Oracle 8.1.7. I tried the Java approach from oracle web site, it works for few commands and not all. Any insight, direction and help to achieve is very much appreciated. Thanks in advance Regards Shiva Baswannappa Senior Developer Digital Consulting and Software Services Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
RE: ORA-1653: unable to extend table - Why?
Its not Miller or Moans or Oracle or OCP... :) Actually, it is the footer in the mail that tells you how to unsubscribe from the list. I receive the list mail on my business e-mail address. The spam detection mechanism considers such declaration a possible sign of spam. Our 'Spam Police' were kind enough to let the direct list mail to my e-mail address come through (by checking a few other things in the message header), but if someone else forwards/ccs to me any of the list mail with that footer, it won't go through. - Kirti -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 2:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-1653: unable to extend table - Why?Or maybe Miller. It is, after all, the name of a well-known alcoholic beverage. Good thing my first name is not spelled Moans. I would probably not get many emails through spam filters.MogensMiller, Jay wrote: Kirti, Thanks for suggesting the Note, I'm reading it now. I tried replying to you directly but my thank you was blocked by your company's spam filter. I'm really curious to know what key word flagged it as spam. Oracle? Jay
RE: Oracle 9.0.1 and 9.2
Hi Kevin, In the 9i R2 Migration Guide (p 321), Step 10 of the upgrade process specifies that you should open the database using "STARTUP MIGRATE". This option sets the status of the database to 'OPEN MIGRATE' in V$INSTANCE. That makes it a migration. Hence the discussion we had a few months ago along the lines of "Yes, 9i Release 1 was really only 8.2 and this is the real 9i" Did you use the Database Upgrade Assistant? That may explain why you didn't see the "migrate" step. I think my phrasing implied that migrating to release 2 was far harder than upgrading to a new version. Thanks to improvements in the process this is no longer the case. Regards, Mike Hately -Original Message- Sent: 05 December 2002 12:34 To: Multiple recipients of list ORACLE-L > The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Can you explain this? I've upgraded multiple databases (Solaris) from 9.0.1 to 9.2.0 by doing a simple upgrade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Something that might be of use
> -Original Message- > it has GUI interface and a lot finer control over the GUI's are evil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Toasters
Patrice, You shouldn't be shocked to see these people being proud of what they did. They still got rich from it and still are rich because of it. Indicted doesnt' mean stripped of ill-gotten gain, it is just a price to be paid for fleecing the underclasses to get richer. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 12:24 PM > I saw a video clip on our National News show here in Canada last night ("The > National"), they talked about corruption at Enron, etc. > > Apparently the accounting consulting firms are still lobbying to let them > continue negotiating consulting contracts with firms they are supposed to be > auditing at arms' length. > > The news item included a video from Enron, which emphasized that integrity > was their prime motivator, and you see the top 3 executives in the video who > have since been indicted. I am probably naive, it was surprising to see > people act normally (even proudly) as if nothing untoward was taking place. > > If you are interested and can view video clips, you can go to > http://www.cbc.ca/news/ and look in the right-hand column, under > "Multimedia" to see the clips. > > Regards, > Patrice Boivin (Canada) > > -Original Message- > Sent: Wednesday, December 04, 2002 11:54 AM > To: Multiple recipients of list ORACLE-L > > > And > > And... if Enron had made toasters... The toast would have come out crooked, > and later 'magically' shred itself into croutons! > > :> Shiva > > -Original Message- > Sent: Wednesday, December 04, 2002 3:39 AM > To: Multiple recipients of list ORACLE-L > > > As a bit of light relief > John > > > > Carry on til the end for the SAP toaster > If IBM made toasters ... They would want one big toaster where people bring > bread to be submitted for overnight toasting. IBM would claim a worldwide > market for five, maybe six toasters. > If Xerox made toasters ... You could toast one-sided or double-sided. > Successive slices would get lighter and lighter. The toaster would jam your > bread for you. > If Radio Shack made toasters ... The staff would sell you a toaster, but not > know anything about it. Or you could buy all the parts to build your own > toaster. > If Oracle made toasters ... They'd claim their toaster was compatible with > all brands and styles of bread, but when you got it home you'd discover the > Bagel Engine was still in development, the Croissant Extension was three > years away, and that indeed the whole appliance was just blowing smoke. > If Sun made toasters ... The toast would burn often, but you could get a > really good cuppa Java. > Does DEC still make toasters?... They made good toasters in the '80s, didn't > they? > If Hewlett-Packard made toasters ... They would market the Reverse Toaster, > which takes in toast and gives you regular bread. > If Tandem made toasters ... You could make toast 24 hours a day, and if a > piece got burned the toaster would automatically toast you a new one. > If Thinking Machines made toasters ... You would be able to toast 64,000 > pieces of bread at the same time. > If Cray made toasters ... They would cost $16 million but would be faster > than any other single-slice toaster in the world. > If the NSA made toasters ... Your toaster would have a secret trap door that > only the NSA could access in case they needed to get at your toast for > reasons of national security. > If Sony made toasters ... The ToastMan, which would be barely larger than > the single piece of bread it is meant to toast, can be conveniently attached > to your belt. > If Timex made toasters ... They would be cheap and small quartz-crystal > wrist toasters that take a licking and keep on toasting. > If Fisher Price made toasters ... "Baby's First Toaster" would have a > hand-crank that you turn to toast the bread that pops up like a > Jack-in-the-box. > And, of course: If Microsoft made toasters ... Every time you bought a loaf > of bread, you would have to buy a toaster. You wouldn't have to take the > toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh > 15000 pounds (hence requiring a reinforced steel countertop), draw enough > electricity to power a small city, take up 95% of the space in your kitchen, > would claim to be the first toaster that lets you control how light or dark > you want your toast to be, and would secretly interrogate your other > appliances to find out who made them. Everyone would hate Microsoft > toasters, but nonetheless would buy them since most of the good bread only > works with their toasters. > If Apple made toasters ... It would do everything the Microsoft toaster > does, but 5 years earlier. > If SAP made toasters, the manual to run the toaster would be approximately > 10,000 pages long. The toaster would come with 2,500 switches which would > all have to be set in an exact pattern and in a precise sequence in order to > toast specific kinds o
io error on alert file
Hi Listers, We had a portal database with some other schemas on the win2000 box. we got error so often and needs to recover that datafile. It hits different datafiles each time. We created the tar with oracle, they pointed to Microsoft problem. Our nt group insisted they didn't see any error log. db version is 8.1.7.2 . Since we had the problem so often, I migrated the whole database and portal to UNIX box. I am curious if someone can give me light why this io "access denied" comes from? Joan Completed: alter database open Wed Dec 04 09:12:12 2002 KCF: write/open error block=0x8ba7 online=1 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' Automatic datafile offline due to write error on file 14: D:\ORACLE\ORADATA\ORCL\SISDW.DBF KCF: write/open error block=0x8bd6 online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' KCF: write/open error block=0x8ba6 online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' KCF: write/open error block=0x8d5c online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any way to script or document jobs defined to the NT/MS2000 Task
We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-1653: unable to extend table - Why?
Well-known, perhapsnot particularly tasty, though HmmmThere isn't anyone on this list named Stella, is there? ;-) (As in Artois...) ;-) -Mark On Thu, 2002-12-05 at 03:39, Mogens Nørgaard wrote: > Or maybe Miller. It is, after all, the name of a well-known alcoholic > beverage. Good thing my first name is not spelled Moans. I would > probably not get many emails through spam filters. > > Mogens > > Miller, Jay wrote: > > >Kirti, > > > >Thanks for suggesting the Note, I'm reading it now. I tried replying to you > >directly but my thank you was blocked by your company's spam filter. I'm > >really curious to know what key word flagged it as spam. Oracle? > > > > > >Jay > > > > > > > >-Original Message- > >Sent: Wednesday, December 04, 2002 12:49 PM > >To: Multiple recipients of list ORACLE-L > > > > > >freelist groups is 1 > > > >-Original Message- > >Sent: Tuesday, December 03, 2002 9:59 PM > >To: Multiple recipients of list ORACLE-L > > > > > >What is the FREELIST GROUPS for the table? > > > >Waleed > > > >-Original Message- > >Sent: Tuesday, December 03, 2002 3:50 PM > >To: Multiple recipients of list ORACLE-L > > > > > >Just for grins, here's the level of support I'm getting on my Oracle TAR: > > > >-- > >You had stated earlier: > >1/ After reanalyzing the table I saw the following stats in DBA_TABLES: > >num_freelist_blocks: 2266966 > >avg_space_freelist_blocks: 3895 > >Unless I'm misreading this I should have had over 8Gig available for > >inserts. > > > >2/ I've had to add another data file and it has already grown to 600 Meg. > > > >If the table is only 600 mb, then there is no way that it can have 8 gb of > >free space. Since you have a lot of blocks with some free space, you may > >want to export and import the table back to re-org the table... > >-- > > > >Someone should inform these people that a table can consist of more than one > >datafile... > > > > > >-Original Message- > >Sent: Tuesday, December 03, 2002 11:54 AM > >To: Multiple recipients of list ORACLE-L > > > > > >I had one thought. > >The Freelist parameter for this table is only set to 1. Is it possible that > >if it gets tied up with contention for the freelist that it grabs a new > >extent? > > > >I see that some of these blocks are being written to, the > >num_freelist_blocks is now down to 2095705. But the new data file has grown > >to 600 Meg. > > > >I've opened a TAR to see what Oracle says but I'm not encouraged by the > >first question they sent me (which was asking to query dba_free_space). > > > >Jay > > > >-Original Message- > >Sent: Monday, December 02, 2002 6:14 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >One thing I haven't seen mentioned yet is what degree of parallelism is > >defined for the table? > >What is the next extent size set to? > >If the table is paralleled, EACH parallel worker will grab a next extent > >sized segment. (Been bit by > >this a few times...) > >How many indexes and are they in the same tablespace? > > > >Ron Thomas > >Hypercom, Inc > >[EMAIL PROTECTED] > >Each new user of a new system uncovers a new class of bugs. -- Kernighan > > > > > > > > > > JayMiller@TDWater > > > > house.comTo: > >[EMAIL PROTECTED] > > > > Sent by: cc: > > > > [EMAIL PROTECTED] Subject: RE: ORA-1653: > >unable to extend table - Why? > > > > > > > > > > > > 12/02/2002 02:04 > > > > PM > > > > Please respond to > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > >Yep, I agree that coalescing is irrelevant in my current situation. In any > >event there was no free space until I added the additional datafile but > >there was the 8gig of space on the freelists. > > > >Jay > > > >-Original Message- > >Sent: Friday, November 29, 2002 8:54 PM > >To: Multiple recipients of list ORACLE-L > > > > > >Richard, > > > >if pctincrease is zero, and there are a large number of contiguous > >smaller extents, SMON will not automatically coalesce the tablespace. > >However, whether or not SMON does an automatic coalesce, if you need an > >extent that is larger than any of the small ones, Oracle will coalesce > >those smaller extents to make the one you need. so Jay would not have > >needed to add a datafile no matter what, if he was not doing a direct > >path insert. > > > >As for meeting in person there is a user group meeting on Dec 12 > >(check www.nyoug.org for details). You can meet me, and more > >importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita > >Bardeen, also of this list. They are all presenting :) > > > >I saw Priscilla about a month ago, haven't talked with her since. > > > >Rachel > > > >--- Richard Ji <[EMAIL PROTECTED]> wrote: > > > >
Re: Archived logs backup
more portable to query V$ARCHIVED_LOG after runninig ARCHIVE LOG ALL instead of using OS utilities... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 5:18 AM > must be currently reserved/open for writing. try lsof to find out yr file to be excluded. > kr mr > > >>> [EMAIL PROTECTED] 12/05/02 12:32 PM >>> > Hi! > > I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... > > Within script how do I skip archived log file that is being written by oracle? > > Thanks, > Vladimir Barac > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Markus Reger > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recipe for application design to run on RAC
Title: RE: Recipe for application design to run on RAC Boris, the example I gave you is 9012 RAC and I have 5 other production systems that are 9202 RAC. BTW remember if you have cluster_database is true, then no matter how many instances, you will see GC traffic and boy those numbers are crooked .. it is a generic problem hopefully there will be patch for it to fix the GC timing.. I think that advise should have been prefixed with something like ... "Following statement is issued so that in case your application fails to scale contrary to our well publicized claim that RAC is extensible and scalable, we can always blame on your not-so-well-thought-rac-incompatible design. This way we will be safe and no one in media can blame us." I am pretty sure it is hidden somewhere ... BTW 9202 ... make sure you get all the patches ... this upgrade is a painful story (at-least for us). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recipe for application design to run on RAC On a more serious note the following guidelines look interesting: http://download-west.oracle.com/docs/cd/A97630_01/rac.920/a96600/migrate.htm#1013313 "Migrate to RAC ... unless your application was specifically designed to not use cluster database processing". I wonder why would somebody do that? This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: ECM / BCV / hot backup
Do backup controlfile before step #1 and make sure that it is swept up by Omniback during step #6. There is no need for step #2. Don't forget that step #6 also has to back up archivelogs as well as datafiles and the controlfile backup. --- Better yet, do use RMAN instead. The RMAN user's guide describes exactly this scenario... - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Thursday, December 05, 2002 5:03 AM Subject: ECM / BCV / hot backup Good morning/afternoon/evening to everyone... I'm about to "configure" oracle backup policy using ECM storgae and HP OmniBack. My idea is as follows 1. put all tablespaces into backup mode (db is in arch. mode), 2. sleep 3. do the split 4. take out tablespaces of backup mode, 5. alter system switch logfile, 6. let the Omni Back do it's job. Anu do's and don't's regarding EMC/Oracle combination?
RE: Are Oracle courses required for Oracle Certification now?
Hang on to those sheets! Mine were stamped "Do Not Lose This Report." After I finished all of my tests, I waited and waited for my certification in the mail. I finally called Oracle Education. They didn't have 2 of my tests on record. I had to fax my copies of the reports to them! Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA 2"+ of snow at 8:00 am and still falling! Wuhoo! >>> [EMAIL PROTECTED] 12/04/02 06:59PM >>> Are you getting a sheet after each exam showing how many you got correct for each section and your overall score? I received that sheet at the testing center after each exam. Other than that, you won't get anything from Oracle until you finish your final exam. It took me about a month to get my packet. At 01:13 PM 12/4/02 -0800, you wrote: >Lyndon - I have completed 2 of the 5 Oracle8i exams. > >Hey - when I took each exam, the testing organization says that I should >receive something from Oracle within a couple of weeks. Got nothing. Should >I be worried? > >Dennis Williams >DBA, 40%OCP >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-Original Message- >Sent: Wednesday, December 04, 2002 1:10 PM >To: Multiple recipients of list ORACLE-L > > >Hey William, > >Why are you 40% OCP - does this mean you are an OCA? When did you take your >very >first 9i certification exam? If you took it before Sept. 1, 2002, the you're >a >50% OCP. > >-- >Lyndon Tiu > > >Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > > > My instructor in a recent Oracle Education class said that there were a > > couple of smart alecs that caused quite a stir within Oracle. After > > receiving their OCP, they couldn't log into a database, and claimed it was > > because they had never actually used Oracle. The instructor indicated that > > the new requirement (9i I believe) would require you to take at least one > > class. I asked "do you mean everyone that takes a class from you will be > > logging on". He just grinned. > > Dennis Williams > > DBA, 40%OCP > > Lifetouch, Inc. > > [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Dennis, When i was taking the initial OCP exams I received a score sheet from the testing orginization the day I passed each test. The only time I received any thing related to Oracle was after I passed all tests and then I received a certification suitable for framing. I also received an email that directed me to the Oracle site where the "Certified Professional" logo image is stored and a password to download the image (suitable for business cards and letterheads). Ron >>> [EMAIL PROTECTED] 12/04/02 04:13PM >>> Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > My instructor in a recent Oracle Education class said that there were a > couple of smart alecs that caused quite a stir within Oracle. After > receiving their OCP, they couldn't log into a database, and claimed it was > because they had never actually used Oracle. The instructor indicated that > the new requirement (9i I believe) would require you to take at least one > class. I asked "do you mean everyone that takes a class from you will be > logging on". He just grinned. > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, December 04, 2002 11:25 AM > To: Multiple recipients of list ORACLE-L > > > Hey people! > > A friend of mine was just asking me about getting Oracle certified (I > completed the Oracle 8i cerfication exams last year), > he told me that to his knowledge Oracle requires that you've done Oracle > courses before you can be certified now. > I knew nothing about this, but can't believe Oracle would so blatantly make > you take their over-priced courses. > > But maybe I'm just naive. > > Cheers, > Kieran Murray > CardBASE Technologies Limited® > BIM House > Crofton Road > Dun Laoghaire > Co Dublin > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kieran Murray > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from)
Re: Archived logs backup
must be currently reserved/open for writing. try lsof to find out yr file to be excluded. kr mr >>> [EMAIL PROTECTED] 12/05/02 12:32 PM >>> Hi! I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... Within script how do I skip archived log file that is being written by oracle? Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9iR2 on Red Hat 8.0/Kernel settings
Hi, I'm to install Oracle9i R2 on RH linux soon as well. I have read the install guide about the kernel settings but they seem to only mention the correct settings for a single instance on LINUX. I have not had the privilege before to work on systems I had to set the kernel parameters (not needed on AIX) so I could use a little help on this. RH linux 8.0 Oracle 9i R2 2 instances on one machine (about 25 concurrent users per db) buffer cache approx. 300MB (based on the old databases that is migrating plus some extra for upgrade) Shared pool 25-35Mb (based on the old databases that is migrating plus some extra for upgrade) What would my kernel settings be looking like, or could anybody point me to ocumentation that explains this??? TIA Jack -Original Message- Sent: donderdag 5 december 2002 10:44 To: Multiple recipients of list ORACLE-L installed O92010 on rh 8.0. went fine so far until I tried to connect via "oemapp console" - whatever connectdescripter I chose it resulted in the error "connection string not properly terminated". same connect descriptors in the CLI worked fine - made them available in the "oemapp console" and got the error message. didn't investigate any further into this - experienced it twice on two different machines. changed back to rh7.2 and things were fine again. don't forget to make the kernel settings for memory - otherwise the database installation will fail - maybe you have to correct the entry in the ORACLE_HOME/ctx/lib/env_ctx.mk file for INSO_LINK and add $(LINKLDLIBS) at the end. installing the patch to make 9.2.0.2.0 out of it may require some tweaking. or if this is a new installation just drop the typical database and create a new one after applying the patch to the other files. be careful with oid - experienced you cannot install it after applying the patch. in general the same hints and points as on SunOS apply on RH 7.2/7.3/8.0. have a lot of fun thats all I can contribute. kr >>> [EMAIL PROTECTED] 12/04/02 23:52 PM >>> Thanks Sean. I installed 9iR2 on both my laptop and a desktop, both running RH 8.0. Pretty straightforward, except for the usual failure in linking intermedia. I would have thought they would fix that by now. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Oracle 9iR2 on Red Hat 8.0 > If you've installed Oracle 9i on RH 8.0, please let me know. > > Also, please let me know of any difficulties and workarounds > you may have encountered. > > Just put a new 40Gig HD in my laptop, and wondering if I > can install RH 8.0, or should use 7.2. Jared: I put together some notes when I installed 9.2.0 on RH7.3. I think that RH8 is probably similar. http://iheavy.com/~shull/files/ora9i_inst_notes.txt HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services
RE: Oracle 9.0.1 and 9.2
> The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Can you explain this? I've upgraded multiple databases (Solaris) from 9.0.1 to 9.2.0 by doing a simple upgrade. -Original Message- Sent: Thursday, December 05, 2002 4:18 AM To: Multiple recipients of list ORACLE-L Stefan, The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Whether you want to go through that is your choice really. If I had the disk to burn I'd go for the fresh install but then I like to have a version of everything available. Regards, Mike Hately -Original Message- Sent: 05 December 2002 08:29 To: Multiple recipients of list ORACLE-L Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a "minor" update like 8.1.5 -> 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ECM / BCV / hot backup
Good morning/afternoon/evening to everyone... I'm about to "configure" oracle backup policy using ECM storgae and HP OmniBack. My idea is as follows 1. put all tablespaces into backup mode (db is in arch. mode), 2. sleep 3. do the split 4. take out tablespaces of backup mode, 5. alter system switch logfile, 6. let the Omni Back do it's job. Anu do's and don't's regarding EMC/Oracle combination?
RE: Are Oracle courses required for Oracle Certification now?
Don't worry, they probably don't know much about Oracle. Here sometimes when I show up for exams I hear: "What's Oracle?" from the people administering the exam. You will get at least a certificate when you finish your track, I got a $0.02 lapel pin as well. ($0.02 is the value Oracle put on the package for Customs Canada). Pat. -Original Message- Sent: Wednesday, December 04, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > My instructor in a recent Oracle Education class said that there were a > couple of smart alecs that caused quite a stir within Oracle. After > receiving their OCP, they couldn't log into a database, and claimed it was > because they had never actually used Oracle. The instructor indicated that > the new requirement (9i I believe) would require you to take at least one > class. I asked "do you mean everyone that takes a class from you will be > logging on". He just grinned. > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, December 04, 2002 11:25 AM > To: Multiple recipients of list ORACLE-L > > > Hey people! > > A friend of mine was just asking me about getting Oracle certified (I > completed the Oracle 8i cerfication exams last year), > he told me that to his knowledge Oracle requires that you've done Oracle > courses before you can be certified now. > I knew nothing about this, but can't believe Oracle would so blatantly make > you take their over-priced courses. > > But maybe I'm just naive. > > Cheers, > Kieran Murray > CardBASE Technologies Limited® > BIM House > Crofton Road > Dun Laoghaire > Co Dublin > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kieran Murray > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- P
Archived logs backup
Hi! I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... Within script how do I skip archived log file that is being written by oracle? Thanks, Vladimir Barac
Re: Oracle 9.0.1 and 9.2
I'd install a new home for 9.2 - once the db is upgraded and working fine, then blow away the 9.0 version. Otherwise there is always that risk that you lose a little file that you would have liked to keep (eg listener.ora etc etc) hth connor --- Stefan Jahnke <[EMAIL PROTECTED]> wrote: > Hi everybody > > I've got 9.0.1 and 8.1.7 running on one laptop (to > test stuff). Now I want > to upgrade the 9.0.1 to 9.2. Does it make sense to > just install the 9.2 to a > new Oracle home or would it be better to get rid of > 9.0.1 and do a fresh > install of 9.2 ? Can 9.2 generally be seen as a > "minor" update like 8.1.5 -> > 8.1.6 or more like 8.0.5 to 8.1.x, which would be a > different major version > ? > > Regards, > Stefan > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Stefan Jahnke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-8103 Error
I have a user who was in essence moving partitions from one table to another. The partitions are date based, one per day She was moving November's data. All went well, until the NOV2802 partition. At that point she received an 8103 error 08103, 0, "object no longer exists" // *Cause: the object has been deleted by another user since the operation // began // *Action: On a partition she had not altred. Indeed all the remaining partitions except "FIRST" are reporting this error. Has anybody else run into this. A tar has been opened. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
which -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle precompiler in O 9.2
is/was yr installation an upgrade from a previously installed 9.0.1.3.0 or 9.0.1.1.0 so that the "proc" remained ? we took the installation images from oracle - same types for linux and SunOS - and the installer shows that precompiler for c,... are duely installed. a blatant lie. kr mr thank you very much for the reply. now my problem seems to be that I didn't install appropriately - but I couldn't find any hint on metalink. find a short summary of my situation - actually the same on linux or SunOS9: === $sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.1.0 - Production on Mi Dez 4 10:51:48 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production co-db oracle 9.2.0.1.0 ~/product/9.2.0.1.0 $ which proc no proc in /usr/ccs/bin /usr/bin etc /usr/openwin/bin . /u01/product/9.2.0.1.0/bin /u01/bin . /usr/local/bin $ pwd /u01/product/9.2.0.1.0 $ echo $ORACLE_HOME /u01/product/9.2.0.1.0 co-db oracle 9.2.0.1.0 ~/product/9.2.0.1.0 $ find . -name proc ./inventory/filemap/rdbms/demo/lobs/proc ./rdbms/demo/lobs/proc co-db oracle 9.2.0.1.0 ~/product/9.2.0.1.0 === hope this sheds some light on my problem. thank you in advance for furhter hints kr >>> [EMAIL PROTECTED] 12/03/02 17:20 PM >>> SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production oraclei@elara-ABC1> oraclei@elara-ABC1> which proc /usr/opt/oracle/current/bin/proc Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, December 03, 2002 5:44 AM To: Multiple recipients of list ORACLE-L hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9iR2 on Red Hat 8.0
installed O92010 on rh 8.0. went fine so far until I tried to connect via "oemapp console" - whatever connectdescripter I chose it resulted in the error "connection string not properly terminated". same connect descriptors in the CLI worked fine - made them available in the "oemapp console" and got the error message. didn't investigate any further into this - experienced it twice on two different machines. changed back to rh7.2 and things were fine again. don't forget to make the kernel settings for memory - otherwise the database installation will fail - maybe you have to correct the entry in the ORACLE_HOME/ctx/lib/env_ctx.mk file for INSO_LINK and add $(LINKLDLIBS) at the end. installing the patch to make 9.2.0.2.0 out of it may require some tweaking. or if this is a new installation just drop the typical database and create a new one after applying the patch to the other files. be careful with oid - experienced you cannot install it after applying the patch. in general the same hints and points as on SunOS apply on RH 7.2/7.3/8.0. have a lot of fun thats all I can contribute. kr >>> [EMAIL PROTECTED] 12/04/02 23:52 PM >>> Thanks Sean. I installed 9iR2 on both my laptop and a desktop, both running RH 8.0. Pretty straightforward, except for the usual failure in linking intermedia. I would have thought they would fix that by now. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Oracle 9iR2 on Red Hat 8.0 > If you've installed Oracle 9i on RH 8.0, please let me know. > > Also, please let me know of any difficulties and workarounds > you may have encountered. > > Just put a new 40Gig HD in my laptop, and wondering if I > can install RH 8.0, or should use 7.2. Jared: I put together some notes when I installed 9.2.0 on RH7.3. I think that RH8 is probably similar. http://iheavy.com/~shull/files/ora9i_inst_notes.txt HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Online Index Rebuild Tuning
The first question is whether you really need to rebuild them. If the indexes columns are such that the values are likely to be reused, then I wouldn't bother - since that deleted space will get reused as required. Cheers Connor --- Mark Richard <[EMAIL PROTECTED]> wrote: > Folks, > > I know that when creating indexes a couple of > settings such as > SORT_AREA_SIZE can have a big impact on duration. > What settings apply > during online rebuilds? Are the rules the same? > What tips do you have? > > Basically we have some very large indexes in an OLTP > system (several > indexes are across ~250m rows, several GB in > physical storage) which have > fairly low density due to deletes and updates. In > looks like the time has > come to rebuild then to gain some performance. Any > other suggestions > regarding tricks to avoid this, etc would be greatly > appreciated. > > Thanks, > Mark. > > PS: If you going to suggest things which are > version specific we're > dealing with 8.1.7.4 on Solaris. > > <<>> >Privileged/Confidential information may be > contained in this message. > If you are not the addressee indicated in > this message >(or responsible for delivery of the message > to such person), > you may not copy or deliver this message > to anyone. > In such case, you should destroy this message and > kindly notify the sender >by reply e-mail or by telephone on (61 3) > 9612-6999. >Please advise immediately if you or your employer > does not consent to > Internet e-mail for messages of this > kind. > Opinions, conclusions and other information > in this message > that do not relate to the official > business of > Transurban City Link Ltd > shall be understood as neither given nor > endorsed by it. > <<<> > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.0.1 and 9.2
Stefan, The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Whether you want to go through that is your choice really. If I had the disk to burn I'd go for the fresh install but then I like to have a version of everything available. Regards, Mike Hately -Original Message- Sent: 05 December 2002 08:29 To: Multiple recipients of list ORACLE-L Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a "minor" update like 8.1.5 -> 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-1653: unable to extend table - Why?
Or maybe Miller. It is, after all, the name of a well-known alcoholic beverage. Good thing my first name is not spelled Moans. I would probably not get many emails through spam filters. Mogens Miller, Jay wrote: Kirti, Thanks for suggesting the Note, I'm reading it now. I tried replying to you directly but my thank you was blocked by your company's spam filter. I'm really curious to know what key word flagged it as spam. Oracle? Jay -Original Message- Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji <[EMAIL PROTECTED]> wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if
Re: DB corruption question
Nope, no corruption of data files as far as I can see. The mount lock (or whatever it's called now) protects Oracle from having two instances mount the same database. There used to be a wonderful _no_mount_lock parameter or such, but I never got it to work. You should be OK. Mogens Nick Wagner wrote: With Oracle 8.1.7, Solaris 8 OS. I have a shared storage device for storing all my datafiles, control files, redo logs, archive logs, etc.. everything except for the ORACLE_HOME and Oracle binaries. If I have the file system and database mounted to one machine, and have a fully open, available database running. What happens if someone else tries to mount the same files to another machine and start up the same database on it. (No OPS or RAC involved) I get the following error on the on the second machine... SVRMGR> ORACLE instance started. Total System Global Area 272359584 bytes Fixed Size 73888 bytes Variable Size 88678400 bytes Database Buffers 183427072 bytes Redo Buffers 180224 bytes Database mounted. SVRMGR> ORA-00283: recovery session canceled due to errors ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile SVRMGR> alter database open * ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile SVRMGR> Server Manager complete. EXITING 1 Unable to start Oracle instance Will this corrupt the database? Will it harm/corrupt the original instance? What happens if someone tries to recover it at this point? Does it make a difference whether its a RAW or cooked file system? Any help is appreciated! Nick
Re: Online Index Rebuild Tuning
As far as I remember the online rebuild does a FFS (Fast Full Scan) of the existing index' leaf blocks, then builds the new one and finally does some clever stuff before switching over (renaming the new index from a temporary segment to a permanent). So there's a lot of reading and writing involved (IO considerations) and the sort area will probably be used just as heavily as if you created a new index (but I'm not too sure about that) and finally there's of course the usual storage consideration (LMT's, etc.). That's about it, I believe. Mogens Mark Richard wrote: Folks, I know that when creating indexes a couple of settings such as SORT_AREA_SIZE can have a big impact on duration. What settings apply during online rebuilds? Are the rules the same? What tips do you have? Basically we have some very large indexes in an OLTP system (several indexes are across ~250m rows, several GB in physical storage) which have fairly low density due to deletes and updates. In looks like the time has come to rebuild then to gain some performance. Any other suggestions regarding tricks to avoid this, etc would be greatly appreciated. Thanks, Mark. PS: If you going to suggest things which are version specific we're dealing with 8.1.7.4 on Solaris. <<>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9.0.1 and 9.2
Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a "minor" update like 8.1.5 -> 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).