PCC-F-02104, Unable to Connect to Oracle When Precompiling And Not Using a Password (Doc ID 1326948.1)

Last updated on MARCH 23, 2017

Applies to:

Precompilers - Version 10.2.0.5 to 12.1.0.1 [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 23rd Mar 2017 ***

Symptoms

When precompiling with SQLCHECK=SEMANTICS it is required to connect to the Database in which the USERID option contains the connection information.

When doing so, the PCC-F-02104 error is returned when only the username and dbname are used in the USERID parameter (no password) during precompiltaion.

The following illustrate an example. Notice that only the username (scott) and connect string (Connect1) is used. The password is not included.


> proc sqlcheck=SEMANTICS userid=scott@Connect1 iname=sample1

Pro*C/C++: Release 10.2.0.5.0 - Production on Tue Apr 5 18:09:09 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

System default option values taken from:
/refresh/64bit/app/oracle/product/10.2.0.5.0/precomp/admin/pcscfg.cfg

Password:
PCC-F-02104, Unable to connect to Oracle

Using the same format "scott@Connect1" works with SQL*Plus (sqlplus scott@Connect1).

The following combinations will work during precompilation

userid=scott/tiger@Connect1 
userid=scott

 

Cause

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 hundreds of Community platforms