Forum Stats

  • 3,741,752 Users
  • 2,248,473 Discussions
  • 7,861,976 Comments

Discussions

ORA-01033 after starting and trying to connect.

463783
463783 Member Posts: 16
I had XE installed and running yesterday on CentOS. Now after shutting down and rebooting I can no longer access the web page http://localhost:8080/htmldb and I get an ORA-01033 when trying to connect.

Any suggestions on where to start troubleshooting?

Shawn

Comments

  • 463737
    463737 Member Posts: 10
    Sounds like the DB didn't get started.
    Did you put a start entry in your rcX.d directory (where X=runlevel at which you want it to start)?

    Jim
  • 241066
    241066 Member Posts: 776
    This means that the database failed to shutdown properly. This could be for a number of reasons. You need to shutdown the database manually, and then restart. To shutdown manually go to the SQL Command Line (as the OS user that installed Oracle).

    At the SQL Prompt SQL> issue
    connect / as sysdba
    For example
    SQL> connect / as sysdba
    Connected.

    Then type
    shutdown immediate;

    You should see the following
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    Then type
    startup
    You should see the following
    SQL> startup
    ORACLE instance started.

    Total System Global Area 599785472 bytes
    Fixed Size 1249348 bytes
    Variable Size 192942012 bytes
    Database Buffers 402653184 bytes
    Redo Buffers 2940928 bytes
    Database mounted.
    Database opened.

    Just to be sure, also try a select
    select count(*) from hr.employees;
    You should see
    SQL> select count(*) from hr.employees;

    COUNT(*)
    ----------
    107

    Any problems or errors reported with any of these steps, please let us know.
  • 463783
    463783 Member Posts: 16
    No i didn't do anything to rcX.d. Although there are files in all of the rcX.d directories.
    FYI: "I'm still comming up to speed on linux."

    I was starting it manually from
    /etc/init.d/oracle-xe start

    I think I know whats wrong. Some how the database system tablespace was corrputed and it can't recover.

    Are the scripts included to manually recreate the database?

    Shawn
  • 241066
    241066 Member Posts: 776
    Yes, but the quickest way forward would be to remove everything and re-install.
  • 463783
    463783 Member Posts: 16
    Thanks!
    Thats what I was guessing.
This discussion has been closed.