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

sexta-feira, 24 de agosto de 2012

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

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 :(

ORA-00600 [16500] [kqdcru] Running purge dba_recyclebin

15:16 No comments

Errors in file /u01/app/oracle/diag/rdbms/aupecdbtest/aupecdbtest/trace/aupecdbtest_ora_27336.trc (incident=281):
ORA-00600: internal error code, arguments: [16500], [kqdcru], [D], [2], [110], [BIN$nFHAOchQTu3gQKjAB2RbGw==$0], [], [], [], [], [], []

Solution

SQL> ALTER SESSION SET NLS_SORT = BINARY;

The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which App...

14:19 No comments

The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which Application Server Control is running

ORACLE_HOME/j2ee/oc4j_instance_name/config/system-jazn-data.xml

edit system-jazn-data.xml

find oc4jadmin

replace credentials>!welcome123

restart container

"Demo It To Oracle" (DITO)

14:17 No comments

CamStudio is a third party desktop recording software that can be used to "Demo It To Oracle" (DITO).

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocDsrc=KB&viewingMode=1143&bmDocType=REFERENCE&bmDocID=11.1&from=BOOKMARK&bmDocTitle=%22Demo%20It%20To%20Oracle%22%20(DITO)%20-%20CamStudio%20Help))