Home » RDBMS Server » Server Administration » Creating new instance
Creating new instance [message #158679] Mon, 13 February 2006 20:37 Go to next message
rohikesh
Messages: 7
Registered: October 2005
Location: 1
Junior Member
Hi Everybody,
Iam a oracle developer and new to DBA. I have very recently installed a Oracle-9i database on my m/c on Windows XP. During the installation itself I created a instance ORAONE. Hence Iam able logon to this instance correctly as uid/pwd@ORAONE. Now, on the same ORACLE server can I create another instance like ORATWO ??
Please let me know of what do I need to do to make that happen and where do I find this information.

summary:
Iam trying to create two instances on a single ORACLE Service.

Thanks You All In Advance!!

Report message to a moderator

Re: Creating new instance [message #158688 is a reply to message #158679] Mon, 13 February 2006 22:09 Go to previous messageGo to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member
hi..

Logon as sysdba and create new instance
either by 1) DBCA or manually

just remeber that before logging on set new oracle SID in case you are going for manually

Report message to a moderator

Re: Creating new instance [message #158689 is a reply to message #158679] Mon, 13 February 2006 22:09 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

You can use "dbca" for creating a new instance and if you wish to do it manually then look into the following link.

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/create.htm#1000691

Report message to a moderator

Previous Topic: Organizing tablespaces
Next Topic: error while creating materialized view...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 16:32:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.