Error: "TNS-04610: NO LITERALS LEFT, REACHED END OF NV PAIR"

book

Article ID: 160384

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

After starting the EnforceServerMigrationUtility, TNS-04610: NO LITERALS LEFT, REACHED END OF NV PAIR, is reported in the EnforceServerMigrationUtility log

Cause

Possible causes:

  • Bad or missing TNSNAMES.ORA file.
  • Oracle InstantClient installed instead of Administrator client
  • JDBC connection string is too long, or contains too many parameters.

Resolution

Ensure the full oracle client is installed and TNSNAMES.ORA file has been created.

Ensure the jdbc.properties connection string contains HOST, PORT, and SERVICE_NAME (all lower case) with no spaces before or after any equals sign.

The string must also end with exactly three parenthesis in order to be read in to the migrator properly.