0 Replies Latest reply: Feb 6, 2012 1:16 PM by 745811 RSS

    Stream replication configuration through Cloud Control: ORA-12547: TNS:lost

    745811
      Hi,

      I'm trying to configure stream replication from 'server1' to 'server2'. I have created 'stradmin' users and stream_tbs tablespaces on both servers using 'Cloud Control'.

      I can tnsping and connect from server1 to server2, and from server2 to server1 on the command line, i.e:
      [oracle@server1 ~]$ tnsping DB2.SERVER2.EXAMPLE.COM
      
      TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 06-FEB-2012 14:06:39
      
      Copyright (c) 1997, 2010, Oracle.  All rights reserved.
      
      Used parameter files:
      /oracle/11gr2/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
      
      
      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server2.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db2.server2.example.com)))
      OK (0 msec)
      [oracle@tesla ~]$ sqlplus stradmin@DB2.SERVER2.EXAMPLE.COM
      
      SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 6 14:06:46 2012
      
      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
      
      Enter password:
      
      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      And the reverse (connecting from server2 to server1 works the same way.

      When I try to configure stream replication using Cloud Control, I am able to configure a job to start the replication, but when it runs, I get the following:
      SQL> SQL> SQL> Executing ..
      SQL> connect STRADMIN/******
      SQL> ERROR:
      ORA-12547: TNS:lost contact
      
      
      
      Error from SQLPLUS: 3
      Can anyone help me figure out what the problem is?

      Thanks,

      Dan