Vmware Oracle streams issue

From: Shastry(DBA) <"Shastry>
Date: Sun, 7 Mar 2010 00:05:18 +0530
Message-ID: <5b294dab1003061035i7aa291ddy85b8f4d0d9ab7865_at_mail.gmail.com>

Hi All Gurus,

I have setup an instance on Vmware Linux RHEL 4 hosting on windows. DB-10.2.0.1.0
OS- RHEL 5 Update 5
Network-type - Bridged
Host -HP Desktop box with 3.5 GB RAM, Windows XP Professional, ( Pretty slow when VMware hosts were started)

I could work successfully in replicating/cloning the instance to three nodes and setup oracle streams between three instances. I could only access the terminals between each instances inside Linux Desktop/terminal as the network type was chosen bridged.
Inorder to make it accessible from host(windows) I had to switch the network to NAT and could ping and access the guest hosts from outside VM i.e on windows.
I am able to tnsping each other and listener is running fine, But while trying to connect to scott/tiger_at_host1 from host2 OR scott/tiger_at_host2from host1 is having a big trouble and facing the below issue. Could anyone
please help and advice if you had faced similar issues?

SQL> conn scott/tiger_at_host1;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Warning: You are no longer connected to ORACLE. SQL> [oracle_at_orcl2 ~]$ netstat -a | grep 1522 tcp 0 0 orcl5.localdomain:1522 *:* LISTEN
tcp 0 0 orcl5.localdomain:1522 orcl6.localdomain:32806 TIME_WAIT
tcp 0 0 orcl5.localdomain:1522 orcl6.localdomain:32809 TIME_WAIT Alert log:

Propagation Schedule for (STRMADMIN.CAPTURE_ORCL2, "STRMADMIN"."FROM_ORCL2"_at_ ORCL1.REGRESS.RDBMS.DEV.US.ORACLE.COM) encountered folloo wing error:
ORA-04052: error occurred when looking up remote object STRMADMIN.DBMS_AQADM_at_ORCL1.REGRESS.RDBMS.DEV.US.ORACLE.COM

ORA-00604: error occurred at recursive SQL level 4
ORA-12170: TNS:Connect timeout occurred
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

SQLNET LOG: Fatal NI connect error 12514, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.129.148)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=ORCL3)(CID=(PROGRAM=oracle)(HOST=orcl2.localdomain)(USER=oracle))))   VERSION INFORMATION:

        TNS for Linux: Version 10.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 -
Production
        TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 -

Production
  Time: 07-MAR-2010 04:16:39
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
I hope the issue lies in perhaps LISTENER is too fast than OS and unable to spawn a new process and physically running out of resources causing the timeout.

*Thanks,*
*Anantha*

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Mar 06 2010 - 12:35:18 CST