ÔÚlinuxÖÐʹÓÃcrontabʵÏÖ¶ÔoracleµÄ¶¨Ê±±¸·Ý
¼ÙÉèÊý¾Ý¿âµÄÓµÓÐÕßΪoracle£¬Êý¾Ý¿âµÄÓû§Îªscott£¬Æä¿ÚÁîΪtrigger£¬
OracleÊý¾Ý¿âµÄ²ÎÊý$ORACLE_HOMEΪ/usr/oracle£¬$ORACLE_SIDΪoracle1£¬ÔòʵÏÖ²½ÖèÈçÏ£º
1¡¢½¨Á¢ÊµÏÖ±¸·ÝµÄshell
ÔÚ/usr/oracleÖÐÓÃviÃüÁÁ¢Îļþbackup.sh£¬ÆäÄÚÈÝΪ:
ORACLE_HOME=/usr/oracle; <br>export ORACLE_HOME;
ORACLE_SID=oracle1;
export ORACLE_SID;
D=$(date +%y%m%d);<br>export D;
/usr/oracle/bin/exp scott/trigger file=/usr/oracle/${D}.dmp owner=scott
×¢Ò⣺ÕâÀïD=$(date +%y%m%d); ÊÇÈ·±£Äãÿ¸ö±¸·ÝÎļþÒÔÈÕÆÚÃû×Ö.ÀýÈç:060814.dmp 060815.dmp
Èç¹ûÏëÿÌì°Ñ±¸·ÝÎļþ¸²¸ÇÄÇô°Ñ ${D}.dmp ÕâÀïÓù̶¨µÄÃû×ÖÀýÈç: backup.dmp
ʹÓÃchmodÃüÁîÐÞ¸Äbackup.shµÄÊôÐÔΪ¿ÉÖ´ÐУº
chmod +x backup.sh
µ½´Ë£¬¾ßÓб¸·Ý¹¦ÄܵĿÉÖ´ÐÐÎļþ£¨shell£©backup.shÒѾ½¨³É¡£ÆäÖ´Ðнá¹ûÊǽ«scottËùÓµÓеÄORACLE¶ÔÏ󱸷ݵ½/usr/oracleÖеÄbackup.dmpÖУ¬¶ÁÕß¿ÉÒÔÖ±½ÓÔËÐÐËüÀ´¿´¿´Ð§¹û¡£ÖµµÃ×¢ÒâµÄÊÇ£¬backup.shÖÐOracleµÄÁ½¸ö»·¾³²ÎÊýÒ»¶¨ÒªÉùÃ÷£¬·ñÔòϵͳ»á±¨´í¡£ÏÂÒ»²½½«¿ªÊ¼½¨Á¢oracleÓû§µÄCrontabÎļþ¡£
2¡¢²é¿´CrontabµÄʹÓÃȨÏÞ
ʹÓ󬼶Óû§£¨root£©µÄÉí·ÝµÇ¼£¬ÔÚ/usr/var/adm/cronÏÂͨ¹ýviÃüÁî²é¿´cron.denyÎļþ£¬Èç¹ûÊý¾Ý¿âµÄÓµÓÐÕßoracle±»ÁÐÔÚÀïÃæ£¬½«Æäɾ³ý¼´¿É¡£
3¡¢½¨Á¢oracleµÄCrontabÎļþ
ÓÃoracleÓû§µÇ¼£¬Í¨¹ýʹÓÃÃüÁîcrontab –e oracle¿ªÊ¼½¨Á¢oracleÓû§µÄCrontabÎļþ¡£ÆäÄÚÈÝΪ£º
00 17 * * 1-5 "/usr/oracle/backup.sh"
´æÅÌÍ˳öºó£¬Äã»á·¢ÏÖÔÚ/var/spool/cron/crontabsÖÐÐÂÔöÁËÒ»¸öÃûΪoracleÎļþ£¬Æä×÷ÓÃÊÇÔÚÖÜÒ»ÖÁÖÜÎåÿÌìµÄ17:00ÔËÐГ/usr/oracle/backup.sh”¡£
µ½´Ë´ó¹¦¸æ³É£¬ÏµÍ³»á½«Ã¿´Î±¸·ÝµÄÐÅϢͨ¹ýmailµÄÐÎʽ·¢Ë͸øoracleÓû§¡£
ÔÚ½øÐÐÒÔÉϲÙ×÷ʱ£¬½¨Ò齫/var/spool/cron/c
Ïà¹ØÎĵµ£º
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
LinuxµÄÍøÂçÅäÖÃ
Redhat LinuxµÄÍøÂçÅäÖ㬻ù±¾ÉÏÊÇͨ¹ýÐ޸öÅäÖÃÎļþÀ´ÊµÏֵģ¬ËäȻҲ¿ÉÒÔÓÃifconfigÀ´ÉèÖÃIP£¬ÓÃrouteÀ´ÅäÖÃĬÈÏÍø¹Ø£¬ÓÃhostnameÀ´ÅäÖÃÖ÷»úÃû£¬µ«ÊÇÖØÆôºó»á¶ªÊ§¡£
Ïà¹ØµÄÅäÖÃÎļþ
/ect/hosts ÅäÖÃÖ÷»úÃûºÍIPµØÖ·µÄ¶ÔÓ¦
/etc/sysconfig/network ÅäÖÃÖ ......
½ñÌìºöÈ»·¢ÏÖ´úÀí·þÎñÆ÷²»ÄÜʹÓÃÁË£¬ÉÏÈ¥Ò»¿´£¬squidµÄ¶Ë¿Ú¼àÌýStopµôÁË£¬²é¿´ÈÕÖ¾£¬ÈçÏ´íÎó ¡¡¡¡½ñÌìºöÈ»·¢ÏÖ´úÀí·þÎñÆ÷²»ÄÜʹÓÃÁË£¬ÉÏÈ¥Ò»¿´£¬squidµÄ¶Ë¿Ú¼àÌýStopµôÁË£¬²é¿´ÈÕÖ¾£¬ÈçÏ´íÎó
¡¡¡¡localhost kernel: Out of Memory: Killed process 785 (squid).
¡¡¡¡ÍøÉÏgoogleһͨ£¬Ã»ÓÐÈκÎÓмÛÖµµÄ½á¹û£¬×Ô¼ºÕÒÆäË ......
1.ϵͳÐÅÏ¢ÏÔʾÃüÁî # uname -a # ²é¿´ÄÚºË/²Ù×÷ϵͳ/CPUÐÅÏ¢
# head -n 1 /etc/issue # ²é¿´²Ù×÷ϵͳ°æ±¾
# cat /proc/cpuinfo # ²é¿´CPUÐÅÏ¢
# hostname ......