problem with the listener ( ORACLE 8.0.4 on SOLARIS 2.6 )

From: Arline Bourdages <bourdages.arline_at_hydro.qc.ca>
Date: Tue, 09 Feb 1999 14:25:01 GMT
Message-ID: <36C0453C.B8B5818D@hydro.qc.ca>

I have problem with the listener :
This is the message:
06-FEB-99 11:26:05 *
(CONNECT_DATA=(SID=dbgivre)(CID=(PROGRAM=)(HOST=sygivre)(USER=pt000))) *
(ADD

RESS=(PROTOCOL=tcp)(HOST=131.195.158.22)(PORT=48042)) * establish * dbgivre * 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

The swap space is 900 meg. and the memory is 132 meg

The shared_pool_size is small : =3500000 ( 3.5 meg )

The only solution is to stop ORACLE and the listener if I want the listener to work properly.

Should I start the database with more share_pool , let say 10 meg ?

bests regards
Arline Bourdages
Hydro-Quebec. Received on Tue Feb 09 1999 - 08:25:01 CST