TroubleShooting

[Tuxedo] Oracle DB Tuxedo / XA 구성 - libclntsh.so.19.1 invaild 에러

최선을 다하자! 2023. 2. 7. 10:47
[oracle@jwchoi|/home/oracle]$ ss
sqlplus: error while loading shared libraries: /orahome/db/product/19c/lib/libclntsh.so.19.1: invalid EL                                F header
[oracle@jwchoi|/home/oracle]$ vi /orahome/db/product/19c/lib/libclntsh.so.19.1
[oracle@jwchoi|/home/oracle]$ stat /orahome/db/product/19c/lib/libclntsh.so.19.1
  File: '/orahome/db/product/19c/lib/libclntsh.so.19.1'
  Size: 21136           Blocks: 48         IO Block: 4096   regular file
Device: fc00h/64512d    Inode: 137822647   Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (  300/  oracle)   Gid: (  500/     dba)
Access: 2022-11-01 10:12:44.695000000 +0900
Modify: 2022-10-21 06:50:22.742000000 +0900
Change: 2022-10-21 06:50:22.742000000 +0900
 Birth: -
[oracle@jwchoi|/home/oracle]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export ORACLE_BASE=/orahome/db
export ORACLE_HOME=/orahome/db/product/19c
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export ORACLE_SID=TEST
export DISPLAY=192.168.10.218:0.0
export TUXCONFIG=/sw/tp/tuxedo12.2.2.0.0/samples/atmi/simpapp/tuxconfig
export T=/sw/tp/tuxedo12.2.2.0.0/samples/atmi/simpapp
export TUXDIR=/sw/tp/tuxedo12.2.2.0.0
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export FLDTBLDIR=/sw/tp/tuxedo12.2.2.0.0/udataobj:/sw/tp/tuxedo12.2.2.0.0/samples/atmi/simpapp/XA_test
export FIELDTBLS=Usysflds,emp.flds
export S=/sw/tp/tuxedo12.2.2.0.0/samples/atmi/simpapp/XA_test/serv


# quick key
alias ss='sqlplus "/as sysdba"'

export LANG=C
[oracle@jwchoi|/home/oracle]$ export LD_LIBRARY_PATH=$ORACLE_HOME
[oracle@jwchoi|/home/oracle]$ sqlplus / as sysdba
sqlplus: error while loading shared libraries: /orahome/db/product/19c/lib/libclntsh.so.19.1: invalid EL                                F header
[oracle@jwchoi|/home/oracle]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oracle@jwchoi|/home/oracle]$ sqlplus / as sysdba
sqlplus: error while loading shared libraries: /orahome/db/product/19c/lib/libclntsh.so.19.1: invalid EL                                F header
[oracle@jwchoi|/home/oracle]$ exit
logout
[root@jwchoi|/root]# find / -name 'libclntsh.so.19.1' -type f
/media/32900021/32904851/files/lib/libclntsh.so.19.1
/orahome/db/product/19c/.patch_storage/32904851_Jul_20_2021_09_21_24/files/lib/libclntsh.so.19.1
/orahome/db/product/19c/lib/libclntsh.so.19.1
[root@jwchoi|/root]# su - oracle
마지막 로그인: 화 11월  1 14:30:46 KST 2022 일시 pts/0
[oracle@jwchoi|/home/oracle]$ mv /orahome/db/product/19c/lib/libclntsh.so.19.1 /orahome/db/product/19c/lib/libclntsh.so.19.1_back
[oracle@jwchoi|/home/oracle]$ cp /orahome/db/product/19c/.patch_storage/32904851_Jul_20_2021_09_21_24/files/lib/libclntsh.so.19.1 /orahome/db/product/19c/lib/libclntsh.so.19.1
[oracle@jwchoi|/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 1 14:36:43 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit
Disconnected