linux oracle ¼ºñ½º ½ÃÀÛ ¹× È®ÀÎ ( °£´Ü )
< µ¥ÀÌÅͺ£À̽º >
# su - oracle
$ ./sqlplus /nolog
SQL> connect /as sysdba
SQL> shutdown immediate
SQL> startup
¶Ç´Â
$ ./sqlplus "/as sysdba"
SQL> shutdown immediate
SQL> startup
< ¸®½º³Ê >
$ ./lsnrctl start
$ ./lsnrctl stop
$ ./lsnrctl status
< iSQL*Plus >
$ ./isqlplusctl start
$ ./isqlplusctl stop
< Enterprise Manager >
$ ./emctl start dbconsole
$ ./emctl stop dbconsole
< µ¥¸ó ÀÚµ¿ ½ÃÀÛ µî·Ï >
* °æ·Î´Â ¼¹ö¿¡ ¸Â°Ô ÁöÁ¤
# vi /etc/rc.d/rc.local
# for Oracle 10g
su - oracle -c '/home/oracle/product/10.2.0/db_1/bin/lsnrctl start
su - oracle -c '/home/oracle/product/10.2.0/db_1/bin/dbstart
su - oracle -c '/home/oracle/product/10.2.0/db_1/bin/isqlplusctl start
¿À¶óŬ ÀÚµ¿ ½ÃÀÛ/Á¾·á ¼³Á¤
# vi /etc/oratab
orcl:/oracle/11g:N <- NÀ» Y·Î ¼öÁ¤ÇÑ´Ù.
orcl:/oracle/11g:Y
Ãâó: http://kkamagistory.tistory.com/364?category=620111 [Karas.]