Error Reading Redir Nse
friend Maximum session exceeded [message #406249] Wed, 03 June 2009 01:01 vinniora Messages: 56Registered: October 2008 Location: Mumbai Member Hi all,From past three days one of the user is getting an error 00018 maximum session exceeded,but querying 'select * from V$resource_limit;' result as shown below resource_name current_util max_utilin initial_allocation limit processes 67 85 500 500 session 263 300 555 555 The profile alloted to the user is default with unlimited session.Please provide the solution.Thnx in advance. Report message to a moderator Re: Maximum session exceeded [message #406277 is a reply to message #406249] Wed, 03 June 2009 02:03 ThomasG Messages: 3186Registered: April 2005 Location: Heilbronn, Germany Senior Member $ oerr ora 00018 00018, 00000, "maximum number of sessions exceeded" // *Cause: All session state objects are in use. // *Action: Increase the value of the SESSIONS initialization parameter. Report message to a moderator Re: Maximum session exceeded [message #406278 is a reply to message #406277] Wed, 03 June 2009 02:10 vinniora Messages: 56Registered: October 2008 Location: Mumbai Member but v$querying resource_limit it shows following result resource_name current_util max_utilin initial_allocation limit processes 67 85 500 500 session 263 300 555 555 here current_utilization is 263 but i have alloted 555 then why so it is happening like that. Report message to a moderator Re: Maximum session exceeded [message #406280 is a reply to message #406278] Wed, 03 June 2009 02:12 ThomasG Messages: 3186Registered: April 2005 Location: Heilbronn, Germany Senior Member what does "show parameter sessions" show? [Updated on: Wed, 03 June 2009 02:14]Report message to a moderator Re: Maximum session exceeded [message #406282 is a reply to message #406280] Wed, 03 June 2009 02:22 vinniora Messages: 56Registered: October 2008 Location: Mumbai Member show parameter session java_max_sessionspace_size integer 0 java_soft_sessionspace_limit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 logmnr_max_persistent_sessions integer 1 session_cached_cursors integer 0 session_m
ID 561429.1)Applies to: Oracle Net Services - Version: 11.1.0.6.0 to 11.2.0.1 - Release: 11.1 to 11.2 Information in this document applies to any platform. Effects versions 11.1.0.6 to 11.2.0.1 SymptomsConnections to 11gTNS Listener are slowand cantake anywhere from 10 seconds to http://www.orafaq.com/forum/t/145970/ 2 minutes. On connection handshake, Oracle Net client trace shows the delay between 1st Connect Packet and Resend packet on nttrd function. 09:59:57.552261:nttrd:entry
10:00:37.578836:nttrd:socket11hadbytesread=8 10:00:37.578894:nttrd:exit
10:00:37.578918:nsprecv:8bytesfromtransport
10:00:37.578943:nsprecv:tlen=8,plen=8,type=11
10:00:37.578966:nsprecv:packetdump
10:00:37.578987:nsprecv:000800000B000000|........|Oracle Net Listener trace http://oradbastuff.blogspot.com/2011/06/connections-to-11g-tns-listener-are.html shows the delay around the fork process. 09:59:57.575893:ntpwr:exit
09:59:57.575911:ntprd:entry
10:00:37.578078:ntprd:exit
10:00:37.578181:ntprd:entry
10:00:37.578482:ntprd:exit
10:00:37.578501:nsbequeath:NSE=12586
10:00:37.578520:nsbequeath:errorreadingREDIR/NSEmsg Please note NSE=12586 is just a complete code and not an error. Significant delay may also be reported in the listener trace at theGetaddrinfo() function: 2009-12-09 13:52:19.835738 : snlinGetAddrInfo:entry
2009-12-09 13:52:29.836309 : snlinGetAddrInfo:getaddrinfo() failed with error -2 Notice in this example a 10 second delay in the getaddrinfo() function. Strace / Truss of the TNS listener process on connection: strace -frT -o
09:59:57.575610 : sntpcall:exit
09:59:57.575626 : ntpctl:exit
09:59:57.575664 : nttaddr2bnd:entry
09:59:57.575683 : snlinGetNameInfo
Windows XP 64bit machine, running Oracle 10g R2. The oracle database gives ORA-01033: Oracle initialization or shutdown in progress when http://forundex.ru/sql/ORA-12170-cherez-db-link-207322 connection is attempted. The listener appears to be up in the dos screens lsnrctl call with QUOTE LSNRCTL> statusConnecting to error reading (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jupiter)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - ProductionStart Date 14-MAY-2009 13:18:02Uptime 0 days 0 hr. 34 min. 32 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File j:\oracle\product\10.2.0\db_1\network\admin\listener.oraListener Log File j:\oracle\product\10.2.0\db_1\network\log\listener.logListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jupiter)(PORT=1521)))Services Summary...Service error reading redir "River_XPT" has 1 instance(s). Instance "river", status READY, has 1 handler(s) for this service...Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "river" has 1 instance(s). Instance "river", status READY, has 1 handler(s) for this service...The command completed successfullyLSNRCTL> Cannot connect with / :QUOTE J:\Documents and Settings\JupiterPower>sqlplusSQL*Plus: Release 10.1.0.4.2 - Production on Thu May 14 13:35:33 2009Copyright © 1982, 2005, Oracle. All rights reserved.Enter user-name: / as sysdbaERROR:ORA-12560: TNS:protocol adapter error Cannot connect with sqlplus normal user:QUOTE J:\Documents and Settings\JupiterPower>sqlplus /nologSQL*Plus: Release 10.1.0.4.2 - Production on Thu May 14 13:48:50 2009Copyright © 1982, 2005, Oracle. All rights reserved.SQL> conn myUser/myUser@riverERROR:ORA-01033: ORACLE initialization or shutdown in progress Suggestion to use SQL*Net to trace any de
с такой проблемой...Пытаюсь через Developer выполнить любой запрос через Db link, отбивается с ошибкой ORA-12170.При этой используя эти же параметры(tns и логин\пароль) в базу из которой хочу инфу захожу спокойно(!), через тот же Developer. Tns ping естественно проходит.TNS выглядит вот такBASE2 = (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=1.1.1.1)(PORT=1521)) (CONNECT_DATA=(SID=base2sid)) )В настройках db link пробовал так(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=1.1.1.1)(Port=1521)))(CONNECT_DATA=(SID=base2sid)))и такBASE2 и вот так 1.1.1.1:1521/base2sidВариант (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=1.1.1.1)(Port=1521)))(CONNECT_DATA=(SID=base2sid)))но с другой базой - работает...Заранее благодарен. Ответ: TNS alias должен быть на сервере, на котором делаешь db linkКлиент коннектится к серверу. Сервер через db link коннектится к другому серверу.Если делаешь db link через (DESCRIPTION=....) не факт что у тебя твой сервер может пробиться к удалённому серверу. Читать все 2 сообщений Вопрос: ORA-12170: TNS:Connect timeout occurred, помогите, пожалуйста. В последнее время участились отказы подключения, если раньше были 1 к 10, то сейчас 50/50 примерно. Конфигурация сервера и клиента не менялось точно уже очень давно, даже обновления Windows отключены.