Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle¹ÜÀíÔ±µÄÁ½ÖÖÈÏÖ¤·½·¨

  Oracle¹ÜÀíÔ±µÄÁ½ÖÖÈÏÖ¤·½·¨
×¢Ò⣺ÖØÒª
parameter ÖÐremote_login_passwordfile
1¡¢alter system set remote_login_passwordfile= none scope =spfile£»
     º¬Ò壺·ÇÃÜÂëÈÏÖ¤£¨´Ëʱ½öosÈÏÖ¤ £©
 2¡¢alter system set remote_login_passwordfile= exclusive scope =spfile£»
     º¬Ò壺ÃÜÂëÎļþÈÏÖ¤£¨´Ëʱ¿É osÈÏÖ¤£©£»
network/admin/sqlnet.oraÎļþÖÐsqlnet.authentication_services
1¡¢sqlnet.authentication_services = NTS  ±íʾOSÈÏÖ¤+ÃÜÂëÎļþÈÏÖ¤2ÖÖ·½Ê½¾ù¿É
2¡¢sqlnet.authentication_services  =NONEʱ ±íʾ½öÃÜÂëÎļþÈÏÖ¤
        1¡¢¹ÜÀíÔ±µÄȨÏÞ£º
        SYSDBA: ĬÈÏschema ΪSYS
        SYSOPER: ĬÈÏschema Ϊ PUBLIC
        ÕâÁ½ÖÖȨÏÞÔÊÐíÓû§ÔÚÊý¾Ý¿âûÓдò¿ªµÄʱºò¾Í¿ÉÒԵǽÊý¾Ý¿â£¬ËùÒÔÕâÖÖȨÏ޵ĿØÖÆȨÔÚÊý¾Ý¿âÖ®Í⡣ͨ³£ÕâÖÖȨÏÞÒ²¿ÉÒÔ±»¿´×öÒ»ÖÖÔÊÐíÄã¶ÔÊý¾Ý¿â½øÐÐijÖÖ²Ù×÷µÄÁ¬½Ó£¬±ÈÈçCONNECT / AS SYSDBA
        2¡¢Á½ÖÖ¹ÜÀíԱȨÏÞÈÏÖ¤·½·¨
        (1) Operating system (OS) authentication :²Ù×÷ϵͳÈÏÖ¤
        --ÒÔÏÂÇé¿öʹÓø÷½·¨£º
        ¹ÜÀíÔ¶³ÌÊý¾Ý¿âʱ£¬¾ßÓа²È«µÄÍøÂçÁ¬½Ó£¨secure connection£©¡£
        ¹ÜÀí±¾µØÊý¾Ý¿âʱ£¬ÏëʹÓÃOSÈÏÖ¤¡£
        --²Ù×÷²½Ö裺
        a.½¨Á¢Ò»¸öosϵͳÓû§
        b.½«Õâ¸öÓû§¼ÓÈëµ½OSDBA»òÕßOSOPERµÄOS×é¡£
        c.ÉèÖòÎÊýREMOTE_LOGIN_PASSWORDFILE=NONE
        d.CONNECT / AS SYSDBA
        --¹ØÓÚOSDBAºÍOSOPER×é
        OSDBA¶ÔÓ¦: UNIXΪdba; WINDOWSΪORA_DBA
    &nbs


Ïà¹ØÎĵµ£º

ORACLE RAC DOWN»úÎÊÌâ·ÖÎö

Author: Rainny
Date: 2010-3-5
Ò»£¬Ö¢×´ÃèÊö
2¸ö½ÚµãµÄORACLE 10G RAC£¬¸ôÒ»¶Îʱ¼äÆäÖеÄÒ»¸öNODE¾Í»áDOWN»ú¡£½Úµã´ÓCLUSTERÖб»ÇýÖð¡£
¶þ£¬Õï¶Ï¹ý³Ì
Rac1±»Öð³ö£¬RAC2´æ»î£¬RAC2½Ó¹ÜÁËRAC1µÄVIP£¬ÎÒÃÇÀ´²é¿´RAC2µÄÏà¹ØLOG¡£
Ê×ÏȲ鿴RAC2µÄ¸æ¾¯ÈÕÖ¾£º..\log\rac2\alertrac2.log:
2010-03-05 14:39:50.750
[cssd(7 ......

ORACLEÐÔÄÜÕï¶ÏʵÀý ÐÐǨÒƺÍÐÐÁ´½Ó

ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.(ÎÒÔ­Ïȱ»Õâ¸ö°ü¸øÆ­ÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç23 24

×Ó³ÌÐò ÃüÃûµÄpl/sql¿é
create procedure ¹ý³ÌÃû [²ÎÊý1 in|out|in out¡­]
    ¾Ö²¿±äÁ¿ÉùÃ÷
    Ö´ÐÐÓï¾ä
in
out
in out
    ¹ý³ÌÃû(²ÎÊýÀï±í); create or replace
procedure add123 as
i integer;
j integer;
begin
i:=1;
j:=2;
dbms_output.put_l ......

Oracle 11g´æÔÚÃÜÂë¹ýÆÚÎÊÌâ

¡¾Ô­Òò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“PASSWORD_LIFE_TIME=180Ìì”Ëùµ¼Ö¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
ÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é ......

OracleÒì³£ÎÊÌâ½â¾ö·½°¸


1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔ­ÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
 ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ: 
 (1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
 (2) ½«"±¾µØ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