doc-linux-ja-html 2006.05.25-1.1 / usr / share / doc / HOWTO / ja-html / Oracle-8-HOWTO-4.html

This file is indexed.

/usr/share/doc/HOWTO/ja-html/Oracle-8-HOWTO-4.html is in doc-linux-ja-html 2006.05.25-1.1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below. 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
 <META NAME="GENERATOR" CONTENT="SGML-Tools 1.0.9">
 <TITLE>Oracle for Linux ¥¤¥ó¥¹¥È¡¼¥ë HOWTO: ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®</TITLE>
 <LINK HREF="Oracle-8-HOWTO-5.html" REL=next>
 <LINK HREF="Oracle-8-HOWTO-3.html" REL=previous>
 <LINK HREF="Oracle-8-HOWTO.html#toc4" REL=contents>
</HEAD>
<BODY>
<A HREF="Oracle-8-HOWTO-5.html">¼¡¤Î¥Ú¡¼¥¸</A>
<A HREF="Oracle-8-HOWTO-3.html">Á°¤Î¥Ú¡¼¥¸</A>
<A HREF="Oracle-8-HOWTO.html#toc4">Ìܼ¡¤Ø</A>
<HR>
<H2><A NAME="s4">4. ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®</A></H2>

<H2><A NAME="ss4.1">4.1 ³µ´Ñ</A>
</H2>

<P>¤Þ¤À¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤·¤Ê¤¤¤è¤¦¤Ë¤È¤¤¤¦Á°Àá¤Î¥¢¥É¥Ð¥¤¥¹¤Ë
½¾¤Ã¤Æ¤¤¤¿¤À¤±¤¿¤Ç¤·¤ç¤¦¤«¡©
<P>¿¤¯¤Î¿Í¡¹¤Ë¤È¤Ã¤Æ¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®¤Ï¼¡¤Î¸ÀÍÕ¤ËÍ×Ìó¤Ç¤­¤ë
¤«¤â¤·¤ì¤Þ¤»¤ó - ¡Ö'dbassist'¤ò¼Â¹Ô¤»¤è¡× Oracle ¤òÁö¤é¤»¤ë¤Î¤¬
½é¤á¤Æ¤Ç¤Ê¤±¤ì¤Ð¡¢'dbassist' ¤¬Ê¹¤¤¤Æ¤¯¤ë¼ÁÌä¤Ë¤ÏÆñ¤Ê¤¯Åú¤¨¤é
¤ì¤ë¤Ï¤º¤Ç¤¹¡£
<P>´°Á´¤ò´ü¤¹¤¿¤á¤Ë¡¢»ä¤Î¤ä¤Ã¤¿¤³¤È¤ò¥É¥­¥å¥á¥ó¥È¤Ë»Ä¤·¤Þ¤¹¤¬¡¢
¤Þ¤º¤Ï»ä¤ÎÌܻؤ·¤Æ¤¤¤¿¤â¤Î¤ò½Ò¤Ù¤ë¤Î¤¬¥Ù¥¹¥È¤À¤È»×¤¤¤Þ¤¹¡£
Í×Ìó - ¤³¤ì¤Ï»Å»öÍѤΥ·¥¹¥Æ¥à¤Ç¤â¡ÖËܳÊŪ¤Ê¡×(Ê£¿ô¥æ¡¼¥¶¤Î¡¢
¤Þ¤¿¤Ï¡¢¾ï»þ»ÈÍѤÎ) ³«È¯Íѥܥ寥¹¤Ç¤â¤Ê¤¤¤Î¤Ç¤¹¡£»ä¤¬ 8i ¤ò
¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¤Î¤Ï¡¢8 °ÊÁ°¤Î¥Ð¡¼¥¸¥ç¥ó¤ËÈæ¤Ù¤Æ¤É¤³¤¬¿·¤·¤¤
¤Î¤«¡¢¤¢¤ë¤¤¤Ï¤É¤³¤¬°ã¤Ã¤Æ¤¤¤ë¤Î¤«¡¢¼ÂºÝ¤Ë¤¤¤¸¤¯¤ê¤Þ¤ï¤·¤Ê¤¬¤é
Ä´¤Ù¤ë¤¿¤á¤Ê¤Î¤Ç¤¹¡£
<P>¤½¤¦¤¤¤¦¤ï¤±¤Ç¡¢¤Ê¤ë¤Ù¤¯ 'dbassist' ¤Î°Â°×¤Ê¥ª¥×¥·¥ç¥ó¤òÁª¤Ó¤Þ¤·¤¿¡£
Ê̤Υǥ£¥¹¥¯¡¢¤Þ¤¿¤Ï¤»¤á¤ÆÊ̤Υѡ¼¥Æ¥£¥·¥ç¥ó¤ò»ÈÍѤ¹¤ë¤³¤È¤ò
¿ä¾©¤µ¤ì¤Þ¤·¤¿¤¬¡¢¤½¤¦¤·¤Þ¤»¤ó¤Ç¤·¤¿¡£»ä¤Î <CODE>$ORACLE_HOME</CODE> ¤Ï 
<CODE>/home/oracle</CODE> ¤Ç¤¹¡£¤¹¤Ù¤Æ¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤È¥½¥Õ¥È¥¦¥§¥¢¤Ï
¤Þ¤È¤Þ¤Ã¤Æ¤½¤³¤Ë¤¢¤ê¡¢1 ¤Ä¤Î¥Ñ¡¼¥Æ¥£¥·¥ç¥ó¤Î¾å¤ËºÜ¤Ã¤Æ¤¤¤Þ¤¹¡£
<H2><A NAME="ss4.2">4.2 ¥¹¥Æ¥Ã¥×¥Ð¥¤¥¹¥Æ¥Ã¥×¥¬¥¤¥É</A>
</H2>

