OracleÀ䱸·Ý»Ö¸´ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÊÖÉÏÓÐһ̨ºÜÔçµÄ»úÆ÷ÁË£¬Ïë°ÑÀïÃæµÄÊý¾ÝÄóöÀ´¡£
OS£ºWindows NT Server 4.0 SP6
DB£ºOracle 8.1.7
ÕÒµ½ÁËÕâ¸öÊý¾Ý¿âµÄÍêÈ«±¸·Ý£¬¾ÍÊÇoracleÎļþ¼ÐϵÄËùÓж«Î÷¡£»úÆ÷Ä¿Ç°²Ù×÷ϵͳ£¨NT Server 4.0£©ºÍOracke£¨8.1.7£©Èí¼þ°²×°Õý³££¬µ«ÊÇûÓÐʵÀý¡£
½«Êý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢¿ØÖÆÎļþ¡¢²ÎÊýÎļþ¡¢ÃÜÂëÎļþ¡¢network/ADMIN¶¼¿½±´ÖÁÏàÓ¦µÄλÖ᣸ù¾Ýlistener.oraÎļþ¸ü¸Ä»úÆ÷Ãû¡£
ʹÓÃ
oradim -new -sid mis
½¨Á¢ÊµÀý¡£¿ÉÒÔ¿´µ½¼àÌýÆ÷ºÍʵÀýµÄ·þÎñ¾ùÒÑÆô¶¯¡£
ÉèÖÃÁËORACLE_SID¡¢ORACLE_HOME»·¾³±äÁ¿£¬ÔÚ×¢²á±íÖÐÒ²ÉèÖÃÁËORACLE_SIDµÄ¼üÖµ¡£
sqlplus /nolog
conn / as sysdba
±¨ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó¡£
conn sys/123@mis as sysdba
±¨ORA-12500£ºTNS£º¼àÌý³ÌÐòÎÞ·¨Æô¶¯×¨Ó÷þÎñÆ÷½ø³Ì¡£
²é¿´alertÎļþ£¬·¢ÏÖûÓÐÈκÎмÓÄÚÈÝ£¬×îºóµÄÒ»Ìõ¼Ç¼»¹ÊÇ2007ÄêµÄ£¬ÄÚÈÝÊÇ£º"Completed: alter database open"¡£ÍƶÏÔÚ×öÕâ¸ö±¸·ÝµÄʱºòÊý¾Ý¿â²¢Ã»ÓÐÕý³£¹Ø±Õ¡£
½«¼àÌýÆ÷·þÎñͣϣ¬ÔÙ½øÐÐ
sqlplus /nolog
conn / as sysdba
ͬÑù±¨ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó¡£
conn sys/123@mis as sysdba
±¨¼àÌýÆ÷ûÓÐÆô¶¯¡£
Çë½Ì¸÷룬ÎÒ¸ÃÈçºÎ»Ö¸´Ëü°¡£¿
ËùÓÐÎļþ¶¼ÒªCOPYµ½Ô¿âËùÔÚµÄĿ¼
1£©ORACLE_SIDÒªÉèÖøúÒÔÇ°µÄÒ»Ñù²ÅÐС£
oradim -new -sid mis
mis¸úÔ¿âµÄSIDÊÇÒ»ÑùµÄô£¿
2£©½øÈëSQLPLUSÇ°£¬ÏÈÉèÖÃSID£¬ÕâÑùÊÔÊÔ
c:\>set ORACLE_SID=mis
c:\>sqlplus /nolog
sql>connect / as sysdba
---Õâ¸öʱºò£¬Ó¦¸ÃÌáʾÁ¬½Óµ½¿ÕÏнø³Ì²ÅÐÐ
Æô¶¯¼àÌýûÓа¡
»·¾³±äÁ¿ÊÇÉèÁ˵ģ¬¼
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×Å°ïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ллÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓƵ£¬¸ú×ÅÊÓƵÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......