Oracle À俽±¸ÊµÀý¹Òµ½ÐÂORACLEʱӦעÒâÎÊÌâ¡£
À俽±¸ÁËÒ»¸öÔÓÐÊý¾Ý¿â£¬Òª°ÑËûÒÆÖ²µ½ÐµÄÊý¾Ý¿âÖÐʱ£¬Òª×¢Òâһϣº
1.Oradim -new -sid [ʵÀýÃû:demo] -intpwd [PWD] -pfile= [Òª´´½¨ÊµÀýµÄÅäÖÃÎļþ£º*.ora]
2.set Oracle_SID=[ʵÀýÃû]£¨×°Íêºó¼ÇµÃÒªÔÚ×¢²á±íÀï¼ÓÉÏ:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1£ºORACLE_SID£¬ÖµÎªÊµÀýÃû¡££©
3.sqlplus /nolog
4.conn sys/[PWD] as sysdba;
5.ÈçÏ£ºÊµÀýµØÖ·×ÔÐÐÐ޸ġ£
startup nomount pfile=C:\oracle\DEMO\initDEMO.ora;
create controlfile set database 'DEMO' resetlogs
LOGFILE
GROUP 1 'C:\oracle\DEMO\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\oracle\DEMO\REDO02.LOG' SIZE 10M,
GROUP 3 'C:\oracle\DEMO\REDO03.LOG' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'C:\oracle\DEMO\SYSTEM01.DBF',
'C:\oracle\DEMO\UNDOTBS01.DBF',
'C:\oracle\DEMO\SYSAUX01.DBF',
'C:\oracle\DEMO\USERS01.DBF',
'C:\oracle\DEMO\IFSAPP_DATA.DBF',
'C:\oracle\DEMO\IFSAPP_INDEX.DBF',
'C:\oracle\DEMO\IFSAPP_LOB.DBF',
'C:\oracle\DEMO\IFSAPP_REPORT_DATA.DBF',
'C:\oracle\DEMO\IFSAPP_REPORT_INDEX.DBF',
'C:\oracle\DEMO\IFSAPP_ARCHIVE_DATA.DBF',
'C:\oracle\DEMO\IFSAPP_ARCHIVE_INDEX.DBF'
CHARACTER SET AL32UTF8
;
alter database open resetlogs;
alter tablespace "TEMP" add tempfile 'C:\oracle\DEMO\temp01.dbf' size 100M;
Íê³ÉºóÒª¼ÇµÃ×öµÚ¶þ²½ºóÃæµÄ£¬²»È»²»ÄÜÓÃPLSQLÁ¬½Ó¡£
Á¬½Óʱ»á±¨£ºÊÊÅäÆ÷ÎÞЧ»ò¼àÌýÆ÷²»ÄÜÓõȵȴíÎó¡£
¶þ¡¢°²×°Íê³Éºó£¬È´²»ÄÜÔÚÆäËü»ú×ÓÁ¬½ÓÎÊÌâ¡£
Oracle ÕýÈ·°²×°ºó£¬Èç¹ûÆäËü»ú×ÓÁ¬½Óʱ±¨£º£¨ÎÞ¿ÉÓüàÌýÆ÷£©¡£ÕâÊÇÒòΪ¼àÌýÆ÷ûÓйҽӵ½ÊµÁеÄÔÒò£¬¿ÉÒÔÔÚ¼àÌýÆ÷¼ÓÈçÏÂÒ»¶Î¡£
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\10G)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = [ʵÀýÃû:DEMO])
(ORACLE_HOME = [Ê
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
×÷ΪÊý¾Ý¼¯³ÉµÄMOSS×é¼þBDC£¬ÔÚMOSS2007°æ±¾Öл¹Óкܶ಻³ÉÊìµÄµØ·½£¬ËäÈ»¿ÉÒÔ´æÈ¡ÆäËûÊý¾Ý¿âÖеÄÊý¾Ý£¬µ«ÅäÖÃȷʵºÜ¸´ÔÓ£¬È±Ê¡µÄ¹¤¾ßÒ²ºÜÈõ£¬ÕâÊÇÔÚÒ»¸öÏîÄ¿ÖÐÓõ½µÄÁ¬½ÓORACLEÊý¾Ý¿âÅäÖÃÎļþ£¬¼Í¼ÔÚ´ÎÒÔ±ãºóÓá£
<?xml version="1.0"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xm ......
ÎÒÔÚoracle 9iµÄ»·¾³Ï¿ª·¢ÁËocciµÄÓ¦Ó㬽á¹û·Åµ½10g(10.2.0.3)·þÎñÆ÷ÉÏÔËÐв»ÁË(Ö»×°ÁËwindows °æµÄ10g·þÎñ¶Ë)£¬Ö»ºÃ°ÑËùÓÐÒÀÀµµÄ9iµÄdll¿½¹ýÈ¥£¬½á¹ûÁ¬½Óocci±¨´í£º
Error while trying to retrieve text for error ORA-32101
µ½http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.ht ......