Update statement in oracle

Update statement in oracle is used to update the existing rows in the table. It is a DML statement. DML stand data manipulation language. We can use this statement to update specific rows ,set of rows or all rows in the table. Syntax is given below Table : It is the table name which need to be updated column : it is the single column … Continue reading Update statement in oracle »

Unable To Authenticate Session in R12

Unable To Authenticate Session or Unable to create session is one of the most common errors in R12 instance ERROR ———————– “Unable to authenticate session” This can happen after the instance is cloned or any changes happened to the system with wrong parameter The first log which you should check in case of this error is $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log Here are some common errors which you might … Continue reading Unable To Authenticate Session in R12 »

Helpful queries for Oracle Apps

How to compile the package,package body ,procedures alter package <package name > compile; alter package <package name > compile body; alter procedure <procedure name > compile; If it is not successfully compiled, we can look at the errors from the below sql Login to SQL*Plus. SELECT text FROM dba_errors WHERE name = packagename; The output will look something like this. TEXT ——————————————————————— PLS-00302: component ‘XYZ’ … Continue reading Helpful queries for Oracle Apps »

How to assign User management Responsibility to user in R12

You may need sometimes to assign User management responsibility to the users in EBS R12 Steps to assign the responsibility are Open Define User form Look for the user which need to assigned the responsibility by typing user name in username column and pressing F11 Assign the user management responsibility to the user and Press Save Now User should be  able to see the responsibility … Continue reading How to assign User management Responsibility to user in R12 »

How to install SSH on Ubuntu

SSH is nice tool to connect to the server. it encrypts all traffic to eliminate eavesdropping, connection hijacking, and other attacks. I will be giving the steps for installing that on Ubuntu OS Step 1: First check if it is already running ps -ef |grep -i SSH Step 2:  Now install the SSH using the command sudo apt-get install openssh-server -y Here are some issue … Continue reading How to install SSH on Ubuntu »

35 Useful command to help you manage the VPS or Dedicated Server

Last updated on October 30th, 2018 at 04:52 amThese are 35 Most Useful command to help you manage the VPS (Virtual Private server) or Dedicated Server. This should help you in daily work on  the server.  I have included command for all major Linux distribution like Cent-OS ,Ubuntu 1)How to connect to Server using putty Download Putty here a)Provide Hostname or IP address of the VPS … Continue reading 35 Useful command to help you manage the VPS or Dedicated Server »

how to start and stop httpd service

Apache is the HTTP server which is freely available over internet. it is widely used on Linux distribution to host websites.  Apache configuration is managed by the configuration file httpd.conf. You can use locate command to find the configuration  file $ locate httpd.conf /etc/httpd/conf/httpd.conf After making the change , you need to restart the Apache services to make it effective Command for  Linux version 4.x/5.x/6.x … Continue reading how to start and stop httpd service »

How to start and stop mysql on Linux

MySQL is a open source database widely used in Industry. If the MySQL. is hosted on Linux platform,here are the steps to stop and start the MySQL. /etc/init.d/mysqld  status The above gives the status of the mysql service /etc/init.d/mysqld  stop The above gives the stop of the mysql service /etc/init.d/mysqld  start The above gives the start of the mysql service /etc/init.d/mysqld  restart The above gives … Continue reading How to start and stop mysql on Linux »

Useful information about INSERT statement in Oracle

Last updated on October 30th, 2018 at 04:56 amINSERT statement  is a DML ( Data Manipulation Language) command . It is use to insert new rows into the tables Syntax INSERT INTO <table_name> (col1, col2, … column_n ) VALUES (value1, value2, … value_n ); Here table_name: Table where new records need to be inserted col1,col2 : are the column in the tables value1,value2….: are the … Continue reading Useful information about INSERT statement in Oracle »

ORA-01652: unable to extend temp segment: Solutions

We receive this error while inserting data,creating index, table when we don’t have enough space in tablespace. Solution is to add sufficient space in the tablespace identified in the error. There are three ways to do  it Add datafile Resize the existing datafile autoextent the datafile Each one is explained below with example below we  can use ALTER TABLESPACE to add datafile in tablespace like Default Tablespace Syntax … Continue reading ORA-01652: unable to extend temp segment: Solutions »