topic Re: Data Protector on OpenVMS + intergration with ORACLE in Operating System - OpenVMS

Data Protector on OpenVMS + intergration with ORACLE

Jiri Koutnik — Mon, 20 Feb 2006 11:11:56 GMT

I have installed Cell Manager on Windows server. Client is VMS server, db is ORACLE. Iam able to backup just filesystem, but the problem is Integration DP with Oracle, I mean backup db ORACLE using RMAN to tape devices !!! I was told, it should worked, but no success for me. Even worse I have no documentation of DP for Open VMS ! Can anyone help me to solve this ?
VMS - 7.3-2
ORACLE 9.2.0.5
DP - 5.50-74

thanx Jiri

Re: Data Protector on OpenVMS + intergration with ORACLE

ASHOK KUMAR_8 — Mon, 27 Feb 2006 05:13:39 GMT

Hello Jiri,

Document for Oracle integration is available
in following path...

SYS$SYSROOT:[SYSHLP]DPA0550.RELEASE_NOTES
and also please find the same ....
******************************************
Configuring the ORACLE 9i Integration Agent

This patch contains by default the files for ORACLE 9i integration.

Before you can use the Oracle Integration Agent user have to modify
OMNI$ROOT:[LOG]LOGIN.COM accordingly.

User needs to modify location of the orauser.com and oratab. files
provided by the ORACLE
For Example:
$PIPE @DKA0:[ORACLE]orauser.com > NLA0:
Suppose orauser.com present in DKC0:[ORACLE9i],
then change above statement to
$PIPE @DKC0:[ORACLE9i]orauser.com > NLA0:

$DEFINE /NOLOG/JOB ORATAB_LOC
DKA0:[ORACLE]oratab.

Suppose oratab. present in DKC0:[ORACLE9i],
then change above statement to
$DEFINE /NOLOG/JOB ORATAB_LOC
DKC0:[ORACLE9i]oratab.

Note:If you are running MA and DP Oracle agents on the same openVMS system,

Then modify group ID of omniadmin user as DBA using MCR AUTHORIZE utility.

Execute OMNI$ROOT:[LOG]login.com .
********************************************

Please describe the detail problem with error so, I can provide you more help on this.

Thanks,
Ashok

Re: Data Protector on OpenVMS + intergration with ORACLE

Jiri Koutnik — Mon, 27 Feb 2006 09:34:18 GMT

Hello,

I tried to go through the doc you provided me for OpenVMS, started again DP gui, but still I was not able to perform Backup operation. I enclosed error message and also snapshot of DP gui.
thanx for any hint.

Jiri

error message:
It is not possible to connect to Oracle DB server !
It is possible that Oracle DB Server is not running or command "svrmgrl" doesnt exist in the /bin directory on the Oracle host.

but we use Oracle version 9.2.0.5 so :-)))

Re: Data Protector on OpenVMS + intergration with ORACLE

ASHOK KUMAR_8 — Tue, 28 Feb 2006 03:47:30 GMT

From the error it seems to be problem with Oracle configuration,not with DP-Integration.
By the way you are using supported version - Oracle version 9.2.0.5 .

Please follow the following steps.
1) To verify Oracle rman ?

execute the following command.

RMAN>run
{
allocate channel d1 type disk;
backup tablespace system;
release channel d1;
}

2) To verify Oracle integration with DP ?

execute the following command. after modifying and executing "login.com" as suggested in previous mail.

RMAN> run
{
allocate channel 'dummy' type 'SBT_TAPE' parms="SBT_LIBRARY=DP_SBT";
release channel 'dummy';
}

Note : For more information you can refer DP ORACLE_INTEGRATION.pdf document.

Section: Configuring the Oracle Server
- Page number 30
Please follow the similar steps as mention for UNIX.

Thanks,
Ashok

Re: Data Protector on OpenVMS + intergration with ORACLE

ASHOK KUMAR_8 — Tue, 28 Feb 2006 07:19:23 GMT

I adding one more point:---

Before executing
RMAN>run
{
allocate channel 'dummy' type 'SBT_TAPE'
parms="SBT_LIBRARY=DP_SBT";
release channel 'dummy';
}

Please make sure that the following line should be uncommented from the login.com
- Means DP_SBT should be point to correct
sharable.

DEFINE /NOLOG /SYSTEM DP_SBT
SYS$SHARE:LIBOBK2SHR32.EXE

Thanks
Ashok

Re: Data Protector on OpenVMS + intergration with ORACLE

Jiri Koutnik — Tue, 28 Feb 2006 11:33:03 GMT

