Troubleshooting of common Oracle Database problems (1)

I. Solve the Problem of ORA-07445 downtime in Oracle 9.2.0.6 Database

Fault symptom:

XX network database goes down. view the log and find the following content:

Wed Jun 8 20:24:17 2005Errors in file /u02/app/oracle/admin/unicom/udump/unicom_ora_661.trc:ORA-07445: \263\366\317\326\322\354\263\243: \272\313\320\304\327\252\264\242 [00000 00101C3089C] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []Wed Jun 8 20:24:22 2005Errors in file /u02/app/oracle/admin/unicom/bdump/unicom_pmon_11598.trc:ORA-07445: exception encountered: core dump [0000000101C399A0] [SIGSEGV] [Address no t mapped to object] [0x000000000] [] []Wed Jun 8 20:24:23 2005Errors in file /u02/app/oracle/admin/unicom/bdump/unicom_pmon_11598.trc:ORA-07445: exception encountered: core dump [0000000101C399A0] [SIGSEGV] [Address no t mapped to object] [0x000000000] [] []ORA-00602: internal programming exceptionORA-07445: exception encountered: core dump [0000000101C399A0] [SIGSEGV] [Address no t mapped to object] [0x000000000] [] []Wed Jun 8 20:24:33 2005CKPT: terminating instance due to error 472Instance terminated by CKPT, pid = 11604Wed Jun 8 21:04:47 2005Starting ORACLE instance (normal)

Solution:

Oracle engineers recommend that you install the Oracle patch p3949307_9206_SOLARIS64. After testing, follow the steps below to install the patch. First, shutdown the database ):

1. decompress the patch file:

Unzip p3949307_9206_SOLARIS64.zip

The unlocked directory is: 4060756.

2. Modify the oraclehomeproperties. xml file in the $ ORACLE_HOME/inventory/ContentsXML directory:

Cp oraclehomeproperties. xml oraclehomeproperties. xmlb. bak

Vi oraclehomeproperties. xml

Change the number 453-> 23. Save the disk and exit.

3. Modify the PATH:

PATH = $ ORACLE_HOME/bin:/usr/ccs/bin :$ {PATH}

4. Run the opatch apply command:

Cd 1, 4060756

$ ORACLE_HOME/OPatch/opatch apply

5. After the installation is successful, the following results will appear:

Updating inventory... /oracle92/app/oracle/product/9.2.0.1/OPatch/opatch.pl version: 1.0.0.0.51 Copyright (c) 2001-2004 Oracle Corporation. All Rights Reserved. OPatch succeeded.