1 2 3 Previous Next 32 Replies Latest reply: Dec 8, 2012 6:04 AM by EdStevens RSS

    Beginners help

    962651
      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
          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
            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
              12cdb
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                Hi,

                                alter database open resetlog;

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