Architecting, installing and maintaining your SAS environment

Additional installation of SAS/ACCESS TO ORACLE

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

Additional installation of SAS/ACCESS TO ORACLE

[ Edited ]

Dear SAS Communities,

in new order of SAS VA Licence files for Linux, we also bought SAS/CONNECT TO ORACLE.

Which had to lead into generating new version of SAS DEPOT for our VA server.

 

Is it OK if i'll just install the SAS/CONNECT TO ORACLE via depot install of "SAS Foundation and related software"?

Would it change any of our preconfigured stuff like SASApp server and so on?

 

Thank you for your advice!

 

Have a nice day,

Michal


Accepted Solutions
Solution
‎03-22-2018 12:00 PM
Valued Guide
Posts: 531

Re: Additional installation of SAS/CONNECT TO ORACLE

Hi Michal,

 

It will not change anything in your configuration. Adding an Access engine is an update to the SASHome part of your deployment rather than the configuration. I agree that it looks like a lot will be done again instead of just adding to what's already there. But you can add Acc/Oracle as you describe.

 

Do not forget the post-install instructions that pertain to this product. They are very important.

 

Regards,

- Jan.

View solution in original post


All Replies
Solution
‎03-22-2018 12:00 PM
Valued Guide
Posts: 531

Re: Additional installation of SAS/CONNECT TO ORACLE

Hi Michal,

 

It will not change anything in your configuration. Adding an Access engine is an update to the SASHome part of your deployment rather than the configuration. I agree that it looks like a lot will be done again instead of just adding to what's already there. But you can add Acc/Oracle as you describe.

 

Do not forget the post-install instructions that pertain to this product. They are very important.

 

Regards,

- Jan.

Super User
Posts: 3,855

Re: Additional installation of SAS/CONNECT TO ORACLE

[ Edited ]

When installing additional software, remember to choose this option when using the SAS Deployment Wizard to avoid re-installing any existing software.

 

BTW it's called SAS/ACCESS to Oracle, SAS/CONNECT is a different product.

Super User
Posts: 9,868

Re: Additional installation of SAS/CONNECT TO ORACLE

SAS depots are heavily customized according to your existing software. If you receive a depot for additional software, and your current installation is not on the current maintenance level, then the depot will include the necessary updates for the current ML, which will be automatically installed as soon as you select "Install Software".

This means you need downtime, as all SAS services and processes have to be stopped.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 21

Re: Additional installation of SAS/CONNECT TO ORACLE

Posted in reply to KurtBremser

Thanks for your answer, i have "just to be sure" question for that.

If the deployment wizard says it will update some components like :

 

                                                                                    Installed  Updated
