ORA-03135 when connecting to Database [ID 404724.1]
這一個錯誤在網路上的搜尋, 有會導致 DB Hung 的情況, 在 Metalink上的說明是這樣的 :
另外這一個問題於10.2.0.3已經被改善了
Symptoms
On 10.2.0.2 in Production:
When attempting to connect to the primary database,the following error occurs.
ERROR
ORA-03135 connection lost contact
Cause
這一個問題是因為: AUDSES$ cache size is set to 20 (default).
Bug.5621770 ORA-3135 CONNECTING TO PRIMARY DATABASE WHEN SHUTDOWN STANDBY HOST.
AUDSES$ is a sequence which is getting updated on connection and is cached for 20 values so only every 20th connection or increment to audses$ will cause an update. If there is a problem to update the seq$, then the client connection will receive ORA-3135.
Solution
依循下列步驟解決此問題:
1. login to database
connect / as sysdba
2. increase the cache size of AUDSES$ from 20 (default) to 10000
ALTER SEQUENCE sys.audses$ cache 10000;
這一個錯誤在網路上的搜尋, 有會導致 DB Hung 的情況, 在 Metalink上的說明是這樣的 :
另外這一個問題於10.2.0.3已經被改善了
Symptoms
On 10.2.0.2 in Production:
When attempting to connect to the primary database,the following error occurs.
ERROR
ORA-03135 connection lost contact
Cause
這一個問題是因為: AUDSES$ cache size is set to 20 (default).
Bug.5621770 ORA-3135 CONNECTING TO PRIMARY DATABASE WHEN SHUTDOWN STANDBY HOST.
AUDSES$ is a sequence which is getting updated on connection and is cached for 20 values so only every 20th connection or increment to audses$ will cause an update. If there is a problem to update the seq$, then the client connection will receive ORA-3135.
Solution
依循下列步驟解決此問題:
1. login to database
connect / as sysdba
2. increase the cache size of AUDSES$ from 20 (default) to 10000
ALTER SEQUENCE sys.audses$ cache 10000;
全站熱搜
留言列表
