当前位置:首页 » 操作系统 » cmdoracle数据库连接

cmdoracle数据库连接

发布时间: 2022-11-08 10:54:41

① 怎么在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

热点内容
随机启动脚本 发布:2025-07-05 16:10:30 浏览:515
微博数据库设计 发布:2025-07-05 15:30:55 浏览:19
linux485 发布:2025-07-05 14:38:28 浏览:299
php用的软件 发布:2025-07-05 14:06:22 浏览:750
没有权限访问计算机 发布:2025-07-05 13:29:11 浏览:425
javaweb开发教程视频教程 发布:2025-07-05 13:24:41 浏览:686
康师傅控流脚本破解 发布:2025-07-05 13:17:27 浏览:233
java的开发流程 发布:2025-07-05 12:45:11 浏览:678
怎么看内存卡配置 发布:2025-07-05 12:29:19 浏览:277
访问学者英文个人简历 发布:2025-07-05 12:29:17 浏览:828