2006/05/23

[Problem] Cannot Start OracleOraHome92Agent

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


Root Cause

It's service internal error or windows internal


Solution

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

2006/05/05

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.