8.9 Creating an Oracle Wallet for an Oracle R Enterprise Connection

An Oracle wallet is a password-protected container for storing security credentials in Oracle Database.

Wallets provide a secure mechanism for specifying connection details in embedded R scripts.

To create a wallet for an Oracle R Enterprise connection:

Start Oracle Wallet Manager:
- (Linux and UNIX) At the command line, enter owm.
- (Windows) Select Start, Programs, Oracle-HOME_NAME, Integrated Management Tools, Wallet Manager.
Follow the instructions in your Oracle Database documentation to create the wallet:
- For Oracle Database 12.1, see "Using Oracle Wallet Manager" in Oracle Database Enterprise User Security Administrator's Guide:
  
  http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBIMI160
- For Oracle Database 11.2, see "Using Oracle Wallet Manager" in Oracle Database Advanced Security Administrator's Guide:
  
  http://www.oracle.com/pls/topic/lookup?ctx=db112&id=ASOAG160

Locate the connection string for the Oracle R Enterprise database in tnsnames.ora. For example:

mydb_test =
      (DESCRIPTION =
         (ADDRESS =
            (PROTOCOL = TCP)
            (HOST = server23)
            (PORT = 1521)
         )
         (CONNECT_DATA = (sid=ORCL))
      )

Specify the connection information in the wallet. Follow the instructions in the Oracle Database security documentation referenced in Step 2.
After you configure the wallet, you can connect to the Oracle R Enterprise server database by simply specifying the connection identifier. For example:
```
ore.connect(conn_string = "mydb_test", all = TRUE)
```
To learn more about ore.connect, use the R help command:
```
help(ore.connect)
```