11gµÄOracle Grid Infrastructure
2010Äê05ÔÂ2ºÅ |
23:59·ÖÀࣺLinux&Unix
, ¹ÜÀíά»¤
| ±à¼
| ±êÇ©£º11g
¡¢grid
±¾Îijö×Ô “inthirties£¨ÄÐ
ÈËÈýÊ®£©
”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦¡£
11gÀï³öÏÖÁËÒ»¸öнÇÉ«¡£
Oracle Grid Infrastructure
http://download.oracle.com/docs/cd/E11882_01/install.112/e10840/oraclerestart.htm#LADBI999
The Oracle grid infrastructure for a standalone server is the Oracle
software that provides system support for an Oracle database including
volume management, file system, and automatic restart capabilities. If
you plan to use Oracle Restart or Automatic Storage Management, you must
install the grid infrastructure before installing your database. The
grid infrastructure for a standalone server is the software that
includes Oracle Restart and Automatic Storage Management. Oracle
combined the two infrastructure products into a single set of binaries
that is installed as the grid infrastructure home. The grid
infrastructure should be installed before installing Oracle Database 11g
Release 2.
Automatic Storage Management is a volume manager and a file system
for Oracle database files that supports single-instance Oracle Database
and Oracle Real Application Clusters (Oracle RAC) configurations.
Automatic Storage Management also supports a general purpose file system
for your application needs including Oracle Database binaries.
Automatic Storage Management is Oracle’s recommended storage management
solution that provides an alternative to conventional volume managers,
file systems, and raw devices.
Oracle Restart improves the availability of your Oracle database by
providing the following:
When there is a hardware or a software failure, Oracle Restart
automatically starts all Oracle components, including Oracle database
instance, Oracle Net Listener, database services, and Automatic Storage
Management.
Oracle Restart starts up components in the pro
Ïà¹ØÎĵµ£º
ͨ¹ýJDBC£¬ÎÒÃÇ¿ÉÒÔÏòoracle²åÈë´ó¶ÔÏó£¬ÈçͼƬ£¬ÒôƵ£¬³¤Îı¾µÈ£¬Æä²åÈë·½·¨Óкܶ࣬ÕâÀïÑÝʾһÏÂͨ¹ýÁ÷¸üиüеÄÐÎʽ²åÈëCLOB´ó¶ÔÏó¡£
ÕâÊÇÒ»¸ö´æ´¢Îı¾µÄÀý×Ó£¬½âÊÍÎÒ»áÔÚ³ÌÐòÖÐÒÔ×¢Ê͵ÄÐÎʽд³ö
/**
* ½«Éú³ÉµÄ±íÑù´æ´¢µ½Êý¾Ý¿â
*
* @param htmlParam
* @return
*/
  ......
Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......
oracle ÔõôÀ´±éÀúÒ»¸öÊ÷£¬Ïà±È½ÏÆäËû·½·¨£¬oracleµÄconnectÓï·¨¸üÄܱܺãÀûµÄ½â¾öÎÊÌâ¡£
Óï·¨¸ñʽ£º
select ...
from ...
start with...
connect by prior expr=expr
order siblings by ..
start with µÄ¹¦ÄÜÀàËÆÓÚwhere£¬Ö¸Ã÷´ÓÄĸö·ÖÖ§¿ªÊ¼±ãÀû£»
connect by Ö¸Ã÷¸¸½ÚµãºÍ×Ó½ÚµãµØÁ¬½Ó·½Ê½£¬¹Ø¼ü×Öprior·ÅÔÚ¸¸½Ú ......
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ38 ¹ØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄÄÚÈݰ²ÅÅ Õâ¶Îʱ¼äÓÉÓÚһֱæÓÚÏîÄ¿£¬Ò²¾ÍÊèÓÚÔÚÈÕÖ¾ÉϺͶÁÕߵĻ¥¶¯£¬Òò´ËÓÖ»ýÔÜÏÂÈô¸É¶ÁÕßÀ´ÐÅδ»Ø£¬ÊµÔÚ±§Ç¸¡£ÆäÖÐÓм¸·âÊǹØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄ£¬ÒªÇóÎÒ¶ÔÅàѵÄÚÈݸøÓë½âÊͺÍ˵Ã÷¡£ÕâÀïÎÒ×öͳһ˵ ......
ÔÚÊý¾Ý¿âµÄÈÕ³£Ñ§Ï°ÖУ¬·¢ÏÖ¹«Ë¾Éú²úÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ätempʹÓÃÇé¿ö´ïµ½ÁË30G£¬Ê¹ÓÃÂÊ´ïµ½ÁË100%£»´ýµ÷ÕûΪ32Gºó£¬Ê¹ÓÃÂÊ»¹ÊÇΪ100%£¬µ¼Ö´ÅÅ̿ռäʹÓýôÕÅ¡£¸ù¾ÝÁÙʱ±í¿Õ¼äµÄÖ÷ÒªÊǶÔÁÙʱÊý¾Ý½øÐÐÅÅÐòºÍ»º´æÁÙʱÊý¾ÝµÈÌØÐÔ£¬´ýÖØÆôÊý¾Ý¿âºó£¬temp»á×Ô¶¯ÊÍ·Å¡£ÓÚÊÇÏëͨ¹ýÖØÆôÊý¾Ý¿âµÄ·½Ê½À´»º½âÕâÖÖÇé¿ö£¬µ«ÊÇÖØÆôÊý¾Ý ......