Re: How to create the seed database?

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. Received on Tue Oct 07 2003 - 20:06:16 CDT