Techgoeasy

Opmnctl command every administrator should know

Oracle, Oracle Database, Oracle Ebuisness Suite

opmnctl is widely used in iAS administration,We should know all the useful command for its administration. Here I am talking about some Opmnctl command every administrator should know. This is valid for both 10g and 11g Version (1) how to get the help on opmnctl opmnctl -helpusage: /u000/oracle/TEST/product/opmn/bin/opmnctl [verbose] [<scope>] <command> [<options>]verbose: print detailed execution message …

Opmnctl command every administrator should know Read More »

Oracle NULLIF() function

Oracle, Oracle Sql

This SQL tutorial provides explanations, examples for NULLIF function in Oracle NULLIF function is very useful function .It compare two values and return null if the values are same , else return the first value expr1 : it is the source values or expression which is going to be compared with expr2expr2 : It is …

Oracle NULLIF() function Read More »

How to check patches applied in weblogic |10.3.6 and 12c

Oracle, Weblogic

Here in this post, we will see how to check patches applied in weblogic in 10.3.6 version, 12c (12.1.1 and 12.1.2 and later ). How to check patches applied in weblogic in the 10.3.6 version and up to 12.1.1 Now how to check patches applied in weblogic in 10.3.6 For Unix cd $MW_HOME/utils/bsu/ bsu.sh -prod_dir=$MW_HOME\wlserver_10.3 …

How to check patches applied in weblogic |10.3.6 and 12c Read More »

How do I create a SSH tunnel (Port Forwarding) in PuTTY to connect to Oracle database on Cloud

Oracle, Oracle cloud

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 …

How do I create a SSH tunnel (Port Forwarding) in PuTTY to connect to Oracle database on Cloud Read More »

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

Oracle, Oracle cloud

When we create the Oracle Compute instance (Linux/Window), by default OPC user is created and it has sudo privileges on Linux and adds 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 …

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

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

Oracle, Oracle cloud

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 …

How to Prepare for OCI Certification (1Z0-932/ 1Z0-1072) Read More »