ADSM-L

Re: [ADSM-L] TDP Oracle failures

2009-05-28 10:41:57
Subject: Re: [ADSM-L] TDP Oracle failures
From: Jorge Amil <jorgeamil AT HOTMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 28 May 2009 16:41:41 +0200
 Hi,

Sometimes(i do not why) i have the same problem.

Try put 

passworddir /opt/tivoli/tsm/client/oracle/bin64

 

in the dsm.sys file

 

Kind regards

 

Jorge Garcia
> Date: Thu, 28 May 2009 14:14:43 +0100
> From: mlargedellteam AT GOOGLEMAIL DOT COM
> Subject: Re: [ADSM-L] TDP Oracle failures
> To: ADSM-L AT VM.MARIST DOT EDU
> 
> Guys, I have some new info, with a slightly different problem, I hope it can
> help:
> 
> This is the message in the rman output file:
> 
> RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at
> 05/28/2009 13:55:26
> ORA-19506: failed to create sequential file, name="688053317_5871_1.arc",
> parms=""
> ORA-27028: skgfqcre: sbtbackup returned error
> ORA-19511: Error received from media manager layer, error text:
> ANS1025E (RC137) Session rejected: Authentication failure
> 
> 
> It says authentication failure, but I'm absolutely sure the tdpoconf
> password process is working as I run the
> 
> TSM> upd no bidwp1-zp1-ora <password>
> 
> and the
> 
> UNIX> tdpoconf password <tdpo file>
> 
> with no errors. I even deleted the password file, and recreated it.
> Running 'tdpoconf showenv <tdpo file>' returns succesfully:
> 
> 
> IBM Tivoli Storage Manager for Databases:
> Data Protection for Oracle
> Version 5, Release 4, Level 1.0
> (C) Copyright IBM Corporation 1997, 2007. All rights reserved.
> 
> 
> Data Protection for Oracle Information
> Version: 5
> Release: 4
> Level: 1
> Sublevel: 0
> Platform: 64bit TDP Oracle SUN
> 
> Tivoli Storage Manager Server Information
> Server Name: TSM1-LANFREE
> Server Address: TSM1
> Server Type: Solaris SPARC
> Server Port: 1500
> Communication Method: TCP/IP
> 
> Session Information
> Owner Name:
> Node Name: BIDWP1-ZP1-ORA
> Node Type: TDP Oracle SUN
> DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
> DSMI_ORC_CONFIG:
> /usr/local/unixsup/backup/tsm/dsm.opt-SWISP012-BIDWP1-ZP1
> TDPO_OPTFILE:
> /usr/local/dba/scripts/backup/rman/tdpo/tdpo.opt-BIDWP1-BIDWP1-ZP1
> Password Directory: /opt/tivoli/tsm/client/oracle/bin64
> Compression: FALSE
> License Information: License file exists and contains valid license data.
> 
> Of course, tdpoconf password used the TDPO_OPTFILE mentioned above.
> 
> What authentication stage am I missing?
> 
> The data should go over the storage agent path, and if that was the problem
> (I do not believe it is) errors associated with the Storage Agent would
> appear instead.
> 
> Any ideas? Or elimination processes?
> 
> Much appreciated,
> 
> Matthew
> 
> 
> 
> 
> 
> On 5/26/09, Matthew Large <mlargedellteam AT googlemail DOT com> wrote:
> >
> > D'oh!
> >
> > Sorry - both the client and the server are SunOS 5.10.
> >
> > My bad
> >
> >
> > On Tue, May 26, 2009 at 10:57 AM, Matthew Large <
> > mlargedellteam AT googlemail DOT com> wrote:
> >
> >> Hi Dave,
> >>
> >> Sure - the clients are on Sun 5.10 and the servers are W2003sp2.
> >>
> >> Much appreciated
> >>
> >>
> >> On Fri, May 22, 2009 at 5:31 PM, Dave Canan <ddcanan AT gmail DOT com> 
> >> wrote:
> >>
> >>> Could you please include the client and server OS platform and level?
> >>> Thanks.
> >>>
> >>> On Fri, May 22, 2009 at 7:37 AM, Matthew Large <
> >>> mlargedellteam AT googlemail DOT com> wrote:
> >>>
> >>> > Hi,
> >>> >
> >>> > I'm unable to ascertain the cause of this backup failure - the Oracle
> >>> > errors
> >>> > point to a disk problem, but then 'inappropriate ioctl for device'
> >>> looks
> >>> > like there is a problem with the destination device, not the source.
> >>> >
> >>> > Starting backup at 22-may-2009 14:44:34
> >>> > current log archived
> >>> > allocated channel: ORA_SBT_TAPE_1
> >>> > channel ORA_SBT_TAPE_1: sid=139 devtype=SBT_TAPE
> >>> > channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0
> >>> > RMAN-00571: ===========================================================
> >>> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> >>> > RMAN-00571: ===========================================================
> >>> > RMAN-03002: failure of backup command at 05/22/2009 14:45:08
> >>> > ORA-19587: error occurred reading 512 bytes at block number 1
> >>> > ORA-27091: unable to queue I/O
> >>> > ORA-27072: File I/O error
> >>> > SVR4 Error: 25: Inappropriate ioctl for device
> >>> > Additional information: 4
> >>> > Additional information: 1
> >>> >
> >>> > Recovery Manager complete.
> >>> > + STATUS=1
> >>> >
> >>> > STATUS=1
> >>> > Fri May 22 14:45:08 BST 2009: Backup failed
> >>> > Fri May 22 14:45:08 BST 2009: Finished
> >>> > swisp012#
> >>> >
> >>> >
> >>> > Any help wholly appreciated!
> >>> >
> >>> > Cheers,
> >>> > Matthew
> >>> >
> >>>
> >>>
> >>
> >>
> >>
> >
> >

_________________________________________________________________
¡Quítate unos clics! Ahora, Internet Explorer 8 tiene todo lo que te gusta de 
Windows Live ¡Consíguelo gratis! 
http://ie8.msn.com/microsoft/internet-explorer-8/es-es/ie8.aspx