Not able to create Oracle library in SAS Management Console

[Lakshmi_G]

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 .

[sandykota]

Hi Lakshmi,

Please follow the below weblink:

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