oracle错误!复制无法执行了!

显示全部楼层 · 2017-3-27 08:04:23

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Productio
NLSRTL Version 10.2.0.1.0 - Production
前段时间在ALERT日志中发现错误如下
Errors in file /oracle/admin/smgerp/bdump/smgerp_ckpt_811780.trc:
ORA-00206: Message 206 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1]
ORA-00202: Message 202 not found; No message file for product=RDBMS, facility=ORA; arguments: [/oradataa/smgerp/control03.ctl]
ORA-27072: Message 27072 not found; No message file for product=RDBMS, facility=ORA
IBM AIX RISC System/6000 Error: 22: Invalid argument
Additional information: 8
按照这个错误,打了补丁4401119 ,不过过程中出了警告如下,可能没有打成功
$ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.0
Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation.All rights reserved..

Oracle Home : /oracle/10.2.0.1.0
Central Inventory : /oracle/oraInventory
from : /oracle/10.2.0.1.0/oraInst.loc
OPatch version: 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location: /oracle/10.2.0.1.0/oui
Log file location : /oracle/10.2.0.1.0/cfgtoollogs/opatch/opatch-00_Aug_28_23-26
-45-GMT+08_Thu.log
ApplySession applying interim patch '4674849' to OH '/oracle/10.2.0.1.0'
Invoking fuser to check for active processes.
Invoking fuser on "/oracle/10.2.0.1.0/bin/oracle"
OPatch detected non-cluster Oracle Home from the inventory and will patch the lo
cal system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
stem.
(Oracle Home = '/oracle/10.2.0.1.0')
Is the local system ready for patching?
Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '4674849' for restore. This might take a
while...
Backing up files affected by the patch '4674849' for rollback. This might take a
while...
File not backed up from /oracle/10.2.0.1.0/lib/libgeneric10.a to /oracle/10.2.0.
1.0/.patch_storage/4674849_Oct_19_2005_17_13_01/files/lib/libgeneric10.a/skgfr.o
... 'ar: 0707-109 Member name skgfr.o does not exist.
'
ApplySession for patch ID '4674849': Could not back up following actions for pat
ch rollback:
1)
libgeneric10.a lib/libgeneric10.a/skgfr.o
Do you want to proceed? [y|n]
y
User Responded with: Y
Patching component oracle.rdbms, 10.2.0.1.0...
Updating archive file "/oracle/10.2.0.1.0/lib/libgeneric10.a"with "lib/libgene
ric10.a/skgfr.o"
Archive not applied /oracle/10.2.0.1.0/OPatch/4674849/files/lib/libgeneric10.a/s
kgfr.o to /oracle/10.2.0.1.0/lib/libgeneric10.a... 'ArchiveAction::apply() faile
d: "ar: 0707-126 /oracle/10.2.0.1.0/OPatch/4674849/files/lib/libgeneric10.a/skgf
r.o is not valid with the current object file mode.
Use the -X option to specify the desired object mode.
"'
ArchiveAction::apply() failed: "ArchiveAction::apply() failed: "ar: 0707-126 /or
acle/10.2.0.1.0/OPatch/4674849/files/lib/libgeneric10.a/skgfr.o is not valid wit
h the current object file mode.
Use the -X option to specify the desired object mode.
""
Do you want to proceed? [y|n]
y
User Responded with: Y
Running make for target ioracle
ApplySession adding interim patch '4674849' to inventory
The local system has been patched and can be restarted.
--------------------------------------------------------------------------------
The following warnings has happened during OPatch execution:
1) OUI-67003:File not backed up from /oracle/10.2.0.1.0/lib/libgeneric10.a to /o
racle/10.2.0.1.0/.patch_storage/4674849_Oct_19_2005_17_13_01/files/lib/libgeneri
c10.a/skgfr.o... 'ar: 0707-109 Member name skgfr.o does not exist.
'
2) OUI-67010:Archive not applied /oracle/10.2.0.1.0/OPatch/4674849/files/lib/lib
generic10.a/skgfr.o to /oracle/10.2.0.1.0/lib/libgeneric10.a... 'ArchiveAction::
apply() failed: "ar: 0707-126 /oracle/10.2.0.1.0/OPatch/4674849/files/lib/libgen
eric10.a/skgfr.o is not valid with the current object file mode.
Use the -X option to specify the desired object mode.
"'
--------------------------------------------------------------------------------
OPatch Session completed with warnings.
之后第二天开始就出现错误
ORA-00600: internal error code, arguments: [kgscLogOff-notempty], [1], [], [], [], [], [], []
ORA-00018: maximum number of sessions exceeded
看这个是需要打补丁,不过我怀疑我第一个补丁就没打好,不知道问题在哪里?
现在oracle的高级复制也无法进行下去了,事务一直堆在那里,推行不下去,大侠们有走过路过的过来看看吧!

千问 · 2017-3-27 08:04:23

如果是第一个补丁没有打好造成的后面连续错误,不知道哪里有问题,看错误提示不太明白
打第一个补丁整个过程如下
$ cd /oracle/10.2.0.1.0/OPatch/4674849
$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.0
Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation.All rights reserved..

Oracle Home : /oracle/10.2.0.1.0
Central Inventory : /oracle/oraInventory
from : /oracle/10.2.0.1.0/oraInst.loc
OPatch version: 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location: /oracle/10.2.0.1.0/oui
Log file location : /oracle/10.2.0.1.0/cfgtoollogs/opatch/opatch-00_Aug_28_23-26
-45-GMT+08_Thu.log
ApplySession applying interim patch '4674849' to OH '/oracle/10.2.0.1.0'
Invoking fuser to check for active processes.
Invoking fuser on "/oracle/10.2.0.1.0/bin/oracle"
OPatch detected non-cluster Oracle Home from the inventory and will patch the lo
cal system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
stem.
(Oracle Home = '/oracle/10.2.0.1.0')
Is the local system ready for patching?
Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '4674849' for restore. This might take a
while...
Backing up files affected by the patch '4674849' for rollback. This might take a
while...
File not backed up from /oracle/10.2.0.1.0/lib/libgeneric10.a to /oracle/10.2.0.
1.0/.patch_storage/4674849_Oct_19_2005_17_13_01/files/lib/libgeneric10.a/skgfr.o
... 'ar: 0707-109 Member name skgfr.o does not exist.
'
ApplySession for patch ID '4674849': Could not back up following actions for pat
ch rollback:
1)
libgeneric10.a lib/libgeneric10.a/skgfr.o
Do you want to proceed? [y|n]
y
User Responded with: Y
Patching component oracle.rdbms, 10.2.0.1.0...
Updating archive file "/oracle/10.2.0.1.0/lib/libgeneric10.a"with "lib/libgene
ric10.a/skgfr.o"
Archive not applied /oracle/10.2.0.1.0/OPatch/4674849/files/lib/libgeneric10.a/s
kgfr.o to /oracle/10.2.0.1.0/lib/libgeneric10.a... 'ArchiveAction::apply() faile
d: "ar: 0707-126 /oracle/10.2.0.1.0/OPatch/4674849/files/lib/libgeneric10.a/skgf
r.o is not valid with the current object file mode.
Use the -X option to specify the desired object mode.
"'
ArchiveAction::apply() failed: "ArchiveAction::apply() failed: "ar: 0707-126 /or
acle/10.2.0.1.0/OPatch/4674849/files/lib/libgeneric10.a/skgfr.o is not valid wit
h the current object file mode.
Use the -X option to specify the desired object mode.
""
Do you want to proceed? [y|n]
y
User Responded with: Y
Running make for target ioracle
ApplySession adding interim patch '4674849' to inventory
The local system has been patched and can be restarted.
--------------------------------------------------------------------------------
The following warnings has happened during OPatch execution:
1) OUI-67003:File not backed up from /oracle/10.2.0.1.0/lib/libgeneric10.a to /o
racle/10.2.0.1.0/.patch_storage/4674849_Oct_19_2005_17_13_01/files/lib/libgeneri
c10.a/skgfr.o... 'ar: 0707-109 Member name skgfr.o does not exist.
'
2) OUI-67010:Archive not applied /oracle/10.2.0.1.0/OPatch/4674849/files/lib/lib
generic10.a/skgfr.o to /oracle/10.2.0.1.0/lib/libgeneric10.a... 'ArchiveAction::
apply() failed: "ar: 0707-126 /oracle/10.2.0.1.0/OPatch/4674849/files/lib/libgen
eric10.a/skgfr.o is not valid with the current object file mode.
Use the -X option to specify the desired object mode.
"'
--------------------------------------------------------------------------------
OPatch Session completed with warnings.
OPatch succeeded.
$$ORACLE_HOME/OPatch/opatch lsinventory

千问 · 2017-3-27 08:04:23

It's rare to see somebody posting a message with Oracle version number. Thank you for that!
I haven't checked ORA-600 [kgscLogOff-notempty] but I think you already searched on Metalink. Since you got "ORA-00018: maximum number of sessions exceeded", why not try bumping up processes (or just sessions) and try again?
ORA-202 and -206 are both control file related. You can find the actual error description in documentation or through a Google search.
Yong Huang

千问 · 2017-3-27 08:04:23

因为是双向复制,出现了一个冲突,复制的错误已经解决,应该和警告日志里面的提示没有关系
复制冲突解决后,process目前都是没超过设定值,日志中未发现错误提示
执行$ORACLE_HOME/OPatch/opatch lsinventory后,发现补丁提示是成功APPLY的,中间的错误提示,可能和没有设置好环境变量有关系,这个等下再试试
现在想问的问题是,打补丁的过程是否是有问题的,比如说执行命令时候的目录路径以及是否还需要设置些什么?
READ ME里面没有太多提示,望不吝赐教

千问 · 2017-3-27 08:04:23

原帖由 dalimao 于 2008-9-2 00:25 发表
现在想问的问题是,打补丁的过程是否是有问题的,比如说执行命令时候的目录路径以及是否还需要设置些什么?
READ ME里面没有太多提示,望不吝赐教
The error "Use the -X option [for ar command] to specify the desired object mode" seems to be related to 32- vs 64-bit confusion. Check your LD_LIBRARY_PATH. Did you search on Metalink?
Yong Huang

千问 · 2017-3-27 08:04:23

感谢版主回帖!
su- oracle后env查到LD_LIBRARY_PATH=/oracle/10.2.0.1.0/lib:/usr/lib
我的错误和这个帖子里面的一样
http://www.itpub.net/viewthread.php?tid=931734 这个帖子里面贴出解决方法是
1. Apply the bug patch for Bug 4401119.
Please execute these steps:
Replace the '' string with the filepath to the skgfr.o object provided.
ar -X64 x $ORACLE_HOME/lib/libgeneric10.a skgfr.o(这一步用oracle用户执行完毕了)
mv $ORACLE_HOME/lib/skgfr.o $ORACLE_HOME/lib/skgfr.o.orig(我用oracle用户执行不了,提示文件不存在)
ar -X64 crl $ORACLE_HOME/lib/libgeneric10.a /skgfr.o
2. Relink the oracle executable following the instructions in this note:
Note 131321.1 How to Relink Oracle Database Software on UNIX
硬着头皮做opatch apply之后,还是和开始一样的错误提示

千问 · 2017-3-27 08:04:23

