ÃֽŠ°Ô½Ã±Û(DB)
2018.10.15 / 13:23

linux oracle ¼­ºñ½º ½ÃÀÛ ¹× È®ÀÎ ( °£´Ü )

hanulbit
Ãßõ ¼ö 185

 < µ¥ÀÌÅͺ£À̽º >


# 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.]