BookmarkSubscribeRSS Feed
Regina_Oliveira
Calcite | Level 5

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

5 REPLIES 5
LinusH
Tourmaline | Level 20
You did what?
Verify that you have a compatible SQL*NET version, and that your tnsnames file have the correct contents.
Full log would help trouble shooting.
Data never sleeps
Regina_Oliveira
Calcite | Level 5
 
My company made ​​an updating of Oracle 11 to Oracle 12 and after that updating the libnamen not connected more
 
my connection odbc.ini

 
[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)

anja
SAS Employee

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

 

Regina_Oliveira
Calcite | Level 5

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)

 

 

anja
SAS Employee

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 2094 views
  • 0 likes
  • 3 in conversation