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

quarta-feira, 29 de maio de 2013

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

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.

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

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

How to Configure Oracle Portal 11g with Reverse Proxy SSL

08:52 No comments

MOS ID: 1119068.1

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

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

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 FORMSREPORTSDOMAIN=$MIDDLEWARE_HOME/user_projects/domains/PortalDomain
export WEBLOGICINSTANCE=$MIDDLEWARE_HOME/asinst_1

echo "Starting AdminServer"
nohup $FORMSREPORTSDOMAIN/startWebLogic.sh >/dev/null 2>/dev/null &

echo "Starting WLS_PORTAL"

nohup $FORMSREPORTSDOMAIN/bin/startManagedWebLogic.sh WLS_PORTAL >/dev/null 2>/dev/null &

echo "Starting WLS_FORMS"

nohup $FORMSREPORTSDOMAIN/bin/startManagedWebLogic.sh WLS_FORMS >/dev/null 2>/dev/null &

echo "Starting WLS_REPORTS"

nohup $FORMSREPORTSDOMAIN/bin/startManagedWebLogic.sh WLS_REPORTS >/dev/null 2>/dev/null &

echo "Starting OPMN managed components"

$WEBLOGICINSTANCE/bin/opmnctl startall

---------------------------------------------------------------------------------------------------

Stop:

export MIDDLEWARE_HOME=/u01/app/oracle/product/Middleware

export FORMSREPORTSINSTANCE=/u01/app/oracle/product/Middleware/as_portal

export FORMSREPORTSDOMAIN=$MIDDLEWARE_HOME/user_projects/domains/PortalDomain

export WEBLOGICINSTANCE=$MIDDLEWARE_HOME/asinst_1

$WEBLOGICINSTANCE/bin/opmnctl stopall

nohup $FORMSREPORTSDOMAIN/bin/stopManagedWebLogic.sh WLS_PORTAL >/dev/null 2>/dev/null &

nohup $FORMSREPORTSDOMAIN/bin/stopManagedWebLogic.sh WLS_FORMS >/dev/null 2>/dev/null &

nohup $FORMSREPORTSDOMAIN/bin/stopManagedWebLogic.sh WLS_REPORTS >/dev/null 2>/dev/null &

nohup $FORMSREPORTSDOMAIN/bin/stopWebLogic.sh >/dev/null 2>/dev/null &

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

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

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-2/

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-node
Server: 10.35.249.52
Address: 10.35.249.52#53** server can't find unknown-not-reachable-node: NXDOMAIN
$ echo $?
1

Oracle Linux 5:

$ nslookup unknown-not-reachable-node
Server: 10.35.249.52
Address: 10.35.249.52#53** server can't find unknown-not-reachable-node: NXDOMAIN
$ echo $? 0

Oracle is pleased to announce the general availability of the Oracle RDBMS Server 11gR2 Pre-Install RPM for Oracle Linux 6 x86_64 (64 Bit) architecture.

This package replaces the previous Oracle Validated RPM

https://oss.oracle.com/pipermail/el-errata/2012-March/002727.html

quarta-feira, 29 de maio de 2013

sábado, 18 de maio de 2013

quarta-feira, 17 de abril de 2013

quinta-feira, 21 de março de 2013

terça-feira, 19 de março de 2013

terça-feira, 12 de março de 2013

segunda-feira, 4 de março de 2013

quarta-feira, 13 de fevereiro de 2013

segunda-feira, 11 de fevereiro de 2013

terça-feira, 5 de fevereiro de 2013

quarta-feira, 30 de janeiro de 2013

To add an index to an existing attribute:

terça-feira, 29 de janeiro de 2013

sexta-feira, 25 de janeiro de 2013

quinta-feira, 1 de novembro de 2012

quinta-feira, 25 de outubro de 2012

terça-feira, 16 de outubro de 2012

terça-feira, 25 de setembro de 2012

quarta-feira, 19 de setembro de 2012

quinta-feira, 13 de setembro de 2012

quarta-feira, 12 de setembro de 2012

quarta-feira, 5 de setembro de 2012

Translate

DISCLAIMER

Oracle ACE Program

Certificações

OraWorld

Sou Articulista

Sou Articulista

Arquivo do blog

Total de visualizações de página

Sobre