Oracle error messages
Top Stories
-
Answer
09 Aug 2007
Query on dblink returning ORA-12545 error
I have a dblink between Oracle 9i and Oracle 10g. When I execute this query sometimes I get the result, but sometimes I get the error "ORA-12545." Continue Reading
-
Answer
22 May 2007
How to increase SGA_MAX_SIZE in Oracle
How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup. Continue Reading
-
Answer
02 Apr 2007
ORA-04082: NEW or OLD references not allowed in table level triggers
I am calling a stored procedure from a trigger. It shows the error: "ORA-04082: NEW or OLD references not allowed in table level triggers." Continue Reading
-
Answer
22 Feb 2007
ORA-01702: a view is not appropriate here
I'm creating an index on a view using Oracle 9.2.0. I get the error ORA-01702 (a view is not appropriate here). Continue Reading
-
Answer
18 Jan 2007
Invalid stored procedures
When running an application that is connected to an Oracle server/database and trying to add rows or make a call to the DB, I am getting various errors that the stored procedures are invalid. Continue Reading
-
Answer
11 Jan 2007
Encountered the symbol "ELSE" when expecting one of the following
I am a beginner to Oracle. I am getting this error: "ORA-06550: line 21, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following:" Continue Reading
-
News
29 Nov 2006
Oracle tutorial library: SearchOracle.com's learning guides
One of the best resources SearchOracle.com offers is our collection of learning guides. They're a perfect education tool for the beginner who's just getting started with Oracle or the seasoned professional looking to attain expert status. We've gathered all our Oracle tutorials here in one invaluable list that you can return to again and again whenever you need a helping hand. Continue Reading
-
Answer
04 Oct 2006
Non-zero values for SHARED_POOL_SIZE and JAVA_POOL_SIZE
I am getting an ORA-04031 error. I have a two-node 10g RAC cluster. If I gave both SHARED_POOL_SIZE and JAVA_POOL_SIZE values (thus overriding the defaults) how would this affect the running of the CLUSTER? Does a CLUSTER require these values to be 0? Continue Reading
-
News
22 Aug 2006
The Oracle Security Challenge
Let's find out what how much you really know about Oracle security. Continue Reading
-
News
20 Jun 2006
Survey: DBAs not planning for downtime
Companies need to do more to reduce the amount of database downtime resulting from both planned and unplanned events, a new IOUG survey finds. Continue Reading