ÇóoracleÎĵµ½éÉÜ£¬Ê¹ÓÃÖ¸ÄÏ - Oracle / »ù´¡ºÍ¹ÜÀí
±¾È˸ã±à³ÌµÄ£¬ËùÒÔ¶ÔÊý¾Ý¿â²»ÊǺÜרҵ¡£
µ«ÊÇѧ¹ý»ù±¾µÄsql£¬¶ÔoracleµÄsqlplusÒ²¿´¹ýÊÓÆµ£¬Ö»ÊÇÁ˽â
ËùÒÔÎÒÏëÖªµÀoracleÓÐʲôÎĵµÖ®ÀàµÄ£¬ÀàËÆÓÚÎÒÃÇjavaseÓÐapi£¬»òÕßʹÓÃÖ¸ÄÏÒ²¿ÉÒÔ¡£
·½±ã²éÕÒ¶«Î÷£¬£¨×îºÃÁ¬ÄÇÖÖ»ù±¾Êý¾ÝÀàÐ͵ÄÖ¸ÄÏÓÐÓУ©
¹Ù·½Îĵµ¶¼ÊÇEÎĵģ¬Â¥ÉÏÁ½Î»¶¼ÊÇÇ¿ÈËѽ
¶þÂ¥ÕâλÈÊÐÖÍÆ¼öµÄÄǸöÌ«´óÁ衃 400¶àMB
ËùÒÔÎÒÁíÍâÕÒÁËһϣ¬ÕÒµ½ÕâЩ
*************************
Oracle Database SQL Language Reference
È«Ãæ½éÉÜSQLÓïÑÔ¡£´ËÎĵµÎÞÐ辫¶Á£¬Åöµ½²»¶®µÄµØ·½²é¿´´ËÎÄ µµ¼´¿É
Oracle Database PL/SQL Language Reference
È«Ãæ½éÉÜPL/SQL±à ³ÌÓïÑÔ¡£´ËÎĵµÎÞÐ辫¶Á£¬Åöµ½²»¶®µÄµØ·½²é¿´´ËÎĵµ¼´¿É
Oracle Database PL/SQL Packages and Types Reference
Õâ¸öÎĵµÈ«Ãæ½éÉÜORACLEÊý¾Ý¿âÖÐÄÚÖõÄPL/SQL°üºÍÀàÐÍ£¬Èç±È½Ï³£ÓõÄÒÔ CTX_(ORACLE TEXTÏà¹ØµÄ°ü)DBMS_(ORACLEÊý¾Ý¿â¹ÜÀíÏà¹ØµÄ°ü),UTL_(ORACLEʵÓù¤¾ßÏà¹ØµÄ°ü)
SQL*Plus User's Guide and Reference
Õâ¸öÎĵµ½éÉÜORACLE³£ÓõĿͻ§¶Ë¹¤¾ßSQL*PlusµÄʹÓÃ
******************
Õ⼸±¾¿´ÆðÀ´Ò²Í¦²»´íµÄ£¿£¿¶øÇÒ¶¼Êǹٷ½µÄ
400MÄÄÀïËã´ó£¬ÏÂÔØµÄÎĵµÀïÓкܶ౾ÊéµÄ£¬ÄãдµÄ¶¼°üÀ¨ÔÚÆäÖÐ
ÔÀ´Èç´Ë
Å£±Æ£¬·Ç³£¸Ðл£¡
û¿´¹ý¡£
www.oracle.orgÀïÃæÓеÄÊÇÎĵµ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......