Re: TNS error on 7.3.2 for Solaris

> mydb.organic.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = organic.com)
> (PROTOCOL = TCP)
> (Host = myhost.organic.com)
> (Port = 1526)
> )
> (CONNECT_DATA =
> (SID = ORA1)
> (GLOBAL_NAME = mydb.organic.com)
> )
> )
> )

I'll answer my own question...heh

My CONNECT_DATA was nested inside ADDRESS_LIST, so Oracle couldn't parse it..bummer...I moved CONNECT_DATA outside ADDRESS_LIST and all was well.

Cheers,

• James

  ---

                              James Paul Cooper
                      Organic Online - pixel_at_organic.com
                          ......Know Future......