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 the file
c) change value [...]

Continue reading »

Multiple ORACLE_HOME on same machine

We can install different oracle versions on same machine like Oracle 8i,9i or 10g. Also, we can create multiple database/instance on a single machine but remember to name them differently, for  example: db1,db2,db3 and so on. When name them like that, we avoid conflicting installing them on our single machine.
Suppose we planned to install oracle [...]

Continue reading »

Installing the Oracle Client on Ubuntu

1. First step is to download the Oracle Database 10g Client Release 2 (10.2.0.1.0) for Linux x86 zip file from www.oracle.com and extract it somewhere.
2. Unzip 10201_client_linux32.zip to a folder
3. Open terminal and run
./runInstaller -ignoreSysPrereqs
4. Following instructions on OUI to install your software. Note that the error appear when you go about 88% installing [...]

Continue reading »

“CLEAR” THE TEMP DEFAULT TABLESPACE

Wanna “clear” the temp default tablespace, huh? Answer is NO WAY!
Luckily you can create a new TEMPORARY TABLESPACE and set it as default.
Then  Drop the old one…
increase size for the new TEMP TABLESPACE.
And there you go…
Minh-Tran

Continue reading »

JBO-35007: Row currency has changed error fixes

When developing JSF pages using Oracle ADF Faces 10.1.3.3, I encountered the error that is reported at the top of the page as: JBO-35007 indicated that the row currency has changed since last visit or something. This was so annoy that it is repeatedly occurred everytimes I hit the back button. Sometimes it disappear when [...]

Continue reading »