Home

datapump basic’s

CONN / AS SYSDBAALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK; CREATE OR REPLACE DIRECTORY test_dir AS ‘/u01/app/oracle/oradata/’;GRANT READ, WRITE ON DIRECTORY test_dir TO scott; Note. Data Pump is a server-based technology, so it typically deals with directory objects pointing to physical directories on the database server. It does not…
Continue reading →: datapump basic’s
scheduling crontab jobs in Linux or Unix

1. Scheduling a Job For a Specific Time The basic usage of cron is to execute a job in a specific time as shown below. This will execute the Full backup shell script (full-backup) on 10th June 08:30 AM. Please note that the time field uses 24 hours format. So,…
Continue reading →: scheduling crontab jobs in Linux or Unix
some basic sql’s for beginners in Oracle database

Oracle Database Commands and Queries: 1.To view all the table from dictionary :SQL> select table_name from dictionary; 2.To identify the database name :SQL> select name from v$database; 3.To identify the instance name :SQL> select instance from v$thread; 4.To know the size of the database blocks SQL> select value from v$parameter…
Continue reading →: some basic sql’s for beginners in Oracle database
script to drop all objects in your schema

This script can be used to drop all the objects in your schema,very useful when you want a fresh schema and start from scratch.no need to delete objects individually or recreate user. —————————————————————————–—– plsql script to drop all the objects in your —– current schema————————————————————–declarev_str1 varchar2(200) := null;cursor…
Continue reading →: script to drop all objects in your schema
Some very usefull sql’s for Datagaurd

Backup – DataGuard Startup commandsTo remove a delay from a standbyCancel managed recoveryRegister a missing log fileIf FAL doesn’t work and it says the log is already registeredCheck which logs are missingDisable/Enable archive log destinationsTurn on fal tracing on the primary dbStop the Data Guard brokerShow the current instance roleLogical…
Continue reading →: Some very usefull sql’s for Datagaurd
disable password verify function in oracle

ISSUE:You may fail to run some oracle provided sql scripts because of user creation failure. the creation failure is because provided password didnt’ pass verify function. CAUSE:default password provided in oracle script doesn’t satisfy your password verify function in default profile SOLUTION:alter profile default limit password_verify_function null;run the scriptalter profile…
Continue reading →: disable password verify function in oracle
Failed to shutdown DBConsole Gracefully

Environment:Oracle:Oracle 10g Release 2 10.2.0.5OS:LinuxSummary:Fix Oracle EM problem:Failed to shutdown DBConsole Gracefully Today on a Linux Oracle machine without Oracle Enterprise Manger, I would like to install Oracle EM. Use command emca -config dbcontrol db -repos create It reports an error – An instance of Oracle Enterprise Manager 10g Database…
Continue reading →: Failed to shutdown DBConsole Gracefully
Drop the EMCA repository,sysman schema and objects

[oracle@linux200 bin]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Jun 19, 2013 4:11:49 PMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information:Database SID: ORCLListener port number: 1521Password for SYS user:Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: YJun…
Continue reading →: Drop the EMCA repository,sysman schema and objects
CREATE STANDBY DATABASE USING RMAN

[oracle@linux1 database]$ sqlplus /”As sysdba” SQL*Plus: Release 11.1.0.6.0 – Production on Sat Mar 2 19:10:41 2013 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select banner from…
Continue reading →: CREATE STANDBY DATABASE USING RMAN