Dear Team,
when I try to connect to oracle database located at(192.168.9.104) from SAS Management console (Located at 192.168.9.38)
I am getting the error "Application could not logon to server", please find the attachment for error screenshot.
Error Message
Unknown User Name.
The application could not log on to the server "sascompute:8591". The user ID "ARGSRI_FINAL" or the password is incorrect.
I can connect to my database from SQL Prompt (please find the screenshot attached), but cannot connect from Management console.
Please let me know where I am going wrong.
here is my LIBNAME
LIBNAME LIBREF ORACLE PATH=ARGPHY SCHEMA=ARGSRI_FINAL USER=ARGSRI_FINAL PASSWORD="{sas002}E7459716560D1F38028B623747D2EFA0063235DB" ;
TNSPING
C:\Users\Administrator>tnsping ARGPHY
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-APR-2
018 13:05:53
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.10.12.26)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ARGPHY)))
OK (20 msec)
C:\Users\Administrator>
where ARGPHY is tns entry name.
Thank you.
And have you contacted your system administrator? They would be best placed to sort out these types of things for you.
Yes, I have contacted my system administrator, unfortunately he has no idea where to make any changes.
we felt like we missed something from the configuration end.
My doubt is, is there anywhere that I need to put my location to tnsnames.ora in SAS management console
Hi
When I try to connect from enterprise guide, I am getting below error
libname LIBREF oracle path="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.12.26)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME=ARGPHY)))" user=ARGSRI_FINAL password=XXXXXXXXXX;
ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable..
Please make sure Oracle environment is set correctly.
Look in the install/Config doc for additional info for your platform.
Other possible reasons - incomplete Oracle client install, 32/64-bit mismatch between Oracle client & SAS, incorrect Oracle client
version(Oracle client must match the version picked during post-install process), incompatible sasora for your OS or its
attribs don't permit SAS to load it.
ERROR: Error in the LIBNAME statement
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: