Ð޸ĵçÄÔµÄÖ÷»úÃûoracle agent ·þÎñͻȻÎÞ·¨Æô¶¯
½ñÌìÓöµ½ÕâÑùµÄÎÊÌ⣬ÐÞ¸ÄÖ÷»úÃûºóoracle agent ·þÎñͻȻÎÞ·¨Æô¶¯£¬ÉÏÍøÕÒÁËÒ»»á×öÈçϲÙ×÷¡£¿ÉÒÔÕý³£Ê¹ÓÃÁË
1¡¢½«%oracle_home\ora92\network\adminϵÄlistener.oraºÍtnsnames.oraÄÚµÄËùÓÐÔÖ÷»úÃû¸ÄΪÏÖÓÐÖ÷»úÃû»òÕ߹̶¨IPµØÖ·£¨ÒÔ±ã¿Í»§¶Ë»úÆ÷Äܹ»·ÃÎÊServer£©£¬µ±È»Èç¹ûÏµÍ³ÖØÆôºó×Ô¶¯¸ÄÕý£¬¿ÉºöÂԴ˲½Öè¡£
2¡¢½«%oracle_home\ora92\network\agentϵÄservices.oraÄÚµÄÔÖ÷»úÃûÒ²ÐÞ¸ÄΪÏÖÓÐÖ÷»úÃû»òÕßIPµØÖ·¡£
3¡¢½«%oracle_home\ora92\network\agentĿ¼ÏµÄËùÓÐ*.qÎļþÈ«²¿É¾³ý£¬ÖØÆôµçÄÔ¡£
Ïà¹ØÎĵµ£º
´´½¨ÁÙʱ±í¿Õ¼ä
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 ......
ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
(DESCRIPTION =
(ADDRESS_LIST =
......
¡¡²Ù×÷·ûÓÅ»¯
¡¡¡¡IN ²Ù×÷·û
¡¡¡¡ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
¡¡¡¡µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
¡¡¡¡ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£ ......
Oracle°æ±¾µÄÇø±ðÓÐÄÇЩ
http://database.51cto.com/art/201004/196494.htm
http://database.51cto.com
2010-04-23 15:20 ØýÃû »¥ÁªÍø ÎÒÒªÆÀÂÛ(
0
)
ͻ񻣼
ÒÔϵÄÎÄÕÂÖ÷ÒªÊǶÔOracle°æ±¾µÄÇø±ðµÄ¼òÊö£¬Èç¹ûÄã¶ÔÆäµÄÏà¹ØÄÚÈݸÐÐËȤµÄ
»°£¬ÒÔϵÄÎÄÕÂÖ÷Òª¾ÍÊÇ¶ÔÆäÏà¹ØÄÚÈÝµÄ ......
³éÏóÊý¾ÝÀàÐÍ
1¡¢´´½¨ÀàÐÍ
--µØÖ·ÀàÐÍ
CREATE OR REPLACE TYPE AddressType AS OBJECT
(
Country varchar2(15),
City varchar2(20),
Street varchar2(30)
);
2¡¢ÀàÐÍǶÌ×
--´´½¨»ùÓÚǰһ¸öÀàÐ͵ÄеijéÏóÊý¾ÝÀàÐÍ£º¾ÞÐÇÀàÐÍ
CREATE OR REPLACE TYPE SuperStarType AS OBJECT
(
StarName varchar2(30),
Addres ......