Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER USER sys IDENTIFIED BY new_password; not working

BsiennApr 14 2014 — edited Apr 15 2014

HI all!

I have seen many post about this but non of them is working.

I am very new to oracle, basically not yet started bcoz the environment is not installed/working.

I have installed Oracle database 12c EE for learning purpose.

during installation it asked for location & database name and password.

the default databasename was orcl. i left it as it is. and entered aRootPass as password.

but i can only login thorough sqlplus system/aRootPass

or in sql developer also with with same credential. but not with sys/sysdba with aRootPass as password.

But when i do sqlplus / as sysdba i can login into sqlplus but not able to connect in sql developer.

after sqlplus / as sysdba

i tried this query:

ALTER USER sys IDENTIFIED BY sysNewPass;

output => user altered

but i cannot login in sqlplus or developer. with sqlplus sysdba/sysNewPass

ORA-01017: invalid username/password; logon denied

please guide.

This post has been answered by Bsienn on Apr 15 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2014

Added on Apr 14 2014

#oracle-sql-developer-japanese, #password, #sqldeveloper, #sqlplus, #開発ツール製品

2 comments

24,330 views