Techgoeasy

How to check RMAN backup status in sql

We can check RMAN backup status in sql using the below sql col STATUS format a9 col hrs format 999.99 select SESSION_KEY,SESSION_RECID,SESSION_STAMP, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This is very helpful when you are operating in a DBCS(Database Cloud Service) environment with automated backup. The …

How to check RMAN backup status in sql Read More »

Create EBS user from backend & Assign Responsibility

Oracle, Oracle Ebuisness Suite

Oracle EBS users can be created from the front end through Oracle forms or using backend PLSQL Blocks as well. We will see how to create user in oracle apps from the backend in this post Application User can be created from sqlplus using PLSQL Block Set serveroutput on BEGIN fnd_user_pkg.CreateUser(x_user_name => ‘UserName’ ,x_owner => …

Create EBS user from backend & Assign Responsibility Read More »

Script to check locks in oracle database

Oracle, Oracle Database

In this post, we will see the Script to check locks in oracle database, how to check locks in oracle, how to check lock on table in oracle Locks is a process in the Oracle database through which it maintains consistency and concurrency. So they keep coming and going. We generally don’t need to worry …

Script to check locks in oracle database Read More »

Troubleshooting adpatch/adop failed job

Oracle, Oracle Ebuisness Suite

Types of jobs and their resolutions .odf files : -odf files are there to create tables, indexes , views etc.-If encountered locking, identify the session that holds the lock and kill the session. Do not skip the job because of locking. Sometimes odf failed to drop the index. then you can manually drop the index …

Troubleshooting adpatch/adop failed job Read More »

How to Get environment variables of running process in Linux

Oracle, Oracle Database, Oracle Ebuisness Suite

In this post, we will talk about one of the useful things that administrator often has to use. The topic is How To Get environment variables of running process in Linux. Let’s first start with what is environment variable and then find out How To Check Environment Variables for a Running Process in different flavours of Unix …

How to Get environment variables of running process in Linux Read More »

How to configure Automatic Managed Backup on ExaCS

Oracle, Oracle cloud

Oracle Provides Automatic Managed Backup Service on ExaCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy. We have two options in the backup object storage and recovery service. Here in this article , we are talking about object storage …

How to configure Automatic Managed Backup on ExaCS Read More »