current position:Home>Open Oracle server under Linux to allow remote connection

Open Oracle server under Linux to allow remote connection

2022-06-24 09:52:00euler1983

Environmental Science :linux,oracle The server , Use docker Inside python visit oracle database .

Report errors :ORA-12541:TNS:no listener 

screening :

su - oracle Switch to oracle After user , use sqlplus You can connect to the database , It shows that the database itself is OK .

function :lsnrctl status, It is found that the listening terminal is localhost.

got it , This limits the remote connection .

resolvent :

modify Configure server listener.ora, add HOST=0.0.0.0, If not , By default, only programs running on this computer can access .

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =0.0.0.0)(PORT = 1521))
)

 

Restart monitoring :lsnrctl stoplsnrctl start

copyright notice
author[euler1983],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/175/202206240850235806.html

Random recommended