If you do not know the password for the System,sys user in Oracle, you can retrieve it as follows:
First, the database is entered as a regular user:
Execute the following command in Sql*plus:
Sql>connect/as Sysdba (can also be connected in the following way: Sql>connect internal)
Sql>alter user sys identified by SYS; (The password for user sys will change to SYS after carriage return)
Similarly, you can change the system password
Sql>alter user system identified by system; (The password for user system will be changed to system) after carriage return
sql> alter user Scott account unlock (Unlock command)
Using the operating system certification
Conn/as SYSDBA
To modify the password for SYS
Test OK under windows
Oracle®database Express Edition Getting Started Guide
10g Release 2 (10.2)
-----------------------------------------------------------------------------------------------------
Enter SELECT * FROM V$pwfile_users with DBA login. You can query which user DBA or SYSDBA permissions.