OCP 11g Chapter II Practice

Exercise 2-1 Installing SQL Developer on a Windows computer

In this exercise, you will install SQL Developer on a Windows computer

1. Download the current SQL Developer version from the following URL:

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html (current version is 4.0.3.16.84 2015/1/2)

Platform
Windows 64-bit -zip file includes the JDK 7	Download 311 M
Windows 32/64-bit - installation Notes	Download 226 M

Download the zip file, unzip it to the desired installation directory, and the installation is complete. You can click SQLDEVELOPER.EXE to run the program (you may be prompted to specify the JDK path).

2. Download the 64-bit version that contains the JDK or the 32/64-bit version that does not contain the JDK. (The current version of the JDK support range is JDK1.7.0.51 version, less than 1.8.0 version, please confirm that the correct JDK version is installed, if not installed, go to Oracle Download the latest JDK1.7 version, 1.7.0.72+ (2015/1/2)

Http://www.oracle.com/technetwork/java/javase/downloads/index.html

Exercise 2-2 to confirm available hardware resources

In this exercise, you'll review what resources are available for Windows and Linux.

Windows:

1. Right click on "My Computer" to open the Properties view RAM capacity, Ram at least 512MB, the preferred capacity is more than 1GB (the current machine has hit more than 4GB, no problem)

2. Open the Advanced tab, and then, in the performance Settings-Performance Options dialog box, select the Advance tab to view the virtual memory settings, which should be at least 1.5 times times the amount of memory reported in step 1 ( The current machine can be ignored, I have no virtual memory settings on this machine)

3. Locate the System Temp folder location using the following command in Echo%temp%, confirming that the system file that is returned has at least 400MB of free space on the disk.

4. Confirm that the file system Oraclehome directory has at least 5GB of free space for installing the software and sample database, must be a local disk, not a file server, if you want to copy the media installation software, you need additional approximately 3-4GB space (can be on the file server)

Linux:

1. At the operating system prompt, use the free command to view main memory and swap space

[[email protected] ~]$ free
Total used free shared buffers Cached
mem:3920760 1838580 2082180 0 92724 1409976
-/+ buffers/cache:335880 3584880
swap:2097144 0 2097144

2. Run df-h to view disk device usage

[Email protected] ~]$ df-h
Filesystem Size used Avail use% mounted on
/dev/sda3 57G 19G 36G 34%/
Tmpfs 1.9G 499M 1.4G 27%/DEV/SHM
/DEV/SDA1 97M 29M 64M 31%/boot

Verify that you have 5GB of free space on the Oracle home directory software and database, and that you have more than 400M of available space under/tmp

3. Use RPM to check if all required packages are installed (correct version and updated version)

4. Use Sysctl to check if all required kernel settings have been installed, to perform this operation, requires root privileges.

OCP 11g Chapter II Practice