JD Edwards CNC

We can use the power of ansible to automate the oracle client installation task on multiple servers.In this article, we will explain how we will achieve this by executing an ansible playbook from ansible control node. Ansible control node  is any machine where ansible tool is installed.    IMPORTANT POINTS: oracle 19c client will be installed on all nodes. Make sure  the servers where  client need to be installed has connectivity from ansible control server   Below are the steps : 1. Copy the oracle 19c client software ( zip file ) to ansible control server. [ansible_node] ls -ltr /oracle/LINUX.X64_193000_client.zip 2. Prepare the inventory file: The list of servers where oracle 19c client will be installed. [ansiblel_node] $ cat /home/ansible/ansible-scipts/host_inv [appserver] linux_host22 ansible_host=10.20.86.60 ansible_connection=ssh ansible_user=root ansible_ssh_pass=dbaclass@123 linux_host29 ansible_host=10.20.86.61 ansible_connection=ssh ansible_...

  Oracle database : Basics about pfile and spfile What is a parameter file Parameter file is a text or binary to store the database initialization parameters. The oracle instance reads the parameter file during startup which are then used to control the behavior of database instance and many other aspects as well. Such as : memory allocation (SGA and PGA), startup of optional background processes, Setting of NLS parameters etc. There are 2 types of parameter files, namely : 1. pfile (parameter file) – older way [ not recommended by oracle ] 2. spfile (server parameter file) – newer way [ recommended by oracle ] spfile was introduced starting from oracle 9i, untill that time text based pfile was used to store database initialization parameters. pfile V/s spfile pfile spfile Text file Binary file Parameters in pfile can be edited using any text editor spfile can not be edited using a text editor. Instead it can only be altered using the “”ALTER SYSTEM”” comm...