13 Replies Latest reply: Oct 9, 2013 8:57 PM by Hemant K Chitale RSS

    Can't start the Database and can't backup

    Dan8

      Can't start the Database and can't backup

       

      What is happening now. My database connection is not stable so can't do the backup.

      I spent two days trying unsuccessfully. Please check the following print screen :

       

      [test@localhost ~]$ xhost +

      access control disabled, clients can connect from any host

      [test@localhost ~]$

      [test@localhost ~]$

      [test@localhost ~]$ su - root

      Password:

      [root@localhost ~]#

      [root@localhost ~]#

      [root@localhost ~]# su - oracle

      [oracle@localhost ~]$

      [oracle@localhost ~]$ export ORACLE_SID=db11gr2

      [oracle@localhost ~]$

      [oracle@localhost ~]$ echo $ORACLE_HOME

      /u01/app/oracle/product/11.2.0/db_1

      [oracle@localhost ~]$

      [oracle@localhost ~]$ echo $ORACLE_BASE

      /u01/app/oracle

      [oracle@localhost ~]$

      [oracle@localhost ~]$ echo $ORACLE_SID

      db11gr2

      [oracle@localhost ~]$

      [oracle@localhost ~]$ lsnrctl start

       

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2013 18:28:29

       

      Copyright (c) 1991, 2009, Oracle.  All rights reserved.

       

      Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

       

      TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

      Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      Start Date                17-SEP-2013 18:28:30

      Uptime                    0 days 0 hr. 0 min. 0 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

      Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

      Services Summary...

      Service "db11gr2" has 1 instance(s).

        Instance "db11gr2", status UNKNOWN, has 1 handler(s) for this service...

      The command completed successfully

      [oracle@localhost ~]$

      [oracle@localhost ~]$ emctl start dbconsole

      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

      Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.

      https://localhost.localdomain:1158/em/console/aboutApplication

      Starting Oracle Enterprise Manager 11g Database Control .............. started.

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

      Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_db11gr2/sysman/log

      [oracle@localhost ~]$

      [oracle@localhost ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 17 18:39:19 2013

       

      Copyright (c) 1982, 2009, Oracle.  All rights reserved.

       

      Connected to an idle instance.

       

      SQL> select STATUS, DATABASE_STATUS from v$instance;

      select STATUS, DATABASE_STATUS from v$instance

      *

      ERROR at line 1:

      ORA-01034: ORACLE not available

      Process ID: 0

      Session ID: 0 Serial number: 0

       

       

      SQL> select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database;

      select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database

      *

      ERROR at line 1:

      ORA-01034: ORACLE not available

      Process ID: 0

      Session ID: 0 Serial number: 0

       

       

      SQL> show parameter spfile

      ORA-01034: ORACLE not available

      Process ID: 0

      Session ID: 0 Serial number: 0

       

       

      SQL> startup

      ORACLE instance started.

       

      Total System Global Area  799313920 bytes

      Fixed Size                  1339484 bytes

      Variable Size             318771108 bytes

      Database Buffers          473956352 bytes

      Redo Buffers                5246976 bytes

      Database mounted.

      Database opened.

      SQL>

      SQL>

      SQL> show parameter spfile

      ORA-03135: connection lost contact

      Process ID: 8828

      Session ID: 1 Serial number: 5

       

       

      SQL> select STATUS, DATABASE_STATUS from v$instance;

      ERROR:

      ORA-03114: not connected to ORACLE

       

       

      SQL> startup

      ORA-24324: service handle not initialized

      ORA-01041: internal error. hostdef extension doesn't exist

      SQL>

      SQL>

      SQL> startup

      ORA-24324: service handle not initialized

      ORA-01041: internal error. hostdef extension doesn't exist

      SQL>

      SQL> show parameter spfile

      ERROR:

      ORA-03114: not connected to ORACLE

       

       

      SQL> startup

      ORA-24324: service handle not initialized

      ORA-01041: internal error. hostdef extension doesn't exist

      SQL>

      SQL> show parameter spfile;

       

      SQL>

      SQL> show parameter spfile

      ERROR:

      ORA-03114: not connected to ORACLE

       

       

      SQL> startup

      ORA-24324: service handle not initialized

      ORA-01041: internal error. hostdef extension doesn't exist

      SQL>

      SQL> !

      [oracle@localhost ~]$

      [oracle@localhost ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 17 19:30:28 2013

       

      Copyright (c) 1982, 2009, Oracle.  All rights reserved.

       

      Connected to an idle instance.

       

      SQL>

      SQL> startup

      ORACLE instance started.

       

      Total System Global Area  799313920 bytes

      Fixed Size                  1339484 bytes

      Variable Size             318771108 bytes

      Database Buffers          473956352 bytes

      Redo Buffers                5246976 bytes

      Database mounted.

      Database opened.

      SQL>

      SQL>

      SQL> !

      [oracle@localhost ~]$ cd /u01/app/oracle/product/11.2.0/db_1/bin

      [oracle@localhost bin]$

      [oracle@localhost bin]$ set ORACLE_SID=db11gr2

      [oracle@localhost bin]$

      [oracle@localhost bin]$ echo $ORACLE_SID

      db11gr2

      [oracle@localhost bin]$

      [oracle@localhost bin]$ rman target /

       

      Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 17 19:41:36 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

       

      connected to target database (not started)

       

      RMAN> set DBID 1654366455;

       

      executing command: SET DBID

       

      RMAN>

       

      RMAN> backup database;

       

      Starting backup at 17-SEP-13

      using target database control file instead of recovery catalog

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of backup command at 09/17/2013 19:44:44

      RMAN-06403: could not obtain a fully authorized session

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux Error: 2: No such file or directory

       

      RMAN>

       

      RMAN> startup force nomount;

       

      Oracle instance started

       

      Total System Global Area     799313920 bytes

       

      Fixed Size                     1339484 bytes

      Variable Size                318771108 bytes

      Database Buffers             473956352 bytes

      Redo Buffers                   5246976 bytes

       

      RMAN> set DBID 1654366455;

       

      executing command: SET DBID

       

      RMAN> backup database;

       

      Starting backup at 17-SEP-13

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=19 device type=DISK

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of backup command at 09/17/2013 19:47:57

      ORA-01507: database not mounted

       

      RMAN> startup force nomount;

       

      Oracle instance started

       

      Total System Global Area     799313920 bytes

       

      Fixed Size                     1339484 bytes

      Variable Size                318771108 bytes

      Database Buffers             473956352 bytes

      Redo Buffers                   5246976 bytes

       

      RMAN> set DBID 1654366455;

       

      executing command: SET DBID

       

      RMAN> backup database;

       

      Starting backup at 17-SEP-13

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=19 device type=DISK

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of backup command at 09/17/2013 19:49:35

      ORA-01507: database not mounted

       

      RMAN> startup

       

      database is already started

      database mounted

      released channel: ORA_DISK_1

      database opened

       

      RMAN> backup database;    

       

      RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

      RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows

      ORACLE error from target database:

      ORA-03135: connection lost contact

      Process ID: 11766

      Session ID: 1 Serial number: 9

       

      Starting backup at 17-SEP-13

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-00601: fatal error in recovery manager

      RMAN-03004: fatal error during execution of command

      ORA-03114: not connected to ORACLE

      RMAN-03002: failure of backup command at 09/17/2013 19:52:55

      ORA-03114: not connected to ORACLE

      [oracle@localhost bin]$

      [oracle@localhost bin]$

      [oracle@localhost bin]$ rman target /

       

      Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 17 19:53:28 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

       

      connected to target database (not started)

       

      RMAN> set DBID 1654366455;

       

      executing command: SET DBID

       

      RMAN> backup database;

       

      Starting backup at 17-SEP-13

      using target database control file instead of recovery catalog

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of backup command at 09/17/2013 19:55:17

      RMAN-06403: could not obtain a fully authorized session

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux Error: 2: No such file or directory

       

      RMAN> list backup;

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of list command at 09/17/2013 19:55:59

      RMAN-06403: could not obtain a fully authorized session

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux Error: 2: No such file or directory

       

      RMAN>

       

      Please tell how that can be resolve. Thanks. Dan.

        • 1. Re: Can't start the Database and can't backup
          Hemant K Chitale

          How about reading the alert.log file of the database instance to see if and why it is crashing (requiring a restart) ?

          Some possibilities :

          1.  A Background process (PMON, SMON, LGWR,  DBWR etc) detects an error or some corruption and fails, bringing down the database instance.

          2.  A Background process is being killed by some monitoring process  (e.g. Linux OutOfMemory killer or some other daemon or process)

          3.  Oracle detects corruption in the SYSTEM or Undo Tablespace and crashes

           

           

          Hemant K Chitale

          • 2. Re: Can't start the Database and can't backup
            nagulan.selvakumar

            Post the last 50 lines of your alert log file.

             

            Thank you!!

            • 3. Re: Can't start the Database and can't backup
              user12075536123

              please post the output of below cmd


              # sqlplus

              # ----------------------------------------
              host ps -ef | grep ora


              startup
              host ps -ef | grep ora


              select STATUS, DATABASE_STATUS from v$instance;
              host ps -ef | grep ora


              shutdown immediate
              startup
              select STATUS, DATABASE_STATUS from v$instance;

              host ps -ef | grep ora


              shutdown abort
              startup
              select STATUS, DATABASE_STATUS from v$instance;

              host ps -ef | grep ora

              # ----------------------------------------

              • 4. Re: Can't start the Database and can't backup
                EdStevens

                Wow!

                Where to start?!?!

                 

                Dan8 wrote:

                 

                Can't start the Database and can't backup

                 

                What is happening now. My database connection is not stable so can't do the backup.

                I spent two days trying unsuccessfully. Please check the following print screen :

                 

                [test@localhost ~]$ xhost +

                access control disabled, clients can connect from any host

                Why? you aren't using any x-windows stuff

                 

                [test@localhost ~]$

                [test@localhost ~]$

                [test@localhost ~]$ su - root

                Password:

                [root@localhost ~]#

                [root@localhost ~]#

                [root@localhost ~]# su - oracle

                 

                Why are you starting as one user, then becoming root, just to become 'oracle'.  If you are going to to DBA stuff, you need to log on as oracle to start.

                 

                [oracle@localhost ~]$

                [oracle@localhost ~]$ export ORACLE_SID=db11gr2

                [oracle@localhost ~]$

                [oracle@localhost ~]$ echo $ORACLE_HOME

                /u01/app/oracle/product/11.2.0/db_1

                [oracle@localhost ~]$

                [oracle@localhost ~]$ echo $ORACLE_BASE

                /u01/app/oracle

                [oracle@localhost ~]$

                [oracle@localhost ~]$ echo $ORACLE_SID

                db11gr2

                [oracle@localhost ~]$

                [oracle@localhost ~]$ lsnrctl start

                 

                LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2013 18:28:29

                 

                Copyright (c) 1991, 2009, Oracle.  All rights reserved.

                 

                Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

                 

                TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

                Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

                 

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

                STATUS of the LISTENER

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

                Alias                     LISTENER

                Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                Start Date                17-SEP-2013 18:28:30

                Uptime                    0 days 0 hr. 0 min. 0 sec

                Trace Level               off

                Security                  ON: Local OS Authentication

                SNMP                      OFF

                Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

                Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

                Listening Endpoints Summary...

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

                Services Summary...

                Service "db11gr2" has 1 instance(s).

                  Instance "db11gr2", status UNKNOWN, has 1 handler(s) for this service...

                The command completed successfully

                [oracle@localhost ~]$

                [oracle@localhost ~]$ emctl start dbconsole

                Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

                Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.

                https://localhost.localdomain:1158/em/console/aboutApplication

                Starting Oracle Enterprise Manager 11g Database Control .............. started.

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

                Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_db11gr2/sysman/log

                [oracle@localhost ~]$

                [oracle@localhost ~]$ sqlplus / as sysdba

                 

                SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 17 18:39:19 2013

                 

                Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                 

                Connected to an idle instance.

                 

                SQL> select STATUS, DATABASE_STATUS from v$instance;

                select STATUS, DATABASE_STATUS from v$instance

                *

                ERROR at line 1:

                ORA-01034: ORACLE not available

                Process ID: 0

                Session ID: 0 Serial number: 0

                 

                Of course.  you are connect to an 'idle' instance.  That means there is no instance against which to issue queries.

                 

                 

                 

                SQL> select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database;

                select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database

                *

                ERROR at line 1:

                ORA-01034: ORACLE not available

                Process ID: 0

                Session ID: 0 Serial number: 0

                 

                 

                SQL> show parameter spfile

                ORA-01034: ORACLE not available

                Process ID: 0

                Session ID: 0 Serial number: 0

                 

                 

                SQL> startup

                ORACLE instance started.

                 

                Total System Global Area  799313920 bytes

                Fixed Size                  1339484 bytes

                Variable Size             318771108 bytes

                Database Buffers          473956352 bytes

                Redo Buffers                5246976 bytes

                Database mounted.

                Database opened.

                SQL>

                Ok, now we're getting somewhere.

                 

                SQL>

                SQL> show parameter spfile

                ORA-03135: connection lost contact

                Process ID: 8828

                Session ID: 1 Serial number: 5

                 

                 

                I'd be checking the alert log at this point, before even continuing ...

                 

                 

                SQL> select STATUS, DATABASE_STATUS from v$instance;

                ERROR:

                ORA-03114: not connected to ORACLE

                 

                 

                SQL> startup

                ORA-24324: service handle not initialized

                ORA-01041: internal error. hostdef extension doesn't exist

                SQL>

                SQL>

                SQL> startup

                ORA-24324: service handle not initialized

                ORA-01041: internal error. hostdef extension doesn't exist

                SQL>

                 

                One definition of insanity is doing the same thing over and over and expecting a different result.

                 

                 

                SQL> show parameter spfile

                ERROR:

                ORA-03114: not connected to ORACLE

                 

                 

                SQL> startup

                ORA-24324: service handle not initialized

                ORA-01041: internal error. hostdef extension doesn't exist

                SQL>

                SQL> show parameter spfile;

                 

                SQL>

                SQL> show parameter spfile

                ERROR:

                ORA-03114: not connected to ORACLE

                 

                 

                SQL> startup

                ORA-24324: service handle not initialized

                ORA-01041: internal error. hostdef extension doesn't exist

                SQL>

                More insanity ...

                 

                SQL> !

                [oracle@localhost ~]$

                [oracle@localhost ~]$ sqlplus / as sysdba

                So, you shell out of sqlplus, spawning another process that is a child of that instance of sqlplus .... then from that dependentant process, start yet another instance of sqlplus ...  so now our process stack looks like this:

                 

                user test

                   user root

                      user oracle

                         sqlplus

                           shell

                              sqlplus


                 

                 

                 

                 

                SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 17 19:30:28 2013

                 

                Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                 

                Connected to an idle instance.

                 

                SQL>

                SQL> startup

                ORACLE instance started.

                 

                Total System Global Area  799313920 bytes

                Fixed Size                  1339484 bytes

                Variable Size             318771108 bytes

                Database Buffers          473956352 bytes

                Redo Buffers                5246976 bytes

                Database mounted.

                Database opened.

                SQL>

                SQL>

                SQL> !

                And from there you shell out yet again.  Now your process stack is

                 

                user test

                   user root

                      user oracle

                         sqlplus

                           shell

                              sqlplus

                                 shell


                 

                 

                 

                [oracle@localhost ~]$ cd /u01/app/oracle/product/11.2.0/db_1/bin

                [oracle@localhost bin]$

                [oracle@localhost bin]$ set ORACLE_SID=db11gr2

                [oracle@localhost bin]$

                [oracle@localhost bin]$ echo $ORACLE_SID

                db11gr2

                [oracle@localhost bin]$

                [oracle@localhost bin]$ rman target /

                user test

                   user root

                      user oracle

                         sqlplus

                           shell

                              sqlplus

                                 shell

                                   rman


                At this point my head is spinning.

                The first rule when one finds oneself in a hole is to stop digging.

                 

                 

                 

                Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 17 19:41:36 2013

                 

                Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

                 

                connected to target database (not started)

                 

                RMAN> set DBID 1654366455;

                 

                executing command: SET DBID

                You don't need to do a SET DBID to do a backukp.  You set it in certain cases for a recovery.

                 

                <snipping remainder >

                 

                Please tell how that can be resolve. Thanks. Dan.

                 

                First, log on directly as oracle.

                Second, don't keep shelling out of one process to do another

                Third, when you hit an unexplained 'disconnected' error, STOP.  Go read the alert log. Solve the error.

                • 5. Re: Can't start the Database and can't backup
                  Dan8

                  Hello Selvakumar !

                   

                  First thanks for your time and help.

                  the alert log file

                  Dan.

                   

                  [test@localhost ~]$ xhost +

                  access control disabled, clients can connect from any host

                  [test@localhost ~]$

                  [test@localhost ~]$

                  [test@localhost ~]$ su - root

                  Password:

                  [root@localhost ~]#

                  [root@localhost ~]# su - oracle

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ export ORACLE_SID=db11gr2

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ echo $ORACLE_BASE/u01/app/oracle

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ echo $ORACLE_SIDdb11gr2

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ lsnrctl start

                   

                  LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-OCT-2013 17:30:18

                   

                  Copyright (c) 1991, 2009, Oracle.  All rights reserved.

                   

                  Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

                   

                  TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                  System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

                  Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

                  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

                   

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

                  STATUS of the LISTENER

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

                  Alias                     LISTENER

                  Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

                  Start Date                07-OCT-2013 17:30:18

                  Uptime                    0 days 0 hr. 0 min. 1 sec

                  Trace Level               off

                  Security                  ON: Local OS Authentication

                  SNMP                      OFF

                  Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

                  Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

                  Listening Endpoints Summary...

                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

                  Services Summary...

                  Service "db11gr2" has 1 instance(s).

                    Instance "db11gr2", status UNKNOWN, has 1 handler(s) for this service...

                  The command completed successfully

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ emctl start dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

                  Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.

                  https://localhost.localdomain:1158/em/console/aboutApplication

                  Starting Oracle Enterprise Manager 11g Database Control .............. started.

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

                  Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_db11gr2/sysman/log

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$

                  [oracle@localhost ~]$ sqlplus "/as sysdba"

                   

                  SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 7 17:32:35 2013

                   

                  Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                   

                  Connected to an idle instance.

                   

                  SQL>

                  SQL> startup

                  ORACLE instance started.

                   

                  Total System Global Area  799313920 bytes

                  Fixed Size                  1339484 bytes

                  Variable Size             318771108 bytes

                  Database Buffers          473956352 bytes

                  Redo Buffers                5246976 bytes

                  Database mounted.

                  ORA-00600: internal error code, arguments: [4194], [: no

                   

                   

                  SQL>

                  SQL> startup

                  ORA-03135: connection lost contact

                  SQL>

                   

                   

                   

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

                   

                  from the Enterprise Manager Console I can see

                  Database Instance is down:

                  ---------

                  Listener

                  Status: Up

                  ---------

                  Agent Connection to Instance :

                  Status: Failed.

                  Details: ORA-01034: ORACLE not available.

                   

                  --------

                  • 6. Re: Can't start the Database and can't backup
                    Hemant K Chitale

                    I don't see an alert.log only the listener.log.

                     

                    Please don't post the XML file -- it is difficult to read.  The plain-text versions are in the trace directory

                     

                     

                    Hemant K Chitale

                    • 7. Re: Can't start the Database and can't backup
                      EdStevens

                      For cryin' out loud, do you actually expect people to read that?  Was it really necessary to dump hundreds of lines of a dump/trace/log?

                       

                      And as Hemant said, that's not even the alert log, which is what was asked for.

                       

                      The alert log (and the readable version, not the html) will be found at $ORACLE_BASE/diag/rdbms/<oraclesid>/<oraclesid>/trace/alert*

                      • 8. Re: Can't start the Database and can't backup
                        Dan8

                        Hello Stevens and others!

                         

                        Since an abnormal shutdown due to power outage I can't start the DB.

                        Thanks for your time.

                         

                        As requested here is the alert log file:

                         

                        alert_db11gr2.log

                         

                         

                        Wed Jul 03 13:17:16 2013

                        Starting ORACLE instance (normal)

                        LICENSE_MAX_SESSION = 0

                        LICENSE_SESSIONS_WARNING = 0

                        Shared memory segment for instance monitoring created

                        Picked latch-free SCN scheme 2

                        Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

                        Autotune of undo retention is turned on.

                        IMODE=BR

                        ILAT =27

                        LICENSE_MAX_USERS = 0

                        SYS auditing is disabled

                        Starting up:

                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

                        With the Partitioning, OLAP, Data Mining and Real Application Testing options.

                        Using parameter settings in client-side pfile /u01/app/oracle/admin/db11gr2/pfile/init.ora $

                        System parameters with non-default values:

                        processes                = 150

                          sga_target               = 764M

                          control_files            = "/u01/app/oracle/oradata/db11gr2/control01.ctl"

                          control_files            = "/u01/app/oracle/flash_recovery_area/db11gr2/control02.ctl"

                          db_block_size            = 8192

                          compatible               = "11.2.0.0.0"

                          db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"

                          db_recovery_file_dest_size= 3852M

                          undo_tablespace          = "UNDOTBS1"

                          remote_login_passwordfile= "EXCLUSIVE"

                          db_domain                = ""

                          dispatchers              = "(PROTOCOL=TCP) (SERVICE=db11gr2XDB)"

                          audit_file_dest          = "/u01/app/oracle/admin/db11gr2/adump"

                          audit_trail              = "DB"

                          db_name                  = "db11gr2"

                          open_cursors             = 300

                          pga_aggregate_target     = 254M

                          diagnostic_dest          = "/u01/app/oracle"

                        Wed Jul 03 13:17:17 2013

                         

                        diagnostic_dest          = "/u01/app/oracle"

                        Wed Jul 03 13:17:17 2013

                        PMON started with pid=2, OS id=10368

                        Wed Jul 03 13:17:17 2013

                        VKTM started with pid=3, OS id=10370 at elevated priority

                        VKTM running at (10)millisec precision with DBRM quantum (100)ms

                        Wed Jul 03 13:17:17 2013

                        GEN0 started with pid=4, OS id=10374

                        Wed Jul 03 13:17:17 2013

                        DIAG started with pid=5, OS id=10376

                        Wed Jul 03 13:17:17 2013

                        DBRM started with pid=6, OS id=10378

                        Wed Jul 03 13:17:17 2013

                        PSP0 started with pid=7, OS id=10380

                        Wed Jul 03 13:17:17 2013

                        DIA0 started with pid=8, OS id=10382

                        Wed Jul 03 13:17:17 2013

                        MMAN started with pid=9, OS id=10384

                        Wed Jul 03 13:17:17 2013

                         

                        MMAN started with pid=9, OS id=10384

                        Wed Jul 03 13:17:17 2013

                        DBW0 started with pid=10, OS id=10386

                        Wed Jul 03 13:17:18 2013

                        LGWR started with pid=11, OS id=10388

                        Wed Jul 03 13:17:18 2013

                        CKPT started with pid=12, OS id=10390

                        Wed Jul 03 13:17:18 2013

                        SMON started with pid=13, OS id=10392

                        Wed Jul 03 13:17:18 2013

                        RECO started with pid=14, OS id=10394

                        Wed Jul 03 13:17:18 2013

                        MMON started with pid=15, OS id=10396

                        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

                        Wed Jul 03 13:17:18 2013

                        MMNL started with pid=16, OS id=10398

                        starting up 1 shared server(s) ...

                        ORACLE_BASE from environment = /u01/app/oracle

                        Wed Jul 03 13:17:23 2013

                         

                        ORACLE_BASE from environment = /u01/app/oracle

                        Wed Jul 03 13:17:23 2013

                        Full restore complete of datafile 4 to datafile copy /u01/app/oracle/oradata/db11gr2/users0$

                          checkpoint is 754487

                        Full restore complete of datafile 3 to datafile copy /u01/app/oracle/oradata/db11gr2/undotb$

                          checkpoint is 754487

                        Wed Jul 03 13:19:08 2013

                        Full restore complete of datafile 2 to datafile copy /u01/app/oracle/oradata/db11gr2/sysaux$

                          checkpoint is 754487

                          last deallocation scn is 754293

                        Wed Jul 03 13:19:38 2013

                        Full restore complete of datafile 1 to datafile copy /u01/app/oracle/oradata/db11gr2/system$

                          checkpoint is 754487

                          last deallocation scn is 749189

                        Wed Jul 03 13:19:42 2013

                        Create controlfile reuse set database "db11gr2"

                        MAXINSTANCES 8

                        MAXLOGHISTORY 1

                        MAXLOGFILES 16

                         

                        MAXLOGHISTORY 1

                        MAXLOGFILES 16

                        MAXLOGMEMBERS 3

                        MAXDATAFILES 100

                        Datafile

                        '/u01/app/oracle/oradata/db11gr2/system01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/sysaux01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/undotbs01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/users01.dbf'

                        LOGFILE GROUP 1 ('/u01/app/oracle/oradata/db11gr2/redo01.log') SIZE 51200K,

                        GROUP 2 ('/u01/app/oracle/oradata/db11gr2/redo02.log') SIZE 51200K,

                        GROUP 3 ('/u01/app/oracle/oradata/db11gr2/redo03.log') SIZE 51200K RESETLOGS

                        WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

                        Default Temporary Tablespace will be necessary for a locally managed database in future rel$

                        Wed Jul 03 13:19:43 2013

                        Successful mount of redo thread 1, with mount id 1654363374

                        Completed: Create controlfile reuse set database "db11gr2"

                        MAXINSTANCES 8

                        MAXLOGHISTORY 1

                         

                        MAXINSTANCES 8

                        MAXLOGHISTORY 1

                        MAXLOGFILES 16

                        MAXLOGMEMBERS 3

                        MAXDATAFILES 100

                        Datafile

                        '/u01/app/oracle/oradata/db11gr2/system01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/sysaux01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/undotbs01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/users01.dbf'

                        LOGFILE GROUP 1 ('/u01/app/oracle/oradata/db11gr2/redo01.log') SIZE 51200K,

                        GROUP 2 ('/u01/app/oracle/oradata/db11gr2/redo02.log') SIZE 51200K,

                        GROUP 3 ('/u01/app/oracle/oradata/db11gr2/redo03.log') SIZE 51200K RESETLOGS

                        Shutting down instance (immediate)

                        Shutting down instance: further logons disabled

                        Stopping background process MMNL

                        Stopping background process MMON

                        License high water mark = 1

                        All dispatchers and shared servers shutdown

                         

                        License high water mark = 1

                        All dispatchers and shared servers shutdown

                        ALTER DATABASE CLOSE NORMAL

                        ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...

                        ALTER DATABASE DISMOUNT

                        Completed: ALTER DATABASE DISMOUNT

                        ARCH: Archival disabled due to shutdown: 1089

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Wed Jul 03 13:19:46 2013

                        Stopping background process VKTM:

                        ARCH: Archival disabled due to shutdown: 1089

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Wed Jul 03 13:19:48 2013

                        Instance shutdown complete

                        Wed Jul 03 13:19:49 2013

                         

                        Instance shutdown complete

                        Wed Jul 03 13:19:49 2013

                        Starting ORACLE instance (normal)

                        LICENSE_MAX_SESSION = 0

                        LICENSE_SESSIONS_WARNING = 0

                        Picked latch-free SCN scheme 2

                        Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

                        Autotune of undo retention is turned on.

                        IMODE=BR

                        ILAT =27

                        LICENSE_MAX_USERS = 0

                        SYS auditing is disabled

                        Starting up:

                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

                        With the Partitioning, OLAP, Data Mining and Real Application Testing options.

                        Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/db11gr2/init$

                        System parameters with non-default values:

                          processes                = 150

                          sga_target               = 764M

                         

                        processes                = 150

                          sga_target               = 764M

                          control_files            = "/u01/app/oracle/oradata/db11gr2/control01.ctl"

                          control_files            = "/u01/app/oracle/flash_recovery_area/db11gr2/control02.ctl"

                          db_block_size            = 8192

                          compatible               = "11.2.0.0.0"

                          db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"

                          db_recovery_file_dest_size= 3852M

                          _no_recovery_through_resetlogs= TRUE

                          undo_tablespace          = "UNDOTBS1"

                          remote_login_passwordfile= "EXCLUSIVE"

                          db_domain                = ""

                          dispatchers              = "(PROTOCOL=TCP) (SERVICE=db11gr2XDB)"

                          audit_file_dest          = "/u01/app/oracle/admin/db11gr2/adump"

                          audit_trail              = "DB"

                          db_name                  = "db11gr2"

                          open_cursors             = 300

                          pga_aggregate_target     = 254M

                          diagnostic_dest          = "/u01/app/oracle"

                         

                        pga_aggregate_target     = 254M

                          diagnostic_dest          = "/u01/app/oracle"

                        Wed Jul 03 13:19:50 2013

                        PMON started with pid=2, OS id=10462

                        Wed Jul 03 13:19:50 2013

                        VKTM started with pid=3, OS id=10464 at elevated priority

                        VKTM running at (10)millisec precision with DBRM quantum (100)ms

                        Wed Jul 03 13:19:50 2013

                        GEN0 started with pid=4, OS id=10468

                        Wed Jul 03 13:19:50 2013

                        DIAG started with pid=5, OS id=10470

                        Wed Jul 03 13:19:50 2013

                        DBRM started with pid=6, OS id=10472

                        Wed Jul 03 13:19:50 2013

                        PSP0 started with pid=7, OS id=10474

                        Wed Jul 03 13:19:50 2013

                        DIA0 started with pid=8, OS id=10476

                        Wed Jul 03 13:19:50 2013

                        MMAN started with pid=9, OS id=10478

                         

                        Wed Jul 03 13:19:50 2013

                        MMAN started with pid=9, OS id=10478

                        Wed Jul 03 13:19:50 2013

                        DBW0 started with pid=10, OS id=10480

                        Wed Jul 03 13:19:50 2013

                        LGWR started with pid=11, OS id=10482

                        Wed Jul 03 13:19:50 2013

                        CKPT started with pid=12, OS id=10484

                        Wed Jul 03 13:19:50 2013

                        SMON started with pid=13, OS id=10486

                        Wed Jul 03 13:19:50 2013

                        RECO started with pid=14, OS id=10488

                        Wed Jul 03 13:19:51 2013

                        MMON started with pid=15, OS id=10490

                        Wed Jul 03 13:19:51 2013

                        MMNL started with pid=16, OS id=10492

                        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

                        starting up 1 shared server(s) ...

                        ORACLE_BASE from environment = /u01/app/oracle

                         

                        starting up 1 shared server(s) ...

                        ORACLE_BASE from environment = /u01/app/oracle

                        Wed Jul 03 13:19:51 2013

                        Create controlfile reuse set database "db11gr2"

                        MAXINSTANCES 8

                        MAXLOGHISTORY 1

                        MAXLOGFILES 16

                        MAXLOGMEMBERS 3

                        MAXDATAFILES 100

                        Datafile

                        '/u01/app/oracle/oradata/db11gr2/system01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/sysaux01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/undotbs01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/users01.dbf'

                        LOGFILE GROUP 1 ('/u01/app/oracle/oradata/db11gr2/redo01.log') SIZE 51200K,

                        GROUP 2 ('/u01/app/oracle/oradata/db11gr2/redo02.log') SIZE 51200K,

                        GROUP 3 ('/u01/app/oracle/oradata/db11gr2/redo03.log') SIZE 51200K RESETLOGS

                        WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

                        Default Temporary Tablespace will be necessary for a locally managed database in future rel$

                         

                        WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

                        Default Temporary Tablespace will be necessary for a locally managed database in future rel$

                        Successful mount of redo thread 1, with mount id 1654358519

                        Completed: Create controlfile reuse set database "db11gr2"

                        MAXINSTANCES 8

                        MAXLOGHISTORY 1

                        MAXLOGFILES 16

                        MAXLOGMEMBERS 3

                        MAXDATAFILES 100

                        Datafile

                        '/u01/app/oracle/oradata/db11gr2/system01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/sysaux01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/undotbs01.dbf',

                        '/u01/app/oracle/oradata/db11gr2/users01.dbf'

                        LOGFILE GROUP 1 ('/u01/app/oracle/oradata/db11gr2/redo01.log') SIZE 51200K,

                        GROUP 2 ('/u01/app/oracle/oradata/db11gr2/redo02.log') SIZE 51200K,

                        GROUP 3 ('/u01/app/oracle/oradata/db11gr2/redo03.log') SIZE 51200K RESETLOGS

                        Stopping background process MMNL

                        Stopping background process MMON

                         

                        Stopping background process MMNL

                        Stopping background process MMON

                        Starting background process MMON

                        Starting background process MMNL

                        Wed Jul 03 13:19:53 2013

                        MMON started with pid=15, OS id=10504

                        ALTER SYSTEM enable restricted session;

                        alter database "db11gr2" open resetlogs

                        Wed Jul 03 13:19:54 2013

                        MMNL started with pid=16, OS id=10506

                        RESETLOGS after incomplete recovery UNTIL CHANGE 754487

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 1 of thread 1

                        ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/db11gr2/redo01.log'

                        ORA-27037: unable to obtain file status

                        Linux Error: 2: No such file or directory

                        Additional information: 3

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 1 of thread 1

                         

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 1 of thread 1

                        ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/db11gr2/redo01.log'

                        ORA-27037: unable to obtain file status

                        Linux Error: 2: No such file or directory

                        Additional information: 3

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 2 of thread 1

                        ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/db11gr2/redo02.log'

                        ORA-27037: unable to obtain file status

                        Linux Error: 2: No such file or directory

                        Additional information: 3

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 2 of thread 1

                        ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/db11gr2/redo02.log'

                        ORA-27037: unable to obtain file status

                        Linux Error: 2: No such file or directory

                        Additional information: 3

                        Wed Jul 03 13:19:58 2013

                         

                        Additional information: 3

                        Wed Jul 03 13:19:58 2013

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_m001_10513.trc:

                        ORA-01155: the database is being opened, closed, mounted or dismounted

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 3 of thread 1

                        ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/db11gr2/redo03.log'

                        ORA-27037: unable to obtain file status

                        Linux Error: 2: No such file or directory

                        Additional information: 3

                        Errors in file /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/trace/db11gr2_ora_10497.trc:

                        ORA-00313: open failed for members of log group 3 of thread 1

                        ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/db11gr2/redo03.log'

                        ORA-27037: unable to obtain file status

                        Linux Error: 2: No such file or directory

                        Additional information: 3

                        Wed Jul 03 13:20:02 2013

                        Setting recovery target incarnation to 2

                        Wed Jul 03 13:20:02 2013

                         

                        Setting recovery target incarnation to 2

                        Wed Jul 03 13:20:02 2013

                        Checker run found 2 new persistent data failures

                        Wed Jul 03 13:20:02 2013

                        Assigning activation ID 1654358519 (0x629b81f7)

                        Thread 1 opened at log sequence 1

                          Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/db11gr2/redo01.log

                        Successful open of redo thread 1

                        Wed Jul 03 13:20:02 2013

                        MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

                        Wed Jul 03 13:20:02 2013

                        SMON: enabling cache recovery

                        Successfully onlined Undo Tablespace 2.

                        Dictionary check beginning

                        Tablespace 'TEMP' #3 found in data dictionary,

                        but not in the controlfile. Adding to controlfile.

                        Dictionary check complete

                        Verifying file header compatibility for 11g tablespace encryption..

                        Verifying 11g file header compatibility for tablespace encryption completed

                         

                        Verifying file header compatibility for 11g tablespace encryption..

                        Verifying 11g file header compatibility for tablespace encryption completed

                        *********************************************************************

                        WARNING: The following temporary tablespaces contain no files.

                                 This condition can occur when a backup controlfile has

                                 been restored.  It may be necessary to add files to these

                                 tablespaces.  That can be done using the SQL statement:

                         

                                 ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

                         

                                 Alternatively, if these temporary tablespaces are no longer

                                 needed, then they can be dropped.

                                   Empty temporary tablespace: TEMP

                        *********************************************************************

                        SMON: enabling tx recovery

                        Database Characterset is US7ASCII

                        Create Relation IPS_PACKAGE_UNPACK_HISTORY

                        No Resource Manager plan active

                        **********************************************************

                         

                        No Resource Manager plan active

                        **********************************************************

                        WARNING: Files may exists in db_recovery_file_dest

                        that are not known to the database. Use the RMAN command

                        CATALOG RECOVERY AREA to re-catalog any such files.

                        If files cannot be cataloged, then manually delete them

                        using OS command.

                        One of the following events caused this:

                        1. A backup controlfile was restored.

                        2. A standby controlfile was restored.

                        3. The controlfile was re-created.

                        4. db_recovery_file_dest had previously been enabled and

                           then disabled.

                        **********************************************************

                        replication_dependency_tracking turned off (no async multimaster replication found)

                        Starting background process QMNC

                        Wed Jul 03 13:20:10 2013

                        QMNC started with pid=20, OS id=10520

                        LOGSTDBY: Validating controlfile with logical metadata

                         

                        QMNC started with pid=20, OS id=10520

                        LOGSTDBY: Validating controlfile with logical metadata

                        LOGSTDBY: Validation complete

                        Global Name changed to DB11GR2

                        Wed Jul 03 13:20:14 2013

                        Completed: alter database "db11gr2" open resetlogs

                        alter database rename global_name to "db11gr2"

                        Completed: alter database rename global_name to "db11gr2"

                        ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/db11gr2/temp01.dbf' SIZE 20480K$

                        Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/db11gr2/temp01.dbf' $

                        ALTER DATABASE DEFAULT TABLESPACE "USERS"

                        Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"

                        ALTER SYSTEM disable restricted session;

                        Wed Jul 03 13:20:30 2013

                        db_recovery_file_dest_size of 3852 MB is 0.00% used. This is a

                        user-specified limit on the amount of space that will be used by this

                        database for recovery-related files, and does not reflect the amount of

                        space available in the underlying filesystem or ASM diskgroup.

                        Wed Jul 03 13:20:32 2013

                         

                        space available in the underlying filesystem or ASM diskgroup.

                        Wed Jul 03 13:20:32 2013

                        Starting background process CJQ0

                        Wed Jul 03 13:20:32 2013

                        CJQ0 started with pid=28, OS id=10550

                        Wed Jul 03 13:20:41 2013

                        Full restore complete of datafile 5 to datafile copy /u01/app/oracle/oradata/db11gr2/exampl$

                          checkpoint is 775539

                          last deallocation scn is 775082

                        Wed Jul 03 13:20:45 2013

                        Plug in tablespace EXAMPLE with datafile

                          '/u01/app/oracle/oradata/db11gr2/example01.dbf'

                        Wed Jul 03 13:21:23 2013

                        ALTER TABLESPACE example READ WRITE

                        Completed: ALTER TABLESPACE example READ WRITE

                        Wed Jul 03 13:21:39 2013

                        Shared IO Pool defaulting to 141557760. Trying to get it from Buffer Cache for process 1060$

                        Wed Jul 03 13:21:44 2013

                        Starting background process SMCO

                         

                        Wed Jul 03 13:21:44 2013

                        Starting background process SMCO

                        Wed Jul 03 13:21:44 2013

                        SMCO started with pid=23, OS id=10604

                        Wed Jul 03 13:22:18 2013

                        Shutting down instance (immediate)

                        Stopping background process SMCO

                        Shutting down instance: further logons disabled

                        Wed Jul 03 13:22:19 2013

                        Stopping background process CJQ0

                        Stopping background process QMNC

                        Stopping background process MMNL

                        Stopping background process MMON

                        License high water mark = 10

                        All dispatchers and shared servers shutdown

                        ALTER DATABASE CLOSE NORMAL

                        Wed Jul 03 13:22:21 2013

                        SMON: disabling tx recovery

                        SMON: disabling cache recovery

                         

                        Stopping background process QMNC

                        Stopping background process MMNL

                        Stopping background process MMON

                        License high water mark = 10

                        All dispatchers and shared servers shutdown

                        ALTER DATABASE CLOSE NORMAL

                        Wed Jul 03 13:22:21 2013

                        SMON: disabling tx recovery

                        SMON: disabling cache recovery

                        Wed Jul 03 13:21:44 2013

                        Starting background process SMCO

                        Wed Jul 03 13:21:44 2013

                        SMCO started with pid=23, OS id=10604

                        Wed Jul 03 13:22:18 2013

                        Shutting down instance (immediate)

                        Stopping background process SMCO

                        Shutting down instance: further logons disabled

                        Wed Jul 03 13:22:19 2013

                        Stopping background process CJQ0

                         

                        Wed Jul 03 13:22:19 2013

                        Stopping background process CJQ0

                        Stopping background process QMNC

                        Stopping background process MMNL

                        Stopping background process MMON

                        License high water mark = 10

                        All dispatchers and shared servers shutdown

                        ALTER DATABASE CLOSE NORMAL

                        Wed Jul 03 13:22:21 2013

                        SMON: disabling tx recovery

                        SMON: disabling cache recovery

                        Wed Jul 03 13:22:21 2013

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Thread 1 closed at log sequence 1

                        Successful close of redo thread 1

                        Completed: ALTER DATABASE CLOSE NORMAL

                        ALTER DATABASE DISMOUNT

                         

                        Completed: ALTER DATABASE CLOSE NORMAL

                        ALTER DATABASE DISMOUNT

                        Completed: ALTER DATABASE DISMOUNT

                        ARCH: Archival disabled due to shutdown: 1089

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Wed Jul 03 13:22:22 2013

                        Stopping background process VKTM:

                        ARCH: Archival disabled due to shutdown: 1089

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Wed Jul 03 13:22:24 2013

                        Instance shutdown complete

                        Wed Jul 03 13:22:24 2013

                        Starting ORACLE instance (restrict)

                        LICENSE_MAX_SESSION = 0

                        LICENSE_SESSIONS_WARNING = 0

                         

                        LICENSE_MAX_SESSION = 0

                        LICENSE_SESSIONS_WARNING = 0

                        Picked latch-free SCN scheme 2

                        Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

                        Autotune of undo retention is turned on.

                        IMODE=BR

                        ILAT =27

                        LICENSE_MAX_USERS = 0

                        SYS auditing is disabled

                        Wed Jul 03 13:22:45 2013

                        Starting up:

                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

                        With the Partitioning, OLAP, Data Mining and Real Application Testing options.

                        Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/db11gr2/init$

                        System parameters with non-default values:

                          processes                = 150

                          sga_target               = 764M

                          control_files            = "/u01/app/oracle/oradata/db11gr2/control01.ctl"

                          control_files            = "/u01/app/oracle/flash_recovery_area/db11gr2/control02.ctl"

                         

                        control_files            = "/u01/app/oracle/oradata/db11gr2/control01.ctl"

                          control_files            = "/u01/app/oracle/flash_recovery_area/db11gr2/control02.ctl"

                          db_block_size            = 8192

                          compatible               = "11.2.0.0.0"

                          db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"

                          db_recovery_file_dest_size= 3852M

                          _no_recovery_through_resetlogs= TRUE

                          undo_tablespace          = "UNDOTBS1"

                          remote_login_passwordfile= "EXCLUSIVE"

                          db_domain                = ""

                          dispatchers              = "(PROTOCOL=TCP) (SERVICE=db11gr2XDB)"

                          audit_file_dest          = "/u01/app/oracle/admin/db11gr2/adump"

                          audit_trail              = "DB"

                          db_name                  = "db11gr2"

                          open_cursors             = 300

                          pga_aggregate_target     = 254M

                          diagnostic_dest          = "/u01/app/oracle"

                        Wed Jul 03 13:23:06 2013

                        PMON started with pid=2, OS id=10643

                         

                        Wed Jul 03 13:23:06 2013

                        PMON started with pid=2, OS id=10643

                        Wed Jul 03 13:23:06 2013

                        VKTM started with pid=3, OS id=10645 at elevated priority

                        VKTM running at (10)millisec precision with DBRM quantum (100)ms

                        Wed Jul 03 13:23:06 2013

                        GEN0 started with pid=4, OS id=10649

                        Wed Jul 03 13:23:06 2013

                        DIAG started with pid=5, OS id=10651

                        Wed Jul 03 13:23:06 2013

                        PSP0 started with pid=7, OS id=10655

                        Wed Jul 03 13:23:06 2013

                        DBRM started with pid=6, OS id=10653

                        Wed Jul 03 13:23:06 2013

                        DIA0 started with pid=8, OS id=10657

                        Wed Jul 03 13:23:07 2013

                        MMAN started with pid=9, OS id=10659

                        Wed Jul 03 13:23:07 2013

                        DBW0 started with pid=10, OS id=10661

                         

                        Wed Jul 03 13:23:07 2013

                        DBW0 started with pid=10, OS id=10661

                        Wed Jul 03 13:23:07 2013

                        LGWR started with pid=11, OS id=10663

                        Wed Jul 03 13:23:07 2013

                        CKPT started with pid=12, OS id=10665

                        Wed Jul 03 13:23:07 2013

                        SMON started with pid=13, OS id=10667

                        Wed Jul 03 13:23:07 2013

                        RECO started with pid=14, OS id=10669

                        Wed Jul 03 13:23:07 2013

                        MMON started with pid=15, OS id=10671

                        Wed Jul 03 13:23:07 2013

                        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

                        Wed Jul 03 13:23:07 2013

                        MMNL started with pid=16, OS id=10673

                        starting up 1 shared server(s) ...

                        ORACLE_BASE from environment = /u01/app/oracle

                        Wed Jul 03 13:23:08 2013

                         

                        ORACLE_BASE from environment = /u01/app/oracle

                        Wed Jul 03 13:23:08 2013

                        ALTER DATABASE   MOUNT

                        Changing di2dbun from  to db11gr2

                        Successful mount of redo thread 1, with mount id 1654367420

                        Database mounted in Exclusive Mode

                        Lost write protection disabled

                        Completed: ALTER DATABASE   MOUNT

                        Wed Jul 03 13:23:12 2013

                        ALTER DATABASE OPEN

                        Thread 1 opened at log sequence 1

                          Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/db11gr2/redo01.log

                        Successful open of redo thread 1

                        MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

                        SMON: enabling cache recovery

                        Successfully onlined Undo Tablespace 2.

                        Verifying file header compatibility for 11g tablespace encryption..

                        Verifying 11g file header compatibility for tablespace encryption completed

                        SMON: enabling tx recovery

                         

                        Verifying 11g file header compatibility for tablespace encryption completed

                        SMON: enabling tx recovery

                        Database Characterset is US7ASCII

                        No Resource Manager plan active

                        replication_dependency_tracking turned off (no async multimaster replication found)

                        Starting background process QMNC

                        Wed Jul 03 13:23:13 2013

                        QMNC started with pid=20, OS id=10687

                        Completed: ALTER DATABASE OPEN

                        alter database character set INTERNAL_CONVERT WE8MSWIN1252

                        Wed Jul 03 13:23:25 2013

                        Thread 1 advanced to log sequence 2 (LGWR switch)

                          Current log# 2 seq# 2 mem# 0: /u01/app/oracle/oradata/db11gr2/redo02.log

                        Wed Jul 03 13:23:37 2013

                        Starting background process SMCO

                        Wed Jul 03 13:23:37 2013

                        SMCO started with pid=23, OS id=10700

                        Wed Jul 03 13:23:41 2013

                        Updating character set in controlfile to WE8MSWIN1252

                         

                        Wed Jul 03 13:23:41 2013

                        Updating character set in controlfile to WE8MSWIN1252

                        Synchronizing connection with database character set information

                        Refreshing type attributes with new character set information

                        Wed Jul 03 13:23:47 2013

                        Thread 1 advanced to log sequence 3 (LGWR switch)

                          Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/db11gr2/redo03.log

                        Completed: alter database character set INTERNAL_CONVERT WE8MSWIN1252

                        Wed Jul 03 13:23:49 2013

                        ALTER SYSTEM disable restricted session;

                        Wed Jul 03 13:23:49 2013

                        db_recovery_file_dest_size of 3852 MB is 0.00% used. This is a

                        user-specified limit on the amount of space that will be used by this

                        database for recovery-related files, and does not reflect the amount of

                        space available in the underlying filesystem or ASM diskgroup.

                        Wed Jul 03 13:23:50 2013

                        Starting background process CJQ0

                        Wed Jul 03 13:23:50 2013

                        CJQ0 started with pid=28, OS id=10724

                         

                        Wed Jul 03 13:23:50 2013

                        CJQ0 started with pid=28, OS id=10724

                        Wed Jul 03 13:24:00 2013

                        Shutting down instance (immediate)

                        Stopping background process SMCO

                        Shutting down instance: further logons disabled

                        Wed Jul 03 13:24:16 2013

                        Stopping background process QMNC

                        Wed Jul 03 13:24:16 2013

                        Stopping background process CJQ0

                        Stopping background process MMNL

                        Stopping background process MMON

                        License high water mark = 1

                        All dispatchers and shared servers shutdown

                        ALTER DATABASE CLOSE NORMAL

                        Wed Jul 03 13:24:19 2013

                        SMON: disabling tx recovery

                        SMON: disabling cache recovery

                        Wed Jul 03 13:24:19 2013

                         

                        SMON: disabling cache recovery

                        Wed Jul 03 13:24:19 2013

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Thread 1 closed at log sequence 3

                        Successful close of redo thread 1

                        Completed: ALTER DATABASE CLOSE NORMAL

                        ALTER DATABASE DISMOUNT

                        Completed: ALTER DATABASE DISMOUNT

                        ARCH: Archival disabled due to shutdown: 1089

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Wed Jul 03 13:24:19 2013

                        Stopping background process VKTM:

                        ARCH: Archival disabled due to shutdown: 1089

                        Shutting down archive processes

                        Archiving is disabled

                         

                        Shutting down archive processes

                        Archiving is disabled

                        Archive process shutdown avoided: 0 active

                        Wed Jul 03 13:24:22 2013

                        Instance shutdown complete

                        Wed Jul 03 13:24:22 2013

                        Starting ORACLE instance (normal)

                        LICENSE_MAX_SESSION = 0

                        LICENSE_SESSIONS_WARNING = 0

                        Picked latch-free SCN scheme 2

                        Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

                        Autotune of undo retention is turned on.

                        IMODE=BR

                        ILAT =27

                        LICENSE_MAX_USERS = 0

                        SYS auditing is disabled

                        Wed Jul 03 13:24:43 2013

                        Starting up:

                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

                         

                        Starting up:

                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

                        With the Partitioning, OLAP, Data Mining and Real Application Testing options.

                        Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfi$

                        System parameters with non-default values:

                          processes                = 150

                          sga_target               = 764M

                          control_files            = "/u01/app/oracle/oradata/db11gr2/control01.ctl"

                          control_files            = "/u01/app/oracle/flash_recovery_area/db11gr2/control02.ctl"

                          db_block_size            = 8192

                          compatible               = "11.2.0.0.0"

                          db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"

                          db_recovery_file_dest_size= 3852M

                          undo_tablespace          = "UNDOTBS1"

                          remote_login_passwordfile= "EXCLUSIVE"

                          db_domain                = ""

                          dispatchers              = "(PROTOCOL=TCP) (SERVICE=db11gr2XDB)"

                          audit_file_dest          = "/u01/app/oracle/admin/db11gr2/adump"

                          audit_trail              = "DB"

                         

                        audit_file_dest          = "/u01/app/oracle/admin/db11gr2/adump"

                          audit_trail              = "DB"

                          db_name                  = "db11gr2"

                          open_cursors             = 300

                          pga_aggregate_target     = 254M

                          diagnostic_dest          = "/u01/app/oracle"

                        Wed Jul 03 13:25:03 2013

                        PMON started with pid=2, OS id=10758

                        Wed Jul 03 13:25:03 2013

                        VKTM started with pid=3, OS id=10760 at elevated priority

                        VKTM running at (10)millisec precision with DBRM quantum (100)ms

                        Wed Jul 03 13:25:03 2013

                        GEN0 started with pid=4, OS id=10764

                        Wed Jul 03 13:25:03 2013

                        DIAG started with pid=5, OS id=10766

                        Wed Jul 03 13:25:03 2013

                        DBRM started with pid=6, OS id=10768

                        Wed Jul 03 13:25:03 2013

                        PSP0 started with pid=7, OS id=10770

                         

                        Wed Jul 03 13:25:03 2013

                        PSP0 started with pid=7, OS id=10770

                        Wed Jul 03 13:25:03 2013

                        DIA0 started with pid=8, OS id=10772

                        Wed Jul 03 13:25:03 2013

                        MMAN started with pid=9, OS id=10774

                        Wed Jul 03 13:25:03 2013

                        DBW0 started with pid=10, OS id=10776

                        Wed Jul 03 13:25:03 2013

                        LGWR started with pid=11, OS id=10778

                        Wed Jul 03 13:25:04 2013

                        CKPT started with pid=12, OS id=10781

                        Wed Jul 03 13:25:04 2013

                        SMON started with pid=13, OS id=10783

                        Wed Jul 03 13:25:04 2013

                        RECO started with pid=14, OS id=10785

                        Wed Jul 03 13:25:04 2013

                        MMON started with pid=15, OS id=10787

                        Wed Jul 03 13:25:04 2013

                         

                        MMON started with pid=15, OS id=10787

                        Wed Jul 03 13:25:04 2013

                        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

                        Wed Jul 03 13:25:04 2013

                        MMNL started with pid=16, OS id=10789

                        starting up 1 shared server(s) ...

                        ORACLE_BASE from environment = /u01/app/oracle

                        Wed Jul 03 13:25:04 2013

                        ALTER DATABASE   MOUNT

                        Successful mount of redo thread 1, with mount id 1654354224

                        Database mounted in Exclusive Mode

                        Lost write protection disabled

                        Completed: ALTER DATABASE   MOUNT

                        Wed Jul 03 13:25:09 2013

                        ALTER DATABASE OPEN

                        Thread 1 opened at log sequence 3

                          Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/db11gr2/redo03.log

                        Successful open of redo thread 1

                        MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

                         

                        Successful open of redo thread 1

                        MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

                        SMON: enabling cache recovery

                        Successfully onlined Undo Tablespace 2.

                        Verifying file header compatibility for 11g tablespace encryption..

                        Verifying 11g file header compatibility for tablespace encryption completed

                        SMON: enabling tx recovery

                        Database Characterset is WE8MSWIN1252

                        No Resource Manager plan active

                        replication_dependency_tracking turned off (no async multimaster replication found)

                        Starting background process QMNC

                        Wed Jul 03 13:25:10 2013

                        QMNC started with pid=20, OS id=10804

                        Wed Jul 03 13:25:12 2013

                        db_recovery_file_dest_size of 3852 MB is 0.00% used. This is a

                        user-specified limit on the amount of space that will be used by this

                        database for recovery-related files, and does not reflect the amount of

                        space available in the underlying filesystem or ASM diskgroup.

                        Starting background process CJQ0

                         

                        space available in the underlying filesystem or ASM diskgroup.

                        Starting background process CJQ0

                        Wed Jul 03 13:25:12 2013

                        CJQ0 started with pid=21, OS id=10819

                        Completed: ALTER DATABASE OPEN

                        Wed Jul 03 13:27:32 2013

                        Starting background process SMCO

                        Wed Jul 03 13:27:32 2013

                        SMCO started with pid=31, OS id=10977

                        Wed Jul 03 13:37:56 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                         

                        VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:37:56

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18231) as a result of ORA-609

                        Wed Jul 03 13:38:37 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:38:37

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                         

                          nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18244) as a result of ORA-609

                        Wed Jul 03 13:38:58 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:38:58

                          Tracing not turned on.

                          Tns error struct:

                         

                        Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18270) as a result of ORA-609

                        Wed Jul 03 13:39:19 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:39:19

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18268) as a result of ORA-609

                        Wed Jul 03 13:39:39 2013

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:39:39

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                         

                          ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18276) as a result of ORA-609

                        Wed Jul 03 13:39:59 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:39:59

                          Tracing not turned on.

                         

                          Time: 03-JUL-2013 13:39:59

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18274) as a result of ORA-609

                        Wed Jul 03 13:40:40 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:40:40

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18532) as a result of ORA-609

                        Wed Jul 03 13:41:00 2013

                         

                        Wed Jul 03 13:41:00 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:41:00

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18530) as a result of ORA-609

                        Wed Jul 03 13:41:20 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:41:20

                         

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:41:20

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18528) as a result of ORA-609

                        Wed Jul 03 13:41:40 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:41:40

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                            ns secondary err code: 12560

                            nt main err code: 0

                            nt secondary err code: 0

                            nt OS err code: 0

                        opiodr aborting process unknown ospid (18526) as a result of ORA-609

                        Wed Jul 03 13:42:00 2013

                         

                        opiodr aborting process unknown ospid (18526) as a result of ORA-609

                        Wed Jul 03 13:42:00 2013

                         

                         

                        ***********************************************************************

                         

                        Fatal NI connect error 12537, connecting to:

                        (LOCAL=NO)

                         

                          VERSION INFORMATION:

                                TNS for Linux: Version 11.2.0.1.0 - Production

                                Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

                          Time: 03-JUL-2013 13:42:00

                          Tracing not turned on.

                          Tns error struct:

                            ns main err code: 12537

                         

                        TNS-12537: TNS:connection closed

                        • 9. Re: Can't start the Database and can't backup
                          Hemant K Chitale

                          Why are all the messages dated 03-Jul-2013 ?  We'd need to see recent messages.

                           

                          There was a CREATE CONTROLFILE,  a Change of CHARACTERSET etc on 03-Jul.

                           

                          The last few errors on 03-July are ORA-609

                          ORA-00609: could not attach to incoming connection  

                          Cause: Oracle process could not answer incoming connection

                           

                          Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.

                           

                          Hemant K Chitale

                          • 10. Re: Can't start the Database and can't backup
                            Levi Pereira

                            Hi Dan,

                            Please edit this reply by removing this alertlog.xml dumped in the  midle of this thread.

                            I took 15 min to reach the  end of this thread, almost got  "out of memory".


                            • 11. Re: Can't start the Database and can't backup
                              Dan8

                              Hi !

                               

                              you asked: 'Why are all the messages dated 03-Jul-2013 ? ' :

                              I don't know why I keep having 03-Jul though the dates and time on my machine are of Oct.

                               

                              I will follow you advice and will keep you posted.

                               

                              Thanks for your help.

                               

                              Dan.

                              • 12. Re: Can't start the Database and can't backup
                                Dan8

                                Hi Levi!

                                 

                                As you requested the alertlog.xml file was removed.

                                Sorry about that.


                                I don't know why I keep having 03-Jul though the dates and time on my machine are of Oct.

                                 

                                Dates and Time in my alert_db11gr2.log are still of 03-Jul though my computer is showing the correct dates and time.

                                 

                                Dan.

                                • 13. Re: Can't start the Database and can't backup
                                  Hemant K Chitale

                                  Possibly, you are looking at the wrong alert log file ?  Maybe the instance is now writing to a different location ?

                                   

                                  Hemant K Chitale