oracle¼¸¸ö¸ÅÄîÎÊÌâ
ÐÂÊÖ£¬¶ÔÓÚoracleÖеÄÊý¾Ý¿âʵÀý£¬·½°¸£¬Óû§Ö®¼äµÄ¹ØÏµÓе㲻̫Ã÷°×£¬Ï£Íû¸÷λ¸ßÊÖÖ¸½Ì¡£
Ôõô¸Ð¾õÔÚÊý¾Ý¿âʵÀýÖпÉÒÔÓжà¸öÓû§£¬¶øÃ¿¸öÓû§ÓÐÒ»¸ö·½°¸£¬ÔÚ·½°¸Ï²ŶÔÓ¦ºÜ¶àÊý¾Ý¿â¶ÔÏó£¨Èç±í£¬ÊÓͼµÈ£©
ʵÀýÊÇÒ»×éORACLEºǫ́½ø³Ì¼°Ò»¿éÄڴ棨ͨ³£³ÆÖ®ÎªSGA£¬ÏµÍ³È«¾ÖÇø£©µÄ¼¯ºÏ¡£
·½°¸(schema)£¬ÊÇָijһÓû§¼°ÆäËùÓжÔÏó£¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°üµÈµÈ£©µÄ¼¯ºÏ¡£
Èç¹ûijÓû§ÎÞÈκζÔÏó£¬ÄÇô£¬Êý¾Ý¿âÀïÖ»´æÔÚ¸ÃÓû§£¬²¢ÎÞ¸Ãschema¡£
1£¬Êý¾Ý¿âʵÀý¾ÍÊǺǫ́½ø³Ì ÔÚ¼ÓÉÏ Ò»¿éÄÚ´æÇø(SGAÓëPGA£¬ÓеÄʱºò»¹ÓÐUGA)¡£
2£¬·½°¸¾ÍÊǽ¨Á¢µÄÓû§ÒÔ¼°¸ÃÓû§ÏÂÃæËùÊôµÄËùÓжÔÏ󣨰üÀ¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°ü¡¢Ë÷Òý¡¢´¥·¢Æ÷µÈµÈ£©µÄ¼¯ºÏ¡£
3£¬Óû§¾ÍÊǼòµ¥µÄ´¿´âµÄÓû§£¬Èç¹ûÊǽ¨Á¢µÄ¿ÕÓû§£¬¾ÍÊÇ˵Óû§ÏÂÃæÃ»ÓÐÈÎºÎ±í¡¢ÊÓͼ¡¢¹ý³ÌµÈ¶ÔÏóµÄ»°£¬ÄÇô£¬Êý¾Ý¿âÀïÃæ¿ÉÒÔÕâô˵£¬Ö»´æÔÚÓû§£¬¶øÃ»ÓÐÏàÓ¦µÄ·½°¸schema¡£
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#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 ÕýÈ ......
ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?
ûÓÐÁªÏµµÄ
exp, imp
ÎÒÒª°ÑÆäÖеÄÁ½ ......