Skip to Main Content

Cloud Connectivity

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TNS: protocol adapter error for cloud wallet

Andrew RDec 12 2023

Hi Experts,

I have done below steps:

I have copied the sqlnet.ora file content from cloud wallet and added it into my local sqlnet.ora. Also did for tnsnames.ora file and added the cloud wallet location.

****************************

# sqlnet.ora Network Configuration File: C:\app\Learncode\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

#for Cloud database
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="D:\cloudwallet")))
SSL_SERVER_DN_MATCH=yes
**********************************************

# tnsnames.ora Network Configuration File: C:\app\Learncode\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

OCIH = copied and added from the cloud wallet file

OCIL = copied and added from the cloud wallet file

OCIM = copied and added from the cloud wallet file

atpdb_tp = copied and added from the cloud wallet file

atpdb_tpurgent = copied and added from the cloud wallet file

********************************************************************

And after i did tnsping OCIH its giving error TNS-12560: TNS: protocol adapter error

Can anyone please help me on this?

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Dec 12 2023
1 comment
314 views