Linux suse 10 ORA-00822: MMAN process terminated with error

Hi all,

I have this error when I started an oracle instance on Linux Suse 10

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 12 17:05:35 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup pfile='/data/OPT/Init/init.ora'
ORA-03113: end-of-file on communication channel

ORA-00822: MMAN process terminated with error

Thanks

Regards

Bibi
bibi92Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mrjoltcolaConnect With a Mentor Commented:
MMAN is only needed when using automatic memory management (auto-tuning)

It is known to happen in some cases with larger SGAs with some versions of Oracle on certain OSes. In some cases, reverting to manual sizing fixes it. In some versions, you cannot go over 3GB with auto-tuning, this is an Oracle bug.

Possibly you can try 2 things:

1) Reduce the total SGA_TARGET and/or SGA_MAX_SIZE to a smaller size to see if that helps
2) Revert to traditional manual memory configuration using specific SGA parameters and don't use the SGA_TARGET (must set to 0 to disable auto-tune). This requires that you set the traditional stuff like DB_CACHE_SIZE, SHARED_POOLSIZE, etc.
0
 
bull_riderCommented:
Can you warm start the instance?
0
 
bibi92Author Commented:
No :
Tue May 12 09:53:55 2009
PMON: terminating instance due to error 822
Instance terminated by PMON, pid = 611
Thanks

Regards
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
schwertnerCommented:
Check if the Listener has registered the service:

lsnrctl services

See in alert log file for more details and post them here
0
 
schwertnerCommented:
Again, why you post your question in MS SQL Server,
What has your question to do with MS SQL Server?
0
 
bibi92Author Commented:
i have done an error on the post. It's an oracle database.
Yes, the listener has registered the service.
Alert.log :

Mon May 11 16:28:23 2009
ALTER DATABASE   MOUNT
Mon May 11 16:28:26 2009
Errors in file /data/IFC/Trace/ifc_pmon_12887.trc:
ORA-00822: MMAN process terminated with error
Mon May 11 16:28:26 2009
PMON: terminating instance due to error 822
Instance terminated by PMON, pid = 12887
Tue May 12 17:01:18 2009
Starting ORACLE instance (normal)
Tue May 12 18:16:19 2009
Starting ORACLE instance (normal)
Tue May 12 18:36:24 2009
Starting ORACLE instance (normal)
Tue May 12 18:47:01 2009
Starting ORACLE instance (normal)
Thanks

Regards
0
 
schwertnerCommented:
I always install Oracle 10g on SuSe 9.
I think you have to read once again the manual how to install 10g on SLES10.
Possibly there are special version of gcc package and also of the other parameters.
0
 
bibi92Author Commented:
Hi,

Thanks. I have applied the note 749524.1on metalink.

Regards

0
 
mrjoltcolaCommented:
For the purpose of the PAQ, the Metalink article is not available to unsupported Oracle customers, so for summary, it is an Oracle bug, but there are 3 ways around it, one of which I recommended in the solution, which I am glad, since I did not see the Metalink article until you provided it.

Patchsets are (10.2.0.5 not yet available) or 11.1.0.7 (available) or 11.2 release (not yet available) although there are one-off patches, which I don't like to apply.

Workaround, don't use SGA_TARGET param

Glad to help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.