<P>
<OL>
<LI>¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤Ç²¼¤Î¤è¤¦¤Ë¥¿¥¤¥×¤·¤Þ¤¹¡£
<PRE>
dbassist
</PRE>

</LI>
<LI>»ä¤Î¥Þ¥·¥ó¤Ï "JNLS Exception: oracle.ntpg.jnls.JNLSException. 
Unable to find any National Character Sets." ¤È¸À¤Ã¤Æ¤­¤Þ¤¹¡£
Oracle8i ¥Ñ¥Ã¥Á¥Þ¥Ë¥å¥¢¥ë¤Ë¤è¤ë¤È¡¢¤³¤ì¤Ï´ûÃΤÎÌäÂê (884001) 
¤Ê¤Î¤Ç̵»ë¤·¤ÆÂç¾æÉפǤ¹¡£</LI>
<LI>"Create a database" ¥é¥¸¥ª¥Ü¥¿¥ó¤òÁªÂò¤·¡¢"Next" ¤ò²¡¤·¤Þ¤¹¡£</LI>
<LI>¤³¤³¤Ç2¤Ä¤Î¥ª¥×¥·¥ç¥ó¤¬¤¢¤ê¤Þ¤¹¡£Ä̾ï(Typical)¤È¥«¥¹¥¿¥à(Custom)¤Ç¤¹¡£
dbassist ¤ÎÁàºî¤¬¤­¤Á¤ó¤È¤ï¤«¤ë¤°¤é¤¤¤Ê¤é¡¢¤³¤ó¤Ê¤È¤³¤í¤òÆɤó¤Ç¤Ï¤¤¤Ê¤¤
¤Ç¤·¤ç¤¦¤·¡¢¥«¥¹¥¿¥à¤òÁª¤ó¤Ç¤â³Ú¾¡¤Ç¤·¤ç¤¦¡£¤½¤ì¤Ï¤³¤³¤Ç¤Ï¼è¤ê°·¤¤¤Þ¤»¤ó¡£
Âå¤ï¤ê¤Ë¡¢"Typical" ¤òÁªÂò¤· "Next" ¤ò²¡¤·¤¿¤â¤Î¤È¤·¤Þ¤¹¡£
(ÌõÃí: ÆüËܸì¥á¥Ã¥»¡¼¥¸¤ò¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¾ì¹ç¤Ï Custom
¤òÁªÂò¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£À½ÉÊÁªÂò²èÌ̤ΤȤ³¤í¤Ç±¦¾å¤Î
Language ¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¡¢Japanese ¤òÄɲ䷤Ƥ¯¤À¤µ¤¤)
</LI>
<LI>¼¡¤Ë CD ¤«¤é¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥³¥Ô¡¼¤¹¤ë¤«¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òºîÀ®¤¹¤ë¤«
ʹ¤¤¤Æ¤­¤Þ¤¹¡£»ä¤¬¡¢ºÇ½é¤Î¥ª¥×¥·¥ç¥ó¤ò»î¤·¤¿¤È¤­¤Ï¡¢ Oracle ¤Ï CD 
¥×¥ì¡¼¥ä¤ò¸«¤Ä¤±¤ë¤³¤È¤Ë¾ï¤Ë¼ºÇÔ¤·¤Æ¤¤¤Þ¤·¤¿¡£
(¤¿¤Ã¤¿º£¤½¤³¤«¤é¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¤Ð¤«¤ê¤Ê¤Î¤Ë¡ª) ¤Ç¤¹¤Î¤Ç¡¢
2ÈÖÌܤΥª¥×¥·¥ç¥ó¤ò¤ª´«¤á¤·¤Þ¤¹¡£Ê̤ËÆñ¤·¤¤¤ï¤±¤Ç¤Ï¤Ê¤¯¡¢
¾¯¤·Í¾·×¤Ë»þ´Ö¤¬¤«¤«¤ë¤À¤±¤Ç¤·¤ç¤¦</LI>
<LI>¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÁö¤é¤»¤ë´Ä¶­¤òʹ¤«¤ì¤¿¤È¤­¡¢'Hybrid' ¤òÁªÂò¤¹¤ë¤Î¤¬
¤ª¤½¤é¤¯ÌµÆñ¤Ç¤·¤ç¤¦¡£</LI>
<LI>º£Å٤Ͼï»þ²¿¿Í¤Î¥æ¡¼¥¶¤¬¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÍøÍѤ¹¤ë¤«Ê¹¤¤¤Æ¤­¤Þ¤¹¡£
»ä¤Ï 5 ¤ÈÆþ¤ì¤Þ¤·¤¿¡£</LI>
<LI>¼¡¤Ë¿·¤·¤¤¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤É¤ÎÀ½ÉʤòÆþ¤ì¤ë¤«Ê¹¤¤¤Æ¤­¤Þ¤¹¡£
¤³¤³¤Ç¤â¡¢¼«Ê¬¤¬²¿¤òÆþ¤ì¤¿¤¤¤Î¤«¤Ê¤ó¤Æ»ä¤è¤êÆɼԤ㧤µ¤ó¤Î¤Û¤¦
¤¬¤è¤¯¤ï¤«¤Ã¤Æ¤¤¤Þ¤¹¤è¤Í¡ª</LI>
<LI>¤³¤³¤Ç¡¢Oracle ¤Ï ¡Ö¥°¥í¡¼¥Ð¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¡× ¤È "SID" ¤òɬÍפȤ·¤Þ¤¹¡£
¤³¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤Ï¡¢¥Õ¥ë¥É¥á¥¤¥ó̾¤Î¤è¤¦¤Ê¤â¤Î¤Ç¤¹¡£
(¤·¤«¤·ÊÌʪ¤Ç¤¹) Oracle ¤Îã¿Í¤Ê¤é²¿¤òÆþ¤ì¤ë¤Ù¤­¤«¤ï¤«¤ë¤Ç¤·¤ç¤¦¤¬¡¢
¤½¤¦¤Ç¤Ê¤¤¾ì¹ç¡¢ÆɼԤβñ¼Ò¤Ë¤Ï¤Ê¤ó¤é¤«¤Î̿̾µ¬Â§¤¬¤¢¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£
»ä¤Î¾ì¹ç¤Ï¡¢'dev1' ¤È¤·¤Þ¤·¤¿¡£(SID ¤È¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤ÎξÊý¤ËÂФ·¤Æ)</LI>
<LI>¤µ¤Æ¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¡ö¤¤¤Þ¡ö¤³¤³¤ÇºîÀ®¤·¤Þ¤¹¤«¡©¤½¤ì¤È¤âɬÍפʾðÊó¤ò
¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤ËÊݸ¤µ¤»¤¿¤Û¤¦¤¬¤¤¤¤¤Ç¤·¤ç¤¦¤«¡©128MB ¤Î RAM ¤Ç¤Ï¡¢
Á°¼Ô¤Î¥ª¥×¥·¥ç¥ó¤Ï¶ìÄˤÀ¤È¤¤¤¦¤³¤È¤¬¤ï¤«¤ê¤Þ¤·¤¿¡£»ä¤Ï¥·¥§¥ë¥¹¥¯¥ê¥×¥È¤ò
ºîÀ®¤·¡¢X ¤Ê¤É¥á¥â¥ê¤òÂçÎ̤˾ÃÈñ¤¹¤ë¤â¤Î¤ò¤¹¤Ù¤Æ½ªÎ»¤µ¤»¤Æ¡¢¤½¤Î¥¹¥¯¥ê¥×¥È¤ò
Áö¤é¤»¤Þ¤·¤¿¡£¤½¤Ã¤Á¤Î¤Û¤¦¤¬¤º¤Ã¤È¼êºÝ¤¬¤¤¤¤¤Ç¤¹¡£</LI>
<LI>¥É¥­¥å¥á¥ó¥È¤Î¤É¤³¤Ë¤â¸«¤Ä¤«¤é¤Ê¤«¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢¤³¤ì¤Ê¤·¤Ë¤Ï
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ï¤Þ¤È¤â¤ËÆ°¤­¤Þ¤»¤ó¡ª 'dbassist' ¤¬ºîÀ®¤¹¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¼«ÂΤÏ
¤¤¤¤¤Î¤Ç¤¹¤¬¡¢¥Ç¥Õ¥©¥ë¥È¤Ç¥æ¡¼¥¶¥í¡¼¥ë¥Ð¥Ã¥¯¥»¥°¥á¥ó¥È¤¬¥ª¥Õ¥é¥¤¥ó¤Ë
¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£(Ãí¼á - Èó¥·¥¹¥Æ¥à¥æ¡¼¥¶¤Ï¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤òɬÍפȤ¹¤ë
Áàºî¤ò¼Â¹Ô¤Ç¤­¤Þ¤»¤ó) °Ê²¼¤Î¤è¤¦¤Ë¥¿¥¤¥×¤·¤Þ¤¹¡£

