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
Ïà¹ØÎĵµ£º
±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
(1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
(2)½âѹËõzip£¬Ï±߰üº¬Ò»¸ö ......
×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£ÔÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËƺõ±äµÃÏ൱À§ÄÑ¡£¼¸¾ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
¡¡¡¡1¡¢±ÜÃâʹÓÃHibernate¿ò¼Ü
¡¡¡¡HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£ ......
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 ......
Oracle RAC
¡¡¡¡RAC£¬È«³Æreal application clusters£¬ÒëΪ“ÕæÕýÓ¦Óü¯Èº”£¬ ÊÇOracleаæÊý¾Ý¿âÖвÉÓõÄÒ»Ïîм¼Êõ£¬Ò²ÊÇOracleÊý¾Ý¿âÖ§³ÖÍø¸ñ¼ÆËã»·¾³µÄºËÐļ¼Êõ¡£
¡¡¡¡Oracle RACÖ÷ÒªÖ§³ÖOracle9i¡¢10g¡¢11g°æ±¾£¬¿ÉÒÔ¿ÉÒÔÖ§³Ö24 x 7 ÓÐЧµÄÊý¾Ý¿âÓ¦Óà ϵͳ£¬Ôڵͳɱ¾·þÎñÆ÷ÉϹ¹½¨¸ß¿ÉÓÃÐÔÊý¾Ý¿âϵͳ£¬²¢Ç ......