My Oracle Support Banner

REP-501/ORA-12162/ORA-03147 When Executing With Password Containing "$" Special Character; SQL*Plus Okay (Doc ID 2391464.1)

Last updated on APRIL 27, 2018

Applies to:

Oracle Reports Developer - Version to [Release 12c to 12.2]
Information in this document applies to any platform.


Using Reports 12.2.1.x, when try to convert .rdf to .rep using, it fails with errors:


REP-0501: The specified database cannot be connected.
ORA-12162: TNS:net service name is incorrectly specified

If TWO_TASK is set, then error is:

REP-0501: The specified database cannot be connected.
ORA-03147: Missing mandatory TTC field

However, same connect string works with SQL*Plus:


New install of Fusion Middleware / Oracle Reports


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.