oracle資料庫的cmd指令,CMD指令下通路Oracle資料庫

1.非叢集下 Windows環境下資料庫

127.0.0.1 隻是個IP代表  實際要輸入你要通路的資料庫伺服器IP位址的

如果資料庫伺服器不在本機上，需要加上資料庫伺服器的位址：[email protected]/資料庫名稱。

①運作->cmd

sqlplus/nolog 然後

第一種方式 ：conn [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)))

叢集下連接配接

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)))

原文：http://www.cnblogs.com/Warmsunshine/p/4997627.html