Database Examples

############# Database Troubleshooting  Examples ################

standby redo log file header 19.0.0.0.0 exceeded the one currently supported on this standby 12.1.0.2.0.

Install Error [DBT-50000] Unable to check for available memory 19c

AHF - 21c Autonomous Health Framework Report on 12.1.0.2.0 Grid

SLES 12 SP4 DNS configuration for RAC setup 12 R1

Pre oracle and grid Requestors setting on Suse12 sp4 for RAC 12.1.0.2.0

Oracle Operating System Pre Requestories OEL 6.7

ORA-00382: 32768 not a valid block size, valid range [2048..16384]

Install SwingBench On Window

Database installation using DBCA Silent installation with custom Template on 12C

Drop database manually by command

example-script-to-delete-old-dump-files

Database Creation 12.1.0.1.0 and above using template Script

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Oracle NID UTILITY TARGET -- Change DBNAME ONLY

Error : ORA-01919: role 'PLUSTRACE' does not exist

Oracle 12c ADCRI commands and examples

telnet enable window

Steps to Configure the UTL Mail in Oracle Database

deinstall oracle database manually 12.1.0.2.0

window service delete

Move datafile Online on 12c oracle database

Online Redo log file drop and recreate

Delete database Using response file

Install database software using Response file oracle 12c R1 db_install.rsp

Install database listener using NETCA Response file oracle 12c R1 netca.rsp

Install database DBCA using Response file oracle 12c R1 dbca.rsp

Disable firewall and SElinux prior to Oracle 12c Database install

Creating a persistent File System on an OEL 6.7 Virtual Machine

Register Oracle Window 11g and 12c database listener on same hostname ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

/extjobO': Operation not permitted make: [iextjob] Error 1 (ignored)

deinstall oracle database manually 12.1.0.2.0

Add disk on VM Virtualbox

#################################################################

DBA_jobs check 

SELECT job, next_date, next_sec, failures, broken, SUBSTR(what,1,40) DESCRIPTION FROM dba_jobs

 select JOB,LOG_USER,PRIV_USER,SCHEMA_USER,LAST_DATE,THIS_DATE,NEXT_DATE,BROKEN,FAILURES,WHAT,INTERVAL from dba_jobs where WHAT like '%SS_EXPORT_SUSPENDED_DATA%';

################################################################

Index Check usable -unusable 

SELECT OWNER, INDEX_NAME, NULL AS PARTITION_NAME, NULL AS SUBPARTITION_NAME, TABLESPACE_NAME,status FROM DBA_INDEXES WHERE owner='GTIPDBA' and STATUS = 'UNUSABLE';

UNION ALL

SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, NULL AS SUBPARTITION_NAME, TABLESPACE_NAME,status FROM DBA_IND_PARTITIONS WHERE STATUS = 'UNUSABLE'; 

UNION ALL

SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, SUBPARTITION_NAME, TABLESPACE_NAME,STATUS FROM DBA_IND_SUBPARTITIONS WHERE STATUS = 'UNUSABLE';