今天剛到公司,例行檢查各台server的狀況。當看到ap server時,發現有好多的session出錯,都是ora 12502的error
查看了DB上的listener 的狀態都為正常,tnsnames.ora也沒有人改( 還是做了checke),再listener.log的內容也有tns 12502的error ,
因為最近一直都正常,只有昨天另外一子公司的同事調整了一個MV ,查看了dba_jobs 真的有一個job broken了
重新resubmit一下后,一切正常!
相關信息:
oerr ora 12502
12502, 00000, "TNS:listener received no CONNECT_DATA from client"
// *Cause: No CONNECT_DATA was passed to the listener.
// *Action: Check that the service name resolved from TNSNAMES.ORA has
// the CONNECT_DATA component of the connect descriptor.
oerr tns 12502
12502, 00000, "TNS:listener received no CONNECT_DATA from client"
// *Cause: No CONNECT_DATA was passed to the listener.
// *Action: Check that the service name resolved from TNSNAMES.ORA has
// the CONNECT_DATA component of the connect descriptor.
發現兩個error的內容是一樣的呢,也就是可以看出有的tns error和ora error表達的意思是一樣的
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51660/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29987/viewspace-51660/