RE: dbca question

Kirti

The OCP questions assume a lot, frequently.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
Well-behaved women rarely make history

-----Original Message-----
Sent: Wednesday, May 21, 2003 2:32 PM
To: Multiple recipients of list ORACLE-L

Thanks, Darrell.
So, that OCP question *assumed* that one installed these sample schemas ;)

• Kirti

-----Original Message-----
Sent: Wednesday, May 21, 2003 1:57 PM
To: Multiple recipients of list ORACLE-L

//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?

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

-

-- 
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).

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: April Wells
  INET: awells_at_csedge.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).