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

sexta-feira, 13 de dezembro de 2013

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

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 { ...

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...

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: Øyvind Isene Osama Mustafa Debra Lilley Philippe Fierens Maris Elsins Jan Karremans Jonathan Lewis Maria Colgan Andy Colvin Frits Hoogland Bjoern...

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 lin...

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 ...

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-...

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...

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...

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 100...

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.ht...

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-variable...

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-11...

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,...

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-4...

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...

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...

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-hostnam...

Portal Shows Bad Performance And Hangs

11:59 No comments

Doc ID 1097532....

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 ...

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_101...

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....

Alterando o tempo de inatividade do Oracle Enterprise Manager 12c

05:10 1 comment

Changing Enterprise Manager 12c Default inactive Timeout http://www.fuadarshad.com/2013/02/changing-enterprise-manager-12c-default.ht...

How to Configure Oracle Portal 11g with Reverse Proxy SSL

08:52 No comments

MOS ID: 1119068...

Converting SSL certificate generated by a 3rd party to an Oracle Wallet

08:28 No comments

http://fusionsecurity.blogspot.com/2012/11/converting-ssl-certificate-generated-by.ht...

Portal Wire Configuration option that replaces ptlconfig in Portal 11.1.x.

11:39 No comments

[ID 1392576.1] 1. Access Fusion Middleware Control (http://servername:port/em). 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....

Attempting to Configure a New SSL Listen Port in 11g Web Cache Admin Fails with Please enter a non-empty string for CRL Path

14:46 No comments

ID 1497163.1 Create a new http (non-SSL) Convert the Listen port to SSL&nbs...

Adding an Index to an Existing Attribute by Using Oracle Directory Services Manager

15:40 No comments

To add an index to an existing attribute: Invoke Oracle Directory Services Manager and connect to the Oracle Internet Directory server as described in "Invoking Oracle Directory Services Manager". From the task selection bar, select Schema. Select an attribute that is not currently indexed that you want to add the index to. Click the The attribute will be cataloged/decataloged icon. When the Confirm Dialog appears, click Confirm. The Indexed box indicates that the attribute is indexed....

STARTUP and Shutdown Portal 11g

14:13 No comments

create boot.properties files: $FORMSREPORTSDOMAIN/servers/AdminServer/security/boot.properties $FORMSREPORTSDOMAIN/servers/WLS_FORMS/security/boot.properties $FORMSREPORTSDOMAIN/servers/WLS_REPORTS/security/boot.properties $FORMSREPORTSDOMAIN/servers/WLS_PORTAL/security/boot.properties --------------------------------------------------------------------------------------------------- Start: #!/bin/sh export MIDDLEWARE_HOME=/u01/app/oracle/product/Middleware export FORMSREPORTSINSTANCE=/u01/app/oracle/product/Middleware/as_portal export...

oracle.as.config.impl.SimpleProvisionException

07:30 No comments

ID:1218563.1 Unpublished Bug 9287845 PS2:CLASSIC:REPORTS SERVER COMPONENT CREATIONS FAILS DURING APACHE PREFLIGHT Solution 1. Update/correct name resolution on the network such that the server's host name and IP address are uniqu...

Failed to assign port 8090: Address family not supported by protocol

15:25 No comments

ID 1113163.1 1. Backup the $MW_HOME//config/WebCache/webcache1/webcache.xml file. 2. Add the IPV6 ENABLED="NO" tag below the MULTIPORT&nbs...

How to clean up after a failed 11gr2 CRS install

14:01 No comments

http://gjilevski.com/2010/08/12/how-to-clean-up-after-a-failed-11g-crs-install-what-is-new-in-11g-r2-...

PRVF-5637 - OEL 6.3

13:44 No comments

ID 1480242.1 On Redhat Linux 6 / Oracle Linux 6 (confirmed from 6.3), nslookup has return code "1" after nslookup failure instead of "0": Oracle Linux 6: $ nslookup unknown-not-reachable-nodeServer: 10.35.249.52Address: 10.35.249.52#53** server can't find unknown-not-reachable-node: NXDOMAIN $ echo $?1 Oracle Linux 5: $ nslookup unknown-not-reachable-nodeServer: 10.35.249.52Address: ...