Oracle - Ajara - Page 14

by Team Ajara

Oracle Tablespace report in html format

Script to get Tablespace report in html format. Run the below script on SQL prompt of oracle database . It generates tbs_rep.html file . SET MARKUP HTML ON ENTMAP OFF

by Team Ajara

How to apply PSU Patch on Grid Infra and Database

Applying PSU Patch on Grid Infrastructure and Database PSU stands for PATCH SET UPDATE. Version Details Grid Version: 12.1.0.2 DB Version : 11.2.0.4 OS: Linux RAC : Two nodes

by Team Ajara

Oracle Database 19c installation requirements on AIX

Prerequisites for 19c installation: IBM AIX 7.1 on POWER Systems (64-Bit) Minimum Operating System Requirements Item Minimum Requirements SSH Requirement OpenSSH_7.5p1 or later AIX 7.1 Operating System AIX

by Team Ajara

Create Oracle service after DB restore to new server

Oracle Service creation after DB restore. Restore activity can be from Disk backup or tape backup or flash copy (with OS commands),but the service creation and configuration is same

by Team Ajara

ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn])

ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn]). ORA-00600 is an internal error code for Oracle databases. It indicates that an unexpected condition has occurred and the system encountered an internal inconsistency.

by Team Ajara

Steps to generate good plan from nonPROD to PROD

PT Issue: step by step Doc to generate good plan from nonPROD to PROD. Issue in detail: Query Performance of Hyperion application monthly batch job in PROD is very slow

by Team Ajara

ORA-19870: error while restoring CDB backup piece.

ORA-19870: error while restoring backup piece.ORA-19507, ORA-27029 We received above mentioned errors while restoring a tape backup from prod environment to non-prod env. As soon as the restoration starts ,

by Team Ajara

Script to get CPU intensive queries in oracle

Script to get CPU intensive queries in oracle. Query to get the SQL details that take more than 5 minutes ========================================================= SELECT sql_id, child_number, executions, elapsed_time, cpu_time, buffer_gets,

by Team Ajara

Oracle Enterprise Manager Agent restarts frequently

Oracle Enterprise Manager Agent restarts frequently Issue: OEM agent restarts frequently Steps to verify and fix the issue: $ cd $AGENT_HOME $ ./emctl stop agent

by Team Ajara

ORA-12520 TNS listener could not find available handler

ORA-12520 TNS listener could not find available handler for requested. This error received from the application team saying that connectivity issue from apps server . Error: ORA-12520 Verification:

Oracle Tablespace report in html format

How to apply PSU Patch on Grid Infra and Database

Oracle Database 19c installation requirements on AIX

Create Oracle service after DB restore to new server

ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn])

Steps to generate good plan from nonPROD to PROD

ORA-19870: error while restoring CDB backup piece.

Script to get CPU intensive queries in oracle

Oracle Enterprise Manager Agent restarts frequently

ORA-12520 TNS listener could not find available handler

Footer Links

Subscribe

All Technologies