Availability for the Always-On Enterprise
RedVision81
Novice
Posts: 8
Liked: never
Joined: Jan 14, 2016 8:02 am
Full Name: Peter
Contact:

v9: Disable Oracle Option / Warning

Post by RedVision81 » Jan 20, 2016 7:35 am

Hello,

since we upddated to Veeam v9 we always get a warning when our Oracle VM is going to be backed up:

Code: Select all

19.01.2016 23:06:24 :: Failed to retrieve Oracle database (SID: XXXXX) settings required to perform archived logs backup. Oracle error has occurred. ORA-12560: TNS: Fehler bei Protokolladapter

--tr:OracleSession: failed to init server.
--tr:Failed to create oracle session.
--tr:Failed to create oracle session holder. SID: MEDISTAR. 
Because we dont want to use this feature, is there a way to disable the Warning, or the complete oracle integration?

Thanks a lot in advance.

Peter

v.Eremin
Veeam Software
Posts: 15227
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by v.Eremin » Jan 20, 2016 9:28 am

Could you tell what AAIP settings are specified for the VM in question (Backup Job -> Guest Processing -> Applications -> VM -> Edit -> Oracle)? Thanks.

alexf85
Lurker
Posts: 2
Liked: 1 time
Joined: Feb 17, 2015 11:41 am
Full Name: Aleksander Fimreite
Contact:

Re: v9: Disable Oracle Option / Warning

Post by alexf85 » Jan 20, 2016 10:08 am 1 person likes this post

Exact same problem here (after v9), with some currently disabled oracle-services on our oracle-hosts.
We have nothing selected in Oracle application processing (default "Do not truncate archived logs").
How to remove/suppress these warnings?

ta_jb
Service Provider
Posts: 20
Liked: 3 times
Joined: Sep 29, 2009 1:40 pm
Contact:

Re: v9: Disable Oracle Option / Warning

Post by ta_jb » Jan 20, 2016 11:28 am 1 person likes this post

RedVision81 wrote: Because we dont want to use this feature, is there a way to disable the Warning, or the complete oracle integration?
+1

v.Eremin
Veeam Software
Posts: 15227
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by v.Eremin » Jan 20, 2016 11:50 am

The issue is currently under investigation. We'll update the topic, once we have more information. So, stay tuned. Thanks.

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy » Jan 20, 2016 12:34 pm

Currently there's no logic for excluding Oracle databases from backup and warning is logged for any database that is not available (e.g. service is disabled). We are going to address such situations in a more friendly manner in future versions.

bdcock
Lurker
Posts: 2
Liked: 2 times
Joined: Jan 20, 2016 1:00 pm
Full Name: Bart De Cock
Contact:

Re: v9: Disable Oracle Option / Warning

Post by bdcock » Jan 20, 2016 1:34 pm

Same issue here. Created an Oracle user with SYSDBA but prolem remains the same.
I made a ticket with veeam.

v.Eremin
Veeam Software
Posts: 15227
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by v.Eremin » Jan 20, 2016 1:38 pm

As mentioned above, the issue has been confirmed to be a known one and more sophisticated logic to address that will be implemented in the future. Thanks.

amo31
Lurker
Posts: 1
Liked: never
Joined: Jan 20, 2016 1:36 pm
Full Name: Amaury Legrand
Contact:

Re: v9: Disable Oracle Option / Warning

Post by amo31 » Jan 20, 2016 1:42 pm

Hi all,

OK for a backup Job, but I have the same warning with a Replication Job.
Or in a Replication Job we can't set credentials for Oracle...(Specify Oracle account with SYSDBA privileges)

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy » Jan 20, 2016 2:15 pm

The behavior is similar for replication job.

bdcock
Lurker
Posts: 2
Liked: 2 times
Joined: Jan 20, 2016 1:00 pm
Full Name: Bart De Cock
Contact:

Re: v9: Disable Oracle Option / Warning

Post by bdcock » Feb 23, 2016 10:36 am 2 people like this post

Open Oracle Universal Installer
Go to Installed Products, click tab Environment.
Mark your oracle Home and click Apply.
This worked for me. Backups are now created successfull.

DavidS
Veeam ProPartner
Posts: 11
Liked: 6 times
Joined: Aug 18, 2014 12:00 pm
Full Name: David
Location: Switzerland
Contact:

Re: v9: Disable Oracle Option / Warning

Post by DavidS » May 19, 2016 8:20 am

Are there any news on this topic?
I am just experiencing the same issue with a customer:

Code: Select all

19.05.2016 09:51:30 :: Unable to perform application-aware processing of Oracle database (SID: PCSA) : Oracle error has occurred. ORA-01017: invalid username/password; logon denied

--tr:Failed to create oracle session.
--tr:Failed to create oracle session holder. SID: PCSA. 
When will there be an option to disable oracle-aware processing?

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy » May 19, 2016 12:12 pm

David, ability to disable Oracle processing was added in Veeam B&R v9 Update 1.

RedVision81
Novice
Posts: 8
Liked: never
Joined: Jan 14, 2016 8:02 am
Full Name: Peter
Contact:

Re: v9: Disable Oracle Option / Warning

Post by RedVision81 » Sep 14, 2016 6:47 am

I tried to add the Registry Key on the Oracle machine as suggested in KB2114, but i still got the warning in the daily summary:

Unable to perform application-aware processing of Oracle database (SID: XXX) : Oracle error has occurred. ORA-12560: TNS: Fehler bei Protokolladapter --tr:OracleSession: failed to init server. --tr:Failed to create oracle session. --tr:Failed to create oracle session holder. SID: XXX.

Do i have to set the DWORD-Value to 0 or to 1 for enabling it, or is there any other hint getting this to work?
THX

foggy
Veeam Software
Posts: 16949
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy » Sep 14, 2016 11:33 am

Hi Peter, you should set the DisableOracleProcessing value to 1 to disable Oracle processing. If this doesn't work, please contact technical support for verification.

Post Reply

Who is online

Users browsing this forum: daniel.triplehorn and 46 guests