Selamat siang semua, saya sedang mencoba - coba 10g - RAC dengan 2 node tetapi aku ada masalah dimana jika salah satu node dengan RAM 2 GB, 2 Processor, nama node = node 2 di jalankan suatu query bersamaan sebanyak 20 session tiba - tiba instance mati. mengapa hal ini terjadi ? bagaimana cara mengatasinya ?
terima kasih atas bantuannya lampiran data lampiran 1 : parameter - parameter [EMAIL PROTECTED] cdump]$ sqlplus / as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Thu Dec 22 10:03:36 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1048576000 bytes Fixed Size 782168 bytes Variable Size 1022103720 bytes Database Buffers 25165824 bytes Redo Buffers 524288 bytes Database mounted. Database opened. SQL> show parameter sga_max_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 1000M SQL> show parameter shared_pool_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 500M SQL> show parameter pga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 24M SQL> show parameter db_block_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_block_size integer 8192 SQL> lampiran 2 : file trace terakhir di udump vi /u01/app/oracle/admin/orcl/udump/orcl2_ora_32175.trc /u01/app/oracle/admin/orcl/udump/orcl2_ora_32175.trc Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1 System name: Linux Node name: rac2pub Release: 2.4.21-15.ELsmp Version: #1 SMP Thu Apr 22 00:18:24 EDT 2004 Machine: i686 Instance name: orcl2 Redo thread mounted by this instance: 0 <none> Oracle process number: 44 Unix process pid: 32175, image: [EMAIL PROTECTED] (TNS V1-V3) *** SERVICE NAME:() 2005-12-22 09:49:37.573 *** SESSION ID:(215.3) 2005-12-22 09:49:37.573 *** 2005-12-22 09:49:37.573 52121 kcrr.c ARCH: Archival disabled due to shutdown: 1089 *** 2005-12-22 09:49:38.607 52121 kcrr.c ARCH: Archival disabled due to shutdown: 1089 lampiran 3 : file alert terakhir di bdump vi /u01/app/oracle/admin/orcl/bdump/alert_orcl2.log Thu Dec 22 09:47:52 2005 Starting background process EMN0 EMN0 started with pid=45, OS id=32177 Thu Dec 22 09:47:56 2005 Shutting down instance: further logons disabled Thu Dec 22 09:48:49 2005 Stopping background process QMNC Thu Dec 22 09:48:49 2005 Stopping background process CJQ0 Thu Dec 22 09:48:50 2005 Stopping background process MMNL Thu Dec 22 09:48:51 2005 Stopping background process MMON Thu Dec 22 09:48:52 2005 Shutting down instance (transactional local) Local transactions complete. Performing immediate shutdown License high water mark = 22 Thu Dec 22 09:48:52 2005 Stopping Job queue slave processes Thu Dec 22 09:48:52 2005 Job queue slave processes stopped Thu Dec 22 09:49:36 2005 All dispatchers and shared servers shutdown Thu Dec 22 09:49:36 2005 ALTER DATABASE CLOSE NORMAL Thu Dec 22 09:49:37 2005 SMON: disabling tx recovery SMON: disabling cache recovery Thu Dec 22 09:49:37 2005 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 2 closed at log sequence 220 Successful close of redo thread 2 Thu Dec 22 09:49:37 2005 Completed: ALTER DATABASE CLOSE NORMAL Thu Dec 22 09:49:37 2005 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thu Dec 22 09:49:40 2005 freeing rdom 0 lampiran 4 : file trace terakhir di bdump Du/u01/app/oracle/admin/orcl/bdump/orcl2_ora_32177.trc Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1 System name: Linux Node name: rac2pub Release: 2.4.21-15.ELsmp Version: #1 SMP Thu Apr 22 00:18:24 EDT 2004 Machine: i686 Instance name: orcl2 Redo thread mounted by this instance: 0 <none> Oracle process number: 0 32177 *** 2005-12-22 09:49:34.121 *** SERVICE NAME:() 2005-12-22 09:49:34.120 *** SESSION ID:(238.3) 2005-12-22 09:49:34.120 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
