Ora-00472 Pmon Process Terminated With Error

to friend DB is Down!! ORA-00472: PMON process terminated user terminating instance due to error 472 with error [message #397559] Sun, 12 April 2009 terminating the instance due to error 472 12:00 nfernandes Messages: 19Registered: April 2009 Junior Member Hello, We are using Oracle error 472 detected in background process 10G (10.2.0.2.0) and after creating a materialized view (with aprox 32 GB in the TEMP Tablespace) we are getting the error ORA-00472: PMON process terminated with error, and we cannot make any transaction on the database. We can startup the database, however after aprox 51 sec the database shutdowns itself. The alert log shows the following: Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.2.0. System parameters with non-default values: processes = 150 __shared_pool_size = 150994944 __large_pool_size = 4194304 __java_pool_size = 12582912 __streams_pool_size = 4194304 sga_target = 775946240 control_files = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\CONTROL01.CTL, C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\CONTROL02.CTL, C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\CONTROL03.CTL db_block_size = 8192 __db_cache_size = 595591168 compatible = 10.2.0.2.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = c:\Programas\oracle\product\10.2.0\flash_recovery_area db_recovery_file_dest_size= 2147483648 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=BIEPMEXDB) job_queue_processes = 10 audit_file_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\ADUMP background_dump_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\BDUMP user_dump_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\UDUMP core_dump_dest = C:\

CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 16 Replies Latest reply on Jul 27, 2010 8:18 PM by 379746 Go to original post This http://www.orafaq.com/forum/t/143528/ content has been marked as final. Show 16 replies 15. Re: ora-00472 PMON process terminated with error on production system ZahKar Jul 26, 2010 9:06 PM (in response to 379746) asgar_amin wrote: like this one.. been running for 189 minutes oracle 5683 1 246 13:46:21 ? 189:34 oracleFINPROD (LOCAL=NO)This looks like ps. Can you please show https://community.oracle.com/thread/1107341?start=15&tstart=0 us what switches you used with "ps" to get this output ? Like Show 0 Likes(0) Actions 16. Re: ora-00472 PMON process terminated with error on production system 379746 Jul 27, 2010 8:18 PM (in response to ZahKar) i was using ps -ef | grep SID I am also seeing the following message in the trace file. SMON: found rollback segment # 38 at address c000000015f3af10 to take offline. *** 2010-07-27 14:41:46.587 SMON: found rollback segment # 19 at address c000000015f3a818 to take offline.I did start the database a few times and it shutdown and came backup without any error. Thank you all for your time.. Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x

- 00472 PMON Process Terminated If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you http://www.dbasupport.com/forums/showthread.php?19351-ORA-00472-PMON-Process-Terminated can post: click the register link above to proceed. To start viewing messages, http://psoug.org/oraerror/ORA-00472.htm select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: ORA - 00472 PMON Process Terminated Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-28-2001,03:17 AM error 472 #1 pbmistry View Profile View Forum Posts Junior Member Join Date Jul 2001 Posts 59 hi, i have above error & my database is not start, what can i do for this, how can i solce this problem ? Help me it is urgent. PRADIP MISTRY Reply With Quote 12-28-2001,03:25 AM #2 julian View Profile View Forum Posts Senior Advisor Join Date Jun 2001 Location instance due to Helsinki. Finland Posts 3,938 Originally posted by pbmistry hi, i have above error & my database is not start, what can i do for this, how can i solce this problem ? Help me it is urgent. PRADIP MISTRY Well, your process cleanup process has died. 1. connect internal 2. shutdown abort 3. startup pfile = ... Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is On Forum Rules Contact Us DBAsupport.com Home Page Top Click Here to Expand Forum to Full Width All times are GMT -4. The time now is 11:56 AM.

Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-00472 Error Description: PMON process terminated with error Error Cause: The process cleanup process died. Action: Warm start instance. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 58 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?