[CentOS 6.4] Oracle10g 설치 Oracle



CentOS 6.4 x64

- swap : 12GB 이상으로 설정



# groupadd dba

# groupadd oinstall

# useradd -g oinstall -G dba -d /home/oracle oracle

# passwd oracle


# su - oracle

# chown -R oracle.dba /home/oracle

# chmod -R 755 /home/oracle



# gunzip 10201_database_linux_x86_64.cpio.gz

# cpio -idmv < 10201_database_linux_x86_64.cpio



# vi /etc/redhat-release 

#CentOS release 6.4 (Final)

redhat-4



# yum groupinstall "Development Tools"

# yum install binutils compat-libstc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat glibc-headers unixODBC unixODBC-devel pdksh


libstdc++-devel (x86_64)
libstdc++-devel (i386) 
sysstat (x86_64)
glibc-devel (x86_64)
glibc-devel (i386) 

libaio-devel (x86_64)
libaio-devel (i386) 
gcc (x86_64)
gcc-c++ (x86_64)
elfutils-libelf-devel-static (x86_64)
elfutils-libelf-devel-static (i386)
unixODBC-devel (x86_64)
unixODBC-devel (i386)
compat-db (x86_64)
compat-gcc-34 (x86_64)
compat-gcc-34 (i386) 
compat-libstdc++-34 (x86_64)
compat-libstdc++-34 (i386)
libXp (i386)

# yum update

# vi /etc/sysctl.conf
# for oracle


kernel.shmmax = 68719476736

kernel.shmall = 4294967296
net.core.rmem_default = 4194304

net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144


kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

net.ipv4.ip_local_port_range = 1024 65000

fs.aio-max-nr = 1048576
fs.file-max = 6815744

# /sbin/sysctl -p



# vi /etc/security/limits.conf

oracle          soft    nproc           2047

oracle          hard    nproc           16384

oracle          soft    nofile          1024

oracle          hard    nofile          65536



# vi /etc/pam.d/login
session    required     pam_limits.so

# vi /etc/selinux/config 

SELINUX=disabled



# su - oracle
# vi .bash_profile

export PATH=$PATH:$HOME/bin


export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/10g

export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl

export ORACLE_SID=orcl

export PATH=$PATH:$ORACLE_HOME/bin

export NLS_LANG=American_america.KO16KSC5601


export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

export LD_LIBRARY=$LD_LIBRARY:.:$ORACLE_HOME/lib


export LANG=C


if [ $USER = "oracle" ]; then

        if [ $SHELL = "/bin/ksh" ]; then

                ulimit -p 16384

                ulimit -n 65536

        else

                ulimit -u 16384 -n 65536

        fi

fi


# source .bash_profile




[oracle@wizcns oracle10g]$ ./runInstaller
./runInstaller: /home/oracle/oracle10g/install/.oui: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

# yum install ld-linux.so.2 libXp libXp.so.6 libXext libXt.so.6 libXtst.so.6


[oracle@wizcns oracle10g]$ ./runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                      Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-06-24_03-51-53PM. Please wait ...
DISPLAY not set. Please set the DISPLAY and try again.
Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
- For csh:                      % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash:         $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
        echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
        echo $DISPLAY
- Make sure that client users are authorized to connect to the X Server.
To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as 'xclock':
        % <full path to xclock.. see below>
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for xclock: /usr/X11R6/bin/xclock


# yum install xhost
# xhost +

access control disabled, clients can connect from any host


# su - oracle

# ./runInstaller

Starting Oracle Universal Installer...


Checking installer requirements...


Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2

                                      Passed



All installer requirements met.


Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-06-26_09-30-43AM. Please wait ...[oracle@test database]$ 


 



위와 같이 발생하면 아래처럼 hostname 추가

# vi /etc/hosts

192.168.0.xx test






다음과 같이 error 발생하면 무시하고 그냥 넘어감.(CentOS 6.4와 호환이 잘 안되는듯..ㅠㅠ)




앗!!! ORA-27125 : unable to create shared memory segment

막혀부렸다...ㅠㅠ




해결책을 찾는 중...








덧글

  • dbai 2014/07/04 18:21 # 삭제 답글

    shared memory 해결 방법은 dbac를 통해서 db create를 할때 SGA 설정하는 부분에서 %방식이 아닌 아래 manual 방식에서 auto로 셋팅해서 진행하면 해결 됩니다.
  • 멋진쟈니 2014/09/09 20:10 #

    답변 감사합니다...^^)b
댓글 입력 영역



통계 위젯 (블랙)

08
90
353737

이 이글루를 링크한 사람 (화이트)

2

google

구글_이글루스_사이드