Alex Zaballa - DBA Oracle - ex-Oracle ACE Director, OCM, OCA, OCP, OCE, OCS

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

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

05:19 No comments

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

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

07:34 No comments

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.

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

05:55 No comments

Change the ping frequency in opmn.xml

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

07:38 No comments

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 :(

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

15:16 No comments

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;

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...

14:19 No comments

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)

14:17 No comments

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))

Ora-01008 - Target 11.2.0.2 - Rman error

11:17 No comments

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;

Get all hidden init parameters in 11G

11:42 No comments

create pfile='/tmp/init' from memory;

RG-10758 When Creating Text Index Using File Datastor

08:47 No comments

Cause

It is an expected error as the default behavior of the CTX system parameter FILE_ACCESS_ROLE has changed.

Solution

1. (Recommended) Create a new role, grant it to the owners of the impacted indexes, and set file_access_role to the new role.
- or -
2. Set file_access_role to 'public'

To change file_access_role, you must be connected as SYSDBA.

SQL> connect as sysdba
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')

11gR2 – empty tables skipped by export (deferred segment creation)

10:24 No comments

http://www.nativeread.com/2010/04/09/11gr2-empty-tables-skipped-by-export-deferred-segment-creation/

Moving to Oracle RAC One Node

12:41 No comments

http://www.databasejournal.com/features/oracle/article.php/10893_3906196_1/article.htm

On EL/RH 5 ORACLEASM LISTDISKS not Showing Devices After Reboot or Restart

13:23 No comments

ID 558596.1

Cause
The oracleasm scans /proc/partitions and expects devices to be available in /dev. If the device doesn't exist in /dev it will fail to open the device. RHEL/OEL5 does not create dm-xx devices in /dev by default.

Solution
Please comment out the following line in file /etc/udev/rules.d/50-udev.rules

#KERNEL=="dm-[0-9]*", ACTION=="add", OPTIONS+="ignore_device"

reboot and the problem should be gone.

11g Database Installation failed with “File not found .. WFMLRSVCApp.ear”

13:28 1 comment

If you are installing 11g database and hit error File not found… WFMLRSVCApp.ear, ensure that you have downloaded two disks (for database software) and both disks are unzipped in same folder.

NI cryptographic checksum mismatch error: 12599.

03:53 No comments

NI cryptographic checksum mismatch error: 12599 errors in the alert.logs of databases monitored by Oracle Enterprise Manager 11gR1 .

***********************************************************************

NI cryptographic checksum mismatch error: 12599.

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
Time: 10-DEC-2010 06:48:19
Tracing not turned on.
Tns error struct:
ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
ns secondary err code: 2526
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Solution:

Add SQLNET.ENCRYPTION_TYPES_SERVER= (3DES168)to the sqlnet.ora forthe repository database

RA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0

19:22 No comments

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/09/2010 22:12:09
ORA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0

Change rman config:

CONFIGURE COMPRESSION ALGORITHM 'HIGH';

Virtual private IP runs on top of the private interface

17:18 No comments

Highly Available IP / Redundant Private IP in Oracle Grid Infrastructure 11g Release 2 (11.2.0.2 or above)

http://oraxperts.com/wordpress/?p=142

11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip
[ID 1210883.1]

11GR2 Grid Install fail with NTP error

13:40 No comments

Error:

INFO: NTP daemon slewing option check failed on some nodes
INFO: Check failed on nodes:
INFO: racpre2,racpre1
INFO: PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"
INFO: Clock synchronization check using Network Time Protocol(NTP) failed
INFO: PRVF-9652 : Cluster Time Synchronization Services check failed

Solution:

vi /etc/sysconfig/ntpd

OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

Move controlfile to ASM

13:39 No comments

Ex:

restore controlfile to '+DG01' from '+fra01/sigfedb/controlfile/current.260.736637371';

After, change database parameter file.

DBCA 11.1.0.7 fail on Grid 11Gr2

13:37 No comments

"DBCA could not startup the ASM instance configured on this node. To processd with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"

Apply patch 8288940

Database 11.1.0.7 with 11GR2 Grid

13:32 No comments

Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1]

Oracle Validated rpm

14:17 No comments

Preparing a Linux box for Oracle Clusterware and RAC installation is made fast and simple with the help of the Oracle Validated Rpm. Downloading and installing the rpm that match you Linux Kernel, automatize the install of the numerous components required to setup OCW and RAC on Linux.

http://blogs.oracle.com/AlejandroVargas/Installing-the-Oracle-Validated-rpm-on-EL5.pdf

KUPW$WORKER.GET_TABLE_DATA_OBJECTS

13:13 No comments

ORA-39126: Erro fatal inesperado do processo de trabalho em KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: falha na seguinte instruc?o de SQL:
BEGIN "DMSYS"."DBMS_DM_MODEL_EXP".SCHEMA_CALLOUT(:1,0,1,'11.00.00.00.00'); END;
ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86
ORA-06512: na "SYS.DBMS_METADATA", linha 1245
ORA-04067: n?o executado, package body "DMSYS.DBMS_DM_MODEL_EXP" n?o existe
ORA-06508: PL/SQL: n?o foi possivel encontrar a unidade de programa que esta a ser chamada : "DMSYS.DBMS_DM_MODEL_EXP"

ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86
ORA-06512: na "SYS.KUPW$WORKER", linha 8353

Solution: DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS';

FMW Welcome Page Application (11.1.0.0.) Down

07:44 No comments

Bug Title: BROKEN 'FMW WELCOME PAGE APPLICATION' APPLICATION DISCOVERED OUT-OF-BOX

1. Apply patch 6880880 (OPatch utility release 11.1.0.8.3) for ORACLE_COMMON

2. Apply patch 9431704
- Stop OMS
$ cd $ORACLE_BASE/Middleware/oms11g/bin
$ ./emctl stop oms -all
- Unzip patch 9431704
$ cd /home/oracle
$ unzip p9431704_111120_Generic.zip
- Apply patch
$ cd /home/oracle/9431704
$ export $ORACLE_BASE/Middleware/oracle_common
$ $ORACLE_BASE/Middleware/oracle_common/OPatch/opatch apply

3. Restart the OMS
$ $ORACLE_BASE/Middleware/oms11g/bin/emctl start oms

Reset INTERNAL password in APEX

05:41 No comments

To change the password for the ADMIN account:

1. Change your working directory to $ORACLE_HOME/apex.
2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
$ sqlplus sys/SYS_password as sysdba
3. Using the following syntax, enter the new password:
> @apxxepwd password

ora-07445 on wwutl_cache_sys.process_background_inval

17:29 No comments

Ora-07445 on Job 31 ---> Portal after migrate database to 11G

begin wwutl_cache_sys.process_background_inval; end;

Try recompile utl_http and utl_tcp.

wwsrc_event_q_mgmt.propagate(true); - job broken

16:18 No comments

begin
wwsrc_event_q_mgmt.disable_propagation_job;
wwsrc_event_q_mgmt.stop_queue;
wwsrc_event_q_mgmt.drop_queue;
end;

The Upgrade Assistant failed in bringing up the database

12:17 3 comments

"The Upgrade Assistant failed in bringing up the database . Oracle Home
obtained from file /etc/oratab was used to connect to the database. Either the database is not
running from Oracle Home or the correct Initialization Parameter file (pfile)
was not found."

Try to remove files on:

/u01/app/oracle/cfgtoollogs/dbua