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

sábado, 7 de dezembro de 2013

UKOUG - TECH13

14:19 2 comments

#ukoug_tech13 – Impressions

Na primeira semana de Dezembro de 2013, estive em Manchester para a conferência TECH13 do UKOUG.

Realmente fiquei impressionado com o nível técnico e a organização do evento.

Finalmente conheci pessoalmente alguns grandes nomes quando se trata de Oracle:

Bjoern Rost
Heli Helskyaho

E o Tim Hall do oracle-base.com

http://www.oracle-base.com/blog/2013/12/03/is-this-the-most-committed-ukoug-tech13-attendee/

Fiz o credenciamento e comecei a participar do evento no domingo 01/12 (Super Sunday)

A primeira palestra do dia foi com a lenda Jonathan Lewis - Compression: Index, basic and OLTP

A segunda foi com James Morle (ACE Director) - Optimal Oracle Configuration for Efficient Table Scanning

A terceira foi com Frits Hoogland (ACE Director) da Enkitec - About Multiblock Reads

Ele compartilhou os resultados de sua pesquisa de 2 anos sobre leituras no Oracle. Muito interessante a demonstração dos eventos de trace do Oracle + strace.

A primeira da Segunda-Feira, foi com Zoran Pavlovic e Maja Veselica - New Security Features in Oracle Database 12c

A segunda foi com Andy Colvin (Oracle ACE) da Enkitec - RMAN in Oracle Database 12c - Top New Features

Fez uma demonstração ao vivo de como utilizar Table Point-in-time Recover.

A terceira foi com Jonathan Lewis e Maria Coglan - Oracle Optimizer Boot camp – 10 Optimizer Tips you Can’t Miss

Foi basicamente a mesma apresentação que eles fizeram no OOW13.

A quarta foi com Joel Goodman - Roundtable - RAC and Grid Infrastructure

Uma discussão muito interessante sobre o 12c.

A quinta foi com Maria Colgan - Introduction to the New Oracle Database In-Memory Option

A sexta foi com Dawid Wojcik do Cern - Cardinality Feedback Tuning Revisited – Adaptive Query Optimization in Oracle 12c

A sétima foi com Tom Kyte - Oracle Optimizer: What’s New in Oracle Database 12c?

Na terça-feira, iniciou com Joze Senegacnik (Oracle Ace Director) - Query Transformations Revisited

A segunda foi com Larry Carpenter da Oracle - Oracle Active Data Guard: Next Generation Data Protection

A terceira, foi novamente com Joze Senegacnik - Opening the Black Box Called “Cost Based Optimizer

A quarta foi novamente com Larry Carpenter da Oracle - Oracle Maximum Availability Architecture Best Practices for Oracle Multitenant

A quinta foi com Tom Kyte - Understanding Optimizer Statistics

A sexta foi com Kyle Hailey (Oracle Ace) da Delphix - Lies, Damned Lies, and I/O Statistics

Na quarta, iniciei com Joel Goodman - Masterclass: Oracle Parallel Execution

A segunda for com Maris Elsins da Pythian - 10 Ways to Improve your RMAN Script

A terceira foi com Martin Bach (Oracle Ace) da Enkitec - Using Cross-Platform Transportable Tablespaces to Reduce Downtime

A quarta foi com Tony Hasler e Jonathan Lewis - Debate: Does Oracle Ignore Hints?

A quinta foi Julian Dyke (Oracle Ace) - Oracle 12c New Features – Picking the Winners

A sexta foi com Cameron Purdy da Oracle - Cloud Application Foundation 12c - Developing and Deploying Java Applications in Modern Data Center Architectures

E o encerramento foi com Thomas Kyte - What I Learned from TECH13

Estou reunindo os links das apresentações e assim que possível colocarei no nosso site de Grupo de Usuários Oracle Angola - GUOA (www.guoa.org).

Até mais.

Alex Zaballa

domingo, 24 de novembro de 2013

12:02 No comments

O GUOA foi oficialmente lançado em Angola!
Entre no site para conferir as fotos do Evento e aproveite para se registrar! (www.guoa.org)

Como recuperar uma package, function ou procedure dropada acidentalmente

15:33 No comments

select object_id,object_name,object_type from dba_objects where object_name = 'OWA_UTIL';

select source
from sys.source$
as of timestamp(sysdate - 1)
where obj#=6298
order by line

Após o upgrade para 11.2.0.4 - unable to delete any rows from table with context index due to error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (Doc ID 1586704.1)

14:33 No comments

After upgrade to 11.2.0.4 unable to delete any rows from table with context index due to error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (Doc ID 1586704.1)

connect / as sysdba
alter session set current_schema=CTXSYS;

create or replace procedure syncrn (
ownid IN binary_integer,
oname IN varchar2,
idxid IN binary_integer,
ixpid IN binary_integer,
rtabnm IN varchar2,
srcflg IN binary_integer,
smallr IN binary_integer
)
authid definer
as external
name "comt_cb"
library dr$lib
with context
parameters(
    context,
    ownid ub4,
    oname OCISTRING,
    idxid ub4,
    ixpid ub4,
    rtabnm OCISTRING,
    srcflg ub1,
    smallr ub1
);
/

