you need to set the instnace_name parameter on the pc tnsnames.ora
also in the listener.ora if havent set it up setup ipc
the ipc key would be ideally the sidname.
"Khedr, Waleed " <Waleed.Khedr@(protected) > wrote:
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@(protected)]
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
.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).
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is D:\Documents and Settings\schaupe\Desktop\cli.trc
New trace level is 4
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source D:\oracle\ora81\network\admin\sqlnet.ora
Parameter source loaded successfully
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 ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "D:\Documents and Settings\schaupe\Desktop\sqlnet.log "
Log stream validation not requested
--- LOG CONFIGURATION 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 (See ORA-12545.ora-code.com)
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <DIV >you need to set the instnace_name parameter on the pc tnsnames.ora </DIV >
<DIV >also in the listener.ora if havent set it up setup ipc </DIV >
<DIV >the ipc key would be ideally the sidname. <BR > <BR > <B > <I > "Khedr, Waleed " <Waleed.Khedr@(protected)> </I > </B > wrote: </DIV >
<BLOCKQUOTE class=replbq style= "PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid " >You can add it to the PC hosts file in \windows\system32\drivers\etc <BR > <BR >Also you can modify the DNS suffix for network settings to default to that domain. <BR > <BR >Waleed <BR > <BR >-- --Original Message-- -- <BR >From: Schauss, Peter [mailto:peter.schauss@(protected)] <BR >Sent: Wednesday, June 02, 2004 11:21 AM <BR >To: Oracle-L (E-mail) <BR >Subject: Multi threaded server configuration puzzle <BR > <BR > <BR >Oracle 8.1.7.4, AIX 5.2 <BR > <BR >I am trying to configure the multithreaded server. <BR >Connections work correctly from other AIX boxes, but <BR >from a PC based client I get: <BR > <BR >TNS-12545: Connect failed because target host or object does not exist <BR > <BR >If I add (SERVER=dedicated) to the the tnsnames.ora file on the client, <BR >I get a connection, but, of course, not the shared connection I was trying for. <BR > <BR >The trace file is shown below ( I have changed <BR >some of the network info
rmation
for security reasons). <BR > <BR >The problem seems to be the lines: <BR > <BR >nttbnd2addr: looking up IP addr for host: node2 <BR >nttbnd2addr: *** hostname lookup failure! *** <BR > <BR >Note that several lines above this point, I got: <BR > <BR >nttbnd2addr: looking up IP addr for host: node2.e.blrf.com <BR >nsopen: opening transport... <BR >nttcnp: Validnode Table IN use; err 0x0 <BR >nttcni: trying to connect to socket 684. <BR >nttcon: set TCP_NODELAY on 684 <BR >nsopen: transport is open <BR > <BR >which seems to indicate sqlnet made the initial connection. <BR > <BR >The node where the connection works has an ip addresses in the form <BR > <NODE >.e.blrf.com and thus presumably understands that node2 translates <BR >to node2.e.blrf.com. I verified that I can ping node2 from the node where the <BR >connection works. To ping that node from the PC where the connection does not <BR >work, I have to give the complete address (node2.e.blrf.com). <BR > <BR >How do I fix this? <BR > <BR >Thanks, <BR >Peter
Schauss <BR > <BR > <BR >==================Begin trace file============================================== <BR > <BR >--- TRACE CONFIGURATION INFORMATION FOLLOWS --- <BR >New trace stream is D:\Documents and Settings\schaupe\Desktop\cli.trc <BR >New trace level is 4 <BR >--- TRACE CONFIGURATION INFORMATION ENDS --- <BR > <BR >--- PARAMETER SOURCE INFORMATION FOLLOWS --- <BR >Attempted load of system pfile source D:\oracle\ora81\network\admin\sqlnet.ora <BR >Parameter source loaded successfully <BR > <BR >Attempted load of local pfile source D:\Documents and Settings\schaupe\Desktop\sqlnet.ora <BR >Parameter source was not loaded <BR > <BR >-> PARAMETER TABLE LOAD RESULTS FOLLOW <- <BR >Successful parameter table load <BR >-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <- <BR >trace_level_client = user <BR >NAMES.DIRECTORY_PATH = (TNSNAMES) <BR >SQLNET.AUTHENTICATION_SERVICES = (NTS) <BR >NAMES.DEFAULT_DOMAIN = dssd.blrf.com <BR >--- PARAMETER SOURCE INFORMATION ENDS --- <BR > <BR >--- LOG CONFIGURATION INFORMATION F
OLLOWS
--- <BR >Log stream will be "D:\Documents and Settings\schaupe\Desktop\sqlnet.log " <BR >Log stream validation not requested <BR >--- LOG CONFIGURATION INFORMATION ENDS --- <BR > <BR >nigini: Count in NI global area now: 1 <BR >nigini: Count in NI global area now: 1 <BR >nrigbni: Unable to get data from navigation file tnsnav.ora <BR >nncpmlf_make_local_addrfile: construction of local names file failed <BR >nncpmsf_make_sys_addrfile: system names file is D:\oracle\ora81\network\admin\tnsnames.ora <BR >niotns: niotns: setting up interrupt handler... <BR >niotns: Not trying to enable dead connection detection. <BR >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)))) <BR >nscall: connecting... <BR >nttbnd2addr: port resolved to 1521 <BR >nttbnd2addr: looking up IP addr for host:
node2.e.blrf.com <BR >nsopen: opening transport... <BR >nttcnp: Validnode Table IN use; err 0x0 <BR >nttcni: trying to connect to socket 684. <BR >nttcon: set TCP_NODELAY on 684 <BR >nsopen: transport is open <BR >nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61 <BR >nsopen: global context check-in (to slot 0) complete <BR >nscon: doing connect handshake... <BR >nscon: sending NSPTCN packet <BR >nscon: sending 256 bytes connect data <BR >nsdo: 256 bytes to NS buffer <BR >nscon: got NSPTRD packet <BR >nscall: redirected <BR >nstimarmed: no timer allocated <BR >nsclose: closing transport <BR >nsclose: global context check-out (from slot 0) complete <BR >nscall: connecting... <BR >nttbnd2addr: port resolved to 33108 <BR >nttbnd2addr: looking up IP addr for host: node2 <BR >nttbnd2addr: *** hostname lookup failure! *** <BR >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 <BR >nioqper: error from nscall <BR >nioqper: nr err code: 0 <BR >nioqper: ns mai
n err
code: 12545 <BR >nioqper: ns (2) err code: 12560 <BR >nioqper: nt main err code: 515 <BR >nioqper: nt (2) err code: 1001 <BR >nioqper: nt OS err code: 0 <BR >niqme: reporting NS-12545 error as ORA-12545 (See ORA-12545.ora-code.com) <BR >niomapnserror: returning error 12545 <BR >niotns: Couldn 't connect, returning 12545 <BR >nigtrm: Count in the NI global area is now 0 <BR >nigtrm: Count in the NL global area is now 0 <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please see the official ORACLE-L FAQ: http://www.orafaq.com <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To unsubscribe send email to: oracle-l-request@(protected) <BR >put 'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at http://www.freelists.org/archives/oracle-l/ <BR >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please see the official ORACLE-L FA
Q:
http://www.orafaq.com <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To unsubscribe send email to: oracle-l-request@(protected) <BR >put 'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at http://www.freelists.org/archives/oracle-l/ <BR >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- </BLOCKQUOTE >
