Please post your listener.ora and sqlnet.ora
dbuckingham wrote:
> Have 4 instances set up on Linux/oracle box (Oracle 8.1.7, RH 7.3). On
> the linux box, i can start and connect to each instance ok via svrmgrl
> and sqlplus after setting the ORACLE_SID.
>
>
>
> However, if I try and establish a entry in the tnsnames.ora file via
> netca I get ORA-12514 error. I have noticed that when I try and start
> netca I get an unknown host entry on the screen:
>
>
>
> [oralce_at_tempus]netca
>
> unknownhost tempus
>
> unknownhost tempus
>
> unknownhost tempus
>
>
>
> Then the network configuration assistant starts up. I enter in the
> service name and host and hit test and get the ORA-12514 error.
>
>
>
> This has come about since giving the linux box a fixed ip for our
> network. Previous to this I was able to make the connection via netca
> and hence also our windows network.
>
>
>
> If i do a TNSPING i get tnsping-03505: failed to resolve host name.
>
>
>
> any ideas?
>
>
> --
> Posted via http://dbforums.com
Received on Tue Aug 19 2003 - 20:32:01 CDT
