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

Oracle RAC ÈÕ³£»ù±¾Î¬»¤ÃüÁî

ÁгöÅäÖõÄËùÓÐÊý¾Ý¿â
[root@node1 ~]# srvctl config database
NOVADB
ËùÓÐʵÀýºÍ·þÎñµÄ״̬
[root@node1 ~]# srvctl status database -d NOVADB
Instance NOVADB1 is running on node node1
Instance NOVADB2 is running on node node2
µ¥¸öʵÀýµÄ״̬
[root@node1 ~]# srvctl status instance -d NOVADB -i NOVADB1
Instance NOVADB1 is running on node node1
ÔÚÊý¾Ý¿âÈ«¾ÖÃüÃû·þÎñµÄ״̬
$ srvctl status service -d orcl -s orcltest
Service orcltest is running on instance(s) orcl2, orcl1
ÌØ¶¨½ÚµãÉϽڵãÓ¦ÓóÌÐòµÄ״̬
[root@node1 ~]# srvctl status nodeapps -n node1
VIP is running on node: node1
GSD is running on node: node1
Listener is running on node: node1
ONS daemon is running on node: node1
ASM ʵÀýµÄ״̬
[root@node1 ~]# srvctl status asm -n node1
ASM instance +ASM1 is running on node node1.
[root@node1 ~]# srvctl status asm -n node2
ASM instance +ASM2 is running on node node2.
ÏÔʾ RAC Êý¾Ý¿âµÄÅäÖÃ
[root@node1 ~]# srvctl config database -d NOVADB
node1 NOVADB1 /opt/ora10g/product/10.2.0/db_1
node2 NOVADB2 /opt/ora10g/product/10.2.0/db_1
ÏÔʾָ¶¨¼¯ÈºÊý¾Ý¿âµÄËùÓзþÎñ
[root@node1 ~]# srvctl config service -d NOVADB
NOVADB PREF: NOVADB1 NOVADB2 AVAIL:
ÏÔʾ½ÚµãÓ¦ÓóÌÐòµÄÅäÖà —£¨VIP¡¢GSD¡¢ONS¡¢¼àÌýÆ÷£©
[root@node1 ~]# srvctl config nodeapps -n node1 -a -g -s -l
VIP exists.: /node1-vip/192.168.150.224/255.255.255.0/eth0
GSD exists.
ONS daemon exists.
Listener exists.
ÀûÓÃsrvctl configÃüÁî¿ÉÒÔ¿´µ½ÏÖÓÐÊý¾Ý¿âµÄÅäÖÃÐÅÏ¢£º
[root@node1 ~]# srvctl config database -d NOVADB -a
node1 NOVADB1 /opt/ora10g/product/10.2.0/db_1
node2 NOVADB2 /opt/ora10g/product/10.2.0/db_1
DB_NAME: NOVADB
ORACLE_HOME: /opt/ora10g/product/10.2.0/db_1
SPFILE: +RAC_DISK/NOVADB/spfileNOVADB.ora
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY: AUTOMATIC
ENABLE FLAG: DB ENABLED
ÏÔʾ ASM ʵÀýµÄÅäÖÃ
[root@node1 ~]# srvctl config asm -n node1
+ASM1 /opt/ora10g/product/10.2.0/db_1
[root@node1 ~]# srvctl config asm -n node2
+ASM2 /opt/ora10g/product/10.2.0/db_1
¼¯ÈºÖÐËùÓÐÕý


Ïà¹ØÎĵµ£º

OracleÈ«¾ÖÊý¾Ý¿âÃû¡¢»·¾³±äÁ¿ºÍsidµÄÇø±ð


http://www.haoxiai.net/shujuku/Oracle/111145.html
Ò»¡¢Êý¾Ý¿âÃû
ʲôÊÇÊý¾Ý¿âÃû
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²ÎÊýDB_NAME±»Ð´Èë²ÎÊýÎļþÖ®ÖС£¸ñʽÈçÏ£º
DB_NAME=m ......

OracleѹËõ±í±í¿Õ¼ä

´ÓOracle 9iR2 ¿ªÊ¼,ORACLEÌṩÁ˱í/±í¿Õ¼äѹËõ¼¼Êõ,ÒÔ¼õÉÙ´ÅÅÌ¿ªÏú,½ÚÊ¡¿Õ¼ä,²¢ÔÚijЩÇé¿öÏÂÌá¸ß²éѯÐÔÄÜ¡£
 
±íѹËõÊÇÈçºÎ¹¤×÷µÄ
ÔÚOrcle9iµÚ2°æÖУ¬±íѹËõÌØÐÔͨ¹ýɾ³ýÔÚÊý¾Ý¿â±íÖз¢ÏÖµÄÖØ¸´Êý¾ÝÖµÀ´½ÚÊ¡¿Õ¼ä¡£Ñ¹ËõÊÇÔÚÊý¾Ý¿âµÄÊý¾Ý¿é¼¶±ðÉϽøÐеġ£µ±È·¶¨Ò»¸ö±íÒª±»Ñ¹Ëõºó£¬Êý¾Ý¿â±ãÔÚÿһ¸öÊý¾Ý¿âÊý¾Ý¿éÖб£ ......

oracle ³£Óú¯Êý

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ× ......

JMS+Oracle Advanced Queue(AQ)Ó÷¨Êµ¼ù

×÷Õß:Ñî´óÓÑ,Óà´¨ ²âÊÔÔ±:Íõ½¡
 
¿ª·¢¹¤¾ß:Oracle Jdeveloper 10131
ÈíÓ²¼þ»·¾³:
²Ù×÷ϵͳlinux redhat 3.0 Êý¾Ý¿âΪOracle 10G 10.0.2
Ó¦Ó÷þÎñÆ÷ΪSOA Application Server 10131
¿ª·¢ÓïÑÔ:java
¹ØÓÚÌåϵ½á¹¹,˵¶àÁËÒ²ÈÃÈ˾õµÃÔÎ.ÎÒÖ±½ÓʾÀýÒ»¸ö×ö·¨,ÖÁÓÚÀí½â,¾ÍÂýÂý¿´Êé°É!
²½Öè:
1.   
´´ ......

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


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