<PRE>
cd $ORACLE_HOME/dbs
</PRE>


¤³¤³¤Ç¡¢"init&lt;SID&gt;.ora" ¤È¤¤¤¦Ì¾Á°¤Î¥Õ¥¡¥¤¥ë¤òÊÔ½¸¤¹¤ëɬÍפ¬
¤¢¤ê¤Þ¤¹¡£ (»ä¤Î¾ì¹ç "initdev1.ora" ¤Ç¤·¤¿)

¥Õ¥¡¥¤¥ë¤Î¿¿¤óÃ椢¤¿¤ê¤Ç¡¢¤³¤ó¤Ê´¶¤¸¤Î¹Ô¤¬¥³¥á¥ó¥È¥¢¥¦¥È¤µ¤ì¤Æ¤¤¤Þ¤¹¡£

<PRE>
# rollback_segments = (r01, r02, r03, r04)
</PRE>


¤³¤Î¹Ô¤Î¥³¥á¥ó¥È¤ò³°¤·¤Æ(¥·¥ã¡¼¥×µ­¹æ¤ò¼è¤ê½ü¤¯) ¥Õ¥¡¥¤¥ë¤òÊݸ¤¹¤ì¤Ð
½ª¤ï¤ê¤Ç¤¹¡£</LI>
<LI>¤³¤ì¤Ï¥á¥¿¥¹¥Æ¥Ã¥×¤È¤Ç¤â¸Æ¤Ö¤Ù¤­¤â¤Î¤Ç¤¹¡£¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¤¢¤Ã¤Æµ¯Æ°
¤Ç¤­¤ë¤Ï¤º¤À¤È¤·¤Æ¤â¡¢¤ª¤½¤é¤¯¥Ñ¥¹¥ï¡¼¥É¥·¥¹¥Æ¥à¤Ë¤Ä¤¤¤Æ¤Ï²¿¤âÃΤê
¤Þ¤»¤ó¤è¤Í¡ªÃΤäƤª¤¯¤Ù¤­¤³¤È¤¬2¤Ä¤¢¤ê¤Þ¤¹¡£1¤Ä¤Ï SYSTEM ¤Î¥Ñ¥¹¥ï¡¼¥É
¤Ç¤¹¡£¥Ç¥Õ¥©¥ë¥È¤Ï '<CODE>MANAGER</CODE>' ¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ (Oracle ¤Î¥Ñ¥¹¥ï¡¼¥É¤Ï
Âçʸ»ú¤Ë¤¹¤ë¤Î¤¬½¬¤ï¤·¤Î¤è¤¦¤Ç¤¹¡£¼ÂºÝ¤Ë¤Ï¡¢Âçʸ»ú¾®Ê¸»ú¤Î°ã¤¤¤Ïǧ¼±
¤µ¤ì¤Þ¤»¤ó) SQL*Plus ¤Î¥×¥í¥ó¥×¥È¤Ç <CODE>password</CODE> ¤È
¥¿¥¤¥×¤·¤Æ¡¢¤¹¤°¤Ë¥Ñ¥¹¥ï¡¼¥É¤òÊѹ¹¤¹¤ë¤³¤È¤ò¤ª´«¤á¤·¤Þ¤¹¡£
(<CODE>ALTER USER</CODE> ¥³¥Þ¥ó¥É¤¸¤ã¤Ê¤¤¤«¤È»×¤¦¿Í¤â¤¤¤ë¤Ç¤·¤ç¤¦¤¬¡¢¤³¤ì¤Ï 
8i ÉÕ°¥Ð¡¼¥¸¥ç¥ó¤Î SQL*Plus ¤Î¿·¥³¥Þ¥ó¥É¤Ç¤¹) ¾¤ËÃΤëɬÍפ¬¤¢¤ë¤Î¤Ï¡¢
SYS ¤Î¥Ñ¥¹¥ï¡¼¥É¤Ç¤¹¡£¤³¤Î¥Ç¥Õ¥©¥ë¥È¤Ï '<CODE>CHANGE_ON_INSTALL</CODE>' ¤Ç¡¢
¤½¤Î̾¤ÎÄ̤ꥤ¥ó¥¹¥È¡¼¥ë¤·¤¿¤é¤¹¤°¤ËÊѹ¹¤·¤Þ¤·¤ç¤¦¡ª</LI>
<LI>ºÇ¸å¤Î¥¹¥Æ¥Ã¥×¤Ç¤¹¡£¤³¤ì¤Ï¡¢SQL*Plus ¤Ø¤Î¥í¥°¥¤¥ó»þ¤Î
¤¦¤Ã¤È¤¦¤·¤¤ 'no profile' ·Ù¹ð¤ò¼è¤ê½ü¤­¤Þ¤¹¡£'system' ¥æ¡¼¥¶¤È¤·¤Æ
¥í¥°¥¤¥ó¤·¤Æ¤¯¤À¤µ¤¤¡£(<CODE>sqlplus system/&lt;password&gt;</CODE>) 
¤½¤ì¤«¤é¼¡¤Î¤è¤¦¤Ë¥¿¥¤¥×¤·¤Þ¤¹¡£

