Host-based backup of VMware vSphere VMs.
Post Reply
albertwt
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Oracle error has occurred. ORA-01031: insufficient privileg

Post by albertwt »

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
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

I've created separate Case # 01758793
--
/* Veeam software enthusiast user & supporter ! */
kkitzul_SE
Novice
Posts: 7
Liked: never
Joined: Jan 22, 2013 9:01 pm
Full Name: Kyle
Contact:

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

Post by kkitzul_SE »

I am experiencing the same issue. Did support get back to you on a fix?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

The case is currently under investigation. I recommend you opening your own one, since the reasons of the observed behavior can vary between environments.
albertwt
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

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 ! */
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

What do our engineers say about that?
albertwt
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

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 ! */
MichaelSawyer1969
Lurker
Posts: 1
Liked: 1 time
Joined: May 18, 2016 1:31 pm
Full Name: Michael Sawyer
Contact:

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

Post by MichaelSawyer1969 » 1 person likes this post

I am having the same issue with Veeam 9 sp1 - was there any resolution to this?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

Michael, please open your own case for a closer look at your setup. Thanks.
albertwt
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

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 ! */
hoFFy
Service Provider
Posts: 183
Liked: 40 times
Joined: Apr 27, 2012 1:10 pm
Full Name: Sebastian Hoffmann
Location: Germany / Lohne
Contact:

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

Post by hoFFy » 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
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

This was a workaround that helped in the OP's case. We're looking into adding exclusions of specific Oracle databases in future.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 51 guests