OracleÓû§¡¢½ÇÉ«¡¢È¨ÏÞºÍϵͳ×ÊÔ´¹ÜÀí³£ÓòÙ×÷
²éѯÓû§ÐÅÏ¢
SELECT USERNAME,DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, PROFILE, ACCOUNT_STATUS, CREATED from dba_users; ²éѯÓû§¿Õ¼äʹÓúÍÉÏÏÞÇé¿ö
SELECT username, tablespace_name, bytes/1024/1024 space_used_in_mb, max_bytes/1024/1024 max_space_in_mb from dba_ts_quotas; ´´½¨Óû§
CREATE USER Óû§Ãû IDENTIFIED BY ¿ÚÁî DEFAULT TABLESPACE ±í¿Õ¼äÃû TEMPORARY TABLESPACE ±í¿Õ¼äÃû QUOTA {ÕýÕûÊý[K|M] | UNLIMITED} ON ±í¿Õ¼äÃû PASSWORD EXPIRE PROFILE ¸ÅÒªÎļþÃû ¸Ä±äÓû§±í¿Õ¼äÅä¶î
ALTER USER Óû§Ãû QUOTA 38M ON ±í¿Õ¼äÃû; ɾ³ýÓû§. É÷ÓÃ,Óû§Ïà¹Ø¶ÔÏóÒ²½«Ïûʧ.
DROP USER Óû§Ãû [CASCADE]; Ëø¶¨ºÍ½âËøÓû§
ALTER USER ̞ ACCOUNT UNLOCK|LOCK;
ÆôÓÃ×ÊÔ´ÏÞÖÆ.·ñÔò¸ÅÒªÎļþÖеĶ¨Òå²»Æð×÷ÓÃ.
a.)Ð޸IJÎÊýÎļþ, RESOURCE_LIMIT = TRUE
b.)ʹÓÃÃüÁî, ALTER SYSTEM SET RESOURCE_LIMIT = TRUE; ²éѯ¸ÅÒªÎļþÇé¿ö. RESOURCE_TYPEΪKERNELʱ¼´ÊÇ×ÊÔ´ÏÞÖÆ.PASSWORDΪ¿ÚÁȫÏÞÖÆ.
SELECT * from dba_profiles; ´´½¨×ÊÔ´ÏÞÖƵĸÅÒªÎļþ. ×î´óÖµ¿ÉΪÕýÕûÊý,UNLIMITED»òDEFAULT.
CREATE PROFILE ¸ÅÒªÎļþÃû LIMIT
[SESSIONS_PER_USER ×î´óÖµ]
[CPU_PER_SESSION ×î´óÖµ] --×ܹ²µÄCPUʹÓÃʱ¼ä.µ¥Î»ÊÇ°Ù·ÖÖ®Ò»Ãë
[CONNECT_TIME ×î´óÖµ] --Á¬½Óʱ¼ä,µ¥Î»ÊÇ·ÖÖÓ
[IDLE_TIME ×î´óÖµ] --·þÎñÆ÷¶Ë½ø³ÌµÄÏÞÖÆʱ¼ä,µ¥Î»ÊÇ·ÖÖÓ
[LOGICAL_READS_PER_SESSION ×î´óÖµ] --´ÅÅ̺ÍÄÚ´æ×î´ó¶ÁÈ¡Êý¾Ý¿éÊý
[CPU_PER_CALL ×î´óÖµ]
[LOGICAL_READS_PER_CALL ×î´óÖµ] ´´½¨¿ÚÁîÏÞÖƵĸÅÒªÎļþ.¿ÉÒÔÓë×ÊÔ´ÏÞÖÆΪͬһ¸ÅÒªÎļþ.ÆäÖÐPASSWORD_REUSE_MAXºÍPASSWORD_REUSE_TIME
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò»¡¢×¼±¸¹¤×÷
1.1 ÉèÖÃÖ÷¿âµÄforce loggingģʽ
SQL> alter database force logging;
Database altered.
1.2 ´´½¨Ö÷¿âÃÜÂëÎļþ
$ orapwd file=orapw$ORACLE_SID password=thunis entries=4
1.3 ÅäÖÃÖ÷¿âstandby redo log£¬²¢ÑéÖ¤½á¹û
SQL> alter database add standby logfile group 4('/u01/app/oradata/guar ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Ò»¡¢ÔÚUnixÏ´´½¨Êý¾Ý¿â
1.È·¶¨Êý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû
¹ØÓÚÊý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû£¬ÎÒ֮ǰÓÐרÃÅÓÃһƪÀ´Ïêϸ½éÉÜ¡£ÕâÀï¾Í²»ÔÙ˵Ã÷ÁË¡£
2.´´½¨²ÎÊýÎļþ
²ÎÊýÎļþºÜÈ·¶¨ÁËÊý¾Ý¿âµÄ×ÜÌå½á¹¹¡£Oracle10gÓÐÁ½ÖÖ²ÎÊýÎļþ£¬Ò»¸öÊÇÎı¾²ÎÊýÎļþ£¬Ò»ÖÖÊÇ·þÎñÆ÷²ÎÊýÎļþ¡£ÔÚ´´½¨Ê ......
ORACLE 10GÔÚLINUXµÄ°²×°:
ÏÈÉÏÀ´Á½ÕÅͼ:
DBAÊÇŬÁ¦µÄ·½Ïò,ORACLE DBA°üÂÞÍòÏó,Á¬LINUX/UNIX¶¼¸ã²»¶¨,»¹ÅªP¸öORACLE°¡.
Á½²¿·Ö:
1.RED HAT ENTERPRISE LINUX 5µÄ°²×°
Äѵã(¶ÔÓÚÏÖÔÚµÄÎÒÀ´Ëµ):1.1YUM±¾µØÔ´µÄÅäÖÃ;ÍøÂçÓÐÏà¹Ø×ÊÁÏ,²»¶à˵ÁË.ÓÉÓÚÊDZ¾»úʹÓÃ,²Î¿¼ÁËFTPÔ´ºó,ÎÒʹÓÃÁËFILEÔ´;
&nb ......