Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition

standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition

From: steve noyle <stevenoyle1_at_yahoo.com>
Date: Tue, 18 Jan 2005 10:39:32 -0800 (PST)
Message-ID: <20050118183932.83421.qmail@web51002.mail.yahoo.com>


hi,
I've just set up a 9.2.0.4 standby database and have been getting the following messages every day.

Timing out on NetServer 1
prod=39901,cons=37325,threshold=2560
ORA-16166: LGWR timed out on Network Server 1 due to buffer full condition.

         No action is required since the log file transfer will be attempted via ARCH
Sun Jan 16 02:34:14 2005
Errors in file
/u01/app/oracle/admin/test01/bdump/test01_lgwr_12800.trc: ORA-16166: LGWR network server failed to send remote message
LGWR: I/O error 16166 archiving log 3 to 'ddb03ps' Sun Jan 16 02:34:14 2005
Errors in file
/u01/app/oracle/admin/test01/bdump/test01_lgwr_12800.trc: ORA-16166: LGWR network server failed to send remote message

The source database is a test database and there are no workload generated on the database. According to metalink, a way to solve the problem is to increase the ASYNC buffer size. I've increased it to 20480 but I'm still getting the same error message. Also, I do not understand why would my buffer be full when I have absolutely nothing running on the source? Does anyone has any clue what is going on or how can I troubleshoot the problem?

>From Note:247129.1 - "As a best practice define your
remote archive destination as such:
service=<tns alias> LGWR ASYNC=20480 reopen=15 max_failure=10 net_timeout=30"

Thanks.

Steve                 



Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 18 2005 - 23:19:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US