Problém 54:
Nemohu se připojit do databáze. V mém případě do standby databáze. Při každém pokusu o připojení přes sqlplus dostávám tuhle chybovou hlášku:
ORA-12516: TNS:listener could not find available handler with matching protocol stack
oracle@server:~> lsnrctl services
LSNRCTL for Linux: Version 10.2.0.3.0 – Production on 19-JUL-2011 09:40:06
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521)))
Services Summary…
…
Service „standby“ has 2 instance(s).
Instance „standby“, status UNKNOWN, has 1 handler(s) for this service…
Handler(s):
„DEDICATED“ established:1051 refused:560
LOCAL SERVER
Instance „standby“, status READY, has 1 handler(s) for this service…
Handler(s):
„DEDICATED“ established:884 refused:0 state:ready
LOCAL SERVER
…
The command completed successfully
SQL> show parameter processes
NAME TYPE VALUE
———————————— ———– ——————————
…
processes integer 40
SQL> select count(*) from v$session;
COUNT(*)
———-
38
Řešení:
Zvětšit maximální hodnotu pro parameter processes.
SQL> alter system set processes=100 scope=spfile;
System altered.
SQL> select OPEN_MODE from v$database;
OPEN_MODE
———-
MOUNTED
SQL> select DATABASE_ROLE from v$database;
DATABASE_ROLE
—————-
PHYSICAL STANDBY
SQL> show parameter processes
NAME TYPE VALUE
———————————— ———– ——————————
…
processes integer 100
oracle@server:~> sqlplus sys@standby as sysdba
SQL*Plus: Release 10.2.0.3.0 – Production on Tue Jul 19 09:49:29 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL>