Featured
The Latest
-
Regular expression
One can use the regular expressions to match in vi, grep, sed and awk. [a-d] – Match one character with… READ MORE
-
Arrays in ksh
# how to create a array and assign a list of values set -A fruit apples pears oranges banana #… READ MORE
-
How to write a case condition in shell?
In ksh shell – case statement case variable_name in pattern1) statements1 ;; pattern2) statements2 ;; # default (catch all remaining)… READ MORE
-
How ERR trap works?
# Sample script that shows how ERR signal works, when a command returns a non-zero status it triggers to calls… READ MORE
-
How to create a database from command line?
Using the following steps one can create database from command line. Place the following pfile in $ORACLE_HOME/dbs directory and set… READ MORE
-
How to Display a List of All Snapshots from OMS
SQL> set lines 100 pages 999 SQL> select snap_id, snap_level, to_char(begin_interval_time, ‘dd/mm/yy hh24:mi:ss’) starting 2 from dba_hist_snapshot 3 order by… READ MORE
-
How to fix Target Database Incarnation Is Not Current In Recovery Catalog RMAN-20011?
When doing a incomplete recovery (i.e. database is open with resetlogs) and when running RMAN to backup that database after… READ MORE
-
What are the command line options that can be passed to runInstaller?
Here are some of the options that can be passed to runInstaller -slient – Slient mode -debug – To get… READ MORE
-
How to force a trace file to be created when an ORA error occurs?
There was an issue we ran into where one of the users ran out temporary tablespace (TEMP) we had message… READ MORE
-
Deleting top n lines
sed ‘1,10d’ file – doesn’t print the top 10 lines from the file sed ‘5d’ myfile – delete 5th line… READ MORE
-
Job to delete log and trace files from OEM
I use this script to clean up all the log and trace file from each host.. You can schedule a… READ MORE
-
How to find and fix block corruption using RMAN?
One of the scenario we ran into when one of the data file reported there was block corruption as RMAN… READ MORE
-
How to find success/failure status of a command in different shells?
Ksh/Borne/Bash shell $ ls /usr/bin …. # when success value is 0 $ echo $? 0 $ ls /usr/bin/blah ls:… READ MORE
-
How to change logical name of SQL Server database?
To change the logical name of the SQL Server databse one can follow the steps below to change the logical… READ MORE
-
|
Set title of a window
Using the script one can set the title of a window, one of the reason for doing would be distinguish… READ MORE
-
|
How to view table of contents of a compress tar file?
Using the example below one can view the contents a compress tar file without un-compressing the file. # if the… READ MORE
-
How to find blocking session?
In 10g, there is a column in V$session called blocking_session to find the session id that is blocking. Session 1)… READ MORE
-
How to find oracle bit size?
Using the following SQL one can find the oracle bit version installed: SQL> SELECT length(addr)*4 || ‘-bit’ word_length FROM v$process… READ MORE
-
How to delete archive logs already archived to backup device?
If one is keeping archive logs available on disk and also have them archived to tape and would like to… READ MORE
-
How to keep 2 days of archive log on disk and still have back to tape?
Using the following rman command one can setup to keep 2 days of archive log on disk and also archive… READ MORE
-
How to extract start and end time of a job in SQL Server?
In Query analyzer — prints job name, step name, start time and end time of each step in the job… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- kubernetes
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- Open Shift
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
