Receiving error ORA-12154 when attemping to run "create_oracle_user.sql" from SQLPlus.
Last Updated July 03, 2010
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
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.
On page 21 of the Symante_DLP_Oracle_Guide.pdf for version 10.x of Symantec DLP the second step of verifying the TNS entry is:
2. Verify that the following lines are present in the file: