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

quarta-feira, 28 de outubro de 2009

String Aggregation Techniques

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

Database Point in Time Recovery failed ORA-01841

09:16 1 comment

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

06:50 No comments

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

12:25 No comments

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

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

11:52 No comments

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

06:51 No comments

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

Scheduler Enhancements in Oracle Database 11g

07:21 No comments

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

07:34 No comments

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)

06:27 No comments

grant exempt access policy to USER;

Metalink DOC ID: 778864.1

Migrating a Microsoft SQL Server Database to Oracle Database 11g

06:26 No comments

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

Fine Grained Dependency (11G)

06:24 No comments

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

06:23 No comments

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

Delete the old ASM database file from its original location

06:22 No comments

$ 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

06:19 No comments

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