`
- 浏览:
172943 次
- 性别:
- 来自:
苏州
-
Modify Oracle Process and Session
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12519)(ERROR_STACK=(ERROR=(CODE=12519)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.driver.OracleConnection.<init>OracleConnection.java) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)这样的问题,先前我让他检查一下程序,他说已确定程序没什么问题。后来我也和他们一起检测过程序,确实程序是没有问题的。这时我想到了可能是数据库连接数的问题,我先用select * from sys.v_$session 这个sql查看了一下当前的用户连接数。这个结果也基本正常,接下来我想由于他的这个业务比较复杂,可能是oracle默认的连接数不够,所以我们修改了一下oracle的init.ora文件的配置。在此和大家一起分享一下在oracle的安装目录下:%oracle_home%\admin\orcl\pfile\有一个init.ora文件,我们来分析一下这个文件的内容############################################################################### Copyright (c) 1991, 2001 by Oracle Corporation############################################################################## ############################################ MTS###########################################dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)" ############################################ 其他###########################################compatible=9.0.0db_name=orcl ############################################ 分布式, 复制和快照###########################################db_domain=""remote_login_passwordfile=EXCLUSIVE ############################################ 排序, 散列联接, 位图索引###########################################sort_area_size=524288 ############################################ 文件配置###########################################control_files=("D:\oracle\oradata\orcl\CONTROL01.CTL", "D:\oracle\oradata\orcl\CONTROL02.CTL", "D:\oracle\oradata\orcl\CONTROL03.CTL") ############################################ 池###########################################java_pool_size=33554432large_pool_size=1048576shared_pool_size=33554432 ############################################ 游标和库高速缓存###########################################open_cursors=300 ############################################ 系统管理的撤销和回退段###########################################undo_management=AUTOundo_tablespace=UNDOTBS ############################################ 网络注册###########################################instance_name=orcl ############################################ 诊断和统计###########################################background_dump_dest=D:\oracle\admin\orcl\bdumpcore_dump_dest=D:\oracle\admin\orcl\cdumptimed_statistics=TRUEuser_dump_dest=D:\oracle\admin\orcl\udump ############################################ 进程和会话###########################################processes=150 ############################################ 重做日志和恢复###########################################fast_start_mttr_target=300 ############################################ 高速缓存和 I/O###########################################db_block_size=4096db_cache_size=33554432 在这个文件的processes=150我们把这个值改为260之后就没问题了! 但是要注意的是:用户最大连接数跟你的硬件配置有关,所以要谨慎
当然还有其他两种修改的方式: 第一种方法:
在 Oracle 企业管理器例程-->会话中可以查看当前连接到数据库的详细信息
第二种方法:
SQLPLUS下运行:alter system set processes=250 scope=spfile;
分享到:
Global site tag (gtag.js) - Google Analytics
相关推荐
This concise tutorial walks you step-by-step through the process, showing you exactly what you need to know to install, create, and support a successful Oracle 8i or 9i environment with Web ...
You will also see how to execute and modify database procedures from PowerShell, run unattended, scheduled scripts, and automate database deployments using Oracle command line tools from PowerShell....
Modify your SQL to solve performance problems and increase the speed and throughput of production database systems Who This Book Is For Anyone who deals with SQL and SQL tuning. Both developers and ...
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of ...
In this second edition you will learn how to modify themes and templates and how to use the new HTML5 and CSS3 features You will also learn how to create visual effects such as tool tips and fading ...
M4 and allow user to modify for M4 and allow user to modify for M4 and allow user to modify for M4 and allow user to modify for M4 and allow user to modify for M4 and allow user to modify for M4 and ...
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=21 and ses.paddr=pro.addr; 说明:21是某个连接的sid数 然后用 kill 命令杀此进程号。 五、SQL*PLUS使用 a、近入SQL*Plus $sqlplus ...
alter table table_name modify (field_name varchar2(100)); 改大行,改小不行(除非都是空的) 13.如果修改表名? alter table old_table_name rename to new_table_name; 14.如何搜索出前N条记录? (desc降序) ...
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of ...
File modifyHeaders = new File(pluginPath); profile.addExtension(modifyHeaders); profile.setPreference("modifyheaders.headers.count", 1); profile.setPreference("modifyheaders.headers.action0", ...
Oracle常用的命令如何查看表的结构 EDITDATA 表名; 修改表字段: Alter table 表名 modify(字段名 类型 ...grant create session to 角色名;--给角色授予创建会话的权限 grant 角色名 to 用户名; --把角色授予用户
modify-http-headers Chrome插件, 测试可用,包含插件安装文档
Oracle 数据库 对数据库的表进行修改有如下几点 1. 列的添加,修改和删除 添加列 Alter table•••add Alter table table_name add (new_colum_name datatype [default value] [not null]) 修改列类型 Alter table...
This API allows non Windows operating systems to run pure Java applications which can both process and deliver Excel spreadsheets. Because it is Java, this API may be invoked from within a servlet, ...
一款谷歌浏览器插件,辅助http头注入的检测,欢迎喜欢的朋友下载
Cloning Oracle Service Bus Projects and Folders.......................................................................... 2-2 Creating Oracle Service Bus Configuration Projects...........................
SQL> Select * from session_privs;// 查询当前用户所拥有的权限 2. 角色 角色。角色是一组权限的集合,将角色赋给一个用户,这个用户就拥有了这个角色中的所有权限。 系统预定义角色 预定义角色是在数据库安装...
WHERE emp.deptno=dept.deptno AND emp.ename=pename; END; / VARIABLE vdname VARCHAR2(14); VARIABLE vloc VARCHAR2(13); EXECUTE DeptMesg('SMITH',:vdname,:vloc); PRINT vdname vloc; 2、 定义一个为修改职工...
oracle oci 官方文档 英文版 超级好 值得拥有 This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by ...
Flash and Flex can load, display, and modify XML content. These applications can also send XML content to other applications for updating or for use in different situations. ActionScript 3.0 ...