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

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

05:11 No comments

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

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

08:12 No comments

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

12c Cloud Control: How to Modify SYSMAN Password

06:51 No comments

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

05:02 No comments

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

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

04:43 No comments

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/

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

08:47 No comments

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

Changing system date in Paravirtualized Oracle VM

05:17 No comments

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

ORA-28368: cannot auto-create wallet

06:24 No comments

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

12c Management Agent Silent Installation

05:17 No comments

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

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

07:52 No comments

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'

ASM instance not registered on LISTENER

06:37 No comments

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

05:35 No comments

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

EM12C - create_credential_set

10:07 No comments

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

07:26 No comments

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

Release Schedule of Current Enterprise Manager Releases and Patch Sets

14:43 No comments

Document ID: 793512.1

Move the EM12c repository database

13:36 No comments

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

In Cloud Control 12c The Job Refresh From My Oracle Support fails with Error Ora-01882: Timezone Region Not Found When Setting My Oracle Support Preferred Credentials

13:21 No comments

Document ID: 1391819.1

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

12:43 No comments

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

12:15 No comments

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

12:14 No comments

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

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

06:39 1 comment

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

Determining Database DBID - Database not open

11:00 No comments

[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,