{"id":1133,"date":"2011-04-14T14:35:38","date_gmt":"2011-04-14T19:35:38","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=1133"},"modified":"2011-07-06T10:01:44","modified_gmt":"2011-07-06T15:01:44","slug":"accessing-asm-via-ftp","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2011\/04\/14\/accessing-asm-via-ftp\/","title":{"rendered":"Accessing ASM via FTP"},"content":{"rendered":"

This is a documented feature, but I wanted to post my notes so I could reference them if needed.<\/p>\n

All you basically have to do to set this up is:<\/p>\n

  • install XML DB (package dbms_xdb). This is installed if you create a database with DBCA by default.<\/li>\n
  • Set the ftp port used by XML DB<\/li>\n

    Below is the output of executing these steps.<\/p>\n

    \r\nSQL> exec dbms_xdb.sethttpport(8080);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL> exec dbms_xdb.setftpport(2100);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\nand Real Application Testing options\r\n15:27:52 oracle@racperf01 ~ >exit\r\nlogout\r\nConnection to racperf01 closed.\r\n15:27:56 oracle@emgrid01 ~ >ftp racperf01 2100\r\nConnected to racperf01.\r\n220- racperf01\r\nUnauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.\r\n220 racperf01 FTP Server (Oracle XML DB\/Oracle Database) ready.\r\nName (racperf01:oracle): system\r\n331 pass required for SYSTEM\r\nPassword:\r\n230 SYSTEM logged in\r\nRemote system type is Unix.\r\nftp> cd \/sys\/asm\/PRDRAC_ASM_SEED\/PRDRAC\/DATAFILE\r\nftp> ls\r\n227 Entering Passive Mode (ip_filtered_out)\r\n150 ASCII Data Connection\r\n-rw-r--r--   1 SYS      oracle  42750451712 APR 14 19:28 XWCS_LG1.365.649697817\r\n-rw-r--r--   1 SYS      oracle  104865792 APR 14 19:28 ATHD_LG6.366.649697819\r\n-rw-r--r--   1 SYS      oracle  94686420992 APR 14 19:28 ATHX_TX1.367.649697837\r\n-rw-r--r--   1 SYS      oracle  55050248192 APR 14 19:28 ATHX_TX2.368.649699187\r\n\r\n\r\n\r\n-rw-r--r--   1 SYS      oracle  104865792 APR 14 19:28 XWCX_SM01.9701.745789107\r\n-rw-r--r--   1 SYS      oracle  4508884992 APR 14 19:28 XWCD_SM01.8544.745789111\r\n-rw-r--r--   1 SYS      oracle  3565162496 APR 14 19:28 XWCD_LB01_4K.8628.745789139\r\n-rw-r--r--   1 SYS      oracle  209723392 APR 14 19:28 ITRX_SM01.9662.745850011\r\n-rw-r--r--   1 SYS      oracle  8808046592 APR 14 19:28 ITRD_SM01.8523.745850017\r\n226 ASCII Transfer Complete\r\nftp>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
    This is a documented feature, but I wanted to post my notes so I could reference them if needed. All you basically have to do to set this up is: install XML DB (package dbms_xdb). This is installed if you…<\/p>\n
    Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/1133"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1133"}],"version-history":[{"count":16,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/1133\/revisions"}],"predecessor-version":[{"id":1141,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/1133\/revisions\/1141"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1133"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}