我远程链接朋友机子上面的 ORACLE 不成功。
报错为：ORA-01017: invalid username/password; logon deniedC:\>sqlplus sys/mq123456 @//192.168.0.130:1251SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 3月 25 10:10:46 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:
ORA-01017: invalid username/password; logon denied希望高手给与我指教。如果不对能否给我一个 ORACLE 远程链接的步骤详细点的。谢谢
报错为：ORA-01017: invalid username/password; logon deniedC:\>sqlplus sys/mq123456 @//192.168.0.130:1251SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 3月 25 10:10:46 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:
ORA-01017: invalid username/password; logon denied希望高手给与我指教。如果不对能否给我一个 ORACLE 远程链接的步骤详细点的。谢谢
正确方法如下:
d:\>sqlplus sys/[email protected]:1521/ora11g as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on 星期三 3月 25 10:36:59 2009Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing optionssys@ORA11G> show user
USER 为 "SYS"
sys@ORA11G>
用sys登录的话
sqlplus sys/mq123456 @192.168.0.130:1251 as sysdba
或者用普通的用户
sqlplus user/[email protected]:1251
C:\>sqlplus sys/[email protected]/orcl as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 27 11:03:54 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:
ORA-12170: TNS: 连接超时
请输入用户名:是不是服务器的原因，如果是服务器的问题，那该如何去配置服务器呢？谢谢