Tổng hợp các lỗi về Datasource WebLogic

Error Message	Cause	Solution
Exceeded simmultaneous SESSION_PER_USER	DB đặt profile giới hạn số lượng session cho user	C1: Restart lại server logic để giải phóng connection tới DB C2: Kill session từ DB
State mục Monitoring --> Testin, các Server có state Uhelthy	Do kết nối với DB bị lỗi	Nếu 1 DS bị lỗi chuyển sang chế độ fail-over
Tra cứu chiều đến NULL Chọn JEBC --> Datasource (test_ds1) --> Monitoring --> Testing Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool test_ds1 is Suspended, cannot allocate resources to applications..		restart managed server
<BEA-000627> <Reached maximum capacity of pool "test_ds2", making "0" new resource instances instead of "1".> "test_ds1", out of which "1" are available and "0" are unavailable.>	Max capacity thấp	Tăng Max Capacity lên 300
Caused By: weblogic.common.ResourceException: weblogic.common.ResourceException: Cannot create Multi Data Source 'test_ds'. Connection Pools 'test_ds 1' and 'test_ds3' underneath this multi data source are not configured correctly, their XA and tx protocol related attributes need to be identical.	Ds test_ds1 và test_ds2 cấu hình chưa đúng	Check lại thông tin cấu hình của 2 ds này, chú ý phần tạo connection physical (khởi tạo, max, bước nhảy)
weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Got minus one from a read call
JDBC begin failed java.sql.SQLException: Connection has already been closed.	It seems that connection object which are requested are in no use	Enable Datasource --> TestconnectionOn Reserve and restart the server
<BEA-001129> <Received exception while creating connection for pool "test_ds2": ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit")	Số lượng kết nối TEST vượt quá 200/1 node	1. Kiểm tra trên Gold để xác định node mà user vượt quá ngưỡng select inst_id,count(*) from gv$session where username like 'TEST%' group by inst_id order by count(*) desc; 2. Kill mọi session đã active trên node quá tải SELECT /*username*/  'kill -9 ' || SPID A ,a.INST_ID,A.SID,A.SQL_ID, a.USERNAME, a.STATUS,A.SCHEMANAME,a.OSUSER,A.MACHINE,A.PROGRAM,A.TYPE,A.LOGON_TIME,BACKGROUND FROM gv$session a, gv$process b  WHERE b.ADDR = a.paddr AND a.inst_id=b.inst_id   AND B.inst_id = 2 and a.status='INACTIVE' AND A.USERNAME LIKE '%TEST%' Copy và past vào console SSH của Gold để kill -9 <pid>
####<Feb 28, 2013 12:28:17 PM ICT> <Info> <JDBC> <wls2> <Server1_1090_HN2> <[ACTIVE] ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1362029297616> <BEA-001156> <Stack trace associated with message 001129 follows: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress	Instance bị down	Check lại DB
####<Mar 29, 2015 1:14:13 AM ICT> <Info> <JDBC> <wls2> <Server1_1090_HN1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning) '> <<WLS Kernel>> <> <> <1427566453410> <BEA-001156> <Stack trace associated with message 001129 follows: java.sql.SQLException: Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocking new connections	Listener không bật	Check lại listener
###<Mar 26, 2015 10:45:29 AM ICT> <Error> <JDBC> <wls2> <Server1_Test2> <[ACTIVE] ExecuteThread: '229' for queue: 'weblogic.kernel.Default (self-tun ing)'> <<anonymous>> <> <> <1427341529865> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "call_ds1" failed with exception: "java.sql.SQLExcept ion: OALL8 is in an inconsistent state".> '	Không tạo kết nối được với DB	Check lại DB
####<Apr 3, 2015 5:04:12 PM ICT> <Warning> <JDBC> <wls1> <Server2_1090_HN4> <[ACTIVE] ExecuteThread: '58' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1428055452353> <BEA-001129> <Received exception while creating connection for pool "test_ds": Got minus one from a read call> ####<Apr 3, 2015 5:04:12 PM ICT> <Info> <JDBC> <wls1> <Server2_1090_HN4> <[ACTIVE] ExecuteThread: '58' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1428055452365> <BEA-001156> <Stack trace associated with message 001129 follows: java.sql.SQLException: Got minus one from a read call	Managed server treo, nhiều kết nối đến nhưng ko trả lời (> 1p)
####<Jul 25, 2017 5:46:07 PM GMT+07:00> <Error> <JDBC> <vmapp03> <Server1_216> <[ACTIVE] ExecuteThread: '22' for queue: 'weblogic.kernel.Default (self-tuni ng)'> <<WLS Kernel>> <> <> <1500979567118> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "test_ds5" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".> --> Ko login được sau khi kill

@ Trần Văn Bình - Founder of Oracle DBA AZ
 #học oracle #oracle database #khóa học oracle online #khóa học oca #học oca ở đâu #oca là gì #oca oracle #BossData #OraAz #OracleDBAAz #OracleTutorial #Quản_trị_cơ_sở_dữ_liệu_Oracle #OracleDBA #OracleDatabaseAdministration