On Nov 9, 2007 8:48 AM, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante_at_labor.state.ny.us> wrote:
> 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
well no it didn't until i removed all of the qualifications from all
the TNS entries and the default domain name from the sqlnet.ora file.
now everything is working like it's supposed to. it's a lot easier if
you set things up yourself and don't walk into something someone has
set up and not explained to you.;-)
--
--
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
Received on Fri Nov 09 2007 - 08:57:32 CST
