windowÏÂÃüÁîÐÐÆô¶¯oracle·þÎñ
windowÏÂÃüÁîÐÐÆô¶¯oracle·þÎñ
2008-11-12 22:30
Ò»¡¢¶ÀÁ¢Æô¶¯£º
Microsoft Windows 2000 [Version 5.00.2195]
(C) °æȨËùÓÐ 1985-2000 Microsoft Corp.
#########################################################
¼ì²é¼àÌýÆ÷״̬£º
#########################################################
E:">lsnrctl status
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-6ÔÂ -2005 11:01:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oyez)(PORT=1521)))
TNS-12541: TNS£ºÎÞ¼àÌýÆ÷
TNS-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
TNS-00511: ÎÞ¼àÌýÆ÷
32-bit Windows Error: 61: Unknown error
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS£ºÎÞ¼àÌýÆ÷
TNS-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
TNS-00511: ÎÞ¼àÌýÆ÷
32-bit Windows Error: 2: No such file or directory
#########################################################
³¢ÊԵǽ±¾µØÊý¾Ý¿â£º
#########################################################
E:">sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚ¶þ 6ÔÂ 28 11:01:09 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn system/qqqqqq@oradb as sysdba
ERROR:
ORA-12541: TNS: ûÓмàÌýÆ÷
££Èç¹ûûÓÐÆô¶¯ORACLE·þÎñµÄ»°£¬½«³öÏÖÏÂÃæµÄ´íÎó¶ø²»ÊÇÉÏÃ棺
ERROR:
ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
#########################################################
ÔÒò£º¼àÌýÆ÷ûÓÐÆô¶¯£¬ÎÞ·¨½âÎö“oradb”·þÎñÃû£¬ËùÒÔÎÞ·¨µÇ½Êý¾Ý¿â¡£
#########################################################
SQL> exit
#########################################################
Æô¶¯¼àÌýÆ÷
#########################################################
E:">lsnrctl start
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-6ÔÂ -2005 11:01:36
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Æô¶¯tnslsnr£ºÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
ϵͳ²ÎÊýÎļþΪF:"oracle"ora92"network"
Ïà¹ØÎĵµ£º
¡¡¡¡1. Oracle°²裝Íê³ÉºóµÄ³õʼ¿ÚÁ
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
¡¡¡¡2. ORACLE9IAS WEB CACHEµÄ³õʼĬÈÏÓû§ºÍÃÜÂ룿
¡¡¡¡administrator/administrator
¡¡¡¡3. oracle 8.0.5Ôõô´´½¨Êý¾Ý¿â£¿
¡¡¡¡ÓÃorainst¡£Èç¹ûÓ ......
http://blog.csdn.net/lzysystem/archive/2009/03/05/3960853.aspx
http://www.linuxidc.com/Linux/2009-06/20390.htm
http://www.linuxdiyf.com/viewarticle.php?id=163893
http://blog.sina.com.cn/s/blog_4ed66efa0100gfjx.html### ......
ÔÎĵØÖ·£ºhttp://arvinnan.javaeye.com/blog/308638
²Î¿¼
http://www.blogjava.net/wxqxs/archive/2008/10/13/237180.html?opt=admin
http://hi.baidu.com/ray315/blog/item/153c97a33cd26caacbefd0de.html
¶¨Òå
External tables access data in
external s ......
×ܵÄÀ´ËµwindowsÏÂÔØ°²×°oracleÈí¼þ±ÈlinuxÏÂÒª¼òµ¥µÄ¶à¡£
Ò».°²×°oracle ·þÎñ¶Ë
1.oracle·þÎñÆ÷µÄÏÂÔØÍøÖ·ÈçÏ£º
http://www.oracle.com/technology/software/products/database/index.html
È»ºóÎÒÑ¡ÔñÁËÏÂÃæÕâ¸ö°²×°°ü£º
Oracle Database 10g Release 2 ( ......