Re: Need help adding another instance

From: Thomas Pall <tpall_at_bga.com>
Date: 3 Nov 98 23:45:31 GMT
Message-ID: <363f959b.0@feed1.realtime.net>

I just took a look at the Getting Started documentation for Oracle 8 on NT and I can understand your confusion. There is a much better description of the steps involved in adding a second database in the Oracle 7.3 Getting Started documentation. However the Oracle 8 documentation is useable.

Basically you will need new services, a new database, registry settings.

The steps are:

Create a directory to contain your init<SID>.ora. This is where your strt<SID>.cmd and pwd<SID>.ora will go. Place your init<SID>.ora in the directory.

Run Oradim:

oradim80 -new -sid mine -intpwd pw -startmode auto

-pfile c:\orant\mine\initmine.ora

I have used mine as the <SID> name in the above. pw is your internal password.

Oradim will create new services, put them in the control panel, create registry settings for the new instance. You must go to the control panel and check to see if the new service is running.

If not running, start it.

Now back to the DOS prompt.

Point to your new instance

set Oracle_Sid = mine

Remember I am using mine as the name of the new instance.

Now go into svrmgr:

svrmgr80
svrmgr> connect internal/pw (pw is the password you gave oradim80)

connected

svrmgr> startup nomount pfile=c:\orant\mine\initmine.ora

now run your database build script:

svrmgr> spool build_mine.log
svrmgr> @build_mine.sql

Now that your database has been built, you need to run the data dictionary creation scripts:

svrmgr> @%rdbms80%\admin\catalog.sql
svrmgr> @%rdbms80%\admin\catproc.sql
svrmgr> @%rdbms80%\admin\catrep8m.sql (run only if you want advanced
                                      (replication)

svrmgr> spool off

Now you have your new database.

Now shutdown the database and do a cold backup.

The next steps are modifying your registry if you want this to be your default database, adding this database to your listener.ora file, setting up your sysdbas and sysopers, setting up your backup procedures.

Greg Burns (h4imigmb_at_nospam.orp41.orp.usace.army.mil) wrote:
: Server guru's:

: I already have Oracle 8 Enterprise set up with a production database on the
: NT platform. I need to add another (unrelated) database to this NT server.

: I've RTFM'd, used the web to find out specifically how this should be done,
: but I've read conflicting information on how to successfully add a second
: instance, ie: one source indicated that a new service will need to be
: created, others don't.

: Does anyone know of any resources (www, manuals, etc) or can anyone give me
: a general outline on how to do this?

: TIA
: --
: Greg Burns, Computer Specialist
: U.S. Army Corps of Engineers, Pittsburgh District
: Remove nospam to reply

-- Received on Tue Nov 03 1998 - 17:45:31 CST