Dear.
I did an oracle against 11 for the oracle 12 c but displays the following error:
ORA-12162: TNS:net service name is incorrectly specified
[SAC10]
Driver=Oracle 12g ODBC driver
DSN=SAC10
ServerName=scan-sac:1521/sac10
UserID=post_tes
Password=xxxxx
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
TraceFile = /backup/sql.log
Trace = Yes
SAS Enterprise Guide
An unexpected error has occurred
The library could not be assigned by the SAS server.
-------------------------------------------------------------------------------------------------------
Exception information
-------------------------------------------------------------------------------------------------------
[Error] CLI error trying to establish connection: [unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified
-------------------------- Technical Information Follows --------------------------
Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
SAS Message: [Error] CLI error trying to establish connection: [unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified
Raw Message: <Exceptions><Exception><SASMessage severity="Error">CLI error trying to establish connection: [unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified </SASMessage></Exception></Exceptions>
Source: SAS.EG.SDS.Model
Target Site: Assign
Stack Trace:
at SAS.EG.SDS.Model.Library.Assign()
at SAS.EG.SDS.Views.View.OnAssign(Object sender, EventArgs e)
A few things to check:
- Do you/ the users, have write permissions on the ODBC.INI file?
- Do you use mixed passwords, and, are you using quotes around the password? In the log you sent, it looks like the password is passed "through" without quotes around. Please try and change to "password" .. .does that work?
- Does that error occur for all users, or only for you? If that's the case, and you are working in "admin mode"/"install mode", make sure you are logging on with a user ID that is not SAS Installer id.
- Are there any changes needed on the env variables that might have not been made?
Hope that helps.
Your best bet for a quick fix would be to contact Tech Support
Thanks
Anja
isql -v "sac10" user password
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
but at SAS GUIDE appears this is error
SAS Enterprise Guide
An unexpected error has occurred
The library could not be assigned by the SAS server.
-------------------------------------------------------------------------------------------------------
Exception information
-------------------------------------------------------------------------------------------------------
[Error] CLI error trying to establish connection: [unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified
-------------------------- Technical Information Follows --------------------------
Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
SAS Message: [Error] CLI error trying to establish connection: [unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified
Raw Message: <Exceptions><Exception><SASMessage severity="Error">CLI error trying to establish connection: [unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified </SASMessage></Exception></Exceptions>
Source: SAS.EG.SDS.Model
Target Site: Assign
Stack Trace:
at SAS.EG.SDS.Model.Library.Assign()
at SAS.EG.SDS.Views.View.OnAssign(Object sender, EventArgs e)
Hi,
At this point, I really think that you should work with SAS Tech Sup. They'll provide you with excellent guidance and am sure have it solved in no time.
Somewhere, a parameter is not set correctly, which causes the error. It doesnt even have to be SAS but a problem with the UNIX side of things?
Best
Anja
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.