Oracle³£¼û´íÎó——TNS 01150
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.26)(PORT = 1521)
)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ora92)
(ORACLE_HOME = /opt/oracle/product/9.2)
)
)
LOGGING_LISTENER = OFF
ÎÒ²¹³äÕûÀíһϣ¬listener.oraÀï´´½¨µÄÿ¸ölistener¶ÔÓ¦2¸ö²¿·Ö£¬·Ö±ðÊÇ£º
NAME=
ºÍ
SID_LIST_NAME=
Á½¸ö²¿·ÖÃû³Æname±ØÐëÒ»Ö£¬LZ¹À¼ÆÊÇÊÖ¹¤ÐÞ¸ÄÁËÃû³Æ¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Close a Database
When you close a database, Oracle writes all database data and recovery data in the SGA to the datafiles and redo log files, respectively. Next, Oracle closes all online datafiles and redo log files. (Any offline datafiles of any offline tablespaces have been closed already. If you ......
±¾µØ¹ÜÀí±í¿Õ¼äÓë×Öµä¹ÜÀí±í¿Õ¼äÏà±È´ó´óÌá¸ßÁ˹ÜÀíЧÂʺÍÊý¾Ý¿âÐÔÄÜ£¬ÆäÓŵãÈçÏ£º
1.¼õÉÙÁ˵ݹé¿Õ¼ä¹ÜÀí
±¾µØ¹ÜÀí±í¿Õ¼äÊÇ×Ô¼º¹ÜÀí·ÖÅ䣬¶ø²»ÊÇÏó×Öµä¹ÜÀí±í¿Õ¼äÐèҪϵͳÀ´¹ÜÀí¿Õ¼ä·ÖÅ䣬±¾µØ±í¿Õ¼äÊÇͨ¹ýÔÚ±í¿Õ¼äµÄÿ¸öÊý¾ÝÎļþÖÐά³ÖÒ»¸öλͼÀ´¸ú×ÙÔÚ´ËÎļþÖпéµÄÊ£Óà¿Õ¼ä¼°Ê¹ÓÃÇé¿ö¡£²¢¼°Ê±×ö¸üС£ÕâÖÖ¸üÐÂÖ»¶Ô ......
¸ù¾ÝǰЩÌìΪij´ó·É»ú¹«Ë¾µ¼Èëij´ó·É»úÉú²úÊý¾ÝµÄ¾Àú£¬×¼±¸Ð´Æª¹ØÓÚOracleµ¼³öÎļþDMP¸ñʽµÄ·ÖÎö£¬½á¹ûÔÚ±¾»úµ¼³öÒ»×éÑÝʾÊý¾Ýʱºò£¬³öÏÖÁË´íÎó£¬Ë³±ã½â¾öÏ¡£
±¾»ú×°µÄÊÇOracle 11g 32bit(11.0.6)µÄClient£¬Ö÷ÒªÊÇΪÁËʹÓÃODT.Net 11.0.6.21£¬Ö§³ÖVS2008¡£µ«ÊDzÉÓÃEXPÃüÁîµ¼³öÊý¾Ý¿âµÄʱºò£¬³öÏÖÁËЩ¹îÒìµÄ´íÎó¡£
Ö´Ð ......