Re: How to create the seed database?

Peter wrote:

>On Tue, 07 Oct 2003 17:37:14 -0700, Daniel Morgan
><damorgan_at_x.washington.edu> wrote:
>
>
>
>>Peter wrote:
>>
>>
>>
>>>On Mon, 06 Oct 2003 20:49:57 +1000, "Howard J. Rogers"
>>><hjr_at_dizwell.com> wrote:
>>>
>>>I could not find a windows service named "OracleServiceHR" so I don't
>>>think I have the seed database HR installed.
>>>Even if I use DBCA to create a new database named HR, it is not the
>>>same as the seed database HR that Oracle would have created during
>>>installation.
>>>But, is there a way to install the seed database using the Oracle
>>>Installer or whatever without reinstalling Oracle?
>>>
>>>Thanks.
>>>
>>>
>>>
>>>
>>>
>>>>Peter wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>On Mon, 06 Oct 2003 10:00:23 GMT, Peter <peter_at_nomorenewspamin.ca>
>>>>>wrote:
>>>>>
>>>>>I couldn't find my starter database.
>>>>>
>>>>>
>>>>>From within Oracle Universal Installer, the Oracle starter database is
>>>>
>>>>
>>>>>listed as an "installed product" which is supposed to be in the folder
>>>>>oracle_home\ora92_rdbms_seeddb
>>>>>But I cannot find the folder. Can I reinstall only the oracle starter
>>>>>database with reinstalling the whole Oracle?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>How do you create the seed HR database after the installation of
>>>>>>Oracle9i on Windows platform?
>>>>>>Is there a way of using DBCA to create the HR seed database?
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>OK, backup a bit. You're on Windows, you've just installed Oracle, and
>>>>you're wondering where your 'seed database' is.
>>>>
>>>>First, check you've got one (because you might conceivably have taken the
>>>>'software only' installation option, in which case you won't have one).
>>>>Open the Control Panel, find the Services applet, and check what services
>>>>you've got listed starting with the word 'Oracle'. You should have ones
>>>>such as OracleTNSListener, OracleIntelligentAgent and so on... none of
>>>>which mean anything in this context. But hopefully, and more to the point,
>>>>you should have one called OracleServiceXXXX. If you've got one of those,
>>>>you've got yourself a seed database.
>>>>
>>>>The 'XXXX' there will be the name of your database. Depends what you
>>>>specified, if you did. But make a note of it, because you'll need to know
>>>>it. Assume for the rest of this post that it's 'ORCL'. Oh, and make sure
>>>>that service is running ("Started").
>>>>
>>>>Open up a DOS window, and type:
>>>>
>>>>sqlplus "/ as sysdba"
>>>>
>>>>You should get a message saying simply 'Connected'. So now type:
>>>>
>>>>select * from v$database;
>>>>
>>>>...and in the middle of all the junk that you then see, you should see a
>>>>column called DBNAME (from memory)... and that should be displaying 'ORCL'
>>>>(or whatever you got for your earlier XXXX. And that's how you connect (and
>>>>find) your seed database.
>>>>
>>>>So then you can see whether you have the HR sample data or not (if you
>>>>created a database from one of Oracle's own templates, then you should do).
>>>>
>>>>First thing: still in SQL*Plus, type:
>>>>
>>>>select username from dba_users;
>>>>
>>>>Hopefully, you'll see one listed there, called 'HR'.
>>>>
>>>>Now try:
>>>>
>>>>select * from dba_tables where owner='HR';
>>>>
>>>>That should list you things like 'EMPLOYEES': what you're seeing is a
>>>>complete list of HR's schema, and EMPLOYEES is one table within that
>>>>schema.
>>>>
>>>>Next, you might try:
>>>>
>>>>select * from hr.employees;
>>>>
>>>>And that should prove the table is full of data.
>>>>
>>>>When Oracle creates databases for you these days, ssample accounts like HR
>>>>are locked and have no password. So if you want to log on as HR, you'll
>>>>have to sort that out:
>>>>
>>>>alter user HR identified by <new_password> account unlock;
>>>>
>>>>All of which assumes you have a database of course. If you don't then yes,
>>>>you use DBCA to create one (and no, that doesn't mean re-installing
>>>>Oracle). Just open a DOS window and type 'dbca' (without the quotes) and
>>>>follow the wizard through. When you get to the bit about naming a database,
>>>>remember to specify a fully-qualified name. Instead of just typing 'ORCL'
>>>>as the database name, supply 'ORCL.domain.local' (or supply a proper domain
>>>>if you have one; or make one up if you don't). The SID on the same screen
>>>>is just the domain-less part of that full name, so that really would be
>>>>just ORCL (or whatever other name you fancy, up to 8 characters long).
>>>>
>>>>Hope that's enough to get you started, anyway.
>>>>
>>>>Regards
>>>>HJ
>>>>
>>>>
>>>>
>>Repeat after me:
>>
>>SQL Server database = Oracle user and schema
>>SQL Server instance = Oracle database and instance
>>
>>
>
>That's not exactly true
>SQL Server instance = SGA and the Oracle background processes
>
>
>
>
>>To use Oracle you must read the manuals. http://tahiti.oracle.com.
>>
>>
>
>I have read the manual several times.
>
>

The manual? Singular? Surely you jest. ;-)

Instance in SQL Server as I understand it also includes the physical files on the disk. If I am
incorrect please provide the correct verbiage. Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)