Usage Note 16596: "Error: Oracle connection error: ORA-12154: TNS could not resolve
service name"
Using an Oracle Names Server instead of TNSNAMES.ORA file will cause
sporadic TNS-12154 errors with SAS/Access Interface to Oracle. This is
an Oracle BUG which is reported on the Oracle Metalink site. The
website is:
https://metalink.oracle.com
Suggested keywords for your search are: CLIENT CONNECTIONS
STAY ESTABLISHED CONNECTING VIA ORACLE NAMES WHEN USING NAMES
SERVER.
When you have multiple LIBNAME statments with different schema names,
you are opening a new connection with each schema name and that will
cause
this error message. The work around to this problem is to use
TSNAMES.ORA instead of the Oracle Names Server.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2005-12-05 15:12:30 |
| Date Created: | 2005-11-29 23:00:11 |
