¦b RedHat 6.2¤W«ö¨B´N¯Z¸Ë¦nOracle 8i-(version 8.1.5)

ORACLE 8i ªº­«­n°T®§!
ORACLE 8i
¥Ø«e¦³¤T­Óª©¥»-8.1.5 ;8.1.6 & 8.1.7¤Tª©. ¤@¯ë¤å¥ó¤Wªºµû½×¬O

8.1.5ªºbug·¥¦h. 8i Release 2 (§Yversion 8.1.6.1).¬O¸û¨ü±ÀÂ˪ºª©¥». 8.1.7 «h¬O¥Ø«eoracle©x¤èºô¯¸ªºreleaseª©¥».¤£ºÞ´X­Óª©¥»,Á`¬O­n¸Õ¬Ý¬Ý

§Ú¨Ï¥Îªº¾÷¾¹²ÕºA

ÁöµM Oracle «Øij­È¦Ü¤Ö 256 megs RAM, ¦ý§Ú¨Ï¥Î¹L³o²Õ¾÷¾¹¸Ë³],¾÷¾¹²ÕºA¬°¡G

      AMD 333 ,192 megs RAM , 10 gig HD.ORACLE 8.1.5¤]¤@¼Ë¥i¥H¨Ï¥Î,¦Ü©ó8.1.6 ©M8.1.7¨â­Óª©¥»,§Ú·|¦A§V¤O

¤å¥ó¤À¤»¬q¸¨

RedHat °ò¥»¦w¸Ë -¥]¬A RedHat 6.2¦w¸Ë, ¼W¥[Oracle°O¾ÐÅé°Ñ¼Æ( memory parameters)ªº¤èªk
¦w¸Ë«e»Ýdownload ©Mª`·N¨Æ¶µ ¡V
¦b¦w¸Ë«e,¥²»Ý¥ý¦³ Java RunTime Àô¹Ò©M¤@­Ó patchÀÉ.
Oracle ¦w¸Ë«e²ÕºA -
³]©w users, groups, mount points ©M environment variables.  
Oracle ¦w¸Ë -
¤@¨B¨B¦w¸ËOracle.
§ó§ï permissions ©M¸Ë¤WpatchÀÉ - 
°õ¦æ patch ÀÉ.
Oracle ¦w¸Ë«áªº½Õ¾ã -
²ÕºA½Õ¾ã©M´ú¸Õ
§Ú¥²»Ý¯S§O±j½Õ¡A³o¨Ç¨BÆJ¦b§Úªº¾÷¾¹²ÕºA¤¤³£½T¹ê°õ¦æ¹L¡A½T©w¥i¦æ¡F¦ý§Ú¤£«OÃÒ¥u°õ¦æ¤ùÂ_ªº³¡¥÷¨BÆJ¤]¥i°õ¦æ¡A¦p¦U¦ì¦³§ó¦nªº¦w¸Ë¤èªk¡A½Ð¤£§[§i¶D§Ú¡C

¬°¦ó¿ï¾Ü Redhat?
­Ó¤HÁÙÄÝLinux ªº·s¥Í¡A¿ï¾Ü¥ÑRedHat ¶}©l¤Jªù¡A´N¬OµÛ²´¦b RedHat ¦³¸û§¹³ÆªºRPM  ®M¥ó¡F¥BOracle ¥H RedHat ¬° Linux ¤W³Ì¥D­nªº¥­¥x¡C  


Redhat°ò¥»¦w¸Ë
¥i¨Ì­Ó¤H»Ý¨D¥h³W¹º, ¥H¤U¥u¬O§Úªº«Øij°µªk.

