DBA TASKS & APPLICATION SUPPORT
 

• How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet
• Oracle: SQL Query to Find out Index Name, Column Name for Table
• How to Backup and Recovery Using Backup as Oracle RMAN Image Copy
• Query to Find Out The Total File Size And Data Occupied Size Of Oracle Database
• Sql Query to Get Hostname, IP Address and Terminal from Oracle Database
• Stop / Disable automatic ads web page opening in Chrome / IE browsers (giraffetraffic.com , go.oclasrv.com)
• How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?
• Oracle SQL Script to Get Daily Thread Wise Archive Log Generation Report
• Kerala PSC Thulasi: New Declaration is required. You are not eligible to apply for this post
• How to Get SQLPLUS Query Output to a Shell Script Variable
• Linux Screen Command: re Attach an Already Attached Session
• Fix for Chrome: These Settings Are Enforced By Your Administrator. A 100% working solution
• Fix ORA-15505: cannot start workload capture because instance 1 encountered errors
• Unix Linux Script to Attach and Embed the HTML File in Mail Body
• TNSPING and SQLPlus works but not Able to connect SQL Developer
• Enable Auto Task Maintenance Jobs in Oracle Scheduler Window Manually
• Stop / Drop Scheduled / Running jobs in Oracle
• RMAN-08591: WARNING: invalid archived log deletion policy
• Insert to Oracle View failed with ORA-01779: cannot modify a column which maps to a non key-preserved table
• Where/How to Check Alert Log File in Oracle 12c?
• Stop/Enable/Disable Oracle Auto Task Jobs Using SQL – Space advisor, Optimiser stats collection, SQL tuning advisor
• Oracle 12c Data Pump: EXPDP IMPDP VIEWS_AS_TABLES Option
• How to Check/Verify the ADDM is enabled in Oracle Database?
• How to Sync Applications in iPhone with iTunes 12 (12.1.1.4)
• How to Remove Duplicate lines from Unix vi Editor file
• How to Copy Only Contacts, Notes and Messages from iTunes after iPhone Factory Restore?
• Fix: iPhone Old Messages are not Indexing in the Spotlight search after the iOS 7 Upgrade
• Database in READ WRITE Mode; desc dba_ gives error ;ORA-04043
• Solve ORA-39170: Schema expression 'OPS' does not correspond to any schemas
• How to Find out / Check SGA and PGA size of Oracle Database?
• Find out Database Growth Month by Month Using V$datafile - Creation_time
• How to Check the Required Data is Present in Flashback Database or not for Recovery?
• How to Enable/Configure and Disable Flashback (On/Off) Feature in Oracle
• Listener Not Starting: IBM/AIX RISC System/6000 Error: 1: Not owner TNS-12555, TNS-12560, TNS-00525
• Fix ORA-30052: invalid lower limit snapshot expression
• Oracle Script to Create or Drop Series of Users or Schemas
• Find out New or Updated Rows from an Oracle Table without having Date Column
• Method to Create New Column in Oracle Table with Combination Other Columns
• Impdp Expdp Failed with ORA-31626, ORA-31633, ORA-06512, ORA-01031
• Use of Expdp Impdp nologfile=y
• Method to Track Oracle Schema User Password and Modification History; Find out Current, New Password
• Sql Query to Find and Reclaim the Fragmented Space in Oracle Table
• Example for Table Reorg and Reclaim the Fragmented Space Using Shrink Space Command
• Example for Table Reorg and Reclaim the Fragmented Space Using Table Movement
• Difference Between Oracle Table Shrink Space, Space Compact, Space Cascade - with Example
• How to Shrink a Table in Oracle Database - With Example
• Recursive Function, Procedure, PLSQL in Oracle
• DGMGRL ORA-16600: not connected to target standby database for failover
• DGMGRL Error: ORA-16647: could not start more than one observer
• DGMGRL Error: ORA-16820: fast-start failover observer is no longer observing this database
• ORA-06512 ORA-06503: PL/SQL: Function returned without value
• Oracle Session Disable Commit in Procedure
• Oracle Query to find out the SQL Text Using the Unix Process ID SPID, SID and for Long Running Sessions
• Sequence Default Cache value 20; ORA-04013: number to CACHE must be less than one cycle
• Difference Between Oracle Join and Union
• Change / Modify / update AdSense Publisher Bank Account for EFT Wire Transfer
• IMPDP Import Only the Rows Does not exist in the Target Table
• EXPDP Filesize : Split or Slice the Dump file into Multiple Directories
• Oracle Sequence Cycle vs Nocycle Difference and Comparison
• Show Error Returns with No errors: How to find out PLSQL Compilation Errors?
• How to find out the Size of the Oracle Database (Any Versions 10g, 11g)
• Oracle pfile vs spfile: Difference and Comparison
• Oracle SQL, Function for finding out Age from DOB
• Create or Alter User failed: ORA-00600: internal error code, arguments: [kzsviver:4]
• TRACEFILE_IDENTIFIER Parameter Oracle 11g
• Putty Configuration Error: There is no disk in the drive. Please insert a disk into drive
• Data Pump Expdp ESTIMATE_ONLY Parameter
• Oracle SQL to Check the Database / Instance Name to Which the Current Session Is Connected using a Non DBA user
• Data Pump Expdp Impdp Metrics=Y Undocumented Parameter
• Invoke Data Pump EXPDP IMPDP export / import Using SQL Developer
• Data Pump Impdp show=y Replaced with SQLFILE Option
• Create File or Modify the Existing UNIX/LINUX File With Old / New Timestamp
• Unix Shell Script to Find out Files Created within x Hours Without Using mmin / cmin for Solaris
• Replace SQL Null Values with SQLPLUS Set Null Command
• Create a Case Sensitive Table in Oracle / Table Name in Lower Case
• How to Check the Number of Concurrent Users in the Oracle Database Dynamically?
• Fix ORA-01927: cannot REVOKE privileges you did not grant
• Compress/zip Sqlplus Spool Output Automatically with Sql Execution Using UNIX Pipe
• SQLPLUS: Create Spool File with DB Schema Name and Current Time and Date/Sysdate
• Rename Oracle 9i, 10g, 11g Datafile with Blank Space/White Space/Special/New line Characters
• How to Append Command Outputs To Oracle SQLPLUS Spool File
• Fix ORA-14400: inserted partition key does not map to any partition
• How to Check Oracle 9i, 10g, 11g Scheduler Jobs Status
• How to Run Expdp Impdp Jobs in Background
• Without WWW Blogger Blogspot Domain is not Working- “Not Found 404”
• How to Fix ORA-20005: object statistics are locked (stattype = ALL)
• Pay BESCOM Electricity Bill Online for Sarjapur Location
• How Can I Get vi Editor Commands History
• Oracle Cast Function: ORA-01438: value larger than specified precision allowed for this column
• Opatch Failed error code 73: OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables"
• Data Pump Expdp Impdp Exclude Include Table Partitions – Table_data option
• Reason for ORA-00439: feature not enabled: Partitioning
• Create Jpg, png, PDF Oracle Database Schema ER / Table Relationship Diagram Using Data Modeler
• ORA-01732: data manipulation operation not legal on this view
• Fix ORA-08189: cannot flashback the table because row movement is not enabled
• Oracle Create View Syntax: 9 Different Examples
• Oracle Create Table Syntax: 19 Different Examples
• NoMachine Tool: Better Remote Desktop Connectivity across Different OS platforms
• Oracle NO_INDEX hint: Syntax, Purpose and Example
• How to Bypass DROP ANY TABLE Privilege for Truncate Table Command
• How to Check AWR Snapshot Setting using SQL Queries?
• Expdp Export Failed: ORA-00439: feature not enabled: Dump File Data Compression
• Expdp / Impdp Tablespace Parameter Benefits and Examples
• How to Perform a Date Test Case with Old or Upcoming Sysdate in Oracle? - FIXED_DATE Parameter
• Oracle Delete and Update Commands Executes With Set Autotrace Traceonly Explain
• SQL Developer, Data Modeler Failed: Unable to Launch the Java Virtual Machine Located at Path:
• How to Check Which User is Connected to Current Oracle Session? 3 different methods
• How to Modify / Set SQLPlus Prompt With Connected Username and SID?
• How to Avoid / Stop /Restrict the Dropping of User Schema by Mistake from Oracle Database?
• How to Exclude MLOG$ Materialized View Log Tables from the Data Pump IMPDP
• Oracle dbms_utility.get_dependency to Get Dependent Objects or Dependencies of a Table
• How to Kill or Resume [1]+ Stopped Unix Jobs
• How to Add or Insert Current Log Time and Date to a Notepad File Or Whenever You Open the file by Default
• Oracle 12c Data Pump EXPDP IMPDP Logtime Option Parameter
• How to Identify Connected Database Instance is Primary or Standby?
• SQL*Loader PARFILE Parameter
• SQL*Loader DISCARDMAX Parameter
• How to Remove / Hide Post Counter from Blogger Archive Widget in New Interface
• How to Hide / Remove ‘Subscribe to: Post Comments (Atom)‘ From the New Blogger Interface 2013
• Shell Script to Execute Oracle Sql Script in Crontab for a Specified SID
• How to Automate / Schedule Oracle Gather Table Statistics Job through Crontab?
• SQL Loader bad file vs Discard File: Difference and Examples
• Oracle SQL Loader Bad file (.bad) Parameter Example
• Shell Script: 3 Methods to Find Out Nth Word in a String
• Shell Script: Different Method to Find Out Number of Characters in a String
• Shell Script to Print Only First / Last Words in all Lines of a Text File
• Data Guard / Standby: ORA-01156: recovery or flashback in progress may need access to files
• How to see / Check the Step by Step Execution of a Shell Script for Debugging?
• How to Set / Unset Default Value for Command Line Arguments For a shell script?
• Shell Script to Repeat the Execution of Command / Job Based on Time Interval Periodically
• Data guard / Stand by: What are the Steps to Move Datafiles / Logfiles to Different Location?
• Data Guard / Standby: ORA-01624: log %s needed for crash recovery of instance %s (thread %s)
• Fix DGMGRL: Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
• May 1st 2013: New IRCTC Train Advance Ticket Reservation Booking Period (ARP) is 60 Days
• How to Find out / Identify the list of Schema / Users Available Inside a expdp data pump .dmp dumpfile
• How to Identify / Check / Find out Oracle .dmp dumpfile is Taken Using Exp / Expdp – Data Pump
• Oracle 11gR2: Truncate Drop Storage Vs Drop All Storage Clauses
• Unable Access Password Protected Spread Sheet / Document Google Drive On iPhone
• By Pass the User Password Using Grant Connect Through clause
• ORA-28150: proxy not authorized to connect as client
• How to Append Extra New Records to Table Using Oracle SQL loader?
• What are the Advantages / Benefits / Features of Oracle SQL loader?
• What is CLRExtProc, PLSExtProc and extproc in Listener.ora? Why actual database SID is not mentioned in listener.ora by default?
• CAN FLASH to 111 Method to Disable / Stop / Turn off / Deactivate unwanted Vodafone Flash Messages
• How to install an application from iTunes to iPhone
• How to Hide / Disable / Remove DISQUS Discovery “ALSO ON” YOUR SITE feature?
• F4 Key to Repeat Last or Previous Action / Task in Microsoft Excel or Word 2007 and 2010?
• How to Hide / Disable / Enable DISQUS AROUND THE WEB Discovery ads?
• Oracle Upgrade Catupgrd.sql failed: with SELECT TO_NUMBER('MUST_BE_11_2_0_3') FROM v$instance
• Steps to Configure Oracle 11g 10g RMAN Catalog in Same / Different Database
• IMPDP EXPDP ENCRYPTION_PASSWORD Parameter ORA-39173: Encrypted data has been stored unencrypted in dump file set
• Adsense CPC Fluctuation / CPC Drop Reasons, Key Factors for CPC Improvement
• ORA-00214 control file flash_recovery_area version %s inconsistent with file version %s
• Fix ORA-38814: ALTER SESSION SET EDITION must be first statement of transaction
• How to Delete / Drop All the Tables in One / Multiple Oracle 10g 11g Schema
• Data Pump impdp expdp Full, Schema, Table Level Export / Import Syntax with Examples
• Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’ of makefile net_client.mk: Oracle installation failed
• file not found dbhome_1\oc4j\j2ee\oc4j_applications\applications\em.ear – Oracle Installation failed
• Oracle 11gR2 Installation Prerequisite Checks Failed on Windows XP
• OUI-10094:Problem in saving inventory. Current access level does not allow writing to the inventory
• OS error in starting service OracleMTSRecoveryService: Oracle 11gR2 Installation Fails
• Google Page Rank (PR) Latest Recent Update Happened on 04 Feb 2013
• Simple Page Navigator for Home and Archive Blogger Pages with Numbers and Customization Tricks
• Use dbms_xplan.display_awr to Pull Full SQL and Execution Plan for a Query in AWR
• What is Oracle BBED Tool? How to make it Available in Oracle 11g?
• How to Recover / Restore / Recreate Dropped Dual Table in Oracle? ORA-01775: looping chain of synonyms
• Difference between BIGFILE and SMALLFILE tablespace, Advantages. How to Create and Resize Bigfile Tablespace?
• Select from System Package DBMS_METADATA Failed: ORA-25153: Temporary Tablespace is Empty, ORA-06512
• Insert, Delete, Truncate Operations with Oracle Dual Table. Just Not Fun
• How to Query / Generate Multiple Rows from Oracle DUAL Table?
• Siebel Database Configuration Failed: C102: The Username / Password Combination.00000: cannot be validated at this
• How to Check What is Getting / Being Audited in Oracle Database?
• Will Oracle Unique Key Constraint Allow / Accept more than One NULL Value?
• crontab Commands Fails in Linux: You (%s) are not allowed to use this program (crontab)
• STOP / Disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter
• How to Change / Move Oracle Inventory Location to another Directory?
• dbms_stats.gather_table_stats : ORA-00600: internal error code, arguments: [smboPut:fixedlen2]
• Oracle SQL Query to Print / Display Calendar Using 11gR2 LISTAGG Function
• How to Disable / Escape / Avoid / Stop & and && Variable Substitutions in Oracle SQL Plus
• Procedure to Apply and get OCP Certificate and Logo who Completed Exams Hands on Training
• Data Pump Impdp TRANSFORM option SEGMENT_ATTRIBUTES, STORAGE, OID and PCTSPACE examples
• How to Prepare awk Data Report? Example
• How to Check Which Child Directory is consuming More Space in Unix/Linux?
• Data Pump impdp remap_table Option to Change the Table Name During Import
• Using vi, awk, sed - erase / remove / cut Few First , Last Characters in all lines of Linux file
• Count & Remove Repeating / Duplicate lines in Linux/Unix file
• vi, awk, sed - Substitute / Replace Few First , Last Characters in all lines of Linux file
• Implement Delay or Sleep in Oracle PL SQL Scripts Using DBMS_LOCK.SLEEP?
• How to Copy File without Changing Last Modified Date, Time stamp and ownership in Linux / Unix?
• cp , ln Commands to Create soft Links for all Files in Linux / Unix Directory
• How to Copy Only New / Modified / Changed Files in Unix / Linux?
• Truncate failed ORA-24005: Inappropriate utilities used to perform DDL on AQ table
• What is Data Pump Expdp SOURCE_EDITION and Impdp TARGET_EDITION Options? Examples
• How to Create Different Editions or Versions for Oracle Objects? Its Advantages
• Data Pump IMPDP failed: ORA-31655: no data or metadata objects selected for job and ORA-39154
• Oracle 11gR2 Impdp DATA_OPTIONS SKIP_CONSTRAINT_ERRORS: How to Skip Constraint Errors during Import?
• RMAN Configure Backup Optimization ON / OFF : Features & Example
• Fix ORA-15097: cannot SHUTDOWN ASM instance with connected client (process %s)
• Fix Oracle 11g Database Block Corruption? - Recovery Using RMAN Backup ORA-01578: ORACLE data block corrupted
• Add or Insert a Heading Extra Line after Every nth Line of File in Unix / Linux
• How to Open and Save UNIX / Linux man Pages to vi Editor File?
• How to Create a Fixed Huge Size File in Unix / Linux Using dd Command?
• Why Oracle DBA_TEMP_FILES view Bytes Column is NULL: How to Drop, Shrink Offline / Online Temp File
• Oracle 11g Database Startup Failed: /dev/shm and ORA-00845: MEMORY_TARGET not supported on this system
• Datapump IMPDP Partition_Options = MERGE , DEPARTITION Examples
• Duplicate Command Failed: RMAN-05001: auxiliary filename %s conflicts with a file used by the target database
• OC4J Connection Pool Error Message: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
• Fix ORA-02032: clustered tables cannot be used before the cluster index is built
• Truncate Failed: ORA-03292: Table to be truncated is part of a cluster
• Shell Script to Run RMAN Backup in Background with nohup
• Move Subpartition for an Interval Partitioned Table Failed: ORA-00600 [kkpod nextFrag]
• Fix IMP-00013: only a DBA can import a file exported by another DBA
• Fix IMP-00058: ORACLE error 1950 encountered
• Blogger Blogspot Page views Reset to Zero Today - Resolved
• Rail Radar: How to Live Locate Indian Railway Trains in Google Map!!
• Index Rebuild Online Failed Oracle 11gR2: ORA-01450: maximum key length (3215) exceeded
• Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
• How to Find out / Check / Set Values for Hidden Underscore _ Parameters in Oracle?
• Validate Exception Queue: ORA-24017: cannot enable enqueue on QUEUE
• Data Pump EXPDP Error: ORA-39181: Only partial table data may be exported due to fine grain access control on
• Fix ORA-01157: cannot identify/lock data file # - see DBWR trace file ORA-01110: data file #: ORA-01136: specified size of file # (n blocks) is less than original size
• Oracle SQL Select Statement / Function to get Server Memory, CPU and Processor details
• ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 2: No such file or directory
• dbms_lob.write Failed with ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
• ORA-06502: PL/SQL: numeric or value error: raw variable length too long: Convert Varchar2 to Blob with utl_raw.cast_to_raw
• Convert Oracle Varchar2 column to Blob data type Using utl_raw.cast_to_raw – Example
• Fix ORA-19870 ORA-19863: device block size 4186112 is larger than max allowed: 1048576
• HISTTIMEFORMAT: How to See the Linux commands History with Date and Time?
• Siebel Error SBL-ODC-00105 ORA- 24345 A Truncation or null fetch error occurred
• Oracle EM Alert: Critical:DBNAME - There have been n failed login attempts in the last x minutes: Identify the LOGIN failure with 1017 returncode
• How to Perform Multiple Comparisons in Oracle SQL Query Using Select .. Case .. When .. Else
• ORA-04031: unable to allocate 2048024 bytes of shared memory: 11 g RAC Fix error
• How to Fix PLS-00201: identifier 'DBMS_AQ' must be declared
• How to Renew the Domain Registered From Blogger Settings – Domain Auto Renewal via Google Apps
• 11g Deferred Segment: ORA-01950: no privileges on tablespace
• Fix ORA-14402: updating partition key column would cause a partition change
• How to Configure Tablespace / Monitoring Alert Emails in Oracle 11g OEM Rules
• How to Avoid / Remove Adsense Ads from Homepage / Archive Page in Blog
• Steps for RMAN Recovery from Old Incarnation without Catalog
• ORA-20021: database not set: Select From RC_BACKUP_FILES Table failed
• How to Use ORADEBUG to Find out Trace file name
• How to Use ORADEBUG CURRENT_SQL to See Other Session SQL
• FireFox: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser
• Internet Explorer: Uninstall / Disable / Remove Yahoo Axis Search Bar from IE Browser
• Google Chrome: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser
• Traffic after Registering Custom Domain for Blogger Blogspot - My Experience
• Work Around for ORA-00600: [kkpo_rcinfo_defstg:objnotfound], [75312]
• Find out Maximum, Current Limit of Oracle Resources (Session, Process, Lock) using v$resource_limit
• Purpose of ORAENV_ASK=NO / YES variable in Oracle
• Data Pump EXPDP IMPDP content=METADATA_ONLY to Extract the Skeleton of the Oracle Database
• How to Check / Find out the Privileges and Roles for My Own Session Oracle
• ORA-00059: maximum number of DB_FILES exceeded - Fix / Resolve Oracle Add Datafile Error
• ORA-28001: the password has expired - Permanent Fix for NOEXPIRY for Oracle User
• Data pump IMPDP SKIP_UNUSABLE_INDEXES=Y/N Parameter Option Example
• Example on Data Pump EXPDP IMPDP Parfile Option
• How to Schedule / Execute / Run an Oracle Procedure through DBMS_JOB?
• Check Who is Accessing / Locking / Blocking the Oracle Session / Table
• How to Run / Schedule a PLSQL Procedure In Shell Script and Crontab?
• How to Keep / Pin / Check PLSQL Objects in Buffer Cache / Memory Using DBMS_SHARED_POOL.KEEP
• Find / Check Hot/Frequently Accessed Objects in Oracle 10g 11g Database Using v$db_object_cache
• How to Set / Fix / Limit the Oracle 10g 11g Trace File Size
• Script to Generate and Spool DDL / SQL statements for Tablespaces in Oracle 10g 11g Database
• Syntax to Find / Check / Change / Set Default Permanent Tablespace for Oracle 10g, 11g Database
• Different methods to find out NLS Parameters from Oracle Database
• How to find / Set NLS_LANG in Solaris AIX Unix and Windows for Oracle?
• Syntax to Find / Check / Change / Set Default Temporary Tablespace for Oracle 10g, 11g Database
• Oracle 11g User Account Status LOCKED(TIMED) with FAILED_LOGIN_ATTEMPTS, PASSWORD_LOCK_TIME Parameters
• Data Pump EXPDP FLASHBACK_SCN Parameter
• IMPDP FLASHBACK_SCN, FLASHBACK_TIME Shows in Parameter Help – Is it a bug?
• Troubleshoot Fix error IMP-00038: Could not convert to environment character set's handle
• Troubleshoot Fix IMP-00010 not a valid export file header failed verification
• Why Adsense Ad Slots are Blank / Empty – Main Reasons
• Data Pump EXPDP IMPDP Status Parameter for Feedback
• No More New PayPal Donate Buttons for Indian Bloggers / Users
• Data Pump IMPDP REMAP_TABLESPACE Parameter Syntax and Examples
• Data Pump IMPDP REMAP_SCHEMA Parameter Syntax and Examples
• SQL Syntax to Add Offset Hour, Minute, Year, Day, Month to Oracle Timestamp Values Examples
• Difference between LOG_ARCHIVE_DEST_1 LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST
• Troubleshoot Fix ORA-16018 ORA-16019 ORA-02097 Oracle Archival Errors
• Add Oracle Constraints – Primary, Foreign, Unique, Check, Null to Existing Table
• How to Add / Install RSS Feedburner Reader Counter to Blogger?
• Oracle 11gR2 LISTAGG Analytical Function – Concatenate / Select Multiple Rows of a Table to Single
• How to Check / Find the Oracle Table Depended Objects?
• Reasons for PL/SQL Code Block Failure with ORA-01001: invalid cursor
• Select Failed with ORA-00980: synonym translation is no longer valid
• Create Synonym Failed with ORA-01471: cannot create a synonym with same name as object
• Oracle SQL Query to Find out Nth Largest, Highest, Lowest, Smallest Values
• Troubleshoot Fix unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 17946
• Interesting Features of Oracle TO_DATE and TRUNC Functions
• Oracle SQL Query to Find out Cumulative SUM and Duplicate Rows of a Table Records
• How to Extract / Get Script for DBA_, V$ Oracle Data Dictionary Views?
• Will IGNORE=Y Option Work with Data Pump IMPDP
• Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE
• Oracle DBMS_RANDOM Package to Generate Random Numbers, Strings
• Generate Random Date between Dates or Period Using Julian Date and DBMS_RANDOM package
• Oracle V$ vs RAC GV$ Dynamic Performance Views – Difference and Features
• Trick to HIDE / Mask Oracle User Password in Alter User Command?
• Oracle 11gR2 NTILE Analytic Function Usage Syntax
• Index Rebuild Failed With ORA-14456: cannot rebuild index on a temporary table
• Oracle 11gR2 NTH_VALUE Function Usage Syntax
• Rename Command fails with ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
• Script to Find out SQL Text from Oracle 11g, 10g RAC Database Using SID, SPID
• Advantage of Caching / Pinning/ Keeping an Oracle Table in Buffer Pool
• Take / Generate Oracle 10g 11g Active Session History Report (ASH) Manually
• Fix ORA-02299: cannot validate (SCOTT.EMP_UK) - duplicate keys found
• Retrieve / Recover / Restore Dropped Table in Oracle 10g 11g Using Flashback Table Feature
• How to Drop Oracle 10g 11g Bin$ / Recycle bin Tables
• Oracle Kill Session Command Fails with ORA-00027: cannot kill current session
• Oracle Create table, Materialized View Command Fails with ORA-01723: zero-length columns are not allowed
• Public Database Link fails with ORA-12154: TNS:could not resolve the connect identifier specified
• Oracle 10g 11g Archivelog Vs Noarchivelog Mode Difference, Advantages, Features
• How to Calculate Income Tax (IT) for New Financial Year 2012-13 after Budget
• How to Remove / Hide / Disable Google Plus One +1 Button from Adsense Image Ads
• EXPDP IMPDP Failed or terminated with ORA-31633, ORA-06512, ORA-00955
• EXPDP IMPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033
• Reasons and Workarounds to Fix ORA-00997: illegal use of LONG datatype
• How to Convert the AIA xref_data Cross Reference table LAST_MODIFIED, LAST_ACCESSED to Date?
• Reasons for ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
• Data Pump vs EXP/IMP: Difference or Comparison Between Data Pump Expdp/impdp and Conventional EXP/IMP
• Execute Immediate Command Fails with DBA role: ORA-01031: insufficient privileges
• Fix ORA-10636: ROW MOVEMENT is not enabled Table Shrink Command Failed
• ORA-10662: Segment has long columns, Table Shrink Command Failed: Workaround
• Fix Data Pump EXPDP Error ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
• Database Recovery from Corrupted, Missing Redo, Archive Log Files Using _ALLOW_RESETLOGS_CORRUPTION, _CORRUPTED_ROLLBACK_SEGMENTS, _minimum_giga_scn and _allow_error_simulation
• ORA-01548: active rollback segment, Find out Oracle 10g 11g Active Undo Segments from system datafile
• How to Share / Add / Embed Youtube Video to Blogger Posts?
• Google Animated Music Doodle on Valentine’s Day 2012
• Purpose of ADR_BASE_Listener & DIAG_ADR_ENABLED_listener : Oracle 11gR1 Listener ADR Parameter
• Unique Index Creation Failed: ORA-12801: error signaled in parallel query server P018, instance
• Oracle 11g LMon RAC Background Process Functions
• Terminate/Kill/Stop Data Pump EXPDP IMPDP Executing Jobs
• Oracle SQL Script to Compile All Package, Body in a Schema
• Oracle 10g 11g Data Pump EXPDP Query Parameter option
• Oracle 11g ORA-12916: cannot shrink permanent or dictionary managed tablespace; Oracle Tablespace Shrink Command Failed
• Relation / Difference : O7_DICTIONARY_ACCESSIBILITY = TRUE / FALSE, SELECT ANY DICTIONARY, SELECT CATALOG ROLE and SELECT ANY TABLE
• userenv('ISDBA') : To check the Current Oracle Session has DBA Privilege
• How to Find Out Oracle Trace File Name for TKPROF or backup controlfile to trace?
• How to Find Out Your Current / Own Oracle Session ID - SID?
• Oracle ASM Datafile add / resize failed with ORA-01237 ORA-01110 ORA-17505 ORA-15041: diskgroup "DATA" space exhausted
• How to Refresh / Recalculate Microsoft Excel Column Formula Automatically
• RMAN Duplicate Database Failed with RMAN-06136, ORA-15001: diskgroup "DATA_CEX" does not exist or is not mounted
• Prepare / Generate repetitive SQL Scripts Using Microsoft EXCEL CONCATENATE Function
• Oracle 11G SQL Command Syntax to Check Free Space, Shrink Temporary Tablespace or Tempfile
• Oracle 10g 11g Data Pump EXPDP SAMPLE Parameter Option
• Oracle Data Pump EXPDP IMPDP REMAP_DATA Parameter for Data Transformation with Example
• Oracle 10g 11g RMAN Useful Commands
• Fix RMAN-04014 ORA-00439: feature not enabled
• Fix RMAN Duplicate Database Failed with ORA-20 Connecting to ASM Instance
• SQLPLUS Connect, Startup Fails with ORA-09925: Unable to create audit trail file SVR4 Error: 13
• Fix RMAN-04014 ORA-07446: sdnfy: bad value '…/bdump' '…/udump'
• Expire Oracle User Password in Few Minutes Using Profile Resouces PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME
• ORA-28011: the account will expire soon; change your password now
• How to Disconnect or Expire the Idle Oracle 10g 11g Sesssions Automatically Using Profile IDLE_TIME Resouce
• DBMS_SCHEDULER. Create_job Fails with ORA-06512 ORA-27486: insufficient privileges
• How to Add / Install Syntax Highlighter for Scripts in Blogger Post – SQL, Java, Python, HTML etc
• Fix Oracle 10g 11g Data Pump IMPDP Failed withORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation
• What are the Considerations for EXADATA Smart Scan Cell Offloading?
• One More Interactive Music Doodle from Google: Happy Holidays 2011
• EXADATA Smart Scan - cell_offload_plan_display = NEVER / AUTO /ALWAYS Parameter
• Fix Duplicate Database failing RMAN-06136: ORA-01618: redo thread is not enabled - cannot mount
• opt_param ( 'cell_offload_processing' , ’TRUE/FALSE’ ) Hint to Enable EXADATA Smart Scan Feature: Speed Comparison with Smart Scan
• Floating Facebook Like, Share, Google Plus One +1 Button Gadget HTML Code For Blogger
• Google Language Translator Gadget HTML Code: With Small Beautiful Flags for Blogger
• Main Reasons for Delay or Not Receiving the Adsense PIN after a Period of Time
• Different Methods to Print Single Quote (') in AWK programming
• Fix RMAN-03009 ORA-00245 RMAN-08132 control file backup operation failed
• What is the Difference between Digital Receiver Type DVBS and DVBS2?
• Tested Tips to Increase or Improve Adsesnse CTR
• Oracle 11g 10g Database SQL Script to Find Out Active Sessions Waits
• Fix DB Link Error ORA-02085: database link connects to
• Oracle 10g 11g RAC ASM RMAN Database Cloning to Different Server with Different File System
• How to Rename Oracle 11g 10g Database Using NID command Line Utility
• Oracle 10g 11G RAC Database Control File Creation Failed with ORA-01503, ORA-12720: operation requires database is in EXCLUSIVE mode
• How to Change Oracle 11g 10g RAC database to Noarchivelog mode?
• How to See the Oracle 10g 11g Bind Variable Values Using v$sql_bind_capture
• Benefits of Registering Own Custom Domains for Your Blog on Blogger or WordPress
• Reset the Password for an Oracle Expired Login or Username to Old or Previous Value
• RMAN Reset Incarnation Failed: ORA-19910: can not change recovery target incarnation in control file
• How to Restore Oracle RMAN Backup from Previous or Old Incarnation
• How to Force Oracle RMAN to Delete All Archive log files
• Oracle RAC Startup failed ORA-01102: cannot mount database in EXCLUSIVE mode
• Database startup failing ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used,
• RMAN-06059 ORA-19625 backup archivelog all delete input
• FIX RMAN-11001 ORA-01547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"
• Fix RMAN-08138: WARNING: archived log not deleted - must create more backups
• Fix RMAN-04005 ORA-01031: insufficient privileges RMAN-00554 in Oracle 10g 11g RAC
• Fix RMAN-20242: Specification Does Not Match Any Archive Log
• Exadata Hybrid Columnar Compression – HCC : Comparison between Compress for Query High and Archive High
• Transfer Oracle ASM binary Files One File System to another File System Using DBMS_FILE_TRANSFER
• HTML Code to Place Adsense Ads Side by Side, Left, Right, Center Aligned on Blogger Posts
• How to Recover the Oracle 10g 11g Database from RMAN Cold Backup
• Fix ORA-09817: Write to audit file failed. SVR4 Error: 28: No space left on device
• New Latest Method to Apply Ration Card Online Karnataka – Bangalore 19-Nov-11
• Oracle 11gR2: Generate Number Series Using Select Command with array(x) as clause? UNDEF Command to Reset && variable
• Fix RMAN-06004 RMAN-20001: target database not found in recovery catalog
• Add Datafile, Create tablespace to Oracle database runing on ASM or with Oracle-managed files? Fix ORA-01276
• How to Drop Datafile from Tablespace on Oracle 8i, 9i, 10g, 11g Database?
• Oracle 11g 10g RMAN Duplicate Database Command Using TAG: How to Clone a Database in same server / node
• Fix RMAN Duplicate database failed ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [kdt.c], [9576], [11.2.0.2.0]
• Troubleshoot & Fix RMAN Duplicate database failed with ORA-12720 RMAN-06136
• Troubleshoot & Fix RMAN Duplicate Database failed with RMAN-11003 & ORA-19906
• Troubleshoot & Fix RMAN Duplicate database Failed RMAN-00600: internal error, arguments [8546] [1]
• Troubleshoot & Fix ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
• Change the RMAN Backup TAG Retention Policy Using Change Backup .. Keep Command
• Oracle 10g 11g Syntax for Lock and Unlock a User Schema Account
• Oracle 10g 11g Shared Database – DB Link – Features, Advantages and Disadvantages
• How to enable voice call in Microsoft Office Communicator 2007 R2 Windows 7 and XP
• Oracle int vs number datatypes difference and features
• How to Rename Tablespaces to a New name in Oracle 9i 10g 11g ?
• Oracle SQL Script to Find Out Active Sessions Details
• Easy Methods to Find Out Oracle 9i 10g 11g DBID
• Different Methods to Find Out Oracle Version From the Database
• How to Use Drop Database Command in Oracle 11gR2?
• How to Change Oracle 9i 10g 11g Database Time_Zone? Fix ORA-02231 & ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ) columns
• How to encrypt UNIX (solaris AIX Linux) files using vi editior? Protect your UNIX files with password
• Soft Link Vs Hard Link in Solaris & AIX Unix OS – Difference and Features
• How to Find Out Last Modified Time of a Row in an Oracle 10g 11g Table Using ORA_ROWSCN and SCN_TO_TIMESTAMP Functions?
• How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
• Get Timestamp from SCN in Oracle 10g 11g? Convert SCN to Timestamp Using scn_to_timestamp and timestamp_to_scn
• How to Rename an Unnamed datafile (UNNAMED00004) to Original Name in Oracle 9i 10g 11g Standby Database?
• How to move oracle datafile to different location and rename?
• How to rename and move a oracle system tablespace datafile?
• What is the command to take Oracle Control file backup? Standby Control file, ASCII control file
• Reason and Fix for ORA-25153: Temporary Tablespace is Empty
• What is the significance of Oracle Parameter Global_names=TRUE?
• How to Signup and Install / Add Google Analytics Code to Your WordPress / Blogger Blogs?
• Oracle Views vs Materialized Views – Difference, Advantages, Disadvantages and Features
• How to Check Whether the Oracle Database is Using Pfile or SPfile?
• Oracle Views vs Tables- Advantages, Disadvantages and Features
• Oracle Private vs Public Synonyms – Advantages Difference and Features
• dbms_system.ksdwrt Procedure to Write Custom Messages to Oracle Alert and Trace Files Manually
• Oracle SQLPlus Copy Command Usage Syntax to Copy tables across database
• Usage syntax for Oracle 10g REGEXP_LIKE regular expression function
• Oracle 11g ADRCI – How to Create Package for an Incident or a Problem?
• Oracle 11g ADRCI - Configure and Setup Automatic Diagnostic Repository Using Command Line Interpreter
• Oracle Data Pump expdp impdp Use JOB_NAME Option to Stop_job, Attach, Kill_job and Continue_client interactively
• What is Oracle 11g Problems and Incidents Concept?
• Oracle 11g Automatic Diagnostic Repository – ADR – Features and advantages
• How to Register Your Land, Vehicle, Employment exchange, Company Online?
• Oracle 11g Security SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter
• Delete vs Truncate in Oracle 9i 10g 11g – Difference and advantages
• How to Create Case Sensitive Password File in Oracle 11g?
• Oracle 11g Enable Case Sensitive Passwords For Improved Password Security
• How to Check and Find Out PF Account Balance and Details online? Portal Lauched on 01-07-2011with SMS
• Oracle 11g Password : Relation between user$, DBA_USERS, PASSWORD_VERSIONS, spare4, IDENTIFIED BY VALUES
• Explicit Vs Implicit Commit in Oracle– Difference and When it Occurs?
• Oracle 11gR2 SQLPlus SET EXITCOMMIT ON/OFF
• How to hide oracle passwords - sqlldr, sqlplus, exp, imp, expdp, impdp from Unix ps command?
• Export and Create Excel File from Oracle SQL Query Spool Output File
• What is the datatype and precision of Oracle NULL column?
• How to read (command) without enter in Linux bash shell?
• How to check the pending transaction in your oracle session?
• How to create dummy NULL column for a Oracle view using function?
• Script to increment or decrement all sequences in a schema by n=1000 numbers
• Reset/Modify/alter Oracle sequence nextval, currval to new value without dropping
• Find out the income tax (IT) ward/circle for income tax e-filing
• How to check file last modification or change date and time details in Linux?
• Oracle 11g Data Pump expdp compression option to reduce the export dump file
• Features and Advantages of Oracle 11gR2 Deferred segments – Segment Creation on Demand
• Oracle 11g ASM (Automatic Storage Management) Features, advantages and benefits
• Data Pump expdp REUSE_DUMPFILE option: Overwrite existing dumpfile
• Connect to hanging database using sqlplus –prelim option in Oracle 10g, 11g
• How to install/apply/change XML template on new blogger interface
• Troubleshoot fix ORA-28368: cannot auto-create wallet ORA-28353: failed to open wallet
• How to setup Oracle 11g, 10g Transparent Data Encryption - TDE? Advantages, SALT Option
• Troubleshoot and fix TNS-12560 TNS-00583: Valid node checking: unable to parse configuration parameters
• Oracle 11g New Feature: Invisible index advantages for performance tuning
• Oracle INDEX hint : Different usage syntax for performance tuning
• Oracle 11g New Feature : SQLPlus Error Logging Features and advantages
• Oracle 11g New Feature : Advantage of Shrink Temp Tablespace and Tempfile
• CHAR vs VARCHAR Difference, Advantage in Performance Tuning
• Oracle 11g : Read-Only Tables New Feature & advantages
• EMCA dbconsole configuration failed with ORA-20001: SYSMAN already exists
• Data Pump impdp expdp : SQLFILE option to extract DDL and DML from dump file
• Data Pump impdp expdp NETWORK_LINK option : Transfer schema across database using db links without dump file!
• Oracle User Password Reset : Two different methods – SQL*Plus and alter user
• How long needed For Google Adsense Approval for Blogspot? I Got In 2 Months for my new blog! 10 Guaranteed Tips!
• Les Paul Interactive Music Google Doodle – With record option still available with doodle collection
• How the Optimizer chooses Between Indexes and Full-Table Scan
• Choosing the best indexing strategy
• Creating indexes on Nullable Columns
• Oracle 11g RESULT_CACHE Hint : Faster Performance Queries, Advantages, Benefits
• Global Index Vs Local index – Difference, Advantages, Disadvantages, features, examples
• WDYL : New Google Multi Search Feature : What Do You Love
• How to get Google Analytics Code again?
• Create PFILE SPFILE from memory 11g New Feature
• Oracle 11g New Feature Parameter DDL_LOCK_TIMEOUT : DDL waiting time for DML Locks
• Troubleshoot & fix ORA-01002: fetch out of sequence
• How to check whether oracle is 32bit/64bit and running OS platform is 32bit/64bit?
• Workaround for ORA-600 [k2vpci_2] SMON Crash and Subsequent startup fails
• Troubleshoot Fix EMCA CONFIG: emca/emcaDbUtil: perl/bin/perl: not found
• Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options Features and examples
• Data Pump EXPDP : How to EXCLUDE table partition explained with example
• How to create and remove soft link (symbolic) in Solaris AIX?
• Troubleshoot Fix emca oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener
• Steps to configure Oracle 11g OEM DBConsole manually for an existing database
• Restrict the commands (SELECT DELETE UPDATE) in SQL*PLUS for a particular user
• Troubleshoot Fix EMCA Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) ORA-01031: insufficient privileges
• RMAN Switch command script to rename the datafile
• ORACLE BASE Vs ORACLE_HOME - Difference between ORACLE_BASE and ORACLE_HOME
• Oracle 10g, 11g User Password Last Modification / Reset time - sys.user$
• How to change or modify the SQLPlus prompt?
• Expdp/Impdp Transportable Tablespace Movement across Different OS Platforms in Oracle 9i, 10g, 11g Examples, Advantages
• Oracle 9i, 10g, 11g: Methods to Rename a username / schema to a new name
• How to Create Virtual Columns with Oracle 11g New Feature?
• SQL Query Check Oracle (9i/10g/11g) tablespace free space and space Usage
• How to Login with more than One (Multiple) Yahoo Messenger simultaneously?
• Oracle 11g New Feature password security dba_users password column is null and stored in user$
• OPatch fails with wrong platform ID (610, 212)
• How to correct & fix the corrupted Oracle (9i, 10g, 11g) inventory using runInstaller & opatch?
• How to generate/spool index creation script for a schema using dbms_metadata.get_ddl?
• How to generate/spool table creation script for a schema using dbms_metadata.get_ddl?
• DBMS_ROWID for Oracle ROWID Pseudo column Format. Structure, Purpose, Features
• What is Oracle memory HIT and Memory Miss? Buffer Cache, Library Cache, Dictionary Cache HIT Ratio
• Troubleshoot fix resolve ORA-12988: cannot drop column from table owned by SYS. How to drop a column of a table owned by SYS
• what is ORA-00031: session marked for kill , ALTER SYSTEM KILL SESSION, resource busy and acquire with NOWAIT
• Troubleshoot Fix Resolve ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed
• Troubleshoot fix resolve ORA-04091: table scott.EMP is mutating, trigger/function may not see it
• Troubleshoot fix resolve ORA-00936: missing expression
• Troubleshoot Fix Resolve ORA-00060: deadlock detected while waiting for resource
• Troubleshoot ORA-00938: ORA-00939: not enough arguments & too many arguments for function
• Creation, Features of a global temporary table, Privileges to populate
• How to disable flash recovery area of existing open Oracle (10g, 11g) database?
• How to check flash recovery area USAGE for oracle(10g, 11g) database?
• How to configure or setup Flash Recovery Area to an Existing oracle (10g, 11g)Database?
• Oracle 11gR2 relink new feature
• How to check patches applied on oracle database? Patch history details
• Troubleshoot Fix Resolve ORA-00054: resource busy and acquire with NOWAIT
• How to disable all constraints on a table or schema - Oracle sql Script
• SET AUTOTRACE EXPLAIN or EXECUTION Plan Options
• RMAN Point in time Recovery (PITR) scenario of a dropped oracle tablespace
• Unix: Command to check swap space in Solaris & AIX?
• Unix: command to check physical memory (RAM) in Solaris & AIX
• Unix: How to find out most CPU consuming processes?
• Unix: Command to kill multiple processes (pid) in single command
• Windows ORAKILL utility usage-Syntax to Kill Oracle thread
• Data Pump (expdp/impdp) Tuning features - PARALLEL option for faster performance behavior
• Solaris psrinfo to check number of CPU/processors SunOS
• Troubleshoot Fix Resolve ORA-01555:snapshot too old: rollback segment number %s
• Features and configuration of Oracle Automatic UNDO Management AUM
• Functions and Features of Oracle UNDO
• Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
• DBMS_STATS.export import:How to transfer oracle statistics between databases
• How to rename Oracle Database? Recreate oracle controlfile: Steps to rename the database
• Oracle Imp show=y & Indexfile: How to generate sql scripts from Oracle dump file?
• vi editor mark to create a sub file from main file: explained
• How to open a crashed oracle database during HOT BACKUP
• How to compress export (exp) dump files using UNIX pipes?
• Oracle exp compress=Y Compress option in export (EXP) utility
• UNIX: How to find out the total size of files from multiple directories
• Oracle Data Pump (expdp/impdp) Benefits / Advantages & Disadvantages
• How to schedule a Unix shell script in crontab to run every 2nd Saturday(nth Day of the month)
• How to search Unix files pattern recursively (subdirectory) with file size
• 5 Different Methods to Partition a non partitioned Oracle table, PARTITION EXCHANGE, SPLIT, Redefinition
• Different types of Oracle Partitioning Range, Hash, List, Interval
• What are the Oracle Advanced Data Compression methodology Tips?
• Trace an Oracle session? DBMS_SYSTEM, DBMS_SUPPORT