Home » RDBMS Server » Server Administration » ORACLE UPGRADE (Oracle 10g, OS- AIX)
ORACLE UPGRADE [message #358505] Tue, 11 November 2008 11:29 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

We upgraded the database from 10.2.0.3 to 10.2.0.4.

Once its completed, while starting the database we are getting the following errors:

SQL> startup
ORACLE instance started.

Total System Global Area 784334848 bytes
Fixed Size 2087320 bytes
Variable Size 612370024 bytes
Database Buffers 167772160 bytes
Redo Buffers 2105344 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

Alert Log file:

Errors in file /u01/app/oracle/admin/JCM3DB1/udump/jcm3db1_ora_930022.trc:
ORA-00450: background process 'QMNC' did not start
ORA-00443: background process "QMNC" did not start
Error 450 happened during db open, shutting down database
USER: terminating instance due to error 450
Instance terminated by USER, pid = 930022
ORA-1092 signalled during: ALTER DATABASE OPEN...


Trace file:

Dumping diagnostic information for QMNC:
OS pid = 499782
loadavg : 1.45 1.22 1.23
swap info: free_mem = 12.66M rsv = 16.00M
alloc = 276.60M avail = 4096.00M swap_free = 3819.40M
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME T
TY TIME CMD
240001 T oracle 499782 1 0 60 20 29cac400 91352 11:34:45
- 0:00 ora_qmnc_JCM3DB1
open: Permission denied
499782: ora_qmnc_JCM3DB1


Guess something wrong in QMNC Process.

Any suggestions to fix this?

Thanks and Regards,
Prashanth
Re: ORACLE UPGRADE [message #358778 is a reply to message #358505] Wed, 12 November 2008 08:21 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
http://google.com
Previous Topic: Redo Log
Next Topic: CDC issue
Goto Forum:
  


Current Time: Fri Nov 29 18:43:55 CST 2024