[CentOS] CentOS Oracle ¼³Ä¡
1. root·Î ·Î±×ÀÎÇÏ¿© °èÁ¤ »ý¼º
# groupadd oinstall # groupadd dba # useradd -g oinstall -G dba oracle # passwd oracle # mkdir -p /u01/app/oracle/product/10.2.0/db_1 |
2. ½Ã½ºÅÛ ÆĶó¸ÞÅÍ Ãß°¡.
# vi /etc/sysctl.conf
kernel.shmmni = 4096
# /sbin/sysctl -p |
# vi /etc/pam.d/login
|
# vi /etc/security/limits.conf
|
# vi /etc/profile
|
3. ½Ã½ºÅÛ ÀçºÎÆà ÈÄ ·çÆ®°èÁ¤ ·Î±×ÀÎ
# shutdown -r now
# vi /etc/redhat-release |
4. oracle »ç¿ëÀÚ·Î ·Î±×¿ÂÇÏ¿©, Oracle ȯ°æ º¯¼ö¸¦ ¼³Á¤
# su - oracle
Ãß°¡ÈÄ ÀúÀåÇÏ°í ¾Æ·¡ ½ÇÇà $ source .bash_profile |
5. Çʼö ÆÐÅ°Áö ¼³Ä¡
# yum install binutils # yum install compat-libgcc-296 # yum install compat-libstdc++-296 # yum install compat-libstdc++-33 # yum install cpp # yum install gcc # yum install gcc-c++ # yum install glibc # yum install glibc-common # yum install glibc-devel # yum install glibc-headers # yum install ksh # yum install libaio # yum install libaio-devel # yum install libgcc # yum install libstdc++ # yum install libstdc++-devel # yum install make # yum install setarch # yum install libXp # yum install openmotif # yum install unixODBC* |
6. ¿À¶óŬ ¾ÐÃà Ç®±â
´Ù¿î °æ·Î À̵¿ÈÄ # unzip 10201_database_linux32.zip # mkdir /oracle10g # chmod 755 database ¼³Ä¡ ÆÄÀÏ ¿øÇϴ°÷¿¡ À̵¿ÈÄ ¼³Ä¡ |
7. ¼³Ä¡ ½ÃÀÛ
# xhost + ¾ÐÃà Ǭ°÷ À̵¿ $ cd database |
¼³Ä¡ ½ÃÀÛÇϱâ
http://huikyun.tistory.com/204
¼ºñ½º ½Ãµ¿/ÁßÁö
$ sqlplus /nolog SQL> connect /as sysdba SQL> startup SQL> SELECT LTRIM('000123','0') FROM DUAL; SQL> 123
|
¼ºñ½º ÀÚµ¿ ½ÃÀÛ
# vi /etc/rc.d/rc.local
¾Æ·¡ ³»¿ë Ãß°¡
# vi /etc/oratab
¾Æ·¡¿¡¼ ³¡¿¡ NÀ» Y·Î ¼öÁ¤ÇÑ´Ù. |
¿À¶óŬ Á¦°Å
¿À¶óŬ Ȩµð·ºÅ͸® ÈÀÏ ÀüºÎ »èÁ¦ # rm -rf /etc/oraInst.loc # rm -rf /etc/oratab # rm -rf /usr/local/bin/oraenv # cd /tmp °ü·Ã ÆÄÀÏ »èÁ¦ °èÁ¤°ü·ÃÆÄÀÏ »èÁ¦ |
¼³Ä¡ÈÄ »ç¿ëÀÚ °ü¸®
»ç¿ëÀÚ È®ÀÎ |
À©µµ¿ì¿¡¼ Á¢¼ÓÇϱâÀ§ÇÑ ¸®½º³Ê ¼³Á¤
¿ì¼± ¹æȺ®¿¡ 1521 Æ÷Æ® ¿·ÁÀÖ´ÂÁö È®ÀÎ # vi /etc/sysconfig/iptables
¾Æ·¡ ³»¿ë ¾øÀ»°æ¿ì Ãß°¡ ÀúÀåÈÄ ¾Æ·¡ ¸í·É ½ÇÇà # service iptables restart
$ vi /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
SID_LIST_LISTENER = LISTENER =
¼³Á¤ÀÌ ¸ðµÎ ³¡³µÀ¸¸é Çѹø ¸®½ºÅ¸Æ® ÇØÁÖÀÚ # shutdown -r now |
Á¢¼ÓÈÄ ½ÇÇàÇϸé Àßµ¹¾Æ°£´Ù ^^
ÇѱÛÀԷ½à Çѱ۱úÁü ó¸®
$ sqlplus /nolog SQL> conn /as sysdba SQL> select * from v$nls_parameters;
SQL> update sys.props$ set value$='KO16KSC5601' where name='NLS_CHARACTERSET'; SQL> update sys.props$ set value$='KO16KSC5601' where name='NLS_NCHAR_CHARACTERSET';
<¾ð¾î¼Â ¼³Á¤> SQL> update sys.props$ set value$= 'AMERICAN' where name='NLS_LANGUAGE'; SQL> commit; SQL> shutdown immediate; SQL> startup; |