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
Ïà¹ØÎĵµ£º
ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.(ÎÒÔÏȱ»Õâ¸ö°ü¸øÆÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......
ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍƳöÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ ......
2010-03-12 21:18:52
ÔÚgoogleÀïÒ»ËÑÒ»´ó°Ñ¡£µ«´ó¶à¶¼ÊÇÒ»¸ö°æ±¾¡£ÔÚÕâÀïÎÒҲתÌùһϡ£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefau ......
¹ØÓÚplsqlÖеÄdefine±äÁ¿ÒÔ¼°Oracle±äÁ¿·ÖÀàС½á
2009-07-29 15:18
ÏȼÇÔظÕÀ§ÈÅÎÒµÄÒ»¸öÎÊÌ⣬×î½üѧϰplsql£¬ÓÉÓÚËùÓÃѧϰÊé¼®ºóÃæÌṩÌâÄ¿³£Óõ½define±äÁ¿£¬µ«ÓÉÓÚÕâÒ»±äÁ¿µÄʹÓÃÌØÊâÐÔ£¬×Ô¼º±ãѰ˼ÕâÒ»±äÁ¿ËùÊéÀà±ð£¬OracleÌṩµÄ±äÁ¿·ÖÀ๲ÓÐËÄÀࣺ
1£©±êÁ¿£¨scalar£©ÀàÐÍ
2£©¸´ºÏ£¨composite£©ÀàÐÍ
3£©²ÎÕÕ£¨re ......