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


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


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

terça-feira, 21 de dezembro de 2010

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


segunda-feira, 20 de dezembro de 2010

Moving to Oracle RAC One Node


domingo, 12 de dezembro de 2010

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

ID 558596.1

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.

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.

sábado, 11 de dezembro de 2010

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

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.

sexta-feira, 10 de dezembro de 2010

NI cryptographic checksum mismatch error: 12599.

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.

TNS for Linux: Version - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version - Production
TCP/IP NT Protocol Adapter for Linux: Version - 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


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

quinta-feira, 9 de dezembro de 2010

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

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

Change rman config:


Virtual private IP runs on top of the private interface

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


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

quinta-feira, 2 de dezembro de 2010

11GR2 Grid Install fail with NTP 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


vi /etc/sysconfig/ntpd

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

Move controlfile to ASM


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

After, change database parameter file.

DBCA fail on Grid 11Gr2

"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 with 11GR2 Grid

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