Re: windows question... resolved, well at least partly
- From: "bill thater" <shrekdba@xxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- Date: Fri, 9 Nov 2007 08:57:32 -0600
On Nov 9, 2007 8:48 AM, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> 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@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"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
