Re: multiple oracle dbs

After the Create database statement, is issued, the scripts that you need to run for the setup of the rest of the data dictionary are;

1. ?/rdbms/admin/catalog
2. ?/rdbms/admin/catproc
3. ?/rdbms/admin/catparr -> If you have Parallel Server Option
4. ?/rdbms/admin/catrep -> If you have Replication Server Option the above scripts run against a CONNECT INTERNAL

Also, run Product User Profile against the SYSTEM account. The script pupbld.sql is generally in ?/dbs or ?/sqlplus/admin

Rgds
Andrew

Thomas Lohman wrote:

> Hi, I've got Oracle 8.0.5 running on a Solaris 2.6 box and I set up a database
> and instance during the install. I'd now like to set up an additional
> database and instance for another (unrelated to the first) application. I've
> had trouble determining from the Oracle manuals what the exact steps to doing
> this are. Can anyone point me to a HOWTO or something about what steps are
> entailed in creating a second database. The main area where I've run into
> problems is not with the create database statement but rather the other steps
> to make sure the database is populated with all the correct packages, etc.
>
> thanks much for your help,
>
> --tom
>
>
> Thomas Lohman - Software Developer
> MIT Building 36 - Room 297; Cambridge, MA. 02139
> e-mail: thomasl_at_mtl.mit.edu
> World Wide Web: http://www-mtl.mit.edu/~thomasl/
Received on Fri Apr 16 1999 - 20:12:20 CDT