본문 바로가기

쓰기

오라클 실행시키는 방법

haru 2017.11.28 11:15 조회 수 : 10

[root@localhost ~]# su - oracle
[oracle@db /home/oracle]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-APR-2011 16:57:59

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

Starting /ORACLE/app/oracle/oracle/product/10.2.0/db_4/bin/tnslsnr: please wait...

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                20-APR-2011 16:58:01
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /ORACLE/app/oracle/oracle/product/10.2.0/db_4/network/admin/listener.ora
Listener Log File         /ORACLE/app/oracle/oracle/product/10.2.0/db_4/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db)(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@db /home/oracle]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 20 16:58:19 2011

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

SQL> connect orcl as sysdba
Enter password: [엔터]
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             109055788 bytes
Database Buffers          490733568 bytes
Redo Buffers                7163904 bytes
Database mounted.

Database opened.
SQL>