¹ØÓÚ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À´±£ÏÕЩ~
Ïà¹ØÎĵµ£º
select name from v$datafile;
create dataspace tablespace datafile '/oracle/oradata/orcl/data01.dbf' size 1024m,'/oracle/oradata/orcl/data02.dbf' size 1024m autoextend on next 100m maxsize unlimited;
alter tablespace dataspace add datafile '/oracle/oradata/orcl/da ......
ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD" (
ID nvarchar2(20) &n ......
OracleÆóÒµ¹ÜÀíÆ÷11gÌṩҵ½ç×îÈ«ÃæµÄÒµÎñÇý¶¯ÐÍIT¹ÜÀí¹¦ÄÜ£¬ÓÐÖúÓÚͨ¹ý¼¯³ÉʽIT¹ÜÀí·½·¨£¬×î´óÏ޶ȵØÌá¸ßÆóÒµÃô½ÝÐÔºÍЧÂÊ¡£
¡¡¡¡OracleÆóÒµ¹ÜÀíÆ÷11gÒýÈëÁË£º
¡¡¡¡ÒµÎñÇý¶¯ÐÍÓ¦ÓùÜÀí - ʹITϵͳÄܹ»¸ü¿ìµØÏìÓ¦ÓÅÏÈÒµÎñ£¬Í¨¹ý¹ÜÀíÃæÏòÓû§ÌåÑéºÍÉÌÎñ½»Ò׵ĹؼüÖ¸±ê£¬Ìṩ¸ü¸ßµÄÉÌÒµ¼ÛÖµ¡£
¡¡¡¡¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀ ......
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING
DATAFI ......