This post is more than 5 years old
14.3K Posts
0
5536
ORACLE_USER and NMDA
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
736 Posts
0
July 2nd, 2012 00:00
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
14.3K Posts
0
July 2nd, 2012 15:00
Thanks Bobby! I passed this info to our support - will wait for patch, test it and get back here with results!
CarlosRojas
1.7K Posts
0
July 2nd, 2012 23:00
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
736 Posts
1
July 3rd, 2012 00:00
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
736 Posts
0
July 3rd, 2012 00:00
Yes - the two escalations refer to the same patch for different versions of the software.
-Bobby
CarlosRojas
1.7K Posts
0
July 3rd, 2012 00:00
Thanks Bobby,
So is the same patched nsrdasv for both Escalations?
Thank you.
ble1
14.3K Posts
0
July 6th, 2012 02:00
Hm, I'm still waiting for patch to be delivered
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
14.3K Posts
0
July 6th, 2012 03:00
Ha, just got it. Must be forums hehe. I will test it tonight.
ble1
14.3K Posts
0
July 6th, 2012 06:00
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
14.3K Posts
0
July 6th, 2012 07:00
... 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
1.7K Posts
1
July 7th, 2012 22:00
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
14.3K Posts
1
July 8th, 2012 22:00
Thanks Carlos... we are in the same wagon... let's keep us each other updates through this topic...
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
July 10th, 2012 03:00
Hi,
I have the same problem at our customer, I hope a patch will be launched soon.
ble1
14.3K Posts
1
July 10th, 2012 07:00
I've been given new set of patches for Linux platform and my tests are ok so far.
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
December 4th, 2013 23:00
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.