¼±¼±¼± oracle²»ÄܵǼ ¼àÌý²»ÄÜÆô¶¯
ÎÒµÄÎļþ´æ´¢ÔÚ C:\oracle\product\10.2.0\db_1\NETWORK\ADMIn\listener.ora
ÅäÖÃÈçÏÂ
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME =C:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =172.31.60.110)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = oravrm))
)
)
Æô¶¯lsnrctl start
Ìáʾ
ÔÚlisterner.oraÖÐÖ¸¶¨
sid_list_listener²ÎÊý²»ÕýÈ·
nl-00303 :NV ×Ö·û´®ÖдæÔÚÓï·¨´íÎó¡£
¸Õ¿ªÊ¼ÊÇÊý¾Ý¿â²»ÄܵǼ¡£
лл´ó¼ÒÁË¡£
ÏÖÔÚ¼àÌýÄÜÆô¶¯ÁË¡£¾ÍÊÇ
ORA-12514:TNS:¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ
¿´¿´tnsnameÄǸöÎļþÖÐÓÐûÓÐÕâ¸öoravrm
ÓÐÄǸöÃû×Ö£¬Çë´ó¼Ò°ï°ïæ
ÖØÐÂÅäÖÃһϼàÌý¿´¿´£¬ °ÑÔÀ´µÄɾ³ýµô¡£
Oracle Êý¾Ý¿â¼àÌýÅäÖÃ
http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx
----
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......