quinta-feira, 1 de dezembro de 2011

PRVF-5300: Failed to retrieve active version for CRS on this node

cd $GRID_HOME /bin

mv crsctl crsctl.orig

create a script “crsctl” with :

EXEC=/u01/app/oragrid/product/11.2.0.3.0/bin/crsctl.orig
case $1 in
query)
echo "Oracle High Availability Services release version on the local node is [11.2.0.2.0]"
;;
*)
$EXEC $*
;;
esac

quinta-feira, 22 de setembro de 2011

OPMN CRASHES IF THE WEBCACHE.PID FILE EXISTS WITH 0 BYTES AND WE START WEBCACHE

Bug 6447507

In Application Server 10.1.2, if the $ORACLE_HOME/webcache/webcache.pid
file exists but it has 0 bytes and you try to startup the WebCache component
the WebCache component is not started up and opmn processes die, leaving the
other opmn managed processes orphans. A manual kill of them needs to be
performed followed by an opmnctl startall to fix the problem. The problem may
happen if the filesystem where the ORACLE_HOME is hosted gets full.

Solution:
rm $ORACLE_HOME/webcache/*.pid
touch $ORACLE_HOME/webcache/webcache.pid

sábado, 2 de julho de 2011

RME-00020: Internal API error - ORA-01400: cannot insert NULL into ("REPOS_OWNER"."I$SDD_INS"."PAC_REF")

RME-00020: Internal API error - ORA-01400: cannot insert NULL into ("REPOS_OWNER"."I$SDD_INS"."PAC_REF")
RME-00011: Operation 'ins' on USER_OBJECT_INDEX_STORAGE has failed
RME-00222: Failed to dispatch operation to Repository


Run the Database Design Transformer without creating object implementations:

1) In the Database Design Transformer dialog box,
2) click button 'Settings',
3) in the 'Settings' dialog box,
4) select Database = '(none')
5) Click OK button
6) Click 'Run' button to launch the Database Design Transformer.

sexta-feira, 27 de maio de 2011

How to Stop Getting "Head /Index.Html HTTP/1.1" Messages Every 20 Seconds in Apache access_log

Change the ping frequency in opmn.xml

sábado, 2 de abril de 2011

Oracle Database XE (Express Edition) 11.2 beta is out!

http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html


- Express Edition is limited to a single instance on any server
- Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server
- Express Edition may only be used to support up to 11 GB of user data (not including Express Edition system data)
- Express Edition may use up to 1 GB RAM of available memory :(

sábado, 5 de março de 2011

ORA-00600 [16500] [kqdcru] Running purge dba_recyclebin

Errors in file /u01/app/oracle/diag/rdbms/aupecdbtest/aupecdbtest/trace/aupecdbtest_ora_27336.trc (incident=281):
ORA-00600: internal error code, arguments: [16500], [kqdcru], [D], [2], [110], [BIN$nFHAOchQTu3gQKjAB2RbGw==$0], [], [], [], [], [], []

Solution

SQL> ALTER SESSION SET NLS_SORT = BINARY;

sexta-feira, 18 de fevereiro de 2011

The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which App...

The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which Application Server Control is running


ORACLE_HOME/j2ee/oc4j_instance_name/config/system-jazn-data.xml

edit system-jazn-data.xml

find oc4jadmin

replace credentials>!welcome123

restart container

"Demo It To Oracle" (DITO)

CamStudio is a third party desktop recording software that can be used to "Demo It To Oracle" (DITO).

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocDsrc=KB&viewingMode=1143&bmDocType=REFERENCE&bmDocID=11.1&from=BOOKMARK&bmDocTitle=%22Demo%20It%20To%20Oracle%22%20(DITO)%20-%20CamStudio%20Help))

terça-feira, 1 de fevereiro de 2011

Ora-01008 - Target 11.2.0.2 - Rman error

It will be fixed in the 11.2.0.3 Patch Set Release.

Solution:

change cursor_sharing to exact or alter system flush shared_pool;