12.2 -> Non-CDB Support

[mjackson81]

Hi,

Would it be possible to have the functionality to install a non-cdb with Oracle 12.2?

Right now the database.pp has the if statement to fail if you are trying to install 12.2 and have container_database set to false.

From what I have seen online non-cdb is deprecated but should still work?

Thanks, Matt

[biemond]

Hi,

really I got exceptions on the dbca command when I don't set it. Probably you need to set it but you can skip the pluggable db creation.

thanks

[mjackson81]

Hi,

I'm still troubleshooting it but it seems like if I comment out the if statement requiring it to be a container, then I get exceptions on the dbca command as well, so I tried to manually copy / execute the dbca command and it was giving me an exception about the ASM storageType.

I see the -datafileDestination option is missing from the dbca command for some reason even though I see it in the code where you create the DBCA command and I am passing in a value for it, so if I then manually run the same DBCA command again but this time add in the -datafileDestination value it starts installing fine, so might just be something with generating the dbca command for 12.2?

Thanks, Matt

[mjackson81]

Turns out it was defaulting me to the dbca command for 11.2 because of the "or $container_database == false" so that is why my dbca command was missing the -datafileDestination parameter / getting the exception.

Just as a test I commented out the "or $container_database == false" in the 11.2 if statement, and removed the "-createAsContainerDatabase ${container_database}" from the 12.2 dbca command and it seems to be installing for me right now. At least I am no longer getting the DBCA exception I was getting before.

[biemond]

interesting

[mjackson81]

I have successfully created a couple of 12.2 non-container databases as tests using the above config. Do you think you might look at this and push out a new release to accommodate?

[biemond]

Perfect, can you send me a Pull request to know for sure I got all your changes. After my own testing I will push a new release.

[mjackson81]

Ok I created a pull request for you, it was just the hack I did to get 12.2 to work but isn't a solution... Would need to change the if statements around the dbca commands, create 1 for containers and one set of non-containers I guess.

[mjackson81]

Actually, I guess probably something like this would work but I wouldn't be able to run a test with it for a few days. database.zip