ORA-01017: Invalid username/password when creating Oracle database

Products

• Data Loss Prevention

Issue/Introduction

When specifying the protect service name, username, and password, there is error: Error calling OCISessionBegin: ORA-01017: Invalid username/password; logon denied

Cause

Protect user was not created

Resolution

During the Oracle installation the Hostname is specified. If the wrong hostname is entered, the Oracle installation will continue but the protect user will not be created when the oracle_create_user.sql script is run.

To resolve this, edit the %ORACLE_HOME%\network\admin\tnsnames.ora file to make sure the HOST entry is correct and resolvable. Then re-run the oracle_create_user.sql script with the following command from the cmd prompt.

sqlplus .nolog @oracle_create_user.sql