ORA-01017 invalid username and password on remote connection.
citicbjDec 17 2009 — edited Dec 18 20091. 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.