Hi all I hope that someone will help me whit this problem
Here is the situation: I use Oracle 22.214.171.124.0 Database and it works fine except one little thing.When I try to create view in my schema Oracle return error:
ORA-03113: End of file on comunnication channel
I know this error is not because of Net8 or Listener problem, usualy this error returns when some other error ocurs. I searched the internet and I find something about "two-task shadow processes" as possible problem. Can anybody help me with this. Here is the sample of creation script for this view:
CREATE OR REPLACE VIEW P2 AS
SELECT SUM(P.COLUMN_1) COLUMN_2, V.COLUMN_3, P.COLUMN_4
FROM VIEW1 P, VIEW2 V
WHERE TO_CHAR(P.COLUMN) = V.COLUMN
GROUP BY V.COLUMN_3,P.COLUMN_4;
Originally posted by berxh3g
first check your alert.log and traces.
I have alredy checked my alert.log and I can't find anything suspicious in there, just usual messages about ARC processes.
But in my core-dump file I found something. I dont understand anything there and I dont know how to decode that file :-( . I will atach this so if anyone can help me.