This content has been marked as final. Show 3 replies
Hello, and welcome to the OTN forums!
Please provide some additional information on your system: OS (exact version, if possible), DB version, system parameters (memory, ...)
From a first glance at the error message you receive, this could be an issue with your network configuration... Could you outline some details like how server and client (if different) are connected?
host_addr='127.0.0.2'... is a little odd. Did you configure this somewhere?
Has the system been broken since install or did it stop suddenly? ...
Assuming you're on 11g since you've posted an xml flavoured alert log entry, and the
means you're on linux, which distro? Something doesn't seem quite right with the network configuration, with an (almost) loopback/local host IP 127.0.0.2.
Linux Error: 32: Broken pipe
Verify your hostname and IP address. Ensure your listener.ora entry has either 1) the correct hostname or 2) your IP address for HOST=... stanza in your listener.ora.
$ ifconfig -a
... how many interfaces? en0? en1?
$ nslookup <hostname>
... <IP address>
$ nslookup <ipaddress>
... <hostname>[.domain name]
The loopback 127.0.0.1 IP is only useful for verifying that TCP is configured on the host, or in the case of the Apex server, the http://127.0.0.1... browser connection when remote apex access is disabled.
Another possible fix, if your hostname and IP is set up correctly, stop the listener and move the listener.ora file out of the way, and start it. An empty listener.ora file gets you a default listener on port 1521- try a system connection `alter system register;` and check the `lsnrctl status` and `lsnrctl services` output and see if symptoms are any different.