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

quarta-feira, 22 de dezembro de 2010

Get all hidden init parameters in 11G

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

RG-10758 When Creating Text Index Using File Datastor

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"