A. Partitioning
1)
±N swap partitions  ºÉ¶q½Õ¦¨ °O¾ÐÅéÁ`¼Æªº3­¿©Î¥H¤W 

2) ³W®æ¤Æ§AªºµwºÐ¡A§Ú±NµwºÐ³W¹º¦p¤U¡G

 /          hda1      8001mb      linux native

/home   hda5      1302mb      linux native

hda6         462mb      swap

©Î¬Oµ¹Oracle ¤@­Ómount point (/u01). ·íµM§A¤]¥i¥H¦p OFA ¤¤«Øij°µ¦¨4­Ómount point,©Î³\ performance ·|§ó¦n¨Ç.

 

B. X Windows
 Oracle 8i
¤@©w­n¨Ï¥Î¨ìX Windows. µ{¦¡¥»¨­¤w¸g¬O GUI-based. ¦b Redhat 6.2¤U, §A ¥i¨Ï¥Î Gnome ©Î KDEÀô¹Ò. °ò¥»¤W³£¶]±o°Ê.¦Ó­Ó¤H¬O¸û³ßÅwGnomeÀô¹Ò .

C. Redhat Install ªº¿ï¶µª¬ªp
¦b Redhat WORKSTATION ²ÕºA¤U¥i¦æ¶Ü? ---¥i¥H.
¦b RedHat SERVER²ÕºA¤U¥i¦æ¶Ü? ---¥i¥H.
¦b RedHat CUSTOM²ÕºA¤U¥i¦æ¶Ü? --- °O±o¤£­nº|±¼¥H¤Uªº packages:

  • XWindows ¬ÛÃö¶µ¥Ø
  • C Development

D. «Øij³Ì¦n±N kernel´£ª@:
1)
±N RedHat 6.2 CD  mount °_¨Ó¨Ã¤Á´«¨ì /RedHat/RPMS ¥Ø¿ý

  • mount  /mnt/cdrom
  • cd /cdrom/RedHat/RPMS

2) Install the kernel source RPM:

  • rpm -ivh kernel-source-2.2.12-20.i386.rpm. ³o¬O­Ó¤H«Øij¤]¨Ï¥Î¹L³Ìí©wªº kernel source, «Øij±Nkernel source´«¦¨¦¹ª©.

3) unmount RedHat CD: 

  • cd /
  • umount /cdrom

Kernel memory °Ñ¼Æ
®Ú¾Ú Oracle install manual¥²»Ý¦binstall«e¥ý½Õ¾ã¦n°O¾ÐÅé°Ñ¼Æ. ¦b RedHat 6.2¤¤, Oracle ¨Ã¤£»Ý½Õ¾ã kernel memory´N·|¶]. ­Ó¤H¬Ýªk¬O¨Ì§Aªº»Ý¨D©MµwÅ骬ªp¨M©w. Redhat 6.2 ªºSHMMAX default setting ¬O 32 megs,¦p§A¦³§ó¦h RAM(¦h©ó64 megs), ´N¥i¥H½Õ½Õ¬Ý¡C

ĵ§i§A!
§ó°Ê kernel parameters ¥²¶· recompile§Aªº Linux kernel. ¦p¤£´¿°µ¹L,¤@©w­n¥ý¬Ý¦n¤â¥U¦A°µ¡A§_«hÁÙ¬O¤Ö°µ²§°Ê¡F²§°Ê¨BÆJ¦p¤U¡G

§ó°Ê memory params
1)
¤Á´«¨ì¥Ø¿ý¤¤¦A½s¿è shmparam.h 

  • cd /usr/src/linux/include/asm
  • vi shmparam.h

2) ©¹¤U§ä¨ì "#define SHMMAX 0x2000000." ¨ä¤¤ 0x2000000 ¥Nªí 32 megs. ±N¥¦§ï¦¨§A©Ò­nªº. §Ú±N¥¦§ï¦¨ 0x8000000¥Nªí¦³128 megs RAM . 
¨ä¾l°Ñ¦Ò­È¦³
0x4000000 = 67108854        64 megs RAM
0x6000000 = 100663296      96 megs RAM

3) ²§°Ê«á¦sÀÉ 

4) ²{¦b§A¥i¥H recompile kernel. Recompile «áÄ~Äò©¹¤U°µ¡C(¦p¤£°µ Recompile ¤]¥i¥HÄ~Äò¦w¸Ë§¹¦¨¡A¦ý®Ä¯à¸û®t



¦w¸Ë«e»Ý download ©Mª`·N¨Æ¶µ
Java RunTime Àô¹Ò
·í¶}©l¸Ë 8i®É, Oracle »Ý­n Java RunTime ªºÀô¹Ò¨ÓÅý installer run. ³Â·Ðªº¬O RedHat ¨Ã¨S´£¨Ñ¦¹®M¥ó, ¥²»Ý¦Û¤v download . ¤èªk¦p¤U:

