When connecting to the Oracle DBA studio in standalone mode I reeive the following message below. I have tried to add a database manually with Hostname MY_PC, Port Number 1521, SID Little, Net service name of Little or Little.world.
Oracle Enterprise Manager
Failed to parse tnsnames.ora file
Error: 100 -- NLNV-NLNV String Format Error
The first column of any SQL*Net/Net8 configuration file marks the beginning of a whole new entry in the file. White space in
the first column marks that this line a continuation of the previous line. Ensure that the first column is the start of a net service name.
Remove/Rename the existing TNSNAMES.ORA file and recreate the file with the Net8 Assistant tool.
Cause of the Problem:
When the "EM Tools" parse the TNSNAMES.ORA file, it is finding either a white space in the very first position or something else has corrupted your files. Please recreate the TNSNAMES.ORA file either with Net8 Configuration Assistant or manually and make sure the first position of the file is not a space or blank line
The following is the workaround for this:
Workaround was to first use a net8 generated tnsnames file, then once your OEM is working, you can "trick it" and replace the net8 generated tnsnames file with the original one that you wanted to use.