I have a log-in problem. I created the new database and when I try to log-in with system user, its giving ORA-01017: invalid username/password; log-in denied, and when I try to log-in with "/ as sysdba" its successfully logged in.
When I try to change SYSTEM user password, I successful change and connecting and after few seconds when I try to connect its again giving same error "ORA-01017: invalid username/password; log-in denied
And I disable the case sensitive password also:
sec_case_sensitive_logon boolean FALSE
Oracle Versions: 18.104.22.168.0
Since you can successfully log in as sysdba, the SID you are using should be the correct one.
Also make sure you are not connecting to a wrong DB as sysdba.
Are you using SQL Developer, TOAD or connecting through JDBC connection ?
Some times old jdbc driver versions give ORA-01017 error.
I found that, actually I am trying to import "impdp" the user's data from production database to test database, here I found when I am trying to "impdp" ,it changing the default database password.
Ex: let as assume
the production database password: production123
the test database password: test123
but when I try to Import "impdp" production to test database:
F:\expdp>impdp directory=expdp dumpfile=21092013_JICLIBDB.DMP logfile=imp_sirsi.log remap_schema=sirsi:test statistics=none
its successfully the impdp command..but no data was import to user..and the test database password also changing to "production123"
please suggest me.