- Database
Creation using dbca failed with Oracle Net Services configuration failed.
The exit code is 1
- netca
command failed with ProfileException: Could not create Profile: TNS-04414:
File error
- India
Driving License Renewal New Process Through sarathi.parivahan.gov.in/
Portal
- Scripts to Check
RMAN Backup Status and Progress
- Datapump
expdp impdp New Feature – Print Content of Parfile to Logfile
- Connect to
Oracle Database Running in Linux
- Script to
Check ASM Disk Usage Details
- Execute
Oracle SQLs from Linux Command Prompt and Exit
- Command to
List the Oracle Databases Running on Linux Server
- Commands to
Delete Old Aged Oracle Trace Files(.trc, .trm) and Audit(.aud) Files
- Create
Restore and Drop Oracle Restore Point - Types and Benefits
- RMAN:
Dropped Table Recovery
- SQL to
Create Script to Analyze All Schema Tables and Indexes in Oracle Database
- SQL to Set
Tablespace Quota for Oracle User
- How to Find
out / Identify Trace File for the Current or Other Oracle User Session
- Trace
Current Oracle Session – Different Methods
- SQL Query
to Find Blocking Sessions and SQL Text for Last One Day from History
- SQL Query
to Find SQLIDs Spend on CPU/Wait/IO
- SQL Query
to Find Most Active Session in Oracle Database for Last One Hour
- SQL Query
to Find I/O Intensive SQL and SQLText in Last One Hour
- SQL Query
to Find Out Oracle Session Details for a Past Time Period from the History
tables
- SQL Query
to Find Out Pending Distributed Transaction in Oracle Database
- OCI-How to
Generate SSH Keys for OCI instance connectivity
- How to
Setup Free Oracle Cloud Infrastructure (OCI) Account
- SQL Query
to Get Oracle Database Server CPU, CPU CORE, CPU Sockets and Physical
Memory
- RMAN / SQL
query to Get Oracle Database Incarnation Details
- SQL Query
to Get Oracle DB TIMEZONE details
- How to
Check, Disable and Enable Recyclebin in Oracle Database
- SQL Query
to Get Oracle Blocking Sessions
- SQL Script
to Check the Open Cursors in the Oracle Database
- SQL Script
to Find out Total SGA and Current SGA Utilization
- SQL Script
to Check the User wise Count in Oracle database
- How to Kill
My Own SQLPLUS Session
- How to
Check When was the Table Insert, Update, Delete Done on Oracle Tables or
Partitions
- SQL Query
to Check Last Modified Time for an Oracle Object
- How Check
Hardware type In Linux / Unix
- ORA-01103:
database name 'TEST' in control file is not 'CDB'
- DBNEWID –
NID Utility – Change DBNAME and DBID
- Flush SQLID
or SQL Statement, Object from Shared Pool - DBMS_SHARED_POOL.PURGE
- How to
Delete Table, Index, Schema Statistics?
- DataPump
EXPDP Estimate [ BLOCKS | STATISTICS ]Option
- How to
Check User Quota on Oracle Tablespace-DBA_TS_QUOTAS
- DataPump Expdp
KEEP_MASTER Option
- Oracle 12c
18c 19c: How to find out the Listener.log file location?
- DataPump
Expdp ORA-39071: Value for EXCLUDE is badly formed
- DataPump
COMPRESSION_ALGORITHM Option
- DataPump
Expdp ABORT_STEP Option
- Oracle CDB
PDB: ORA-65096: invalid common user or role name; Create user Command
failed
- Oracle SQL
Query/Script: Find out Current Running Active, Inactive Sessions Connected
to the Database.
- How to
Remove / Delete / Drop a Machine from Oracle VM Virtual Box?
- iPhone -
How to Call Non-emergency Number from Locked iPhone Without Knowing
Password?
- WARNING:
Your password has expired. Password change required but no TTY available.
- How to
Enable or Disable the Supplemental Logging in Oracle Database
- Startup
command fails with ORA-27102: out of memory, Linux-x86_64 Error: 28: No space
left on device
- Oracle
relink all command failed with ld: 0706-006 Cannot find or open library
file: -l java
- Expdp
failed with ORA-39047 ORA-39047: Jobs of type TRANSPORTABLE cannot use
multiple execution streams
- How to Copy
and Multiplex Oracle OCR into Different Disk Group
- Check/Find
Location and Status of Oracle OCR and VOTEDISK
- PROC-50
PROT-30: The Oracle Cluster Registry location to be added is not usable
- Settings to
Run SQLPLUS from Other or Non-Oracle User
- Steps to
Remove / Deinstall Oracle OEM, OMS from Unix Server
- Oracle Sql
Query to Find Out Number Of Weeks Between Two Dates
- Database
Connection Using SQLPLUS Without tnsnames.ora from Command Line
- digitizeindia.gov.in:
What is the Reward Point Conversion rate / Value in Rupee or Paise?
- digitizeindia.gov.in:
Snippets have exhausted. Please try again later
- 2 Ways to Run
/ Execute OS (Unix, Linux, Windows) Commands, Shell Script from SQLPLUS or
SQL prompt
- Fix
Oracleasm Deletedisk Command Failed with Unable to Clear Disk “Disk Name”
- Oracle 12c
Data Redaction (Full, Partial, Random, Regular Expression) Implementation
Examples
- ERROR:
OMS_HOST cannot be null. Pass OMS_HOST value either as command-line
arguments or in response file
- 3 Ways to
Invoke / Open Vi Editor by ed Command in SQLPLUS
- Fix
terminating the instance due to error 27625; Instance terminated by RBAL,
pid = ; summary=[abnormal instance termination]
- Silent
Installation of OEM 12c agent: manually using emcli, scripts and response
file
- onewaycopyAction
: Source File dropdb.pl" does not exists or is not readable; Cannot
copy file from 'dropdb.pl' to '/u01/app/12.1.0/grid/crs/install/dropdb.pl'
- Steps to
Recover Database from RMAN Backup TAG
- Steps to
Enable fast_start failover (automatic) in Data Guard(DG) Broker
- Steps to
Setup Data Guard Broker (DG BROKER) in Oracle 12c RAC Database with ASM
- Steps to
Setup / Configure Data Guard and Broker on Oracle 12c RAC ASM Multi Node
Database
- ORA-16693:
requirements not met for enabling fast-start failover
- RMAN
Restore Failed RMAN-06100: no channel to restore a backup or copy of
datafile n
- Fix OEM
emctl Error: Backend WLS or EM application seems to be down
- Fix
ORA-15045 ORA-15120 ORA-27090: Unable to reserve kernel resources for as
- How to
Install Wireshark in RedHat Linux
- Fix
(wireshark:29484): Pango-WARNING **: failed to choose a font, expect ugly
output. engine-type='PangoRenderFc', script='latin'
- Fix DGMGRL
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
- Golden Gate
ggsci start manager: ERROR: Parameter file mgr.prm does not exist.
- Unable to
Bring Up RAC Clusterware: ORA-15081: failed to submit an I/O operation to
a disk, ORA-27072: File I/O error
- IE on
Windows 10 Error: SSL Network Extender Service is down and could not be
started. Consider rebooting the computer. (#323)
- Fix
ORA-01504: database name 'RESTRICT' does not match parameter db_name
'DBNAME'
- 12c RAC
Data Guard DGMGRL: show configuration failed with Error: ORA-01017:
invalid username/password
- Oracle
Installation OUI Warning “Package: nfs-utils-1.2.3-15”
- OEM 12c
Cloud Control - Add Host, Target, Cluster, ASM Instance, Database Manually
- Fix Oracle
UI Returns Error: PRVF-0002 : Could not retrieve local node name
- DGMGRL Edit
Configuration and Switch Over fails with Error: ORA-16627
- CRS-4638
CRS-4535 CRS-4530 CRS-4534 CRS-2674: Start of 'ora.cssd' on 'Node2' failed
- GoldenGate
ggsci command failed with error while loading shared libraries:
libnnz12.so, libons.so, libclntsh.so.12.1, libclntshcore.so.12.1
- GoldenGate
Start Extract Command Failed with OGG-00868 ORA-01291: missing logfile
- GoldenGate
Start Extract Pump Failing / Abending with OGG-01224 TCP/IP error 111
(Connection refused)
- GoldenGate
GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 28,365
- GoldenGate
GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 24,034
- GoldenGate
GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 26,665
- How Stop /
Start Multiple Database Instances Under One Oracle Home in Single srvctl
Command?
- Perl script
(rootcrs.pl) execution failed: Can't locate Env.pm in @INC (@INC contains:
- Fix IMPDP
ORA-39006 ORA-39213
- Oracle SQL
Query to Find Only the Directory Names of the Datafiles
- Fix Opatch:
Missing command :fuser Prerequisite check
"CheckSystemCommandAvailable" failed.
- Oracle 12c:
How to Create ASM Cluster file System (ACFS) Using ASM Configuration Assistant
(ASMCA)
- Fix:
/usr/bin/ld: warning: libstdc++.so.5, needed by libsc_ca.so, not found
- Fix
ORA-12712: new character set must be a superset of old character set
- Where You
Can Find the Oracle 11g 12c DBCA Installation / Trace Logs
- DBMS_MACADM
Package to Disable / Enable Database Vault in Oracle 12c
- Fix:
ORA-15081: failed to submit an I/O operation to a disk; Unmounting ASMlib
driver filesystem: failed
- ORA-01105
ORA-19808: Database Instance Startup Failed with ORA-01105: mount is
incompatible with mounts by other instances
- [INS-40719]
IP address configured for Single Client Access Name (SCAN): is already
assigned to another system
- Install
Oracle GoldenGate 12.2.0.1.1 on Linux – Step by Step Instructions
- How to Remove
/ Deinstall Oracle Grid Infrastructure / Clusterware Software from RAC
Nodes on Linux
- How to
Remove / Deinstall Oracle Database Software from RAC Nodes on Linux?
- wget
Command: Download Oracle Software from www.Oracle.com
- How to Install
and Check Required rpms for Oracle 12c on Linux 7
- ARCHIVE_LAG_TARGET:
Why So Many Archive Log Getting Generated Even Without Any Transaction in
Oracle Database
- 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
Check Bank Account, Aadhaar Linking Status with HP Gas Online
- 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
- Fill Maadi
Win Aagi: Win Prizes from IOC Fuel Outlets
- 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
- 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
- How to Pay
Kerala Electricity Bill Online? Introduced New System from 23-April-2013
- 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
- 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 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 get
Aadhaar UID application enrollment centers information for Maharashtra
& Orissa
- How to
Rename an Unnamed datafile (UNNAMED00004) to Original Name in Oracle 9i
10g 11g Standby Database?
- How to get
Aadhaar UID application enrollment centers information for Uttrakhand,
Tripura, Uttar Pradesh, West Bengal?
- How to get
Aadhaar UID application enrollment centers information for Tamil Nadu,
Puducherry, Rajasthan
- How to get
Aadhaar UID application enrollment centers information for Himachal
Pradesh, Madhya Pradesh, Haryana?
- How to get
Aadhaar UID application enrollment centers information for Goa &
Gujarat?
- How to get
Aadhaar UID application enrollment centers information for Delhi?
- How to get
Aadhaar UID application enrollment centers information for Chandigarh?
- How to get
Aadhaar UID application enrollment centers information for Bihar?
- How to get
Aadhaar UID application enrollment centers information for Kerala?
- How to
Check Aadhaar UID Application Status Online?
- How to get
Aadhaar UID Enrollment Centers Information for Karnataka Bangalore– Day
Centers and night Centers
- How to get
Aadhaar UID enrollment centers information for Maharashtra and Andra
Pradesh?
- 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?
- How to
apply for Government Cards online – PAN, TAN, Ration, Passport, and
Electoral
- How to Apply
for Government Certificates Online – Birth, Caste, Tribe, Dominical,
Driving, Marriage and Death
- 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
- Kochi Metro
Railway Stations Route List
- 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?
- How to
Check Vehicle Registration Details Online? Goa, Kerala, Delhi
- 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
- Easy and
quick way to get Google Plus invites. Steps to get Google Plus invitation
from my blog
- 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
- 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
- Database
Creation using dbca failed with Oracle Net Services configuration failed.
The exit code is 1
Hot Topics
- How to Find out / Check SGA and PGA size of Oracle Database?
- SQL Query to Find Out Oracle Session Details for a Past Time Period from the History tables
- Stop / Drop Scheduled / Running jobs in Oracle
- Oracle SQL to Check the Database / Instance Name to Which the Current Session Is Connected using a Non DBA user
- Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
- Oracle NO_INDEX hint: Syntax, Purpose and Example
- How to Force Oracle RMAN to Delete All Archive log files
A thousand may fall at your side, ten thousand at your right hand, but it will not come near you. (Psalm 91:7)
acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer