SOLVED

ORA-12519: TNS :no appropriate service handler found .

Asked by OracleDba14 viewsoracle
1
2
3
4
5
ORA-12519: TNS :no appropriate service handler found .

ERROR :

ORA-12519: TNS :no appropriate service handler found .
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
SQL> show parameter processes

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes                       integer     1

db_writer_processes                   integer     1

gcs_server_processes                  integer     0

global_txn_processes                  integer     1

job_queue_processes                   integer     40

log_archive_max_processes             integer     4

processes                             integer     300

SQL> alter system set processes=500 scope=spfile;

System altered.

Restart database after this operation.
OracleDba

Post Your Solution