Pmon Terminating Instance Due To Error 472 10g
Contents |
to friend DB is Down!! ORA-00472: PMON process terminated with error [message #397559] Sun, 12 April 2009 12:00 nfernandes Messages: 19Registered: April 2009 Junior user terminating instance due to error 472 Member Hello, We are using Oracle 10G (10.2.0.2.0) and after creating oracle error 472 a materialized view (with aprox 32 GB in the TEMP Tablespace) we are getting the error ORA-00472: 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.
Error 472 Detected In Background Process
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 ora-1092 : opitsk aborting process 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 started with pid=9, OS id=4692 CJQ0 started with pid=10, OS id=3356 MMON started with pid=11, OS id=3828 MMNL started with pid=12, OS id=3728 Thu Apr 09 20:17:37 2009 starting up 1 dispatcher(s) for network address '(ADDRESS=(P
and receive notifications of new posts by email. Join 4,587 other followers Follow Pavan DBA's Blog on WordPress.com Visitor Count hit counter Categories Admin (49) Enterprise Manager (4) Bkp n Recovery (15) cloning (4) Certification ora-03113 end-of-file on communication channel (3) Dataguard (6) export/import/Datapump (11) Freshers (1) General (22) Installation (5) Interview Questions (1) RMAN, backup n recovery (1) Jobs (1,700) Networking with Oracle (5) Perf Tuning (1) RAC (1) RMAN (8) Scripts (73) Administration (33) backup and recovery (9) Dataguard (2) Performance Tuning (28) RAC (1) Training (23) upgradation (10) User management (3) Vote your opinion… Take Our Poll TechMaster Training TechMaster Training My Facebook Page My Facebook http://www.orafaq.com/forum/t/143528/ Page My Tweets TechMaster announcing SQL Server DBA online training by Venkat New batch starting from 7th Nov 2016 @ 7 AM IST... fb.me/1AFmsoANU 3hoursago Installing 12c (12 1 0 2) on OEL 7 2 fb.me/62LUdmy27 1dayago 12c Installation video on Oracle Linux 7.2 fb.me/5K9eOxGMr 1dayago Follow @pavandba My DBA links 4shared Akadia Asktom Website Database Journal DBA Oracle DBA Pool DBA Support DBA Village Devshed IXORA My Oracle Support https://pavandba.com/tag/pmon-terminating-instance-due-to-error-490/ Orabyte Oracle articles Oracle Base Oracle DBA Online Oracle Forums ORACLE RAC SIG ORAFAQ Orakhoj Oraperf Scribd Searchoracle Techtarget Statspack Analyzer Other DBA Blogs All Things Oracle Aman's Blog Arup Nanda's blog Dmitry's Blog Gavin Soorma's blog Hemanth Jonathan Lewis Julian Dyke's blog Kamran Kevin's blog Mario's Blog Rafi's blog Richard foote Satish Blog Sudhakar Blog Tanelpoder's blog Tom Kyte's blog Uwe Hesse Blog Posts Tagged ‘PMON: terminating instance due to error 490' How to resolve ORA-00490error? Posted by Pavan DBA on October 17, 2011 Yesterday in one post (https://pavandba.com/2011/10/16/which-process-starts-first-when-instance-is-started/) I explained about PSP0 process which is introduced in 10g Sometimes all of a sudden our Instance will be crashed and when looked at alert log file we found below error message ORA-00490: PSP process terminated with error While PSP process itself terminated due to any error the whole instance is crashed with ORA-00490 error message. On further check you may found one more error also in the alert log file which describes as ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3 When operating system is encountering with some unknown error like insufficient space in temp Area or swap Area or insufficient system re
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=30822 Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites http://www.dba-oracle.com/t_callan_server_alerts.htm Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 35800 error 472 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47789Total active users2118Act. users last terminating instance due 24h12Act. users last hour0Registered user hits last week805Registered user hits last month2452 Go up ORA-00472: PMON PROCESS TERMINATED WITH ERROR Next thread: list the running instance in a unix/linux box Prev thread: help me to tune this statement Message Score Author Date Dear all, my database instance was down in the la...... Ahmed Abd El Latif Oct 16, 2007, 11:47 Dump file d:\oracle\product\10.2.0\admin\xlp\bdump...... Ahmed Abd El Latif Oct 16, 2007, 11:47 Hi Ahmed, try to use "ORA-600 Argument Lookup T...... Ales Kavsek Oct 16, 2007, 12:55 Follow up by mail Click here Subject: ORA-00472: PMON PROCESS TERMINATED WITH ERROR Author: Ahmed Abd El Latif, Egypt Date: Oct 16, 2007, 11:47, 3295 days ago Os info: Windows 2003 Server 64 bit Oracle info: Oracle 10g (10.2.0.3.0) Message: Dear all, my database instance was down in the last weekend for about 40 minute I checked the alert log file and I found that the PMON was terminated abnormally . I use multimaster replication between this database and another one. ************Alert log File***** Errors in file d:\oracle\product\10.2.0\admin\xlp\bdump\xlp_j000_3284.trc: ORA-00600: internal error code, arguments: [1100], [0x0DFFD1018], [0x0DFFD1018], [], [], [], [], [] ORA-00600: internal error code, arguments: [kcbget_37], [1], [], [], [], [], [], [] Fri Oct 12 15:59:49 2007 Errors in file d:\oracl
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Serving Up Server Alerts Expert Oracle Tips by Steve Callan May 23, 2015 Serving up Server Alerts By Steve Callan How and when do alerts or informational messages about what's taking place inside your database make their way out to you, the DBA par excellence? There are several ways, some free and some hand-crafted, to expose alerts and messages. Let's face it, as the Oracle RDBMS engine becomes more and more Skynet-Terminator-Judgement Day-aware, keeping track of what's taking place inside an instance has become easier and harder at the same time. The easier aspect of this statement is evidenced by more sophisticated monitoring tools and interfaces, and the harder part is borne out by the sheer number of metrics that are available to monitor. Let's start off with a simple peek inside the database option. Tail the Alert Log A commonly used quick and dirty monitoring tool in UNIX-based environments (AIX, HP, Solaris, and Linux) is a simple script to tail ?X? number of lines out of the alert log, and then search (grep) the extract for whatever is of interest to you. Specific ORA-xxxxx errors can be searched, or to make things even simpler, the search can be based on any ORA error. If an ORA error appears, then an email is fired off via a mail transfer agent (MTA) to one or more addresses. The steps can be summarized by the shell script pseudo code below: #! /usr/bin/kshtail $ORACLE_HOME\bdump\alert_