[Problem] Cannot Start OracleOraHome92Agent

As we wanna start OracleOraHome92Agent service, it always cannot be initialized normally.

Root Cause

It's service internal error or windows internal


delete the *.q files which locate at %oracle_home%\network\agent


SP2-0678: 資料欄或屬性類型無法經由 SQL*Plus 顯示

As I use sqlplus to do query, it showed the error message as belows:
SP2-0678: 資料欄或屬性類型無法經由 SQL*Plus 顯示
The sql statement is select * from projec2;

Owing to the column in this table include BLOB data, sqlplus cannot show the BLOB data so it will return this kind of error message.