Thursday, March 3, 2011

Audit vault Server & Agent Installation

Installing the Audit Vault Server
1.         Open a terminal window and “unset” the ORACLE_SID and ORACLE_HOME environment variables. (Note: The environment variables are set for your source database by default.)
            [oracle@EDRSR2P1 ~]$ echo $ORACLE_SID
            orcl
            [oracle@EDRSR2P1 ~]$ export ORACLE_SID=
            [oracle@EDRSR2P1 ~]$ echo $ORACLE_SID

            [oracle@EDRSR2P1 ~]$ echo $ORACLE_HOME
            /u01/app/oracle/product/10.2.0/db_1
            [oracle@EDRSR2P1 ~]$ export ORACLE_HOME=
            [oracle@EDRSR2P1 ~]$ echo $ORACLE_HOME


2.         Install the Audit Vault Server. Invoke Oracle Universal Installer to begin the installation of the Audit Vault server.
a.         The Audit Vault Server installation files have been staged in the $HOME/av_installmedia directory. Change to the directory containing the Audit Vault Server installation files.
            [oracle@EDRSR2P1 ~]$ cd av_installmedia/server 
b.         Invoke the Oracle installer as follows:
            [oracle@EDRSR2P1 server]$ ./runInstaller

3.  Perform an Advanced installation of the Audit Vault Server.
a.         On the Select Installation Type page, select Advanced Installation. Click Next.
b.         On the Advanced Installation Details page, provide the following information and click Next:
            Audit Vault Name: av
            Audit Vault Home: /u01/app/oracle/product/10.2.0/av_1
            Audit Vault Administrator: avadmin1
            Administrator Password: oracle_1
            Audit Vault Auditor Username: avaudit1
            Auditor Password: oracle_1


c.         The Database Vault User Credentials Page appears. Enter the following information:
            Database Vault Owner: dbvowner1
            Owner Password: dbvoracle_1
            Database Vault Account Manager: dbvacct1
            Account Manager Password: dbvoracle_1
            Click Next.
d.         The Product-Specific Prerequisite Checks page appears. After the checks complete, click Next.
e.         The Specify Database Storage Option page appears. Select File System and specify /u01/app/oracle/oradata/av in the Specify Database file location field. Click Next.
f.          The Specify Backup and Recovery Options page appears. Select Enable Automated Backups. Specify /u01/app/oracle/flash_recovery_area/av in the Recovery Area Location field. Specify oracle in the Username and Password fields. Click Next.
g.         The Specify Schema Database Passwords page appears. Select “Use the same passwords for all accounts” and enter oracle_2 in the Password field. Click Next.
h.         Review the information on the Summary page. Click Install.
i.          The Install page appears.
j.          The Configuration Assistants page appears. The Database Configuration Assistant Page appears.
k.         Click OK on the password management page.
l.          Execute the root.sh script as directed. Do not overwrite the existing files.
m.        When the End of Installation page appears, make note of the Enterprise Manager Database Control URL and the Audit Vault Console URL. Click Exit.
            Enterprise Manager Database Control URL: _____________________________
            Audit Vault Console URL: ___________________________________________
n.         Click Yes to confirm.



4. Create a user in the Audit Vault Server database for the Audit Vault Agent.

a.         Open a terminal window and set the Audit Vault environment variables (ORACLE_SID, ORACLE_HOME and PATH) for the Audit Vault Server.
            You can also use the $HOME/labs/setavserver.sh script to accomplish this as follows:
[oracle@EDRSR2P1 labs]$ . ./setavserver.sh
            OR set the environment variables manually:
[oracle@EDRSR2P1 ~]$ export ORACLE_SID=av
[oracle@EDRSR2P1 ~]$ echo $ORACLE_SID
            av
[oracle@EDRSR2P1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/av_1
[oracle@EDRSR2P1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/av_1
[oracle@EDRSR2P1 ~]$ export PATH=/u01/app/oracle/product/10.2.0/av_1/bin:$PATH

b. Log in to SQL*Plus using the Database Vault Account Manager username and password.           

[oracle@EDRSR2P1 av_1]$ sqlplus dbvacct1/dbvoracle_1

c.  Create the Audit Vault Agent user. Exit from SQL*Plus.

SQL> create user avagentuser identified by avagentpass;
User created.
SQL> exit

5.  In the terminal window, use AVCA to add the Audit Vault Agent user to Audit Vault. Supply the following values:
            Agentname: avagent1
            Agenthost: <server name> Note: Include the domain name as in this example:       edrsr2p1.us.oracle.com
            Agentusr: avagentuser

[oracle@EDRSR2P1 av_1]$ avca add_agent -agentname avagent1 -agenthost <Audit Vault Agent hostname>  -agentusr avagentuser
AVCA started
Adding agent...
Agent added successfully.

Install the Audit Vault agent on Source Database Server

6.         Invoke Oracle Universal Installer to begin the installation of the Audit Vault agent.
a.         Change directories to the directory containing the Audit Vault agent installation files
 [oracle@EDRSR2P1 ]$ cd av_installmedia/avagent/linux_x32
b.         Invoke Oracle Universal Installer as follows:
[oracle@EDRSR2P1 linux_x32]$ ./runInstaller

7.         Proceed with the installation of the Audit Vault Agent.
a.         On the Audit Vault Agent Installation Details page, provide the following information and click Next:
            Audit Vault Agent Name: avagent1
            Audit Vault Agent Home: /u01/app/oracle/product/10.2.0/av_agent_1
            Agent Username: avagentuser
            Agent Password: avagentpass
            Audit Vault Server Connection Information: host name:listener port:service name
            (auditvault-server-host:1522:av.us.oracle.com as an example)
b.         The Product-Specific Prerequisite Checks page appears. After the checks complete, click Next.
c.         Review the information on the Summary page. Click Install.
d.         The Install page appears.
e.         The Configuration Assistants page appears.
f.          Execute the root.sh script as directed. Click OK.
g.         On the End of Installation page, note the Audit Vault agent port number. Click Exit.



Starting Audit Vault Server & Agent (For Information only)          

f.  Execute the AVCA redeploy command as follows:
            [oracle@EDRSR2P1 av_installmedia]$ avca redeploy
            AVCA started
            Starting OC4J...
            OC4J started successfully.
            Deploying to standalone OC4J...
            done.
            Restarting agent OC4J...
            OC4J restarted successfully.
            [oracle@EDRSR2P1 av_installmedia]$
           
g.  In your Audit Vault Agent terminal window, restart the Audit Vault Agent OC4J as follows:
            [oracle@EDRSR2P1 av_installmedia]$ avctl start_oc4j
            AVCTL started
            Starting OC4J...
            OC4J started successfully.
            [oracle@EDRSR2P1 av_installmedia]$

h.  In your Audit Vault Server terminal window, restart the Audit Vault agent as follows:
            [oracle@EDRSR2P1 av_1]$ avctl start_agent -agentname avagent1
            AVCTL started
            Starting agent...
            Agent started successfully.

11. Log in to Audit Vault Console as the Audit Vault Administrator user.
           
Open a browser window and enter the following URL:
http://<host name>:<Audit Vault Console port>/av

Note: The Audit Vault Console port is displayed at the end of the Audit Vault Server installation. Refer to page A-5 if you have forgotten the port number. Supply the following:
User Name: avadmin1
Password: oracle_1
Connect as: AV_ADMIN



The Oracle Database 10g Licensing Information page appears. Click “I Agree.” Click the Agent tab and verify that the avagent1 agent is started.



No comments:

Post a Comment