Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net trouble with Oracle 9i on Redhat 8

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

From: Peter Hand <phand_at_t2th.com>
Date: Sat, 26 Oct 2002 01:05:12 GMT
Message-ID: <pan.2002.10.26.01.06.23.18306@t2th.com>


Yeah, the errors are at the bottom of the original post. Here they are again:

Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.100)(PORT=1521))) TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory

Thanks,

Peter

On Fri, 25 Oct 2002 14:15:56 +0000, TurkBear wrote:

> 
> Nothing obvious here ( as far as I can tell on a Friday afternoon)
> Did you export your
> ORACLE_HOME, TNS_ADMIN and ,(optionally I think) ORACLE_SID environment variables?
> 
> Does lsnrctl generate any errors?
> ( I think that exists in the Linux installation)
> 
> 
> "Peter Hand" <phand_at_t2th.com> wrote:
> 

>>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 =-----
> 
> 
> 
> -----------== 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 - 20:05:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US