Hi! In the SAS Manadment Console, when the server is configured, the Path field is filled in as follows (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = XXX.XXX.XXX.XXX) (PORT = 1521))) (CONNECT_DATA = (sid = orc1))). When I try to view the library that accesses this server in SAS Enterprisse Guide, I get an error Exception type: SAS.EG.SDS.SDSException SAS Message: [Error] ORACLE connection error: ORA-12505: TNS: listener does not know of SID given in connect descriptor. Raw Message: <? Xml version = '1.0'?> <Exceptions> <Exception> <SASMessage severity = 'Error'> ORACLE connection error: ORA-12505: SIN given in connect descriptor. / SASMessage> </ Exception> </ Exceptions> Source: SAS.EG.SDS.Model Target Site: Assign Stack Trace: at SAS.EG.SDS.Model.Library.Assign () at SAS.EG.SDS.Model.Library.PopulateDatasets (Collection & collection) at SAS.EG.SDS.Model.Broker.PopulateCollection (Collection collection) at SAS.EG.SDS.Model.Collection.DoPopulate () at SAS.EG.SDS.Views.View.DoPopulate (DisplayOperation & op). The SID field is taken from the tnsnames.ora file. oracle client works normally using the tnsnames.ora file. Tell me what can be wrong.
... View more