10 Tricks You Must Know When Using Autoconfig In Oracle R12

Last updated on November 10th, 2019 at 05:40 pmIntroduction to Autoconfig in oracle apps R12 -Autoconfig in oracle apps r12 is a tool that supports automated configuration of an Applications instance. -Autoconfig tool is a set of scripts to centralize and simplify E-Business Suite configuration management. -It does so by maintaining a central repository of E-Business Suite environment information in a context file(.xml) on each midtier. … Continue reading 10 Tricks You Must Know When Using Autoconfig In Oracle R12 »

How to Login to Oracle Cloud Database using SSH tunnel

When a oracle database cloud instance is created, network access to the instance is limited to Secure Shell (SSH) connections on port 22. This access restriction ensures that the instance is secure by default. You can either ask your cloud service administrator to open ports or, as you will learn in this tutorial, you can use SSH client software to create an SSH tunnel to … Continue reading How to Login to Oracle Cloud Database using SSH tunnel »

How to create additional User on Oracle Compute instance (Linux/Window)

When we create the Oracle Compute instance (Linux/Window), by default OPC user is created and it has sudo privileges on linux and add user account privileges on Windows instance To create an additional SSH-enabled user on Linux Compute instance 1.Generate an SSH key pair for the new user. How to generate ssh key pair on Unix using ssh-keygen How to Use Puttygen on Windows for … Continue reading How to create additional User on Oracle Compute instance (Linux/Window) »

How to Login to compute instance in oracle cloud (Linux/Window)

We can have both Linux and Window compute instance in Oracle cloud. Lets learn about how to login to both the Linux and Window compute instance Linux Compute Instance We first need to make sure, we have the public IP associated with the Compute instance and security list allowed to connection to the SSH port 22 on that instance We have two ways to connect … Continue reading How to Login to compute instance in oracle cloud (Linux/Window) »

Top Oracle Cloud Key Terms which you should not Forget

Oracle Cloud Key Terms Oracle Cloud Identifier (OCID) Oracle Cloud Identifier (OCID) is a unique name assigned to every resource you provision on OCI. This is an auto-generated long string used by Support Engineers to identify your cloud resource when working with any Support Tickets. The customer can’t choose a preferred value for OCID and can’t modify it for the life of cloud resource. The … Continue reading Top Oracle Cloud Key Terms which you should not Forget »

How to Prepare for OCI Certification (1Z0-932)

How to Prepare for OCI Certification Who is a cloud architect? is responsible to architect cloud solutions has a strong understanding of cloud computing concepts knows all components of OCI builds a highly resilient infrastructure in cloud translates on-premises infrastructure to a typical cloud based infrastructure How to Prepare Step by Step Here is the recommended learning path for an individual to successfully prepare for … Continue reading How to Prepare for OCI Certification (1Z0-932) »

Top 33 Oracle RMAN Interview Questions

Last updated on November 7th, 2019 at 03:15 am Oracle RMAN Interview Questions Question 1 What is RMAN? Answer RMAN stands for recovery manager.it is a utility that can manage your entire Oracle backup and recovery activities. Question 2 What is the Difference between catalog and nocatalog mode in RMAN? Answer Few differences a.Recovery catalog is central and can have information of many databases. While … Continue reading Top 33 Oracle RMAN Interview Questions »

All about alter system kill session in Oracle database

Alter system kill session command alter system kill session is a very important command for Oracle DBA. We can kill any session in the oracle database with the help of it Syntax alter system kill session ‘sid, serial#’; Here sid, serial# can be obtained from v$session view. select sid, serial# from v$session where username=’SCOTT’; For Oracle RAC database You can either login to same instance … Continue reading All about alter system kill session in Oracle database »

CPU vs Core Vs Socket

Physical CPU It is the physical Processor on the server.Each CPU is assigned to one socket Core Each Physical CPU consist of single or Multiple Processing unit which are called Core of the Physical CPU. A Physical CPU could be dual core,quad core .It is the core which execute all the program  instructions. In multiple core processor,multiple programs can be executed in parallel providing better … Continue reading CPU vs Core Vs Socket »

What is a Bind Variable in Oracle

Last updated on October 8th, 2019 at 05:47 pmWhat is a Bind Variable? -It is a placeholder for a value .It is replaced by actual value when the SQL statement is executed -In PL/SQL it is called a local or global variable. DECLARE l_empl_id DEPT.emp_id%TYPE; BEGIN select first_name  from DEPT  where id = l_empl_id; END; -in SQL*Plus it is a variable variable a number BEGIN :a … Continue reading What is a Bind Variable in Oracle »