Re: SQL*Net trouble with Oracle 9i on Redhat 8

From: Peter Hand <phand_at_t2th.com>
Date: Fri, 25 Oct 2002 18:53:15 GMT
Message-ID: <pan.2002.10.25.18.54.24.415705@t2th.com>

Good Assumption! ;-)

listener.ora

#######################

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = MYDB)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = MYDB)

    )
  )

#######################

tnsnames.ora

#######################

# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

INST1_HTTP.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)

    )
  )

MYDB.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)

    )
  )

#######################

On Fri, 25 Oct 2002 12:22:17 +0000, TurkBear wrote:

> 
> Assuming you installed a listener, could you post your listener.ora file ( make any security-related changes you need)
> What happens when you run lsnrctl?
> 
> 
> "Peter Hand" <phand_at_t2th.com> wrote:
> 
>>Hi,
>>
>>I installed 9.2 with no trouble on my RedHat 8 server until I tried to
>>start up the listener.  This is what I get:
>>
>>TNS-12541: TNS:no listener
>> TNS-12560: TNS:protocol adapter error
>>  TNS-00511: No listener
>>   Linux Error: 2: No such file or directory
>>
>>Listener failed to start. See the error message(s) above...
>>
>>I checked Metalink and didn't think anything there was all that helpful,
>>and I know that this is not a "certified" platform, but any help would be
>>deeply appreciated.  The database works great and connects locally just
>>fine.
>>
>>Regards, Peter
> 
> 
> 
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
>    http://www.newsfeed.com       The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

Received on Fri Oct 25 2002 - 13:53:15 CDT