̽ ߿ ۽ ....
ORA-00020: maximum number of processes (200) exceeded
Ŭ μ ʰ Դϴ. JDBC ̿ؼ Ŭ ʺڵ Ҽ ִ ߿ ϳ Դϴ. ϴ JDBC Connection ϰ close() ʾƼ մϴ. close ʾ Ŭ μ ϴٰ ᱹ init.ora processes ĶͿ μ ʰؼ ϰ ˴ϴ.
Oracle ÿ ִ Open ִ java.sql.Connection $Oracle_HOME/pfile/init.ora processes ĶͿ մϴ.
processes=150
Ķ ִ ؾ ˴ϴ.
SQL> shutdown immediate;
ORA-00020: maximum number of processes (200) exceeded
SQL>
SQL> host ipcs -ms;
IPC status from <running system> as of 2006 6 1 08 52 19
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x5000067b --rw-r--r-- root root
m 401 0x7f9fd5bc --rw-r----- oracle dba
m 134402 0xa2006891 --rw-rw-rw- search search
m 138403 0xb5006c0f --rw-rw-rw- search search
m 135604 0x68006d9c --rw-rw-rw- search search
m 4405 0 --rw-rw-rw- root other
m 4406 0 --rw-rw-rw- root other
m 1207 0 --rw-rw-rw- root other
m 1208 0 --rw-rw-rw- root other
Semaphores:
s 196608 0xfcdb6b5c --ra-r----- oracle dba
s 22020097 0xa2006890 --ra-ra-ra- search search
s 22675458 0xb5006c0e --ra-ra-ra- search search
s 22216707 0x68006d9a --ra-ra-ra- search search
SQL> quit
SQL> show sga;
ORA-01034: ORACLE not available
SQL> conn /as sysdba
Connected to an idle instance.
SQL> quit
db% ipcs
IPC status from <running system> as of 2006 6 1 09 05 45
T ID KEY MODE OWNER GROUP
Message Queues:
Shared Memory:
m 0 0x5000067b --rw-r--r-- root root
m 401 0x7f9fd5bc --rw-r----- oracle dba
m 134402 0xa2006891 --rw-rw-rw- search search
m 138403 0xb5006c0f --rw-rw-rw- search search
m 135604 0x68006d9c --rw-rw-rw- search search
m 4405 0 --rw-rw-rw- root other
m 4406 0 --rw-rw-rw- root other
m 1207 0 --rw-rw-rw- root other
m 1208 0 --rw-rw-rw- root other
Semaphores:
s 196608 0xfcdb6b5c --ra-r----- oracle dba
s 22020097 0xa2006890 --ra-ra-ra- search search
s 22675458 0xb5006c0e --ra-ra-ra- search search
s 22216707 0x68006d9a --ra-ra-ra- search search
db% ipcrm -m 401
db% ipcs
IPC status from <running system> as of 2006 6 1 09 06 17
T ID KEY MODE OWNER GROUP
Message Queues:
Shared Memory:
m 0 0x5000067b --rw-r--r-- root root
m 134402 0xa2006891 --rw-rw-rw- search search
m 138403 0xb5006c0f --rw-rw-rw- search search
m 135604 0x68006d9c --rw-rw-rw- search search
m 4405 0 --rw-rw-rw- root other
m 4406 0 --rw-rw-rw- root other
m 1207 0 --rw-rw-rw- root other
m 1208 0 --rw-rw-rw- root other
Semaphores:
s 196608 0xfcdb6b5c --ra-r----- oracle dba
s 22020097 0xa2006890 --ra-ra-ra- search search
s 22675458 0xb5006c0e --ra-ra-ra- search search
s 22216707 0x68006d9a --ra-ra-ra- search search
db% ipcrm -s 196608
db%
db%
db% ps -ef | grep oracle
oracle 400 1 0 12 18 ? 6:53 /oracle/app/902/bin/tnslsnr LISTENER -inherit
oracle 10452 9608 0 21:07:01 pts/2 0:00 grep oracle
oracle 9560 9558 0 20:06:24 pts/2 0:00 -csh
oracle 9608 9560 0 20:09:22 pts/2 0:00 csh
db%
db%
db% sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jun 1 21:07:10 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 303531072 bytes
Fixed Size 730176 bytes
Variable Size 285212672 bytes
Database Buffers 16777216 bytes
Redo Buffers 811008 bytes
Database mounted.
Database opened.
SQL>