Home 2022 September

Monthly Archives: September 2022

black and white photo of clocks

Protected: Linux Shell Script To Monitor GoldenGate Lag

0
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

0
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...
close up photo of programming of codes

Oratop Utility

0
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

0
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:...
yellow scrabble tiles

Protected: CRS-41053: Checking Oracle Grid Infrastructure for file permission issues CRS-4000

0
# 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...
close up shot of keyboard buttons

Protected: Improve Performance of Data Pump Import In Oracle 19c

0
The Oracle Data Pump Export and Import utilities are designed especially for very large databases. If you have large quantities of data versus metadata,...
yellow scrabble tiles

Protected: CRS-2974: unable to act on resource

0
Problem Summary: On a 19c RAC DB when shutting down instance using srvctl command it throws below error: $ srvctl stop instance -d prod -i...
close up shot of black rifle with scope

Protected: Create Trigger to Detect Client/App related error.

0
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...
network servers on an enclosure

Protected: Result cache in Oracle 11g

0
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...
man blocking a ball over the net

Protected: Blocking sessions in Oracle

0
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...
person writing on notebook

Oracle AWR (Automatic Workload Repository)

1
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...
KSC-20161117-PH-SWW01_0001

sec_case_sensitive_logon Parameter in oracle

0
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:...
black and white photo of clocks

Crontab

0
Cron is named after Greek word “Chronos” that is used for time. It is a system process that will automatically perform tasks as per...
a close up shot of a command key

Linux Operating System 2.

0
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...
a close up shot of a command key

Linux Operating System 1.

0
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...
person using macbook pro

Automatic Diagnostic Repository (ADR)

0
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...
a close up shot of a command key

Details of PGA, SGA, db_cache, shared_pool and db/sp%, subpools

0
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

0
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

0
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

0
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...
yellow scrabble tiles

ORA-32001: How to identify if the database was started with spfile or pfile?

0
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,...
Greeting card featuring two cartoons depicting Mr P.L. Oliver (blood donation memorabilia)

19c New Features

0
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...