biemond / biemond-oradb

Puppet Oracle Database Module
Apache License 2.0
59 stars 113 forks source link

18c support #235

Open chrisdrew1 opened 5 years ago

chrisdrew1 commented 5 years ago

Is 18c support going to be added as the installer is image based now for the db.

biemond commented 5 years ago

Oh, I am planning to do this. I did not look at it yet. But I was thinking it is just a minor 12.2 release with a new 18c name . You have more info about this image part.

Thanks

chrisdrew1 commented 5 years ago

https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/about-image-based-database-installation.html#GUID-0315AA15-1C03-4E96-B801-3A8E5F5D4B39

It's a MUCH faster install as you just unzip it into your oracle-home now. Kind of like the newer grid installs.

biemond commented 5 years ago

Ok cool. Create an db is still the same with dbca optional with a template ?

chrisdrew1 commented 5 years ago

Yep. Still very much the same.

biemond commented 5 years ago

I guess I won’t support this golden image creation based on an existing oracle home. But nice Oracle is doing cloning and just extracting.

biemond commented 5 years ago

Did you try the rpm based installation?

chrisdrew1 commented 5 years ago

So, no 18c support then?

chrisdrew1 commented 5 years ago

I haven't tried the rpm based install yet.

biemond commented 5 years ago

Not yet , in a few weeks for sure. A lot of research and testing without breaking the current stuff

chrisdrew1 commented 5 years ago

Great. I'm still trying to find a good way to release PSU/RU to the environments without having puppet/opatch fail after every run. opatch wants to apply patch, db is still up, puppet fails.

biemond commented 5 years ago

I need to take a look at puppet tasks for this . If this can solve these tasks you need to do a few times a year

chrisdrew1 commented 5 years ago

What we do now is deploy with the module, then manual patching afterwards.. Works, but it's not ideal. An emcli fleet management module would be awesome.

chrisdrew1 commented 5 years ago

I'm working using a hiera version value to have some machines not get patched, and new builds get the latest RU/PSU.

finduramit commented 5 years ago

Would be great to have 18c support soon. We have some resources lined up to test. Thanks Amit

phince commented 5 years ago

@biemond Is there an update on the roadmap for the implementation of 18c support?

biemond commented 5 years ago

yeah, there is. I know what to do , add it to the manifests and do a lot of testing.

I guess I will start with the client , database and at last grid.

biemond commented 5 years ago

On github oradb, 18.3 for grid and db install + config are working. I made an example but there is an issue on github, but basically use 18.0.0.0 as version for the install and 18.3 in the DB creation. Use LINUX.X64_180000_db_home.zip or LINUX.X64_180000_grid_home.zip as zip.