ORACLE
HOME > DB > ORACLE
2019.02.11 / 13:16

¿ìºÐÅõ¿¡¼­ ÃÖ±Ù¿¡ ÃøÁ¤ ÇÑ ³»¿ë Oracle 11g Release 2ÀÇ »õ·Î¿î ¹öÀüÀ» ¼³Ä¡ - ½ÇÀü

hanulbit
Ãßõ ¼ö 242

https://www.jianxiangqiao.com/install-oracle11gr2-on-ubuntu-16-04/


¿ìºÐÅõ¿¡¼­ ÃÖ±Ù¿¡ ÃøÁ¤ ÇÑ ³»¿ë Oracle 11g Release 2ÀÇ »õ·Î¿î ¹öÀüÀ» ¼³Ä¡ÇϽʽÿÀ.
Âü°í : Oracle 11g R2ÀÇ ¼³Ä¡
°úÁ¤¿¡¼­ÁÖÀǸ¦ ±â¿ïÀ̽ʽÿÀ. , °ü·Ã ¹æ¾î¿ë :

root @ dbserver : ~ # ufw disable
½Ã½ºÅÛ ½ÃÀ۽à ¹æÈ­º®ÀÌ ÁßÁöµÇ°í ºñÈ°¼ºÈ­ µÊ

1. ¼ÒÇÁÆ®¿þ¾î °³¹ß ¿ä±¸

1.1 Á¶ÀÛ ½Ã½ºÅÛ

Ubuntu 16.04.2 LTS, ³»ÇÙ ¹öÀü 4.4.0-62-generic, µî :

root @ dbserver : ~ # lsb_release -a
LSB ¸ðµâÀ» »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
¹èÆ÷ÀÚ ID : Ubuntu
¼³¸í : ¿ìºÐÅõ 16.04.2 LTS
Ãâ½Ã : 16.04
ÄÚµå ¸í : xenial
root @ dbserver : ~ # uname -a
Linux dbserver 4.4.0-62-generic # 83-Ubuntu SMP Wed 1 ¿ù 18 ÀÏ 14:10:15 UTC 2017 x86_64 x86_64 x86_64 GNU / Linux

1.2 ¿î¿µ ½Ã½ºÅÛ ¼ÒÇÁÆ®¿þ¾î

à» áóËÇ 为 网æ¶ 软Ëì ê¹ :

root @ dbserver : ~ # vi /etc/apt/sources.list
deb http://mirrors.163.com/ubuntu/ xenial ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ multiverse
deb http://mirrors.163.com/ubuntu/ xenial-security ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ multiverse
deb http://mirrors.163.com/ubuntu/ xenial-update ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ ´ÙÁß ¿ìÁÖ
deb http://mirrors.163.com/ubuntu/ xenial Á¦¾ÈÇÑ ÁÖ¿ä Á¦ÇÑ ¿ìÁÖ ¿ìÁÖ
deb http://mirrors.163.com/ubuntu/ xenial-backports ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ ´ÙÁß ¿ìÁÖ
deb-src http://mirrors.163.com/ubuntu/ xenial ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ multiverse
deb-src http://mirrors.163.com/ubuntu/ xenial-security ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ multiverse
deb-src http://mirrors.163.com/ubuntu/ xenial-update ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ ´ÙÁß ¿ìÁÖ
deb-src http://mirrors.163.com/ubuntu/ xenial Á¦¾È µÈ ÁÖ¿ä Á¦ÇÑ ¿ìÁÖ ¿ìÁÖ
deb-src http://mirrors.163.com/ubuntu/ xenial-backports ÁÖ¿ä Á¦ÇÑµÈ ¿ìÁÖ ´ÙÁß ¿ìÁÖ
root @ dbserver : ~ # apt-get update

¼³Ä¡ ÆÐÅ°Áö :

root @ dbserver : ~ apt-get install binutils libcap-dev libstdc ++ 5 gcc g ++ libc6 libc6-dev ksh libaio1 libaio-dev lib32gcc1 libgcc1 libstdc ++ 6 libstdc ++ 6-4.7-dev libxi6 libxtst6 make sysstat apt- ÆÄÀÏ

2. ¿î¿µ üÁ¦ ¿ë »ç¿ëÀÚ È­ ±×·ì

»ç¿ëÀÚ Á¤ÀÇ ¿À¶óŬ, ¿À¶óŬ, ¿À¶óŬ »ç¿ëÀÚ :

root @ dbserver : ~ # groupadd oinstall
root @ dbserver : ~ # groupadd dba
root @ dbserver : ~ # groupadd oper
root @ dbserver : ~ # useradd -g oinstall -G dba, oper oracle
root @ dbserver : ~ # passwd oracle
»õ UNIX ¾ÏÈ£ ÀÔ·Â :
»õ UNIX ¾ÏÈ£ ´Ù½Ã ÀÔ·Â :
passwd : ¾ÏÈ£°¡ ¼º°øÀûÀ¸·Î ¾÷µ¥ÀÌÆ®µÇ¾ú½À´Ï´Ù.
// Ubuntu ¾Æ·¡ ¿ä±¸ »çÇ× ¼ö¼ø ÀÛ¼ºÀÏ :
root @ dbserver : ~ # mkdir / home / oracle
root @ dbserver : ~ # chown oracle : oinstall ~ oracle

¿À¶óŬÀ» »ç¿ëÇÏ¿© umask¸¦ ¾÷µ¥ÀÌÆ®ÇϽʽÿÀ.

root @ dbserver : ~ # su - oracle
# su - oracle
$ umask
0022
// 确ÜÁ umask = 022, Üúìã áóËÇ .bash_profile Ãß°¡ åý ú¼ :
$ vi ~ / .profile
umask 0022

