Oracle shrink datafiles to reclaim space

worth using below or You can use TOAD if you have it installed.

select value from v$parameter where name = 'db_block_size'
/
set lines 300 pagesize 1000;
select 'alter database datafile '''||file_name||''' resize ' ||
ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd
from dba_data_files a,
( select file_id, max(block_id+blocks-1) hwm
from dba_extents
group by file_id ) b
where a.file_id = b.file_id(+)
and a.file_name like '+AMPCDP_DATA_01%'
and ceil( blocks*&&blksize/1024/1024) -
ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0
/

Change listener log

UNIX> cd /u0001/oracle/product/10.2.0/network/log
UNIX> lsnrctl set log_status off
UNIX> mv listener.log listener.old
UNIX> lsnrctl set log_status on

Exclude tablespace in a backup

For example, you can exclude testing tablespaces cwmlite and example from whole
database backups as follows:
CONFIGURE EXCLUDE FOR TABLESPACE DATA_01;
CONFIGURE EXCLUDE FOR TABLESPACE INDEX_01;
BACKUP DATABASE;

If you run the above command, then RMAN backs up all tablespaces in the database except DATA_01 and INDEX_01:

OPatch lsinventory hang

OPatch lsinventory just hangs:

recent changes : cloned from RAC to stand alone server.

One of the things we forgot after cloning is making changes in the ORACLE_HOME inventory file:

test case:

export OPATCH_DEBUG=TRUE
$opatch lsinventory -all

shows the old Oracle server names:


Rac::getInstance(): local node is "ourdbdrdb01cdc"
Rac::getRemoteNodes()
No cmd. arg. given, return clusterNodes detected as remoteNodes.
Remote nodes excluding local node:
"ourdbprdb01cdp""ourdbprdb02cdp""ourdbprdb03cdp" <==== these are prod server names still reflecting on the DEV lsinventory:
Rac::isCFS()


So removed the cluster_info from the below file: (backup the file before making any changes)

$ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml






Reran the opatch after removing the cluster info from xml file and it succeeded this time..





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

OPatch succeeded.


or you can do this using the runInstaller.

PMP --9 Knowledge areas

Quick way to remember the 9 knowledge areas in PMP.

THICQ-CRSP  ( Also called " Thick Crisp ")

ofcourse they are not in order.. Just to remember what are all the areas that actually exists.

1. Project Time Management - ensure timely completion of the project.
2. Project Human Resource Management - to make the most effective use of the people involved with the project
3. Project Integration Management - various elements of the project are properly coordinated.
4. Project Cost Management - completed within the approved budget.
5. Project Quality Management - project will satisfy the needs for which it was undertaken 
6. Project Communications Management - to ensure timely and appropriate generation, collection, dissemination,Storage, and ultimate disposition of project information.
7. Project Risk Management - identifying, analyzing, and responding to project risk. 
8. Project Scope Management - includes all the work required, to complete the project successfully.
9. Project Procurement Management - to acquire goods and services from outside the performing organization.