Re: OCIServerAttach returns ORA-12514

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 14 Aug 2006 22:53:12 +0200
Message-ID: <44e0e2b6$0$32431$ba620e4c@news.skynet.be>

"Paul" <paul.flew_at_globaladdress.net> wrote in message news:1155586157.707075.165100_at_b28g2000cwb.googlegroups.com...
> Thanks for the help on this one.
>
> We've traced the actual problem to the connection string. It appears
> that the listener on the new database I'm trying to connect to will not
> allow connection strings such as:
>
> //<dns name>.<domain>:<port>/<instance>
>
> but requires:
>
> //<dns name>.<domain>:<port>/<instance>.<domain>
>
> e.g.
>
> //dbserver.domain.com:1254/dbinstance
>
> doesn't work on the new connection, but worked on the old one, and:
>
> //dbserver.domain.com:1254/dbinstance.domain.com
>
> works on the new one. The listener versions on both the Oracle servers
> is the same and the setup is apparently the same, although someone will
> now be investigating that further.
>
> Thanks
>
>
>
> Paul
>

Must be your sqlnet.ora file that is different (or missing on one of the servers) Received on Mon Aug 14 2006 - 15:53:12 CDT