| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbca question
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?
-
--
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
 |
 |