Keep track of changed using bash-git-prompt

Great tool to help figure out what still needs to be added , updated or uploaded to your git repo. ✔ ~/cookbooks/nom_oracle_role [master ↓·1|✔] ✔ ~/cookbooks/nom_oracle_role [master L|✔] ✔ ~/cookbooks/nom_oracle_role […]

Quick how to use LogMiner

Just as a quick note to myself, this is how i used Logminer before to retrieve detailed information on who did what from which machine. Before you can really lookup […]

Use RESTORE POINT with Flashback Database

When automating your way through releases and want to have a way to rollback if needed. It might be wise to use flashback database as a method to create a […]

Easy setup guide EM Express formally known as DB Console

Configure Dispatcher SQL> alter system set dispatchers='(PROTOCOL=TCP) (SERVICE=NOMT1XDB)’ SCOPE=both; Configure XDB Listener For HTTP SQL> exec dbms_xdb_config.sethttpport(8080); FOR HTTPS SQL> exec dbms_xdb_config.sethttpsport(5500); Set the XDB to allow local and remote […]

Oracle Direct NFS Setup

Here is a quick setup quide for Direct NFS Enable / Disable DNFS for your Database Enable mv libodm11.so libodm11.so_stub ln -s $ORACLE_HOME/lib/libnfsodm11.so $ORACLE_HOME/lib/libodm11.so Disable rm $ORACLE_HOME/lib/libodm11.so mv libodm11.so_stub libodm11.so […]

Cleanup Oracle Incident using ADRCI

Login ADRCI [oracle@nomtdb1 NOMT1 incident]$ adrci ADRCI: Release 11.2.0.3.0 – Production on Fri Sep 28 17:57:06 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base […]

grant select rights to views and tables for role

Here is a simple script to grant select on all tables and views under the selected schema’s ‘APPOWNER1’ , ‘APPOWNER2’ and grant them to ‘APPS_READ_ROLE’ set serveroutput on size 1000000 […]

Reset EXPIRED GRACE to OPEN with same password hash

Quick note on how to reset a user / application user to use the same password. SQL> select USERNAME ,ACCOUNT_STATUS from dba_users where username like ‘NOM_U_BACK’; USERNAME |ACCOUNT_STATUS ———–|————————— NOM_U_BACK […]

RMAN backup is killed on RHEL 4 with Out of Memory message

RMAN seems to run fine , but after some time the process is aborted. input datafile fno=00058 name=/u02/oradata/YD001/USR08.dbf input datafile fno=00061 name=/u02/oradata/YD001/IDX13.dbf input datafile fno=00070 name=/u02/oradata/YD001/USR17.dbf input datafile fno=00082 name=/u02/oradata/YD001/USR20.dbf […]

Online add disk to VMware Linux guest

When adding a new disk to a VMware Linux guest, you won’t see the disk using “fdisk -l” without rebooting the system. This is in most cases not preferable , […]