Como Instalar o Oracle Developer Suite 6i (Patch 18) em Windows 8

13:12 No comments

Install Oracle Developer Suite 6i (Patch 18) on Windows 8

http://windows7bugs.wordpress.com/2012/08/25/windows-8-oracle-developer-suite-6i-patch-18/

OBIEE 11g: "OBIEE content cannot be displayed in an IFrame"

07:20 No comments

http://atlantabi.blogspot.com/2011/12/obiee-11g-obiee-content-cannot-be.html

Doc ID 1427865.1
Doc ID 1540125.1

Erro "java.lang.Throwable: ResourceBundle is null" durante o ugprade do Oracle Portal

16:54 No comments

java.lang.Throwable: ResourceBundle is null - Portal upgrade

Applying patchset 10.1.2.2 or 10.1.2.3 to midtier hangs on portal upgrade.

Log file shows:

[java.lang.Throwable: ResourceBundle is null
at oracle.sysman.oii.oiix.OiixJarResourceBundle.(OiixJarResourceBundle.java:124)

The $ORACLE_HOME/j2ee/OC4J_Portal/applications/portal/portal/WEB-INF/web.xml got corrupted.

Solution

Adjust or Restore the original web.xml

OBIEE 11G - "HTTP 500 Internal server error" ao tentar acessar o Mapviewer

12:28 No comments

HTTP 500 Internal server Error Trying To Access Mapviewer

Stop the managed server

cd home>/Oracle_BI1/bifoundation/jee/mapviewer.ear

rm web.war/WEB-INF/lib/adf-faces-api.jar
rm web.war/WEB-INF/lib/adf-faces-impl.jar
rm web.war/WEB-INF/lib/commons-digester.jar
rm web.war/WEB-INF/lib/commons-logging-1.1.jar
rm web.war/WEB-INF/lib/jsf-api.jar
rm web.war/WEB-INF/lib/jsf-impl.jar
rm web.war/WEB-INF/lib/jsr173_1.0_api.jar
rm web.war/WEB-INF/lib/mvutil.jar
rm web.war/WEB-INF/lib/xdb.jar
rm web.war/WEB-INF/adf-faces-config.xml
rm web.war/WEB-INF/orion-web.xml

rm -rf home>/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_use
r/mapviewer_11.1.1

Restart the managed server.

Utizando "Reports Server Queue" - 10g

14:59 No comments

Using the Reports Server Queue - 10g

Execute RW_SERVER.sql script (located in $ORACLE_HOME/reports/admin/sql)

cd $ORACLE_HOME/reports/admin/sql
sqlplus scott/tiger@dbalias
SQL> @rw_server.sql

The Reports Server's configuration file is located at $ORACLE_HOME/reports/conf/.conf

The RW_SERVER_JOB_QUEUE table capures data.

*****Se the maxQueueSize parameter, default is 1000.

Red Hat / Oracle Enterprise Linux I/O tuning for Oracle databases

04:54 No comments

http://blog.yannickjaquier.com/linux/red-hat-oracle-enterprise-linux-io-tuning-for-oracle-databases.html

Utilizando o EM12c para visualizar o valor das variáveis bind

04:38 No comments

Using EM12C to see bind variables

http://jhdba.wordpress.com/2013/07/24/using-em12c-to-see-bind-variables/

FMAP no OBIEE 11g

05:25 No comments

FMAP in OBIEE 11g

http://oraclebisolutions.blogspot.com.br/2013/01/fmap-in-obiee-11g.html

http://techforum4u.com/entry.php/3474-How-To-Use-Images-In-OBIEE-11G

ORA-15032 ORA-15054

05:59 No comments

ALTER DISKGROUP FRA01 DROP DISK "_DROPPED_0001_FRA01" FORCE;

ORA-15032: not all alterations performed ORA-15054: disk "_DROPPED_0001_FRA01" does not exist in diskgroup "FRA01"

[root@maiombe ~]# /etc/init.d/oracleasm querydisk -d DISK04
Disk "DISK04" is a valid ASM disk on device [8,65]

[root@maiombe ~]# ls -l /dev |grep 8|grep 65
brw-r----- 1 root disk 8, 65 Jul 5 09:34 sde1

[root@maiombe ~]# dd if=/dev/zero of=/dev/sde1 bs=4k count=20000

20000+0 records in

20000+0 records out

81920000 bytes (82 MB) copied, 0.361043 seconds, 227 MB/s

[root@maiombe ~]# /etc/init.d/oracleasm scandisks

Scanning the system for Oracle ASMLib disks: [ OK ]

[root@maiombe ~]# /etc/init.d/oracleasm listdisks

DISK01

DISK02

DISK03

[root@maiombe ~]# /etc/init.d/oracleasm createdisk DISK04 /dev/sde1

Marking disk "DISK04" as an ASM disk: [ OK ]

[root@maiombe ~]# /etc/init.d/oracleasm listdisks

DISK01

DISK02

DISK03

DISK04

SQL> ALTER DISKGROUP FRA01 ADD DISK 'ORCL:DISK04';

Diskgroup altered.

Configurando o Oracle HTTP Server (OHS) nas portas 80 e 443

06:55 No comments

Configure Oracle HTTP Server (OHS) on port 80 / 443

http://onlineappsdba.com/index.php/2013/05/30/configure-oracle-http-server-ohs-on-port-80-443

Alterando a string “Business Intelligence” no cabeçalho do OBIEE11g

11:35 No comments

Change the “Business Intelligence” name on OBIEE11g Common Portal header

/u01/app/oracle/product/Middleware/Oracle_BI1/bifoundation/web/msgdb/l_en/messages/productmessages.xml

change:

Business Intelligence

restart bi presentation.

Limpando o cache no OBIEE11G

10:17 No comments

Clear cache in OBIEE11G

/u01/app/oracle/product/Middleware/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh

/u01/app/oracle/product/Middleware/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb -u weblogic -p PASSWORD -s /u01/app/oracle/product/Middleware/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/purgecache.txt

purgecache.txt:

For all:
Call SAPurgeAllCache()

For especific table:
Call SAPurgeCacheByTable( 'Biminfin - Físico', '', 'BIMINFIN','TB_FAT_0_CAD_DESPESA' );

Customizando a página de login, imagens e logos do OBIEE11g

10:14 No comments

Customizing Login pages, Images and Logos in OBIEE11g

To change logo and Login page in obiee 11g:

/u01/app/oracle/product/Middleware/Oracle_BI1/bifoundation/web/app/res/sk_blafp/login

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/.appmergegen_1316154755380/analytics.ear/ukjjdc/res/sk_blafp/b_mozilla_4

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/.appmergegen_1316154755380/analytics.ear/ukjjdc/res/sk_blafp/login

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/b_mozilla_4

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/login

To Change images :

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/.appmergegen_1307357397958/analytics.ear/ukjjdc/res

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images

/u01/app/oracle/product/Middleware/Oracle_BI1/bifoundation/web/app/res/s_blafp/images

/u01/app/oracle/product/Middleware/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/.appmergegen_1291264099332/analytics.ear/ukjjdc/res/s_blafp/images

OPatch found the word "warning" in the stderr of the make command

18:30 No comments

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

This is a warning only which opatch is reporting. The Patch has applied successfully and the warning output can be safely ignored.

11.2 Oracle Restart – Alterando o Hostname

13:52 No comments

11.2 Oracle Restart – Changing Hostname

http://oraganism.wordpress.com/2009/12/20/11-2-changing-hostname/

Portal Shows Bad Performance And Hangs

11:59 No comments

Doc ID 1097532.1

Ajustando as permissões do Oracle Portal

10:40 No comments

Adjust Oracle Portal permissions

declare
v_dn varchar2(2000);
v_id number;
begin
for i in (select ID, OBJECT_TYPE_NAME, OWNER, NAME,
GRANTEE_GROUP_ID, GRANTEE_USER_ID, GRANTEE_TYPE, PRIVILEGE,CREATED_BY_DBUSER,CREATED_BY_USER from PORTAL.WWSEC_SYS_PRIV$
where GRANTEE_GROUP_ID <> 0
) loop
begin

select dn
into v_dn
from wwsec_group$ where id=i.grantee_group_id;

select max(id)
into v_id
from wwsec_group$ where dn = v_dn;
end;

begin

update PORTAL.WWSEC_SYS_PRIV$
set grantee_group_id = v_id
where id=i.id;
exception when others then
dbms_output.put_line('erro '||i.id);
end;
end loop;
commit;
end;

The Oracle Home /u01/app/oracle/product/as10g/MidTier is not registered with the Central Inventory. OPatch was not able to get details of the home from the inventory.

07:27 No comments

./runInstaller -silent -invPtrLoc /etc/oraInst.loc -attachHome ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="MID_1013"

EM12c - sudo: no tty present and no askpass program specified

10:59 No comments

Disable the 'requiretty' and visiblepw option in the 'sudoers' file and rerun the failed job.

Verify if you don't have:

oracle ALL=(ALL) ALL

12c: Credentials Fail - PAM authentication...PAM failed with error: libpam.so: cannot open shared object file: No such file or directory

05:38 No comments

DOC ID 1477095.1

cd /lib
ln -s libpam.so.0 libpam.so

cd /lib64
ln -s libpam.so.0 libpam.so

2. In the Navigation Pane, expand the Domain Farm > Portal > and select portal (WLS_PORTAL).

3. From the Portal drop down, select Settings > Wire Configuration.

Or WebLogic Scripting Tool.

Oracle Text release 11.2.0.3.0 mandatory Patches

14:49 No comments

ID 1386945.1

Apply Patch 12960302 to fix the ORA-30576, DRG-10607 and ORA-1426 errors.
Apply Patch 13922299 to fix the meta data corruption, the core dump in function druhfind() from 'create index' statement and the import problem.