环境: 服务器安装oracle 9i客户端安装的 oracle10G 客户端 配置了 net 配置 再客户端计算机用plsql 大概10分钟左右不操作 再进去操作会提示 ora-03114 未连接到oracle.用delphi ado 用oracle provider for ole db 方式开发了测试exe 如果有一段时间没操作 也会提示连接数据库失败select resource_name,profile from dba_profiles; 值都是default是oracle 版本不匹配还是服务器端需要什么设置 请指点
看值是不是为true,
如果打开了就增大idle_time值
alter system set db_cache_size=256M scope=spfile;alter system set sga_max_size=1536M scope=spfile; alter system set undo_management=auto scope=spfile; alter system set undo_retention=10800 scope=spfile; alter system set shared_pool_size=256M scope=spfile;alter system set workarea_size_policy=auto scope=spfile; alter system set pga_aggregate_target=200M scope=spfile;alter system set log_buffer=1024000 scope=spfile;alter system set java_pool_size=64M scope=spfile;alter system set Large_pool_size=32M scope=spfile;alter system set session_cached_cursors=50 scope=spfile;alter system set pre_page_sga=false scope=spfile;alter system set processes=400 scope=spfile;alter system set job_queue_processes=10 scope=spfile;alter system set db_file_multiblock_read_count=8 scope=spfile;alter system set open_cursors=350 scope=spfile;alter system set log_checkpoint_interval=0 scope=spfile;alter system set log_checkpoint_timeout=1800 scope=spfile;alter system set remote_login_passwordfile=exclusive scope=spfile;alter system set timed_statistics=true scope=spfile;alter system set global_names=false scope=spfile; alter system set cursor_sharing=exact scope=spfile;alter system set disk_asynch_io=FALSE scope=spfile;
SQL> drop trigger sys.cdc_alter_ctable_before;
SQL> drop trigger sys.cdc_create_ctable_after;
SQL> drop trigger sys.cdc_create_ctable_before;
SQL> drop trigger sys.cdc_drop_ctable_before;
SQL> call sys.dbms_java.dropjava('-s rdbms/jlib/cdc.jar');