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

segunda-feira, 29 de julho de 2013

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

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

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