Architecting, installing and maintaining your SAS environment

Update oracle 11 for 12c

Reply
New Contributor
Posts: 3

Update oracle 11 for 12c

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

Super User
Posts: 5,256

Re: Update oracle 11 for 12c

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
New Contributor
Posts: 3

Re: Update oracle 11 for 12c

 
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)

SAS Super FREQ
Posts: 291

Re: Update oracle 11 for 12c

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

 

New Contributor
Posts: 3

Re: Update oracle 11 for 12c

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)

 

 

SAS Super FREQ
Posts: 291

Re: Update oracle 11 for 12c

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

Ask a Question
Discussion stats
  • 5 replies
  • 638 views
  • 0 likes
  • 3 in conversation