topic Update oracle 11 for 12c in Administration and Deployment

Update oracle 11 for 12c

Regina_Oliveira — Wed, 20 Jul 2016 00:37:38 GMT

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

Re: Update oracle 11 for 12c

LinusH — Wed, 20 Jul 2016 15:24:11 GMT

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.

Re: Update oracle 11 for 12c

Regina_Oliveira — Thu, 21 Jul 2016 00:16:09 GMT

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)

Re: Update oracle 11 for 12c

anja — Thu, 21 Jul 2016 14:10:30 GMT

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

Re: Update oracle 11 for 12c

Regina_Oliveira — Fri, 22 Jul 2016 01:35:26 GMT

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)

Re: Update oracle 11 for 12c

anja — Fri, 22 Jul 2016 12:50:58 GMT

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