Re: URGENT REPORTS
Gene, Good stuff. Thanks for the tip. ed - Original Message - From: Gene Sais To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 6:29 PM Subject: RE: URGENT REPORTS What I like about VNC, is that all you need for a client is a browser. http://ip.address:5800 gets you a nice java client connection. Gene [EMAIL PROTECTED] 09/24/03 06:14PM If y'all do choose a VNC route, I'd highly recommend the free and GPL'dTightVNC from http://www.tightvnc.com/Better compression, better security, and better performance then otherRFB-compliant VNC flavors.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Wednesday, September 24, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSetting up vnc server and directing DISPLAY to that is easier, I think. Ihave a Apps reports server setup which has run for few years for now withvnc server.Tanel.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, Rich INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Guys, This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route? -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 24, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Setting up vnc server and directing DISPLAY to that is easier, I think. I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT REPORTS
Title: RE: URGENT REPORTS You got to have xvnc server installed somewhere, then you can direct any X app to it as you would do with normal X. So the app appears on vnc virtual display and if you want to see it, you have to connect to this virtual display using vncviewer. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, September 25, 2003 7:15 PM Subject: RE: URGENT REPORTS Guys, This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route? -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 24, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Setting up vnc server and directing DISPLAY to that is easier, I think. I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT REPORTS
Title: RE: URGENT REPORTS An X-DISPLAY application (Reports) needs to access an X-display terminal in order for it to run.You can either give it a real X-terminal, or you can simulate the functionality (pretend X terminal) with software, either Xvbf or VNC. Since the application doesn't need to really display anything, it doesn't know any better, so runs along quite happily. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, September 26, 2003 4:15 AM Subject: RE: URGENT REPORTS Guys, This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route? -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 24, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Setting up vnc server and directing DISPLAY to that is easier, I think. I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Thanks. -Original Message-From: Binley Lim [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 1:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT REPORTS An X-DISPLAY application (Reports) needs to access an X-display terminal in order for it to run.You can either give it a real X-terminal, or you can simulate the functionality (pretend X terminal) with software, either Xvbf or VNC. Since the application doesn't need to really display anything, it doesn't know any better, so runs along quite happily. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, September 26, 2003 4:15 AM Subject: RE: URGENT REPORTS Guys, This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route? -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 24, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Setting up vnc server and directing DISPLAY to that is easier, I think. I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT REPORTS
Title: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Thanks. -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 4:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
Re: URGENT REPORTS
Title: RE: URGENT REPORTS Setting up vnc server and directing DISPLAY to that is easier, I think.I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. - Original Message - From: Johnston, Tim To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 11:09 PM Subject: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: URGENT REPORTS
You can't. As of about a year or so ago, there must be a buffer available for reports. vnc works nicley for this. Many notes/articles on Metalink concerning this. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: URGENT REPORTS com 09/24/2003 01:54 PM Please respond to ORACLE-L Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT REPORTS
If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Setting up vnc server and directing DISPLAY to that is easier, I think. I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT REPORTS
What I like about VNC, is that all you need for a client is a browser. http://ip.address:5800 gets you a nice java client connection. Gene [EMAIL PROTECTED] 09/24/03 06:14PM If y'all do choose a VNC route, I'd highly recommend the free and GPL'dTightVNC from http://www.tightvnc.com/Better compression, better security, and better performance then otherRFB-compliant VNC flavors.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Wednesday, September 24, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSetting up vnc server and directing DISPLAY to that is easier, I think. Ihave a Apps reports server setup which has run for few years for now withvnc server.Tanel.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, Rich INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: URGENT REPORTS WONT START
Title: RE: URGENT REPORTS WONT START It was a problem with 2 things: 1-someone had changed the display on me! 2-conf file was corrupted. Worked it out but can anyone tell me where I can get more robust descriptions of the conf files and how to edit them and each part of them? Thanks, Paula -Original Message- From: Govindan K [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 11, 2003 9:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS WONT START Not sure if this would be of 1% help. I remember getting into similar trouble when i was working on 9iAS stuff. - Is there any reference to server name? If so replace it with IP address. - Do you have original copy of the conf file. If so do a unix diff to see where all the difference arises. May be some / is missed out while closing the tag? Can you mail me the conf file highlighting the changes? GovindanK On Thu, 11 Sep 2003 10:59 , [EMAIL PROTECTED] sent: RE: URGENT REPORTS WONT START Getting error: REP-50125: Caught exception: java.lang.reflect.InvocationTargetException One note I found on web said to comment out some tags. Doesn't seem to help. Any ideas? Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT REPORTS WONT START
Title: RE: URGENT REPORTS WONT START Getting error: REP-50125: Caught exception: java.lang.reflect.InvocationTargetException One note I found on web said to comment out some tags. Doesn't seem to help. Any ideas?
RE: URGENT REPORTS WONT START
Not sure if this would be of 1% help. I remember getting into similar trouble when i was working on 9iAS stuff. - Is there any reference to server name? If so replace it with IP address. - Do you have original copy of the conf file. If so do a unix diff to see where all the difference arises. May be some / is missed out while closing the tag? Can you mail me the conf file highlighting the changes? GovindanK On Thu, 11 Sep 2003 10:59 , [EMAIL PROTECTED] sent: RE: URGENT REPORTS WONT START Getting error: REP-50125: Caught exception: java.lang.reflect.InvocationTargetException One note I found on web said to comment out some tags. Doesn't seem to help. Any ideas? Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent INFO needed. - OFF TOPIC
Yeah, well, when all the American IT companies conquered (spelling?) the world and ran the Danish HW-vendors in the ground, as well as a lot of small and medium sized SW-shops, I think - but I could be awfully wrong here :-) - most Americans thought that was because we were too expensive, too lazy, too lesbian, too something, and that we could just go out and compete, or find some new cheese. Otherwise, I think they called us a bunch of bad losers. I think - but, again, I'm probably very wrong here - the same happened with our esteemed weapons industry. Who can ever forget the wonderful Madsen machinegun, for instance? I know for a fact it has happened a lot in agriculture... So yes, jobs are moved around, and it's not funny anymore when it's our jobs. But there's only one thing to do about it: Go out and find some new cheese. It's hopefully past those days where the Danish Government would forbid the Danish Military to buy American weapons, or we would have import controls on American software and hardware in order to stimulate domestic production of some Unix compute like the excellent NUMA architecture of DDE... Mogens Longballs Nogood VIVEK_SHARMA wrote: Well-Spoken Indeed -Original Message- Sent: Friday, September 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Yes, in your experience...and maybe most of the other lister's experience...majority of the time its true... That's because you people are the best DBAs I've seen... Your experiences...10...15 years...some of you have a little over 3 years and are already experts... Of course a lot of other people are less skilled than you are... But I am not sure if you represent the rest of the US DBAs...or if I represent the rest of the 3rd world DBAs... Again, as I have said...some peopler are just better than others...that's my opinion...obviously, yours is a lot different than mine... I don't know you, Joe, well enough to judge you. So I won't call you names. Joe Testa wrote: Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday,
RE: Urgent INFO needed. - OFF TOPIC
Well-Spoken Indeed -Original Message- Sent: Friday, September 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Yes, in your experience...and maybe most of the other lister's experience...majority of the time its true... That's because you people are the best DBAs I've seen... Your experiences...10...15 years...some of you have a little over 3 years and are already experts... Of course a lot of other people are less skilled than you are... But I am not sure if you represent the rest of the US DBAs...or if I represent the rest of the 3rd world DBAs... Again, as I have said...some peopler are just better than others...that's my opinion...obviously, yours is a lot different than mine... I don't know you, Joe, well enough to judge you. So I won't call you names. Joe Testa wrote: Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, September 03, 2003 5:30 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: URGENT : sql*loader performance problem on partionned tab
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab here the trace : SELECT STATEMENT, GOAL = CHOOSE 2 72 1368 FOR UPDATE FILTER PARTITION RANGE SINGLE TABLE ACCESS BY LOCAL INDEX ROWID FICOM HREL_FUSION 2 72 1368 INDEX RANGE SCAN FICOM IDX_HREL_FUSION_P_COD_REL 1 72 TABLE ACCESS BY INDEX ROWID FICOM PRIMEDI_ENR2_TEMP_FUSION 2 1 32 INDEX RANGE SCAN FICOM IDX_PRIMCOD_ENR2_TEMP_FUSION 1 1 TIA Philippe Nguyen CETELEM - Administration, Architecture Décisionnelle Direction Customer Relationship Management E-Mail : [EMAIL PROTECTED] Tel : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88 -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : 05 September 2003 00:09 À : Multiple recipients of list ORACLE-L Objet : RE: RE: URGENT : sql*loader performance problem on partionned tab Did you explain plan? I suspect FTS taking place in case of NOT EXISTS. It must be using Range scan for the non partitioned table. Can you confirm / post the explain plan. GovindanK Here the informations : table HREL_FUSION : 63 millions rows 3 indexes on columns : nodos_or, nodos_or, numcli --- too much indexes ?? table primedi_enr2_temp_fusion : 133 000 rows I also took snaps with stastpack, can it help you ? this table is recreated and re-analyze each day, but the hanging part of the scritp in located here : ** SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or AND primedi_enr2_temp_fusion.code_logis = hrel_fusion.cod_rel AND primedi_enr2_temp_fusion.date_logis = hrel_fusion.dat_rel) FOR UPDATE ** The mostly amazing thing is that the same script work in 12 min on non-partitionned table. Here a subset of the script : *** cat EOD $maj_histo_rel set serveroutput on; DECLARE vt_code_logis char(4); vt_date_logis number(4); n number; cursor curs_code_ctlm is select code_logis,date_logis from primedi_temp_fusion where exists (select null from $TABLE_RETOURS where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom ) ; cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is select null from HREL_FUSION where cod_rel=vt_code_logis and dat_rel=vt_date_logis and not exists (select null from primedi_enr2_temp_fusion where primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or and primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel and primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel) for update ; BEGIN DBMS_OUTPUT.ENABLE(50); for curs in curs_code_ctlm loop n:=0; for enr_histo in curs_histo_ctlm1 (curs.code_logis,curs.date_logis) loop delete from HREL_FUSION where current of curs_histo_ctlm1; n:=n+1; --if (mod(n,5000) = 0) then --commit; --end if; end loop; --commit; DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) ' ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION'); -- update $TABLE_RETOURS -- set DATE_MAJ=to_number(to_char(sysdate,'mmdd')) -- where exists (select null from primedi_temp_fusion -- where curs.code_logis=$TABLE_RETOURS.code_logis -- and curs.date_logis=$TABLE_RETOURS.date_logis -- ) --; end loop; COMMIT; END; / exit; EOD *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent INFO needed.
Maria I just wanted to thank you for posting your views on the DBA situation from your perspective. I always feel better informed when I have an opportunity to hear opinions from people whose situation is different from mine. And I agree with you that this is a valuable forum where people with a staggering amount of expertise are willing to spend a few moments helping you. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 12:14 AM To: Multiple recipients of list ORACLE-L Yes, in your experience...and maybe most of the other lister's experience...majority of the time its true... That's because you people are the best DBAs I've seen... Your experiences...10...15 years...some of you have a little over 3 years and are already experts... Of course a lot of other people are less skilled than you are... But I am not sure if you represent the rest of the US DBAs...or if I represent the rest of the 3rd world DBAs... Again, as I have said...some peopler are just better than others...that's my opinion...obviously, yours is a lot different than mine... I don't know you, Joe, well enough to judge you. So I won't call you names. Joe Testa wrote: Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, September 03, 2003 5:30 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com - Free, easy-to-use web site
RE: RE: URGENT : sql*loader performance problem on partionned tab
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb! Here the informations : table HREL_FUSION : 63 millions rows 3 indexes on columns : nodos_or, nodos_or, numcli --- too much indexes ?? table primedi_enr2_temp_fusion : 133 000 rows I also took snaps with stastpack, can it help you ? this table is recreated and re-analyze each day, but the hanging part of the scritp in located here : ** SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or AND primedi_enr2_temp_fusion.code_logis = hrel_fusion.cod_rel AND primedi_enr2_temp_fusion.date_logis = hrel_fusion.dat_rel) FOR UPDATE ** The mostly amazing thing is that the same script work in 12 min on non-partitionned table. Here a subset of the script : *** cat EOD $maj_histo_rel set serveroutput on; DECLARE vt_code_logis char(4); vt_date_logis number(4); n number; cursor curs_code_ctlm is select code_logis,date_logis from primedi_temp_fusion where exists (select null from $TABLE_RETOURS where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom ) ; cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is select null from HREL_FUSION where cod_rel=vt_code_logis and dat_rel=vt_date_logis and not exists (select null from primedi_enr2_temp_fusion where primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or and primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel and primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel) for update ; BEGIN DBMS_OUTPUT.ENABLE(50); for curs in curs_code_ctlm loop n:=0; for enr_histo in curs_histo_ctlm1 (curs.code_logis,curs.date_logis) loop delete from HREL_FUSION where current of curs_histo_ctlm1; n:=n+1; --if (mod(n,5000) = 0) then --commit; --end if; end loop; --commit; DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) ' ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION'); -- update $TABLE_RETOURS -- set DATE_MAJ=to_number(to_char(sysdate,'mmdd')) -- where exists (select null from primedi_temp_fusion -- where curs.code_logis=$TABLE_RETOURS.code_logis -- and curs.date_logis=$TABLE_RETOURS.date_logis -- ) --; end loop; COMMIT; END; / exit; EOD ***
Re: Urgent INFO needed.
I could not say it in a better way /Quamrul From: Maria Aurora de la Vega <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Urgent INFO needed. Date: Wed, 03 Sep 2003 21:19:41 -0800 Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that "you get what you pay for" or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- From: Ora DBA [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 5:30 AM To: Multiple recipients of list ORACLE-L Subject: Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software Try MSN Messenger 6.0 with integrated webcam functionality! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quamrul Polash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent INFO needed.
Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, September 03, 2003 5:30 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com - Free, easy-to-use web site design software -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent INFO needed.
Joe, It's all about dollars and cents, true. In your view, can a company look past the next quarter and see that by outsourcing they might be jumping over dollars to save pennies? Example, most of the companies in my region aren't Fortune 500, they're small manufacturing outfits - it's rare to see a company with more than a thousand people on the payroll. By outsourcing, they loose all of their flexibility as regards what they can do with IT. This has costs and consquences beyond the next quarter, sometimes it won't have an impact for years. Can the corporate mindset look that far ahead? ~brian -Original Message- Sent: Thursday, September 04, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, September 03, 2003 5:30 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com - Free, easy-to-use web site design software -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: RE: URGENT : sql*loader performance problem on partionned tab
Did you explain plan? I suspect FTS taking place in case of NOT EXISTS. It must be using Range scan for the non partitioned table. Can you confirm / post the explain plan. GovindanK Here the informations : table HREL_FUSION : 63 millions rows 3 indexes on columns : nodos_or, nodos_or, numcli --- too much indexes ?? table primedi_enr2_temp_fusion : 133 000 rows I also took snaps with stastpack, can it help you ? this table is recreated and re-analyze each day, but the hanging part of the scritp in located here : ** SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or AND primedi_enr2_temp_fusion.code_logis = hrel_fusion.cod_rel AND primedi_enr2_temp_fusion.date_logis = hrel_fusion.dat_rel) FOR UPDATE ** The mostly amazing thing is that the same script work in 12 min on non-partitionned table. Here a subset of the script : *** cat EOD $maj_histo_rel set serveroutput on; DECLARE vt_code_logis char(4); vt_date_logis number(4); n number; cursor curs_code_ctlm is select code_logis,date_logis from primedi_temp_fusion where exists (select null from $TABLE_RETOURS where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom ) ; cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is select null from HREL_FUSION where cod_rel=vt_code_logis and dat_rel=vt_date_logis and not exists (select null from primedi_enr2_temp_fusion where primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or and primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel and primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel) for update ; BEGIN DBMS_OUTPUT.ENABLE(50); for curs in curs_code_ctlm loop n:=0; for enr_histo in curs_histo_ctlm1 (curs.code_logis,curs.date_logis) loop delete from HREL_FUSION where current of curs_histo_ctlm1; n:=n+1; --if (mod(n,5000) = 0) then --commit; --end if; end loop; --commit; DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) ' ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION'); -- update $TABLE_RETOURS -- set DATE_MAJ=to_number(to_char(sysdate,'mmdd')) -- where exists (select null from primedi_temp_fusion -- where curs.code_logis=$TABLE_RETOURS.code_logis -- and curs.date_logis=$TABLE_RETOURS.date_logis -- ) --; end loop; COMMIT; END; / exit; EOD *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent INFO needed.
Yes, in your experience...and maybe most of the other lister's experience...majority of the time its true... That's because you people are the best DBAs I've seen... Your experiences...10...15 years...some of you have a little over 3 years and are already experts... Of course a lot of other people are less skilled than you are... But I am not sure if you represent the rest of the US DBAs...or if I represent the rest of the 3rd world DBAs... Again, as I have said...some peopler are just better than others...that's my opinion...obviously, yours is a lot different than mine... I don't know you, Joe, well enough to judge you. So I won't call you names. Joe Testa wrote: Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, September 03, 2003 5:30 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com - Free, easy-to-use web site design software -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: Urgent INFO needed. - OFF TOPIC
$2.50 is simply because of the $ to Rupee PARITY RATIO respective Cost of Living here in India. Labor in India is NOT Cheap . It is Simply this ratio which gives the impression of being cheap. Also Outsourcers get to pay LESS because of the Current prevailing Work-to-Earnings monetary scenario existing in India. Usually Tech. competence , for most , is at par amongst professionals irrespective of nationality . -Original Message- Sent: Thursday, September 04, 2003 10:30 PM To: Multiple recipients of list ORACLE-L Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially today. Thats why you see it as much as you do. My example: I worked for an online training company, they were paying me $25/hr to do online tutoring or web based oracle DBA classes., I was with them from the beginning just like alot of other tutors from around th world. We were told in early/mid 2002, we've decided to outsource all tutoring to India, so if you're interested in teaching your replacements, we'll keep you on board for a little extra time. The end was near and someone had asked me how long I'd been doing it, how long I was a DBA and how long did I plan on doing it, i gave them the truthful answer, about 4 yrs, 10 years as a DBA and not much longer since it was all being outsourced to India, got my a$$ fired from the job before my time was up. Basically the concept was: we can go to India and pay $2.50, 10% of what we pay you and we really dont care about the quality because they will pick up their English language from previous answers you and others have submitted to students throughout the years.. You tell me I shouldn't have an attitude, you're as full of garbage as them. Joe PS: for those who want to know the company, email me direct, i'll be glad to share. Maria Aurora de la Vega wrote: Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that you get what you pay for or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- *From:* Ora DBA [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, September 03, 2003 5:30 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com - Free, easy-to-use web site design software -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for
RE: URGENT : sql*loader performance problem on partionned table
Title: RE: URGENT : sql*loader performance problem on partionned table precision : Oracle 8.1.7.3 (64 bits) in Solaris 8 -Message d'origine- De : NGUYEN Philippe (Cetelem) Envoyé : 02 September 2003 18:14 À : '[EMAIL PROTECTED]' Objet : URGENT : sql*loader performance problem on partionned table Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance!
RE: URGENT : sql*loader performance problem on partionned table
Title: RE: URGENT : sql*loader performance problem on partionned table thank U Dennis, I use local index, the script is still running (2hours now! instead of 10-20 min) and here is the statement in question (the script who used non-partionned table is already ended) SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or AND primedi_enr2_temp_fusion.code_logis = hrel_fusion.cod_rel AND primedi_enr2_temp_fusion.date_logis = hrel_fusion.dat_rel) FOR UPDATE The explain plan show that hrel_fusion table is ACCESS BY LOCAL INDEX ROWID and primedi table used INDEX too. When I looking at lock tables it show me 2 session locked : SQL select session_id, oracle_username, object_name 2 from v$locked_object lo, dba_objects o 3 where lo.object_id = o.object_id 4 ; SESSION_ID ORACLE_USERNAME OBJECT_NAME -- -- 7 FICOM HREL_FUSION 7 FICOM HREL_FUSION -Why are there 2 locks on this table even there only one session ? - Yesterday I did gather_statitic on this table and it worked fine (12 min), should I do this each day ? TIA Philippe -Message d'origine- De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Envoyé : 02 September 2003 19:45 À : Multiple recipients of list ORACLE-L Objet : RE: URGENT : sql*loader performance problem on partionned table Philippe You aren't providing many details on which to base some guesses. However, your statement brand new disks implies that you are adding additional partitions to an existing table. Then, your statement should I drop indexes implies that you have indexes on the partitioned table, possibly global indexes. If you are continuing to grow a partitioned (or non-partitioned) table than has indexes, then the load time will increase because Oracle must integrate each new entry into the index, which will take more time as the index grows. Take a look at local indexes. If I not understood your situation correctly, please clarify your situation further. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 02, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]
Re: URGENT : sql*loader performance problem on partionned table
Yesterday i posted a reply on this .. but did not reach. Check if too much logging taking place. Avoid this with loading as UNRECOVERABLE; Or else Presort the data on the index key to minimise the use of Temp segment. As of now i am able to think of only these two. HTH GovindanK Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT : sql*loader performance problem on partionned table
Hello Did you check alert.log for any unusual messages? May be it is using lot of rollback / archiving. You can use unrecoverable option to load. You have not mentioned whether you are using direct load or not. Check if too many extents are getting allocated at runtime. That is going to slow down the load. Presorting data on indexed columns is another method to speeden up load. This is likely to minimise the use of temp segment. HTH GovindanK Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT : sql*loader performance problem on partionned table
Title: RE: URGENT : sql*loader performance problem on partionned table thankx for all those advbices, actually,the problem does not come from the sql*loader but from this particular statement: SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or AND primedi_enr2_temp_fusion.code_logis = hrel_fusion.cod_rel AND primedi_enr2_temp_fusion.date_logis = hrel_fusion.dat_rel) FOR UPDATE The explain plan show that hrel_fusion table is ACCESS BY LOCAL INDEX ROWID and primedi table used INDEX too. When I looking at lock tables it show me 2 session locked : SQL select session_id, oracle_username, object_name 2 from v$locked_object lo, dba_objects o 3 where lo.object_id = o.object_id 4 ; SESSION_ID ORACLE_USERNAME OBJECT_NAME -- -- 7 FICOM HREL_FUSION 7 FICOM HREL_FUSION -Why are there 2 locks on this table even there only one session ? - Yesterday I did gather_statitic on this table and it worked fine (12 min), should I do this each day ? TIA Philippe -Message d'origine- De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Envoyé : 02 September 2003 19:45 À : Multiple recipients of list ORACLE-L Objet : RE: URGENT : sql*loader performance problem on partionned table Philippe You aren't providing many details on which to base some guesses. However, your statement "brand new disks" implies that you are adding additional partitions to an existing table. Then, your statement "should I drop indexes" implies that you have indexes on the partitioned table, possibly global indexes. If you are continuing to grow a partitioned (or non-partitioned) table than has indexes, then the load time will increase because Oracle must integrate each new entry into the index, which will take more time as the index grows. Take a look at local indexes. If I not understood your situation correctly, please clarify your situation further. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 02, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]
Re: RE: URGENT : sql*loader performance problem on partionned table
1. by 'filling' are you doing inserts also? I see a 'FOR UPDATE' statement which implies that you are doing updates from with in a cursor. 2. How many indexes do you have on this table? 3. Is anything else running at the same time? 4. Are you doing your DML from with in a cursor. This is very slow. Try to do it all in SQL. 5. Consider changing your not exists to Where NOT IN (SELECT /*+ hash_aj */ ...) That can be faster if your sub-query is significantly less costly than your your outer query(its the opposite for exists). Wont necessarily help in your case. You can also eliminate the join with the 'in'. This can improve performance as well. Please post a subset of your batch script. Please format it so its readable. Ill look at it. Also please post how many rows are in each table. Ill see if I can find anything. I think the two locks on the same object are locks on seperate partitions. Not sure. From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED] Date: 2003/09/03 Wed AM 09:59:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: URGENT : sql*loader performance problem on partionned table thank U Dennis, I use local index, the script is still running (2hours now! instead of 10-20 min) and here is the statement in question (the script who used non-partionned table is already ended) SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or AND primedi_enr2_temp_fusion.code_logis = hrel_fusion.cod_rel AND primedi_enr2_temp_fusion.date_logis = hrel_fusion.dat_rel) FOR UPDATE The explain plan show that hrel_fusion table is ACCESS BY LOCAL INDEX ROWID and primedi table used INDEX too. When I looking at lock tables it show me 2 session locked : SQL select session_id, oracle_username, object_name 2 from v$locked_object lo, dba_objects o 3 where lo.object_id = o.object_id 4 ; SESSION_ID ORACLE_USERNAMEOBJECT_NAME -- -- 7 FICOM HREL_FUSION 7 FICOM HREL_FUSION -Why are there 2 locks on this table even there only one session ? - Yesterday I did gather_statitic on this table and it worked fine (12 min), should I do this each day ? TIA Philippe -Message d'origine- De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Envoyé : 02 September 2003 19:45 À : Multiple recipients of list ORACLE-L Objet : RE: URGENT : sql*loader performance problem on partionned table Philippe You aren't providing many details on which to base some guesses. However, your statement brand new disks implies that you are adding additional partitions to an existing table. Then, your statement should I drop indexes implies that you have indexes on the partitioned table, possibly global indexes. If you are continuing to grow a partitioned (or non-partitioned) table than has indexes, then the load time will increase because Oracle must integrate each new entry into the index, which will take more time as the index grows. Take a look at local indexes. If I not understood your situation correctly, please clarify your situation further. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 02, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Title: RE: URGENT : sql*loader performance problem on partionned table thank U Dennis, I use local index, the script is still running (2hours now! instead of 10-20 min) and here is the statement in question (the script who used non-partionned table is already ended) SELECT NULL FROM hrel_fusion WHERE cod_rel = :b1 AND dat_rel = :b2 AND NOT EXISTS (SELECT NULL FROM primedi_enr2_temp_fusion WHERE primedi_enr2_temp_fusion.nodos_or = hrel_fusion.nodos_or
RE: Urgent INFO needed.
All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message-From: Ora DBA [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 5:30 AMTo: Multiple recipients of list ORACLE-LSubject: Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: Urgent INFO needed.
That is call mondialisation... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tony JohnsonSent: Wednesday, September 03, 2003 3:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Urgent INFO needed. All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message-From: Ora DBA [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 5:30 AMTo: Multiple recipients of list ORACLE-LSubject: Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: Urgent INFO needed.
Actually, I've seen the reverse be true. I've seen the work offshore be so poor that more folks are brought in locally to correct the problems, yet the offshore remain too because of contractual issues. Happened to me on at least two different occations. You get what you pay for. There are some great Indian DBA's out there (KG for one is awsome), but just as in America, for every great one there are probably 5 that should take up some other profession. This will come and go like everything else. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/3/2003 3:44 PM That is call mondialisation... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Tony Johnson Sent: Wednesday, September 03, 2003 3:05 PM To: Multiple recipients of list ORACLE-L All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- Sent: Wednesday, September 03, 2003 5:30 AM To: Multiple recipients of list ORACLE-L Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA _ Do you Yahoo!? Yahoo! http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com SiteBuilder - Free, easy-to-use web site design software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent INFO needed.
i dont think so. There is too much money in this. Odds are they will refine their processes 'slowly' improve. Over a period of years they will be better. Will it always be as good as the US? No, but it doesnt need to be. Its cheap. This doesnt mean every IT job will dissapear, but there is a contraction in the market and it is continueing.. Those manufacturing jobs sent to sweat shops never came back due to lack of quality? No I dont think the IT market will dissapear, however, I think wages will continue to decline at least for a while. Most of the jobs out there these days are low paying, short temp jobs. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 5:29 PM Actually, I've seen the reverse be true. I've seen the work offshore be so poor that more folks are brought in locally to correct the problems, yet the offshore remain too because of contractual issues. Happened to me on at least two different occations. You get what you pay for. There are some great Indian DBA's out there (KG for one is awsome), but just as in America, for every great one there are probably 5 that should take up some other profession. This will come and go like everything else. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/3/2003 3:44 PM That is call mondialisation... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Tony Johnson Sent: Wednesday, September 03, 2003 3:05 PM To: Multiple recipients of list ORACLE-L All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- Sent: Wednesday, September 03, 2003 5:30 AM To: Multiple recipients of list ORACLE-L Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA _ Do you Yahoo!? Yahoo! http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com SiteBuilder - Free, easy-to-use web site design software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent INFO needed.
Freeman Robert - IL wrote: Actually, I've seen the reverse be true. I've seen the work offshore be so poor that more folks are brought in locally to correct the problems, yet the offshore remain too because of contractual issues. Happened to me on at least two different occations. You get what you pay for. There are some great Indian DBA's out there (KG for one is awsome), but just as in America, for every great one there are probably 5 that should take up some other profession. This will come and go like everything else. RF I disagree about the 'you get what you pay for'. I have been reviewing in the past weeks code written both in Bangalore and in Paris, and in both cases I have had to reach for my Prozac box. For what had been written in France, it is the product of a big (US) consulting firm which must have been retrospectively happy to change their name a couple of years ago; note that it is in no way specific of them, I can exhibit dreadful code from multiple sources. I can assure you that it was both bad and expensive. Concerning what you pay for, I believe that whatever you outsource is far from being as cheap as it looks like; part of the problem is the existence of a contract, part of the problem is indeed the developers, part of the problem is that very few people can write decent specs - because in any creative process, and software engineering is one, you only converge towards the result through several iterations (just look at famous manuscripts or Old Masters X-ray pictures), and that interaction with end-users is essential. Which means that I agree with the conclusion :-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent INFO needed.
part of the problem is that very few people can write decent specs - because in any creative process, and software engineering is one, you only converge towards the result through several iterations Good point. If folks speaking the same language aren't communicating well how much more of a challenge is it when there is a language barrier?! Regarding clear specs, here's one of my keeper links about what it takes to write perfect software: http://www.fastcompany.com/online/06/writestuff.html Steve Orr -Original Message- Sent: Wednesday, September 03, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Importance: High I disagree about the 'you get what you pay for'. I have been reviewing in the past weeks code written both in Bangalore and in Paris, and in both cases I have had to reach for my Prozac box. For what had been written in France, it is the product of a big (US) consulting firm which must have been retrospectively happy to change their name a couple of years ago; note that it is in no way specific of them, I can exhibit dreadful code from multiple sources. I can assure you that it was both bad and expensive. Concerning what you pay for, I believe that whatever you outsource is far from being as cheap as it looks like; part of the problem is the existence of a contract, part of the problem is indeed the developers, part of the problem is that very few people can write decent specs - because in any creative process, and software engineering is one, you only converge towards the result through several iterations (just look at famous manuscripts or Old Masters X-ray pictures), and that interaction with end-users is essential. Which means that I agree with the conclusion :-). -- Regards, Stephane Faroult Oriole Software -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent INFO needed.
Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs in India or some other countries with cheaper labor. And to say that "you get what you pay for" or insinuating that cheaper labor means less quality...is definitely out of line... some people are just better than others...that's it...it has nothing to do with geography or nationality... some of the best DBAs...or IT professionals in general...are in fact indians... Point is its not the indians' fault jobs just come knocking at their doors... we all want better jobs and better pay...if it comes to me i'll grab it no doubt... would I think about other DBAs who were taken off to accomodate me? of course not. I have nothing to do with their decision to outsource...and even if I stress myself worrying about it...can I do anything about it? no...so, what do I do...I'd take advantage of course... I've come to believe no one is indispensable...even if you've served 5, 10, 15 years in a company...there's always a reason to take you out no matter how good you are... And sometimes companies think...do I really need someone that good and costs a lot more? or can we do with someone quite average but can get the job done and costs a lot less? Tony Johnson wrote: All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- From: Ora DBA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 03, 2003 5:30 AM To: Multiple recipients of list ORACLE-L Subject: Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: URGENT : sql*loader performance problem on partionned table
Philippe You aren't providing many details on which to base some guesses. However, your statement brand new disks implies that you are adding additional partitions to an existing table. Then, your statement should I drop indexes implies that you have indexes on the partitioned table, possibly global indexes. If you are continuing to grow a partitioned (or non-partitioned) table than has indexes, then the load time will increase because Oracle must integrate each new entry into the index, which will take more time as the index grows. Take a look at local indexes. If I not understood your situation correctly, please clarify your situation further. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 02, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Hi gurus, we have two daily loads that one after the other. The first fill up a non partitionned table and the second do the same into a partitionned table. First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours Any one has any clue ? - Tablespaces for partitionned table used brand new separate disks - Does it come from indexes ? should I drop them first ? Thankx in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consBTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consThere seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete
Re: URGENT!!! My 9i databases are not shutting down
Habit. The sync command is picked up by the scheduler sched and may not be executed immediately. With three sync calls, at least one goes through by the time you are ready to type in shutdown or init 0 Hemant At 08:04 AM 21-08-03 -0800, you wrote: Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Hemant K Chitale Oracle 9i
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consBTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consThere seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We
RE: URGENT!!! My 9i databases are not shutting down
Title: Message Tanel, It is more like 'two is company, three is a crowd'. The 'sync; sync; sync' was used in the days of yore when the disk controller was flaky and you had a few seconds of 'think time' on your hand in between commands. As Hemant says, it became a habit which still dogs me after 19 years - I have my (younger) colleagues here asking 'what is sync'? This was far better than my initial days when we used 8" AC Floppy drives whose speed varied with the electricity supply frequency and we had to use a frequency meter to note down the frequency during a floppy recording. [Btw - the term 'floppy' came from this media which was a flexible plastic based magnetic disk enclosed in a flexible - floppy - cover. And there was a 5 1/4" version before it finally became the 3 1/2" 'firm' disk]. I also worked on card punch IBM machines with 64 Kb RAM and 2 Mb (that right 2 MB!) system drives. Now back to Oracle stuff before Jared bears down on us :) John -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 9:19 AMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down Habit. The "sync" command is picked up by the scheduler "sched" and may not be executed immediately.With three "sync" calls, at least one goes through by the time you are ready to type in "shutdown" or "init 0"HemantAt 08:04 AM 21-08-03 -0800, you wrote: Hi!I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid)Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the inte
Re: URGENT!!! My 9i databases are not shutting down
John, thats just hilarious, i remember doing sync;sync;sync all the time and still once in a while type sync on a unix box :) joe John Kanagaraj wrote: Tanel, It is more like 'two is company, three is a crowd'. The 'sync; sync; sync' was used in the days of yore when the disk controller was flaky and you had a few seconds of 'think time' on your hand in between commands. As Hemant says, it became a habit which still dogs me after 19 years - I have my (younger) colleagues here asking 'what is sync'? This was far better than my initial days when we used 8 AC Floppy drives whose speed varied with the electricity supply frequency and we had to use a frequency meter to note down the frequency during a floppy recording. [Btw - the term 'floppy' came from this media which was a flexible plastic based magnetic disk enclosed in a flexible - floppy - cover. And there was a 5 1/4 version before it finally became the 3 1/2 'firm' disk]. I also worked on card punch IBM machines with 64 Kb RAM and 2 Mb (that right 2 MB!) system drives. Now back to Oracle stuff before Jared bears down on us :) John -Original Message- *From:* Hemant K Chitale [mailto:[EMAIL PROTECTED] *Sent:* Thursday, August 21, 2003 9:19 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Re: URGENT!!! My 9i databases are not shutting down Habit. The sync command is picked up by the scheduler sched and may not be executed immediately. With three sync calls, at least one goes through by the time you are ready to type in shutdown or init 0 Hemant At 08:04 AM 21-08-03 -0800, you wrote: Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message how about if I send you $1,111,111.11 3 times. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consBTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consThere seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message Hey Tom, You can send me $111 3 times and I'll be happy! ;o) -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons how about if I send you $1,111,111.11 3 times. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consBTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consThere seems to be a problem with consistent shutdowns i
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
I will not object to anything. You can send me $1 and I'll gladly take it
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message Thanks for all the wonderful and interesting responses - esp. Tim Gorman. I think that is what I needed. Sorry to resurface that old issue again. Mladen, you too? Did the nuns hit your knuckles with a ruler as well? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Hey Tom, You can send me $111 3 times and I'll be happy! ;o) -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons how about if I send you $1,111,111.11 3 times. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consBTW, nothing happening i
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message One thingI like about 'sync' is it will fail silently. i.e.., if you don't have privs, it will not complain but pretend that it completed successfully, which is correct, it completed successfully but didn't do anything. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Thanks for all the wonderful and interesting responses - esp. Tim Gorman. I think that is what I needed. Sorry to resurface that old issue again. Mladen, you too? Did the nuns hit your knuckles with a ruler as well? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Hey Tom, You can send me $111 3 times and I'll be happy! ;o) -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons how about if I send you $1,111,111.11 3 times. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message "Did the nuns hit your knuckles with a ruler as well?" three times for the father, son and holy ghost! PS - Jared, is this enough??? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Thanks for all the wonderful and interesting responses - esp. Tim Gorman. I think that is what I needed. Sorry to resurface that old issue again. Mladen, you too? Did the nuns hit your knuckles with a ruler as well? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Hey Tom, You can send me $111 3 times and I'll be happy! ;o) -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons how about if I send you $1,111,111.11 3 times. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Um, yeah. Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/21/2003 12:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Did the nuns hit your knuckles with a ruler as well? three times for the father, son and holy ghost! PS - Jared, is this enough??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Thanks for all the wonderful and interesting responses - esp. Tim Gorman. I think that is what I needed. Sorry to resurface that old issue again. Mladen, you too? Did the nuns hit your knuckles with a ruler as well? -Original Message- From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Hey Tom, You can send me $111 3 times and I'll be happy! ;o) -Scott Stefick -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons how about if I send you $1,111,111.11 3 times. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Thursday, August 21, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message Yes they did, despite the fact that Croatia had communism while I was growing up. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consUm, yeah. "Mercadante, Thomas F" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/21/2003 12:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT!!! My 9i databases are not shutting down cleanly/cons"Did the nuns hit your knuckles with a ruler as well?" three times for the father, son and holy ghost! PS - Jared, is this enough??? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consThanks for all the wonderful and interesting responses - esp. Tim Gorman. I think that is what I needed. Sorry to resurface that old issue again. Mladen, you too? Did the nuns hit your knuckles with a ruler as well? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consHey Tom, You can send me $111 3 times and I'll be happy! ;o) -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/conshow about if I send you $1,111,111.11 3 times. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consIt's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/consHi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people reall
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Um, yeah. [Shrek] sync sync sync move thread to [EMAIL PROTECTED] -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] A good intention but fixed and resolute - bent on high and holy ends, we shall find means to them on every side and at every moment; and even obstacles and opposition will but make us "like the fabled spectre-ships," which sail the fastest in the very teeth of the wind. - Ralph Waldo Emerson
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
A couple of corrections are in order here. First, some Christians might object to your characterizing the Holy Trinity, et. al. as mythology. Second, I thought we became food for worms, not ants. --- Mladen Gogala [EMAIL PROTECTED] wrote: It's a superstition. Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend into food for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33 -- Mladen Gogala Oracle DBA -Original Message- Tanel Poder Sent: Thursday, August 21, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 12:04 AM I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- ] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- ] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- ] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Paul Baumgartel wrote: A couple of corrections are in order here. First, some Christians might object to your characterizing the Holy Trinity, et. al. as mythology. I don't believe Andrei Rublev to be on this list. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT!!! My 9i databases are not shutting down
Oh, we're used to it. It's the predominant mythos of the current society. Everybody gets their own opinion unitl either death or judgment. Allan -Original Message- Sent: Thursday, August 21, 2003 5:09 PM To: Multiple recipients of list ORACLE-L cleanly/cons Paul Baumgartel wrote: A couple of corrections are in order here. First, some Christians might object to your characterizing the Holy Trinity, et. al. as mythology. I don't believe Andrei Rublev to be on this list. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Wow--that one sent me scrambling to Google. Nice riposte! --- Stephane Faroult [EMAIL PROTECTED] wrote: Paul Baumgartel wrote: A couple of corrections are in order here. First, some Christians might object to your characterizing the Holy Trinity, et. al. as mythology. I don't believe Andrei Rublev to be on this list. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons I think the reasoning falls somewhere between the utterly rational and the insanely superstitious... Ive known people who would keep repeating sync until their fingers started tripping over one another, so I tend to see three syncs as the minimum. At least, thats how it was explained to me 20 years ago: by the time you type it in for the third time, the first one has done the job... Go ahead, type in sync just once. I dare ya... on 8/21/03 9:04 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
$ su - root Password: [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# [EMAIL PROTECTED] root]# sync [EMAIL PROTECTED] root]# On 2003.08.22 00:34, Tim Gorman wrote: I think the reasoning falls somewhere between the utterly rational and the insanely superstitious... I¹ve known people who would keep repeating ³sync² until their fingers started tripping over one another, so I tend to see three ³sync²s as the minimum. At least, that¹s how it was explained to me 20 years ago: ³by the time you type it in for the third time, the first one has done the job²... Go ahead, type in ³sync² just once. I dare ya... on 8/21/03 9:04 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Hi! I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid) Tanel. - Original Message - From: Tim Gorman mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i?
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i?
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Paula - Haven't noticed an issue. What command are you using to shut down? SHUTDOWN IMMEDIATE? Are you receiving an error message? Anything in alert_log? Which Oracle version are you on? Most of my databases are 9.2.0.1. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 20, 2003 11:25 AM To: Multiple recipients of list ORACLE-L There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up No errors in the alert logs, no traces no ORA- but they don't shutdown cleanly and so I don't get consistent backups (this is every once in awhile). -Original Message-From: Josh Collier [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons What exactly "goes wrong"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i?
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Are you sure there are no jobs running during the time you are trying to shutdown. Murali. [EMAIL PROTECTED] tate.fl.usTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons om 08/20/2003 01:59 PM Please respond to ORACLE-L No errors in the alert logs, no traces no ORA- but they don't shutdown cleanly and so I don't get consistent backups (this is every once in awhile). -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons What exactly goes wrong? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up ...wait...for...it... -Original Message-From: Josh Collier [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons What exactly "goes wrong"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i?
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up Wait...and... wait... and w.a.i.t In our case, a lot of the problemwas 'supposed' to be a bug fixed in 9.2 (for a while it was EMN0 waking up... but now that error seems to have mysteriously disappeared)... oh and Oracle's position is... shutdown abort is a perfectly legitimate means of shutting down the database. So is just cycling the box but an option that I am comfortable with as a problem solution? NOT. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons ...wait...for...it... -Original Message-From: Josh Collier [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons What exactly "goes wrong"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Do you see any OS processes with high CPU usage? Rob Caldwell DBA - United Space Alliance www.unitedspacealliance.com -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 2:20 PM To: Multiple recipients of list ORACLE-L cleanly/cons Are you sure there are no jobs running during the time you are trying to shutdown. Murali. [EMAIL PROTECTED] tate.fl.usTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons om 08/20/2003 01:59 PM Please respond to ORACLE-L No errors in the alert logs, no traces no ORA- but they don't shutdown cleanly and so I don't get consistent backups (this is every once in awhile). -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons What exactly goes wrong? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Caldwell, Robert A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message April, it;s a bug. Below is bug description. Advice: upgrade to 9.2.0.4 ASAP. May the farce be with you. Bug:1841387 Fixed: 8173 9011 9201 Hangs / Spins Shutdown immediate sometimes takes more than 60 seconds even if there is no active transaction if PMON is busy when the shutdown is issued. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April WellsSent: Wednesday, August 20, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Note
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up Any errors ?? what does alert log say? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons Id suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)... Does anyone remember the UNIX mantra of entering sync; sync; sync before halt? :-) on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediate April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons BTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up What exactly "goes wrong"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i?
RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons sync, sync sync always reminded me of Benny Goodman. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim GormanSent: Wednesday, August 20, 2003 5:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting down cleanly/consI'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"? :-)on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote: We have started waiting 90 min then do shutdown abort, startup, shutdown immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWhich brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crashApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consBTW, nothing happening in terms of processes that would hang-up the system. Also, I have check alert and trace files and there are no obvious errors. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting down cleanly/consThere seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are running. Does anyone have problems shutting down their databases consistently with 9i? The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.Corporate Systems, Inc. has taken reasonable precautions to ensure that any attac
RE: Urgent! Is it safe to apply patch Windows2000-KB823980?
Luis: We're patching like crazy, too. So far, none of our systems has experienced any issues. We're running mostly 8 and 8i, with a couple 9i machines in there too, on NT4 and Win2k. Cheers, Mike -Original Message- Sent: Tuesday, August 19, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent! Is it safe to aply patch Windows2000-KB823980?
Thanks for your response. -Original Message- Sent: Tuesday, August 19, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste Systems Analyst PH. (850) 454.2943 e-mail: [EMAIL PROTECTED] Vertex Aerospace LLC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent! Is it safe to aply patch Windows2000-KB823980?
Hi, We've applied this on NT4 and W2K servers running 81745 with no Oracle issues. However, have seen 1 anomaly after this patch: nbtstat against a remote server no longer shows the logged on user name. This may have been a security improvement by design. Note you can still use the freeware psloggedon to see who is logged on to a server (may require admin privs on the target). Regards, Bruce Reardon -Original Message- Sent: Wednesday, 20 August 2003 3:49 AM Luis: We're patching like crazy, too. So far, none of our systems has experienced any issues. We're running mostly 8 and 8i, with a couple 9i machines in there too, on NT4 and Win2k. Cheers, Mike -Original Message- Sent: Tuesday, August 19, 2003 10:39 AM Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Urgent! Is it safe to apply patch Windows2000-KB823980?
Luis, Sorry for the delayed reply. we installed the same patch on all our 8i/9i instances on win2k. we have not faced any problem so far. Regards, Jp. Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent Business Proposal (Nigerian scam, with a twist)
lol OR SHOULD i HAVE SAID LOL! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Madhu, Can you ping the host? BTW, please use '!'s sparingly - I couldn't help but noticed that most of your message carry a few. They should be used for emergencies not just attention grabbers. Dennis -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
check listener.ora and the hostname of the box for resoltution problems. -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Madhu, If you are sure you are starting all the listeners, not just the default listener but named listeners as well (if any). I would look into the HPUX error next. What is file or directory is it looking for? I would examine the listener.ora closely and verify that the logging/tracing directories exist and the appropriate permissions are in place. Cross-check the listener.ora entries with the tnsnames.ora entries to make sure someone hasn't accidentally updated either file with invalid information. Carol -Original Message- Sent: Friday, August 15, 2003 1:34 PM To: Multiple recipients of list ORACLE-L file or Madhu, Can you ping the host? BTW, please use '!'s sparingly - I couldn't help but noticed that most of your message carry a few. They should be used for emergencies not just attention grabbers. Dennis -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER =service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pena, Carol A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
Yeah, that host is always reachable. As for the telnet, I don't run that thingy any more. It's ssh localhost, not telnet localhost. Telnet is politically incorect. -- Mladen Gogala Oracle DBA -Original Message- Testa Sent: Friday, August 15, 2003 3:59 PM To: Multiple recipients of list ORACLE-L i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USE R=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
very true and telnet service is usually disabled but localhost it just doesn't have the confusion for the newbies as 127.0.0.1 does joe Mladen Gogala wrote: Yeah, that host is always reachable. As for the telnet, I don't run that thingy any more. It's ssh localhost, not telnet localhost. Telnet is politically incorect. -- Mladen Gogala Oracle DBA -Original Message- Testa Sent: Friday, August 15, 2003 3:59 PM To: Multiple recipients of list ORACLE-L i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USE R=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
Not on ANY server. MANY, perhaps, but not ANY. Doesn't work for our HP/UX 11.0 servers here, nor my RH7.2/RH8.0 boxes at home. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
Let me rephrase it: it works on any machine which has telnet service up and running in shape or form, even on Windoze. -- Mladen Gogala Oracle DBA -Original Message- Jesse, Rich Sent: Friday, August 15, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Not on ANY server. MANY, perhaps, but not ANY. Doesn't work for our HP/UX 11.0 servers here, nor my RH7.2/RH8.0 boxes at home. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such
The only time I have seen this is when the server process could not be started because the database shared segment did not exist or an executable that was pointed to in the TNS entry actually did not exist. HP-UX error 2 is file not found so I think you are looking at the later case. It looks very much like you are trying to establish a dedicated connection through an mts dispatcher. Allan -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER =service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Title: Message Hi Paula Another issue you may encounter is that duplicate in 8.1.7may not work w/o a "set until" clause see bug 2329702 Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate database from cold backup - auxi This is the type of script I am using: rman EOFconnect target rman/[EMAIL PROTECTED]connect catalog rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run {resync catalog;allocate auxiliary channel d1 type disk;allocate auxiliary channel d2 type disk;set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch logfile';duplicate target database to test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 1M,'/data/oracle8/TEST3/redoTEST302.log' size 1M,'/data/oracle8/TEST3/redoTEST303.log' size 1M;}EOF -Original Message-From: Stankus, Paula G Sent: Monday, August 04, 2003 4:12 PMTo: '[EMAIL PROTECTED]'Subject: RE: URGENT: Trying to duplicate database from cold backup - auxiliary database not mounted error!!! Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d
RE: URGENT: Trying to duplicate database from cold backup - auxi
I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
We have top men working on that right now Mr. Jones. Who? Top Men. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/5/2003 5:29 PM Jared Okay, I'll bite. What do you mean about a separate project for verifying backups. It reminds me of the ending to the movie Indiana Jones - we have a team of top experts working on that, you know, the scene where they're packing the ark away in an enormous warehouse. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 05, 2003 5:19 PM To: Multiple recipients of list ORACLE-L auxi I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
No doubt about it, the old way is much easier. I've had to do it often enough that I wrote some PL/SQL, SQL and Perl to more or less automate the generation of the scripts needed to mount and unmount shares, copy files, generate the controlfile script and open up the database. Doing this with RMAN is prohibitively difficult. My reason for doing so was to get the experience needed to restore an entire database to a new server should the old one fail, as it is the same process. Jared Freeman Robert - IL [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Title: Message Thanks for the confirmation - I really believe that was it as well!! - please see my earlier e-mail. -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 05, 2003 5:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate database from cold backup - auxi Hi Paula Another issue you may encounter is that duplicate in 8.1.7may not work w/o a "set until" clause see bug 2329702 Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate database from cold backup - auxi This is the type of script I am using: rman EOFconnect target rman/[EMAIL PROTECTED]connect catalog rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run {resync catalog;allocate auxiliary channel d1 type disk;allocate auxiliary channel d2 type disk;set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch logfile';duplicate target database to test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 1M,'/data/oracle8/TEST3/redoTEST302.log' size 1M,'/data/oracle8/TEST3/redoTEST303.log' size 1M;}EOF -Original Message-From: Stankus, Paula G Sent: Monday, August 04, 2003 4:12 PMTo: '[EMAIL PROTECTED]'Subject: RE: URGENT: Trying to duplicate database from cold backup - auxiliary database not mounted error!!! Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d
RE: URGENT: Trying to duplicate database from cold backup - auxi
Jared Okay, I'll bite. What do you mean about a separate project for verifying backups. It reminds me of the ending to the movie Indiana Jones - we have a team of top experts working on that, you know, the scene where they're packing the ark away in an enormous warehouse. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 05, 2003 5:19 PM To: Multiple recipients of list ORACLE-L auxi I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 05, 2003 4:44 PM To: Multiple recipients of list ORACLE-L auxi BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT: Trying to duplicate database from cold backup - auxi
Hi! One of the fastest and most reliable ways to verify backups is to look into the safe (or drawer) and check whether the tapes are still there. It doesn't waste much IO bandwidth either, except a little in the path from your desk to the location of tapes. Only very little CPU processing is needed, especially when Async IO is available (= a junior DBA whom to send to check). You can verify virtually terabytes of any backups in less than a second using this proven method. Ok, time to go to sleep now, it's 2:21 AM here... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 2:59 AM You heard him. Top men. ;) Verifying backups is something we do in our spare time, one of those skunk works projects we don't tell our bosses about. ;) Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 03:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Jared Okay, I'll bite. What do you mean about a separate project for verifying backups. It reminds me of the ending to the movie Indiana Jones - we have a team of top experts working on that, you know, the scene where they're packing the ark away in an enormous warehouse. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 05, 2003 5:19 PM To: Multiple recipients of list ORACLE-L auxi I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED