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

sexta-feira, 9 de julho de 2010

PDF Printing in Application Express

13:13 No comments

http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html

frmwebutil.jar 10.1.2.3.0

12:57 No comments

Versão correta se encontra no Patch 7384879.

chgiphost.sh - ELF file data encoding not little-endian

07:42 No comments

[oracle@semba scripts]$ ./chgiphost.sh -idm
Oracle Home set to /u01/app/oracle/product/as10g/Infra
Starting Change Hostname/IP...

Change Hostname/IP completed successfully.

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/as10g/Infra/chgip/lib/libpass.so: /u01/app/oracle/product/as10g/Infra/chgip/lib/libpass.so: ELF file data encoding not little-endian
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1511)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:834)
at oracle.chgip.InteractiveInterfaceManager.(InteractiveInterfaceManager.java:72)
at oracle.chgip.InterfaceManager.createInterfaceManager(InterfaceManager.java:133)
at oracle.chgip.InterfaceManager.getInterfaceManager(InterfaceManager.java:113)
at oracle.chgip.Session.(Session.java:97)
at oracle.chgip.StartUp.main(StartUp.java:250)

Cause

There is a bug in the 10.1.2.3 patchset with the libpass.so file, as an incorrect library was included in the patchset media. Bug 7000666 has been filed for this.

Solution

Download and install Patch 7000666 for Linux x86

OracleAS 10.1.3 AS Control Home Page is Very Slow to Appear

11:38 No comments

Find a trace file in Oracle 11g

13:19 No comments

SELECT value
FROM v$diag_info
WHERE name = 'Default Trace File';

"configuration for DISK channel n is ignored"

15:41 No comments

CONFIGURE CHANNEL N DEVICE TYPE DISK CLEAR;

Oracle Designer - ORA-7445 when deleting an object from the Repository

05:59 No comments

Metalink Doc Id:578441.1

Workaround is:

alter system set "_optimizer_cost_based_transformation"=off scope=both;

or create on logon trigger for designer users to alter the session, for
example:
create or replace trigger .on_logon
after logon on database
begin
execute immediate 'alter session set
"_optimizer_cost_based_transformation"=off';
end;

Oracle Application Development Tools Statement of Direction: Oracle Forms, Oracle Reports and Oracle Designer

06:15 No comments

http://www.oracle.com/technology/products/forms/pdf/10g/ToolsSOD.pdf

Invalid Objects After Removing OLAP or Migration of a Database to 64 Bit

10:24 No comments

Doc Id: 565773.1

-> conn / as sysdba
SQL> @?/olap/admin/catnoamd.sql
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/catnoxoq.sql

Determine all PUBLIC synonyms referring to objects in the OLAPSYS schema:

SQL>spool olapdrop.sql
SQL> select 'drop public synonym ' || synonym_name || ';'
from dba_synonyms
where owner='PUBLIC' and table_owner='OLAPSYS';
SQL>spool off

Modify the datapump handler table to remove handlers used to export OLAP data:

SQL>select * from sys.exppkgact$ where package = 'DBMS_AW_EXP' and
schema= 'SYS';
SQL>delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'
and schema= 'SYS';
SQL>commit;

PL/SQL Web - File Upload and Download Procedures

15:33 1 comment

http://www.oracle-base.com/articles/9i/FileUploadDownloadProcedures9i.php

Oradebug - Diagnosing Library Cache Latch Contention

12:56 No comments

http://arup.blogspot.com/2008/08/diagnosing-library-cache-latch.html

RAC One Node tips

11:39 No comments

http://www.dba-oracle.com/t_rac_one_node.htm

Oracle Enterprise Manager Desktop Widgets

09:06 No comments

http://blogs.oracle.com/emwidgets/

String Aggregation Techniques

15:55 No comments

http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php

Database Point in Time Recovery failed ORA-01841

09:16 1 comment

Doc ID: 370500.1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/10/2006 11:43:56
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'MAY 10 2006 06:40:04'
ORA-01841 (full) year must be between -4713 and +4713 / +9999 and must not be 0

Cause

o NLS_LANG was not set (empty)

Solution
To implement the solution, please execute the following steps:

1. Set Environemnt Variable for example:

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
echo $NLS_LANG

Problem : iAS Discovery/Monitoring Fails If Agent Is Installed Under Another OS User Than iAS

06:50 No comments

Doc ID: 437078.1

cd $IAS_HOME
chmod g+rx $IAS_HOME
chmod g+rx $IAS_HOME/bin
chmod g+rx $IAS_HOME/bin/emtgtctl
chmod ug+s $IAS_HOME/bin/emtgtctl2

chmod g+rx $IAS_HOME/perl
chmod g+rx $IAS_HOME/perl/bin
chmod g+rx $IAS_HOME/perl/bin/perl

chmod g+rx $IAS_HOME/sysman
chmod g+rx $IAS_HOME/sysman/emd
chmod g+rw $IAS_HOME/sysman/emd/targets.xml
touch $IAS_HOME/sysman/emd/centralagents.lst
chmod g+rw $IAS_HOME/sysman/emd/centralagents.lst

chmod g+rx $IAS_HOME/sysman/config
chmod g+rw $IAS_HOME/sysman/config/*.properties

chmod g+rx $IAS_HOME/opmn
chmod g+rx $IAS_HOME/opmn/conf
chmod g+rw $IAS_HOME/opmn/conf/opmn.xml

chmod g+rx $IAS_HOME/config
chmod g+rw $IAS_HOME/config/*.xml
chmod g+rw $IAS_HOME/config/*.properties

chmod g+rx $IAS_HOME/Apache
chmod g+rx $IAS_HOME/Apache/Apache
chmod g+rx $IAS_HOME/Apache/Apache/conf
chmod g+rw $IAS_HOME/Apache/Apache/conf/*.conf
chmod g+rw $IAS_HOME/Apache/Apache/conf/*.xml
chmod g+rw $IAS_HOME/Apache/Apache/conf/mime.types

For each OC4J (in this example OC4J_SECURITY):
chmod g+rx $IAS_HOME/j2ee
chmod g+rx $IAS_HOME/j2ee/OC4J_SECURITY
chmod g+rx $IAS_HOME/j2ee/OC4J_SECURITY/config
chmod g+rw $IAS_HOME/j2ee/OC4J_SECURITY/config/*

chmod g+rx $IAS_HOME/dcm
chmod g+rx $IAS_HOME/dcm/config
chmod g+rw $IAS_HOME/dcm/config/*.conf
chmod g+rw $IAS_HOME/dcm/config/*.xml

Oracle Database 11g Release 2 New Features Summary

12:25 No comments

http://www.dbasupport.com/oracle/ora11g/11gR2-new-features-01.shtml

Linux Error: 104: Connection reset by peer when starting Oracle Listener

11:52 No comments

Make sure the loopback entry in /etc/hosts is not missing when you start the listener:

127.0.0.1 localhost.localdomain localhost

What happens during oracle database hot backup

06:51 No comments

http://arjudba.blogspot.com/2009/08/what-happens-during-oracle-database-hot.html

Scheduler Enhancements in Oracle Database 11g

07:21 No comments

Scheduler Enhancements in Oracle Database 11g Release 1
http://www.oracle-base.com/articles/11g/SchedulerEnhancements_11gR1.php

Scheduler Enhancements in Oracle Database 11g Release 2
http://www.oracle-base.com/articles/11g/SchedulerEnhancements_11gR2.php

Remote Scheduler Agent Installation for Oracle 11g Release 2
http://www.oracle-base.com/articles/11g/SchedulerAgentInstallation_11gR2.php

Monitorando o progresso do RMAN

07:34 No comments

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;

ORA-28112 (select * from mgmt_targets)

06:27 No comments

grant exempt access policy to USER;

Metalink DOC ID: 778864.1

Migrating a Microsoft SQL Server Database to Oracle Database 11g

06:26 No comments

http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

Fine Grained Dependency (11G)

06:24 No comments

Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL.

In previous releases, object dependencies were managed at the object level, so altering an object automatically invalidated all dependent objects. Oracle 11g has more granular dependency management, so only changes that directly affect an object will cause an invalidation.

http://www.oracle-base.com/articles/11g/EnhancedFinerGrainedDependencyManagement_11gR1.php

http://www.oraclebrains.com/2007/09/plsql-fine-grained-dependency-tracking/

http://ocpdba.wordpress.com/2009/03/05/a-new-paradigm-oracle-11gs-feature-for-context-objects-invalidation-coi/

Moving ASM Database Files from one Diskgroup to Another

06:23 No comments

http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml

Delete the old ASM database file from its original location

06:22 No comments

$ ORACLE_SID=+ASM; export ORACLE_SID

$ sqlplus "/ as sysdba"

SQL> ALTER DISKGROUP TESTDB_DATA2 DROP FILE '+TESTDB_DATA2/testdb/datafile/app_data.256.598127837';

http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml

Resetting the Administrator (oc4jadmin) Password

06:19 No comments

1 - Stop OC4J and the Application Server Control.

2 - Locate and open the following file in a text editor:

(UNIX)ORACLE_HOME/j2ee/home/config/system-jazn-data.xml

3 - Locate the line that defines the credentials property for the oc4jadmin user.

{903}4L50lHJWIFGwLgHXTub7eYK9e0AnWLUH

4 - Replace the existing encrypted password with the new password.

!mynewpassword123

5 - Delete cached password data by deleting the contents of the following directory:

ORACLE_HOME/j2ee/oc4jinstance/persistence/ascontrol/ascontrol/securestore/

6 - Start OC4J and the Application Server Control.

http://download-west.oracle.com/docs/cd/B31017_01/core.1013/b28940/trouble_asc.htm#BCEDHFEI

Oracle's Block Browser and Editor tool

08:33 No comments

Oracle's Block Browser and Editor tool

http://www.dbasupport.com/oracle/ora10g/bbed.shtml

http://www.dbasupport.com/oracle/ora10g/bbed02.shtml

Tuning Reports Server Configuration

07:28 No comments

<'engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="10" maxEngine="150" minEngine="10" engLife="50" maxIdle="30" callbackTimeOut="60000" engineResponseTimeOut="60" jvmOptions="-Xms128m -Xmx1024m">

Mais detalhes em:

http://download-west.oracle.com/docs/cd/B14099_17/bi.1012/b14048/pbr_tune.htm#i1006609

Result Cache - PL/SQL 11G

07:05 No comments

“Result Cache” é uma feature do 11g que possibilita manter o resultado de uma função em CACHE.
Muito útil, por exemplo, para funções que são constantemente utilizadas pelas aplicações.

Mais detalhes em:

http://www.oracle.com/technology/oramag/oracle/07-sep/o57asktom.html

http://www.oracle.com/technology/oramag/oracle/07-sep/o57plsql.html

http://www.oracle-base.com/articles/11g/CrossSessionPlsqlFunctionResultCache_11gR1.php