Forum Stats

  • 3,854,276 Users
  • 2,264,345 Discussions
  • 7,905,628 Comments

Discussions

ORA-00214

2»

Answers

  • 1021200
    1021200 Member Posts: 125

    Hello,

    As per your assistance, What I did, is....

    I edit my pfile with original control file '/u01/app/oracle/oradata/orcl/control01.ctl'  and create spfile from pfile.

    SQL> create spfile from pfile

      2  ;

    File created.

    then shutdown the database and started with spfile:

    SQL> shutdown immediate

    ORA-01507: database not mounted

    ORACLE instance shut down.

    SQL> startup

    ORACLE instance started.

    Total System Global Area  835104768 bytes

    Fixed Size                  2217952 bytes

    Variable Size             562038816 bytes

    Database Buffers          268435456 bytes

    Redo Buffers                2412544 bytes

    Database mounted.

    Database opened.

    Problem has been resloved and database is opened.

    SQL> select open_mode from v$database;

    OPEN_MODE

    --------------------

    READ WRITE

    Thank You so much for your assistance (Alvaro and Sb)

This discussion has been closed.