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 »

Re-install oracle-xe on Ubuntu

Quite confuse when you want to re-install oracle-xe on Ubuntu. Struggling for several hours googling, I found this tip:
1. Run “sudo dpkg -P oracle-xe-universal” to get Ubuntu remove all the files as well as configuration files.
2. Delete folder: “/usr/lib/oracle/xe”
3. Restart the machine
4. Install the oracle-xe package.
5. Run “sudo /etc/init.d/oracle-xe configure” to have oracle-xe be setup
6. [...]

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 »