{"id":1463,"date":"2012-11-24T23:51:30","date_gmt":"2012-11-24T15:51:30","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1463"},"modified":"2013-08-02T14:56:35","modified_gmt":"2013-08-02T06:56:35","slug":"%e6%9f%a5%e8%af%a2%e5%a4%96%e9%83%a8%e8%a1%a8%e5%87%ba%e7%8e%b0kup-4040%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1463","title":{"rendered":"\u67e5\u8be2\u5916\u90e8\u8868\u51fa\u73b0KUP-4040\u9519\u8bef"},"content":{"rendered":"

\u5728\u8fd0\u884cORACLE_LOADER\u7c7b\u578b\u7684\u5916\u90e8\u8868\u67e5\u8be2\u65f6\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002
\n\u6570\u636e\u5e93\u7684\u60c5\u51b5\u6bd4\u8f83\u590d\u6742\uff0c\u7b80\u5355\u63cf\u8ff0\u4e00\u4e0b\u3002\u6570\u636e\u5e93\u662f\u5b89\u88c5\u5728\u64cd\u4f5c\u7cfb\u7edforacle\u7528\u6237\u4e0b\uff0c\u9ed8\u8ba4\u7ec4\u4e3aoinstall\uff0c\u5f53\u524d\u4f7f\u7528\u7684\u662f\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237tingkun.yang\uff0c\u540c\u6837\u662foinstall\u7ec4\uff0c\u56e0\u6b64\u5f53\u524d\u7528\u6237\u53ef\u4ee5\u7528SYSDBA\u8eab\u4efd\u767b\u5f55\u6570\u636e\u5e93\u3002
\n\u4ee5\u5f53\u524d\u7528\u6237tingkun.yang\u8fd0\u884csqlplus\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u521b\u5efa\u76ee\u5f55\u548c\u5916\u90e8\u8868\uff0c\u5728\u8bfb\u53d6\u5916\u90e8\u8868\u65f6\u62a5\u9519\uff1a<\/p>\n

[tingkun.yang@enmoteam2 ~]$ id\r\nuid=505(tingkun.yang) gid=501(oinstall) groups=501(oinstall),502(dba)\r\n[tingkun.yang@enmoteam2 ~]$ ps -ef|grep lgwr\r\noracle 1552 1 0 Sep07 ? 00:04:14 ora_lgwr_enmot2\r\n505 28312 28185 0 22:52 pts\/0 00:00:00 grep lgwr\r\n[tingkun.yang@enmoteam2 ~]$ sqlplus olasuser\/olasuser\r\nSQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 24 22:53:06 2012\r\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nSQL> create directory d_alert as '\/home\/oracle\/sqlldr';\r\nDirectory created.\r\nSQL> create table t_alert\r\n2 (text varchar2(4000))\r\n3 organization external\r\n4 (type oracle_loader\r\n5 default directory d_alert\r\n6 access parameters\r\n7 (records delimited by newline\r\n8 fields (text (1:255) char))\r\n9 location ('alert_enmot2.log'));\r\nTable created.\r\nSQL> select * from t_alert where rownum = 1;\r\nselect * from t_alert where rownum = 1\r\n*\r\nERROR at line 1:\r\nORA-29913: error in executing ODCIEXTTABLEOPEN callout\r\nORA-29400: data cartridge error\r\nKUP-04040: file alert_enmot2.log in D_ALERT not found<\/pre>\n
\u67e5\u8be2MOS\u53d1\u73b0\u6240\u6709\u7684\u5df2\u77e5\u95ee\u9898\u90fd\u548c\u5f53\u524d\u7684\u73b0\u8c61\u4e0d\u540c\uff0c\u8be5\u6587\u4ef6\u5df2\u7ecf\u5b58\u5728\u4e8e\u6307\u5b9a\u7684\u76ee\u5f55\u4e0b\uff0c\u751a\u81f3\u5728\u8fd9\u4e2a\u76ee\u5f55\u4e0b\uff0c\u9519\u8bef\u65e5\u5fd7\u5df2\u7ecf\u751f\u6210\uff1a<\/p>\n
[oracle@enmoteam2 sqlldr]$ pwd\r\n\/home\/oracle\/sqlldr\r\n[oracle@enmoteam2 sqlldr]$ ls -l\r\ntotal 664\r\n-rw-rw-rw- 1 oracle oinstall 674964 Nov 22 14:06 alert_enmot2.log\r\n-rw-r--r-- 1 oracle oinstall 95 Nov 24 22:54 T_ALERT_28321.log\r\n[oracle@enmoteam2 sqlldr]$ more T_ALERT_28321.log \r\n\r\nLOG file opened at 11\/24\/12 22:54:52\r\nKUP-04040: file alert_enmot2.log in D_ALERT not found<\/pre>\n
\u7ecf\u8fc7\u591a\u6b21\u6d4b\u8bd5\u53d1\u73b0\uff0c\u5982\u679c\u4f7f\u7528oracle\u7528\u6237\u542f\u52a8sqlplus\uff0c\u5219\u53ef\u4ee5\u8bfb\u53d6t_alert\u8868\uff1a<\/p>\n
[oracle@enmoteam2 ~]$ id\r\nuid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)\r\n[oracle@enmoteam2 ~]$ sqlplus olasuser\/olasuser\r\nSQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 24 22:58:57 2012\r\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nSQL> select * from t_alert where rownum = 1;\r\nTEXT\r\n----------------------------------------------------\r\nFri Aug 10 13:39:20 2012<\/pre>\n
\u4e00\u76f4\u8ba4\u4e3a\uff0c\u8fd9\u79cdDIRECTORY\u7684\u8bfb\u53d6\uff0c\u4f7f\u7528\u7684\u662foracle\u7528\u6237\u7684\u8eab\u4efd\u548c\u6743\u9650\uff0c\u548c\u767b\u5f55\u7684\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u65e0\u5173\u3002\u6ca1\u6709\u60f3\u5230\uff0cOracle\u662f\u6839\u636e\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u662f\u5426\u6709\u6743\u9650\u8bbf\u95ee\u8fd9\u4e2a\u6587\u4ef6\u4f5c\u4e3a\u5916\u90e8\u8868\u8bbf\u95ee\u7684\u6761\u4ef6\u3002\u4f46\u662f\u5916\u90e8\u8868\u7684\u65e5\u5fd7\u5e76\u6ca1\u6709\u53d7\u6743\u9650\u7684\u63a7\u5236\u800c\u5df2\u7ecf\u4ea7\u751f\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u8fd0\u884cORACLE_LOADER\u7c7b\u578b\u7684\u5916\u90e8\u8868\u67e5\u8be2\u65f6\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002 \u6570\u636e\u5e93\u7684\u60c5\u51b5\u6bd4\u8f83\u590d\u6742\uff0c\u7b80\u5355\u63cf\u8ff0\u4e00\u4e0b\u3002\u6570\u636e\u5e93\u662f\u5b89\u88c5\u5728\u64cd\u4f5c\u7cfb\u7edforacle\u7528\u6237\u4e0b\uff0c\u9ed8\u8ba4\u7ec4\u4e3aoinstall\uff0c\u5f53\u524d\u4f7f\u7528\u7684\u662f\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237tingkun.yang\uff0c\u540c\u6837\u662foinstall\u7ec4\uff0c\u56e0\u6b64\u5f53\u524d\u7528\u6237\u53ef\u4ee5\u7528SYSDBA\u8eab\u4efd\u767b\u5f55\u6570\u636e\u5e93\u3002 \u4ee5\u5f53\u524d\u7528\u6237tingkun.yang\u8fd0\u884csqlplus\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u521b\u5efa\u76ee\u5f55\u548c\u5916\u90e8\u8868\uff0c\u5728\u8bfb\u53d6\u5916\u90e8\u8868\u65f6\u62a5\u9519\uff1a [tingkun.yang@enmoteam2 ~]$ id uid=505(tingkun.yang) gid=501(oinstall) groups=501(oinstall),502(dba) [tingkun.yang@enmoteam2 ~]$ ps -ef|grep lgwr oracle 1552 1 0 Sep07 ? 00:04:14 ora_lgwr_enmot2 505 28312 28185 0 22:52 pts\/0 00:00:00 grep lgwr [tingkun.yang@enmoteam2 ~]$ sqlplus olasuser\/olasuser SQL*Plus: Release 11.2.0.3.0 Production on … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":""},"categories":[3],"tags":[638,27,1281,396,368,1282],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-nB","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1463"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1463"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1463\/revisions"}],"predecessor-version":[{"id":1464,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1463\/revisions\/1464"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}