Is any options are there to compare databases of two different environments

[Nirmalkumar]

Hi all,

Is there any options or oracle utilities in oracle9i to compare and generate report for the configurations and parameters files of database in two different environments.

Help appreciated...

Thanks,
Nirmal.

[Steven E. Protter]

Shalom,

binary diff utility on the files themselves, probably not because of different fragmentation patterns.

Sounds to me like you have to write some sql code.

If you are lucky, maybe you could compare exports if the data structure is identical.

SEP

[Patrick Wallek]

If you are just talking about parameters and information that is stored in the SPFILE, then you could create a copy of the SPFILE to PFILE, the PFILE is a text file, and then compare the PFILEs.

[Patrick Wallek]

Here's a good document that talks about the spfile and tells how to create a pfile from the spfile.

[Patrick Wallek]

Sigh.....

Here is the link to the article I mention above:
http://www.dbasupport.com/oracle/ora9i/spfile.shtml

[Nirmalkumar]

Hi patrick,

Thank u for your suggestions..

Acutally we are having 10 databases in production environment and another 10 databases in staging environment.The configurations and parameters for both environment is more or less same only.

i want to know any automated tool or any oracle utility is there in oracle 9i to find the differenece(configurations and parameters ) between two environments.

Note:we are using pfile only in all databases.


Help appreciated...

Thanks,
Nirmal.

[Yogeeraj_1]

hi Nirmal,

RDA is one free tool provided by oracle and that collect all information about your database on a particular server. if you run them on all of the 10 database server and compare them together, it will be feasible.

if you need any further information, do let us know.

kind regards
yogeeraj

[Yogeeraj_1]

hi again,

RDA can download from Metalink Note 314422.1. You should select the RDA packaging format you wish to download and click on the related link. Each package contains all the files you need, so only choose one package to download.

If you want to compare only at the database level, you may use "TOAD -> Compare Database" feature.


hope this helps too!
kind regards
yogeeraj

[Nirmalkumar]

Hi yogeeraj,

Thank u for ur sugestions

TOAD is a oracle utility or any third party tool.if it is oracle utility means whether it is a freeware or lincensed utility..


Thanks,
Nirmal

[Yogeeraj_1]

hi Nirmal,

Toad is not free. You will have to purchase. However, you may still download the evaluation version and perform this operation.

http://www.quest.com

Otherwise, you may also look into Oracle SQL Developer -- which is free.

hope this helps too!

kind regards
yogeeraj