After finishing the installation of Oracle 12c on Centos 7, now I try to allow access on my PC (via SQL Developer) to the server. The problem is that when I do:
I get this error:
TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory
So, I try to start the listener with:
And I get this error:
TNS-01198: Listener failed to initialize valid node list NL-07007: internal error NL-00408: cannot find or read value NL-00408: cannot find or read value NL-00408: cannot find or read value
To finish I go to this website: TNS-01198: Listener failed to initialize valid node list post upgrade from 11g to 12c
Then I added, as he tell the following line on the
VALID_NODE_CHECKING_REGISTRATION_<LISTENER_SERVICENAME> = OFF
but nothing change.
To finish, this is my
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. VALID_NODE_CHECKING_REGISTRATION_<LISTENER_SID> = OFF LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ns330926.ip-37-187-120.eu)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
I added my hostname in the
Does anyone have a solution?