Re: Separating the Oracle TDP Cfg - from the OS cfg ..
Hello Charles, DP Oracle relies on the dsm.sys file in the TSM API bin directory (/usr/tivoli/tsm/client/api/bin64 on AIX, for instance). So the answer to your question really depends on what you mean by base dsm.sysif by base dsm.sys you mean the BA Client, then yes, DP Oracle can use a different dsm.sys file. Regards, Neil Rasmussen Tivoli Storage Manager Client Development IBM Corporation Almaden Research Center 650 Harry Road San Jose, CA 95120-6099 rasmu...@us.ibm.com From: Hart, Charles A charles_h...@uhc.com To: ADSM-L@VM.MARIST.EDU Date: 06/23/2009 12:47 PM Subject: Separating the Oracle TDP Cfg - from the OS cfg .. Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU We are wondering if its possible to separate the TDP Oracle Cfg so it uses its own dsm.sys instead of the base dsm.sys The reason we ask is our Oracle DBA's use TSM to clone DB's and not all our Unix team member know how to cfg the TDP client and all the stanza's associated with DB Cloning (Backup Restore) I looked in the TDP Redbook, didn't really see a way. Does anyone have a good idea to have a dsm.sys just for OS Backup and Dsm.sys for the Oracle folks? Thank you all for being so helpful! This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
Re: TSM for Oracle
Hi David, From the TSM Side you can run 'tdposync' utility that is included with the DP Oracle installation. This will run a comparison between the RMAN catalog and TSM Server showing orphaned backups left on the TSM Server. This utility also provides the ability to delete these orphaned backups. Before using this utility, you should really take the opportunity to read the User's Guide and understand the implications of running such utility as the deletions from TSM are final. Regards, Neil Rasmussen Tivoli Storage Manager Client Development IBM Corporation Almaden Research Center 650 Harry Road rasmu...@us.ibm.com From: David E Ehresman deehr...@louisville.edu To: ADSM-L@VM.MARIST.EDU Date: 06/04/2009 07:14 AM Subject: Re: TSM for Oracle Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU I understand that rman CAN automatically delete old backups. As a TSM Admin, I am being asked to verify that rman IS deleting old backups. Is there any way to verify such from the TSM side? David Grigori Solonovitch g.solonovi...@bkme.com 6/4/2009 1:42 AM I am using RMAN 9i/10g with TSM 5.5 successfully. RMAN manages data expiry for Oracle databases completely without any manual intervention, but some configuration efforts are required: 1) dedicated TSM node for Oracle data with management class and copy group; 2) set vere=no limit, verd=0 rete=N ret=0 in copy group, where N is a period of time in days to be able to recover database (I am using 31 day); 3) for each database set retention period in RMAN by CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF N DAYS, where N equal to N in copy group; 4) run full database backup periodically. I am running full database backup twice per month with retention period 31 days. All other days run incremental backup for database; 5) perform delete noprompt obsolete from RMAN backup script; 6) schedule at proper time crosscheck backup + delete noprompt expired backup + delete noprompt obsolete daily for each database (just not to delay backups); 7) schedule crosscheck archivelog all + delete noprompt expired archivelog all daily for each database (just not to delay backups) Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of David E Ehresman Sent: Wednesday, June 03, 2009 8:59 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM for Oracle Do can a TSM Admin verify that the rman clients are deleting their old TSM for Oracle backups? David Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME.
Re: Removing Oracle TDP data from TSM (rebinding data to new MC's?)
As a starting point First check to make sure the TSM node for your Oracle backups have backdel=yes...in the past Oracle/RMAN would remove the backups from the RMAN catalog prior to checking to see if the TSM delete operation was actually successful...I believe Oracle has changed this behavior in later releases. You can use TDPOSYNC to verify what is out of sync. This tool looks to see what TSM backups exist on the TSM Server that Oracle/RMAN is not aware of and allows you to remove these backups from the TSM Server. Be careful when using this utility, especially if you manage more than one Oracle node on the TSM Server, as TDPOSYNC may report many objects out-of-sync when in reality you may not have queried against the correct DB Instance in RMAN. Regards, Neil Rasmussen Tivoli Storage Manager Client Development IBM Corporation Almaden Research Center 650 Harry Road San Jose, CA 95120-6099 Phone: 408.927.2206 (T/L: 457-2206) [EMAIL PROTECTED] Stefan Folkerts [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 04/03/2008 07:29 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Removing Oracle TDP data from TSM (rebinding data to new MC's?) Hi guy's, I am running into a strange but pretty serieus problem at one of our customers. Capacity is at the limit and I need to fix this issue fast but am at a los at the moment.. There were some wrong policy domains settings that were used to backup Oracle TDP data. I have fixed this issue and put the deleted versions and day's to 0 in the MC. The Oracle DBA tells me rman is deleting it's old data, but I still see data in the system when I look with 'show versions node *', data that should have been removed a long time ago (months ago that is). I suspect this has something to do with bindings to wrong MC's, the question is can this be true? And if so, how can I fix this? Or is the DBA wrong and not deleting the old data correctly? Please advise. Regards, Stefan
Re: TDP-Oracle+RMAN
Every Oracle backuppiece starts a new TSM session. Look at the RMAN's User Guide on how to use the 'filesperset' for starters. There are a few other parameters that you can use in RMAN to help tune your backups. Regards, Neil Rasmussen Tivoli Storage Manager Client Development IBM Corporation Almaden Research Center 650 Harry Road San Jose, CA 95120-6099 Phone: 408.927.2206 (T/L: 457-2206) [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 02/21/2008 11:23 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDP-Oracle+RMAN Hi, recently I reviewed backup sessions of some Oracle DB servers (RMAN). Our DB servers have about 100-400 sessions a day. Can someone explain in which cases there are new sessions opened by TDPO/RMAN and how to reduce session usage. I've investigated actlog and there were many many session open/close operations within one minute. I think that might stress the backup server unnecessarily. Thanks Regards, ..--Egonle More new features than ever. Check out the new AIM(R) Mail ! - http://webmail.aim.com
Re: TSM API error
Hello Avy, rc 106 means that your Error Log is not writable by the current application...meaning that, if one already exists it was probably created by root and the Application using the API is a non-root user, or the Error Log is not created yet but your Application using the API does not have write permission to the directory where you Error Log is trying to be created. Regards, Neil Rasmussen Tivoli Storage Manager Client Development IBM Corporation Almaden Research Center 650 Harry Road San Jose, CA 95120-6099 Phone: 408.927.2206 (T/L: 457-2206) [EMAIL PROTECTED] Avy Wong [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/25/2007 12:45 PM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TSM API error Hello, I encounter error, Error: 9 establishing TSM API session . Unknown TSM API error. when I update/reinstall TSM scheduler. The services kicks off on the client side no problem, but when I kick off a session from the TSM server to NodeXXX, there is no response. I see new_ImageObject plugin could not be initialized rc 106, error in the dsmerror.log. Before I go and do a reboot, I thought I'll ask around to see if anyone has the same problem before and if there is a fix for that. Many thanks. dsmerror.log: 10/25/2007 14:26:33 ANS1814E Unable to start the scheduled event '0200_SQL_AMBK' 10/25/2007 14:26:33 ANS1815E Either the window has elapsed or the schedule has been deleted 10/25/2007 14:28:33 ANS1909E The scheduled command failed. 10/25/2007 14:28:33 ANS1512E Scheduled event '0200_SQL_AMBK' failed. Return code = 1. 10/25/2007 14:32:36 new_ImageObject: plugin could not be initialized rc 106 Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860)862-8164 (cell) (860)961-6976
Re: tdp for oracle on win2k3
DP Oracle needs to match the bit architecture of the Oracle database. Please verify that the DP Oracle package you are installing is indeed 32bit package if your Oracle is 32bit. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Remco Post [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 07/06/2007 02:00 PM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject tdp for oracle on win2k3 Hi all, one of my users has 32 bits oracle 9i running on a 64 bits windows 2003 server. Now, the installer insists that he needs the 64 bits tdpo, but of course, rman requires (I believe) a 32 bits tdpo, am I correct? What does he need? -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
Re: TDPO and encryption
Encryption is supported through the TSM API starting at 5.3. To set it up with DP Oracle/RMAN you need to make the following changes in your dsm.sys for the DP Oracle stanza, for instance: enableclientencryptkey yes encryptiontype AES128 include.encrypt /adsmorc/.../* This assumes that your TDPO_FS is 'adsmorc' (the default) and that you want all Oracle backups to be encrypted. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Hans Christian Riksheim [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/22/2007 02:24 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDPO and encryption Hi, does anyone have any experience with rman/tdpo and encryption? I have not found any detailed information on how to implement it and the redbook from 2001(Backing up Oracle using TSM) does not mention it. I have learned that there are two ways of doing it: Client handles encryption through the API. Here I have not seen how to set this up with RMAN. API handles it transparently and stores the key on the TSM-server. I haven't fully understood the security implications of this method. I don't understand how this method can be as secure as for example BA-encryption where the key is held by the administrator of the client. Anyway, any tip on how to do it or pointers to information is much appreciated. Best regards Hans Chr. Riksheim htmlbodybr /br /br /font face=Arial size=1hrThis email originates from Steria AS, Biskop Gunnerus' gate 14a, N-0051 OSLO, http://www.steria.no. This email and any attachments may contain confidential/intellectual property/copyright information and is only for the use of the addressee(s). You are prohibited from copying, forwarding, disclosing, saving or otherwise using it in any way if you are not the addressee(s) or responsible for delivery. If you receive this email by mistake, please advise the sender and cancel it immediately. Steria may monitor the content of emails within its network to ensure compliance with its policies and procedures. Any email is susceptible to alteration and its integrity cannot be assured. Steria shall not be liable if the message is altered, modified, falsified, or even edited./font/body/html
Re: Running both 32- and 64-bit TDPOracle on same machine
Yes, this configuration is possible and supported. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] William Boyer [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/22/2007 11:55 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Running both 32- and 64-bit TDPOracle on same machine I have a client with 2 versions of Oracle on the same Solaris machine. They want to be able to do TSM backups using RMAN and TDP for both instances. Solaris 5.8 TSM Server 5.2.9 on AIX 5.2ML9 TSM Client 5.2.2.0 TDPO 32-bit 5.2.0 Oracle 32 bit version = 9.2.0.6 ORACLE_HOME Path = /oraapps/ipocdb/9.2.0 Oracle 64 bit version = 10.2.0.1.0 ORACLE_HOME = /oradb/oracle/10.2.0 Is it possible to install and run a TDPO 64-bit 5.3? As long as I install the appropriate 64-bit TSM API. The package names are different, and they install in different directories (/bin and /bin64). Even looks like the libobk.so goes in different places for creating the link. Bill Boyer Select * from USERS where CLUE0 0 rows returned
Re: tdposync on Linux
Hi Rich, The 'tdposync' utility is a component to the DP Oracle package...meaning, that you have to select it to install it. The package you need is: TDP-Oracle.Utilility-5.3.3-0 Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Richard Mochnaczewski [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 02/15/2007 08:11 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject tdposync on Linux Hi *, Does this utility exist in Linux ? My AIX boxes have this utility installed but it seems to be missing from my Linux boxes. Rich
Re: Oracle Agent help
The RMAN script for the backup says backup backupset all;I have not
had time to research this command (to see what it is supposed to do) but I
do not think you are backing up your whole Oracle database with this
command. Try doing a backup database and then run your restore script.
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
Gill, Geoffrey L. [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
11/22/2006 08:19 AM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Oracle Agent help
Admittedly I have very limited knowledge on this subject so I hope you
can pardon my ignorance while I ask some questions. This is something we
(the dbas) have not used for some years and are only now trying to get
working again. The TSM server is on AIX 5.3 TSM 5.3.3.0, and this
particular client is at 5.3.4 on HP-UX Itanium. The agent level they
installed is 5.2.3.0 from the looks of the info they sent me, yet they
say they just got it from IBM so I am confused since I have 5.3.3. for
them if they would have just talked to me. Perhaps the best thing to do
is upgrade but I think it will not fix the errors since it is more than
likely some sort of config problem to start. The dbas here now have no
experience with this product, and although he says hes configured it
properly some things stick out at me as being wrong based on some of the
email I have saved from the group.
To start I have created a management class and node specifically for
this client. It is not in its own domain so it is not the default
class, and I dont think that is a problem, however I am guessing the
tdpo.opt needs this information, see below, but they have that section
commented out and the names listed are not the one I created. Should
this be fixed and is there something else missing from the file. The
dsm.opt for the client only has the servername and the dsm.sys a bit
more but not sure if those entries are relevant so they are not listed
here.
Hopefully someone can decipher all of this and help me out.
DSMI_ORC_CONFIG/opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/logs
TDPO_FSoracle10gdb
TDPO_NODE o-cppsdbd1
TDPO_OWNER oracle
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1
TDPO_NUM_FMT 1
TDPO_TIME_FMT 1
* TDPO_MGMT_CLASS_2 mgmtclass2
* TDPO_MGMT_CLASS_3 mgmtclass3
* TDPO_MGMT_CLASS_4 mgmtclass4
They say they ran a backup, and from a TSM perspective what I see is one
filespace, oracle10gdb, within TSM which seems to be 4 files.
RMAN run
2 {
3 ALLOCATE CHANNEL t1 TYPE 'sbt_tape' parms
4 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
5 backup backupset all;
6 }
allocated channel: t1
channel t1: sid=504 instance=PSHDMO1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.2.3.0
Starting backup at 06-NOV-06
input backupset count=125 stamp=605788428 creation_time=06-NOV-06
channel t1: starting piece 1 at 06-NOV-06
channel t1: backup piece
/d1/app/oracle/product/cur_rev/db/dbs/3ti1n68c_1_1
piece handle=3ti1n68c_1_2 comment=API Version 2.0,MMS Version 5.2.3.0
channel t1: finished piece 1 at 06-NOV-06
channel t1: backup set complete, elapsed time: 00:00:25
Finished backup at 06-NOV-06
released channel: t1
A restore however failed and below is most of what was in the logs. I
have cut out numerous data file lines between 5 and 123 as they were
all the same.
RMAN run
2 {
3 ALLOCATE CHANNEL t1 TYPE 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4 RESTORE DATABASE VALIDATE;
5 }
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=500 instance=PSHDMO1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.2.3.0
Starting restore at 10-NOV-06
data file 5 will be created automatically during restore operation
data file 123 will be created automatically during restore operation
released channel: t1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure of restore command at 11/10/2006 16:58:09
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Thanks and Happy Thanksgiving to all who celebrate,
Geoff Gill
TSM Administrator
PeopleSoft Sr. Systems Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]
Re: setting up TDPO / newbie help
2516 means that your agents license file is corrupt
(/usr/tivoli/tsm/client/oracle/bin64/agent.lic). You may need to reinstall
the product to refresh the license file.
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
goc [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
11/15/2006 07:43 AM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: setting up TDPO / newbie help
thanks all, i managed the error log problem , now let's move to something
completely new :-)
log
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: SDPSI (DBID=2754641404)
using target database controlfile instead of recovery catalog
RMAN RUN
2 {
3 ALLOCATE CHANNEL t1 TYPE sbt_tape
PARMS='ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4 BACKUP CURRENT CONTROLFILE;
5 BACKUP TABLESPACE TOOLS;
6 }
7
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03009: failure of allocate command on t1 channel at 11/15/2006
16:39:52
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 2516: System call error number 2516.
Recovery Manager complete.
i can smell some relinking of oracle , do you ? (i've found this idea on
google)
BIG thanks.
- Original Message -
From: William Boyer [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Wednesday, November 15, 2006 4:39 PM
Subject: Re: setting up TDPO / newbie help
Just went through this on a TDP Informix installcheck the
DSMERROR.LOG
file. The new 5.3 client REQUIRES a write-able error log
location. If you have ERRORLOGNAME specified in the DSM.SYS, remove it
and
add a DSM_LOG environment varilable for the user.
Bill Boyer
Law of Cybernetic Entomology - There is always another bug. - ??
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
goc
Sent: Wednesday, November 15, 2006 10:15 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: setting up TDPO / newbie help
thanks a lot, as i figured out you are right and i found what you meant
with
106 errno
0106 EDSM_RC_ACCESS_DENIED
Explanation: The specified file is being used by another process. You
tried to read from or write to a file that is currently being
used by another process.
System Action: Processing stopped.
User Response: Ensure that you specified the correct file or directory
name, correct the permissions, or specify a new location.
what file ?
what process ?
what permissions ?
so many questions. thanks again
- Original Message -
From: Richard Sims [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Wednesday, November 15, 2006 4:06 PM
Subject: Re: setting up TDPO / newbie help
On Nov 15, 2006, at 9:12 AM, goc wrote:
...
3 ALLOCATE CHANNEL d1 TYPE disk
...
ORA-19502: write error on file 04i2fdof_1_1, blockno 381953
(blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect IBM
AIX RISC System/6000 Error: 28: No space left on device
Goran -
I'm no RMAN expert, but it looks to me like you managed to configure
it to back up to local disk, rather than to the TSM server via the SBT
API. From what I understand, your messages should have like allocate
channel t1 type 'sbt_tape'. Have a look at the redbook Backing Up
Oracle using Tivoli Storage Management for background.
And do a 'df' on your AIX system to look for a full disk. An RMAN
expert will probably post more.
Richard Sims
Re: TDP for Oracle license error
Chip, Not at all. Since you are installing v5.3.3 for the first time, you need to make sure that you get the base install from a CD or from Passport Advantage...it is these installation packages that contain the agent.lic file. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/25/2006 06:36 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: TDP for Oracle license error OK. You recently suggested that I install v5.3.3, but I need to install the v5.3.0 first, then upgrade? Sorry for my confusion... -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Neil Rasmussen Sent: Tuesday, October 24, 2006 5:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle license error Chip, ELA is not related to the 2512 return code. The ELA is only there as an accept/not accept option during the installation phase of DP Oracle - if you accept it then the product installs, otherwise the installation exits without installing. The return code of 2512 means that DP Oracle could not open /usr/tivoli/tsm/client/oracle/bin64/agent.lic file. So, I need to ask weather you obtained your DP Oracle code base from a CD or the Passport Advantage site or did you use the FTP site to download your installation package? The short of it is, if you installed from the FTP site then your package will not contain the agent.lic file. The was discussion on this just this morning on ADSM-Lyou will need the base package from either a CD or from the Passport Advantage site. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/24/2006 02:55 PM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle license error TDP client v5.3.3 Server v5.3.1.2 We installed the ELA, but it does not show up in oracle/bin64 (???) Everything was seemingly done by the book, but obviously something is amiss. Opinions/facts? I tried uninstalling/reinstalling the ELA. using target database controlfile instead of recovery catalog RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on t1 channel at 10/24/2006 15:30:28 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer IBM AIX RISC System/6000 Error: 2512: System call error number 2512. God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: TDP for Oracle license error
Chip, ELA is not related to the 2512 return code. The ELA is only there as an accept/not accept option during the installation phase of DP Oracle - if you accept it then the product installs, otherwise the installation exits without installing. The return code of 2512 means that DP Oracle could not open /usr/tivoli/tsm/client/oracle/bin64/agent.lic file. So, I need to ask weather you obtained your DP Oracle code base from a CD or the Passport Advantage site or did you use the FTP site to download your installation package? The short of it is, if you installed from the FTP site then your package will not contain the agent.lic file. The was discussion on this just this morning on ADSM-Lyou will need the base package from either a CD or from the Passport Advantage site. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/24/2006 02:55 PM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle license error TDP client v5.3.3 Server v5.3.1.2 We installed the ELA, but it does not show up in oracle/bin64 (???) Everything was seemingly done by the book, but obviously something is amiss. Opinions/facts? I tried uninstalling/reinstalling the ELA. using target database controlfile instead of recovery catalog RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on t1 channel at 10/24/2006 15:30:28 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer IBM AIX RISC System/6000 Error: 2512: System call error number 2512. God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: TDP for Oracle on AIX...configuration
Larry, Before creating your password you should note two things: there is a license file error - make sure that /usr/tivoli/tsm/client/oracle/bin64/agent.lic exists. If not, you need to use the installation CD and re-install DP Oracle (or atleast the license portion). Secondly, notice where your password directory is pointing /usr/tivoli/tsm/client/api/bin64, just make sure that this is what you intended. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Lawrence Clark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/23/2006 07:56 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: TDP for Oracle on AIX...configuration [EMAIL PROTECTED] 10/23/06 10:20 AM Your dsm.opt file should have only the following entry : SErvername backup Yes, that was how I had it originallyI just set it back to that and I'm back to my original problem: Data Protection for Oracle Information Version: 5 Release: 3 Level:3 Sublevel: 0 Platform: 64bit TDP Oracle AIX Tivoli Storage Manager Server Information Server Name: BACKUP Server Address: 172.30.3.86 Communication Method: TCP/IP Session Information Owner Name: oracle Node Name:TDP_ORA DSMI_DIR: /usr/tivoli/tsm/client/api/bin64 DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/api/bin64/dsm.opt TDPO_OPTFILE: /home/oracle/tsm/tdpo.opt Password Directory: /usr/tivoli/tsm/client/api/bin64 Compression: FALSE License Information: License File Error - see tdpoerror.log for details ANS0282E (RC168) Password file is not available. 10/23/06 10:53:29 ANS0282E Password file is not available. Guillaume Gilbert Storage Architect Storage Group, Sun Microsystems [EMAIL PROTECTED] 514.866.8876 Office 514.290.6526 Cell -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: October 23, 2006 10:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle on AIX...configuration changed the tdpo.opt to point to dsm.opt...same error: ANS0220E (RC400) An invalid option was found during option parsing. [dba2dbms] /home/oracle/tsm # 10/23/06 10:03:38 ANS1036S Invalid option 'COMMMETHOD' found in options file ' /usr/tivoli/tsm/client/api/bin64/dsm.opt' at line number : 2 Invalid entry : 'COMMmethod TCPip' 10/23/06 10:03:38 ANS1038S Invalid option specified OPTIONS FILE: dsm.opt SErvername backup COMMmethod TCPip TCPPort1500 TCPServeraddress 172.30.3.86 passwordaccess prompt mailprog /bin/mail root errorlogretention 7 nodename TDP_DBA2DBMS dsm.sys: SErvername backup * COMMMETHOD TCPIP * TCPPort1500 TCPServeraddress 172.30.3.86 passwordaccess prompt * mailprog /bin/mail root * errorlogretention 7 nodename TDP_DBA2DBMS tdpo.opt file: * DSMI_ORC_CONFIG/usr/tivoli/tsm/client/api/bin64/dsm.opt DSMI_LOG /home/oracle/tsm TDPO_FSFS_TDPDBA2 TDPO_NODE TDP_ORA TDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/api/bin64 *TDPO_DATE_FMT 1 *TDPO_NUM_FMT 1 *TDPO_TIME_FMT 1 *TDPO_MGMT_CLASS_2 mgmtclass2 *TDPO_MGMT_CLASS_3 mgmtclass3 [EMAIL PROTECTED] 10/23/06 9:45 AM You should not point to a dsm.sys file. You should point to a dsm.opt file which then will point to the dsm.sys. Guillaume Gilbert Storage Architect Storage Group, Sun Microsystems [EMAIL PROTECTED] 514.866.8876 Office 514.290.6526 Cell -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: October 23, 2006 09:34 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle on AIX...configuration Yes, I went through that Friday. Eliminate one option and the following one shows as an error. The only one it takes is server For example: change the dsm.sys to: SErvername backup * COMMMETHOD TCPIP TCPPort1500 TCPServeraddress 172.30.3.86 passwordaccess prompt * mailprog /bin/mail root * errorlogretention 7 nodename TDP_DBA2DBMS and I get: ANS0220E (RC400) An invalid option was found during option parsing. [dba2dbms] /home/oracle/tsm # in the tdpoerror.log it shows: 10/23/06 09:22:33 ANS1038S Invalid option specified 10/23/06 09:29:47 ANS1036S Invalid option 'TCPPORT' found in options file '/us r/tivoli/tsm/client/api/bin64/dsm.sys' at line number : 3 Invalid entry : 'TCPPort1500' 10/23/06 09:29:47 ANS1038S Invalid option specified Commenting out the TCPPORT option, I then get: 10/23/06 09:29:47 ANS1038S Invalid option specified 10/23/06 09:32:21 ANS1036S Invalid
Re: TDP for Oracle filesets
Chip, You will want the following: tivoli.tsm.client.api.aix51.64bit ALL tivoli.tsm.client.oracle.64bit ALL tivoli.tsm.client.oracle.tools.aix51.64bit ALL However, I just noticed from your first email that you are using Oracle 10g. I would recommend that you upgrade to Data Protection for Oracle 5.3.3 as it contains some APAR fixes that you will need when running Oracle 10g. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/12/2006 11:04 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: TDP for Oracle filesets Here is what I am seeing available to install. Thanks! * tivoli.tsm.client.api.aix43.32bit ALL * *+ 5.1.5.0 TSM Client - Application Programming Interface * * * * tivoli.tsm.client.api.aix43.64bit ALL * *+ 5.1.5.0 TSM Client - 64 Bit Application Programming Interface * * * * tivoli.tsm.client.api.aix51.64bit ALL * *+ 5.1.5.0 TSM Client - 64 Bit Application Programming Interface * * tivoli.tsm.client.books ALL * *+ 5.1.5.0 TSM BOOKS - Using UNIX Clients - HTML Format * *+ 5.1.5.0 TSM BOOKS - Using UNIX Clients - PDF Format * * * * tivoli.tsm.client.oracle.32bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle on AIX * * * * tivoli.tsm.client.oracle.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle on AIX * * tivoli.tsm.client.oracle.aix51.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle on AIX * * * * tivoli.tsm.client.oracle.books ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle - HTML F * *+ 5.2.0.0 Tivoli Storage Manager for Databases - Oracle - PDF Format * * * * tivoli.tsm.client.oracle.tools.32bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle Tools on * * tivoli.tsm.client.oracle.tools.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle Tools on * * * * tivoli.tsm.client.oracle.tools.aix51.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle Tools on * -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Neil Rasmussen Sent: Thursday, October 12, 2006 10:50 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle filesets Chip, I am not clear as to which filesets you are seeing, but basically DP Oracle requires the ELA, the TSM API, and the DP Oracle Utilities as well as the DP Oracle fileset itself. If you could list the filesets you are seeing from smitty, I could be a little more specific in my answer. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/12/2006 06:55 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle filesets What filesets would I need to install from physical media, TDP for Oracle 5.3.1, if we are running Oracle 10g on AIX v5.3, 64-bit? When running smitty install, there were many different valid-looking filesets, and I became confused... :-) God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: TDP for Oracle filesets
Chip, I am not clear as to which filesets you are seeing, but basically DP Oracle requires the ELA, the TSM API, and the DP Oracle Utilities as well as the DP Oracle fileset itself. If you could list the filesets you are seeing from smitty, I could be a little more specific in my answer. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/12/2006 06:55 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle filesets What filesets would I need to install from physical media, TDP for Oracle 5.3.1, if we are running Oracle 10g on AIX v5.3, 64-bit? When running smitty install, there were many different valid-looking filesets, and I became confused... :-) God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: Encryption in API
Fred, Encrypting Oracle databases with DP Oracle is accomplished in very much the same fashion. The twist? In order to exploit the include.encrypt statements you will have to rely on the 'format' statement in the RMAN scripts that you use to backup your Oracle database. Using the 'format' statement allows you to prepend/append characters (strings) to each backup piece. For instance, you may have an RMAN script for each database, say DB1 and DB2, then prepend these strings to each 'format' statement in your RMAN script. Then you can use these identifiers in your include.encrypt statements in your dsm.opt file. I can give you explicit examples if you need them. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] fred johanson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 08/28/2006 07:00 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: Encryption in API Thanks Del. I suspected that is the way it works for SQL. I can't surmise how to limit how much ORACLE is encrypted. At 08:44 AM 8/28/2006 -0400, you wrote: Fred, Go to: http://www.ibm.com/us/ Search for: Encrypting Data Protection for SQL Backups (include the double quotes around the Search for text) Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/25/2006 01:07:23 PM: Since TDP for ORACLE and MSSQL use the API, I should be able to encrypt some or all of DB backups we do. Since SQL generates the directory name for the backup, how do we determine which is which to include or exclude selected DBs on a particular client? We have one client with about 75 DBs on it and not all should be encrypted. Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: Encryption in API
Fred,
Here is the basic idea: Let's say that you have 3 databases, DB1 and DB2
and DB3, and you only want to encrypt data for DB2 and DB3. You would need
to have an RMAN script for each database. Data Proctection for Oracle can
share the same dsm.opt among these databases. Assuming your TDPO_FS is
/adsmorc here is what it might look like:
RMAN script for DB1:
run
{
allocate channel t1 type 'sbt_tape';
backup
format 'DB1_%d_%t_%s_%p'
(database);
}
RMAN script for DB2:
run
{
allocate channel t1 type 'sbt_tape';
backup
format 'DB2_%d_%t_%s_%p'
(database);
}
RMAN script for DB3:
run
{
allocate channel t1 type 'sbt_tape';
backup
format 'DB3_%d_%t_%s_%p'
(database);
}
**
dsm.opt
include.encrypt /adsmorc/.../DB2_*
include.encrypt /adsmorc/.../DB3_*
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
fred johanson [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
08/28/2006 07:54 AM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Encryption in API
Thanks Neil, explicit examples would mean I don't lose anything in
transmission to the ORACLE DBAs.
At 07:40 AM 8/28/2006 -0700, you wrote:
Fred,
Encrypting Oracle databases with DP Oracle is accomplished in very much
the same fashion. The twist? In order to exploit the include.encrypt
statements you will have to rely on the 'format' statement in the RMAN
scripts that you use to backup your Oracle database. Using the 'format'
statement allows you to prepend/append characters (strings) to each
backup
piece. For instance, you may have an RMAN script for each database, say
DB1 and DB2, then prepend these strings to each 'format' statement in
your
RMAN script. Then you can use these identifiers in your include.encrypt
statements in your dsm.opt file.
I can give you explicit examples if you need them.
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
fred johanson [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
08/28/2006 07:00 AM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Encryption in API
Thanks Del. I suspected that is the way it works for SQL. I can't
surmise
how to limit how much ORACLE is encrypted.
At 08:44 AM 8/28/2006 -0400, you wrote:
Fred,
Go to:
http://www.ibm.com/us/
Search for:
Encrypting Data Protection for SQL Backups
(include the double quotes around the Search for text)
Del
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/25/2006
01:07:23 PM:
Since TDP for ORACLE and MSSQL use the API, I should be able to
encrypt
some or all of DB backups we do. Since SQL generates the directory
name
for the backup, how do we determine which is which to include or
exclude
selected DBs on a particular client? We have one client with about
75
DBs
on it and not all should be encrypted.
Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464
Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464
Re: TSM for DB
Yes, 5.2 is the latest as of nowstay tuned for updates coming soon. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] David E Ehresman [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 06/14/2006 10:02 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TSM for DB I just downloaded from Passport Advantage TSM for DB 5.3. What I got, AIX smitty ids as TSM for DB 5.2.0.0. Is this the most uptodate TSM for DB (for oracle on aix)?
Re: Trying to use TSM API
Mike,
Here is whole message explanation to what you are seeing:
2065 E DSM_RC_WRONG_VERSION_PARM
Explanation: The caller's structure version is different than the ITSM
library version.
System Action: The system returns to the calling procedure.
User Response: Ensure that the stVersion field is set with the value in
the header file. Recompile the application with the latest header files.
Your library versions are ok. If the problem was with library versions
then you would see a return code like the following:
DSM_RC_WRONG_VERSION
The problem is down in the guts of the code (ie. the structure you are
passing to the API)...what is the specific TSM API function call that you
are using?
When creating structures to pass into the API functions you need to use
care when initializing, make sure you have something like the following:
int funcA()
{
...
qryMCData qMCData = {0}; /*create and zero out the
structure */
...
qMCData.stVersion = qryMCDataVersion;
qMCData.mcName = mcBindKey.mcName;
qMCData.mcDetail = dsmTrue;
...
return 0;
}
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
Mike [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
06/04/2006 01:39 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Trying to use TSM API
I have a program that compiles properly, and connects, but when
querying (I'm testing managemt classes first) it gets an error:
ANS0245E (RC2065) The caller's structure version is different than the TSM
library version.
The version of the tivoli.tsm.samples is the same as the
tivoli.tsm.client. Is there a way to check what is wrong? Is there
a way around the problem?
Mike
Re: FW: intergratinf tivoli with rman
I see one problem in the script you providedDSMI_ORC_CONFIG is referrencing back to itself. DSMI_ORC_CONFIG needs to point to the dsm.opt file. You might want your setup to look something like the following: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt DSMI_LOG /oradata5/rman/tsm/logs TDPO_FS ora10g TDPO_NODE odtsvkhaxdct0004 *TDPO_OWNER username TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64 TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1 /usr/tivoli/tsm/client/oracle/bin64/dsm.opt Servername MyFavoriteStanza /usr/tivoli/tsm/client/api/bin64/dsm.sys Servername MyFavoriteStanza tcpserveraddress myserver.mycompany.com Commmethod tcpip tcpport1500 passwordaccess prompt Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Touheed Abbas [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 04/17/2006 05:04 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject FW: intergratinf tivoli with rman Hi, I?m very much new to TSM and running a critical production system on Oracle I?m trying to integrate Oracle with Tivoli 5.2, but I?m still not able to integrate it??.. Can somebody guide me and send a precise document that tells how many dsm.opt files need to configured and how to configure them?? My environment is: Oracle 10g rel.1 on IBM AIX 5.3 with gpfs 2.3 and following components of Tivoli are installed on the machine tivoli.tivguid1.3.0.0 tivoli.tsm.books.en_US.client.htm5.3.2.0 tivoli.tsm.books.en_US.client.pdf 5.3.2.0 tivoli.tsm.client.api.32bit 5.3.2.0 tivoli.tsm.client.api.aix51.64bit 5.1.5.0 tivoli.tsm.client.ba.32bit.base 5.3.2.0 tivoli.tsm.client.ba.32bit.common 5.3.2.0 tivoli.tsm.client.ba.32bit.image5.3.2.0 tivoli.tsm.client.ba.32bit.nas5.3.2.0 tivoli.tsm.client.ba.32bit.web 5.3.2.0 tivoli.tsm.client.oracle.aix51.64bit5.2.0.0 tivoli.tsm.client.oracle.tools.aix51.64bit5.2.0.0 Running rman for allocating channel gives me following error using target database controlfile instead of recovery catalog RMAN-03009: failure of allocate command on tivoli channel at 04/04/2006 18:46:20 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 here is the parameter/opt file contents of tivoli: DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt DSMI_LOG /oradata5/rman/tsm/logs TDPO_FS ora10g TDPO_NODE odtsvkhaxdct0004 *TDPO_OWNER username TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64 TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1 *TDPO_MGMT_CLASS_2 mgmtclass2 *TDPO_MGMT_CLASS_3 mgmtclass3 *TDPO_MGMT_CLASS_4 mgmtclass4 Regards, Touheed Abbas Asst. Manager, Database/System Administration Dubai Islamic Bank +92-333-2235665 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.698 / Virus Database: 455 - Release Date: 6/2/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.698 / Virus Database: 455 - Release Date: 6/2/2004
Re: Deleting RMAN catalogue file
Rich, TDP Oracle backups are stored on the TSM Server (for Unix TDP Oracle clients) as follows: /filespace//Oracle_backup_piece*note: notice the empty highlevel I have never tried the expire command from the TSM server so I do not know if is possible, although I believe it would be. Do these backup pieces still exist in the RMAN catalog? I only as because there is the 'tdposync' utility that will allow an administrator to delete backups that still exist on the TSM Server but have been removed from the RMAN catalogthis might help your situation. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Richard Mochnaczewski [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/29/2006 10:59 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Deleting RMAN catalogue file Hi, I'm having some trouble trying to delete a few RMAN recovery catalogue logfiles. My DBA is unable to delete them in Oracle, but I would like to delete the in TSM. I know I can use the expire command to do so but because of the RMAN virtual filespace in TSM I'm unable to. Info : Filespace Name: /adsm-rman FSID: 78 Client's Name for File: // lf_TRCV02_573465621_530_1 When I try running expire /adsm-rman/lf_TRCV02_573465621_530_1 I get the following error : Backup files will be expired. Do you wish to proceed? (Yes (Y)/No (N)) y ANS1302E No objects on server match query Expire processing of '/adsm-rman/lf_TRCV02_573465621_530_1*' finished with 1 failures. When I check the dsmerror/log file , I get the following message : 29.03.2006 13:51:21 ANS1302E No objects on server match query I know the file exists because it is located on one of my onsite tapes. I tried using the wildcard * at the end of the filename thinking that the filename may be truncated but that is not the case. How can I delete this file ? Rich
Re: expiration Oracle backups
Kurt, When deleting Rman objects on the TSM Server, TDP Oracle uses the delete function on objectsthe objects do not move to inactive they are just simply deleted from the TSM Server. So if you are certain that Rman is deleting the objects from the controlfile, then my guess is that your TSM Node is not configured with backdel=yes. One simple way to know what is going on during the deletion is to look in the tdpoerror.log this should tell you if the objects are being deleted or if there is an error occurring during the delete. Unfortunately, Oracle ignores errors that come from the delete functions so any error that TDP Oracle gives during deletion is lost, the only way to know for sure is the tdpoerror.log Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Kurt Beyers [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/13/2005 06:19 AM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject expiration Oracle backups Hello, My environment is the following: TSM 5.3.2 server on Windows2003 Sun Solaris 5.8 with Oracle 8.1.7.4 with a TSM BA client 5.3.x and the TDP for databases 5.3 The backup of the Oracle databases is already working. The metadata of the backups is written in the control files of the Oracle database. The backups are bound to a mgmt class with the correct settings (as every object receives a unique name in TSM). The expiration must first be done in Oracle with a script, eg expire the backups older than X days. Could anybody share a working script? I'm still struggling to get it working as it should. But how are the backups made inactive in the TSM database after they have been deleted in Oracle? The 'tdposync' tool only works when the metadata is stored in a recovery catalog database. And after a forced deletion of the backups in RMAN, they do not become inactive in TSM either. How can the metadata in the TSM database be synchronized with the metadata in Oracle (control file) . I know this must have been discussed in the past already, but a search of the old threads didn't clear it out yet. thanks a lot, Kurt
Re: TDP Oracle
I believe this to be possible.
'SBT_TAPE' tells Oracle/Rman that you want to use a 3rd party media
manager (ie. TDP for Oracle) for your backups. 'SBT_DISK' tells
Oracle/RMAN that you want to use Oracle's internal disk library which
means that you can dump it to local disk. Keep in mind that I have never
attempted this but you should be able to redirect to a tape device rather
than a disk. Again I have never gone directly to tape using this method
but at first glance it seems possible; you may want to refer the
Oracle/Rman User's Guide on this. To be sure, to go to disk your rman
script would look something like the following (remeber this is just an
example):
run
{
allocate channel t1 type 'SBT_DISK';
backup controlfile;
backup database;
}
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
Kurt Beyers [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
09/22/2005 10:50 PM
Please respond to
ADSM: Dist Stor Manager
To
ADSM-L@VM.MARIST.EDU
cc
Subject
TDP Oracle
Good morning,
A rather general question.
Is it possible to take the backup of only 1 instance with the TDP for
Oracle
(an instance that would be used for testing in TSM) and to take the backup
of the other (production) instances to a local tape with an RMAN script?
Both backups (TPD and local RMAN backup) do allocate 'sbt_tape' as
channel.
In other backup solutions, a symbolic link of the Oracle library
$ORACLE_HOME/lib/libobk.sl is created to the library of the backup
solution.
Which means that a backup to a local device using a RMAN script is no
longer
possible.
I did not find out if this is the case too with the TDP for Oracle. Must
all
Oracle instances be restarted after the installation of the TDP or only
the
instance that you want to backup with the TDP or is there no restart at
all.
Thanks,
Kurt Beyers
Re: TDP for Oracle 8.1.7.4 9.2.0.6 on same server
Scott, TDP Oracle can interface with both a 32-bit and 64-bit Oracle instance by defining the correct symbolic links. The 32-bit Oracle should use the 32-bit TDP Oracle libobk.a and the 64-bit Oracle should use the 64-bit TDP Oracle libobk.a. To ensure this, define the symbolic links as follows: 32-bit Oracle 8i $ORACLE_HOME/lib/libobk.a -- /usr/tivoli/tsm/oracle/bin/libobk.a. 64-bit Oracle 9.2 $ORACLE_HOME/lib/libobk.a -- /usr/tivoli/tsm/oracle/bin64/libobk64.a. (With the 9.2 version of 64-bit Oracle the directory structure changed to use just the lib directory for the 64-bit library location. ) It is necessary to verify the library path that is being used (LIBPATH or LD_LIBRARY_PATH). Ensure that the /usr/lib is NOT first in the path. $ORACLE_HOME/lib should be first in the path so that Oracle will look in its own library directory where the libobk.a links have been created. The TDP for Oracle version 5.2 package is such that the 32-bit installation will be placed in the /usr/tivoli/tsm/client/oracle/bin and the 64-bit version will be installed in to the /usr/tivoli/tsm/client/oracle/bin64. Therefore the installed filesets will not be overwritten. Please note, however, that the installation will automatically create a soft link in the /usr/lib directory for the libobk.a file. You will need to either remove this link or ensure that it is pointing to the correct (32-bit versus 64-bit) location you want. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Scott Grover [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 09/01/2005 01:51 PM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle 8.1.7.4 9.2.0.6 on same server 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 on the 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 #
Re: TDP for ORACLE AIX
Scott, Try this link: http://www-1.ibm.com/support/docview.wss?rs=666context=SSTFZRq1=106uid=swg21197242loc=en_UScs=utf-8lang=en Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Scott Grover [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 08/11/2005 11:40 AM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject TDP for ORACLE AIX Hi all, Doing a TDP for Oracle AIX first time implementation. (Oracle 9i; AIX 5.2, TDP 5.2.0) Install went well, TDPOCONF PASSW SHOWENV successful. First attempt at an RMAN backup produced the following RMAN error: RMAN-03009: failure of allocate command on ch00 channel at 08/11/2005 13:10:23 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer IBM AIX RISC System/6000 Error: 106: For future use Additional information: 7011 ORA-19511: Error received from media manager layer, error text: SBT error = 7011, errno = 106, sbtopen: system error However, nothing was logged in the TSM log I specified in TDPO.OPT dsmi_log parm. That seemed odd so I changed the permissions on the log to 666, and then RMAN backups started working. (Lucky shot in the dark). Now getting same error on recovery. Despite what the content of the error message says, my problems seem to be related to file ownership and / or permissions on the client. However, I can find nothing in the installation guide that helps, nor are there any recent hits in IBMLINK.Any suggestions?? Thanks.
Re: ANR0481W and COMMTIMEOUT setting
I noticed that the node in your example is a TDP SQL node (if I am reading correctly). It is not uncommon for nodes that are TDPs to require longer timeouts. What happens is that databases will start up a session with the TSM Server and then will go off and collect the information to send - depending on the amount of processing that occurs, which quite often correlates to the size of the database, can take a *very* long time. For instance, I know that with Oracle/TDP Oracle during an incremental of larger databases, Oracle may spend a long time trying to locate changed blocks. I have seen these times take longer than 30 minutes (although not common). The short of it is that you may need a time out of 1800+ to accomodate these databases. Regards, Neil Rasmussen Software Development Data Protection for Oracle Andrew Raibeck/Tucson/[EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 05/11/2005 12:49 PM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject Re: ANR0481W and COMMTIMEOUT setting 1800 seconds is a *very* long commtimeout setting. Assuming the clients in question are on relatively fast networks (e.g., not dial-up), I would tend to suspect that a problem in the network (though I could not tell you what that problem is), especially if it continues to occur. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2005-05-11 12:29:27: Thanks John, appreciate the info. John Naylor wrote, on 05/11/05 01:42: Robert, My commtimeout is set 3600 with no problems Where you are seeing hits where you had none before you may want to consider/alleviate the cause per the description in Admin Ref Specifies how long the server waits for an expected client message during an operation that causes a database update. If the length of time exceeds this time-out, the server ends the session with the client. You may want to increase the time-out value to prevent clients from timing out. Clients may time out if there is a heavy network load in your environment or they are backing up large files John robert moulton [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 10/05/2005 20:07 Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu cc Subject ANR0481W and COMMTIMEOUT setting Greetings ADSM List - Seeking your advice and/or a nudge toward applicable documentation ... TSM Version 5, Release 2, Level 4.0 AIX 5.2 We're seeing an increasing number of these ANR0481W messages in server logs: ANR0481W Session 38 for node M_SQLSAN01_CL_U (WinNT) terminated - client did not respond within 1800 seconds. As you can see our COMMTIMEOUT setting is 1800 seconds. Are there risks involved with boosting it even higher? Thanks in advance for your advice. Robert Moulton University of Washington Computing Communications ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy Group. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Unless specifically stated otherwise, this email (or any attachments to it) is not an offer capable of acceptance or acceptance of an offer and it does not form part of a binding contractual agreement. Scottish Hydro-Electric, Southern Electric, SWALEC, S+S and SSE Power Distribution are trading names of the Scottish and Southern Energy Group. **
Re: TDP for Oracle Failes after AIX 5.1 -Aix 5.3 upgrade
Micahael, It sounds to me like that during the upgrade the TDP Oracle soft links were corrupted. Please verify that the following exist: /usr/lib/libobk64.a - /usr/tivoli/tsm/client/oracle/bin64/libobk64.a and/or $ORACLE_HOME/lib/libobk.a - /usr/tivoli/tsm/client/oracle/bin64/libobk64.a If the above does not help, you could as a last ditch effort, reinstall TDP Oracle to see if that helps. Otherwise, I would suggest calling IBM support and opening a problem ticket. Regards, Neil Rasmussen Software Development Data Protection for Oracle Michael Garnebode [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 05/02/2005 05:37 AM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle Failes after AIX 5.1 -Aix 5.3 upgrade Hi to all, After a aix 5.1 upgrade to aix 5.3 our tdp for oracle cant't backup anymore. The testmachine have installed api-client for 32- and 64-bit databases. Before upgrade Aix 5.1 kernel modus are 32-bit. After upgrade the kernel modus are 64-bit. Now rman can't load the SBT_TAPE device. See error below. I have deinstalled all tsm-client packetges and have a new installation for a tsm-client 5.2.3.4 for 64-bit and tdp oracle version 5.2.0.0 bit tivoli.tivguid 1.1.0.0C FIBM Tivoli GUID on AIX tivoli.tsm.client.api.64bit 5.2.3.4C FTSM Client - 64bit Application Programming Interface tivoli.tsm.client.ba.64bit.base 5.2.3.4C FTSM Client - Backup/Archive Base Files tivoli.tsm.client.ba.64bit.common 5.2.3.4C FTSM Client - Backup/Archive Common Files tivoli.tsm.client.ba.64bit.image 5.2.3.4C FTSM Client - IMAGE Backup Client tivoli.tsm.client.ba.64bit.nas 5.2.3.4C FTSM Client - NAS Backup Client tivoli.tsm.client.ba.64bit.web 5.2.3.4C FTSM Client - Backup/Archive WEB Client tivoli.tsm.client.oracle.aix51.64bit 5.2.0.0C FIBM Tivoli Storage Manager for Databases - Oracle on AIX tivoli.tsm.client.oracle.tools.aix51.64bit 5.2.0.0C FIBM Tivoli Storage Manager for Databases - Oracle Tools on AIX The problem exist furthermore. We see no dsierror.log, tdpoerror.log or anything The error in the script is: RMAN-03002: failure of backup command at 05/02/2005 09:27:33 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 Thanks for any advice Michael
Re: TDP for Oracle Error !!!!!!
Jose,
This is a known issue when upgrading to the TSM API 5.3please see
http://www-1.ibm.com/support/docview.wss?uid=swg21197242
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
Loon, E.J. van - SPLXM [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
03/17/2005 02:09 AM
Please respond to
ADSM: Dist Stor Manager
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: TDP for Oracle Error !!
Hi Jose!
Try and find the sbtio.log file. It probably contains more useful messages
about the cause.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-Original Message-
From: Jose Antonio Atala Olaechea [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 20:34
To: ADSM-L@VM.MARIST.EDU
Subject: TDP for Oracle Error !!
Hi TSM'rs
When I tried to do a full backup using the TDP for Oracle the following
error message appear:
RMAN run
2 {
3 allocate channel t1 type 'sbt_tape' parms
4 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
5 backup
6 filesperset 15
7 format 'df_%t_%s_%p'
8 (database);
9 release channel t1;
10 }
11
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03009: failure of allocate command on t1 channel at 03/12/2005
11:38:35
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux Error: 106: El otro extremo ya estaonectado
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error
Recovery Manager complete.
In the same way when I tried to do a archive log backup using the TDP for
Oracle the following message appear:
RMAN run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
filesperset 5
format 'al_%t_%s_%p'
(archivelog all delete input);
release channel t1;
}
2 3 4 5 6 7 8 9 10
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03009: failure of allocate command on t1 channel at 03/15/2005
10:46:26
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux Error: 106: El otro extremo ya estaonectado
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error
My environment is:
Linux RHAS 3.0
Version Kernell Linux 2.4.21-27
compat-gcc-c++-7.3-2.96.128
acl-2.2.3-1
Oracle 9i - 9206
TSM SERVER 5.2
CLIENTE TSM 5.3
TDP 5.2
reagards
Josi Antonio Atala Olaechea
_
Charla con tus amigos en lmnea mediante MSN Messenger:
http://messenger.latam.msn.com/
**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee only. If
you are not the addressee, you are notified that no part of the e-mail or
any attachment may be disclosed, copied or distributed, and that any other
action related to this e-mail or attachment is strictly prohibited, and
may be unlawful. If you have received this e-mail by error, please notify
the sender immediately by return e-mail, and delete this message.
Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any delay in
receipt.
**
Re: TDP/ORACLE Backup
Keep in mind that TDP Oracle just passes on what Oracle/Rman asks it to. So for DB estimation, TDP Oracle uses the value that Oracle passes to it (which probably is overestimated). If compression is turned on then this value is grossly overestimated. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Wholey, Joseph (IDS DMDS) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 12/06/2004 08:08 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject TDP/ORACLE Backup When running a TDP for Oracle backup, does TDP lock the estimated amount of the storage pool which it thinks it needs to complete the backup? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: TDP/ORACLE Backup
Yes there is a way to change this. By specifying the option: TDPO_AVG_SIZE n (where 'n' is the size estimate, in MB, you want TDP Oracle to use with the TSM Server) Using this option overrides any size that Oracle specifies and can cause other performance problems on the the TSM Server. However, this option is very useful if you are using compression and the TSM Server is up against the wall with regards to availabe storage space for backups. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Wholey, Joseph (IDS DMDS) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 12/06/2004 09:24 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: TDP/ORACLE Backup Is it possible to change the estimated size? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Neil Rasmussen Sent: Monday, December 06, 2004 12:07 PM To: [EMAIL PROTECTED] Subject: Re: TDP/ORACLE Backup Keep in mind that TDP Oracle just passes on what Oracle/Rman asks it to. So for DB estimation, TDP Oracle uses the value that Oracle passes to it (which probably is overestimated). If compression is turned on then this value is grossly overestimated. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Wholey, Joseph (IDS DMDS) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 12/06/2004 08:08 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject TDP/ORACLE Backup When running a TDP for Oracle backup, does TDP lock the estimated amount of the storage pool which it thinks it needs to complete the backup? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: TDP for Oracle on Linux - ANS0263E (RC2230
Sandra, DP for Oracle uses the TSM API to connect to the TSM Server, because of this, the API is going to look in /opt/tivoli/tsm/client/api/bin for the dsm.sys file - I am making the assumption that this is the reason for the error. You have two choices at this point, either create a dsm.sys file in the API directory or create a link from the API directory over to your dsm.sys in the .../ba/bin directory. Just one other point, it is not recommended that you share your BA Client dsm.sys stanza's with all nodesespecially in this case where you have passwordaccess generate. DP Oracle expects the passwordacces prompt. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Sandra [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/29/2004 09:56 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject TDP for Oracle on Linux - ANS0263E (RC2230 Dear List, Here is another problem with me: TDP for Oracle on Linux. tdpoconf password or tdpoconf showenvironment commands giving error as under: ANS0263E (RC2230) Either the dsm.sys file was not found, or the Inclexcl file specified in dsm.sys was not found. I installed: BA Client TDP oracle TDP Utilities since TSM API gave message that 5.2.2 version is already installed, and I received 5.1.5 with TDP oracle. tdpo.opt fie: DSMI_ORC_CONFIG /opt/tivoli/tsm/client/ba/bin/dsm.opt DSMI_LOG /opt/tivoli/tsm/client/oracle/bin TDPO_FS /adsmorc TDPO_NODE onlinedb-orc TDPO_OWNER root TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1 dsm.opt file: SERVERNAME 172.16.17.117 DOMAIN ALL-LOCAL dsm.sys file: SERVERNAME 172.16.17.117 GROUPS root USERS root PASSWORDDIR /opt/tivoli/tsm/client/ba/bin PASSWORDACCESS GENERATE NODENAME onlinedb TCPSERVERADDRESS 172.16.17.117 I tried to copy the dsm.sys and dsm.opt files in /opt/tivoli/tsm/client/oracle/bin directory but to no avial. Removed GROUPS and USERS from dsm.sys file but to no avail. Did this and that, but to no avail. Tivoli BA Client is installed and it is backing up files perfectly. I am missing that one thing which is right. I tried the same on Windows 2000 machine and the two commands worked fine. Please help me out of this unwelcome situation. Regards, Sandra
Re: Oracle TDPO error SBT 2175
Adrie, In a nutshell, the error that you are seeing from the sbtio.log is a telling sign that the object name that Oracle is giving to the file for that backup already exists on the TSM Server. Usually this is a result of the backup_piece name that Oracle generates is very long and the part of the name that should make the name unique is getting truncated so it looks like a duplicate name to TDP Oracle/TSM. Without seeing your Rman script for this backup I can only venture a guess but I think that you need to take a little more control over how the backup pieces are being named - you can control the naming (to a degree) that Rman/Oracle uses for it's backup_pieces, see the Rman User's guide on this subject. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Tuyl Adrie, A.C. van [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/08/2004 02:44 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Oracle TDPO error SBT 2175 Dear Oracle and TSM specialists, We are trying to backup an Oracle database with Oracle TDPO for HP-UX. Installation as mentioned in the manual. We created a seperate tdpo node with backdelete yes. rman script works when creating files. When backing up to the TSM server we get the following error from the TDP: SBT-2175 08/04/2004 13:45:58 send2.cpp(650): sbtbackup(): Exit - tdpoQueryObj() failed. dsmHandle = 1, rc = 8 The log in TSM server does not show (me) problems, a connection from the TDP is made and data is sent. After that the connection is closed. What can be the problem here? TDPO logs and server logs added. Thanks, Adrie HP UX 11 Oracle 8.1.7.R4 TDPO 2.2.1 TSM server 5.1.8.2 (w2k SP4) Output TDPO $ cat sbtio.log === Tracing started for: --- Application Client : TDP Oracle HP Version : 2.2.1.0 === SBT-2175 08/04/2004 13:45:58 send2.cpp(650): sbtbackup(): Exit - tdpoQueryObj() failed. dsmHandle = 1, rc = 8 SBT-2175 08/04/2004 13:45:59 remove2.cpp(237): sbtremove2(): Exit - wrong state, dsmHandle = 1, state = 2 Server log ** 04-08-2004 13:41:43 ANR2017I Administrator 18447 issued command: UPDATE NODE OWCX01 CLOPTSET=HP_SERVER CONTACT=WOZ Centraal DOMAIN=HPUNIX COMPRESSION=YES AUTOFSRENAME=NO ARCHDELETE=YES BACKDELETE=YES FORCEPWRESET=NO KEEPMP=NO MAXNUMMP=5 URL=http://owcx01:1581 04-08-2004 13:41:43 ANR2063I Node OWCX01 updated. 04-08-2004 13:43:29 ANR0406I Session 25290 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3031)). 04-08-2004 13:47:00 ANE4991I (Session: 25290, Node: OWCX01_ORCL) TDP Oracle HP ANU0599 ANU2535I File /adsmorc//TMWB_8_1_533310141.bck = 204800 bytes sent 04-08-2004 13:47:00 ANR0406I Session 25291 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3026)). 04-08-2004 13:47:00 ANR0403I Session 25291 ended for node OWCX01_ORCL (TDP Oracle HP). 04-08-2004 13:47:00 ANR0403I Session 25290 ended for node OWCX01_ORCL (TDP Oracle HP). 04-08-2004 13:47:04 ANR0406I Session 25292 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3025)). 04-08-2004 13:47:05 ANR0403I Session 25292 ended for node OWCX01_ORCL (TDP Oracle HP). This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify [EMAIL PROTECTED] This footnote also confirms that this e-mail message has been checked by McAfee Groupshield for the presence of computer viruses.
Re: TDP for Oracle 5.2 password file
Janusz, On Windows passwordaccess needs to be set to generate and unset the TDPO_NODE in the tdpo.opt fileTDP Oracle uses the nodename specified in the dsm.opt or the machine name if not specified in the dsm.opt. On Windows the password is stored in the registry so you will not see a TDPO.nodename like in Unix. Once you make these changes, run tdpoconf passw again (this should generate your pw in the registry) and then try to run tdpoconf showenv to see if that clears the password problem up. Regards, Neil Rasmussen Software Development Data Protection for Oracle Janusz Wiszniowski [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 07/01/2004 08:04 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject TDP for Oracle 5.2 password file Hi TSM'ers I have problem with generating TDP for Oracle password file on Win2003. My TDP version is 5.2.0. In the dsm.opt file PASSWORDACCESS is set to PROMPT, also TDPO_NODE is set in tdpo.opt file. Tdpoconf logs in correctly to TSM server, I can set the password, but it doesn't generate TDPO.nodename file in default directory. When I run tdpoconf showenv it returns error Session rejected. Authentication failure. Any ideas? Regards Janusz
Re: Yet another TDP Oracle issue
David, The error code 2534 indicates that there is an error in the TDP Oracle options file. Not sure if the tdpoerror.log gives any indication as to whyI would recommend looking at the log for any indication, if it does not give any indication you may want to compare the differences between the tdpo.opt that works and this one. If that gives no results I recommend calling TSM Support and have them help you identify the problem. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED]
Re: sbttest a -libname libobk64.a Queston?
The return code from the RMAN layer is the key here - RMAN is not very robust reporting errors from initialization problems but that 2512 is from DP for Oracle which is a licensing problem. You need to check that your license exists and that it can be found by DP Oracle. If your license is in the installation directory then it may be a permissions problem. Otherwise, you need to set TDPO_PSWDPATH to point to the directory of where it can find the license file. The name of the license file is agent.lic. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Mladen Portak [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 05/10/2004 02:56 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject sbttest a -libname libobk64.a Queston? Hi to all! I'm trying to setup rman/tdp for Oracle 9i running on an AIX 5.2 system, Oracle 9.2.0.1.0 but I have problems with RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on t1 channel at 05/07/2004 11:22:37 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer IBM AIX RISC System/6000 Error: 2512: System call error number 2512. Does anyone know how to check libobk.a ? I do the next: # sbttest a -libname /usr/tivoli/tsm/client/oracle/bin64/libobk64.a libobk64.a could not be loaded. Check that it is installed properly, and that LD_LIBRARY_PATH environment variable (or its equivalent on your platform) includes the directory where this file can be found. Here is some additional information on the cause of this error: 0509-022 Cannot load module /lib/libobk64.a. 0509-124 The program is a discontinued 64-bit object file. Is this correct state of libobk64.a? #what /usr/tivoli/tsm/client/oracle/bin64/libobk64.a libobk64.a: IBM Tivoli Storage Manager for Databases, Data Protection for Oracle. Licensed Materials - Property of IBM 5698-APD (C) Copyright IBM Corporation 1990, 2003 All Rights Reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM CORP Version: 5.2.0.0. Build Date: Feb 23 2003. I done all necessary environment variables but I still get the same error! Please advise thanks!.
Re: oracle 9i/rman tdp with tsm
My experience has been that Oracle on AIX has not required the DB to be restarted since 8i - it has been the only database with some consistency in that regards. The biggest problem that I have seen with Oracle on AIX is the fact that AIX by default only uses /usr/lib for 32bit and 64bit libraries. Unfortunately, with the introduction of 9i, Oracle no longer looks in it's ORACLE_HOME/lib directory for the libobk.a but rather in the /usr/lib directory - and so the configuration nightmare begins.This is a conflict with Oracle since Oracle only looks for libobk.a regardless of 32 or 64bit and DP for Oracle 64bit library is named libobk64.a. So in particular if you are using Oracle 9i on AIX 5 then your link(s) should look like this: $ORACLE_HOME/lib/libobk.a -/usr/tivoli/tsm/client/oracle/bin64/libobk64.a and in the Oracle user's environment you need to export the LD_LIBRARY_PATH: export LD_LIBRARY_PATH=$ORACLE_HOME/lib (for this to take effect I believe you will have to restart Oracle) Last week I posted a link to our Knowledge Base articles that has a word document (and some slides) that walks through this configuration. This document has been found to be invaluable by others and I really recommend anyone having DP Oracle configuration problems, no matter what platform, to read it. Here is the link again: http://www-1.ibm.com/support/entdocview.wss?rs=0q1=DP%20Oracleuid=swg21145506loc=en_UScs=utf-8cc=uslang=en Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Justin Bleistein [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 05/07/2004 07:54 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject oracle 9i/rman tdp with tsm I'm trying to setup rman/tdp for Oracle 9i running on an AIX 5.1 system, Oracle 9.2.X.X.X. Now in the Solaris world when I tried to setup Oracle 8i to rman/tdp I had to bring down the tsm instance, like the $ORACLE_HOME/lib/libobk.so to /usr/lib/libobk.so which linked to: /usr/tivoli/tsm/client/oracle/bin/libobk.so. Then bring the instances backup then I was able to backup to TSM via rman. However if it was an Oracle 9i database I was backing up then I didn't have to bounce the Oracle instances. I didn't even have to link the library file. I could just use the SBT_LIBRARY= rman option in my scripts and just point to the libobk.so library in the tivoli tdp install directory and it backed up fine. No outage required. Now has that changed in AIX? Do you need an Oracle bounce even with 9i in AIX? Please advise thanks!. --Justin Richard Bleistein Unix/TSM Systems Administrator (Sungard Availability Services) Desk: (856) 566 - 3485 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: RMAN handling of environment variables
...the ones specified in the RMAN channel definitions in effect at the time of the restore. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Thomas Denier [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 05/06/2004 12:55 PM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject RMAN handling of environment variables We are preparing to migrate our TSM server to a new platform. Some of our client systems use TDP for Oracle. Most of these perform a full backup of Oracle databases once per week and incremental backups at least once per day. This raises the interesting possiblity of ending up with a full backup on our old TSM server and some of the subsequent incremental backups on our new TSM server. RMAN channel definitions for use with TDPO generally include a parameter specifying the value of the TDPO_OPTFILE environment variable to be passed to TDPO. I am wondering what would happen with the following scenario: 1.We define a new TDPO options file. 2.We change the RMAN environment variable definition to point to the new options file. 3.We run one or more incremental backups. 4.We run a restore. When TDPO is called to restore a particular file, will the environment variables passed to TDPO be the ones in use when that particular file was backed up, or the ones specified in the RMAN channel definitions in effect at the time of the restore?
Re: problem with tdp oracle 5.2 with oracle RMAN 9.2.0.4
The 2507 is a return code number that we give back to Oracle which in turn reports it as bsercerrno=2507. You will find that 2507 is: TDP_ORC_LOWER_APIVER ANU2507E Runtime API version is outdated Runtime API is lower than compile time API. Check compile time API level, obtain same or higher level of API library. As far as DP Oracle not being loaded when RMAN is run is another issue. When creating your links, are you linking directly to libobk64.a? You may want to look at http://www-1.ibm.com/support/entdocview.wss?rs=0q1=DP%20Oracleuid=swg21145506loc=en_UScs=utf-8cc=uslang=en there is a document called STE Oracle.doc. This has some good information that the manual does not contain. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] AMHOUCHE Youssef [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 05/04/2004 08:22 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: problem with tdp oracle 5.2 with oracle RMAN 9.2.0.4 I've always the same problem: The libobk.a link is well; LIBPATH and LD_LIBRARY_PATH include first the $ORACLE_HOME/lib directory. but the sbttest command give the following errors [EMAIL PROTECTED]:/ sbttest a -libname /usr/tivoli/tsm/client/oracle/bin64/libobk64.a /usr/tivoli/tsm/client/oracle/bin64/libobk64.a could not be loaded. Check that it is installed properly, and that LD_LIBRARY_PATH environment variable (or its equivalent on your platform) includes the directory where this file can be found. Here is some additional information on the cause of this error: 0509-022 Cannot load module /usr/tivoli/tsm/client/oracle/bin64/libobk64 .a. 0509-124 The program is a discontinued 64-bit object file. with a simple test file TOTO sbttest give [EMAIL PROTECTED]:/ [EMAIL PROTECTED]:/ sbttest TOTO -dbname pcard The sbt function pointers are loaded from libobk.a(shr.o) library. Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 2507 sbtopen: System error - eg. malloc, fork errors do you have any idea ? thank you! youssef -Message d'origine- De : Steve S Lafrance [mailto:[EMAIL PROTECTED] Envoyé : vendredi 30 avril 2004 18:44 À : [EMAIL PROTECTED] Objet : Re: problem with tdp oracle 5.2 with oracle RMAN 9.2.0.4 Importance : Faible Hi Youssef ! 1) I know that 9i is only available is 64 bit. Did we install the TSM API 64 bit version ? TDP for Oracle 64 bit version ? After installing the 64-bit version, you should have .../client/oracle/bin64 and .../client/api/bin64 directories. You can also verify with : lslpp -l | grep tivoli . 2) Search for all instances of libobk.a and libobk64.a. The only link should be: $ORACLE_HOME/lib/libobk.a - /usr/tivoli/tsm/client/oracle/bin64/libobk64.a . 3) You can test sbbtest with : . sbttest a -libname /usr/tivoli/tsm/client/oracle/bin64/libobk64.a . 4) The error we received indicates there are problems getting the correct sbt library loaded. As i mentionned before, look on your system for all the files starting with libobk. If attempting to load the TDP for Oracle libobk.X library file, do not use the SBT_LIBRARY parm as this has been seen to cause a failure for the library to load. Oracle 9i will load the media management libraries (libobk.X) dynamically when a channel is allocated with the a type of 'SBT_TAPE. Ensure that the libobk.a exists in the $ORACLE_HOME/lib directory and that the $ORACLE_HOME/lib directory is first in the LIBPATH (or LD_LIBRARY_PATH). . 8) Please make sure you have the license file for the tdp..i've seen in the past the same error...and it was caused by the missing license file. Best Regards, Steve -- Steve Lafrance IBM Tivoli Storage Manager Level II Support - Tivoli Certified Consultant International Business Machines (514) 938-6422 FAX: (514)938-6366 Visit our new IBM Tivoli Storage Manager support page: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManag er.html AMHOUCHE Youssef [EMAIL PROTECTED]@VM.MARIST.EDU on 2004-04-30 14:26:10 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:problem with tdp oracle 5.2 with oracle RMAN 9.2.0.4 Hi every one we have a problem when RMAN 9.2.0.4 invoke tdp oracle 5.2 for backup of database on TSM 5.1 server some idea about this ?(urgent)!! this the error message : RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on t1 channel at 04/30/2004 17:01:51 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 thanks joseph
Re: Firewall backups
I have no comment on the best method of firewall implementation. However, I could not let the statement that TSM Sends it username/password as plain text go by without comment. Neither the TSM Client nor the Web-GUI send the username/password in the clear. I am not sure where this information came from but it just is not true. Here is a post from about a year ago that explains how the password is sent, the explanation goes for the Client as well as the Web-GUI: http://msgs.adsm.org/cgi-bin/get/adsm0302/707.html Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Sal Mangiapane [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/21/2004 08:06 PM Please respond to salm To [EMAIL PROTECTED] cc Subject Re: Firewall backups We operate through firewalls differently: We have a small VPN device that we use to create an IPSec VPN tunnel and only have entries in the firewall for this tunnel, then we run all ITSM traffic through the tunnel. Makes for simpler firewall settings and adds extra security because username/password is sent as plain text by ITSM. You will also want to limit the Web-GUI client for security reasons too (plain text -- too). I can provide more details, contact me directly: salm(at)vitalds(dot)com or 724-758-3981 Sal Vital Data Systems -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Gill, Geoffrey L. Sent: Wednesday, April 21, 2004 6:43 PM To: [EMAIL PROTECTED] Subject: Firewall backups We're trying to get backups running outside a firewall and below are the results of a test. The network folks sent me this log to show the ports which communicating during backup. On the left is the server IP on the right is the client IP. The client settings are below. The question is how to get all to communicate on one specified port so they can tighten down acls. I've read the write-up on this and thought everything was set properly but I must be missing something. If someone has advice it would be greatly appreciated. Thanks, COMMmethod TCPIP TCPServeraddress xxx.xxx.xxx.xxx TCPCLIENTADDRESS xxx.xxx.xxx.xxx WEBPORTS 1582,1583 TCPPort1500 TCPCLIENTPORT 1501 HTTPPort 1581 Apr 20 17:04:50 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37317) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:04:51 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(1500) - xxx.xxx.xxx.xxx(2200), 1 packet Apr 20 17:05:04 PDT: list TSM-Filter denied tcp xxx.xxx.xxx.xxx(37316) - xxx.xxx.xxx.xxx(1501), 2 packets Apr 20 17:05:04 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37317) - xxx.xxx.xxx.xxx(1501), 4 packets Apr 20 17:05:04 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(1500) - xxx.xxx.xxx.xxx(2200), 5648 packets Apr 20 17:05:21 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37318) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:05:51 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37319) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:06:21 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37320) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:06:51 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37321) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:07:21 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37322) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:07:51 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37323) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:08:21 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37324) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:08:51 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37325) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:09:21 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37326) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:09:51 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37327) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:10:06 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(1500) - xxx.xxx.xxx.xxx(2200), 61959 packets Apr 20 17:10:21 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(37328) - xxx.xxx.xxx.xxx(1501), 1 packet Apr 20 17:10:25 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(1500) - xxx.xxx.xxx.xxx(2235), 1 packet Apr 20 17:10:41 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(1500) - xxx.xxx.xxx.xxx(2235), 8 packets Apr 20 17:10:41 PDT: list TSM-Filter permitted tcp xxx.xxx.xxx.xxx(1500) - xxx.xxx.xxx.xxx(2200), 2586 packets Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 854-0975
Re: ANS1302E on TDP Oracle restore
Bill, Most likely the problem is due to the fact that your target machine is not configured correctly - that is, from a DP for Oracle point of view. Generally, if you configure your target machine exactly as your source the duplicate command should work without a hitch. My method for doing this is to copy all the options files for DP Oracle (dsm.opt, dsm.sys, tdpo.opt) from the source machine to the target machine. The common misconception is that the duplicate command uses the configuration setting from the source machine when in fact it comes from the target machine. Hope this helps. Regards, Neil Rasmussen Software Development Data Protection for Oracle Bill Boyer [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/24/2004 08:56 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject ANS1302E on TDP Oracle restore TSM Server 5.2.2.1 on AIX 5.2 TSM Client 5.2.2.1 on Solaris V8 TSM For Databases Oracle 5.2.2.0 Oracle 8.1.7.4 I have a client trying to restore a database into a new instance using the RMAN DUPLICATE command. The channel gets allocated, but then the command fails with ANS1302E no objects match query. The object in question is on the server. If we login with dsmc and do a QUERY BACKUP on the Oracle filespace, the objects show and as active. Here's the RMAN error: RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential fi le, handle=df_521549451_206_1, parms= ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: ANS1302E (RC2)No objects on server match query and this is the output of the QUERY BACKUP: Size Backup DateMgmt Class A/I File ----- --- API 12,378,112 KB 03/20/04 23:42:46DEFAULT A /oratest//df_521336569_135_1 API 12,378,112 KB 03/20/04 23:48:42DEFAULT A /oratest//df_521336924_136_1 API 12,374,016 KB 03/20/04 23:54:17DEFAULT A /oratest//df_521337260_137_1 API 12,374,016 KB 03/21/04 00:00:06DEFAULT A /oratest//df_521337606_139_1 API 12,374,016 KB 03/21/04 00:05:28DEFAULT A /oratest//df_521337931_140_1 API 12,392,448 KB 03/21/04 23:31:09DEFAULT A /oratest//df_521422269_164_1 API 12,396,544 KB 03/21/04 23:37:26DEFAULT A /oratest//df_521422644_165_1 API 12,387,328 KB 03/21/04 23:43:13DEFAULT A /oratest//df_521422990_166_1 API 12,391,424 KB 03/21/04 23:50:56DEFAULT A /oratest//df_521423386_167_1 API 12,387,328 KB 03/22/04 00:05:28DEFAULT A /oratest//df_521423906_168_1 API 12,392,448 KB 03/22/04 00:19:49DEFAULT A /oratest//df_521425162_170_1 API 12,387,328 KB 03/22/04 00:25:53DEFAULT A /oratest//df_521425557_171_1 API 12,392,448 KB 03/22/04 23:31:07DEFAULT A /oratest//df_521508666_191_1 API 12,396,544 KB 03/22/04 23:38:12DEFAULT A /oratest//df_521509091_192_1 API 12,392,448 KB 03/22/04 23:43:38DEFAULT A /oratest//df_521509418_193_1 API 12,387,328 KB 03/22/04 23:49:23DEFAULT A /oratest//df_521509763_194_1 API 12,392,448 KB 03/22/04 23:54:59DEFAULT A /oratest//df_521510099_195_1 API 12,387,328 KB 03/23/04 00:00:34DEFAULT A /oratest//df_521510434_197_1 API 12,387,328 KB 03/23/04 00:05:59DEFAULT A /oratest//df_521510759_198_1 API 12,397,568 KB 03/23/04 10:50:52DEFAULT A /oratest//df_521549451_206_1 My experience with RMAN is limited. Most DBA's run when you mention RMAN to them, so we haven't had much call for TDP Oracle. Any help on this would be appreciated! Bill Boyer Life is not about how fast you run, or how high you climb but how well you bounce. - ??
Re: relink RMAN and TDP
Nghiatd, What is it that has led you to believe that this is a relinking issue? Do you see the Rman backups complete successfully but just don't see the data on the TSM Server? What is it that you are looking for from query occupancy that has led you to believe that the database is not being backed up? If indeed it is relinking that you need we provide that information in our DP for Oracle User's Guide - this information can also be found in Oracle documentation (as this is an Oracle issue) and it can be slightly different for each platform. Regards, Neil Rasmussen Software Development Data Protection for Oracle nghiatd [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/21/2004 02:06 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject relink RMAN and TDP Hi all., I am using TSM and RMAN to backup database for Oracle. But I don't know how to relink RMAN and TDP. So I don't see database when using query occupancy * command in TSM server. Does anyone know relinking RMAN and TDP to backup database for Oracle ? Thanks, Nghiatd
Re: Linux; Oracle TDP; Client Schedular
I know this might sound like a silly question - but have you read the DP for Oracle User's Guide. There is a whole section on setting up the scheduler with DP for Oracle. It walks you through all the steps for dealing with root user vs. Oracle user. Regards, Neil Rasmussen Software Development Data Protection for Oracle CORP Rick Willmore [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/19/2004 09:55 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: Linux; Oracle TDP; Client Schedular How do you su - oracle -c script.sh if you use the client sched or do you? TSM support stated I couldnt do this. R. -Original Message- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 5:26 AM To: [EMAIL PROTECTED] Subject: Re: Linux; Oracle TDP; Client Schedular We have never used crontab to perform the backups for Oracle, MS-SQL or Domino/Notes. We always use the scheduler to run the COMMAND on the client. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 02/18/2004 06:50:47 PM: Anyone using the Client schedular to backup oracle databases/logs via the tdp? I need/want to run the backup script from the user oracle and was curious if anyone is doing this or if everyone is just using the crontab. R.
Re: Strange orphaned objects
Hi Andy, Below is a response that I am thinking about sending to a LISTSERV user. Can you tell me if I am on track, or if you know the answer could you share that information with me? thanks. * Eric, I am not sure that there is any better way to do your query than what you have already done. You might want to try breaking your queries up into smaller search patterns by maybe querying all nodes that begin with the letter A then B and so forth and then run these scripts over the course of serveral days to minimize impact on the server. Having said that, I do not know what the side effect of this kind of query - in other words, will the TSM Server query for all high level // and then filter out the results based on node names or will it filter on node names first. This is where you may want to try it on your test machine first. Regards, Neil Rasmussen Software Development Data Protection for Oracle Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/04/2004 06:28 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: Strange orphaned objects Hi Neil! My previous solution (del object) appeared to be a too easy solution. The old TDP backups are also present in the Oracle recovery catalog. Since then, a lot of things changed. The nodename was changed and also the Oracle filespace has changed. I guess it will not be all that easy to get rid of these backups, but it's worth trying because we talk about several gigabytes of obsolete data. What I now want to find out is if there are more of those nodes in my TSM environment. The only way I could think of is to create a select statement which lists all backups of non-oracle nodes with a ll_name of //. However, I ran that statement on my test environment and it took almost 3 hours to finish. On my production environment I'm afraid it will take days with all the negative impact on the database performance. Do you have an idea how to list these files without a select * from backups? Thank you VERY much for your reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Neil Rasmussen [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 17:16 To: [EMAIL PROTECTED] Subject: Re: Strange oprphaned objects Eric, Those look like Data Protection for Oracle backups. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/03/2004 08:11 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Strange oprphaned objects Hi *SM-ers! I have a Sun Solaris node for which I found something very strange. I issued a select * from backups where node_name='NODE' and I forwarded the output to a file. In that file I see some very old backup files which have a very strange path. The filespace name for such a file is /data0001, the ll_name is // and the object name is MT01D_t382461362_S3_P1. The files cannot be seen by the BA GUI, because it only displays the files located in /data0001/, not the files located in /data0001//. Has anybody seen this before? Client level is 4.2.3, server level is 5.1.8. Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Strange oprphaned objects
Eric, Those look like Data Protection for Oracle backups. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/03/2004 08:11 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Strange oprphaned objects Hi *SM-ers! I have a Sun Solaris node for which I found something very strange. I issued a select * from backups where node_name='NODE' and I forwarded the output to a file. In that file I see some very old backup files which have a very strange path. The filespace name for such a file is /data0001, the ll_name is // and the object name is MT01D_t382461362_S3_P1. The files cannot be seen by the BA GUI, because it only displays the files located in /data0001/, not the files located in /data0001//. Has anybody seen this before? Client level is 4.2.3, server level is 5.1.8. Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: tsm oracle tdp linux
By default TDP Oracle uses the dsm.sys file found in /opt/tivoli/tsm/client/api/bin. This is because TDP Oracle uses the TSM API to communicate with the TSM Server. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] CORP Rick Willmore [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 01/23/2004 03:54 PM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject tsm oracle tdp linux Anyone know why oracle tdp cant see the dsm.sys or incluexcl files?? Thanks. Error: 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. ANS0263E (RC2230) Either the dsm.sys file was not found, or the Inclexcl file sp ecified in dsm.sys was not found. tdpo.opt file: *** * IBM Tivoli Storage Manager for Databases *Data Protection for Oracle * * Sample tdpo.opt for the Linux86 Data Protection for Oracle * DSMI_ORC_CONFIG/opt/tivoli/tsm/client/oracle/bin/dsm.opt *DSMI_LOG /opt/tivoli/tsm/client/oracle/bin *TDPO_FS/ora/u03/oradata/WEBDEV *TDPO_NODE hostname *TDPO_OWNER username *TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin * *TDPO_DATE_FMT 1 *TDPO_NUM_FMT 1 *TDPO_TIME_FMT 1 *TDPO_MGMT_CLASS_2 mgmtclass2 *TDPO_MGMT_CLASS_3 mgmtclass3 *TDPO_MGMT_CLASS_4 mgmtclass4 File links in tdp directory (just to make sure): [EMAIL PROTECTED] bin]# ls -al dsm* lrwxrwxrwx1 root root 37 Jan 23 15:46 dsm.opt - /opt/tivoli/t sm/client/ba/bin/dsm.opt lrwxrwxrwx1 root root 37 Jan 23 15:46 dsm.sys - /opt/tivoli/t sm/client/ba/bin/dsm.sys [EMAIL PROTECTED] bin]# pwd /opt/tivoli/tsm/client/oracle/bin [EMAIL PROTECTED] bin]# [EMAIL PROTECTED] bin]# ls -al /opt/tivoli/tsm/client/ba/bin/dsm.opt -rwxr--r--1 root root 892 Jun 4 2003 /opt/tivoli/tsm/client/b a/bin/dsm.opt [EMAIL PROTECTED] bin]# ls -al /opt/tivoli/tsm/client/ba/bin/dsm.sys -rwxr--r--1 root root 1347 Jan 23 16:03 /opt/tivoli/tsm/client/b a/bin/dsm.sys [EMAIL PROTECTED] bin]# PASSWORDACCESS GENERATE Schedlogretention 14 Errorlogretention 14 inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl.file inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl.file [EMAIL PROTECTED] bin]# ls -al /opt/tivoli/tsm/client/ba/bin/inclexcl.file -rw-r--r--1 root root0 Jan 23 16:03 /opt/tivoli/tsm/client/b a/bin/inclexcl.file [EMAIL PROTECTED] bin]# ~ tdpo.opt 22L, 726C
Re: RMAN type sbt_tape?
You can set it type DISK but you will not get the results that you desire. Rman has no concept of TSM diskpool vs. tape - if you were to use type DISK the backup would go to your local disk (probably not what you want). I would recheck your management class settings for Oracle backups and make sure that they are indeed using the diskpool for it's destination, otherwise I would question your existing copygroup settings. Hi, I am taking backup from tdp client of Oracle database,RMAN type should be sbt_tape? is it possible to I can specify type DISK.I want backup should go to diskpool and then data should migrate to tapepool.My copygroup- copy distination is pointing diskpool,but at the time of backup,it is asking tape? Regards, Neil Rasmussen Software Development
Re: ANU2508E wrong write state
Sorry if this is a duplicate...not sure if the first one I sent was a successfull post. Wrong write state is a message that is left over from the Oracle Agent days...it should now read Wrong state. This message indicates that Oracle made a call to Data Protection for Oracle that is out of sequence from their stated protocol. Because there is nothing in the error log preceding this it is not very helpful. The other error in the error might be of concern, again it depends on the context that these errors were written to the log. I would suggest using IBM/Tivoli support to help solve this one so that we can collect the proper traces and logs and put this into context. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Wholey, Joseph (IDS DMDS) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 01/10/2004 09:23 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject ANU2508E wrong write state Need help... I'm getting this message prior to the TDP for Oracle backup failure. It transmits appx 6G over 3 channels, but then generates the following errors in the tdpoerror.log. I'm not that concerned with the ANU2602E or the ANS4994S, but I am concerned with the ANU2508E. Also, there is very little documentation on the error. We (tsm admins) did not change any configuration on our side, and the DBA's state they made no changes on their side. There is nothing in the actlog to indicate there is a problem. My initial question is, what is in the Wrong write state? And my next question is, how do I resolve? Before I call support, does anyone have any insight? OS platform SunOS 5.8 Oracle 8.1.7 TDPv2.2.1 TSM Server V5,2,0.0 running on zOS 01/10/04 09:26:59 ANU2508E Wrong write state 01/10/04 09:28:30 ANU2602E The object /adsmorc//arch.BFRMDM.9720.515063712 was not found on the TSM Server 01/10/04 09:28:30 ANS4994S TDP Oracle SUN ANU0599 ANU2602E The object /adsmorc//arch.BFRMDM.9720.515063712 was not fou nd on the TSM Server 01/10/04 09:28:31 ANU2602E The object /adsmorc//arch.BFRMDM.9719.515063712 was not found on the TSM Server 01/10/04 09:28:31 ANS4994S TDP Oracle SUN ANU0599 ANU2602E The object /adsmorc//arch.BFRMDM.9719.515063712 was not fou nd on the TSM Server Regards, Joe
Re: ANU2508E wrong write state
Wrong write state is a message that is left over from the Oracle Agent days...it should now read Wrong state. This message indicates that Oracle made a call to Data Protection for Oracle that is out of sequence from their stated protocol. Because there is nothing in the error log preceding this it is not very helpful. The other error in the error might be of concern, again it depends on the context that these errors were written to the log. I would suggest using IBM/Tivoli support to help solve this one so that we can collect the proper traces and logs and put this into context. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Wholey, Joseph (IDS DMDS) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 01/10/2004 09:23 AM Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject ANU2508E wrong write state Need help... I'm getting this message prior to the TDP for Oracle backup failure. It transmits appx 6G over 3 channels, but then generates the following errors in the tdpoerror.log. I'm not that concerned with the ANU2602E or the ANS4994S, but I am concerned with the ANU2508E. Also, there is very little documentation on the error. We (tsm admins) did not change any configuration on our side, and the DBA's state they made no changes on their side. There is nothing in the actlog to indicate there is a problem. My initial question is, what is in the Wrong write state? And my next question is, how do I resolve? Before I call support, does anyone have any insight? OS platform SunOS 5.8 Oracle 8.1.7 TDPv2.2.1 TSM Server V5,2,0.0 running on zOS 01/10/04 09:26:59 ANU2508E Wrong write state 01/10/04 09:28:30 ANU2602E The object /adsmorc//arch.BFRMDM.9720.515063712 was not found on the TSM Server 01/10/04 09:28:30 ANS4994S TDP Oracle SUN ANU0599 ANU2602E The object /adsmorc//arch.BFRMDM.9720.515063712 was not fou nd on the TSM Server 01/10/04 09:28:31 ANU2602E The object /adsmorc//arch.BFRMDM.9719.515063712 was not found on the TSM Server 01/10/04 09:28:31 ANS4994S TDP Oracle SUN ANU0599 ANU2602E The object /adsmorc//arch.BFRMDM.9719.515063712 was not fou nd on the TSM Server Regards, Joe
Re: AIX 64bit and TDP oracle????
Youssef, You should use Data Protection for Oracle 5.2. Can you be a bit more specific about the problems you are encountering? Regards, Neil Rasmussen Software Development Data Protection for Oracle AMHOUCHE Youssef [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 12/15/2003 06:09 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:AIX 64bit and TDP oracle Hi every one What version of TDP oracle can i use whith AIX 5.1 64bit and TSM client 5.1. ?? With the TDP 5.1.5 i have a lot of problems on AIX 64bit. thank you more Youssef * Ce message et toutes les pieces jointes (ci-apres le message) sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. *
Re: Can't backup oracle with TDP 5.1.5 on windows 2000 server
Two Problems here: First off, you need to register the target database with RMAN - that should take care of your last error. Secondly, you need to put the key word TDPO_OPTFILE in all caps. Although, it appears to work for you, I can assure it is not. The 'ENV=()'; command in RMAN puts the contents inside the parentheses to the environment (putenv()). DP for Oracle does a getenv() on TDPO_OPTFILE which means that if that does not match exactly we do not recognize the parameter. The reason why it appears to work is that by default we look in the installation directory for the tdpo.opt file. The allocate channel command should look like this: allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\Tsm\AgentOBA\tdpo.opt)'; Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED]
Re: TDP for Oracle Errors
Eric, Oracle 9i introduced the concept of autobackups for the control file. During the autobackup process, Oracle dynamically generates the backuppiece name for the control files that are being saved. During this backup processing, a unique name is generated by Oracle prior to backing it up and the TSM Server is then checked to ensure that this backuppiece name does not exist. When performing this check for any existing objects that might have this name, Oracle will first try to delete this file regardless of whether it exists or not. The return code from the deletion process not finding the object on the TSM Server is the ANU2602E message. During the autobackup processing, Oracle calls the Media Management Layer (Data Protection for Oracle/TSM Server in this case). Oracle issues the command to attempt a deletion prior to autobackup of the control file. Because each MML operation is a unique and distinct session, the MML has to treat each delete the same. In other words, Oracle gives no hints as to the type of deletion being performed therefor Data Protection for Oracle just attempts the delete. From Data Protection for Oracle's point of view a file not found during a delete could be a potentially serious error. For example: - During the delete the user is actually using a TSM filespace name that is different than what the objects were originally backed up under. - The TSM node does not have the backup delete permissions (backdel=yes|no). - During the deletion a different TDPO_NODE is specified than what was used during backup. The reason that these are potentially dangerous is that when Data Protection for Oracle detects an error during delete that a file is not found or cannot be deleted Oracle specifies that the MML does not return an error to Oracle. This causes a situation where during normal deletion Oracle would remove the backuppiece name from it's catalog but the backup could still exist on the TSM Server there by using up unnecessary storage space. Unfortunately, unless we ignore this error altogether then there is nothing that we (developement) can do. In the mean time the only tips we can give to work around these error messages during autobackups is for the user to do the following: Use the DISABLE EVENTS command on the TSM Server to suppress all ANU0599 ANU2602E messages so there would be no notification when a the file is not being found during DP for Oracle processing. For the tdpoerror.log, a different DSMI_LOG could be specified (in the tdpo.opt file) for the autobackup so that the errorlog would go to a different directory - in this way these logs could be monitored separately. -- Date:Tue, 4 Nov 2003 16:28:55 +0100 From:Loon, E.J. van - SPLXM [EMAIL PROTECTED] Subject: TDP for Oracle Errors Hi *SM-ers! Our Oracle guys and girls are currently testing DP for Oracle 5.2 on Oracle 9i. They turned one a new RMAN feature for automated controlfile backup (for those of you interested, the command is 'configure controlfile autobackup on;') Now, whenever a controlfile backup is running it generates the following error in both the tdpoerror.log and the actlog: ANE4994S (Session: 1437562, Node: KL1003VC-ORC) TDP Oracle AIX ANU0599 ANU2602E The object /mount/appl1//c-213141136-20031104-0e was not found on the TSM Server We had to make a trace to see that this error is generated because TSM first checks whether the object exists on the server before allocating it. I created a PMR for this behavior and level 1 now says: works as designed, just suppress ANE4994S from the actlog (impossible since ANE4994S is a generic message) and build something yourself to clear your tdpoerror.log periodically. I find this a VERY disappointing reply from IBM Has anybody encountered this behavior to and maybe found a better way to solve these errors? Maybe someone from development listening on this list has a good suggestion? I'm really stuck here with the Dutch level 1 support... :-(( Kindest regards, Eric van Loon KLM Royal Dutch Airlines Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED]
Re: TDPO V5.2 with RMAN setup
Dale, You explanation of the environment might need a bit of clarification but I will make some guesses for now. If you are running Oracle 9.2, that version of Oracle is 64bit (Oracle dropped 32bit AIX with 9i) and therefor you will need to make sure that your Data Protection for Oracle and your TSM API (comes with DP for Oracle package) are 64bit. It does not matter what your kernel mode is set to, the Oracle and DP for Oracle have to be the same architecture. Once you verify that you will need to make sure that your linking is set correctly as explained below. The most common problems are due to the name of the Data Protection for Oracle library (/usr/lib/libobk64.a). Regardless of whether Oracle is 32bit or 64bit it expects this library name to be the same (/usr/lib/libobk.a) - we chose this naming to allow for both 32 bit and 64bit Oracle to be installed on the same machine. You have several options at this point: You can rename the link /usr/lib/libobk64.a to /usr/lib/libobk.a and that should allow Oracle to easily find the library. You can make the link $ORACLE_HOME/lib/libobk.a - /usr/lib/libobk64.a and then export LD_LIBRARY_PATH=$ORACLE_HOME/lib;$LD_LIBRARY_PATH Or, you can make the link $ORACLE_HOME/lib/libobk.a - /usr/tivoli/tsm/client/oracle/bin64/libobk64.a and then export LD_LIBRARY_PATH=$ORACLE_HOME/lib;$LD_LIBRARY_PATH I am sure that my explanations are a bit vague. If you want more detailed information please go to link below as there are many documents that explain in more detail this and other potential gotchas. Hope this helps. http://www-3.ibm.com/software/sysmgmt/products/support/ -- Date:Mon, 27 Oct 2003 15:47:39 -0600 From:Dale Gieseke [EMAIL PROTECTED] Subject: TDPO V5.2 with RMAN setup Greeting all, My DBAs are having a problem with TDP for Oracle version 5.2. Was hoping = someone would be able shed some light on our problem. Thanks in advance = for any informantion you can provide. =20 Environment: TSM server 5.1.7.2 (on AIX 5.1 32bit kernel) Oracle 9.2 and TDPO 5.2 (on AIX 5.1 32bit kernel) TSM client V5.1.6.9 32bit =20 Dale Gieseke=20 TSM administrator The Toro Company [EMAIL PROTECTED] =20 =20 Following is the error information from my DBAs: =20 RMANconfigure channel 1 device type sbt format 'orc_%d_%t'; RMANconfigure channel 1 device type sbt PARMS 'ENV=3D(TDPO_OPTFILE=3D/orac= le/admin/rman/optfile/tdpo_osmt.opt)'; RMAN backup database; =20 Starting backup at 27-OCT-03 RMAN-00571: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-00571: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-03002: failure of backup command at 10/27/2003 10:23:03 ORA-19554: error allocating device, device type: SBT_TAPE, device name:=20 ORA-27211: Failed to load Media Management Library Additional information: 8 =20 sbttest test The sbt function pointers are loaded from oracle.static library. libobk.a(shr.o) could not be loaded. Check that it is installed =20 =97= RMANallocate channel x1 type 'sbt_tape' 2 PARMS=3DSBT_LIBRARY=3Doracle.disksbt, 3 ENV=3D(BACKUP_DIR=3D/oracle/DBAQ/archlog); 4 backup database; =20 This runs fine. Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: ITSM for Databases 5.2 requirements
-- David, Data Protection for Oracle will work with your current server without losing any functionality. However, in the manual we are required to state the lowest server version that is in support at the time of release. -- Date:Mon, 6 Oct 2003 17:30:50 -0400 From:David Longo [EMAIL PROTECTED] Subject: ITSM for Databases 5.2 requirements I am going to need to use ITSM for Databases (TDP Oracle) to backup Oracle 9.2.2 DB on Solaris 8, 64bit. The Tivoli Manual states requiremen= ts for TDPO 5.2 as TSM API 5.1.5 and TSM Server 5.1.0 as minimum. However the online requirements say TSM API 5.1.5 but just says TSM server, doesn't state a version. Question: Does TDPO 5.2 work with my current TSM Server 4.2.3.4 on AIX? If it works, do I loose any functionality by staying with this serv= er? (I will be upgrading to 5.1 or 5.2 server soon, just want to see if I will be forced sooner). Thanks, David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: RMAN crosscheck command and ITSM for DB 5.2
Matt, Rman crosscheck will only expire those backups that belong to that node during the RMAN crosscheck. This statement does not belong in the manual, I am glad that you pointed this out. There is no need for your DBA's to be concerned that other data is needlessly getting expired. -- Date:Tue, 30 Sep 2003 09:57:05 +0100 From:Thomas, Matthew [EMAIL PROTECTED] Subject: RMAN crosscheck command and ITSM for DB 5.2 *SMers In the ITSM for Databases v5.2 (Oracle) manual SC32-9064-00 it states: Be aware that the RMAN crosscheck command will expire backups on the Tivoli Storage Manager Server that belong to a different Tivoli Storage Manager node or file space. ...three times (relating to policy set up, deleting old backups and using utilities). Our DBAs were understandably a bit concerned having seen this and would like some clarification, since they use crosscheck as part of their backup expiration/deletion scripts. It seems to indicate that the crosscheck command will expire Oracle backups for ALL our nodes backing up to a given TSM server, although i'm sure this can't be the case. I presume that this is true only if you don't specify the TDPO.opt file during deletion script? Can anybody confirm or refute this as it's not very clear and it's a alarmed our DBAs somewhat TIA Matt Thomas Storage Support - Open Systems ITSD Service Introduction * internal7-430-3213 * external020-7922-3213 * e-mail [EMAIL PROTECTED] --- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Oracle Recovery failed
The log from the first backup is a little baffling because Oracle is claiming that it cannot find the archive log but Data Protection for Oracle is not complaining. Compare it to the second log where DP for Oracle is actually giving an error that the archive log requested by Oracle cannot be found on the TSM Server. The information that you have given me thus far does not tell me much. However, in this RAC environment are you backing up your data all from the same node in the cluster? If not are you duplicating the DP for Oracle nodename to all DP for Oracle nodes so that all the backups are cataloged to the TSM Server under the same node? The most common problem seen in RAC environments are the fact that backups are done from different nodes from within the environment but each node is using slightly different TSM/TDP options so that during the restore to a particular node not all of the backup information can be retrieved. These are just some thoughts that I have. If none of this helps I highly suggest that you use our support channels to resolve this problem; they are knowledgable in this area. -- Date:Wed, 24 Sep 2003 18:55:06 +0200 From:Nalevajko Tomas [EMAIL PROTECTED] Subject: Oracle Recovery failed Hello guys, I encounter problems in oracle recovery and I'd like to ask for some suggestion what to check or change. We have implemented TDP for Oracle. There is Oracle RAC. Backup entire database succeed. Problems are if we try to make recovery. Restore process goes ok, all dbf files are restored. There are failure in recovery when restoring/recovering archive log files. this is portion of log file from first try: Starting recover at 23-SEP-03 starting media recovery channel node2: starting archive log restore to default destination channel node1: starting archive log restore to default destination channel node2: restoring archive log archive log thread=2 sequence=344 channel node1: restoring archive log archive log thread=1 sequence=798 channel node1: restored backup piece 1 piece handle=fjf20obo_1_1 tag=TAG20030922T233624 params=NULL channel node1: restore complete unable to find archive log archive log thread=1 sequence=798 released channel: node1 released channel: node2 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of recover command at 09/23/2003 09:08:20 RMAN-06055: could not find log sequence 798 thread 1 RMAN **end-of-file** and something like this in another try: channel node1: starting archive log restore to default destination channel node2: starting archive log restore to default destination channel node1: restoring archive log archive log thread=1 sequence=800 channel node2: restoring archive log archive log thread=1 sequence=801 channel node1: restored backup piece 1 piece handle=frf21o42_1_1 tag=TAG20030923T083826 params=NULL channel node1: restore complete released channel: node1 released channel: node2 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of recover command at 09/23/2003 12:09:25 ORA-19507: failed to retrieve sequential file, handle=fvf21p7c_1_1, parms= ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1302E (RC2)No objects on server match query RMAN **end-of-file** There is also non clustered databse on one node. We did not see any problems with this database. Several tries was made. Finally, it recovered successfuly but during another restore/recovery after database backup it behaves same as before. Any ideas or suggestions? Thanks. -- Nalevajko Tomas e-mail: [EMAIL PROTECTED] homepage: www.dcs.fmph.uniba.sk/~nalevajk -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: TDP for oracle on linux
Karla, Data Protection for Oracle 5.2.0 support AS 2.1!! -- Date:Thu, 11 Sep 2003 07:31:10 -0500 From:Karla Ross [EMAIL PROTECTED] Subject: TDP for oracle on linux Does anyone know if there is a TDP for oracle that will run on Linux redhat interprize AS 2.1? Karla Ross -- Regards, Neil Rasmussen Software Development Data Protection for Oracle
Re: TDP Oracle config question
Steve, The reason that you are seeing this error is that Oracle/Rman first tries to delete the backuppiece that it is about to create on the TSM Server. In this way Oracle/Rman ensures that only one copy of the backuppiece exists on the Backup Media so Rman tries to delete the backuppiece in case it already exists. The Rman specifications state that only one copy of a backuppiece will exist at one time on Media Manager (DP for Oracle). Unfortunately, Oracle/Rman also specifies that the delete routine act as single and seperate operation, so when Oracle tries to delete a backuppiece that does not exist, that is an error and DP for Oracle returns that error. There is no way for DP for Oracle to determine if the deletion is a true delete of a backuppiece or if Oracle is checking for backuppiece existence prior to backup. Hope this helps clear things up. -- Date:Wed, 16 Jul 2003 13:13:39 -0600 From:Conko, Steven [EMAIL PROTECTED] Subject: Re: TDP Oracle config question Thanks for that bit of information... it definitely clears some things up. According to the docs, we should be using unique TDPO_FS names for each node we are backing up using TDP, correct? After doing the query and some further investigation into the BACKUPS table, it appears we are getting this message because of a missing - When I do a select in the BACKUPS table, the LL_NAME shows up as: c-3756527612-2003-0714-02 However, in the error we are getting, the name of the object is: c-3756527612-20030714-02 Any idea why this is?? Steve Regards, Neil Rasmussen Software Development TDP for Oracle
Re: TDP Oracle config question
Steve, Can you answer me this? Does your backup actually fail, or is this just something that shows up during a successful backup? The /adsmorc filespace is a TSM Server filespace and is the default for TDP Oracle and will get created during the backup, if it doesn't already exist. Unless of course, you are specifying something other than the default (the option is TDPO_FS). -- Date:Tue, 15 Jul 2003 13:42:36 -0600 From:Conko, Steven [EMAIL PROTECTED] Subject: TDP Oracle config question TSM Server: AIX 4.3.3, TSM 5.1.5.4 RMAN Server: AIX4.3.3, TDP 5.2 RMAN Client: AIX 4.3.3, TSM 5.1.5, TDP5.2 The installation guide seems to be a little fuzzy on this topic... At some point during the backup process we get this error in our tdpoerror.log file: 23:28:55 ANS4994S TDP Oracle AIX ANU0599 ANU2602E The object /adsmorc//c-3756527612-20030714-03 was not found on the TSM Server After doing some of my own research I realize its telling me that the /adsmorc file space does not exist. My question is where is is supposed to exist? Am I supposed to create an adsmorc file system or directory on the TSM server, on the TDP/RMAN server, or the client? Is anything ever going to get put there? Does it need to be its own mount point? Any help would be greatly appreciated. Thanks in advance Steve Regards, Neil Rasmussen Software Development TDP for Oracle
Re: TDPO 5.2 error 2534
Eric, A return code 2534 should be referenced in the TDP Oracle manual - probably as ANS2534. Anyways, 2534 is an options file error. However, there should have been created a file called tdpoerror.log. This file get created in the local directory (what ever happens to be local for Oracle). I just ran a quick test and found that to be $ORACLE_HOME/dbs/tdpoerror.log. In the tdpoerror.log you should see the exact reason for failure. Hope this helps. -- Date:Tue, 1 Jul 2003 17:05:11 +0200 From:Loon, E.J. van - SPLXM [EMAIL PROTECTED] Subject: TDPO 5.2 error 2534 Hi *SM-ers! We are testing TDP for Oracle 5.2 on AIX 5.2 with Oracle 9i. We configured everything by the book, but when we try to run a backup we receive the following error: RMAN backup 2 incremental level = 0 3 tag inc0 4 filesperset 5 5 (database include current controlfile); Starting backup at 01-JUL-03 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of backup command at 07/01/2003 15:30:24 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer IBM AIX RISC System/6000 Error: 2534: System call error number 2534. I know that error 2534 is a TDPO return code, but where can we find the explanation of those return codes? Both log files (dsierror.log and sbtio.log) are empty... Thanks in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines Regards, Neil Rasmussen Software Development TDP for Oracle
Re: Password file for TDP Oracle on Windows platform
Try generating your password first with 'tdpoconf passw
-tdpo_optfile=C:\progra~1\Tivoli\TSM\AgentOBA\tdpo_ori.opt'. You should really read
the manual on password generation it should
explain all the particulars about Windows and using
passwordaccess=generate. Also, pay attention to the section about using
the utilities like 'tdpoconf'.
From the error I see below, though, I am just going to guess that you set
TDPO_NODE in your tdpo_ori.opt file. The only nodename that you should set
is in your TSM API dsm.opt file. Hope this helps.
Regards,
Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]
Ameerul Mazli [EMAIL PROTECTED]
03/27/2003 05:19 PM
To: Neil Rasmussen/San Jose/[EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: Password file for TDP Oracle on Windows platform
Hi Neil,
I did try the passwordaccess generate option for the
tdp oracle node but it gave me the error in rman:
:\Program Files\Tivoli\TSM\AgentOBArman target
sys/[EMAIL PROTECTED] rcvcat r
man/[EMAIL PROTECTED]
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: ORIHRM
(DBID=3027765092)
RMAN-06008: connected to recovery catalog database
RMAN run
2 {
3 allocate channel t1 type 'sbt_tape' parms
4
'ENV=(TDPO_OPTFILE=C:\progra~1\Tivoli\TSM\AgentOBA\tdpo_ori.opt)';
5 backup
6 full
7 filesperset 5
8 format 'df_%t_%s_%p'
9 (database);
10 release channel t1;
11 }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for
Oracle: version 2.2.1.0
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile
backupset
RMAN-08502: set_count=74 set_stamp=489701281
creation_time=26-MAR-03
RMAN-08010: channel t1: specifying datafile(s) in
backupset
RMAN-08522: input datafile fno=1
name=D:\ORACLE\ORADATA\ORIHRM\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=3
name=D:\ORACLE\ORADATA\ORIHRM\USERS01.DBF
RMAN-08522: input datafile fno=7
name=D:\ORACLE\ORADATA\ORIHRM\DR01.DBF
RMAN-08522: input datafile fno=4
name=D:\ORACLE\ORADATA\ORIHRM\TEMP01.DBF
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03007: retryable error occurred during execution
of command: backup
RMAN-07004: unhandled exception during command
execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed
to create sequential file
, name=df_489701281_74_1, parms=
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: ANS0237E (RC2033) On dsmInit, the node is
not allowed when PASSWORDAC
CESS=generate.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
--
When i change it back to password access prompt, it
will give the authentication failure message as
bellow:
RMAN run
2 {
3 allocate channel t1 type 'sbt_tape' parms
4
'ENV=(TDPO_OPTFILE=C:\progra~1\Tivoli\TSM\AgentOBA\tdpo_ori.opt)';
5 backup
6 full
7 filesperset 5
8 format 'df_%t_%s_%p'
9 (database);
10 release channel t1;
11 }
RMAN-08031: released channel: t1
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for
Oracle: version 2.2.1.0
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile
backupset
RMAN-08502: set_count=75 set_stamp=489701478
creation_time=26-MAR-03
RMAN-08010: channel t1: specifying datafile(s) in
backupset
RMAN-08522: input datafile fno=1
name=D:\ORACLE\ORADATA\ORIHRM\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=3
name=D:\ORACLE\ORADATA\ORIHRM\USERS01.DBF
RMAN-08522: input datafile fno=7
name=D:\ORACLE\ORADATA\ORIHRM\DR01.DBF
RMAN-08522: input datafile fno=4
name=D:\ORACLE\ORADATA\ORIHRM\TEMP01.DBF
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK
FOLLOWS ===
RMAN-00571:
===
RMAN-03007: retryable error occurred during execution
of command: backup
RMAN-07004: unhandled exception during command
execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed
to create sequential file
, name=df_489701478_75_1, parms=
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: ANS1025E (RC137) Session rejected:
Authentication failure
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
Re: Password file for TDP Oracle on Windows platform
Password generation is related to the node name, so there will only be two passwords if you are using two different node names for each TDP Oracle instance (which I hope you are). Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED] Ameerul Mazli [EMAIL PROTECTED] 03/24/2003 10:26 PM To: [EMAIL PROTECTED] cc: Neil Rasmussen/San Jose/[EMAIL PROTECTED] Subject:Re: Password file for TDP Oracle on Windows platform Hi Neil, What if there are 2 instances of Oracle? Will there be 2 password in the registry too? Thanks and regards Ameerul Madzali Forwarded Message Date: Mon, 24 Mar 2003 08:36:29 -0800 From: Neil Rasmussen [EMAIL PROTECTED] Subject: Re: Password file for TDP Oracle on Windows platform Ameerul, On Windows TDP Oracle uses password access generate. Therefore, the password is encrypted and stored in the registry. Have you generated a password before? In your dsm.opt file makesure that passwordaccess is set to generate and use 'tdpoconf passw' to create a password in the registry. Hope this helps. -- Date:Sun, 23 Mar 2003 17:53:40 -0800 From:Ameerul Mazli [EMAIL PROTECTED] Subject: Password file for TDP Oracle on Windows platform Hi All, Does anyone know where or what is the password file name if you have TDP Oracle on a Windows platform? 1. I know for Solaris, it will create a file called TDPO.nodename in the TDPO_PSWDPATH directory. What abt Windows NT/2000? 2. The thing is I've an error authentication failure when i do the tdpoconf showenv. Pls help me with the above. Thx in advance. Ameerul __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
Re: Password file for TDP Oracle on Windows platform
Ameerul, On Windows TDP Oracle uses password access generate. Therefore, the password is encrypted and stored in the registry. Have you generated a password before? In your dsm.opt file makesure that passwordaccess is set to generate and use 'tdpoconf passw' to create a password in the registry. Hope this helps. -- Date:Sun, 23 Mar 2003 17:53:40 -0800 From:Ameerul Mazli [EMAIL PROTECTED] Subject: Password file for TDP Oracle on Windows platform Hi All, Does anyone know where or what is the password file name if you have TDP Oracle on a Windows platform? 1. I know for Solaris, it will create a file called TDPO.nodename in the TDPO_PSWDPATH directory. What abt Windows NT/2000? 2. The thing is I've an error authentication failure when i do the tdpoconf showenv. Pls help me with the above. Thx in advance. Ameerul __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Regards, Neil Rasmussen Software Development TDP for Oracle
Re: tdpoconf error --- ANS0236E (RC2032)
I did not paste all of the original information because it gets a bit cumbersome to read. But if you go back and look at some key things in the 'tdpoconf showenv' dump you will notice that you are specifying an options file that exists in .../oracle/bin64 directory but you are using a 32bit AIX TDP Oracle client, did you mean to do this? It is not mandatory, but I would highly recommend keeping 32bit configuration files in the 32bit client directory until you can work through these problems. What server stanza are you using in /usr/tivoli/tsm/client/oracle/bin64/dsm.opt? If you prefer we can take this off line too. Also, on another note: do not worry about what client code versions you see in the TDP Oracle trace, that has nothing to do with the BA Client you have on your machine. -- Date:Tue, 11 Mar 2003 14:14:51 -0500 From:shekhar Dhotre [EMAIL PROTECTED] Subject: tdpoconf error--- ANS0236E (RC2032) Hi All , I have double checked dsm.sys file and other opt file ,no ASSWORDACCESS=generate .. Still I get the following error. has anyone seen this error before ?? tdpoconf password -tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: TDP for Oracle on Linux
Lars, Data Protection for Oracle on Linux Intel is due to release with ITSM 5.2. Keep an eye out for the RFA on this. -- Date:Thu, 6 Mar 2003 14:18:38 +0100 From:Lars Bebensee [EMAIL PROTECTED] Subject: TDP for Oracle on Linux Hi guys and girls, does anyone of you know if there are plans to support the TDP for Oracle on Linux in the near future? If so, when can we expect public availability? Thanks a lot Lars -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Help setting up RMAN w/ TDP 2210
Theresa, The 2518 return code you are seeing means that the license file that Data Protection for Oracle is picking up and reading is not a valid license file for TDP Oracle. It could be that your license file was corrutped during install?? Unfortunately, troubleshooting is very hard with Rman when a failure occurs during initialization - It isn't until a later function call that Rman will actually send a meaningful message to the Rman output. If you believe that the license file is the correct one for TDP Oracle, try removing and reinstalling TDP Oracle. Hope this helps. -- Date:Mon, 24 Feb 2003 17:35:27 -0500 From:Theresa Sarver [EMAIL PROTECTED] Subject: Help setting up RMAN w/ TDP 2210 This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_623D0BF3.7E1F7317 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi all; I'm having all kinds of problems and am hoping someone can assist me with = this setup...as I'm all confused at this point. Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: When comes the supportTDP for Oracle 9.2.x.x
Michael, We support 9.2 with Data Protection for Oracle 2.2.1 (Data Protection for Oracle 5.1.5 on AIX 5L 64bit). -- Date:Thu, 13 Feb 2003 08:26:46 +0100 From:Schmitz Garnebode [EMAIL PROTECTED] Subject: When comes the supportTDP for Oracle 9.2.x.x Good morning, can anybody tell me when Tivoli support Oracle 9.2.x.x with TDP ?? MfG Michael Garnebode Diplom-Informatiker Schmitz Rz Consult GmbH Bachstr.1 50259 Pulheim Tel.: 02238/922266 Fax: 02238/922267 EMail: [EMAIL PROTECTED] Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: TSM for Oracle
Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: www.homestead.com/topas/topas.html -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Help w/TDP for Oracle w/RMAN
Holly, There are no specific environment variable to set for restores. What you do need to make sure of is that you are using the same options for restore that you used for backup. In particular you need to make sure the filespace on the server is set the same for both backups and restores. It may help you to verify (query) that the particular backuppiece that you backed up is sitting on the TSM Server and that it is in the filespace that you expect. -- Date:Thu, 7 Nov 2002 16:45:28 -0500 From:Peppers, Holly [EMAIL PROTECTED] Subject: Help w/TDP for Oracle w/RMAN All, Please help. :-) WE are currently receiving an error message when trying to retrieve files via TDP for Oracle w/RMAN. The error we are seeing is as follows: ANS1302E (RC2) No objects on server match query I'm thinking there may be an environment variable that needs to be specifically set for the restores? Seems like I heard that somewhere once before...but if so, I'm not sure where it is or what it is. Let me know if any of you have any hints. Thanks. Holly L. Peppers BCBSFL Technical Services Regards, Neil Rasmussen Software Development TDP for Oracle
Re: TDPOCONF ANU2521 Error
Gagan Singh Rana, Check the path really closelyI am just going to venture a guess and say that you copied the sample options file to tdpo.opt. Depending on the platform, there was a typo in the path for TDPO_PSWDPATH in the sample file. -- Date:Tue, 29 Oct 2002 12:06:39 +0530 From:Gagan Rana [EMAIL PROTECTED] Subject: TDPOCONF ANU2521 Error Dear *smites I am facing a very strange problem with my TDP for Oracle 2.2 on Solaris 8 with Oracle 8.1.5 Whenever I run Tdpoconf password - it gives me the error error opening /opt/tivoli/tsm/client/oracle/bin check the permissions When I run the tdpoconf showenv, it gives me all the details except the error for the password file. I have tried all the means I could but without any +ve results. I request you to kindly help me with this. Thanks and regards Gagan Singh Rana -- Gagan Singh Rana Regards, Neil Rasmussen Software Development TDP for Oracle
Re: Oracle and TDP issues
Steve, I see a need for a correction here: IBM Tivoli Storage Manager for Databases, Data Protection for Oracle 5.1.5 (at 2.2.1), this is what Tivoli is calling it now, does support Oracle 9i and has since the release of 2.2.1. If this is information that you received from us, please tell me where so that I may correct it. Thank you. -- Date:Wed, 23 Oct 2002 08:57:19 +0800 From:Tailor, Steve [EMAIL PROTECTED] Subject: Re: Oracle and TDP issues There is a program supplied with Oracle 7 called EBU. What we are doing is to use EBU to backup the database to disk and then do an archive of the backup. It all works OK as long as you have the disk space. We also have to do this with our Oracle 9 databases as TDP for that version is not yet available. Regards Steve Tailor Technical Consultant Regards, Neil Rasmussen Software Development TDP for Oracle
Re: Monitoring oracle Backups
Joe, Not sure what version of TDP for Oracle you are using, but with TDP Oracle 2.2.1 we actually send 2 messages to the TSM Server activity log that you may find useful: ANU2535I File /fs/ll/backuppiece = number of bytes sent. (This denotes a successful backup) ANU2536I File /fs/ll/backuppiece = number of bytes received. (This denotes a successful restore). Note: On UNIX the Low Level path (ll) is empty on Windows the Low Level path is /orcnt. These two messages may be of some use to you to help automate your notifications. -- Date:Tue, 22 Oct 2002 09:26:28 -0400 From:Wholey, Joseph (TGA\\MLOL) [EMAIL PROTECTED] Subject: Monitoring oracle Backups Recently installed TDP for Oracle. DBA's would like to be paged real time if a database backup fails. Aside from the paging part, does anyone know where I can pull the status of an Oracle database backup as soon as it completes. I don't want to extract from the client logs (when would I start looking?) And the Activity log does not supply all that much useful information. Any help would be greatly appreciated. thx. -joe- Regards, Neil Rasmussen Software Development TDP for Oracle
Oracle 8.1.7 backup failure
Tim, TDP Oracle 2.1.0.9 is a pretty old version of TDP Oracle - there was not real robust logging in that version. A few questions: Is this your only backup that is failing? How about TSM API logging? Some of TDP Oracle log events get logged to the API log file. In the mean time try this: 'ENV=(DSMO_DEBUG=49)'; This will cause TDP Oracle to trace to the sbtio.log file located in the Oracle target db's 'bdump' directory. You can try to analyze this trace file or email it to me and I will take a look at it. In fact we can take this offline from the ListServ and then post our findings at the end. Thanks. -Original Message- From: HEMPSTEAD, Tim [mailto:Tim.HEMPSTEAD;READING.SEMA.SLB.COM] Sent: Friday, October 18, 2002 5:06 AM To: [EMAIL PROTECTED] Subject: Oracle 8.1.7 backup failure People, Anybody have any ideas on how we can fix the following. We have Oracle 8.1.7.0 backing up to TSM 3.7.4 using TDP for Oracle 2.1.0.9 under AIX 4.3.3 ML8. Backup fails with the error message as below after approximately 2hrs and errpt indicates that Oracle core dumps at this time as well. Thanks Tim The error obtained is as follows: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03015: error occurred in stored script backup_db_level_0 RMAN-03006: non-retryable error occurred during execution of command: backup RMAN-07004: unhandled exception during command execution on channel tape1 RMAN-10035: exception raised in RPC: ORA-00447: fatal error in background process RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE -- Tim Hempstead, [EMAIL PROTECTED] Unix Technical Specialist SchlumbergerSema Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Client install on Unix (Also running TDP for Oracle)
Mark, libApiDS.so is the TSM API library which is also part of the BA Client package. When you removed the BA Client with 'pkgrm', you also removed the TSM API library. TDP Oracle has a dependency on the TSM API library to communicate with the TSM Server. Essentially, the rug was just pulled out from under Oracle. What needs to be done to fix this is to make sure all the links are in their proper places. With all Oracle/Rman instances shutdown (including listener), check that the following links are in place: (I will assume 32bit) $ORACLE_HOME/lib/libobk.so - /usr/lib/libobk.so /usr/lib/libobk.so - /opt/tivoli/tsm/client/oracle/bin/libobk.so (Make sure the libobk.so file exists in /opt/tivoli/tsm/client/oracle/bin ) /usr/lib/libApiDS.so - /opt/tivoli/tsm/client/api/bin/libApiDS.so (Make sure the libApiDS.so file exists /opt/tivoli/tsm/client/api/bin ) You may want to run the command: # /usr/ccs/bin/what /usr/lib/libApiDS.so | more This should tell you that this link is pointing to a valid TSM API and it will give you the version of the API. Since you upgraded client to 5.1, the API should have been upgraded as well, and the 'what' command should reflect this. If you find the TSM API is not installed you can reinstall the BA Client package and only select the API for that installation. Hope this helps. -- Date:Wed, 18 Sep 2002 15:00:44 -0500 From:Mark Hayden [EMAIL PROTECTED] Subject: Client install on Unix (Also running TDP for Oracle) Question, we just finished installing just the client on a Unix machine = running Solaris 8. We upgraded the client to TSM 5.1 When we did the PKGRM = for just the Tivoli client software, (did not remove the TDP for Oracle) = we noticed that we could not bring the Oracle DB back up. It was looking = for a file called libApiDS.so which is located in the API/BIN directory of = the client. So when we removed the TSM software, we started to get the = error. My question, does anyone know why and what this file is used = for Below is the actual error. ld.so.1: oracleorap: fatal: libApiDS.so: open failed: No such file or = directory ERROR: ORA-12547: TNS:lost contact Thanks, Mark Hayden Informations Systems Analyst E-Mail: [EMAIL PROTECTED] -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Error allocating SBT_TAPE device
Christy, 2512 is the return code from TDP Oracle...means that you had a license file (agent.lic) error. Check that it exists in /usr/tivoli/tsm/client/oracle/bin. -- Date:Tue, 10 Sep 2002 02:39:31 +0800 From:Christy Wu, T.F. [EMAIL PROTECTED] Subject: Error allocating SBT_TAPE device Folks, Wonder if anyone out there ever came across problem with Oracle RMAN utility? How did you solve it then? The OS is AIX 4.3.3 M10 and Oracle is ver8.1.7. TSM is ver5.1.1 and TDP for Oracle is 2.2.10 RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: allocate RMAN-07004: unhandled exception during command execution on channel t1 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: 2512: System call error number 2512. Additional information: 7011 ORA-19511: SBT error = 7011, errno = 2512, sbtopen: system error RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DEVICEALLOCATE Best regards, Christy -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: RMAN error
I have here our preferred method for starting Rman with the TSM Scheduler: When using the TSM scheduler to automate the TDP Oracle backups, the differences in how these two clients work must be taken into account. - The scheduler runs as root and would need passwordaccess generate. - The TDP Oracle backup runs as an Oracle user and need passwordaccess prompt. Since the TDP client requires passwordaccess prompt, automating the TSM scheduler process on the client machine often encounters various issues. The following steps should assist with clarifying how to setup this type of configuration for a working environment. To setup the TSM Scheduler for the TDP Oracle node, it is critical that the password for the node on the TSM Server be set so that the password will not expire. Then setup the TDP Oracle to use PasswordAccess prompt and setup the TSM Scheduler (for the tdp oracle backup) to use PasswordAccess generate. To use only one dsm.sys file, ensure there is a symbolic link to this single dsm.sys file so it can be seen from the API directory (/opt/tivoli/tsm/client/api/bin) and the TDP can find and use this dsm.sys. In this one dsm.sys file, there will normally be more than one ServerName stanza when using the TDP Oracle on the same machine. One ServerName stanza for the filesystem backups and another ServerName stanza for the TDP Oracle backups (which need passwordaccess prompt). To assist with setting up the TSM Scheduler for the TDP Oracle node, you would need to create a third ServerName stanza in this dsm.sys file. In general, the dsm.sys file would be similar to the following: servername TSMbackup COMMMETHOD tcpip TCPServeraddressxxx.xxx.xxx.xxx TCPPORT1500 NODENAME Client PASSWORDACCESSgenerate servername TSMOracle COMMMETHOD tcpip TCPServeraddress xxx.xxx.xxx.xxx TCPPORT1500 PASSWORDACCESSprompt servername TDPSched COMMMETHOD tcpip TCPServeraddressxxx.xxx.xxx.xxx TCPPORT1500 NODENAME TDPNode PASSWORDACCESSgenerate You would have three dsm.opt files. One for the Backup/Archive client that would normally be located in the /opt/tivoli/tsm/client/ba/bin directory. Based on the dsm.sys example above, this would contain the line: servername TSMbackup There would be a second dsm.opt file (which could have a different filename, such as dsmoracle.opt) for the TDP for Oracle. Based on the dsm.sys example this user option file for the Oracle client would contain the line: servername TSMOracle and would have passwordaccess prompt. There would be a third dsm.opt file (which could have a different filename, such as dsmsched.opt) for the TDP for Oracle scheduler. Based on the dsm.sys example this user option file for the Oracle client would contain the line: servername TDPSched and would have passwordaccess generate and have the NodeName for the TDP Oracle client specified. Environment variables would need to be utilized with the Oracle backup to point to the user option file. This would be specified in the TDPO_OPTFILE with the DSMI_ORC_CONFIG variable. For example: DSMI_ORC_CONFIG /opt/tivol/tsm/client/oracle/bin/dsmoracle.opt When starting the TSM Scheduler for the TDP Oracle backups, you will need to use the -SErvername parameter and specify which stanza should be used. Based on the example dsm.sys the scheduler command would be such as: dsmc sched -SE=TDPSched For the TDP backup, the script file for the command schedule backup will be launched by the scheduler daemon. Then within the command script launch the RMAN backup script. Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: sbtio error 959 and ANS1192E symbolic link not allowed
Chris, What version of TDP for Oracle are you currently using? I believe there was a fix related to this problem and it would really help if you could tell me what version you are on for my recommendation. Thank you. Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
tdpoconf, error, ANU2534E
Luis, I apologize, that is a pretty useless message (and not very helpful). But regardless, I think I can help you out. First off, are you using the tdpo.opt in the installation directory or are you defining it in your own directory? To start, I would use default installation directory /usr/tivoli/tsm/client/oracle/bin with the following in my tdpo.opt, substituting for your environment: In your /usr/tivoli/tsm/client/oracle/bin/tdpo.opt: DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin/dsm.opt TDPO_NODE node TDPO_OWNER owner In your /usr/tivoli/tsm/client/oracle/bin/dsm.opt: Servername your dsm.sys stanza servername In your /usr/tivoli/tsm/client/api/bin/dsm.sys: servername match from dsm.opt commm tcpip tcpport your TSM Server port number tcpsyour TSM Server address You should be able to establish a connection with your server with these basic settings. Then you should run tdpoconf password. Hope this helps. -- Date:Fri, 17 May 2002 03:23:15 + From:Luis Tapia [EMAIL PROTECTED] Subject: tdpoconf, error, ANU2534E Hi List, I`ve been trying to install TDP for Oracle for AIX 2.2.1 in a AIX 5.1 box, but I can not make the utility TDPOCONF work, it seems that my tdpo.opt file is not right but I cant not find where the problem is, when I issue and tdpoconf showenv or try to set the password I get an ANU 2534E Option file error the file tdpoerror.log is not very helpful, can somebody send me a working tdpo.opt/dsm.opt/dsm.sys set so i can use them as example? thanks for your help. Luis Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
TDP for Oracle causing Mutex problems.
Stuart, Are you setting TDPO_NUM_BUFFERS to something to other than 1 (default)? Setting TDPO_NUM_BUFFERS to anything higher causes TDP Oracle to spawn threads for sending data buffers to the TSM Server. If you have TDPO_NUM_BUFFERS in your options file, comment it out using '*' and run again. If you still experience this behavior, you have a couple of options: 1. Upgrade TDP for Oracle to 2.2.1, and/or 2. Call Tivoli support and open a problem record. -- Date:Tue, 14 May 2002 13:11:47 +0100 From:Stuart Pitt [EMAIL PROTECTED] Subject: TDP for Oracle causing Mutex problems. Hi, NT 4 Server running SP6a. TSM 4.2, TDP for oracle 2.2.0.2 We currently have a problem where, when our oracle database backups run, they are causing the Mutexes to hit 500 or above. Once this happens no one is able to logon to any of the databases, and the only way around this problem is to reboot the server, or stop and start the oracle scheduler service and all the databases affected. Anyone got any ideas please Regards Stuart Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: tdp-oracle 2.2.0.2 with unkown error
The rc = 406 is a return code from the TSM API and Oracle caught the
error. I am not sure why there is no logging from the TSM API to help you
indicate where the error originated. Rc = 406 is telling me that the TSM
API could not find the dsm.opt file. Please make sure that you're TDP for
Oracle options file has an entry similar to the following:
DSMI_ORC_CONFIGc:\tivoli\tsm\agentoba\dsm.opt
With this, TDP for Oracle will pass into the TSM API where to find the
dsm.opt file.
--
Date:Fri, 26 Apr 2002 12:19:03 +0200
From:Norbert Martin NKM-Solutions [EMAIL PROTECTED]
Subject: tdp-oracle 2.2.0.2 with unkown error
Hi,
at the moment we have the problem with a tdp for Oracle NT V2.2.0.2 an
Client 4.2.1.20
Please help
Has anybody seen this problem und lose this before?
Error Log / Sched Log:
04/25/2002 11:59:45 ANS1512E Scheduled event 'IC_V1_W1_NT_ORACLE' failed.
Return code = 3.
04/25/2002:09:44:48 PID158 == Error: pstdpoCallDsmSetUp failed. rc =
406
What is happend? The Oracle DB is a 8.0.5
RMAN-06005: connected to target database: SVP_BUHA
RMAN-06008: connected to recovery catalog database
RMAN run {
2 allocate channel t1 type 'SBT_TAPE' parms
3 'ENV=(TDPO_OPTFILE=c:\apps\tivoli\tsm\AgentOBA\tdpo.opt)';
4
5 allocate channel t2 type 'SBT_TAPE' parms
6 'ENV=(TDPO_OPTFILE=c:\apps\tivoli\tsm\AgentOBA\tdpo.opt)';
7
8 backup incremental level 0
9 format 'df_%t_%s_%p_%u_%c'
10 (database include current controlfile);
11
12 sql 'alter system archive log current';
13
14 backup archivelog all delete input
15 format 'df_%t_%s_%p_%u_%c';
16
17 release channel t1;
18
19 release channel t2;
20 }
21
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00569: error message stack follows
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-07001: could not open channel t1
RMAN-10008: could not create channel context
RMAN-10024: error setting up for rpc polling
RMAN-10006: error running sql statement: select distinct my.sid,
sex.serial
from
v$mystat my, x$ksusex sex where sex.sid = my.sid
RMAN-10002: ORACLE error: ORA-01455: converting column overflows integer
datatyp
with kind regards / mit freundlichen Gruessen
Norbert Martin
High End Storage Consultant
DISK / TAPE / SAN / TSM
Mobile:+49-170-2234111
E-Mail:[EMAIL PROTECTED]
Regards,
Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]
Re: TDP Oracle on Linux (was AIX 5.1)
Linux support for TDP for Oracle is due out 1Q03 time frame. -- Date:Tue, 23 Apr 2002 08:48:13 -0400 From:Zoltan Forray/AC/VCU [EMAIL PROTECTED] Subject: TDP Oracle on Linux (was AIX 5.1) Now then, how about a TDP for Oracle on Linux We have been running Oracle on a RH Linux box, for a long time. It is supported by Oracle ! Regards, Neil Rasmussen Software Development TDP for Oracle
Re: TDP Oracle on AIX 5.1
Luis, Yes, here is the site, it should be accessable from the internet. ftp://service.boulder.ibm.com/storage/tivoli-storage-management/ -- Date:Fri, 19 Apr 2002 19:12:21 + From:Luis Tapia [EMAIL PROTECTED] Subject: Re: TDP Oracle on AIX 5.1 Thanks Neil, yes, it4s AIX 5.1 32bit, which ftp site are you talking about? the one at service.boulder? it4s accesible from the internet? thanks again Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
TDP Oracle on AIX 5.1
Luis, What version of AIX 5 are you after, AIX 5 32bit? Tivoli has GAed TDP for Oracle 2.2.1 (aka 5.1.0) that supports AIX 5 32bit and has been available on the ftp site for some weeks now. If you do not qualify for FTP TDP for Oracle please see your rep. for the GAed version. AIX 5 64bit support will come at a later date, I just noticed that Oracle has released its developers release for Oracle 9i on AIX 5L (64bit). Hope this helps. -- Date:Wed, 17 Apr 2002 16:53:16 -0400 From:Luis Tapia [EMAIL PROTECTED] Subject: TDP Oracle on AIX 5.1 Hi list, I'want to know if some of you have some experiences installing TDP for Oracle for AIX in an AIX 5.1 box, as you know it is not supported but, is there a way? i mean, do i have to wait until tivoli releases 5.1 support? (someday) please help, i have a big warehouse oracle and i have to backup it to a robot in a TSM environment. thanks LT Regards, Neil Rasmussen Software Development TDP for Oracle
Re: Need help - TDP for Oracle on Solaris - Scheduler question
Here are some tidbits to scheduling Rman backups: First off, the method I am going to discuss can be found at: http://www.tivoli.com/asktivoli (registration is required, this is free) When using the TSM scheduler to automate the TDP Oracle backups, the differences in how these two clients work must be taken into account: o The scheduler runs as root and needs passwordaccess generate. o The TDP Oracle backup runs as an Oracle user and needs passwordaccess prompt. On the TSM server there would normally be two schedules setup for the machine where Oracle is located: 1) an incremental file system backup 2) a command schedule for the TDP backups. One way to set this up is to associate both schedules on the TSM server to the node that is performing the file system backup. This may initially be confusing as it would be anticipated that the nodename for the TDP backup should be used for the command schedule that is going to run the TDP Oracle backup. However, since the TDP client requires passwordaccess prompt, it is not possible to automate the schedule process on the client machine (without encountering various issues). If the regular backup/archive client node is associated with the command schedule, this usually has passwordaccess generate already set and is running as root on the client machine. Additionally, if using the Backup/Archive nodename, then only one scheduler daemon is needed on the client machine. For the TDP backup, the script file for the command schedule backup will be launched by the scheduler daemon. In this script, it will be necessary to switch user su to the Oracle user that is going to perform the backup. It is mandatory that the environment for the Oracle user be in existence, so the su will need to be done such that the .profile is sourced (the oracle variables esp. the ORACLE_SID and ORACLE_HOME need to be available for the TDP/RMAN backup). Then within the command script, launch the RMAN backup script. Having said this, it may be less confusing to run your backup as a cron job (this is my opinion). Regards, Neil Rasmussen Software Development TDP for Oracle
Re: Rman/TSm
One thing to note about TDPO_AVG_SIZE when using TDP for Oracle 2.2, and more importantly when using TDP for Oracle 2.2 with Oracle 8i or greater is that we no longer require the use of TDPO_AVG_SIZE. It used to be that Oracle (versions prior to 8i) did not send the size of the backup to TDP for Oracle. With 8i Oracle, the size of the backup piece which we send to the TSM Server is sent in place of TDPO_AVG_SIZE. Regards, Neil Rasmussen Software Development TDP for Oracle
TDPO 2.2.0.2 patch install on AIX
David, It may not be necessary at all to shutdown your Databases. However, because Oracle has changed the way they load in TDP for Oracle library from version to version, it is sometimes necessary and in our readme's we try to cover worst case scenario. In short, be aware that it could be necessary to shutdown the Oracle instances, your upgrade may do fine without doing so. -- Date:Tue, 12 Mar 2002 15:24:05 -0500 From:David Longo [EMAIL PROTECTED] Subject: TDPO 2.2.0.2 patch install on AIX I have anew install of TDP Oracle 2.2.0.0 on AIX and was going to follow up with the 2.2.0.2 patch before configuring. The README with the patch says All the database instances under $ORACLE_HOME should be shutdown before performing the following steps The steps are copying several TDP files and libobk.a file. Is this really necessary to shutrdown? Don't have to shutdown to install = 2.2.0.0. Thanks, David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 =46ax:321.434.5525 [EMAIL PROTECTED] MMS health-first.org made the following annotations on 03/12/02 15:37:26 ---= Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
HP server with Oracle 8.1.7 and Oracle 7.3.4
Gavin, There are some things to consider here. Both Oracle and Tivoli (TDP for Oracle) no longer supports Oracle 7. I highly recommend that you upgrade that Database. In fact, Oracle is pushing all customers to Oracle 8i or higher. Having said that, TDP for Oracle 2.2.0 in theory will backup Oracle 7 databases. The TDP for Oracle 2.1.10 code base still exists in the 2.2 code, the version of function calls is handled by Oracle so it knows the right sequence to call. However, I must mention again that we do not support Oracle 7 with TDPO any longer, and you must realize that if something goes wrong you are on your own. This also means that TDP for Oracle 2.1.10 no longer supports Oracle 7. -- Date:Mon, 4 Mar 2002 15:51:25 +1100 From:Ring, Gavin M [EMAIL PROTECTED] Subject: HP server with Oracle 8.1.7 and Oracle 7.3.4 Hello All I have a HP server running both Oracle 8.1.7 and Oracle 7.3.4 databases. I've installed TDP for Oracle 2.2.0 to backup the Oracle 8.1.7 databases, but how do I cater for the Oracle 7.3.4 databases? Is it possible to install TDP for Oracle 2.1.0 on the same system ? The TDP or Oracle 2.1.0 documentation indicates it will install over the top of the TDP for Oracle 2.2.0 software. Is it possible to install TDP for Oracle 2.1.0 in a location other than the default? Regards Gavin Ring EDS Australia Enterprise Storage -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Oracle9i + TDP for HPUX-11
For the current level of supported platforms follow the link below, this should answer questions 1 3. The short of it is, yes, we support HP and Solaris. TDP for Oracle does not yet support Oracle on Linux, this is in plan though. http://www.tivoli.com/products/index/data_protect_oracle/index.html 1. Does anybody use the above mentioned combination ? 2. BTW, is a TDP-LINUX-client available ( I didn't see it on the download-pages ) ? 3. What about a SOLARIS-platform ? Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
TDP Oracle 2.1.10 'libobk.so' problems on Oracle 8.1.7 / Solaris 2.7
Kent, The first real obvious thing that I see is the TSM API Architecture. If you are running 32bit TDP for Oracle then you TSM API needs to be 32bit. However, when you run the aobpswd it uses the TSM API to comunicate with the TSM Server to manage passwords so this indicates that they are both the same architecture. In short, you need to go back and make sure that Oracle and TDP for Oracle and the TSM API are all the same archetecture. The next step is to ensure that your soft links are in order for libobk.so. The link should look like the following: $ORACLE_HOME/lib/libobk.so - /usr/lib/libobk.so /usr/lib/libobk.so - /opt/tivoli/tsm/client/oracle/bin/libobk.so If the is correct and you verify that Rman is still is not using TDP for Oracle you might want to try running Oracle's linking process. - Shut down all Oracle instances that use $ORACLE_HOME - Go to the $ORACLE_HOME/lib directory. If the libobk.so file exists in this directory, remove it. - Go to the $ORACLE_HOME/rdbms/lib directory. - Enter the following command to relink RMAN with TDP for Oracle: $ make -f ins_rdbms.mk LLIBMM=/usr/lib/libobk.so ioracle - Verify that the relinking process has completed. Even though the above step is not supposed to be necessary, we have found that this works sometimes for us. -- Date:Thu, 7 Feb 2002 12:24:14 -0500 From:Kent Monthei [EMAIL PROTECTED] Subject: TDP Oracle 2.1.10 'libobk.so' problems on Oracle 8.1.7 / Solaris 2.7 We have the following configuration (all on same Sun Ultra server hardware/OS): Solaris 7 (64-bit kernel) Oracle 8.1.7/RMAN (32-bit) TSM Server 4.1.2 (new) TSM 4.1.2.12 BA Client (64-bit) (new) TSM 4.1.2.12 API (64-bit) (new) TDP Oracle 2.1.10 (32-bit) We're trying to test RMAN with TDP-Oracle, but are having problems getting Oracle/RMAN to interact with the TDP-Oracle 2.1.10 (32-bit) Media Management Library 'libobk.so'. RMAN fails to recognize 'SBT_TAPE'. Both Oracle and ADSM-L have posted problem reports on this issue which identified some Solaris OS patches. However, all of those patches are installed and we are still having problems. These Solaris OS patches are installed: 106300 106327 106980 106541 107544. One other mentioned patch 109104 has been superseded is not installed. There's a chance that 106980-07 is down-rev vs postings. Our Oracle admin advised me to install the 32-bit 'libobk.so' library for compatibility. I might suspect 32-bit/64-bit compatibility issues, but 'aobpswd' runs successfully, opening a TSM Server (v4.1.2) session of type 'TDP Oracle SUN'. Isn't that sufficient proof that the TDP-Oracle library and the TSM API configuration are functioning properly together? If so, where does the problem (more importantly the resolution) lie? If you can help me resolve this, rsvp.thanks Kent Monthei GlaxoSmithKline Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: TDPO 2.2
Chris, I am assuming you are refering to the sbtio.log and you are running TDPO 2.2.0.0. If my assumption is correct about the version, there was a bug (APAR IC30670) in TDP for Oracle where the logging to sbtio.log was always on with full tracing turned on so that this log file fills up quite rapidly. By default this file should only be written to if an error occurs. Get the latest fixtest TDP for Oracle 2.2.0.2 from the IBM ftp site and I believe this will fix your problem. -- Date:Tue, 18 Dec 2001 12:35:15 +0100 From:Christoph Pilgram [EMAIL PROTECTED] Subject: TDPO 2.2 Hi all, my question is about TDP for Oracle running on HP-UX 11.0 On our database-server is a logfile written in the .../udump-directory which contains messages with number SBT-13167. I cannot see who is writing these messages but there are a lot of these messages. I would like to stop the writing in the logfile, but I don't know how. Thanks for any help Chris Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Error: sbtread2 block 2296 does not match
Nina, Can you tell me more about your environment? What OS? What level of TDP for Oracle? What level of Oracle? Also, it might help if you know for sure that you are using TDP for Oracle and not Oracle's dummy library for this test. Of course, if you followed the installation process of TDP for Oracle from the manual this should not be a problem. --- Date:Mon, 17 Dec 2001 14:58:36 -0800 From:Nina [EMAIL PROTECTED] Subject: Error: sbtread2 block 2296 does not match Hi all, I am trying to set up TDP for oracle inorder to backup databases using RMAN. However, when I do and sbttest to test the MML, I get the following errors? Does any one know what is going on? Please help Error: sbtread2 block 2296 does not match Thanks Nina Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Neil Rasmussen/San Jose/IBM is out of the office.
I will be out of the office starting November 22, 2001 and will not return until December 10, 2001. I am on vacation and I will respond to your messages when I return. If this is an emergency please contact, Gary Coleman (manager).
Re: rman question
Steve, Rman will hold all channels until it finishes it processesing on the entire backup job. Rman usually does a good job making sure that the channels get equal amount of work but you can imagine that in some instances the majority of the work load goes to one channel. For instance: channel t1 backs up the control file and several small datafiles that equal 100mb while channel t2 gets a datafile (maybe the remaining backup piece) that is 700mb. In this case channel t1 will have finished long before channel t2 and then Rman holds the resources of t1 until t2 completes. Date:Mon, 22 Oct 2001 15:50:23 +0800 From:Steve de Souza [EMAIL PROTECTED] Subject: rman question Hi there I use tdp for oracle 2.2 on a tsm4.2 server I allocate 2 channels for the rman backup, t1 and t2 when the backup starts, it initially starts to write to 2 tapes. After a short while, one drive goes idle and the other tape continually gets written to, till completion of the backup. Anyone have any idea as to what is causing one the tapes to go idle? The backup files aren't very big. channels t1 and t2 continue to get 'allocated' to completion if the job. The mountretention on the devc is big. what else could I check? cheers steve Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
No Subject
Matt,
The section you are reading about is for Oracle 8.0.x. Is this the Oracle
level you are running on? Try creating the link like mentioned in the
8.1.x section. I don't think it is even necessary to run the link command,
although you may have to.
--
Date:Wed, 17 Oct 2001 13:53:57 +0100
From:Warren, Matthew James [EMAIL PROTECTED]
Subject: Re: TDPOracle v2.2 HPUX problem
I have tried creating the link manually, but no joy.
I have always ensured that the libobk.sl has been deleted from
${ORACLE_HOME} before performing the make command if I have created it by
hand.
Should I manually create the link, then run the Make? The installation
instruction specifically say to remove the link first.
I dont think the make is returning any errors, but it doesnt say anything
that makes nuch sense either. To me, it looks like it spits out a whole
set
of compiler options.
Thanks,
Matt.
Regards,
Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]
TDPOracle v2.2 HPUX problem
Matt, BACKUP_DIR is what Oracle uses to decide where on disk to backup the data when using Oracle's Internal Media Manager (DO NOT set this while using TDP for Oracle). What this is telling you is that Oracle/Rman does not recognize that there is a third party vendor available to use. Follow the linking process described in the manual for linking TDP for Oracle's libobk.sl with Oracle/Rman. TDPO_FS is for the filespace name on the TSM server. Date:Fri, 21 Sep 2001 11:27:29 +0100 From:Warren, Matthew James [EMAIL PROTECTED] Subject: TDPOracle v2.2 HPUX problem Hello TSM'ers, A DBA of ours is seeing the following error when trying to perform a backup using TDPOracle on an HPUX system, ABOX/opt/app/blooper9/admin/ABOX/udump $ tail -100 sbtio.log (10613) OBK-sbt: sbtinit: initializing SBT API (10613) OBK-sbt: sbtpvt_tfn: BACKUP_DIR not set. I have checked through TDPOracle documentation and cannot find any mention of BACKUP_DIR; I am not very au fait with the method used from within RMAN to start a backup and I have asked the DBA to check to see if BACKUP_DIR is a value that is needed by RMAN separate from TDPOracle. In the meantime, has anyone seen this before? Thanks, Matt. Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Does TDP 2.1.10 for NT support Oracle 8.1.6?
Hanna Hahne, Yes, 2.1.10 does support 8.1.7. Oracle 8.1.7 was release before TDP for Oracle V2.2 was released. We claimed support then, this information might have been discarded when the web pages were updated for V2.2. Regards, Neil G. Rasmussen TDP for Oracle E-mail: [EMAIL PROTECTED]
Re: BackUp Oracle with min data
Wang, Rman has control of the backup. And this is one of the purposes of Rman. Rman will only backup the data inside the datafile not the entire datafile. Does this answer your question? Regards, Neil G. Rasmussen E-mail: [EMAIL PROTECTED] Date:Fri, 22 Jun 2001 13:52:26 +0800 From:Lei L Wang [EMAIL PROTECTED] Subject: BackUp Oracle with min data Hi all, The size of my customer's Oracle data file is 1TG,but there is only 1G real data in the DB. How can I use TDP for Oracle to bacuk/restore the min data through Oracle RMAN? Thank you very much ! Wang Lei
Re: Oracle restore error
Eric, errno 2505 is TDP for Oracle's return code for end-of-file reached. oer7061 is Oracle/Rman's code for end-of-file reached (we actually send that to Oracle to let them know we are done restoring). If you are sure that you are getting a failure - check the Rman restore log upon this failure and set DSMO_DEBUG=49 (this will turn on tracing in TDP for Oracle and produce an orcagent.log) in your restore script. Review that script to see what the error is. If you want, you may send the orcagent.log and I can review it. Thanks, Neil Date:Mon, 18 Jun 2001 16:02:46 +0200 From:Loon, E.J. van - SPLXM [EMAIL PROTECTED] Subject: Oracle restore error Hi *SM-ers! One of our Oracle people is trying to restore a database (on Solaris). After some processing the restore fails with the following message in the sbtio.log: (2651) OBK-sbt:06/18/2001:15:10:22 odsmSess(): # of dsmInit retries = 1 (2650) OBK-sbt:06/18/2001:15:10:22 sbtread(): End of file reached. oer = 7061, errno = 2505. I know that 7061 and 2505 are return codes, but I don't know from which component (TSM, TDP or Oracle?), nor do I know where to find what they mean. Can anybody help me with solving this problem? Thanks in advance for any reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines Regards, Neil G. Rasmussen TDP for Oracle
Re: Question about TDP for Oracle 2.2.0
Michael, From the prior notes these are my assumptions: 1. You have HP-UX 11 64bit 2. You loaded Oracle 8.0.6 64bit on HP 3. You installed TDP for Oracle 2.2.0 If the above is true you should have the following directories on you machine: $ORACLE_HOME/rdbms/lib $ORACLE_HOME/rdbms/lib64 $ORACLE_HOME/lib $ORACLE_HOME/lib64 If you do not have the lib64 directories then that brings into question if you really have Oracle 64bit installed. At the very least Oracle 64bit looks for the libobk.sl (or the link) in the $ORACLE_HOME/lib64 directory. Before I wrote you back last time I re-checked these directories on our Oracle 8.0.6 64bit on HP-UX 11 and did a re-install of TDP for Oracle 2.2.0 to verify that this is all true. I found that if you do a make on the library that you do indeed get the errors that you saw. What you need to do is just make sure the soft links are there as I mentioned earlier and copy the oracle64 to oracle. More importantly, though, you need to find out why the lib64 directory is not there. * Hi Neil: I deeply appreciated your advice. I could not find $ORACLE_HOME/lib64/ in my system. I found the libobk.sl in the $ORACLE_HOME/lib/ and I remove it. I use ln command to link libobk.sl : ln -s /usr/libobk.sl/pa20_64/libobk.sl libobk.sl It doese't work. so I use the make command : make -f ins_rdbms.mk LLIBMM=/usr/lib/pa20_64/libobk.sl ioracle It failed again. Is it necessary that I must have $ORACLE_HOME/lib64/ directory in my system ? Can I make a soft link : $ORACLE_HOME/lib/libobk.sl - /usr/lib/pa20_64/libobk.sl to substitute $ORACLE_HOME/lib64/libobk.sl - /usr/lib/pa20_64/libobk.sl ? Thanks Michael Hsu Regards, Neil G. Rasmussen Software Engineer TDP for Oracle Phone: 408-256-8265, t/l 276-8265 E-mail: [EMAIL PROTECTED]
Re: Question about TDP for Oracle 2.2.0
Michael, Please Note - the installation guide (on Pg. 7) of the TDP for Oracle manual for Unix mentions that you should refer to Oracle documentation when linking files. The make command that you ran is used only when Oracle's documented method fails (We should have been more clear). This is what needs to be done: 1. Make sure you database's and listener's are shutdown. 2. make sure $ORACLE_HOME/lib64/libobk.sl - /usr/lib/pa20_64/libobk.sl (soft link) 3. make sure /usr/lib/pa20_64/libobk.sl - /opt/tivoli/tsm/client/oracle/bin64/libobk.sl (again, soft link) 4. when you ran the make command you probably corrupted the ORACLE_HOME/bin/oracle file. cp $ORACLE_HOME/bin/oracle64 $ORACLE_HOME/bin/oracle The previous should be enough to get you going. Regards, Neil G. Rasmussen TDP for Oracle E-mail: [EMAIL PROTECTED]