1) ¥H root Login ¤Wºô³s¨ì http://www.blackdown.org

2) ¿ï¨ì downloads Ápµ²¶µ.

3) §A²´«e©Ò¨£´N¬O FTP ¯¸¤¤ªºµe­±.

4) ´M§ä jre_1.1.6-v5-glibc-x86.tar.gzÀÉ®×. ¤£­ndownload¸û·sªºª©¥»(8.1.5»P¦¹ª©¸û¶¶) .  ¤Á°O¤@©w­n§äÀɮ׶}ÀY¬O jre...ªºÀÉ®×. ¨Ã¤£¬O jdk... ªºÀÉ®×.

5) ±NÀÉ®×download ¨ì /usr/local.

6) ¶}­Ó terminal window. ¸ÑÀ£ÁY«á°µ­ÓÁpµ²Åý Oracle Installer ¯à§ä¨ìÀÉ®×. ¤èªk¦p¤U:

  • tar xzvf  jre_1.1.6-v5-glibc-x86.tar.gz
  • ln -s /usr/local/jre116_v5 /usr/local/jre

7) ½T»{¤@¤U¬O§_Ápµ²¦¨¥\

§ä¨ì oracle 8i ªºpatchset
³o patches¥i­×¸É¤@¨Ç Oracle 8i for Linuxªº°ÝÃD. ¸Ë¸m patchesªº¤èªk¦p¤U!

1) ¤Wºô³s¨ì http://technet.oracle.com.

2) ¦p§A¨S¦³±b¸¹, ´Nµù¥U¤@¤U. ³o¬O§K¶O¦Ó¥i§ä¨ìORACLE¸ê°TªººÞ¹D.

3) ¥ý¿ï Software ³¡¥÷

4) ¦b "Select a Product" ³¡¥÷¿ï "8i Enterprise Edition," ¤£ºÞStandard edition©ÎEnterprise editionªº patchsetÀɳ£¬O¤@¼Ëªº.

5) ¨Ìµe­±»Ý¨DÁä¤J±b¸¹©M±K½X.

6) ¿ï¾Ü·Q­nªº³nÅé.

7) Accept ©Ò¦³ªº license agreement.

3) ³Ì«á§ä¨ì linux_815patches.tar.gz

4) ±NÀɮצs¨ì homeªºroot¥Ø¿ý¤U.

±µµÛ¶i¦æ Oracle ¦w¸Ë«e²ÕºAªº³]©w.


Oracle ¦w¸Ë«e²ÕºA
¦b¦¹¬q¸¨¤¤, ±N«Ø¥ß user©Ò»Ýªº¸s²Õ©M±b¸¹.

«Ø¥ß Oracle account ©M group
oracle
±b¸¹¥Î¨Ó«Ø¥ß¨Ã±Ò©l oracle database. dba ¸s²Õ¥Î¨Ó°µ Database Administrators.

1) ¥ý¶}¤@­Ó¤å¦r terminal window.

2) ¦b¦¹ terminal window ¤¤«Ø¥ß¸s²Õ±b¸¹

  • groupadd dba

3) ±µµÛ«Ø¥ß oracle user±b¸¹.

  • useradd oracle -g dba (¨Ïsub number ©M dba group ¬Û¦P)
  • passwd oracle («Ø¥ß¨Ï¥ÎªÌ±K½X)


4)
¤§«e,±N linux_815patches.tgz ©ñ¦bhomeªºroot¥Ø¿ý¤U. ²{¦b±N¥¦²¾¨ì oracleªº home ¥Ø¿ý¤¤¨Ã§ó§ïpermissions Åý oracle ±b¸¹¯à¨Ï¥Î. ¦b terminal window¤¤¦p¦¹°µ:

  • mv ~/linux_815patches.tar.gz /home/oracle
  • chown -R oracle.dba /home/oracle/linux_815patches.tar.gz

5) ¦p§A¤]¹³§Ú¨S°µ mount points µ¹Oracle, ´N°µ­Ó¥Ø¿ýµ¹ oracle, §Úµ¹¥¦¦WºÙ /u01. 

  • mkdir /u01. (§A¤]¥i¹³ OFA«Øij«Ø /u01, /u02, /u03 ©M /u04 ¥|­Ó¥Ø¿ý).

