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

oracle 11g ORA 12514´íÎó£¬ÎҵĽâ¾ö°ì·¨

Ç°ÑÔ:ÍøÉÏÓкܶà½â¾ö°ì·¨£¬É¾listener.oraÒ²ºÃ£¬»¹ÊÇʲôҲºÃ£¬¶¼½â¾ö²»ÁËÎÒÕâ¸öÎÊÌ⣬ÒÀÈ»±¨12514´íÎó£¬ÒÔÏÂÊÇÎÒÖð¸ö³¢ÊÔºó³É¹¦µÄ¼àÌý×Ö·û´®¡£¡£
listener.oraÎļþ£º
# listener.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = cjtfs)   
      (ORACLE_HOME = d:\app\john\product\11.1.0\db_1)
      (PROGRAM = cjtfs)
    )
     (SID_DESC =
      (GLOBAL_DBNAME = cjtfs)
      (ORACLE_HOME = d:\app\john\product\11.1.0\db_1)
      (SID_NAME = cjtfs)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    )
  )
tnsnames.oraÎļþ£º
# tnsnames.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
CJTFS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cjtfs)   #ÒªºÍlistener.oraÀïÃæµÄcjtfsλÖõÄÃû×Ö±£³ÖÒ»ÖÂ
    )
  )
Èç¹û»¹½â¾ö²»ÁË£¬ÄǾÍÁôÑÔ£¬ÎÒÒ»°ã»á³£¿´blogµÄ¡£¡£¡£¡£´ó¼ÒÒ»Æð½â¾ö¡£¡£»¥Ïàѧϰ¡£


Ïà¹ØÎĵµ£º

oracleÖеÄÊÓͼ


create table a(
id number primary key,
name varchar2(20)
);
create table b(
id number,
name varchar2(20),
aid number references a(id)
);
insert into a values(1,'1');
insert into b values(1,'aaa',1);
Èç¹û create view vi_new as select * from a
ÔÚÊÓͼvi_new ÉÏ×öÈκΠdml²Ù×÷¶¼»áÐÞ¸Ä ¶ÔÓ¦µÄ ......

oracleÖд¥·¢Æ÷

´¥·¢Æ÷µÄÀàÐÍÓÐ:
¡¡¡¡´¥·¢Æ÷ÀàÐÍ£º           
¡¡¡¡1¡¢ Óï¾ä´¥·¢Æ÷
¡¡¡¡2¡¢ Ðд¥·¢Æ÷
¡¡¡¡3¡¢INSTEAD OF´¥·¢
¡¡¡¡4¡¢ ϵͳÌõ¼þ´¥·¢Æ÷
¡¡¡¡5¡¢ Óû§Ê¼þ´¥·¢Æ÷
Óï¾ä¼¶´¥·¢Æ÷.(Óï¾ä¼¶´¥·¢Æ÷¶Ôÿ¸öDMLÓï¾äÖ´ÐÐÒ»´Î)
ÊÇÔÚ±íÉÏ»òÕßijЩÇé¿öϵÄÊÓͼÉÏÖ´Ð ......

OracleÖ÷ÒªÅäÖÃÎļþ

Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£¨×ªÌû£©
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
    profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora
Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
              ......

Ïê½âOracleÓû§½âËøÃüÁîµÄÁ½ÔòʵÏÖ·½·¨

ÔÚ°²×°ÍêOracle
10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃ漸¸öÔ­Òò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨ ......

PHP ÖÐʹÓÃoracle »·¾³ÅäÖÃ

http://www.oracle.com/technology/global/cn/pub/notes/technote_php_instant.html
Ϊ Linux ºÍ Windows °²×° PHP ºÍ Oracle 10g Instant Client
×÷ÕߣºChristopher Jones£¬¼×¹ÇÎĹ«Ë¾µÄ×Éѯ¼¼ÊõÈËÔ±
·¢²¼ÈÕÆÚ£º2004 Äê 12 ÔÂ
Oracle 10g Instant Client£¨Ãâ·ÑÏÂÔØ£©ÊÇPHP ÓëÔ¶³Ì Oracle Êý¾Ý¿âÁ¬½ÓµÄ×î¼òµ¥·½Ê½£¬Ëü ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