Oracle-L: RE: dbca question

From: Darrell Landrum <DLANDRUM_at_zalecorp.com>
Date: Wed, 21 May 2003 10:56:42 -0800
Message-ID: <F001.0059F0BD.20030521105642@fatcity.com>

//From the OCP Oracle 9i Database: New Features for Administrators Exam Guide by Danaiel Benjamin:

"When the Oracle DBCA installs or creates a new database, it locks and expires most default user accounts. Some accounts that are exceptions to this lock and expire rule are SYS, SYSTEM, and SCOTT. Before you can user these locked and expired accounts, you must first unlock the account manually and generate a new password."

//From the Oracle 9i Sample Schemas documentation on OTN: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96539/installa.htm#4365

Using the Database Configuration Assistant Using DBCA is by far the most intuitive and simple way to install the Sample Schemas. Step 4 of the database creation process lets you configure the Sample Schemas you wish to use in your database. The following dependencies are enforced by the Database Configuration Assistant:

The checkbox "Example Schemas" needs to be checked for any Sample Schema to be created.
"Oracle Spatial" needs to be selected to allow the Order Entry schema to be created.
"Oracle Intermedia" needs to be selected to allow for the creation of the Product Media schema. You can select this option by clicking on the "Additional database configurations ..." button. "Oracle JVM" needs to be selected for the evaluation of materialized views and dimensions. If you intend to use these features, select this option by clicking on the "Additional database configurations ..." button.
The Order Entry schema option requires the Human Resources option to be selected.
The Product Media schema option requires the Order Entry option to be selected.
The Shipping schema option requires the Order Entry option to be selected.
Selecting "Oracle OLAP Services" with the Sales History option selected will add OLAP server metadata to the Sales History schema.

Two of the three predefined database templates shipped with the Database Configuration Assistant contain the Sample Schemas:

OLTP database
DSS database

>>> kirti.deshpande_at_verizon.com 05/21/03 11:46AM >>> C.
But, I would like to say:
It depends, or None of the Above.
Does this assistant install sample schemas without giving you a choice to do so? ;)

Kirti

-----Original Message-----
Sent: Wednesday, May 21, 2003 10:02 AM
To: Multiple recipients of list ORACLE-L

Hi list , I came across a question while preparing for my exam

QUESTION : You created a database by using the Database Configuration Assistant. What
must you do to access a user account in the sample schemas?

Create the user account and unlock the account.
Create the user account and define a password.
Unlock the user account and define a password.
Set the 07_DICTIONARY_ACCESSIBILITY parameter to TRUE.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <bulbultyagi_at_now-india.net.in
INET: bulbultyagi_at_now-india.net.in

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Darrell Landrum
INET: DLANDRUM_at_zalecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------