3. ¼öÁ¤ µÈ ³»ºÎ ÇÙ ¸Å°³ º¯¼ö¿Í Á¦ÇÑ

3.1 Á¶Á¤ °èÅë ³»ÇÙ ÆĶó¹ÌÅÍ

ÁßÀçÀÚ ¶Ç´Â ÁßÀçÀÚ°¡ OracleÀ» »ç¿ëÇÏ°íÀÖ´Â °æ¿ì,

# vi /etc/sysctl.conf
kernel.panic_on_oops = 1
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 32768 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
// ñìãæ Ê¥载 ÛÕöÇ ÙþËì :
# / sbin / sysctl -p

3.2 ¿À¶óŬÀÇ »ç¿ëÀÚ Á¤º¸ °ü¸® Á¦ÇÑ ¼öÁ¤

Ubuntu 16.04.2 LTS ¾Æ·¡ÂÊ ³»¿ë Ãß°¡ :

root @ dbserver : ~ # vi /etc/security/limits.conf
¿À¶óŬ Çϵå nproc 16384
¿À¶óŬ ¼ÒÇÁÆ® ½ºÅà 10240
¿À¶óŬ ÇÏµå ½ºÅà 32768
¿À¶óŬ ¼ÒÇÁÆ® memlock 3145728
¿À¶óŬ Çϵå memlock 3145728

4. ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ¼³Ä¡

¿øº» ORACLE_BASE º´ÇÕ :

root @ dbserver : ~ # mkdir -p / u01 / app /
root @ dbserver : ~ # chown -R oracle : oinstall / u01
root @ dbserver : ~ # chmod -R 775 / u01

5. ¿À¶óŬ äÌ装 øÐ Æç ö¢ ªê

¿À¶óŬ ¼³Ä¡, ¿À¶óŬ ¹öÀü 11.2.0.4 :

$ cd
$ mkdir -p orainst / 11.2.0.4
$ cd orainst / 11.2.0.4
// ´Ù¿î·Îµå ¶Ç´Â À§ÂÊ 11.2.0.4
$ ls -l
ÃÑ 2487208
-rw-r - r-- 1 oracle oinstall 1395582860 5 ¿ù 2 ÀÏ 12½Ã 26 ºÐ p13390677_112040_Linux-x86-64_1of7.zip
-rw-r -r-- 1 oracle oinstall 1151304589 May 2 12:28 p13390677_112040_Linux-x86-64_2of7.zip
$ unzip p13390677_112040_Linux-x86-64_1of7.zip
$ unzip p13390677_112040_Linux-x86-64_2of7.zip

6. ¼³Ä¡ ¼ÒÇÁÆ®¿þ¾î

¿À¶óŬ ¼öõ °³ÀÇ ¼ÒÇÁÆ®¿þ¾î, ¿À¸®Áö³Î Àç ±¸Ãà :

$ cd /home/oracle/orainst/11.2.0.4/database/
$ ./runInstaller
Oracle Universal Installer ½ÃÀÛ Áß ...

Àӽà °ø°£ È®ÀÎ : 120MB ÀÌ»óÀ̾î¾ßÇÕ´Ï´Ù. ½ÇÁ¦ 8063 MB ÇÕ°Ý
½º¿Ò °ø°£ È®ÀÎ : 150MBº¸´Ù Ä¿¾ßÇÕ´Ï´Ù. ½ÇÁ¦ 4095 MB Åë°ú
È®ÀÎ ¸ð´ÏÅÍ : ÃÖ¼Ò 256 »öÀ» Ç¥½ÃÇϵµ·Ï ±¸¼ºÇؾßÇÕ´Ï´Ù.
>>> / usr / bin / xdpyinfo¸¦ ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù. ½ÇÆÐÇß½À´Ï´Ù. <<<< ÀϺΠ¿ä±¸ »çÇ× °Ë»ç¿¡ ½ÇÆÐÇß½À´Ï´Ù. ¼³Ä¡¸¦ °è¼ÓÇϱâ Àü¿¡ÀÌ ¿ä±¸ »çÇ×À» ÃæÁ·ÇؾßÇÕ´Ï´Ù (°è¼Ó)? (y / n) [n] y >>> Çʼö ÀüÁ¦ Á¶°Ç ½ÇÆи¦ ¹«½ÃÇÕ´Ï´Ù. °è¼Ó ...
/ tmp / OraInstall2017-05-02_12-37-15PM¿¡¼­ Oracle Universal Installer¸¦ ½ÃÀÛÇϱâÀ§ÇÑ Áغñ. ±â´Ù·ÁÁֽʽÿÀ ... $

º¸¾È ¾÷µ¥ÀÌÆ® ±¸¼º : °¡Á® ¿À±â ¾ÈÀü ¾÷µ¥ÀÌÆ®¸¦ ¼±ÅÃÇϽʽÿÀ. "´ÙÀ½"º¸¾È ¾÷µ¥ÀÌÆ®¸¦ ¼³Ä¡ÇϽʽÿÀ. ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö
: ¾÷µ¥ÀÌÆ®
ÆÐÅ°Áö¸¦ ¼³Ä¡ÇϽʽÿÀ : ÆÐÅ°Áö ¼³Ä¡ ÆÐÅ°Áö : ÆÐÅ°Áö
¿¹Á¦¸¦ ¼³Ä¡ÇϽʽÿÀ.
Á¦Ç° ±¸¼º : ¿µ¾îûú简体ñéÙþ.
数Ëß库÷úÜâ:Ðê业÷úÜâ.
ò¦ïÒäÌ装êÈöÇ:Ùù认¿À¶óŬ ÀÚ·á : / U01 / ÀÀ¿ë ÇÁ·Î±×·¥ / ¿À¶óŬ, ¿À¶óŬ Ȩ :. /u01/app/oracle/product/11.2.0/dbhome_1
创Ëï清单ÙÍ录:Ùù认清单"$ ORACLE_BASE /../ oraInventory"Áï½Ã / u01 / app / oraInventory, "oinstall"
ÁöÁ¤ °ü¸®ÀÚ : OSDBA : dba, OSOPER :
¿î¿µÃ¼Á¦. ¿À½î ÀÎ ¾Õ °Ë»ö : ¿À¶óŬÀº ¹«·á ¿ìºÐÅõ, rpm ÆÐÅ°Áö¸¦ »ç¿ëÇÏ¿© rpm ÆÐÅ°Áö¸¦ ãÀ» ¼ö ¾øÀ¸¸é rpm ÆÐÅ°Áö¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù rpm ÆÐÅ°Áö¸¦ ãÀ» ¼ö ¾øÀ¸¸é rpm ÆÐÅ°Áö¸¦ ´Ù¿î·ÎµåÇϽʽÿÀÖõ, Á÷Á¢ ûìßÈ 即ʦ. ³»ÇÙ ÁøÀ§, ±¸¼º °ª = ¾Ë ¼ö ¾øÀ½, ÇöÀç °ª Üô á³ ûìÕÔ, °ªÀ» ¿¹»ó.
Oracle11gR2- Çʼö Á¶°Ç °Ë»ç

开ã· äÌ装, ìíò¤ êÈöÇ :

ÀÌ ¼³Ä¡ ¼¼¼ÇÀÇ ·Î±×´Â ´ÙÀ½¿¡¼­ ãÀ» ¼ö ÀÖ½À´Ï´Ù.
/u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log
// 查Ê× ìíò¤
$ tail -f /u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log

éçÓðîÜ错误ûúú°决办Ûö:
/ ºó / LD : 1错误ãÀ» ¼ö /usr/lib64/libpthread_nonshared.a
错误ìíò¤:

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/bin/genclntsh

Á¤º¸ : / usr
Á¤º¸ : / bin / ld : /usr/lib64/libpthread_nonshared.a¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.

Á¤º¸ : collect2 : ¿À·ù : ld ¹Ýȯ µÈ 1 Á¾·á »óÅÂ

Á¤º¸ : genclntsh : libclntsh.so.11.1 ¿¬°áÇÏÁö ¸øÇß½À´Ï´Ù.

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk:36 : 'client_sharedlib'´ë»óÀÇ Á¦Á¶¹ý¿¡ ½ÇÆÐÇß½À´Ï´Ù.

Á¤º¸ : È®ÀÎ : *** [client_sharedlib] ¿À·ù 1

INFO : »ý¼º µÈ ÇÁ·Î¼¼½ºÀÇ Ãâ·ÂÀ» Á¾·áÇÕ´Ï´Ù.
Á¤º¸ : ----------------------------------
Á¤º¸ : ÀÛ¾÷¿¡¼­ throw µÈ ¿¹¿Ü : ¸¸µé±â
¿¹¿Ü À̸§ : MakefileException
¿¹¿Ü ¹®ÀÚ¿­ : makefile '/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk'ÀÇ 'client_sharedlib'´ë»óÀ» È£ÃâÇÏ´Â Áß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº '/u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log'¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿¹¿Ü ½É°¢µµ : 1

¼Ö·ç¼Ç :

root @ dbserver : ~ # ã±â / usr - À̸§ libpthread_nonshared.a
/usr/lib/x86_64-linux-gnu/libpthread_nonshared.a
root @ dbserver : ~ # ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/libpthread_nonshared.a

libpthread_nonshared.a ÆÄÀÏ, libc6-dev : libc6-dev :

root @ dbserver : ~ # apt-file search libpthread_nonshared.a
libc6-dev : /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a
...

öÀúÇÑ ºÐ¼® ¹æ¹ý Áß Çϳª :

  • Á¤º¸ : / usr / bin / ld : ãÀ» ¼ö ¾ø½À´Ï´Ù /usr/lib64/libc_nonshared.a
  • 将 /usr/lib/x86_64-linux-gnu/libc_nonshared.a / usr / lib64 :

    root @ dbserver : ~ # ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a / usr / lib64
    

2/2 ºÎ : sysman / lib / ins_emagent.mk : 176 : ´ë»ó¿¡ ´ëÇÑ ·¹¼­ÇÇ '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl'½ÇÆÐ ÇÔ
错误 ìíò¤ :

/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib//libnmectl.a(nmectlt.o) : ÇÔ¼ö`nmectlt_genSudoProps '¿¡¼­ :
nmectlt.c :(. ÅؽºÆ® + 0x76) : 'B_DestroyKeyObject'¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶
nmectlt.c :(. ÅؽºÆ® + 0x7f) : 'B_DestroyKeyObject'¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶
nmectlt.c :(. ÅؽºÆ® + 0x88) : 'B_DestroyKeyObject'¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶
nmectlt.c :(. ÅؽºÆ® + 0x91) : 'B_DestroyKeyObject'¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶

Á¤º¸ : collect2 : ¿À·ù : ld ¹Ýȯ µÈ 1 Á¾·á »óÅÂ

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:176 : ´ë»ó¿¡ ´ëÇÑ ·¹¼­ÇÇ '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ emdctl '½ÇÆÐ
make [1] : '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'µð·ºÅ丮¿¡¼­ ³ª°¡±â

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52 : ´ë»ó 'emdctl'¿¡ ´ëÇÑ Á¦Á¶¹ý ½ÇÆÐ

Á¤º¸ : È®ÀÎ [1] : *** [/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/emdctl] ¿À·ù 1

Á¤º¸ : È®ÀÎ : *** [emdctl] ¿À·ù 2

INFO : »ý¼º µÈ ÇÁ·Î¼¼½ºÀÇ Ãâ·ÂÀ» Á¾·áÇÕ´Ï´Ù.
Á¤º¸ : ----------------------------------
Á¤º¸ : ÀÛ¾÷¿¡¼­ throw µÈ ¿¹¿Ü : ¸¸µé±â
¿¹¿Ü À̸§ : MakefileException
¿¹¿Ü ¹®ÀÚ¿­ : makefile '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk'ÀÇ 'agent nmhs'´ë»óÀ» È£ÃâÇÏ´Â Áß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº '/u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log'¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿¹¿Ü ½É°¢µµ : 1

Çؼ® :
"emdctl"îÜ 编译 参 数, 编辑 "

171 # ===================
172 # emdctl
173 # =====================
174
175 $ (SYSMANBIN) emdctl :
176 $ (MK_EMAGENT_NMECTL)

modified

171 # ===================
172 # emdctl
173 # =====================
174
175 $ (SYSMANBIN) emdctl :
176 $ (MK_EMAGENT_NMECTL) -lnnz11

Óîó¹ 3 : rdbms / lib / ins_rdbms.mk : 1096 : ´ë»ó¿¡ ´ëÇÑ ·¹¼­ÇÇ '/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/kfod'½ÇÆÐ ÇÔ
错误 ìíò¤ :

Á¤º¸ : 'kgfoControl'¿¡ ´ëÇÑ ÂüÁ¶
/u01/app/oracle/product/11.2.0/dbhome_1/lib//libocrb11.so :`kgfoCreate2P '¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶
collect2 : ¿À·ù : ld°¡ 1 Á¾·á »óŸ¦ ¹ÝȯÇß½À´Ï´Ù.

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk:1096 : ´ë»ó¿¡ ´ëÇÑ ·¹¼­ÇÇ '/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ kfod '½ÇÆÐ

Á¤º¸ : È®ÀÎ : *** [/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/kfod] ¿À·ù 1

INFO : »ý¼º µÈ ÇÁ·Î¼¼½ºÀÇ Ãâ·ÂÀ» Á¾·áÇÕ´Ï´Ù.
Á¤º¸ : ----------------------------------
Á¤º¸ : ÀÛ¾÷¿¡¼­ throw µÈ ¿¹¿Ü : ¸¸µé±â
¿¹¿Ü À̸§ : MakefileException
¿¹¿Ü ¹®ÀÚ¿­ : makefile '/_01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk'ÀÇ 'all_no_orcl'´ë»óÀ» È£ÃâÇÏ´Â Áß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº '/u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log'¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿¹¿Ü ½É°¢µµ : 1

ú°决办Ûö:
áóËÇ"kfod"îÜ编译参数,查Ê×"/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk"ÙþËìîÜ1096ú¼Ý¾ÐÎ:

1095 $ (KFOD) : $ (ALWAYS) $ (KFOD_DEPS)
1096 $ (ÀÚµ¿) $ (¿¡ÄÚ)
1097 $ (ÀÚµ¿) $ (¿¡ÄÚ) "OSM °Ë»ö À¯Æ¿¸®Æ¼ (kfod) ¿¬°á"
1098 $ (RMF) $ @
1099 ´Þ·¯ (KFOD_LINKLINE)

¼öÁ¤ "KFOD_LINKLINE"º¯°æ, "KFOD_LINKLINE"Á¤ÀÇ, ""ins_rdbms.mk "ÆÄÀÏ,

root @ dbserver : ~ # ll /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/*.mk
-rw-r -r-- 1 oracle oinstall 143192 2011 ³â 8 ¿ù 24 ÀÏ /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk
-rw-r -r-- 1 oracle oinstall 40983 2011 ³â 8 ¿ù 24 ÀÏ /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
root @ dbserver : ~ # grep KFOD_LINKLINE /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk
KFOD_LINKLINE = $ (¸µÅ©) $ (S0MAIN) $ (SSKFODED) $ (SKFODPT) $ (KFODOBJ) \

"KFOD_LINKLINE"env_rdbms.mk "ÆÄÀÏ ³»¿ë, ¼öÁ¤ /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk"¹®¼­, Àå

KFOD_LINKLINE = $ (¸µÅ©) $ (S0MAIN) $ (SSKFODED) $ (SKFODPT) $ (KFODOBJ) \

modified

ÇÊ¿ä¾ø´Â $ (SSKFODED) $ (SKFODPT) $ (KFODOBJ) \ KFOD_LINKLINE = $ (LINK) $ (S0MAIN)

öÀúÇÑ ºÐ¼® ¹æ¹ý Áß Çϳª :

  • Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk:1102 : ´ë»ó¿¡ ´ëÇÑ ·¹¼­ÇÇ '/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ ¾Æ¹Ì µÎ '½ÇÆÐ
  • áóËÇ "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk"¹®¼­, Àå

    AMDU_LINKLINE = $ (LINK) $ (S0MAIN) $ (SSKFMUED) $ (SKFMUPT) \
            $ (LLIBDBTOOLS) $ (LLIBCORE) $ (LLIBGENERIC) \
            $ (LLIBCOMMON) $ (LLIBGENERIC) $ (LLIBCOMMON) $ (LLIBUNLSRTL) \
            $ (LLIBNLSRTL) $ (LLIBCORE) $ (LLIBAGE) $ (LLIBSKGXP) \
            $ (LLIBNLSRTL) $ (CSSCLNTLIBS_SERVER) $ (LLIBASMCLNT) $ (LINKTTLIBS)
    

    modified

    AMDU_LINKLINE = $ (¸µÅ©) $ (S0MAIN) -Wl - ÇÊ¿ä ¾øÀ½ $ (SSKFMUED) $ (SKFMUPT) \
            $ (LLIBDBTOOLS) $ (LLIBCORE) $ (LLIBGENERIC) \
            $ (LLIBCOMMON) $ (LLIBGENERIC) $ (LLIBCOMMON) $ (LLIBUNLSRTL) \
            $ (LLIBNLSRTL) $ (LLIBCORE) $ (LLIBAGE) $ (LLIBSKGXP) \
            $ (LLIBNLSRTL) $ (CSSCLNTLIBS_SERVER) $ (LLIBASMCLNT) $ (LINKTTLIBS)
    
  • Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk:1114 : ´ë»ó¿¡ ´ëÇÑ ·¹¼­ÇÇ '/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ À̸§ÀÌ ¹Ù²ï '½ÇÆÐ
  • áóËÇ "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk"¹®¼­, Àå

    KFNDG_LINKLINE = $ (¸µÅ©) $ (S0MAIN) $ (SSKFNDGED) $ (SKFNDGPT) $ (KFNDGOBJ) \
    $ (ÀϹݿë) $ (ÀϹݿë) $ (ÀϹݿë) \ (ÀϹݿë) \
    $ (LIBCORE) $ (CSSCLNTLIBS_SERVER) $ (ASMCLNT_LIBS) $ (LINKTTLIBS)
    

    modified

    KFNDG_LINKLINE = $ (¸µÅ©) $ (S0MAIN) -Wl - ÇÊ¿ä¾ø´Â $ (SSKFNDGED) $ (SKFNDGPT) $ (KFNDGOBJ) \
    $ (ÀϹݿë) $ (ÀϹݿë) $ (ÀϹݿë) \ (ÀϹݿë) \
    $ (LIBCORE) $ (CSSCLNTLIBS_SERVER) $ (ASMCLNT_LIBS) $ (LINKTTLIBS)
    
  • Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/srvm/lib/ins_srvm.mk:52 : 'getcrshome'´ë»óÀÇ Á¦Á¶¹ý¿¡ ½ÇÆÐÇß½À´Ï´Ù.
  • ¼öÁ¤ "/u01/app/oracle/product/11.2.0/dbhome_1/srvm/lib/env_srvm.mk"

    GETCRSHOME_LINKLINE = $ (LINK) $ (LDPATHFLAG) $ (RDBMSLIB) $ (CDEBUG) $ (OPT) \
    $ (GETCRSHOME_OBJ1) $ (OCRLIBS_DEFAULT) $ (LLIBCLNTSH) \
    $ (¸µÅ© ¸µÅ©)
    

    modified

    GETCRSHOME_LINKLINE = $ (LINK) -Wl, ÇÊ¿ä ¾øÀ½ $ (LDPATHFLAG) $ (RDBMSLIB) $ (CDEBUG) $ (OPT) \
    $ (GETCRSHOME_OBJ1) $ (OCRLIBS_DEFAULT) $ (LLIBCLNTSH) \
    $ (¸µÅ© ¸µÅ©)
    
  • Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/network/lib/ins_net_server.mk:27 : 'tnslsnr'´ë»óÀÇ Á¦Á¶¹ý¿¡ ½ÇÆÐÇß½À´Ï´Ù.
  • ¼öÁ¤ "/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/env_network.mk"

    TNSLSNR_LINKLINE = $ (LINK) $ (TNSLSNR_OFILES) $ (LINKTTLIBS) $ (LLIBONS) \
    $ (LOCALNETLIBS) $ (MATHLIB) $ (TNSLSNR_THREADLIB)
    

    modified

    TNSLSNR_LINKLINE = $ (LINK) -Wl, ÇÊ¿ä¾ø´Â $ (TNSLSNR_OFILES) $ (LINKTTLIBS) $ (LLIBONS) \
    $ (LOCALNETLIBS) $ (MATHLIB) $ (TNSLSNR_THREADLIB)
    
  • Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk:732 : ´ë»ó¿¡ ´ëÇÑ Á¦Á¶¹ý '/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ ¿À¶óŬ '½ÇÆÐ
  • áóËÇ "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk"¹®¼­, Àå

    ORACLE_LINKLINE = $ (ORACLE_LINKER) $ (PL_FLAGS) $ (ORAMAI) $ (SSORED) $ (TTCSOI) \
    $ (ORACLE_KERNEL_LIBS) $ (LINKLDLIBS)
    

    modified

    ORACLE_LINKLINE = $ (ORACLE_LINKER) $ (PL_FLAGS) -Wl - ÇÊ¿äÇÏÁö ¾ÊÀ½ $ (ORAMAI) $ (SSORED) $ (TTCSOI) \
    $ (ORACLE_KERNEL_LIBS) $ (LINKLDLIBS)
    

¿À·ù 4 : gcc : ¿À·ù : /lib64/libgcc_s.so.1 : ÇØ´ç ÆÄÀÏÀ̳ª µð·ºÅ丮°¡ ¾øÀ½, gcc : ¿À·ù : /usr/lib64/libstdc++.so.6 : ÇØ´ç ÆÄÀÏÀ̳ª µð·ºÅ丮°¡ ¾øÀ½
错误 ìíò¤ :

Á¤º¸ : - liborasdkbase ¸µÅ©Çϱâ

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/bin/genorasdksh -base

Á¤º¸ : $ Id : genorasdksh.sh / linuxamd64 / 15 2010/04/28 22:10:13 aime Exp $

Á¤º¸ : ±âº» ORASDK ¶óÀ̺귯¸® »ý¼º Áß ...

Á¤º¸ : ¸¸µé±â /u01/app/oracle/product/11.2.0/dbhome_1/lib/liborasdkbase.so.11.1

Á¤º¸ : gcc : ¿À·ù : /lib64/libgcc_s.so.1 : ÇØ´ç ÆÄÀÏÀ̳ª µð·ºÅ͸®°¡ ¾ø½À´Ï´Ù.
gcc : error : /usr/lib64/libstdc++.so.6 : ±×·± ÆÄÀÏÀ̳ª µð·ºÅ丮°¡ ¾ø½À´Ï´Ù.

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/bin/genorasdksh : liborasdkbase.so.11.1À» ¿¬°áÇÏÁö ¸øÇß½À´Ï´Ù.

Á¤º¸ : È®ÀÎ : *** [liborasdkbase] ¿À·ù 1

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk:1309 : 'liborasdkbase'´ë»óÀÇ Á¦Á¶¹ý¿¡ ½ÇÆÐÇß½À´Ï´Ù.

INFO : »ý¼º µÈ ÇÁ·Î¼¼½ºÀÇ Ãâ·ÂÀ» Á¾·áÇÕ´Ï´Ù.
Á¤º¸ : ----------------------------------
Á¤º¸ : ÀÛ¾÷¿¡¼­ throw µÈ ¿¹¿Ü : ¸¸µé±â
¿¹¿Ü À̸§ : MakefileException
¿¹¿Ü ¹®ÀÚ¿­ : makefile '/_01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk'ÀÇ 'all_no_orcl'´ë»óÀ» È£ÃâÇÏ´Â Áß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº '/u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log'¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿¹¿Ü ½É°¢µµ : 1

¼Ö·ç¼Ç :

root @ dbserver : ~ # find / -name libgcc_s.so.1
/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libgcc_s.so.1
/usr/lib32/libgcc_s.so.1
/lib/x86_64-linux-gnu/libgcc_s.so.1
root @ dbserver : ~ # find / -name libstdc ++. so.6
/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libstdc++.so.6
/usr/lib64/libstdc++.so.6
/usr/lib/x86_64-linux-gnu/libstdc++.so.6
root @ dbserver : ~ # ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1/lib64/libgcc_s.so.1
root @ dbserver : ~ # ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/libstdc++.so.6

ÁÖÀÇ : "/usr/lib32/libgcc_s.so.1", 32bit, "/lib64/libgcc_s.so.1 : ½Éº¼ Ãß°¡ ¿À·ù : À߸øµÈ Çü½ÄÀÇ ÆÄÀÏ"错误.
错误 5 : bin / genorasdksh : ¸µÅ©ÇÏÁö ¸øÇß½À´Ï´Ù. liborasdk.so.11.1
错误 ìíò¤ :

Á¤º¸ : : ÇÔ¼ö`ttctzRcv '¿¡¼­ :
ttctz.c :(. ÅؽºÆ® + 0x3e8) : 'LdiInterFromArray'¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libcommon11.a(kdzu.o) : ÇÔ¼ö`kdzu_dump_header '¿¡¼­ :
kdzu.c : (text.unlikely + 0x6171) : Á¤ÀǵÇÁö ¾ÊÀº 'lbivffs'ÂüÁ¶
kdzu.c : (text.unlikely + 0x61a9) : Á¤ÀǵÇÁö ¾ÊÀº 'lbivffs'ÂüÁ¶
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libcommon11.a(kdxd4.o) : ÇÔ¼ö`kdxd4bu '¿¡¼­ :
kdxd4.c : (text.hot + 0x2587) :`lnxren '¿¡ ´ëÇÑ Á¤ÀǵÇÁö ¾ÊÀº ÂüÁ¶
collect2 : ¿À·ù : ld°¡ 1 Á¾·á »óŸ¦ ¹ÝȯÇß½À´Ï´Ù.

Á¤º¸ : /u01/app/oracle/product/11.2.0/dbhome_1/bin/genorasdksh : liborasdk.so.11.1 ¿¬°á ½ÇÆÐ
make : *** [liborasdksh] ¿À·ù 1

INFO : »ý¼º µÈ ÇÁ·Î¼¼½ºÀÇ Ãâ·ÂÀ» Á¾·áÇÕ´Ï´Ù.
Á¤º¸ : ----------------------------------
Á¤º¸ : ÀÛ¾÷¿¡¼­ throw µÈ ¿¹¿Ü : ¸¸µé±â
¿¹¿Ü À̸§ : MakefileException
¿¹¿Ü ¹®ÀÚ¿­ : makefile '/_01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk'ÀÇ 'all_no_orcl'´ë»óÀ» È£ÃâÇÏ´Â Áß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº '/u01/app/oraInventory/logs/installActions2017-05-02_12-37-15PM.log'¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿¹¿Ü ½É°¢µµ : 1

ÇØ°á ¹æ¹ý :
"/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk"À» (¸¦) º¸·Á¸é ÆÄÀÏ : liborasdksh ¸í·É ¹Þ±â :

1313 liborasdksh : $ (LIBORASDKSH_DEPS)
1314 $ (ÀÚµ¿) $ (¿¡ÄÚ)
1315 $ (ÀÚµ¿) $ (¿¡ÄÚ) "- ¸µÅ© liborasdk"
1316 ´Þ·¯ (GENORASDKSH)

查Ê× "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk"GENORASDKSH Á¤ÀÇ ±ÔÁ¤ :

GENORASDKSH = $ (BINHOME) genorasdksh

Á÷Á¢ ¼öÁ¤ "/u01/app/oracle/product/11.2.0/dbhome_1/bin/genorasdksh"ÙþËì, 将ÏÚ

289 $ LD $ LD_RUNTIME $ LD_OPT $ LD_OUT $ LD_SELF_CONTAINED $ BASE_LIB \
290 $ LD_OBJS $ LD_SYMS $ OLIBS $ SYSLIBS $ USRLIBS

modified

289 $ LD $ LD_RUNTIME $ LD_OPT -Wl - ÇÊ¿ä ¾øÀ½ $ LD_OUT $ LD_SELF_CONTAINED $ BASE_LIB \
290 $ LD_OBJS $ LD_SYMS $ OLIBS $ SYSLIBS $ USRLIBS

¼³Ä¡ ¿Ï·á ÈÄ, ·çÆ® ½ºÅ©¸³Æ® ½ÇÇà.
orainstRoot.sh :

root @ dbserver : ~ # /u01/app/oraInventory/orainstRoot.sh
/u01/app/oraInventory/orainstRoot.sh : 1 : /u01/app/oraInventory/orainstRoot.sh : / bin / awk : ãÀ» ¼ö ¾øÀ½
/u01/app/oraInventory/orainstRoot.sh : 1 : /u01/app/oraInventory/orainstRoot.sh : / bin / awk : ãÀ» ¼ö ¾øÀ½
/u01/app/oraInventory/orainstRoot.sh : 9 : [:! = : ¿¹±âÄ¡ ¾ÊÀº ¿¬»êÀÚ
/ u01 / app / oraInventoryÀÇ ±ÇÇÑ º¯°æ.
±×·ì¿¡ ´ëÇÑ Àбâ, ¾²±â ±ÇÇÑÀ» Ãß°¡ÇÕ´Ï´Ù.
world¿¡ ´ëÇÑ Àбâ, ¾²±â, ½ÇÇà ±ÇÇÑ Á¦°Å

/ u01 / app / oraInventoryÀÇ ±×·ì À̸§À» oinstallÀ¸·Î º¯°æÇÕ´Ï´Ù.
½ºÅ©¸³Æ® ½ÇÇàÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù.

找ÜôÓð / bin / awk, ÇØ°áÃ¥ :

·çÆ® @ dbserver : ~ # ¾î¶² awk
/ usr / bin / awk
root @ dbserver : ~ # ln -s / usr / bin / awk / bin / awk

î¢ òûú¼ ìéø¼ orainstRoot.sh ÊÅÜâ :

root @ dbserver : ~ # /u01/app/oraInventory/orainstRoot.sh
/ u01 / app / oraInventoryÀÇ ±ÇÇÑ º¯°æ.
±×·ì¿¡ ´ëÇÑ Àбâ, ¾²±â ±ÇÇÑÀ» Ãß°¡ÇÕ´Ï´Ù.
world¿¡ ´ëÇÑ Àбâ, ¾²±â, ½ÇÇà ±ÇÇÑ Á¦°Å

/ u01 / app / oraInventoryÀÇ ±×·ì À̸§À» oinstallÀ¸·Î º¯°æÇÕ´Ï´Ù.
½ºÅ©¸³Æ® ½ÇÇàÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù.

root.sh ÊÅÜâ :

root @ dbserver : ~ # /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
Oracle 11g¿¡ ´ëÇÑ ·çÆ® »ç¿ëÀÚ ÀÛ¾÷ ¼öÇà

´ÙÀ½ ȯ°æ º¯¼ö´Â ´ÙÀ½°ú °°ÀÌ ¼³Á¤µË´Ï´Ù.
ORACLE_OWNER = ¿À¶óŬ
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

·ÎÄà bin µð·ºÅ丮ÀÇ Àüü °æ·Î À̸§À» ÀÔ·ÂÇϽʽÿÀ : [/ usr / local / bin] :
/ usr / local / bin¿¡ dbhome º¹»ç Áß ...
oraenv¸¦ / usr / local / bin¿¡ º¹»ç Áß ...
/ usr / local / bin¿¡ coraenv º¹»ç Áß ...

/ etc / oratab ÆÄÀÏ ¸¸µé±â ...
Ç׸ñÀº ÇÊ¿ä¿¡ µû¶ó / etc / oratab ÆÄÀÏ¿¡ Ãß°¡µË´Ï´Ù.
µ¥ÀÌÅͺ£À̽º »ý¼º½Ã µ¥ÀÌÅͺ£À̽º ±¸¼º Áö¿ø
·çÆ® ½ºÅ©¸³Æ®ÀÇ ÀÏ¹Ý ºÎºÐÀ» ½ÇÇàÇß½À´Ï´Ù.
ÀÌÁ¦ Á¦Ç° º° ·çÆ® ÀÛ¾÷ÀÌ ¼öÇàµË´Ï´Ù.
Á¦Ç° º° ·çÆ® ÀÛ¾÷À» ¿Ï·áÇß½À´Ï´Ù.

äÌ装 èÇà÷! ¿î¿µ üÁ¦ ¹öÀü :

root @ dbserver : ~ # su - oracle
$ vi ~ / .profile
ORACLE_BASE = / u01 / app / oracle
ORACLE_HOME = $ ORACLE_BASE / product / 11.2.0 / dbhome_1
ORACLE_SID = jxq11g
PATH = $ PATH : $ ORACLE_HOME / bin
ORACLE_BASE ORACLE_HOME ORACLE_SID PATH¸¦ ³» º¸³À´Ï´Ù.
$ source ~ / .profile

7. ¼³Á¤ °è

oracle
ÀÎÁõ¼­¸¦ »ç¿ëÇÏ¿© ÀÎÁõ¼­¸¦ ¼±ÅÃÇϽʽÿÀ :
¼±ÅÃ
¸ñ·Ï¿¡¼­ ÀÎÁõ¼­¸¦ ¼±ÅÃÇϽʽÿÀ
:
¼±Åñâ : TCP
: ¼³Á¤À» ¸¶Ä¨´Ï´Ù : ÀÏÄ¡ 1521. ´Ù¸¥ ±¸¼º ¿ä¼Ò : ¼±Åà »çÇ× :

Oracle Net Services ±¸¼º :
¸®½º³Ê ±¸¼º : LISTENER
¸®½º³Ê ±¸¼ºÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù.
Oracle Net Listener ½ÃÀÛ :
½ÇÇàÁßÀÎ ¸®½º³Ê Á¦¾î :
/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER
¸®½º³Ê Á¦¾î°¡ ¿Ï·áµÇ¾ú½À´Ï´Ù.
¸®½º³Ê°¡ ¼º°øÀûÀ¸·Î ½ÃÀ۵Ǿú½À´Ï´Ù.
Oracle Net Services ±¸¼ºÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. Á¾·á ÄÚµå´Â 0ÀÔ´Ï´Ù.

8. 创Ëï 数 Ëß库

ÞÅéÄ¿À¶óŬ帐号Ôô录,执ú¼DBCAÙ¤Öµ:
.创Ëï数Ëß库选择
数Ëß库Ù¼÷ù:.ìéÚõéÄÔ²ûä选择ÞÀ务处×â
数Ëß库SID :îïÏÑ数Ëß库Ù£: jxq11g.jianxiangqiao.com.SID :. jxq11g
ÛÕöÇEM.
设öÇ统ìéîÜη×â员ÚË码.
ðí储类úþûúðí储êÈöÇ:.ÙþËìͧ统,Ùù认îÜÙþËìêÈöÇ
öááÜüá复区:. {ORACLE_BASE} / fast_recovery_area, 4õ1¹é82¸Þ°¡¹ÙÀÌÆ®
.ÜôÛÕöÇ»ùÇÃûú»ç¿ëÀÚ Á¤ÀÇ ½ºÅ©¸³Æ®
ôøã·ûù参数: ¸Þ¸ð¸® :Ùù认.Processes : 150÷¼á³,调Óð(300). µ¥ÀÌÅͺ£À̽º ¹®ÀÚ ÁýÇÕ : ZHS16GBK.Default Territory : China.Connection Model : Ùù认.

°³Åë µÈ °Ç¹°, °³Àå µÈ °Ç¹° :
Oracle11gR2- ¼³Ä¡ ¿Ï·á
±× (°Í)µé, µµ¼­°ü ¼³Ä¡, ¼³Ä¡, ¼³Ä¡, ¼³Ä¡.

9. °íÀ§ ȯ°æ ​​±¸Ãà

9.1 OS °áÁ¤ Âü°íݬ

Bash ½©, ¼öÁ¤ ¿À¶óŬ ¿ë .profile, Ãß°¡ Á¤º¸ :

$ vi ~ / .profile
PS1 = '[\ h : \ u : $ {ORACLE_SID}] $'
$ source ~ / .profile
[dbserver : oracle : jxq11g] $

9.2 ÀÚ½ÅÀ» Á¤ÀÇÇÏ´Â SQL Ç¥ÇöÇ¥

set SQLPROMPT ¸í·É :
1) ¿î¿µ üÁ¦ SQLPATH ¼³Á¤, .profile, Ãß°¡ Á¤º¸ :

