參考:https://blog.csdn.net/a657281084/article/details/49490069
https://my.oschina.net/hongjunzhan/blog/1553158
1.下載安裝OracleXE
2.檢查oracleXE和TNS服務是否啟動 (若TNS無法啟動枢步,則檢查環(huán)境變量的ORACLE_HOME,修改為oracle安裝目錄)
3.配置好listener.ora渐尿,tnsnames.ora
4.配置好環(huán)境變量TSN_ADMIN醉途,NLS_LANG,ORACLE_HOME等
5.常見問題
(1) ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
解決:startup
(2)執(zhí)行startup時又報錯:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
原因:dbs目錄下缺少spfileXE.ora
解決:create spfile='D:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora' FROM pfile='D:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora';
參考:http://www.orafaq.com/usenet/comp.databases.oracle.server/2005/12/14/1026.htm
(3)處理完以上兩部后砖茸,執(zhí)行SQL> startup 又有報錯:ORA-00205: ?????????, ??????, ???????
百度為文件損壞:參考http://blog.itpub.net/29876893/viewspace-1623346/
未解決隘擎,目前已經啟動示例,問題遺留