Skip to Main Content

DevOps, CI/CD and Automation

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!

ORA-12560

user7075308Oct 5 2012 — edited Oct 12 2012
Hello,

i'm working on Windows2003-Server and installed oracle full client to connect to an Oracle-DB 11g on Unix.
I can connect using SQL-Plus but not with Oracle Ole DB. The programs i use, are C#-Programs with NET-Version 2.0.

The connection string i use in the program is "Provider=OraOLEDB.Oracle;Persist Security Info=False;Password=xxx;User ID=XXX; DataSource=vgdb;Extended Properties=".
I tried several connection strings, but i always get the error ORA-12560.
This connection-string works already on other machine. But here its a fully installation of oracle database 10g on windows and i can also connect from here to Oracle-DB 11g on Unix.

Configuration of sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

ADR_BASE = O:\app\admin\product\11.2.0\client_1\log

Entry in tnsnames.ora:
vgdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.156.199)(PORT = 1523))
)
(CONNECT_DATA =
(SID = svgdb)
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2012
Added on Oct 5 2012
9 comments
32,372 views