Comprehensive data protection for all workloads
RedVision81
Enthusiast
Posts: 39
Liked: 2 times
Joined: Jan 14, 2016 8:02 am
Full Name: Peter
Contact:

v9: Disable Oracle Option / Warning

Post by RedVision81 »

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
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by veremin »

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 » 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 » 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
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by veremin »

The issue is currently under investigation. We'll update the topic, once we have more information. So, stay tuned. Thanks.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

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 »

Same issue here. Created an Oracle user with SYSDBA but prolem remains the same.
I made a ticket with veeam.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by veremin »

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 »

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: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

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

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: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

David, ability to disable Oracle processing was added in Veeam B&R v9 Update 1.
RedVision81
Enthusiast
Posts: 39
Liked: 2 times
Joined: Jan 14, 2016 8:02 am
Full Name: Peter
Contact:

Re: v9: Disable Oracle Option / Warning

Post by RedVision81 »

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: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

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.
ar63
Novice
Posts: 3
Liked: never
Joined: Feb 17, 2016 2:58 pm
Full Name: AR

Re: v9: Disable Oracle Option / Warning

Post by ar63 »

foggy wrote: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.
I have same warnings when i make oracle guest backups for my db servers with same olds Oracle instance stopped. But my oracle servers are Linux (Red Hat). There is a workaround for Linux too?

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

Re: v9: Disable Oracle Option / Warning

Post by foggy »

ar63
Novice
Posts: 3
Liked: never
Joined: Feb 17, 2016 2:58 pm
Full Name: AR

Re: v9: Disable Oracle Option / Warning

Post by ar63 »

Ok. But how to write the VeeamOracleAgent.xml file to not to backup a particulat oracle db? Usually i have 1 db instance active and sometimes there is an oracle db in shutdown state. The veeam backup create a warning because it try to backup both databases.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

Exclusion of specific Oracle databases will be available in v9.5.
chasemei
Novice
Posts: 3
Liked: never
Joined: Jan 30, 2017 10:02 pm
Full Name: Chase Mei
Contact:

Re: v9: Disable Oracle Option / Warning

Post by chasemei »

We have similar requests and using Veem 9. Anyone knows if we can disable a specified DB through VeeamOracleAgent.xml? What the config is?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by veremin »

As far as I'm concerned, in version 9 you can only disable oracle processing altogether, while Oracle selected db exlcussion is not possible. Is there any particular reason preventing you from updating to 9.5 Update 1? Thanks.
chasemei
Novice
Posts: 3
Liked: never
Joined: Jan 30, 2017 10:02 pm
Full Name: Chase Mei
Contact:

Re: v9: Disable Oracle Option / Warning

Post by chasemei »

Thanks for your reply.
Sorry from my ignorance, yes, we are using 9.5.
May I know if we can add parameters to file VeeamOracleAgent.xml to only ignore one instance?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by veremin »

Kindly, reach our support team, they should be aware of regkey (existing in 9.5) using which you can exclude particular databases. Thanks.
chasemei
Novice
Posts: 3
Liked: never
Joined: Jan 30, 2017 10:02 pm
Full Name: Chase Mei
Contact:

Re: v9: Disable Oracle Option / Warning

Post by chasemei »

We DBAs have no support account to Veeam. Would very appreciate your help, if you can let us know the parameter. Otherwise, I will ask our system team reaching the support team.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: v9: Disable Oracle Option / Warning

Post by veremin »

I've shared the keys with in PM. Check your forum inbox. Thanks.
jveerd1
Service Provider
Posts: 52
Liked: 10 times
Joined: Mar 12, 2013 9:12 am
Full Name: Joeri van Eerd
Contact:

Re: v9: Disable Oracle Option / Warning

Post by jveerd1 »

Can you share the keys with me as well? Case # 02060158
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

Please ask your engineer to share the values with you.
sakhavan
Lurker
Posts: 1
Liked: never
Joined: Jun 23, 2017 12:12 pm
Full Name: shahab akhavan
Contact:

Re: v9: Disable Oracle Option / Warning

Post by sakhavan »

Hi all,
Try to connect you to DB and try this:

Code: Select all

alter system switch logfile;
nsahw@gmx.de
Lurker
Posts: 2
Liked: never
Joined: Nov 24, 2017 12:39 pm
Full Name: Norbert Schulze
Contact:

Re: v9: Disable Oracle Option / Warning

Post by nsahw@gmx.de »

It is also a problem in v9.5

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

I choose the general options
"Try application processing, but ignore failures"
and
Perform coy only (lets another application use logs)

#01068886
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: v9: Disable Oracle Option / Warning

Post by foggy »

Hi Norbert, the specified number refers to a pretty old support case that is not related to Oracle. Could you please check and provide the correct one?
Post Reply

Who is online

Users browsing this forum: No registered users and 190 guests