Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbca question

RE: dbca question

From: Mark Work <mark_at_cool-tools.co.uk>
Date: Wed, 21 May 2003 12:16:39 -0800
Message-ID: <F001.0059F168.20030521121639@fatcity.com>


RE: dbca questionAre there any guides as to what they actually assume?

A "partly" interested party.. ;)

Do I want to, do I *really*?

Mark
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of April Wells   Sent: 21 May 2003 20:57
  To: Multiple recipients of list ORACLE-L   Subject: 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-----
  From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com]   Sent: Wednesday, May 21, 2003 2:32 PM
  To: Multiple recipients of list ORACLE-L   Subject: RE: dbca question

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

  -----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? ;)

  -----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: Mark Work
  INET: mark_at_cool-tools.co.uk

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).
Received on Wed May 21 2003 - 15:16:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US