Oracle\u7528\u6237\u7684crontab\u53ef\u4ee5\u8fd0\u884c\uff0c\u4f46\u662f\u53d1\u73b0oracle\u7528\u6237\u65e0\u6cd5\u5bf9\u5176\u8fdb\u884c\u4fee\u6539\u3002
\n\u5c1d\u8bd5\u901a\u8fc7crontab \u2013e\u7684\u65b9\u5f0f\u4fee\u6539crontab\u7684\u914d\u7f6e\uff0c\u5728\u4fdd\u5b58\u7684\u65f6\u5019\u62a5\u9519\uff1a<\/p>\n
\/app\/oracle10g\/rman_catalog_dmp> crontab -l\r\n40 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\n\/app\/oracle10g\/rman_catalog_dmp> crontab -e\r\n\"\/var\/tmp\/aaaa01943\" 1 line, 59 characters \r\n47 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\n~\r\n~\r\n~\r\n~\r\n\"\/var\/tmp\/aaaa01943\" 1 line, 59 characters \r\ncrontab: can't create your crontab file in the crontab directory.\r\n\/app\/oracle10g\/rman_catalog_dmp> crontab -l\r\n40 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh<\/pre>\n\u5efa\u7acb\u4e00\u4e2acrontab\u6587\u4ef6\uff0c\u91c7\u7528crontab crontab_file\u7684\u65b9\u5f0f\u540c\u6837\u51fa\u73b0\u9519\u8bef\uff1a<\/p>\n
\/app\/oracle10g\/rman_catalog_dmp> vi crontab.oracle\r\n\"crontab.oracle\" 1 line, 59 characters \r\n47 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\n~\r\n~\r\n\"crontab.oracle\" 1 line, 59 characters \r\n\/app\/oracle10g\/rman_catalog_dmp> crontab crontab.oracle\r\ncrontab: error in message queue open, errno=13\r\nwarning: commands will be executed using \/usr\/bin\/sh<\/pre>\n\u901a\u8fc7GOOGLE\u67e5\u8be2\u53d1\u73b0\uff0c\u8fd9\u4e2a\u95ee\u9898\u6709\u5f88\u591a\u4eba\u78b0\u5230\u4e86\uff0c\u53ef\u60dc\u7684\u662f\uff0c\u6ca1\u6709\u627e\u5230\u4e00\u4e2a\u5408\u7406\u7684\u89e3\u91ca\u4e5f\u6ca1\u6709\u4e00\u4e2a\u9760\u8c31\u7684\u89e3\u51b3\u65b9\u6cd5\u3002
\n\u7531\u4e8e\u5728\u7f51\u4e0a\u627e\u4e0d\u5230\u89e3\u51b3\u65b9\u6cd5\uff0c\u53ea\u597d\u81ea\u5df1\u60f3\u529e\u6cd5\u89e3\u51b3\uff0c\u5c1d\u8bd5\u4f7f\u7528root\u6765\u8bbe\u7f6eoracle\u7684crontab\uff0c\u7ed3\u679c\u8fd9\u6b21\u6ca1\u6709\u62a5\u9519\uff0c\u800c\u4e14EXP\u811a\u672c\u4e5f\u6210\u529f\u8fd0\u884c\u4e86\uff1a<\/p>\n
acap3#[\/]crontab -e oracle\r\n\"\/var\/tmp\/aaaa02394\" 1 line, 59 characters \r\n0 7 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh \r\n~\r\n~\r\n~\r\n~\r\n\"\/var\/tmp\/aaaa02394\" 1 line, 57 characters \r\nwarning: commands will be executed using \/usr\/bin\/sh\r\nacap3#[\/]crontab -l oracle\r\n0 7 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh<\/pre>\n\u5207\u6362\u5230oracle\u7528\u6237\uff0c\u5728\u5bfc\u51fa\u7ed3\u675f\u540e\u6536\u5230mail\u901a\u77e5\uff1a<\/p>\n
\/app\/oracle10g\/rman_catalog_dmp> more \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\nexport ORACLE_SID=RMANDB\r\nexport ORACLE_BASE=\/app\/oracle10g\r\nexport ORACLE_HOME=$ORACLE_BASE\/product\/10.2.0\r\nexport NLS_LANG=American_America.ZHS16CGB231280\r\nexport PATH=$ORACLE_HOME\/bin:$PATH\r\nDATE=`date +\"%Y%m%d\"`\r\nexp parfile=\/app\/oracle10g\/rman_catalog_dmp\/exp.par file=\/app\/oracle10g\/rman_catalog_dmp\/rman_catalog_$DATE.dmp log=\/app\/oracle10g\/rman_cat\r\nalog_dmp\/rman_catalog_$DATE.log\r\nyou have mail in \/var\/mail\/oracle\r\n> mail \r\nFrom root@acap3 Thu Aug 18 15:21:46 EAT 2011\r\nReceived: (from root@localhost)\r\nby acap3 (8.9.3 (PHNE_35950)\/8.9.3) id PAA02370\r\nfor oracle; Thu, 18 Aug 2011 15:21:45 +0800 (EAT)\r\nDate: Thu, 18 Aug 2011 15:21:45 +0800 (EAT)\r\nFrom: root@acap3\r\nMessage-Id: <201108180721.PAA02370@acap3>\r\nSubject: cron\r\n\r\nExport: Release 10.2.0.4.0 - Production on Thu Aug 18 15:15:00 2011\r\nCopyright (c) 1982, 2007, Oracle. All rights reserved.\r\n\r\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Data Mining and Real Application Testing options\r\nExport done in ZHS16CGB231280 character set and AL16UTF16 NCHAR character set\r\nAbout to export specified users ...\r\n. exporting pre-schema procedural objects and actions\r\n. exporting foreign function library names for user RMAN_FGMS \r\n. exporting foreign function library names for user RMAN_MODDB \r\n. exporting foreign function library names for user RMAN_ACDB \r\n.\r\n.\r\n.\r\n. exporting post-schema procedural objects and actions\r\n. exporting statistics\r\nExport terminated successfully without warnings.\r\n\r\n*************************************************\r\nCron: The previous message is the standard output\r\nand standard error of one of your crontab commands:\r\n\/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\n\r\n? q<\/pre>\n\u8fd9\u79cd\u529e\u6cd5\u867d\u7136\u53ef\u4ee5\u89e3\u51b3\u95ee\u9898\uff0c\u4f46\u662f\u540c\u6837\u4e5f\u5b58\u5728\u4e00\u4e2a\u95ee\u9898\uff0c\u5c31\u662foracle\u7528\u6237\u6ca1\u6709\u6743\u9650\u68c0\u67e5\u81ea\u5df1\u7528\u6237\u4e0b\u7684crontab\u8bbe\u7f6e\u4e86\u3002
\n\u6700\u540e\u5c1d\u8bd5\u5728metalink\u4e2d\u67e5\u8be2\uff0c\u6ca1\u60f3\u5230\u627e\u5230\u4e86\u6700\u7ec8\u7684\u89e3\u51b3\u65b9\u6848\uff0c\u6587\u6863\u53c2\u8003ID 1005095.1\u3002\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u7531\u4e8e\/usr\/bin\/crontab\u547d\u4ee4\u7684\u6743\u9650\u4e0d\u5bf9\uff1a<\/p>\n
acap3#[\/]crontab -r oracle\r\nacap3#[\/]ls -l \/usr\/bin\/crontab\r\n-rwxrwxrwx 1 root bin 28672 Jul 18 2002 \/usr\/bin\/crontab\r\nacap3#[\/]chmod 4555 \/usr\/bin\/crontab\r\nacap3#[\/]ls -l \/usr\/bin\/crontab\r\n-r-sr-xr-x 1 root bin 28672 Jul 18 2002 \/usr\/bin\/crontab<\/pre>\n\u5c06crontab\u547d\u4ee4\u7684\u6743\u9650\u4fee\u6539\u4e3a4555\u540e\uff0coracle\u7528\u6237\u7684crontab\u6062\u590d\u6b63\u5e38\uff1a<\/p>\n
\/app\/oracle10g\/rman_catalog_dmp> crontab -e\r\n\"\/var\/tmp\/aaaa02482\" \r\n# 0 0 * * * test.sh\r\n~\r\n~\r\n~\r\n\"\/var\/tmp\/aaaa02482\" 1 line, 20 characters \r\nwarning: commands will be executed using \/usr\/bin\/sh\r\n\/app\/oracle10g\/rman_catalog_dmp> more crontab.oracle\r\n47 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\n\/app\/oracle10g\/rman_catalog_dmp> echo \"0 7 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\" > crontab.oracle\r\n\/app\/oracle10g\/rman_catalog_dmp> more crontab.oracle\r\n0 7 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh\r\n\/app\/oracle10g\/rman_catalog_dmp> crontab crontab.oracle\r\nwarning: commands will be executed using \/usr\/bin\/sh<\/pre>\n\u4ece\u8fd9\u4e2a\u95ee\u9898\u7684\u89e3\u51b3\u8fc7\u7a0b\u4e5f\u53ef\u4ee5\u770b\u51fa\uff0cOracle\u7684metalink\u77e5\u8bc6\u5e93\u7684\u5f3a\u5927\u4e4b\u5904\uff0c\u4e00\u4e2a\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u7684\u95ee\u9898\uff0c\u5728HP\u4ee5\u53ca\u4e00\u4e9b\u64cd\u4f5c\u7cfb\u7edf\u76f8\u5173\u7684\u4e13\u4e1a\u7f51\u7ad9\u4e0a\u90fd\u67e5\u627e\u4e0d\u5230\uff0c\u53cd\u800c\u5728Oracle\u7684metalink\u4e2d\u67e5\u8be2\u5230\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle\u7528\u6237\u7684crontab\u53ef\u4ee5\u8fd0\u884c\uff0c\u4f46\u662f\u53d1\u73b0oracle\u7528\u6237\u65e0\u6cd5\u5bf9\u5176\u8fdb\u884c\u4fee\u6539\u3002 \u5c1d\u8bd5\u901a\u8fc7crontab \u2013e\u7684\u65b9\u5f0f\u4fee\u6539crontab\u7684\u914d\u7f6e\uff0c\u5728\u4fdd\u5b58\u7684\u65f6\u5019\u62a5\u9519\uff1a \/app\/oracle10g\/rman_catalog_dmp> crontab -l 40 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh \/app\/oracle10g\/rman_catalog_dmp> crontab -e “\/var\/tmp\/aaaa01943” 1 line, 59 characters 47 14 * * * \/app\/oracle10g\/rman_catalog_dmp\/exp_by_date.sh ~ ~ ~ ~ “\/var\/tmp\/aaaa01943” 1 line, 59 characters crontab: can’t create your crontab … Continue reading