How do I configure Oracle database connection to SAS in Linux?

[WorkingMan]

I just received a new Linux server and I would like to extract data from Oracle database. Currently, I haven't got the access to the linux server but assuming that it has SAS/Access component, what would be the steps for me to configure in order for me to extract data from Oracle database and used in SAS Data Integration studio?

What I can remember for a windows server without SAS/ACCESS component is to install oracle client. Then, configure tnsnames.ora file by putting oracle user and password. Next is to create a "server" in SAS Management Console and later create a group for storing this DB access. Lastly, configure in ODBC.

For Linux, will the steps be similar like below?
1. Install Oracle Client

2. Create a "server" in SMC (skip tnsnames.ora due to having SAS/ACCESS)

3. Create a group for storing this DB access

Hope I can get advice for this?

[Kurt_Bremser]

You will also need to configure the Oracle client, so it can reach the Oracle server from a commandline call.

I remember that I did have to create an "instance" when I used ACCESS to DB/2, so I guess you need to do something similar for Oracle.

See 

Establishing Connectivity to an Oracle Database 

SAS/ACCESS Interface to Oracle 

[Sajid01]

Hello
This is my experience with setting up oracle on RHEL With SAS Access interface to ODBC.

(I had followed similar steps on SLES 11 )

Others may have different suggestions depending on their use cases.
Assuming you have installed SAS

1. Make sure that ODBC manager unixODBC is installed. Typically done by Unix/Linux Administrator.

2.Make sure that oracle client is installed. This is typically this is done by Oracle DBA. tnsname.ora etc are typically done by the ORACLE DBA's

3.Ensure that /etc/odbc.ini is configured. Oracle DBA provides the content. You may need the Linux admins help to edit this file. Typically SAS Admins cannot edit anything under /etc

4.Configure the sasenv_local file with LD_LIBRARY . ORACLE_HOME paths.

6.Make sure that access is allowed to the users from this server. Oracle DBA's do this.

7.Test connectivity from the Linux command line (sas -nodms). Once you are OK with this you can do the next steps.