Php remote connection Oracle error oci_connect (): ORA-12541: TNS: nolistener

The situation is as follows: Oracle and php are not on the same machine and can access Oracle on the machine where Oracle is located. But when remotely connected via php, the error oci_connect (): ORA-12541: TNS: nolistener is reported. The listener of the Oracle machine has been enabled. How to solve the problem of ph... is as follows:

1. Oracle and php are not on the same machine, and Oracle can be accessed on the machine where Oracle is located.

2. But when remotely connected via php, the error oci_connect (): ORA-12541: TNS: no listener is reported.

3. The listener of the Oracle machine has been enabled.

How to solve php remote connection? Thank you!

Reply content:

The situation is as follows:

1. Oracle and php are not on the same machine, and Oracle can be accessed on the machine where Oracle is located.

2. But when remotely connected via php, the error oci_connect (): ORA-12541: TNS: no listener is reported.

3. The listener of the Oracle machine has been enabled.

How to solve php remote connection? Thank you!

All methods have been tried. After oracle is uninstalled and re-installed, everything is normal...

On the oracle server, run the following command to check whether the oracle listening service is running normally.

su - oraclelsnrctl status

If the listening service is normal, the following similar results should be output. XXX is the name of serive and instance.
Service "XXX" has 1 instance (s ).
Instance "XXX", status READY, has 1 handler (s) for this service...
The command completed successfully

First, make sure that an error is reported in PHP.no listenerSo it must beno listenerYou do not need to question this.

1. remote connection to Oracle (whether Oracle allows remote access)
2. Can PHP server connect to Oracle server.