操作系统:AIX
$ ./ggsci
exec(): 0509-036 Cannot load program ./ggsci because of the following errors:
0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.
0509-022 Cannot load module libclntsh.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
已经确认两点:
1、LIBPATH已经设置正确
$ echo $LIBPATH
/odc:/oracle/product/10.2.0/db_1/lib
2、ORACLE版本是64位,ggs软件也是64位。
检查libclntsh.a是否存在:
$ cd /oracle/product/10.2.0/db_1/lib
$ ls libclntsh*
libclntsh.so.10.1
确实没有libclntsh.a,检查生产端(生产端得操作系统和ORACLE版本与备份端一样):
$ cd $ORACLE_HOME/lib
$ pwd
/home/oracle/app/product/10.2.0/db_1/lib
$ ls libclntsh*
libclntsh.a libclntsh.so libclntsh.so.10.1
将生产端得2个文件ftp到备份端得相应目录下:
$ ftp 10.17.4.33
Connected to 10.17.4.33.
220 p570_p3 FTP server (Version 4.2 Tue Aug 10 14:04:02 CDT 2010) ready.
Name (10.17.4.33:root):
331 Password required for root.
Password:
230-Last unsuccessful login: Mon Mar 5 13:29:34 BEIST 2012 on /dev/pts/1 from 10.17.7.11
230-Last login: Mon Mar 5 15:09:43 BEIST 2012 on ftp from ::ffff:10.17.7.11
230 User root logged in.
ftp> bin
200 Type set to I.
ftp> cd /oracle/product/10.2.0/db_1/lib
250 CWD command successful.
ftp> put libclntsh.a
200 PORT command successful.
150 Opening data connection for libclntsh.a.
226 Transfer complete.
25025752 bytes sent in 0.5819 seconds (4.2e+04 Kbytes/s)
local: libclntsh.a remote: libclntsh.a
ftp> put libclntsh.so
200 PORT command successful.
150 Opening data connection for libclntsh.so.
226 Transfer complete.
24441460 bytes sent in 0.5374 seconds (4.442e+04 Kbytes/s)
local: libclntsh.so remote: libclntsh.so
ftp> by
221 Goodbye.
修改权限:
# cd /oracle/product/10.2.0/db_1/lib
# ls -rtl libclnts*
-rw-r—– 1 oracle dba 0 Aug 14 2005 libclntst10.a
-rw-r–r– 1 oracle dba 0 May 27 2010 libclntsh.so.10.1
-rw-r—– 1 root system 25025752 Mar 06 08:57 libclntsh.a
-rw-r—– 1 root system 24441460 Mar 06 08:57 libclntsh.so
# chown oracle:dba libclntsh*
再次启动ggsci成功:
$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Oct 5 2011 02:32:51
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (p570_p3) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER STOPPED
GGSCI (p570_p3) 2>
Related postscoded by nessus