My Oracle Support Banner

VMS: Troubleshooting Guide for TNS-12500 Errors on Alpha OpenVMS (Doc ID 93322.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle Net Services - Version 9.2.0.2 to 10.2.0.4 [Release 9.2 to 10.2]
HP OpenVMS Itanium
HP OpenVMS Alpha

Purpose

This document is intended to help in resolving the most common reasons for ORA-12500/TNS-12500 errors on OpenVMS in Oracle 9.2 and up. Much of the information also applies to versions of Oracle on OpenVMS going back to 7.3.3, but this document concentrates on newer versions.

This  article does not include Oracle Names Server problems, it is only based  on systems that make connections using TNSNAMES.ORA.

The intended audience is Oracle personnel, and Oracle customers who encounter this error.


Troubleshooting Steps

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

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


In this Document
Purpose
Troubleshooting Steps
 Recommended Reading
 Introduction
 A. Basic Checks
 A.1 Setup your basic test environment
 A.2. Ensure ORASRV_NETV2.COM is setup correctly.
 A.3. Check the ORASRV_NETV2_<SID>.COM specification in LISTENER.ORA
 B. Beyond basic setup analysis
 B.1.  Check the login command files
 B.2. Check Account privileges
 B.3. Check the SQLNET.LOG file.
 B.4. Check the OpenVMS Accounting file
 
 B.5.  Check your system resources.
 B.6. If your TNS errors are still not resolved
References

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