patch的read me如下
#
#WARNING: Failure to carefully read and understand these requirements may
#result in your applying a patch that can causeyour Oracle Server to
#malfunction, including interruption of service and/or loss of data.
#
#If you do not meet all of the following requirements, please log an
#iTAR, so that an Oracle Support Analyst may review your situation. The
#Oracle analyst will help you determine if this patch is suitable for you
#to apply to your system. We recommend that you avoid applying any
#temporary patch unless directed by an Oracle Support Analyst who has
#reviewed your system and determined that it is applicable.
#
#Requirements:
#
#- You must have located this patch via a Bug Database entry
#and have the exact symptoms described in the bug entry.
#
#- Your system configuration (Oracle Server version and patch
#level, OS Version) must exactly match those in the bug
#database entry - You must have NO OTHER PATCHES installed on
#your Oracle Server since the latest patch set (or base release
#x.y.z if you have no patch sets installed).
#
#- [Oracle 9.2.0.2 & above] You must have Perl 5.00503 (or later)
#installed under the ORACLE_HOME, or elsewhere within the host
#environment. OPatch is no longer included in patches as of 9.2.0.2.
#Refer to the following link for details on Perl and OPatch:
#http://metalink.oracle.com/metal ... T&p_id=189489.1
#
#- [IBM AIX O/S & Java patches for Oracle 9.2]
#In order to apply java class updates to IBM AIX based systems using
#java_131, you must update your java if you are running a version prior
#to Service Refresh build date 20030630a. This is
#necessary to fix IBM Defect#60472.
#
#To identify which java build date you are on, enter the following
#command ;
#
#> $ORACLE_HOME/jdk/bin/java -fullversion
#... example response ...
#java full version "J2RE 1.3.1 IBM AIX build ca131-20030630a"
#
#The string ends in the date format YYYYMMDD or YYYYMMDDa where 'a'
#indicates an updated release to the original build. You should always
#apply the latest AIX Java SDK 1.3.1Service Update available from IBM.
#As a minimum, the above service refresh can be found under
#APAR IY47055. The signature for the updated JVM is ca131-20030630a.
#Information on the latest available fixes, as well as how to apply
#the APARs to your AIX systems, is available at the IBM Java site.
#
#If you are running AIX 5L, you can safely ignore any comment against
#the APAR that says (AIXV43 only). The APAR is applicable to
#both AIX 4.3 and AIX 5L.
#
#Once you have updated your java installation you need to copy these
#updated files to Oracle's copies in $ORACLE_HOME/jdk.
#As the Oracle owner, simply issue the following commands;
#
#> cd /usr/java131
#> cp -fpR * $ORACLE_HOME/jdk
#
#
#If you do NOT meet these requirements, or are not certain that you meet
#these requirements, please log an iTAR requesting assistance with this
#patch and Support will make a determination about whether you should
#apply this patch.
#
#-------------------------------------------------------------------------
#Interim Patch for : 4674849
Base Bugs: 4401119
#-------------------------------------------------------------------------
#
#DATE:October 2005
#-------------------------------
#Platform Patch for : AIX5L
#Product Version #: 10.2.0.1
#Product Patched: ORACORE
#
#Bugs Fixed by this patch:
#-------------------------
# 4401119 - DATABASE DOWN WITH CONTROLFILE CORRUPTION
#
#Patch Installation Instructions:
#--------------------------------
#To apply the patch, unzip the PSE container file:
#
#p4401119_10201_AIX5L.zip
#
#Set your current directory to the directory where the patch
#is located:
#
#% cd 4674849
#
#Ensure that the directory containing the opatch script appears in
#your $PATH; then enter the following command:
#
#% opatch apply
#
#Patch Special Instructions:
#---------------------------
#Make sure all instances running under the ORACLE_HOME being patched
#are cleanly shutdown before installing this patch. Also ensure that
#the tool used to terminate the instance(s) has exited cleanly.
#
#If the Oracle inventory is not setup correctly this utility will
#fail. To check accessibility to the inventory you can use the
#command
#
#% opatch lsinventory
#
#If you have any problems installing this PSE or are not sure
#about inventory setup please call Oracle support.
#
#Patch Deinstallation Instructions:
#----------------------------------
#Use the following command:
#
#% cd 4674849
#% opatch rollback -id 4674849
#
我按照这个来做,还是会出现警告

千问 · 2017-3-27 08:04:23

if I were you and it is production.
when you were in step:
File not backed up from /oracle/10.2.0.1.0/lib/libgeneric10.a to /oracle/10.2.0.
1.0/.patch_storage/4674849_Oct_19_2005_17_13_01/files/lib/libgeneric10.a/skgfr.o
... 'ar: 0707-109 Member name skgfr.o does not exist.
'
you should stop and check error instead of Y Y Y

open a TAR right away with oracle instead of searching around...

千问 · 2017-3-27 08:04:23

谢版主，按你的提示在测试机器上成功