Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¹À¼ÆÊÇÊÖ¹¤ÐÞ¸ÄÁËÃû³Æ¡£


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleÔËÐÐÃüÁî´óÈ«

net use \\ip\ipc$ " " /user:" " ½¨Á¢IPC¿ÕÁ´½Ó
net use \\ip\ipc$ "ÃÜÂë" /user:"Óû§Ãû" ½¨Á¢IPC·Ç¿ÕÁ´½Ó
net use h: \\ip\c$ "ÃÜÂë" /user:"Óû§Ãû" Ö±½ÓµÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use h: \\ip\c$ µÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use \\ip\ipc$ /del ɾ³ýIPCÁ´½Ó
net use h: /del ɾ³ýÓ³Éä¶Ô·½µ½±¾µ ......

ɱËÀOracleÊý¾Ý¿âÖпͻ§¶ËÓû§Á¬½Ó½ø³Ì

<Ò»>ʵÏÖɱËÀij¸öÓû§µÄ¿Í»§¶ËÁ¬½Ó½ø³Ì
1.ÒÔ¹ÜÀíÔ±Éí·ÝµÇ¼ºó²é¿´V$SESSIONµÄÊÓͼ½á¹¹
SQL> desc v$session;
 Ãû³Æ                             &n ......

ORACLE ±¾µØ¹ÜÀí±í¿Õ¼äÓë×Öµä¹ÜÀí±í¿Õ¼äµÄ±È½Ï


±¾µØ¹ÜÀí±í¿Õ¼äÓë×Öµä¹ÜÀí±í¿Õ¼äÏà±È´ó´óÌá¸ßÁ˹ÜÀíЧÂʺÍÊý¾Ý¿âÐÔÄÜ£¬ÆäÓŵãÈçÏ£º
1.¼õÉÙÁ˵ݹé¿Õ¼ä¹ÜÀí
±¾µØ¹ÜÀí±í¿Õ¼äÊÇ×Ô¼º¹ÜÀí·ÖÅ䣬¶ø²»ÊÇÏó×Öµä¹ÜÀí±í¿Õ¼äÐèҪϵͳÀ´¹ÜÀí¿Õ¼ä·ÖÅ䣬±¾µØ±í¿Õ¼äÊÇͨ¹ýÔÚ±í¿Õ¼äµÄÿ¸öÊý¾ÝÎļþÖÐά³ÖÒ»¸öλͼÀ´¸ú×ÙÔÚ´ËÎļþÖпéµÄÊ£Óà¿Õ¼ä¼°Ê¹ÓÃÇé¿ö¡£²¢¼°Ê±×ö¸üС£ÕâÖÖ¸üÐÂÖ»¶Ô ......

OracleÌṩÁË·ÖÇø¼¼Êõ(»ã×ÜÌû)

OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£ 
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