This exception met? I am a server creates two oracle instance, local access is normal, another machine, can only access one of them, another is to this question,
Error connecting to the database: (using class. Oracle JDBC. Driver. OracleDriver)
The Listener refused the connection with the following error:
ORA - 12519,
TNS: no appropriate service handler found
The Connection descriptor 2 by The client was:
IP address: 1521: instance name b

Online a lot are configured number of connections, but in fact, the number of connections did not exceed the maximum number of connections, solving, other solutions,

CodePudding user response:

Is there listening???

CodePudding user response:

Monitor service configuration file, hair;

CodePudding user response:

Monitor file is not configured to monitor which service,

LSNRCTL status

Or
In can't access service
Up sqlplus/nolog
Conn/as sysdba
The alter system register;