Splitting Oracle Server

July 5th, 2007 by it gossips | Filed under Uncategorized.

There are three four days to deadline for final project of database labwork. But, there’re some problems here. One of critical problem is my Oracle Server down for a night. All of user complain to me and I don’t know what should I do. I just restart the database service but it doesn’t work. I don’t sleep for a night again. I try to do another way but it’s still failed. Asking some friends doesn’t help too. What should I do?In the next night, I decide to split my Oracle server in laboratory. I find the other Oracle server in other laboratory but I can’t import user from my original database. Perhaps it uses Oracle 9g and my lab with 10g. I can’t debug for a long time anymore. It’s the three days counter down to deadline.I choose on of the computer in lab although it’s very hard to be a server because its RAM only 512MB. But, if I don’t split my server, it will be going down with crazy traffic like this. First, I export user in the database. And then install Oracle and create database in new server. Second, create user and importing user from original database. There are 74 groups and I split it become two parts. In original server, there are 50 groups and 24 groups in the new server.Oho, it’s work for two days! Although there is a chaos an hour before deadline. I’m still finding out how to optimize Oracle server and Windows Server 2003 as its operating system. Can somebody help?Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/07/splitting-oracle-server.html)