RE: Please ignore: Internet DBA'ng
Title: RE: Please ignore: Internet DBA'ng Salesmanship. They told the customer that they can't allow this, and instead of outsourcing DBA'ng to another company, why don't they just pay us for administration. -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 16 April 2002 5:13 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Please ignore: Internet DBA'ng How? -Original Message- From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent: 04 ÕÝÑ, 1423 09:08 AM To: Multiple recipients of list ORACLE-L Subject: Please ignore: Internet DBA'ng Solved this issue. > -Original Message- > From: Sujatha Madan > Sent: Tuesday, 16 April 2002 2:55 PM > To: Multiple recipients of list ORACLE-L (E-mail) > Subject: Internet DBA'ng > > Hi, > > We have a network/web hosting shop, and one of our customers is asking for > a firewall to be opened for DBA access over the internet. They want two > non-Oracle specific ports opened so that their Oracle Databases can be > administrated via the internet. > > Has anyone heard of any vulnerabilities associated with this? Or is there > anything that I should be aware of in terms of security? Or should I be > asking them any questions? > > Thanks > > Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please ignore: Internet DBA'ng
Title: RE: Please ignore: Internet DBA'ng How? -Original Message- From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent: 04 ÕÝÑ, 1423 09:08 AM To: Multiple recipients of list ORACLE-L Subject: Please ignore: Internet DBA'ng Solved this issue. > -Original Message- > From: Sujatha Madan > Sent: Tuesday, 16 April 2002 2:55 PM > To: Multiple recipients of list ORACLE-L (E-mail) > Subject: Internet DBA'ng > > Hi, > > We have a network/web hosting shop, and one of our customers is asking for > a firewall to be opened for DBA access over the internet. They want two > non-Oracle specific ports opened so that their Oracle Databases can be > administrated via the internet. > > Has anyone heard of any vulnerabilities associated with this? Or is there > anything that I should be aware of in terms of security? Or should I be > asking them any questions? > > Thanks > > Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix script
Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log file is also sent by mail to people. I would like this log file only to be sent if there is anything wrong with the script(for instance if the database is down) So if the script goes fine, then no email will be sent. The log file looks like this: Jobb startat :Sun Apr 14 18:06:23 MEST 2002 -- ehbgrupp status Total logical records skipped: 0 Total logical records read: 400 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:06:23 2002 Run ended on Sun Apr 14 18:11:51 2002 Elapsed time was: 00:05:28.15 CPU time was: 00:00:00.07 (Ma -- -- kampanj status Total logical records skipped: 0 Total logical records read:13 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:11:51 2002 Run ended on Sun Apr 14 18:12:44 2002 Elapsed time was: 00:00:52.52 CPU time was: 00:00:00.04 (Ma -- -- mxurval status Total logical records skipped: 0 Total logical records read: 4829 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:44 2002 Run ended on Sun Apr 14 18:12:50 2002 Elapsed time was: 00:00:05.90 CPU time was: 00:00:00.18 (Ma -- -- load_arg status Total logical records skipped: 0 Total logical records read:151613 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:50 2002 Run ended on Sun Apr 14 18:28:11 2002 Elapsed time was: 00:15:20.92 CPU time was: 00:00:25.07 (Ma -- -- laddabsg status Total logical records skipped: 0 Total logical records read: 92326 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:28:11 2002 Run ended on Sun Apr 14 18:40:15 2002 Elapsed time was: 00:12:03.95 CPU time was: 00:00:32.17 (Ma -- Jobb klart! :Sun Apr 14 18:49:23 MEST 2002 I would really appreciate help. Thanks in advance Roland laddabilbo.sh Description: Binary data
sql & isql
Dear Gurus, Where can I get the difference between 'sql' and 'isql' in Oracle. I shall be grateful if anyone please mention some differences. mks -- 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 ignore: Internet DBA'ng
Solved this issue. > -Original Message- > From: Sujatha Madan > Sent: Tuesday, 16 April 2002 2:55 PM > To: Multiple recipients of list ORACLE-L (E-mail) > Subject: Internet DBA'ng > > Hi, > > We have a network/web hosting shop, and one of our customers is asking for > a firewall to be opened for DBA access over the internet. They want two > non-Oracle specific ports opened so that their Oracle Databases can be > administrated via the internet. > > Has anyone heard of any vulnerabilities associated with this? Or is there > anything that I should be aware of in terms of security? Or should I be > asking them any questions? > > Thanks > > Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Internet DBA'ng
Hi, We have a network/web hosting shop, and one of our customers is asking for a firewall to be opened for DBA access over the internet. They want two non-Oracle specific ports opened so that their Oracle Databases can be administrated via the internet. Has anyone heard of any vulnerabilities associated with this? Or is there anything that I should be aware of in terms of security? Or should I be asking them any questions? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interview questions
What if one or more of your candidates are members of this list ^_^? I suggest to arrange your questions on level of difficulty, easy to hard to make the candidate feel comfortable A few simple ones Which control to use for what purpose: e.g., mutually exclusive options, more than one option from several options What would you prefer for items that are not updateable, use display item or make text item disabled Medium What to consider while manually joining two blocks Using timer in forms Difficult Checking duplicate on non PK columns in a block Blocks based on procedures HTH! Aleem -Original Message- Sent: Tuesday, April 16, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Subject:interview questions Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: temporary tablespace
Hi Seema, Your file is growing because you have set AUTOEXTEND ON. When you shut the instance down, Oracle will release the temp segments, but not actually reduce the file size. You can try shrinking the file (preferably after bouncing the instance) if possible, or you can add a new temp tablespace, make it the users' default temp space, and drop the original one (after checking, of course, that its not being used - see v$sort_segment, v$sort_usage). HTH, Mandar. -Original Message- Sent: Tuesday, April 16, 2002 4:18 AM To: Multiple recipients of list ORACLE-L Hi I created temporary tablespace by following command create tablespace TEMP datafile '/xxx/yyy/temp01.dbf' size 800M autoextend on next 2m default storage (initial 1024K next 1024K minextents 1 maxextents 2147483645 pctincrease 0) temporary online / Is this correct? I am looking that it is filling the disk partitions. is temp tablespace will release the space once i shutdown the database? I am thinking i used to use create temporary tablespace temp tempfile 'filename' size would be good syntax? if i offline this tablespace and create another temporary tablespace and ssign that tablespace to users which are using earlier?What will beimpact? tHx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Shete INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OC4J
AFAIK, OC4J is NOT dependent upon other 9iAS components. P I P O wrote: > > > i am just curious if OC4J could be used > alone with out installing the other components > of the Application Server? I mean does the > OC4J has dependencies on the Appication Server > other components? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
interview questions
Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OC4J
i am just curious if OC4J could be used alone with out installing the other components of the Application Server? I mean does the OC4J has dependencies on the Appication Server other components?
Re: protocol.ora
Sajid, I used protocol.ora to restrict connection based on ip on oracle 8.1.6.3.0 and now 8.1.7.2.0 (Solaris 8). I don't have problem. However, when I had two sets of databases running on the same ORACLE_HOME and using two listeners for these two sets of databases, I had complications. The behavior was that the listener that had the protocol.ora in the directory had to be started after the other one (somehow the restriction stayed in the memory). If you failed to start the restricted-listener last, or restarted the open-connection listener after the restricted-listener is running, then the open-set of databases don't have open connections. Hope this helps. Sharon --- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinformatics CB#7100 UNC-CH, Chapel Hill, NC 27599 (919)843-6106 (office) (919)966-6821 (fax) Date: Mon, 15 Apr 2002 08:59:01 +0100 (BST) Subject: Re: protocol.ora Hi I tried this however I get the same result as in it doesn't allow any connections at all..even IP addresses which are included in the .protocol.ora file. Regards Saj Iqbal On Fri, 12 Apr 2002, Jeremiah Wilton wrote: > If you trace the listener you will see that it is looking for > .protocol.ora with a leading period. This is a documented bug. Just > copy protocol.ora to .protocol.ora. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Fri, 12 Apr 2002, Sajid Iqbal wrote: > > > We used to use the protocol.ora file to restrict access to the database, > > on oracle 8.0.5 > > > > However since moving to Oracle 8.1.6.3 this doesn't work. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
fwd: Maximizing Productivity When Running Oracle9i on Windows NT/2000
---excerpted--- Session Search Oracle OpenWorld Display Session Paper #105 Title Maximizing Productivity When Running Oracle9i on Windows NT/2000 Speaker Megh Thakkar Quest Software Track Fast Track to Oracle9i Description System administrators and DBAs can take numerous actions to optimize the performance of Oracle9i on Windows NT/2000. This presentation discusses various strategies for integrating, automating, and simplifying the administration of Oracle9i with Windows NT/2000. Practical tips are provided for using Oracle9i capabilities that can make an immediate impact on the current system. Schedule Wednesday December 5th, 2001 at 08:30 AM in room Room 103 WhitepaperDownload ZIP format. http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6&p_file=W11958.zip PresentationDownload ZIP format. http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6&p_file=P11958.zip ---end--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stephen Andert's IOUG Dispatches
Ah, I am definitely missing the Thai food. I'll be there next year, I promise. Jared Jonathan Gennick <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/15/02 12:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Stephen Andert's IOUG Dispatches For those like me who can't be at IOUG this year: http://www.oreillynet.com/cs/weblog/view/wlg/1288 Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Locally managed tablespaces/What a DBA can do ?
Darren - Do you have to reorganize the vendor's files now? The objective of LMT's is to make Oracle more self-managing (you know, so the MS SQL people can't say it takes a lot more DBA time to manage the database). To me in your situation, the bottom line is whether you have to spend quite a bit of time reorganizing those files today. If the answer is "no", then LMT's probably aren't going to help you much. If the answer is "yes", then that gives you some opportunity try something with their files, since you are doing that anyway. The key point is whether you know how the vendor's software interfaces with Oracle. If you have to reorg quite a bit, then I am confident you know that interface well (otherwise you are jeopardizing the data). If the vendor has made it pretty automated (management of the data), then you probably aren't that familiar with the details of how the vendor accomplishes that, and shouldn't mess with their stuff. I apologize for being wordy here, but maybe you can see my point. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 15, 2002 4:33 PM To: Multiple recipients of list ORACLE-L I am looking into locally managed tablespaces, have done some research, and have a basic understanding of how they work, but I am unsure about the benefits if any for my environment. I have multiple instances running, one for each application. In some cases these apps just have two tablespaces, data and index. If I have a tablespace that is composed of tables that are various sizes and activity, will LMT help or hinder ? I have read the paper about creating tablespaces based on extent size, which is the concept I would follow, but I am unsure how the vendor(s) would feel if I re-org'd their database(s). Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
temporary tablespace
Hi I created temporary tablespace by following command create tablespace TEMP datafile '/xxx/yyy/temp01.dbf' size 800M autoextend on next 2m default storage (initial 1024K next 1024K minextents 1 maxextents 2147483645 pctincrease 0) temporary online / Is this correct? I am looking that it is filling the disk partitions. is temp tablespace will release the space once i shutdown the database? I am thinking i used to use create temporary tablespace temp tempfile 'filename' size would be good syntax? if i offline this tablespace and create another temporary tablespace and ssign that tablespace to users which are using earlier?What will beimpact? tHx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX hardware sizing for multiple instances
I know that sizing has to start some where, but what really drives the sizing in my opinion is: - > what will the instances be used for, how many users and what kind of transaction load is required (average and maximum), and what kind of response time is required (average and maximum). That will drive the number if disks (as there can be a good estimate of the number of I/Os per tx), number of users will drive the memory requirements and number of CPU is driven by the response time. That is the technical minimum requirement as I see it, there may be a completely different side to it that drives money/economic decisions. Performance should be a consideration in your sizing, else how do you know that you buy enough disks ? Or fast enough CPUs or enough CPUs ? Anjo. Paul Vallee wrote: > Hi Peter, > > disk space... you'll want a healthy margin here, enough to take hot backups, > keep a day's worth of archived redo, etc. The other thing when buying disk > nowadays is remembering that disk storage capacity (in MB) has increased > dramatically faster than disk IO capacity (in MB/minute). You'll have to > ensure that however much you buy, it can handle not only your storage > requirements but also your IO requirements. Some SAs have been known to only > format the inside 25% of each platter because of IO needs outweighing > storage capacity. > > physical memory... don't forget to calculate additional memory for your > instance processes and background processes! > > number of processors... although oracle was designed to use multiple > processors (or multiple threads on NT) acting simultaneously, oracle's > current pricing model encourages you to use few (or one!) very fast > processors instead. My understanding is that a single very fast processor > can give excellent oracle performance. Interestingly, I understand that > there is a significant performance advantage to using 8MB secondary caches > instead of 4MB caches, as the bulk of the active oracle executable code is > then op-code cached. > > Hope this helps, > Paul > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new services for > supplementing DBAs: get our help with monitoring, 24x7 on-call, daily > verifications, storage management, performance and more. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, April 15, 2002 3:18 PM > > My group has requirement to run three, possibly > four, instances of Oracle (8.1.7, most likely) on a UNIX server > (AIX, if that matters). We are considering separate instances > because the software comes from three different vendors. > The fourth database will be ours and may be able to run on one of > the other three instances. > > For determining the size of the server we are using the following > guidelines: > > disk space = amount needed for the o/s (including virtual memory) + > Oracle software + > data files > > physical memory = amount needed for the o/s + > total sizes of the SGA for all instances > > number of processors = at least two > > processor speed = somewhere in the middle range > > We are assuming that the processors do not have to be blindingly fast for > a database server. We are also assuming that the number of processors > is more important than their speed. > > So my questions are: > > 1. Are we on the right track with the physical memory calculation? > > 2. Should we figure in an additional amount of memory for each dedicated > server process, > assuming that we will not be using MTS? > > 3. What criteria should we use to determine number of processors? > > 4. Any other comments about our calculations and assumptions? > > Thanks, > > Peter Schauss > Northrop Grumman Corporation > 516-346-3148 > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vallee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL P
Re: EMC Storage Array Issue
It seems silly to get into a semantic argument over this. My point was
that Oracle in fact does use asynchronous io as far as the POSIX
definition of aio. Just because the ocntrolling thread looks in on the
status of the aiocb when it is signaled upon completion doesn't make it
any less asynchronous.
On Monday, April 15, 2002, at 06:23 PM, Anjo Kolk wrote:
> George,
>
> Those writes are unbuffered (so synchronous) and each thread will write
> them
> out and will wait for the write to finish and then update the AIO
> control
> block in the parent thread to indicate that the I/O took place. The
> parent
> thread will check this control block to make sure that the I/O really
> happened. If there is an error or some time out experid and the i/o
> didn't
> complete, the parent thread will assume an error.
>
> Anjo.
>
>
> George Schlossnagle wrote:
>
>> On Monday, April 15, 2002, at 02:08 PM, Anjo Kolk wrote:
>>
>>> Claudio,
>>>
>>> All writes in Oracle are synchronous, they are just fired
>>> asynchronously. So
>>> even the DBWR writes synchronously.
>>
>> My dbw uses asynchronous writes I'm writing to qio files, which
>> means that they bypass buffer cache, but I think it's misleading to
>> call
>> those 'synchronous writes', they're asynchronous, unbuffered writes.
>>
>> 14:28:09(george@core-0)[~]> truss -tkaio -twrite -tread -p `ps -ef |
>> grep dbw | grep -v grep | awk '{print $2}'`
>> kaio(AIOWRITE, 396, 0xB0258000, 8192, 0x4FBF6000, 0x01974EC8) = 0
>> kaio(AIOWRITE, 308, 0xB6BFE000, 8192, 0x48478000, 0x01B20518) = 0
>> kaio(AIOWRITE, 396, 0xB921A000, 8192, 0x249E8000, 0x019C5558) = 0
>> kaio(AIOWRITE, 396, 0xB4584000, 8192, 0x24F7E000, 0x0196CA84) = 0
>> kaio(AIOWRITE, 396, 0xB82BC000, 8192, 0x6D822000, 0x01B543CC) = 0
>> kaio(AIOWRITE, 313, 0xB5ED4000, 8192, 0x1FCD2000, 0x019EE1D8) = 0
>> kaio(AIOWRITE, 395, 0xBF256000, 8192, 0x21AE6000, 0x01971958) = 0
>> kaio(AIOWRITE, 313, 0xB170, 8192, 0x1FCD4000, 0x019B65D0) = 0
>> kaio(AIOWRITE, 396, 0xBA238000, 8192, 0x24F86000, 0x01B5E32C) = 0
>>
>>
>>> So individual writes are synchronously, they are just fired off
>>> asynchronously.
>>>
>>> Anjo Kolk.
>>>
>>> claudio cutelli wrote:
>>>
Hi,
which background process had the problem?
because if lgwr, it already write in sync mode ...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 5:33 PM
> We have implemented a Sun Solaris Cluster (4 machines),
> connected
> to
> an EMC storage array. The migration began last fall, and we now
> have
> 15
> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.
> We
> recently have had 2 occurances of asynchronous I/O wait times
> exceeded.
> When this occurs, every database crashes at the same time. The
> solution
> from EMC is to turn asynchronous I/O off in all of the Oracle
> instances
> (disk_async_io = false) and to increase the database writer slaves
> (dbwr_io_slaves = ) to emulate asynchronous I/O.
> Has anyone run into this problem before? If so, how did you
> "correct" it? My feeling is that EMC is trying to give us a bandage
> to
> cover up the real problem, by trying to get Oracle to ignore it.
>
> Thank you.
>
> --
> Scott Canaan ([EMAIL PROTECTED])
> (585) 475-7886
> "Life is like a sewer, what you get out of it depends on what you
> put
> into it" - Tom Lehrer
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Canaan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: claudio cutelli
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for ot
Replication errors
I have problem with our database replication between Master and Slaves. Looked at alert.log, I found following errors. Can someone please explain to me what following errors mean and how do I fix them? ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386 ORA-06512: at "SYS.DBMS_IREFRESH", line 450 ORA-06512: at "SYS.DBMS_REFRESH", line 182 Thanks, David Nguyen -- 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: EMC Storage Array Issue
George,
Those writes are unbuffered (so synchronous) and each thread will write them
out and will wait for the write to finish and then update the AIO control
block in the parent thread to indicate that the I/O took place. The parent
thread will check this control block to make sure that the I/O really
happened. If there is an error or some time out experid and the i/o didn't
complete, the parent thread will assume an error.
Anjo.
George Schlossnagle wrote:
> On Monday, April 15, 2002, at 02:08 PM, Anjo Kolk wrote:
>
> > Claudio,
> >
> > All writes in Oracle are synchronous, they are just fired
> > asynchronously. So
> > even the DBWR writes synchronously.
>
> My dbw uses asynchronous writes I'm writing to qio files, which
> means that they bypass buffer cache, but I think it's misleading to call
> those 'synchronous writes', they're asynchronous, unbuffered writes.
>
> 14:28:09(george@core-0)[~]> truss -tkaio -twrite -tread -p `ps -ef |
> grep dbw | grep -v grep | awk '{print $2}'`
> kaio(AIOWRITE, 396, 0xB0258000, 8192, 0x4FBF6000, 0x01974EC8) = 0
> kaio(AIOWRITE, 308, 0xB6BFE000, 8192, 0x48478000, 0x01B20518) = 0
> kaio(AIOWRITE, 396, 0xB921A000, 8192, 0x249E8000, 0x019C5558) = 0
> kaio(AIOWRITE, 396, 0xB4584000, 8192, 0x24F7E000, 0x0196CA84) = 0
> kaio(AIOWRITE, 396, 0xB82BC000, 8192, 0x6D822000, 0x01B543CC) = 0
> kaio(AIOWRITE, 313, 0xB5ED4000, 8192, 0x1FCD2000, 0x019EE1D8) = 0
> kaio(AIOWRITE, 395, 0xBF256000, 8192, 0x21AE6000, 0x01971958) = 0
> kaio(AIOWRITE, 313, 0xB170, 8192, 0x1FCD4000, 0x019B65D0) = 0
> kaio(AIOWRITE, 396, 0xBA238000, 8192, 0x24F86000, 0x01B5E32C) = 0
>
>
> > So individual writes are synchronously, they are just fired off
> > asynchronously.
> >
> > Anjo Kolk.
> >
> > claudio cutelli wrote:
> >
> >> Hi,
> >> which background process had the problem?
> >> because if lgwr, it already write in sync mode ...
> >>
> >> - Original Message -
> >> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> >> Sent: Monday, April 15, 2002 5:33 PM
> >>
> >>> We have implemented a Sun Solaris Cluster (4 machines), connected
> >>> to
> >>> an EMC storage array. The migration began last fall, and we now have
> >>> 15
> >>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.
> >>> We
> >>> recently have had 2 occurances of asynchronous I/O wait times
> >>> exceeded.
> >>> When this occurs, every database crashes at the same time. The
> >>> solution
> >>> from EMC is to turn asynchronous I/O off in all of the Oracle
> >>> instances
> >>> (disk_async_io = false) and to increase the database writer slaves
> >>> (dbwr_io_slaves = ) to emulate asynchronous I/O.
> >>> Has anyone run into this problem before? If so, how did you
> >>> "correct" it? My feeling is that EMC is trying to give us a bandage
> >>> to
> >>> cover up the real problem, by trying to get Oracle to ignore it.
> >>>
> >>> Thank you.
> >>>
> >>> --
> >>> Scott Canaan ([EMAIL PROTECTED])
> >>> (585) 475-7886
> >>> "Life is like a sewer, what you get out of it depends on what you put
> >>> into it" - Tom Lehrer
> >>>
> >>>
> >>> --
> >>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >>> --
> >>> Author: Scott Canaan
> >>> INET: [EMAIL PROTECTED]
> >>>
> >>> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> >>> San Diego, California-- Public Internet access / Mailing Lists
> >>>
> >>> To REMOVE yourself from this mailing list, send an E-Mail message
> >>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >>> the message BODY, include a line containing: UNSUB ORACLE-L
> >>> (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: claudio cutelli
> >> INET: [EMAIL PROTECTED]
> >>
> >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> >> San Diego, California-- Public Internet access / Mailing Lists
> >>
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (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: Anjo Kolk
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> >
> > To REMOVE yourself from this mailing list, send an E-Mail m
Re: oracle on windows xp (only 9i is supported)
I used Oracle8i EE on my winXP Professional for about half a year now. It has no problem so far. --- [EMAIL PROTECTED] wrote: > > 8i is not supported, only 9i is -> > http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=161546.1&p_database_id=NOT > > > Brian P. MacLean > Oracle DBA, OCP8i > > > > > > > "Farnsworth, Dave" > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > iture.com> > cc: > > Sent by: > Subject: oracle on windows xp > > [EMAIL PROTECTED] > > > > > > > > > 04/10/02 05:28 AM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > Has anyone installed Oracle 8i personal edition on > WIN XP with success? > > 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). __ 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: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Locally managed tablespaces/What a DBA can do ?
I am looking into locally managed tablespaces, have done some research, and have a basic understanding of how they work, but I am unsure about the benefits if any for my environment. I have multiple instances running, one for each application. In some cases these apps just have two tablespaces, data and index. If I have a tablespace that is composed of tables that are various sizes and activity, will LMT help or hinder ? I have read the paper about creating tablespaces based on extent size, which is the concept I would follow, but I am unsure how the vendor(s) would feel if I re-org'd their database(s). Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: User_product_profile and sqlplusw
I haven't tried this for a while, but I think it's case sensitive. try
'sqlplusw.exe'
-Original Message-
Sent: Monday, April 15, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have successfully restricted insert,update,delete using
product_user_profile if the user users sqlplus at the command prompt.
However I cannot
get it to work if they use sqlplusw.exe. Any ideas what entry I have to
use to enforce this.
This is what I used to restrict product access with sqlplus.exe
This works for command prompt sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlus','USER_ID','INSERT','DISABLED') ;
This does not work for windows sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlusw','USER_ID','INSERT','DISABLED') ;
Thanks
Rick
--
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: Shaw John-P55297
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
User_product_profile and sqlplusw
Hi,
I have successfully restricted insert,update,delete using
product_user_profile if the user users sqlplus at the command prompt.
However I cannot
get it to work if they use sqlplusw.exe. Any ideas what entry I have to
use to enforce this.
This is what I used to restrict product access with sqlplus.exe
This works for command prompt sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlus','USER_ID','INSERT','DISABLED') ;
This does not work for windows sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlusw','USER_ID','INSERT','DISABLED') ;
Thanks
Rick
--
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: UNIX hardware sizing for multiple instances
Hi Peter, disk space... you'll want a healthy margin here, enough to take hot backups, keep a day's worth of archived redo, etc. The other thing when buying disk nowadays is remembering that disk storage capacity (in MB) has increased dramatically faster than disk IO capacity (in MB/minute). You'll have to ensure that however much you buy, it can handle not only your storage requirements but also your IO requirements. Some SAs have been known to only format the inside 25% of each platter because of IO needs outweighing storage capacity. physical memory... don't forget to calculate additional memory for your instance processes and background processes! number of processors... although oracle was designed to use multiple processors (or multiple threads on NT) acting simultaneously, oracle's current pricing model encourages you to use few (or one!) very fast processors instead. My understanding is that a single very fast processor can give excellent oracle performance. Interestingly, I understand that there is a significant performance advantage to using 8MB secondary caches instead of 4MB caches, as the bulk of the active oracle executable code is then op-code cached. Hope this helps, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 3:18 PM My group has requirement to run three, possibly four, instances of Oracle (8.1.7, most likely) on a UNIX server (AIX, if that matters). We are considering separate instances because the software comes from three different vendors. The fourth database will be ours and may be able to run on one of the other three instances. For determining the size of the server we are using the following guidelines: disk space = amount needed for the o/s (including virtual memory) + Oracle software + data files physical memory = amount needed for the o/s + total sizes of the SGA for all instances number of processors = at least two processor speed = somewhere in the middle range We are assuming that the processors do not have to be blindingly fast for a database server. We are also assuming that the number of processors is more important than their speed. So my questions are: 1. Are we on the right track with the physical memory calculation? 2. Should we figure in an additional amount of memory for each dedicated server process, assuming that we will not be using MTS? 3. What criteria should we use to determine number of processors? 4. Any other comments about our calculations and assumptions? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stephen Andert's IOUG Dispatches
For those like me who can't be at IOUG this year: http://www.oreillynet.com/cs/weblog/view/wlg/1288 Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Storage Array Issue
On Monday, April 15, 2002, at 02:08 PM, Anjo Kolk wrote:
> Claudio,
>
> All writes in Oracle are synchronous, they are just fired
> asynchronously. So
> even the DBWR writes synchronously.
My dbw uses asynchronous writes I'm writing to qio files, which
means that they bypass buffer cache, but I think it's misleading to call
those 'synchronous writes', they're asynchronous, unbuffered writes.
14:28:09(george@core-0)[~]> truss -tkaio -twrite -tread -p `ps -ef |
grep dbw | grep -v grep | awk '{print $2}'`
kaio(AIOWRITE, 396, 0xB0258000, 8192, 0x4FBF6000, 0x01974EC8) = 0
kaio(AIOWRITE, 308, 0xB6BFE000, 8192, 0x48478000, 0x01B20518) = 0
kaio(AIOWRITE, 396, 0xB921A000, 8192, 0x249E8000, 0x019C5558) = 0
kaio(AIOWRITE, 396, 0xB4584000, 8192, 0x24F7E000, 0x0196CA84) = 0
kaio(AIOWRITE, 396, 0xB82BC000, 8192, 0x6D822000, 0x01B543CC) = 0
kaio(AIOWRITE, 313, 0xB5ED4000, 8192, 0x1FCD2000, 0x019EE1D8) = 0
kaio(AIOWRITE, 395, 0xBF256000, 8192, 0x21AE6000, 0x01971958) = 0
kaio(AIOWRITE, 313, 0xB170, 8192, 0x1FCD4000, 0x019B65D0) = 0
kaio(AIOWRITE, 396, 0xBA238000, 8192, 0x24F86000, 0x01B5E32C) = 0
> So individual writes are synchronously, they are just fired off
> asynchronously.
>
> Anjo Kolk.
>
> claudio cutelli wrote:
>
>> Hi,
>> which background process had the problem?
>> because if lgwr, it already write in sync mode ...
>>
>> - Original Message -
>> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>> Sent: Monday, April 15, 2002 5:33 PM
>>
>>> We have implemented a Sun Solaris Cluster (4 machines), connected
>>> to
>>> an EMC storage array. The migration began last fall, and we now have
>>> 15
>>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.
>>> We
>>> recently have had 2 occurances of asynchronous I/O wait times
>>> exceeded.
>>> When this occurs, every database crashes at the same time. The
>>> solution
>>> from EMC is to turn asynchronous I/O off in all of the Oracle
>>> instances
>>> (disk_async_io = false) and to increase the database writer slaves
>>> (dbwr_io_slaves = ) to emulate asynchronous I/O.
>>> Has anyone run into this problem before? If so, how did you
>>> "correct" it? My feeling is that EMC is trying to give us a bandage
>>> to
>>> cover up the real problem, by trying to get Oracle to ignore it.
>>>
>>> Thank you.
>>>
>>> --
>>> Scott Canaan ([EMAIL PROTECTED])
>>> (585) 475-7886
>>> "Life is like a sewer, what you get out of it depends on what you put
>>> into it" - Tom Lehrer
>>>
>>>
>>> --
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>> --
>>> Author: Scott Canaan
>>> INET: [EMAIL PROTECTED]
>>>
>>> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>>> San Diego, California-- Public Internet access / Mailing Lists
>>>
>>> To REMOVE yourself from this mailing list, send an E-Mail message
>>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>> the message BODY, include a line containing: UNSUB ORACLE-L
>>> (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: claudio cutelli
>> INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California-- Public Internet access / Mailing Lists
>>
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (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: Anjo Kolk
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
// George Schlossnagle
// Principal Consultant
// OmniTI, Inc http://www.omniti.com
// (c) 301.343.6422 (e) [EMAIL PROTECTED]
// 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (85
Running tunefs on Solaris with Oracle
OS: Solaris, 2.7 Oracle: v8.1.7 Anyone mess around with tuning file systems to be optimized for Oracle with the "tunefs" command. I've messed with the "-m minfree" parameter before but that is a usable/free space issue, not really a performance issue. I'm looking at the "-e maxbpg" parameter now. The last line of the man pages reads "For file systems with exclusively large files, this parameter should be set higher". Google, IXORA, Metalink, and Sun searches didn't turn up anything Opinions, links, experiences Anyone? The man page reads as follows: -e maxbpg Indicate the maximum number of blocks any single file can allocate out of a cylinder group before it is forced to begin allocating blocks from another cylinder group. Typically this value is set to approximately one quarter of the total blocks in a cylinder group. The intent is to prevent any single file from using up all the blocks in a single cylinder group, thus degrading access times for all files subsequently allocated in that cylinder group. The effect of this limit is to cause big files to do long seeks more fre- quently than if they were allowed to allocate all the blocks in a cylinder group before seeking elsewhere. For file systems with exclusively large files, this parameter should be set higher. TIA Brian P. MacLean Oracle DBA, OCP8i -- 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).
UNIX hardware sizing for multiple instances
My group has requirement to run three, possibly four, instances of Oracle (8.1.7, most likely) on a UNIX server (AIX, if that matters). We are considering separate instances because the software comes from three different vendors. The fourth database will be ours and may be able to run on one of the other three instances. For determining the size of the server we are using the following guidelines: disk space = amount needed for the o/s (including virtual memory) + Oracle software + data files physical memory = amount needed for the o/s + total sizes of the SGA for all instances number of processors = at least two processor speed = somewhere in the middle range We are assuming that the processors do not have to be blindingly fast for a database server. We are also assuming that the number of processors is more important than their speed. So my questions are: 1. Are we on the right track with the physical memory calculation? 2. Should we figure in an additional amount of memory for each dedicated server process, assuming that we will not be using MTS? 3. What criteria should we use to determine number of processors? 4. Any other comments about our calculations and assumptions? Thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
support 11.03 and 11i
Hi, First, I would like to compare support with 11.03 and 11i and I would like to compare both release of them. Somebody can tell me what will sill support in 11i against 11.03, and what can do to keep support in 11.03. if I split gl_lines into few partition, is this supported by oracle. Where can I find some doc on it. thanks Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: EMC Storage Array Issue
We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -Original Message- Canaan Sent: Monday, April 15, 2002 11:34 AM To: Multiple recipients of list ORACLE-L We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = ) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you "correct" it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James 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).
OT: Cobol & Zone Dec.
Hello everyone,
If anyone can help me interpret this junk that I am seeing (I have a feeling
it's zone decimal, but I am having a hard time finding a simple definition
of exactly what zone dec is) please email me directly.
Thank you, here's some of my junk, er, an example of what I'm referring to.
1 select id, member_number, assessment_0_30_delinquent,
total_past_due
2 from fpmast_raw
3 where rownum < 15
4* and total_past_due not like '000%'
(INV-ELVIS)>/
ID MEMBER_NU ASSESSMEN TOTAL_PAS
- - - -
193 001469663 001061I 001777C
215 001547860 00{ 001201B
250 001747190 000252G 002626H
272 002166726 00{ 007573A
284 002224443 000185D 002087A
308 002267067 000293G 019461B
309 002268727 00{ 001201B
390 002441850 000226F 001633C
443 002566750 00{ 001124H
468 002643641 000198B 003603D
565 003342161 000421C 003228B
569 003346365 000274A 006456{
579 003368045 000366C 023057H
731 004286360 000259A 011834D
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
--
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: runInstaller problems - urgent
PROBLEM DESCRIPTION --- AutoInstall worker failed during Oracle Applications Release 11.0 installation with the following error: Unable to initialize threads: cannot find class java/lang/thread. Could not create Java VM. Configuration Information: Product:Oracle Applications Version:11.0 Platform: Sun Sparc Solaris Version:2.5.1 Oracle Version: 8.0.4 SEARCH WORDS: adaimgr auto install thread SOLUTION DESCRIPTION The $OA_JDK_TOP/lib/rt.jar path needs to be included in the $CLASSPATH environment variable. The steps taken to solve this problem are as follows: 1. Include the $OA_JDK_TOP/lib/rt.jar path in the $CLASSPATH environment variable. The $CLASSPATH environment variable resided in the $APPL_TOP/admin/adovars.env file, and it is edited by the user. Other variables such as JAVA_TOP, OA_JDK_TOP, OAH_TOP, and OAD_TOP are defined also in this file. 2. Export the $CLASSPATH variable to the environment. 3. Invoke the "adctrl" tool to label the worker that failed as Fixed/Restart. 4. Invoke the AutoInstall "adaimgr" to continue where the installation left off. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=1059189.6 --Madhu -Original Message- Sent: Monday, April 15, 2002 9:34 AM To: Multiple recipients of list ORACLE-L Hi, I'm trying to get the runInstaller working ... I've done this a million and one times, but for some reason, tonight of all nights it doesn't want to run. It keeps saying: "Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait... Unable to initialize threads: cannot find class java/lang/Thread Could not create Java VM" I've got the CLASSPATH set to $ORACLE_HOME/jdbc/lib/classes111.zip I'm running 8.1.7 on HP-UX Please help. Thanks --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 5316 Mobile # +61 402 354 347 FAX # +61 2 9775 5360 Email [EMAIL PROTECTED] WEB http://www.optusbusiness.com.au/ --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: list of shourtcut oracle9ias mswindows
I would encourage you to re-install, even though it takes a while to install iAS. It's worth the hassle. If the groups and icons are missing, what else might be missing? The installer tells you the installation was successful, even though no icons were created. Obviously it doesn't track everything. Since it doesn't track one thing, you can be sure that it is not tracking others. Don't take a chance with iAS if you can avoid it. There are enough pieces bundled in iAS that you don't want to have to start figuring out which ones are there, and which ones are not. I concur with Jared, during the installation, don't do things like surf the 'net, leave the computer alone. Not only because of the Universal Installer, but also because of all the Java-related work that is going on. My advice from administering two iAS servers on NT. If after a second try you still have missing pieces, and you want to do it a third time, try boosting the jrew.exe process priority from normal to high. But only as a last resort. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, April 15, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Subject:Re: list of shourtcut oracle9ias mswindows The installation was successfull (at least this was the message) but the gruops oracle developer 6, oracle discoverer server 4i, oracle forms and reports 6i, oracle forms 6i, oracle olap client 2.2, oracle reports 6i , oracle reports 6i Admin are empty. The group oracle isuites is O.K. I still have to reinstall? Thanks again [EMAIL PROTECTED] wrote: > You need to investigate why this is happening. > > The installer is likely crashing before it is complete. I've had > the same thing happen with 8i on NT. The fix for me was > to reboot the box, don't start anything else, just install Oracle. > > The installers are notoriously fussy. I've had this and similar > problems on several versions. > > You really need to reinstall. > > Jared > > > On Sunday 14 April 2002 16:33, [EMAIL PROTECTED] wrote: > >>HI >> >>I installed oracle9ias v1.0.2.2.2a but it didn´t install the groups and >>its shorcuts. >> >>Anybody has this list of groups, shortcuts and parameters of this >>shortcuts. >> >>Thanks a lot >> >>Alvaro Quintero >> -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EMC Storage Array Issue
Claudio, All writes in Oracle are synchronous, they are just fired asynchronously. So even the DBWR writes synchronously. So individual writes are synchronously, they are just fired off asynchronously. Anjo Kolk. claudio cutelli wrote: > Hi, > which background process had the problem? > because if lgwr, it already write in sync mode ... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, April 15, 2002 5:33 PM > > > We have implemented a Sun Solaris Cluster (4 machines), connected to > > an EMC storage array. The migration began last fall, and we now have 15 > > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > > recently have had 2 occurances of asynchronous I/O wait times exceeded. > > When this occurs, every database crashes at the same time. The solution > > from EMC is to turn asynchronous I/O off in all of the Oracle instances > > (disk_async_io = false) and to increase the database writer slaves > > (dbwr_io_slaves = ) to emulate asynchronous I/O. > > Has anyone run into this problem before? If so, how did you > > "correct" it? My feeling is that EMC is trying to give us a bandage to > > cover up the real problem, by trying to get Oracle to ignore it. > > > > Thank you. > > > > -- > > Scott Canaan ([EMAIL PROTECTED]) > > (585) 475-7886 > > "Life is like a sewer, what you get out of it depends on what you put > > into it" - Tom Lehrer > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Scott Canaan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: claudio cutelli > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: list of shourtcut oracle9ias mswindows
By successful do you mean that the final screen came up, and you pressed the button to exit the installer? If not, the install was not successful. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/15/02 09:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: list of shourtcut oracle9ias mswindows The installation was successfull (at least this was the message) but the gruops oracle developer 6, oracle discoverer server 4i, oracle forms and reports 6i, oracle forms 6i, oracle olap client 2.2, oracle reports 6i , oracle reports 6i Admin are empty. The group oracle isuites is O.K. I still have to reinstall? Thanks again [EMAIL PROTECTED] wrote: > You need to investigate why this is happening. > > The installer is likely crashing before it is complete. I've had > the same thing happen with 8i on NT. The fix for me was > to reboot the box, don't start anything else, just install Oracle. > > The installers are notoriously fussy. I've had this and similar > problems on several versions. > > You really need to reinstall. > > Jared > > > On Sunday 14 April 2002 16:33, [EMAIL PROTECTED] wrote: > >>HI >> >>I installed oracle9ias v1.0.2.2.2a but it didn´t install the groups and >>its shorcuts. >> >>Anybody has this list of groups, shortcuts and parameters of this >>shortcuts. >> >>Thanks a lot >> >>Alvaro Quintero >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EMC Storage Array Issue
Are you running Veritas as well? There are (I belive still outstanding) bugs with VXFS/VXVM on Oracle which cause these errors. Also, are you seeing high latency right times or experiencing 'hangs' in IO to your symmetrix? I've also seen faulty fiber cabling cause this problem (basically all IO to the symmetrix blocked, and the asynch io's timed-out. George On Monday, April 15, 2002, at 01:19 PM, Scott Canaan wrote: > Claudio, > I didn't think to mention the process. It is always the ckpt > (checkpoint) > background process that reports the problem. The database goes down > with an > ORA-27062. > > claudio cutelli wrote: > >> Hi, >> which background process had the problem? >> because if lgwr, it already write in sync mode ... >> >> - Original Message - >> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >> Sent: Monday, April 15, 2002 5:33 PM >> >>> We have implemented a Sun Solaris Cluster (4 machines), connected >>> to >>> an EMC storage array. The migration began last fall, and we now have >>> 15 >>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. >>> We >>> recently have had 2 occurances of asynchronous I/O wait times >>> exceeded. >>> When this occurs, every database crashes at the same time. The >>> solution >>> from EMC is to turn asynchronous I/O off in all of the Oracle >>> instances >>> (disk_async_io = false) and to increase the database writer slaves >>> (dbwr_io_slaves = ) to emulate asynchronous I/O. >>> Has anyone run into this problem before? If so, how did you >>> "correct" it? My feeling is that EMC is trying to give us a bandage >>> to >>> cover up the real problem, by trying to get Oracle to ignore it. >>> >>> Thank you. >>> >>> -- >>> Scott Canaan ([EMAIL PROTECTED]) >>> (585) 475-7886 >>> "Life is like a sewer, what you get out of it depends on what you put >>> into it" - Tom Lehrer >>> >>> >>> -- >>> Please see the official ORACLE-L FAQ: http://www.orafaq.com >>> -- >>> Author: Scott Canaan >>> INET: [EMAIL PROTECTED] >>> >>> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>> San Diego, California-- Public Internet access / Mailing Lists >>> >>> To REMOVE yourself from this mailing list, send an E-Mail message >>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>> the message BODY, include a line containing: UNSUB ORACLE-L >>> (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: claudio cutelli >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California-- Public Internet access / Mailing Lists >> >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" > - Tom Lehrer > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for
Re: Archiving Data Strategies.
Ian, I've put of replying to this for a couple of weeks now. I see that no one else has replied either, at least to the list. Archiving data is a rather complex subject. When data is taken offline and archived, there are a number of things to consider. * algorithms for archiving. Your application may already have this built in. If not, you will need to build it yourself. Archiving data with it's dependence on other data is not a simple task. There are 3rd party tools to aid in this. ( don't ask me which, I've never used one. I just know they're available ) * media life How long will the archive media survive? Nothing lasts forever. CDROM's have a useful life of about 20 years. ( don't throw away those vinyl LP's! ) Tape lasts 10-15 years. But that's only part of the problem. Will you have the hardware needed to read the format stored on tape or disk? Will the hardware still work? What if it breaks? You may not be able to fix it. * binaries You better keep versions of the binaries that are current with the archived data. Programs change over time. You won't be able to read 10 year old data with your current software. * data structures These are static. Do you think that you'll be able to load 10 year old data into your current data structures? Probably not. * legal requirements Are you legally required to keep records for a period of time? Accounting data for the last 7 years ( at least ) is usually needed for audits. Medical records must often be available for 15 years. * cost It's probably less expensive to leave your data online. --- As for as I'm concerned, data that has been archived is lost. Even if you do due diligence in all of the requisite areas, the chances of every seeing data are greatly reduced with time once it's archived and deleted from an online system. I just bought a very interesting book yesterday, "DARK AGES II - When The Digital Data Die" It's theme is the longevity of digital data. I'll post more when I've read it. Jared "Biddell, Ian" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/27/02 01:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Archiving Data Strategies. Hi All, I previously posted this question to the Lazydba List and got a couple of replies, but thought I would also send it to this list as well to see if I can just get a couple more (so excuses to those people that have already seen it) I am currently discussing with a customer their requirements for archiving data as their system is 4 years old and billing data is piling up which obviously is affecting performance. I am pushing for an Oracle upgrade, they are currently on 7.3.4 and I am trying to get them to go to 9i. The main reason for this is so they can use partitioning. My question to the List is to try and find out other people's experiences in archiving complex and integral data and whether most have gone the partitioning path or some other path (ie. Something like separate tables and data migration). So I would appreciate anyones comments, the path they chose, database size etc. With Thanks Ian Biddell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Biddell, Ian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: EMC Storage Array Issue
Claudio, I didn't think to mention the process. It is always the ckpt (checkpoint) background process that reports the problem. The database goes down with an ORA-27062. claudio cutelli wrote: > Hi, > which background process had the problem? > because if lgwr, it already write in sync mode ... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, April 15, 2002 5:33 PM > > > We have implemented a Sun Solaris Cluster (4 machines), connected to > > an EMC storage array. The migration began last fall, and we now have 15 > > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > > recently have had 2 occurances of asynchronous I/O wait times exceeded. > > When this occurs, every database crashes at the same time. The solution > > from EMC is to turn asynchronous I/O off in all of the Oracle instances > > (disk_async_io = false) and to increase the database writer slaves > > (dbwr_io_slaves = ) to emulate asynchronous I/O. > > Has anyone run into this problem before? If so, how did you > > "correct" it? My feeling is that EMC is trying to give us a bandage to > > cover up the real problem, by trying to get Oracle to ignore it. > > > > Thank you. > > > > -- > > Scott Canaan ([EMAIL PROTECTED]) > > (585) 475-7886 > > "Life is like a sewer, what you get out of it depends on what you put > > into it" - Tom Lehrer > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Scott Canaan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: claudio cutelli > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
About SAN -- IBM or COMPAQ
Hi friends: I'm evaluating migration of storage to SAN( Storage Area Network), I have - 2 Database Oracle 8.1.7 of 100 GB each one on RISC Plataform - 100 GB of data on fileservers INTEL with WIN 2K What do you think about: -COMPAQ - MA8000 -IBM-FastT500 -HP- VA7000 Thanks for your help, ILL DBA Oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Storage Array Issue
Getting an error means having i/o problems. Disabling async_io and increasing slaves means stopping the error but does not mean any performance gain since there are io issues. I think they have to find and trace the time out errors and try to fix them. Are you using raw or cooked (i assume raw)? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/15/02 10:33 AM We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = ) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you "correct" it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: list of shourtcut oracle9ias mswindows
The installation was successfull (at least this was the message) but the gruops oracle developer 6, oracle discoverer server 4i, oracle forms and reports 6i, oracle forms 6i, oracle olap client 2.2, oracle reports 6i , oracle reports 6i Admin are empty. The group oracle isuites is O.K. I still have to reinstall? Thanks again [EMAIL PROTECTED] wrote: > You need to investigate why this is happening. > > The installer is likely crashing before it is complete. I've had > the same thing happen with 8i on NT. The fix for me was > to reboot the box, don't start anything else, just install Oracle. > > The installers are notoriously fussy. I've had this and similar > problems on several versions. > > You really need to reinstall. > > Jared > > > On Sunday 14 April 2002 16:33, [EMAIL PROTECTED] wrote: > >>HI >> >>I installed oracle9ias v1.0.2.2.2a but it didn´t install the groups and >>its shorcuts. >> >>Anybody has this list of groups, shortcuts and parameters of this >>shortcuts. >> >>Thanks a lot >> >>Alvaro Quintero >> -- 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: list of shourtcut oracle9ias mswindows
The installer consumes huge quantities of memory and most personal computers aren't designed for it. Also, check your swap space, windoze usually defaults to an inadequate size. >>> [EMAIL PROTECTED] 04/15/02 11:39AM >>> You need to investigate why this is happening. The installer is likely crashing before it is complete. I've had the same thing happen with 8i on NT. The fix for me was to reboot the box, don't start anything else, just install Oracle. The installers are notoriously fussy. I've had this and similar problems on several versions. You really need to reinstall. Jared On Sunday 14 April 2002 16:33, [EMAIL PROTECTED] wrote: > HI > > I installed oracle9ias v1.0.2.2.2a but it didn t install the groups and > its shorcuts. > > Anybody has this list of groups, shortcuts and parameters of this > shortcuts. > > Thanks a lot > > Alvaro Quintero -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: EMC Storage Array Issue
Which filesystem/volume manager are you using, if any? That is potentially where you would want to look if the async write queue is getting backed up. Just shutting off async is a terrible suggestion from EMC. I am suprised at them. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 15 Apr 2002, Scott Canaan wrote: > We have implemented a Sun Solaris Cluster (4 machines), connected to > an EMC storage array. The migration began last fall, and we now have 15 > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > recently have had 2 occurances of asynchronous I/O wait times exceeded. > When this occurs, every database crashes at the same time. The solution > from EMC is to turn asynchronous I/O off in all of the Oracle instances > (disk_async_io = false) and to increase the database writer slaves > (dbwr_io_slaves = ) to emulate asynchronous I/O. > Has anyone run into this problem before? If so, how did you > "correct" it? My feeling is that EMC is trying to give us a bandage to > cover up the real problem, by trying to get Oracle to ignore it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Storage Array Issue
Hi Scott, Recently we had issues with EMC. Last week we started getting IO timeout on one of our frames followed by files being accessed disappearing. We lost controlfiles, redo log files and library files. EMC hasn't been able to tell us why it happended. I would like to hear about solutions/explanation they come up with for your problem. Regards, Denny Quoting Scott Canaan <[EMAIL PROTECTED]>: > We have implemented a Sun Solaris Cluster (4 machines), connected > to > an EMC storage array. The migration began last fall, and we now have > 15 > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. > We > recently have had 2 occurances of asynchronous I/O wait times > exceeded. > When this occurs, every database crashes at the same time. The > solution > from EMC is to turn asynchronous I/O off in all of the Oracle > instances > (disk_async_io = false) and to increase the database writer slaves > (dbwr_io_slaves = ) to emulate asynchronous I/O. > Has anyone run into this problem before? If so, how did you > "correct" it? My feeling is that EMC is trying to give us a bandage > to > cover up the real problem, by trying to get Oracle to ignore it. > > Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Storage Array Issue
Hi, which background process had the problem? because if lgwr, it already write in sync mode ... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 5:33 PM > We have implemented a Sun Solaris Cluster (4 machines), connected to > an EMC storage array. The migration began last fall, and we now have 15 > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > recently have had 2 occurances of asynchronous I/O wait times exceeded. > When this occurs, every database crashes at the same time. The solution > from EMC is to turn asynchronous I/O off in all of the Oracle instances > (disk_async_io = false) and to increase the database writer slaves > (dbwr_io_slaves = ) to emulate asynchronous I/O. > Has anyone run into this problem before? If so, how did you > "correct" it? My feeling is that EMC is trying to give us a bandage to > cover up the real problem, by trying to get Oracle to ignore it. > > Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recompiling Invalid Objects after Table Rename
Unfortunately we do not have the partitioning option available. I should mention that when I say I want to delete a large number of rows, the number of rows I want to keep is even larger. (Delete, say, 3 million rows, keep 7 million rows) so the option that some other have suggested of truncating the original table and copying the rows back would likely be much slower than recompiling the invalid objects. Thanks to all those who have suggested a way of doing so. - Bill. At 04:58 15/04/02 -0800, you wrote: >$ORACLE_HOME/rdbms/admin/utlrp will recompile all invalid objects. > >Could you partition the table so that you only need to drop a partition >instead of deleting rows? > >Jay > > >>> [EMAIL PROTECTED] 04/15/02 08:23AM >>> >Hi all, > >We have an application which deletes a large number of rows from a >table. It would be faster to simply insert the rows that we want to keep >into a second table, drop the original table and then rename the second >table to that of the one we have just dropped. > >The only downside that I can see is that all the source objects which >reference the original table become invalid. > >We could: >1. Simply allow the source objects to be recompiled naturally overtime >as they are reused (but with the possibility of a large number of invalid >objects at any one time in the database and little control over when >compilation is done). >2. Force recompilation following the drop table. However this would >require logging all objects which would need recompilation. This is an >additional step for any new development and would therefore the list of >object would be prone to become inaccurate over time. (Could maybe do this >automatically using USER_REFERENCES prior to the drop table? - still seems >a bit clumsy) > >Does anyone have any comments on doing this? > >Many thanks >- Bill. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Bill Buchan > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: Jay Hostetter > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: list of shourtcut oracle9ias mswindows
You need to investigate why this is happening. The installer is likely crashing before it is complete. I've had the same thing happen with 8i on NT. The fix for me was to reboot the box, don't start anything else, just install Oracle. The installers are notoriously fussy. I've had this and similar problems on several versions. You really need to reinstall. Jared On Sunday 14 April 2002 16:33, [EMAIL PROTECTED] wrote: > HI > > I installed oracle9ias v1.0.2.2.2a but it didn´t install the groups and > its shorcuts. > > Anybody has this list of groups, shortcuts and parameters of this > shortcuts. > > Thanks a lot > > Alvaro Quintero -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Brainbench Oracle certifications
>Does OCP, MCP, etc. allow open book or open computer exam? >BrainBench does. While you are answering a question at >BrainBench, you can verify your answer on the same computer by >running the program. Still you will not find it easy to get the >required score. FWIW--I'd call this a strength of BB's tests. It's much closer to real life tasks. I'm almost never deprived of manuals or a test environment when I need to figure something out... I've taken several of the MCP tests & always resented having to memorize useless arcana that's easily found in the documentation. Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, April 11, 2002 9:28 PM To: Multiple recipients of list ORACLE-L Well! What's the criteria for a degree being of some value? I think at least these 3 1- How many people know about that degree 2- How hard the issuing authority works to maintain its standards for passing score, exam questions, etc.? 3- How has one obtained it, The sites like cramsession, braindump, etc. have contributed a lot in producing more "Certified Professionals" at the same time have damaged the credibility of certification by providing possible questions. If degrees/certifications are of some worth then am I right to say that you will hire any graduate from the best university of your country without interviewing him/her? No you wouldn't, then what is the worth of the degree/certification he/she holds? Does OCP, MCP, etc. allow open book or open computer exam? BrainBench does. While you are answering a question at BrainBench, you can verify your answer on the same computer by running the program. Still you will not find it easy to get the required score. Aleem -Original Message- Sent: Friday, April 12, 2002 3:09 AM To: Multiple recipients of list ORACLE-L Subject:Re:Brainbench Oracle certifications Nope. Reply Separator Author: Andrey Bronfin <[EMAIL PROTECTED]> Date: 4/11/2002 1:23 PM Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t othe OCP, but is there any value at all for it ? Thanks a lot in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
EMC Storage Array Issue
We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = ) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you "correct" it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to use profiles??
You are better off controlling the # of concurrent users from the app server. With Oracle profiles, users just exit when resources are exceeded, not a clean exit for the user. Most app servers have some controls or you can build them in the application. >>> [EMAIL PROTECTED] 04/15/02 10:08AM >>> Hi! We are experiencing performance problems on one of our production boxes, because some sessions are using up all the resources. All the users connect to the db through an application server using the same database user (approx 30 simultaneous connections). I was thinking about using profiles to limit the amount of resources a session can use. But I am pretty unsure to what values I should set the single criterias. The db is running on a Sun server, 4 CPUs, 4 GB of RAM and a Raid 0+1 disk array. What would be reasonable ballpark numbers to set for cpu_per_session cpu_per_call logical_reads_per_session logical_reads_per_call What would happen if cpu_per_session is set to 500 (i.e. 5 seconds) and the session used up all that CPU time? Would the session error out then? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- 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: How to use profiles??
On Mon, Apr 15, 2002 at 06:08:21AM -0800, Daiminger, Helmut wrote: > Hi! > > We are experiencing performance problems on one of our production boxes, > because some sessions are using up all the resources. All the users connect > to the db through an application server using the same database user (approx > 30 simultaneous connections). > > I was thinking about using profiles to limit the amount of resources a > session can use. But I am pretty unsure to what values I should set the > single criterias. The db is running on a Sun server, 4 CPUs, 4 GB of RAM and > a Raid 0+1 disk array. Something is rotten in Denmark. 30 sessions are killing a 4 processor, 4GB ram system I have 50 sessions on an old 1 cpu 333mHz machine built back when DEC was a company. You have some serious tuning issues. Limiting per session resources seems like putting your thumb in the broken dike (more Northern Europe humor..) > > What would be reasonable ballpark numbers to set for > > cpu_per_session > cpu_per_call > logical_reads_per_session > logical_reads_per_call > > What would happen if cpu_per_session is set to 500 (i.e. 5 seconds) and the > session used up all that CPU time? Would the session error out then? > > This is 8.1.7 on Sun Solaris. > > Thanks, > Helmut > -- === 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:How to use profiles??
Helmut, This thing with app servers and everyone ending up on the DB as a single user (like PeopleSoft likes it) is one BIG pain in the &^%. Basically your stuck with not being to limit anything. Reason is that you cannot predict what jobs/sessions should have the longer vs. shorter limits. Setting any one of these will cause the offending session to abort. OH, BTW: there's a bug in 8.1.7.0.0 (BUG # 2085332) where you set the CPU_PER_CALL and your user gets an ORA-2394 vs. an ORA-2393 when they exceed the per call CPU utilization. It's supposedly fixed in 9.2. OH, don't forget for any profile limits to work you need to set RESOURCE_LIMIT=TRUE in init.ora. Dick Goulet Reply Separator Author: "Daiminger; Helmut" <[EMAIL PROTECTED]> Date: 4/15/2002 6:08 AM Hi! We are experiencing performance problems on one of our production boxes, because some sessions are using up all the resources. All the users connect to the db through an application server using the same database user (approx 30 simultaneous connections). I was thinking about using profiles to limit the amount of resources a session can use. But I am pretty unsure to what values I should set the single criterias. The db is running on a Sun server, 4 CPUs, 4 GB of RAM and a Raid 0+1 disk array. What would be reasonable ballpark numbers to set for cpu_per_session cpu_per_call logical_reads_per_session logical_reads_per_call What would happen if cpu_per_session is set to 500 (i.e. 5 seconds) and the session used up all that CPU time? Would the session error out then? This is 8.1.7 on Sun Solaris. Thanks, Helmut How to use profiles?? Hi! We are experiencing performance problems on one of our production boxes, because some sessions are using up all the resources. All the users connect to the db through an application server using the same database user (approx 30 simultaneous connections). I was thinking about using profiles to limit the amount of resources a session can use. But I am pretty unsure to what values I should set the single criterias. The db is running on a Sun server, 4 CPUs, 4 GB of RAM and a Raid 0+1 disk array. What would be reasonable ballpark numbers to set for cpu_per_session cpu_per_call logical_reads_per_session logical_reads_per_call What would happen if cpu_per_session is set to 500 (i.e. 5 seconds) and the session used up all that CPU time? Would the session error out then? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- 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).
runInstaller problems - urgent
Hi, I'm trying to get the runInstaller working ... I've done this a million and one times, but for some reason, tonight of all nights it doesn't want to run. It keeps saying: "Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait... Unable to initialize threads: cannot find class java/lang/Thread Could not create Java VM" I've got the CLASSPATH set to $ORACLE_HOME/jdbc/lib/classes111.zip I'm running 8.1.7 on HP-UX Please help. Thanks --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 5316 Mobile # +61 402 354 347 FAX # +61 2 9775 5360 Email [EMAIL PROTECTED] WEB http://www.optusbusiness.com.au/ --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
Thanks all for your responses. I'll go by "the order doesn't matter". Let's see if I can hose up our dev DB with this now... ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > Sent: Thursday, April 11, 2002 3:13 PM > To: Multiple recipients of list ORACLE-L > > > I'm writing a Perl script to automate the procedure to create > a copy of an > 8.1.7 production DB to a development server. Both production > and dev are > HP/UX 11.0. > > In doing this, I've created a file that cross-references where the > production datafiles are and where they are to be placed in dev. This > works > fine, but I also wanted to dynamically create the CREATE CONTROLFILE > statement for the "new" dev DB. > > I've noticed that the DATAFILE clause does not have the > SYSTEM tablespace's > datafile first, nor are any of the other datafiles in the > same order that > they are in production (e.g. from the output of an ALTER SYSTEM BACKUP > CONTROLFILE TO TRACE). Does this matter? Does the order need to be > preserved? > > I suppose I'll end up dynamically creating the > cross-reference file, which > would preserve the order, but now I'm curious. > > TIA! > > Rich Jesse System/Database Administrator -- 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).
How to use profiles??
Title: How to use profiles?? Hi! We are experiencing performance problems on one of our production boxes, because some sessions are using up all the resources. All the users connect to the db through an application server using the same database user (approx 30 simultaneous connections). I was thinking about using profiles to limit the amount of resources a session can use. But I am pretty unsure to what values I should set the single criterias. The db is running on a Sun server, 4 CPUs, 4 GB of RAM and a Raid 0+1 disk array. What would be reasonable ballpark numbers to set for cpu_per_session cpu_per_call logical_reads_per_session logical_reads_per_call What would happen if cpu_per_session is set to 500 (i.e. 5 seconds) and the session used up all that CPU time? Would the session error out then? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Archival Freeze - Painful lessons learned
How strange, that happened to me on Oracle 7.3 and on 8.1.7. on Tru64 UNIX, and the database continued automatically after freeing up disk space. It complained a lot, though, while there was no space left on disk. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, April 15, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject:Re: Archival Freeze - Painful lessons learned If you have freed up the space and your archiver is STILL hung, read note 131427.1 on MetaLink. This was my painful lesson. Jay >>> [EMAIL PROTECTED] 04/12/02 06:38PM >>> After reading the other postings I better add this one too;^) (If ya didn't learn something new today, it's because ya didn't do anything today). ORA-00257, "archiver error. Connect internal only, until freed." Brian P. MacLean Oracle DBA, OCP8i Brian P MacLean To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] 04/12/02 02:19 Subject: Re: Archival Freeze - Painful lessons learned(Document link: PM Brian P MacLean) As Daffy Duck says -> http://www.dailywav.com/0700/dcorrect.wav The archiver freaks first, and will keep trying to write/recover/looking for space. But the database will not hang until all the redo logs are full and none remain that have been archived (ie: all redo logs need archiving). The error in the alert.log is some combination of: ORA-00255, "error archiving log %s of thread %s, sequence # %s" ORA-00270, "error creating archive log %s" ORA-19504, "failed to create file \"%s\"" ORA-27040, "skgfrcre: create error, unable to create file" ARCH: Archival stopped, error occurred. Will continue retrying SVR4 Error: 5: I/O error Why do I have a list of the above errors you ask? Because I've been there (painful lessons learned), and these are just some of the errors I look for in my db status script. Brian P. MacLean Oracle DBA, OCP8i Rajesh.Rao@jpm chase.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Archival Freeze om 04/12/02 02:13 PM Please respond to ORACLE-L Hi Fellow DBAs, I and a fellow DBA are currently debating about how insufficient space in the archive destination freezes up the DB. He claims that as soon as the ARCH process is unable to write to the disk, the db freezes. I am of the opinion that it does not. It will only report an error (Any idea, what the error code is?). It will only freeze when it cycles thru the rest of the redolog groups, and then when it tries to switch log to the one which has not been archived. That's why the error message is "cannot allocate new log". Whats your say? He's also on this list. Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo
RE: Recompiling Invalid Objects after Table Rename
Can't you just do a variant of
SET HEAD OFF TERMOUT OFF ECHO OFF
select 'alter '||decode(object_type,'PACKAGE BODY',' PACKAGE
',object_type)||
' '||object_name||' compile '||
decode(object_type,'PACKAGE BODY','BODY ','')||';'
from user_objects
where object_type in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 'FUNCTION',
'VIEW','TRIGGER')
and status != 'VALID'
spool recomp.sql
/
spool off
SET HEAD ON TERMOUT ON ECHO ON
start recomp
which will attempt to recompile anything invalid.
Option 1 wouldn't necessarily ever work as I believe recompilation only
happens when something is called directly i.e. if the user calls a package
which in turn calls an invalid package then recompilation would not happen
(apologies if I'm wrong)
Iain Nicoll
-Original Message-
Sent: Monday, April 15, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
Hi all,
We have an application which deletes a large number of rows from a
table. It would be faster to simply insert the rows that we want to keep
into a second table, drop the original table and then rename the second
table to that of the one we have just dropped.
The only downside that I can see is that all the source objects which
reference the original table become invalid.
We could:
1. Simply allow the source objects to be recompiled naturally overtime
as they are reused (but with the possibility of a large number of invalid
objects at any one time in the database and little control over when
compilation is done).
2. Force recompilation following the drop table. However this would
require logging all objects which would need recompilation. This is an
additional step for any new development and would therefore the list of
object would be prone to become inaccurate over time. (Could maybe do this
automatically using USER_REFERENCES prior to the drop table? - still seems
a bit clumsy)
Does anyone have any comments on doing this?
Many thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nicoll, Iain (Calanais)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Recompiling Invalid Objects after Table Rename
$ORACLE_HOME/rdbms/admin/utlrp will recompile all invalid objects. Could you partition the table so that you only need to drop a partition instead of deleting rows? Jay >>> [EMAIL PROTECTED] 04/15/02 08:23AM >>> Hi all, We have an application which deletes a large number of rows from a table. It would be faster to simply insert the rows that we want to keep into a second table, drop the original table and then rename the second table to that of the one we have just dropped. The only downside that I can see is that all the source objects which reference the original table become invalid. We could: 1. Simply allow the source objects to be recompiled naturally overtime as they are reused (but with the possibility of a large number of invalid objects at any one time in the database and little control over when compilation is done). 2. Force recompilation following the drop table. However this would require logging all objects which would need recompilation. This is an additional step for any new development and would therefore the list of object would be prone to become inaccurate over time. (Could maybe do this automatically using USER_REFERENCES prior to the drop table? - still seems a bit clumsy) Does anyone have any comments on doing this? Many thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Archival Freeze - Painful lessons learned
If you have freed up the space and your archiver is STILL hung, read note 131427.1 on MetaLink. This was my painful lesson. Jay >>> [EMAIL PROTECTED] 04/12/02 06:38PM >>> After reading the other postings I better add this one too;^) (If ya didn't learn something new today, it's because ya didn't do anything today). ORA-00257, "archiver error. Connect internal only, until freed." Brian P. MacLean Oracle DBA, OCP8i Brian P MacLean To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] 04/12/02 02:19 Subject: Re: Archival Freeze - Painful lessons learned(Document link: PM Brian P MacLean) As Daffy Duck says -> http://www.dailywav.com/0700/dcorrect.wav The archiver freaks first, and will keep trying to write/recover/looking for space. But the database will not hang until all the redo logs are full and none remain that have been archived (ie: all redo logs need archiving). The error in the alert.log is some combination of: ORA-00255, "error archiving log %s of thread %s, sequence # %s" ORA-00270, "error creating archive log %s" ORA-19504, "failed to create file \"%s\"" ORA-27040, "skgfrcre: create error, unable to create file" ARCH: Archival stopped, error occurred. Will continue retrying SVR4 Error: 5: I/O error Why do I have a list of the above errors you ask? Because I've been there (painful lessons learned), and these are just some of the errors I look for in my db status script. Brian P. MacLean Oracle DBA, OCP8i Rajesh.Rao@jpm chase.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Archival Freeze om 04/12/02 02:13 PM Please respond to ORACLE-L Hi Fellow DBAs, I and a fellow DBA are currently debating about how insufficient space in the archive destination freezes up the DB. He claims that as soon as the ARCH process is unable to write to the disk, the db freezes. I am of the opinion that it does not. It will only report an error (Any idea, what the error code is?). It will only freeze when it cycles thru the rest of the redolog groups, and then when it tries to switch log to the one which has not been archived. That's why the error message is "cannot allocate new log". Whats your say? He's also on this list. Raj -- 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
RBS question
Hi All I have just been asked to find if there's contention in the rollback segment header.. which tables (columns) should I look in ? TIA SI -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Recompiling Invalid Objects after Table Rename
Hi all, We have an application which deletes a large number of rows from a table. It would be faster to simply insert the rows that we want to keep into a second table, drop the original table and then rename the second table to that of the one we have just dropped. The only downside that I can see is that all the source objects which reference the original table become invalid. We could: 1. Simply allow the source objects to be recompiled naturally overtime as they are reused (but with the possibility of a large number of invalid objects at any one time in the database and little control over when compilation is done). 2. Force recompilation following the drop table. However this would require logging all objects which would need recompilation. This is an additional step for any new development and would therefore the list of object would be prone to become inaccurate over time. (Could maybe do this automatically using USER_REFERENCES prior to the drop table? - still seems a bit clumsy) Does anyone have any comments on doing this? Many thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: protocol.ora
I believe that this functionality is now (i.e. 8.1.7 )encapsulated into CMAN -Original Message- Sent: Monday, April 15, 2002 11:58 To: Multiple recipients of list ORACLE-L Hi I tried this however I get the same result as in it doesn't allow any connections at all..even IP addresses which are included in the .protocol.ora file. Regards Saj Iqbal On Fri, 12 Apr 2002, Jeremiah Wilton wrote: > If you trace the listener you will see that it is looking for > .protocol.ora with a leading period. This is a documented bug. Just > copy protocol.ora to .protocol.ora. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Fri, 12 Apr 2002, Sajid Iqbal wrote: > > > We used to use the protocol.ora file to restrict access to the database, > > on oracle 8.0.5 > > > > However since moving to Oracle 8.1.6.3 this doesn't work. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Phoee, Find views with column name
I'm not sure if probing the sga would work - its common in systems that do a lot of parsing to see many calls to view$ in trace files (for the same view) - leading to the hypothesis that view defn's are not cached. hth connor --- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote: > If it's only aliases you need to worry about you can > get the view text and use dbms_sql.parse and > dbms_sql.describe_columns to get the names. However > if the column in the view is involved in a function > or perhaps used in conjunction with another > column, then this method does not work. > > There was an admittedly ugly suggestion of" getting > the view names from one of the dependencies tables; > renaming the table containing the column of > interest; creating another table with the same name > and structure as the original one but with the > column missing, and then checking to see which > views became invalid. I wouldn't do that on a > production system. > > One would think that once a view has been parsed, > Oracle would hold that somewhere in memory. I don't > know the X$ structures well enough. Perhaps it > isn't accessible. Perhaps one needs to dump the > SGA. > > It looks like the real answer is to write your own > parser. > > Ian MacGregor > Stanforfd Linear Accelerator Center > [EMAIL PROTECTED] > > -Original Message- > Sent: Thursday, April 11, 2002 2:34 PM > To: Multiple recipients of list ORACLE-L > > > This won't work if I alias the column name in the > view definition, would it? > > Raj > __ > Rajendra JamadagniMIS, 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: Thursday, April 11, 2002 5:24 PM > To: Multiple recipients of list ORACLE-L > > > Darn E-mail package. Every once in a while I get a > message as I'm deleting > one > or more I don't want & one I do want goes as well. > Well, I guess that's > IBM/Lotus for you. > > Anyway, someone asked how to find all the views that > include a specific > column. > Try the following: > > select view_name > from user_views, user_tab_columns > where view_name = table_name > and column_name = ''; > > Dick Goulet > > > -- > 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: MacGregor, Ian 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). = 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: 8i migration - full import or schema imports ?
Agreed. In particular an effective (although rather deceitful) strategy is to indicate that you will be doing an unload/reload (to obtain the necessary downtime committment from management) but then (a) do a migration and (b) take advantage of all those 8i features to reorg the data "in place" via 'alter table move' and 'alter index rebuild' et al. In this way, you manage to do a migration as well as getting one of those precious few moments to do a reorg of your system hth connor --- Jared Still <[EMAIL PROTECTED]> wrote: > > That depends on the size of your database. > > If over 20 gig or so, you may want to do migration > rather than an import. Imports are rather slow, > even > when optimized. > > Jared > > On Sunday 14 April 2002 15:18, jaroszewski andrzej > wrote: > > We are planning to perform migration from 7.3.4 to > 8i. We are considering > > full import versus schema by schema imports. > > What is the better method and what are the cons > and pros. > > > > Thanks > > Andrew > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = 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: protocol.ora
Hi I tried this however I get the same result as in it doesn't allow any connections at all..even IP addresses which are included in the .protocol.ora file. Regards Saj Iqbal On Fri, 12 Apr 2002, Jeremiah Wilton wrote: > If you trace the listener you will see that it is looking for > .protocol.ora with a leading period. This is a documented bug. Just > copy protocol.ora to .protocol.ora. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Fri, 12 Apr 2002, Sajid Iqbal wrote: > > > We used to use the protocol.ora file to restrict access to the database, > > on oracle 8.0.5 > > > > However since moving to Oracle 8.1.6.3 this doesn't work. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rman, Duplicating without set untill.... & cloning with/BUG
Hi Oracle WWS, have asked me to send the output of RDA if I wish to purue this as a new bug (of course I want this) They figured it port specific but I'm on IBM and jay is on tru64 so not really port specific Jay should I mention that tru64 also has the same problem?? Jack "Robin Li" <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Re: Rman, Duplicating without set untill & cloning with 12-04-2002 17:59 Please respond to ORACLE-L I think your theory is correct. I have the same experience, I have to use SET UNTIL, otherwise RMAN complains about the archivelogs. Oracle 8.1.7 on IBM AIX. Robin Jay Hostetter wrote: > > My experience has been that RMAN will try to restore the database right up to the current point-in-time of the production database. So if you are on a remote system, it will be looking for data in the current redo logs (or logs that were archived since the backup), which it can't access. Oracle claims that RMAN will restore the last backup, but I think it is trying to bring the duplicated DB in sync with production. > > I am on 8.1.7 on Tru64. I haven't investigated this enough to prove the theory, so I could be wrong. All I know is that if I don't use SET UNTIL when duplicating a database, RMAN complains about missing archivelogs. > > Jay > > >>> [EMAIL PROTECTED] 04/12/02 10:13AM >>> > I duplicate without at set until time using 8.0.6.3. I follow the > instructions from Metalink. I duplicate our production databases to another > box and change the names from prd to rpt. I do clone all of the > tablespaces. > > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, April 12, 2002 5:58 AM > tablespaces > > Hi All, > > I'm currently in the middle of a tar with Oracle about duplicating without > set until time/scn According to the doc's it must be possible but when > trying I get an error message about an archive log file that it needs but > is not yet there. > Any of you duplicating without set untill time/scn etc.. w/o problems > > if so what version RMAN/Oracle What OS/version > What sequence of actions do you perform? > > Second I try to find the rman alternative to cloning just a part of the > database but can't find anything in the Doc's > Anybody > > TIA > > Jack > > === > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u > vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender > en het origineel en eventuele kopieën te verwijderen en te vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. >
