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

segunda-feira, 20 de janeiro de 2014

Recuperando a senha do Oracle Portal 11g

12:45 No comments

How to Retrieve the Portal Schema Password in Portal 11g? (Doc ID 843978.1)

cd $ORACLE_HOME/common/bin

./wlst.sh

connect()

informar o username, password e URL.

listCred(map="oracle.portal.dads", key="/pls/portal")

Script para inicializar o OID após o banco de dados

15:50 No comments

Making Applications Highly Available Using 11gR2 Grid Infrastructure (Doc ID 1105489.1)

/u01/app/11.2.0.4/grid/bin/crsctl add resource OPN -type ora.local_resource.type -attr "AUTO_START=always,ACTION_SCRIPT=/u01/app/oracle/scripts/opn.sh"

/u01/app/11.2.0.4/grid/bin/crsctl modify resource OPN –attr "START_DEPENDENCIES=hard(ora.oimtrei.db)"

/u01/app/11.2.0.4/grid/bin/crsctl modify resource OPN –attr "STOP_DEPENDENCIES=hard(ora.oimtrei.db)"

/u01/app/11.2.0.4/grid/bin/crsctl modify resource OPN -attr "CHECK_INTERVAL=120"

DRG-10513: index WWSBR_TOPIC_CTX_INDX metadata is corrupt

18:39 No comments

Caso ocorra o erro abaixo na migração do Portal, utilizando o banco 11.2.0.4:

###
### ERROR: WWU-01013: Upgrade terminated with the following errors:
### 10465 : ERROR at line 1:
### 10466 : ORA-20000:
### 10467 : ORA-06512: at "PORTAL.WWPOF", line 440
### 10468 : ORA-06512: at line 152
### 10469 : ORA-06510: PL/SQL: unhandled user-defined exception
### 10470 : ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 164
### 10471 : ORA-06512: at "PORTAL.WWV_CONTEXT", line 2283
### 10472 : ORA-06510: PL/SQL: unhandled user-defined exception
### 10473 : ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 71
### 10474 : ORA-06512: at "PORTAL.WWV_CONTEXT", line 2231
### 10475 : ORA-29874: warning in the execution of ODCIINDEXALTER routine
### 10476 : ORA-29960: line 1,
### 10477 : DRG-10595: ALTER INDEX WWSBR_TOPIC_CTX_INDX failed
### 10478 : DRG-50857: oracle error in drixmd.PurgeKGL
### 10479 : ORA-20000: Oracle Text error:
### 10480 : DRG-10513: index WWSBR_TOPIC_CTX_INDX metadata is corrupt
### 10481 : ORA-30576: ConText Option dictionary loading error
### 10482 : DRG-50610: internal error: kglpurge []
### 10492 : # ERROR: Creating missing Text indices
### 10493 : # ERROR: User-Defined Exception
### 10501 : ### ERROR: Exception Executing upg/common/posttrge/crtxtind.sql

Rodar os seguintes scripts para recriar os índices antes do upgrade:

/u01/app/oracle/product/as10g/MidTier/portal/admin/plsql/wws/ctxdrind.sql

/u01/app/oracle/product/as10g/MidTier/portal/admin/plsql/wws/ctxcrind.sql

Aplicar o patch e seguir as instrucões:

Oracle Text release 11.2.0.4.0 mandatory Patches (Doc ID 1608029.1)

ORA-04063: package body "ODS.TSPURGE" has errors

14:54 3 comments

If you are creating the Oracle Internet Directory schema in an Oracle database using RCU, you may encounter the following error messages:

ORA-04063: package body "ODS.TSPURGE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ODS.TSPURGE"
ORA-06512: at line 3

To work around this issue:

Stop RCU and drop any Oracle Internet Directory schemas already created. Refer to "Dropping Schemas" in Oracle Fusion Middleware Repository Creation Utility User's Guidefor instructions.

Log into the database using SQL*Plus and run the following command:

 grant execute on sys.dbms_job to PUBLIC and grant execute on dbms_reputil to PUBLIC

Run RCU again and create the schemas.

http://docs.oracle.com/cd/E28389_01/doc.1111/e14775/install.htm

XATRANS Views are not installed on this Database

14:34 No comments

@?/javavm/install/initxa.sql
@?/rdbms/admin/xaview.sql
grant select on V$XATRANS$ to public;

add_external_contact to Oracle Beehive

09:23 No comments

beectl add_external_contact --family_name Silva --given_name Joao --display_name "Joao da Silva" --address BUSINESS_1:mailto:joao.silva@email.gv.ao --scope enpr=Jupiter

beectl list_external_contacts

Para adicionar em um grupo:

beectl list_groups --entity_format id

arquivo.xml:

beectl modify_group --file arquivo.xml

