at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.load0(Unknown Source)
at java.lang.System.load(Unknown Source)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)
这种方法会造成系统不能启动。
yum remove libXext-el6* libXext-devel-* libX11-* libxcb-* libXau-*
yum remove libXext-1.1-3.el6* libXext-devel-1.1-3.el6* libX11-* libxcb-* libXau-* libXtst-* libXi-*
mkdir -p /mnt/cdrom
fdisk -l
mount /dev/sdb4 /mnt/cdrom (原安装盘)
libc.so.6 is needed by XXX
yum install glibc.i686 在64位系统中,要同时安装64位的包和32位的兼容包
[root@ebs cdrom]# rpm -Uhv /mnt/cdrom/Packages/libXext-1.1-3.el6* /mnt/cdrom/Packages/libXext-devel-1.1-3.el6* /mnt/cdrom/Packages/libX11-*.rpm /mnt/cdrom/Packages/libxcb-*.rpm /mnt/cdrom/Packages/libXau-*.rpm --replacepkgs
warning: /mnt/cdrom/Packages/libXext-1.1-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:libXau ########################################### [ 6%]
2:libxcb ########################################### [ 12%]
3:libX11-common ########################################### [ 18%]
4:libX11 ########################################### [ 24%]
5:libXext ########################################### [ 29%]
6:libXau ########################################### [ 35%]
7:libXau-devel ########################################### [ 41%]
8:libXau-devel ########################################### [ 47%]
9:libxcb ########################################### [ 53%]
10:libxcb-devel ########################################### [ 59%]
11:libX11 ########################################### [ 65%]
12:libX11-devel ########################################### [ 71%]
13:libXext-devel ########################################### [ 76%]
14:libX11-devel ########################################### [ 82%]
15:libxcb-devel ########################################### [ 88%]
16:libXext ########################################### [ 94%]
17:libXext-devel ########################################### [100%]
[root@ebs cdrom]# rpm -Uhv /mnt/cdrom/Packages/libXext-1.1-3.el6* /mnt/cdrom/Packages/libXext-devel-1.1-3.el6* /mnt/cdrom/Packages/libX11-*.rpm /mnt/cdrom/Packages/libxcb-*.rpm /mnt/cdrom/Packages/libXau-*.rpm --replacepkgs
warning: /mnt/cdrom/Packages/libXext-1.1-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:libXau ########################################### [ 6%]
2:libxcb ########################################### [ 12%]
3:libX11-common ########################################### [ 18%]
4:libX11 ########################################### [ 24%]
5:libXext ########################################### [ 29%]
6:libXau ########################################### [ 35%]
7:libXau-devel ########################################### [ 41%]
8:libXau-devel ########################################### [ 47%]
9:libxcb ########################################### [ 53%]
10:libxcb-devel ########################################### [ 59%]
11:libX11 ########################################### [ 65%]
12:libX11-devel ########################################### [ 71%]
13:libXext-devel ########################################### [ 76%]
14:libX11-devel ########################################### [ 82%]
15:libxcb-devel ########################################### [ 88%]
16:libXext ########################################### [ 94%]
17:libXext-devel ########################################### [100%]
[root@ebs cdrom]# rpm -Uhv /mnt/cdrom/Packages/libXtst-* /mnt/cdrom/Packages/libXi-* --replacepkgs
warning: /mnt/cdrom/Packages/libXtst-1.0.99.2-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing... ########################################### [100%]
1:libXi ########################################### [ 13%]
2:libXtst ########################################### [ 25%]
3:libXi ########################################### [ 38%]
4:libXi-devel ########################################### [ 50%]
5:libXtst-devel ########################################### [ 63%]
6:libXi-devel ########################################### [ 75%]
7:libXtst ########################################### [ 88%]
8:libXtst-devel ########################################### [100%]
./rapidwiz
64位下安装32位库
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
# rpm -ivh libXi-1.3-3.el6.i686.rpm
warning: libXi-1.3-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing... ########################################### [100%]
1:libXi ########################################### [100%]
# rpm -ivh libXtst-1.0.99.2-3.el6.i686.rpm
warning: libXtst-1.0.99.2-3.el6.i686.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing... ########################################### [100%]
1:libXtst ########################################### [100%]
[root@localhost rapidwiz]# yum list |grep libXtst
libXtst.x86_64 1.2.2-2.1.el6 @base
libXtst-devel.x86_64 1.2.2-2.1.el6 @base
libXtst.i686 1.2.2-2.1.el6 base
libXtst-devel.i686 1.2.2-2.1.el6 base
[root@localhost rapidwiz]# yum install libXtst.i686
已加载插件:fastestmirror
设置安装进程
Loading mirror speeds from cached hostfile
* rpmforge: ftp.riken.jp
base | 3.7 kB 00:00
extras | 3.7 kB 00:00
rpmforge | 1.9 kB 00:00
updates | 3.7 kB 00:00
解决依赖关系
--> 执行事务检查
---> Package libXtst.i686 0:1.2.2-2.1.el6 will be 安装
--> 处理依赖关系 libXi.so.6,它被软件包 libXtst-1.2.2-2.1.el6.i686 需要
--> 执行事务检查
---> Package libXi.i686 0:1.7.2-2.2.el6 will be 安装
--> 完成依赖关系计算
依赖关系解决
=======================================================================================================
软件包 架构 版本 仓库 大小
=======================================================================================================
正在安装:
libXtst i686 1.2.2-2.1.el6 base 19 k
为依赖而安装:
libXi i686 1.7.2-2.2.el6 base 37 k
事务概要
=======================================================================================================
Install 2 Package(s)
总下载量:55 k
Installed size: 86 k
确定吗?[y/N]:y
下载软件包:
(1/2): libXi-1.7.2-2.2.el6.i686.rpm | 37 kB 00:00
(2/2): libXtst-1.2.2-2.1.el6.i686.rpm | 19 kB 00:00
-------------------------------------------------------------------------------------------------------
总计 195 kB/s | 55 kB 00:00
运行 rpm_check_debug
执行事务测试
事务测试成功
执行事务
Warning: RPMDB altered outside of yum.
** Found 4 pre-existing rpmdb problem(s), 'yum check' output follows:
PackageKit-0.5.8-19.0.1.el6.x86_64 has missing requires of PackageKit-yum = ('0', '0.5.8', '19.0.1.el6')
PackageKit-0.5.8-19.0.1.el6.x86_64 has missing requires of PackageKit-yum-plugin = ('0', '0.5.8', '19.0.1.el6')
abrt-addon-ccpp-1.1.16-3.0.1.el6.x86_64 has missing requires of yum-utils
rhn-check-1.0.0-61.0.2.el6.noarch has missing requires of yum-rhn-plugin >= ('0', '0.5.3', '30')
正在安装 : libXi-1.7.2-2.2.el6.i686 1/2
正在安装 : libXtst-1.2.2-2.1.el6.i686 2/2
Verifying : libXi-1.7.2-2.2.el6.i686 1/2
Verifying : libXtst-1.2.2-2.1.el6.i686 2/2
已安装:
libXtst.i686 0:1.2.2-2.1.el6
作为依赖被安装:
libXi.i686 0:1.7.2-2.2.el6
完毕!
[root@localhost rapidwiz]# yum list |grep libXi
libXi.i686 1.7.2-2.2.el6 @base
libXi.x86_64 1.7.2-2.2.el6 @base
libXi-devel.x86_64 1.7.2-2.2.el6 @base
libXinerama.x86_64 1.1-1.el6 @anaconda-OracleLinuxServer-201105261616.x86_64/6.1
libXinerama-devel.x86_64 1.1-1.el6 @anaconda-OracleLinuxServer-201105261616.x86_64/6.1
libXi-devel.i686 1.7.2-2.2.el6 base
libXinerama.i686 1.1.3-2.1.el6 base
libXinerama.x86_64 1.1.3-2.1.el6 base
libXinerama-devel.i686 1.1.3-2.1.el6 base
libXinerama-devel.x86_64 1.1.3-2.1.el6 base
[root@localhost rapidwiz]# yum install libXi.i686
已加载插件:fastestmirror
设置安装进程
Loading mirror speeds from cached hostfile
* rpmforge: ftp.riken.jp
base | 3.7 kB 00:00
extras | 3.7 kB 00:00
rpmforge | 1.9 kB 00:00
updates | 3.7 kB 00:00
包 libXi-1.7.2-2.2.el6.i686 已安装并且是最新版本
无须任何处理
[root@localhost linux patch]# ls -al /usr/lib/libXext.so.6
lrwxrwxrwx. 1 root root 16 1月 1 20:50 /usr/lib/libXext.so.6 -> libXext.so.6.4
[root@localhost rapidwiz]# ./rap*
Rapid Install Wizard is validating your file system......
4 dvd labels found
Rapid Install Wizard will now launch the Java Interface.....
2、https://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/ EBS 专用库
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
openmotif21-2.1.30-11.EL6.i686.rpm
3、因unzip版本问题,我们需要首先替换系统内的unzip
cd /usr/bin
mv  unzip  unzip.old
cd xxxx/Stage12/startCD/Disk1/rapidwiz/unzip/Linux_x64
cp unzip /usr/bin
4、安装过程中报错
0% completed AC-00402: Unable to read driver file: /data/oraprod/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv
[root@oracle lib]# yum install libdb*i686*
已加载插件:fastestmirror
设置安装进程
Loading mirror speeds from cached hostfile
* rpmforge: ftp.riken.jp
base | 3.7 kB 00:00
extras | 3.7 kB 00:00
rpmforge | 1.9 kB 00:00
updates | 3.7 kB 00:00
解决依赖关系
--> 执行事务检查
---> Package libdbi.i686 0:0.8.3-4.el6 will be 安装
---> Package libdbi-devel.i686 0:0.8.3-4.el6 will be 安装
--> 完成依赖关系计算
依赖关系解决
================================================================================
软件包 架构 版本 仓库 大小
================================================================================
正在安装:
libdbi i686 0.8.3-4.el6 base 39 k
libdbi-devel i686 0.8.3-4.el6 base 597 k
事务概要
================================================================================
Install 2 Package(s)
总下载量:636 k
Installed size: 1.7 M
确定吗?[y/N]:y
下载软件包:
(1/2): libdbi-0.8.3-4.el6.i686.rpm | 39 kB 00:00
(2/2): libdbi-devel-0.8.3-4.el6.i686.rpm | 597 kB 00:02
--------------------------------------------------------------------------------
总计 264 kB/s | 636 kB 00:02
运行 rpm_check_debug
执行事务测试
事务测试成功
执行事务
正在安装 : libdbi-0.8.3-4.el6.i686 1/2
正在安装 : libdbi-devel-0.8.3-4.el6.i686 2/2
Verifying : libdbi-devel-0.8.3-4.el6.i686 1/2
Verifying : libdbi-0.8.3-4.el6.i686 2/2
已安装:
libdbi.i686 0:0.8.3-4.el6 libdbi-devel.i686 0:0.8.3-4.el6
完毕!
5 、 %33 error
----------------------------------------------------------------------------------------------------------------
sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directoryegrep: /data/oraprod/db/tech_st/11.1.0/appsutil/log/PROD_oracle/adcrdb_PROD.txt: No such file or directory
.end err out.
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : oracle
sDbDomain : ebs.com
sDbPort : 1521
sDbSid : PROD
sDbUser : APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@oracle.ebs.com:1521:PROD
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.ebs.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.ebs.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD.ebs.com)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Connection could not be obtained; returning null
[root@oracle 桌面]# yum install glibc*i686*
已加载插件:fastestmirror
设置安装进程
Loading mirror speeds from cached hostfile
* rpmforge: ftp.riken.jp
base | 3.7 kB 00:00
extras | 3.7 kB 00:00
rpmforge | 1.9 kB 00:00
updates | 3.7 kB 00:00
包 glibc-2.12-1.149.el6.i686 已安装并且是最新版本
解决依赖关系
--> 执行事务检查
---> Package glibc-devel.i686 0:2.12-1.149.el6 will be 安装
---> Package glibc-static.i686 0:2.12-1.149.el6 will be 安装
--> 完成依赖关系计算
依赖关系解决
==================================================================================
软件包 架构 版本 仓库 大小
==================================================================================
正在安装:
glibc-devel i686 2.12-1.149.el6 base 983 k
glibc-static i686 2.12-1.149.el6 base 1.1 M
事务概要
==================================================================================
Install 2 Package(s)
总下载量:2.1 M
Installed size: 5.3 M
确定吗?[y/N]:y
下载软件包:
(1/2): glibc-devel-2.12-1.149.el6.i686.rpm | 983 kB 00:03
(2/2): glibc-static-2.12-1.149.el6.i686.rpm | 1.1 MB 00:04
----------------------------------------------------------------------------------
总计 243 kB/s | 2.1 MB 00:08
运行 rpm_check_debug
执行事务测试
事务测试成功
执行事务
正在安装 : glibc-devel-2.12-1.149.el6.i686 1/2
正在安装 : glibc-static-2.12-1.149.el6.i686 2/2
Verifying : glibc-devel-2.12-1.149.el6.i686 1/2
Verifying : glibc-static-2.12-1.149.el6.i686 2/2
已安装:
glibc-devel.i686 0:2.12-1.149.el6 glibc-static.i686 0:2.12-1.149.el6
完毕!
------------------------------------------------------------------------------------------------------------------------------------------------------------------
%33 配置数据库错误(可以看到这里已经在恢复数据库了通过克隆脚本的方式(其实也是运用了RMAN)
报错,先看日志如下,顺其找到详细日志,看ALERT日志。删除原来的安装生成的文件,PKILL掉用户进程重新运行安装。
Log file located at /ebs/oraprod/db/tech_st/11.1.0/appsutil/log/PROD_oracle/ApplyDatabase_01031922.log
| 0% completed
/ 0% completed
- 0% completed
\ 0% completed
| 0% completed
/ 0% completed
- 0% completed
\ 0% completed
| 0% completed
/ 0% completed
- 0% completed RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
Cannot execute configure of database using RapidClone
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 3 19:22:51 1980
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
/ebs/oraprod/db/tech_st/11.1.0/admin/PROD_oracle/diag/rdbms/prod/PROD/trace
DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'-bash-4.1$ id
Cause
In this particular case, the system time was incorrect causing time conversion to fail.
Solution
To implement the solution, correct the system time.
------------------------------------------------------------------------------------------------------------------------------------------------------------------
path 12415211:
$ cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.2/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
After this is done and sourcing the APPS<CONTEXT_NAME>.env file, users should relink all 10.1.2 executables by running the$ORACLE_HOME/appsutil/clone/adlnktools.sh script and ensuring that there are now no errors in the make log file output from the script.
The instructions for the 10.1.3 Oracle Home are:
$ cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.3/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
After this, users should relink sqlplus by running the <INSTALL_DIR>/apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh script and ensuring that there are now no errors in the make log file output from the script.
-bash-4.1$ $ORACLE_HOME/appsutil/clone/adlnktools.sh
adlnktools.sh started at 2015年 04月 16日 星期四 15:43:38 CST
Log file located at /ebs/applprod/inst/apps/PROD_oracle/logs/ora/10.1.2/install/make_04161543.log
find: “/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/*/lib”: 没有那个文件或目录
Error while running adlnktools.sh.
return code = .16.17.18.21.22.23.24.25.32.33.34.36.37.38
Please check logfile located at /ebs/applprod/inst/apps/PROD_oracle/logs/ora/10.1.2/install/make_04161543.log
gcc -m32 -o /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmemso.so -Wl,--whole-archive -shared -L/ebs/applprod/apps/tech_st/10.1.2/lib/ -L/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/ -L/ebs/applprod/apps/tech_st/10.1.2/lib/stubs/ -L/ebs/applprod/apps/tech_st/10.1.2/lib -L/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/ -Wl,-rpath,/ebs/applprod/apps/tech_st/10.1.2/lib/:/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/ /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmem.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmer.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeu.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmt.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnml.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmee.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmefmgr.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmevr.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmehu.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmehl.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmepm.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmedc.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmedt.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmedm.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmedr.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeb.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmec.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmesched.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmectl.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmejc.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmej.a -L/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386/client -L/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rpath,/ebs/applprod/apps/tech_st/10.1.2/lib/:/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/:/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386/client:/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386 /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeclumgr.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmecluster.a /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmexml.a -Wl,--no-whole-archive -lxml10 -lcore10 -lnls10 -lunls10 -lclntsh -lnnz10 -lpthread -lnsl -lm -ldl -Wl,-rpath,/ebs/applprod/apps/tech_st/10.1.2/lib `cat /ebs/applprod/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm
/usr/bin/ld: cannot find -ljava
collect2: ld 返回 1
make[1]: *** [/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmemso.so] 错误 1
make[1]: Leaving directory `/ebs/applprod/apps/tech_st/10.1.2/sysman/lib'
make: *** [libnmemso] 错误 2
Failed linking targets (agent nmo nmb) on 2015年 04月 16日 星期四 15:59:17 CST...
/ebs/applprod/apps/tech_st/10.1.2/sysman/lib
gcc -m32 -o /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeoci.so `cat /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeoci.def | perl /ebs/applprod/apps/tech_st/10.1.2/bin/processDef.pl | grep -E "[a-zA-Z]+[;]" | awk -F ";" '{printf(" -u "$1);}'` -shared -L/ebs/applprod/apps/tech_st/10.1.2/lib/ -L/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/ -L/ebs/applprod/apps/tech_st/10.1.2/lib/stubs/ /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeoci.a -L/ebs/applprod/apps/tech_st/10.1.2/lib -L/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/ -lnmemso -lcore10 -Wl,-rpath,/ebs/applprod/apps/tech_st/10.1.2/lib/:/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/:/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386/client:/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386 -L/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386/client -L/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rpath,/ebs/applprod/apps/tech_st/10.1.2/lib/:/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/:/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386/client:/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386 -Wl,--allow-shlib-undefined `cat /ebs/applprod/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm
/usr/bin/ld: cannot find -ljava
collect2: ld 返回 1
make: *** [/ebs/applprod/apps/tech_st/10.1.2/sysman/lib/libnmeoci.so] 错误 1
Failed linking target libnmeoci on 2015年 04月 16日 星期四 15:59:17 CST...
/ebs/applprod/apps/tech_st/10.1.2/sysman/lib
Solution:
-bash-4.1$ vi /ebs/applprod/apps/tech_st/10.1.2/sysman/lib/env_sysman.mk
JRE_LIB_DIR=/d2/R12/ab/apps/R1211XB9/apps/tech_st/10.1.2/jdk/jre/lib/i386 ==>JRE_LIB_DIR=/ebs/applprod/apps/tech_st/10.1.2/jdk/jre/lib/i386
-bash-4.1$ $ORACLE_HOME/appsutil/clone/adlnktools.sh
adlnktools.sh started at 2015年 04月 16日 星期四 16:16:35 CST
Log file located at /ebs/applprod/inst/apps/PROD_oracle/logs/ora/10.1.2/install/make_04161616.log
adlnktools.sh completed sucessfully
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
AD Administration error:
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 1
sqlplus -s &un_apps/***** @/ebs/applprod/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
An error occurred while running adsetmmd.sql.
Continue as if it were successful [No] :
aiimToggleMaintenanceMode():Error while calling aiucm3().
AD Administration error:
Unable to Enable Maintenance Mode.
SQL> @/ebs/applprod/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
fnd_apps_mode_util.set_to_normal_mode(ret_code,err_buf);
*
ERROR at line 10:
ORA-06550: line 10, column 9:
PLS-00201: identifier 'FND_APPS_MODE_UTIL.SET_TO_NORMAL_MODE' must be declared
ORA-06550: line 10, column 9:
PL/SQL: Statement ignored
ORA-06550: line 27, column 9:
PLS-00201: identifier 'FND_APPS_MODE_UTIL.SET_TO_MAINTENANCE_MODE' must be
declared
ORA-06550: line 27, column 9:
PL/SQL: Statement ignored
SQL> show errors
No errors.
SQL> select object_name from dba_objects where status='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
ORDIMG_PKG
DR$JTF_NOTES_TL_C1$I
DR$JTF_NOTES_TL_C1$K
DR$JTF_NOTES_TL_C1$N
DR$JTF_NOTES_TL_C1$R
ORDIMGEXTCODEC_PKG
ODM_MINING_MODEL_TRIGGER
OP_COMMON
ODM_MODEL_UTIL
ODM_SUPERVISED_MODEL
ODM_ABN_MODEL
OBJECT_NAME
--------------------------------------------------------------------------------
ODM_KM_CLUSTERING_MODEL
ODM_NAIVE_BAYES_APPLY
ODM_NAIVE_BAYES_MODEL
AS_GROUP_MV
PLSQL_PROFILER_RUNNUMBER
PLSQL_PROFILER_RUNS
PLSQL_PROFILER_UNITS
PLSQL_PROFILER_DATA
PRVT_WORKLOAD
SERVLET$xd
Folder23_TAB$xd
OBJECT_NAME
--------------------------------------------------------------------------------
VALIDATE_ORDIM
BIM_I_ATTR_NAME_MV
BIM_I_OBJ_NAME_MV
LNS_LOAN_DTLS_ALL_MV
OZF_CUST_FUND_SUMMARY_MV
AMW_OPINION_MV
AMW_OPINION_LOG_MV
FEM_LN_ITEMS_ATTRD_MV
FEM_NAT_ACCTS_ATTRD_MV
OE_ITEMS_MV
include345_TAB$xd
OBJECT_NAME
--------------------------------------------------------------------------------
fallback341_TAB$xd
fallback340_TAB$xd
ORDDCM_DOCUMENTS
ORDDCM_CONSTRAINT_NAMES
ORDDCM_DOCS_USR
ORDDCM_STD_ATTRS_USR
ORDDCM_PRV_ATTRS_USR
ORDDCM_MAPPING_DOCS_USR
ORDDCM_MAPPED_PATHS_USR
ORDDCM_ANON_RULES_USR
ORDDCM_ANON_ATTRS_USR
OBJECT_NAME
--------------------------------------------------------------------------------
ORDDCM_RT_PREF_PARAMS_USR
ORDDCM_UID_DEFS_USR
ORDDCM_CT_PRED_USR
ORDDCM_CT_PRED_SET_USR
ORDDCM_CT_PRED_PAR_USR
ORDDCM_CT_ACTION_USR
ORDDCM_CONFORMANCE_VLD_MSGS
ORDDCM_DOCUMENTS
ORDDCM_CONSTRAINT_NAMES
ORDDCM_CONFORMANCE_VLD_MSGS
ORD_DICOM_CT
OBJECT_NAME
--------------------------------------------------------------------------------
ORD_DICOM_ADMIN_PRV
56 rows selected.
SQL> SQL> select owner, object_type, status, count(*) from dba_objects where status='INVALID' group by owner, object_type, status order by owner, object_type;
OWNER OBJECT_TYPE STATUS COUNT(*)
------------------------------ ------------------- ------- ----------
APPS MATERIALIZED VIEW INVALID 10
APPS SYNONYM INVALID 8
ODM PACKAGE BODY INVALID 7
ODM TRIGGER INVALID 1
ORDSYS PACKAGE BODY INVALID 4
ORDSYS VIEW INVALID 16
PUBLIC SYNONYM INVALID 3
SYS PACKAGE BODY INVALID 1
SYS PROCEDURE INVALID 1
XDB TRIGGER INVALID 5
10 rows selected.
SQL> col owner for a20;
col object_name for a32;
col object_type for a16;
col status for a8
SQL> select owner, object_name, object_type, status from dba_objects where status='INVALID' order by 1, 2,3;
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
APPS AMW_OPINION_LOG_MV MATERIALIZED VIE INVALID
W
APPS AMW_OPINION_MV MATERIALIZED VIE INVALID
W
APPS AS_GROUP_MV MATERIALIZED VIE INVALID
W
APPS BIM_I_ATTR_NAME_MV MATERIALIZED VIE INVALID
W
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
APPS BIM_I_OBJ_NAME_MV MATERIALIZED VIE INVALID
W
APPS DR$JTF_NOTES_TL_C1$I SYNONYM INVALID
APPS DR$JTF_NOTES_TL_C1$K SYNONYM INVALID
APPS DR$JTF_NOTES_TL_C1$N SYNONYM INVALID
APPS DR$JTF_NOTES_TL_C1$R SYNONYM INVALID
APPS FEM_LN_ITEMS_ATTRD_MV MATERIALIZED VIE INVALID
W
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
APPS FEM_NAT_ACCTS_ATTRD_MV MATERIALIZED VIE INVALID
W
APPS LNS_LOAN_DTLS_ALL_MV MATERIALIZED VIE INVALID
W
APPS OE_ITEMS_MV MATERIALIZED VIE INVALID
W
APPS OZF_CUST_FUND_SUMMARY_MV MATERIALIZED VIE INVALID
W
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
APPS PLSQL_PROFILER_DATA SYNONYM INVALID
APPS PLSQL_PROFILER_RUNNUMBER SYNONYM INVALID
APPS PLSQL_PROFILER_RUNS SYNONYM INVALID
APPS PLSQL_PROFILER_UNITS SYNONYM INVALID
ODM ODM_ABN_MODEL PACKAGE BODY INVALID
ODM ODM_KM_CLUSTERING_MODEL PACKAGE BODY INVALID
ODM ODM_MINING_MODEL_TRIGGER TRIGGER INVALID
ODM ODM_MODEL_UTIL PACKAGE BODY INVALID
ODM ODM_NAIVE_BAYES_APPLY PACKAGE BODY INVALID
ODM ODM_NAIVE_BAYES_MODEL PACKAGE BODY INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
ODM ODM_SUPERVISED_MODEL PACKAGE BODY INVALID
ODM OP_COMMON PACKAGE BODY INVALID
ORDSYS ORDDCM_ANON_ATTRS_USR VIEW INVALID
ORDSYS ORDDCM_ANON_RULES_USR VIEW INVALID
ORDSYS ORDDCM_CONFORMANCE_VLD_MSGS VIEW INVALID
ORDSYS ORDDCM_CONSTRAINT_NAMES VIEW INVALID
ORDSYS ORDDCM_CT_ACTION_USR VIEW INVALID
ORDSYS ORDDCM_CT_PRED_PAR_USR VIEW INVALID
ORDSYS ORDDCM_CT_PRED_SET_USR VIEW INVALID
ORDSYS ORDDCM_CT_PRED_USR VIEW INVALID
ORDSYS ORDDCM_DOCS_USR VIEW INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
ORDSYS ORDDCM_DOCUMENTS VIEW INVALID
ORDSYS ORDDCM_MAPPED_PATHS_USR VIEW INVALID
ORDSYS ORDDCM_MAPPING_DOCS_USR VIEW INVALID
ORDSYS ORDDCM_PRV_ATTRS_USR VIEW INVALID
ORDSYS ORDDCM_RT_PREF_PARAMS_USR VIEW INVALID
ORDSYS ORDDCM_STD_ATTRS_USR VIEW INVALID
ORDSYS ORDDCM_UID_DEFS_USR VIEW INVALID
ORDSYS ORDIMGEXTCODEC_PKG PACKAGE BODY INVALID
ORDSYS ORDIMG_PKG PACKAGE BODY INVALID
ORDSYS ORD_DICOM_ADMIN_PRV PACKAGE BODY INVALID
ORDSYS ORD_DICOM_CT PACKAGE BODY INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- -------------------------------- ---------------- --------
PUBLIC ORDDCM_CONFORMANCE_VLD_MSGS SYNONYM INVALID
PUBLIC ORDDCM_CONSTRAINT_NAMES SYNONYM INVALID
PUBLIC ORDDCM_DOCUMENTS SYNONYM INVALID
SYS PRVT_WORKLOAD PACKAGE BODY INVALID
SYS VALIDATE_ORDIM PROCEDURE INVALID
XDB Folder23_TAB$xd TRIGGER INVALID
XDB SERVLET$xd TRIGGER INVALID
XDB fallback340_TAB$xd TRIGGER INVALID
XDB fallback341_TAB$xd TRIGGER INVALID
XDB include345_TAB$xd TRIGGER INVALID
56 rows selected.
SQL> alter MATERIALIZED VIEW APPS.AMW_OPINION_LOG_MV COMPILE;
Materialized view altered.
SQL> alter MATERIALIZED VIEW APPS.AMW_OPINION_MV COMPILE;
Materialized view altered.
SQL> alter MATERIALIZED VIEW APPS.AS_GROUP_MV COMPILE;
Materialized view altered.
SQL> alter MATERIALIZED VIEW APPS.BIM_I_ATTR_NAME_MV COMPILE;
Materialized view altered.
alter MATERIALIZED VIEW owner.xxx compile
alter view owner.xxx compile
alter package owner.xxx compile
alter trigger owner.xxx compile exec dbms_utility.compile_schema( 'APPS');
-bash-4.1$ sqlplus
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Apr 16 18:45:32 2015
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: apps
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @/ebs/applprod/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
再运行 ./adpatch 打补丁
|