Not able to create Oracle library in SAS Management Console

Lakshmi_G — Tue, 16 Jul 2019 09:10:28 GMT

Hi everyone,

Hope you're doing good !!

I am trying to create Oracle library in SMC. I am getting an error as below.

ERROR: Libref Post is not assigned.
ERROR: Error in the LIBNAME statement.

I am not getting any other error to find out where the issue causes.

Ours is a windows environment.

Please find the below libname statement from SMC.

LIBNAME post ORACLE INSERTBUFF=4000 READBUFF=4000 SHOW_SYNONYMS=YES
PATH="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXX)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=postsp)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))" AUTHDOMAIN="ORAAuth" ;

After running the above statement in SAS EG we are getting the below error.

ERROR: ORACLE connection error: ORA-12545: Connect failed because target host or object does not exist.
ERROR: Error in the LIBNAME statement.

Please help me out by giving your valuable suggestions.

Many Thanks in Advance !!

Best Regards,

Lakshmi .

Re: Not able to create Oracle library in SAS Management Console

sandykota — Tue, 16 Jul 2019 10:02:14 GMT

Hi Lakshmi,

Please follow the below weblink:

http://support.sas.com/techsup/technote/ts771.pdf

topic Not able to create Oracle library in SAS Management Console in New SAS User

Not able to create Oracle library in SAS Management Console

Re: Not able to create Oracle library in SAS Management Console