Hi folks,   We have the following situation. We defined a Oracle library on SAS Management Console. This library is not pre-assigned. When we assign it on SAS EG (right click and select Assign), the library is assign correctly but doesn't show tables inside it. But if we execute the libname statement (copy the code from SAS MC, right click on library and select "Display libname assignment") directly on SAS EG, library is define fine and we see the list of tables inside it.   Any idea why using SAS MC configuration is not displaying the tables?    Thanks!     ... View more

Hi Folks,   We are setting our first Oracle connection using wallets. We have SAS 9.4 M6 installed on Linux and we have Oracle 12c client installed too.   We copy the wallet folder (includes sqlnet.ora, tnsname.ora, etc files inside) on a new directory. This folder has 400 permission for "sas" user. We also add on out TNS_ADMIN environment variable, inside sasenv_local file the wallet directory and restarted the SAS services.   But when we tried to connect the following error appears:   LIBNAME TEST ORACLE PATH=path_defined_wallet_tns USER=user PASSWORD=XXXXXXXXXXXXXXXXX; ERROR: ORACLE connection error: ORA-28759: failure to open file. ERROR: Error in the LIBNAME statement.   Any suggestions?   Regards, ... View more

Hi Folks,   Is there any way to add a code (bash), inside WorkspaceServer_usermods.sh script to capture the user and PID that starts the workspace server and save it on txt file?   Regards,  ... View more