Oracle error has occurred. ORA-01031: insufficient privileg

[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

[albertwt]

I've created separate Case # 01758793

[kkitzul_SE]

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

[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]

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

[foggy]

What do our engineers say about that?

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

[MichaelSawyer1969]

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

[foggy]

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

[albertwt]

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.

[hoFFy]

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?

[foggy]

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