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

oracle°²×°ÎÊÌâ

1.
  ÔÚ°²×°µÄʱºò°²×°µÄoracle 9i release¡£¡£¡£ÊÇ·ñÓ¦¸Ã°²×°Õâ¸ö°æ±¾£¬ÔÙ°²×°¹ý³ÌÖгöÏÖoracle net configuration assistantÅäÖÃÄ£¿é£¬ÊäÈëÖ÷»úºÅºÍ¶Ë¿ÚºÅÒÔ¼°sll¶Ë¿ÚºÅ£¬²»ÖªµÀÊÇʲôÎÊÌâ¡£

2.
  SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 16:58:03 2009

  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


  ERROR:
  ORA-12560: TNS: ЭÒéÊÊÅäÆ÷´íÎó


  ÕâÊÇʲôÎÊÌ⣿³õѧ£¬Çë¶àÖ¸½Ì¡£


ÍøÉϵݲװͼ½â¸úÎÒ°²×°Ê±µÄ²»Ò»Ñù£¬¶àÁ˼¸¸ö»·½Ú£¬ÎÒÏÂÔØµÄºÃÏñÊÇOracle9i Database Release2 Client for Windows98_NT_2000_XP£¬Õâ¸ö°æ±¾ÓëOracle9i Database Release2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP/2003ÓÐÇø±ðÂð£¿

ÄãϵÄÊDz»Ö»ÊÇOracleµÄ¿Í»§¶Ë£¿ÓзþÎñÆ÷µÄ»°£¬Åätnsnames.ora¡£

Ó¦¸Ã¾ÍÊǿͻ§¶ËÁË£¬»»¸ö°æ±¾µÄ£¬µ½ÄÄÀïÈ¥ÏÂÔØ±È½Ï·½±ã?



Â¥Ö÷ҪװµÄÓ¦¸ÃÊÇ·þÎñ¶Ë¡£

Oracle9i ¹Ù·½ÏÂÔØµØÖ·
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html

10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html

11gµÄ²»ÊÇÊý¾Ý¿â°É£¬ºÃÏñÊÇʲôÉÌÒµÌ×¼þ£¬ÎÒÊdzõѧoracle£¬Ö÷ÒªÊÇÏȶÔÊý¾Ý¿âÓïÑÔÓиöºÜºÃµÄÁ˽⣬Äĸö°æ±¾¶¼¶ÔÎҴ´ÂÓÐÓàÁË£¬Èç¹ûÕÆÎÕÁË10gÄÇ9iÒ²²»³ÉÎÊÌâÁ˰ɣ¬ÎÒÏëÖªµÀÏÖÔÚÉç»áÉϵÄÖ÷Á÷ÊÇʹÓõÄÄǸö°æ±¾£¬¾Ý˵10gµÄbug±È½Ï¶à£¬²»ÖªµÀ»á²»»á¶ÔÒÔºóµÄǰ¾°ÓÐËùÓ°Ï죿

1¡£Ä¬ÈÏÅäÖðÉ

2.ÄãûÓÐÅ


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

ÇëÎÊΪʲôOracle¼àÌýºó»áÓдóÁ¿µÄµÈ´ýÁ¬½Ó£¿

ÏÂÃæÊǸոÕÖØÆôºóÔËÐÐnetstatµÄ½á¹û£¬ÕªÂ¼ÁËÆäÖÐÓë1521¶Ë¿ÚÓйصIJ¿·Ö

  TCP    tky-026e3e945e8:1055  localhost:1521        ESTABLISHED
  TCP  ......

OracleÆ´½Ó×Ö·û´®ÎÊÌâ

select A_NM || '----' || B_NM
  from (select distinct a.sttn_nm a_nm, b.sttn_nm b_nm
          from tb_sttn a, tb_sttn b
        whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