Database Administration (MOSC)

MOSC Banner

oracle 10g alter

edited May 13, 2018 1:33AM in Database Administration (MOSC) 14 commentsAnswered ✓

hello,

it's too odd to ask a question about 10g, we have plan to upgrade this database to 12.2 in next month..

but before that i got some error like this.  Does anyone come across this situation.  can we do something without database shutdown ?

I reset my password to 'temp123' for my id: ramya1

SQL> show user

USER is "SYS"

SQL> select version from v$instance;

VERSION

-----------------

10.2.0.3.0

SQL> alter user ramya1 identified by temp123tom;

User altered.

SQL> connect ramya1/ temp123tom

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center