Vmware Oracle streams issue
Date: Sun, 7 Mar 2010 00:05:18 +0530
Hi All Gurus,
I have setup an instance on Vmware Linux RHEL 4 hosting on windows.
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;
ORA-12514: TNS:listener does not currently know of service requested in connect
Warning: You are no longer connected to ORACLE.
[oracle_at_orcl2 ~]$ netstat -a | grep 1522
tcp 0 0 orcl5.localdomain:1522 *:*
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
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.