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: windows question... resolved, well at least partly

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

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 9 Nov 2007 09:48:49 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF017BF843@EXCNYSM0A1AJ.nysemail.nyenet>


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
Received on Fri Nov 09 2007 - 08:48:49 CST

Original text of this message

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