Home | Contact Us | Submit Troubleshooting Info | Search | Help


    Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS


ORA-12560: TNS:protocol adapter error when connecting to Oracle


Product

  Prinergy Connect 2.1 ; Prinergy Direct 2.1 ; Prinergy Access 2.1 ; Prinergy Powerpack 2.1

Platform

 

Intel

Operating system

 

Windows 2000


Error

 

ORA-12560: TNS:protocol adapter


Symptoms

 

When attemtping to connect to the Oracle database using SVRMGRL.EXE or SQLPLUS.EXE in a terminal service session, the Oracle error ORA-12560 occurs.


Cause

  The Oracle bequeath protocol does not work in Terminal Services, you must use the SQL*Net alias (username/password@tns_alias) .

Solution

 

Use the syntax username/password@tns_alias when connecting to Oracle.

Example:

D:\> sqlplus prinergy/araxi@araxidbserver

Or if using SVRMGRL, enter:

SVRMGR> connect prinergy/araxi@araxidbserver

Permanent fix:


See also

 


Keywords

 

oracle


Technical contact(s)
 

Stan Yoshida

Submitted by
 

Stan Yoshida

Date submitted
 

24 Aug 2005


    Copyright © 2005 Creo Inc. All rights reserved. Confidential. Back to top.