問題描述:sqlplus /nolog
conn sys/XXX as sysdba;
create user bnx identified by bnx;
grant create session to bnx; grant dba to bnx;
cmd e:/
imp bnx/[email protected] file=d:/test.dmp full=y;
導入庫後在plsql連接配接不上庫,報辨別符無效或連接配接逾時
plsql連接配接不上,需要檢查的有以下幾步:
1.oracle服務,監聽是否已啟動.
2.netmanager中是否有服務命名,我的就沒有這個,奇怪,控制台
3.檢查是否能連上資料庫 cmd-tnsping orcl (127.0.0.1)
出現 "已使用tnsnames擴充卡來解析别名",說明沒有問題
4.使用者是否能連上 cmd -sqlplust -bnx(使用者名)-bnx(密碼)
5.oracle-network-admin-tnsnames.ora中配置的辨別不正确,本地就用orcl就可以了(我的機子是這樣的),
沒必要再去寫一樣的配置,而辨別符不同
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-201101172021)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
bnx=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
這樣寫會重複,沒必要寫隻要用orcl連接配接就可以