()ý
Home
Ȩ ȸҰ ý Ʈ ũ
 
 
ۼ : 06-06-05 13:33
oracle datebase shutdown ʵɰ....
 ۾ :
ȸ : 4,842  
   http://blog.naver.com/kotaeho0512/50000826289 [716]

  ̽ ߿ ۽ ޽ ....


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>


 


 


 
 

Total 136
ȣ     ۾ ¥ ȸ
31 Ǽ mysql DB
2006/07/14 9876
30 NAS SAN .....
2006/07/11 4447
29 ý ڱ ....
2006/07/10 4628
28 oracle 9i ġ
2006/06/14 3067
27 oracle datebase shutdown ʵɰ....
2006/06/05 4843
26 x4100
2006/04/26 3072
25 RAID 1-6 ϱ
2006/04/11 3549
24 Ŭ Ƽ ũ Ǯ ӽ ġ.
2006/04/11 13555
23 bdump, cdump, udump
2006/04/11 6886
22 sas disk --- Serial Attached SCSI
2006/04/06 3761
21 ms-sql *.mdf .
2006/04/03 7419
20 tomcat web Manager йȣ Ȯ.
2006/03/31 11055
19 MySQL Dumpߴ
2006/03/21 10116
18 mysql db .
2006/03/21 6685
17 nagios ġ.
2006/03/13 10414
 1  2  3  4  5  6  7  8  9  10  
 
 
 
Administrator Login