ADSM-L

Re: [ADSM-L] TDP Oracle failures

2009-05-29 01:44:20
Subject: Re: [ADSM-L] TDP Oracle failures
From: goc <gooooc AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 29 May 2009 07:42:03 +0200
hi,check permissions on TSM.PWD file
and if oracle user can read the file

i put all of my tdpo nodes password files in /home/oracle

//
goran

On Thu, May 28, 2009 at 3:14 PM, Matthew Large <
mlargedellteam AT googlemail DOT com> wrote:

> 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
> >>> >
> >>>
> >>>
> >>
> >>
> >>
> >
> >
>

<Prev in Thread] Current Thread [Next in Thread>