Install Oracle Audit Vault and DB Firewall step by step ..

Prerequisites 1. Laptop/PC • Latest and fast processors • At least 8GB memory • Windows 64 bit • At least 50 GB free HDD (Hard Disk Drive) • VirtualBox pre-installed. VirtualBox can be downloaded from https://www.virtualbox.org/wiki/Downloads. The activity was performed with release 4.3.4r91027 version of VirtualBox. • Host machine should be able to access guest machine. Later host machine has to access web console of audit vault server. Host Machine: IP Address : 192.168.169.174 Subnet Mask : 255.255.255.0 Gateway : 192.168.169.1 Guest Machine (AV Server): IP Address : 192.168.169.21 Subnet Mask : 255.255.255.0 Gateway : 192.168.169.1 Installation 1. Set Default Machine Folder. • Open VirtualBox • Select File -> Preferences • Enter "D:\ORACLEAVDF\12111" as Default Machine Folder. Once this is set all the VMs created hence forth will be redirected to this location. 2. Create new virtual machine for Audit Vault Server. • Click on "New" icon to create new virtual machine for Audit Vault Serve 3. Give a name for Oracle Audit Vault Server. • Select Type as "Linux" • Select Version as "Oracle (64 Bit)" • Click on "Next" button to continue. 4. Specify memory size for the Virtual Machine. For testing purpose 1.5 GB memory should work. • Enter required memory. Since I have 16 GB RAM in my laptop so I have allocated 3072MB memory. • Click on "Next" button to continue. 5. Add Virtual Hard Disk Drive. • Select "Create a virtual hard drive now" option. • Click on "Create" button. 6. Select Hard Drive File Type • Select "Create a Virtual hark disk now". • Click on "Next" button to continue. This file type allows to split files into size of less than 2GB. A number of files will be automatically created by Virtual Box based on the size of Hard Drive that we specify in coming steps. Select "VMDK (Virtual Machine Disk)". 7. Storage on Physical Hard Drive • Select "Dynamically Allocated" option. • Select "Split into files of less than 2GB" check box. If this check box is selected then single Hard Disk file will be split into smaller files of less than 2GB each. • Click on "Next" button to continue. 8. Choose a location for Hard Disk file • Provide appropriate file name for the virtual hard disk file. • Choose appropriate location to store virtual hard disk file. • Click on "Save" button to save the virtual hard disk file. 9. File Location and Size. • Review the file location. • Enter "130 GB" as the size of file. • Click on "Create" button to create Virtual Hard Disk File. NOTE: If the size of the file is less than 120 GB the installation will terminate with as shown in screenshot below. VM Created 10. Virtual Machine Details. The screen below shows details of virtual machine just created. Review the details and modify if necessary. Use Settings icon to modify any settings. 11. Select Audit Vault Installation Media. • In the main screen of VirtualBox, select "Audit Vault" Virtual machine. • Click on "Settings" icon. • Click on "Storage" • Click on "Empty" CD icon. • Click on "CD icon" on the right side. • Click on "Choose a virtual CD/DVD disk file. 14. Set Network Adapter. • Select Network on the left pane. • Select Enable Network Adapter on the right pane. • Select Attached to as "Bridged Adapter". • Select Name as the available network adapter of your machine. • Click on "OK" button. 13. Details of Installation media. • Review the details of Audit Vault Server installation media. 15. Start installation of Oracle Audit Vault. • Select Audit Vault Virtual Machine on the left pane. • Review the details of Virtual Machine on the right pane. • Click on Start button to start the installation of Oracle Audit Vault Server Installation Main Screen • Type "install" and press "" to continue. 17. Installation in Progress 18. Applying Configuration • Wait until the installer goes to next screen. 19. Enter Installation Passphrase • Enter a strong passphrase. Welcome+1 This passphrase will be used later to change other system passwords. It is recommended to note the password securely for future reference. NOTE: The passphrase should be 8 characters or more and contains an uppercase, lowercase, digit and punctuation. If this policy is violated then following message will be displayed. 20. Confirm Installation Passphrase • Re-enter the installation passphrase for confirmation. • Press "" key to go to next screen. 21. Oracle Audit Vault Installation Successful. Congratulations if you get screen like below screenshot. Installation of Oracle Audit Vault is now completed successfully. • Press "" button to go to next screen. vv 21. Oracle Audit Vault Installation Successful. Congratulations if you get screen like below screenshot. Installation of Oracle Audit Vault is now completed successfully. • Press "" button to go to next screen. 16. 23. Select Management Interface • Select one of the available interface as Management Interface. This will be used to connect to the audit vault server through terminals like ssh, putty e.t.c. for maintenance operations. • Press"" key to make the selection and go to next screen. 25. Specify IP address • Enter IP address, subnet mask and gateway for the management interface. • Press "" key to complete the installation and reboot the server. 26. First Reboot The first reboot of the server could take up to an hour depending upon the configuration of the machine that is being used. There is nothing much to do here other than wait until the installation completes. 27. Audit Vault Server Installation Complete Screenshot below shows the final screen after the installation of Oracle Audit Vault server is completed. Use Up/Down arrow keys and press "" key to make appropriate selection. D. Post Installation Login to Database Vault Web Console 1. Open a web browser in your host machine and enter following url in the address bar https://192.168.169.21 2. Press "" key to go to the specified url. 3. Click on "Proceed Anyway" button. Enter Installation Passphrase • Enter Installation Passphrase. • Click on "Login" button. Time and DNS configuration Time Setup: Select "Set Manually" option. Set proper date and time. DNS Setup: We will not use DNS in this setup. Click on "Save" button at the upper right corner. Login to Audit Vault Server console • After "Save" button is clicked, system will automatically redirect to Login page. • Login as "AVADMIN" user. Provide the username and password. • Click on "Login" button. AAudit Vault Home page After successful login, system redirects to Audit Vault Server console home page. Congratulations.......! Audit Vault Server 12.1.1.1.0 installation completed successfully. User Configuration • Enter username and password for the users to be configured. • User Setup: Users AVADMIN and AVAUDITOR are created in Oracle database. • Users "root" and "support" are created in operating system. While connecting to the audit vault server using terminals like ssh and putty, first login as support user then switch to other users. User "oracle" is implicitly created in the operating system. 6. Time and DNS configuration Time Setup: Select "Set Manually" option. Set proper date and time. DNS Setup: We will not use DNS in this setup. Click on "Save" button at the upper right corner. 7. Login to Audit Vault Server console • After "Save" button is clicked, system will automatically redirect to Login page. • Login as "AVADMIN" user. Provide the username and password. • Click on "Login" button. Audit Vault Home page After successful login, system redirects to Audit Vault Server console home page. Congratulations.......! Audit Vault Server 12.1.1.1.0 installation completed successfully. DB FIREWALL INSTALLATION 5. Add Virtual Hard Disk Drive. • Select "Create a virtual hard drive now" option. • Click on "Create" button. 7. Storage on Physical Hard Drive • Select "Dynamically Allocated" option. • Select "Split into files of less than 2GB" check box. If this check box is selected then single Hard Disk file will be split into smaller files of less than 2GB each. Small size of files help during transfer to external hard disk drives for testing purposes. • Click on "Next" button to continue. 9. File Location and Size. • Review the file location. • Enter "130 GB" as the size of file. • Click on "Create" button to create Virtual Hard Disk File. NOTE: If the size of the file is less than 80 GB the installation will terminate with as shown in screenshot below. 11. Select Database Firewall Installation Media. • In the main screen of VirtualBox, select "Database Firewall" Virtual machine. • Click on "Settings" icon. • Click on "Storage" • Click on "Empty" CD icon. • Click on "CD icon" on the right side. • Click on "Choose a virtual CD/DVD disk file 14. Set Network Adapter. Installation of Oracle Database Firewall requires 3 network adapters. Network Adapter 1: • Select Network on the left pane. • Select "Adapter 1" tab • Select Enable Network Adapter on the right pane. • Select Attached to as "Bridged Adapter". • Select Name as the available network adapter of your machine. Network 1 15. Start installation of Oracle Database Firewall Server. • Select Database Firewall Virtual Machine on the left pane. • Review the details of Virtual Machine on the right pane. • Click on Start button to start the installation. 192.168.1.124 dbfirewall https://192.168.1.121 5. Post Installation Configuration As a part of post installation configuration an administrator user for Database Firewall has to be created and password of root and support user has to be reset. • Enter FWADMIN as username. Usually administrator user for Database Firewall is named as FWADMIN. THIS USERNAME IS CASE SENSITIVE. • Users "root" and "support" are created in operating system. While connecting to this server using terminals like ssh and putty, first login as support user then switch to other users. User "oracle" is implicitly created in the operating system. By default database named "dbfwdb" is created. • Click on "Save" button after all the information has been filled. Welcome+1 6. Login to Database Firewall web console System will redirect to the login screen after Save button is clicked in the earlier screen. • Enter the username and password for the administrator user of Oracle Database Firewall. • Click on Login button to login to the web console. 7. Check System Status On initial login, Database Firewall web console shows the status. • Click on Show Report button to check Diagnostic Status. 8. Configure Network Interfaces and Hostname • Click on "Network" link on the left panel. • Click on "Change" button at the bottom of the right corner. • Change the hostname to "fwserver01". • In "Proxy Ports" section, select "Enabled" check box, enter "15211" as port number and click on "Add" button. • In Traffic Sources section, change the IP address from "192.168.0.220" to "192.168.168.23". • Click on "Save" button. This usually requires a reboot but we will restart the server once all the post-installation configuration is complete. Review the image below. before after 9. DNS and Access configuration • Click on "Services" link on the left panel. • Click on "Change" button on the right panel. • Leave the DNS Server configuration unchanged i.e. leave values of "DNS Server 1", "DNS Server 2" and "DNS Server 3" to "disabled". • Set the value of "Web Access" to "all". • Set the value of "SSH Access" to list of IP address from where this server will be accessed. The list of IP addresses should be separated by space. • Leave the value of "SNMP Access" to "disabled". • Review the changes. • Click on "Save" button. 10. Change Date and Time • Click on "Date and Time" from system menu on the left panel. • Click on "Change" button at the corner of right panel in the bottom. 11. Change Keyboard Layout 12. Post-Install Configuration Complete • This completes post-installation configuration of Oracle Database Firewall. • After network settings has been changed Database Firewall asks for reboot of server. In such cases it is recommended to reboot the server. 13. Reboot Server • Login to the database firewall server. • Select "Power Off" using Up/Down arrow keys as shown in image below. • Press "Enter" button. • Enter "root" user pasword when prompted. • Press "Enter" to shutdown the server. • To start server, select Database Firewall machine in VirtualBox Manager and click on start ico ==== Register the Database Firewall in the Audit Vault Server 12.1.1.1 integrating Audit Vault and Database Firewall. You must associate each Database Firewall with an Audit Vault Server by specifying the server's certificate and IP address, so that the Audit Vault Server can manage the firewall. If you are using a resilient pair of Audit Vault Servers for high availability, you must associate the firewall to both servers. Note: You must specify the Audit Vault Server certificate and IP address to the Database Firewall before you register the firewall in the Audit Vault Server. Registering database firewall in audit vault server requires 2 steps. They are: A. Specify the Audit Vault Server certificate and IP address in Database Firewall B. Register the Database Firewall in the Audit Vault Server A. To specify the Audit Vault Server certificate and IP address in Database Firewall 1. Log in to the Audit Vault Server as AVADMIN. 2. Copy Audit Vault Server certificate. • Click the Settings tab. • In the Security menu, click Certificate. The server’s certificate is displayed. • Copy the server’s certificate into your clipboard or into a text file (if you use a text file it must be securely deleted afterwards). Make sure you also copy the header and footer (-----BEGIN CERTIFICATE----- and -----END CERTIFICATE-----) Audit Vault certificate: -----BEGIN CERTIFICATE----- MIIFlzCCA3+gAwIBAgIJAK13Xmyu3+j2MA0GCSqGSIb3DQEBBQUAMDsxOTA3BgNV BAMMMEFWU19DQV9DZXJ0LTkwZGJhOTYwLTU0ODUtNGY0My1iYmMxLTM1OTg3ODk3 N2U3ZTAeFw0xNTExMjUwODE3MzJaFw0yNTExMjIwODE3MzJaMDsxOTA3BgNVBAMM MEFWU19DQV9DZXJ0LTkwZGJhOTYwLTU0ODUtNGY0My1iYmMxLTM1OTg3ODk3N2U3 ZTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAJQgf/z9g+3S1Xh3PkwO HCEWbQk8VsIBczwGka3Xa8muASkKpLzJ4RGr4Dy/5EyJ5irAdDcdIhAb05HYZFwk PAJn+3TRXT2MFJ1NG6hwytDEZo82n5Ruhmlx/oJAoTbczFswK9R3i7ePKG6JHkqj CLgUFqBxS1PhFOz8m2vfn8pblq1h/mpYmzJOrnfZLSarPCx/rpM6lRna+xK/ulzW Bp8ndMAecQ03iyrLiTsM0QR4WhSM07WOob2HUO+f17Cz5w/+GG3tsxIbUiGbHy+7 GALjSBK57x35iw7RsMK0eu0KlVuR6V3RYBFQ3vvWbT254fh9TRQuuo8mkyVkg5aW WDMq2cKHTO74R/n0XDZ3XtmHVg35jWgHK0v7NxCx4RSdxFh7ryoP+rsEMIZ5AisC THh/L8xWej1jS2AOtP5POl7J+fsfmPhUGGMLCmvQSw9zzibqc96iDg9Dsvii73q3 59yModzaJw+Q/0fQ4j3zqDOpqcKIk5zjrMGVCa/zr9AVDQ53h+eMZ4t28mVAZdZL uJf20j82Zybq/lrjqKHDBqFue48A2VFGGoIn5xehZuqEkWvP5S/j3K9tig21CJQ9 Up4c555O0edrbmzGcXNXjoHeYKSll6z5c+euqzEoGnLtoUOAwdPDsfHaSzDPCtf8 6x/qTD3zSPP/1NW4cZ2QUm+pAgMBAAGjgZ0wgZowHQYDVR0OBBYEFFsOZMD9taTw 310oN2M/obLdmEnxMGsGA1UdIwRkMGKAFFsOZMD9taTw310oN2M/obLdmEnxoT+k PTA7MTkwNwYDVQQDDDBBVlNfQ0FfQ2VydC05MGRiYTk2MC01NDg1LTRmNDMtYmJj MS0zNTk4Nzg5NzdlN2WCCQCtd15srt/o9jAMBgNVHRMEBTADAQH/MA0GCSqGSIb3 DQEBBQUAA4ICAQA2BBpzM3xyljZGrNVHi/WfVpcXrj8pRpnXGuAZpBHrvjmO6VNG Ft3tH2/SGr65W589Q8PXzhou+WFtI7IzJ3GLYgJYBbFOjLhGPfCMKdJtWvzKcmUu I15CkbqKlNFGQc/8x/9vRctC6tE/dD7rbKv8v1z1blAcMJHNTOqXRd8lxSMGcO/u SQcYgE+qljXhlQjL1AocFhhFsk8IF5R0AW7B8sajA9VjewV3572mg0eyLuijH2Vd 22sWZPtSWD0mhU3qPT5SKGfJmLu7BX58vbUVH5LxeoXtdQ+bsMMvXGMXxjVjUMEz nAE/HZFbKoowPe5OuwvINpUC77s4xL4O12XDkzwcJc498jNgpEKWiF4+QcyIT3n7 BgbIhndDrfygsNKL2R9r30Wv1bkaBQKQDtDKJaUJzvUAhemUzd8nBcSQ5BDshjNp pjfVPlIfHXPoHAVkFgUceYfTpn0JrAc9sn99Db2Enp+0ynzbaut3g1IJ8ZJfXsZf 7b5I2is8K9mPar0XienaevD+fFNcJ6aG1Q1oNBPoBxiatHAiq5Gf/ho1ZFS0GM2C fAGjWKr/BPjiDM76HpvMcywhmGAl07GcJ9CNAC8gRawDvfCP6Ue02u1NLCaqF/Pa TTMtg2e6lfin8RviYE/o92nbFkWa+GUUTTZJYBTxWTx5O/uHr1LPpMcpxA== -----END CERTIFICATE---- 3. Log in to the Database Firewall administration console. 4. In the System menu, click Audit Vault Server. • Enter the IP Address of the Audit Vault Server: 192.168.169.21 • Paste the Audit Vault Server’s Certificate in the next field. • Click on "Apply" button. B. Register the Database Firewall in the Audit Vault Server You must register the Database Firewall in the Audit Vault Server in order to enable communication between the two. To register a Database Firewall in the Audit Vault Server: 1. Log in to the Audit Vault Server as an administrator (AVADMIN) 2. Register Database Firewall in Audit Vault Server • Click on "Firewall" tab. • Click on "Register" button. This will open new page. 3. Save Registration • Enter name of the Database Firewall in the "Name" field. • Enter IP Address of the Database Firewall in the "Address" field. It is preferred to use the actual hostname for the firewall that you had set earlier. It makes it easier to keep track of servers in production environment. • Click on "Save" button. In the above screen the user logged in is fmwadmin . create user fwadmin ..and copy the vault server ceritvicate to fw console ..then try registering . it will work  4. Registered Firewalls • You will see screen like in below screenshot if you have successfully completed above steps. 5. Test Database Firewall Diagnostics • Click on "Settings => Status => Test Diagnostics" to ensure that everything is running correctly. • Everything should have a green "OK" next to it like in the next screenshot. 6. Check Database Firewall Status • Click on Home, and check the firewall status. • If the status is "GREEN" then all set up correctly. • If there is an error message that indicates that there is a problem with the certificate, check that the date and time are the same on the Audit Vault server and the Database Firewall Appliance.

