ÇóÖú£¬ oracleÎÊÌâ
ÎÒÔÚlinuxÖÕ¶ËÏ ִÐÐoracleÃüÁî ´´½¨Ò»¸ö±í »òÕß±ðµÄʲôÃüÁÐèÒª´òºÜ¶àÐУ¬ÓÐʱºò´òµ½µÚÊ®ÐеÄʱºò·¢ÏÖµÚ¾ÅÐÐÓеط½³ö´íÁË£¬ÐèÒªÐÞ¸Ä µ«Êǻز»µ½ÉÏÃæÒ»ÐУ¬Ö»ÄܰÑËùÓÐÃüÁîÖØÐÂÔÙ´òÒ»±é£¬ºÜ¿àÄÕ£¬Çë½Ì¸÷λ´óϺ£¬ÔõôÑùÔÚ´ò´íÃüÁîµÄʱºò»Øµ½ÉÏÒ»ÐУ¬½øÐÐÐÞ¸Ä
ÓõÚÈý·½¹¤¾ß£¬»òÕßд½Å±¾£¬Ö´ÐеÄʱºòÖ±½ÓÖ´ÐÐÏà¹ØµÄ½Å±¾
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......