Re: How to create the seed database?

On Tue, 07 Oct 2003 19:55:02 -0700, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

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

I have no authority to correct you at all.

According to what I read from the manual, instance = SGA and the Oracle background processes

Thanks for your help. Received on Wed Oct 08 2003 - 14:04:22 CDT