Archive for the ‘HowTo’ Category

Source: https://sites.google.com/site/joeztechland/how-to–in-adf ADF BC (Model) ADF Faces (UI) Bindings: – DataProvider code example: here VOs: Single, Shared VO Instance or Multiple? Page Behavior: – Prevent initial page render: adfFacesInitialContext Render Issues: here and here Passing Data as Parameters (how to get data from point A to point B) 1. Data Bindings – Value is set [...]

Problem Description Drop undo tablespace fails with error Ora-01548 . SQL> drop Tablespace UNDOTBS1; drop Tablespace UNDOTBS1 * ERROR at line 1: ORA-01548: active rollback segment ‘_SYSSMU1$’ found, terminate dropping tablespace Cause of The Problem An attempt was made to drop a tablespace that contains active rollback segments. Solution of The Problem In order to [...]

1. Dump a trace of the controlfile. Use SQL*Plus (or Server Manager) and enter: SQL> alter database backup controlfile to trace ; 2. Modify the created trace file (located in the user_dump_dest directory): a) remove from the first line to the line before “STARTUP NOMOUNT” b) remove line “ALTER DATABASE OPEN” to the end of [...]

ORA-00202: controlfile: ‘C:\ORACLE\ORADATA\ORACLE91\CONTROL02.CTL’ ORA-27091: skgfqio: unable to queue I/O ORA-27070: skgfdisp: async read/write failed OSD-04006: ReadFile() failure, unable to read from file O/S-Error: (OS 23) Data error (cyclic redundancy check). i find this problem on one of my server database. this problem will make oracle fail to mount and open. if you try to connect [...]

When exporting data from Oracle DB 9i 9.2.0.5, encountered by the error: . exporting pre-schema procedural objects and actions . exporting foreign function library names for user QLNS . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user QLNS EXP-00008: ORACLE error 942 encountered ORA-00942: table or view [...]