جزاك الله خيراً، لربما واجهت بعض المشاكل خاصة عند محاولة انشاء اتصال بين نظامي الويندوز والاوراكل لينكس، لكن حللت الموضوع ب انشاء ملف مشترك بين النظامين ثم رفع الحزمة المضغوطة عليه. كذلك واجهت مشكلة عدم توفر مساحة كافية عند تنصيب الاوراكل داتابيس لملف ال swap لكن حللتها كذلك بزيادة المساحة. شرح كافي ووافي، احسن الله إليك، وبارك الله فيك.❤
I've been struggling a lot with different database errors during the setup and also with the guestadittions in vbox but this guide has worked out perfectly to me. 10/10 it works
Say, it gives error "Oracle Net Services configuration failed. The exit code is 1" during the db creation & fails , and as for listener, the name is empty ! What might be the issue here with the listener?
Excellent explanation giving step by step instructions. One query though, after we restart the VM, is the DB mydb automatically available or we need to perform certain steps to start the mydb database and in which order. Is it 1) Start listener 2) startup etc. Kindly provide the steps to bring the mydb online after restart. Thank you in advance.
Thank you for liking the video, to start the database after restarting the VM you need to follow the steps as below: 1- startup the database 1.1- sqlplus / as sysdba 1.2- startup 1.3- exit 2- Startup the listener 2.1- lsnrctl start * note: you need make sure that the $ORACLE_HOME/bin on the ENV path I recommended to start the database first and make sure that it available for clients then start the listener, so the application and the users can reach it.
hey sir thanks for the video. I have an issue whenever I run the installer it keeps bringing up an error message and I seem not being able to fix it. just right after the command ./ runInstaller. how can I fix it.
Sir when enter sudo dnf.....19c cmd on terminal it's asking password sudo password but when I entered it's showing satish is not in the sudoers file .this incident will be reported
that means the user that you are using it not sudoer, you can check if its sudoer or not by runing this command echo $(id) and share the result of this command here plz
maybe the package changed in the Oracle Linux Release 9, could you please search for this package? "sudo dnf search preinstall" and see if this shows any result
@@icyb3r1 Last metadata expiration check: 0:02:47 ago on Sat 06 Aug 2022 08:24:40 PM +01. No match for argument: oracle-database-preinstall-19c Error: Unable to find a match: oracle-database-preinstall-19c
@@Serius Sorry for being late to reply, first of all If you are installing oracle for development or for testing it's okay, but if its for production I advice you to go with oracle linux 8 not oracle linux 9, any way if you want this package to install on your oracle linux 9 you can run those command from terminal curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm sudo yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
it worked the first time i tried it, but when I restarted the vm it tells me bash permission denied for lsnrctl and sqlplus commands with the full /u01/ path
Please, make sure that you are using oracle user and check the environment variable called $ORACLE_HOME if its available if you can copy the result of this command here, `echo $PATH`
@@MultiALI97 tthe script/setEnv.sh this you need to source it in .bash_profile, or in .profile it depends on which shell you are using and you need to grant execute for this file as well, `chmod +x script/setEnv.sh` , I hope this help you out. let me know if the issue still come to you
@@icyb3r1 it is present in the .bash_profile and I executed the chmod command but still no luck, I did install sql developer after your guide but I dont think that is what why it is giving errors
This is nice link for auto start so you can use systemctl to stop / start the database: www.moreajays.com/2020/11/database-auto-startup-in-oracle-19c.html Manual: If you want to stop VM which contains a DB : 1- stop listener: "lsnrctl stop" 2- stop database: "sqlplus -s / as sysdba shu immediate" to startup the database once you reboot the VM: 1- start database: "sqlplus -s / as sysdba startup" 2- start listener: "lsnrctl start"
make sure that you create scripts folder in oracle home directory. try => chmod +x ~/scripts/setEnv.sh if not working send me here the result of this command => ls -l ~/scripts
Here is the document I uploaded it there in case you want more docs related to oracle github.com/icyb3r-code/DBAdmin/blob/519a9d5f10d961cbe9e3c4abf095059ebf248794/Oracle/Contents/Install_Oracle19c_SingleInstance/README.md
جزاك الله خيراً، لربما واجهت بعض المشاكل خاصة عند محاولة انشاء اتصال بين نظامي الويندوز والاوراكل لينكس، لكن حللت الموضوع ب انشاء ملف مشترك بين النظامين ثم رفع الحزمة المضغوطة عليه. كذلك واجهت مشكلة عدم توفر مساحة كافية عند تنصيب الاوراكل داتابيس لملف ال swap لكن حللتها كذلك بزيادة المساحة.
شرح كافي ووافي، احسن الله إليك، وبارك الله فيك.❤
بارك الله فيك و زادنا و زادك علما و تقوى
I've been struggling a lot with different database errors during the setup and also with the guestadittions in vbox but this guide has worked out perfectly to me. 10/10 it works
Nice to hear that. willing to help with more video in near future.
Thank you for this helpful and well-orgenized video!
Thank for liking,
Say, it gives error "Oracle Net Services configuration failed. The exit code is 1" during the db creation & fails , and as for listener, the name is empty ! What might be the issue here with the listener?
thank you brother
You're welcome!
BEST EXPLANATION EVER THANKS ALOT
thanks for commenting the video, soon I will add RAC 19c Installation
Amazing work
I had successfully created database but when trying to test it , it is showing error 6 intializing sql*plus
Excellent explanation giving step by step instructions. One query though, after we restart the VM, is the DB mydb automatically available or we need to perform certain steps to start the mydb database and in which order. Is it 1) Start listener 2) startup etc. Kindly provide the steps to bring the mydb online after restart. Thank you in advance.
Thank you for liking the video, to start the database after restarting the VM you need to follow the steps as below:
1- startup the database
1.1- sqlplus / as sysdba
1.2- startup
1.3- exit
2- Startup the listener
2.1- lsnrctl start
* note: you need make sure that the $ORACLE_HOME/bin on the ENV path
I recommended to start the database first and make sure that it available for clients then start the listener, so the application and the users can reach it.
Hello sir, can we use the same steps to install 19c db in Alma and Rocky Linux? Thank you for the great video.
Red Hat has the same way of installation, but there will be some manual work, I will try to cover this in future videos.
It's clear and very helpful! Thanks!
Thank you, for liking, I will add more videos Soon
thank you for sharing the helpful video, but your GitHub link is corrupted.
sorry for that I will update it as as possible .. but u can check my github repos, github.com/icyb3r-code
hey sir thanks for the video. I have an issue whenever I run the installer it keeps bringing up an error message and I seem not being able to fix it. just right after the command ./ runInstaller. how can I fix it.
could you please join me on discord so it will be easy to share screenshot of the error , here is invitation link discord.com/invite/WsKUT67k
Awesome video, thank you 🙏🙏
Most welcome, brother.
Sir when enter sudo dnf.....19c cmd on terminal it's asking password sudo password but when I entered it's showing satish is not in the sudoers file .this incident will be reported
that means the user that you are using it not sudoer, you can check if its sudoer or not by runing this command echo $(id) and share the result of this command here plz
Thanks
I have Oracle linux 9 and the command "dnf install..." doesn't work for me. It gives me an error: unable to find a match
maybe the package changed in the Oracle Linux Release 9, could you please search for this package? "sudo dnf search preinstall" and see if this shows any result
@@icyb3r1 still the same error
@@Serius could you plz add the complete error message here?
@@icyb3r1 Last metadata expiration check: 0:02:47 ago on Sat 06 Aug 2022 08:24:40 PM +01.
No match for argument: oracle-database-preinstall-19c
Error: Unable to find a match: oracle-database-preinstall-19c
@@Serius Sorry for being late to reply, first of all If you are installing oracle for development or for testing it's okay, but if its for production I advice you to go with oracle linux 8 not oracle linux 9, any way if you want this package to install on your oracle linux 9 you can run those command from terminal
curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
sudo yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
have try install oracle19c on AIX?
Yes I've installed it on IBM AIX 7.2 as RAC to RAC data guard 19c
it worked the first time i tried it, but when I restarted the vm it tells me bash permission denied for lsnrctl and sqlplus commands with the full /u01/ path
Please, make sure that you are using oracle user and check the environment variable called $ORACLE_HOME if its available if you can copy the result of this command here, `echo $PATH`
[oracle@localhost dbhome_1]$ echo $PATH
/u01/app/oracle/product/19.3/dbhome_1/bin:/usr/sbin:/usr/local/bin:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin
@@icyb3r1 this was the output and I ran the source script/setEnv.sh command
@@MultiALI97 tthe script/setEnv.sh this you need to source it in .bash_profile, or in .profile it depends on which shell you are using and you need to grant execute for this file as well, `chmod +x script/setEnv.sh` , I hope this help you out. let me know if the issue still come to you
@@icyb3r1 it is present in the .bash_profile and I executed the chmod command but still no luck, I did install sql developer after your guide but I dont think that is what why it is giving errors
Very nice!!
Thank you
Could you please share how we can auto start / stop DB when we stop/restart the VM.
This is nice link for auto start so you can use systemctl to stop / start the database:
www.moreajays.com/2020/11/database-auto-startup-in-oracle-19c.html
Manual:
If you want to stop VM which contains a DB :
1- stop listener: "lsnrctl stop"
2- stop database: "sqlplus -s / as sysdba shu immediate"
to startup the database once you reboot the VM:
1- start database: "sqlplus -s / as sysdba startup"
2- start listener: "lsnrctl start"
I use Windown 10 not linux, You can get me scripts use in windown " ifconfig | grep -i "vmet8" -A1 | grep -i inet" .Thank you
thanks for your comment, you can use this powershell command on windows: ipconfig | select-string "vmnet8" -context 0,4 | findstr -i "ipv4"
Hi, It is a nice installation procedure. But, not understand the part LINUX.X64_193000_db_home.zip. and OracleLinux-R8......
Thanks for commenting, do you mean the Downloading or moving the .zip files to Oracle linux server ?
Hi, I didn't understand how can I download "LINUX.X64_193000_db_home.zip" and "OracleLinux-R8-U1-x86-64-dvd.iso".
@@rashmiranjansenapati
you need to download them from the oracle edelivery edelivery.oracle.com/
you can search on google oracle edelivery
Vlw muito obrigado me ajudou muito .
Most welcome, I will add more RAC and DG soon
could please share oracle client 21c xe installation video and create users in oracle linux
sure if I got enough time I'll share that installation and setup video
When I get to 'source scripts/setEnv.sh' I'm getting a batch permission denied. Cant chmod it. hewp
make sure that you create scripts folder in oracle home directory.
try => chmod +x ~/scripts/setEnv.sh
if not working send me here the result of this command => ls -l ~/scripts
I need this document will you please share
Here is the document I uploaded it there in case you want more docs related to oracle
github.com/icyb3r-code/DBAdmin/blob/519a9d5f10d961cbe9e3c4abf095059ebf248794/Oracle/Contents/Install_Oracle19c_SingleInstance/README.md
Can you please demo
On virtual box too
Sure I will do that video
thanks for the video, but your github link is corrupted
Thanks for commenting, Check now plz
sir can u give the pdf for installation and commands to my email
this is the link of the installation commands
tinyurl.com/5n9bxm2p
Thank you for this detailed and well-explained video!
thanks for liking the video.
Thank you very much.
It's my pleasure.