Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Nirmalkumar
Frequent Advisor

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

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.
9 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Patrick Wallek
Honored Contributor

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

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
Honored Contributor

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

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

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

Sigh.....

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

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

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
Honored Contributor

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Nirmalkumar
Frequent Advisor

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

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
Honored Contributor

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)