RUN SQL SCRIPTS TO GENERATE THE OBJECTS USED BY ENTERPRISE MANAGER...

5. Run SQL scripts to generate the objects used by Enterprise Manager Database Control, and any other database options chosen to be enabled.On Windows systems, there is an additional step because Oracle runs as a Windows service. Oracle provides a utility, oradim.exe, to assist you in creating this service.These steps can be executed interactively from the SQL*Plus prompt or through a GUI tool, the Database Configuration Assistant (DBCA). Alternatively, you can automate the process by using scripts or start the DBCA with a response file.Whatever platform you are running on, the easiest way to create a database is through the DBCA. You may well have run this as part of the installation: OUI can launch the DBCA, which prompts you and walks you through the whole process. It creates a parameter file and a password file and then generates scripts that will start the instance; create the database; and generate the data dictionary, the data dictionary views, and Enterprise Manager Database Control. Alternatively, you can create the parameter file and password file by hand, and then do the rest from a SQL*Plus session. Many DBAs combine the two techniques: use the DBCA to generate the files and scripts, and then look at them and perhaps edit them before running them from SQL*Plus.The DBCA is written in Java—it is therefore the same on all platforms. On Unix, you run the DBCA on the machine where you wish to create the database, but you can launch and control it from any machine that has an X server to display the DBCA windows. This is standard X Window System—you set an environment variable DISPLAY to tell the program where to send the windows it opens. For example,

export DISPLAY=10.10.10.65:0.0

will redirect all X windows to the machine identified by IP address 10.10.10.65, no matter which machine you are actually running the DBCA on.To launch the DBCA on Windows, take the shortcut on the Start menu. The navigation path will be