ORACLE AUDIT VAULT AND DB FIREWALL 11g

Guys ,now am working on ORACLE AUDIT VAULT AND DB FIREWALL 11g for a Bank . Will share the details on.. 1. ORACLE AUDIT VAULT AND DB FIREWALL 11g Overview 2. How to Install and Configure 3. How to Implement HA 4. How to deploy agents in the target database servers 5. How to perform the auditing 6. How to set policies in DB Firewall

how-to-install-oracle-grid-control-11g-step-by-step-guide.html

http://www.gokhanatil.com/2011/07/how-to-install-oracle-grid-control-11g-step-by-step-guide.html https://docs.oracle.com/cd/E11882_01/install.112/e41961/toc.htm https://docs.oracle.com/cd/E11882_01/install.112/e41961.pdf http://www.oracledba.org/11gR2/Install_11gR2_Grid_Infrastructure.htm

ORACLE DATABASE 10g to 11g UPGRADE

http://www.oracle.com/technetwork/database/upgrade/11gr2-upgrade-methods-wp-2011-486336.pdf Complete Checklist to Upgrade the Database to 11gR2 Using DBUA (Doc ID 870814.1) Good One : http://www.dbas-oracle.com/2011/06/step-by-step-manual-database-upgrade-to.html For Manual Upgrade check the below 2 links https://lessonsfromoracle.wordpress.com/2013/11/25/oracle-database-upgrade-steps-10-2-0-4-to-11-2-0-3/ https://somireddy.wordpress.com/2013/04/24/step-by-step-manual-database-upgrade-to-11-2-0-2-from-10-2-0-4/ http://facedba.blogspot.qa/2014/09/upgrade-oracle-database-from-10204-to.html https://www.youtube.com/watch?v=6F4_CeCJHoM https://oracle-base.com/articles/11g/upgrading-to-11g

