Home » Server Options » Streams & AQ » Connecttion Timeout Occured
Connecttion Timeout Occured [message #256488] Sun, 05 August 2007 00:56 Go to next message
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)
Connecttion Timeout Occured. [message #256505 is a reply to message #256488] Sun, 05 August 2007 05:28 Go to previous messageGo to next message
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.

icon8.gif  Re: What problem is going on? [message #256506 is a reply to message #256488] Sun, 05 August 2007 05:33 Go to previous messageGo to next message
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 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Weekened Wink Laughing
Previous Topic: Which data is replicated.
Next Topic: Which SQL statement is captured/ propagated / applied.
Goto Forum:
  


Current Time: Fri Mar 29 01:53:21 CDT 2024