Discussions specific to the VMware vSphere hypervisor
Post Reply
albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Oracle error has occurred. ORA-01031: insufficient privileg

Post by albertwt » 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: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt » Apr 11, 2016 2:25 am

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 » Apr 13, 2016 4:31 pm

I am experiencing the same issue. Did support get back to you on a fix?

foggy
Veeam Software
Posts: 16932
Liked: 1377 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 » 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.

albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt » 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 ! */

foggy
Veeam Software
Posts: 16932
Liked: 1377 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 » Apr 25, 2016 1:42 pm

What do our engineers say about that?

albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt » 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 ! */

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 » 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?

foggy
Veeam Software
Posts: 16932
Liked: 1377 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 » May 18, 2016 1:57 pm

Michael, please open your own case for a closer look at your setup. Thanks.

albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt » 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 ! */

hoFFy
Service Provider
Posts: 175
Liked: 27 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 » 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

foggy
Veeam Software
Posts: 16932
Liked: 1377 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 » 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 19 guests