SAS/SECURE Java Component                                                           9.4_M3     9.4_M5
SAS/GRAPH JAR Files                                                                 9.4_M3     9.4_M5
Threaded Kernel Java Jars                                                           9.4_M3     9.4_M5
SAS Integration Technologies Documentation                                          9.4_M3     9.4_M5
SAS Integration Technologies JAR Files                                              9.4_M3     9.4_M5
Base SAS JAR Files                                                                  9.4_M3     9.4_M5
SAS Threaded Kernel Core Routines (64-bit)                                          9.4_M3     9.4_M5
SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone (64-bit)               9.4_M3     9.4_M5
SAS Threaded Kernel In-Database Supervisor (64-bit)                                 9.41_M1    9.41_M3
SAS Threaded Kernel DS2 and FedSQL Language Processors (64-bit)                     9.41_M1    9.41_M3
Threaded Kernel IOM (64-bit)                                                        9.4_M3     9.4_M5
SAS Threaded Kernel Component for Accessing the Threaded Kernel from JAVA (64-bit)  9.4_M2     9.4_M4
SAS Threaded Kernel Interface to R (64-bit)                                         9.4_M3     9.4_M5
SAS Threaded Kernel Online Documentation (64-bit)                                   9.4_M3     9.4_M5
SAS Threaded Kernel User Functions (64-bit)                                         9.4_M3     9.4_M5
Threaded Kernel Java (64-bit)                                                       9.4_M3     9.4_M5
SAS Threaded Kernel Components for Scalable Performance Data (64-bit)               9.41_M3    9.41_M5
SAS Threaded Kernel Grid (64-bit)                                                   9.4_M3     9.4_M5
Threaded Kernel National Language Support (64-bit)                                  9.4_M3     9.4_M5
SAS Threaded Kernel User Formats (64-bit)                                           9.4_M3     9.4_M5
SAS Threaded Kernel (64-bit)                                                        9.4_M3     9.4_M5
Threaded Kernel OLAP Server Component (64-bit)                                      9.4_M3     9.4_M5
SAS Table Server Base Components (64-bit)                                           9.4_M3     9.4_M5
Threaded Kernel Metadata Component (64-bit)                                         9.4_M3     9.4_M5
SAS Threaded Kernel Secure (64-bit)                                                 9.4_M3     9.4_M5
Threaded Kernel Log for SAS (64-bit)                                                9.4_M3     9.4_M6
Base SAS (64-bit)                                                                   9.4_M3     9.4_M5
SAS High Performance Server Help and Documentation (64-bit)                         2.1_M3     2.1_M5
DATA Step to DS2 Translator (64-bit)                                                3.1_M3     3.1_M5
SAS Integration Technologies (64-bit)                                               9.4_M3     9.4_M5
Base SAS User Interface (64-bit)                                                    9.4_M3     9.4_M5
SAS Data Mining Scoring (64-bit)                                                    9.4_M3     9.4_M5
SAS/GRAPH (64-bit)                                                                  9.4_M3     9.4_M5
SAS/ACCESS Interface to PC Files (64-bit)                                           9.4_M3     9.4_M5
SAS/ACCESS Interface Products Samples (64-bit)                                      9.4_M2     9.4_M5
ODS Templates (64-bit)                                                              9.4_M3     9.4_M5
Common Content MVA product Help and Documentation (64-bit)                          9.4_M3     9.4_M5
SAS/CONNECT (64-bit)                                                                9.4_M3     9.4_M5
SAS High-Performance Server (64-bit)                                                2.2_M4     2.2_M6
SAS Intelligence Platform Object Framework                                          9.4_M3     9.4_M5
SAS Management Console                                                              9.4_M3     9.4_M5
SAS Deployment Tester Plug-in for SAS Management Console                            9.4_M3     9.4_M5
SAS Configuration Manager                                                           9.4_M3     9.4_M5
SAS Foundation Services                                                             9.4_M3     9.4_M5
SAS Environment Manager Agent                                                       2.5        2.5_M2
SAS Deployment Tester - Server                                                      2.2_M3     2.2_M5
SAS Deployment Tester - Client                                                      2.2_M3     2.2_M5
SAS Threaded Kernel Extension for PostgreSQL (64-bit)                               9.4_M2     9.4_M4
SAS Threaded Kernel Extensions for High-Performance Analytics (64-bit)              2.2_M4     2.2_M6
SAS Threaded Kernel Extension for In-Memory Data Storage (64-bit)                   2.1_M2     2.1_M4
SAS Java Component for Accessing Threaded Kernel from Java                          9.4_M2     9.4_M4
SAS Threaded Kernel Extension for RDBMS Drivers Parser (64-bit)                     9.41_M1    9.41_M3
SAS Install Qualification Tool                                                      9.49516    9.49516_M2

BUT we have metadata server on different machine (obviously with older software than this update) - will it makes any problems? Thanks a lot!

Super User
Posts: 9,868

Re: Additional installation of SAS/CONNECT TO ORACLE

I would at least run the SDW on the metadata server to check if it finds something to update.

If in doubt, get in touch with your SAS representative.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 21

Re: Additional installation of SAS/ACCESS TO ORACLE

Thanks for all advices - I've changed the title of question to sas/access. Going to install it tommorow. Thanks a lot!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 191 views
  • 0 likes
  • 4 in conversation