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).
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).
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 thesecond 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: 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: 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: 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 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: 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).
[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).
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).
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).
Archived logs backup
Hi! I want to write unix script to automate archved logs backup to tape ... After hot backup of data filesis completed... Within script how do I skip archived log file that is being written by oracle? Thanks, Vladimir Barac
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
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 some_time 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: 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).
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-- 858-538-5051
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).
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). You may also send the HELP command for other information (like subscribing).
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 DE 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: 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 some_time 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: 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: 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: 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: 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
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).
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).
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 of bread. Each pattern would be established by SAP's experts as the Best Practices method of toasting
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: 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: ORA-1653: unable to extend table - Why?
Its not Miller or Moans or Oracle or OCP...:) Actually, it is the footerin 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 mye-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
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: 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).
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-
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 21
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 21
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: 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 some_time 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
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 some_time 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 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: 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: 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: ORA-8103 Error
Curioser and Curioser If I run the following query select timestamp from table_which_reports ora-8103 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: 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: 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: 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
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: 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 stdio.h
#include stdlib.h
#include string.h
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 'full path to shared lib/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: 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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California
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: 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: 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
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: 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.
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 (DE) 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 that is
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 ORACLE-L FAQ:
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: 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: 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: 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 the decision to include middleware capable of data-routing when designing
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: 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: 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 (DE) 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
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 some_time 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: 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: 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?
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).
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 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).
sys login -probably a dumb question
I have 2 instances on a sun box. instance abc I can connectby 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: 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 thesecond 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: Database up longer that host?
OK, since it's virtual anyway, grin [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 - To REMOVE yourself from this mailing
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: 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: 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
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: 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?
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: 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: 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: RE: To_Number
Very Possible. I'm 8.1.7.2 W2K sp2
whack
-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: 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
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
BurtonL@prism[EMAIL PROTECTED]
plus.comcc:
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: 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: 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 know this from
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
BurtonL@prism[EMAIL PROTECTED]
plus.comcc:
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: 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] hamcdc@yahoo. cc: 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
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: 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
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
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
BurtonL@prism[EMAIL PROTECTED]
plus.comcc:
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).
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
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
wisernet100@Y[EMAIL PROTECTED]
AHOO.COMcc:
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: 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] hamcdc@yahoo. cc: 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
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: 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 4 1 25 enqueue requests
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
wisernet100@Y [EMAIL PROTECTED]
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: 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: 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: 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
wisernet100@Y[EMAIL PROTECTED]
AHOO.COMcc:
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: 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).
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: 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
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).
