Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trouble after moving database to new server

Status
Not open for further replies.

tt523600

Technical User
Jul 16, 2002
12
NO
hi guys!

This is what I've done:
I copied an existing oracle 7.3.4, 2 instances, to a new server that replaced the old server. The OS is NT4 SP6 and both machines run 7.3.4.0.

For each instance i did the following

• Stop the instances
• copy all the datafiles over to the new server
o sys1xxx.ora (SYSTEM)
o usr1xxx.ora (USER_DATA)
o rbs1xxx.ora (ROLLBACK_DATA)
o tmp1xxx.ora (TEMPORARY_DATA)
o dat1xxx.ora (DB_DATA)
• copy the controlfiles
o ctl1xxx.ora
o ctl2xxx.ora
• copy the redo-log files, 2 sets
• copy the archive-logs
• copy the initxxx.ora file
• make the new instance with oradim73

All the files were copied with scopy and placed in the same filestructur, located exactly the same as on the original server .
The old server was then deleted from the domain and the new server was renamed to the name the old server had. Then I mounted both instances and everything seemed ok.

Now, nearly a month after the installation I'm getting reports that strange things is happening in one of the instances, the other one seems fine. There seems to be something wrong with the pointers to this instance. The client-programs seems to have trouble to register data in some fields and fields get crossed causing a mess of reports
from this database.

Also, there are some economy-systems(i.e winsak) installed on top of these instances that are very special. only the programmers can explain how these programs work, but they include a lot a batch-jobs and mappings to the database-server..

Is there anybody that can tell me if i did something wrong under the moving job of the database? I'm kinda suspecting these special-systems on top of oracle that is causing troubles, but I cannot be sure.. appreciate any suggestions!
 
Copy looks fine to me. Although I'm familiar with Unix and not Oracle on NT. So maybe NT does some Windows-registry stuff that doesn't happen on Unix.

You'd have to look at the log files (database, & listener) and also look at the application log files. If the applications are getting Oracle errors they should be reporting it. You are going to have to work with the programmers to see if the problem is with the application or the database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top