RE: windows question... resolved, well at least partly

Bill,

You probably needed this in the "HOST=" part, but not in the tns entry
declaration, right?
This should work, no?

PNO_PROD =
  (DESCRIPTION =
    (CONNECT_DATA =
      (Service_Name = PNO_PROD)
    )
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1523)(HOST =
foo.blah.AD.blah.COM))
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1528)(HOST =
foo.blah.AD.blah.COM))
    )
  )

Tom

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of bill thater
Sent: Friday, November 09, 2007 9:24 AM
To: oracle-l
Subject: windows question... resolved, well at least partly

turns out i needed to fully qualify both the server name and the tns
entry.  it now connects if i use pno_prod..blah.AD.blah.COM.  tnsping
finds it that way and sqlplus connects OK.  however not if i use just
pno_prod.  any further suggestions?

tnsnames stanza:

PNO_PROD.blau.AD.blah.COM =
  (DESCRIPTION =
    (CONNECT_DATA =
      (Service_Name = PNO_PROD)
    )
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1523)(HOST =
foo.blah.AD.blah.COM))
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1528)(HOST =
foo.blah.AD.blah.COM))
    )
  )


sqlnet.ora:

# SQLNET.ORA Network Configuration File:
D:\oracle\ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = blech.ad.blah.com

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
#SQLNET.AUTHENTICATION_SERVICES= (NONE)

#NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)



NAMES.DIRECTORY_PATH= (TNSNAMES)

--
--
Bill "Shrek" Thater     ORACLE DBA
       shrekdba@xxxxxxxxx
------------------------------------------------------------------------
"He's one who knows that life is just a leap of faith, so spread your
arms and hold your breath and always trust your cape."
-- "The Cape"
--
http://www.freelists.org/webpage/oracle-l




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

Other related posts: