topic ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement. in SAS Programming

ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement.

Srigyan — Tue, 05 Oct 2021 10:30:38 GMT

I am trying to connect SAS with the oracle and i wrote the below code:

libname oralib oracle path='sukdc02ora01' user='login' password="password" schema='schema name';

sukdc02ora01 is host name

I am getting following error

40 libname oralib oracle path='sukdc02ora01' user='login' password='password'
41 schema='schema_name';
ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.

oracle client is installed and working fine with my python.

python code if that helps:

import pandas as pd
import pandasql as ps
import sqlalchemy
import cx_Oracle

ip = 'sukdc02ora01'
port = 1521
SID = 'DEVNEW'
user = 'login'
password = 'password'

dsn_tns = cx_Oracle.makedsn(ip, port, SID)
conn = cx_Oracle.connect(user, password, dsn_tns)
print(conn.version)

Please suggest what should be done to connect with oracle

Re: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement.

Kurt_Bremser — Tue, 05 Oct 2021 10:48:55 GMT

Do you have SAS/ACCESS to Oracle installed? Please run PROC SETINIT and PROC PRODUCT_STATUS, and post the log of both.

Re: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement.

Srigyan — Fri, 08 Oct 2021 10:02:16 GMT

output of SAS INIT

Original site validation data
Current version: 9.04.01M6P110718
Site name: 'BALLY TECHNOLOGIES INC'.
Site number: 70195295.
CPU A: Model name='' model number='' serial=''.
Expiration: 30MAR2022.
Grace Period: 45 days (ending 14MAY2022).
Warning Period: 45 days (ending 28JUN2022).
System birthday: 07APR2021.
Operating System: W32_WKS .
Product expiration dates:
---Base SAS Software 30MAR2022 (CPU A)
---SAS/STAT 30MAR2022 (CPU A)
---SAS/GRAPH 30MAR2022 (CPU A)
---SAS/Secure 168-bit 30MAR2022 (CPU A)
---SAS/Secure Windows 30MAR2022 (CPU A)
---SAS Enterprise Guide 30MAR2022 (CPU A)
---SAS/ACCESS Interface to OLE DB 30MAR2022 (CPU A)
---SAS Workspace Server for Local Access 30MAR2022 (CPU A)
---High Performance Suite

output of PROC PRODUCT_STATUS

For Base SAS Software ...
Custom version information: 9.4_M6
Image version information: 9.04.01M6P110718
For SAS/STAT ...
Custom version information: 15.1
For SAS/GRAPH ...
Custom version information: 9.4_M6
2 The SAS System 11:26 Monday, October 4, 2021

For High Performance Suite ...
Custom version information: 2.2_M7
For SAS/ACCESS Interface to OLE DB ...
Custom version information: 9.4_M6

Re: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement.

ChrisNZ — Fri, 08 Oct 2021 10:31:49 GMT

You do not have SAS/ACCESS to Oracle.

What you can do is use ACCESS to OLEDB: install an Oracle OLEDB provider.

Re: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement.

Srigyan — Fri, 08 Oct 2021 14:29:31 GMT

Okay, let me try and comback.