RMAN> run {
2> allocate channel 'dummy' type 'SBT_TAPE' parms="SBT_LIBRARY=DP_SBT";
3> release channel 'dummy';
4> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on dummy channel at 02/28/2006 17:27:17
ORA-03113: end-of-file on communication channel

RMAN> exit

I tried several times to LOGON and LOGOFF, but still no success at all. I performed those steps localy on the VMS client, is this correct ? thanx Jiri

Re: Data Protector on OpenVMS + intergration with ORACLE

benghezal zakaria — Tue, 28 Feb 2006 12:00:19 GMT

hello,

i m just searching for dataprotectior for openvms
i have IA server running DP5.5 and i want integrate open vms client ALPHA OpenVMS 7.3.2,

can you please insure me where can i find the DP SofWare

Regards

Re: Data Protector on OpenVMS + intergration with ORACLE

Jiri Koutnik — Wed, 01 Mar 2006 04:27:54 GMT

Hello,

you can find SW here:

http://h18006.www1.hp.com/products/storage/software/dataprotector/index.html

patches are available on www.itrc.com
search for example for DPWIN_00182

best regards,
jiri

Re: Data Protector on OpenVMS + intergration with ORACLE

ASHOK KUMAR_8 — Wed, 01 Mar 2006 05:21:51 GMT

Hello Jir,

Now you know the problem area, first of all this command should work fine
then only you can try for Backup.

Please find the result in my environment.

***********************************************************************

ORACLE>$ rman catalog rman/rman@CAT target sys/sys123@TEST

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: TEST (DBID=1878002656)
connected to recovery catalog database

RMAN> run
2> {
3> allocate channel d1 type disk;
4> backup tablespace system;
5> release channel d1;
6> }
allocated channel: d1
channel d1: sid=18 devtype=DISK

Starting backup at 01-MAR-06
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=DKA400:[ORACLE9I.ORADATA.TEST]SYSTEM01.DBF
channel d1: starting piece 1 at 01-MAR-06
channel d1: finished piece 1 at 01-MAR-06
piece handle=DKA400:[ORACLE9I.ORADATA.TEST]4NHCS0PG_1_1. comment=NONE
channel d1: backup set complete, elapsed time: 00:00:46
Finished backup at 01-MAR-06

released channel: d1

RMAN> run
2> {
3> allocate channel 'dummy' type 'SBT_TAPE' parms="SBT_LIBRARY=DP_SBT";
4> release channel 'dummy';
5> }
allocated channel: dummy
channel dummy: sid=18 devtype=SBT_TAPE
channel dummy: Data Protector A.05.50/OpenVMS A.05.50 (74)

released channel: dummy

RMAN> exit

Recovery Manager complete.
ORACLE>$
ORACLE>$ sh log DP_SBT
"DP_SBT" = "SYS$SHARE:LIBOBK2SHR32.EXE" (LNM$SYSTEM_TABLE)

*********************************************************************************

From the error in your environment :::::::

RMAN-03009: failure of allocate command on dummy channel at 02/28/2006 17:27:17
ORA-03113: end-of-file on communication channel

This could be a very small issue with Oracle environment.

like :---
* May be the Target and Catalog database is not running in archive mode.
* May be with ORATAB_LOC .and editing with omni$root:[log]login.com file.
* etc etc !!!!!!!!!!

Benghezal :

You can download latest DP on

http://wtec.cup.hp.com/~wtec_ss/patches/default.htm

and for Open VMS Alpha directly from the

http://wtec.cup.hp.com/patches-bin/parse/patches-info?Patch=DPWIN_00182

Thanks,
Ashok.

Re: Data Protector on OpenVMS + intergration with ORACLE

ASHOK KUMAR_8 — Wed, 01 Mar 2006 06:02:23 GMT

Hi Benghezal,

Sorry for the wrong link.. please check with the following link to download DP for Open VMS.

Additional information about this patch and the patch download are available at the
HP OpenView support website:
http://openview.hp.com/sso/ecare/getsupportdoc?docid=DPWIN_00182

Regards,
Ashok

Re: Data Protector on OpenVMS + intergration with ORACLE

Jiri Koutnik — Wed, 01 Mar 2006 11:15:14 GMT

Im afraid, the procedure in our environment terminated with the same result. Now we are searching some Oracle hints, so no progress informations I can provide to you today. We will see what next days will bring to us :-)

Jiri

Re: Data Protector on OpenVMS + intergration with ORACLE

Elias Abboud — Mon, 24 Jul 2006 10:42:13 GMT

We are facing the same.

did you get to a solution?

please help...

Re: Data Protector on OpenVMS + intergration with ORACLE

Jiri Koutnik — Tue, 25 Jul 2006 03:06:01 GMT

Im afraid, together with local HP we didnt get any success with DP and its Oracle integration ! in parallel we tested the speed of backup on OpenVMS using DP, on LTO-3 library, but the result was, that VMS backup is still faster ! so we decided to leave DP and at the moment we are testing product ABS, where we have reference, that it works in productive environment !

Jiri