We faced below interesting issue in one of our test environments, I call it SPICE19 here. One of the datafile was deleted with the intent to recreate it. Unfortunately, database was up and running at that moment when the datafile was deleted at OS level. Observations - 1. Database SPICE19 was in noarchivelog mode. 2. No backups were available for restoration. 3. Datafile '/u02/oracle/oradata/SPICE19/users06' was created accidentally with a wrong name (should have been /u02/oracle/oradata/SPICE19/users06.dbf) 4. It was then removed using (rm) at OS level. 5. A new datafile was added with ..read more

This post will cover different approaches to deploy Object Storage Gateway. You can call Object Storage gateway as a bridge that will connect your on-premise environment with Object Storage. It enables File-to-object transparency.  Object Storage buckets are mounted as nfs mount points in your on-prem environment. Substantial information is available on Object storage gateway and links are shared in this post. Let's jump to understanding different approaches to deploy Object Storage Gateway. My observations when implementing below POCs- 1. Object Storage gateway can be deployed either o ..read more

Recently, I created a group and added user to that group for some testing.  Username - Useradmin001 Groupname - sysadmin01 Once testing was done, I decided to delete both user and group. When trying to delete a Useradmin001 user belonging to a group, I received below error notification on OCI- Cannot delete Useradmin001. A user in a group can’t be deleted. So I thought of deleting group as they both (group and user) were being used to testing and not needed anymore. Cannot delete sysadmin01. A group with members can’t be deleted. Finally figured out that we need to perform below step ..read more

 Recently, I was asked implications of Admin server availability when connecting to Oracle EBS login Page. When pondering further, Few scenarios that arise were - 1. What if running Admin server goes down for some reason, will this impact managed servers that are already running?2. Can we start managed server (say oacore_server1) if admin server is down? How? Let's start understanding relationship between admin server and managed server. Admin server  is the central entity for configuration of entire domain. You manage and  configure all resources in the domain through admin ser ..read more

  Desired state of a resource can be simply defined as the state that is mentioned in your resource block of tf file. Current state of a resource is the actual configuration state for the resource. This may be different from desired state mentioned in .tf file.   Terraform will only synchronize current state(changes done manually in console) to desired state(changes mentioned in your tf file) for attributes that are explicitly mentioned in your tf file. Case 1 – Please consider below example, note that object bucket ‘test_bucket is already present on OCI – resource "oci_objectstorag ..read more

  Issue -  Recently faced below 'Connection Timed Out' Error when trying to mount a freshly created OCI file system. Would like to share my experience and document this for future references. I am using public and private subnets with security lists defined for each. File system is created in the private subnet and faced below issue when trying to mount it from an instance in the same private subnet, sudo mount -v 10.3.2.10:/fssfortestcomp /mnt/fssfortestcomp mount.nfs: timeout set for Wed Sep  9 06:27:20 2020 mount.nfs: trying text-based options 'vers=4.1,addr=10.3.2.10,client ..read more

  ..read more

  ..read more

Oracle EBS migration involves migration of Oracle Enterprise edition database with additional products that come under E-business suite. Summarizing this migration, I would be highlighting some key notes on how this complete activity was planned. Initially we only had brief information about migration and in such a scenario, it is very important to gather further information. Below table was first step before deciding on migration approach - Information Gathering & Backup Task No Task Name Task Details 1 Backup Plan RMAN script - export v_rman_loc=/erp_backup/hotb ..read more

Introduction – Seasoned DBAs are already aware about architectural changes in 11i, r12 and r12.2. Likewise, there are some significant changes when you compile jsp pages in these versions. This article will cover important aspects when performing same action in different versions. We will start with 11i until r12.2 followed by a summary on differences and similarities. JSP Cache -          It is compiled version of JSP files. -          They have extension .class. -      &n ..read more