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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com
------------------------------------------------------------------------
"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