Validating the input XML file.
Successfully validated the XML File.
For details see the management and core log files.
Modifying groups in batches. This may take a while...

Successfully modified 1 groups, total 1

Summary:

Total number of groups: 1
Successfully modified: 1
Partially modified(usability, visibility not set): 0
Failed to modify: 0

beectl list_groups --name dbas.sigfe --show ALL

STACKX User Guide (Doc ID 362791.1)

08:04 No comments

STACKX

Core / Stack Trace Extraction Tool - Version 1.2

Este utilitário, permite a análise de arquivos de Core Dump.

TECH: Getting a Stack Trace from a CORE file on Unix (Doc ID 1812.1)

How to obtain a Core Dump file from a Web Cache crash (Doc ID 263660.1)

08:03 No comments

Em caso de problemas no WEBCACHE, é possível gerar arquivos de CORE DUMP para análise:

Release 9.0.4 (10g) to 10.1.2.x:

$ opmnctl startproc process-type=WebCache WCCore=true

Client Address Information in HTTP Reverse Proxy Scenarios

07:00 No comments

Doc ID -263943.1

Add in httpd.conf:

UseWebCacheIp ON

and change this line

LogFormat "%h %l %u %t \"%r\" %>s %b" common

for

LogFormat "%{X-Forwarded-For}i %l %u %t \"%r\" %>s %b" common

Can't locate object method "header_in" via package "Apache2::RequestRec" AdjustRemoteAddrAccordingToHeader.pm line 9

12:36 No comments

Ao migrar o Oracle Portal para versão 11G, o script AdjustRemoteAddrAccordingToHeader.pm começou a apresentar o seguinte erro:

Can't locate object method "header_in" via package "Apache2::RequestRec" at /u01/app/oracle/product/Middleware/asinst_1/config/OHS/ohs1/AdjustRemoteAddrAccordingToHeader.pm line 9

Para resolver este problema, basta acrescentar o seguinte:

use Apache2::compat;

AdjustRemoteAddrAccordingToHeader.pm:

package Apache::AdjustRemoteAddrAccordingToHeader;

use Apache2::compat;

sub handler
{
my $r = shift;
my $configuredValue = $r->dir_config ("UseIPFromHeader");
if ($configuredValue)
{
my $ip = $r->header_in($configuredValue);
if ($ip)
{
$r->connection->remote_ip($ip);
}
}
else
{
print STDERR "AdjustRemoteAddrAccordingToHeader: PerlSetVar UseIPFromHeader is not set, so I did not do anything\n";
}

# Adjust for Oracle HTTP Server and REMOTE_ADDR
# Remove this line if not necessary
$r->header_in("ClientIP", $r->connection->remote_ip());

return OK;
}

return 1;

httpd.conf:

PerlRequire /u01/app/oracle/product/Middleware/asinst_1/config/OHS/ohs1/AdjustRemoteAddrAccordingToHeader.pm
PerlPostReadRequestHandler Apache::AdjustRemoteAddrAccordingToHeader
PerlSetVar UseIPFromHeader X-Forwarded-For

Recommended Patches for Oracle Portal 11g (Doc ID 1443292.1)

13:09 No comments

Atualizar a versão do OPATCH 11.1.1x --> Patch:6880880

Aplicar o Patch:15844859 - MLR: MANDATORY PATCH FOR PORTAL 11G PATCHING V3 --> mesmo sendo da versão 11.1.1.4 ele é obrigatório para aplicar os patchs no 11.1.1.7.0

O Portal continua na versão 11.1.1.6, então mesmo no 11.1.1.7, deve-se aplicar os patchs abaixo:
Portal Repository Patch 15997732 - Generic Platform
Portal Repository Patch 13938784 - Generic Platform

Atualizar o WEBCACHE:

Oracle Web Cache 11.1.1.7.0
WebCache 11.1.1.7 Oct 2013 CPU Patch 17306880 or higher

Documentos interessantes:
Unable To Apply Oracle Portal 11g Patches Using OPatch Getting Too Many Arguments And OS Undefined Variable (Doc ID 1465506.1)

Error 1:
=======
opatch: line 386: [: too many arguments
- This is caused by using the double quotes " " in the opatch command. The readme incorrectly has these around the -pre section and they should not be there.

Error 2:
========

Please set your ORACLE_HOME to your 10.1.2 midtier installation home.
.....................................................................
OS: Undefined variable.

Command invocation returned Error... 'OS: Undefined variable.
', Return Code = 1

- This is caused by a few issues. Ensure you have the latest 11.1.0.0.0 OPatch version downloaded, and ensure you have the Mandatory Portal 11g Patching Patch which fixes issues with the patching tool itself.
Reference: Note 1443292.1 Recommended Patches for Oracle Portal 11g
- That patch applies to all Portal 11g versions.

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.