Oracle error has occurred. ORA-01031: insufficient privileg

VMware specific discussions

Oracle error has occurred. ORA-01031: insufficient privileg

Veeam Logoby albertwt » Sun Apr 10, 2016 10:31 am

Hi,

After upgrading to Veeam Backup & Replication 9.0.0.1491, all in a sudden I've received the below warning message in my Windows Oracle VM backup:

Unable to perform application-aware processing of Oracle database (SID: OPERA) : Oracle error has occurred. ORA-01031: insufficient privileges --tr:Failed to create oracle session. --tr:Failed to create oracle session holder. SID: OPERA.


Previously it never complained like that, so I wonder what is going on here and how to fix this issue ?

Case # 01744386
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby albertwt » Mon Apr 11, 2016 2:25 am

I've created separate Case # 01758793
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby kkitzul_SE » Wed Apr 13, 2016 4:31 pm

I am experiencing the same issue. Did support get back to you on a fix?
kkitzul_SE
Novice
 
Posts: 5
Liked: never
Joined: Tue Jan 22, 2013 9:01 pm
Full Name: Kyle

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby foggy » Wed Apr 13, 2016 4:59 pm

The case is currently under investigation. I recommend you opening your own one, since the reasons of the observed behavior can vary between environments.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby albertwt » Mon Apr 25, 2016 1:27 pm

Hi Foggy,

Can you help here please, I can confirmed that I am able to login to the SQL database from command prompt using:

Code: Select all
Sqlplus sys/s3cur3passw0rd@opera as sysdba


but somehow the job still end up with warning:

Code: Select all
[25.04.2016 19:31:54] <  2412> oralib| Trying to initialize oracle interface Failed.
[25.04.2016 19:31:54] <  2412> oralib| ERR |Oracle session init thread failed
[25.04.2016 19:31:54] <  2412> oralib| >>  |Oracle error has occurred. ORA-12560: TNS:protocol adapter error
[25.04.2016 19:31:54] <  2412> oralib| >>  |
[25.04.2016 19:31:54] <  2412> oralib| >>  |--tr:OracleSession: failed to init server.
[25.04.2016 19:31:54] <  2412> oralib| >>  |--tr:Failed to create oracle session.
[25.04.2016 19:31:54] <  2412> oralib| >>  |An exception was thrown from thread [2412].
[25.04.2016 19:31:54] <  4828> oralib|   Creating oracle session holder: OPERA. Failed.
[25.04.2016 19:31:54] <  4828> oralib|   Destroying oracle session
[25.04.2016 19:31:54] <  4828> oralib|   Destroying oracle session ok.
[25.04.2016 19:31:54] <  4828> oralib| WARN|Failed to check if oracle db is active, sid: OPERA
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby foggy » Mon Apr 25, 2016 1:42 pm

What do our engineers say about that?
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby albertwt » Mon Apr 25, 2016 1:56 pm

Not yet reply on my case yet.
I also don't know if it is due to Veeam limitation or do I need to type the command above in specific format ?
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby MichaelSawyer1969 » Wed May 18, 2016 1:33 pm 1 person likes this post

I am having the same issue with Veeam 9 sp1 - was there any resolution to this?
MichaelSawyer1969
Lurker
 
Posts: 1
Liked: 1 time
Joined: Wed May 18, 2016 1:31 pm
Full Name: Michael Sawyer

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby foggy » Wed May 18, 2016 1:57 pm

Michael, please open your own case for a closer look at your setup. Thanks.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby albertwt » Wed May 18, 2016 10:38 pm

MichaelSawyer1969 wrote:I am having the same issue with Veeam 9 sp1 - was there any resolution to this?


Michael,

Yes it finally resolved. It was due to the old Oracle Database binaries and settings that was left over, therefore the solution was to put this registry to ignores it:

Code: Select all
HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication
Key: DisableOracleProcessing
Type: REG_DWORD
value: 1


Hope that helps.
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby hoFFy » Wed Nov 30, 2016 7:37 am 2 people like this post

Good morning,

I've got a customer with the same error message. If I set the registry key... what is the exact effect of it? As the name of the key states it disables the processing of the Oracle databases. But is that what we want?
VMCE 7 / 8 / 9, VCP-DC 5 / 5.5 / 6, MCITP:SA
Blog: machinewithoutbrain.de
hoFFy
Veeam ProPartner
 
Posts: 161
Liked: 25 times
Joined: Fri Apr 27, 2012 1:10 pm
Location: Germany / Lohne
Full Name: Sebastian Hoffmann

Re: Oracle error has occurred. ORA-01031: insufficient privi

Veeam Logoby foggy » Wed Dec 07, 2016 12:26 pm

This was a workaround that helped in the OP's case. We're looking into adding exclusions of specific Oracle databases in future.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 11 guests