6) §ó§ï mount points ¤Wªºowner ©M group permissions. 

  • chown oracle.dba /u01 (¦p§A¦³ /u02, /u03 and /u04 ´N­«Âаµ)

7) Log out.  (°h¥Xroot±b¸¹)

8) ¥H oracle ±b¸¹Log in.

³]©w oracle userªºÀô¹Ò
1)
¶}­Ó terminal window.

2) ½T»{ Oracle CD ¬O§_mount°_¨Ó¤F. ¦pªG¨S¦³¥i¦p¦¹°µ:

  • su root (¿é¤J password)
  • mount  /mnt/cdrom
  • exit (¦A¦^¨ìoracle±b¸¹ªºÅv­­).


3)
Áä¤J umask «á[enter]¡A¥H½T»{ umask ­È¬° 022. ¦pªG¬Oªí¥Ü¤@¤Á¶¶§Q.¦pªG¤£¬O,µ¥¤@¤U¦b  .bash_profile Àɤ¤»Ý¥[¥H³]©w

4) ¨Ï¥Î§A³Ì±`¥Îªº½s¿è¤u¨ã¦b oracle ªº home ¥Ø¿ý¤U½s¿è¤@­Ó .bash_profile ÀÉ. ¤º®e¦p¤U:  

  • ORACLE_HOME=/u01/app/oracle/product/8.1.5; export ORACLE_HOME
  • LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/lib; export LD_LIBRARY_PATH
  • ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  • ORACLE_SID=ora1; export ORACLE_SID
  • ORACLE_TERM=vt100; export ORACLE_TERM
  • ORA_NLS33=/u01/app/oracle/product/8.1.5/ocommon/nls/admin/data; export ORA_NLS33
  • PATH=$PATH:/u01/app/oracle/product/8.1.5/bin; export PATH
  • umask 022 (¥u¦³·í umask ­È¤£¬O 022 ®É¤~¥[¤J¦¹¦æ)

3) ¥t¥~ÁÙ¦³¤@¦æÅܼƻݭn¥[¤J .bash_profile ¤¤. ¨º´N¬O NLS_LANG ÅܼÆ. ¥[¤J¦¹³]©w¤~¯à³]©w¨Ï¥Î¤å¦r»y¨t. ¨Ï¥Î¤W¤@©w­n¤p¤ß.§_«h database ¶]°_¨Ó¥²©w¤£¶¶! ¤@¨Ç°Ñ¼Æ¦p¤Uªí:

¥Ñ©ó­n¨Ï¥Î¤¤¤å, ¦]¦¹¥²»Ý¦b .bash_profile¤¤¥[¤J:

  • NLS_LANG="traditional chinese"; export NLS_LANG

¨Ï¥Î»y¨¥

NLS_LANG ­È

US English

american

Arabic

arabic

Brazilian Portugese

"brazilian portugese"

Canadian French

frc

Czech

czech

Danish

danish

Dutch

dutch

Finnish

finnish

French

french

German

german

Hungarian

hungarian

Icelandic

is

Italian

italian

Japanese

japanese

Korean

korean

Lithuanian

lt

Mexican Spanish

esm

Norweigan

norweigan

Polish

polish

Portugese

portugese

Russian

russian

Simplified Chinese

"simplified chinese"

Slovak

slovak

Swedish

swedish

Thai

th

Traditional Chinese

"traditional chinese"

Turkish

turkish


 

3) Log out, ¦A¦¸¥H oracle µn¤J. Áä¤J env ¨Ó½T»{¤è¤~³]©wªºÀô¹Ò¥Í®Ä 

4) ¦A¦¸½T»{¤@¦¸ Oracle¦b /bin, /usr/bin, /usr/local/bin ¤¤ªº¸ô®| 

5) ¤@©w­n½T»{ .bash_profile¤¤ªº³]©w¥Í®Ä,±µµÛ´N¦w¸Ëµ{¦¡


Oracle¦w¸Ë
¥Ñ©ó¬O¦b RedHat¤U¦w¸Ë,§Ú­Ì±N¥Hinstaller¨Ó±Ò©l¦w¸Ë.

1) ¥ý§â CD  mount °_¨Ó

  • su root (¿é¤J root ªºpassword)
  • mount  /mnt/cdrom
  • exit (Â÷¶} superuserÅv­­¦^¨ìoracle Åv­­).

2) ¤Á´«¨ì§t¦³ RedHat install scriptªº¸ô³w¤U.

  • cd /mnt/cdrom/install/linux

2) ±Ò°Ê installer

  • ./runInstaller

3) ±µµÛ¦³ GUI window ¥X²{.µe­±¥X²{ Welcome to the Java-based Oracle installer.

4) «ö Next Áä.

5) ½T»{ Source path ¬° [cd mount point]/stage/products.jar

6) ½T»{ Destination path »P $ORACLE_HOME Àô¹Ò³]©w¬Û¦P.

7) «ö Next.

8) ¦b Unix Group Name ®æ¤¤, Áä¤J"dba" °µ¬° group¦WºÙ, ±µµÛ«ö Next Áä.

9) ±µµÛ·|¼u²{¤@­Ó°ÝÃDµøµ¡§i¶D§A run orainstRoot.sh. ½Ð¨Ì¤U¦C¨BÆJ:

  • ¤Á°O¤£­nÃö±¼¼u²{µøµ¡,¥t¶}­Ó·sªº terminal window
  • su root (±µµÛ¿é¤Jroot ªº password)
  • cd /tmp/OraInstall
  • ./orainstRoot.sh
  • exit (Â÷¶}rootªºÅv­­)
  • exit (Ãö³¬ terminal window)


10)
¦^¨ì­è­è¼u²{ªºµøµ¡¤¤,±µµÛ«öRetryÁä.

11) ±µ¤U¨Ó¶i¤J²£«~µøµ¡. ¿ï¾Ü Oracle 8i 8.1.5.0.0 ¨Ã«ö Next Áä.

12) ¦b¤U¤@µøµ¡, ¿ï Custom, ¨Ã«ö Next Áä.

13) ¦b Available Product Components µe­±¤¤. §A¥i¥H¹w³]­È¥hinstall. ©ÎªÌ¥ý§â Oracle Intermedia¤£¿ï. ¤@¤è­±¬O§@³æ¾÷´ú¸Õ, ¤@¤è­±¤]¬O¤j³¡¥÷¨Ï¥ÎªÌ¥Î¤£¨ì,¤£¿ï´N¤£¥Î¬°¥¦ªº³]©w¶Ë¸£µ¬,¤£¹L¿ï¤£¿ï¬Ý»Ý¨D. ±µµÛ«öNextÁä.

14) ²{¦b installer ·|°Ý§A¬O§_­n create ¤@­Ó database. ¿ï No. ¦ý©_©Çªº¬O§Y¨Ï§A¿ï No, oracleµ¥¤@¤UÁÙ¬O·|¹Á¸Õ«Ø¥ßdatabase. ¦b³oùØ¿ï No ·|¨Ï§AÁ׶}¤@°ïµL¥Îªºµe­±. ±µµÛ«öNextÁä.

15)  Oracle Protocol Support µe­±¥X²{. ³]©w¤¤¥X²{ªÅ¥Õ,¤£¥Î¾á¤ß. TCP/IP ¤w¸g¤º«Ø¤F, ±µµÛ«öNextÁä.

16) ³Ì«á¦^¨ì Summary µe­±¤U, §A©Ò¿ï©wªº¥\¯à¶µ³£·|¦b¦¹¥X²{. «ö Install Áä.

17) ¦¹³B¦³ bug , installer ·|¥X²{ĵ§iµwºÐªÅ¶¡¤£¨¬. ¤£¥Î¾á¤ß, «öOKÁäÄ~Äò¦w¸Ë.

18) ¨ì³o¨BÆJ®É, ©Ò¦³°ò¥»³]©w³£¤w§¹¦¨ ,´Nµ¥µÛ±Nµ{¦¡¸Ë¶iµwºÐ¤F!

19) ·í©Ò¦³Àɮ׳£ copy¨ìµwºÐ«á, ·|¼u²{¤@­Ó°ÝÃDµøµ¡§i¶D§A run root.sh script. ½Ð¨Ì¤U¦C¨BÆJ:

  • ¤Á°O¤£­nÃö±¼¼u²{µøµ¡,¥t¶}­Ó·sªº terminal window
  • su root (±µµÛ¿é¤Jroot ªº password)
  • cd $ORACLE_HOME
  • chmod 744 root.sh (Åý script ¯à¦broot Åv­­¤U°õ¦æ)
  • ./root.sh
  • ·íµe­±¸ß°Ý§Aªº local bin ¥Ø¿ý¸ô³w®É,ª½±µ«ö Enter
  • exit (Â÷¶}rootªºÅv­­)
  • exit (Ãö³¬ terminal window)

20) ¦^¨ì­è­è¼u²{ªºµøµ¡¤¤,±µµÛ«öOKÁä.

21) Oracle Database Configuration Assistant ·|±µµÛ°õ¦æ.

22) ¦¹®É·|¥X²{ error message ¶}©l¥y¤l¬° "JNLS Exception." ,³o¬OJAVAªº°ÝÃD,¤£­n²z·|,µ{¦¡¨ÌµM¥i¥H§¹¦¨(ÁöµMµe­±¦r«¬·|©Ç©Çªº). «öOKÁä.

23) ·í Database Configuration Assistant ¥X²{®É, «ö Cancel Áä.(µy«á¦A¸Ë³])

24) ½T»{±N exit ¥Xµøµ¡.

25) §A±N±o¨ì°T®§Åã¥Ü·|¦³¨Ç¥\¯à¥¢±Ñ. ¤£­n²z·|. «öOKÁä.

26) «ö Next Áä.

27) ¦b End of Installation µe­±¤¤. «öExitÁä.

28) ½T»{±N exit ¥Xµøµ¡.

29) ±µµÛ§Ú­Ì±N§ó°Ê¤@¨ÇÀɮתº permission¨ÓÅý patch¥i¥H°õ¦æ. (¦¹®É¤Á°Oterminal window¤£­nÃö±¼)


§ó§ï permissions ©M¸Ë¤W Oracle 8i ªºpatchÀÉ
§ó§ï permission
¬°¤F½T¹ê§ó§ïÅv­­¨ÃÅýpatchÀÉ°õ¦æ. ¤Á°O¦b¦P¤@­Ó terminal window ¤¤¤u§@.

1) ¤Á´«¸ô³w°õ¦æ«ü¥O:

  • cd $ORACLE_HOME/install/utl
  • ./linux.sh

2) ±µµÛ¦w¸ËpatchÀÉ..

patch ÀÉ
¨ì¥Ø«e©Ò¸Ëªº Oracle 8i ª©¥»¬°8.1.5.0.0. patch ÀÉ·|§â8i´£ª@¨ì8.1.5.0.2. ©Ò¥HOracle ¤½¥q«Øij¸Ë¸m patch ÀÉ.

1) ¤èªk¦p¤U:

  • cd ~
  • tar xzvf  linux_815patches.tgz
  • cd linux_815patches
  • ./linux_815patches.sh

2) µe­±¤W·|¥X²{patchÀɦb¹B§@ªº°T®§. ³Ì«á·|¥X²{­n link Intelligent Agent executablesªº°T®§,¤£²z·|¥¦¹ï³æ¾÷¹B§@¤£·|¼vÅT. (¦¹¨BÆJ¬Ý§AªºRed Hat6.2¬O§_¸Ë¤FTCL rpm package,­Y¤w¸Ë³]«h¤£·|¥X²{°T®§)

3) ±µ¤U¨Ó´N¬O­n¹ê»Ú«Ø¥ß database¤F.


«Ø¥ß Database
±µ¤U¨Óªº¨BÆJ­n«Ø¥ß­ì©l database. ·|­nÂI®É¶¡.

1) ¦b teminal window¤¤, Áä¤J¦p¤U«ü¥O:

  • dbassist &

2) µe­±·|¦A¥X²{ JNLS Exception errorªº°T®§. ¤´¬OJAVAªº°ÝÃD, «öOKÁä.

3) ¿ï Create a Database ¨Ã «öNextÁä.

4) ¿ï Custom¨Ã «öNextÁä.

5) ±µ¤U¨Ó¥|­Óµe­±³£¥Î default­È°õ¦æ. «öNextÁä¹L¥h, ¦bµe­±­n¨D§A¿é¤J Global Database Name ®É°±¤U¨Ó.

6) ¦b¦¹µe­±, ¿é¤J¤@­Ó¦WºÙµ¹ database. ¦WºÙ ¥²»Ý¬°8­Ó¦r¥À¥H¤U. ¨Ã½T»{ SID ­È»P¤§«e³]Àô¹Ò°Ñ¼Æ¬Û¦P.

7) ©óChange Character Set ©M National Character Set  ªº¿ï¶µ¤¤,¿ï¨ú¤å¦r¨Ï¥Î¡¨ZHT16BIG5¡¨, «öNextÁä.

8) ±µµÛªºµe­±³£«öNextÁä±µ¨ü. ª½¨ìµe­±¸ß°Ý Create database now.

9) ½T»{¤w¿ï¨ú Create database now, «ö Finish Áä.

10) µe­±¦A½T»{¬O§_°õ¦æ, «öYesÁä.

11) ¦bµ¥«Ý®É¥ð®§¤@¤U¼¢³Ò¦Û¤v. ³o¶¥¬q·|­nÂI®É¶¡. ¦ý¦]µy«e¥¼¿ï¸ËOracle Intermedia ¬ÛÃö®M¥ó·|¥X²{¿ù»~°T®§,³£¿ïIgnoreÁä¸õ¹L§Y¥i.

12) ·íµe­±¥X²{database «Ø¥ß§¹¦¨®É, «öOKÁä¨Ã¶}©l°µ¦w¸Ë«á½Õ¾ã. (¦¹®É¤Á°Oterminal window¤£­nÃö±¼)



Oracle ¦w¸Ë«áªº½Õ¾ã
¤@¤Áªº§V¤O³£¬°¤F¦¹¤@¨è.

ORACLEªº¤º«Ø±K½X
Oracle
¤º«Ø¦³¨â­Ó±b¸¹¨Ó±±ºÞdatabase. ¦WºÙ©M±K½X¦p¤U:
sys - change_on_install
system - manager

1) ¨Ï¥Î»P¤§«e¦P¤@­Ó terminal window ¥H«O«ù¸Ë¸mªº¤@­P©Ê

2) ­Y§A¬O±q§OªºPCºÝ¨Ï¥Î GUI ¤¶­±¨ÓºÞ²zOracle server, §A´N¥²»Ý¨Ï¥Î¨ì TNS listener. ORACLE8i ¤º«Ø·íµ{¦¡°_¨Ó®É TCP/IP ´N°õ¦æ, ¥i¦Û¤v½Õ¾ã. Åý¥¦§ó¶¶ºZ

  • lsnrctl start

3) ±Ò°Ê Oracle Server:

  • svrmgrl
  • connect internal
  • startup
  • quit

4) ©ÎªÌ§A·Q¸Õ¥Î¤º«Øªº sample tables ( user/password¬° scott/tiger),§A¥i¦p¦¹°µ:

  • cd $ORACLE_HOME/rdbms/admin
  • sqlplus (¥ý¥Î system/managerµn¤J)
  • @utlsampl.sql

5) ²{¦b§Ú­ÌÀH«K°µ­Ó¬d¸ß, ´N¥Î SQLPLUS ÁÙ¦³¤§«e¸Ëªº example tables. username ¥s scott ¦Ópassword ¬° tiger. 

  • sqlplus
  • username: scott
  • password: tiger
  • select * from emp;

 6) ¦pªG¤@¤Á¥¿±`, §A·|±q emp ªºtable¤¤¬Ý¨ì¸ê®Æ. ¨º´Nªí¥ÜORACLE ¶}©l¤u§@¤F.