FAQ
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*

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 6, '10 at 6:35p
activeMar 6, '10 at 6:35p
posts1
users1
websiteoracle.com

1 user in discussion

Anonymous: 1 post

People

Translate

site design / logo © 2022 Grokbase