Thursday, June 7, 2007

Oracle 10g BI Discoverer Viewer was getting Disconnect

Issue : Oracle 10g BI Discoverer Viewer was getting Disconnect with Given error for one discoverer server nfinoasd12 whereas it was working fine for other server infinoas11. We have same set of configuration for both discoverer servers nfinoas11 and nfinoas12.

“Contact with the Discover server has been lost To continue your work, please restart Discoverer Pluse. If this problem persists, please contact your Oracle Application Server Administrator"

Solution:

1. Checked "Timeout" in $ORACLE_HOME/discoverer/util/pref.txt at both server.

[oracle@nfinoas11 util]$ grep -i timeout pref.txt

Timeout = 28800 #1800 # Timeout in seconds if there is no client activity. Minimum allowed time is 180 secs

[oracle@nfinoas11 util]$ pwd

/local/oracle/product/10.1.2.0.2/discoverer/util

[oracle@nfinoas12 ~]$ cd /local/oracle/product/10.1.2.0.2/discoverer/util

[oracle@nfinoas12 util]$ grep -i timeout pref.txt

Timeout = 28800 # 1800 # Timeout in seconds if there is no client activity. Minimum allowed time is 180 secs

2. Checked $TNS_ADMIN/sqlnet.ora at database server and given entry was missing in sqlnet.ora file. SQLNET.EXPIRE_TIME= 10

No comments: