ADSM-L

Re: TDP for Oracle 8.1.7.4 & 9.2.0.6 on same server

2005-09-01 18:05:14
Subject: Re: TDP for Oracle 8.1.7.4 & 9.2.0.6 on same server
From: Sung Y Lee <sunglee AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 1 Sep 2005 18:04:14 -0400
Could it be due to bit mismatch ?

Not sure exactly if this is your situation, but I see that you are trying
to backup Oracle 32 bit  version 8.1.7 with TDP 64 bit for Oracle.
TDP for Oracle bit should match your Oracle bit.  So if you have 32 bit
oracle, use 32 bit TDP to backup and if you have 64 bit oracle, use 64 bit
TDP to backup.   I think the problem you are having might be due to using
64 bit TDP to backup 32 bit Oracle a version mismatch.

I'd like to suggest  to reconfigure  tdpo_ts91 so that it is using the
correct tdp filesets namely 32 bit.

 SESSION INFORMATION
>  Owner Name:           oracle
>  Node Name:            tdpo_ts91_ds612
>  Node Type:            TDP Oracle AIX
>  DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64 ----->
/usr/tivoli/tsm/client/api/bin
>  DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsmd_ts91.opt
---> this might be okay but i would normally prefer to put it under
seperate to keep track  /usr/tivoli/tsm/client/oracle/bin/dsmd_ts91.opt
>  TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo_ts91.opt
---> this might be okay but i would normally prefer to put it under
seperate to keep track  /usr/tivoli/tsm/client/oracle/bin/dsmd_ts91.opt
>  Password Directory:   /etc/adsm
>  Compression:          FALSE


Thanks,

Sung Y. Lee



"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/01/2005
04:51:18 PM:

> Hi all,
>       I have TDP  64 bit for Oracle AIX 5.2.0  running on an AIX 5.2
client.  I
> believe I have the symbolic links for both Oracle instances set up
> properly, and
> have done "relink all" for both successfully.  I also have permissions
set to
> 666 on the tdpoerror logs, etc. - but getting the following error onthe
Oracle
> 8.1.7 instance (Oracle 9 runs fine):
>
> RMAN-03007: retryable error occurred during execution of command:
allocate
> RMAN-07004: unhandled exception during command execution on channel ch00
> RMAN-10035: exception raised in RPC: ORA-19554: error allocating
> device, device
> type: SBT_TAPE, device name:
> ORA-19557: device error, device type: SBT_TAPE, device name:
> ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
> IBM AIX RISC System/6000 Error: 14: Bad address
> Additional information: 585
> ORA-19511: Unknown SBT error code = 585, errno = 14
> RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.
> DEVICEALLOCATE
>
> Has anyone else run into this?
> Thanks in advance if anyone has any ideas !
> Here's showenv output for both oracle instances; ts90 is 64 bit and ts91
is 32
> bit:
>
> TS90:
> svho1ds612 #  tdpoconf showenv
> -tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo_ts90.opt
>
>
> IBM Tivoli Storage Manager for Databases:
> Data Protection for Oracle
> Version 5, Release 2, Level 0.0
> (C) Copyright IBM Corporation 1997, 2003. All rights reserved.
>
>
> DATA PROTECTION FOR ORACLE INFORMATION
>  Version:              5
>  Release:              2
>  Level:                0
>  Sublevel:             0
>  Platform:             64bit TDP Oracle AIX
>
> TSM SERVER INFORMATION
>  Server Name:          TDPO_TS90_DS612
>  Server Address:       SVHO1TSM1.SUPERVALU.COM
>  Server Type:          AIX-RS/6000
>  Server Port:          1500
>  Communication Method: TCP/IP
>
> SESSION INFORMATION
>  Owner Name:
>  Node Name:            tdpo_ts90_ds612
>  Node Type:            TDP Oracle AIX
>  DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
>  DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsmd_ts90.opt
>  TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo_ts90.opt
>  Password Directory:   /etc/adsm
>  Compression:          FALSE
>
> TS91:
> svho1ds612 # tdpoconf showenv
> -tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo_ts91.opt
>
>
> IBM Tivoli Storage Manager for Databases:
> Data Protection for Oracle
> Version 5, Release 2, Level 0.0
> (C) Copyright IBM Corporation 1997, 2003. All rights reserved.
>
>
> DATA PROTECTION FOR ORACLE INFORMATION
>  Version:              5
>  Release:              2
>  Level:                0
>  Sublevel:             0
>  Platform:             64bit TDP Oracle AIX
>
> TSM SERVER INFORMATION
>  Server Name:          TDPO_TS91_DS612
>  Server Address:       SVHO1TSM1.SUPERVALU.COM
>  Server Type:          AIX-RS/6000
>  Server Port:          1500
>  Communication Method: TCP/IP
>
> SESSION INFORMATION
>  Owner Name:           oracle
>  Node Name:            tdpo_ts91_ds612
>  Node Type:            TDP Oracle AIX
>  DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
>  DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsmd_ts91.opt
>  TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo_ts91.opt
>  Password Directory:   /etc/adsm
>  Compression:          FALSE
>
> svho1ds612 #