Adnan Khurshid on April 4th, 2011

For large output which is not able to fit in a single window, scrolling the results can skip data while it looks messy as well. to get rid of scrolling, you can use the command “set pause on”. With pause ON, the output will come in small chunks and will continue only when you press […]

Continue reading about How to get rid of scrolling for long SQL output in Oracle

Adnan Khurshid on April 4th, 2011

This post will guide you how you can play with SQL using the interactive variable values inside the statement. To begin with, suppose we even don’t know which table we want to query from. To check all the tables inside the logged in database, you can query the TABLE_NAME from user_tables. To get all the […]

Continue reading about How to run SQL commands with an input variable

This is one of the most commonly observed error in Oracle database. The exact error description is as follows: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SUN OS Error: 2: No such file or directory Due to this error, the DBA is unable to login to the SQL prompt. This […]

Continue reading about How to resolve Oracle Error “shared memory realm does not exist”

Adnan Khurshid on March 4th, 2011

Let’s discuss the processes running in Oracle database and their functions. DBW`: Database Writer, this process writes the data from buffer cache to the DB file and this operation of reading and writing is done in blocks. The default block size in Oracle is 8192 bytes, however it can be modified as required. Starting from […]

Continue reading about Basics of Oracle System Processes

Adnan Khurshid on February 11th, 2011

There are mainly 4 steps involved. 1) Create users for ISQL*PLUS DBA URL 2) Grant webdba role to those users 3) Restart the httpserver 4) Access the webpage @ http://localhost:port/isqlplus/dba Let’s follow these steps. 1) To create users, first you’ll have to define java_home and oracle_home and then run this weird long command to get […]

Continue reading about How to login to ISQL*PLUS as sysdba in Oracle

Adnan Khurshid on February 11th, 2011

The default port to access iSQL*PLUS is 5560. You can access iSQL*PLUS with the following URL given that the oracle is installed on the local host ‘http://localhost:5560/isqlplus/’ To change the port number, modify the file “http-web-site.xml” as given below:

Continue reading about How to change the port number for iSQL*PLUS in Oracle

Adnan Khurshid on February 1st, 2011

If you need to drop a table in informix and create it again, you require the script which was initially used to create that table. To get the SQL script, we use dbschema command. Most frequently, the command is used in the following format. dbschema -d <database> -t <tablename> -ss <file_name>                                                                             |__ To Generate Server […]

Continue reading about How to retrieve SQL script for table creation from Informix