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×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨Ë ......
analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......
ÈçºÎ½â¾öORA-00054×ÊÔ´Õý棬ҪÇóÖ¸¶¨NOWAIT£¿
²éÔÄ´íÎó´úÂëÖ¸ÄϺóÓÐÈçÏÂÌáʾ£º
ORA-00054 resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Tr ......
Oracle 11gµÄLinux°æ±¾ÔÚÐÞ¸ÄÁËMEMORY_TARGET»òÕßSGA_TARGETºóÆô¶¯¿ÉÄܻᱨ´í£º
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
Õâ¸öÎÊÌâÊÇÓÉÓÚÉèÖÃSGAµÄ´óС³¬¹ýÁ˲Ù×÷Ï ......