The SAS Output Delivery System and reporting techniques

Cannot connect to oracle database | Please help

Reply
New Contributor
Posts: 3

Cannot connect to oracle database | Please help

[ Edited ]

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.

 

 

 

 

Attachment
Super User
Super User
Posts: 8,967

Re: Cannot connect to oracle database | Please help

Posted in reply to nareshgandi

And have you contacted your system administrator?  They would be best placed to sort out these types of things for you.

Highlighted
New Contributor
Posts: 3

Re: Cannot connect to oracle database | Please help

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

New Contributor
Posts: 3

Re: Cannot connect to oracle database | Please help

Posted in reply to nareshgandi

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 statementRegedit.jpg

Ask a Question
Discussion stats
  • 3 replies
  • 89 views
  • 0 likes
  • 2 in conversation