Re: URGENT>>DBA HELP<< with LISTENER.ORA & TNSNAMES.ORA files

From: Nick DiBlasi <ovmail1.qz46nj_at_eds.com>
Date: 1996/02/22
Message-ID: <4giinm$2iq_at_maverick.tad.eds.com>#1/1


Don.Williams_at_dal.ca (Don Williams) wrote:
>Hello all...
>
>In attempts to get my listener running in a Mac environment I decided to
>manually create LISTNER.ORA and TNSNAMES.ORA myself. I have included them
>in this message below.
>
>Questions:
>1) Where should they be placed in the UNIX (AIX) file system?
> I have put them in ....oracle/products/7.2.3/network/ with links to /etc/

Personally, I put these files directly into the /etc directory.

>
>2) Can anyone notice any syntax problems with the files?

There seem to be differences between what you have and the working versions I support. Here is a sample entry from some of my productive files:


  • listener.ora entry
    rpmt_lsnr = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC) (KEY= rpmt) ) (ADDRESS = (PROTOCOL = TCP) (HOST = 000.000.000.000) (PORT = 00001) ) ) STARTUP_WAIT_TIME_RPMT_LSNR = 0 CONNECT_TIMEOUT_RPMT_LSNR = 1800 LOG_DIRECTORY_RPMT_LSNR = /oracle/ora.7.2.2.3/network/log LOG_FILE_RPMT_LSNR = rpmt_lsnr.log SID_LIST_RPMT_LSNR = (SID_LIST = (SID_DESC = (SID_NAME = rpmt) (ORACLE_HOME=/oracle/ora.7.2.2.3) ) ) TRACE_LEVEL_RPMT_LSNR = OFF
  • tnsnames.ora entry
    rpmt = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 000.000.000.000) (PORT = 00001) ) ) (CONNECT_DATA = (SID = rpmt) ) )

>
>3) when I start the listener 3lsnrctl start listener2 it begins to start
>then hangs. Any ideas why?

This may be due to its inability to resolve the host address, or the possible syntax errors in your file, but I'm not 100% sure.

>
>4)Also, does SQL*NET V2 have to be the same for both the client and the
>server? As the s/w for clients is SQL*NET 2.0.15.0.0D and the server is
>SQL*NET 2.2.3 in my config?
>

I'm not sure about this one.

(Text deleted)

Hope this helps.



Nick DiBlasi
DBA
EDS
ahipc1j.ndibla01
Received on Thu Feb 22 1996 - 00:00:00 CET

Original text of this message