<PRE>
@?/sqlplus/admin/pupbld.sql
</PRE>


µ¿ÌäÉä¤Ï <CODE>$ORACLE_HOME</CODE> ¥Ç¥£¥ì¥¯¥È¥ê¤Î¥¨¥¤¥ê¥¢¥¹¤Ç¤¹¡£
</LI>
</OL>

¤³¤ì¤Ç½ª¤ï¤ê¤Ç¤¹¡£¤³¤ì¤Ç¡¢SQL*Plus ¤ò»È¤Ã¤Æ¥í¥°¥¤¥ó¤Ç¤­¤Æ¡¢
¤¹¤°¤Ë»È¤¨¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¤Ç¤­¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£
<P>
<H2><A NAME="ss4.3">4.3 £Ñ¡õ£Á</A>
</H2>

<H3>ËÜÅö¤Ë¤½¤ó¤Ê¤Ë´Êñ¤Ê¤ó¤Ç¤¹¤«¡©</H3>

<P>Åú¤¨¤Ï¥¤¥¨¥¹¤Ç¤¢¤ê¥Î¡¼¤Ç¤â¤¢¤ê¤Þ¤¹¡£¤¿¤ÀÍ·¤ó¤À¤ê¡¢8i ¤Î¿·¤·¤¤ÆÃħ¤ò
³Ø¤Ö¤¿¤á¡¢¼«Ê¬¼«¿ÈÍѤ˥ǡ¼¥¿¥Ù¡¼¥¹¤ò¹½ÃÛ¤¹¤ë¤Ê¤é¡¢Åú¤¨¤Ï¥¤¥¨¥¹¤Ç¤¹¡£
¾å¤Î»Ø¼¨¤Ë½¾¤Ã¤Æ¤Ç¤­¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ï´°Á´¤Ç¡¢¤¦¤Þ¤¯Æ°ºî¤·¤Þ¤¹¡£
<P>¤·¤«¤·¡¢Oracle ¤Ë¤Ä¤¤¤ÆÃ챤¬¤¢¤ë¤Ê¤é¡¢¥Ç¥Õ¥©¥ë¥È¤Î¥³¥ó¥Õ¥£¥®¥å¥ì¡¼¥·¥ç¥ó¤Ï
¤¢¤­¤ì¤ë¤Û¤É¤Ò¤É¤¤¤â¤Î¤À¤È¤¹¤°¤Ëµ¤¤Å¤¯¤Ç¤·¤ç¤¦¡£¤â¤·ËܳÊŪ¤Ê»Å»öÍѤÎ
¥·¥¹¥Æ¥à¤òºî¤Ã¤Æ¤¤¤ë¤Ê¤é¡¢"Custom" ¥ª¥×¥·¥ç¥ó¤ò»È¤Ã¤¿¤Û¤¦¤¬¤¤¤¤¤Ç¤·¤ç¤¦¡£
<P>»ä¤Î¤ªÍ·¤Ó¤Î¥·¥¹¥Æ¥à¤ËÂФ·¤Æ¤µ¤¨¡¢¤¤¤¯¤é¤«¤Ò¤Í¤ê¤òÆþ¤ì¤Þ¤·¤¿¡£ÂçÉôʬ¤Î
¥Æ¡¼¥Ö¥ë¥¹¥Ú¡¼¥¹¤Î¥µ¥¤¥º¤òÁý¤ä¤·¡¢¤«¤Ä¤½¤ì¤¬¼«Æ°Åª¤ËÁý¤¨¤Ê¤¤¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£
(Íø¸ý¤Ö¤ë¥½¥Õ¥È¥¦¥§¥¢¤Ï·ù¤¤¤Ç¤¹)
<H3>ËÜÅö¤Ë¤¹¤Ù¤Æ¤Î¥Õ¥¡¥¤¥ë¤òÊÌ¡¹¤Î¥Ç¥£¥¹¥¯¤ËÆþ¤ì¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¤«¡©</H3>

