{"id":4083,"date":"2018-05-28T12:00:48","date_gmt":"2018-05-28T11:00:48","guid":{"rendered":"https:\/\/www.data-protector.org\/wordpress\/?p=4083"},"modified":"2018-06-16T10:09:55","modified_gmt":"2018-06-16T09:09:55","slug":"sysbackup-oracle-12c","status":"publish","type":"post","link":"https:\/\/www.data-protector.org\/wordpress\/2018\/05\/sysbackup-oracle-12c\/","title":{"rendered":"SYSBACKUP for Oracle 12c"},"content":{"rendered":"<p>Starting with Oracle 12c three new administrative roles and users have been introduced to conform the principle of access to the least privilege. The users and roles named SYSBACKUP, SYSDG and SYSKM will be created when the database is created with their account in expired and locked status.\u00a0SYSBACKUP is used to perform backup and recovery operations from either Oracle Recovery Manager (RMAN) and or through SQL*Plus &#8211; you can see all privileges within the <a href=\"https:\/\/docs.oracle.com\/database\/121\/DBSEG\/authorization.htm#DBSEG785\">Oracle documentation.<\/a><\/p>\n<p>If a Oracle 12c is detected on the client system, Data Protector A.10.01 and later now automatically uses <em>sqlplus\u00a0user\/password@SID AS SYSBACKUP<\/em> as the connection string to the database.\u00a0As a result you may encounter the following backup issue after a Data Protector client or a Oracle database upgrade.<\/p>\n<pre>ORA-01031: insufficient privileges\r\nCONNECT: sys\/*****@SID\r\n[Major] From: ob&#50;&#x72;&#x6d;&#x61;n&#64;&#111;&#x72;&#x61;&#x63;le&#46;&#x64;&#x6f;&#x6d;ain&#46;&#x6c;&#x61;&#x6e; \"\" Time: 05\/15\/18 18:15:21\r\nBackup of target database failed.<\/pre>\n<p>Older Oracle databases (10g, 11i) do\u00a0not require changes as they will continue to use SYSDBA.<!--more--><\/p>\n<p>This can be changed using the omnirc variable <em>OB2_ORACLE_USE_SYSDBA=1<\/em> on the database server if you are not able to adopt these changes immediately. Starting with Data Protector A.10.03 the following command can be used to push this parameter to the client system.\u00a0<span class=\"fontstyle0\">A restart of the services is not required.<\/span><\/p>\n<pre>omnicc -update_omnirc OB2_ORACLE_USE_SYSDBA -value 1 ClientFQDN\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Starting with Oracle 12c three new administrative roles and users have been introduced to conform the principle of access to the least privilege. The users and roles named SYSBACKUP, SYSDG and SYSKM will be created when the database is created with their account in expired and locked status.\u00a0SYSBACKUP is used to perform backup and recovery [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[11],"tags":[211,60,210],"translation":{"provider":"WPGlobus","version":"2.8.8","language":"en","enabled_languages":["en","de"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"de":{"title":true,"content":true,"excerpt":false}}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p28cjj-13R","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":121,"url":"https:\/\/www.data-protector.org\/wordpress\/2010\/08\/external-utility-reported-error\/","url_meta":{"origin":4083,"position":0},"title":"External utility reported error","date":"2. August 2010","format":false,"excerpt":"{:en}If you receive the error below during a backup of a Oracle Instance, a faulty Perl module on the client is the source of the problem... The problem is difficult to debug, so just ask support for QCIM2A24591_TM3. With the fix the module DPoracle.pm will be changed, this should resolve\u2026","rel":"","context":"In &quot;Bugs&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":903,"url":"https:\/\/www.data-protector.org\/wordpress\/2012\/06\/backup-exec-no-longer-for-the-enterprise\/","url_meta":{"origin":4083,"position":1},"title":"Backup Exec no longer for the Enterprise","date":"7. June 2012","format":false,"excerpt":"{:de}Kurz und Knapp: Symantec hat in einem Artikel f\u00fcr Backup Exec 2012 einige seiner Komponenten auf EOL - end of life - gesetzt und verliert aus meiner Sicht die F\u00e4higkeit im Enterprise Backup & Recovery L\u00f6sungen anzubieten. Der Einsatz im Mittelstand ist fragw\u00fcrdig, da auch in diesem Bereich Anwendungen wie\u2026","rel":"","context":"In &quot;Common&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3209,"url":"https:\/\/www.data-protector.org\/wordpress\/2016\/10\/hpe-data-protector-patch-bundle-9-08\/","url_meta":{"origin":4083,"position":2},"title":"Data Protector 9 &#8211; Patch Bundle 9.08 (Build 112)","date":"14. October 2016","format":false,"excerpt":"{:en}On 2016\/10\/13 Hewlett Packard Enterprise released patch bundle 9.08 for Linux, HP-UX and Windows, it includes important changes and new features. For a complete list, please refer to the patch description. The focus for this release was stability, so only two new features were introduced: Microsoft Azure support and support\u2026","rel":"","context":"In &quot;DP A.09.00&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":897,"url":"https:\/\/www.data-protector.org\/wordpress\/2012\/06\/current-patches-dp-6-21\/","url_meta":{"origin":4083,"position":3},"title":"Current Patches DP 6.21","date":"25. June 2012","format":false,"excerpt":"{:de}Wenn Sie einen g\u00fcltigen Wartungsvertrag haben, so k\u00f6nnen Sie die Patches unter http:\/\/support.openview.hp.com\/selfsolve\/patches herunterladen, die Anmeldung erfolgt mit dem HP Passport Account. \u00c4ltere Meldungen zu den Patches werden nach unten verschoben. Update 2012\/06\/22:\u00a0HP hat f\u00fcr DP 6.21 am 07.06.2012 und 22.06.2012 neue Patches herausgegeben, das Patch Bundle DPXXXBDL_00621 ist aber\u2026","rel":"","context":"In &quot;DP A.06.00&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1412,"url":"https:\/\/www.data-protector.org\/wordpress\/2013\/06\/basics-installation-order-patches\/","url_meta":{"origin":4083,"position":4},"title":"Installation order of Patches","date":"3. June 2013","format":false,"excerpt":"{:de}Immer wieder stellt sich die Frage in welcher Reihenfolge die Patches f\u00fcr Data Protector installiert werden. Zwischen den einzelnen Patches ergeben sich Abh\u00e4ngigkeiten, welche man in den Beschreibungsdateien zum Patch nachlesen kann; diese m\u00fcssen bei der Installation eingehalten werden. Generell gilt folgende Reihenfolge f\u00fcr die Installation: sofern vorhanden: Patchbundle, Core,\u2026","rel":"","context":"In &quot;History&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1710,"url":"https:\/\/www.data-protector.org\/wordpress\/2014\/01\/data-protector-8-10-whats-new\/","url_meta":{"origin":4083,"position":5},"title":"Data Protector 8.10 available &#8211; whats new?","date":"7. January 2014","format":false,"excerpt":"{:en}Data Protector 8.10 has been released. The new version delivers some new features, my favorites are the new advanced scheduler and the file-system backup, which can be resumed. For customers with a valid support contract, the new version can be downloaded here: http:\/\/support.openview.hp.com. With Data Protector 8.1 new licenses are\u2026","rel":"","context":"In &quot;Common&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts\/4083"}],"collection":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/comments?post=4083"}],"version-history":[{"count":15,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts\/4083\/revisions"}],"predecessor-version":[{"id":4232,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/posts\/4083\/revisions\/4232"}],"wp:attachment":[{"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/media?parent=4083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/categories?post=4083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.data-protector.org\/wordpress\/wp-json\/wp\/v2\/tags?post=4083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}