apt-get update gave me the following error message:W: GPG error: http://oss.oracle.com unstable Release: The following signatures were invalid: KEYEXPIRED 1315142507 KEYEXPIRED 1315142507 KEYEXPIRED 1315142507
W: You may want to run apt-get update to correct these problems
CALL DBMS_XDB.CFG_UPDATE(
UPDATEXML(
DBMS_XDB.CFG_GET(),
'/xdbconfig/descendant::http-port/text()',
'8888'
)
);"SYS as SYSDBA" in the database.ORA-03113: end-of-file on communication channel error. This happens only if the view is merged by the query optimizer into the query. Using the NO_MERGE hint on the view fixes the issue. I experienced this on Oracle 9iR2 9.2.0.1.0 on a Win2003 server. The same query ran perfectly on a HP-UX box with 9.2.0.6.0 (using the same code and data). This is definitely a bug that was fixed somewhere between 9.2.0.1.0 and 9.2.0.6.0.
Recent comments
1 day 13 hours ago
1 day 17 hours ago
3 days 1 hour ago
3 days 5 hours ago
3 days 9 hours ago
5 days 7 hours ago
1 week 7 hours ago
1 week 2 days ago
1 week 5 days ago
1 week 6 days ago