{"id":395,"date":"2013-03-05T11:31:31","date_gmt":"2013-03-05T20:31:31","guid":{"rendered":"\/blog\/?p=395"},"modified":"2023-09-21T09:38:53","modified_gmt":"2023-09-21T00:38:53","slug":"solarisoracle%ec%97%90%ec%84%9c-oracle-%ec%84%a4%ec%b9%98-%ed%9b%84-%ea%b5%ac%eb%8f%99%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=395","title":{"rendered":"Solaris+Oracle\uc5d0\uc11c Oracle \uc124\uce58 \ud6c4 \uad6c\ub3d9\ud558\uae30"},"content":{"rendered":"\n

1. \/etc\/init.d\/oracle.sh \ub97c \uc544\ub798\uc640 \uac19\uc774 \ub9cc\ub4e4\uc5b4 \uc900\ub2e4.<\/span> (\ud37c\ubbf8\uc158\uc740 755)<\/b>

#!\/usr\/bin\/bash<\/span>

ORA_HOME=\/export\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2<\/span>
ORA_OWNER=oracle<\/span>

if [ ! -f ${ORA_HOME}\/bin\/dbstart ]<\/span>
then<\/span>
echo \"Oracle startup: cannot start\"<\/span>
exit<\/span>
fi<\/span>

echo ${ORA_HOME}<\/span>

case \"$1\" in<\/span>
'start')<\/span>
echo su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/dbstart\"<\/span>
su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/dbstart ${ORA_HOME}\"<\/span>
#su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/emctl start dbconsole\"<\/span>
#su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/isqlplusctl start\"<\/span>
;;<\/span>
'stop')<\/span>
#su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/isqlplusctl stop\"<\/span>
#su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/emctl stop dbconsole\"<\/span>
#su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/lsnrctl stop\"<\/span>
su - ${ORA_OWNER} -c \"${ORA_HOME}\/bin\/dbshut ${ORA_HOME}\"<\/span>
;;<\/span>
esac<\/span>

2. ~\/.bash_profile \uc5d0 Oracle \uad00\ub828 \ud658\uacbd\ubcc0\uc218\ub97c \uc124\uc815\ud558\uace0 oracle \uacc4\uc815\ub3c4 \ub611\uac19\uc774 \ubcf5\uc0ac\ud55c\ub2e4.<\/span><\/b>

# .bash_profile<\/span>

export PS1='[\\u@\\h \\W]\\$ '<\/span>
export PS2='> '<\/span>
export PS4='+ '<\/span>

umask 022<\/span>
ORACLE_BASE=\/export\/home\/oracle\/app\/oracle<\/span>
ORACLE_HOME=${ORACLE_BASE}\/product\/11.2.0\/dbhome_2<\/span>
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME\/lib<\/span>
NLS_DATE_FORMAT=\"YYYY-MON-DD HH24:MI:SS\"<\/span>
ORA_NLS11=$ORACLE_HOME\/nls\/data<\/span>
ORACLE_SID=racdb1<\/span>
ORACLE_TERM=xterm<\/span>
TNS_ADMIN=$ORACLE_HOME\/network\/admin<\/span>

export ORACLE_HOME<\/span>
export LD_LIBRARY_PATH<\/span>
export NLS_DATE_FORMAT<\/span>
export ORA_NLS11<\/span>
export ORACLE_BASE<\/span>
export ORACLE_SID<\/span>
export ORACLE_TERM<\/span>
export TNS_ADMIN<\/span>

PATH=${ORACLE_HOME}\/bin:${PATH}<\/span>

3. \/etc\/init.d\/oracle.sh start<\/span><\/b>

4. ${ORACLE_HOME}\/dbs\/init.ora\ub97c init${ORACLE_SID}.ora\ub85c \uc774\ub984\uc744 \ubcc0\uacbd\ud55c\ub2e4.<\/span><\/b>

mv ${ORACLE_HOME}\/dbs\/init.ora ${ORACLE_HOME}\/dbs\/init${ORACLE_SID}.ora<\/span>

5. init${ORACLE_SID}.ora\ub97c \ud3b8\uc9d1\ud55c\ub2e4.<\/span><\/b>

- <ORACLE_BASE>\ub85c \ub418\uc5b4 \uc788\ub294 \ubd80\ubd84\uc744 \uc2e4\uc81c \uacbd\ub85c\ub85c \ubaa8\ub450 \ubc14\uafd4\uc900\ub2e4.<\/span>
- control_files = (ora_control1, ora_control2) \ub85c \ub418\uc5b4 \uc788\ub294 \ubd80\ubd84\uc5d0\uc11c ora_control?\uc744 \uc2e4\uc81c \uacbd\ub85c\ub85c \ubc14\uafd4\uc900\ub2e4.<\/span>
\uc608) control_files = (\"\/export\/home\/oracle\/app\/oracle\/oradata\/orcl\/control01.ctl\", \"\/export\/home\/oracle\/app\/oracle\/flash_recovery_area\/orcl\/control02.ctl\")<\/span>

6. sudo - oracle \ud55c \ub2e4\uc74c \uc544\ub798\uc640 \uac19\uc774 sqlplus\ub85c Database\ub97c \ub9c8\uc6b4\ud2b8(\uad6c\ub3d9) \ud55c\ub2e4.<\/span><\/b>
(orcl\uc740 \uc778\uc2a4\ud1a8 \uc2dc \uc124\uc815\ud55c \uad00\ub9ac\uacc4\uc815\uc774\ub2e4.)<\/span>

$ sqlplus \"orcl\/<orcl \uacc4\uc815 \ube44\ubc00\ubc88\ud638> as sysdba\"<\/span>
SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 5 12:53:24 2013<\/span>

Copyright (c) 1982, 2009, Oracle.  All rights reserved.<\/span>


Connected to:<\/span>
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production<\/span>
With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>

SQL> startup<\/b><\/span>
ORACLE instance started.<\/span>

Total System Global Area 1069252608 bytes<\/span>
Fixed Size                  2154936 bytes<\/span>
Variable Size             616570440 bytes<\/span>
Database Buffers          444596224 bytes<\/span>
Redo Buffers                5931008 bytes<\/span>
Database mounted.<\/span>
Database opened.<\/span>

\u203b \uc5b8\ub9c8\uc6b4\ud2b8\ub294 shut \uba85\ub839\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/span>

7. ${ORACLE_HOME}\/bin\/dbstart\uc640 ${ORACLE_HOME}\/bin\/dbshut \ud30c\uc77c\uc744 \ud3b8\uc9d1\ud558\uc5ec<\/span> \uad6c\ub3d9 \uc258\uc744 \/usr\/bin\/bash \ub85c \ubcc0\uacbd\ud574 \uc900\ub2e4.<\/span><\/b>

8. OS \ubd80\ud305 \uc2dc \uc790\ub3d9\uc73c\ub85c \uad6c\ub3d9\ud558\uac8c \ub9cc\ub4e0\ub2e4.<\/span><\/b>

ln -s \/etc\/init.d\/oracle.sh \/etc\/rc0.d\/K10oracle.sh<\/span>
ln -s \/etc\/init.d\/oracle.sh \/etc\/rc2.d\/S99oracle.sh<\/span><\/p>


<\/p>\n","protected":false},"excerpt":{"rendered":"

1. \/etc\/init.d\/oracle.sh \ub97c \uc544\ub798\uc640 \uac19\uc774 \ub9cc\ub4e4\uc5b4 \uc900\ub2e4. (\ud37c\ubbf8\uc158\uc740 755) #!\/usr\/bin\/bash ORA_HOME=\/export\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2ORA_OWNER=oracle if [ ! -f ${ORA_HOME}\/bin\/dbstart ]thenecho “Oracle startup: cannot start”exitfi echo ${ORA_HOME} case “$1” in’start’)echo su – ${ORA_OWNER} -c “${ORA_HOME}\/bin\/dbstart”su – ${ORA_OWNER} -c “${ORA_HOME}\/bin\/dbstart ${ORA_HOME}”#su – ${ORA_OWNER} -c “${ORA_HOME}\/bin\/emctl start dbconsole”#su – ${ORA_OWNER} -c “${ORA_HOME}\/bin\/isqlplusctl start”;;’stop’)#su – ${ORA_OWNER} -c “${ORA_HOME}\/bin\/isqlplusctl stop”#su – ${ORA_OWNER} -c […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[39],"tags":[],"class_list":["post-395","post","type-post","status-publish","format-standard","hentry","category-os_linux_unix_macos"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=395"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}