Monday, June 29, 2009

OEM Backup Notification

›
If Backup is failed or stop then i will get notification Steps : - Open a database target (SNS0910) - Click on User-Defined-Metrics - Create...
Saturday, June 27, 2009

OEM Backup Error Solution

›
OEM Backup Error -------------------- Recovery Manager: Release 10.2.0.3.0 - Production on Sat Jun 27 11:24:24 2009 Copyright (c) 1982, 2005...
Tuesday, June 23, 2009

ORACLE EXPORT/IMPORT UTILITY - DATA PUMP

›
==================ROLES====================================== SQLPLUSW sys/linux@sns0910srv as sysdba; create user dpuser identified by dpus...
Friday, June 19, 2009

Configure Oracle E-MAIL notification for DB shutdown or startup events Manually

›
Configure Oracle E-MAIL notification for DB shutdown or startup events Manually conn sys/linux@sns0910srv as sysdba @E:\oracle\product\10.2....
Tuesday, June 9, 2009

Oracle 10g Data Guard

›
Oracle 10g Data Guard Oracle Data Guard ensures high availability, data protection, and disaster recovery f...

Oracle- OEM - Export Database / Table / Schema / Tablespace (Data Pump)

›
1) user: snsexport passowrd:snsexp role:exp_full_database 2) Now Try to export database by login above user Errors: ORA-31626: job does not ...

Oracle - Create Standby / Duplicate / Test / Development / Clone Database

›
Steps to restore RMAN backup to different host, for example, RMAN backup from Production server to Test server. Presumptions * Productio...
Saturday, June 6, 2009

Spool To Excel and Html

›
SPOOL to EXCEL set head off; set feed off; set trimspool on; set linesize 32767; set pagesize 32767; set echo off; set termout off; Spool c:...
Friday, June 5, 2009

OEM OS Host Credentials (User Authenication Error)

›
OEM OS Host Credentials (User Authenication Error) Validation Error - Connection to host as user kgupta2 failed: ERROR: Wrong password for u...
Tuesday, June 2, 2009

Oracle-Rename database User

›
Rename Oracle Database User 1) exp owner=kgupta2 2) create user kshitij identified by rakesh; 3) DROP USER kgupta2 CASCADE; 4) imp FROMUSER=...

Oracle- Rename Database

›
Rename the Oracle Database 1) Full Database Backup 2) conn SYS/ORACLE AS SYSDBA 3) ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS; 4) ...
Saturday, May 23, 2009

ORacle - Change SID name after Creating Database

›
Change SID name after Creating Database Recreate the Control file to achieve this . 1. SVRMGR>Alter Database backup controlfile to trace;...
Friday, May 22, 2009

Oracle DB Data Dictionary Views

›
select * from DICTIONARY; use following query from sys user select kqfvinam name from x$kqfvi order by kqfvinam; select * from PUBLICSYN whe...

Sql Server System Stored Procedures

›
Sql Server System Stored Procedures --provide list of all database objects exec sp_help --provide list of all columns , there datatype and s...

SQL Server DBCC (DataBase Console Commands)

›
SQL Server DBCC(DataBase Console Commands) DBCC CACHESTATS displays information about the objects currently in the buffer cache, suc...