Nice video, but I feel that is a little bit uncompleted, you should have talked also about db parameters like LOCAL_LISTENER and REMOTE_LISTENER. I did a migration few weeks ago and I had some problems with this parameters, they are no such a big deal, but are important to know :D.
Hi Malik. I am not able to connect to Oracle DB XE using SQL developer. I watched many youtube videos and most of them are useless. I am new in SQL development. In my Windows 7 machine (I prefer it because it is fast and does not give problems constantly like Windows 10.). SQL developer and Oracle DB Developer on Virtual Machine are installed correctly. They both are both running. Unfortunatly I have no experience using Oracle Network Manager. Do you have a video on how to configure the network connection using Oracle Network Configuration Assistant? Thank yoiu!
Hey malli good morning.. I have only one doubt with respect to listerner. If there are some on going transactions happening and we accidentally killed listener, what happens to the user transactions??
There will not be any impact on the running transactions as listener work is just to hand off the connection to the database once the connection is establish there is no dependcy on the listener. New session will not be able to connect the database and will get "no listener" error. All connected session will run as they were before listener when listener was up..hope it help.
@@rocksolid194 yes thanks much , so even after killing the listener ,if I have a session established already to the DB ,then until I exit from it I can keep performing transactions ?
@@Nareshreddy-ot3fc Exactly it will not end until you exit it or someone kill it manually user transaction will continue. You can test this on your local environment. Practical things last long then theories.