ÇóÖú oracle 10g Á¬²»ÉÏ ÄÄλÅóÓÑ°ïæ½â¾öÒ»ÏÂ
Ï£Íû¸ßÊÖ¿ÉÒÔ°ïæһÏ ²»Ê¤¸Ð¼¤
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on ÐÇÆÚËÄ 5ÔÂ 20 17:23:05 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn system/manager as sysdba;
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£
SQL> conn scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
¾¯¸æ: Äú²»ÔÙÁ¬½Óµ½ ORACLE¡£
SQL>
Ïà¹ØÎĵµ£º
Ôì³ÉORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎóµÄÎÊÌâµÄÔÒòÓÐÈý¸ö£º
1.¼àÌý·þÎñûÓÐÆðÆðÀ´¡£windowsƽ̨¸öÒ»ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å,Æô¶¯oraclehome92TNSlistener·þÎñ¡£
2.database instanceûÓÐÆðÆðÀ´¡£windowsƽ̨ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å£¬Æô¶¯oracleserviceXXXX ......
Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔÒò¡£ÔÚÕâƪÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖƵĻù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......
OracleÈ«ÎÄË÷ÒýµÄ»ù±¾ÖªÊ¶
Ò»¡¢ÀúÊ·±³¾°
OracleÊý¾Ý¿âµÄÈ«ÎļìË÷¼¼ÊõÒѾ·Ç³£ÍêÃÀ£¬Oracle TextʹOracle9i¾ß±¸ÁËÇ¿´óµÄÎı¾¼ìË÷ÄÜÁ¦ºÍÖÇÄÜ»¯µÄÎı¾¹ÜÀíÄÜÁ¦¡£Oracle TextÊÇOracle9i²ÉÓõÄÐÂÃû³Æ£¬ÔÚOracle8/8iÖÐËü±»³Æ×÷Oracle interMedia Text£¬ÔÚOracle8ÒÔÇ°ËüµÄÃû³ÆÊÇOracle ConText Cartridge¡£
¶þ¡¢Oracle Text Ë÷Ò ......
1.desc(ÃèÊö£© emp ÃèÊöempÕâÕűí
2.desc dept ²¿Ãűí
3.desc salgrade нˮµÈ¼¶
4.select *from table ²éÕÒ±íÖеÄÔªËØ
5.dual &nbs ......