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

Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ

OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе½ÁËSQL*PlusÖУ¬Ò²¾ÍÊÇ˵´Ó8iÒÔºó¶ÔÓÚÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ¿ÉÒÔÖ±½Óͨ¹ýSQL*PlusÀ´Íê³É£¬¶ø²»ÔÙÁíÍâÐèÒªServer Manager£¬µ«ÏµÍ³ÎªÁ˱£³ÖÏòϼæÈÝ£¬ÒÀ¾É±£ÁôÁËServer Manager¹¤¾ß¡£ÁíÍâÒ²¿Éͨ¹ýͼÐÎÓû§¹¤¾ß£¨GUI£©µÄOracle Enterprise ManagerÀ´Íê³ÉϵͳµÄÆô¶¯ºÍ¹Ø±Õ£¬Í¼ÐÎÓû§½çÃæInstance Manager·Ç³£¼òµ¥£¬ÕâÀï²»ÔÙÏêÊö¡£
¡¡¡¡ÒªÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬±ØÐëÒªÒÔ¾ßÓÐOracle ¹ÜÀíԱȨÏÞµÄÓû§µÇ½£¬Í¨³£Ò²¾ÍÊÇÒÔ¾ßÓÐSYSDBAȨÏÞµÄÓû§µÇ½¡£Ò»°ãÎÒÃdz£ÓÃINTERNALÓû§À´Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¨INTERNALÓû§Êµ¼ÊÉÏÊÇSYSÓû§ÒÔSYSDBAÁ¬½ÓµÄͬÒå´Ê£©¡£OracleÊý¾Ý¿âµÄа汾½«Öð²½ÌÔÌ­INTERNALÕâ¸öÄÚ²¿Óû§£¬ËùÒÔÎÒÃÇ×îºÃ»¹ÊÇÉèÖÃDBAÓû§¾ßÓÐSYSDBAȨÏÞ¡£
¶þ¡¢Êý¾Ý¿âµÄÆô¶¯£¨STARTUP£©
    Æô¶¯Ò»¸öÊý¾Ý¿âÐèÒªÈý¸ö²½Ö裺
¡¡¡¡¡¡1¡¢ ´´½¨Ò»¸öOracleʵÀý£¨·Ç°²×°½×¶Î£©
¡¡¡¡¡¡2¡¢ ÓÉʵÀý°²×°Êý¾Ý¿â£¨°²×°½×¶Î£©
¡¡¡¡¡¡3¡¢ ´ò¿ªÊý¾Ý¿â£¨´ò¿ª½×¶Î£©
ÔÚStartupÃüÁîÖУ¬¿ÉÒÔͨ¹ý²»Í¬µÄÑ¡ÏîÀ´¿ØÖÆÊý¾Ý¿âµÄ²»Í¬Æô¶¯²½Öè¡£
¡¡¡¡
1¡¢STARTUP NOMOUNT
        NONOUNTÑ¡Ïî½ö½ö´´½¨Ò»¸öOracleʵÀý¡£¶ÁÈ¡init.ora³õʼ»¯²ÎÊýÎļþ¡¢Æô¶¯ºǫ́½ø³Ì¡¢³õʼ»¯ÏµÍ³È«¾ÖÇø£¨SGA£©¡£Init.oraÎļþ¶¨ÒåÁËʵÀýµÄÅäÖ㬰üÀ¨ÄÚ´æ½á¹¹µÄ´óСºÍÆô¶¯ºǫ́½ø³ÌµÄÊýÁ¿ºÍÀàÐ͵ȡ£ÊµÀýÃû¸ù¾ÝOracle_SIDÉèÖ㬲»Ò»¶¨ÒªÓë´ò¿ªµÄÊý¾Ý¿âÃû³ÆÏàͬ¡£µ±ÊµÀý´ò¿ªºó£¬ÏµÍ³½«ÏÔʾһ¸öSGAÄÚ´æ½á¹¹ºÍ´óСµÄÁÐ±í£¬ÈçÏÂËùʾ£º
SQL> startup nomount
ORACLE Àý³ÌÒѾ­Æô¶¯¡£
Total System Global Area 35431692 bytes
Fixed Size 70924 bytes
Variable Size 18505728 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
¡¡¡¡
2¡¢STARTUP MOUNT
¡¡¡¡¸ÃÃüÁî´´½¨ÊµÀý²¢ÇÒ°²×°Êý¾Ý¿â£¬µ«Ã»Óдò¿ªÊý¾Ý¿â¡£Oracleϵͳ¶ÁÈ¡¿ØÖÆÎļþÖйØÓÚÊý¾ÝÎļþºÍÖØ×÷ÈÕÖ¾ÎļþµÄÄÚÈÝ£¬µ«²¢²»´ò¿ª¸ÃÎļþ¡£ÕâÖÖ´ò¿ª·½Ê½³£ÔÚÊý¾Ý¿âά»¤²Ù×÷ÖÐʹÓã¬Èç¶ÔÊý¾ÝÎļþµÄ¸üÃû¡¢¸Ä±äÖØ×÷ÈÕÖ¾ÒÔ¼°´ò¿ª¹éµµ·½Ê½µÈ¡£ÔÚÕâÖÖ´ò¿ª·½Ê½Ï£¬³ýÁ


Ïà¹ØÎĵµ£º

ÔÚRedhat 5 ÉÏ°²×°Oracle 10g

     ³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
      ±¾ÎÄÖصãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......

oracle dblink µÄÓ¦ÓÃ


1¡¢ÓÃdblinkÁ´½Óoracle
£¨1£©Óëƽ̨Î޹صÄд·¨£º
create public database
link cdt connect to apps
identified by apps using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.205.100)(PORT = 1541))
)
(CONNECT_DATA =
(SERVICE_NAME = CDT)
)
)'
£¨2£©¿ÉÒÔ½«µ¥ÒýºÅÄÚµÄÄÚÈÝ ......

Oracle×Ö·û´®º¯Êý

 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 
¸ø³öÕ ......

oracle Data Mining

 Executive Overview
The Oracle Data Mining Option provides powerful data mining functionality within the Oracle Database. It enables you to discover new insights hidden in your data and to leverage your investment in Oracle Database technology. With Oracle Data Mining, you can build and apply ......

oracle sqlplusÖÐÎÄÏÔʾÂÒÂëµÄÎÊÌâ

ÔÚwindowsÏÂsqlplusÍêÈ«Õý³££¬¿ÉÊǵ½linuxÏ£¬sqlplusÖÐÎÄÏÔʾ¾Í³öÎÊÌâÁË£¬×ÜÊÇÏÔʾ“??”£¬Õâ¸öÎÊÌâÓÖÔõô½â¾öÄØ£¿
¾­¹ýÔÚÍøÂçÉϲé×ÊÁÏ£¬ÒÔ¼°³¢ÊÔ£¬µÃµ½µÄ½â·¨ÈçÏ£º
ÆäʵºÜ¼òµ¥ÎÒÃÇÖ»ÒªÉèÖÃÍ˳ösqlplus,ÉèÖÃÏàÓ¦µÄ»·¾³±äÁ¿NLS_LANG 
      export NLS_LANG="SIMPLI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