Skip to Main Content
  • Questions

  • Oracle instant client 12c EZConnect Using tcps instead of tcp

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, c.

Asked: February 26, 2019 - 10:39 am UTC

Last updated: March 06, 2019 - 1:28 am UTC

Version: oracle instant client 12.2.0.1.0

Viewed 1000+ times

You Asked

I download oracle instant client 12.2.0.1.0, I try to use sql loader to load csv data to the database. I can successfully load using following:

sqlLdr.exe userid=user/password@//192.9.200.228:1521/oracle ERRORS=4000 control=D:\temp\csma\xx_20190225.ctl log=D:\temp\csma\xx.log


However my production would only allow secured connection only (use tcps), can EZConnect using tcps? If yes, how? If not how can I connect using tcps using sql loader just in the instant client (not full client) without tnsnames.ora?

and Connor said...

From MOS note 2502638.1

Does EZCONNECT (aka Easy Connect) work with SSL / TCPS?

No. Only the TCP/IP protocol is supported with the EZCONNECT (Easy Connect) method of Client connectivity.
The TCPS protocol (and other protocols) are not supported.

Sorry, but you'll need a client. But assuming you're running sqlldr, doesn't that suggest you already have the client installed ?

Rating

  (2 ratings)

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

Comments

c c, February 28, 2019 - 3:57 am UTC

Thx Connor! I just have the instant client but not the full oracle client. I tried and success with using my oracle server to generate the wallet for the client, import the oracle server cert to the client as trusted cert. Copy the client wallet to the instant client and add sqlnet.ora and tnsnames.ora to the instant client's network/admin folder and use now it works!
Connor McDonald
March 01, 2019 - 1:07 am UTC

Nice work!

tcps

Laurent Schneider, March 04, 2019 - 3:05 pm UTC

Use TCPS:// as a prefix

SQL> conn user/password@tcps://h:1521/svc.example.com
Connected.


works like a charm with instant client 19c
Connor McDonald
March 06, 2019 - 1:28 am UTC

Good point.

There's a *lot* of new goodies in the 19c instant client
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

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database