BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
aiaimanel
Obsidian | Level 7

Hi everyone,

 

I was questioned about the possibility and compatibility of migrating the Oracle version from 11 to 12C, in a 9.1 version of SAS, which is in use at this moment.

 

I know this version is outdated and no longer supported by SAS, and that the normal answer will be to upgrade the system or to not relly on an old SAS version to keep up with a new Oracle Version, but did anyone tried this?

 

We don't have anything too complex in terms of Oracle in our SAS DIS, and regarding the ODBC that SAS uses in this version, could it be used with Oracle 12c?

 

Best regards and thanks everyone.

1 ACCEPTED SOLUTION

Accepted Solutions
JBailey
Barite | Level 11

Hi @aiaimanel,

 

SAS 9.1.3 is 9 years old. When it was released it was base-lined on Oracle 8.1.7. This is a very old version of Oracle. Typically, we support the baseline plus two major releases. Using this formula we come to the unfortunate conclusion that SAS 9.1.3 does not support Oracle 12c. Keep in mind, this doesn't mean that it won't work. It means that if you have a problem there is little chance of Tech Support being able to help you. As you mention in your post, SAS 9.1.3 is not supported either... so, this is moot.

 

There is a chance that this will work. I have never tried it and I haven't heard of others trying it. Your best bet is to use an Oracle 11g client for the connection to 12c. That may work, but there are no guarantees.

 

Good luck,

Jeff

 

PS. I feel compelled to suggest upgrading your SAS environment... Now I feel better;)

View solution in original post

6 REPLIES 6
JBailey
Barite | Level 11

Hi @aiaimanel,

 

SAS 9.1.3 is 9 years old. When it was released it was base-lined on Oracle 8.1.7. This is a very old version of Oracle. Typically, we support the baseline plus two major releases. Using this formula we come to the unfortunate conclusion that SAS 9.1.3 does not support Oracle 12c. Keep in mind, this doesn't mean that it won't work. It means that if you have a problem there is little chance of Tech Support being able to help you. As you mention in your post, SAS 9.1.3 is not supported either... so, this is moot.

 

There is a chance that this will work. I have never tried it and I haven't heard of others trying it. Your best bet is to use an Oracle 11g client for the connection to 12c. That may work, but there are no guarantees.

 

Good luck,

Jeff

 

PS. I feel compelled to suggest upgrading your SAS environment... Now I feel better;)

aiaimanel
Obsidian | Level 7
Thank you for your answer.
Although in this particular case there is no "right solution" and the only way is testing, I'm going to accept your reply as the solution.

PS: I hope you feel better with the upgrade suggestion, I also feel the same whenever I come across a bug in this version.
Patrick
Opal | Level 21

in terms of Oracle in our SAS DIS,

 

...and in regards of upgradel: If you're on SAS9.1.3 then you have still to use DIS3.4. If so then it's really time to upgrade as the changes and improvements to DIS 4.x increased usability and productivity quite a bit.

aiaimanel
Obsidian | Level 7
Thank you for your reply.

And can I upgrade the DIS Version in this case? Or do I need to upgrade all SAS ?
JBailey
Barite | Level 11

Hi @aiaimanel,

 

You would have to upgrade all of SAS because DI Studio will use the underlying SAS/ACCESS components and they are what limiting you here.

 

Hope this helps!

Jeff

aiaimanel
Obsidian | Level 7
Thanks so much Jeff, I will look it up!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1565 views
  • 3 likes
  • 3 in conversation