Alex Zaballa - DBA Oracle

PRVF-5300: Failed to retrieve active version for CRS on this node

2011-12-01T08:25:00.000-08:00

cd $GRID_HOME /bin

mv crsctl crsctl.orig

create a script “crsctl” with :

EXEC=/u01/app/oragrid/product/11.2.0.3.0/bin/crsctl.orig
case $1 in
query)
echo "Oracle High Availability Services release version on the local node is [11.2.0.2.0]"
;;
*)
$EXEC $*
;;
esac

OPMN CRASHES IF THE WEBCACHE.PID FILE EXISTS WITH 0 BYTES AND WE START WEBCACHE

2011-09-22T01:19:00.000-07:00

Bug 6447507

In Application Server 10.1.2, if the $ORACLE_HOME/webcache/webcache.pid
file exists but it has 0 bytes and you try to startup the WebCache component
the WebCache component is not started up and opmn processes die, leaving the
other opmn managed processes orphans. A manual kill of them needs to be
performed followed by an opmnctl startall to fix the problem. The problem may
happen if the filesystem where the ORACLE_HOME is hosted gets full.

Solution:
rm $ORACLE_HOME/webcache/*.pid
touch $ORACLE_HOME/webcache/webcache.pid

RME-00020: Internal API error - ORA-01400: cannot insert NULL into ("REPOS_OWNER"."I$SDD_INS"."PAC_REF")

2011-07-02T03:34:00.000-07:00

RME-00020: Internal API error - ORA-01400: cannot insert NULL into ("REPOS_OWNER"."I$SDD_INS"."PAC_REF")
RME-00011: Operation 'ins' on USER_OBJECT_INDEX_STORAGE has failed
RME-00222: Failed to dispatch operation to Repository

Run the Database Design Transformer without creating object implementations:

1) In the Database Design Transformer dialog box,
2) click button 'Settings',
3) in the 'Settings' dialog box,
4) select Database = '(none')
5) Click OK button
6) Click 'Run' button to launch the Database Design Transformer.

How to Stop Getting "Head /Index.Html HTTP/1.1" Messages Every 20 Seconds in Apache access_log

2011-05-27T01:55:00.000-07:00

Change the ping frequency in opmn.xml

Oracle Database XE (Express Edition) 11.2 beta is out!

2011-04-02T03:38:00.000-07:00

http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html

- Express Edition is limited to a single instance on any server
- Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server
- Express Edition may only be used to support up to 11 GB of user data (not including Express Edition system data)
- Express Edition may use up to 1 GB RAM of available memory :(

ORA-00600 [16500] [kqdcru] Running purge dba_recyclebin

2011-03-05T10:16:00.000-08:00

Errors in file /u01/app/oracle/diag/rdbms/aupecdbtest/aupecdbtest/trace/aupecdbtest_ora_27336.trc (incident=281):
ORA-00600: internal error code, arguments: [16500], [kqdcru], [D], [2], [110], [BIN$nFHAOchQTu3gQKjAB2RbGw==$0], [], [], [], [], [], []

Solution

SQL> ALTER SESSION SET NLS_SORT = BINARY;

The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which App...

2011-02-18T08:19:00.001-08:00

The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which Application Server Control is running

ORACLE_HOME/j2ee/oc4j_instance_name/config/system-jazn-data.xml

edit system-jazn-data.xml

find oc4jadmin

replace credentials>!welcome123

restart container

"Demo It To Oracle" (DITO)

2011-02-18T08:17:00.000-08:00

CamStudio is a third party desktop recording software that can be used to "Demo It To Oracle" (DITO).

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocDsrc=KB&viewingMode=1143&bmDocType=REFERENCE&bmDocID=11.1&from=BOOKMARK&bmDocTitle=%22Demo%20It%20To%20Oracle%22%20(DITO)%20-%20CamStudio%20Help))

Ora-01008 - Target 11.2.0.2 - Rman error

2011-02-01T05:17:00.000-08:00

It will be fixed in the 11.2.0.3 Patch Set Release.

Solution:

change cursor_sharing to exact or alter system flush shared_pool;

Get all hidden init parameters in 11G

2010-12-22T05:42:00.000-08:00

create pfile='/tmp/init' from memory;

RG-10758 When Creating Text Index Using File Datastor

2010-12-22T02:47:00.000-08:00

Cause

It is an expected error as the default behavior of the CTX system parameter FILE_ACCESS_ROLE has changed.

Solution

1. (Recommended) Create a new role, grant it to the owners of the impacted indexes, and set file_access_role to the new role.
- or -
2. Set file_access_role to 'public'

To change file_access_role, you must be connected as SYSDBA.

SQL> connect as sysdba
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')

11gR2 – empty tables skipped by export (deferred segment creation)

2010-12-21T04:24:00.000-08:00

http://www.nativeread.com/2010/04/09/11gr2-empty-tables-skipped-by-export-deferred-segment-creation/

Moving to Oracle RAC One Node

2010-12-20T06:41:00.001-08:00

http://www.databasejournal.com/features/oracle/article.php/10893_3906196_1/article.htm

On EL/RH 5 ORACLEASM LISTDISKS not Showing Devices After Reboot or Restart

2010-12-12T07:23:00.001-08:00

ID 558596.1

Cause
The oracleasm scans /proc/partitions and expects devices to be available in /dev. If the device doesn't exist in /dev it will fail to open the device. RHEL/OEL5 does not create dm-xx devices in /dev by default.

Solution
Please comment out the following line in file /etc/udev/rules.d/50-udev.rules

#KERNEL=="dm-[0-9]*", ACTION=="add", OPTIONS+="ignore_device"

reboot and the problem should be gone.

11g Database Installation failed with “File not found .. WFMLRSVCApp.ear”

2010-12-11T07:28:00.000-08:00

If you are installing 11g database and hit error File not found… WFMLRSVCApp.ear, ensure that you have downloaded two disks (for database software) and both disks are unzipped in same folder.

NI cryptographic checksum mismatch error: 12599.

2010-12-09T21:53:00.000-08:00

NI cryptographic checksum mismatch error: 12599 errors in the alert.logs of databases monitored by Oracle Enterprise Manager 11gR1 .

***********************************************************************

NI cryptographic checksum mismatch error: 12599.

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
Time: 10-DEC-2010 06:48:19
Tracing not turned on.
Tns error struct:
ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
ns secondary err code: 2526
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Solution:

Add SQLNET.ENCRYPTION_TYPES_SERVER= (3DES168)to the sqlnet.ora forthe repository database

RA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0

2010-12-09T13:22:00.001-08:00

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/09/2010 22:12:09
ORA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0

Change rman config:

CONFIGURE COMPRESSION ALGORITHM 'HIGH';

Virtual private IP runs on top of the private interface

2010-12-09T11:18:00.000-08:00

Highly Available IP / Redundant Private IP in Oracle Grid Infrastructure 11g Release 2 (11.2.0.2 or above)

http://oraxperts.com/wordpress/?p=142

11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip
[ID 1210883.1]

11GR2 Grid Install fail with NTP error

2010-12-02T07:40:00.000-08:00

Error:

INFO: NTP daemon slewing option check failed on some nodes
INFO: Check failed on nodes:
INFO: racpre2,racpre1
INFO: PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"
INFO: Clock synchronization check using Network Time Protocol(NTP) failed
INFO: PRVF-9652 : Cluster Time Synchronization Services check failed

Solution:

vi /etc/sysconfig/ntpd

OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

Move controlfile to ASM

2010-12-02T07:39:00.000-08:00

Ex:

restore controlfile to '+DG01' from '+fra01/sigfedb/controlfile/current.260.736637371';

After, change database parameter file.

DBCA 11.1.0.7 fail on Grid 11Gr2

2010-12-02T07:37:00.000-08:00

"DBCA could not startup the ASM instance configured on this node. To processd with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"

Apply patch 8288940

Database 11.1.0.7 with 11GR2 Grid

2010-12-02T07:32:00.000-08:00

Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1]

Oracle Validated rpm

2010-11-30T08:17:00.000-08:00

Preparing a Linux box for Oracle Clusterware and RAC installation is made fast and simple with the help of the Oracle Validated Rpm. Downloading and installing the rpm that match you Linux Kernel, automatize the install of the numerous components required to setup OCW and RAC on Linux.

http://blogs.oracle.com/AlejandroVargas/Installing-the-Oracle-Validated-rpm-on-EL5.pdf

KUPW$WORKER.GET_TABLE_DATA_OBJECTS

2010-11-17T07:13:00.000-08:00

ORA-39126: Erro fatal inesperado do processo de trabalho em KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: falha na seguinte instruc?o de SQL:
BEGIN "DMSYS"."DBMS_DM_MODEL_EXP".SCHEMA_CALLOUT(:1,0,1,'11.00.00.00.00'); END;
ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86
ORA-06512: na "SYS.DBMS_METADATA", linha 1245
ORA-04067: n?o executado, package body "DMSYS.DBMS_DM_MODEL_EXP" n?o existe
ORA-06508: PL/SQL: n?o foi possivel encontrar a unidade de programa que esta a ser chamada : "DMSYS.DBMS_DM_MODEL_EXP"

ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86
ORA-06512: na "SYS.KUPW$WORKER", linha 8353

Solution: DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS';

FMW Welcome Page Application (11.1.0.0.) Down

2010-11-15T01:44:00.000-08:00

Bug Title: BROKEN 'FMW WELCOME PAGE APPLICATION' APPLICATION DISCOVERED OUT-OF-BOX

1. Apply patch 6880880 (OPatch utility release 11.1.0.8.3) for ORACLE_COMMON

2. Apply patch 9431704
- Stop OMS
$ cd $ORACLE_BASE/Middleware/oms11g/bin
$ ./emctl stop oms -all
- Unzip patch 9431704
$ cd /home/oracle
$ unzip p9431704_111120_Generic.zip
- Apply patch
$ cd /home/oracle/9431704
$ export $ORACLE_BASE/Middleware/oracle_common
$ $ORACLE_BASE/Middleware/oracle_common/OPatch/opatch apply

3. Restart the OMS
$ $ORACLE_BASE/Middleware/oms11g/bin/emctl start oms

Reset INTERNAL password in APEX

2010-11-01T00:41:00.001-07:00

To change the password for the ADMIN account:

1. Change your working directory to $ORACLE_HOME/apex.
2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
$ sqlplus sys/SYS_password as sysdba
3. Using the following syntax, enter the new password:
> @apxxepwd password

ora-07445 on wwutl_cache_sys.process_background_inval

2010-10-30T12:29:00.000-07:00

Ora-07445 on Job 31 ---> Portal after migrate database to 11G

begin wwutl_cache_sys.process_background_inval; end;

Try recompile utl_http and utl_tcp.

wwsrc_event_q_mgmt.propagate(true); - job broken

2010-10-30T11:18:00.001-07:00

begin
wwsrc_event_q_mgmt.disable_propagation_job;
wwsrc_event_q_mgmt.stop_queue;
wwsrc_event_q_mgmt.drop_queue;
end;

The Upgrade Assistant failed in bringing up the database

2010-10-30T07:17:00.000-07:00

"The Upgrade Assistant failed in bringing up the database . Oracle Home
obtained from file /etc/oratab was used to connect to the database. Either the database is not
running from Oracle Home or the correct Initialization Parameter file (pfile)
was not found."

Try to remove files on:

/u01/app/oracle/cfgtoollogs/dbua

Find the top 10 larger files in the Directory

2010-08-25T04:56:00.000-07:00

$ls -lrt | awk '{print $5,$9}' | sort -nr head | xargs ls -lrt

Check if the installed Oracle Software is 32/64

2010-08-25T04:55:00.000-07:00

Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

Or

select metadata from sys.kopm$ ;

If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit

pam_limits.so setting for 64-bit Linux

2010-08-12T02:39:00.000-07:00

Removing the hardcoded path allows the OS to choose the correct pam_limits.so

/etc/pam.d/login
session required pam_limits.so

DOC ID 301665.1

Problem with Oracle Web Services Manager login

2010-08-10T09:05:00.000-07:00

Change default password admin OWSM

cd $ORACLE_HOME/owsm/bin

vi manageUserGroups.properties

user_id=admin
user_name=admin user
user_password={PASSWORD}
user_email=wsmadmin@xxxx.xxx

group_id=su1-grp
group_desc=super user group

./wsmadmin.sh manageUserGroups deleteUserGroup

./wsmadmin.sh manageUserGroups deleteUser

./wsmadmin.sh manageUserGroups addUser

./wsmadmin.sh manageUserGroups addUserGroup

see the $ORACLE_HOME/j2ee/oc4j_soa/log/ccore.log

Oracle APEX Listener

2010-08-09T08:46:00.000-07:00

http://www.oracle.com/technology/products/database/application_express/apex_listener/apex_listener.html

PDF Printing in Application Express

2010-07-09T09:13:00.001-07:00

http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html

frmwebutil.jar 10.1.2.3.0

2010-05-27T08:57:00.000-07:00

Versão correta se encontra no Patch 7384879.

chgiphost.sh - ELF file data encoding not little-endian

2010-05-26T03:42:00.000-07:00

[oracle@semba scripts]$ ./chgiphost.sh -idm
Oracle Home set to /u01/app/oracle/product/as10g/Infra
Starting Change Hostname/IP...

Change Hostname/IP completed successfully.

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/as10g/Infra/chgip/lib/libpass.so: /u01/app/oracle/product/as10g/Infra/chgip/lib/libpass.so: ELF file data encoding not little-endian
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1511)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:834)
at oracle.chgip.InteractiveInterfaceManager.(InteractiveInterfaceManager.java:72)
at oracle.chgip.InterfaceManager.createInterfaceManager(InterfaceManager.java:133)
at oracle.chgip.InterfaceManager.getInterfaceManager(InterfaceManager.java:113)
at oracle.chgip.Session.(Session.java:97)
at oracle.chgip.StartUp.main(StartUp.java:250)

Cause

There is a bug in the 10.1.2.3 patchset with the libpass.so file, as an incorrect library was included in the patchset media. Bug 7000666 has been filed for this.

Solution

Download and install Patch 7000666 for Linux x86

OracleAS 10.1.3 AS Control Home Page is Very Slow to Appear

2010-05-20T07:38:00.000-07:00

Find a trace file in Oracle 11g

2010-04-15T09:19:00.000-07:00

SELECT value
FROM v$diag_info
WHERE name = 'Default Trace File';

"configuration for DISK channel n is ignored"

2010-04-10T11:41:00.000-07:00

CONFIGURE CHANNEL N DEVICE TYPE DISK CLEAR;

Oracle Designer - ORA-7445 when deleting an object from the Repository

2010-03-11T00:59:00.000-08:00

Metalink Doc Id:578441.1

Workaround is:

alter system set "_optimizer_cost_based_transformation"=off scope=both;

or create on logon trigger for designer users to alter the session, for
example:
create or replace trigger .on_logon
after logon on database
begin
execute immediate 'alter session set
"_optimizer_cost_based_transformation"=off';
end;

Oracle Application Development Tools Statement of Direction: Oracle Forms, Oracle Reports and Oracle Designer

2009-11-24T00:15:00.000-08:00

http://www.oracle.com/technology/products/forms/pdf/10g/ToolsSOD.pdf

Invalid Objects After Removing OLAP or Migration of a Database to 64 Bit

2009-11-21T04:24:00.000-08:00

Doc Id: 565773.1

-> conn / as sysdba
SQL> @?/olap/admin/catnoamd.sql
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/catnoxoq.sql

Determine all PUBLIC synonyms referring to objects in the OLAPSYS schema:

SQL>spool olapdrop.sql
SQL> select 'drop public synonym ' || synonym_name || ';'
from dba_synonyms
where owner='PUBLIC' and table_owner='OLAPSYS';
SQL>spool off

Modify the datapump handler table to remove handlers used to export OLAP data:

SQL>select * from sys.exppkgact$ where package = 'DBMS_AW_EXP' and
schema= 'SYS';
SQL>delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'
and schema= 'SYS';
SQL>commit;

PL/SQL Web - File Upload and Download Procedures

2009-11-19T09:33:00.001-08:00

http://www.oracle-base.com/articles/9i/FileUploadDownloadProcedures9i.php

Oradebug - Diagnosing Library Cache Latch Contention

2009-11-12T06:56:00.000-08:00

http://arup.blogspot.com/2008/08/diagnosing-library-cache-latch.html

RAC One Node tips

2009-11-09T05:39:00.001-08:00

http://www.dba-oracle.com/t_rac_one_node.htm

Oracle Enterprise Manager Desktop Widgets

2009-11-09T03:06:00.001-08:00

http://blogs.oracle.com/emwidgets/

String Aggregation Techniques

2009-10-28T10:55:00.001-07:00

http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php

Database Point in Time Recovery failed ORA-01841

2009-10-28T04:16:00.000-07:00

Doc ID: 370500.1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/10/2006 11:43:56
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'MAY 10 2006 06:40:04'
ORA-01841 (full) year must be between -4713 and +4713 / +9999 and must not be 0

Cause

o NLS_LANG was not set (empty)

Solution
To implement the solution, please execute the following steps:

1. Set Environemnt Variable for example:

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
echo $NLS_LANG

Problem : iAS Discovery/Monitoring Fails If Agent Is Installed Under Another OS User Than iAS

2009-10-28T01:50:00.000-07:00

Doc ID: 437078.1

cd $IAS_HOME
chmod g+rx $IAS_HOME
chmod g+rx $IAS_HOME/bin
chmod g+rx $IAS_HOME/bin/emtgtctl
chmod ug+s $IAS_HOME/bin/emtgtctl2

chmod g+rx $IAS_HOME/perl
chmod g+rx $IAS_HOME/perl/bin
chmod g+rx $IAS_HOME/perl/bin/perl

chmod g+rx $IAS_HOME/sysman
chmod g+rx $IAS_HOME/sysman/emd
chmod g+rw $IAS_HOME/sysman/emd/targets.xml
touch $IAS_HOME/sysman/emd/centralagents.lst
chmod g+rw $IAS_HOME/sysman/emd/centralagents.lst

chmod g+rx $IAS_HOME/sysman/config
chmod g+rw $IAS_HOME/sysman/config/*.properties

chmod g+rx $IAS_HOME/opmn
chmod g+rx $IAS_HOME/opmn/conf
chmod g+rw $IAS_HOME/opmn/conf/opmn.xml

chmod g+rx $IAS_HOME/config
chmod g+rw $IAS_HOME/config/*.xml
chmod g+rw $IAS_HOME/config/*.properties

chmod g+rx $IAS_HOME/Apache
chmod g+rx $IAS_HOME/Apache/Apache
chmod g+rx $IAS_HOME/Apache/Apache/conf
chmod g+rw $IAS_HOME/Apache/Apache/conf/*.conf
chmod g+rw $IAS_HOME/Apache/Apache/conf/*.xml
chmod g+rw $IAS_HOME/Apache/Apache/conf/mime.types

For each OC4J (in this example OC4J_SECURITY):
chmod g+rx $IAS_HOME/j2ee
chmod g+rx $IAS_HOME/j2ee/OC4J_SECURITY
chmod g+rx $IAS_HOME/j2ee/OC4J_SECURITY/config
chmod g+rw $IAS_HOME/j2ee/OC4J_SECURITY/config/*

chmod g+rx $IAS_HOME/dcm
chmod g+rx $IAS_HOME/dcm/config
chmod g+rw $IAS_HOME/dcm/config/*.conf
chmod g+rw $IAS_HOME/dcm/config/*.xml

Oracle Database 11g Release 2 New Features Summary

2009-10-27T07:25:00.000-07:00

http://www.dbasupport.com/oracle/ora11g/11gR2-new-features-01.shtml

Linux Error: 104: Connection reset by peer when starting Oracle Listener

2009-10-16T07:52:00.000-07:00

Make sure the loopback entry in /etc/hosts is not missing when you start the listener:

127.0.0.1 localhost.localdomain localhost

What happens during oracle database hot backup

2009-10-16T02:51:00.001-07:00

http://arjudba.blogspot.com/2009/08/what-happens-during-oracle-database-hot.html

Scheduler Enhancements in Oracle Database 11g

2009-10-15T03:21:00.000-07:00

Scheduler Enhancements in Oracle Database 11g Release 1
http://www.oracle-base.com/articles/11g/SchedulerEnhancements_11gR1.php

Scheduler Enhancements in Oracle Database 11g Release 2
http://www.oracle-base.com/articles/11g/SchedulerEnhancements_11gR2.php

Remote Scheduler Agent Installation for Oracle 11g Release 2
http://www.oracle-base.com/articles/11g/SchedulerAgentInstallation_11gR2.php

Monitorando o progresso do RMAN

2009-10-14T03:34:00.000-07:00

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;

ORA-28112 (select * from mgmt_targets)

2009-10-14T02:27:00.000-07:00

grant exempt access policy to USER;

Metalink DOC ID: 778864.1

Migrating a Microsoft SQL Server Database to Oracle Database 11g

2009-10-14T02:26:00.000-07:00

http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

Fine Grained Dependency (11G)

2009-10-14T02:24:00.000-07:00

Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL.

In previous releases, object dependencies were managed at the object level, so altering an object automatically invalidated all dependent objects. Oracle 11g has more granular dependency management, so only changes that directly affect an object will cause an invalidation.

http://www.oracle-base.com/articles/11g/EnhancedFinerGrainedDependencyManagement_11gR1.php

http://www.oraclebrains.com/2007/09/plsql-fine-grained-dependency-tracking/

http://ocpdba.wordpress.com/2009/03/05/a-new-paradigm-oracle-11gs-feature-for-context-objects-invalidation-coi/

Moving ASM Database Files from one Diskgroup to Another

2009-10-14T02:23:00.000-07:00

http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml

Delete the old ASM database file from its original location

2009-10-14T02:22:00.000-07:00

$ ORACLE_SID=+ASM; export ORACLE_SID

$ sqlplus "/ as sysdba"

SQL> ALTER DISKGROUP TESTDB_DATA2 DROP FILE '+TESTDB_DATA2/testdb/datafile/app_data.256.598127837';

http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml

Resetting the Administrator (oc4jadmin) Password

2009-10-14T02:19:00.000-07:00

1 - Stop OC4J and the Application Server Control.

2 - Locate and open the following file in a text editor:

(UNIX)ORACLE_HOME/j2ee/home/config/system-jazn-data.xml

3 - Locate the line that defines the credentials property for the oc4jadmin user.

{903}4L50lHJWIFGwLgHXTub7eYK9e0AnWLUH

4 - Replace the existing encrypted password with the new password.

!mynewpassword123

5 - Delete cached password data by deleting the contents of the following directory:

ORACLE_HOME/j2ee/oc4jinstance/persistence/ascontrol/ascontrol/securestore/

6 - Start OC4J and the Application Server Control.

http://download-west.oracle.com/docs/cd/B31017_01/core.1013/b28940/trouble_asc.htm#BCEDHFEI

Oracle's Block Browser and Editor tool

2009-09-30T04:33:00.000-07:00

Oracle's Block Browser and Editor tool

http://www.dbasupport.com/oracle/ora10g/bbed.shtml

http://www.dbasupport.com/oracle/ora10g/bbed02.shtml

Tuning Reports Server Configuration

2009-09-29T03:28:00.001-07:00

<'engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="10" maxEngine="150" minEngine="10" engLife="50" maxIdle="30" callbackTimeOut="60000" engineResponseTimeOut="60" jvmOptions="-Xms128m -Xmx1024m">

Mais detalhes em:

http://download-west.oracle.com/docs/cd/B14099_17/bi.1012/b14048/pbr_tune.htm#i1006609

Result Cache - PL/SQL 11G

2009-09-29T03:05:00.001-07:00

“Result Cache” é uma feature do 11g que possibilita manter o resultado de uma função em CACHE.
Muito útil, por exemplo, para funções que são constantemente utilizadas pelas aplicações.

Mais detalhes em:

http://www.oracle.com/technology/oramag/oracle/07-sep/o57asktom.html

http://www.oracle.com/technology/oramag/oracle/07-sep/o57plsql.html

http://www.oracle-base.com/articles/11g/CrossSessionPlsqlFunctionResultCache_11gR1.php

Response-Time Analysis

2009-09-25T08:18:00.000-07:00

http://www.oracle.com/technology/pub/articles/schumacher_analysis.html

Oracle licensing

2009-09-24T01:31:00.000-07:00

http://www.orafaq.com/wiki/Oracle_licensing

ORA-24247 When Executing UTL_HTTP

2009-09-23T10:37:00.000-07:00

When executing UTL_INADDR (or) UTL_HTTP (or) any UTL packages after upgrading to 11gR1, fails with following error:


declare
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-6512: at "SYS.UTL_HTTP", line 1029
ORA-24247: network access denied by access control list (ACL)
ORA-6512: at line 6

Utilizar a package

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE para atribuir privilégios de connect e resolve ao usuário.


Mais detalhes em :

 Metalink Doc ID: 453786.1

Copiando as senhas de uma base LDAP para outra

2009-09-23T10:28:00.000-07:00

ldapsearch -h 192.168.244.131 -p 389 -D "cn=orcladmin" -w PASSWORD -L -b "cn=users,dc=oracle,dc=com,dc=br" -s sub "objectclass=*" userpassword > portal_users.ldif

exemplo de arquivo gerado:

dn: cn=alex.zaballa,cn=users,dc=oracle,dc=com,dc=br
userpassword: {SHA}BnaRkBbuGYJWeIxqI25m075ZBs0=

alterar o arquivo da seguinte forma:

dn: cn=alex.zaballa,cn=users,dc=oracle,dc=com,dc=br
changetype: modify
replace: userpassword
userpassword: {SHA}BnaRkBbuGYJWeIxqI25m075ZBs0=

Aplicar alterações:

ldapmodify -h 192.168.245.131 -p 389 -D "cn=orcladmin" -w PASSWORD -f portal_users.ldif

Integração do Application Server 10.1.3 com SSO

2009-09-23T10:17:00.000-07:00

http://download.oracle.com/docs/cd/B32110_01/core.1013/b32196/reconfig.htm#BHCIAJIF

Oracle Portal com Database 11g

2009-09-23T10:15:00.000-07:00

How to upgrade the Portal Database to 11g?

Metalink
Doc ID: 465968.1

Master Note for OracleAS Portal Upgrade Issues

Metalink
Doc ID: 262623.1

How to Add a Watermark to Oracle Reports PDF Output

2009-09-23T10:11:00.000-07:00

Documento que mostra como adicionar uma marca d'agua nos relatórios.

Metalink Doc ID: 400817.1

Beehive + Linux + Portas Baixas

2009-09-23T10:07:00.000-07:00

Uso de portas baixas no Beehive:

chown root hasbind
chmod a+x hasbind
chmod a+s hasbind

/etc/cap.ora
+user user1: bind port 20
+user user1: bind port 21
+user user1: bind port 23
+user user1: bind port 80
+user user1: bind port 25
+user user1: bind port 443
+user user1: bind port 143
+user user1: bind port 993
+user user1: bind port 465

Para poder utilizar o Apache na porta 443:

chown root .apachectl
chmod a+x .apachectl
chmod a+s .apachectl

Exemplo de mudança de porta do SMTP no Beehive:

beectl modify_port --protocol SMTP --port 25

beectl activate_configuration

Beehive + Imap + SSL

2009-09-23T10:04:00.000-07:00

Para "colocar" um certificado digital para oIMAP no Beehive, basta alterar a propriedade WalletDir, apontando para o caminho está está seu Wallet.

beectl list_property --component beehive_instance_OrionInstance.your_domain.com --name WalletDir

beectl modify_property --component beehive_instance_OrionInstance.your_domain.com --name WalletDir --value /u01/app/oracle/product/1.5.1.0.0/beehive/Apache/Apache/conf/ssl.wlt/portal/

beectl activate_configuration

Adicionar um email externo a um grupo de Emails do Beehive

2009-09-23T09:51:00.001-07:00

Infelizmente até a versão 1.5 do Beehive, não é possível adicionar um email externo a um grupo de emails utilizando o Beekeeper.

Existe uma solução via Beectl:

add_external_contact --family_name Silva --display_name "Joao da Silva" --address BUSINESS_1:mailto:joao.silva@yourdomain.com

Criar um arquivo xml com estrutura conforme a imagem:

beectl modify_group --file yourxmlname.xml

Consultando os membros do grupo:

beectl list_groups --name EMPRESA --show MEMBERS

Proxy Reverso + Application Server + Ip errado nos logs

2009-09-23T09:48:00.000-07:00

Para quem utiliza solução de proxy reverso juntamente com application server, já deve ter tido problemas com os logs. O IP que aparece é o do Proxy e não de quem fez a requisição HTTP.

Segue uma solução encontrada para o problema:

Criar o arquivo AdjustRemoteAddrAccordingToHeader.pm

package Apache::AdjustRemoteAddrAccordingToHeader;

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;

Adicionar no httpd.conf

PerlRequire /u01/app/oracle/product/as10g/MidTier/Apache/Apache/conf/AdjustRemoteAddrAccordingToHeader.pm
PerlPostReadRequestHandler Apache::AdjustRemoteAddrAccordingToHeader
PerlSetVar UseIPFromHeader X-Forwarded-For

Installing Oracle Enterprise Manager 10g Grid Control Rel 5 on Oracle Database 11g and Linux

2009-09-23T09:47:00.000-07:00

Passo-a-passo interessante para instalação do GRID Versão 10.2.0.5 em um banco 11G.

http://www.oracle.com/technology/pub/articles/revitt-oem.html

Converting Your Oracle Forms Applications to Application Express 3.2

2009-09-23T09:35:00.001-07:00

Artigo interessante para quem já trabalhou com o bom e velho FORMS.

http://www.oracle.com/technology/obe/apex32/apex32frmmigr.htm

BULK COLLECT

2009-09-23T09:34:00.001-07:00

Artigo interessante sobre o uso da cláusula LIMIT.

http://www.oracle.com/technology/oramag/oracle/08-mar/o28plsql.html

Oracle Audit

2009-09-23T07:32:00.000-07:00

Como muitos DBA's, também gosto de guardar meus LOG's de auditoria dentro do banco de dados.

Para isso, o primeiro passo é criar uma tablespace que irá manter os logs (Isto server apenas para não inflar a tablespace System).

CREATE TABLESPACE TBSDAT_AUDITORIA DATAFILE SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE 8192M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

select TABLESPACE_NAME from dba_segments where SEGMENT_NAME='AUD$'
Para alterar a tablespace, podemos proceder de 2 formas, dependendo da versão do banco de dados.

Utilizar a package DBMS_AUDIT_MGMT ou o script que está no DOC ID: 1019377.6

BEGIN
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION( AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,AUDIT_TRAIL_LOCATION_VALUE => 'TBSDAT_AUDITORIA');
END;

select TABLESPACE_NAME from dba_segments where SEGMENT_NAME='AUD$'

Metalink - DOC ID: 804624.1
The associated LOB and LOB INDEX segments for AUD$ are not moved from the SYSTEM tablespace when the AUD$ table is moved to another tablespace using the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION procedure.

select owner,table_name,segment_name,tablespace_name from dba_lobs where table_name='AUD$'
select owner, table_name,index_name,index_type,tablespace_name from dba_indexes where table_name='AUD$'

alter table aud$ move lob (sqlbind) store as (tablespace TBSDAT_AUDITORIA);
alter table aud$ move lob (sqltext) store as (tablespace TBSDAT_AUDITORIA);

Finalmente alterar o parâmetro de inicialização:

alter system set audit_trail=db scope=spfile;

"Jogar" uma tablespace para o ASM

2008-03-31T18:29:00.000-07:00

Dentro do RMAN:

sql "alter tablespace MGMT_ECM_DEPOT_TS offline";

backup as copy tablespace MGMT_ECM_DEPOT_TS format '+DGGRIDDBDES';

switch tablespace MGMT_ECM_DEPOT_TS to copy;

sql "alter tablespace MGMT_ECM_DEPOT_TS online";

exit;

2008-03-31T18:26:00.000-07:00

2008-02-28T01:50:00.001-08:00

TNSNAMES + ASM + BLOCKED

2008-02-09T11:26:00.000-08:00

Alteração no TNS para conseguir acessar uma instância ASM:

ASM1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = +ASM) (INSTANCE_NAME =+ASM1)
(UR=A)
)
)

2007-11-19T05:35:00.000-08:00

Não finaliza o serviço do banco no Red Hat

2007-11-08T09:47:00.000-08:00

Verificar se existem as linhas abaixo nos scripts de stop e start do oracle /etc/init.d/oracle

start
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/oracle

stop
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/oracle

2007-11-08T00:02:00.000-08:00

2007-11-01T09:33:00.000-07:00

2007-11-01T09:30:00.000-07:00

Instalar idioma "Português" no Oracle Portal

2007-10-08T10:44:00.000-07:00

Executar da Mid:

./ptllang.sh -i custom -s portal -sp password -c hostname:1521:servicename -lang pt

Rotacionar ssl_request_log

2007-10-08T10:43:00.001-07:00

Modificar no ssl.conf:

CustomLog "|/u01/OraMid10g/Apache/Apache/bin/rotatelogs /u01/OraMid10g/Apache/Apache/logs/ssl_request_log 43200" "%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" %b"

2007-07-20T08:26:00.000-07:00

2007-07-19T03:42:00.001-07:00

IE 7/8 and Firefox + FORMS + Crash

2007-07-19T03:39:00.000-07:00

Para resolver este problema, basta copiar o arquivo jvm.dll da sua JRE para o diretório hotspot do Jinitiator.

Ex:
De:
C:\Program Files\Java\jre1.6.0_05\bin\client
Para:
C:\Program Files\Oracle\JInitiator 1.3.1.28\bin\hotspot

connect and ORA-06553: PLS-801: internal error [56319] , After i duplicate database from 64bits to 32bits

2007-07-02T10:58:00.001-07:00

sql>connect / as sysdba
sql>shutdown immediate;
sql>startup migrate;
sql> @$ORACLE_HOME/rdbms/admin/utlirp.sql
sql>shutdown immediate;
sql> startup
sql>
sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql
sql> connect system/password

TO_CHAR + NLS

2007-04-28T10:17:00.000-07:00

select to_char(sysdate,'MONTH','NLS_DATE_LANGUAGE = PORTUGUESE') from dual

2007-04-25T09:22:00.000-07:00

2007-04-18T10:51:00.000-07:00

2007-04-17T08:33:00.001-07:00

2007-04-17T08:30:00.000-07:00

2007-04-17T08:28:00.000-07:00