Receiving error ORA-12154 when attemping to run "create_oracle_user.sql" from SQLPlus.

Products

• Data Loss Prevention Enforce
• Data Loss Prevention

Issue/Introduction

After finishing the installation of Oracle, the guide mentions the creation of the Symantec DLP schema owner (typically "protect") through the use of the "create_oracle_user.sql" script.  When attempting to run this script in SQLPlus, it rapidly throws the following error:

ERROR:
ORA-12154: TNS: could not resolve the connect identifier specified

SQL>

It may also throw a bunch of "SP2-" errors.

Resolution

ORA-12154 is a connectivity error.  It is usually associated with an invalid TNSnames.ora entry. 

In the Symantec DLP documentation link titled: Verifying tnsnames.ora contents the second step of verifying the TNS entry is:

2. Verify that the following lines are present in the file:

PROTECT =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <ip_address>)(PORT = <port_number>))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = protect)
    )
  )

If these lines do not exist, add them to the file, replacing <ip_address> and <port_number> with the correct values for your system.