I changed the ulimit
oracle_at_king:~/apache/logs> ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
Serghei wrote:
> madunix писал(а):
>
> > SQL> show parameter shared_servers;
> >
> > NAME TYPE VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > max_shared_servers integer
> > shared_servers integer 0
> > SQL>
> >
> > oracle_at_king:~> ulimit -a
> > core file size (blocks, -c) unlimited
> > data seg size (kbytes, -d) unlimited
> > file size (blocks, -f) unlimited
> > max locked memory (kbytes, -l) unlimited
> > max memory size (kbytes, -m) unlimited
> > open files (-n) 1024
> > pipe size (512 bytes, -p) 8
> > stack size (kbytes, -s) unlimited
> > cpu time (seconds, -t) unlimited
> > max user processes (-u) 16384
> > virtual memory (kbytes, -v) unlimited
> > oracle_at_king:~> locate sysctl.conf
> > /etc/sysctl.conf
> > /usr/share/man/man5/sysctl.conf.5.gz
> > oracle_at_king:~> vi /etc/sysctl.conf
> >
> > # Disable response to broadcasts.
> > # You don't want yourself becoming a Smurf amplifier.
> > net.ipv4.icmp_echo_ignore_broadcasts = 1
> > # enable route verification on all interfaces
> > net.ipv4.conf.all.rp_filter = 1
> > # enable ipV6 forwarding
> > #net.ipv6.conf.all.forwarding = 1
> >
> > # listener.ora Network Configuration File:
> > /opt/oracle/product/10gR2/network/admin/listener.ora
> > # Generated by Oracle configuration tools.
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = /opt/oracle/product/10gR2)
> > (PROGRAM = extproc)
> > )
> > (SID_DESC =
> > (SID_NAME = king)
> > (ORACLE_HOME = /opt/oracle/product/10gR2)
> > )
> > (SID_DESC =
> > (SID_NAME = TestDBDSN)
> > (ORACLE_HOME = /opt/oracle/product/10gR2)
> > (PROGRAM = extproc)
> > )
> > )
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
> > (ADDRESS = (PROTOCOL = TCP)(HOST = king.sdc)(PORT = 1521))
> > )
> > )
> >
> > Serghei wrote:
> > > The first think is :
> > > RDBMS listener - is in dedicated or shared mode?
> > > Show me "listener.ora" - file...
> > >
> > > And show me output of
> > >
> > > sqlplus> conn sys/**passord**@king as sysdba
> > >
> > > sqlplus> show parameter shared_servers;
> > > ......
> > > .....
> > >
> > > The second think is :
> > > BUG of 10.2.0.2
> > > # 4518443 - LISTENER GETS HUNG UP
> > >
> > > The third think is :
> > > Or may be Eve Hoellwarth is right.
>
> in first
> open files (-n) 1024 --
>
> MUST BE 65535 ...
> change the kernel parameters.
> if it not resolve problem then
> show me next:
>
> sqlplus> show parameter dispatchers;
> ....
> sqlplus> show parameter session_max_open_files;
> ....
> sqlplus> show parameter sessions;
> ....
> sqlplus> show parameter shared_server_sessions;
>
> Regards from Moldova.
Received on Mon Sep 11 2006 - 07:58:22 CDT
