OraFAQ Forum: Streams & AQ » Connecttion Timeout Occured

Home » Server Options » Streams & AQ » Connecttion Timeout Occured

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecttion Timeout Occured [message #256488]

Sun, 05 August 2007 00:56

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

In source database,

SQL> select destination_dblink,error_message,status,SOURCE_QUEUE_OWNER so ,DESTINATION_QUEUE_OWNER des from dba_propagation;

Database
Link       Error Message                                      Status   SO                             DES
---------- -------------------------------------------------- -------- ------------------------------ ------------------------------
SATURN.NET ORA-12170: TNS:Connect timeout occurred            ENABLED  STRMADMIN                      STRMADMIN
           ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1087
           ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7616
           ORA-06512: at "SYS.DBMS_AQADM", line 631
           ORA-06512: at line 1

SQL> select owner,db_link from dba_db_links;

Owner      DB_LINK
---------- --------------------------------------------------------------------------------------------------------------------------------
STRMADMIN  SATURN.NET

SQL> select count(username) from dba_users@saturn.net;

COUNT(USERNAME)
---------------
             28

Why connecttion timeout happens

MY SQLnet.ora is as follows:

# sqlnet.ora Network Configuration File: /oracle/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Report message to a moderator

Connecttion Timeout Occured. [message #256505 is a reply to message #256488]

Sun, 05 August 2007 05:28

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I am almost finished with this error.

While configuring Oracle Streams Replication the propagation gives me the following error:

SQL>  select * from dba_propagation;

                                                                                                                                                           Database
PROPAGATION_NAME               SOURCE_QUEUE_OWNER             SOURCE_QUEUE_NAME              DESTINATION_QUEUE_OWNER        DESTINATION_QUEUE_NAME         Link       RULE_SET_OWNER
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------
                                                                                                                                                               Error
RULE_SET_NAME                  NEGATIVE_RULE_SET_OWNER        NEGATIVE_RULE_SET_NAME         QUEUE Status   Error Message                                      Date
------------------------------ ------------------------------ ------------------------------ ----- -------- -------------------------------------------------- ---------
STREP01_PROPAGATION            STRMADMIN                      STREAMS_CAPTURE_Q              STRMADMIN                      STREAMS_CAPTURE_Q              SATURN.NET STRMADMIN
RULESET$_48                                                                                  TRUE  ENABLED  ORA-12170: TNS:Connect timeout occurred            05-AUG-07
                                                                                                            ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1087
                                                                                                            ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7616
                                                                                                            ORA-06512: at "SYS.DBMS_AQADM", line 631
                                                                                                            ORA-06512: at line 1

There is no network problem and ping works fine. Moreover the query executes successfully.

SQL> select count(*) from dba_users@saturn.net
  2  ;

  COUNT(*)
----------
        28

Please give your suggestions.

Report message to a moderator

Re: What problem is going on? [message #256506 is a reply to message #256488]

Sun, 05 August 2007 05:33

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Nobody there to help me figure out this problem!!!

[Updated on: Sun, 05 August 2007 05:34]

Report message to a moderator

Re: What problem is going on? [message #256542 is a reply to message #256506]

Sun, 05 August 2007 16:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Weekened

Report message to a moderator

Previous Topic:	Which data is replicated.
Next Topic:	Which SQL statement is captured/ propagated / applied.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:37:47 CST 2024