Posts

Showing posts from February, 2012

All about ORA-600 lookup tool

Image
ORA-600/ORA-7445 are generic internal error numbers for Oracle program exceptions.
Sometimes these errors are unique for your specific problem and cannot be found via search engines.
Using "ORA-600 lookup tool" may point your specific problem, faster and accurate.
The tool can be found in ORA-600 lookup tool - Metalink Document ID 153788.1

The flowing video will guide you the usage of the LookUp Tool (11:12) - Metalink Document ID 1082674.1

List of installed Database Patches

Image
Looking for installed patches on the database I have always used
opatch lsinventory (since 9.2 and up)
From CPUJan2006 onwards you can just query
select * from registry$history; See Metalink Note:352783.1 for more information.

oracle 11.2 on ubuntu

installing or upgrading on Ubuntu is not supported but can be done
thanks to other bloggers it is well documented here

https://lostinmac.com/2012/01/29/installtion-doracle-11gr2-sur-ubunutu-11-10/

thanks

Changing database options

before oracle 11.2 we should have do this steps:
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink allfrom now this is simpler and shorter
cd %ORACLE_HOME%/bin
chopt disable dvAll options are written in the usage syntax:
usage:

chopt [enable|disable] {option}

options:
dm = Oracle Data Mining RDBMS Files
dv = Oracle Database Vault option
lbac = Oracle Label Security
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing

ADRCI & Alert file

Image
ADRCI & alert file

In Oracle version 11, no need to look for the location of alert log file, just use:
adrci exec="set home orcl ;show alert -tail -f" detailed practical usage can be found here