I'm trying to connect to an Oracle 10G database which is present in a remote server, through SAS EG in UNIX. However, when i try to assign a libname using the below code -
libname DDW oracle user='user-id' ORAPW='pass' path='@path' schema=DDWMGR;
I get the following error message:
ERROR: ORACLE connection error: ORA-12541: TNS:no listener.
ERROR: Error in the LIBNAME statement.
Could you please tell me what is it that I'm missing here?