Oracle 11g´æÔÚÃÜÂë¹ýÆÚÎÊÌâ
¡¾ÔÒò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“PASSWORD_LIFE_TIME=180Ìì”Ëùµ¼Ö¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
ÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐЧÆÚÓÉĬÈϵÄ180ÌìÐ޸ijɓÎÞÏÞÖÆ”£º
sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ÐÞ¸ÄÖ®ºó²»ÐèÒªÖØÆô¶¯Êý¾Ý¿â£¬»áÁ¢¼´ÉúЧ¡£
4¡¢Ð޸ĺ󣬻¹Ã»Óб»ÌáʾORA-28002¾¯¸æµÄÕÊ»§²»»áÔÙÅöµ½Í¬ÑùµÄÌáʾ£»
ÒѾ±»ÌáʾµÄÕÊ»§±ØÐëÔÙ¸ÄÒ»´ÎÃÜÂ룬¾ÙÀýÈçÏ£º
$sqlplus / as sysdba
sql> alter user smsc identified by <ÔÀ´µÄÃÜÂë> ----²»Óû»ÐÂÃÜÂë
oracle11gÆô¶¯²ÎÊýresource_limitÎÞÂÛÉèÖÃΪfalse»¹ÊÇtrue£¬ÃÜÂëÓÐЧÆÚ¶¼ÊÇÉúЧµÄ£¬ËùÒÔ±ØÐëͨ¹ýÒÔÉÏ·½Ê½½øÐÐÐ޸ġ£ÒÔÉϵÄÕÊ»§ÃûÇë¸ù¾Ýʵ¼ÊʹÓõÄÕÊ»§Ãû¸ü¸Ä¡£
¶þ¡¢¡¾ÎÊÌâÃèÊö¡¿
½üÈÕH¾Öµã·´À¡£¬Ê¹ÓÃsqlplusµÇ½¶ÌÏûÏ¢oracleÊý¾Ý¿âʱÌáʾ“ORA-28000: Õʺű»Ëø¶¨”¡£
¡¾ÔÒò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“FAILED_LOGIN_ATTEMPTS=10´Î”£¬µ±ÊäÈëÃÜÂë´íÎó´ÎÊý´ïµ½ÉèÖÃÖµ½«µ¼Ö´ËÎÊÌâ¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
Õʺű»Ëø¶¨ºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÕʺű»Ëø¶¨ºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
3¡¢½«³¢ÊԵǼʧ°Ü´ÎÊýÓÉĬÈϵÄ10´ÎÐ޸ijɓÎÞÏÞÖÆ”£º
sql>ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
4¡¢Ð޸ĺ󣬻¹Ã»Óб»ÌáʾORA-28000¾¯¸æµÄÓû§²»»áÔÙÅöµ½Í¬ÑùµÄÌáʾ£»
ÒѾ±»Ëø¶¨µÄÕÊ»§±ØÐë½
Ïà¹ØÎĵµ£º
ÏîÄ¿ÖÐÐèҪʹÓõ½°´¹æÔòÉú³ÉÐòÁкţ¬¿ªÊ¼µÄ½â¾ö°ì·¨ÊǸù¾ÝÌõ¼þÈ¡µÃ×î´óIDºÅ½øÐзֽâ+1Ôٺϲ¢µÄ½â¾ö·½°¸£¬ºóÀ´·¢ÏÖÈç¹ûÁ½¸ö¿Í»§Í¬Ê±²Ù×÷µÄʱºò³öÏÖÎÊÌ⣺Ìí¼ÓµÄʱºòIDÒѾ´æÔÚ£¬ÔÒòÊÇ£ºAÓû§ÔÚ·ÃÎÊÈ¡µÃµÚMAX(N)¼Ç¼deID£¬µ«ÊÇ»¹Ã»ÓнøÐÐÔö¼Ó²Ù×÷£¬Õâʱ£¬BÓû§Ò²È¡µÃµÚMAX(N)¼Ç¼deID£¬ÕâÊÇ£Á½øÐÐÌí¼Ó²Ù×÷ͬʱ£¬£ÂҲͬʱ½øÐÐ ......
ORACLE 10G for RHEL AS 4 °²×°
ÑéÖ¤°²×°:¼ì²éORACLEËùÐèµÄ³ÌÐòÊÇ·ñ°²×°¾ùÒÑ°²×°(»ò¸ü¸ß°æ±¾)
compat-db-4.1.25-9.i386.rpm
compat-gcc-32-3.2.3-47.3.i386.rpm
compat-gcc-32-c++-3.2.3-47.3.i386.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm
compat-oracle-rhel4-1.0-5.i386.rpm
gcc-3.4.3-9.EL4.i386.rpm
gli ......
--´´½¨¶ÔÏóÀàÐÍ
create or replace type emp_typ as object (
id number,
name varchar2(30),
sal number,
comm number,
member procedure change_comm(new_comm number),
member function get_info return varchar2
) ;
--´´½¨¶ÔÏóÀàÐ͹¹Ô캯Êý¶¨Òå
create or replace type body emp_typ is
member proce ......
ºÜ¶àÈ˶¼ÖªµÀ£¬OracleµÄ¼àÌýÆ÷Ò»Ö±´æÔÚ×ÅÒ»¸ö°²È«Òþ»¼£¬¼ÙÈç²»ÉèÖð²È«´ëÊ©£¬ÄÇôÄܹ»·ÃÎʵÄÓû§¾Í¿ÉÒÔÔ¶³Ì¹Ø±Õ¼àÌýÆ÷¡£
Ïà¹ØʾÀý£º
D:\>lsnrctl stop eygle
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 28-11ÔÂ-2007 10:02:40
Copyright (c) 1991, 2006, Oracle. All rights reserved.
......
OracleµÄÔÚÏßÖض¨Òå±í¹¦ÄÜ
http://blog.itpub.net/post/468/12855
http://blog.itpub.net/post/468/12962
ÔÚÒ»¸ö¸ß¿ÉÓÃϵͳÖУ¬Èç¹ûÐèÒª¸Ä±äÒ»¸ö±íµÄ¶¨ÒåÊÇÒ»¼þ±È½Ï¼¬ÊÖµÄÎÊÌ⣬ÓÈÆäÊǶÔÓÚ7×24ϵͳ¡£OracleÌṩµÄ»ù±¾Óï·¨»ù±¾¿ÉÒÔÂú×ãÒ»°ãÐÔÐ޸ģ¬µ«ÊǶÔÓÚ°ÑÆÕͨ¶Ñ±í¸ÄΪ·ÖÇø±í£¬°ÑË÷Òý×éÖ¯±íÐÞ¸ÄΪ¶Ñ±íµÈ²Ù×÷¾ÍÎÞ ......