今天启动Tomcat下的JAVA项目,连接数据库意外发现报错:Got minus one from a read call。。。 这样的Exception:
解决方案如下:
1. sys用户登录数据库
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as SYS
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 250
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 408
shared_server_sessions integer
SQL> alter system set processes=350 scope=spfile;
System altered
SQL> alter system set sessions=450 scope=spfile;
System altered
SQL>
2. 重启数据库
# su - oracle
$ sqlplus / as sysdba
关闭数据库
SQL> shutdown immediate
启动数据库:
SQL> startup
问题解决。