Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Native hostname adapter doesn't work
pdalberth_at_bhsoftware.com (Paul Dalberth) wrote in message news:<86eeba3c.0203091303.3e5d6b24_at_posting.google.com>...
> I have no tnsnames file and am trying to use the native hostname
> adapter.
>
> We are using TCP/IP and there is only one database on serv1 and the
> listener is running OK.
>
> DNS correctly resolves serv1 to the appropriate IP.
>
> But, when I try to connect from SQL*Plus I get ORA-12154 errors - "tns
> cannot resolve service name"
>
> The name of the database on the server is "prod"
>
> Is there some other requirement for the native hostname adapter that
> I'm missing? Maybe wrt the database name? We would like to be able
> to "failover" users to a standby database simply by implementing a DNS
> change - is this possible?
>
> Thanks in advance for any help.
>
> - Paul Dalberth
The problem was that there must be a DNS alias with the same name as the sid of the database instance and this DNS entry must resolve to the IP of the server that hosts the database. Received on Mon Mar 11 2002 - 08:48:08 CST