quinta-feira, 1 de novembro de 2012

quinta-feira, 25 de outubro de 2012

New Version Of XPLAN_ASH Utility

http://oracle-randolf.blogspot.com/2012/10/new-version-of-xplanash-utility.html

terça-feira, 16 de outubro de 2012

Oracle Application Express 4.2 released

Oracle Application Express 4.2 was officially released.

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

terça-feira, 25 de setembro de 2012

Database Control To Be Desupported in DB Releases after 11.2

MOS ID: 1484775.1


quarta-feira, 12 de setembro de 2012

quarta-feira, 5 de setembro de 2012

ORA-01502: index 'BIMINFIN.PK_FAT_0_ORCAMENTO' or partition of such index is in unusable state

ORA-01502: index 'BIMINFIN.PK_FAT_0_ORCAMENTO' or partition of such index is in unusable state AFTER TRUNCATE PARTITIONED TABLE:

add: UPDATE GLOBAL INDEXES

Ex: ALTER TABLE my_table TRUNCATE PARTITION partition UPDATE GLOBAL INDEXES;





oracle-rdbms-server-11gR2-preinstall.x86_64


Oracle is pleased to announce the general availability of the Oracle RDBMS Server 11gR2 Pre-Install RPM for Oracle Linux 6 x86_64 (64 Bit) architecture.

This package replaces the previous Oracle Validated RPM

https://oss.oracle.com/pipermail/el-errata/2012-March/002727.html

quinta-feira, 30 de agosto de 2012

How to modify Limit Size of an Email Message Sent from Oracle Beehive



beectl > list_properties --component _EmailService:SMTPProperties

Properties for OutboundVMS

beectl > list_properties --component 772066ac-aa17-48f8-8a9c-6761bad59ffd

beectl > modify_property --component ff3a517b-bfd7-4305-b59a-d648bf0c8fb8 --name UseDefaultMaxSz --value false

beectl > modify_property --component ff3a517b-bfd7-4305-b59a-d648bf0c8fb8 --name MaxSzAbortTx --value 20971520

beectl > activate_configuration

sexta-feira, 24 de agosto de 2012

12c Cloud Control: How to Modify SYSMAN Password

cd /u01/app/oracle/product/Middleware/oms/bin
 ./emctl stop oms
 ./emctl config oms -change_repos_pwd

Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
Enter Repository User's Current Password :
Enter Repository User's New Password :
Changing passwords in backend ... Passwords changed in backend successfully. Updating repository password in Credential Store... Successfully updated Repository password in Credential Store. Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'. Successfully changed repository password. 

./emctl stop oms -all
./emctl start oms

UTL_SMTP - multiple recipients


Emails with multiple recipients, simply call the RCPT procedure once for each separate email address. 

http://www.oracle-base.com/articles/misc/email-from-oracle-plsql.php

terça-feira, 14 de agosto de 2012

SEVERE:Number of new nodes being added are not equal to number of new virtual nodes. Silent install cannot continue.

If you are using Grid Naming Service (GNS) and got this error, try to use sintax for not GNS:

"CLUSTER_NEW_VIRTUAL_HOSTNAMES={oralab4-vip}" 

details: http://martincarstenbach.wordpress.com/2009/10/12/build-your-own-rac-system-part-iv-extending-grid-infrastructure/

quarta-feira, 25 de julho de 2012

ORACLE 12c: HOW TO CREATE A TABLE WITH A PRIMARY KEY USING AN IDENTITY CLAUSE

ID 1472346.1 create table teste (PK number generated always as identity (start with 99) PRIMARY KEY, COLt VARCHAR2(20)); insert into teste (colt) values ('10');

segunda-feira, 2 de julho de 2012

Changing system date in Paravirtualized Oracle VM

echo 1 > /proc/sys/xen/independent_wallclock or to make persist xen.independent_wallclock=1
date -s "May 21 09:00:00"

quarta-feira, 23 de maio de 2012

ORA-28368: cannot auto-create wallet

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/wallet
[oracle@ocm wallet]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 23 14:15:34 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set encryption key identified by "welcome1";
 System altered.
SQL> exit

quinta-feira, 10 de maio de 2012

12c Management Agent Silent Installation

http://gavinsoorma.com/2012/05/12c-management-agent-silent-installation/

quarta-feira, 9 de maio de 2012

