cmdoracle資料庫連接
① 怎麼在CMD中輸入命令，查看資料庫oracle是否連接好
1、windows+R，輸入CMD點擊確定。
② cmd連接遠程oracle資料庫
您好，提問者：
這樣可以是可以，但是如果那個機器沒有安裝或者配置oracle環境變數就找不到了。
用.bat腳本的時候先檢查一下環境變數是否有這個路徑存在，如果沒有就提示，有就連接。
③ cmd命令連接oracle資料庫連接到三個字為什麼是亂碼
cmd命令窗口字元編碼不一致或不兼容。
1、查一下伺服器端的字元集。
2、把客戶端的字元集設置為一致的。
3、你要用sqlplus的話，先通過設置環境變數來定義客戶端的字元集。
④ 如何用cmd命令連接oracle資料庫
1，非集群下 Windows環境下資料庫
conn scott/[email protected]:1521/orcl
conn scott/123456@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =
(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =
(SERVER = DEDICATED)(SERVICE_NAME = orcl)))
Linux環境下資料庫
conn scott/123@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST
= 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =
orcl)))
2，集群下連接
conn scott/123@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE = yes)(FAILOVER = on)
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=
(PROTOCOL=TCP)(HOST=127.0.0.2)(PORT=1521)))(CONNECT_DATA=(SERVER=default)
(SERVICE_NAME=orcl)))
(4)cmdoracle資料庫連接擴展閱讀
在命令行中登錄oracle資料庫：
sqlplus username/password 如：普通用戶登錄 sqlplus scott/tiger
sqlplus username/password as sysdba 如：sqlplus sys/admin as sysdba
sqlplus username/password@net_service_name 如: sqlplus scott/tiger@orcl
sqlplus username/password@//host:port/sid
⑤ 如何用命令行連接oracle資料庫
1，非集群下 Windows環境下資料庫
conn scott/[email protected]:1521/orcl
conn scott/123456@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =
(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =
(SERVER = DEDICATED)(SERVICE_NAME = orcl)))
Linux環境下資料庫
conn scott/123@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST
= 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =
orcl)))
2，集群下連接
conn scott/123@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE = yes)(FAILOVER = on)
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=
(PROTOCOL=TCP)(HOST=127.0.0.2)(PORT=1521)))(CONNECT_DATA=(SERVER=default)
(SERVICE_NAME=orcl)))
(5)cmdoracle資料庫連接擴展閱讀
在命令行中登錄oracle資料庫：
sqlplus username/password 如：普通用戶登錄 sqlplus scott/tiger
sqlplus username/password as sysdba 如：sqlplus sys/admin as sysdba
sqlplus username/password@net_service_name 如: sqlplus scott/tiger@orcl
sqlplus username/password@//host:port/sid