This content has been marked as final. Show 3 replies
Let's assume the following:
1)you are using Linux
2)and your hostname is myhost
3)and your sys password is mysyspassword
4)the new hr password is hr
From the command line write the following
If the question is answered, please close it as answered and give the points where earned ...
[oracle@myhost ~]$ sqlplus sys/mysyspassword as sysdba SQL*Plus: Release 126.96.36.199.0 Production on Sun Feb 10 09:50:04 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - Production With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> alter user hr identified by hr; User altered.
using window 7 ?
No difference, just use SQLPlus of the installed instance1 person found this helpful
and use connect
connect sys/mysyspassword as sysdba
SQL> alter user hr identified by hr;