Dnes je: 21. května 2012
Nabídka služeb
Podpora
Ostatní
Autor knihy
| ORA-12516: TNS:listener could not find available handler with matching protocol stack |
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>
|
Partnerské internetové stránky:
www.oracledba.cz www.asktom.cz www.tomas-solar.cz