TNS-12519與processes參數設置

　　今天遇到這樣一個小問題客戶程序連接數據庫遇到了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