Re: DB hang

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 - 03:02:30 CDT