Cursor In Oracle/Oracle Tutorial/plsql programming

Cursor In Oracle .What is Cursor? it is a pointer to this context area. Oracle creates context area for processing an SQL statement which contains all information about the statement.

Friday, February 27, 2015

ORA-01033: ORACLE initialization or shutdown in progress

      No comments   

When you login into Oracle Database and it throws following error message: i could not login into my account . I was unable to login with the following error. But datbase was in open state.

If your database shutdown is in progress then wait for some time until the database is shutdown and start your database with Startup command.
ORA-01033: ORACLE initialization or shutdown in progress

Under this situation follow the following steps:

 SQL> startup mount

ORACLE Instance started

SQL> recover database

Media recovery complete

SQL> alter database open

Database altered

0 comments:

Post a Comment

Click on the links below to visit site

Popular Posts

Recent Posts

Unordered List

Pages

Text Widget

Search This Blog
Powered by Blogger.

Followers

Total Pageviews

Cursor Video

Basic commands in-sql

Breaking

Top Page

About Me

CURSOR IN PL SQL

What is Cursor

Implicit Cursor
Cursor For Loop
Cursor With Parameter
Forward Declaration
LightBlog
Adbox

LOBs In PL/SQL

BFILES IN PL SQL

Most Trending

  • WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100 DECLARE
    Pl -sql : Programming Concept. --WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100  DECLARE  N NUMBER(3) :=0;  BEGIN  WHILE N<=100  LOO...
  • UPDATE NOWAIT clause in Plsql
    The WHERE CURRENT OF statement allows you to update or delete the record that was last fetched by the cursor.Using for update nowait will ...
  • Differences Between Anonymous Blocks and Subprograms
    1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle sto...
  • Differences Between Anonymous Blocks and Subprograms
    1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle stor...
  • IN clause IN SQL
    An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using in O...
  • Difference between TRUNCATE, DELETE and DROP commands
    The delete command is used to remove  rows from a Table. A where clause can be used to only remove some rows.if no where condition is specif...
  • For Loop
    --Write a PL_SQL block to insert numbers into student table  Using For Loop First You need to create table student. sql> create table stu...
  • Anonymous Blocks
    Anonymous blocks In this tutorial, you will learn about the PL/SQL block structure and how to write and execute the first PL/SQL block in S...
  • Replace Function In Sql
    Trim :- Removes leading and /or trailing blanks(or other characters ) from a string. Syntax:- TRim([[<trim_spec >] char ] SQL> sele...
  • How to create Database Manually in oracle
    CREATING   MANUAL  DATABASE Create the following directories in a folder where u want to create database: --          c:\oracle\admin\dbname...

Popular Posts

  • WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100 DECLARE
    Pl -sql : Programming Concept. --WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100  DECLARE  N NUMBER(3) :=0;  BEGIN  WHILE N<=100  LOO...
  • UPDATE NOWAIT clause in Plsql
    The WHERE CURRENT OF statement allows you to update or delete the record that was last fetched by the cursor.Using for update nowait will ...
  • Differences Between Anonymous Blocks and Subprograms
    1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle sto...
  • Differences Between Anonymous Blocks and Subprograms
    1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle stor...
  • IN clause IN SQL
    An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using in O...
  • Difference between TRUNCATE, DELETE and DROP commands
    The delete command is used to remove  rows from a Table. A where clause can be used to only remove some rows.if no where condition is specif...
  • For Loop
    --Write a PL_SQL block to insert numbers into student table  Using For Loop First You need to create table student. sql> create table stu...
  • Anonymous Blocks
    Anonymous blocks In this tutorial, you will learn about the PL/SQL block structure and how to write and execute the first PL/SQL block in S...
  • Replace Function In Sql
    Trim :- Removes leading and /or trailing blanks(or other characters ) from a string. Syntax:- TRim([[<trim_spec >] char ] SQL> sele...
  • How to create Database Manually in oracle
    CREATING   MANUAL  DATABASE Create the following directories in a folder where u want to create database: --          c:\oracle\admin\dbname...

Visit Site

Sample Text