본문 바로가기

ORACLE

오라클 재기동

[root@localhost ~]# echo $LANG
ko_KR.UTF-8
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-SEP-2012 13:59:20

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siserver)(PORT=1521)))
The command completed successfully
LSNRCTL> exit
[oracle@localhost ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 4 13:59:56 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate      
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2432696320 bytes
Fixed Size                  2022696 bytes
Variable Size             637534936 bytes
Database Buffers         1778384896 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-SEP-2012 14:03:05

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siserver)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siserver)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                04-SEP-2012 14:03:05
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=siserver)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$ ps -ef | grep ora
root     15022 14993  0 11:39 pts/1    00:00:00 su - oracle
oracle   15024 15022  0 11:39 pts/1    00:00:00 -bash
root     16909 16890  0 13:58 pts/2    00:00:00 su - oracle
oracle   16910 16909  0 13:58 pts/2    00:00:00 -bash
oracle   16975     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16977     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16979     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16981     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16983     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16985     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16987     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16989     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16991     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16993     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16995     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   16997     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   17005     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   17007     1  0 14:02 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/oracle.bin
oracle   17010     1  0 14:03 ?        00:00:00 /oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle   17013 16910  0 14:03 pts/2    00:00:00 ps -ef
oracle   17014 16910  0 14:03 pts/2    00:00:00 grep ora