Pmon Process Terminated With Error
Contents |
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
Error 472 Detected In Background Process
Oracle 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\BIE
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux 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 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 http://www.orafaq.com/forum/t/143528/ JoeTorre Craig 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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora00472-pmon-process-terminated-with-error-616910 share technical 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 terminate
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 https://community.oracle.com/thread/1107341?start=15&tstart=0 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 http://www.sql.ru/forum/70327/ora-00472-pmon-process-terminated-with-error 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 error 472 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 instance due to 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
[new] друг Member Откуда: Екатеринбург Сообщений: 17 После перезагрузки такая ситуация при коннекте к базе. Кто нибудить сталкивался с этой проблемой и как её решить? 23 янв 04, 15:07 [504850] Ответить | Цитировать Сообщить модератору Re: ORA-00472 PMON process terminated with error [new] друг Member Откуда: Екатеринбург Сообщений: 17 Востановил все из бекапа только там нету Temp файла может кто нибуть подцелял фалы и как можно это сделать? Дайте хоть ссылку 23 янв 04, 19:25 [505367] Ответить | Цитировать Сообщить модератору Re: ORA-00472 PMON process terminated with error [new] друг Member Откуда: Екатеринбург Сообщений: 17 Сделал так 1) startup mount; 2) alter database datafile 'путь, файл' offline drop; 3) alter database open; 4) drop tablespace <имя> 5)создать новую tablespace И все заработало. Но все же что же было это ORA-00472 PMON process terminated with error и как его можно обойти 23 янв 04, 20:00 [505381] Ответить | Цитировать Сообщить модератору Re: ORA-00472 PMON process terminated with error [new] Markelenkov Member Откуда: Сообщений: 2312 ORA-00472 PMON process terminated with error Cause: The Process Monitor process terminated abnormally. Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found. Что в alert.log и в trace-файле, с которым отвалился PMON? 23 янв 04, 20:25 [505389] Ответить | Цитировать Сообщить модератору Re: ORA-00472 PMON process terminated with error [new] друг Member Откуда: Екатеринбург Сообщений: 17 Fri Jan 23 14:58:06 2004 ORA-449 signalled during: alter database "oracle" open... Dump file c:\ORANT\RDBMS73\trace\orclALRT.LOG Fri Jan 23 15:04:40 2004 ORACLE V7.3.4.5.0 - Production vsnsta=0 vsnsql=b vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Starting up ORACLE RDBMS Version: 7.3.4.5.0. System parameters with non-default values: processes = 50 shared_pool_size