28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔÀ´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄܵļì²éÓëµ÷Óŵȡ£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊ ......
1) Instance in RESTRICTED SESSIONS mode?
¡¡¡¡Check if the instance is in restricted sessions mode:
¡¡¡¡select instance_name,logins from v$instance;
¡¡¡¡If logins=RESTRICTED, then:
¡¡¡¡alter system disable restricted session;
¡¡¡¡^-- Checked!
¡¡¡¡2) JOB_QUEUE_PROCESSES=0
¡¡¡¡Make sure th ......
28.2.4 °²×°Oracle 11g
Oracle 11gÌṩÁËͼÐλ¯µÄ°²×°½çÃæ£¬Óû§¿Éͨ¹ýÒÆ¶¯ºÍµ¥»÷Êó±êÍê³É°²×°¹ý³Ì¡£¾ßÌå°²×°²½ÖèÈçÏÂËùʾ¡£
£¨1£©½âѹOracle 11g°²×°°üÎļþ¡£
unzip linux_11gR1_database_1013.zip
Îļþ½«»á±»½âѹµ½linux_11gR1_database_1013Ŀ¼Ï£¬ÈçÏÂËùʾ¡£
# ls
doc inst ......
×î½ü½Ó´¥OracleµÄ¶«Î÷£¬¸Õ¸Õ¿ªÊ¼Ñ§Ï°²¢Í¬Ê±×öµã¶«Î÷£¬×î½üÀÏÊÇʹÓô洢¹ý³Ì¡£ÏÖÔÚͨ¹ýÎÒ¸öÈ˵ÄʹÓüòµ¥ËµÏÂ×Ô¼ºµÄ¸ÐÊÜ£¡
ÔÚÉè¼Æ´æ´¢¹ý³ÌÖУ¬Ò»±¾Í¨¹ý¶þ¸ö·½Ê½ÊµÏÖ£º
1£º¾ÍÊǼòµ¥µÄʵÏÖÓαê
---¹ý³ÌµÄÉùÃ÷---
......