熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

TNS-12519與processes參數設置

2013-11-13 15:57:51  來源: Oracle 

  今天遇到這樣一個小問題客戶程序連接數據庫遇到了TNS錯誤

   TNS: TNS:no appropriate service handler found

  在監聽器日志中也能看到這個錯誤信息

  這個錯誤以前還真是沒有遇到過Oracle文檔提示

   ORA: TNS:no appropriate service handler found
Cause: The listener could not find any available service handlers that are appropriate for the client connection
Action: Run lsnrctl services to ensure that the instance(s) have registered with the listener and are accepting connections

  檢查了數據庫的監聽等一切正常唯一的問題在於processes進程數量設置的太小僅有將這個參數修改為重啟數據庫一切恢復正常

   SQL> alter system set processes= scope=spfile;

  System altered

  此外在數據庫的日志中還能夠看到如下提示

   Tue Oct ::
starting up shared server(s)
Oracle Data Guard is not available in this edition of Oracle

  發現Oracle的告警日志信息提示越來越全面詳盡


From:http://tw.wingwit.com/Article/program/Oracle/201311/17587.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.