{"id":367,"date":"2009-05-07T14:07:20","date_gmt":"2009-05-07T04:07:20","guid":{"rendered":"http:\/\/nsrd.wordpress.com\/?p=367"},"modified":"2009-05-07T14:07:20","modified_gmt":"2009-05-07T04:07:20","slug":"networker-75-and-oracle-module-5","status":"publish","type":"post","link":"https:\/\/nsrd.info\/blog\/2009\/05\/07\/networker-75-and-oracle-module-5\/","title":{"rendered":"NetWorker 7.5 and Oracle Module 5"},"content":{"rendered":"<p>Since I have more than a passing interest in <a title=\"my database project\" href=\"http:\/\/www.anywebdb.com\" target=\"_blank\">databases<\/a>, I always try to keep appraised of the Oracle module for NetWorker. It therefore surprised me a few days ago to see that v5 of the module had been released in March. I guess my excuse is that March was an insanely busy month for me between work and travel. (Well, that&#8217;s my excuse, and I&#8217;m sticking to it.)<\/p>\n<p>So yesterday I downloaded v5 of the module (for Linux), and spun it up. This is a version I really, really like.<\/p>\n<p>Now, here&#8217;s a few bullet points before I get to the most impressive feature:<\/p>\n<ul>\n<li>No longer supports Oracle 9i or lower; if you want older, unsupported versions of Oracle you have to use an older version of the module.<\/li>\n<li>Requires features that exist only in Networker 7.5.x as the underlying client.<\/li>\n<li>Must have the NetWorker regular client installed and running in order for the module software to correctly install and activate,<\/li>\n<li>Can work with the 7.4.x NetWorker server with the exception that what I&#8217;m about to describe below doesn&#8217;t work with a 7.4 server.<\/li>\n<li><em>Now has a client configuration wizard that works within NMC and makes Oracle backup configuration a breeze<\/em>.<\/li>\n<\/ul>\n<p>Honestly, if you&#8217;re about to do a new NetWorker install into a site that has Oracle, skip everything else and install 7.5.1. I.e., this is one of these compelling reasons for 7.5.x.<\/p>\n<p>The Oracle client configuration wizard is integrated into NMC&#8217;s wizards. Right-click on a client in the configuration panel, choose &#8220;Client Backup Configuration -&gt; New&#8221;, and you&#8217;re off and running:<\/p>\n<figure id=\"attachment_368\" aria-describedby=\"caption-attachment-368\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-368\" title=\"Oracle Client Configuration Step 1\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/1.png\" alt=\"Oracle Client Configuration Step 1\" width=\"500\" height=\"318\" \/><figcaption id=\"caption-attachment-368\" class=\"wp-caption-text\">Oracle Client Configuration Step 1<\/figcaption><\/figure>\n<figure id=\"attachment_369\" aria-describedby=\"caption-attachment-369\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-369\" title=\"Oracle Client Configuration Step 2\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/2.png\" alt=\"Oracle Client Configuration Step 2\" width=\"500\" height=\"318\" \/><figcaption id=\"caption-attachment-369\" class=\"wp-caption-text\">Oracle Client Configuration Step 2<\/figcaption><\/figure>\n<p>Note that you won&#8217;t reach this point if you&#8217;ve disabled &#8216;nsrauth&#8217; authentication on the backup server. I had done so on my lab server as a test on Monday, and spent half an hour trying to work out a &#8230; rather inexact &#8230; error message.<\/p>\n<figure id=\"attachment_370\" aria-describedby=\"caption-attachment-370\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-370\" title=\"Oracle Client Configuration Step 3\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/3.png\" alt=\"Oracle Client Configuration Step 3\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-370\" class=\"wp-caption-text\">Oracle Client Configuration Step 3<\/figcaption><\/figure>\n<figure id=\"attachment_371\" aria-describedby=\"caption-attachment-371\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-371\" title=\"Oracle Client Configuration Step 4\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/4.png\" alt=\"Oracle Client Configuration Step 4\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-371\" class=\"wp-caption-text\">Oracle Client Configuration Step 4<\/figcaption><\/figure>\n<p>The above step is where things get <em>fun<\/em>. Note that if you are given these details, you don&#8217;t even need to log onto the client to setup an <em>nsrnmo<\/em> script any longer. This is the start of <em>A Really Good Thing<\/em>.<\/p>\n<p>Also, I should note, in the above screen shot, because I was using a temporary database installed just for a few tests and I was in a rush, I used the <em>sys<\/em> account for connecting to the target database. No, you shouldn&#8217;t ever do that \u2013 create a backup user and use that account, <em>please<\/em>.<\/p>\n<p>Note that Oracle, and the Oracle Listener, must both be running on the client in order to clear the above step.<\/p>\n<p>After the above, we then start to get into the &#8216;regular&#8217; client configuration options:<\/p>\n<figure id=\"attachment_372\" aria-describedby=\"caption-attachment-372\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-372\" title=\"Oracle Client Configuration Step 5\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/5.png\" alt=\"Oracle Client Configuration Step 5\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-372\" class=\"wp-caption-text\">Oracle Client Configuration Step 5<\/figcaption><\/figure>\n<figure id=\"attachment_373\" aria-describedby=\"caption-attachment-373\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-373\" title=\"Oracle Client Configuration Step 6\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/6.png\" alt=\"Oracle Client Configuration Step 6\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-373\" class=\"wp-caption-text\">Oracle Client Configuration Step 6<\/figcaption><\/figure>\n<figure id=\"attachment_374\" aria-describedby=\"caption-attachment-374\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-374\" title=\"Oracle Client Configuration Step 7\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/7.png\" alt=\"Oracle Client Configuration Step 7\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-374\" class=\"wp-caption-text\">Oracle Client Configuration Step 7<\/figcaption><\/figure>\n<p>This summary screen shows you what you&#8217;re going to get as far as the configuration is concerned \u2013 including the RMAN script that has been automatically generated for you:<\/p>\n<figure id=\"attachment_375\" aria-describedby=\"caption-attachment-375\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-375\" title=\"Oracle Client Configuration Step 8\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/8.png\" alt=\"Oracle Client Configuration Step 8\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-375\" class=\"wp-caption-text\">Oracle Client Configuration Step 8<\/figcaption><\/figure>\n<p>Confirmation of sweet success:<\/p>\n<figure id=\"attachment_376\" aria-describedby=\"caption-attachment-376\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-376\" title=\"Oracle Client Configuration Step 9\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/9.png\" alt=\"Oracle Client Configuration Step 9\" width=\"500\" height=\"307\" \/><figcaption id=\"caption-attachment-376\" class=\"wp-caption-text\">Oracle Client Configuration Step 9<\/figcaption><\/figure>\n<p>The finished client in NMC:<\/p>\n<figure id=\"attachment_378\" aria-describedby=\"caption-attachment-378\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-378\" title=\"Oracle Client Configuration Step 10\" src=\"http:\/\/nsrd.files.wordpress.com\/2009\/05\/101.png\" alt=\"Oracle Client Configuration Step 10\" width=\"500\" height=\"10\" \/><figcaption id=\"caption-attachment-378\" class=\"wp-caption-text\">Oracle Client Configuration Step 10<\/figcaption><\/figure>\n<p>Once configured, you&#8217;re ready to start backing up straight away. Honestly, it couldn&#8217;t be simpler.<\/p>\n<p>As a closing note, I know some other backup products have had Oracle backup wizards for some time, so I&#8217;m not claiming EMC is the first with this style of setup, but I do think it&#8217;s a great feature to see included now.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since I have more than a passing interest in databases, I always try to keep appraised of the Oracle module&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9,11,16],"tags":[706,707],"class_list":["post-367","post","type-post","status-publish","format-standard","hentry","category-databases","category-features","category-networker","tag-oracle","tag-oracle-module"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKpIN-5V","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/comments?post=367"}],"version-history":[{"count":0,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/367\/revisions"}],"wp:attachment":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media?parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/categories?post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/tags?post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}