文章目录
关于修改oracle的最大连接数问题
- 修改最大连接数正常操作
sql>show parameter processes;
sql>show parameter sessions;
sql>show parameter spfile;
sql>alter system set processes=1000 scope=spfile;
sql>alter system set processes=1105 scope=spfile;
shutdown immediate;
startup;
查看默认启动方式
SQL> select decode(count(*),1,'spfile','pfile') from v$spparameter where rownum=1 and isspecified ='TRUE';
- 自己创建spfile
create pfile=''/opt/oracle/initmediadbtest.ora' from spfile;
- 出现内存不够用的情况
SQL> startup;
ORA-00371: not enough shared pool memory, should be atleast 838860800 bytes
- 出现无法修改最大连接数情况的操作
当运行startup的时候,oracle会指定spfile,startup 启动次序 spfile优先于pfile。
默认启动方式出现value丢失的情况,估计是在哪个环节没有配置好。所以只能暂时指定某个修改好的特定文件来启动
vim /data/oracle/product/11.2/dbs/initORCL.ora
[oracle@localhost ~]$ grep -v "^#" /data/oracle/product/11.2/dbs/initORCL.ora
db_block_size=8192
db_cache_size=1048576000
open_cursors=300
db_domain=""
db_name=test
control_files=("/data/oracle/oradata/test/control01.ctl", "/data/oracle/oradata/test/control02.ctl")
compatible=11.2.0.0.0
diagnostic_dest=/data/oracle
java_pool_size=50331648
large_pool_size=160432128
shared_pool_size=838860800 #重点修改
processes=3000 #重点修改
sessions=3305 #重点修改
audit_file_dest=/data/oracle/admin/test/adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP) (SERVICE=testXDB)"
pga_aggregate_target=11856248832
undo_tablespace=UNDOTBS1
开始重新启动
SQL> startup pfile='/data/oracle/product/11.2/dbs/initORCL.ora'
ORACLE instance started.
Total System Global Area 2121256960 bytes
Fixed Size 2214976 bytes
Variable Size 1056965568 bytes
Database Buffers 1056964608 bytes
Redo Buffers 5111808 bytes
Database mounted.
Database opened.
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 2
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 3000
SQL> show parameter sessions;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 4528
shared_server_sessions integer