14 Replies Latest reply: Dec 18, 2009 4:58 PM by sb92075 RSS

    ORA-01017 invalid username and password on remote connection.

    citicbj
      1. Server: Windows 2003 service Pack 2 64 bit
      2. Oracle 10.2.0.4

      I created a new database and setup everything. Database is up running. At second day, I tried to connect this database from a remote client laptop. A normal user connection is working (I changed sqlnet.ora file to SQLNET.AUTHENTICATION_SERVICES = (NONE)). but I couldn't connect as SYS or SYSTEM users through SQLPLUS or Third party SQL tool. It gave me ORA-01017 error. My steps like:

      C:> set Oracle_sid=mydb
      C:>sqlplus /nolog
      SQL:>conn sys/syspassword as sysdba

      ORA-01017

      However, I remotely log on to server machine, do the same steps

      C:> set Oracle_sid=mydb
      C:>sqlplus /nolog
      SQL:>conn sys/syspassword as sysdba
      SQL:> connected

      What caused this error from remote client connection. I have done some search to resolve the problem. Some suggest to re-create password file or create OPS$user. I just setup SYS password during database creation. So I don't want to re-create password file. I have another client machine in office that can connect as SYS and SYSTEM users either from server or from SQLPLUS on client machine without problem. So the issue is on my laptop that is connected to database remotely. Please give me some advices. Thanks.