search

gvenzl / oci-oracle-xe

Build scripts for Oracle Database XE container/docker images
Apache License 2.0
257 stars 77 forks source link

Trying to run gvenzl/Oracle-XE image From a Synology 920 DSM Container #242

Closed dbreslin42 closed 4 months ago

dbreslin42 commented 6 months ago

Hi. I'll start off by saying I am totally new to container-based executions but I'm willing to experiment and learn as I'm trying to run an Oracle Database from my NAS unit so that the overhead isn't on my main laptop. Based on my research this seems to be the a version of the DB that is designed for container use (and containers are the only way it seems I can run the database on the DSM OS)

I was able to locate this image in the Docker Registry and downloaded it. Now for anyone unfamiliar with the Container Manager in Synology, its GUI Based and so I am unable to edit anything or execute a terminal until I have a stable container open then I get a terminal option.

When I create the container, this is what the GUI looks like ss1 ss2 ss3 ss4

When I run the container script I receive the following error and have not been able to resolve it. "Container starting up Oracle Database SYS and SYSTEM passwords have to be specified at first database startup. Please Specific a password either via the $ORACLE_PASSWORD variable, e.g. '-e ORACLE_PASSWORD=' or set the $ORACLE_RANDOM_PASSWORD environment variable to any value, e.g. '-e ORACLE_RANDOM_PASSWORD=yes'.

I've tried to enter various derivatives of ORACLE_PASSWORD in the variable section and some sample code that I cant locate at the moment in the execution command section without success. Oh and executing this container dosn't even bring up a prompt or terminal automatically for me to enter the passwords. It simply closes the container with the above error.

Can anyone help? I've found terminal based assistance with the Oracle documentation and general container based assistance for synology but no posts covering this image and a container in Synology; s environment.

Thanks in advance for ANY help for this middle-aged dog that is trying to learn new tricks in his free time to maintain being somewhat competitive at work

gvenzl commented 5 months ago

Hey @dbreslin42,

Thanks a lot for your interest in these images!

Hm, you should really not need all these variables to run the container, they are already all set in the container image itself. However, you will need the ORACLE_PASSWORD or ORACLE_RANDOM_PASSWORD variable set. But you said even when that is set, the container still tells you that it isn't, is that right?

The container will never prompt you for the password as it assumes to be run in the background on some server. That's why the container stops if the variable isn't provided.

Perhaps you'd like to first try to run the container on your laptop? That way it would perhaps be easier to see the difference on the container manager software on the Synology DSM.

dbreslin42 commented 4 months ago

Thank you for responding. I spent a lot of time trying to play with containers and getting it running on the NAS and the laptop and gave up. Found a Synology MariaDB Package and had that up and running in like 5 minutes. with PHPAdmin Unfortunately been banging my head a lot with doing non-windows applications lately and in the end a GUI is nice to let the package do the install/configuration.

BUt yes I tried to set the passwords but there was no construct that the package seemed to accept so I could not proceed

gvenzl commented 4 months ago

I'm sorry to hear that, @dbreslin42 but thanks for giving it a try!