Éî¿ÌÀí½â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ϵͳ¶ÁÈ¡¿ØÖÆÎļþÖйØÓÚÊý¾ÝÎļþºÍÖØ×÷ÈÕÖ¾ÎļþµÄÄÚÈÝ£¬µ«²¢²»´ò¿ª¸ÃÎļþ¡£ÕâÖÖ´ò¿ª·½Ê½³£ÔÚÊý¾Ý¿âά»¤²Ù×÷ÖÐʹÓã¬Èç¶ÔÊý¾ÝÎļþµÄ¸üÃû¡¢¸Ä±äÖØ×÷ÈÕÖ¾ÒÔ¼°´ò¿ª¹éµµ·½Ê½µÈ¡£ÔÚÕâÖÖ´ò¿ª·½Ê½Ï£¬³ýÁ
Ïà¹ØÎĵµ£º
³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
±¾ÎÄÖصãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......
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£©¿ÉÒÔ½«µ¥ÒýºÅÄÚµÄÄÚÈÝ ......
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
¸ø³öÕ ......
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 ......
ÔÚwindowsÏÂsqlplusÍêÈ«Õý³££¬¿ÉÊǵ½linuxÏ£¬sqlplusÖÐÎÄÏÔʾ¾Í³öÎÊÌâÁË£¬×ÜÊÇÏÔʾ“??”£¬Õâ¸öÎÊÌâÓÖÔõô½â¾öÄØ£¿
¾¹ýÔÚÍøÂçÉϲé×ÊÁÏ£¬ÒÔ¼°³¢ÊÔ£¬µÃµ½µÄ½â·¨ÈçÏ£º
ÆäʵºÜ¼òµ¥ÎÒÃÇÖ»ÒªÉèÖÃÍ˳ösqlplus,ÉèÖÃÏàÓ¦µÄ»·¾³±äÁ¿NLS_LANG
export NLS_LANG="SIMPLI ......