{"id":3968,"date":"2018-06-20T10:21:40","date_gmt":"2018-06-20T01:21:40","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3968"},"modified":"2018-08-17T09:31:10","modified_gmt":"2018-08-17T00:31:10","slug":"oradim","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3968","title":{"rendered":"oradim"},"content":{"rendered":"\n\n\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
\n

 <\/p>\n

<oradim \uc0ac\uc6a9\ubc95><\/strong><\/span><\/p>\n

 <\/p>\n

\u203b Unix\uc5d0\uc11c\uc758 \uc218\ub3d9\uc124\uce58\uc2dc\uc5d0\ub294 \uc774 \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 Windows \ud658\uacbd\uc5d0\uc11c\ub9cc \uc0ac\uc6a9.<\/span><\/p>\n

 <\/p>\n

DBCA(Database Configuration Assistant)\ub97c \uc774\uc6a9\ud55c Oracle\u00a0\uc790\ub3d9\uc124\uce58\uac00 \uc544\ub2cc \uc708\ub3c4\uc6b0 cmd\ucc3d\uc5d0\uc11c \uc218\ub3d9\uc124\uce58\ub97c \ud560 \uacbd\uc6b0\uc5d0 Oradim Utility\ub97c \uc0ac\uc6a9\ud558\uac8c \ub41c\ub2e4.<\/p>\n

 <\/p>\n

\uc77c\ub2e8 \uc774 \uba85\ub839\uc774 \ubb34\uc5c7\uc778\uc9c0 \uac04\ub7b5\ud558\uac8c \uc54c\uc544\ubcf4\uae30 \uc704\ud574\uc11c<\/p>\n

 <\/p>\n

c:\\oracle\\oradata\\NBRDB>oradim -h<\/p>\n

 <\/p>\n

\ub77c\uace0 \uba85\ub839\uc5b4\ub97c \uc368\ubcf4\uc558\ub2e4.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

\uadf8\ub7fc \uc704\uc640 \uac19\uc774\u00a0\uc124\uba85\uc774 \ub098\uc624\uac8c\ub41c\ub2e4. \ubd80\uac00\uc801\uc73c\ub85c \uc124\uba85\uc744 \ub367\ubd99\uc774\uc790\uba74 oradim \ud30c\uc77c\uc740 Oracle 9i\ubd80\ud130 \uc0ac\uc6a9\ud560\uc218 \uc788\ub294 Command-Line Tool\ub85c\uc11c,\u00a0\uc6b0\ub9ac\uac00 \uc218\ub3d9\uc73c\ub85c \uc11c\ube44\uc2a4\uc5d0 \uc0dd\uc131\ud558\uac70\ub098 \uc9c0\uc6b0\uace0, \uc124\uc815\ud560\uc218 \uc788\ub294 \uc720\ud2f8\ub9ac\ud2f0\uc774\ub2e4.<\/p>\n

 <\/p>\n

\u25b6 \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131<\/p>\n

\uadf8\ub7fc \uc9c0\uae08\ubd80\ud130 \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131 \ubb38\ubc95\ubd80\ud130 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uc790. \uc544\ub798\ub294\u00a0oradim\uc758 \ubb38\ubc95 \uccb4\uacc4\uc774\ub2e4.<\/p>\n

 <\/p>\n

oradim -NEW -SID<\/span>\u00a0SID\uc774\ub984 | -SRVC<\/span>\u00a0service_name [INTPWD password][-MAXUSERS number][-STARTMODE auto | manual][-PFILE filename][-TIMEOUT second]<\/p>\n

 <\/p>\n

\u25b7\u00a0\ud544\uc218 \ud30c\ub77c\ubbf8\ud130<\/p>\n

\u25c7 -NEW :\u00a0\uc0dd\uc131\uc2dc \uc0ac\uc6a9\ud558\ub294 \ud544\uc218 \ud30c\ub77c\ubbf8\ud130 \uc774\ub2e4.<\/p>\n

\u25c7 -SID SID\uc774\ub984 : SID\uc758 \uc774\ub984\uc744 \uc785\ub825\ud574\uc900\ub2e4.<\/p>\n

\u25c7 -SRVC \uc11c\ube44\uc2a4 \uc774\ub984 : \uc11c\ube44\uc2a4 \uc774\ub984\uc744 \uc785\ub825\ud574\uc900\ub2e4.<\/p>\n

\u203b -SID\ub098 -SRVC \ub458\uc911 \ud558\ub098\ub294 \uaf2d \uc785\ub825\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4. \uc774 \ub610\ud55c \ud544\uc218 \ud30c\ub77c\ubbf8\ud130\uc774\ub2e4.<\/p>\n

 <\/p>\n

\u25b7\uc120\ud0dd \ud30c\ub77c\ubbf8\ud130<\/p>\n

\u25c7 -INTPWD\u00a0\ube44\ubc00\ubc88\ud638 :\u00a0Password File\uc744 \ud1b5\ud55c \uc778\uc99d\uc744 \ubc1b\ub294\ub2e4.<\/p>\n

\u25c7 -MAXUSERS \uc22b\uc790 : Password File\uc5d0 \uc800\uc7a5\ub418\uba70 \uc720\uc800\uc758 \uc22b\uc790\ub97c \uc124\uc815\ud55c\ub2e4. \ub514\ud3f4\ud2b8\ub294 5 \uc774\ub2e4.<\/p>\n

\u25c7 -STARTMODE \ubaa8\ub4dc : \ubaa8\ub4dc\ub97c Auto\ub85c \ud560\uc9c0 Manual\ub85c \ud560\uc9c0 \uc124\uc815\ud574\uc900\ub2e4.<\/p>\n

\u25c7 -PFILE \ud30c\uc77c\uba85 :\u00a0\uc0ac\uc6a9\ud560 PFILE\ub97c \ubd88\ub7ec\uc628\ub2e4.<\/p>\n

\u25c7 -TIMEOUT \ucd08 :<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

EX> (\ud604\uc7ac\u00a0\uac04\ub2e8\ud55c \uc124\uc815\uc774 \uc644\ub8cc\ub41c \uc0c1\ud0dc\uc5d0\uc11c \uc608\uc81c\ub97c \uc2e4\ud589\ud558\uc600\uc2b5\ub2c8\ub2e4)<\/strong><\/p>\n

\uc6b0\uc120 [ \uad00\ub9ac\ub3c4\uad6c ] – [ \uc11c\ube44\uc2a4 ] \uc5d0\uac00\uc11c \ud55c\ubc88 \ud655\uc778\uc744\ud574\ubcf4\uc790<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\ud604\uc7ac 3\uac1c\uc758 OracleServiceXXXXX\uac00 \uc788\ub2e4.<\/p>\n

\uadf8\ub7fc \uc77c\ub2e8 \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c\uc744 \ubbf8\ub9ac \uc0dd\uc131\ud574 \uc8fc\uc5c8\uace0, oradim\uba85\ub839\uc744 \uc2e4\ud589\ud574\ubcf4\uaca0\ub2e4.<\/p>\n

 <\/p>\n

c:\\>oradim -NEW -SID NBRDB -INTPWD password -STARTMODE manual -PFILE “C:\\oracle\\ora92\\database\\initNBRDB.ora”<\/span><\/p>\n

\u203b \uc704\uc758 \uc608\uc81c\ub294 \ubaa8\ub450 1\uc904\uc5d0 \uc774\uc5b4\uc11c\u00a0\uc785\ub825\uc744 \ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

 <\/p>\n

\uadf8\ub9ac\uace0 \ud55c\ubc88 \uc11c\ube44\uc2a4\ub97c \ub2e4\uc2dc \ud655\uc778\ud558\uc5ec \ubcf4\uc790.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\uc704\uc640\uac19\uc774 OracleServiceNBRDB\ub77c\uace0 \ucd94\uac00\ub41c\uac83\uc774 \ubcf4\uc77c\uac83\uc774\uace0 \uc0c1\ud0dc\ub294 ‘\uc2dc\uc791\ub428’\uc73c\ub85c \ub418\uc5b4\uc788\ub2e4.<\/p>\n

\uadf8\ub7fc \uc774\ubc88\uc5d4 \uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\ud574\ubcf4\uc790.<\/p>\n

 <\/p>\n

c:\\>oradim \u00a0-SHUTDOWN -SID NBRDB<\/span><\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

\uc704\uc640\uac19\uc774\u00a0\ube68\uac04\uc904\uc774 \uadf8\uc5b4\uc9c4\uacf3\uc758\u00a0\uc0c1\ud0dc\uac00 \uc2dc\uc791\ub428\uc5d0\uc11c \uacf5\ub780\uc73c\ub85c \ubc14\ub010\uac83\uc744 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n

\ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc0ad\uc81c\ub3c4 \ud55c\ubc88\ud574\ubcf4\uc790.<\/p>\n

 <\/p>\n

C:\\>oradim -DELETE -SID NBRDB<\/span><\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

\uc774\uc81c \uc11c\ube44\uc2a4\uc5d0\uc11c \ubaa9\ub85d\uc774 \uc0ad\uc81c\ub41c\uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\ub2e4.<\/p>\n

 <\/p>\n

\uc5ec\uae30\uae4c\uc9c0 \ubaa8\ub450 \ud655\uc778\uc744 \ud574\ubcf4\uc558\ub2e4\uba74\u00a0oradim -h \uba85\ub839\uc744 \ud1b5\ud574\uc11c\u00a0\uadf8\ub54c \uadf8\ub54c \ucc3e\uc544\ubcf4\uba70\u00a0\uc774 \uae30\ub2a5\uc744\u00a0\uc0ac\uc6a9\ud574 \ubcfc\uc218 \uc788\uc744\uac70\ub77c \uc0dd\uac01\ub41c\ub2e4.<\/p>\n

 <\/p>\n

(\uc704 \uae00\uc5d0\uc11c oradim\uc744 \uc774\uc6a9\ud558\uc5ec \uc2e4\ud589 or \uc911\uc9c0\ub4f1\uc744 \ud588\uace0 \uadf8\ub9bc\ucc98\ub7fc \uc11c\ube44\uc2a4\ub85c\ub3c4 \ub611\uac19\uc774 \ud560\uc218\uac00 \uc788\ub2e4.)<\/p>\n

 <\/p>\n

 <\/p>\n

\ucc38\uace0\uc790\ub8cc : Administrator’s Guide for Windows<\/p>\n

\n

 <\/p>\n<\/div>\n

 <\/p>\n

<\/h3>\n

< Exemples with oradim usage ><\/h2>\n
\n
\n
<\/div>\n

oradim -startup -sid ORCL92 \u2013usrpwd manager
\n-starttype SRVC,INST -pfile\u00a0<\/span>C:\\oracle9i\\admin\\ORCL92\\pfile\\init.ora<\/span><\/a><\/p>\n

\u2022 startup \u2013 Indicates that the specified instance should be started.
\n\u2022 sid \u2013 The SID of the database to start.
\n\u2022 usrpwd \u2013 The password for the database user.
\n\u2022 starttype \u2013 Specifies whether to start the instance, the service, or both (SRVC, INST)<\/p>\n<\/div>\n<\/div>\n

\n

<li>-pfile is the fully qualified location of the init.ora file <\/li><li>-intpwd is the internal password <\/li><li>-timeout refers to the number of seconds Windows will give the service to respond to a “Start” command before timing out. <\/li><li><\/p>\n

Short first examples:<\/div>\n

Starting the service<\/h3>\n
\n
c:\\some\\arbitrary\\path> oradim -startup -sid <your-sid-goes-here> -starttype srvc<\/strong><\/pre>\n<\/div>\n
Starting the instance<\/h3>\n
\n
c:\\some\\arbitrary\\path> oradim -startup -sid <your-sid-goes-here> -starttype inst<\/strong><\/pre>\n<\/div>\n
Starting both the service and the instance<\/h3>\n
\n
c:\\some\\arbitrary\\path> oradim -startup -sid <your-sid-goes-here> -starttype srvc,inst<\/strong><\/pre>\n<\/div>\n
Examples in details:<\/p>\n
Startup\u00a0<\/strong>– The following command can be used to start the instance with oradim:<\/p>\n
C:\\oracle\\bin\\oradim\u00a0<\/span>\u2013startup \u2013sid\u00a0MYSID<\/span><\/p>\n
Shutdown\u00a0<\/strong>– The following command can be used to shutdown the instance with oradim:<\/p>\n
C:\\oracle\\bin\\oradim -shutdown -sid MYSID -shutttype SRVC,INST \u2013shutmode A<\/span><\/p>\n
Create instance\u00a0<\/strong>– The following command can be used to create an instance with oradim:<\/p>\n
C:\\oracle\\bin\\oradim\u00a0<\/span>\u2013new \u2013sid MYSID \u2013intpwd <pwd> \u2013maxusers 20 startmode auto \u2013pfile initMYSID.ora<\/p>\n
Delete Instance<\/strong>\u00a0– The following command can be used to delete an instance with oradim:<\/p>\n
C:\\oracle\\bin\\oradim\u00a0<\/span>\u2013delete \u2013sid\u00a0MYSID<\/span><\/p>\n
Notice that no password is needed to perform this task.<\/p>\n
The shuttype parameter specifies what is to be stopped \u2013 the service (SRVC), the instance (INST), or both (SRVC, INST). The shutmode specifies the method that should perform the shutdown \u2013 (A)bort, (I)mmediate, or (N)ormal.<\/p>\n