ADF Faces binding mystery…

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 [...]

ORA-06553: PLS-801: internal error [56319] After duplicate database from 64bits to 32bits and vice-versa

sql>connect / as sysdba sql>shutdown immediate; sql>startup migrate; sql> @$ORACLE_HOME/rdbms/admin/utlirp.sql sql>shutdown immediate; sql> startup sql> sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql sql> connect system/password Happy times…

Error dropping undo tablespace

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 [...]

How to Change Maxdatafiles, Maxlogfiles after Creating Database

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 Oracle Problem with Control File

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 [...]