This discussion is archived
1 2 3 Previous Next 32 Replies Latest reply: Dec 8, 2012 4:04 AM by EdStevens RSS

Beginners help

962651 Newbie
Currently Being Moderated
Hi, I'm a complete noob to oracle 11g, I'm running Fedora 17 and I need to know how to solve this error I keep getting in the sqlplus command line:
SQL> CONNECT SYSTEM
Enter password: 
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
What is the problem here?

Edited by: 959648 on Nov 10, 2012 12:44 AM
  • 1. Re: Beginners help
    yoonas Expert
    Currently Being Moderated
    Hi,

    I think you know that oracle 11g is not certified on fedora 17.
    http://docs.oracle.com/cd/E11882_01/install.112/e24321/pre_install.htm#CIHFICFD

    Install on a certified os.

    Coming back to your problem, did the installation complete successfully .The message says the database is being in the process of starting or shutting down .

    If you have just started wait for some time and try connecting again.

    Regards
    Yoonas



    Edited by: yoonus on Nov 10, 2012 12:58 AM

    Edited by: yoonus on Nov 10, 2012 1:03 AM
  • 2. Re: Beginners help
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    ORA-01033: ORACLE initialization or shutdown in progress.
    Cause: An attempt was made to log on while Oracle is being started up or shutdown.
    Action: Wait a few minutes. Then retry the operation

    Check
    http://www.dbmotive.com/ora-01033-oracle-initialization-or-shutdown-in-progress/
  • 3. Re: Beginners help
    user296828 Expert
    Currently Being Moderated
    As suggested earlier, the database seems down.
    You can also check oracle process status if they are running at OS level.
    $ps -ef | grep ora_
  • 4. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    Ok, so my teacher told me I could solve the issue by running a shell script, but I go into the the oracle directories to run it, I get another error:
    [eddie_nygma@localhost scripts]$ cd /u01/app/oracle/product/11.2.0/xe/config/scripts
    [eddie_nygma@localhost scripts]$ ls
    backupdatabase.sh     initXETemp.ora        registerforonlineforum.sh  startdb.sql
    backup.sh             oracle-xe             restoredatabase.sh         stopall.sh
    cloneDBCreation.sql   oraclexe.menu         restore.sh                 stopdb.sh
    CloneRmanRestore.sql  oraclexe-merge.menu   rmanBackup.sql             stopdb.sql
    conmsg.sql            oracle-xe.sles        rmanRestoreDatafiles.sql   XE.sh
    gettingstarted.sh     postDBCreation.sql    runsqlplus.sh              XE.sql
    gotoonlineforum.sh    postScripts.sql       sqlplus.sh
    init.ora              readdocumentation.sh  startdb.sh
    [eddie_nygma@localhost scripts]$ ./startdb.sh
    which is followed by an error message saying "eddie_nygma must be in the DBA OS group to start the database." ... So how doI add myself to that specific user group?
  • 5. Re: Beginners help
    sb92075 Guru
    Currently Being Moderated
    959648 wrote:
    Ok, so my teacher told me I could solve the issue by running a shell script, but I go into the the oracle directories to run it, I get another error:
    [eddie_nygma@localhost scripts]$ cd /u01/app/oracle/product/11.2.0/xe/config/scripts
    [eddie_nygma@localhost scripts]$ ls
    backupdatabase.sh     initXETemp.ora        registerforonlineforum.sh  startdb.sql
    backup.sh             oracle-xe             restoredatabase.sh         stopall.sh
    cloneDBCreation.sql   oraclexe.menu         restore.sh                 stopdb.sh
    CloneRmanRestore.sql  oraclexe-merge.menu   rmanBackup.sql             stopdb.sql
    conmsg.sql            oracle-xe.sles        rmanRestoreDatafiles.sql   XE.sh
    gettingstarted.sh     postDBCreation.sql    runsqlplus.sh              XE.sql
    gotoonlineforum.sh    postScripts.sql       sqlplus.sh
    init.ora              readdocumentation.sh  startdb.sh
    [eddie_nygma@localhost scripts]$ ./startdb.sh
    which is followed by an error message saying "eddie_nygma must be in the DBA OS group to start the database." ... So how doI add myself to that specific user group?
    can you log into OS as root user?
  • 6. Re: Beginners help
    yoonas Expert
    Currently Being Moderated
    Hi,

    So which user did you use to install the database? Did you follow the oracle installation manual?
    Adding user to a group in GUI
    Application > Other > Users And Groups
    Select the user, double click and open properties
    Go to Groups tab and tick the dba group. If dba does not exist create one using add group

    Command line

    start a terminal
    switch user to root
    usermod -G dba eddie_nygma
    to create dba group - groupadd dba

    Regards
    Yoonas
  • 7. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    Startdb.sh did nothing for me I'm still getting the same error, here's the process output:
    [root@localhost eddie_nygma]# ps -ef | grep ora_
    root      4182  4135  0 01:45 pts/0    00:00:00 grep --color=auto ora_
    [root@localhost eddie_nygma]# ps -ef | grep oracle
    oracle    3869     1  0 01:41 ?        00:00:00 xe_pmon_XE
    oracle    3871     1  0 01:41 ?        00:00:00 xe_psp0_XE
    oracle    3873     1  0 01:41 ?        00:00:00 xe_vktm_XE
    oracle    3877     1  0 01:41 ?        00:00:00 xe_gen0_XE
    oracle    3879     1  0 01:41 ?        00:00:00 xe_diag_XE
    oracle    3881     1  0 01:41 ?        00:00:00 xe_dbrm_XE
    oracle    3883     1  0 01:41 ?        00:00:00 xe_dia0_XE
    oracle    3885     1  0 01:41 ?        00:00:00 xe_mman_XE
    oracle    3887     1  0 01:41 ?        00:00:00 xe_dbw0_XE
    oracle    3889     1  0 01:41 ?        00:00:00 xe_lgwr_XE
    oracle    3891     1  0 01:41 ?        00:00:00 xe_ckpt_XE
    oracle    3893     1  0 01:41 ?        00:00:00 xe_smon_XE
    oracle    3895     1  0 01:41 ?        00:00:00 xe_reco_XE
    oracle    3897     1  0 01:41 ?        00:00:00 xe_mmon_XE
    oracle    3899     1  0 01:41 ?        00:00:00 xe_mmnl_XE
    oracle    3901     1  0 01:41 ?        00:00:00 xe_d000_XE
    oracle    3903     1  0 01:41 ?        00:00:00 xe_s000_XE
    oracle    3905     1  0 01:41 ?        00:00:00 xe_s001_XE
    oracle    3907     1  0 01:41 ?        00:00:00 xe_s002_XE
    oracle    3909     1  0 01:41 ?        00:00:00 xe_s003_XE
    1000      4033  3051  0 01:42 ?        00:00:00 /bin/bash /u01/app/oracle/product/11.2.0/xe/config/scripts/runsqlplus.sh
    1000      4035  4033  0 01:42 ?        00:00:00 /usr/bin/gnome-terminal -t SQL*Plus -e /u01/app/oracle/product/11.2.0/xe/config/scripts/sqlplus.sh
    1000      4040  4035  0 01:42 pts/1    00:00:00 /bin/bash /u01/app/oracle/product/11.2.0/xe/config/scripts/sqlplus.sh
    1000      4047  4040  0 01:42 pts/1    00:00:00 sqlplus        @/u01/app/oracle/product/11.2.0/xe/config/scripts/conmsg.sql
    oracle    4064  4047  0 01:44 ?        00:00:00 oracleXE (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    root      4184  4135  0 01:45 pts/0    00:00:00 grep --color=auto oracle
    So, what should my next step be in trying to fix this so I can connect successfully in sqlplus?
  • 8. Re: Beginners help
    yoonas Expert
    Currently Being Moderated
    Hi,
    ps output shows database processes are running.

    What error message are you getting when you try to connect with sqlplus.

    Regards
    Yoonas
  • 9. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    Same one as in my first post:
    SQL> CONNECT SYSTEM
    Enter password: 
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress
    Process ID: 0
    Session ID: 0 Serial number: 0 
  • 10. Re: Beginners help
    yoonas Expert
    Currently Being Moderated
    Hi,
    connect / as sysdba
    if its connecting run this code and see
    select open_mode from v$database;
    do a shutdown
    shutdown immediate
    Rrestart
    startup
    post the alert log(alert_xe) content
    Regards
    Yoonas
  • 11. Re: Beginners help
    962651 Newbie
    Currently Being Moderated
    Okay firstly, I have no idea what folder to find alert_xe in, but let me show my sqlplus output:
    SQL>connect / as sysdba
    Connected to an idle instance.
    SQL>select open_ mode from v$database
    select open_mode from database
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial Number: 0
    
    
    
    SQL>shutdown immediate
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    SQL>startup
    ORACLE instance started.
    
    Total System Global Area 1068937216 bytes
    Fixed Size                            2233344 bytes
    Variable Size                    616565760 bytes
    Database Buffers              444596224 bytes
    Redo Buffers                          551888 bytes
    Database mounted.
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open   
    What do I do next?
  • 12. Re: Beginners help
    yoonas Expert
    Currently Being Moderated
    Hi,

    alter database open resetlog;

    Regards
    Yoonas
  • 13. Re: Beginners help
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Alter database Open Resetlogs ;
  • 14. Re: Beginners help
    sb92075 Guru
    Currently Being Moderated
    What do I do next?
    hope you have backups that can be restored.
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points