리눅스에서 오라클 실행하기

예전에 리눅스에서 오라클 실행할줄도 몰라서 쩔쩔매엇던 기억이 난다..-_-;;
이게 또 사용을 안하니깐 기억이 가물가물해질려고해서 간단하게 메모를 남긴다...

최초 오라클 계정으로 접속한 후 (11 기준)
# su - oracle
# sqlplus /nolog 
   SQL> conn /as sysdba 
   SQL> startup

기본적으로 오라클이 실행된다. 그후 리스너를 실행시키자.

[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus /nolog
 
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 4 09:30:27 2014
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
 
Total System Global Area 6680915968 bytes
Fixed Size                  2213936 bytes
Variable Size            3556771792 bytes
Database Buffers         3087007744 bytes
Redo Buffers               34922496 bytes
Database mounted.
Database opened.
SQL> 

# lsnrctl start     -> 리스너 실행
# lsnrctl status   -> 리스너 상태
# lsnrctl stop     -> 리스너 정지

[oracle@localhost ~]$ lsnrctl start
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JUL-2014 09:31:31
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
Starting /database/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-JUL-2014 09:31:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$ lsnrctl status
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JUL-2014 09:31:40
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-JUL-2014 09:31:33
Uptime                    0 days 0 hr. 0 min. 7 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$ lsnrctl status
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JUL-2014 09:31:42
 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-JUL-2014 09:31:33
Uptime                    0 days 0 hr. 0 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /database/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /database/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully

[참조]

http://cspark.egloos.com/667106