oracle資料庫修改串連數

標籤：常式   class   http   dmi   提示   art   sys   ica   ora   

       最近在用weblogic部署項目，同時用的是oracle資料庫，然後今天遇到一個問題：多個使用者串連資料庫連接不成功，有時提示被鎖住，經檢查發現一方面weblogic控制台中資料來源的串連池配置沒有配置足夠的容量，另一方面是oracle資料庫沒有配足夠的串連數

1.weblogic控制台修改如下

2.通過cmd命令修改資料庫連接數並重啟資料庫

C:\Users\Administrator>sqlplus sys/sys@192.168.13.211/oanet as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 2月 9 11:57:01 2017Copyright (c) 1982, 2005, Oracle.  All rights reserved.ERROR:ORA-12560: TNS: 協議適配器錯誤請輸入使用者名稱:ERROR:ORA-12560: TNS: 協議適配器錯誤請輸入使用者名稱:ERROR:ORA-12560: TNS: 協議適配器錯誤SP2-0157: 在 3 次嘗試之後無法串連到 ORACLE, 退出 SQL*PlusC:\Users\Administrator>d:D:\>cd appD:\app>cd AdministratorD:\app\Administrator>cd productD:\app\Administrator\product>cd 11.2.0D:\app\Administrator\product\11.2.0>cd dbhome_1D:\app\Administrator\product\11.2.0\dbhome_1>cd BIND:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on 星期四 2月 9 11:57:25 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.串連到:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter processesNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------aq_tm_processes                      integer     1db_writer_processes                  integer     1gcs_server_processes                 integer     0global_txn_processes                 integer     1job_queue_processes                  integer     1000log_archive_max_processes            integer     4processes                            integer     150SQL> select count(*) from v$process;  COUNT(*)----------        85SQL> show parameter sessionNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------java_max_sessionspace_size           integer     0java_soft_sessionspace_limit         integer     0license_max_sessions                 integer     0license_sessions_warning             integer     0session_cached_cursors               integer     50session_max_open_files               integer     10sessions                             integer     248shared_server_sessions               integerSQL> select count(*) from v$session;  COUNT(*)----------        82SQL> alter system set processes=300 scope=spfile;系統已更改。SQL> alter system set sessions=300 scope=spfile;系統已更改。SQL> shutdown immediate資料庫已經關閉。已經卸載資料庫。ORACLE 常式已經關閉。SQL> startupORACLE 常式已經啟動。Total System Global Area 1352876032 bytesFixed Size                  2281056 bytesVariable Size             922747296 bytesDatabase Buffers          419430400 bytesRedo Buffers                8417280 bytes資料庫裝載完畢。資料庫已經開啟。SQL>修改linux系統下的oracle資料庫連接數：[[email protected] ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.4.0 Production on Fri May 5 10:26:24 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.SQL> conn /as sysdba  ????SQL> show parameter sessionNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------java_max_sessionspace_size           integer     0java_soft_sessionspace_limit         integer     0license_max_sessions                 integer     0license_sessions_warning             integer     0session_cached_cursors               integer     50session_max_open_files               integer     10sessions                             integer     248shared_server_sessions               integerSQL> show parameter processNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------aq_tm_processes                      integer     1cell_offload_processing              boolean     TRUEdb_writer_processes                  integer     1gcs_server_processes                 integer     0global_txn_processes                 integer     1job_queue_processes                  integer     1000log_archive_max_processes            integer     4processes                            integer     150processor_group_name                 stringSQL> alter system set processes=400 scope=spfile;                                                                    ??????SQL> alter system set sessions=450 scope=spfile;??????SQL> show parametersessionSP2-0735: ??? SHOW ???? "parameters..."SQL> shutdown immediate;????????????????ORACLE ???????SQL> startupORACLE ???????Total System Global Area  784998400 bytesFixed Size                  2257352 bytesVariable Size             599789112 bytesDatabase Buffers          176160768 bytesRedo Buffers                6791168 bytes????????????????SQL> 

 

oracle資料庫修改串連數