<P>ɬÍפϤ¢¤ê¤Þ¤»¤ó¡£¤½¤¦¤·¤Ê¤¯¤Æ¤âÆ°ºî¤·¤Þ¤¹¡£¤·¤«¤·¡¢¤½¤¦¤À¤È¤·¤Æ¤â¡¢
¤¹¤Ù¤Æ¤Î¥Õ¥¡¥¤¥ë¤òƱ¤¸¥Ç¥£¥¹¥¯¤ËÆþ¤ì¤ë¤Î¤Ï´«¤á¤Þ¤»¤ó¡£
<P>¥Õ¥¡¥¤¥ë¤ò¤¤¤¯¤Ä¤«¤Î¥Ç¥£¥¹¥¯¤Ëʬ»¶¤·¤ÆÃÖ¤¯¤È¡¢¤¿¤È¤¨¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤È
¥í¡¼¥ë¥Ð¥Ã¥¯¥»¥°¥á¥ó¥È¤òÊÌ¡¹¤Ë¤¹¤ë¤À¤±¤Ç¤â¡¢Ãø¤·¤¤¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¾å¤Î
ÍøÅÀ¤¬¤¢¤ê¤Þ¤¹¡£¾Ü¤·¤¯¤Ï¡¢Oracle DBA book ¤òÆɤó¤Ç¤¯¤À¤µ¤¤¡£
<P>
<H3>dbassist ¤òµ¯Æ°¤Ç¤­¤Þ¤»¤ó</H3>