Error - Please set the credentials for the target racprod-cluster:cluster

emcli create_credential_set -set_name=CredentialOraoem -target_type=cluster -auth_target_type=cluster -supported_cred_types=HostCreds -monitoring -description='Credential Oraoem Cluster'

emcli set_monitoring_credential -target_name=racprod-cluster -target_type=cluster -set_name=CredentialOraoem -cred_type=HostCreds -auth_target_type=host -attributes='HostUserName:oraoem;HostPassword:password'

segunda-feira, 7 de maio de 2012

ASM instance not registered on LISTENER

sqlplus / as sysasm
show parameter local_listener
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.247.135)(PORT=1521))))"

 It's wrong ip address
Change: alter system set local_listener="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.247.130)(PORT=1521))))";

alter system register;

EM12c - Deinstalling Oracle Management Agent

http://docs.oracle.com/cd/E24628_01/install.121/e24089/deinstall_agent.htm#CBBCEJHG

sexta-feira, 4 de maio de 2012

EM12C - create_credential_set

./emcli login -username=sysman emcli create_credential_set -set_name=CredentialOraoem -target_type=host -auth_target_type=host -supported_cred_types=HostCreds -monitoring -description='Credential Oraoem' 

emcli set_monitoring_credential -target_name=target1 -target_type=host -set_name=CredentialOraoem -cred_type=HostCreds -auth_target_type=host -attributes='HostUserName:oraoem;HostPassword:password%'

Oracle Enterprise Manager 12c - Create and Use Metric Extensions

http://www.oracle.com/webfolder/technetwork/tutorials/obe/em/em12c/metric_extensions/Metric_Extensions.html

quinta-feira, 3 de maio de 2012

Release Schedule of Current Enterprise Manager Releases and Patch Sets

Document ID: 793512.1

Move the EM12c repository database

http://martincarstenbach.wordpress.com/2011/10/17/move-the-em12c-repository-database/

How to Download New Agent Software for Oracle Cloud Control 12c

http://www.gokhanatil.com/2012/03/how-to-download-new-agent-software-for-oracle-cloud-control-12c.html

Installing Oracle Management Agent Using RPM File

http://docs.oracle.com/cd/E24628_01/install.121/e24089/install_agent_usng_rpm.htm http://martincarstenbach.wordpress.com/2011/11/22/installing-oem-12c-agents-in-rpm-format/

EM12c:Automated discovery of Targets

http://askdba.org/weblog/2012/02/em12c-automated-discovery-of-targets/

quarta-feira, 21 de março de 2012

Failed to write the checkpoint:'' with status:FAIL.Error code is 32512

Improper Oracle Grid Infrastructure configuration found on this host
Deconfigure the existing cluster configuration before starting
to configure a new Grid Infrastructure
run '/u01/app/11.2.0.3/grid/crs/install/roothas.pl -deconfig'
to configure existing failed configuration and then rerun root.sh
/u01/app/11.2.0.3/grid/perl/bin/perl -I/u01/app/11.2.0.3/grid/perl/lib -I/u01/app/11.2.0.3/grid/crs/install /u01/app/11.2.0.3/grid/crs/install/roothas.pl execution failed

[root@ dev]# /u01/app/11.2.0.3/grid/crs/install/roothas.pl -deconfig
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params
Oracle Restart stack is not active on this node
Restart the SIHA stack (use /u01/app/11.2.0.3/grid/bin/crsctl start has) and retry
Failed to write the checkpoint:'' with status:FAIL.Error code is 32512
Failed to verify HA resources



Solution:
$GRID_HOME/crs/install/roothas.pl -deinstall -force

Re-run root.sh

sexta-feira, 16 de março de 2012

Determining Database DBID - Database not open

[oracle@orcl ~]$ strings /u02/oradata/orcl/sysaux01.dbf | grep DB_ID
DB_ID 941873125

or

[oracle@orcl ~]$ strings /bkp/orcl/backupset/df_ORCL_11_1_787935734.dbf | grep MAXVALUE
941982635, MAXVALUE,

UDEV rules for device persistency and permissions/ownerships in OEL6/REDHAT 6 for ASM

http://gjilevski.wordpress.com/2011/05/10/udev-rules-for-device-persistency-and-permissionsownerships-in-oel6redhat-6-for-asm/