Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

oracle 10 ´´½¨¶à¸öÊý¾Ý¿âµÇ¼¸÷¸öEMµÄ·½·¨

Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾ­Æô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME\product\10. ......

OracleÏÞÖÆIP·ÃÎÊÉèÖÃ

Ò»¡¢$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ÐÔÄÜÌá¸ß ÅúÁ¿°ó¶¨

author:skatetime:2010-05-04
ÔÚÎÒÃǵÄϵͳÀ´ó¼ÒÔÚдpl/sqlʱ£¬´¦Àí¶àÌõ¼Ç¼ʱ£¬¼¸ºõ¶¼ÊÇͨ¹ýÓαêÀ´Íê³ÉµÄ£¬ÕâÑùÊǷdz£Ó°ÏìÐÔÄܵġ£ÎÒÃÇ¿ÉÒÔÓÃÅúÁ¿°ó¶¨¿ÉÒÔ´ó´óµÄ¸ÄÉÆ¡£
 
ÅúÁ¿°ó¶¨ÊÇoracle9iÔö¼ÓµÄÌØÐÔ£¬ÊÇÖ¸Ö´Ðе¥´Îsql²Ù×÷ÄÜ´«µÝËùÓм¯ºÏÔªËØµÄÊý¾Ý¡£Í¨¹ý°ó¶¨°ó¶¨±äÁ¿¿ÉÒÔ¼«´óµÄÌá¸ßÊý¾Ý´¦ÀíËÙ¶È£¬Ìá¸ßÓ¦ÓÃ³Ì ......

Oracle ¿ØÖÆÎļþ


Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECO ......

oracle sql tuning

alert index mem_ct monitoring usage;
desc v$object_usage;
set linesize 190
select * from v$object_usage;
SQL>SET AUTOTRACE ON;
¡¡¡¡*autotrace¹¦ÄÜÖ»ÄÜÔÚSQL*PLUSÀïʹÓÃ
¡¡¡¡ÆäËûһЩʹÓ÷½·¨£º
¡¡¡¡2.2.1¡¢ÔÚSQLPLUSÖеõ½Óï¾ä×ܵÄÖ´ÐÐʱ¼ä
¡¡¡¡SQL> set timing on;
2.2.2¡¢Ö»ÏÔʾִÐмƻ®--(»áÍ¬Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