pl/sql - Oracle / ¿ª·¢
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ¥ORACLE ÔÙÂýÂýÏòDBA·½Ïò·¢Õ¹ÁË£¿£¿ ÎÒ¸öÈËÈÏΪͦÓÐǰ;µÄ£¬ÎÒÀÏÆÅ×öOracle EBS¾ÍÓÃPL/SQLÄØ¡£ Èç¹ûÄãÔÚ´óÁ¬£¬È¥°£ÉÕÜͦ²»´íµÄ ¶Ô,ORACLE µÄEBS ÓÐǰ;! ÓÐǰ; Oracle¹ÙÍøÉ쵀 sqldeveloper ÍêÈ«ºº»¯ ͦ²»´íµÄ Èç¹ûÄãûÓùýPL/SQLµÄ»° ½¨ÒéÄã¾ÍÓà sqldeveloper °É ÆäʵÎÒÒªÇóûÄãÃÇ˵µÄÄÇô¸ß£¬ÎÒÖ»ÒªÇóÒÔºóÈ¥±ðµÄÖÐС³ÇÊУ¬Ò²ÄÜÕÒµ½ÀàËÆµÄ¸Úλ ²»ÏñÎÒ±ÏÒµµÄʱºò×öFRAME COBOL£¬Á½ÄêÁ˵½±ðµÄµØ·½È¥ÕÒCOBOLÖ°Òµ£¬³ýÁËIBMµÄһЩÍâ°ü¹«Ë¾£¬¼¸ºõûÓа¡£¡£¡£¡ÈÃÈËÐĺ®£¡£¡£¡ Á½Äê¾ÑéÕÒ¸öCOBOL¹¤×÷·ÑÁ¦ÆøµÄ¡£¡£¡£ËùÒÔÎÒÏÖÔÚµÄÒªÇó¾ÍÊÇORACLE¿ª·¢ÊDz»ÊÇÔڴ󲿷ֳÇÊж¼ÊÇÓÐÐèÇóµÄ£¿£¿£¿ÒýÓà ÆäʵÎÒÒªÇóûÄãÃÇ˵µÄÄÇô¸ß£¬ÎÒÖ»ÒªÇóÒÔºóÈ¥±ðµÄÖÐС³ÇÊУ¬Ò²ÄÜÕÒµ½ÀàËÆµÄ¸Úλ ²»ÏñÎÒ±ÏÒµµÄʱºò×öFRAME COBOL£¬Á½ÄêÁ˵½±ðµÄµØ·½È¥ÕÒCOBOLÖ°Òµ£¬³ýÁËIBMµÄһЩÍâ°ü¹«Ë¾£¬¼¸ºõûÓа¡£¡£¡£¡ÈÃÈËÐĺ®£¡£¡£¡ Á½Äê¾ÑéÕÒ¸öCOBOL¹¤×÷·ÑÁ¦ÆøµÄ¡£¡£¡£ËùÒÔÎÒÏÖÔÚµÄÒªÇó¾ÍÊÇORACLE¿ª·¢ÊDz»ÊÇÔڴ󲿷ֳÇÊж¼ÊÇÓÐÐèÇóµÄ£¿£¿£¿ ÏëÒª´ó²¿·Ö³ÇÊж¼ÓÐÐèÇó£¬ÄãÒª¿¼ÂÇ×öjava»òÕßÓÎÏ·¶¯»ÁË¡£¡£¡£ plsql?½ö½ö»áplsqlÄÜ×öʲô£¿ÏëרÃÅ×öÊý¾Ý¿âÄ¿±êÖÁÉÙÊÇDBA¡£ÒýÓà ÆäʵÎÒÒªÇóûÄãÃÇ˵µÄÄÇô¸ß£¬ÎÒÖ»ÒªÇóÒÔºóÈ¥±ðµÄÖÐС³ÇÊУ¬Ò²ÄÜÕÒµ½ÀàËÆµÄ¸Úλ ²»ÏñÎÒ±ÏÒµµÄʱºò×öFRAME COBOL£¬Á½ÄêÁ˵½±ðµÄµ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......