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

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 26 Oct 2002 10:33:00 -0700
Message-ID: <apejkc03fm@drn.newsguy.com>

In article <pan.2002.10.25.18.54.24.415705_at_t2th.com>, "Peter says...
>
>Good Assumption! ;-)
>

well, I would turn on tracing in the listener and see what might be going awry. On RH8.0, 9iR2 i used your listener file (changed the ip and oracle home and nothing else) and it started right up -- so the config is OK

[ora920_at_tkyte-pc-isdn admin]$ cat listener.ora LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = tkyte-pc-isdn)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/oracle/ora920/OraHome1)
      (PROGRAM = extproc)

)
(SID_DESC =

      (GLOBAL_DBNAME = MYDB)
      (ORACLE_HOME = /usr/oracle/ora920/OraHome1)
      (SID_NAME = MYDB)

)
)

[ora920_at_tkyte-pc-isdn admin]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 26-OCT-2002 13:30:19

Starting /usr/oracle/ora920/OraHome1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.1.0 - Production System parameter file is /usr/oracle/ora920/OraHome1/network/admin/listener.ora Log messages written to /usr/oracle/ora920/OraHome1/network/log/listener.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tkyte-pc-isdn.us.oracle.com)(PORT=1521)))

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tkyte-pc-isdn)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date                26-OCT-2002 13:30:19
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /usr/oracle/ora920/OraHome1/network/admin/listener.ora
Listener Log File         /usr/oracle/ora920/OraHome1/network/log/listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tkyte-pc-isdn.us.oracle.com)(PORT=1521))) Services Summary...
Service "MYDB" has 1 instance(s).
Instance "MYDB", status UNKNOWN, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

>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 =-----
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sat Oct 26 2002 - 12:33:00 CDT