Re: What's wrong with tnsnames.ora?

Jim Lewis <pojpl_at_ais.ucla.edu> wrote in message news:8c0k7v$oas$1_at_carroll.library.ucla.edu...
> RedHat 6.1
> Oracle8i 8.1.5
> Problem: Getting error 12514 TNS: listener could not resolve
> SERVICE_NAME given in connect description.
>
>
> Oracle8i is installed. The sample database is installed and working
> -- I can connect as scott/tiger on the RedHat machine and run sql
> against the emp table.
>
> I have used Net8 Assistant to create listener.ora, tnsnames.ora and
> sqlnet.ora files on the RedHat server and on the NT4.0 client machine.
>
> Something is wrong with one or more of these configuration files I
> guess, but the Oracle documentation I've read seems to show examples
> of these files that are a mix of 8.0 and 8i parameters -- at least
> they managed to confuse me!
>
> Here is the listener.ora file that was generated by Net8 Assistant on
> the RedHat/Oracle box: (I've only changed the HOST address here)
>
> # LISTENER.ORA Configuration
> File:/apps/oracle/8i/u01/app/oracle/product/8.1.5/n
> etwork/admin/listener.ora
> # Generated by Oracle Net8 Assistant
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = <IP address>)(PORT = 1521))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
> )
> )
>
>
> I thought I would only need an ADDRESS entry for TCP. Is that
> incorrect?
>

Yes, you'll also need an address for IPC

> Here is the tnsnames.ora file generated by Net8 Assistant on the
> RedHat/Oracle box. or8iDB is the global database name for this
> database:
>
> # TNSNAMES.ORA Configuration
> File:/apps/oracle/8i/u01/app/oracle/product/8.1.5/n
> etwork/admin/tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> or8iDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = <IP address>(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = or8iDB)
> )
> )
>
> I'm sure I've managed to wedge this somehow. What have I done wrong?
>

A bracket is missing after the IP address. You're also advised NOT to use hardcoded IP-addresses.
If you don't have proper DNS, you can always use the hosts or the lmhosts file on the client machine.

Hth,
Sybrand Bakker, Oracle DBA

>
>
>
>
>
>
>
Received on Fri Mar 31 2000 - 00:00:00 CST