要远程连接对象的IP:192.168.1.172
我在tnsnames.ora文件中添加如此:
# tnsnames.ora Network Configuration File: d:\app\QOQ\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
#我的链接
myORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.172)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = QOQ-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
但结果是报ORA-01017: invalid username/password; logon denied
而我用本地ORCL数据库时可以正常登陆.
用户和密码我都是复制过来的,不可能有错.
希望又能帮解答,谢谢了.
我在tnsnames.ora文件中添加如此:
# tnsnames.ora Network Configuration File: d:\app\QOQ\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
#我的链接
myORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.172)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = QOQ-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
但结果是报ORA-01017: invalid username/password; logon denied
而我用本地ORCL数据库时可以正常登陆.
用户和密码我都是复制过来的,不可能有错.
希望又能帮解答,谢谢了.
2。确认服务器端是动态监听还是静态监听,如果是静态的话,去看一下它的lisener.ora
配置和你所连接的是否一致(service_name)
3.核对本地tnsnames.ora文件是否和服务器上的lisener.ora一致
"核对本地tnsnames.ora文件是否和服务器上的lisener.ora一致"这两个怎么一致?
2、检查SERVICE_NAME是否正确
我刚在隔壁的机器上远程那台,文件都一样,可以连接上去.注:隔壁这台也是Oracle 10g与远程的一致.
大家觉得呢 ?
oracle是向下兼容的,你用11g客户端可连接10g服务器
set oracle_sid=xxx
然后再登陆
删掉自己添加的数据库连接用netca自动添加。
然后再试试看是否有错误。