28.4.1 ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ
28.4.1 ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ
OracleÊý¾Ý¿â·þÎñÓÉÁ½²¿·Ö×é³É£ºÊý¾Ý¿â½ø³ÌºÍÍøÂç¼àÌýÆ÷½ø³Ì£¬ËüÃÇ·Ö±ð¿Éͨ¹ýsqlplusºÍlsnrctlÃüÁî¿ØÖÆÆô¶¯¹Ø±Õ¡£
1£®Êý¾Ý¿â½ø³Ì
ʹÓÃDBCA¹¤¾ß´´½¨Êý¾Ý¿âºó£¬Æä½ø³ÌÒѾ×Ô¶¯Æô¶¯£¬ÕâЩ½ø³Ì¶¼ÊÇÒÔÊý¾Ý¿âÃû³Æ£¨ÔÚ±¾ÀýÖÐΪorcl£©ÃüÃû£¬ÈçÏÂËùʾ¡£
$ ps -ef|grep orcl
oracle 870 1 0 11:54 ? 00:00:00 ora_pmon_orcl //½ø³Ì¼à¿ØÆ÷½ø³Ì
oracle 872 1 0 11:54 ? 00:00:00 ora_vktm_orcl //ʱÖÓ¸üнø³Ì
oracle 876 1 0 11:54 ? 00:00:00 ora_diag_orcl //Êý¾Ý¿âÕï¶Ï½ø³Ì
oracle 878 1 0 11:54 ? 00:00:00 ora_dbrm_orcl //Êý¾Ý¿â×ÊÔ´¹ÜÀí½ø³Ì
oracle 880 1 0 11:54 ? 00:00:00 ora_psp0_orcl //½ø³Ì²úÉú
oracle 884 1 0 11:54 ? 00:00:03 ora_dia0_orcl //ÁíÒ»¸öÊý¾Ý¿âÕï¶Ï½ø³Ì
oracle 886 1 0 11:54 ? 00:00:00 ora_mman_orcl //Ö´ÐÐÊý¾Ý¿âµÄÄÚ²¿ÈÎÎñ
oracle 888 1 0 11:54 ? 00:00:00 ora_dbw0_orcl //Êý¾Ý¿âд½ø³Ì
oracle 890 1 0 11:54 ? 00:00:01 ora_lgwr_orcl //ÈÕÖ¾½ø³Ì
oracle 892 1 0 11:54 ? 00:00:01 ora_ckpt_orcl //¼ì²éµã½ø³Ì
oracle 894 1 0 11:54 ? 00:00:04 ora_smon_orcl //ϵͳ¼à¿Ø½ø³Ì
oracle 896 1 0 11:54 ? 00:00:00 ora_reco_orcl
oracle 898 1 0 11:54 ? 00:00:05 ora_mmon_orcl //ÊÕ¼¯SQL¶ÔÏóÐÅÏ¢
oracle 900 1 0 11:54 ? 00:00:00 ora_mmnl_orcl //¸ºÔð½«SGAͳ¼ÆÐÅÏ¢Êä³ö //µ½Êý¾Ý¿â
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊ ......
28.2 OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°
Óû§¿ÉÒÔͨ¹ýOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔص½×îеÄOracleÊý¾Ý¿â²úÆ·µÄÈí¼þ°²×°°ü£¬ÔÚ°²×°Oracle 11gÇ°ÐèÒª¼ì²éϵͳµÄÈíÓ²¼þ»·¾³ÊÇ·ñ·ûºÏ°²×°ÒªÇó¡£Oracle 11gÌṩͼÐλ¯µÄ°²×°³ÌÐò½çÃ棬Óû§¿ÉÒÔͨ¹ýµ¥»÷Êó±êÍê³ÉOracleµÄ°²×°¡£ ......
Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â
Àý³Ì£>ÅäÖã>Ò»°ãÐÅÏ¢ÖÐ Æô¶¯ºÍÍ£Ö¹Êý¾Ý
Í£Ö¹Êý¾Ý¿âÓ¦¸ÃÑ¡Ôñ£ºµ±ËùÓÐÊÂÎñ½áÊøʱ¡£
Ò²¿ÉÒÔÓÃÃüÁîÆô¶¯ºÍÍ£Ö¹(ÓÃoracleÓû§µÇ½)
Æô¶¯ £º lsnrctl start //Æô¶¯ lister
sqlplus /nolog <<EO ......
ORACLEÊý¾Ý¿âÓÐÁ½ÖÖÔËÐз½Ê½£ºÒ»Êǹ鵵·½Ê½(ARCHIVELOG)£¬¹éµµ·½Ê½µÄÄ¿µÄÊǵ±Êý¾Ý¿â·¢Éú¹ÊÕÏʱ×î´óÏ޶Ȼָ´ËùÓÐÒÑÌá½»µÄÊÂÎï;¶þÊDz»¹éµµ·½Ê½(NOARCHIVELOG)£¬»Ö¸´Êý¾Ý¿âµ½×î½üµÄ»ØÊյ㡣ÎÒÃǸù¾ÝÊý¾Ý¿âµÄ¸ß¿ÉÓÃÐÔºÍÓû§¿É³ÐÊܶªÊ§µÄ¹¤×÷Á¿µÄ¶àÉÙ£¬°ÑÎÒÃÇÕýʽÔËÐеÄÊý¾Ý¿â²ÉÓÃΪ¹éµµ·½Ê½;ÄÇЩÕýÔÚ¿ª·¢ºÍµ÷ÊÔµÄÊý¾Ý¿â²ÉÓò»¹é ......