가~~~끔 필요한 절차라 기록한다.
아래 진한 글을 실행하면 된다.
[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>
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
sys 계정으로 로그인하기
$sqlplus
Enter user-name: sys as sysdba
Enter password: 설치 시 입력한 비밀번호
SQL> show user
USER is "SYS"
SQL>