Oracle DBAÖ°Ôð¼°ÈÕ³£¹¤×÷·ÖÎö
DBA Ö°Ôð¼°ÈÕ³£¹¤×÷Ö°Ôð:
1.°²×°ºÍÉý¼¶Êý¾Ý¿â·þÎñÆ÷,ÒÔ¼°Ó¦ÓóÌÐò¹¤¾ß¹¹½¨ºÍÅäÖÃÍøÂç»·¾³.
2.ÊìϤÊý¾Ý¿âϵͳµÄ´æ´¢½á¹¹Ô¤²âδÀ´µÄ´æ´¢ÐèÇó,Öƶ©Êý¾Ý¿âµÄ´æ´¢·½°¸.
3.¸ù¾Ý¿ª·¢ÈËÔ±Éè¼ÆµÄÓ¦ÓÃϵͳÐèÇó´´½¨Êý¾Ý¿â´æ´¢½á¹¹.
4.¸ù¾Ý¿ª·¢ÈËÔ±Éè¼ÆµÄÓ¦ÓÃϵͳÐèÇó´´½¨Êý¾Ý¿â¶ÔÏó
5.¸ù¾Ý¿ª·¢ÈËÔ±µÄ·´À¡ÐÅÏ¢,ÔÚ±ØÒªµÄʱºòÐÞ¸ÄÊý¾Ý¿âµÄ½á¹¹
6.¹ÜÀíÊý¾Ý¿âµÄÓû§Î¬»¤Êý¾Ý¿âµÄ°²È«ÐÔ
7.¿ØÖƺͼà¿ØÓû§¶ÔÊý¾Ý¿âµÄ´æÈ¡·ÃÎÊ
8.¼à¿ØºÍÓÅ»¯Êý¾Ý¿âµÄÐÔÄÜ
9.Öƶ¨Êý¾Ý¿â±¸·Ý¼Æ»®,ÔÖÄѳöÏÖʱ¶ÔÊý¾Ý¿âÐÅÏ¢½øÐлָ´
10.±¸·ÝºÍ»Ö¸´Êý¾Ý¿â
11.ÁªÏµÊý¾Ý¿âϵͳÉú²ú³§ÉÌ,¸ú×Ù¼¼ÊõÐÅÏ¢
12.½â¾ö¿Í»§¶ËÖмä²ãºÍ·þÎñÆ÷µÄÁ´½ÓÎÊÌâ
13.±£Ö¤°²È«Á¬½Ó
ÿÈÕ¹¤×÷:
1 È·±£·þÎñÆ÷¹¤×÷״̬Õý³£,¸÷ÀàÊý¾Ý¿â״̬Õý³£
2 ¼ì²éÓ²ÅÌ¿Õ¼äÊÇ·ñ¹»ÓÃ
3 ²é¿´Êý¾Ý¿âÈÕÖ¾,²é¿´¸ú×ÙÎļþ,¼ì²éÊÇ·ñÓдíÎóÐÅÏ¢
4 ¼ì²é±¸·ÝµÄÓÐЧÐÔ
5 ͨ¹ýϵͳµÄÐÔÄܼàÊÓÆ÷¶Ô·þÎñÆ÷µÄÐÔÄܲÎÊý¼à¿Ø·¢ÏÖÊý¾Ý¿âµÄÐÔÄÜÊÇ·ñϽµ,Ñ°ÕÒÔÒò²¢½â¾ö
6 ÌîдdbaÈÕÖ¾
ÿÖܹ¤×÷:
1 ¼à¿ØÊý¾Ý¿â¶ÔÏóµÄ¿Õ¼äÀ©Õ¹Çé¿ö
2 ¾ö¶¨ÊÇ·ñµ÷Õû´æ´¢²ÎÊý
3 ¶Ôϵͳ½¡¿µ¼ì²é
4 ¼ì²éɾ³ýûÓÐÈκÎÒâÒåµÄÊý¾Ý¶ÔÏó
5 ¼ì²éɾ³ýûÓÐÒâÒåµÄÔ¼ÊøºÍ´¥·¢Æ÷
6 ¶ÔÿÖܵı¸·Ý¼ì²é´¦Àí
ÿÔ¹¤×÷:
1 ¸ù¾ÝÉÏÃæµÄ¼ì²éÇé¿ö,·ÖÎöÊý¾Ý¿âÖÐÊÇ·ñÓÐÓ°ÏìÐÔÄܵĴ洢ËéƬ´æÔÚ
2 ¸ù¾ÝÊý¾Ý¿âÐÔÄܵÄÀúÊ·Êý¾Ý,¾ö¶¨ÈçºÎÓÅ»¯ÐÔÄÜ
3 ´¦ÀíÿÈÕÿÖÜÿÔµı¸·Ý
4 ×ܽṤ×÷,Ìá³öÏÂÒ»²½µÄ¹ÜÀí¼Æ»®
Oracle DBAÈÕ³£¹¤×÷×ܽá
Oracle¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔOracleÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£º
1¡¢Ã¿Ìì¶ÔOracleÊý¾Ý¿âµÄÔËÐÐ״̬¡¢ÈÕÖ¾Îļþ¡¢±¸·ÝÇé¿ö¡¢Êý¾Ý¿â¿Õ¼äʹÓÃÇé¿ö¡¢ÏµÍ³×ÊԴʹÓÃÇé¿ö½øÐмì²é£¬·¢ÏÖ²¢½â¾öÎÊÌâ¡£
2¡¢Ã¿Öܶ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕßÆäËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀÏ°åÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚÏ°àµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁË°¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......
ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......
£¨1£© varchar2(n):¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®£¬ÆäÖÐ n ÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ 32767 ×Ö½Ú¡£µ±Ê¹ÓøÃÊý¾ÝÀàÐͶ¨Òå±äÁ¿ÊÇ£¬±ØÐë×¢Ò⣬ÔÚPL/SQL¿éÖÐʹÓøÃÊý¾ÝÀàÐͲÙ×Ývarchar2±íÁÐʱ£¬ÆäÊýÖµµÄ³¤¶È²»Ó¦¸Ã³¬¹ý 4000 ×Ö½Ú¡£
......
package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.p ......