Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
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 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
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
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
Last updated on November 26th, 2018 at 05:21 pmDelete from table statement is used in Sql to delete the rows in the table. It is a DML (Data Manipulation language) statement. It is used to delete the subset of existing rows or all existing rows from the table. we will looking at Oracle Sql syntax but this is valid for sql’s Here is the syntax … Continue reading Delete from table statement in Oracle
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
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
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
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
Many times we need to change password on the remote desktop. And you find that when you press Ctrl + Alt + Del while in RDP, this is still passed to the local computer from where you have setup the Remote desktop connection. I have too encountered this issue recently and I did lot of research over it to find the various solution Here are … Continue reading How to change password on Remote desktop (RDP)
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
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