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

Oracle 10G R2 RAC ÈÕ³£¹ÜÀí

Ò»¡¢Ê¹ÓÃsrvctl¹ÜÀíRACÊý¾Ý¿â
[root@NODE01 bin]# pwd
/orac/crs/bin   # srvctlÔÚ$CRS_HOME/binĿ¼Ï£¬Ëü¿ÉÒÔÔÚÈκνڵãÉÏά»¤¡£
[root@NODE01 bin]# ./srvctl
Usage: srvctl <command> <object> [<options>]
    command: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
    objects: database|instance|service|nodeapps|asm|listener
For detailed help on each command and object and its options use:
    srvctl <command> <object> -h
³£ÓõÄÃüÁîÖ÷ÒªÈçÏÂ:
 
1¡¢Ê¹ÓÃsrvctl statusÃüÁî
²é¿´Êý¾Ý¿âµÄ״̬£º
[root@NODE01 bin]# ./srvctl status database -d racdb
Instance RACDB1 is running on node node01
Instance RACDB2 is running on node node02
²é¿´Êý¾Ý¿âʵÀýµÄ״̬£º
[root@NODE01 bin]# ./srvctl status instance -d racdb -i racdb1,racdb2
Instance racdb1 is running on node node01
Instance racdb2 is running on node node02
²é¿´ASMʵÀýµÄ״̬£º
[root@NODE01 bin]# ./srvctl status asm -n node01
ASM instance +ASM1 is running on node node01.
[root@NODE01 bin]# ./srvctl status asm -n node02
ASM instance +ASM2 is running on node node02.
²é¿´½ÚµãÓ¦ÓóÌÐò£¨VIP¡¢GSD¡¢Listener¡¢ONS£©µÄ״̬£º
[root@NODE01 bin]# ./srvctl status nodeapps -n node01
VIP is running on node: node01
GSD is running on node: node01
Listener is running on node: node01
ONS daemon is running on node: node01
[root@NODE01 bin]#
[root@NODE01 bin]# ./srvctl status nodeapps -n node02
VIP is running on node: node02
GSD is running on node: node02
Listener is running on node: node02
ONS daemon is running on node: node02
ÒÔÉϵÄÃüÁîÔÚÈκνڵãÉ϶¼¿ÉÒÔÖ´ÐС£ÆäÖÐ-d±íʾÊý¾Ý¿âµÄÃû×Ö£¬-i±íʾinstanceÃû³Æ£¬-n±íʾ½ÚµãµÄÖ÷»úÃû¡£
 
2¡¢Ê¹ÓÃsrvctl start/stopÃüÁî
srvctl start asm –n node01               # to start the ASM instance
srvctl stop asm –n node01         &nb


Ïà¹ØÎĵµ£º

OracleÈ«ÎÄË÷ÒýÉèÖò½Öè

ÒÑÓм¸¸öÏîÄ¿×鿪ʼʹÓÃoracleµÄÈ«ÎÄË÷Òý¡£OracleµÄ´Ê·¨·ÖÎöÆ÷Õë¶ÔZHS16GBK×Ö·û¼¯µÄ´Ê·¨·ÖÎöÉв»¹»ÖÇÄÜ£¬Ö»ÄÜ»úеµØÒÔ×ÖΪµ¥Ôª
½øÐÐÆ¥Åä¡£¶ÔÓÚutf8×Ö·û¼¯µÄÊý¾Ý¿âÓÐÒ»¸öеĺºÓï·ÖÎöÆ÷chinese_lexer£¬Ð§ÂÊÓÐÁ˺ܴó¸ÄÉÆ¡£ÏÖ½«ÑéÖ¤²¢ÕûÀí¹ýµÄÈçºÎ½øÐÐoracleÈ«ÎÄ
Ë÷ÒýÉèÖõÄÎĵµ·¢¸ø´ó¼Ò£¬ÊÊÓÃÓÚ8i¡¢9i¸÷ƽ̨°æ±¾¡£
¡¡¡¡¶ÔÓ ......

oracle ³õ²½Ñ§Ï°±Ê¼Ç


Ò»:oracle°æ±¾½éÉÜ:
oracle8
oracle8i ±íʾ´Ëʱoracle¹«Ë¾½ø¾ü»¥ÁªÍø,i´ú±íInternet
oracle9iºÍoracle8iÀàËÆ
oracle10g°üÀ¨ÏÖÔÚµÄ11gʹÓÃÁËÍø¸ñ¼ÆËã,g´ú±ígrid.
 
¶þ:oracle10g·þÎñ½éÉÜ:
OracleDBConsoleorcl Õâ¸öÊDzÉÓÃä¯ÀÀÆ÷ʹÓõÄoracleÆóÒµ¹ÜÀíÆ÷ (Ò²¾ÍÊÇÄã°²×°µ¯³öµÄÄǸöÍøÒ³)
OracleOraDb10g_home1iSQ ......

oracle ÈÕÆÚº¯Êý

sqlÓï¾äÈçÏÂ:
select * from userdb40.numservice  where ServiceNumber =88880068
 and applytime <= to_date('2009-12-26 10:41:44','yyyy-MM-dd HH24:mi:ss')
select to_date('2007-06-28 19:51:20.0','yyyy-MM-dd HH24:mi:ss') from dual; ......

ORACLEÈ«±¸·ÝºÍ0¼¶ÔöÁ¿±¸·ÝµÄÇø±ð

±È½Ï¹Ù·½µÄ˵·¨
Full
A backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. It can also be stored in a backup set, in which case datafile blocks not in use may be skipped, ......

½ñÌì×°ORACLE µÄµãµãµÎµÎ£¡

ËäÈ»ÒÔǰÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql  µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
  1. Oracle 10g windows ƽ̨ϰ²×°
¡¡¡¡ÏÂÔØµØÖ·£º  http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