1 2 Previous Next 19 Replies Latest reply on Apr 24, 2009 9:34 AM by 697798 Go to original post
      • 15. Re: Starting Oracle
        Pavan Kumar
        Hi,

        I think data file got corrupted. Do you have any backup with you.

        - Pavan Kumar N
        • 16. Re: Starting Oracle
          612265
          i had database backup
          which is created by using exp command


          did u mean that
          • 17. Re: Starting Oracle
            Satish Kandi
            If that is the only thing left with you, then you need to scrap the existing database and create a new one. Import this dump into that database and loose the changes that have taken place in the time when export was taken and the crash occurred.
            • 18. Re: Starting Oracle
              509477
              I went to the Dos prompt and typed rman.
              Then I types delete backup and that solved the problem.
              Its what was in the log file I posted earlier.

              tom
              • 19. Re: Starting Oracle
                697798
                I am trying to slove this problem by your solution, but I still can't connect to my database(Oracle 11g).

                ---
                SQL> startup nomount
                ORA-32004: obsolete and/or deprecated parameter(s) specifie
                ORACLE 執行處理已啟動. ~~~~> It's mean "ORACLE Process is runing."

                Total System Global Area 535662592 bytes
                Fixed Size 1334380 bytes
                Variable Size 348128148 bytes
                Database Buffers 180355072 bytes
                Redo Buffers 5844992 bytes
                SQL> alter database mount;
                alter database mount
                *
                ERROR 在行 1: ~~~~> ERROR in Line 1
                ORA-01507: ??????   ~~~~> I don't know why it is just show "??????"

                ---

                The Error message in OEM screen is:
                ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)
                ---

                I had set the environment parameter about ORACLE_SID(orcl) and ORACLE_HOME(E:\app\Administrator\product\11.1.0\db_1) in my OS(MS Windows XP).

                I had set thesqlnet.ora ( SQLNET.AUTHENTICATION_SERVICES= (NONE) ), and restart OracleService & OS again and again.

                Could somebody tell me what the problem is, and how can I do?


                The content of alert_orcl.log is here:
                ---
                Fri Apr 24 17:30:44 2009
                Shutting down instance: further logons disabled
                Stopping background process MMNL
                Stopping background process MMON
                Shutting down instance (immediate)
                License high water mark = 2
                Waiting for dispatcher 'D000' to shutdown
                All dispatchers and shared servers shutdown
                ALTER DATABASE CLOSE NORMAL
                ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
                ARCH: Archival disabled due to shutdown: 1089
                Shutting down archive processes
                Archiving is disabled
                Archive process shutdown avoided: 0 active
                ARCH: Archival disabled due to shutdown: 1089
                Shutting down archive processes
                Archiving is disabled
                Archive process shutdown avoided: 0 active
                Fri Apr 24 17:30:48 2009
                Stopping background process VKTM:
                Fri Apr 24 17:30:50 2009
                Instance shutdown complete
                Fri Apr 24 17:30:59 2009
                Starting ORACLE instance (normal)
                LICENSE_MAX_SESSION = 0
                LICENSE_SESSIONS_WARNING = 0
                Picked latch-free SCN scheme 2
                Autotune of undo retention is turned on.
                IMODE=BR
                ILAT =18
                LICENSE_MAX_USERS = 0
                SYS auditing is disabled
                Starting up ORACLE RDBMS Version: 11.1.0.6.0.
                Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
                System parameters with non-default values:
                processes = 150
                memory_target = 512M
                control_files = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
                control_files = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL"
                control_files = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL"
                db_block_size = 8192
                compatible = "11.1.0.0.0"
                log_archive_start = TRUE
                log_archive_dest_1 = "LOCATION=E:\app\Administrator\product\11.1.0\db_1\RDBMS MANDATORY REOPEN=300 QUOTA_SIZE=32M"
                log_archive_dest_10 = "LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300"
                db_recovery_file_dest = "E:\app\Administrator\flash_recovery_area"
                db_recovery_file_dest_size= 10G
                undo_tablespace = "UNDOTBS1"
                remote_login_passwordfile= "EXCLUSIVE"
                db_domain = "(My IP Address)"
                dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
                audit_file_dest = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
                audit_trail = "DB"
                db_name = "orcl"
                open_cursors = 300
                diagnostic_dest = "E:\APP\ADMINISTRATOR"
                Deprecated system parameters with specified values:
                log_archive_start
                End of deprecated system parameter listing
                Fri Apr 24 17:30:59 2009
                PMON started with pid=2, OS id=2124
                Fri Apr 24 17:30:59 2009
                VKTM started with pid=3, OS id=2312 at elevated priority
                Fri Apr 24 17:30:59 2009
                DIAG started with pid=4, OS id=4052
                VKTM running at (20)ms precision
                Fri Apr 24 17:30:59 2009
                DBRM started with pid=5, OS id=712
                Fri Apr 24 17:31:00 2009
                PSP0 started with pid=6, OS id=1960
                Fri Apr 24 17:31:00 2009
                DSKM started with pid=7, OS id=2620
                Fri Apr 24 17:31:00 2009
                DIA0 started with pid=8, OS id=3960
                Fri Apr 24 17:31:00 2009
                MMAN started with pid=9, OS id=2680
                Fri Apr 24 17:31:00 2009
                DBW0 started with pid=7, OS id=2548
                Fri Apr 24 17:31:00 2009
                LGWR started with pid=10, OS id=3504
                Fri Apr 24 17:31:00 2009
                CKPT started with pid=11, OS id=3412
                Fri Apr 24 17:31:00 2009
                SMON started with pid=12, OS id=2756
                Fri Apr 24 17:31:00 2009
                RECO started with pid=13, OS id=2996
                Fri Apr 24 17:31:00 2009
                MMON started with pid=14, OS id=1636
                starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                Fri Apr 24 17:31:00 2009
                MMNL started with pid=15, OS id=3584
                starting up 1 shared server(s) ...
                ORACLE_BASE from environment = E:\app\Administrator
                Fri Apr 24 17:31:06 2009
                alter database mount
                Setting recovery target incarnation to 2
                Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3680.trc:
                ORA-01507: ??????
                ORA-1507 signalled during: alter database mount...
                alter database open
                ORA-1507 signalled during: alter database open...
                ---

                Edited by: Life Reader on 2009/4/24 下午 5:31
                1 2 Previous Next