{"id":945,"date":"2015-06-26T01:14:20","date_gmt":"2015-06-26T01:14:20","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=945"},"modified":"2015-06-27T13:51:12","modified_gmt":"2015-06-27T13:51:12","slug":"after-cloning-a-12c-oracle-home-sqlplus-error-exec-0509-036","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=945","title":{"rendered":"After Cloning a 12c Oracle Home – SQLPLUS error exec(): 0509-036"},"content":{"rendered":"

Problem:<\/h2>\n

After cloning a 12c Oracle Home to another AIX 7.1 server, I received the following error when I started SQLPLUS.<\/p>\n

$\u00a0 .\/sqlplus \/nolog\r\n exec(): 0509-036 Cannot load program sqlplus because of the following errors:\r\n rtld: 0712-001 Symbol CreateIoCompletionPort was referenced\r\n \u00a0\u00a0\u00a0\u00a0\u00a0 from module \/oracle\/12.1.0.2.2\/lib\/libttsh12.so(), but a runtime definition\r\n \u00a0\u00a0\u00a0\u00a0\u00a0 of the symbol was not found.\r\n rtld: 0712-001 Symbol GetMultipleCompletionStatus was referenced\r\n \u00a0\u00a0\u00a0\u00a0\u00a0 from module \/oracle\/12.1.0.2.2\/lib\/libttsh12.so(), but a runtime definition\r\n \u00a0\u00a0\u00a0\u00a0\u00a0 of the symbol was not found.\r\n rtld: 0712-002 fatal error: exiting.<\/pre>\n
 <\/p>\n
Cause:<\/h2>\n
The I\/O Completion Port was not correctly configured on the AIX operating system.\u00a0 The parameter is configured to its default of “Defined”, and Oracle 12c requires this parameter to be configured as “Available”.<\/p>\n
Verify:<\/h3>\n
$ lsdev -c iocp<\/strong><\/p>\n
\"iocp_defined\"<\/a><\/p>\n
Resolution:<\/h2>\n
Note:<\/strong> May need to do this as (or sudo to) the root user.<\/p>\n
$ smitty iocp<\/strong><\/p>\n
\"smitty_iocp\"<\/a><\/p>\n
The default is the highlighted “Change \/ Show\u00a0 Characteristics of I\/O Completion Ports<\/strong>“, just hit the Enter<\/strong> key.<\/p>\n
\"change_iocp\"<\/a><\/p>\n
Hit the tab key<\/strong> to until “Available<\/strong>” is shown in the right column, then hit the “Enter<\/strong>” key.<\/p>\n
\"change_to_available\"<\/a><\/p>\n
Smitty will display a status, hit the F10<\/strong> key to exit from Smitty.<\/p>\n
\"iocp_changed\"<\/a><\/p>\n
Again run the following command to verify the change was made to “Available”:<\/p>\n
$ lsdev -c iocp<\/strong><\/p>\n
\"verify_iocp_available\"<\/a><\/p>\n
In my case, I did not need to restart the operating system.\u00a0 I was at this point able to access Oracle’s SQLPLUS.<\/p>\n
\"SqlPlus12c\"<\/a><\/p>\n
For more details: see section 3.10 of the Oracle 12c Database Pre-Installation Tasks<\/a><\/p>\n
Thanks to Martin Berger’s blog<\/a><\/strong> (http:\/\/www.martinberger.com\/?p=289<\/a>).\u00a0 With the help of his blog post, I was able to resolve this issue.<\/p>\n","protected":false},"excerpt":{"rendered":"
Problem: After cloning a 12c Oracle Home to another AIX 7.1 server, I received the following error when I started SQLPLUS. $\u00a0 .\/sqlplus \/nolog exec(): 0509-036 Cannot load program sqlplus … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":955,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,3],"tags":[50,48,49],"class_list":["post-945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aix","category-oracle","tag-aix-7-1","tag-io-completion-port","tag-iocp"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/945"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=945"}],"version-history":[{"count":10,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/945\/revisions"}],"predecessor-version":[{"id":967,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/945\/revisions\/967"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/955"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=945"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}