This happened to me one fine morning. For one of my databases, DBWR crashed and then all other processes died. After that neither svrmgrl not sqlplus were even starting. These just returned back to unix prompt. The errors in alert log were 600 and 7445 errors. I was running on 7.3.4 on digital unix 4.0D. Shared memory was still allocated for this instance and i was getting 6 trace files in udump directory every 5 minutes.
I Worked with oracle suppport on this. It seemed I had hit a bug resolved in 7.3.4.1 . Solution was to find shared memory segment for victim database by process of elimination using "oradebug ipc" on all other databases and "ipcs -b" on unix prompt and then removing the shared memory segments using ipcsrm (-s or -m for shared memory or semaphores)Monday, March 17, 2008
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(52)
-
▼
March
(52)
- Questions and Answers Create Oracle Host
- Questions and Answers Change the Port number after...
- Questions and Answers Problems with Password File
- Questions and Answers Fresh Install Done Login Pro...
- Questions and Answers How to create a DBMS Job?
- Questions and Answers HP UX 11.0 - Oracle 7.3.4 li...
- Questions and Answers Explain plan and Autotrace o...
- Questions and Answers Creating Dimensions in Oracl...
- Questions and Answers Oracle Performance On Differ...
- Questions and Answers Small Select Statement
- Questions and Answers java.sql.SQLException: ORA-1...
- Questions and Answers Find How Much Time Left For ...
- Questions and Answers Finding How Much Data Has Be...
- Questions and Answers Query about Data Storage and...
- Questions and Answers Why this Query Returns null
- Questions and Answers Update statements in Query
- Questions and Answers Questions and Answers
- Questions and Answers Need to write one PL/SQL pro...
- Questions and Answers Questions and Answers
- Questions and Answers List prerequisites to connec...
- Questions and Answers About Referential Integrity
- Questions and Answers Accessing Oracle Database
- Questions and Answers What is PL/SQL tables?
- Questions and Answers Using Trigger And Procedure ...
- Questions and Answers Error in PL/SQL block of tri...
- Questions and Answers Is IMPORT & EXPORT is platfo...
- Questions and Answers How Can I Copy Data in Anoth...
- Questions and Answers Advantage Between Range Scan...
- Questions and Answers Droping Logfile Group Failed
- Oracle Application Oracle Application Hints and Tips
- Control Files Backup and Recovery Tips
- Oracle Forms TEXT_IO code to write data to a flat ...
- Oracle Forms 4.5 FAQ
- Developer Programming Tips PL/SQL coding
- Developer Programming Tips Explain Plan Tips
- Developer Programming Tips Using SQL Plus
- Developer Programming Displaying Elapsed Time: The...
- Oracle Database How Can We Calculate Hit Ratios
- Oracle Database Cloning Database From Hot Backup
- Oracle Database Hindi Format In Oracle Database
- Oracle Database Processes that Used Too Much CPU R...
- Oracle Database Change Oracle Installation Locatio...
- Oracle Database Understand Exactly What a Schema Is
- Finding Oracle_SID Of A Database
- Oracle Database Oracle FAQ
- Oracle Database How To Find Out The Size Of Database
- Oracle Database How to find your log block size?
- Oracle Database Database Crashed. Server manager d...
- Oracle Database What does 'SNIPED' status in v$ses...
- Oracle Database What is "snapshot too old" error a...
- Oracle Database What is a deadlock and how does or...
- Oracle Database Day-to-day Problems & Solutions fo...
-
▼
March
(52)
No comments:
Post a Comment