ORACLE DBAѧϰ±Ê¼Ç ¹ÜÀí¹éµµÈÕÖ¾Îļþ
¹éµµÈÕÖ¾Îļþ£ºÊÇ´¦Óڷǻ£¨INACTIVE£©µÄ״̬µÄÖØ×öÈÕÖ¾ÎļþµÄ±¸·Ý¡£Ëü¶ÔORACLEÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´ÆðÖÁ¹ØÖØÒªµÄ×÷Óá£ÊÇÁª»úÖØ×öÈÕÖ¾ÎļþµÄÒ»¸ö¸±±¾£¬Óë±»¸´ÖƵijÉÔ±Íê³ÉÒ»Ñù£¬¼´ÖØ×ö¼Ç¼Ïàͬ£¬ÈÕÖ¾ÐòÁкÅÏàͬ¡£
Ò»¡¢Êý¾Ý¿âµÄ¹éµµÓë·Ç¹éµµÄ£Ê½£º
1£® µ±Êý¾Ý¿â´¦ÓÚNOACRCHIVELOGģʽʱ£¬²»¶ÔÖØ×öÈÕÖ¾Îļþ½øÐй鵵£¬Ö±½Ó¸²¸Ç¾ÉµÄÖØ×öÈÕÖ¾Îļþ£¬´ËʱÊý¾Ý¿âÖ»ÄÜ´ÓÀý³Ìʧ°ÜÖнøÐлָ´¡£
Ìص㣺
a. ·¢ÉúÈÕÖ¾Çл»Ê±£¨alter system switch logfile£©£¬LGWRºǫ́½ø³Ì¿ÉÒÔÎÞÌõ¼þ¸²¸ÇÔÀ´µÄÒѾ±äΪ·Ç»î¶¯µÄ£¨INACTIVE£©ÖØ×öÈÕÖ¾ÎļþµÄÄÚÈÝ¡£
b. ½øÐÐÊý¾Ý¿â±¸·Ýʱ£¬±ØÐëÏÈʹÓÃSHUTDOWN »òÕßSHUTDOWN IMMEDIATEÃüÁîÏȹرÕÊý¾Ý¿â£¬È»ºó²ÅÄÜͨ¹ý²Ù×÷ϵͳ±¸·ÝËùÓеÄÎïÀíÎļþ¡£¼´À䱸·Ý¡£²»ÄܽøÐÐÁª»úµÄÈȱ¸·Ý¡£
c. NOACRCHIVELOGģʽʱ£¬Ö»Äܱ£»¤Êý¾Ý¿âÃâÓÚÀý³Ìʧ°Ü£¬µ«²»Äܱ£»¤Êý¾Ý¿âÃâÓÚ½éÖÊʧ°Ü¡£
d. NOACRCHIVELOGģʽ²»ÐèÒª¿¼ÂÇ´æ´¢¿Õ¼äµÄÎÊÌâ¡£
2£® µ±Êý¾Ý¿â´¦ÓÚACRCHIVELOGģʽʱºò£¬ÏµÍ³Í¨¹ýºǫ́½ø³ÌARCnÀ´°ïÖúDBA×Ô¶¯Íê³É¶ÔÖØ×öÈÕÖ¾Îļþ½øÐй鵵£¬¹éµµÖ®ºó²Å¸²¸Ç¾ÉµÄÖØ×öÈÕÖ¾Îļþ£¬²¢½«Æ临ÖƵ½Ò»¸öÖ¸¶¨µÄλÖ㬳ÉΪ¹éµµÈÕÖ¾Îļþ£¬´ËʱÊý¾Ý¿â»¹ÄܽøÒ»²½´Ó½éÖÊʧ°ÜÖлָ´¡£¼´¿É½«Êý¾ÝµÄËðʧ¼õÉÙµ½×îС£¬¿ÉÓÃÐÔÌá¸ßµ½×î¸ß¡£
Ìص㣺
a. µ±ACRCHIVELOGģʽʱ¡£¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐÐÁª»úµÄÈȱ¸·Ý¡£
b. µ±³öÏÖÊý¾ÝÎļþËð»µÊ±£¬³ýÁËSYSTEM±í¿Õ¼äµÄÊý¾ÝÎļþ£¬ÆäËû±í¿Õ¼ä¶¼¿ÉÒÔÔÚÊý¾Ý¿â´¦ÓÚOPENʱ»Ö¸´¡£
c. Ö´ÐÐÊý¾Ý¿â±¸·Ýʱ£¬²»½ö¿ÉÒÔ½øÐÐÍê³É»Ö¸´£¬Ò²¿ÉÒÔÖ¸¶¨»Ö¸´µ½Ä³¸öÌض¨µÄʱ¼äµã¡£
Ò»¡¢Êý¾Ý¿â¹éµµ²ÎÊý
ͨ¹ýARCHIVE LOG LIST ²é¿´Êý¾Ý¿âµÄ¹éµµÄ£Ê½£»
1£® LOG_ARCHIVE_DUPLIEX_DESTÓëLOG_ARCHIVE_DEST_n
LOG_ARCHIVE_DESTÓÃÓÚÖ¸¶¨µÚÒ»¸ö¹éµµÄ¿±êλÖã¨Ö÷¹éµµÄ¿±ê£©£¬n±íʾ¸´±¾ÊýÁ¿¡£Èç¹ûÖ»ÉèÖÃÒ»¸ö¸´±¾£¬µ±Õâ¸ö¸´±¾´íÎóʱºò£¬Ôò¿ÉÒÔͨ¹ýÆäËû¸´±¾±¸Óᣣ¨1<=n<=10£©
LOG_ARCHIVE_DUPLIEX_DESTÓÃÓÚÖ¸¶¨µÚ¶þ¸ö¹éµµÄ¿±êλÖ㨴ι鵵Ŀ±ê£©£¬
ÕâÁ½¸ö²ÎÊýµÄÏàÅųâµÄ£¬²»ÄÜͬʱ´æÔÚ¡£
2£® Æô¶¯ºÍ½ûÓÃ×Ô¶¯¹éµµµÄ²ÎÊý
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
--´´½¨Ò»¸ö°ü
create or replace package types
as
type cursorType is ref cursor;
end types;
--´´½¨´æ´¢¹ý³Ì,ÓαêÀàÐÍ·µ»Ø²ÎÊý
create or replace procedure SP_Fee_Instance(v_company in varchar, v_sdate in nva ......
ÔÎĵØÖ·£ºhttp://blog.csdn.net/cnham/archive/2009/08/30/4500928.aspx
oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæͨ¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ ......
ÏÖÏó£º
oracleÆô¶¯¼àÌý£¬±¨¸æÈçÏ´íÎó£º
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
ÔÒò£º
lisenter.log ÎļþÌ«´óÁË,OracleÎÞ·¨¶ÔËü½øÐвÙ×÷ÁË£¬µ¼ÖÂlistenerÎÞ·¨Õý³£Æô¶¯¡£
listener.log ³¬¹ý2G¾Í»á³öÎÊÌâ
·½·¨£º
·¨1. ÒƳýÔ$ ......