http://fdtool.free.fr/LAF/doc/Oracle_Forms_Look_and_Feel_project.h...
quinta-feira, 1 de novembro de 2012
quinta-feira, 25 de outubro de 2012
terça-feira, 16 de outubro de 2012
Oracle Application Express 4.2 released
07:03
No comments
Oracle Application Express 4.2 was officially released.
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.ht...
terça-feira, 25 de setembro de 2012
quarta-feira, 19 de setembro de 2012
How I Simplified Oracle Database 11g Installation on Oracle Linux 6
05:03
No comments
http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux6-1845247.ht...
quinta-feira, 13 de setembro de 2012
Exadata MAA Best Practices Migrating Oracle Databases
05:18
No comments
http://www.oracle.com/technetwork/database/features/availability/xmigration-11-133466.p...
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
14:06
No comments
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...
quinta-feira, 30 de agosto de 2012
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_configuratio...
sexta-feira, 24 de agosto de 2012
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...
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.p...
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.
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-infrastructur...
quarta-feira, 25 de julho de 2012
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')...
segunda-feira, 2 de julho de 2012
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:0...
quarta-feira, 23 de maio de 2012
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...
quinta-feira, 10 de maio de 2012
quarta-feira, 9 de maio de 2012
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:passwor...
segunda-feira, 7 de maio de 2012
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 registe...
sexta-feira, 4 de maio de 2012
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.h...
quinta-feira, 3 de maio de 2012
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.h...
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-form...
quarta-feira, 21 de março de 2012
Failed to write the checkpoint:'' with status:FAIL.Error code is 32512
06:39
1 comment
Improper Oracle Grid Infrastructure configuration found on this hostDeconfigure the existing cluster configuration before startingto configure a new Grid Infrastructurerun '/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 -deconfigUsing configuration...
sexta-feira, 16 de março de 2012
Determining Database DBID - Database not open
11:00
No comments
[oracle@orcl ~]$ strings /u02/oradata/orcl/sysaux01.dbf | grep DB_IDDB_ID 941873125or[oracle@orcl ~]$ strings /bkp/orcl/backupset/df_ORCL_11_1_787935734.dbf | grep MAXVALUE 941982635, MAXVAL...
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-a...
