ORACLE_USER and NMDA

Question

Is there anyone using ORACLE_USER statement with NMDA v1.2 on Linux (x64)?  Today I decided to make couple of upgrades from NMO to NMDA.  I did test NMDA earlier this year, but it was tested against databases where I use RMAN script where connect string specifies user for both target and catalog.  In older setup, we were using different approach - we would specify connect / for target since rman script would be called using ORACLE_USER (which in our case is oradba - the oracle user).  Of course that worked find as oradba is authentificated and if one reads NMDA manual this option is more than valid with NMDA too. Somehow, at least with NMDA 1.2 on Linux x64, this is not the case.  Call is made as root instead of ORACLE_USER and of course you get nice 'go away' error from Oracle.  Anyone already hit that issue?

coganb · Accepted Answer

Morning Hrvoje,

This is known issue which has been fixed under the reference NW140995 (NMDA Oracle scheduled backup with OS authentication fails with insufficient privileges). There is a patched nsrdasv binary available to fix this. You should open an SR to request this.

-Bobby

ble1 · Answer

Thanks Bobby!  I passed this info to our support - will wait for patch, test it and get back here with results!

CarlosRojas · Answer

Hi Bobby,

I just started to face this very same issue. Is there any KB for this?

I couldn't find anything in Powerlink.

I already opened a SR with support and waiting for the fix now.

Thank you.

Carlos.

coganb · Answer

Hi Carlos,

The article on this doesn't provide any extra information, but here it is:

http://solutions.emc.com/EMCSolutionView.asp?id=esg129584&usertype=C

NW139879 & NW140995 are related to the same issue.

-Bobby

coganb · Answer

Yes - the two escalations refer to the same patch for different versions of the software. -Bobby

CarlosRojas · Answer

Thanks Bobby, So is the same patched nsrdasv for both Escalations? Thank you.

ble1 · Answer

Hm, I'm still waiting for patch to be delivered &#xa0; Not sure why... ticket was opened by reseller who provides support for company I work for (48704666) and I've been waiting for day now despite providing bug id.

ble1 · Answer

Ha, just got it. Must be forums hehe. I will test it tonight.

ble1 · Answer

Well, just did a test with linux x64 and - it does not work. I was getting no errors on client side so I decided to run patched nsrdasv manually and there I see "why" it fails:

[root@foo11 logs]# nsrdasv -z /nsr/apps/config/nmda_E02ASI_arch.cfg

Segmentation fault

[root@foo11 logs]# /usr/sbin/_nsrdasv.GA -z /nsr/apps/config/nmda_E02ASI_arch.cfg

@(#) Module Name: NetWorker Module for Databases and Applications v@(#) Module Vers: 1.2.0.1

Fri Jul 6 15:51:43 2012

foo: The NSR_SAVESET_NAME was not specified

_nsrdasv.GA is obviously GA binary which has original issue. Back to the support

ble1 · Answer

... not to mention that new patched binary looks fat (might not be stripped thou):

[root@foo sbin]# ll *nsrdasv*

-rwxr-xr-x 1 root root 9852624 Jul 6 15:34 nsrdasv

-rwxr-xr-x 1 root root 2402256 Nov 30 2011 _nsrdasv.GA

CarlosRojas · Answer

Hi Hrvoje,

I also opened a case (SR# 48725944) and got a pair of binaries). The "normal" one also gave me segmentation fault error messages, so I used the "non-stripped" one and didn't work either, basically I'm facing the exact same behavior.

I didn't get any update from support, so I hope either here or in my SR this gets resolved as this is production DB what we are trying to backup.

Thank you.

Carlos.

ble1 · Answer

Thanks Carlos... we are in the same wagon... let's keep us each other updates through this topic...

ble1 · Answer

I've been given new set of patches for Linux platform and my tests are ok so far.

ble1 · Answer

Grigory.Gokhman wrote:

Hrvoje, do you have those patches in place? This SR is archived and I'm not able to access it. If so-could you please send it to me? grigory.gokhman@emc.com. Thank you.

You must open a ticket with support and request patch. If you plan to run against NSR8 server, you will also have to request build 348 libnsrora.so so it might be good thing to request this combo with new request to support.

NetWorker

ORACLE_USER and NMDA

Was this post helpful?