Monthly Archives: September 2022
Protected: Linux Shell Script To Monitor GoldenGate Lag
Schedule this script on (Source & Destination) replication servers in order to detect the lag on all processes (Extract, Pump, and Replicate).
Set following...
Relocating enabl database for oracle 19c
Relocating enabl database for oracle 19c
1:- After the upgrade add this hosting members as below
$GRID_HOME/bin/crsctl modify resource ora.enabl.db -attr "HOSTING_MEMBERS='server01 server02' PLACEMENT='favored'" -unsupported
2:- Create...
Oratop Utility
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone...
Standby : Unnamed file issue
Sun Jan 1 22:02:11 2022
Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc:
ORA-01111: name for data file 185 is unknown - rename to correct file
ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185'
ORA-01157:...
Protected: CRS-41053: Checking Oracle Grid Infrastructure for file permission issues CRS-4000
# crsctl start crs
CRS-41053: checking Oracle Grid Infrastructure for file permission issues
PRVG-11960 : Set user ID bit is not set for file "/u01/app/grid/12.2.0/grid/bin/extjob" on...
Protected: Improve Performance of Data Pump Import In Oracle 19c
The Oracle Data Pump Export and Import utilities are designed especially for very large databases. If you have large quantities of data versus metadata,...
Protected: CRS-2974: unable to act on resource
Problem Summary:
On a 19c RAC DB when shutting down instance using srvctl command it throws below error:
$ srvctl stop instance -d prod -i...
Protected: Create Trigger to Detect Client/App related error.
Use the CREATE TRIGGER statement to create and enable a database trigger, which is:
A stored PL/SQL block associated with a table, a schema, or the database orAn anonymous...
Protected: Result cache in Oracle 11g
The result cache stores the results of SQL queries and PL/SQL functions in an area called Result Cache Memory in the shared pool.
Server result...
Protected: Blocking sessions in Oracle
Blocking sessions are a problem for the DBA which occur when a session issues an insert, update or delete command that changes a row.
When...
Oracle AWR (Automatic Workload Repository)
Automated Workload Repository (AWR) report (awrrpt.sql), which is very similar to the STATSPACK elapsed-time report. The AWR elapsed-time report (awrrpt.sql)contains valuable information regarding the...
sec_case_sensitive_logon Parameter in oracle
The SEC_CASE_SENSITIVE_LOGON parameter is deprecated. It is retained for backward compatibility only.
SEC_CASE_SENSITIVE_LOGON enables or disables password case sensitivity in the database.
true: Database logon passwords are case sensitive.
false:...
Crontab
Cron is named after Greek word “Chronos” that is used for time. It is a system process that will automatically perform tasks as per...
Linux Operating System 2.
File Permissions
The "umask" command can be used to read or set default file permissions for the current user. The umask value is subtracted from...
Linux Operating System 1.
File and Directory
The "pwd" command displays the current directory:
# pwd
/u01/app/oracle/product/19.0.0/dbhome_1
The "ls" command lists all files and directories in the specified directory. If no location is defined it...
Automatic Diagnostic Repository (ADR)
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. ADRCI enables you to:
View diagnostic data...
Details of PGA, SGA, db_cache, shared_pool and db/sp%, subpools
with PGA_GB as (SELECT VALUE/(1024*1024*1024) PGA_GBFROM V$PARAMETER WHERE NAME = 'pga_aggregate_target'),subpools as (SELECT COALESCE(SUM(VALUE/(1)), NULL) subpoolsFROM V$PARAMETER WHERE NAME = '_kghdsidx_count'),SGA_GB as (select (trunc(sum(value)/1024/1024/1024,2))...
Protected: Purge Archivelog Script
Add this entry to crontab as oracle user:
##Temp purge applied arch logs.
*/5 * * * * /home/oracle/scripts/purge_applied_archives.ksh <INST_SID> >>/home/oracle/scripts/purge_standby_logs.log 2>&1
#!/usr/bin/ksh
export CmdName=${0##*/}
export CmdDir=${0%%"/${CmdName}"*}
if ]
then
...
ORA-1652: unable to extend temp segment by 128 in tablespace
Overview:
The ORA-01652 error concerns a failure in allocating the extent for the temp segment in the tablespace. The temp segment refers to a temporary...
Users
Create user
CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE_NAME> TEMPORARY TABLESPACE ;
Drop user
drop user <USERNAME> cascade;
Alter user
alter user <USERNAME> identified by (account unlock);
Backup...
ORA-32001: How to identify if the database was started with spfile or pfile?
There are couple of ways of finding if the database was started with spfile or pfile.
First we can check the value of parameter spfile,...
19c New Features
In this article, we’ll discuss 5 new features and functionality of Oracle Database 19c that will have you not just ready, but excited for...