Getting Started
Getting Started
Oracle, VMware, and Red Hat have teamed up to provide everything you need to run Oracle Database 10g on Linux environment on your Windows desktop - including the operational infrastructure and step-by-step instructions on how to use Oracle Database 10g with Real Application Clusters.
In less than one hour you will be up and running with preinstalled and configured Oracle software running inside a Red Hat Virtual Machine.
The following topics are discussed:
This is strictly for evaluation / development use. Oracle will not support a deployment use of this software.
 Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so, depending on your Internet connection, may result in a slow response time.)
Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.
This kit includes a comprehensive collection of technical whitepapers, seminars and customers and partner videos highlighting the benefits of Oracle Database 10g Release 2. Also included are Oracle By Example (OBE) step-by-step tutorials on how to use unique features of Oracle Database 10g. The provided database is preloaded with all the sample schemas required to complete the OBE tutorials. The kit also includes the following:
 |
Oracle Instant Client (Windows ODBC/JDBC/OCI support). |
|
Oracle Migration Workbench (Migrate most other databases into Oracle). |
|
Oracle Universal Installer (OUI, Used to install the VM). |
|
VMware Workstation v5.0.0 build 13124 |
Back to Topic List
To watch customer and partner videos, listen to seminars, read white papers and try self-study exercises:
|
400 MHz or faster CPU minimum (500 MHz recommended) |
|
DVD drive |
To install and evaluate Oracle Database 10g with Real Application Clusters on Red Hat Enterprise Linux 4 using VMware Workstation:
Back to Topic List
Back to Topic List
Follow the steps below to install your Desktop Data Center
| 1. |
You first need to register with VMware to receive an evaluation serial number for the VMware workstation software on the VMware website: http://www.vmware.com/vcommunity/technology/vm/oracle.html
Once you receive an email with your serial number, you can proceed to the next step.
You do not need to download VMware Workstation 5.0 from the Vmware site; the Oracle Universal Installer will automatically install it for you.
The evaluation period is 90 days. To continue using this evaluation kit after that time you may purchase a license from VMware at the following URL: https://www.vmware.com/vmwarestore/newstore/index.jsp
|
| 2. |
Launch the Oracle Universal Installer by running Setup.exe from the install directory on Your Desktop Data Center DVD 1.
|
| 3. |
The Oracle Universal Installer Welcome window appears. Select Next to begin the installation of your software
|
| 4. |
A license agreement appears. Click I accept the License Terms and Export Restrictions.
|
| 5. |
The Specify Home Details page appears. The Virtual Machine will be installed in the Destination (referred to as an Oracle Home) you select. The required space on that folder is 12 GB. Then click Next.
|
| 6. |
As part of the installation of this kit, OUI will prompt you to install VMware Workstation software on your Windows system. Make your selection, then click Next.
Note: It is strongly recommended that you choose to install VMware even if you already have it installed on your PC. The Oracle Universal Installer will deinstall the prior release and install VMware Workstation 5.0 as well as configure your network subnets. If you choose to reinstall the VMware software, you can SKIP the section below on Configuring a Pre-existing VMware Workstation Installation.
|
| 7. |
Specify the path and folder where you wish to install the VMware workstation software. Then click Next.
|
| 8. |
You will be prompted for an evaluation serial number for the VMware workstation software. Enter username, company and serial number details from the email you received previously. Click Next.
|
| 9. |
The Summary page appears containing a list of the products to be installed. Click Install to begin the installation.
|
| 10. |
You will see the progress window.
NOTE: It is normal for OUI to show “0% progress” during the first few minutes of the installation. Due to the file sizes involved and DVD speeds this is normal behavior.
|
| 11. |
You will be prompted to insert disk 2. Insert disk 2 and then click OK.
|
| 12. |
The End of Installation page appear. Click Exit. Then click Yes to exit.
You have now completed the installation of your Desktop Data Center.
REMEMBER TO INSERT DVD 1 INTO YOUR DVD DRIVE TO RETURN TO THE ONLINE MENU
|
Back to Topic List
Before you begin the Oracle by Example (OBE) tutorials, you should become familiar with the environment in which you will be working. The environment is built in a VMware Virtual Machine (VM). The VM contains a simulated Oracle Real Application Cluster running on Red Hat Enterprise Linux 4.0 . Database storage is managed by Oracle Automatic Storage Management (ASM). The diagram summarizes the architecture deployed in the VM. Notice that the cluster hosts 2 instances RACDB1 & RACDB2 as well as 2 listeners (not shown on the diagram).
Back to Topic List
Follow the steps below to start the Oracle Database 10g on Red Hat Linux Virtual Machine.
| 1. |
The install process has placed a VMware Workstation icon on your Windows desktop. Double click on the icon to launch the virtual machine.
|
| 2. |
Select Open Virtual Machine from the File menu.
|
| 3. |
Open Oracle10R2_RHEL4-OBE.vmx within your Oracle Home directory.
|
| 4. |
Click Start this virtual machine.
|
| 5. |
The Virtual Machine starts running. It loads Red Hat Linux and then starts Oracle Database 10g with Real Application Clusters and various applications. To login to the Linux operating system, enter oracle as the Username.
|
| 6. |
Enter oracle as the Password.
|
| 7. |
Typically after 15 minutes, all services are operational. If a pop-up warns about windows swapping, click OK to continue. Open a terminal window and execute the following command to see if all the services have started. If some of the services still say offline, wait some more time, then execute the command until all are online.
crs_stat2
|
| 7. |
Double Click on the Start Here icon.
|
| 8. |
The Oracle by Example Index appears. Click on a focus area to receive a list of lessons for that focus area.
|
Back to Topic List
The following tasks relate to configuring and using VMware Workstation:
Back to Topic List
Configuring a Pre-existing VMware Workstation Installation
The VMware network must be set correctly for the Virtual Machine (VM) on the DVD to function properly.
Note: If you install VMware Workstation using the Oracle Universal Installer, the installation will already be configured and there is no need to perform this section. In addition, you can run /install/Setup_VMNetwork.bat on DVD1 to configure your network environment automatically.
Follow these steps to manually configure a pre-existing VMware Workstation software installation:
| 1. |
Select Start > Programs > VMware > Manage Virtual Networks.
|
| 2. |
Select the  to the right of VMnet1 and select Subnet...
|
| 3. |
Enter the ipaddress 10.10.10.0 and subnet of 255.255.255.0 and click OK.
|
| 4. |
Select the to the right of VMnet8 and select Subnet...
|
| 5. |
Enter the ipaddress 192.168.203.0 and subnet of 255.255.255.0 and click OK.
|
| 6. |
Click OK to save your Virtual Network settings.
|
Back to Topic
Configuring VMware Memory
If your Host Windows PC has more than 1GB of physical memory you can allocate more memory to the Linux Virtual Machine and get better performance. The supplied VM is set to consume 720 MB of memory from Windows when it is Powered ON (That memory is returned to Windows when the VM is Powered OFF). Memory settings can only be changed when the VM is powered off. To change your memory settings
| 1. |
Click VM > Settings.
|
| 2. |
Change your memory to the desired setting and click OK.
|
| 3. |
Click Start this Virtual Machine.
|
Back to Topic
Using the VMware Toolbar
On the VMware toolbar you will find the following buttons:
| POWER OFF |
Will turn off the Virtual Machine right away. It is similar to powering off any PC, you may lose some work inside the Linux Virtual Machine.
|
| SUSPEND |
Writes all memory content of Linux VM to disk, which allows resuming from that exact point at a future time.
|
| POWER ON |
Turn Virtual Machine ON, it will then boot into Linux.
|
RESET
|
Same as pressing Power OFF and ON.
|
| SNAPSHOT |
Saves a snapshot of the Virtual Machine State. You can continue using it, including rebooting, powering ON or OFF. At any moment if you press the REVERT you will be taken back to the point in time snapshot was taken.
|
| REVERT |
Discard all changes and go back to the previously saved Snapshot.
|
| FULL SCREEN |
Use the VM in Full Screen Mode (Control + Alt + Enter). To exit out of Full Screen Mode press Control + Alt. For best results use the FULL SCREEN option from above.
|
Full documentation of the VMware Workstation product is available at: http://www.vmware.com/support/ws5/doc/releasenotes_ws5.html
Back to Topic
Enabling Port Forwarding
If you want to connect to the applications running in the Virtual Machine from a system other than the Virtual Machine or the Host Windows system you need to enable NAT Port Forwarding for the ports you will use.
Port forwarding is only needed when trying to connect to the Linux Guest OS from outside the Host Windows system. In that case, external users should use the IP address of the Host OS (ipconfig on Windows shows it), VMware Workstation will route the connection to the remote VM Image. To connect to your VM Image from the Host Windows system itself just use the IP address assigned to your Guest OS, which is 192.168.203.11 (In this case, no port forwarding is needed).
To enable port forwarding perform the following:
| 1. |
From within VMware, select Edit > Virtual Network Settings...
|
| 2. |
Click the Host Virtual Network Mapping tab.
|
| 3. |
Click > at the end of the VMnet8 line. Then select NAT....
|
| 4. |
Click Port Forwarding.
|
| 5. |
Under Incoming TCP Ports, click Add.
|
| 6. |
Host port is the incoming port on the Host OS. Enter the forwarding IP 192.168.203.11 and click OK.
Use the chart below for popular ports you can use:
Port Number |
Description |
21 |
ftp |
22 |
ssh |
| 23 |
telnet |
| 1521 |
Oracle*Net |
| 1158 |
Enterprise Manager Database Control |
| 7777 |
HTML DB/Apache |
| 5560 |
iSQL*Plus |
|
| 7. |
Click OK 3 times .
|
The VM Image supplied on the DVD is designed to be used with NAT and port forwarding.
Note: Changing to Bridged Networking will cause services inside the VM to fail to start.
Back to Topic
Reverting to the Original VM Image
As you work through the lessons, you may find the need to refresh the environment to its original state. To do so, click  on the VMware toolbar. To see the VMware toolbar, you cannot be in VM full-screen mode. Exit the VM full-screen mode by pressing Ctrl-Alt.
Back to Topic
Setting Up Shared Folders
You may need to use certain files that are outside the VM in either Windows or Linux. To access those files inside the VM, you need to setup your shared folders. Perform the following steps:
| 1. |
Select VM > Settings.
|
| 2. |
Select the Options tab.
|
| 3. |
Select the Shared Folders setting, select the vmware_shared folder and click Properties.
|
| 4. |
Set your Host folder to the directory you will store the files you want to share. In order for this functionality to work, the directory must exist. Then click OK twice.
|
| 5. |
To test the shared folder functionality, place a file in the directory that you specified in the previous step (i.e. c:\vmware_shared). Then switch to the VM and execute the following commansd from a terminal window.
cd /vmware_shared
ls
You will see the same file listed.
|
Back to Topic
Snapshots allow you to freeze your environment so that you can revert to the same exact environment after you power off. It is useful if you want to refresh your environment to its original state. The VM Image comes with one snapshot in Power Off mode. You may use this snapshot to return to the originally supplied VM. You may need to create additional snapshots. For example, you want to freeze your environment because you are in the middle of performing a particular lesson and you want to be able to come back to that point in time rather than starting at the beginning again. To create a snapshot, perform the following steps:
| 1. |
Select VM > Snapshot > Take Snapshot or click he icon in the toolbar 
|
| 2. |
Change the name or keep the name of the default and click OK.
|
| 3. |
The snapshot may take a few minutes to create. In the lower right corner, you see a bunch of disks flashing normally. When a snapshot is created, the lights will stop flashing. Once they start flashing again, wait about 5 minutes and then you can start your work.
|
| 4. |
Once you do work, if you shutdown your VMware image, your changes are saved. In order to get back to your original starting point, you can revert to a snapshot. Click the Revert button , select the snapshot you want to revert back to and click OK.
Important Note: To shutdown safely, open a terminal window and execute the following commands:
su
oracle
shutdown -h now
|
Back to Topic
The VMware Image contains an environment already configured with the necessary software to perform the OBE tutorials. The following tasks relate to using the VMware Image:
Back to Topic List
Using the Oracle By Example Tutorials
To get started with the OBE tutorials, double click on the Start Here icon on your desktop. Select the Focus Area and then the Tutorial you are interested in performing. Follow the instructions to complete the tutorial.
For best results, use the VM in full-screen mode by pressing Ctrl-Alt-Enter. To exit VM full-screen mode, press Ctrl-Alt.
Note: If you have not installed the VM, you can still view the OBEs directly from the DVD, by opening Oracle_10g_Self_Study_Guide\obe\index.htm on Disk 1.
Important Accounts and Passwords
Account Type |
User Name |
Password |
OS |
root |
oracle |
OS |
oracle |
oracle |
DB admin |
SYS |
oracle |
DB admin |
SYSTEM |
oracle |
| HR user |
HR |
hr |
| OE user |
OE |
oe |
| SH user |
SH |
sh |
| HTML DB user |
OBE |
obe |
| Oracle Secure Backup admin |
admin |
<no password> |
All account passwords are set to oracle unless otherwise specified.
Oracle recommends that you change the passwords to some non-obvious alphanumeric string if the security of the VM is of importance. In general if port forwarding is not enabled in VMware the Linux system is secure.
Connect Identifiers for the Oracle Database
Oracle Instance |
Description |
RACDB1 |
Connect to Oracle Instance 1 |
RACDB2 |
Connect to Oracle Instance 2 |
| RACDB-TAF |
Connect with Transparent Application Failover (TAF) enabled |
| RACDB-NOTAF |
Connect with TAF disabled |
| RACDB |
Another Identifier used to connect with TAF disabled |
Back to Topic
Using the VMware Image Launch Icons
The following panel of icons is displayed at the top of your window inside the VMware Image.
Back to Topic
Using your Browser Bookmarks
Within the VMware image, in your browser, click On This Machine bookmark folder to see bookmarks that you might need while performing the OBE lessons.
Back to Topic
Accessing Sample Pre-installed Applications
You can access most of the services that run inside the Linux Virtual Machine directly from the URLs in the HTML version of this README, both from Host Windows and Guest Linux. There is no need to setup port forwarding (only needed for external access). Inside Linux you can use either the hostname raclinux1 or the IP: 192.168.203.11 in URLs. On Windows use the Linux VM's IP: 192.168.203.11 or add that IP with a name to your Windows hosts file.
Back to Topic
Back to Topic List
Oracle JDeveloper 10g
Oracle JDeveloper 10g is an Integrated Development Environment (IDE) for building applications and Web services using the latest industry standards for java, XML, and SQL. More details regarding JDeveloper are available at: http://www.oracle.com/technology/products/jdev/index.html
Back to Topic
Oracle HTML DB
Oracle HTML DB is a hosted declarative development environment for developing and deploying database-centric Web applications. Oracle HTML DB turns a single Oracle database into a shared service by enabling multiple workgroups to build and access applications as if they were running in separate databases. Thanks to built-in features such as design themes, navigational controls, form handlers, and flexible reports, Oracle HTML DB accelerates the application development process.
To start using HTML DB use a web browser to access:
http://192.168.203.11:7777/pls/htmldb/htmldb
Login with:
Workspace: obe
Username: obe
Password: obe
To create or manage users of HTML DB use a web browser to access:
http://192.168.203.11:7777/pls/htmldb/htmldb_admin
Login with:
Workspace: internal
Username: admin
Password: oracle
To access HTML DB or the HTML DB manager from another system on your network, follow the steps under Enabling Port Forwarding. Then use the URL:
http://yourhost.yourdomain:7777/pls/htmldb/htmldb
Use the actual node name or ip address for the system running the Host Windows OS.
More details regarding HTML DB are available at: http://www.oracle.com/technology/products/database/htmldb/index.html
Back to Topic
Oracle Enterprise Manager
Using Oracle Enterprise Manager, from any location where you can access a Web browser, you can now manage Oracle databases, application servers, host computers, and Web applications, as well as the related hardware and software that supports your Web applications.
To start using Oracle Enterprise Manager use a web browser to access:
http://192.168.203.11:1158/em/
To access the Oracle Enterprise Manager from another system on your network, follow the steps under Enabling Port Forwarding. Then use the URL:
http://yourhost.yourdomain:1158/em/
Use the actual node name or ip address for the system running the Host Windows OS.
More details regarding Enterprise Manager are available at: http://www.oracle.com/technology/products/oem/index.html
Back to Topic
iSQL*Plus
iSQL*Plus is a Web based front end to SQL*Plus. To run this application, open a terminal window in the VM and start the necessary processes by typing "isqlplusctl start".
Open a web browser and connect using the URL:
http://192.168.203.11:5560/isqlplus/
Log into an Oracle database account. For example Username: system, Password: oracle; Specify a connect identifier. For example, RACDB; Click Login. Note: iSQLPlus does not support connecting as SYSDBA or SYSOPER.
Enter and execute SQL statements. To access iSQL*Plus from another system on your network, follow the steps under Enabling Port Forwarding. Then use the URL:
http://yourhost.yourdomain:5560/isqlplus
Use the actual node name or ip address for the system running the Host Windows OS.
Back to Topic
Oracle Instant Client
Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.
ISVs and Partners benefit greatly from packaging Instant Client along with their applications, saving customers the extra step of installing and configuring an Oracle client. Free.
For installation and usage directions see: Oracle_10g_Instant_Client\Readme_Oracle_10g_Instant_Client.txt on the DVD labeled: Your Desktop Data Center Disk 1.
More details regarding Instant Client are available at: http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
Back to Topic
Oracle Migration Workbench
Oracle Migration Workbench Release 10.1.0.4 enables you to migrate the following databases to Oracle Database 10g, Oracle9i, or Oracle8i:
|
Informix Dynamic Server 7.3, 9.x Beta |
|
Microsoft Access 2.0, 95, 97, 2000 This release of Migration Workbench also allows you to migrate a Microsoft Access 2.0, 95, 97, and 2000 database to an Oracle9i Lite database. |
|
Microsoft SQL Server 6.5, 7.0, 2000 |
|
MySQL 3.22, 3.23, 4.x |
|
Sybase Adaptive Server 11, 12 |
|
IBM DB2/AS400 V4R5 and V4R3 |
|
IBM DB2 UDB 6 Beta, 7 Beta |
For release notes and usage directions click on: Oracle_Migration_Workbench\relnotes.htm on the DVD labeled Your Desktop Data Center Disk 1.
To install, follow the instructions in the OBE tutorial titled Migrating from Microsoft SQL Server to Oracle Database 10g Using Oracle Migration Worksbench or simply unzip (Omwb.zip) to Windows and execute:
Omwb\bin\omwb.bat, Connect as:
Username: repuser
Password: oracle
Host: 192.168.203.11 (or if name exists: raclinux1)
Port: 1521
SID: RACDB1
ALL the needed plugins are provided.
More details regarding Oracle Migration Workbench are available at: http://www.oracle.com/technology/tech/migration/workbench/index.html
Back to Topic
Follow the steps below to deinstall your Desktop Data Center
| 1. |
Launch the Oracle Universal Installer by running Setup.exe from the install directory on Your Desktop Data Center DVD 1.
|
| 2. |
The Oracle Universal Installer Welcome window appears. Select Deinstall Products to begin the deinstall of the software.
|
| 3. |
The Inventory screen appears which shows you Oracle products you have installed. Select OraLnxEval1and click Remove.
|
| 4. |
You will be prompted to confirm that you want to deinstall the products listed. Click Next.
|
| 5. |
A screen appears informing you directory and inventory deinstall progress. When done, the inventory screen is display and OraLnxEval1 should no longer be displayed in the list of Oracle Homes. Click Close.
|
| 6. |
Click Exit to exit the Oracle Universal Installer. Then click Yes to confirm.
|
| 7. |
To remove the VMware Workstation software from your system launch the Control Panel from your Start menu.
|
| 8. |
Double click on the Add/Remove Programs icon in your Control Panel.
|
| 9. |
Scroll down until you find the VMware Workstation entry. Click Remove.
|
| 10. |
Click Yes to remove the software from your system.
You have now completed the deinstall of your Desktop Data Center.
Note: Only the Virtual Machine files (not including undo files) in the Oracle Home will be removed. The VMware Workstation software will not be removed. Use the Windows Add/Remove Software entry on the control panel to remove it.
|
Back to Topic List
The following tips have been put together to help you troubleshoot issues before they arise.
|
The performance of the VM may be improved by shutting down services that you do not need. In particular the following command will shut down the RAC instance RACDB2.
srvctl stop instance -d RACDB -i RACDB2
|
|
To disable an instance from starting upon the next reboot you can execute the following command:
srvctl disable instance -d RACDB -i RACDB2
|
|
More startup and shutdown commands are in ~oracle/bin & /etc/rc.local
|
|
Two-button mouse emulation is does not work inside the VM. This makes it harder to copy and paste for laptop users or PCs with only a two-button mouse. To paste, use a three-button mouse. Click the middle button to paste.
|
|
Make sure your TEMP environment variable on Windows points to a location with at least 100MB of free space before installing VMware Workstation.
|
|
Autorun is disabled when installing VMware Workstation. As a result, you can enable it again by following the steps in this Microsoft document.
|
Back to Topic List
Visit our online forum on OTN for questions relating to the installation, start up or use of the Oracle Database 10g on Red Hat Linux Virtual Machine.
If you would like to access the entire DVD online, click here.
Back to Topic List
** ORACLE Corporation Copyright (c) 2005 Oracle. All rights reserved. **
| 
