ora init parameter comparison

[cxpatt4]

I am trying to compare init parameters between two instances.While I
can do this with database compare and it gives me scripts to sync
one to be like the other- I don't really want to do this. (going
from 8i to 9i with new 9i db creation and import) I don't want to
add obselete parameters to 9i. Is there a way to create a side by
side comparison for the output? it would be much easier to read) ie-

parameter inst1 inst2

parm1 value value
parm2 value
parm3 value value
parm4

Thanks




Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Jeff Smith]

You are almost there!

On the Compare Databases Output screen, where you see
'Objects Which Differ'
'INIT.ORA'

R-Click on INIT.ORA and choose 'Show Difference Details'

This will popup both INIT.ORAs in the Toad File DIFF gui. Very handy,
and hopefully just what you are looking for.

-jeff

-----Original Message-----
From: cxpatt4 [mailto:***@qwest.com]
Sent: Thursday, August 12, 2004 6:41 PM
To: ***@yahoogroups.com
Subject: [toad] ora init parameter comparison

I am trying to compare init parameters between two instances.While I can
do this with database compare and it gives me scripts to sync one to be
like the other- I don't really want to do this. (going from 8i to 9i
with new 9i db creation and import) I don't want to add obselete
parameters to 9i. Is there a way to create a side by side comparison
for the output? it would be much easier to read) ie-

parameter inst1 inst2

parm1 value value
parm2 value
parm3 value value
parm4

Thanks




Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip Yahoo! Groups
Links









Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Patterson, Cindy]

Great!
Thanks so much. Exactly what I was looking for!

Cindy Patterson
Qwest
DBA Design Engineer II
Shared Data/Database Services- LOSDB
303-624-2328


-----Original Message-----
From: Jeff Smith [mailto:***@quest.com]
Sent: Friday, August 13, 2004 6:19 AM
To: ***@yahoogroups.com
Subject: RE: [toad] ora init parameter comparison


You are almost there!

On the Compare Databases Output screen, where you see
'Objects Which Differ'
'INIT.ORA'

R-Click on INIT.ORA and choose 'Show Difference Details'

This will popup both INIT.ORAs in the Toad File DIFF gui. Very handy,
and hopefully just what you are looking for.

-jeff

-----Original Message-----
From: cxpatt4 [mailto:***@qwest.com]
Sent: Thursday, August 12, 2004 6:41 PM
To: ***@yahoogroups.com
Subject: [toad] ora init parameter comparison

I am trying to compare init parameters between two instances.While I can
do this with database compare and it gives me scripts to sync one to be
like the other- I don't really want to do this. (going from 8i to 9i
with new 9i db creation and import) I don't want to add obselete
parameters to 9i. Is there a way to create a side by side comparison
for the output? it would be much easier to read) ie-

parameter inst1 inst2

parm1 value value
parm2 value
parm3 value value
parm4

Thanks




Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip Yahoo! Groups
Links









Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links







Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Jeff Smith]

We please to aim! Or something like that...

-----Original Message-----
From: Patterson, Cindy [mailto:***@qwest.com]
Sent: Friday, August 13, 2004 11:36 AM
To: ***@yahoogroups.com
Subject: RE: [toad] ora init parameter comparison

Great!
Thanks so much. Exactly what I was looking for!

Cindy Patterson
Qwest
DBA Design Engineer II
Shared Data/Database Services- LOSDB
303-624-2328


-----Original Message-----
From: Jeff Smith [mailto:***@quest.com]
Sent: Friday, August 13, 2004 6:19 AM
To: ***@yahoogroups.com
Subject: RE: [toad] ora init parameter comparison


You are almost there!

On the Compare Databases Output screen, where you see
'Objects Which Differ'
'INIT.ORA'

R-Click on INIT.ORA and choose 'Show Difference Details'

This will popup both INIT.ORAs in the Toad File DIFF gui. Very handy,
and hopefully just what you are looking for.

-jeff

-----Original Message-----
From: cxpatt4 [mailto:***@qwest.com]
Sent: Thursday, August 12, 2004 6:41 PM
To: ***@yahoogroups.com
Subject: [toad] ora init parameter comparison

I am trying to compare init parameters between two instances.While I can
do this with database compare and it gives me scripts to sync one to be
like the other- I don't really want to do this. (going from 8i to 9i
with new 9i db creation and import) I don't want to add obselete
parameters to 9i. Is there a way to create a side by side comparison
for the output? it would be much easier to read) ie-

parameter inst1 inst2

parm1 value value
parm2 value
parm3 value value
parm4

Thanks




Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip Yahoo! Groups
Links









Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links







Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links









Questions? Try the on-line FAQ: http://www.toadsoft.com/faq2.html

To download the beta: http://www.toadsoft.com/beta.zip
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/