<P>ºÇ½é¤Ë¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿»þ¤Ë¤¤¤¯¤Ä¤«¤¢¤ëŤµ 0 ¤Î¥Õ¥¡¥¤¥ë¤¬¸¶°ø¤Ç¤¹¡£
¥Ñ¥Ã¥Á¤òÅö¤Æ¤ë¤ÈÌäÂê¤Ï²ò·è¤·¤Þ¤¹¡£
<H3>"ORA-01034: ORACLE not available" ¤È¸À¤ï¤ì¤Þ¤¹</H3>

<P>´Êñ¤Ë¸À¤¦¤È¡¢¤ª¤½¤é¤¯¡¢<CODE>$ORACLE_SID</CODE> ¤¬Àµ¤·¤¯ÀßÄꤵ¤ì¤Æ¤¤¤Ê¤¤¤«¡¢
¤¢¤ë¤¤¤Ï¤Þ¤Ã¤¿¤¯ÀßÄꤵ¤ì¤Æ¤¤¤Ê¤¤¤«¡¢¤Ç¤¹¡£'dbassist' ¤ÇÍ¿¤¨¤¿¤â¤Î¤È
Ʊ¤¸ÃͤËÀßÄꤵ¤ì¤Æ¤¤¤Æ¡¢¤«¤Ä¥¨¥¯¥¹¥Ý¡¼¥È¤µ¤ì¤Æ¤¤¤ë¤³¤È¤ò³Îǧ¤·¤Æ
¤¯¤À¤µ¤¤¡£ (¤Ä¤Þ¤ê B ¥·¥§¥ë¸ß´¹¥·¥§¥ë¤Ç¤Ï¡¢export <CODE>ORACLE_SID</CODE>)
<H3>"ORA-01012: Not logged in" ¤È¸À¤ï¤ì¤Þ¤¹</H3>

