SQL>alter system set processes=1200 scope = spfile;SQL>create pfile from spfile;SQL>shutdown imeediateSQL>startup
SQL> show parameter processesNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 20
log_archive_max_processes integer 2
processes integer 150总是没改成功,不明白为什么?是跟ASM有关系吗?
SQL> show parameter processesNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 20
log_archive_max_processes integer 2
processes integer 150总是没改成功,不明白为什么?是跟ASM有关系吗?
解决方案 »
- oracle配置问题
- oracle在java存储过程中如何创建和删除 txt文件呢,是否需要授权呢
- 请教各位老大,如何将几个存储过程按顺序一次性调运
- 我郁闷呀,ORACLE9i,我怎么就折腾不了你呢?很初级的一系列问题,来者给分。
- 存储过程中的事务
- ORACLE 8。0。5升级到ORACLE 9I后,速度明显变慢,是什么原因呢?
- sql语句检测问题?
- oracle8i中如何取得一表table的ddl语句
- 非常火急!!!!!!!一个ORACLE登录问题
- OraclePreparedStatement的问题(紧急求助)
- ORACLE 11G SQL优化求教~~
- 如何统计不同部门的人数???????????????
Tue Jul 31 22:08:39 2012
Thread 1 cannot allocate new log, sequence 370
Checkpoint not complete
Current log# 3 seq# 369 mem# 0: +DG_DB2/db2/onlinelog/group_3.263.675564233
Tue Jul 31 22:08:41 2012
Thread 1 advanced to log sequence 370 (LGWR switch)
Current log# 1 seq# 370 mem# 0: +DG_DB2/db2/onlinelog/group_1.261.675564233
Tue Jul 31 22:08:52 2012
Thread 1 cannot allocate new log, sequence 371
Checkpoint not complete
Current log# 1 seq# 370 mem# 0: +DG_DB2/db2/onlinelog/group_1.261.675564233
Tue Jul 31 22:08:53 2012
Thread 1 advanced to log sequence 371 (LGWR switch)
Current log# 2 seq# 371 mem# 0: +DG_DB2/db2/onlinelog/group_2.262.675564233
Tue Jul 31 22:09:31 2012
Thread 1 advanced to log sequence 372 (LGWR switch)
Current log# 3 seq# 372 mem# 0: +DG_DB2/db2/onlinelog/group_3.263.675564233
Tue Jul 31 22:29:59 2012
Thread 1 advanced to log sequence 373 (LGWR switch)
Current log# 1 seq# 373 mem# 0: +DG_DB2/db2/onlinelog/group_1.261.675564233
Tue Jul 31 22:42:29 2012
ALTER SYSTEM SET shared_pool_size='20M' SCOPE=BOTH;
Tue Jul 31 22:43:41 2012
ALTER SYSTEM SET sga_max_size='2000M' SCOPE=SPFILE;
Tue Jul 31 22:46:00 2012
ALTER SYSTEM SET sga_target='2000M' SCOPE=SPFILE;
Tue Jul 31 22:50:18 2012
ALTER SYSTEM SET processes=1200 SCOPE=SPFILE;
Tue Jul 31 22:51:18 2012
Shutting down instance: further logons disabled
Tue Jul 31 22:51:18 2012
Stopping background process CJQ0
Tue Jul 31 22:51:18 2012
Stopping background process QMNC
Tue Jul 31 22:51:19 2012
Stopping background process MMNL
Tue Jul 31 22:51:20 2012
Stopping background process MMON
Tue Jul 31 22:51:21 2012
Shutting down instance (immediate)
License high water = 37
Tue Jul 31 22:51:21 2012
Stopping Job queue slave processes, flags = 7
Tue Jul 31 22:51:21 2012
Job queue slave processes stopped
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Tue Jul 31 22:51:24 2012
ALTER DATABASE CLOSE NORMAL
Tue Jul 31 22:51:24 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jul 31 22:51:24 2012
Shutting down archive processes
Archiving is disabled
Tue Jul 31 22:51:29 2012
ARCH shutting down
ARC1: Archival stopped
Tue Jul 31 22:51:34 2012
ARCH shutting down
ARC0: Archival stopped
Tue Jul 31 22:51:35 2012
Thread 1 closed at log sequence 373
Successful close of redo thread 1
Tue Jul 31 22:51:36 2012
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jul 31 22:51:36 2012
ALTER DATABASE DISMOUNT
Tue Jul 31 22:51:36 2012
SUCCESS: diskgroup DG_DB2 was dismounted
Tue Jul 31 22:51:36 2012
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
Tue Jul 31 22:52:20 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =158
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.4.0.
System parameters with non-default values:
processes = 150
sessions = 1440
sga_max_size = 2097152000
lock_sga = TRUE
__shared_pool_size = 33554432
shared_pool_size = 33554432
__large_pool_size = 0
__java_pool_size = 16777216
__streams_pool_size = 0
spfile = /usr/local/oracle/oracle/product/10.2.0/db_1/dbs/spfiledb2.ora
sga_target = 1073741824
control_files = +DG_DB2/db2/controlfile/current.260.675564229
db_block_size = 8192
__db_cache_size = 1006632960
compatible = 10.2.0.3.0
log_archive_dest_1 = location=/var/dbbak/arc/
db_file_multiblock_read_count= 8
db_create_file_dest = +DG_DB2
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=db2XDB)
job_queue_processes = 10
background_dump_dest = /usr/local/oracle/admin/db2/bdump
user_dump_dest = /usr/local/oracle/admin/db2/udump
core_dump_dest = /usr/local/oracle/admin/db2/cdump
audit_file_dest = /usr/local/oracle/admin/db2/adump
db_name = db2
open_cursors = 300
query_rewrite_enabled = TRUE
pga_aggregate_target = 419430400
PMON started with pid=2, OS id=19606
PSP0 started with pid=3, OS id=19608
MMAN started with pid=4, OS id=19610
DBW0 started with pid=5, OS id=19612
LGWR started with pid=6, OS id=19614
CKPT started with pid=7, OS id=19616
SMON started with pid=8, OS id=19618
RECO started with pid=9, OS id=19620
CJQ0 started with pid=10, OS id=19622
MMON started with pid=11, OS id=19624
Tue Jul 31 22:52:20 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=19626
Tue Jul 31 22:52:20 2012
starting up 1 shared server(s) ...
Tue Jul 31 22:52:20 2012
ALTER DATABASE MOUNT
Tue Jul 31 22:52:20 2012
Starting background process ASMB
ASMB started with pid=16, OS id=19633
Starting background process RBAL
RBAL started with pid=17, OS id=19637
Tue Jul 31 22:52:23 2012
SUCCESS: diskgroup DG_DB2 was mounted
Tue Jul 31 22:52:27 2012
Setting recovery target incarnation to 3
Tue Jul 31 22:52:28 2012
Successful mount of redo thread 1, with mount id 1953579556
Tue Jul 31 22:52:28 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jul 31 22:52:28 2012
ALTER DATABASE OPEN
Tue Jul 31 22:52:28 2012
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=19644
Tue Jul 31 22:52:28 2012
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=20, OS id=19646
Tue Jul 31 22:52:28 2012
Thread 1 opened at log sequence 373
Current log# 1 seq# 373 mem# 0: +DG_DB2/db2/onlinelog/group_1.261.675564233
Successful open of redo thread 1
Tue Jul 31 22:52:28 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jul 31 22:52:28 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Jul 31 22:52:28 2012
ARC1: Becoming the heartbeat ARCH
Tue Jul 31 22:52:28 2012
SMON: enabling cache recovery
Tue Jul 31 22:52:28 2012
Successfully onlined Undo Tablespace 1.
Tue Jul 31 22:52:28 2012
SMON: enabling tx recovery
Tue Jul 31 22:52:28 2012
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=21, OS id=19649
Tue Jul 31 22:52:31 2012
Completed: ALTER DATABASE OPEN
Tue Jul 31 22:53:46 2012
ALTER SYSTEM SET sga_target='1800M' SCOPE=BOTH;
Tue Jul 31 22:58:19 2012
ALTER SYSTEM SET job_queue_processes=20 SCOPE=BOTH;
Wed Aug 1 08:00:36 2012
Thread 1 advanced to log sequence 374 (LGWR switch)
Current log# 2 seq# 374 mem# 0: +DG_DB2/db2/onlinelog/group_2.262.675564233
[oracle@localhost bdump]$
Completed: ALTER DATABASE OPEN
数据库不是启动正常吗?
数据库是正常启动了,但processes还是150,而不是1200;
其实2种都试过,
包括export ORACLE_SID=+ASM
和export ORACLE_SID=db2;
分别做了alter system set processes=1200 scope = spfile;
然后重启动,但依然无法修改生效.
root 1937 1902 0 15:11 pts/1 00:00:00 grep ocl
是不是这个服务器做了RAC有关系?