Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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
---Õâ¸öʱºò£¬Ó¦¸ÃÌáʾÁ¬½Óµ½¿ÕÏнø³Ì²ÅÐÐ


Æô¶¯¼àÌýûÓа¡

»·¾³±äÁ¿ÊÇÉèÁ˵ģ¬¼


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×Å°ïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

ллÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓƵ£¬¸ú×ÅÊÓƵÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