Thursday, September 13, 2012

ORA-04095 trigger already exists on another table, cannot replace it

›
When trying to compile a trigger you receive following error: ORA-04095 trigger "string" already exists on another table, canno...
Thursday, August 30, 2012

emagent_perl.trc: ERROR: Max Count Value not set properly in file

›
Errors in $ORACLE_HOME/host/sysman/log/emagent_perl.trc: maxRowCount.pl: Tue Aug 21 14:34:29 2012: ERROR:  Max Count Value not set prope...
2 comments:

RAC 11.2 + ASM: Multiplex control files

›
To add new control file after RAC installation with ASM storage: 1. View current control_files parameter (as oracle owner) [oracle@ora...
Wednesday, August 29, 2012

RAC 11.2: Reconfigure SCAN Addresses

›
At install time there is the possibility to install RAC with one SCAN address specified in /etc/hosts file. If after installation, SCAN I...

Install on 11.2.0.3 RAC: Patch 13440962: DIFFERENT SUBNET FAILED TO CONNECT TO VIP AFTER RESTART VIP (11.2.0.3)

›
As oracle [oracle@oracle-node-2 ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; the...

RAC 11.2. change to ARCHIVELOG mode

›
[oracle@oracle-node-1 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28 13:54:49 2012 Copyright (c) 1982, ...

RUNCLUVFY: PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"

›
[oracle@oracle-node-1 grid]$ ./runcluvfy.sh stage -pre dbinst -n oracle-node-1,oracle-node-2 -r 11gR2 –verbose ….. Check for NTP daem...