¹ØÓÚOracleÖÐtnsnames.oraµÄÅäÖÃ
ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mstrdw)
)
)
ÉÏÊö´úÂëÖÐÊ×ÐÐmstrdwÇ°Ãæ²»ÄÜÓпոñ£¬ÆäÓಿ·ÖÐÐÊ×±ØÐëÓпոñ¡£
ºô~
Æäʵ£¬¶ÔÓÚ±¾µØNET·þÎñÃûµÄÅäÖ㬻¹ÊÇÖ±½Óͨ¹ýNET configuration assistantÀ´±£ÏÕЩ~
Ïà¹ØÎĵµ£º
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐÐ ......
2¡¢ ³éÏóÊý¾ÝµÄÒýÓá£
¡¡¡¡µ±½¨Á¢ºÃ³éÏóÊý¾ÝÀàÐ͵Äʱºò£¬Êý¾Ý¿â¹ÜÀíÔ±¾Í¿ÉÒÔÏò»ù±¾Êý¾ÝÀàÐÍÄÇÑù£¬ÒýÓóéÏóÊý¾ÝÀàÐÍ£¬°üÀ¨ÔÚ½¨Á¢±í»òÕß¶ÔÏà¹Ø×ֶνøÐи³ÖµµÄʱºò£¬¶¼Õâô·½±ã¡£
¡¡¡¡ÈçÔÚ½¨Á¢±íµÄʱºò£¬¿ÉÒÔ°ÑÕâ¸ö³éÏóÊý¾ÝÀàÐÍÖ±½Ó¸úij¸ö×ֶιØÁªÆðÀ´¡£Èç
¡¡¡¡Create Table USERS
¡¡¡¡(F_Adress Adress );
¡¡¡ ......
oracleËøµÄÅŶӻúÖÆ£º
ÇëÇóËø¶¨ÐèÒªÅŶӡ£Èç¹ûij¸ö»á»°ÇëÇóÒ»¸öËø¶¨£¬µ«ÊÇÓÉÓÚÆäËû»á»°ÒÑ¾Ëø¶¨ÁËÖ¸¶¨¼Ç¼»ò¶ÔÏó¶øÎÞ·¨»ñµÃËùÐèµÄËø¶¨£¬ÄÇôÕâ¸ö»á»°½«»áµÈ´ý¡£´Ëʱ£¬¿ÉÄܶà¸ö»á»°¶¼Ôڵȴý·ÃÎÊÏàͬ¼Ç¼»ò¶ÔÏó£¬ÔÚÕâÖÖÇé¿öÏ£¬ORACLE»á¸ú×ÙÕâЩ»á»°ÇëÇóËø¶¨µÄ˳Ðò¡£
Èç¹û ......
¸ß¼¶¸´ÖÆ
ʲôÊǸ´ÖÆ£¿¼òµ¥µØËµ¸´ÖƾÍÊÇÔÚÓÉÁ½¸ö»òÕß¶à¸öÊý¾Ý¿âϵͳ¹¹³ÉµÄÒ»¸ö·Ö²¼Ê½Êý¾Ý¿â»·¾³Öп½±´Êý¾ÝµÄ¹ý³Ì¡£
¸ß¼¶¸´ÖÆ£¬ÊÇÔÚ×é³É·Ö²¼Ê½Êý¾Ý¿âϵͳµÄ¶à¸öÊý¾Ý¿âÖи´ÖƺÍά»¤Êý¾Ý¿â¶ÔÏóµÄ¹ý³Ì¡£ Oracle ¸ß¼¶¸´ÖÆÔÊÐíÓ¦ÓóÌÐò¸üÐÂÊý¾Ý¿âµÄÈκθ±±¾£¬²¢½«ÕâЩ¸ü¸Ä×Ô¶¯´«µÝµ½ÆäËûÊ ......