http://www.oracle-base.com/articles/10g/StringAggregationTechniques....
quarta-feira, 28 de outubro de 2009
Database Point in Time Recovery failed ORA-01841
09:16
1 comment
Doc ID: 370500.1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 05/10/2006 11:43:56RMAN-11003: failure during parse/execution of SQL statement: alter database recover if neededstart until time 'MAY 10 2006 06:40:04'ORA-01841 (full) year must be between -4713 and +4713 / +9999 and must not be 0Causeo NLS_LANG was not set (empty)SolutionTo implement...
Problem : iAS Discovery/Monitoring Fails If Agent Is Installed Under Another OS User Than iAS
06:50
No comments
Doc ID: 437078.1cd $IAS_HOMEchmod g+rx $IAS_HOMEchmod g+rx $IAS_HOME/binchmod g+rx $IAS_HOME/bin/emtgtctlchmod ug+s $IAS_HOME/bin/emtgtctl2chmod g+rx $IAS_HOME/perlchmod g+rx $IAS_HOME/perl/binchmod g+rx $IAS_HOME/perl/bin/perlchmod g+rx $IAS_HOME/sysmanchmod g+rx $IAS_HOME/sysman/emdchmod g+rw $IAS_HOME/sysman/emd/targets.xmltouch $IAS_HOME/sysman/emd/centralagents.lstchmod g+rw $IAS_HOME/sysman/emd/centralagents.lstchmod g+rx $IAS_HOME/sysman/configchmod g+rw $IAS_HOME/sysman/config/*.properties chmod g+rx $IAS_HOME/opmnchmod g+rx $IAS_HOME/opmn/confchmod...
terça-feira, 27 de outubro de 2009
sexta-feira, 16 de outubro de 2009
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 localh...
quinta-feira, 15 de outubro de 2009
Scheduler Enhancements in Oracle Database 11g
07:21
No comments
Scheduler Enhancements in Oracle Database 11g Release 1http://www.oracle-base.com/articles/11g/SchedulerEnhancements_11gR1.phpScheduler Enhancements in Oracle Database 11g Release 2http://www.oracle-base.com/articles/11g/SchedulerEnhancements_11gR2.phpRemote Scheduler Agent Installation for Oracle 11g Release 2http://www.oracle-base.com/articles/11g/SchedulerAgentInstallation_11gR2....
quarta-feira, 14 de outubro de 2009
Monitorando o progresso do RMAN
07:34
No comments
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"FROM V$SESSION_LONGOPSWHERE OPNAME LIKE 'RMAN%'AND OPNAME NOT LIKE '%aggregate%'AND TOTALWORK != 0AND SOFAR <> TOTALWO...
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....
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...
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.sh...
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.sh...
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.xml3 - Locate the line that defines the credentials property for the oc4jadmin user.{903}4L50lHJWIFGwLgHXTub7eYK9e0AnWLUH4 - Replace the existing encrypted password with the new password.!mynewpassword1235 - 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...
