Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Multi threaded server configuration puzzle

RE: Multi threaded server configuration puzzle

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 2 Jun 2004 20:24:24 -0400
Message-ID: <42BBD772AC30EA428B057864E203C999274216@MSGBOSCLF2WIN.DMN1.FMR.COM> 





This is where conflict starts. Probably the sysadmin can explain the reasons for the conflict.



Waleed




-----Original Message-----



From: Schauss, Peter [mailto:peter.schauss_at_ngc.com]
Sent: Wednesday, June 02, 2004 3:18 PM


To: oracle-l_at_freelists.org


Subject: RE: Multi threaded server configuration puzzle




Thanks for all of the suggestions.



I added the host name of the server to my \WINNT\system3\drivers\etc\hosts
file and that solved my problem.



In the /etc/hosts file on my server, the first name listed is the host name by
itself.  If I give the "hostname" command, that is the name I get back.
Is that where the dispatcher gets the host name that it sends back to the
client to complete the connection?



Thanks,


Peter Schauss




-----Original Message-----



From: Schauss, Peter 


Sent: Wednesday, June 02, 2004 1:17 PM


To: oracle-l_at_freelists.org


Subject: RE: Multi threaded server configuration puzzle




Where does my client get the idea that it is supposed to be 
talking to node2 instead of node2.e.blrf.com?



Peter Schauss



-----Original Message-----



From: Khedr, Waleed [mailto:Waleed.Khedr_at_FMR.COM]
Sent: Wednesday, June 02, 2004 12:10 PM


To: oracle-l_at_freelists.org


Subject: RE: Multi threaded server configuration puzzle




You can add it to the PC hosts file in \windows\system32\drivers\etc



Also you can modify the DNS suffix for network settings to default to that domain.



Waleed



-----Original Message-----



From: Schauss, Peter [mailto:peter.schauss_at_ngc.com]
Sent: Wednesday, June 02, 2004 11:21 AM


To: Oracle-L (E-mail)


Subject: Multi threaded server configuration puzzle




Oracle 8.1.7.4, AIX 5.2



I am trying to configure the multithreaded server.
Connections work correctly from other AIX boxes, but 
from a PC based client I get:



TNS-12545: Connect failed because target host or object does not exist



If I add (SERVER=dedicated) to the the tnsnames.ora file on the client,
I get a connection, but, of course, not the shared connection I was trying for.



The trace file is shown below ( I have changed
some of the network information for security reasons).



The problem seems to be the lines:



nttbnd2addr: looking up IP addr for host: node2
nttbnd2addr:  *** hostname lookup failure! ***



Note that several lines above this point, I got:



nttbnd2addr: looking up IP addr for host: node2.e.blrf.com

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 684.
nttcon: set TCP_NODELAY on 684
nsopen: transport is open





which seems to indicate sqlnet made the initial connection.



The node where the connection works has an ip addresses in the form 
<node>.e.blrf.com and thus presumably understands that node2 translates
to node2.e.blrf.com.  I verified that I can ping node2 from the node where the
connection works.  To ping that node from the PC where the connection does not
work, I have to give the complete address (node2.e.blrf.com).



How do I fix this?



Thanks,


Peter Schauss



==================Begin trace file==============================================







Attempted load of local pfile source D:\Documents and Settings\schaupe\Desktop\sqlnet.ora
Parameter source was not loaded



 -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load


 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
  trace_level_client = user


  NAMES.DIRECTORY_PATH = (TNSNAMES)



  SQLNET.AUTHENTICATION_SERVICES = (NTS)

  NAMES.DEFAULT_DOMAIN = dssd.blrf.com


--- PARAMETER SOURCE INFORMATION ENDS ---






nigini: Count in NI global area now: 1


nigini: Count in NI global area now: 1


nrigbni: Unable to get data from navigation file tnsnav.ora
nncpmlf_make_local_addrfile: construction of local names file failed
nncpmsf_make_sys_addrfile: system names file is D:\oracle\ora81\network\admin\tnsnames.ora

niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2.e.blrf.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=mdev1.node2.e.blrf.com)(SERVER=shared)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=DLNY1SCHAUPE1)(USER=schaupe))))
nscall: connecting...




nttbnd2addr: port resolved to 1521


nttbnd2addr: looking up IP addr for host: node2.e.blrf.com

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 684.
nttcon: set TCP_NODELAY on 684
nsopen: transport is open




nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61
nsopen: global context check-in (to slot 0) complete

nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: sending 256 bytes connect data




nsdo: 256 bytes to NS buffer


nscon: got NSPTRD packet


nscall: redirected


nstimarmed: no timer allocated


nsclose: closing transport


nsclose: global context check-out (from slot 0) complete
nscall: connecting...

nttbnd2addr: port resolved to 33108
nttbnd2addr: looking up IP addr for host: node2
nttbnd2addr:  *** hostname lookup failure! ***
nserror: nsres: id=0, op=77, ns=12545, ns2=12560; nt[0]=515, nt[1]=1001, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nioqper:  error from nscall
nioqper:    nr err code: 0
nioqper:    ns main err code: 12545
nioqper:    ns (2)  err code: 12560
nioqper:    nt main err code: 515




nioqper:    nt (2)  err code: 1001


nioqper:    nt OS   err code: 0


niqme: reporting NS-12545 error as ORA-12545
niomapnserror: returning error 12545

niotns: Couldn't connect, returning 12545
nigtrm: Count in the NI global area is now 0
nigtrm: Count in the NL global area is now 0


----------------------------------------------------------------



Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org


put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org


put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org


put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org


put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Received on Wed Jun 02 2004 - 19:21:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US