Thread: ORA-01552: cannot use system rollback segment for non-system tablespace

The undo_ xxx is set to manual in my pfile and init-ora. So I changed it to AUTO.

ORA-30012: undo tablespace ‘UNDOTBS01′ does not exist or of wrong type

I modified the undo_tablespace in init-ora file and spfile by changing undotbs01 to undotbs02 and it worked.

liboraInstaller.so (Cannot open or remove a file containing a running program.)

 Erroin writing to file
'................/oracle/product/10.2.0/db_1/oui/lib/aix/liboraInstaller.so'.
[................/oracle/product/10.2.0/db_1/oui/lib/aix/liboraInstaller.so (Cannot open or remove a file containing a running program.)]

You will see four options.

click Help
click Retry
click Ignore
click Cancel to stop this installation

The solution is that:

Go to that directory and rename the old file, for example: mv liboraInstaller.so liboraInstaller.so.bak

OUI-18001: The operating system 'AIX Version 6100.05' is not supported.

I am installing ORACLE 10.2.0.2 today on an AIX 6.1 machine. This error poped up when the software is checking the prerequisites of the system. Since AIX 6.1 comes after ORACLE 10.2.0.2, so just ignore the error and keep installing.

Can't shutdown oracle database

Last time, I accidentally deleted the control file and can't shutdown the database by using "shutdown immediate". I was so panic....The solution is that using "shutdown abort"...

TOAD windows 7 (ORA-06413 : Connection Not Open)

Problem:
When using TOAD on Windows 7, it pops up an error:

ORA-06413 : Connection Not Open

Solution:

Copy Quest Software from C:\Program(x86) to C:\Program

alert log

 Check Alert Log for the detailed error messages under ORACLE_HOME/admin/db_name/bdump/alert.log

refer to http://www.adp-gmbh.ch/ora/concepts/alert_log.html