Generate SSL Certificate Request (csr) for Unix/Oracle

Problem Description : 

Each year, will need to create a csr file (SSL Certificate Request file) for renewal of Unix/Oracle hosts running Banner IAS and INB

 Resolution : 

1) Login into Unix host as Oracle user.

2) Source script to set Oracle home, etc 

export ORACLE_HOME=/oracle/product/ias/

export DISPLAY=<<IP ADDRESS>>:0.0

3) Setup Xterm access on the PC from Unix host (XLaunch) 

4) CD to /oracle/product/ias/bin and run the oracle command ./owm to start the Oracle Wallet Manager

5) Select Wallet|Open and navigate to /oracle/product/mw11g/ias/instances/ias/config/OHS/ohs1/keystores/default

6) Enter Wallet password

7) Select Operations|Add Certificate Request

8) Use following:

- Common name: host.gordonstate.edu

- Organizational Unit: Computer Services Department

- Organization: Gordon College

- Location/City: Barnesville

- State/Province (DO NOT ABBREVIATE!!!): Georgia

- Country (DO NOT ABBREVIATE): United States

- Key Size: 2048

9) After generating, select Operations|Export Certificate Request

10) Save to /oracle with name of hostname_yyyy.csr

11) Move csr file to N: drive

12) Order certificate 

 Revision Date : 3/20/2014