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

RG-10758 When Creating Text Index Using File Datastor

CauseIt is an expected error as the default behavior of the CTX system parameter FILE_ACCESS_ROLE has changed.Solution1. (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 sysdbaSQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'publi...

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

Moving to Oracle RAC One Node

12:41 No comments

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

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

13:23 No comments

ID 558596.1CauseThe 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. SolutionPlease 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 go...

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

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

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:09ORA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0Change rman config: CONFIGURE COMPRESSION ALGORITHM 'HIG...

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=14211gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883...

11GR2 Grid Install fail with NTP error

13:40 No comments

Error:INFO: NTP daemon slewing option check failed on some nodesINFO: Check failed on nodes:INFO: racpre2,racpre1INFO: 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) failedINFO: PRVF-9652 : Cluster Time Synchronization Services check failedSolution:vi /etc/sysconfig/ntpdOPTIONS="-x -u ntp:ntp -p /var/run/ntpd.p...