<P>¤³¤ì¤Ï¤È¤Æ¤â¤¢¤ê¤Õ¤ì¤¿¥¨¥é¡¼¤Ç¡¢¤¤¤í¤¤¤í¤Ê¸¶°ø¤¬¤¢¤ê¤Þ¤¹¡£
<P>¤Þ¤º¡¢¶¦Í­¥µ¡¼¥Ð¹½À® (MTS ¤È¸Æ¤Ð¤ì¤ë¤³¤È¤â¤¢¤ë) ¤Ç¤Ï¤Ê¤¤¤³¤È¤ò³Îǧ¤·¤Æ
¤ß¤¿¤Û¤¦¤¬¤¤¤¤¤Ç¤·¤ç¤¦¡£ÀìÍÑ¥µ¡¼¥Ð¹½À®¤ò»È¤Ã¤Æ¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤·¡¢
¸å¤Ç¤½¤ì¤òÊÑ´¹¤·¤Þ¤¹¡£
(ÌõÃí¡§¶¦Í­¥µ¡¼¥Ð¹½À®¤Ç¤Ï¡¢¤Ï°ì¤Ä¤Î¥µ¡¼¥Ð¡¼¥×¥í¥»¥¹¤¬Ê£¿ô¤Î¥æ¡¼¥¶¡¼
¥»¥Ã¥·¥ç¥ó¤Î½èÍý¤ò¼õ¤±»ý¤Ä¤Î¤ËÂФ·¡¢ÀìÍÑ¥µ¡¼¥Ð¡¼¹½À®¤Ç¤Ï¡¢¥æ¡¼¥¶¡¼
¤Î¥»¥Ã¥·¥ç¥ó£±¤Ä¤ËÂФ·¤Æ Oracle ¤Î¥µ¡¼¥Ð¡¼¥×¥í¥»¥¹¤¬°ì¤Ä
À¸À®¤µ¤ì¤Þ¤¹)
<P>¤³¤ì¤¬¸¶°ø¤Ç¤Ê¤±¤ì¤Ð¡¢NLS_LANG ´Ä¶­ÊÑ¿ô¤ò¥Á¥§¥Ã¥¯¤·¤Þ¤¹¡£°ìÈÖ´Êñ¤Ê¤Î¤Ï¡¢
¤½¤ì¤ò unset ¤¹¤ë¤³¤È¤Ç¤¹¡£¤â¤·ËÜÅö¤Ë»È¤¤¤¿¤¤¤Ê¤é¡¢É¬¤º´°àú¤ËÀµ¤·¤¯ÀßÄꤷ¤Þ¤¹¡£
1 (¤¤¤Á) ¤È l (¥¨¥ë) ¤ò¼è¤ê°ã¤¨¤Ê¤¤¤è¤¦¤Ëµ¤¤ò¤Ä¤±¤Æ¤¯¤À¤µ¤¤¡ª
(ÌõÃí¡§EUC »ÈÍѤÎÆüËܸì´Ä¶­¤Ç¤Ï japanese_japan.ja16euc ¤ò»È¤¤¤Þ¤¹¡£
¤¿¤À¤·´Ä¶­ÊÑ¿ô ORA_NLS33 ¤âÀµ¤·¤¯ÀßÄꤷ¤Ê¤¤¤ÈÆüËܸì¥á¥Ã¥»¡¼¥¸¤Ï»È¤¨¤Þ¤»¤ó)
<P>
<HR>
<A HREF="Oracle-8-HOWTO-5.html">¼¡¤Î¥Ú¡¼¥¸</A>
<A HREF="Oracle-8-HOWTO-3.html">Á°¤Î¥Ú¡¼¥¸</A>
<A HREF="Oracle-8-HOWTO.html#toc4">Ìܼ¡¤Ø</A>
</BODY>
</HTML>

APT Browse - Built by Thomas Orozco.