| Create more Oracle Instances in the same server environment [message #51264] |
Fri, 10 May 2002 07:41  |
Jason
Messages: 32
Registered: February 1999
|
Member |
|
|
We are currently using Clintrial 4.3 (databaseprogram for clinical trial studies) which is an Oracle based interface program.
However, the instance that we have so far is for production purpose. We would like to create another Oracle instance for testing purpose. Can you make any suggestion what we need to be aware or any reference that we are able to follow the procedures step by step?
In the nearest future, we will create more instances for our safety, project management, and scanning documentation databases.
Thank you for your help.
Best Regards,
Jason
|
|
|
|
| Re: Create more Oracle Instances in the same server environment [message #51272 is a reply to message #51264] |
Sat, 11 May 2002 04:25  |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
sir,
creating multiple database in the same system is very easy.using the datbase assistant wizard you can create databases(please refer oracle doc).during creating the database,the sid,global_name,oracle database name should be unique.
now i am giving some points.
1,first register your oracle services
2,create the parameter file
3,then start the database in nomount stage
4.create the database
5.then execute the catlog,catproc scripts
6.create necessary rollback segments,tablespaces
7.configure the listener.ora file
that's all
bye and take care
k.sreenivasan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
