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

quarta-feira, 12 de setembro de 2012

Enterprise Manager Cloud Control 12c Release 2

http://www.gokhanatil.com/2012/09/enterprise-manager-cloud-control-12c-release-2.html

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

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,

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

07:55 No comments

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

PRVF-5300: Failed to retrieve active version for CRS on this node

14:25 No comments

cd $GRID_HOME /bin

mv crsctl crsctl.orig

create a script “crsctl” with :

EXEC=/u01/app/oragrid/product/11.2.0.3.0/bin/crsctl.orig
case $1 in
query)
echo "Oracle High Availability Services release version on the local node is [11.2.0.2.0]"
;;
*)
$EXEC $*
;;
esac

OPMN CRASHES IF THE WEBCACHE.PID FILE EXISTS WITH 0 BYTES AND WE START WEBCACHE

05:19 No comments

Bug 6447507

In Application Server 10.1.2, if the $ORACLE_HOME/webcache/webcache.pid
file exists but it has 0 bytes and you try to startup the WebCache component
the WebCache component is not started up and opmn processes die, leaving the
other opmn managed processes orphans. A manual kill of them needs to be
performed followed by an opmnctl startall to fix the problem. The problem may
happen if the filesystem where the ORACLE_HOME is hosted gets full.

Solution:
rm $ORACLE_HOME/webcache/*.pid
touch $ORACLE_HOME/webcache/webcache.pid

RME-00020: Internal API error - ORA-01400: cannot insert NULL into ("REPOS_OWNER"."I$SDD_INS"."PAC_REF")

07:34 No comments

RME-00020: Internal API error - ORA-01400: cannot insert NULL into ("REPOS_OWNER"."I$SDD_INS"."PAC_REF")
RME-00011: Operation 'ins' on USER_OBJECT_INDEX_STORAGE has failed
RME-00222: Failed to dispatch operation to Repository

Run the Database Design Transformer without creating object implementations:

1) In the Database Design Transformer dialog box,
2) click button 'Settings',
3) in the 'Settings' dialog box,
4) select Database = '(none')
5) Click OK button
6) Click 'Run' button to launch the Database Design Transformer.

How to Stop Getting "Head /Index.Html HTTP/1.1" Messages Every 20 Seconds in Apache access_log

05:55 No comments

Change the ping frequency in opmn.xml

Oracle Database XE (Express Edition) 11.2 beta is out!

07:38 No comments

http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html

- Express Edition is limited to a single instance on any server
- Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server
- Express Edition may only be used to support up to 11 GB of user data (not including Express Edition system data)
- Express Edition may use up to 1 GB RAM of available memory :(