ITPUB??ì3
12月微软Hyper-V虚拟化沙龙主题征集
ITPUB论坛 » Oracle专题深入讨论 » oracle错误!复制无法执行了!

标题: oracle错误!复制无法执行了!
离线 dalimao
初级会员



精华贴数 0
个人空间 0
技术积分 59 (24865)
社区积分 2 (26851)
注册日期 2005-3-2
论坛徽章:0
      
      

发表于 2008-9-2 10:06 
oracle错误!复制无法执行了!

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
CORE    10.2.0.1.0      Production
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的高级复制也无法进行下去了,事务一直堆在那里,推行不下去,大侠们有走过路过的过来看看吧!


只看该作者    顶部
离线 dalimao
初级会员



精华贴数 0
个人空间 0
技术积分 59 (24865)
社区积分 2 (26851)
注册日期 2005-3-2
论坛徽章:0
      
      

发表于 2008-9-2 10:10 
如果是第一个补丁没有打好造成的后面连续错误,不知道哪里有问题,看错误提示不太明白
打第一个补丁整个过程如下
$ 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


只看该作者    顶部
离线 Yong Huang
版主



精华贴数 2
个人空间 0
技术积分 4382 (324)
社区积分 129 (3072)
注册日期 2001-10-9
论坛徽章:6
现任管理团队成员ITPUB元老管理团队2006纪念徽章会员2006贡献徽章授权会员2008年新春纪念徽章
      

发表于 2008-9-2 11:24 
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


只看该作者    顶部
离线 dalimao
初级会员



精华贴数 0
个人空间 0
技术积分 59 (24865)
社区积分 2 (26851)
注册日期 2005-3-2
论坛徽章:0
      
      

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


只看该作者    顶部
离线 Yong Huang
版主



精华贴数 2
个人空间 0
技术积分 4382 (324)
社区积分 129 (3072)
注册日期 2001-10-9
论坛徽章:6
现任管理团队成员ITPUB元老管理团队2006纪念徽章会员2006贡献徽章授权会员2008年新春纪念徽章
      

发表于 2008-9-3 03:46 


QUOTE:
原帖由 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


只看该作者    顶部
离线 dalimao
初级会员



精华贴数 0
个人空间 0
技术积分 59 (24865)
社区积分 2 (26851)
注册日期 2005-3-2
论坛徽章:0
      
      

发表于 2008-9-3 09:06 
感谢版主回帖!
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 '<patchlocation>' 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 <patchlocation>/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之后,还是和开始一样的错误提示


只看该作者    顶部
离线 dalimao
初级会员



精华贴数 0
个人空间 0
技术积分 59 (24865)
社区积分 2 (26851)
注册日期 2005-3-2
论坛徽章:0
      
      

发表于 2008-9-3 09:09 
patch的read me如下
#
#  WARNING: Failure to carefully read and understand these requirements may
#  result in your applying a patch that can cause  your 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.1  Service 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
#

我按照这个来做,还是会出现警告


只看该作者    顶部
离线 netbanker
版主


精华贴数 5
个人空间 0
技术积分 12670 (94)
社区积分 2511 (529)
注册日期 2001-9-24
论坛徽章:12
现任管理团队成员ITPUB元老管理团队2006纪念徽章会员2007贡献徽章会员2006贡献徽章授权会员
生肖徽章2007版:马2008北京奥运纪念徽章:射箭2008年新春纪念徽章生肖徽章2007版:鼠ITPUB新首页上线纪念徽章生肖徽章:虎

发表于 2008-9-4 01:18 
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...


__________________
Have a nice day!MSN: stevenzhaoyi@hotmail.com
只看该作者    顶部
离线 dalimao
初级会员



精华贴数 0
个人空间 0
技术积分 59 (24865)
社区积分 2 (26851)
注册日期 2005-3-2
论坛徽章:0
      
      

发表于 2008-9-14 06:13 
谢版主,按你的提示在测试机器上成功


只看该作者    顶部
 
    

相关内容


CopyRight 1999-2006 itpub.net All Right Reserved.
北京皓辰广域网络信息技术有限公司. 版权所有
E-mail:Webmaster@itpub.net
京ICP证:010037号 联系我们 法律顾问