Oracle Solution for Error ora-12523

ORA-12523: TNS:listener could not find instance appropriate for the client connection

What triggered the Error:

The listener could not find any available (database) instances, that are appropriate for the client connection.

What should we do to fix it:

Run "lsnrctl services" to ensure that the instance(s) are registered with the listener, and have status READY.