In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U. You recreate the password file:

$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5 Examine the command and result:

$ sqlplus u1/Oracle_4U@testdb as sysdba ERROR:

ORA-01017: invalid username/password; logon denied What can you do to fix this error?

Question

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U. You recreate the password file:

$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5 Examine the command and result:

$ sqlplus u1/Oracle_4U@testdb as sysdba ERROR:

ORA-01017: invalid username/password; logon denied What can you do to fix this error?

Accepted Answer

A. Recreate the password file with the password set to Oracle_4U.

Answer

B. Change the password of U1 to Oracle_123.

Answer

C. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

Answer

D. Regrant SYSDBA to U1.

Answer

E. Restart the database instance.

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U. You recreate the password file: $ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5 Examine the command and result: $ sq