리눅스 및 orcl database service 기동

Linux system을 기동 시킨 후, oracle 계정으로 로그인합니다.

listener 기동

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-APR-2008 00:20:22

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

Starting /u01/app/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 /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orasrv1.oraworld.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orasrv1.oraworld.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 27-APR-2008 00:20:22
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orasrv1.oraworld.com)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

dbserver 기동

$ sqlplus / as sysdba

SQL> startup

ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 79694068 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

database control 기동

$ emctl start dbconsole

TZ set to ROK
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://orasrv1.oraworld.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ......................... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/orasrv1.oraworld.com_orcl/sysman/log
[oracle@orasrv1 ~]$

5. isqlplus control 기동

[oracle@orasrv1 ~]$ isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.

isqlplus 기동

$ isqlplusctl start

iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.

접속확인

/u01/app/oracle/product/10.2.0/db_1/install/readme.txt 에서

Enterprise Manager URL Database control URL - (orcl) , iSQL*Plus URL 두개를 확인후

firefox 에서 http://localhost:5560/isqlplus/ 로 접속

firefox 에서 http://localhost:1158/em/ 로 접속

만약에 설치시 연습용 디비 계정의 락을 해제를 안시키고 온경우..

$ sqlplus system/oracle@orcl

SQL> alter user hr identified by hr account unlock ;

SQL> alter user scott identified by tiger account unlock ;