Recently I've been asked to help some developer company to solve the problem - unexpected very slow connect time.
OS: Windows 2008 server
RDBMS: Oracle Enterprise 11.2.0.1 x64
tnsping gives from 12 to 51 seconds.
listener trace files were full of entries like this:
** DBGRL Error: Text Alert Log
** DBGRL Error: SLERC_OERC, 48180
** DBGRL Error: OSD-00001: additional error information
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
** DBGRL Error: 01-ОКТ-2012 13:21:23 * (CONNECT_DATA=(CID=(PROGRAM=)....
Stop, something wrang with listener log file... The size! It appears bigger than 4Gb!
The next step was truncate it:
echo. > orcls.log
The result - tnsping gives 10 msec
It's common problem, and not only with windows, but unix also (at least I met this on AIX).
I met similar problem on Oracle Application Server working under AIX. OC4J_BI_Forms was restarting constantly, every several minutes.
The problem was the "default-web-access.log" bigger than 2Gb. [ID 338805.1]
OS: Windows 2008 server
RDBMS: Oracle Enterprise 11.2.0.1 x64
tnsping gives from 12 to 51 seconds.
listener trace files were full of entries like this:
** DBGRL Error: Text Alert Log
** DBGRL Error: SLERC_OERC, 48180
** DBGRL Error: OSD-00001: additional error information
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
** DBGRL Error: 01-ОКТ-2012 13:21:23 * (CONNECT_DATA=(CID=(PROGRAM=)....
Stop, something wrang with listener log file... The size! It appears bigger than 4Gb!
The next step was truncate it:
echo. > orcls.log
The result - tnsping gives 10 msec
It's common problem, and not only with windows, but unix also (at least I met this on AIX).
I met similar problem on Oracle Application Server working under AIX. OC4J_BI_Forms was restarting constantly, every several minutes.
The problem was the "default-web-access.log" bigger than 2Gb. [ID 338805.1]
