Michael McMullen
2021-03-19 15:50:41 UTC
I"ve worked on six different ODA systems/versions and 6 exadatas. I'll take an exadata for patching/maintenance over an ODA any day of the week.
Performance is great, administration is tedious. Everything needs to be done via the api. You don't use things such as dbca. There is a derby database that keeps track of all the oda metadata. If you get one, lock it down to the cowboys in the organization. You need to rule it with an iron fist because if the metadata doesn't match what's been done on the system it is tough.
If your org requires you to add extra rpm's for security etc, then have a system in place to remove and reinstall with every ODA patch.
Get two ODA's because you need one to test the patches on. Even then, with identical ODA's I've had different issues on each one during patching.
MOSC ODA is a great resource. I've dm'd the mod on that list with my SR# and they have personally led oracle support to the resolution.
________________________________
From: oracle-l-***@freelists.org <oracle-l-***@freelists.org> on behalf of nilesh kumar <***@gmail.com>
Sent: March 15, 2021 12:22 AM
To: ORACLE-L <oracle-***@freelists.org>
Subject: Oracle ODA suggestions.
Hello All,
Hope everyone is doing good!
We are migrating our database from AIX machine to different platform namely Linux or Windows if possible.
Current oracle db is 12.2 version and they are mission critical databases and are standalone databases roughly with 5 tb sizes.
I was looking for a better solution when compared to the old legacy based approach like set-up a similar hardware and networks in our location and then do the database migration.
With minimum experience on the Hardware side and networking side, I came across Oracle data Appliance (ODA) but do not have any experience on ODA, if any one has set-up ODA or working on ODA could you please share your experience on ODA pros and cons.
Or any better approach or solution please advise.
--
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)
"As our circle of knowledge expands, so does the circumference of darkness surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat you with experience." - Unknown
Performance is great, administration is tedious. Everything needs to be done via the api. You don't use things such as dbca. There is a derby database that keeps track of all the oda metadata. If you get one, lock it down to the cowboys in the organization. You need to rule it with an iron fist because if the metadata doesn't match what's been done on the system it is tough.
If your org requires you to add extra rpm's for security etc, then have a system in place to remove and reinstall with every ODA patch.
Get two ODA's because you need one to test the patches on. Even then, with identical ODA's I've had different issues on each one during patching.
MOSC ODA is a great resource. I've dm'd the mod on that list with my SR# and they have personally led oracle support to the resolution.
________________________________
From: oracle-l-***@freelists.org <oracle-l-***@freelists.org> on behalf of nilesh kumar <***@gmail.com>
Sent: March 15, 2021 12:22 AM
To: ORACLE-L <oracle-***@freelists.org>
Subject: Oracle ODA suggestions.
Hello All,
Hope everyone is doing good!
We are migrating our database from AIX machine to different platform namely Linux or Windows if possible.
Current oracle db is 12.2 version and they are mission critical databases and are standalone databases roughly with 5 tb sizes.
I was looking for a better solution when compared to the old legacy based approach like set-up a similar hardware and networks in our location and then do the database migration.
With minimum experience on the Hardware side and networking side, I came across Oracle data Appliance (ODA) but do not have any experience on ODA, if any one has set-up ODA or working on ODA could you please share your experience on ODA pros and cons.
Or any better approach or solution please advise.
--
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)
"As our circle of knowledge expands, so does the circumference of darkness surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat you with experience." - Unknown