RE: EMC question
It looks like it's available now. This is from: ResourcePak for Windows Version 3.2 Product Guide Symmetrix Microcode level 5x65 includes support for concatenated (contiguous) and striped metavolumes. Noncontiguous metavolumes (including striped) require EMC Enginuity(tm) (5x66 microcode) or higher. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/1/02 5:38 PM Waleed list, I researched this issue recently and found out that the meta volume was concatenating a bunch of hyper volume. As you know, concatenation is NOT striping. The hyper volumes get filled with data one after another, eventually giving you the simulation of a striped volume, when all hypers are filled with data. I don't know about the single-host vs. multi-host addressibility issue. There are plans for supporting true striped volumes in microcode level 68 or 69. From some reliable sources that does not look like it will happen any time soon. So until then, you should consider created mirrored hyper volumes within EMC (RAID 1) and then create a striped volume using Veritas Volume Manager, giving you a RAID 1+0 configuration, which is ideal. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: Four years ago the only hardware striping available on EMC I was aware of was RAID-S. Recently researching striping ideas on EMC and was told that we can achieve raid0+1 hardware striping on EMC. I was told that EMC has some layer called meta-volume that is made of many other hyper-volumes. Told also that meta-volumes could be raid-0 (striped) and it's not a single-host addressable volume. Does anybody know anything about this? Can we really get a hardware striped volume using EMC? Any limitations there? Thanks. Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FW: Oracle Step-by-Step Guide feedback
Yup. I particularly dislike the ... We're thinking about a special program for the people who made us go to the trouble of sending the draft and then did not provide feedback. What special program ? Compulsory Military Service ? There really wasn't anything significant in the version 0.3 draft. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Koivu, Lisa [EMAIL PROTECTED] 30/03/2002 01:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: FW: Oracle Step-by-Step Guide feedback Anyone else get an email like this that sounded kinda threatening? -Original Message- From: SANS Research Office [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Oracle Step-by-Step Guide feedback This is a note to the 167 people who promised to provide feedback on the Oracle problem list. First, great thanks to all who have sent feedback. I have read most of the response. They reflect real expertise and thoughtfulness. This project has taken on more meaning because the specifications of a safe Oracle installation we are producing are now being discussed as criteria in Oracle procurements at multiple federal agencies. In other words, we need to do it right the first time. So we especially appreciate teh feedback. If you provided substantive feedback on the problem set draft, we will also send you the actual draft of the problems and solutions. Others will be able to purchase the document later when it is published after several rounds of review. We're thinking about a special program for the people who made us go to the trouble of sending the draft and then did not provide feedback. Because of the holiday weekend, we'll extend the feedback deadline to Thursday April 4. Alan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: One sql statement
select sum(decode(balance,'D',amount,0)) SUM_DEBIT,sum(decode(balance,'C',amount,0)) SUM_CREDIT from mytable -Original Message- Situmorang Sent: Tuesday, April 02, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Suppose I have table structure like this: amount Numeric(10) balance VARCHAR(1) the balance column can only have one of 'D' or 'C' I want to sum the amount of Debet and Credit on ONE SQL statement. How my SQL statement should be? Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferry Situmorang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Atul Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Congratulations, Ari! + FYI: 9i usage survey
Congratulations Ari. They made a good choice! Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 01, 2002 5:24 PM Hi list, Thanks John for the warm email. I am honored to have been elected to the Board, and will listen and work hard to make IOUG continue to be great for the Oracle community. There were many very strong candidates running this year, so I know how valuable it was to have been elected. Any comments people have to make IOUG better, my email is [EMAIL PROTECTED] Take care, -Ari -Original Message- Kanagaraj Sent: Monday, April 01, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Hi all, Came across this on the IOUG page: Results of the IOUG Board of Directors Election. The Winners are... 13-MAR-02 Michael Abbey - 48.5% of voters Kimberly Floss - 45.6% of voters Karen Langley - 41.5% of voters Ari Kaplan - 40.3% of voters Congratulations to the winners. Michael Abbey, popular speaker, author, and Oracle guru returns to the board. Kimberly Floss and Karen Langley were re-elected by the membership and will continue their efforts on behalf the of the Oracle user community. Ari Kaplan joins the IOUG Board of Directors for the first time. The community looks forward to his insights and contributions. JK: Congratulations, Ari! You owe us one. Results of 9i Migration Survey Completed by OTN and IOUG Members 11-MAR-00 - 20% of respondents have installed Oracle9i. This number has climbed from 10% in July to 28% in November to 43% in January 2002 - 77% of respondents plan to use Oracle9i for production applications within the next 12 months - 41% plan to move all application to 9i, while 37% plan to move some applications, and 22% plan to deploy only new applications on Oracle9i - 74% of respondents rate Oracle9i as very innovative - 52% of respondents plan to migrate non-Oracle databases to 9i John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Joseph S Testa [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: Installing Oracle 9.0.1 on Red Hat Linux 7.2 first time you get the error, open a new window go to $ORACLE_HOME/bin look for genclntsh vi the file, looking for -z defs, remove that part, the -z defs ./genclntsh then hit retry, all should be good. joe [EMAIL PROTECTED] wrote: If you have successfully installed Oracle 9.0.1 on Red Hat 7.2, please let me know what steps you had to take to make it work. I've installed the compatibility libs and glibc stub patch for Oracle 8i, and have successfully installed 8.1.7. The 9i install consistently fails on the ins_plsql.mk makefile. I'll check on MetaLink some more. And yes, I know 7.2 is not yet certified, but it appears from the forums on MetaLink that others have done this. Thanks, Jared -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ari Kaplan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: Seeking opinions
Paul, I live under similiar standards. They make sense here becuase, when one looks at the big picture, they need these types of standards to help the DBA's (there are three of them) to cope with the many many Oracle instances across multiple platforms (NT, Sun Unix, Dec Unix). I look at it this way - at least it's a standard - better than no standards at all. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do programmers tune SQL?
[EMAIL PROTECTED] wrote: I may open a can of worms - but don't intend to... zymurgy's law: once you open a can of worms, the only way to recan them is to get a bigger can.;-) In our company many developers have DBA access to databases and in fact nobody does anything stupid. I have found that if people don't know what they are doing, they ask. Nobody tries to drop or truncate tables because they have found the script that seesm cool and want to see what it does... Over my 8 years here only once we had a problem - a few tables were dropped by mistake but the tables were dropped by our DBA who run the wrong script. It took almost no time at all to rebuild it. And it happened in a test database. you are in a very good environment, stay there. i have had to give up DBA access to test databases to developers here, and then spend a lot of time rebuilding them because they had no clue as to what they were doing. it took me months of wasted time and long hours to get control back. and i had to keep up with production too. i am obviously reluctant to give it up again, but i am more than willing to work with them to do any tuning needed. I understand restrictions in production databases but more access to development and test would make life easier and am sure more happy faces around. only if you fix what you break, if i have to keep going in and fixing it i have less time in an already busy schedule to do what i need to in the production side. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. You are not thinking. You are merely being logical. - Neils Bohr to Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
jdbc oci driver - UnsatisfiedLinkError
Hi gurus, we would like to connect to 8i databases with jdbc oci driver. Our environment: Db servers: Oracle Standard Ed. v. 8.1.6.1.0 on RedHat Linux 6.2 Oracle Enterprise Ed. v. 8.1.7.0.0 on Windows 2000 Client: 8.1.7 client on RedHat Linux java version: 1.2.2 CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.jar LD_LIBRARY_PATH=/lib:$ORACLE_HOME/lib There is no classes11* file in $OH/jdbc/lib directory. libocijdbc8.so and libocijdbc8_g.so files are in $OH/lib. The tnsnames.ora on client contains valid entries to databases so connection via sqlplus works fine. We compiled JdbcCheckup.java according to JDBC Developer's Guide and Reference. But we get the following error when we launch it: Exception in thread main java.lang.UnsatisfiedLinkError: get_env_handle Any suggestion to solve this problem? Thanks in advance! Zoltan Hives -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?H=EDves=20Zolt=E1n?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cold NT backups
Group, We are doing a cold backup to a remote server. I am using OCOPY that fails intermittently with the following message: OCOPY - Insufficient disk space on target drive There is more than sufficient space on the drive to hold the file. I filed a TAR and was told that the error message is generic in nature and they could not tell me exactly what is failing. Can anyone PLEASE give me some suggestions. The file is always SYSTEM01.DBF. All the rest of the files copy across without a problem. TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
WorkFlow on 9iAS
Hi It is supposed that workflow is installed when you install a fresh copy of Oracle 9iAS 1.02.2, but not in my case. Do you know where I can find the Oracle Workflow software to download? (i can't find it in OTN) and some documentation on how to install it in my 9iAS . Thanks for all Gonzalo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gonzalo Romero A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql Server to Oracle
I've got a Texas client who has a link to an office in India. They are attempting to insert records from Sql*Server, but are using ole-db or what ever it's called. In M$ wisdom, the first thing the link does is request the entire table from the host... This causes a 1-2 minute delay to insert 1 record. Fortunately it only does it once. Is there a way to turn this off? What in the world would happen if they were trying to insert into s 50 million row table? They'd not only have a 1-2 hour delay, but probably die flooding the memory of the Sql*Server box... They are looking into a visual basic program, but if this get a copy of the whole table could be stopped, then this opportunity would be over. It's been too long since I've looked at Sql Server 7, and I can't think of anything off hand. Maybe one of you have been there, done that... Thanks. Michael Kline ThinkSpark Richmond, VA 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OracleService is down on regular basis
Jamdagni Danishment, Thanks for your help. I opened a ticket with Oracle and it got fixed. See the Oracle explanation ... This is bug 614799. Abstract: ORA-600[17034] WHEN CONSTRAINT IS VIOLATED Workaround is: set AUDIT_TRAIL=NONE or set AUDIT_TRAIL=FALSE Thanks, Bob --- Danisment Gazi Unal [EMAIL PROTECTED] wrote: Hi, can you paste ora-600 trace files to list ? Jamadagni, Rajendra wrote: Check the code in the trigger it seems that one of the variables is getting assigned a value that is longer than it can hold. The ora-2 error is user generated. Check on metalink you could be running into a bug, one of the posters got it resolved by pinning all the packages in SGA. Anyways, the mantra is 'If you see ora-600 error, first contact OWS and then the list.' HTH 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! Name: ESPN_Disclaimer.txt ESPN_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Seeking opinions
Paul, We kindof use something like that here. Basically when we need to create a database we have the SA create a high level mount point, like '/PS' for our PoepleSoft stuff. We then create additional mount points like say '/PS/pstools' for individual stuff. Disk space is not allocated to '/PS', but to '/PS/pstools'. It does make it easier to find what datafiles are what, but still you'd need to look in the data dictionary. Actually it's faster to look in the data dictionary and you can do it remotely as well. Dick Goulet Reply Separator Author: Paul Baumgartel [EMAIL PROTECTED] Date: 4/1/2002 2:48 PM Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: jdbc oci driver - UnsatisfiedLinkError
- Original Message - Exception in thread main java.lang.UnsatisfiedLinkError: get_env_handle Metalink Note 157468.1 may be helpful: === fact: Oracle Server - Enterprise Edition 8.1.7 fact: Oracle JDBC/OCI Driver for JDK 1.2 fact: JDK 1.2 fact: Intel Based Server LINUX symptom: Connecting to database fails symptom: java.lang.UnsatisfiedLinkError: get_env_handle symptom: Works using thin driver. cause: The cause of this problem is still undetermined. fix: Upgrade to Oracle Server - Enterprise Edition 9i or Apply patchset 8.1.7.2 === hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on NT
I think that he has a much more serious problem than setting the SID. If I understand the situation the Oracle Service (the instance) is not starting because the ORACLE_HOME parameter in the registry is messed up (probably as part of the upgrade). Try clicking START, PROGRAMS, ORACLE FOR WIN2K (or something like that), and see if you have 'Oracle Home Selector'. After you set the ORACLE_HOME, click START, PROGRAMS, ACCESSORIES (or ADMINISTRATIVE TOOLS - I forget which {MS changed it in Win2K}) and SERVICES. Scroll down until you see the ORACLE. services and start the automatic start ones that haven't started. If the ORACLE_HOME is still messed up, then you'll have to dig into the registry. Look under HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE, ALL_HOMES. There should be a parameter called HOME_COUNTER that will tell you how many ORACLE_HOMES are set up on your machine. Further branches will be IDn where 0 is the first Oracle home, 1 is the second, etc. Under those are parameters NAME and PATH. Find the one with the NAME DEFAULT_HOME and set it's PATH to what you want the ORACLE_HOME to be (maybe something like C:\ORACLE\ORACLE8I {include the quotes}). Then scroll down to ORACLE_HOMES. Under that will be folders named ORACLEn, again where 0 is the first Oracle Home, 1 is the second, etc. Here the parameter ORACLE_HOME should be the path, ie., what you set PATH to be above. One of the folders should have the parameter ORACLE_HOME_NAME set to DEFAULT_HOME. This is the one that you want to set the ORACLE_HOME to your chosen Oracle Home. It can also have a SHARED_ORACLE_HOME parameter that you should set to your Oracle Home. Then reboot the machine for the registry changes to take effect and see if the services have started. You can check out the NSL_LANGUAGE parameters while you're there but my experience is that that's a bogus error message. Oracle can't find the correct Oracle Home, tries to send you an error message, realizes that it doesn't have the NSL_LANGUAGE parameter set, and settles for sending you an error message to that effect. BTW - save a copy of your registry before you try this!!! From the Registry Editor (regedit) click on 'registry' and 'export registry file' to save a copy. To change registry values right click on the parameter name. You'll get a little pop-up. Click 'Modify' and you'll get a little edit window to edit the value. Good luck - HTH Boivin, Patrice J To: Multiple recipients of list ORACLE-L BoivinP [EMAIL PROTECTED] @mar.dfo-mpo.cc: gc.ca Subject: RE: Oracle on NT Sent by: root 04/01/2002 07:08 PM Please respond to ORACLE-L Blake, When you open a command line window (aka DOS session I like to call them), remember to issue the following statement before you try to use sqlplus: Set oracle_sid=put_your_SID_here e.g. set oracle_sid=ORCL sqlplus Then connect internal if you can. I like to try something like select name from v$database to see if the database is really up. If it is, you will get the database name; if not... Oracle will tell you. You then probably should do a shutdown abort followed by startup (specify the pfile if Oracle doesn't know how to find it). After rebooting, wait a couple of minutes before logging in. Oracle sometimes takes a while to get up and running on Windows NT 4, I strongly suspect it's the same on Windows2000, since that is just NT 5 anyway. You can always r-click on the bottom bar, where the minimized applications appear. Select Task Manager, and look at the Performance tab to see if the memory has been allocated for your Oracle instance. If you have more than one instance, you will need to set oracle_sid=xxx before using the tools, or you need to
Re: Cold NT backups
Since it is a cold backup. The database is closed. Try using the copy command instread of the ocopy to see if this eliminates the problem. I don't expect that it will but if it does you can complain about a problem in ocopy and if not you can eliminate ocopy as the problem and start blaming Microsoft. John [EMAIL PROTECTED] wrote: Group, We are doing a cold backup to a remote server. I am using OCOPY that fails intermittently with the following message: OCOPY - Insufficient disk space on target drive There is more than sufficient space on the drive to hold the file. I filed a TAR and was told that the error message is generic in nature and they could not tell me exactly what is failing. Can anyone PLEASE give me some suggestions. The file is always SYSTEM01.DBF. All the rest of the files copy across without a problem. TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql Server to Oracle
The only thing that help you with SQL Server is Gates Open Directory (GOD, for short). They started developing the communication protocols a few thousand years ago, but so far it only supports unidirectional communication. -Original Message- From: Michael Kline [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: Sql Server to Oracle I've got a Texas client who has a link to an office in India. They are attempting to insert records from Sql*Server, but are using ole-db or what ever it's called. In M$ wisdom, the first thing the link does is request the entire table from the host... This causes a 1-2 minute delay to insert 1 record. Fortunately it only does it once. Is there a way to turn this off? What in the world would happen if they were trying to insert into s 50 million row table? They'd not only have a 1-2 hour delay, but probably die flooding the memory of the Sql*Server box... They are looking into a visual basic program, but if this get a copy of the whole table could be stopped, then this opportunity would be over. It's been too long since I've looked at Sql Server 7, and I can't think of anything off hand. Maybe one of you have been there, done that... Thanks. Michael Kline ThinkSpark Richmond, VA 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Designer's Table API: Threat or Menace?
Greetings all, Is anyone out there using Oracle Designer's Table API? We're trying to decide whether to use it as opposed to writing our own packages triggers (for things like populating sequence-generated PKs, upcasing VARCHARs, enforcing domains, etc.). From my (admittedly selfish) perspective, any working line of code that I don't have to write/support is a good line of code, but it does look like a *lot* of code to do not so very much. Our DBA is concerned that it's creating unnecessary triggers, will suck down resources unecessarily, server will grind to a halt, etc. My concern is that we'll find out that the TAPI procs are bulky complicated for a reason--we'll decide to chuck them then wind up reinventing them (and maybe not as well as the folks at Oracle). Has anybody out there been over this ground care to make a reccomendation? Thanks! -Roy P.S. In case it's important, we're using Designer 6.0 to create OAS-deployed Oracle Forms Reports to run against a 9i db. Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Move index to another tablespace
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Move index to another tablespace Hi U have to rebuild the index only. u can't able to move from one tablespace to another like move table. Regards Ayyappan.S Ayyappan, you can move indexes around if you purchase UHAUL for Indexes. Just kidding. That was available since version 7.3. Another thing: can you, please, stop using that teenage chat syntax in your emails? It is quite annoying, you know. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle , SQL*Server Concurrent SELECT
Title: RE: Oracle , SQL*Server Concurrent SELECT Any Links , Docs on the Same ? -Original Message-From: Shripad Bharati [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:48 AMTo: VIVEK_SHARMASubject: RE: Oracle , SQL*Server Concurrent SELECT U can use Oracle's Heterogeneous Services . -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: 02 April 2002 08:07 To: LazyDBA.com Discussion Subject: Oracle , SQL*Server Concurrent SELECT 2 Databases Exist - 1 in Oracle , 2nd SQL Server AIM To Possibly Run the Following SELECT Query in Some Manner SELECT Oracle Data, SQL Server Data FROM Oracle Table , SQL*Server Table Is the Above possible ? If so How ? Thanks 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: Installing Oracle 9.0.1 on Red Hat Linux 7.2
Jared - Check this link, there is a workaround. http://www.puschitz.com/InstallingOracle9i.html Gene [EMAIL PROTECTED] 04/01/02 02:53PM If you have successfully installed Oracle 9.0.1 on Red Hat 7.2, please let me know what steps you had to take to make it work. I've installed the compatibility libs and glibc stub patch for Oracle 8i, and have successfully installed 8.1.7. The 9i install consistently fails on the ins_plsql.mk makefile. I'll check on MetaLink some more. And yes, I know 7.2 is not yet certified, but it appears from the forums on MetaLink that others have done this. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Move index to another tablespace
-Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Move index to another tablespace Hi Ayyappan, Correct me if I am wrong. I think in 8.1.6, you can use the alter index command to move an index to a different tablespace eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE new_tablespace_name; That is available since 7.3. Moving tables is available as of 8i. There are few missing links now. I'd like to see RENAME USER command added to the lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cold NT backups
For cold backup you could just use standard NT copy command. Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 8:58 AM Group, We are doing a cold backup to a remote server. I am using OCOPY that fails intermittently with the following message: OCOPY - Insufficient disk space on target drive There is more than sufficient space on the drive to hold the file. I filed a TAR and was told that the error message is generic in nature and they could not tell me exactly what is failing. Can anyone PLEASE give me some suggestions. The file is always SYSTEM01.DBF. All the rest of the files copy across without a problem. TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: archive log curr v. switch logfile
I use Alter system archive log current. If your archiver process is caught up, you will get this error message when issuing Alter system archive log all: SQL alter system archive log all; alter system archive log all * ERROR at line 1: ORA-00271: there are no logs that need archiving Just don't like error messages in the logs :). Lisa's method seems the safest, but never had an archiver not keeping up and if I did, that would be an issue to be resolved quickly. Here's my hot backup model with help from list members and Velpuri/Adkoli's Backup/Recovery Book: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Backup controlfile. # 8) Alter system archive log current ; # Archives are backed up separately 2 x day to tape. Gene PS. Confident w/ hot backups, next to conquer RMAN cautiously. [EMAIL PROTECTED] 03/29/02 12:13PM Actually I use alter system archive log all. I saw that if the database was behind with archiving, this would ensure that all logs were written to the arc destination. archive log current only did the most recent. Am I wrong? Please correct me if I am . Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: archive log curr v. switch logfile I believe alter system archive log current will wait until archiver has successfully archived the file, thus this is the one you would want to use in any backup scripts. - Ethan -Original Message- Sent: Friday, March 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Move index to another tablespace
You can do that in 8.0.6 too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 9:43 AM -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Move index to another tablespace Hi Ayyappan, Correct me if I am wrong. I think in 8.1.6, you can use the alter index command to move an index to a different tablespace eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE new_tablespace_name; That is available since 7.3. Moving tables is available as of 8i. There are few missing links now. I'd like to see RENAME USER command added to the lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seeking opinions
Great point. I had recently created a DB file and forgot to put the .dbf extension on it. If someone didn't query the DD of the DB first, they might have thought it was a junk/temp file (they would have to ignore the file's timestamp) and deleted it. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Subject: RE: Seeking opinions Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Designer's Table API: Threat or Menace?
Worked on a 100% generated application on very similar versions you state. Although I used the term 100% in quotes, I was very impressed with the developers - who got about 95% of the gui (screens, reports) done purely through Designer. Table API's were used primarily for the journalling feature. Worked fine - the only real pain being that any references to CG_REF_CODES in the validation code were done with literals - so heaps of parsing with sql's that could for all intensive purposes be common. You'll your shared pool littered with select .. from cg_ref_codes where domain = some_literal_in_quotes and ... I raised an enhancement with Oracle, but as at 6i.2 (the last time I looked at Designer) it was still the same. hth connor --- Pardee, Roy E [EMAIL PROTECTED] wrote: Greetings all, Is anyone out there using Oracle Designer's Table API? We're trying to decide whether to use it as opposed to writing our own packages triggers (for things like populating sequence-generated PKs, upcasing VARCHARs, enforcing domains, etc.). From my (admittedly selfish) perspective, any working line of code that I don't have to write/support is a good line of code, but it does look like a *lot* of code to do not so very much. Our DBA is concerned that it's creating unnecessary triggers, will suck down resources unecessarily, server will grind to a halt, etc. My concern is that we'll find out that the TAPI procs are bulky complicated for a reason--we'll decide to chuck them then wind up reinventing them (and maybe not as well as the folks at Oracle). Has anybody out there been over this ground care to make a reccomendation? Thanks! -Roy P.S. In case it's important, we're using Designer 6.0 to create OAS-deployed Oracle Forms Reports to run against a 9i db. Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 , SQL*Server Concurrent SELECT
Title: RE: Oracle , SQL*Server Concurrent SELECT Metalink has some papers and docs on this. Also there is a book called "Oracle Distributed Systems" by Charles Dye. Also, when in doubt you can always RTFM. ;o) Dave -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:03 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle , SQL*Server Concurrent SELECT Any Links , Docs on the Same ? -Original Message-From: Shripad Bharati [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:48 AMTo: VIVEK_SHARMASubject: RE: Oracle , SQL*Server Concurrent SELECT U can use Oracle's Heterogeneous Services . -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: 02 April 2002 08:07 To: LazyDBA.com Discussion Subject: Oracle , SQL*Server Concurrent SELECT 2 Databases Exist - 1 in Oracle , 2nd SQL Server AIM To Possibly Run the Following SELECT Query in Some Manner SELECT Oracle Data, SQL Server Data FROM Oracle Table , SQL*Server Table Is the Above possible ? If so How ? Thanks 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: Seeking opinions
Richard, In a busy shop, I would think that there is a *less* chance of a DBA making a mistake if all databases across all platforms conformed to the same directory standard. Can you imagine how long it would take to diagnose and fix a problem if every database was set up to a different standard? Mistakes can happen, but at least with standards, if a file is in the wrong place, it would stand out like a sore thumb. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 02, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
It sounds to me that whoever architected this approach really didn't understand the idea of metadata and the flexibility that OFA provides in terms of tuning (I'm not limited to specific disks because I have customer data) and performance. My 2 cents... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 02, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seeking opinions
This is hogwash. OFA perfectly helps to separate the datafiles from different database instances. We run well over 300+ Oracle databases here and the ONLY extension we have to OFA is that I add a /data /control and /redo directory to the file systems for just a little extra protection from possible inode corruption. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 02, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Paul, I live under similiar standards. They make sense here becuase, when one looks at the big picture, they need these types of standards to help the DBA's (there are three of them) to cope with the many many Oracle instances across multiple platforms (NT, Sun Unix, Dec Unix). I look at it this way - at least it's a standard - better than no standards at all. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: archive log curr v. switch logfile
Gene's afraid of R-Man! Gene's afraid of R-Man! Gene you will not believe how simple RMAN is once you start using it... Lisa Koivu Oracle Database TANK Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: archive log curr v. switch logfile I use Alter system archive log current. If your archiver process is caught up, you will get this error message when issuing Alter system archive log all: SQL alter system archive log all; alter system archive log all * ERROR at line 1: ORA-00271: there are no logs that need archiving Just don't like error messages in the logs :). Lisa's method seems the safest, but never had an archiver not keeping up and if I did, that would be an issue to be resolved quickly. Here's my hot backup model with help from list members and Velpuri/Adkoli's Backup/Recovery Book: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Backup controlfile. # 8) Alter system archive log current ; # Archives are backed up separately 2 x day to tape. Gene PS. Confident w/ hot backups, next to conquer RMAN cautiously. [EMAIL PROTECTED] 03/29/02 12:13PM Actually I use alter system archive log all. I saw that if the database was behind with archiving, this would ensure that all logs were written to the arc destination. archive log current only did the most recent. Am I wrong? Please correct me if I am . Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject:RE: archive log curr v. switch logfile I believe alter system archive log current will wait until archiver has successfully archived the file, thus this is the one you would want to use in any backup scripts. - Ethan -Original Message- Sent: Friday, March 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network
RE: Congratulations, Ari! + FYI: 9i usage survey
Congratulations to Ari and all the other Board Members! My vote does count ;) - Kirti -Original Message- Sent: Monday, April 01, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Hi all, Came across this on the IOUG page: Results of the IOUG Board of Directors Election. The Winners are... 13-MAR-02 Michael Abbey - 48.5% of voters Kimberly Floss - 45.6% of voters Karen Langley - 41.5% of voters Ari Kaplan - 40.3% of voters Congratulations to the winners. Michael Abbey, popular speaker, author, and Oracle guru returns to the board. Kimberly Floss and Karen Langley were re-elected by the membership and will continue their efforts on behalf the of the Oracle user community. Ari Kaplan joins the IOUG Board of Directors for the first time. The community looks forward to his insights and contributions. JK: Congratulations, Ari! You owe us one. Results of 9i Migration Survey Completed by OTN and IOUG Members 11-MAR-00 - 20% of respondents have installed Oracle9i. This number has climbed from 10% in July to 28% in November to 43% in January 2002 - 77% of respondents plan to use Oracle9i for production applications within the next 12 months - 41% plan to move all application to 9i, while 37% plan to move some applications, and 22% plan to deploy only new applications on Oracle9i - 74% of respondents rate Oracle9i as very innovative - 52% of respondents plan to migrate non-Oracle databases to 9i John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Joseph S Testa [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: Installing Oracle 9.0.1 on Red Hat Linux 7.2 first time you get the error, open a new window go to $ORACLE_HOME/bin look for genclntsh vi the file, looking for -z defs, remove that part, the -z defs ./genclntsh then hit retry, all should be good. joe [EMAIL PROTECTED] wrote: If you have successfully installed Oracle 9.0.1 on Red Hat 7.2, please let me know what steps you had to take to make it work. I've installed the compatibility libs and glibc stub patch for Oracle 8i, and have successfully installed 8.1.7. The 9i install consistently fails on the ins_plsql.mk makefile. I'll check on MetaLink some more. And yes, I know 7.2 is not yet certified, but it appears from the forums on MetaLink that others have done this. Thanks, Jared -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: License standby database?
Title: RE: License standby database? I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. Jon [EMAIL PROTECTED] -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: License standby database? Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: License standby database?
Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. Jon [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.45 TITLERE: License standby database?/TITLE /HEAD BODY PFONT SIZE=2I believe as long as it is only stand-by, no additional licensing required.nbsp; Only one system is quot;functionalquot; at a time./FONT /P BR PFONT SIZE=2Jon/FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: DENNIS WILLIAMS [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Tuesday, April 02, 2002 10:28 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: License standby database?/FONT /P BR PFONT SIZE=2Can someone tell me - if you have a standby database, must you carry a full/FONT BRFONT SIZE=2Oracle license on it? Thanks./FONT BRFONT SIZE=2Dennis Williams/FONT BRFONT SIZE=2DBA/FONT BRFONT SIZE=2Lifetouch, Inc./FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: DENNIS WILLIAMS/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2/FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
Robert, What part of what I said is hogwash. The part about the DBA's wanting similiar structures across all machine types, or the part about having standards? Huh? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 02, 2002 10:58 AM To: Multiple recipients of list ORACLE-L This is hogwash. OFA perfectly helps to separate the datafiles from different database instances. We run well over 300+ Oracle databases here and the ONLY extension we have to OFA is that I add a /data /control and /redo directory to the file systems for just a little extra protection from possible inode corruption. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 02, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Paul, I live under similiar standards. They make sense here becuase, when one looks at the big picture, they need these types of standards to help the DBA's (there are three of them) to cope with the many many Oracle instances across multiple platforms (NT, Sun Unix, Dec Unix). I look at it this way - at least it's a standard - better than no standards at all. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
RE: Seeking opinions
Tom, I am not oppositting the idea of standard. I implement OFA and other stuff, and everywhere I go the first I do is establish standards. The problem is even with standard in place one should not assume everything will be in place as is should be. Which is the problem I see as Paul described. People are relying on standard more than data dictionary. And like you said when a file is in the wrong place it will stand out like a sore thumb. But the bigger question is what will the other 15 DBAs do about it? If they trust the standard so much they will think it shouldn't be there and without querying data dictionary to confirm it some one might go ahead and delete it. And yes the chance are very small but I don't like to risk it. Richard -Original Message- Sent: Tuesday, April 02, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Richard, In a busy shop, I would think that there is a *less* chance of a DBA making a mistake if all databases across all platforms conformed to the same directory standard. Can you imagine how long it would take to diagnose and fix a problem if every database was set up to a different standard? Mistakes can happen, but at least with standards, if a file is in the wrong place, it would stand out like a sore thumb. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 02, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Hi Paul, How's going? What if someone on the dba group make a mistake (typo or whatever) and put the data file in the wrong place? And other DBAs didn't notice it and work on something. I don't like the idea people assume things will be in the right place because the rule says so. I'd rather trust data dictionary than somethng that has 16 DBA's hands on it. Do they also write they scripts assuming everything is where it should be? Richard Ji -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: Do programmers tune SQL?
Well, I sent this to the list yesterday but it never showed up, trying again. Learn the basics of executing SQL from Java: Statement - basic SQL statement Prepared Statement - precompiled SQL statement (bind variables) Callable Statement - calling database procedures/functions Get the O'Reilly book Java Enterprise in a Nutshell. That book was a lifesaver for me when working with Java developers, as it helped me understand and communicate in terms they understood. Suzy DENNIS WILLIAMS wrote: Oh, I guess I'm a little slow on Monday. I've enjoyed the discussion so far. Very close to my situation. Given my situation - i.e., we haven't had many SQL statement problems, but expecting to receive more with Java, I'm wondering how I can get ahead of the game. I have worked on a set of SQL statement recommendations, simple stuff like make sure screen queries use and index. I am considering creating a checklist form for SQL statements for the developers to use. Like include the listing from EXPLAIN PLAN. Does anyone have any thoughts on this approach? I'm not sure if the developers/management would go for it, but I thought it would be worth asking as a starting point. Everybody is new to Java and a little nervous, so they are probably more open to suggestions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 01, 2002 9:13 AM To: Multiple recipients of list ORACLE-L and your question is? --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: All, We are in transition here at my site. Our primary development tool over the past few years has been a client-server tool named Uniface from Compuware, which does an excellent job of protecting developers from themselves. However, we are switching to Java, and moving more developers from the mainframe to an Oracle-Java system that is being developed. For a Java IDE, it looks like a tool named TogetherSoft. I am concerned that I will need to take a more active role with the developers. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 29, 2002 8:03 PM To: Multiple recipients of list ORACLE-L Greg, You *do* see DBA's doing the bulk of the SQL tuning work in many shops. But it's not necessarily because the developers, or at least some them, can't, or, that many of them don't care (and *many* of them never do give it a thought). I've seen places where the developers begged for the ability to turn on tracing in development, or to have a plan_table and/or the use of autotrace, and were denied. And other cases where the development, testing, and QA environments were so different from production that there was nearly no point. Anyway, just by virtue of their titles, I don't know that a DBA is any better at SQL tuning than a developer or vice versa (and I'm not pointing that comment at you, Greg, but just in general that I don't think the title of DBA or developer makes a difference). It really depends on their backgrounds and skill levels. I've seen, for the most obvious example, many DBA's and developers freak when they see a full table scan, never taking into consideration if that was the appropriate approach. Instead, they just lived by some rule that full table scans are bad. You see lots of things like that. Anyway, as someone who started off as both a DBA and developer, and drifts back and forth between the two and still serving in both roles, I can see both sides. I know DBA's who rant about the developers not giving a flip about performance when they write their code, and in many cases it is true, the issue of performance was never considered. But I also know many developers who *do* care and are hindered from doing so. By the same token, I know a lot of DBA's who are very good at SQL tuning, and tuning and general, and many more who aren't. So, what we can we do? We can work with the developers (and DBA's) and mentor them. We can teach the tricks and efficient styles (whether SQL itself or application design in general). And it really helps if we can provide an environment that mimics production (dollars and budgets make that hard to do in many cases). Sorry for the length, but it touches on something I'm dealing with right now. I'm helping some developers who are getting hammered about why their code performs so poorly in production. Heck, it ran great in all the other environments, there's not much more that they could have done. And yes, I now sit in on the code reviews making suggestions when something could be done better, and testing their code and every SQL statement against production. Often times requires significant work in stubbing out the DML pieces and duplicating the same logic when doing so. But if they aren't given a real
Re: Designer's Table API: Threat or Menace?
Roy, we are using the TAPI on my current project, and haven't seen any significant disadvantages (I'm the DBA, so I would know). Performance is fine. I don't think the number of triggers should be an issue as long as your SYSTEM tablespace is correctly sized. To me, the advantages of generated code far outweigh the possibility that the code isn't the most compact. Paul Baumgartel --- Pardee, Roy E [EMAIL PROTECTED] wrote: Greetings all, Is anyone out there using Oracle Designer's Table API? We're trying to decide whether to use it as opposed to writing our own packages triggers (for things like populating sequence-generated PKs, upcasing VARCHARs, enforcing domains, etc.). From my (admittedly selfish) perspective, any working line of code that I don't have to write/support is a good line of code, but it does look like a *lot* of code to do not so very much. Our DBA is concerned that it's creating unnecessary triggers, will suck down resources unecessarily, server will grind to a halt, etc. My concern is that we'll find out that the TAPI procs are bulky complicated for a reason--we'll decide to chuck them then wind up reinventing them (and maybe not as well as the folks at Oracle). Has anybody out there been over this ground care to make a reccomendation? Thanks! -Roy P.S. In case it's important, we're using Designer 6.0 to create OAS-deployed Oracle Forms Reports to run against a 9i db. Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
My apologies, I was reading the post *REALLY* fast (on my way to my daily deluge of meetings) and mis-read what you said completely. Upon re-reading, I agree 100% with what you said about standards. Again, removing foot from mouth. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 02, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Robert, What part of what I said is hogwash. The part about the DBA's wanting similiar structures across all machine types, or the part about having standards? Huh? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 02, 2002 10:58 AM To: Multiple recipients of list ORACLE-L This is hogwash. OFA perfectly helps to separate the datafiles from different database instances. We run well over 300+ Oracle databases here and the ONLY extension we have to OFA is that I add a /data /control and /redo directory to the file systems for just a little extra protection from possible inode corruption. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 02, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Paul, I live under similiar standards. They make sense here becuase, when one looks at the big picture, they need these types of standards to help the DBA's (there are three of them) to cope with the many many Oracle instances across multiple platforms (NT, Sun Unix, Dec Unix). I look at it this way - at least it's a standard - better than no standards at all. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, April 01, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Thanks, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: Seeking opinions
I agree. I think that some people don't understand OFA's intentions. First of all, it _is_ a standard, meant to provide great flexibility. The reason mount points are to be named in a generic fashion is to allow any type of file to reside on them. Any number of file types can happily coexist under their own appropriately named subdirectories. Under OFA, database files can be easily identified by ls /u???/oradata/$ORACLE_SID; the file name ought to include the name of the tablespace to which the file belongs. Richard's point about a file that gets misnamed is well-taken. The only identification of datafiles that matters is the data dictionary. Rely on anything else and you're asking for trouble. Thanks to all for their comments. --- Freeman, Robert [EMAIL PROTECTED] wrote: It sounds to me that whoever architected this approach really didn't understand the idea of metadata and the flexibility that OFA provides in terms of tuning (I'm not limited to specific disks because I have customer data) and performance. My 2 cents... = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: EMC question
Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is right now. It has been rumored that microcode 5x68 or 5x69, will do that. Remains to be seen. So all the EMC striping does right now is to alleviate the problem of read-intensive operations not hammering a single drive, provided the data is spread across all the underlying hypers. I am not very familiar with the Engenuity product offering, hence cannot comment on that, but from what I have heard, it is a software-based volume management product. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: It looks like it's available now. This is from: ResourcePak for Windows Version 3.2 Product Guide Symmetrix Microcode level 5x65 includes support for concatenated (contiguous) and striped metavolumes. Noncontiguous metavolumes (including striped) require EMC Enginuity(tm) (5x66 microcode) or higher. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/1/02 5:38 PM Waleed list, I researched this issue recently and found out that the meta volume was concatenating a bunch of hyper volume. As you know, concatenation is NOT striping. The hyper volumes get filled with data one after another, eventually giving you the simulation of a striped volume, when all hypers are filled with data. I don't know about the single-host vs. multi-host addressibility issue. There are plans for supporting true striped volumes in microcode level 68 or 69. From some reliable sources that does not look like it will happen any time soon. So until then, you should consider created mirrored hyper volumes within EMC (RAID 1) and then create a striped volume using Veritas Volume Manager, giving you a RAID 1+0 configuration, which is ideal. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: Four years ago the only hardware striping available on EMC I was aware of was RAID-S. Recently researching striping ideas on EMC and was told that we can achieve raid0+1 hardware striping on EMC. I was told that EMC has some layer called meta-volume that is made of many other hyper-volumes. Told also that meta-volumes could be raid-0 (striped) and it's not a single-host addressable volume. Does anybody know anything about this? Can we really get a hardware striped volume using EMC? Any limitations there? Thanks. Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -- = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
TEST PLEASE DELETE
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: One sql statement
select sum(decode(balamce,'D',amount,-1*amount) from table ; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 01, 2002 9:58 PM Suppose I have table structure like this: amount Numeric(10) balance VARCHAR(1) the balance column can only have one of 'D' or 'C' I want to sum the amount of Debet and Credit on ONE SQL statement. How my SQL statement should be? Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferry Situmorang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seeking opinions
Robert, Tell me a little more about potential for inode corruption and how this helps? Never heard of that one before. I stick it all in /x/oradata/$ORACLE_SID and distinguish my files by .dbf, .ctl, .arc and .rdo. Also are yall mostly Oracle or are you running anything else? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 9:58 AM To: Multiple recipients of list ORACLE-L This is hogwash. OFA perfectly helps to separate the datafiles from different database instances. We run well over 300+ Oracle databases here and the ONLY extension we have to OFA is that I add a /data /control and /redo directory to the file systems for just a little extra protection from possible inode corruption. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
To me, there is a potential problem with having the software, administrative files (init.ora, etc), and database files all under one tree. Has no one else needed to do an rm -r in an admin or datafile directory to delete an old database? While there is a certain level of trust that must be given to SAs and DBAs, I try to prevent human error -- especially when that human is me! If our datafiles all reside under the /oracle directory (under several mountpoints) while the software and admin directories are under another, it becomes that much more difficult to accidentally mangle files unintentionally. And all this aside, Oracle doesn't support OFA in any way on OpenVMS. Trying to implement it there is an excersize in futility. And cause for excessive beer consumption. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Seeking opinions I agree. I think that some people don't understand OFA's intentions. First of all, it _is_ a standard, meant to provide great flexibility. The reason mount points are to be named in a generic fashion is to allow any type of file to reside on them. Any number of file types can happily coexist under their own appropriately named subdirectories. Under OFA, database files can be easily identified by ls /u???/oradata/$ORACLE_SID; the file name ought to include the name of the tablespace to which the file belongs. Richard's point about a file that gets misnamed is well-taken. The only identification of datafiles that matters is the data dictionary. Rely on anything else and you're asking for trouble. Thanks to all for their comments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: License standby database?
yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. Jon [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.45 TITLERE: License standby database?/TITLE /HEAD BODY PFONT SIZE=2I believe as long as it is only stand-by, no additional licensing required.nbsp; Only one system is quot;functionalquot; at a time./FONT /P BR PFONT SIZE=2Jon/FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: DENNIS WILLIAMS [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Tuesday, April 02, 2002 10:28 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: License standby database?/FONT /P BR PFONT SIZE=2Can someone tell me - if you have a standby database, must you carry a full/FONT BRFONT SIZE=2Oracle license on it? Thanks./FONT BRFONT SIZE=2Dennis Williams/FONT BRFONT SIZE=2DBA/FONT BRFONT SIZE=2Lifetouch, Inc./FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: DENNIS WILLIAMS/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2/FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Database shut itself down
I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lietral
= Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seeking opinions
Paul Baumgartel wrote: Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) taken to the next level. I disagree with their approach, and I'd be interested to see what list members think. The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). System datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004. User datafiles are allowed on /a001 and /a002, tables and indexes, respectively. To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think? Paul, Your story reminds me of a shell script I have seen which was the pride of its author and was 'fully configurable'. There was a configuration file containing assignments to about 200 variables, including those which could have been derived from others, and the great majority of which was used only once. There is a fine line between extreme logic and insanity, and wanting to regulate anything down to the most minute detail is a sure recipe for pushing people to trespass the rules. My guess is that some day space will be lacking under /a001 or /a002, or that, because of a failing batch, the rollback/undo tablespace will be massively increased, past the then current capacity of /u004. This will probably end up with soft links, and that's when one will discover that the 'find' statements in the script lack '-follow'. The road to hell ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
O/S-Error: (OS 5) Access is denied.' This is the most important error message, talk to NT admins to see if anyone changes any privileges ... my guess, someone did. 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, April 02, 2002 2:03 PM To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Database shut itself down - FIXED
I had to do a STARTUP MOUNT RECOVER DATABASE That fixed it and I'm back up and running. Thanks, Dave -Original Message- Sent: Tuesday, April 02, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
Could any of you please summarize all the points once the discussion is over. Thanks, Ashoke -Original Message- Sent: Tuesday, April 02, 2002 11:14 AM To: Multiple recipients of list ORACLE-L I agree. I think that some people don't understand OFA's intentions. First of all, it _is_ a standard, meant to provide great flexibility. The reason mount points are to be named in a generic fashion is to allow any type of file to reside on them. Any number of file types can happily coexist under their own appropriately named subdirectories. Under OFA, database files can be easily identified by ls /u???/oradata/$ORACLE_SID; the file name ought to include the name of the tablespace to which the file belongs. Richard's point about a file that gets misnamed is well-taken. The only identification of datafiles that matters is the data dictionary. Rely on anything else and you're asking for trouble. Thanks to all for their comments. --- Freeman, Robert [EMAIL PROTECTED] wrote: It sounds to me that whoever architected this approach really didn't understand the idea of metadata and the flexibility that OFA provides in terms of tuning (I'm not limited to specific disks because I have customer data) and performance. My 2 cents... = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Literal SQL and sys.dual
I am working on a database optimization project. My Shared pool is filled with SQL like select 0 from dual; select 1/1 from dual; select 1 - 1/(2 + 2) from dual; I tried to use the bind variables to minimize the literal SQL. However I need a different SQL script for each case. select :b1 from dual; select :b1/:b2 from dual; select :b1 - :b2/(:b3 + :b4) from dual; first one will handle all cases for b1 from 0 to any number which is good. And second sql will handle all the cases for any number for b1 and b2. So I do reduce the literal SQL. However, I need to know ahead of time what type of data I am calculating and then use the appropriate SQL. I think the easy solution would be to use arithmetic. That is to pass the string like ( 1 + 1 / (2 -2) ) to some function that can return me the result of this sting. So I would not be using SQL script, to minimize SQL execution, sys.dual contention or literal SQL filling shared pool and causing both library cache and shared pool. Not to mention saving in CPU processing by not parsing SQL scripts. Anybody, aware of such function in PL/SQL? Is there any other way to do calculations other than 'select 1 + 1 from dual' ? I would really appreciate if you could let me know. Thanks Mohammed Shakir = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ticket tracking system
I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Warehouse Tools
Hi All - This is for DBAs who have participated in a DW project: what kind of tools did you use for design, ETL, Query etc. I know Oracle has a data warehouse builder but it doesn't seem to be widely used. What is the most popular tools out there for DW construction and what is the trend? TIA Dennis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
Permissions set wrong on the file ??? Database started up by the wrong id ?? -Original Message- Sent: Tuesday, April 02, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
Perhaps another program tied up the file - virus scan, backup software. My Oracle on NT is easier killed that way - so I scream at the SA. Mine usually restarts and recovers fine afterward though. Mike -Original Message- Sent: Tuesday, April 02, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
It's all fixed. And of course the network guys deny everything. Dave -Original Message-From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 2:13 PMTo: Farnsworth, Dave; [EMAIL PROTECTED]Subject: Re: Database shut itself down Dave, Maybe I'm way off base here, but it looks like there is some problem at the OS level. Is that file still there and writable? Stephen [EMAIL PROTECTED] 04/02/02 12:03PM I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error.Tue Apr 02 10:47:40 2002KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to fileO/S-Error: (OS 5) Access is denied.'DBW0: terminating instance due to error 1242Instance terminated by DBW0, pid = 287This is a new for me. Any ideas what I am dealing with?Thanks,Dave--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Farnsworth, Dave INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Database shut itself down
Dave Oracle had a problem with written to the file J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF this was happened because Oracle did not have proper permission in NT to write to the file. There are many reasons that could give this problem 1) the file was in shear 2) the acl was changed 3) oracle was started as a another user Farnsworth, Dave wrote: I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database shut itself down - FIXED
Did the original problem happened after you started the database? If that's the case, is it possible, that the file in question was opened by some other application at the time you were starting the database? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 2:48 PM I had to do a STARTUP MOUNT RECOVER DATABASE That fixed it and I'm back up and running. Thanks, Dave -Original Message- Sent: Tuesday, April 02, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: License standby database?
Thanks to Rachel, Dick, Jon, and everyone for clarifying this issue. The answer falls into a disturbing pattern I'm seeing in Oracle licensing -- lots of confusion, conflicting opinions, and in the end a large invoice from Oracle. I participated in a META Group teleconference this morning. A number of press reporters participated also, so you will probably be seeing press releases over the next few days. META offered pretty good proof that Oracle is interpreting the named licensing to be that if your data warehouse is being loaded with data from another system that has 200 users, then your data warehouse needs that many named user licenses. -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. Jon [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.45 TITLERE: License standby database?/TITLE /HEAD BODY PFONT SIZE=2I believe as long as it is only stand-by, no additional licensing required.nbsp; Only one system is quot;functionalquot; at a time./FONT /P BR PFONT SIZE=2Jon/FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: DENNIS WILLIAMS [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/F ONT BRFONT SIZE=2Sent: Tuesday, April 02, 2002 10:28 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: License standby database?/FONT /P BR PFONT SIZE=2Can someone tell me - if you have a standby database, must you carry a full/FONT BRFONT SIZE=2Oracle license on it? Thanks./FONT BRFONT SIZE=2Dennis Williams/FONT BRFONT SIZE=2DBA/FONT BRFONT SIZE=2Lifetouch, Inc./FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: DENNIS WILLIAMS/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2 /FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Ticket tracking system
use the undelete command :) [EMAIL PROTECTED] 04/02/02 02:38PM I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database shut itself down
On Tue, Apr 02, 2002 at 11:03:21AM -0800, Farnsworth, Dave wrote: I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file Dr. Steve Adams says: This is a reasonably well known problem on NT. Generally the error is seen when a routine NT file system backup takes a byte-range lock on one of the Oracle datafiles in that file system in order to back it up. There are many solutions, such as configuring the backup software to skip open files, or at least not to lock them; or you can use ocopy to copy the datafiles and back those up instead; or you can shutdown the instance; and so on. O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database shut itself down
Dave, Maybe I'm way off base here, but it looks like there is some problem at the OS level. Is that file still there and writable? Stephen [EMAIL PROTECTED] 04/02/02 12:03PM I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error.Tue Apr 02 10:47:40 2002KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to fileO/S-Error: (OS 5) Access is denied.'DBW0: terminating instance due to error 1242Instance terminated by DBW0, pid = 287This is a new for me. Any ideas what I am dealing with?Thanks,Dave--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Farnsworth, Dave INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: EMC question
HI Gaja list, I am trying to find the truth here! I was told by the storage group that EMC has striping now and this what I'm researching. Gaja, what you described as a problem during WRITES to striped EMC is a typical procedure in any striped volumes. There is a mid layer that has to map logical I/O addresses to physical disk addresses. If you are using Veritas LVM then all reads/writes requests will be queued to the LVM and will do exactly as you mentioned. There is a queue but the difference is big. You have a queue with many servers serving the queue requests simultaneously. Please check powerlink.emc.com Regards, Waleed -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is right now. It has been rumored that microcode 5x68 or 5x69, will do that. Remains to be seen. So all the EMC striping does right now is to alleviate the problem of read-intensive operations not hammering a single drive, provided the data is spread across all the underlying hypers. I am not very familiar with the Engenuity product offering, hence cannot comment on that, but from what I have heard, it is a software-based volume management product. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: It looks like it's available now. This is from: ResourcePak for Windows Version 3.2 Product Guide Symmetrix Microcode level 5x65 includes support for concatenated (contiguous) and striped metavolumes. Noncontiguous metavolumes (including striped) require EMC Enginuity(tm) (5x66 microcode) or higher. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/1/02 5:38 PM Waleed list, I researched this issue recently and found out that the meta volume was concatenating a bunch of hyper volume. As you know, concatenation is NOT striping. The hyper volumes get filled with data one after another, eventually giving you the simulation of a striped volume, when all hypers are filled with data. I don't know about the single-host vs. multi-host addressibility issue. There are plans for supporting true striped volumes in microcode level 68 or 69. From some reliable sources that does not look like it will happen any time soon. So until then, you should consider created mirrored hyper volumes within EMC (RAID 1) and then create a striped volume using Veritas Volume Manager, giving you a RAID 1+0 configuration, which is ideal. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: Four years ago the only hardware striping available on EMC I was aware of was RAID-S. Recently researching striping ideas on EMC and was told that we can achieve raid0+1 hardware striping on EMC. I was told that EMC has some layer called meta-volume that is made of many other hyper-volumes. Told also that meta-volumes could be raid-0 (striped) and it's not a single-host addressable volume. Does anybody know anything about this? Can we really get a hardware striped volume using EMC? Any limitations there? Thanks. Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -- = Gaja Krishna Vaidyanatha Director, Storage Management Products,
RE: RE: License standby database?
Not sure this is correct Rachel. I sat in a conference call today with some folks and an Oracle rep and it was stated that any type of HA software being used would require additional licenses for the all possible servers in the failover cluster. So even if Oracle is not running on server B until A fails I would need a license for B. Of course the whole reason for the call was to discuss Oracles evolving licensing model. Can anyone else confirm or deny? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
You are dealing with a problem. From here (Trumbull, CT) it looks that your problem is lack of permission to write to the database files or the files that reside on a remote drive (mounted through the network), which is a big no-no that you should be aware of. -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 2:03 PM To: Multiple recipients of list ORACLE-L Subject: Database shut itself down I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ticket tracking system
Perhaps put a trigger on the ticket table that will insert a row into another table, which can then be queried from your app? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject: Ticket tracking system I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ticket tracking system
Instead of deleting, set a flag which indicated the ticket is open or closed. I believe you or someone else asked the same question a few weeks ago and received a similar answer (as above). 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, April 02, 2002 2:38 PM To: Multiple recipients of list ORACLE-L I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: Database shut itself down
Check and see if your J disk is full. On your Win2k desktop, find the My Computer icon. Right click and choose explore. Find the J drive and right click; choose properties. If the disk is full, that's your problem. On the other hand, a J drive could be a network mounted drive. If it is, there may be a timing issue. Oracle does not normally support network mounted drives. Farnsworth, DaveTo: Multiple recipients of list ORACLE-L DFarnsworth [EMAIL PROTECTED] @Ashleyfurnitcc: ure.com Subject: Database shut itself down Sent by: root 04/02/2002 02:03 PM Please respond to ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ticket tracking system
David Don't use delete use a update to mark the row deleted. This has the advantaged that it is possible to track what happened to a ticket (call it journal or history) Nguyen, David M wrote: I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database shut itself down
Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Literal SQL and sys.dual
Mohammed Shakir wrote: I am working on a database optimization project. My Shared pool is filled with SQL like select 0 from dual; select 1/1 from dual; select 1 - 1/(2 + 2) from dual; I tried to use the bind variables to minimize the literal SQL. However I need a different SQL script for each case. select :b1 from dual; select :b1/:b2 from dual; select :b1 - :b2/(:b3 + :b4) from dual; first one will handle all cases for b1 from 0 to any number which is good. And second sql will handle all the cases for any number for b1 and b2. So I do reduce the literal SQL. However, I need to know ahead of time what type of data I am calculating and then use the appropriate SQL. I think the easy solution would be to use arithmetic. That is to pass the string like ( 1 + 1 / (2 -2) ) to some function that can return me the result of this sting. So I would not be using SQL script, to minimize SQL execution, sys.dual contention or literal SQL filling shared pool and causing both library cache and shared pool. Not to mention saving in CPU processing by not parsing SQL scripts. Anybody, aware of such function in PL/SQL? Is there any other way to do calculations other than 'select 1 + 1 from dual' ? I would really appreciate if you could let me know. Thanks Mohammed Shakir = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) Mohammed, Don't you think, before starting with a PL/SQL function of death, that it *might* be easier to check the code and see where these statements, which are unlikely to be functional requirements, are used? Rewriting the PL/SQL code around them is probably the most efficient way to get rid of them. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Data Warehouse Tools
-- [EMAIL PROTECTED] on 04/02/02 12:03:27 -0800 Hi All - This is for DBAs who have participated in a DW project: what kind of tools did you use for design, ETL, Query etc. I know Oracle has a data warehouse builder but it doesn't seem to be widely used. What is the most popular tools out there for DW construction and what is the trend? Most of the ETL I design is done with Ab Initio, less often Informatica. Ab Initio is the best tool going for scaleable parallel processing and distribution across multiple nodes; Informatica has some advantages with lower throughput and messier metadata; its licensing is also simpler. I tend to use Red Brick for data warehousing. Main reasons are offline loading of data, star and target indexes and much simpler data management -- mainly due to lack of rollback processing and ability to add phyisical storage without effecting data access. Now that Oracle at least has partitioning it gets more usable for warehousing but still needs too much care and feeding, and doesn't support offline loads. For clickstream processing Oracle with partitioning is a nice combination. In either case, DBI seems to be the most portable way to talk to various databases, especially for combining data from multiple sources (e.g., feeding selection criteria back from a Red Brick warehouse to an Oracle OLTP system). enjoi. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ticket tracking system
Don't delete the row(s) you'll need later. Perhaps add a column called ticket_status char(1), that gets a default value of 'O' (open). When you close the ticket change the value to 'C' (closed). To reopen change it back to 'O'. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 11:38 AM I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ticket tracking system
Don't delete. Just mark it as closed. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 2:38 PM I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Seeking opinions
It's been a while since I've been an admin guy but let me try... Every file, directory, etc... on a file system is represented by an inode on the file system. Think of an inode (in a simple term) as another file or a pointer if you will. It contains information on that structure (rights, who owns it, the time stamp for the file, and so on...) The data block addresses that are assigned to the file are contained in the inode. The OS then uses the inode to locate the file or directory and to store information on the file or directory. It is possible for that inode to become corrupted (e.g. system crash) and I've seen 2 cases of it in the 15 years I've been doing this (both on SCO Unix). File systems that journal seem to be safer, and I've never seen it happen on such a file system but that doesn't mean it can't happen!. I've read cases of OS bugs on earlier AIX versions that could cause Inode corruption in specific cases, but I've never experienced the problem in AIX or SUN. Corruption of an inode can lead to loss of directories or data files, and therefore I like to limit the size of directories based on a number of factors, such as MTTR one directory, the SLA that I have with the customer and so on. So, by keeping my redo, control files and datafiles in separate dirs under /u0x, I reduce the likelihood of inode corruption a bit, but it is still there in the form of /u0x or the other directories falling below it. HTH RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 02, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Robert, Tell me a little more about potential for inode corruption and how this helps? Never heard of that one before. I stick it all in /x/oradata/$ORACLE_SID and distinguish my files by .dbf, .ctl, .arc and .rdo. Also are yall mostly Oracle or are you running anything else? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 9:58 AM To: Multiple recipients of list ORACLE-L This is hogwash. OFA perfectly helps to separate the datafiles from different database instances. We run well over 300+ Oracle databases here and the ONLY extension we have to OFA is that I add a /data /control and /redo directory to the file systems for just a little extra protection from possible inode corruption. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Literal SQL and sys.dual
One way to calculate select (1+1) from dual; is myvar := 1+1;. Trust me, it is more efficient. Most arithmetic functions can be used in pl/sql, without having to use dual. Question for you, why do you think you need to go to database, when you are NOT accessing anything from the database? 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! ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
sqlplus connect too slow under load both from DB APP Servers
-Original Message- Sent: Tuesday, April 02, 2002 9:15 AM To: 'Karl Vogel'; '[EMAIL PROTECTED]' Servers Hi Because of Increase of SEMAPHORES ( semmns to 100,000 from 20,000 ) the Slowdown of sqlplus Connect to Database started Occuring after 1050 Process Connections Instead of 850 (Previously) . We are yet to try the Settings of Reducing swapfs_minfree , noatime Option with mount , inode cache Hit ratio as advised by you Below . I will Revert to you . Thanks Indeed Vivek -Original Message- Sent: Thursday, March 28, 2002 1:26 PM To: 'Karl Vogel' Servers On Adding the Following Parameters to the /etc/system the Slowdown of sqlplus Connect to the Database Started Occuring after 850 Process Connections Instead of 500 (Previously) set tcp:tcp_conn_hash_size=262144 set rlim_fd_max=8092 set rlim_fd_cur=8092 set autoup=900 set tune_t_fsflushr=1 set bufhwm=8000 We Are Considering INCREASING the Semaphores to the Following Values :- - /etc/system File on the DB APP Servers :- set shmsys:share_page_table=1 set maxuprc=2 set maxusers=1500 set shmsys:shminfo_shmseg=200 set shmsys:shminfo_shmmin=2 set shmsys:shminfo_shmmni=5000 set shmsys:shminfo_shmmax=25769803776 forceload: sys/shmsys forceload: sys/shmsys set semsys:seminfo_semmsl=1000 set semsys:seminfo_semaem=16384 set semsys:seminfo_semmap=70 set semsys:seminfo_semmni=6 set semsys:seminfo_semmns=10 set semsys:seminfo_semmnu=1 set semsys:seminfo_semume=100 set semsys:seminfo_semvmx=32767 Thanks indeed for the Very Valuable Suggestions Regards Vivek -Original Message- Sent: Wednesday, March 27, 2002 12:11 AM To: VIVEK_SHARMA Servers On Tue, 26 Mar 2002 17:06:21 +0530, VIVEK_SHARMA [EMAIL PROTECTED] said: V Machine Model = E6500 V No. of CPUs = 20 V RAM = 40 GB V SWAP = 4 GB You may need more swap. I've had the best luck with multiple 1-Gbyte swap partitions on different devices. V After Migration from Oracle 7.3.4 to 8.1.7.2 on Solaris 2.8 sqlplus V becomes SLOW as the Number of Unix Users Connecting to the Database V Increases to about 400 whereafter even after all users are logged out V the response continues to be Slow even after the machine is Booted Some suggestions are below. You may be spending too much time scanning memory for dirty pages. -- Karl Vogel ASC/YCOA, Wright-Patterson AFB, OH 45433 [EMAIL PROTECTED] http://www.dnaco.net/~vogelke I am not the reincarnation of Sammy Davis Jr. --written on blackboard by Bart Simpson - http://docs.sun.com/ab2/coll.709.2/SOLTUNEPARAMREF/ Overview of Solaris System Tuning Tuning a Solaris System Tuning the Solaris Kernel Special Structures Viewing System Configuration Information kstats Solaris Kernel Tunables NFS Tunable Parameters - If you have an application that's an incredible swap hog, or the system is really slowing down, try adding the lines below to /etc/system and rebooting. I run with these settings and they've never caused me trouble. * * Swap * System keeps 1/8th of all memory for swap, which is too much for * a 4GB system. Reduce that to 32 Mbytes (4096 8K pages). set swapfs_minfree=4096 * * Memory management * * http://www.carumba.com/talk/random/tuning-solaris-checkpoint.txt * Tuning Solaris for FireWall-1 * Rob Thomas [EMAIL PROTECTED] * 14 Aug 2000 * * On firewalls, it is not at all uncommon to have quite a bit of * physical memory. However, as the amount of physical memory is * increased, the amount of time the kernel spends managing that * memory also increases. During periods of high load, this may * decrease throughput. * * To decrease the amount of memory fsflush scans during any scan * interval, we must modify the kernel variable autoup. The default * is 30. For firewalls with 128MB of RAM or more, increase this * value. The end result is less time spent managing buffers, * and more time spent servicing packets. set autoup = 120 - Run mount to see how your filesystems are set up. You can mount filesystems with noatime turned on, meaning don't bother updating the access time whenever a file is opened. We use this under Solaris-8, and it makes a *huge* difference if you're doing something to a large number of small or medium sized files. Check the size of your inode caches, which keep track of previously-accessed files. Run the DNLC script below as root to see your hit-rate percentage. If it's under 90-95%, you need to up the cache size. The easiest way to do that is setting maxusers in /etc/system to something like 2048. --- #!/bin/sh # # NAME: #dnlc # #
Re: Literal SQL and sys.dual
Why don't you do: variable1 := 1+ 1; instead of select (1+1) into variable1 from dual? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 2:03 PM I am working on a database optimization project. My Shared pool is filled with SQL like select 0 from dual; select 1/1 from dual; select 1 - 1/(2 + 2) from dual; I tried to use the bind variables to minimize the literal SQL. However I need a different SQL script for each case. select :b1 from dual; select :b1/:b2 from dual; select :b1 - :b2/(:b3 + :b4) from dual; first one will handle all cases for b1 from 0 to any number which is good. And second sql will handle all the cases for any number for b1 and b2. So I do reduce the literal SQL. However, I need to know ahead of time what type of data I am calculating and then use the appropriate SQL. I think the easy solution would be to use arithmetic. That is to pass the string like ( 1 + 1 / (2 -2) ) to some function that can return me the result of this sting. So I would not be using SQL script, to minimize SQL execution, sys.dual contention or literal SQL filling shared pool and causing both library cache and shared pool. Not to mention saving in CPU processing by not parsing SQL scripts. Anybody, aware of such function in PL/SQL? Is there any other way to do calculations other than 'select 1 + 1 from dual' ? I would really appreciate if you could let me know. Thanks Mohammed Shakir = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ticket tracking system
Manager to David... David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true? ok enough of that let's ponder some possible solutions... 1. Have everyone print out a copy of their ticket and then submit it back to you to re-enter if they want to re-open it. 2. Use log miner to log your archive logs. Find the SQL to recreate the ticket then run it again against the database. 3. This one is really just a better idea for #1...have everyone do a print screen of each ticket then create a database that allows people to upload the picture of the ticket. Save those and you can refer to them if you need to re-create a ticket. 4. This last solution is really dumb but also might work...instead of deleting the record perhaps you could just add a status column to the table and then mark it as closed. Then you could re-open it using an update statement. - Ethan -Original Message- Sent: Tuesday, April 02, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail. Maybe this is a nice 'feature' but it doesn't leave much room for testing br Lisa Koivu Oracle Database Brick House - 36-54-36 Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: John Hallas [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: Database shut itself down Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ticket tracking system
Thank you all very much for different advices. I will give it a try. Regards, David -Original Message- Sent: Tuesday, April 02, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Don't delete the row(s) you'll need later. Perhaps add a column called ticket_status char(1), that gets a default value of 'O' (open). When you close the ticket change the value to 'C' (closed). To reopen change it back to 'O'. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 11:38 AM I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ticket tracking system
Solution 4 is not dumb. We use it frequently - it allows retrieval of tickets marked as closed as well as providing a bit of history for the ticket. If you use this technique, David, you must keep in mind that sooner or later you must actually delete the old closed tickets. We generally set up a purge schedule that removes any closed items after they reach a certain age limit. We also have an archive schedule that places a copy of any changed item on CD-ROM on a daily interval. This allows us to retrieve any ticket, if necessary - though it requires operator intervention to reload the ticket. - Ron -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ticket tracking system Manager to David... David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true? ok enough of that let's ponder some possible solutions... 1. Have everyone print out a copy of their ticket and then submit it back to you to re-enter if they want to re-open it. 2. Use log miner to log your archive logs. Find the SQL to recreate the ticket then run it again against the database. 3. This one is really just a better idea for #1...have everyone do a print screen of each ticket then create a database that allows people to upload the picture of the ticket. Save those and you can refer to them if you need to re-create a ticket. 4. This last solution is really dumb but also might work...instead of deleting the record perhaps you could just add a status column to the table and then mark it as closed. Then you could re-open it using an update statement. - Ethan -Original Message- Sent: Tuesday, April 02, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.0.5 -- 8.1.7 apps upgrade
Looking into how to do this. The 8.0.5 database is on NT. The 8.1.7 is on Windows2000. I thought I could: - shut down database on 8.0.5 (on NT) - copy datafiles to windows 2000 server. - start 8.1.7 service on windows2000 server - run cat08005.sql scripts on windows2000 server - finish other tasks This way I could move the database and upgrade in 1 step. Oracle is saying I cannot do it this way. They are stating I must Migrate the Database from 805 to 817 on a Supported Platform and THEN move the database from one machine to another. To do this, I will then have to install 8.1.7 on my current production server (NT), do the upgrade and then move the database to the new windows2000 server. Is there a better way? Thanks in advance. John Fedock K Line America, Inc. [EMAIL PROTECTED] www.kline.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fedock, John (KAM.RHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ticket tracking system
I better refrain from kidding in the future... :) Solution 5 was... 5. Get an infinite number of monkeys to type on an infinite number of keyboards opening an infinite number of tickets, eventually the correct ticket will be opened up. Don't place your redo logs on RAID 5 devices, this could cause a bottleneck during this period. - E -Original Message- Sent: Tuesday, April 02, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Solution 4 is not dumb. We use it frequently - it allows retrieval of tickets marked as closed as well as providing a bit of history for the ticket. If you use this technique, David, you must keep in mind that sooner or later you must actually delete the old closed tickets. We generally set up a purge schedule that removes any closed items after they reach a certain age limit. We also have an archive schedule that places a copy of any changed item on CD-ROM on a daily interval. This allows us to retrieve any ticket, if necessary - though it requires operator intervention to reload the ticket. - Ron -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ticket tracking system Manager to David... David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true? ok enough of that let's ponder some possible solutions... 1. Have everyone print out a copy of their ticket and then submit it back to you to re-enter if they want to re-open it. 2. Use log miner to log your archive logs. Find the SQL to recreate the ticket then run it again against the database. 3. This one is really just a better idea for #1...have everyone do a print screen of each ticket then create a database that allows people to upload the picture of the ticket. Save those and you can refer to them if you need to re-create a ticket. 4. This last solution is really dumb but also might work...instead of deleting the record perhaps you could just add a status column to the table and then mark it as closed. Then you could re-open it using an update statement. - Ethan -Original Message- Sent: Tuesday, April 02, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
Unix at command ???
Hi all, I'd like to run a file (r2) at 15:10 Apr 2. Below was what I did and I could not get out of at normally. /export/home/oracle/test$ at 15:10 Apr 2 at r2 at EOF at EOF at EOT at EOT at ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2 I tried EOF according to the on-line doc, and also tried EOT, but none works. Finally I used Control Z to get out of at. I was out, but the script file didn't run. So what's the correct syntax to run the command at a specific date, time? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
who compiled this proc
How to find which database user and ip-address compiled this stored proc ? -Bp
Re:RE: RE: License standby database?
Dennis, You've hit on the three constants of life, death, taxes, and Oracle's bill. Actually I think the last causes the first. Dick Goulet Reply Separator Author: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 4/2/2002 12:33 PM Thanks to Rachel, Dick, Jon, and everyone for clarifying this issue. The answer falls into a disturbing pattern I'm seeing in Oracle licensing -- lots of confusion, conflicting opinions, and in the end a large invoice from Oracle. I participated in a META Group teleconference this morning. A number of press reporters participated also, so you will probably be seeing press releases over the next few days. META offered pretty good proof that Oracle is interpreting the named licensing to be that if your data warehouse is being loaded with data from another system that has 200 users, then your data warehouse needs that many named user licenses. -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker [EMAIL PROTECTED] Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time. Jon [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.45 TITLERE: License standby database?/TITLE /HEAD BODY PFONT SIZE=2I believe as long as it is only stand-by, no additional licensing required.nbsp; Only one system is quot;functionalquot; at a time./FONT /P BR PFONT SIZE=2Jon/FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: DENNIS WILLIAMS [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/F ONT BRFONT SIZE=2Sent: Tuesday, April 02, 2002 10:28 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: License standby database?/FONT /P BR PFONT SIZE=2Can someone tell me - if you have a standby database, must you carry a full/FONT BRFONT SIZE=2Oracle license on it? Thanks./FONT BRFONT SIZE=2Dennis Williams/FONT BRFONT SIZE=2DBA/FONT BRFONT SIZE=2Lifetouch, Inc./FONT BRFONT SIZE=2[EMAIL PROTECTED]/FONT /P PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: DENNIS WILLIAMS/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2 /FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official
RE: EMC question
Take a look at this pdf file and search for 'microcode 5265' : http://powerlink.emc.com/MediumFreq/21108_Symmetrix_3832_Installation_Manual .pdf?_requestid=260 Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is right now. It has been rumored that microcode 5x68 or 5x69, will do that. Remains to be seen. So all the EMC striping does right now is to alleviate the problem of read-intensive operations not hammering a single drive, provided the data is spread across all the underlying hypers. I am not very familiar with the Engenuity product offering, hence cannot comment on that, but from what I have heard, it is a software-based volume management product. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: It looks like it's available now. This is from: ResourcePak for Windows Version 3.2 Product Guide Symmetrix Microcode level 5x65 includes support for concatenated (contiguous) and striped metavolumes. Noncontiguous metavolumes (including striped) require EMC Enginuity(tm) (5x66 microcode) or higher. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/1/02 5:38 PM Waleed list, I researched this issue recently and found out that the meta volume was concatenating a bunch of hyper volume. As you know, concatenation is NOT striping. The hyper volumes get filled with data one after another, eventually giving you the simulation of a striped volume, when all hypers are filled with data. I don't know about the single-host vs. multi-host addressibility issue. There are plans for supporting true striped volumes in microcode level 68 or 69. From some reliable sources that does not look like it will happen any time soon. So until then, you should consider created mirrored hyper volumes within EMC (RAID 1) and then create a striped volume using Veritas Volume Manager, giving you a RAID 1+0 configuration, which is ideal. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: Four years ago the only hardware striping available on EMC I was aware of was RAID-S. Recently researching striping ideas on EMC and was told that we can achieve raid0+1 hardware striping on EMC. I was told that EMC has some layer called meta-volume that is made of many other hyper-volumes. Told also that meta-volumes could be raid-0 (striped) and it's not a single-host addressable volume. Does anybody know anything about this? Can we really get a hardware striped volume using EMC? Any limitations there? Thanks. Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -- = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ:
RE: Cold NT backups
Use XCOPY. -- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Rusnak, George A. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 06:58 AM To: Multiple recipients of list ORACLE-L Subject: Cold NT backups Group, We are doing a cold backup to a remote server. I am using OCOPY that fails intermittently with the following message: OCOPY - Insufficient disk space on target drive There is more than sufficient space on the drive to hold the file. I filed a TAR and was told that the error message is generic in nature and they could not tell me exactly what is failing. Can anyone PLEASE give me some suggestions. The file is always SYSTEM01.DBF. All the rest of the files copy across without a problem. TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix at command ???
try control-C or a period or a control-D On Tue, 2 Apr 2002, Janet Linsy wrote: Hi all, I'd like to run a file (r2) at 15:10 Apr 2. Below was what I did and I could not get out of at normally. /export/home/oracle/test$ at 15:10 Apr 2 at r2 at EOF at EOF at EOT at EOT at ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2 I tried EOF according to the on-line doc, and also tried EOT, but none works. Finally I used Control Z to get out of at. I was out, but the script file didn't run. So what's the correct syntax to run the command at a specific date, time? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database shut itself down
Hi Lisa Just check that the files owner is who you think it should be and check the permissions. A great thing NT Admins are god for is changing permissions in a directory at teh top of a tree and propagating it down with teh include subdirectories checkbox. the OS error Access denied says either you don't have permissions on the file or another process is holding a file lock on it. A reboot of teh server should clear that if you cant resolve it by other means Oh and you are right Oracle holds exclusive locks on the files at the OS level and as such if you try and move or delete them it won't happen Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Koivu, Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2002 07:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Database shut itself down I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail. Maybe this is a nice 'feature' but it doesn't leave much room for testing br Lisa Koivu Oracle Database Brick House - 36-54-36 Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: John Hallas [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:53 PM To:Multiple recipients of list ORACLE-L Subject: Re: Database shut itself down Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Ticket tracking system
So.. which one is the Winner ?? ;-)) What's the volume of these tickets? Have you considered partitioning the table for deleted tickets? - Kirti -Original Message- Sent: Tuesday, April 02, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Thank you all very much for different advices. I will give it a try. Regards, David -Original Message- Sent: Tuesday, April 02, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Don't delete the row(s) you'll need later. Perhaps add a column called ticket_status char(1), that gets a default value of 'O' (open). When you close the ticket change the value to 'C' (closed). To reopen change it back to 'O'. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 11:38 AM I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dynamic create and execute procedure
What !!! -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Bernard, Gilbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30/03/2002 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Dynamic create and execute procedure I need to create a generic dynamic procedure to create and execute any procedure I wish. === -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: EMC question
Hi Waleed list, The issue I raised about queuing was within the context of sequential writes to the various stripe units within a striped volume. If you have a 4-way stripe and there are 4 dirty disk blocks (1 on each stripe unit) that needs to be written to each of the 4 disks, the LVM-mid-layer should be able to get them down to their respective disks, independent of one another, not one after the other. If the dirty disk blocks are not written independent of one another, there will be no advantage of striping for writes. And pure striping should cater to I/O scalability for both reads and writes. Regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: HI Gaja list, I am trying to find the truth here! I was told by the storage group that EMC has striping now and this what I'm researching. Gaja, what you described as a problem during WRITES to striped EMC is a typical procedure in any striped volumes. There is a mid layer that has to map logical I/O addresses to physical disk addresses. If you are using Veritas LVM then all reads/writes requests will be queued to the LVM and will do exactly as you mentioned. There is a queue but the difference is big. You have a queue with many servers serving the queue requests simultaneously. Please check powerlink.emc.com Regards, Waleed -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Waleed list, To define the terms we have on hand:- A contiguous meta volume requires the hyper volumes to be sequential. A non-contiguous does not require the hyper volumes to be sequential. I want to reiterate again that the concept of pure striping at the hardware level, is still not there in EMC, even though you have documentation that claims that you do. Let me explain. When you look at pure striping, there are 2 aspects to it :- 1) The read aspect 2) The write aspect Take an example of a 4-way striped volume. The read aspect provides us the capability for all 4 drives to independently spin and service I/O from each of the drives. This the EMC device does, after the data has been placed on all hypers that support a meta volume. The write aspect needs to offer the same functionality. So, if you are writing to 4 distinct blocks (each on 1 disk), then each drive should be able to write 1 block in an independent fashion. That is where, the EMC hardware striping is not complete. This is because, the 4 blocks that need to be written to the meta volume with 4 hypers (regardless of whether it is contiguous or not), will happen in sequential fashion. Meaning, to write 4 blocks into the striped volume, the first block will be written to the first hyper, followed by the second block to the second hyper and so on. As you can see the blocks that need to be written are queued up, so that they are written in a sequential fashion on the underlying hypers. This can and will cause severe write-intensive I/O bottlenecks. Why is this implemented this way? No specific reasons, except, that is how it is right now. It has been rumored that microcode 5x68 or 5x69, will do that. Remains to be seen. So all the EMC striping does right now is to alleviate the problem of read-intensive operations not hammering a single drive, provided the data is spread across all the underlying hypers. I am not very familiar with the Engenuity product offering, hence cannot comment on that, but from what I have heard, it is a software-based volume management product. Best regards, Gaja --- Khedr, Waleed [EMAIL PROTECTED] wrote: It looks like it's available now. This is from: ResourcePak for Windows Version 3.2 Product Guide Symmetrix Microcode level 5x65 includes support for concatenated (contiguous) and striped metavolumes. Noncontiguous metavolumes (including striped) require EMC Enginuity(tm) (5x66 microcode) or higher. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/1/02 5:38 PM Waleed list, I researched this issue recently and found out that the meta volume was concatenating a bunch of hyper volume. As you know, concatenation is NOT striping. The hyper volumes get filled with data one after another, eventually giving you the simulation of a striped volume, when all hypers are filled with data. I don't know about the single-host vs. multi-host addressibility issue. There are plans for supporting true striped volumes in microcode level 68 or 69. From some reliable sources that does not look like it will happen any time soon. So until then, you should consider created mirrored hyper volumes within EMC (RAID 1) and then create a striped volume using Veritas Volume Manager, giving you a RAID 1+0 configuration, which is ideal. Best regards, Gaja --- Khedr, Waleed [EMAIL
Re: Unix at command ???
Try Control-D when you are done inputting your commands Brian P. MacLean Oracle DBA, OCP8i Janet Linsy janetlinsy@ya To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hoo.com cc: Sent by: Subject: Unix at command ??? [EMAIL PROTECTED] om 04/02/02 03:14 PM Please respond to ORACLE-L Hi all, I'd like to run a file (r2) at 15:10 Apr 2. Below was what I did and I could not get out of at normally. /export/home/oracle/test$ at 15:10 Apr 2 at r2 at EOF at EOF at EOT at EOT at ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2 I tried EOF according to the on-line doc, and also tried EOT, but none works. Finally I used Control Z to get out of at. I was out, but the script file didn't run. So what's the correct syntax to run the command at a specific date, time? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_STATS
Hi, I am new to using oracle and was wondering if anyone could help me out in using the DBMS_STAT's package. Firstly, does the package need to be installed as I am trying to run some of the subprograms but get errors like: execute DBMS_STATS.GATHER_TABLE_STATS( ownname='SCOTT', tabname='user_backup', cascade=TRUE); BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname='SCOTT', tabname='user_backup', cascade=TRUE); END; * ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body SYSTEM.DBMS_STATS does not exist ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 Secondly, if I don't specifiy a 'stattab', the statistics are stored in the dictionary. Where and what is this. Sorry for the low level question, but I need to start somewhere.. Thanks Scott -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Bunnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dynamic create and execute procedure
Cool! A PL/SQL procedure that responds to your every wish! I want one of those too! Seriously Gilbert, be a bit more specific about your desirements. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 Bernard, Gilbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30/03/2002 12:54 AM I need to create a generic dynamic procedure to create and execute any procedure I wish. === -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).