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.
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.