2012年3月28日 星期三

Oracle connection drop repeatedly on Weblogic/WebCenter


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

沒有留言:

張貼留言