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]
4 comments:
Thank you very much for this post.
I searched a lot over web but finally got the solution on this post.
Really appreciate. Thanks once again.
Oh man you are my hero. Looked around for ages trying to work out why the listener would work one minute and not the next. Turns out this was the issue!
Took me 3 days to get this post, and it took me 30 seconds to solve after reading the post.
Fantastic.
Thanks mate.
Bravo.. Its a real solution..Worked fine.. Thanks for saving my time in prod environment.
Post a Comment