windowsÏ sqlplus / as sysdba ±¨ora-12560µÄÖÕ¼«½â¾ö·½·¨
windowsÏ£¬sqlplus / as sysdba¾³£±¨ ORA-12560: TNS:protocol adapter error,½â¾öÕâ¸ö±¨´í£¬Óжà¸ö·½·¨£º
1.È·ÈÏwindows×¢²á±íÖеÄORACLE_HOME ¼ü¼°Æä ¼üÖµ ÊÇÕýÈ·µÄ£¬ÊÇÓÐЧµÄ
±ÈÈ磺HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1Ï£¬ÕÒµ½ORACLE_HOME ¼ü£¬¶ÔÓ¦µÄ¼üֵΪH:\oracle\product\10.2.0\db_1 ,ÆäʵÕýÈ·µÄ¼üֵΪF:\oracle\product\10.2.0\db_1
--->×¢Ò⣺windowsÏ£¬Çë²»ÒªÉèÖÃORACLE_HOME»·¾³±äÁ¿£¬ÏêϸÇë¼ûÎÒ·ÒëµÄÎÄÕ£º
http://blog.csdn.net/msdnchina/article/details/38010025
--->×¢Ò⣺windowsϵÄ×¢²á±í´æ´¢µÄORACLE_HOME ¼ü ºÍ ORACLE_SID ¼üÏ൱ÓÚunixϵÄ.profileÖж¨ÒåµÄORACLE_HOME,ORACLE_SIDµÈ»·¾³±äÁ¿---¸Ã˵·¨´¿ÊôÎÒ¸öÈ˵Ä×ܽᡣ
2È·±£windows ·þÎñÀï±äµÄOracleServiceXXX·þÎñÊÇÒÑÆô¶¯×´Ì¬¡£
¹ØÓÚOracleServiceXXX ºÍ Oracle ʵÀýµÄ¹ØÏµ£¬Çë¼ûÎÒдµÄÎÄÕ£º
http://blog.csdn.net/msdnchina/article/details/38011055
3.cmdÏÂ,cdµ½ F:\oracle\product\10.2.0\db_1\binÏ£¬ÔÙÇÃsqlplus / as sysdba
×¢Ò⣬²»ÊÇcdµ½F:\oracle\product\10.2.0\client_1\bin¡£Ò²¾ÍÊÇ˵cdµ½ oracleÊý¾Ý¿âÈí¼þµÄ·þÎñÆ÷¶Ë£¬²»ÊÇcdµ½oracleÊý¾Ý¿âÈí¼þµÄ¿Í»§¶Ë¡£
--->×¢Ò⣺windowsµÄcmdÏ£¬ÇÃÒ»¸öÃüÁwindows¶Ô¸ÃÃüÁîµÄ²éÕÒ˳ÐòΪ£ºÊ×ÏÈÕÒµ±Ç°Ä¿Â¼ÏÂÓÐÎÞ¸ÃÃüÁÆä´ÎÔÙµ½PATH·¾¶ÏÂÕÒÓÐÎÞ¸ÃÃüÁî¡£
4.cmdÏ£¬set ORACLE_SID=ÄãÏë½øÈëµÄÊý¾Ý¿âµÄÄǸösid
5.cmdÏÂ,cdµ½ F:\oracle\product\10.2.0\db_1\binÏ£¬ÔÙÇÃsqlplus /@ÍøÂç·þÎñÃû as sysdba
×¢Ò⣬²»ÊÇcdµ½F:\oracle\product\10.2.0\client_1\bin¡£Ò²¾ÍÊÇ˵cdµ½ oracleÊý¾Ý¿âÈí¼þµÄ·þÎñÆ÷¶Ë£¬²»ÊÇcdµ½oracleÊý¾Ý¿âÈí¼þµÄ¿Í»§¶Ë¡£