Pmon Process Terminated With Error Ora-00472
to friend DB is Down!! ORA-00472: PMON process terminated with error [message #397559] Sun, 12 April 2009 12:00 user terminating instance due to error 472 nfernandes Messages: 19Registered: April 2009 Junior Member Hello, We are terminating the instance due to error 472 using Oracle 10G (10.2.0.2.0) and after creating a materialized view (with aprox 32 GB in error 472 detected in background process 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:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\CDUMP db_name = BIEPME open_cursors = 300 pga_aggregate_target = 256901120 PMON started with pid=2, OS id=4668 PSP0 started with pid=3, OS id=4952 MMAN started with pid=4, OS id=4080 DBW0 started with pid=5, OS id=4956 LGWR started with pid=6, OS id=2964 CKPT started with pid=7, OS id=4972 SMON started with pid=8, OS id=4228 RECO
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
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora00472-pmon-process-terminated-with-error-616910 Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research http://dbaforums.org/oracle/index.php?showtopic=13773 Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig error 472 Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES Wave Direct Avaya Pivotal CRM SendGrid View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical instance due to expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-00472: PMON process terminated with error mpsfree asked Dec 18, 2004 | Replies (3) Dear Experts i have face a a problem when i login in database oracle 7 . it shown following error "ORA-00472: PMON process terminated with error" plzzz send solution