$ vi ~ / .profile
export SQLPATH = $ HOME / scripts
$ source ~ / .profile

2) SQLPATH¿¡¼­ login.sql ÆÄÀÏÀ» »èÁ¦ÇÏ°í ¾Æ·¡ Äڵ带 Ãß°¡ÇϽʽÿÀ :

$ mkdir $ HOME / scripts
$ vi $ HOME / scripts / login.sql
SQLPROMPT '& _USER. @ & _ CONNECT_IDENTIFIER.>'¸¦ ¼³Á¤ÇϽʽÿÀ.

3) 查Ê× 结Íý

$ sqlplus / as sysdba

SQL * Plus : 5 ¿ù 2 ÀÏ È­¿äÀÏ 11.2.0.4.0 Ãâ½Ã 18:29:34 2017

Copyright (c) 1982, 2013, Oracle. ÆÇ±Ç ¼ÒÀ¯.

¿¬°á ´ë»ó :
Oracle Database 11g Enterprise Edition ¸±¸®Áî 11.2.0.4.0 - 64 ºñÆ® »ý»ê
ÆÄƼ¼Å´×, OLAP, µ¥ÀÌÅÍ ¸¶ÀÌ´× ¹× ½ÇÁ¦ ÀÀ¿ë ÇÁ·Î±×·¥ Å×½ºÆ® ¿É¼Ç

SYS @ jxq11g>

9.3 ¼³Ä¡ ·¦Åé µµ±¸

¹é ½ºÆäÀ̽º Å°, ¹é ½½·¡½¬ Á¶ÇÕ, ¹é ½½·¡ÀÌ¼Ç Á¶ÇÕ, ¹é ½½·¡ÀÌ¼Ç Á¶ÇÕ, ¹é ½½·¡ÀÌ¼Ç Á¶ÇÕ, ¹é ½½·¡ÀÌ¼Ç Á¶ÇÕ, ¹é ½½·¡ÀÌ¼Ç Á¶ÇÕ ±â´É. ¼³Ä¡ÇϽʽÿÀ.

root @ dbserver : ~ # apt-get install rlwrap

¿¹ : .profile,

$ vi ~ / .profile
º°Äª sqlplus = 'rlwrap sqlplus'
º°Äª rman = 'rlwrap rman'

Âü°í ÀÚ·á :
http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm
----------------
¼­¸Ó çµÎù ò¢ò£http : // www .jianxiangqiao.com / install-oracle11gr2-on-ubuntu-16-04 / , ´Ù¿î·Îµå ÁöħÀ» ÂüÁ¶ÇϽʽÿÀ.