client 설치 할 때 error 발생할 경우
tail -f /app/oracle/19c/oraInventory/logs/installActions2024-12-23_09-14-52AM.log
사용해서 error 하나하나 추적해야 함.
---- 64 bits client error 시 ----
curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
yum install -y oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
groupadd dba
useradd -m oracle -g dba
mkdir -p /app/oracle/19c/client_home
chown -R oracle:dba /app
-- 설치할때 --
cd $ORACLE_HOME
export CV_ASSUME_DISTID=OL8
export DISPLAY=192.168.30.100:0.0
./runInstaller
https://widm2240.tistory.com/71
rm -rf $ORACLE_HOME/lib/stubs/*
cp $ORACLE_HOME/rdbms/lib/env_rdbms.mk $ORACLE_HOME/rdbms/lib/env_rdbms.mk.orig
vi $ORACLE_HOME/rdbms/lib/ins_rdbms.mk
----
LINKTTLIBS=$(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS)
--> LINKTTLIBS=$(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) -lons
LINK=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS) $(COMPSOBJS)
LINK32=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS32) $(COMPSOBJS)
--> LINK=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS) $(COMPSOBJS) -Wl,--no-as-needed
LINK32=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS32) $(COMPSOBJS) -Wl,--no-as-needed
TG4PWD_LINKLINE= $(LINK) $(OPT) $(TG4PWDMAI) \
$(LLIBTHREAD) $(LLIBCLNTSH) $(LLIBNZ) $(LINKLDLIBS)
--> TG4PWD_LINKLINE= $(LINK) $(OPT) $(TG4PWDMAI) \
$(LLIBTHREAD) $(LLIBCLNTSH) $(LLIBNZ) $(LINKLDLIBS) -lnnz12
----
vi $ORACLE_HOME/rdbms/lib/ins_rdbms.mk
----
$(ORAPWD_LINKLINE)
--> $(ORAPWD_LINKLINE) -lnnz11
----
INFO:
/usr/bin/ld: cannot find -lnsl
https://knowledge.broadcom.com/external/article/278405/gen-86-build-on-rhel-89-usrbinld-cannot.html
# cd /usr/lib64
# ls -al libnsl*
# cd /usr/lib64
# ln -s libnsl.so.1 libnsl.so
# ls -al libnsl*
-rwxr-xr-x 1 root root 99152 Jan 23 05:08 libnsl-2.28.so
lrwxrwxrwx 1 root root 11 Jan 24 22:39 libnsl.so -> libnsl.so.1
lrwxrwxrwx 1 root root 14 Sep 20 10:54 libnsl.so.1 -> libnsl-2.28.so
lrwxrwxrwx. 1 root root 15 Aug 12 2018 libnsl.so.2 -> libnsl.so.2.0.0
-rwxr-xr-x. 1 root root 116408 Aug 12 2018 libnsl.so.2.0.0
여기까지 하면 에러코드 변함.
INFO:
/usr/bin/ld: cannot find -lgcc_s
yum install -y *gcc*
yum groupinstall -y "Development Tools"
export LD_LIBRARY_PATH=/usr/lib64:$LD_LIBRARY_PATH
여기까지 하면 에러코드 변함.
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a
yum install -y *glibc*
https://www.rpmfind.net/linux/rpm2html/search.php?query=compat-libpthread-nonshared&submit=Search+...&system=&arch=
opensuse rpm file download
ln -s /usr/lib64/libpthread_nonshared.a /usr/lib64/x86_64-linux-gnu/libpthread_nonshared.a
yum localinstall compat-libpthread-nonshared-0-150300.3.6.1.x86_64.rpm
sqlplus system/oracle@ 192.168.30.101 :1521/oracle
----Oracle client 32 bits ----
-- error 발생 --
gui 도 안뜸
-- 해결 --
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=65688149312125&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2887424.1&_afrWindowMode=0&_adf.ctrl-state=cdyvigl4h_4
yum install binutils.x86_64 \
gcc.x86_64 \
gcc-c++.x86_64 \
glibc.i686 \
glibc.x86_64 \
glibc-devel.i686 \
glibc-devel.x86_64 \
csh \
ksh \
libaio.i686 \
libaio.x86_64 \
libaio-devel.i686 \
libaio-devel.x86_64 \
libgcc.i686 \
libgcc.x86_64 \
libstdc++.i686 \
libstdc++.x86_64 \
libstdc++-devel.i686 \
libstdc++-devel.x86_64 \
libXi.i686 \
libXi.x86_64 \
libXtst.i686 \
libXtst.x86_64 \
libXrender.i686 \
make.x86_64 \
sysstat.x86_64 \
libnsl.i686 -y
export CV_ASSUME_DISTID=OL7
export DISPLAY=192.168.30.1:0.0
export ORACLE_HOME=/app/oracle/19c/client_home
./runInstaller
--ERROR 발생 --
INFO:
/bin/ld: cannot find /usr/lib/libpthread_nonshared.a
-- 해결 --
http://pchero21.com/?p=2748
yum localinstall compat-libpthread-nonshared-0-150300.3.6.1.x86_64.rpm
[root@localhost 19c]# find / -name libpthread_nonshared.a
find: ‘/run/user/1000/gvfs’: Permission denied
/usr/lib64/libpthread_nonshared.a
[root@localhost 19c]# ln -s /usr/lib64/libpthread_nonshared.a /usr/lib/libpthread_nonshared.a
--ERROR 발생 --
INFO:
/bin/chmod: cannot access '/app/oracle/19c/client_home/precomp/lib/proc': No such file or directory
yum install -y binutils*
-- 이후 error 발생시 전부 continue --
all continue
오라클/error note