Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. Check if any running jobs currently: # odacli list-jobs. 2. If none, then stop the …
Read More »Manually remove ODA DB HOME
Removing Old Grid Home
Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-componentSystem Version—————19.20.0.0.0 System node Name—————testlinux …
Read More »AWR Snapshot Retention Period
AWR Snapshot Retention Period Configuration This article explores the process of modifying the AWR snapshot retention period in Oracle. Regarding AWR Reports The Oracle MMON background process gathers AWR …
Read More »ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Read More »unable to spawn jobq slave process, slot 0, error 1089
ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Read More »Temporary Tablespace and Datafile Management in Oracle database
Temporary Tablespace and Datafile Management in Oracle database 1. For Finding temp file and temp tablespace with size SELECT file#, status, bytes / 1024 / 1024 “Size_MB”, name FROM v$tempfile; SELECT file_name, tablespace_name, bytes / 1024 / 1024 / 1024, status FROM dba_temp_files; 2. Add …
Read More »How To Find Oracle Database 32 bit or 64 bit
How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle: …
Read More »Change Date and Time Formats In Oracle Database?
Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format=’DD/MONTH/YYYY’; Session altered. SQL> select sysdate …
Read More »Difference between P-File and SP-File?
Difference between P-File and SP-File? P-FILE SP-FILE It is called as parameter file. It is called as server parameter file. P-File is ASCII file and it can be edited Manually spfile is binary file and it …
Read More »How to rename a Datafile with Extension .dbf?
How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …
Read More »