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
Ïà¹ØÎĵµ£º
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 ......
ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.(ÎÒÔÏȱ»Õâ¸ö°ü¸øÆÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......
×Ó³ÌÐò ÃüÃûµÄ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 ......
¡¾ÔÒò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“PASSWORD_LIFE_TIME=180Ìì”Ëùµ¼Ö¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
ÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é ......
1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ:
(1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
(2) ½«"±¾µØ ......