OracleÓû§¹ÜÀí³£ÓòÙ×÷
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£
1.
SQL>Create
profile
ÎļþÃû limit
2.
FAILED_LOGIN_ATTEMPTS
£ºÖ¸¶¨Ëø¶¨Óû§µÄµÇ¼ʧ°Ü´ÎÊý
3.
PASSWORD_LOCK_TIME
£ºÖ¸¶¨Óû§±»Ëø¶¨ÌìÊý
4.
PASSWORD_LIFE_TIME
£ºÖ¸¶¨¿ÚÁî¿ÉÓÃÌìÊý
5.
PASSWORD_REUSE_TIME
£ºÖ¸¶¨Ôڶ೤ʱ¼äÄÚ¿ÚÁî²»ÄÜÖØÓÃ
6.
PASSWORD_REUSE_MAX
£ºÖ¸¶¨ÔÚÖØÓÿÚÁîǰ¿ÚÁîÐèÒª¸Ä±äµÄ´ÎÊý
7.
SESSIONS_PER_USER
£ºÏÞÖÆÓû§²¢·¢»á»°¸öÊý
8.
CPU_PER_SESSION
£ºÏÞÖÆ»á»°ËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩
9.
CPU_PER_CALL
£ºÏÞÖÆÃ¿´Îµ÷ÓÃËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩
10.
CONNECT_TIME
£ºÏÞÖÆ»á»°µÄ×ܼÆÁ¬½Óʱ¼ä£¨·ÖÖÓ£©
11.
IDLE_TIME
£ºÏÞÖÆ»á»°µÄ¿ÕÏÐʱ¼ä£¨·ÖÖÓ£©);
Oracle
Óû§¹ÜÀíÖ®¶þ¡¢´´½¨Óû§£¨°üÀ¨´´½¨½ÇÉ«£©:
1.
SQL>Create
user
Óû§Ãû
2.
IDENTIFIED BY
¿ÚÁî
3.
Default
tablespace &nb
Ïà¹ØÎĵµ£º
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to&nb ......
ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
£¨1£© varchar2(n):¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®£¬ÆäÖÐ n ÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ 32767 ×Ö½Ú¡£µ±Ê¹ÓøÃÊý¾ÝÀàÐͶ¨Òå±äÁ¿ÊÇ£¬±ØÐë×¢Ò⣬ÔÚPL/SQL¿éÖÐʹÓøÃÊý¾ÝÀàÐͲÙ×Ývarchar2±íÁÐʱ£¬ÆäÊýÖµµÄ³¤¶È²»Ó¦¸Ã³¬¹ý 4000 ×Ö½Ú¡£
......
1. ¼ì²éOracleµÄ½ø³Ì
$ ps -ef|grep "ora_"|grep -v grep
oracle 5998 1 0 11:15:59 ? 0:01 ora_j000_PPRD10
oracle 2968 1  ......