Home » RDBMS Server » Server Administration » Create another new instance on Win 2K server
Create another new instance on Win 2K server [message #57826] Wed, 09 July 2003 11:30 Go to next message
Maggie
Messages: 9
Registered: January 2003
Junior Member
OS: Win 2K server
DB: Oracle 8.1.7

We would like to create another new intance on the Win 2K server. There are already an existing instance on the server. How do we create another instance on the server has existing instance ? Thanks!

Report message to a moderator

Re: Create another new instance on Win 2K server [message #57829 is a reply to message #57826] Wed, 09 July 2003 16:29 Go to previous messageGo to next message
Michel Bartov
Messages: 35
Registered: February 2003
Member
I posted an integrated set of GUI tools to manage, monitor and tune the Oracle database. One of the many functions is to generate a shell script in Unix or as a .bat file for Windows to clone or create a database. The link is http://www.barsoft.net

Not taht the name of the instance(database) has to be different from the current one.

Report message to a moderator

Re: Create another new instance on Win 2K server [message #57855 is a reply to message #57826] Fri, 11 July 2003 05:11 Go to previous message
Shesh
Messages: 16
Registered: July 2003
Junior Member
Use Oradim utility to create a new instance.

C:Oradim -new -sid NEW -startmode auto -intpwd <Pwd>

and set the oracle SID as
c:Set ORACLE_SID=NEW
now connect as dba in sqlprompt
and create the database.

After starting up the database in nomount stage
you can query v$instance to check whether you are working on new instance or not.

bye
shesha

Report message to a moderator

Previous Topic: Diff. between undo & rollback segments??
Next Topic: oracle seminar for oracle/ocp proffesionals
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:33:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.