ADSM-L

Re: [ADSM-L] TDP Oracle failures

2009-05-28 09:58:20
Subject: Re: [ADSM-L] TDP Oracle failures
From: David McClelland <david.mcclelland AT NETWORKC.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 28 May 2009 14:57:08 +0100
Hi Matt,

Does the TSM Server activity log reveal anything - any of the associated
nodes attempting to log in by being denied?

Also, do you have any 'special characters' in the password? I understand
this has caused problems in the past.

And, of course - has this TDP client ever worked? Or has some event, known
or unknown, stopped it working from a previously healthy config?

Cheers,

/David Mc
London, UK


http://www.linkedin.com/in/dmcclelland


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Matthew Large
Sent: 28 May 2009 14:15
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDP Oracle failures

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.39/2134 - Release Date: 05/27/09
18:21:00