ORACLE Audit Vault and Database Firewall (ORACLE AVDF)

Very good URL http://insightintooracle.blogspot.qa/2014/01/installing-oracle-avdf-database.html https://www.youtube.com/watch?v=f48Cz99iHuQ https://docs.oracle.com/cd/E37100_01/doc.121/e27778/toc.htm https://docs.oracle.com/cd/E37100_01/doc.121/e27778.pdf https://docs.oracle.com/cd/E37100_01/doc.121/e27778/preinstall.htm#SIGIG170 https://docs.oracle.com/cd/E37100_01/doc.121/e27778/install.htm#SIGIG177 Installing Oracle AVDF (Database Firewall) Server 12.1.1.1.0 Installation of Oracle Audit Vault and Database Firewall (AVDF) 12.1.1.1.0 comprises of installing Audit Vault first and then Database Firewall. Oracle Audit Vault and Database Firewall come in two different installation medias. I have discussed on installation of Oracle Audit Vault in my previous post. This document deals with the installation of Oracle Database Firewall Server only. Oracle Audit Vault and Database Firewall (Database Firewall) provides a first line of defense for databases and consolidates audit data from databases, operating systems, and directories. A highly accurate SQL grammar-based engine monitors and blocks unauthorized SQL traffic before it reaches the database. Database activity data from the network is combined with detailed audit data for easy compliance reporting and alerting. With Oracle Audit Vault and Database Firewall, auditing and monitoring controls can be easily tailored to meet enterprise security requirements. For details on Oracle AVDF please visit http://www.oracle.com/technetwork/database/database-technologies/audit-vault-and-database-firewall/overview/overview-1877404.html. Following are the top level steps that needs to be performed to install Oracle Database Firewall Server 12.1.1.1.0: A. Media Download B. Prerequisites C. Installation D. Post Installation A. Download Media 1. Download media from https://edelivery.oracle.com/. · Open a web browser. · Type https://edelivery.oracle.com/ in the address bar. · Press "" key. · Click on "Sign In / Register" button. Image AVDF-121110-DF-01.png 2. Login to edelivery Sign In / Register button redirects to the login screen. · Provide login username and password. · Click on Sign in button to login. Image AVDF-121110-DF-02.png 3. Search Required Media · In Product pack select Oracle Database. · In Platform select Linux x86-64. · Select "Oracle Audit Vault and Database Firewall 12.1.1 Media Pack for Linux x86-64". · Click on "Go" button to search. Image AVDF-121110-DF-03.png 4. Download Media · Click on "Download" button next to "Oracle Audit Vault and Database Firewall (12.1.1.1.0) - Server" to download Audit Vault Server. · Click on "Download" button next to "Oracle Audit Vault and Database Firewall (12.1.1.1.0) - Database Firewall" to download Database Firewall. I will cover this in my next post. Image AVDF-121110-DF-04.png B. Prerequisites 1. Laptop/PC · Latest and fast processors · At least 8GB memory · Windows 64 bit · At least 50 GB free HDD (Hard Disk Drive) · VirtualBox pre-installed. VirtualBox can be downloaded from https://www.virtualbox.org/wiki/Downloads. The activity was performed with release 4.3.4r91027 version of VirtualBox. · Host machine should be able to access guest machine. Later host machine has to access web console of Database Firewall server. Host Machine: IP Address : 192.168.169.174 Subnet Mask : 255.255.255.0 Gateway : 192.168.169.1 Guest Machine (DF Server): IP Address : 192.168.169.22 Subnet Mask : 255.255.255.0 Gateway : 192.168.169.1 C. Installation 1. Set Default Machine Folder. · Open VirtualBox · Select File -> Preferences Image AVDF-121110-DF-05.png Enter "D:\VM\AVDF\12111" as Default Machine Folder. Once this is set all the VMs created hence forth will be redirected to this location. Image AVDF-121110-DF-06.png 2. Create new virtual machine for Database Firewall Server. · Click on "New" icon to create new virtual machine for Database Firewall Server. Image AVDF-121110-DF-07.png 3. Give a name for Oracle Database Firewall Server. · Select Type as "Linux" · Select Version as "Oracle (64 Bit)" · Click on "Next" button to continue. Image AVDF-121110-DF-08.png 4. Specify memory size for the Virtual Machine. For testing purpose 1.5 GB memory should work. · Enter required memory. Since I have 16 GB RAM in my laptop so I have allocated 3072MB memory. · Click on "Next" button to continue. Image AVDF-121110-DF-09.png 5. Add Virtual Hard Disk Drive. · Select "Create a virtual hard drive now" option. · Click on "Create" button. Image AVDF-121110-DF-10.png 6. Select Hard Drive File Type · Select "VMDK (Virtual Machine Disk)". · Click on "Next" button to continue. This file type allows to split files into size of less than 2GB. A number of files will be automatically created by Virtual Box based on the size of Hard Drive that we specify in coming steps. Image AVDF-121110-DF-11.png 7. Storage on Physical Hard Drive · Select "Dynamically Allocated" option. · Select "Split into files of less than 2GB" check box. If this check box is selected then single Hard Disk file will be split into smaller files of less than 2GB each. Small size of files help during transfer to external hard disk drives for testing purposes. · Click on "Next" button to continue. Image AVDF-121110-DF-12.png 8. Choose a location for Hard Disk file · Provide appropriate file name for the virtual hard disk file. · Choose appropriate location to store virtual hard disk file. · Click on "Save" button to save the virtual hard disk file. Image AVDF-121110-DF-13.png 9. File Location and Size. · Review the file location. · Enter "130 GB" as the size of file. · Click on "Create" button to create Virtual Hard Disk File. Image AVDF-121110-DF-14.png NOTE: If the size of the file is less than 80 GB the installation will terminate with as shown in screenshot below. Image AVDF-121110-DF-15.png 10. Virtual Machine Details. The screen below shows details of virtual machine just created. Review the details and modify if necessary. Use Settings icon to modify any settings. Image AVDF-121110-DF-16.png 11. Select Database Firewall Installation Media. · In the main screen of VirtualBox, select "Database Firewall" Virtual machine. · Click on "Settings" icon. · Click on "Storage" · Click on "Empty" CD icon. · Click on "CD icon" on the right side. · Click on "Choose a virtual CD/DVD disk file..." Image AVDF-121110-DF-17.png 12. Choose Virtual Optical Disk file. · Select Database Firewall ISO image file "V39779-01_DF.iso". Original filename was "V39779-01.iso". · Click on "Open" button to select the file. Image AVDF-121110-DF-18.png 13. Details of Installation media. · Review the details of Database Firewall Server installation media. Image AVDF-121110-DF-19.png 14. Set Network Adapter. Installation of Oracle Database Firewall requires 3 network adapters. Network Adapter 1: · Select Network on the left pane. · Select "Adapter 1" tab · Select Enable Network Adapter on the right pane. · Select Attached to as "Bridged Adapter". · Select Name as the available network adapter of your machine. Image AVDF-121110-DF-20.png Network Adapter 2: · Select Network on the left pane. · Select "Adapter 2" tab · Select Enable Network Adapter on the right pane. · Select Attached to as "Bridged Adapter". · Select Name as the available network adapter of your machine. · Select Promiscuous Mode as "Allow All". Image AVDF-121110-DF-21.png Network Adapter 3: · Select Network on the left pane. · Select "Adapter 3" tab · Select Enable Network Adapter on the right pane. · Select Attached to as "Internal Network". · Select Name as the available network adapter of your machine. · Select Promiscuous Mode as "Allow All". · Click on "OK" button. Image AVDF-121110-DF-22.png 15. Start installation of Oracle Database Firewall Server. · Select Database Firewall Virtual Machine on the left pane. · Review the details of Virtual Machine on the right pane. · Click on Start button to start the installation. Image AVDF-121110-DF-23.png 16. Installation Main Screen · Type "install" and press "" to continue. Image AVDF-121110-DF-24.png 17. Installation in Progress Image AVDF-121110-DF-25.png 18. Applying Configuration · Wait until the installer goes to next screen. Image AVDF-121110-DF-26.png 19. Enter Installation Passphrase · Enter a strong passphrase. This passphrase will be used later to change other system passwords. It is recommended to note the password securely for future reference.

ERP 12.2.3 storage migration plan

ERP 12.2.3 storage migration plan 1. Pre health checks. 2. Creation New diskgroup(+OCR) with normal redundancy containing 3 disks. 3. Stop Both application nodes(erppap01,erppap02). 4. Stop both the instances(PIC1 & PIC2). 5. Move ocr and votedisk to new diskgroup(+OCR). 6. Move asm spfile to new diskgroup(+OCR). 7. Move controlfile into multipule diskgroups(+PEBSDG1,+FRA,+OCR). 8. Stop RAC nodes(erppdb01,erppdb02). 9. Start RAC nodes (erppdb01,erppdb02). 10.Start the instances (PIC1 & PIC2). 11.Add New disks to (+PEBSDG1). 12.Add New disks to (+FRA). 13.Once the data get mirror into new disks remove old disks from diskgroups (+PEBSDG1,+FRA). 14.Start Both application nodes(erppap01,erppap02). 15.Stop and Start the complete PNHIC environment. 16.Removable of old LUN's ( Mr Sajan ). 17.Post health checks. 18. Release instance.

Refere : http://www.jobacle.nl/?p=868 Very informative blog Save money by understanding the Oracle licensing model At several companies I worked for, most of the time a lot of confusion exists about the licensing model of Oracle. The general feeling was that they paid too much for their use of Oracle products, and they were not certain of their compliancy. This post will try to give some clarity about this issue. The information in this post is not intended to be used as legal statements or sources for negotiations with Oracle. I will be referring to some other documents which can and must be used. The information is not supposed to be exhaustive but will hopefully give the reader an idea of the licensing model of Oracle at this moment (2010). The post has been checked by Daniel Hesselink from License Consulting who suggested some very usefull additons. Thanks Daniel! Subjects in this post: License Levels Prices Species of Databases Types of licences Processor based Named User based Employee based Support Support on VMware Cost and pitfalls Sources Differences between Enterprise, Standard and Personal Edition (link to notes) License levels Three levels to be recognized: ‘Full Use’ level = end-user license, you may do with the database what you want, like running (several) tailor-made applications on it. ‘Application Specific Full Use’ (ASFU) = Example: SAP. You can only use the Oracle software for that particular purpose. ‘Embedded Software License’ (ESL). Only to be used for specific to be used applications, and the database schema is not accessible to the end user but only to the aplication (runtime). Scope in this post: ‘Full Use’ – level. You may use the Oracle software free for generally 30 days , after downloading and installation. This period may sometimes be extended to (generally) 90 days after consulting Oracle, and is used for ‘proof of concepts’ and that kind of things. This type of license is not a formal license-level, and is known as the ‘developers’ license. Prices First year’s costs can be calculated as: ( purchase + support (22%)) – purchase discount. Costs of second and all the next years: Support-costs – staggered discount. Purchase without support is possible, you only get no Metalink support and patches. Purchase is also possible for a period of 1, 2, 3, 4 or 5 years (Term License), but then you are required to purchase support with it (based on the list-price!). On www.oracle.com are the so-called ‘list-‘ prices in dollars. These are the prices with no purchase-discount at all. This discount depends greatly on the volume you buy, and there are some fixed ‘staggered’ discounts you can agree on with Oracle. A minimum purchase of 100.000 Euro is a common amount for getting any discount and a percentage of of 25 to 40% for large customers should be reachable. Remember that these discounts are only given on the purchase, not on the yearly support…. when you won’t negotiate about it 😉 This works the same as for the license discount. By the way: the discount is based on the sum of the purchases. When you decide over time to end a part of the purchage, this will lead to a recalculation, and could be influencing your yearly costs, because of stumbling into a lower staggered discount. Prices will be adjusted regularily. If changes happen, they occur within June. For Europe, changes will also depend on the rate of the dollar. Oracle has also a so-called ‘Matching Service Level Policy’: sometimes it does not matter what you are using, but it does matter what you bought in the past. Example: you purchased database licenses for 3 servers, but only use one server, then you will be charged for 3 servers when you purchase an additional ‘management-pack’ for those databases. Those management-packs are linked one on one to the databases. Oracle does not pro-actively monitor this at this time.. only on an order-by-order basis, and when customers try to de-support a part of the license stack later in time. So it helps sometimes to act low-profile…. Species of databases Enterprise Edition (multi-user database). Most expensive, complete database. Standard Edition (multi-user database). Less functionalities, e.g. no online index rebuild, on servers with a maximum of 4 sockets. Standard Edtition One. On servers with a maximum of 2 sockets. Personal Edition (single user database). Lite Edition (mobile devices) Enterprise Edition is required with the following configurations: When the server has got more than 4 sockets or You are using Oracle Enterprise Manager Packs, like Tuning pack or You are using Database Options (e.g. Partitioning) You have to pay for the Database Options, besides the ‘standard’ database licenses: Real Application Clusters Partitioning Advanced Security Database Vault Advanced Compression Active Data Guard Real Application Testing Label Security Total Recall Spatial In-Memory Database Cache Data Mining OLAP Media Pack For Apex and Oracle10 XE , no licensies are necessary. Types of licenses With ‘Full Use’ licentie there can be chosen from 3 types of licensies: Processor based (Proc) Named User Plus (NUP) Employee (EMP) – license. 1. Processor based (Proc). Here you pay per processor, but a processor under the definition of Oracle. As the processors become increasingly powerful and have multiple cores, Oracle has created a “core element”. For Intel and AMD dual-core CPU typically a factor of 0.5 for each core is used, so Oracle will count this processor as 1 Oracle processor (2 cores x 0.5 = 1). This is no different from the number of CPUs in this case. But customers also uses servers with 2 quad core cpu’s. Suppose this has also a factor of 0.5, so Oracle will count this as four processors: 2 CPUs x 4 cores = 8 cores. 8 cores x 0.5 = 4 Oracle processors. The core-factor-table Oracle uses is to be found here. Thus, if a database on a server is installed on two quad core processors running as previous example, 4 processor licenses must be paid for. On that server you are free to install multiple databases, regardless of the version! The processor-based license is paid per server and not per database. Oracle is not supporting virtual servers, except their own OracleVM. A consequence is that in virtualization with VMware for example, the underlying number of hardware processor are calculated. Extreme example: on a cluster ESX (VMware) with 3 nodes, each with two quad core processors, a VM is created. On a VM is an Oracle database installed, and one (1) virtual processor is assigned. In terms of technique uses this virtual server is actually only one core of the available 24 (3 nodes x 2 CPUs x 4 cores). License Technically you pay the underlying hardware. When the factor of the CPU concerning is e.g. 0.5, then you will be settled on 24 cores x 0.5 = 12 processors for this one database. 2. Named User Plus (NUP). What does it mean: • A person in any way data viewing and / or importing data into an Oracle database • A non-human operated device. This may be scanning robot for example, but also an information board at a station, if it also actively approaches the database. A batch process, however, is not considered as Named User. This is an escape worth thinking of ! • With multiplexers (such as application servers) the real users are counted and not just the user that the database approaches. When the application server is connected to the outside world (web application), it is not possible to license under NUP, and you have buy processor-based licenses. The name also suspect that there’s a “Named User” license exists without ‘Plus’. In the past it did exist indeed, but with the recent licensing change, this was changed in NUP. A named-user is attached to a database, but with a minimum purchase. You may not purchase a database license with eg 2 named-users. Oracle will take the server as base. For an Enterprise Edition is a minimum purchase of 25 users per processor (definition of Oracle) required, for a Standard Edition a minimum purchase of five users per organization. An application server 10 per processor. Example of the latter: If there are 10 Enterprise Editon databases running on a server with two quad-core processors, and there are a total of 50 developers, then based on the NUP minimum number of 100 users is calculated: 2 quad-core = 8 cores. With the factor of 0.5 released: 4 Oracle processors. Minimum of 25 users per processor = 100 users. 3. Employee based (Emp). This is all the staff: Full-time Part-time Temporary staff Hired consultants Staff of companies which are executing the outsource of that company. This type of license is for a limited number of products possible, for example BI Publisher. Not the users of the system are counted, but the number of people who are employed, fixed, temporary or outsourced. Support Oracle has got a Lifetime Support Policy , This means that there is always support for different versions, but is limited after the ‘normal’ support period (five years after general availability date). Support-table: Release General availability date End of Premier Support End of Extended Support (to pay for) End of Sustaining Support 9.2 Jul 2002 Jul 2007 Jul 2010 Indefinite 10.1 Jan. 2004 Jan 2009 Jan 2012 Indefinite 10.2 Jul 2005 Jul 2010 Jul 2013 Indefinite 11.1 Aug 2007 Aug 2012 Aug 2015 Indefinite 11.2 Sep 2009 Jan 2015 Jan 2018 Indefinite Premier support usually ends five years after the release of a version. When a customer really wants it, he can buy off the same level of support by switching to extended support. For extended support you’ll have to pay extra: Year 6 after product release: 10% of current year’s Software Update License & Support Year 7 after product release: 20% of current year’s Software Update License & Support Year 8 after product release: 20% of current year’s Software Update License & Support Extended Support offers the following: Updates, fixes and security alerts Tax, legal and regulatory updates Upgrade scripts Technical support Major product and technology releases Quotes Oracle for sustaining support: Sustaining Support will be available for as long as you license your Oracle products. With Sustaining Support,you receive technical support, including access to our online support tools, knowledgebases, andtechnical support experts. You benefit from Major product and technology releases Technical support Access to My Oracle Support Fixes, updates, and critical patch updates created during the Premier Support stage Sustaining Support does not include: New updates, fixes, security alerts, data fixes, and critical patch updates New tax, legal, and regulatory updates New upgrade scripts Certification with new third-party products/versions Certification with new Oracle products Support on VMware Oracle will give no formal support on Oracle product running on virtual software, unlike oracleVM. Bottom-line is that questions are to be answered, but serious problems will first be ‘replayed’ on physical hardware. Note 249212.1 on Oracle Support: Support Status for VMware Virtualized Environments “. Quote here: Oracle has not certified any of its products on VMware virtualized environments. Oracle Support will assist customers running Oracle products on VMware in the following manner: Oracle will only provide support for issues that either are known to occur on the native OS, or can be demonstrated not to be as a result of running on VMware. Cost and pitfalls Generally you can save money by installing as much as possible Standard Edition (One) Databases instead of Enterprise Edition Database. But there are more factors than just saving costs, and you should carefully consider all the options. When using VMware the underlying processor-capacity (ESX-servers) is used as base for the licenses, and may only be usefull when there are a lot of VM’s with Oracle software. Support-issues still play a major role in this, so be carefully using this. When using standby-databases with a processor based licensing, you have to count both servers (primary and standby) ! Generally it is cheaper to license a development- and a test- environment as NUP, but recalculate this per database/purchase. The following rule will mostly be valid: when (sum named users) / (sum processors) >= 50, then choose for processor-license. When you don’t pay a license anymore, the status will be internally set as ‘expired’. But when there are suddenly licenses needed, this may be set ‘active’ within a year, with only a fine of 50% on the support-costs. Should be a lot cheaper then buying new licenses. When you actively ends it, it will be set to terminated and you can no longer re-activate it (although exeptions occur if you insist whithin a resonable time timeframe after the termination). When using options,like partitioning or spatial, centralize the databases which will use these options as much as possible on one server, as you have to license just one server in that case. You need approval from Oracle (account-managers level) to install two species of database on the same server. E.g. Standard Edition and Enterprise Edition may officially not reside on the same server. But Oracle may hardly complain when you install a Standard Edition database on a server which has been licensed as an Enterprise Edition server. You paid for a Rolls! Sources Software Investment Guide: http://www.oracle.com/corporate/pricing/sig.pdf Processor-factor tabel: http://www.oracle.com/corporate/contracts/library/processor-core-factor-table.pdf Prijslist: http://www.oracle.com/corporate/pricing/technology-price-list.pdf Support: http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf Metalink note 249212.1 : Support Status for VMware Virtualized Environments With special thanks to Peter Vermaat of Transfer Solutions and Erwin de Kok of Logica Differences between Enterprise, Standard and Personal Edition Starting point: Note 465455.1 Content of this note: Server Version Note # ABSTRACT ==================================================================== 8.1 NOTE.112591.1 Differences Between Enterprise, Standard and Personal Editions on Oracle 8.1 9.0 NOTE.161556.1 Differences between Oracle9i Personal, Standard and Enterprise on NT/2000 9.2 NOTE.269040.1 Differences Between Enterprise, Standard and Personal Editions on Oracle 9.2 10.1 NOTE.271886.1 Differences Between Different Editions of Oracle Database 10G 10.2 NOTE.465465.1 Differences Between Enterprise, Standard and Personal Editions on Oracle 10.2 11.1 Note.465460.1 Differences Between Enterprise, Standard and Personal Editions on Oracle 11.1 11.2 Note.1084132.1 Differences Between Enterprise, Standard and Personal Editions on Oracle 11.2 By admin|August 8th, 2010|Categories: Database, licensing, Meta-DBA|Tags: license, linkedin|18 Comments Share This Story, Choose Your Platform! About the Author: admin