RE: Oracle not available???
YOur network guys may have turned off access to ports 1521 or 1575 if you are using onames to stop the spread of the worm. I used to DBA 30 some instances on several windows boxes. Both NT and 2k. Pretty much made a point of rebooting at least once a week. Did cold backups so database was down anyway and adding a reboot was easy. One box we did not reboot regularly and it would eventually crash or lose its mind. I don't think we had a windows box up for more than 120 days on windows. (patching, crashes, memory leaks, hardware failure etc...) These were canned apps and they tended to have lots of extra crap installed on the DB server so rebooting was a prudent to prevent business hours downtime. One box was rebooted nightly due to poorly designed interface between a phone switch and a database. -Original Message- Sent: Thursday, September 04, 2003 1:45 AM To: Multiple recipients of list ORACLE-L Thanks Patrice, I'll look into this, however I find it way strange that the server has been running no problems for almost three months. Maybe a suggestion from one of the other listers is very pertinant - reboot bi-weekly perhaps. However I hear from my virus admin that we were attacked by another worm yesterday and also that it was not only my system that lost connections, the other system was a SQLserver machine. So makes me wonder. Anyway Patrice, I'll look into your suggestion, purely because I was did not know of it before, and thanks for the info. PS when you mention mem utilization stats - are thinking of the ones generated by the windows monitoring utility? Best Regards Denham Check in Task Manager, Performance Tab... upper right corner, Physical Memory (K) Total = lower left corner, Commit Charge (K) Peak = Commit Charge Peak should be less than half physical RAM, otherwise users may not be able to connect. Oracle can't be swapped to disk in Windows because it updates the data block and other headers regularly, and it's too fast for the Windows virtual memory manager. I don't know if this is the case only for busy databases, but I bumped into that here. Windows splits memory equally between kernel and user processes, that means you get to use about half the available RAM on your machine. User sessions can usually be swapped to disk (I think), if they are inactive. I would be curious to hear what memory utilization stats you have on the machine. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle not available???
No, in Task Manager. place the cursor over the task bar (at the bottom of the screen), right-click, and Task Manager will be one of the items listed. Open it, go to the Performance tab. Patrice. -Original Message- Sent: Thursday, September 04, 2003 3:45 AM To: Multiple recipients of list ORACLE-L Thanks Patrice, I'll look into this, however I find it way strange that the server has been running no problems for almost three months. Maybe a suggestion from one of the other listers is very pertinant - reboot bi-weekly perhaps. However I hear from my virus admin that we were attacked by another worm yesterday and also that it was not only my system that lost connections, the other system was a SQLserver machine. So makes me wonder. Anyway Patrice, I'll look into your suggestion, purely because I was did not know of it before, and thanks for the info. PS when you mention mem utilization stats - are thinking of the ones generated by the windows monitoring utility? Best Regards Denham Check in Task Manager, Performance Tab... upper right corner, Physical Memory (K) Total = lower left corner, Commit Charge (K) Peak = Commit Charge Peak should be less than half physical RAM, otherwise users may not be able to connect. Oracle can't be swapped to disk in Windows because it updates the data block and other headers regularly, and it's too fast for the Windows virtual memory manager. I don't know if this is the case only for busy databases, but I bumped into that here. Windows splits memory equally between kernel and user processes, that means you get to use about half the available RAM on your machine. User sessions can usually be swapped to disk (I think), if they are inactive. I would be curious to hear what memory utilization stats you have on the machine. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle not available???
Thanks Patrice, I'll look into this, however I find it way strange that the server has been running no problems for almost three months. Maybe a suggestion from one of the other listers is very pertinant - reboot bi-weekly perhaps. However I hear from my virus admin that we were attacked by another worm yesterday and also that it was not only my system that lost connections, the other system was a SQLserver machine. So makes me wonder. Anyway Patrice, I'll look into your suggestion, purely because I was did not know of it before, and thanks for the info. PS when you mention mem utilization stats - are thinking of the ones generated by the windows monitoring utility? Best Regards Denham Check in Task Manager, Performance Tab... upper right corner, Physical Memory (K) Total = lower left corner, Commit Charge (K) Peak = Commit Charge Peak should be less than half physical RAM, otherwise users may not be able to connect. Oracle can't be swapped to disk in Windows because it updates the data block and other headers regularly, and it's too fast for the Windows virtual memory manager. I don't know if this is the case only for busy databases, but I bumped into that here. Windows splits memory equally between kernel and user processes, that means you get to use about half the available RAM on your machine. User sessions can usually be swapped to disk (I think), if they are inactive. I would be curious to hear what memory utilization stats you have on the machine. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle not available???
You don't get any other message than a 'Not Available' message? I have one application that did that a lot, but that was because it's SGA was sized way to small. And, thankfully, the people on the this list help me over that bump in the road. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: Denham Eva [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 03, 2003 10:45 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle not available??? > > > Hello Gurus > > I had a weird one to day, all access to Oracle on our oracle > database was suddenly lost When you try to connect it > says that Oracle is on available. However the DB has been up > for more than 70 days. The other thing the service was > running and the Oracle process and listener was running? No > errors in the logs, nothing. > Server: Win2k, Oracle 817. > > > Has anyone experienced this before??? > > TIA > Denham Eva > Oracle DBA > Linux like TeePee... No Windows, No Gates and Apache inside! > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Denham Eva > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle not available???
Check in Task Manager, Performance Tab... upper right corner, Physical Memory (K) Total = lower left corner, Commit Charge (K) Peak = Commit Charge Peak should be less than half physical RAM, otherwise users may not be able to connect. Oracle can't be swapped to disk in Windows because it updates the data block and other headers regularly, and it's too fast for the Windows virtual memory manager. I don't know if this is the case only for busy databases, but I bumped into that here. Windows splits memory equally between kernel and user processes, that means you get to use about half the available RAM on your machine. User sessions can usually be swapped to disk (I think), if they are inactive. I would be curious to hear what memory utilization stats you have on the machine. Patrice. -Original Message- Sent: Wednesday, September 03, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hello Gurus I had a weird one to day, all access to Oracle on our oracle database was suddenly lost When you try to connect it says that Oracle is on available. However the DB has been up for more than 70 days. The other thing the service was running and the Oracle process and listener was running? No errors in the logs, nothing. Server: Win2k, Oracle 817. Has anyone experienced this before??? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle not available???
windozereboot... -Original Message- Sent: Wednesday, September 03, 2003 9:45 AM To: Multiple recipients of list ORACLE-L Hello Gurus I had a weird one to day, all access to Oracle on our oracle database was suddenly lost When you try to connect it says that Oracle is on available. However the DB has been up for more than 70 days. The other thing the service was running and the Oracle process and listener was running? No errors in the logs, nothing. Server: Win2k, Oracle 817. Has anyone experienced this before??? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle not available ???
If the database was shutdown cleanly, the online logs are not required or desired. If the database was not shutdown cleanly, you will not be able to open the database without them. Jared [EMAIL PROTECTED] .tenet.eduTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: RE: oracle not available ??? 01/01/02 07:30 PM Please respond to ORACLE-L Nagaraj, Yes, you may indeed have a problem. You say you backed up the datafiles. Did you get the redo logs and controlfile? How did your DB go down? Did it crash, or were you able to shut it down? If you're not in archivelog mode, are the redo logs that were current at the time of the most recent backup available? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Nagaraj Panyam" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/01/2002 11:55 AM PST Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle not available ???
A Cold Backup is always a Full backup --- all datafiles (and, highly recommended, all control files and redo log files). Did you shutdown the database twice but only backup 6 files each time ? How many log switches occurred between the first backup and the second ? If the transactions are still in the online redo logs, you might try a recovery. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Nagaraj Panyam" <[EMAIL PROTECTED]> 02/01/2002 03:55 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: oracle not available ??? Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle not available ???
Nagaraj, Yes, you may indeed have a problem. You say you backed up the datafiles. Did you get the redo logs and controlfile? How did your DB go down? Did it crash, or were you able to shut it down? If you're not in archivelog mode, are the redo logs that were current at the time of the most recent backup available? David A. BarbourOracle DBA, OCPAISD512-414-1002 "Nagaraj Panyam" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]01/01/2002 11:55 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: RE: oracle not available ??? Hi listI have a database recovery problem.The scenario is like thisa) My database is not in archive mode.b) I have taken a cold back up on two different times. 6 data files inthe morning and 6 in the evening. In between the database was startedand againWas shutdown before taking back up in the evening.I want to recover the database completely but I don't mind losing thedata of the period between the back ups.Can any one have solution.Thanks in advanceNAGARAJ--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Nagaraj Panyam INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle not available ???
Maybe I don't understand what you are saying but a cold backup is the complete database. There is no part there like you can do with a hot backup. So if you only backed up part of it the first time and part of it the second time and you are not in archive mode you are screwed. However, if it is indeed a full backup then just restore your latest. -Original Message- Panyam Sent: Tuesday, January 01, 2002 11:55 AM To: Multiple recipients of list ORACLE-L Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle not available ???
Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).