docker-oracle-xe icon indicating copy to clipboard operation
docker-oracle-xe copied to clipboard

cannot stat

Open bmbBAMBUS opened this issue 6 years ago • 8 comments

docker run -p 32118:1521 -p 35518:5500 --name=oracle-xe --volume ~/docker/oracle-xe:/opt/oracle/oradata oracle-xe:18c

Database exists
cp: cannot stat '/opt/oracle/oradata/dbconfig/XE/oratab': No such file or directory
The Oracle Database is not configured. You must run '/etc/init.d/oracle-xe-18c configure' as the root user to configure the database.
The following output is now a tail of the alert.log:
tail: cannot open '/opt/oracle/diag/rdbms/*/*/trace/alert*.log' for reading: No such file or directory
tail: no files remaining

Hello, probably it's my fault but could you advise me what to do in such situation? Build passed successfully.

bmbBAMBUS avatar Nov 07 '18 21:11 bmbBAMBUS

Do you have selinux in enforcing mode?

fuzziebrain avatar Nov 07 '18 21:11 fuzziebrain

getenforce returns Disabled

bmbBAMBUS avatar Nov 07 '18 21:11 bmbBAMBUS

What about the Docker version that you're running?

fuzziebrain avatar Nov 07 '18 22:11 fuzziebrain

Docker version 18.06.1-ce, build e68fc7a I want to add that XE 11 from oracle/docker-images works correctly.

bmbBAMBUS avatar Nov 08 '18 07:11 bmbBAMBUS

I run the same version of Docker and have had no issues. You could try running the container without mounting a volume. See if that works.

fuzziebrain avatar Nov 08 '18 08:11 fuzziebrain

I see the last comment was nearly half a year ago, but I ran into the same issue. Since I finally figured it out, I figured I'd at least comment in case anyone else runs into it.

I was running into the same exact issue so I decided I'd try to start completly over, which means destroying all the docker containers, images and the host OS data directory ~/docker/oracle-xe.

I then remembered, and recreated this issue.

After running docker build -t oracle-xe:18c ., next command you should run is docker run ....

You should definetly watch the logs with a better docker logs command such as this docker logs -f --tail 25 oracle-xe because if the docker run fails on the first attempt it will give the error of this issue #20. Like @fuzziebrain explains, this is because it runs oracle-xe configure on the first run.

Either way, if you run into this error rm -rf ~/docker/oracle-xe or whever your datastores are, destroy all docker containers and images used and start over with the instructions.

TylerAngelier avatar Jul 05 '19 20:07 TylerAngelier

Following the above advice, I blew away everything. During the build step, I do notice that I get errors in installing the required packages:

install-info: /usr/share/info/dir: could not read (No such file or directory) and could not create (No such file or directory) failed to link /usr/share/man/man1/ksh.1.gz -> /etc/alternatives/ksh-man: No such file or directory

I'm not sure if this is a critical error, or more a warning, the logs don't clearly tell me. I allow the build to continue and the build finally reports complete! When running the first docker run command, the run command trows a warning about the sga_target is too small, ORACLE not available, and finally cannot stat /opt/oracle/product/18c/dbhomeXE/dbs/spfileXE.ora.

I'm sure there is some step I'm missing, I just can't seem to figure out what that missing step is.

shannonlowder avatar Feb 10 '20 23:02 shannonlowder

Hello There: I need to connect SQL Developer to oracle database and my kitematic container log after sudo docker run Database exists cp: cannot stat '/opt/oracle/oradata/dbconfig/XE/oratab': No such file or directory The Oracle Database is not configured. You must run '/etc/init.d/oracle-xe-18c configure' as the root user to configure the database. The following output is now a tail of the alert.log: tail: cannot open '/opt/oracle/diag/rdbms///trace/alert*.log' for reading: No such file or directory tail: no files remaining Database exists cp: cannot stat '/opt/oracle/oradata/dbconfig/XE/oratab': No such file or directory The Oracle Database is not configured. You must run '/etc/init.d/oracle-xe-18c configure' as the root user to configure the database. The following output is now a tail of the alert.log: tail: cannot open '/opt/oracle/diag/rdbms///trace/alert*.log' for reading: No such file or directory tail: no files remaining: This is my second attempt since my first try failed so I created another docker oracle-xe from your image download. Can you please what should I do to get my sql developer connects to ORACLE DATABASE?

arun101GitHub avatar Oct 18 '20 20:10 arun101GitHub