Re: DB hang

From: madunix <madunix_at_gmail.com>
Date: 10 Sep 2006 22:11:00 -0700
Message-ID: <1157951460.833368.300230@e3g2000cwe.googlegroups.com>

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.

Received on Mon Sep 11 2006 - 00:11:00 CDT