Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 6: Oracle 9i Database Design using DBCA
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Step 19:
Once you see the message, database has been created successfully. Open
up OEM (Oracle Enterprise Manager) as shown in the figure below.
Figure 41: Use Oracle Enterprise Manager (OEM) to test
connection to your recently developed database. OEM is located under
<Start>, <All Programs>, <Oracle> folder.
________________________________________
Figure 42: A close-up of the figure 41.
________________________________________
Once you click ‘Enterprise Manager Console’, following window will popup asking you whether you want to run OEM standalone or you want to login to the Oracle Management Server. Oracle Management Server is an add-on product and we haven’t installed it so we will be running OEM as ‘standalone’. Click Ok.
Figure 43: Select the ‘Launch standalone’ option.
________________________________________
The next popped up window will be the main control panel of OEM. From here you can control all the databases you are running all over the world. Right now it’s showing you only one database i.e. TEST.
Figure 44: The ‘TEST’ database will be visible in the
tree hierarchy of OEM (Oracle Enterprise Manager).
________________________________________
TEST is the database that we have developed using DBCA. If you click on TEST item in the tree, the following window will appear asking you for credentials i.e. login and password. There is no need to specify the login and password just select SYSDBA from ‘Connect as’ drop down option box and click OK button.
Figure 45: Connecting as SYSDBA to TEST database
________________________________________
Now you would be able to expand the tree under TEST database. If you click ‘Tablespaces’ under ‘Storage’ item, you would be able to see the list of all the tablespaces and corresponding data files that DBCA has developed for you. Let me give you a closer look to this window in the following picture. We will learn in depth about OEM and other good stuff later in this book.
Figure 46: Expand the “Tablespaces” item in the tree
to see the list of tablespaces within TEST database.
________________________________________
Chapter 6: Oracle 9i Database Design using DBCA
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: