1.將兩個(gè)壓縮包同時(shí)選中解壓,點(diǎn)擊setup直接安裝,安裝完后修改兩個(gè)文件:
D:/XX/PRoduct/11.2.0/dbhome_1/NETWORK/ADMINlistener:(SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (Oracle_HOME = D:/app/201610201/product/11.2.0/dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:/app/201610201/product/11.2.0/dbhome_1/bin/oraclr11.dll") ) 加入下面內(nèi)容: (SID_DESC = (SID_NAME = ORCL) (ORACLE_HOME = D:/app/201610201/product/11.2.0/dbhome_1) (ENVS = "EXTPROC_DLLS=ONLY:D:/app/201610201/product/11.2.0/dbhome_1/bin/oraclr11.dll") ) )tnsnames:全部修改為:HOST = 127.0.0.1
2.打開plsql-工具-首選項(xiàng)-檢查連接
3.登錄:sqlplus 用戶名:sys 密碼 as sysdba 連接到oracle4.新建用戶 create user XX identified by XX 授權(quán) grant dba to fXX5.導(dǎo)入dmp:cmd-imp XX/XX@orcl file="D:/2015.dmp" full=y;(dos命令非oracle命令)6.登錄:XX XX 127.0.0.1:1521/ORCL7.安裝myeclipse:安裝目錄為:C:/tools/Genuitec 也可修改配置文件myeclipse.ini項(xiàng)目導(dǎo)入-取消校驗(yàn)(vaidation,showView-navigator-.project)-修改xml中地址,全部改為127.0.0.1 XX XX
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注