Oracle°²×°ÖеÄDHCPÎÊÌâ
¹Ø¼ü×Ö: oracle
Oracle°²×°ÖеÄDHCPÎÊÌâ
1.Linux
ÐÞ¸ÄhostsÎļþ ½«ipµØÖ·ÓëlocalhostÉ趨¾Í¿ÉÒÔÁË£¬ÈçÏÂ
vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.193.129 www.myzhtc.com
192.168.193.129 localhost myzhtc.com
127.0.0.1 localhost
Ó¢ÎÄÌáʾÈçÏ£º
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Not executed <<<<
Recommendation: Oracle supports installations on systems with DHCP-assigned public IP addresses. However, the primary network interface on the system should be configured with a static IP address in order for the Oracle Software to function properly. See the Installation Guide for more details on installing the software on systems configured with DHCP.
ÖÐÎÄÌáʾÈçÏ£º
ÕýÔÚ¼ì²éÍøÂçÅäÖÃÐèÇó...
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: δִÐÐ <<<<
½¨Òé°¸: Oracle Ö§³ÖÔÚ¾ßÓÐ DHCP ·ÖÅäµÄ¹«¹² IP µØÖ·µÄϵͳÉϽøÐа²×°¡£µ«Ó¦Ê¹Óþ²Ì¬ IP µØÖ·À´ÅäÖÃϵͳµÄÖ÷ÍøÂç½Ó¿Ú, ÒÔ±ã Oracle Èí¼þÕý³£¹¤×÷¡£ÓйØÔÚÅäÖÃÓÐ DHCP µÄϵͳÉϰ²×°Èí¼þµÄÏêϸÐÅÏ¢, Çë²ÎÔÄ Installation Guide¡£
Õâ¸öDHCPµÄÎÊÌ⣬ҲÐíÒòΪ½â¾ö°ì·¨Ì«¼òµ¥£¬ËùÒÔûÈËд×ÊÁÏ£¬OracleµÄ°²×°ÊÖ²áÉÏÒ²ÇáÃèµÐ´£¬ÈÃÈË¿´ÁËһͷÎíË®£¬Ã»ÈËд×ÊÁÏÍøÉϾͲ鲻µ½£¬ÕâÑù²»ÖªµÀµÄÒ²¾ÍºÜÄÑÔÙÖªµÀ£¬ÔÙ¼ÓÉÏÏñÎÒÕâÑùÔÙ±¿µãµÄÈË£¬ÓпÉÄÜ»¨µô´ó°ÑµÄʱ¼ä¶øÎÞ¹¦¶ø·µ£¬ÕâÊǸö¶ñÐÔÑ»·£¬ÈÃÎÒÀ´½áÊøËü¡£
2.Windows
´íÎóÌáʾÈçÏ£º
¡¡¡¡Oracle Ö§³ÖÔÚ¾ßÓÐ DHCP ·ÖÅäµÄ IP µØÖ·µÄϵͳÉϽøÐа²×°2009-7-23 10:35¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: δִÐÐ <<<<
¡¡¡¡½¨Òé°¸: Oracle Ö§³ÖÔÚ¾ßÓÐ DHCP ·ÖÅäµÄ IP µØÖ·µÄϵͳÉϽøÐа²×°¡£µ«ÔÚ°²×°Ö®Ç°, ±ØÐ뽫 Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷¡£ÓйØÔÚÅäÖÃÓÐ DHCP µÄϵͳÉϰ²×°Èí¼þµÄÏêϸÐÅÏ¢, Çë²ÎÔÄ Installation Guide¡£
¡¡¡¡
¡¡¡¡½â¾ö°ì·¨£º
¡¡¡¡
¡¡¡¡¿ØÖÆÃæ°å -> Ìí¼ÓÓ²¼þ£¬ÔÚÏòµ¼ÖÐÑ¡Ôñ“ÊÇ£¬ÒѾÁ¬½ÓÁË´ËÓ²¼þ” -> “Ìí¼ÓеÄÓ²¼þÉ豸” -> “°²×°ÎÒÊÖ¶¯´ÓÁбíÖÐÑ¡ÔñµÄÓ²¼þ” -> &l
Ïà¹ØÎĵµ£º
author:skate
time:2009/10/23
ÕâÁ½ÌìÒ»ÅóÓÑÎÊÈçºÎ¸ü¸ÄÊý¾Ý¿âÃû£¬ÓÚÊÇ×ö¸ö²âÊÔ£¬¼òµ¥¼Ç¼Ï£¬ÒÔ±ã˵Ã÷ÎÊÌâ
ÈçºÎÐÞ¸ÄÊý¾Ý¿âÃû£¨db_name)¼°ÊµÀýÃû(Instance_name or Service_name)
NidÊÇOracle´Ó9iR2¿ªÊ¼ÌṩµÄ¹¤¾ß£¬¿ÉÒÔÓÃÀ´¸ü¸ÄÊý¾Ý¿âÃû³Æ£¬¶øÎÞÐèͨ¹ýÖ®Ç°ÖØ½¨¿ØÖÆÎļþµÈ·±Ëö·½Ê½¡£
nidÊÇ×Ô´øµÄ¹¤¾ß£¬ÔÚoracle_home/b ......
oracleÖв鿴Óû§È¨ÏÞ
1.²é¿´ËùÓÐÓû§£º
select * from dba_users;
select * from all_users;
select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ(Ö±½Ó¸³Öµ¸øÓû§»ò½ÇÉ«µÄϵͳȨÏÞ)£º
select * from dba_sys_privs;
select * from user_sys_privs;
3.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óà ......
1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ôʼ·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾¹ýÎļþϵͳµÄ»º³å¡£
¡¡¡¡
¡¡¡¡2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡× ......