1 2 3 Previous Next 39 Replies Latest reply: Nov 6, 2012 5:31 AM by orafad Go to original post RSS
      • 15. Re: OracleServiceXE Won't Start After Active Directory Install
        clcarter
        Database is making it thru the mount mode, check the alertlog, alert_xe.log. In a trace directory way down under the oraclexe folder ...
        • 16. Re: OracleServiceXE Won't Start After Active Directory Install
          JL09
          clcarter wrote:
          Database is making it thru the mount mode, check the alertlog, alert_xe.log. In a trace directory way down under the oraclexe folder ...
          VKTM started with pid=4, OS id=3312 at elevated priority
          VKTM running at (10)millisec precision with DBRM quantum (100)ms
          Thu Nov 01 09:07:52 2012
          GEN0 started with pid=5, OS id=3248
          Thu Nov 01 09:07:52 2012
          DIAG started with pid=6, OS id=724
          Thu Nov 01 09:07:52 2012
          DBRM started with pid=7, OS id=3332
          Thu Nov 01 09:07:52 2012
          DIA0 started with pid=8, OS id=2156
          Thu Nov 01 09:07:52 2012
          MMAN started with pid=9, OS id=1664
          Thu Nov 01 09:07:52 2012
          DBW0 started with pid=10, OS id=2448
          Thu Nov 01 09:07:52 2012
          LGWR started with pid=11, OS id=672
          Thu Nov 01 09:07:52 2012
          CKPT started with pid=12, OS id=3964
          Thu Nov 01 09:07:52 2012
          SMON started with pid=13, OS id=1848
          Thu Nov 01 09:07:52 2012
          RECO started with pid=14, OS id=2100
          Thu Nov 01 09:07:52 2012
          MMON started with pid=15, OS id=2012
          Thu Nov 01 09:07:52 2012
          MMNL started with pid=16, OS id=3844
          starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
          starting up 4 shared server(s) ...
          ORACLE_BASE from environment = C:\oraclexe\app\oracle
          Thu Nov 01 09:07:52 2012
          alter database mount exclusive
          ORA-3113 signalled during: alter database mount exclusive...
          Thu Nov 01 10:16:16 2012
          alter database open
          ORA-1507 signalled during: alter database open...
          Thu Nov 01 10:58:18 2012
          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
          ALTER DATABASE CLOSE NORMAL
          ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
          ARCH: Archival disabled due to shutdown: 1089
          Shutting down archive processes
          Archiving is disabled
          ARCH: Archival disabled due to shutdown: 1089
          Shutting down archive processes
          Archiving is disabled
          Thu Nov 01 10:58:20 2012
          Stopping background process VKTM
          Thu Nov 01 10:58:22 2012
          Instance shutdown complete
          Thu Nov 01 10:58:26 2012
          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 =18
          LICENSE_MAX_USERS = 0
          SYS auditing is disabled
          Starting up:
          Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
          Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
          System parameters with non-default values:
          sessions = 172
          spfile = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
          memory_target = 1G
          control_files = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
          compatible = "11.2.0.0.0"
          db_recovery_file_dest = "C:\oraclexe\app\oracle\fast_recovery_area"
          db_recovery_file_dest_size= 10G
          undo_management = "AUTO"
          undo_tablespace = "UNDOTBS1"
          remote_login_passwordfile= "EXCLUSIVE"
          dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
          shared_servers = 4
          job_queue_processes = 4
          audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
          db_name = "XE"
          open_cursors = 300
          diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
          Thu Nov 01 10:58:34 2012
          PMON started with pid=2, OS id=5028
          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
          Thu Nov 01 10:58:34 2012
          PSP0 started with pid=3, OS id=4928
          Thu Nov 01 10:58:34 2012
          VKTM started with pid=4, OS id=3888 at elevated priority
          VKTM running at (10)millisec precision with DBRM quantum (100)ms
          Thu Nov 01 10:58:34 2012
          GEN0 started with pid=5, OS id=4520
          Thu Nov 01 10:58:34 2012
          DIAG started with pid=6, OS id=4652
          Thu Nov 01 10:58:34 2012
          DBRM started with pid=7, OS id=4588
          Thu Nov 01 10:58:34 2012
          DIA0 started with pid=8, OS id=5000
          Thu Nov 01 10:58:34 2012
          MMAN started with pid=9, OS id=4436
          Thu Nov 01 10:58:34 2012
          DBW0 started with pid=10, OS id=4292
          Thu Nov 01 10:58:34 2012
          LGWR started with pid=11, OS id=1732
          Thu Nov 01 10:58:34 2012
          CKPT started with pid=12, OS id=4420
          Thu Nov 01 10:58:34 2012
          SMON started with pid=13, OS id=4132
          Thu Nov 01 10:58:34 2012
          RECO started with pid=14, OS id=1460
          Thu Nov 01 10:58:34 2012
          MMON started with pid=15, OS id=4404
          Thu Nov 01 10:58:34 2012
          MMNL started with pid=16, OS id=4604
          starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
          starting up 4 shared server(s) ...
          ORACLE_BASE from environment = C:\oraclexe\app\oracle
          Thu Nov 01 10:58:34 2012
          ALTER DATABASE MOUNT
          Successful mount of redo thread 1, with mount id 2679289626
          Database mounted in Exclusive Mode
          Lost write protection disabled
          Completed: ALTER DATABASE MOUNT
          Thu Nov 01 10:58:40 2012
          ALTER DATABASE OPEN
          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_lgwr_1732.trc:
          ORA-00313: open failed for members of log group 1 of thread 1
          ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_82TNGPV9_.LOG'
          ORA-27041: unable to open file
          OSD-04002: unable to open file
          O/S-Error: (OS 2) The system cannot find the file specified.
          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_lgwr_1732.trc:
          ORA-00313: open failed for members of log group 1 of thread 1
          ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_82TNGPV9_.LOG'
          ORA-27041: unable to open file
          OSD-04002: unable to open file
          O/S-Error: (OS 2) The system cannot find the file specified.
          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4880.trc:
          ORA-00313: open failed for members of log group 1 of thread
          ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_82TNGPV9_.LOG'
          USER (ospid: 4880): terminating the instance due to error 313
          System state dump requested by (instance=1, osid=4880), summary=[abnormal instance termination].
          System State dumped to trace file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_diag_4652.trc
          Dumping diagnostic data in directory=[cdmp_20121101105842], requested by (instance=1, osid=4880), summary=[abnormal instance termination].
          Instance terminated by USER, pid = 4880
          • 17. Re: OracleServiceXE Won't Start After Active Directory Install
            clcarter
            Ahh I usually do a controlfile rebuild whenever starting up a new instance, that fixes redo logfiles as part of the process.

            Try grabbing the redo files from that backup, copy them to the folder named in the alertlog ...FAST_RECOVERY_AREA...

            Or move the CONTROL.DBF file out of the way, do a startup mount and run a create controlfile script to build a new controlfile.

            If you've ever done one or two of those, its trivial. First time, not so much. If pulling the redolog files from backup doesn't work, you already have a list of the datafiles and that is about 90% of completing a create controlfile task.
            • 18. Re: OracleServiceXE Won't Start After Active Directory Install
              JL09
              Recovered the original two files:

              O1_MF_1_82TNGPV9_
              O1_MF_2_82TNGRDB_

              Tried running the alter database open again and received:

              SQL> connect /as sysdba
              Connected to an idle instance.
              SQL> alter database open;
              alter database open
              *
              ERROR at line 1:
              ORA-01034: ORACLE not available
              Process ID: 0
              Session ID: 0 Serial number: 0

              If I am to delete control.dbf and then run a create controfile script to build a new controlfile, what are those steps?

              I found this in another forum. Are these correct:

              STARTUP NOMOUNT
              CREATE CONTROLFILE SET DATABASE "DBNAME" RESETLOGS NOARCHIVELOG;
              CREATE CONTROLFILE REUSE DATABASE "DBNAME" RESETLOGS NOARCHIVELOG
              MAXLOGFILES 32
              MAXLOGMEMBERS 2
              MAXDATAFILES 30
              MAXINSTANCES 8
              MAXLOGHISTORY 800
              LOGFILE
              GROUP 1 '/u01/oracle/7.1.6/dbs/log1p716.dbf' SIZE 500K,
              GROUP 2 '/u01/oracle/7.1.6/dbs/log2p716.dbf' SIZE 500K,
              GROUP 3 '/u01/oracle/7.1.6/dbs/log3p716.dbf' SIZE 500K
              DATAFILE
              '/u01/oracle/7.1.6/dbs/systp716.dbf' SIZE 40M,
              '/u01/oracle/7.1.6/dbs/tempp716.dbf' SIZE 550K,
              '/u01/oracle/7.1.6/dbs/toolp716.dbf' SIZE 15M
              ;

              # Recovery is required if any of the datafiles are restored backups,

              # or if the last shutdown was not normal or immediate.

              RECOVER DATABASE

              # Database can now be opened normally.

              ALTER DATABASE OPEN;
              • 19. Re: OracleServiceXE Won't Start After Active Directory Install
                clcarter
                Connected to an idle instance.
                The correct answer there is either 'startup', 'startup nomount', or 'startup mount'. Can't go from shutdown to open, you can only go to open from the mount mode.
                found this in another forum. Are these correct:
                No. Not for your database, adjustments to the create controlfile statement are needed. The correct filenames as well as the correct database name. The:
                CREATE CONTROLFILE REUSE DATABASE "XE" ...
                is part of the SQL needed, not the 'set database "...' line. The database character should also be specified in the create controlfile statement, for 11g XE its AL32UTF8. The LOGFILE stanza needs adjustment, filenames. Look at the direction of the slashes, that should tell you that its not quite correct for your host.
                to build a new controlfile, what are those steps?
                First try a plain startup instead of the 'alter database open'. It may work, it may not. If it does not work, then yes, startup nomount, run the *correct* create controlfile statement, alter database open, and (re)add the temporary datafile.

                If you really want to try a create controlfile statement, in the ...ORADATA\XE directory make a REDO folder, *rename* CONTROL.DBF to CONTROL.DBF.bk0 and sqlplus ... startup nomount and:

                {code}
                CREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS NOARCHIVELOG
                LOGFILE
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF' SIZE 50M,
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF' SIZE 50M
                DATAFILE
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF',
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF',
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF',
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF',
                'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\APEX_1303222700452456.DBF'
                CHARACTER SET AL32UTF8
                ;
                {code}

                Adding in a 'recover database;' after running the create controlfile statement might throw an error, but if recovery is not needed that is normal.

                The tempfile will also have to be (re)added *after* the 'alter database open' if it succeeds. The new controlfile has no information on the tempfiles and temporary tablespaces are not relevant in a recovery situation, they only matter in an open database, when a user session needs temp space for sorting operations, to fix it:

                {code}
                ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEMP.DBF'
                SIZE 200M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2000M;
                {code}
                • 20. Re: OracleServiceXE Won't Start After Active Directory Install
                  JL09
                  First try a plain startup instead of the 'alter database open'.
                  That worked. But I continued with the rest of your suggestions.

                  1. Made REDO folder
                  2. Renamed CONTROL.DBF to CONTROL.DBF.bk0

                  and

                  C:\Users\Administrator.DISMART>sqlplus /nolog
                  SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 1 20:14:44 2012
                  Copyright (c) 1982, 2010, Oracle. All rights reserved.

                  SQL> connect /as sysdba
                  Connected to an idle instance.

                  SQL> startup nomount
                  ORACLE instance started.
                  Total System Global Area 1071333376 bytes
                  Fixed Size 1388352 bytes
                  Variable Size 624951488 bytes
                  Database Buffers 440401920 bytes
                  Redo Buffers 4591616 bytes

                  SQL> CREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS NOARCHIVELOG
                  2 LOGFILE
                  3 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF' SIZE 50M,
                  4 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF' SIZE 50M
                  5 DATAFILE
                  6 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF',
                  7 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF',
                  8 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF',
                  9 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF',
                  10 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\APEX_1303222700452456.DBF'
                  11 CHARACTER SET AL32UTF8
                  12 ;
                  Control file created.
                  SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEMP.
                  DBF'
                  2 SIZE 200M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 2000M;
                  ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEMP.DBF'
                  *
                  ERROR at line 1:
                  ORA-01109: database not open

                  What next? Can you please provide a step-by-step? I had a bit of a time following the last set of instructions.
                  • 21. Re: OracleServiceXE Won't Start After Active Directory Install
                    clcarter
                    tempfile will also have to be (re)added after the 'alter database open'
                    Create controlfile steps:

                    Database closed/shutdown.
                    Move controlfile so the instance can create a new controlfile.
                    Startup nomount.
                    Run create controlfile statement. This leaves the instance in the mount state, recovery can be done.
                    Recover database, if needed. If the datafiles are from a cold backup (shutdown) this step can be skipped.
                    Alter database open.
                    Add tempfile(s).
                    Done.

                    For a double check, its good to run a complete shutdown/startup cycle. When the instance is not in archivelog mode, recovery is not possible anyway.

                    shutdown immediate;
                    startup;

                    And for future use, its handy to make a controlfile trace backup, this will create a trace file with all these steps in the .../diag/rdbms/.../trace directory, run this statement as system or sysdba and find the trace file (%ORACLE_SID%_ora_<n>.trc) generated in the trace folder. If you don't specify resetlogs or noresetlogs you'll have both versions of the steps in that file. Can also use the 'as' clause to specify a different location and filename.

                    alter database backup controlfile to trace [as '<drive>:\<path>\<filename>'] resetlogs ;
                    • 22. Re: OracleServiceXE Won't Start After Active Directory Install
                      JL09
                      Thank you for your help. Your steps went a little quick for me but I tried to follow. These are the steps I performed:

                      0. sqlplus /nolog
                      1. connect /as sysdba
                      2. shutdown immediate
                      3. moved current controlfile
                      4. ran:

                      SQL> CREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS NOARCHIVELOG
                      2 LOGFILE
                      3 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF' SIZE 50M,
                      4 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF' SIZE 50M
                      5 DATAFILE
                      6 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF',
                      7 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF',
                      8 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF',
                      9 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF',
                      10 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\APEX_1303222700452456.DBF'
                      11 CHARACTER SET AL32UTF8
                      12 ;
                      Control file created.

                      5. datafiles were from a cold backup so I assumed recovery was not needed
                      6. upon running :

                      Alter database open

                      received:

                      ERROR at line 1:
                      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

                      Thanks.
                      • 23. Re: OracleServiceXE Won't Start After Active Directory Install
                        clcarter
                        Just add resetlogs to the alter database open statement, no need to repeat all those steps again.

                        There's lots more to managing an RDBMS, although restoring from a backup is a frequent chore for the dba. Also its good to get familiar with the documentation, its quite thorough but that also means it can be difficult to locate an exact how-to quickly. The 2-Day DBA Guide is a good place to start, for XE at: http://docs.oracle.com/cd/E17781_01/server.112/e18804/toc.htm

                        And there will be several features available to XE that aren't covered in the XE documentation, the full 11gR2 documentation set is at http://www.oracle.com/pls/db112/portal.all_books

                        Enabling archivelog mode for hot backups is a good thing to do, that way the instance does not have to be shutdown to get a good backup.
                        • 24. Re: OracleServiceXE Won't Start After Active Directory Install
                          JL09
                          That statement seemed to work. It outputted "database altered" and after adding the temp file it outputted "tablespace altered". However, still nothing at the startup page.

                          Here's the lastest alert file. Would you be open to setting up a remote assistance session to get this resolved? I would be willing to compensate for all of your time.

                          Fri Nov 02 22:41:13 2012
                          alter database open resetlogs
                          RESETLOGS after incomplete recovery UNTIL CHANGE 3321567
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_3524.trc:
                          ORA-00313: open failed for members of log group 1 of thread 1
                          ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF'
                          ORA-27041: unable to open file
                          OSD-04002: unable to open file
                          O/S-Error: (OS 2) The system cannot find the file specified.
                          Clearing online redo logfile 1 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF
                          Clearing online log 1 of thread 1 sequence number 0
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_3524.trc:
                          ORA-00313: open failed for members of log group 1 of thread 1
                          ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF'
                          ORA-27041: unable to open file
                          OSD-04002: unable to open file
                          O/S-Error: (OS 2) The system cannot find the file specified.
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_3524.trc:
                          ORA-00313: open failed for members of log group 1 of thread 1
                          ORA-00312: online log 1 thread 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF'
                          ORA-27041: unable to open file
                          OSD-04002: unable to open file
                          O/S-Error: (OS 2) The system cannot find the file specified.
                          Clearing online redo logfile 1 complete
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_3524.trc:
                          ORA-00313: open failed for members of log group 2 of thread 1
                          ORA-00312: online log 2 thread 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF'
                          ORA-27041: unable to open file
                          OSD-04002: unable to open file
                          O/S-Error: (OS 2) The system cannot find the file specified.
                          Clearing online redo logfile 2 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF
                          Clearing online log 2 of thread 1 sequence number 0
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_3524.trc:
                          ORA-00313: open failed for members of log group 2 of thread 1
                          ORA-00312: online log 2 thread 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF'
                          ORA-27041: unable to open file
                          OSD-04002: unable to open file
                          O/S-Error: (OS 2) The system cannot find the file specified.
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_3524.trc:
                          ORA-00313: open failed for members of log group 2 of thread 1
                          ORA-00312: online log 2 thread 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF'
                          ORA-27041: unable to open file
                          OSD-04002: unable to open file
                          O/S-Error: (OS 2) The system cannot find the file specified.
                          Clearing online redo logfile 2 complete
                          Online log C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF: Thread 1 Group 1 was previously cleared
                          Online log C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO01.DBF: Thread 1 Group 2 was previously cleared
                          Fri Nov 02 22:41:17 2012
                          Setting recovery target incarnation to 2
                          Fri Nov 02 22:41:18 2012
                          Assigning activation ID 2679356892 (0x9fb3bddc)
                          Thread 1 opened at log sequence 1
                          Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF
                          Successful open of redo thread 1
                          Fri Nov 02 22:41:18 2012
                          SMON: enabling cache recovery
                          Fri Nov 02 22:41:24 2012
                          [3524] Successfully onlined Undo Tablespace 2.
                          Undo initialization finished serial:0 start:166408637 end:166410306 diff:1669 (16 seconds)
                          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
                          SMON: enabling tx recovery
                          *********************************************************************
                          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
                          *********************************************************************
                          Database Characterset is AL32UTF8
                          Opening with Resource Manager plan: INTERNAL_PLAN_XE
                          Fri Nov 02 22:41:27 2012
                          Starting background process VKRM
                          Fri Nov 02 22:41:27 2012
                          VKRM started with pid=23, OS id=1280
                          **********************************************************
                          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
                          Fri Nov 02 22:41:32 2012
                          QMNC started with pid=24, OS id=4620
                          LOGSTDBY: Validating controlfile with logical metadata
                          Fri Nov 02 22:41:34 2012
                          LOGSTDBY: Validation complete
                          Fri Nov 02 22:41:47 2012
                          Starting background process CJQ0
                          Fri Nov 02 22:41:47 2012
                          CJQ0 started with pid=28, OS id=4968
                          Fri Nov 02 22:41:47 2012
                          Completed: alter database open resetlogs
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          Setting Resource Manager plan SCHEDULER[0x30FB]:DEFAULT_MAINTENANCE_PLAN via scheduler window
                          Fri Nov 02 22:41:55 2012
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_m001_4140.trc:
                          ORA-25153: Temporary Tablespace is Empty
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:41:58 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:42:00 2012
                          Shutting down instance (immediate)
                          Shutting down instance: further logons disabled
                          Stopping background process QMNC
                          Stopping background process CJQ0
                          Stopping background process MMNL
                          Stopping background process MMON
                          License high water mark = 5
                          Stopping Job queue slave processes, flags = 7
                          Fri Nov 02 22:42:03 2012
                          Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_j002_3996.trc:
                          ORA-12012: error on auto execute of job "APEX_040100"."ORACLE_APEX_PURGE_SESSIONS"
                          ORA-01089: immediate shutdown in progress - no operations are permitted
                          ORA-06512: at "APEX_040100.WWV_FLOW_CACHE", line 45
                          ORA-06512: at line 1
                          Process ID:
                          Session ID: 0 Serial number: 0
                          Job queue slave processes stopped
                          All dispatchers and shared servers shutdown
                          ALTER DATABASE CLOSE NORMAL
                          Fri Nov 02 22:42:06 2012
                          SMON: disabling tx recovery
                          SMON: disabling cache recovery
                          Fri Nov 02 22:42:06 2012
                          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 DISMOUNT
                          ARCH: Archival disabled due to shutdown: 1089
                          Shutting down archive processes
                          Archiving is disabled
                          ARCH: Archival disabled due to shutdown: 1089
                          Shutting down archive processes
                          Archiving is disabled
                          Fri Nov 02 22:42:07 2012
                          Stopping background process VKTM
                          Fri Nov 02 22:42:09 2012
                          Instance shutdown complete
                          Fri Nov 02 22:42:12 2012
                          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 =18
                          LICENSE_MAX_USERS = 0
                          SYS auditing is disabled
                          Starting up:
                          Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
                          Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
                          System parameters with non-default values:
                          sessions = 172
                          spfile = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
                          memory_target = 1G
                          control_files = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
                          compatible = "11.2.0.0.0"
                          db_recovery_file_dest = "C:\oraclexe\app\oracle\fast_recovery_area"
                          db_recovery_file_dest_size= 10G
                          undo_management = "AUTO"
                          undo_tablespace = "UNDOTBS1"
                          remote_login_passwordfile= "EXCLUSIVE"
                          dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
                          shared_servers = 4
                          job_queue_processes = 4
                          audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
                          db_name = "XE"
                          open_cursors = 300
                          diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
                          Fri Nov 02 22:42:21 2012
                          PMON started with pid=2, OS id=812
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          Fri Nov 02 22:42:21 2012
                          PSP0 started with pid=3, OS id=2596
                          Fri Nov 02 22:42:21 2012
                          VKTM started with pid=4, OS id=4144 at elevated priority
                          VKTM running at (10)millisec precision with DBRM quantum (100)ms
                          Fri Nov 02 22:42:21 2012
                          GEN0 started with pid=5, OS id=4364
                          Fri Nov 02 22:42:21 2012
                          DIAG started with pid=6, OS id=2012
                          Fri Nov 02 22:42:21 2012
                          DBRM started with pid=7, OS id=604
                          Fri Nov 02 22:42:21 2012
                          DIA0 started with pid=8, OS id=2040
                          Fri Nov 02 22:42:21 2012
                          MMAN started with pid=9, OS id=2508
                          Fri Nov 02 22:42:21 2012
                          DBW0 started with pid=10, OS id=3948
                          Fri Nov 02 22:42:21 2012
                          LGWR started with pid=11, OS id=3228
                          Fri Nov 02 22:42:21 2012
                          CKPT started with pid=12, OS id=3640
                          Fri Nov 02 22:42:21 2012
                          SMON started with pid=13, OS id=4276
                          Fri Nov 02 22:42:21 2012
                          RECO started with pid=14, OS id=4688
                          Fri Nov 02 22:42:21 2012
                          MMON started with pid=15, OS id=4420
                          Fri Nov 02 22:42:21 2012
                          MMNL started with pid=16, OS id=4972
                          starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                          starting up 4 shared server(s) ...
                          ORACLE_BASE from environment = C:\oraclexe\app\oracle
                          Fri Nov 02 22:42:22 2012
                          ALTER DATABASE MOUNT
                          Changing di2dbun from to XE
                          Successful mount of redo thread 1, with mount id 2679422094
                          Database mounted in Exclusive Mode
                          Lost write protection disabled
                          Completed: ALTER DATABASE MOUNT
                          Fri Nov 02 22:42:27 2012
                          ALTER DATABASE OPEN
                          Thread 1 opened at log sequence 1
                          Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF
                          Successful open of redo thread 1
                          SMON: enabling cache recovery
                          [1204] Successfully onlined Undo Tablespace 2.
                          Undo initialization finished serial:0 start:166476638 end:166477714 diff:1076 (10 seconds)
                          Verifying file header compatibility for 11g tablespace encryption..
                          Verifying 11g file header compatibility for tablespace encryption completed
                          SMON: enabling tx recovery
                          *********************************************************************
                          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
                          *********************************************************************
                          Database Characterset is AL32UTF8
                          Opening with Resource Manager plan: INTERNAL_PLAN_XE
                          Fri Nov 02 22:42:32 2012
                          Starting background process VKRM
                          Fri Nov 02 22:42:32 2012
                          VKRM started with pid=22, OS id=4940
                          replication_dependency_tracking turned off (no async multimaster replication found)
                          Starting background process QMNC
                          Fri Nov 02 22:42:35 2012
                          QMNC started with pid=24, OS id=1796
                          Fri Nov 02 22:42:38 2012
                          Completed: ALTER DATABASE OPEN
                          Fri Nov 02 22:42:44 2012
                          Starting background process CJQ0
                          Fri Nov 02 22:42:44 2012
                          CJQ0 started with pid=29, OS id=3408
                          Fri Nov 02 22:42:46 2012
                          db_recovery_file_dest_size of 10240 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.
                          Setting Resource Manager plan SCHEDULER[0x30FB]:DEFAULT_MAINTENANCE_PLAN via scheduler window
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          ...

                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:47:46 2012
                          alter tablespace temp add tempfile 'c:\oraclexe\app\oracle\oradata\xe\temp.dbf' size 200m reuse autoextend on next 100m maxsize 2000m
                          Completed: alter tablespace temp add tempfile 'c:\oraclexe\app\oracle\oradata\xe\temp.dbf' size 200m reuse autoextend on next 100m maxsize 2000m
                          Fri Nov 02 22:47:47 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:47:57 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:48:07 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:48:07 2012
                          Shutting down instance (immediate)
                          Stopping background process SMCO
                          Shutting down instance: further logons disabled
                          Stopping background process QMNC
                          Stopping background process CJQ0
                          Stopping background process MMNL
                          Stopping background process MMON
                          License high water mark = 6
                          All dispatchers and shared servers shutdown
                          ALTER DATABASE CLOSE NORMAL
                          Fri Nov 02 22:48:12 2012
                          SMON: disabling tx recovery
                          SMON: disabling cache recovery
                          Fri Nov 02 22:48:12 2012
                          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 DISMOUNT
                          ARCH: Archival disabled due to shutdown: 1089
                          Shutting down archive processes
                          Archiving is disabled
                          ARCH: Archival disabled due to shutdown: 1089
                          Shutting down archive processes
                          Archiving is disabled
                          Fri Nov 02 22:48:13 2012
                          Stopping background process VKTM
                          Fri Nov 02 22:48:15 2012
                          Instance shutdown complete
                          Fri Nov 02 22:48:18 2012
                          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 =18
                          LICENSE_MAX_USERS = 0
                          SYS auditing is disabled
                          Starting up:
                          Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
                          Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
                          System parameters with non-default values:
                          sessions = 172
                          spfile = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
                          memory_target = 1G
                          control_files = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
                          compatible = "11.2.0.0.0"
                          db_recovery_file_dest = "C:\oraclexe\app\oracle\fast_recovery_area"
                          db_recovery_file_dest_size= 10G
                          undo_management = "AUTO"
                          undo_tablespace = "UNDOTBS1"
                          remote_login_passwordfile= "EXCLUSIVE"
                          dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
                          shared_servers = 4
                          job_queue_processes = 4
                          audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
                          db_name = "XE"
                          open_cursors = 300
                          diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
                          Fri Nov 02 22:48:26 2012
                          PMON started with pid=2, OS id=5116
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          Fri Nov 02 22:48:26 2012
                          PSP0 started with pid=3, OS id=1272
                          Fri Nov 02 22:48:26 2012
                          VKTM started with pid=4, OS id=3992 at elevated priority
                          VKTM running at (10)millisec precision with DBRM quantum (100)ms
                          Fri Nov 02 22:48:26 2012
                          GEN0 started with pid=5, OS id=4624
                          Fri Nov 02 22:48:26 2012
                          DIAG started with pid=6, OS id=4992
                          Fri Nov 02 22:48:26 2012
                          DBRM started with pid=7, OS id=3048
                          Fri Nov 02 22:48:26 2012
                          DIA0 started with pid=8, OS id=3136
                          Fri Nov 02 22:48:26 2012
                          MMAN started with pid=9, OS id=4984
                          Fri Nov 02 22:48:26 2012
                          DBW0 started with pid=10, OS id=3212
                          Fri Nov 02 22:48:26 2012
                          LGWR started with pid=11, OS id=3004
                          Fri Nov 02 22:48:26 2012
                          CKPT started with pid=12, OS id=4692
                          Fri Nov 02 22:48:26 2012
                          SMON started with pid=13, OS id=3632
                          Fri Nov 02 22:48:26 2012
                          RECO started with pid=14, OS id=4848
                          Fri Nov 02 22:48:26 2012
                          MMON started with pid=15, OS id=4856
                          Fri Nov 02 22:48:26 2012
                          MMNL started with pid=16, OS id=4196
                          starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                          starting up 4 shared server(s) ...
                          ORACLE_BASE from environment = C:\oraclexe\app\oracle
                          Fri Nov 02 22:48:26 2012
                          ALTER DATABASE MOUNT
                          Successful mount of redo thread 1, with mount id 2679447802
                          Database mounted in Exclusive Mode
                          Lost write protection disabled
                          Completed: ALTER DATABASE MOUNT
                          Fri Nov 02 22:48:32 2012
                          ALTER DATABASE OPEN
                          Thread 1 opened at log sequence 1
                          Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF
                          Successful open of redo thread 1
                          SMON: enabling cache recovery
                          [4576] Successfully onlined Undo Tablespace 2.
                          Undo initialization finished serial:0 start:166841712 end:166842570 diff:858 (8 seconds)
                          Verifying file header compatibility for 11g tablespace encryption..
                          Verifying 11g file header compatibility for tablespace encryption completed
                          SMON: enabling tx recovery
                          Database Characterset is AL32UTF8
                          Opening with Resource Manager plan: INTERNAL_PLAN_XE
                          Fri Nov 02 22:48:37 2012
                          Starting background process VKRM
                          Fri Nov 02 22:48:37 2012
                          VKRM started with pid=22, OS id=4372
                          replication_dependency_tracking turned off (no async multimaster replication found)
                          Starting background process QMNC
                          Fri Nov 02 22:48:40 2012
                          QMNC started with pid=24, OS id=664
                          Fri Nov 02 22:48:43 2012
                          Completed: ALTER DATABASE OPEN
                          Fri Nov 02 22:48:50 2012
                          Starting background process CJQ0
                          Fri Nov 02 22:48:50 2012
                          CJQ0 started with pid=29, OS id=3336
                          Fri Nov 02 22:48:52 2012
                          db_recovery_file_dest_size of 10240 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.
                          Setting Resource Manager plan SCHEDULER[0x30FB]:DEFAULT_MAINTENANCE_PLAN via scheduler window
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          Fri Nov 02 22:49:00 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:49:10 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:49:20 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:49:30 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:49:40 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:49:50 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:50:00 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:50:10 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:50:20 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:50:30 2012
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                          O/S-Error: (OS 1) Incorrect function. !
                          Fri Nov 02 22:50:37 2012
                          Shutting down instance (immediate)
                          Shutting down instance: further logons disabled
                          Stopping background process QMNC
                          Stopping background process CJQ0
                          Stopping background process MMNL
                          Stopping background process MMON
                          License high water mark = 3
                          All dispatchers and shared servers shutdown
                          alter database close normal
                          Fri Nov 02 22:50:41 2012
                          SMON: disabling tx recovery
                          SMON: disabling cache recovery
                          Fri Nov 02 22:50:42 2012
                          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 dismount
                          ARCH: Archival disabled due to shutdown: 1089
                          Shutting down archive processes
                          Archiving is disabled
                          ARCH: Archival disabled due to shutdown: 1089
                          Shutting down archive processes
                          Archiving is disabled
                          Fri Nov 02 22:50:43 2012
                          Stopping background process VKTM
                          Fri Nov 02 22:50:45 2012
                          Instance shutdown complete
                          Fri Nov 02 22:50:49 2012
                          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 =18
                          LICENSE_MAX_USERS = 0
                          SYS auditing is disabled
                          Starting up:
                          Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
                          Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
                          System parameters with non-default values:
                          sessions = 172
                          spfile = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
                          memory_target = 1G
                          control_files = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
                          compatible = "11.2.0.0.0"
                          db_recovery_file_dest = "C:\oraclexe\app\oracle\fast_recovery_area"
                          db_recovery_file_dest_size= 10G
                          undo_management = "AUTO"
                          undo_tablespace = "UNDOTBS1"
                          remote_login_passwordfile= "EXCLUSIVE"
                          dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
                          shared_servers = 4
                          job_queue_processes = 4
                          audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
                          db_name = "XE"
                          open_cursors = 300
                          diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
                          Fri Nov 02 22:50:58 2012
                          PMON started with pid=2, OS id=520
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          Fri Nov 02 22:50:58 2012
                          PSP0 started with pid=3, OS id=2248
                          Fri Nov 02 22:50:58 2012
                          VKTM started with pid=4, OS id=2072 at elevated priority
                          VKTM running at (10)millisec precision with DBRM quantum (100)ms
                          Fri Nov 02 22:50:58 2012
                          GEN0 started with pid=5, OS id=1876
                          Fri Nov 02 22:50:58 2012
                          DIAG started with pid=6, OS id=1788
                          Fri Nov 02 22:50:58 2012
                          DBRM started with pid=7, OS id=3812
                          Fri Nov 02 22:50:58 2012
                          DIA0 started with pid=8, OS id=2780
                          Fri Nov 02 22:50:58 2012
                          MMAN started with pid=9, OS id=432
                          Fri Nov 02 22:50:58 2012
                          DBW0 started with pid=10, OS id=4544
                          Fri Nov 02 22:50:58 2012
                          LGWR started with pid=11, OS id=1760
                          Fri Nov 02 22:50:58 2012
                          CKPT started with pid=12, OS id=4296
                          Fri Nov 02 22:50:58 2012
                          SMON started with pid=13, OS id=612
                          Fri Nov 02 22:50:58 2012
                          RECO started with pid=14, OS id=4532
                          Fri Nov 02 22:50:58 2012
                          MMON started with pid=15, OS id=4240
                          Fri Nov 02 22:50:58 2012
                          MMNL started with pid=16, OS id=4936
                          starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                          starting up 4 shared server(s) ...
                          ORACLE_BASE from environment = C:\oraclexe\app\oracle
                          Fri Nov 02 22:50:58 2012
                          alter database mount exclusive
                          Successful mount of redo thread 1, with mount id 2679471762
                          Database mounted in Exclusive Mode
                          Lost write protection disabled
                          Completed: alter database mount exclusive
                          alter database open
                          Thread 1 opened at log sequence 1
                          Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\APP\ORACLE\ORADATA\XE\REDO\REDO02.DBF
                          Successful open of redo thread 1
                          SMON: enabling cache recovery
                          [3196] Successfully onlined Undo Tablespace 2.
                          Undo initialization finished serial:0 start:166993313 end:166994156 diff:843 (8 seconds)
                          Verifying file header compatibility for 11g tablespace encryption..
                          Verifying 11g file header compatibility for tablespace encryption completed
                          SMON: enabling tx recovery
                          Fri Nov 02 22:51:08 2012
                          Database Characterset is AL32UTF8
                          Opening with Resource Manager plan: INTERNAL_PLAN_XE
                          Fri Nov 02 22:51:09 2012
                          Starting background process VKRM
                          Fri Nov 02 22:51:09 2012
                          VKRM started with pid=23, OS id=3836
                          replication_dependency_tracking turned off (no async multimaster replication found)
                          Starting background process QMNC
                          Fri Nov 02 22:51:11 2012
                          QMNC started with pid=24, OS id=3060
                          Completed: alter database open
                          Fri Nov 02 22:51:17 2012
                          Starting ORACLE instance (normal)
                          Fri Nov 02 22:51:20 2012
                          Starting background process CJQ0
                          Fri Nov 02 22:51:20 2012
                          CJQ0 started with pid=28, OS id=3560
                          Fri Nov 02 22:51:23 2012
                          db_recovery_file_dest_size of 10240 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.
                          Setting Resource Manager plan SCHEDULER[0x30FB]:DEFAULT_MAINTENANCE_PLAN via scheduler window
                          OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                          Fri Nov 02 22:51:31 2012
                          • 25. Re: OracleServiceXE Won't Start After Active Directory Install
                            orafad
                            JL09 wrote:
                            That statement seemed to work. It outputted "database altered" and after adding the temp file it outputted "tablespace altered". However, still nothing at the startup page.

                            Here's the lastest alert file. Would you be open to setting up a remote assistance session to get this resolved? I would be willing to compensate for all of your time.
                            It seems you have managed to open the database.

                            The unavailable Get Started page is likely a minor problem.

                            Please post output from lsnrctl stat.


                            You could also try the following:

                            Stop the listener (e.g. via Services, OracleXETNSListener)

                            Move listener.ora (network\admin\listener.ora, rename to listener.ora_xe)

                            Start listener, which will now use default listener parameters.

                            Wait at least one minute for instance to register services.


                            Again, run and post output from lsnrctl stat - and try the Get Started url.


                            Edited by: orafad on Nov 3, 2012 10:14 PM
                            • 26. Re: OracleServiceXE Won't Start After Active Directory Install
                              JL09
                              I moved the listener file and restarted the services - a new one was not created.

                              How would I output from lsnrctl stat?

                              Edited by: JL09 on Nov 3, 2012 2:29 PM
                              • 27. Re: OracleServiceXE Won't Start After Active Directory Install
                                orafad
                                JL09 wrote:
                                I moved the listener file and restarted the services - a new one was not created.
                                That's expected. It uses a built-in set of (default) parameter values (when a listener.ora is not found/loaded).

                                How would I output from lsnrctl stat?
                                Open command window (cmd). Then enter the command.

                                Edited by: orafad on Nov 3, 2012 10:36 PM
                                • 28. Re: OracleServiceXE Won't Start After Active Directory Install
                                  JL09
                                  Thanks.

                                  C:\Users\Administrator.DISMART>lsnrctl stat

                                  LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 03-NOV-2012 17:37
                                  :52

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

                                  Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                                  STATUS of the LISTENER
                                  ------------------------
                                  Alias LISTENER
                                  Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
                                  ction
                                  Start Date 03-NOV-2012 17:26:49
                                  Uptime 0 days 0 hr. 11 min. 3 sec
                                  Trace Level off
                                  Security ON: Local OS Authentication
                                  SNMP OFF
                                  Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\DISMART\listener\a
                                  lert\log.xml
                                  Listening Endpoints Summary...
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DISMART.server.local)(PORT=1521)))
                                  Services Summary...
                                  Service "XEXDB" has 1 instance(s).
                                  Instance "xe", status READY, has 1 handler(s) for this service...
                                  Service "xe" has 1 instance(s).
                                  Instance "xe", status READY, has 1 handler(s) for this service...
                                  The command completed successfully
                                  • 29. Re: OracleServiceXE Won't Start After Active Directory Install
                                    orafad
                                    JL09 wrote:
                                    Listening Endpoints Summary...
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DISMART.server.local)(PORT=1521)))
                                    Here should be a http endpoint, that Apex and Get Started app uses.
                                    Services Summary...
                                    Service "XEXDB" has 1 instance(s).
                                    Instance "xe", status READY, has 1 handler(s) for this service...
                                    Service "xe" has 1 instance(s).
                                    Instance "xe", status READY, has 1 handler(s) for this service...
                                    The command completed successfully
                                    Services ok, XDB is there but no endpoint.

                                    Well, perhaps firewall rules have changed in the process.

                                    Could you, at least for 1 minute, try disabling the Windows firewall? During that time bounce Oracle XE (stop and start the service/database), then see if another endpoints shows up from lsnrctl stat.

                                    Do you know for sure that Get Started worked before?

                                    Post if possible output from:
                                    hostname
                                    ping -4 <hostname result here>
                                    ping -4 localhost

                                    Edited by: orafad on Nov 3, 2012 10:49 PM