oracle客户端登录数据库怎么填,怎么登录oracle数据库

首页 > 教育培训 > 作者:YD1662023-10-28 22:02:54

其他:关于配置文件tnsnames.ora

SID的方式:

DB_82_204 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)) ) (CONNECT_DATA = (SID = ora11g) ) )

service_name:

DB_82_233 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl.oracle11g.com ) ) )

这就要注意登录的时候数据库如何填写,是哪种方式:

ip:orcl sid ip/orcl servicec_name

也就是这边,由于我配置的是SERVICE_NAME = ORCL,所以IP/service_name(也就是ip/ORCL)

oracle客户端登录数据库怎么填,怎么登录oracle数据库(1)

栏目热文

文档排行

本站推荐

Copyright © 2018 - 2021 www.yd166.com., All Rights Reserved.