Skip to Main Content
  • Questions

  • 12c Pro*C precompiler no longer supports ezconnect syntax?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Scott.

Asked: February 20, 2017 - 10:57 pm UTC

Last updated: February 23, 2017 - 2:33 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hi Tom,

Did Oracle remove support for the ezconnect connect syntax in the userid= option on the 12c Pro*C precompiler?

I recently attempted to update a Pro*C application that is compiled using the instant client and precompiler (instantclient-precomp-linux.x64-12.1.0.2.0.zip) that I downloaded with the instant client. However, when I went to recompile my .pc file using my usual sqlcheck=symantics and userid=login/password@//server/service option, I kept getting a PCC-F-02104 error. I was able to connect just fine using the instantclient-sqlplus using the same connect string. When I switched back to the 11gR2 instant, all is well again.

I tried different variations and used wireshark to see if 'proc' was even trying to connect to the database server. It was not. However, if I removed the '//' as user/pass@server/service, then I did see a request to the database server but without any service information and so it was rejected.

It is a known issue?

Thanks,

Scott

and Connor said...

I've replicated your issue

[oracle@vbgeneric ~]$ touch x.pc
--
-- works with TNS
--
[oracle@vbgeneric ~]$ proc userid=scott/tiger@np12 sqlcheck=full iname=x.pc oname=x.c

Pro*C/C++: Release 12.1.0.2.0 - Production on Mon Feb 20 22:14:52 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

System default option values taken from: /u01/app/oracle/product/12.1.0.2/db_1/precomp/admin/pcscfg.cfg

--
-- not with EZ
--

[oracle@vbgeneric ~]$ proc userid=scott/tiger@//192.168.1.10:1522/np12 sqlcheck=full iname=x.pc oname=x.c

Pro*C/C++: Release 12.1.0.2.0 - Production on Mon Feb 20 22:15:14 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

System default option values taken from: /u01/app/oracle/product/12.1.0.2/db_1/precomp/admin/pcscfg.cfg

PCC-F-02104, Unable to connect to Oracle

--
-- but sqlplus fine
--

[oracle@vbgeneric ~]$ sqlplus scott/tiger@//192.168.1.10:1522/np12

SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 20 22:16:59 2017

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

Last Successful login time: Mon Feb 20 2017 22:14:54 -05:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options


Unfortunately the docs just say

"To connect to the Oracle server, specify the USERID option on the command line, using the syntax: USERID=username/password"

so there's some ambiguity there. I suggest you log a call with Support.

As a workaround, you could try

TWO_TASK=//blah/service
proc userid=user/pass


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Oracle has worst installation docs

A reader, February 22, 2017 - 5:07 am UTC

Unfortunately Oracle has the worst installation docs.
Those oracle engineers never try or test their stuff and put all wrong stuff in the manuals and when we create a support ticket, we end up teaching oracle what is the correct way to do installations.

Just try the oracle enterprise manager Install manuals to experience yourself. I would really want to fire those who create such garbage installation manuals without testing it themselves.
Oracle such a good product with terrible install docs.
Connor McDonald
February 23, 2017 - 2:33 am UTC

Have you used the feedback option in the online docs. Whenever I've used it, the docs team have always got back to me quite quickly with either a fix or discussion.


Quick and thoughtful response

Scott Ortel, February 22, 2017 - 11:57 am UTC

Hi Tom,

Thanks for the very quick and thoughtful response. I really appreciate you recreating the issue to verify the problem. I also appreciate the suggested work around. I wonder if other have run into this issue? I will report this to Oracle support and hopefully it will be fixed in the next release of the precompiler.

Thanks,

Scott
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.