If Oracle connection is dropped repeatedly for unknown reason. Try to do this:
sqlplus sys/welcome1@XE as sysdba
show parameter session
show parameter processes
alter system reset sessions scope=spfile sid='*';
alter system set processes=200 scope=spfile;
shutdown immediate
exit
net stop OracleServiceXE
net start OracleServiceXE
sqlplus sys/welcome1@XE as sysdba
show parameter session
show parameter processes
exit
沒有留言:
張貼留言