listener is running okay
it has refused some connections:
WW_DB> lsnrctl stat
LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003
14:49:01
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.7.0.0 -
Production
Start Date 01-MAY-2003 16:13:23
Uptime 133 days 22 hr. 35 min. 38 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File
/export/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File
/export/oracle/product/8.1.7/network/log/listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
TRADEDB1 has 1 service handler(s)
TRADEDB1 has 2 service handler(s)
The command completed successfully
WW_DB> lsnrctl services
LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003
14:49:07
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
TRADEDB1 has 1 service handler(s)
DEDICATED SERVER established:2 refused:0
LOCAL SERVER
TRADEDB1 has 2 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022
state:ready
D000 <machine: trade-db2, pid: 659>
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=trade-db2.webwayllc.com)(PORT=32804))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))
Presentation: oracle.aurora.server.SGiopServer
DEDICATED SERVER established:213656 refused:4442
LOCAL SERVER
The command completed successfully
WW_DB>
the problem is with One particular client machine.
Regards
----------------------------------------------------
On Sat, 13 Sep 2003 [EMAIL PROTECTED] wrote :
>
>Oddly enough, I received the same error today on one of our
>Solaris
>servers while trying to start a listener. I ran 'top' and
>noticed that all
>of the available swap space on the machine was being used. After
>the
>guilty process was killed, I was able to start the listener.
>FYI, the
>process was picld, an O/S process that is known to have a memory
>leak.
>
>Hope that helps...
>
>Alan
>
>
>Alan Aschenbrenner
>Oracle DBA
>IHS Group
>[EMAIL PROTECTED]
>
>
>
>
> "bhabani s
> pradhan" To:
>Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED] cc:
> ffmail.com> Subject: Re:
>Bus Error (Urgent)
> Sent by:
> [EMAIL PROTECTED]
> com
>
>
> 09/12/2003 04:14
> PM
> Please respond to
> ORACLE-L
>
>
>
>
>
>
> From the listener.log I am getting:
>
>12-SEP-2003 11:24:20 *
>(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM
>=)(HOST=trade-host2)(USER=rubix)))
>* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) *
>establish * TRADEDB1 * 12500
>TNS-12500: TNS:listener failed to start a dedicated server
>process
> TNS-12540: TNS:internal limit restriction exceeded
> TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
> Solaris Error: 12: Not enough space
>
>Regards
>
>----------------------------------------------------------
>On Sat, 13 Sep 2003 bhabani s pradhan wrote :
> >Hi All
> >
> >I am able to connect to my database from a set of different
> >clients from different machines.
> >
> > From one particular machine i am not able to connect to the
> >DB
> >server machine.
> >
> >ping <db_machine_ip> works fine
> >but tnsping <service_name> gives
> >
> >Bus Error (core dumped)
> >
> >
> >Please help
> >
> >Thanks and Regards
> >
> >___________________________________________________
> >Interior meets Software; Rani Weds Gaurav.
> >Rediff Matchmaker strikes another interesting match
> >Visit http://matchmaker.rediff.com?1
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: bhabani s pradhan
> > INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- 858-538-5051
> >http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting
> >services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail
> >message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
>and
> >in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).
>You
> >may
> >also send the HELP command for other information (like
> >subscribing).
>
>___________________________________________________
>Interior meets Software; Rani Weds Gaurav.
>Rediff Matchmaker strikes another interesting match
>Visit http://matchmaker.rediff.com?1
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: bhabani s pradhan
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You
>may
>also send the HELP command for other information (like
>subscribing).
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author:
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You
>may
>also send the HELP command for other information (like
>subscribing).
___________________________________________________
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
