Re: NT Oracle8 DB Instance duplication

The database files and SQL*Net files needed to create a 2nd instance are located in the following directories as you have noted: \orant\net80\admin and \orant\database

As you seem to be aware of, you will need to create services for the new instance. You can use the instance manager which can be invoked from the DOS command line executing the following: oradim80 or oradim73... depending on the version.

Actually, I prefer to use the oradim command to create the instance at the DOS command line. There should be an example in the Getting Started manual that comes w/the software. To create a new instance the syntax is more or less: oradim80 -new -sid <sid_name> -intpwd <password> -pfile <path_&_pfile_name>

In article <6t4vp7$ji4$1_at_news.tokyo.att.ne.jp>,   "Dick Weisinger" <dickw_at_tkb.att.ne.jp> wrote:
> I would like to be able to duplicate a DB instance in Oracle8 on one NT
> portable PC to another machine (by just copying dbf files, if possible).
>
> I've copied DBs successfully under UNIX before, but I'm having some problem
> with NT.
> On Unix, most of the Oracle files are in the following directories:
> oracle\oradata\{SID} and
> oracle\admin\{SID}
> oracle\dbs (for the init${SID}.ora file)
>
> On NT, things seem to be different. It looks like the files I'm interested
> are in the following directories:
> \orant\net80\admin and
> \orant\database
>
> There are also Oracle Instance-specific Services which will start the Oracle
> DB on NT startup. I'm not exactly sure how to add/define the new Oracle
> Instance services.
> Thanks for any help you can provide.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 11 1998 - 21:30:22 CDT