Unsolved
This post is more than 5 years old
4 Posts
0
3294
October 14th, 2011 02:00
After upgrade Oracle server to 11.2.0.2 allocating a channel on tape crashes the database
Hi, we have a very strange issue followed a successful database upgrade on an Oracle 11gR2 RAC system comprising of two databases.
For the database not yet upgraded (OTHE) all continues to go fine, but for the one recently upgraded (ENE) happens what is specified
in the subject of this thread.
I read Note 1097466.1 on Oracle support (see attached file) that talks about a similar problem, but at this point i suppose that we should need to reinstall NMO for every node of the RAC system in order to link it to the right new oracle_home, but in that case the scenario could be the opposite because until we will decide to upgrade OTHE database (on 11.2.0.1) this will fail as happens now for ENE.
But the general question is:on WIndows how NMO knows about two differents ORACLE_HOME, hence two different release version of Oracle databases on the same box? The linking phase with oracle executables is performed only at installation time. Am i right? So in presence of two different versions of oracle executables how can this problem be solved?
This is what happens, the problem is reproducible everytime:
RMAN> ALLOCATE CHANNEL for maintenance TYPE sbt_tape PARMS='ENV=(NSR_DEBUG_FILE=C:\DBA\allocatechannel.log,NSR_DEBUG_LEVEL=2)';
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-03113: end-of-file on communication channel
Process ID: 7128
Session ID: 529 Serial number: 19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-12560: TNS:protocol adapter error
RMAN-03002: failure of allocate command at 10/12/2011 12:36:41
ORA-03114: not connected to ORACLE
Please help. We are very stumped on this matter.
Thanks a lot
Flavio
damasco71
4 Posts
0
October 14th, 2011 04:00
Thanks for the attention you gave to my post.
Yes it's a Windows system.
You don't see what is failing because is the Oracle instance that fails at the same time the channel on tape is attempted to allocate. No sbtio.log errors nor c:\dba\allocatechannel.log file generated. The Oracle instance crashes and restart everytime this action is performed (manually or through Networker backup scheduling).
Channel allocation of a disk device type is performed well
and tape device type channel allocation for the other database instance (OTHE) not yet upgradated is performed well.c:\dba>set ORACLE_SID=ene3
c:\dba>rman target / catalog rman/rman@rpdb
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Oct 14 13:24:01 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ENE (DBID=4290375529)
connected to recovery catalog database
RMAN>
RMAN> ALLOCATE CHANNEL for maintenance TYPE sbt_tape PARMS='ENV=(NSR_DEBUG_FILE=C:\DBA\allocatechannel.log,NSR_DEBUG_LEVEL=2)';
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-03113: end-of-file on communication channel
Process ID: 7128
Session ID: 529 Serial number: 19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-12560: TNS:protocol adapter error
RMAN-03002: failure of allocate command at 10/12/2011 12:36:41
ORA-03114: not connected to ORACLE
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
October 14th, 2011 04:00
11gR2 RAC on Windows? Gee... that hurts
What do you see in trace log and sbtio.log? When looking at what you posted, I do not see at all that it fails during what you have quoted. Perhaps you wish to execute rman script from CLI and send us complete output for better understanding.
Mark_Bellows
240 Posts
0
October 14th, 2011 06:00
What version of NMO are you using?
I found this information - I am not 100% sure it applies, but it looks like it might:
The problem is due to Oracle unloading libnwora.xx before the end of the "channel" process.
To fix the problem, it is required to install Oracle patch bug2257740.
Please read this information on Oracles website and see if it fits for your situation.
Mark
damasco71
4 Posts
0
October 14th, 2011 06:00
Hi we are using 5.0 version of NMO. I will verify bug 2257740 appliance on oracle support web site and will update this threar asap.
damasco71
4 Posts
0
October 14th, 2011 07:00
I checked the pertinence of bug 2257740 but on oracle support web site it's claimed to affect oracle database versions < 9.2 and be fixed in 9.2 oracle database version.This bug seems to be filled almost ten years ago and i hope Oracle haven't not re-introduced it after so many years. Sincerely i don't think so.
So my issue remains the same:
how on WIndows NMO knows about two differents ORACLE_HOME, hence two different release version of Oracle databases on the same box? The linking phase with oracle executables is performed only at installation time. Am i right? So in presence of two different versions of oracle executables how can this problem be solved?
Mark_Bellows
240 Posts
0
October 14th, 2011 09:00
Hello again!
Please review these two articles and see if they provide you the information you are looking for:
Describe the various allowed coexistences of NetWorker Module for Oracle (NMO), and Business Suite module for Oracle (BMO)
http://solutions.emc.com/EMCSolutionView.asp?id=esg65434&usertype=C
How to backup multiple Oracle instances from one client?
http://solutions.emc.com/EMCSolutionView.asp?id=esg56667&usertype=C
Refers to Oracle 8i, but the principle looks the same.
Let me know if this answers your questions!
Mark