Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Öд¥·¢Æ÷

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

oracleÊý¾Ý¿âÎļþÔÚ´ÅÅÌÖеÄÒƶ¯

1¡¢¹Ø±ÕÊý¾Ý¿â >>shutdown immediate;
2¡¢¿½±´Îļþ£¨*.dbf)µ½Ä¿µÄÎļþ¼Ð;
3¡¢Æô¶¯Êý¾Ý¿â >>startup mount;
4¡¢¸ü¸Ä·¾¶
>>alter database rename file 'C:\oracle\oradata\global\USERS01.DBF' to 'D:\oracle\USERS01.DBF';
>>alter database rename file 'C:\oracle\oradata\global\UNDOTBS ......

oracleѧϰ£¨´´½¨±í£©

ÎÒÏë×î³õѧϰÊý¾Ý¿âʱ¶¼ÊÇÒÔstudent±í¡¢course±íºÍsc±íΪÀýµÄ°É
Ê×ÏÈ´´½¨ÕâÈýÕÅ±í£º±ØҪʱ¿ÉÖØд´½¨Óû§¼°ÃÜÂë²¢µÇ½
»·¾³£ºoracle 10g
declare
  vcnt number;
begin
  select count(*) into vcnt from user_tables where table_name='SC';
  If vcnt = 1 Then
    Execute immedi ......

Oracleµ¼Èëµ¼³öÊý¾Ý¿â

µ¼³öÊý¾Ý¿â£ºexp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÅÌ·û£º/Îļþ¼Ð/ÎļþÃû.bmp owner=Óû§ »ò exp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÅÌ·û£º/Îļþ¼Ð/ÎļþÃû.bmp full=y
µ¼ÈëÊý¾Ý¿â£ºimp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=µ¼³öµÄÎļþ full=y ......

BEA Weblogic92 ÅäÖÃOracleÁ¬½Ó³Ø

Ò»¡¢
´ò¿ª¿ØÖÆ̨£º
´ò¿ª http://localhost
:7001/console

£¬Æô¶¯¹ÜÀí¿ØÖÆ̨¡£ÊäÈë¹ÜÀíÔ±Óû§ÃûºÍÃÜÂ루ĬÈÏ£ºweblogic/weblogic£©¡£
¶þ¡¢´´½¨
JDBCÊý¾ÝÔ´£º
1¡¢
µ¥»÷“Ëø¶¨²¢±à¼­
”°´Å¥£»
2¡¢
ÔÚ“Óò½á¹¹
”Ê÷ÖУ¬Õ¹¿ª“·þ
Îñ”>“JDBC”
£¬È»ºóÑ¡Ôñ“Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