Configuring Oracle Network || listener-tnsnames-sqlnet || netmgr - netca || tnsping and lsnrctl
HTML-код
- Опубликовано: 13 июл 2024
- Tools for Configuring and Managing the Oracle Network
Enterprise Manager Net Services Administration page
Oracle Net Manager
Oracle Net Configuration Assistant
Command line
lsnrctl
tnsping
REMOTE_ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = host02.example.com) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.example.com)
)
)
#listener.ora #tnsnames.ora #sqlnet.ora #tnsping #lsnrctl #Administration #Database #Exadata #RAC #ASM #Oracle
Please do follow me and support me on,
LinkedIn: / mallik034
RUclips: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RUclips: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg Наука
Thanks a lot
Thank you sir
You are welcome
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.
Hello Lucian,
There is one session i have clearly talked about local_listener and remote_listener.
Please search on playlist and refer that video
❤
Thanks
Do you have JDBC Thin connection video using SSL for port 2484?
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!
What is the error message you seeing
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.
Thanks for clarifying
Thanks for clarifying
Hi sir, sorry to say that, your voice is very low even at full volume & fluctuations also there.
Very bad vedio quality. Plz Improve vedio quality