[오라클] 시작과 종료

[oracle@oracle ~]$ sqlplus /nolog

 

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Feb 27 14:52:30 2012

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

 

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

 

Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@oracle ~]$ lsnrctl start

 

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 27-FEB-2012 14:53:20

 

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

 

Starting /home/oracle/app/oracle/product/920/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /home/oracle/app/oracle/product/920/network/admin/listener.ora
Log messages written to /home/oracle/app/oracle/product/920/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.sangchul.kr)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.10.100)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=NHMS)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

 

Listener failed to start. See the error message(s) above...

 

[oracle@oracle ~]$

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production