oracle ³õʼ»¯²ÎÊýÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
os windows 2003
dbms oracle 10g
ʹÓà host copy g:\oracle\product\10.2.0\db_1\srvm\admin\init.ora g:\oracle\product\10.2.0\db_1\database\initsky.ora
´´½¨ÁËÒ»¸öĬÈϵÄpfile Îļþ
È»ºó ʹÓÃsysµÇ½Êý¾Ý¿â
create spfile='spfilesky.ora' from pfile='g:\oracle\product\10.2.0\db_1\database\initsky.ora';
´´½¨¶¯Ì¬²ÎÊýÎļþʱ±¨´í
µÚÒ»ÐгöÏÖ´íÎó
ora-01078:´¦Àíϵͳ²ÎÊýʧ°Ü
ora-32003:´¦Àí²ÎÊý'distributed_transactions'ʱ³ö´í
lrm-00101:umknown parameter name 'distributed_transactions'
¸ÃÔõô°ì
лл ½â¾öÁË£¡£¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......