- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- One of the instance failure in Oracle 9.2.0.5 RAC...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-01-2005 06:14 PM
тАО05-01-2005 06:14 PM
One of the instance failure in Oracle 9.2.0.5 RAC on HPUnix 11i
RAC instance is crashing during the transaction runs.
Following errors are obnserved in one of the alert log file .
ORA-07445: exception encountered: core dump [kdxlpu()+2008] [SIGSEGV] [unknown code] [0x8000000100200000] [] []
Sat Apr 30 14:49:25 2005
Errors in file /u01/app/oracle/admin/db9i/udump/db9i1_ora_26438.trc:
ORA-00600: internal error code, arguments: [25012], [15], [0], [], [], [], [], []
Sat Apr 30 14:49:28 2005
For more details please refere attachment .
Please get back to me ASAP.
Please treat this as urgent .
Thanks and Regards,
SAI
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-01-2005 06:50 PM
тАО05-01-2005 06:50 PM
Re: One of the instance failure in Oracle 9.2.0.5 RAC on HPUnix 11i
I've found in the past these types of problems have been solved by putting in patchs and working closely with Oracle support.
ORA-0600 is a very non-specific error code. It means the database picked up a problem but has very little idea what kind of problem it is.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-01-2005 07:03 PM
тАО05-01-2005 07:03 PM
Re: One of the instance failure in Oracle 9.2.0.5 RAC on HPUnix 11i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2005 08:40 AM
тАО05-02-2005 08:40 AM
Re: One of the instance failure in Oracle 9.2.0.5 RAC on HPUnix 11i
Your problem is:
Corrupt block relative dba: 0x038110aa (file 14, block 69802)
Fractured block found during preparing block for write
Data in bad block -
type: 6 format: 2 rdba: 0x038110aa
last change scn: 0x0000.00f207e8 seq: 0x1 flg: 0x02
consistency value in tail: 0x139013d4
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
You will have to recover this block or always that a query access this block you will have problem.
Also, always put db_block_checksum=true in your init.ora, because this parameter will check the block every time dbwr write to disk.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2005 08:41 AM
тАО05-02-2005 08:41 AM
Re: One of the instance failure in Oracle 9.2.0.5 RAC on HPUnix 11i
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2005 09:51 AM
тАО05-02-2005 09:51 AM
Re: One of the instance failure in Oracle 9.2.0.5 RAC on HPUnix 11i
ORA-7445 can be related to an object that faced a NOLOGGING action. This can not be recovered at all (meaning "recovering" in terms of applying redologs), but needs to be reprocessed by application.
I.e. if this bad block belongs to an Index, which has been created with the nologging option, you need to recreate it.
Do not mix up "recover" and "restore".
Good luck
Volker