while opening the kitematic i'm getting the below error. How to solve this. 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
I did all the steps as they were shown, but when I try to connect to the db, during the testing of the connection I receive this mistake "Status : Failure -Test failed: IO Error: Got minus one from a read call". Can you help me with that please?
I am getting this error please help. 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
connecting with role SYSDBA is succesful, but doing it with role Default I get this error: Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied
Could somebody help me please ? I followed all the steps, and when I clicked test connection at the end, I got the error: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
hi, thanks for your video. i ran " sudo docker run -d \ -p 32118:1521 \ -p 35518:5500 \ -e ORACLE_PWD=Oracle18 \ --name=oracle-xe \ --volume ~/docker/oracle-xe:/opt/oracle/oradata \ --network=oracle_network18c \ oracle-xe:18c " i got " Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?. " how can i fix it ?
Hello, The video is great. Thanks for all the help. I'm having a problem though. When I try to configure Docker in terminal, the below message is what I'm getting: docker: Error response from daemon: Conflict. The container name "/oracle-xe" is already in use by container "1fb94c97fa6ba0ad08b6e39f6e408a722f7f614123e5be9d90f48d8e22d6fa2a". You have to remove (or rename) that container to be able to reuse that name. See 'docker run --help'. And, the "oracle-xe" image will not run in Kitematic. Am I doing something wrong? Thanks.
I was following same steps but when installation process was going in KITEMATIC and the same time my laptop is shutdown and using MAC machine and after that i tried to start again the process getting this error even i have tried multiple times created new network and different networks can someone help me below errors ---- 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
So when you created did you use sudo command as it says you need to be root user and if you don't use sudo before the command, you will not be able to configure the database
Hello, at first, thanks very much for your video I have a question, i want to use "HR" account. so in terminal i typed `ALTER USER hr ACCOUNT UNLOCK;' but reply is ORA-01918: user 'HR' does not exist.' How can i solve this problem?
first run the create command to create the HR user and password here For MSSQL => docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-2017 For Oracle => docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8003.htm#SQLRF01503
Hi, great demo, I followed your instructions, but I can't connect as sys with the standard Oracle18 password as role sysdba. I didn't deviate from the video but I get ORA-01017 Invalid username/password. I've tried typing, checked case, tried cutting and pasting username/password, "sys" uppercase/lowercase to no avail. I can login as "system" as role "default" with Oracle18. Any ideas please?
Its needed as per requirement from fuzzy brain - on his git repo, to execute some scripts in the image..Try without installing XCode - should work. As, I dint see it in requirement now.
GUI applications are tricky to run in a container. Better to use a Linux VM for that. You can get official VirtualBox VM's from Oracle with the Database already installed. www.oracle.com/technetwork/community/developer-vm/index.html or you can grab a vagrant image from here github.com/oracle/vagrant-boxes.
@@shanexbloom I have another video, where I installed MSSQL server with the image directly from Kitematic, you can follow that. Basically after install just update the Settings for the container =>Port number, system admin password etc
@@TechHowdy invalid reference format. im getting the same error, i checked and Docker is running. at first it asked me for a Password, i entered password incorrecr 3 times so now im getting the message invalid reference format.
Status: Nicht erfolgreich -Test nicht erfolgreich: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I was unable to install or even see kitematic on my Mac? It was a lengthy tutorial and everything was in vain. I don’t think kitematic is available anymore.
Hey Tech Howdy, I am getting the below error while configuring and running Docker. unknown shorthand flag: '-' in --p Please help me in resolving this issue.
@@TechHowdy I am using mac. The commands that i used are listed below, Umeshs-MBP:~ root# sudo docker run -d\ > -p 32118:1521\ > -p 35518:5500\ > -e ORACLE_PWD=Oracle18\ > --name=oracle-xe\ > --volume -/docker/oracle-xe:/opt/oracle/oradata \ > --network=oracle_networkXE \ > oracle-xe:18c For which am getting error as below, unknown shorthand flag: '-' in --p See 'docker run --help'.
hi, I got this error: Step 5/11 : RUN yum install -y oracle-database-preinstall-18c && yum install -y /tmp/${ORACLE_XE_RPM} && rm -rf /tmp/${ORACLE_XE_RPM} ---> Running in e62980ed9b08 There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: No module named yum Please install a package which provides this module, or verify that the module is installed correctly. It's possible that the above module doesn't match the current version of Python, which is: 2.7.5 (default, Jun 20 2019, 13:30:36) [GCC 4.8.5 20150623 (Red Hat 4.8.5-36.0.1)]
12:07 database files are not loading ((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)) i get this message in kitematic
Hello, I am receiving the following error: Step 4/11 : COPY ./files/${ORACLE_XE_RPM} /tmp/ COPY failed: stat /var/lib/docker/tmp/docker-builder713699068/files/oracle-database-xe-18c-1.0-1.x86_64.rpm: no such file or directory Please help!!!
@@ekakoll This is probably caused by the version of docker you re using, can you try to downgrade the version and try as /var/lib/docker does not exist. Or try to re-install docker and try
Hello, 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 Terminated Stopping container. SIGTERM received, shutting down database! it appears like this in my container ^ ! and in sql developer I receive this error ( Status : Failure -Test failed: IO Error: Got minus one from a read call )
i changed my password for my mac, because i had a symbol now it accept my new password thats all digits. However im getting this error: docker: Error response from daemon: Conflict. The container name "/oracle-xe" is already in use by container "ce58331bc2fa78658d341e8ef4b2390619be7ac65815bfcf851291677ba5275a". You have to remove (or rename) that container to be able to reuse that name.
Hi, not sure if you made same mistake i had, but you followed like for like, you might want to make sure the O in Oracle18 for the password in capitalized.
How can I change "/var/root/oracle_data/" to another path to pass this error ? ----------- docker: Error response from daemon: Mounts denied: The path /var/root/oracle_data/ is not shared from OS X and is not known to Docker. You can configure shared paths from Docker -> Preferences... -> File Sharing. See docs.docker.com/docker-for-mac/osxfs/#namespaces for more info.
Uh oh :( DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 1): no suitable image found. Did find: file system relative paths not allowed in hardened programs". See oracle.github.io/odpi/doc/installation.html#macos for help Node-oracledb installation instructions: oracle.github.io/node-oracledb/INSTALL.html You must have the 64-bit Oracle Instant Client Basic or Basic Light package in ~/lib or /usr/local/lib They can be downloaded from www.oracle.com/technetwork/topics/intel-macsoft-096467.html
Thanks for your detailed instruction! Your instruction made my day and allow me to pass the data and work the project at home.
Thank you so so much. I followed each steps and it worked. Just this one video saves me a lotta time.
Very good guide! Congratz!
thank you you made my day , saved my life , I love you
lokan tchoufi ana
Thank you for this tutorial, you help me a lot!!!
while opening the kitematic i'm getting the below error. How to solve this.
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
Bravo!!! Bravo!!! Bravo!!! Bravo!!! Bravo!!! Bravo!!!
It's working on my mac. Thanks so much !!!
Thank you so much!! You saved my day!
Thank you bro are you awesome!
Thank you very much, it also worked for me on ubuntu.
I follow every step but my docker doesn't respond on the command in terminal. All I receive is "0 No logs for this container." Can anyone help?
thanks a lot,
can this solution apply to build Oracle database on Mac M2, please?
Thank you Sr.
How to get proc library without having to install a complete oracle database?
I get this Error when I try to access via SQL Developer .
Status : Failure -Test failed: IO Error: Got minus one from a read call
I did all the steps as they were shown, but when I try to connect to the db, during the testing of the connection I receive this mistake "Status : Failure -Test failed: IO Error: Got minus one from a read call". Can you help me with that please?
I have done everything up until 11:50 but no database files are being created. Please help me.
I am getting this error please help.
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
Gracias amigo a pesar de que está todo en inglés a final de cuentas logre instalar correctamente el contenedor.
thanks buddy :D
Ive got this error after wrote the first command "docker build" requires exactly 1 argument
How can I add a new login Connection? bc on Windows OS I can just right-click, on a mac, I just get a refresh option!!!!!
connecting with role SYSDBA is succesful,
but doing it with role Default I get this error:
Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied
Can you use the command line to change the password of the user
try System/ or sys as SYSDBA/
Could somebody help me please ?
I followed all the steps, and when I clicked test connection at the end, I got the error:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
can you check the port number is correctly mapped
@@TechHowdy Hello, i have the same issue can i have some help please ?
My Docker Port is 1521 and IP:PORT 32118 as in the video
@@TechHowdy same problem ......
Thank you.
Hi thank you very much it works !!
Quick question though, can I delete the file 'docker-oracle-xe' after completing all the steps ?
Hi Can you please layout how to install oracle apex on top of oracle express 18c on a docker in MAC
hi, thanks for your video. i ran " sudo docker run -d \
-p 32118:1521 \
-p 35518:5500 \
-e ORACLE_PWD=Oracle18 \
--name=oracle-xe \
--volume ~/docker/oracle-xe:/opt/oracle/oradata \
--network=oracle_network18c \
oracle-xe:18c
" i got " Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?. "
how can i fix it ?
i ran hello-work, it works.
i tried to restart docker it remain the same.
thank you sir...
Hello,
The video is great. Thanks for all the help. I'm having a problem though. When I try to configure Docker in terminal, the below message is what I'm getting:
docker: Error response from daemon: Conflict. The container name "/oracle-xe" is already in use by container "1fb94c97fa6ba0ad08b6e39f6e408a722f7f614123e5be9d90f48d8e22d6fa2a". You have to remove (or rename) that container to be able to reuse that name.
See 'docker run --help'.
And, the "oracle-xe" image will not run in Kitematic. Am I doing something wrong?
Thanks.
Sorted. I just restarted Kitematic. You're my hero @Tech Howdy. Thanks.
Thank you
hi, can I change the password without the CLI or do I really need to install CLI to change password? Thank you
Thanks for sharing, great video, can you please make same thing for Windows 10, it'll help alot. Pls.
Is Xcode necessary to install Oracle DB 18c? I haven't seen that it was used on the video.
Try and see if it works without Xcode build tools
@@TechHowdy thank you again, I successfully installed it but somehow, it does not work after I turned off and on my mac...
@@recording_kim7852 Hey - you need to restart your container and docker when you reboot mac
I was following same steps but when installation process was going in KITEMATIC and the same time my laptop is shutdown and using MAC machine and after that i tried to start again the process getting this error even i have tried multiple times created new network and different networks can someone help me below errors
----
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
So when you created did you use sudo command as it says you need to be root user and if you don't use sudo before the command, you will not be able to configure the database
@@TechHowdy i've got the same error and i used sudo, any fix ?
Hello, at first, thanks very much for your video
I have a question, i want to use "HR" account. so in terminal i typed `ALTER USER hr ACCOUNT UNLOCK;' but reply is ORA-01918: user 'HR' does not exist.'
How can i solve this problem?
first run the create command to create the HR user and password here
For MSSQL => docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-2017
For Oracle => docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8003.htm#SQLRF01503
hola me sale un error al crear el build
=> ERROR [3/5] RUN yum install -y oracle-database-preinstall-18c && y 11.4s
I have the same error. Does anyone know how to solve it?
how can i add HR account?
Hi, great demo, I followed your instructions, but I can't connect as sys with the standard Oracle18 password as role sysdba. I didn't deviate from the video but I get ORA-01017 Invalid username/password. I've tried typing, checked case, tried cutting and pasting username/password, "sys" uppercase/lowercase to no avail. I can login as "system" as role "default" with Oracle18. Any ideas please?
I am Windows rather than Mac, the cmd window wasn't "run as admin".
Yep that was it, in windows, make sure the cmd window is "run as admin"
Now sys won't login. What kind of hell is this dB?!
please how to Install oracle 11g on mac ?
thanks
that work! thanks :D But Is it necessary to install XCode?
If you already have it installed you don't need to, the zip file provided from fuzziebrain has scripts that require Xcode to run them
hey may i ask what's the purpose of installing xcode since it's taking 11gb of my storage space
Its needed as per requirement from fuzzy brain - on his git repo, to execute some scripts in the image..Try without installing XCode - should work. As, I dint see it in requirement now.
Is it possible to install Oracle Forms and Reports builder after installing Oracle Database 18c XE using Docker??
GUI applications are tricky to run in a container. Better to use a Linux VM for that. You can get official VirtualBox VM's from Oracle with the Database already installed. www.oracle.com/technetwork/community/developer-vm/index.html or you can grab a vagrant image from here github.com/oracle/vagrant-boxes.
Hey quick question, can these steps work with oracle 12c or is it different?
Yes you can - but use the 12c image directly available on kitematic
Tech Howdy gotcha thank you!
Tech Howdy hey so because I am downloading 12c image directly from kitematic what part of the video should I skip. Or don’t skip anything?
@@shanexbloom I have another video, where I installed MSSQL server with the image directly from Kitematic, you can follow that. Basically after install just update the Settings for the container =>Port number, system admin password etc
I have done the same as the steps shown but it shows “ docker: invalid reference format. Please on help
can you check if docker is running - check the docker icon on top
@@TechHowdy invalid reference format. im getting the same error, i checked and Docker is running. at first it asked me for a Password, i entered password incorrecr 3 times so now im getting the message invalid reference format.
@@mohammedbougayou3169 Can you verify if you are using the image from fuzzybrain ?
Status: Nicht erfolgreich -Test nicht erfolgreich: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
SAME ISUSUE WITH ME..ANY SOLUTION??
I was unable to install or even see kitematic on my Mac? It was a lengthy tutorial and everything was in vain. I don’t think kitematic is available anymore.
kitematic.com/
Its part of docker tool box now
Hey Tech Howdy,
I am getting the below error while configuring and running Docker.
unknown shorthand flag: '-' in --p
Please help me in resolving this issue.
Are you using mac or windows . Also can you share the command
ok your command has --p two dashes. It should be only one dash -p
@@TechHowdy I am using mac. The commands that i used are listed below,
Umeshs-MBP:~ root# sudo docker run -d\
> -p 32118:1521\
> -p 35518:5500\
> -e ORACLE_PWD=Oracle18\
> --name=oracle-xe\
> --volume -/docker/oracle-xe:/opt/oracle/oradata \
> --network=oracle_networkXE \
> oracle-xe:18c
For which am getting error as below,
unknown shorthand flag: '-' in --p
See 'docker run --help'.
Tech Howdy i used only one dash
hi, I got this error: Step 5/11 : RUN yum install -y oracle-database-preinstall-18c && yum install -y /tmp/${ORACLE_XE_RPM} && rm -rf /tmp/${ORACLE_XE_RPM}
---> Running in e62980ed9b08
There was a problem importing one of the Python modules
required to run yum. The error leading to this problem was:
No module named yum
Please install a package which provides this module, or
verify that the module is installed correctly.
It's possible that the above module doesn't match the
current version of Python, which is:
2.7.5 (default, Jun 20 2019, 13:30:36)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-36.0.1)]
12:07 database files are not loading ((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)) i get this message in kitematic
You don't need Kitematic in the new versions of docker for mac.
Hi i use the password Oracle18c in sql developer but doesnt work, what can i do?
thx
I found it, Oracle18
Hello,
I am receiving the following error:
Step 4/11 : COPY ./files/${ORACLE_XE_RPM} /tmp/
COPY failed: stat /var/lib/docker/tmp/docker-builder713699068/files/oracle-database-xe-18c-1.0-1.x86_64.rpm: no such file or directory
Please help!!!
did you run the command with "sudo" ?
same error here. Even after using sudo, getting the same error. Any luck?
@@TechHowdy same error here. Even after using sudo, getting the same error. Any help will be very much appreciated,
@@ekakoll This is probably caused by the version of docker you re using, can you try to downgrade the version and try as /var/lib/docker does not exist. Or try to re-install docker and try
@@TechHowdy Sure. Doing it now. Will keep you posted. Thanks
Hello,
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
Terminated
Stopping container.
SIGTERM received, shutting down database!
it appears like this in my container ^ ! and in sql developer I receive this error ( Status : Failure -Test failed: IO Error: Got minus one from a read call )
please I need help 😞
while building image , after reaching step 4/11 my build is being cancelled. what could be the reason??
can anyone help me how to resolve it?
did you try with sudo command as mac denies permission
@@TechHowdy
Step 5/11 : RUN yum install -y oracle-database-preinstall-18c && yum install -y /tmp/${ORACLE_XE_RPM} && rm -rf /tmp/${ORACLE_XE_RPM}
---> Running in 5154614d0f73
Loaded plugins: ovl
The command '/bin/sh -c yum install -y oracle-database-preinstall-18c && yum install -y /tmp/${ORACLE_XE_RPM} && rm -rf /tmp/${ORACLE_XE_RPM}' returned a non-zero code: 137
AM GETTING THE ABOVE ERROR IN TERMINAL...
@@TechHowdy
I don't know anything about docker software or how it works ..I'm blindly following your instructions from the videos.
@@TechHowdy
hey my problem is resolved ...
btw thank you so much for the video!!
XD
i changed my password for my mac, because i had a symbol now it accept my new password thats all digits. However im getting this error: docker: Error response from daemon: Conflict. The container name "/oracle-xe" is already in use by container "ce58331bc2fa78658d341e8ef4b2390619be7ac65815bfcf851291677ba5275a". You have to remove (or rename) that container to be able to reuse that name.
are you on windows- if yes can you run the cmd as admin
@@TechHowdy im in mac, now i was able to go forward with everything thanks for your help.
@@mohammedbougayou3169 did you fix that on mac then? can you tell me how plz?
@@giannipisano8301 I had so much trouble with it. so i just bought a windows machine and i install it. sorry.
I downloaded docket but I don't see kitematic
kitematic is seperate GUi - you wills ee it in the docker dropdown - click on it and install it
hy why i have invalid password .ursename when i create connection in sql
Did you setup a admin password ? or did u choose the right container or can be your docker is running but container is stopped.
Hi, not sure if you made same mistake i had, but you followed like for like, you might want to make sure the O in Oracle18 for the password in capitalized.
@@CodingWithGhostInCode thanks alot!
How can I change "/var/root/oracle_data/" to another path to pass this error ?
-----------
docker: Error response from daemon: Mounts denied:
The path /var/root/oracle_data/
is not shared from OS X and is not known to Docker.
You can configure shared paths from Docker -> Preferences... -> File Sharing.
See docs.docker.com/docker-for-mac/osxfs/#namespaces for more info.
so complicated way to install 1 simple database. Why Oracle you do this?
this not work on my m1 mac
Hi, Is there any other way to install oracle on M1 Mac?
Uh oh :( DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 1): no suitable image found. Did find: file system relative paths not allowed in hardened programs". See oracle.github.io/odpi/doc/installation.html#macos for help Node-oracledb installation instructions: oracle.github.io/node-oracledb/INSTALL.html You must have the 64-bit Oracle Instant Client Basic or Basic Light package in ~/lib or /usr/local/lib They can be downloaded from www.oracle.com/technetwork/topics/intel-macsoft-096467.html
What's the password default? 'Oracle18' is invalid
it's ok after add arg -e ORACLE_PWD=Oracle18