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

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

Read More

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

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.

Read More

Limpando o cache no OBIEE11G

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' );

Read More

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

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

Read More

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

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.

Read More