1 2 3 Previous Next 39 Replies Latest reply: Nov 6, 2012 5:31 AM by orafad RSS

    OracleServiceXE Won't Start After Active Directory Install

    JL09
      Hello Folks,

      Newbie to Oracle but proficient in general I.T. stuff. Client contacted us stating Active Directory role installed on Server 2008 box running as a virtual machine. After which client could no longer remotely access server and subsequently removed Active Directory. Since then, OracleServiceXE will not start and no response on the homepage of Oracle at http://127.0.0.1:8080/apex/f?p=4950.

      I see many other posts here of troubleshooting that led to reinstall of software. We're OK with that. However, I would like to verify that the customer's database will be able to be reattached after the reinstall? If so, what is that process please?

      We're open to troubleshooting as well if there's a relatively easy fix but otherwise open to reinstall.

      We're open to paid support if necessary as client has been down for a few days now.

      Please help!

      Thanks,

      Jon
        • 1. Re: OracleServiceXE Won't Start After Active Directory Install
          clcarter
          With a bit of care, a backup of all database files taken with the instance shut down, it's not too hard to preserve the old database. Installer creates a new database, shut it down, copy in the files, and if the drives/paths are identical you should be able to go directly to a startup mount; and alter database open resetlogs;

          The apex web page not working isn't relavent yet, if there is no database running the http:...8080/apex pages are not going to work.

          First things first, back up the disaster. That will at least give some sort of state to fallback to. Find the .dbf files for the instance and make a copy of them some place safe, not under the OracleXE folder- a deinstall would wipe them. Make a new folder called "DontTuch" maybe under c:\temp put a copy of the dbf files there.

          On Windows, if the ...ServiceXE will not start it might be helpful to figure out why.

          Check the alertlog, its named alert_xe.log and also copying out the last section where the database started to get all the non-default init parameters could also be quite helpful later on.
          • 2. Re: OracleServiceXE Won't Start After Active Directory Install
            JL09
            clcarter,

            Thank you. I copied the entire database directory to the desktop. Should be good to go there.

            Now, how would one shut down the database, go to a startup mount and alter the database open reset logs?

            Alert log (beginning and end) follows:

            Thu Aug 16 16:01:10 2012
            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 =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 client-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\CONFIG\SCRIPTS\INIT.ORA on machine DISMART
            System parameters with non-default values:
            sessions = 172
            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 Aug 16 16:01:22 2012
            PMON started with pid=2, OS id=2412
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
            Thu Aug 16 16:01:22 2012
            PSP0 started with pid=3, OS id=3060
            Thu Aug 16 16:01:22 2012
            VKTM started with pid=4, OS id=1128 at elevated priority
            VKTM running at (10)millisec precision with DBRM quantum (100)ms
            Thu Aug 16 16:01:22 2012
            GEN0 started with pid=5, OS id=5772
            Thu Aug 16 16:01:22 2012
            DIAG started with pid=6, OS id=5972
            Thu Aug 16 16:01:22 2012
            DBRM started with pid=7, OS id=5832
            Thu Aug 16 16:01:22 2012
            DIA0 started with pid=8, OS id=5812
            Thu Aug 16 16:01:22 2012
            MMAN started with pid=9, OS id=5200
            Thu Aug 16 16:01:22 2012
            DBW0 started with pid=10, OS id=2036
            Thu Aug 16 16:01:22 2012
            LGWR started with pid=11, OS id=4284
            Thu Aug 16 16:01:22 2012
            CKPT started with pid=12, OS id=5168
            Thu Aug 16 16:01:22 2012
            SMON started with pid=13, OS id=6020
            Thu Aug 16 16:01:22 2012
            RECO started with pid=14, OS id=5940
            Thu Aug 16 16:01:22 2012
            MMON started with pid=15, OS id=480
            Thu Aug 16 16:01:22 2012
            MMNL started with pid=16, OS id=5320
            Thu Aug 16 16:01:22 2012
            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 Aug 16 16:01:22 2012
            kcbztek_populate_tbskey: db key in controlfile and datafile 1 is inconsistent..
            Full restore complete of datafile 3 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF. Elapsed time: 0:00:02
            checkpoint is 354593
            Full restore complete of datafile 4 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF. Elapsed time: 0:00:09
            checkpoint is 354593
            Thu Aug 16 16:01:53 2012
            Full restore complete of datafile 1 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF. Elapsed time: 0:00:31
            checkpoint is 354593
            Thu Aug 16 16:02:09 2012
            Full restore complete of datafile 2 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF. Elapsed time: 0:00:47
            checkpoint is 354593
            Thu Aug 16 16:02:09 2012
            Create controlfile reuse set database "XE"
            MAXINSTANCES 8
            MAXLOGHISTORY 1
            MAXLOGFILES 16
            MAXLOGMEMBERS 3
            MAXDATAFILES 100
            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'
            LOGFILE
            GROUP 1 SIZE 51200K,
            GROUP 2 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 release
            Thu Aug 16 16:02:10 2012
            Successful mount of redo thread 1, with mount id 2672646209
            Completed: Create controlfile reuse set database "XE"
            MAXINSTANCES 8
            MAXLOGHISTORY 1
            MAXLOGFILES 16
            MAXLOGMEMBERS 3
            MAXDATAFILES 100
            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'
            LOGFILE
            GROUP 1 SIZE 51200K,
            GROUP 2 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
            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
            ARCH: Archival disabled due to shutdown: 1089
            Shutting down archive processes
            Archiving is disabled
            Thu Aug 16 16:02:14 2012
            Stopping background process VKTM
            Thu Aug 16 16:02:16 2012
            Instance shutdown complete
            Thu Aug 16 16:02: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 client-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\CONFIG\SCRIPTS\INITXETEMP.ORA on machine DISMART
            System parameters with non-default values:
            sessions = 172
            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
            audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
            db_name = "XE"
            open_cursors = 300
            diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
            Thu Aug 16 16:02:26 2012
            PMON started with pid=2, OS id=5128
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
            Thu Aug 16 16:02:26 2012
            PSP0 started with pid=3, OS id=5388
            Thu Aug 16 16:02:26 2012
            VKTM started with pid=4, OS id=4004 at elevated priority
            VKTM running at (10)millisec precision with DBRM quantum (100)ms
            Thu Aug 16 16:02:26 2012
            GEN0 started with pid=5, OS id=4976
            Thu Aug 16 16:02:26 2012
            DIAG started with pid=6, OS id=5860
            Thu Aug 16 16:02:26 2012
            DBRM started with pid=7, OS id=5532
            Thu Aug 16 16:02:26 2012
            DIA0 started with pid=8, OS id=2820
            Thu Aug 16 16:02:26 2012
            MMAN started with pid=9, OS id=5088
            Thu Aug 16 16:02:26 2012
            DBW0 started with pid=10, OS id=4236
            Thu Aug 16 16:02:26 2012
            LGWR started with pid=11, OS id=4240
            Thu Aug 16 16:02:26 2012
            CKPT started with pid=12, OS id=4244
            Thu Aug 16 16:02:26 2012
            SMON started with pid=13, OS id=5432
            Thu Aug 16 16:02:26 2012
            RECO started with pid=14, OS id=5076
            Thu Aug 16 16:02:26 2012
            MMON started with pid=15, OS id=5124
            Thu Aug 16 16:02:26 2012
            MMNL started with pid=16, OS id=5924
            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 Aug 16 16:02:26 2012
            Create controlfile reuse set database "XE"
            MAXINSTANCES 8
            MAXLOGHISTORY 1
            MAXLOGFILES 16
            MAXLOGMEMBERS 3
            MAXDATAFILES 100
            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'
            LOGFILE
            GROUP 1 SIZE 51200K,
            GROUP 2 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 release
            Successful mount of redo thread 1, with mount id 2672635474
            Completed: Create controlfile reuse set database "XE"
            MAXINSTANCES 8
            MAXLOGHISTORY 1
            MAXLOGFILES 16
            MAXLOGMEMBERS 3
            MAXDATAFILES 100
            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'
            LOGFILE
            GROUP 1 SIZE 51200K,
            GROUP 2 SIZE 51200K,
            RESETLOGS
            Stopping background process MMNL
            Stopping background process MMON
            Starting background process MMON
            Thu Aug 16 16:02:29 2012
            MMON started with pid=15, OS id=5732
            Starting background process MMNL
            Thu Aug 16 16:02:29 2012
            MMNL started with pid=16, OS id=5704
            ALTER SYSTEM enable restricted session;
            alter database "XE" open resetlogs
            RESETLOGS after incomplete recovery UNTIL CHANGE 354593
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 1 of thread 1
            Clearing online redo logfile 1 C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_%U_.LOG
            Clearing online log 1 of thread 1 sequence number 0
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 1 of thread 1
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 1 of thread 1
            Clearing online redo logfile 1 complete
            Thu Aug 16 16:02:32 2012
            Checker run found 1 new persistent data failures
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 2 of thread 1
            Clearing online redo logfile 2 C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_%U_.LOG
            Clearing online log 2 of thread 1 sequence number 0
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 2 of thread 1
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 2 of thread 1
            Thu Aug 16 16:02:32 2012
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_m000_1808.trc:
            ORA-01155: the database is being opened, closed, mounted or dismounted
            Clearing online redo logfile 2 complete
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 3 of thread 1
            Clearing online redo logfile 3 C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_0_%U_.LOG
            Clearing online log 3 of thread 1 sequence number 0
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 3 of thread 1
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_5312.trc:
            ORA-00313: open failed for members of log group 3 of thread 1
            Clearing online redo logfile 3 complete
            Online log C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_82TNGPV9_.LOG: Thread 1 Group 1 was previously cleared
            Online log C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_82TNGRDB_.LOG: Thread 1 Group 2 was previously cleared
            Online log C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_82TNGSP9_.LOG: Thread 1 Group 3 was previously cleared
            Setting recovery target incarnation to 2
            Thu Aug 16 16:02:37 2012
            Assigning activation ID 2672635474 (0x9f4d2e52)
            Thread 1 opened at log sequence 1
            Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_82TNGPV9_.LOG
            Successful open of redo thread 1
            Thu Aug 16 16:02:37 2012
            SMON: enabling cache recovery
            Thu Aug 16 16:02:41 2012
            [5312] Successfully onlined Undo Tablespace 2.
            Undo initialization finished serial:0 start:2306864 end:2307738 diff:874 (8 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
            *********************************************************************
            Updating character set in controlfile to AL32UTF8
            Create Relation IPS_PACKAGE_UNPACK_HISTORY
            Opening with Resource Manager plan: INTERNAL_PLAN_XE
            Thu Aug 16 16:02:44 2012
            Starting background process VKRM
            Thu Aug 16 16:02:44 2012
            VKRM started with pid=23, OS id=2684
            **********************************************************
            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
            Thu Aug 16 16:02:47 2012
            QMNC started with pid=24, OS id=3676
            LOGSTDBY: Validating controlfile with logical metadata
            LOGSTDBY: Validation complete
            Global Name changed to XE
            Thu Aug 16 16:02:51 2012
            Starting background process CJQ0
            Thu Aug 16 16:02:51 2012
            CJQ0 started with pid=25, OS id=2536
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
            Thu Aug 16 16:02:57 2012
            Completed: alter database "XE" open resetlogs
            alter database rename global_name to "XE"
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Completed: alter database rename global_name to "XE"
            Thu Aug 16 16:02:57 2012
            Thread 1 advanced to log sequence 2 (LGWR switch)
            Current log# 2 seq# 2 mem# 0: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_82TNGRDB_.LOG
            alter database drop logfile group 3
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Deleted Oracle managed file C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_82TNGSP9_.LOG
            Completed: alter database drop logfile group 3
            ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
            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. !
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            ALTER SYSTEM disable restricted session;
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Thu Aug 16 16:03:02 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. !
            Thu Aug 16 16:03:02 2012
            Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_j003_5264.trc:
            ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
            ORA-06550: line 1, column 807:
            PLS-00201: identifier 'DBSNMP.BSLN_INTERNAL' must be declared
            ORA-06550: line 1, column 807:
            PL/SQL: Statement ignored
            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. !
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Thu Aug 16 16:03:11 2012
            db_recovery_file_dest_size of 10240 MB is 0.98% 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.
            Thu Aug 16 16:03:14 2012
            XDB installed.
            Thu Aug 16 16:03:15 2012
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            XDB initialized.
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Thu Aug 16 16:03:25 2012
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Thu Aug 16 16:03:28 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 = 6
            All dispatchers and shared servers shutdown
            ALTER DATABASE CLOSE NORMAL
            Thu Aug 16 16:03:31 2012
            SMON: disabling tx recovery
            SMON: disabling cache recovery
            Thu Aug 16 16:03:31 2012
            Shutting down archive processes
            Archiving is disabled
            Archive process shutdown avoided: 0 active
            Thread 1 closed at log sequence 2
            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
            Thu Aug 16 16:03:32 2012
            Stopping background process VKTM
            Thu Aug 16 16:03:35 2012
            Instance shutdown complete
            Thu Aug 16 16:03:37 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 Aug 16 16:03:48 2012
            PMON started with pid=2, OS id=5692
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
            Thu Aug 16 16:03:48 2012
            PSP0 started with pid=3, OS id=5744
            Thu Aug 16 16:03:48 2012
            VKTM started with pid=4, OS id=5576 at elevated priority
            VKTM running at (10)millisec precision with DBRM quantum (100)ms
            Thu Aug 16 16:03:48 2012
            GEN0 started with pid=5, OS id=4756
            Thu Aug 16 16:03:48 2012
            DIAG started with pid=6, OS id=1020
            Thu Aug 16 16:03:48 2012
            DBRM started with pid=7, OS id=5300
            Thu Aug 16 16:03:48 2012
            DIA0 started with pid=8, OS id=5864
            Thu Aug 16 16:03:48 2012
            MMAN started with pid=9, OS id=5636
            Thu Aug 16 16:03:48 2012
            DBW0 started with pid=10, OS id=3564
            Thu Aug 16 16:03:48 2012
            LGWR started with pid=11, OS id=5840
            Thu Aug 16 16:03:48 2012
            CKPT started with pid=12, OS id=5996
            Thu Aug 16 16:03:48 2012
            SMON started with pid=13, OS id=5280
            Thu Aug 16 16:03:48 2012
            RECO started with pid=14, OS id=5512
            Thu Aug 16 16:03:48 2012
            MMON started with pid=15, OS id=3684
            Thu Aug 16 16:03:48 2012
            MMNL started with pid=16, OS id=5104
            Thu Aug 16 16:03:48 2012
            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 Aug 16 16:03:48 2012
            ALTER DATABASE MOUNT
            Changing di2dbun from to XE
            Successful mount of redo thread 1, with mount id 2672626596
            Database mounted in Exclusive Mode
            Lost write protection disabled
            Completed: ALTER DATABASE MOUNT
            Thu Aug 16 16:03:53 2012
            ALTER DATABASE OPEN
            Thread 1 opened at log sequence 2
            Current log# 2 seq# 2 mem# 0: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_82TNGRDB_.LOG
            Successful open of redo thread 1
            SMON: enabling cache recovery
            [5776] Successfully onlined Undo Tablespace 2.
            Undo initialization finished serial:0 start:2384085 end:2384865 diff:780 (7 seconds)
            Verifying file header compatibility for 11g tablespace encryption..
            Verifying 11g file header compatibility for tablespace encryption completed
            Thu Aug 16 16:03:59 2012
            SMON: enabling tx recovery
            Database Characterset is AL32UTF8
            Opening with Resource Manager plan: INTERNAL_PLAN_XE
            Thu Aug 16 16:04:00 2012
            Starting background process VKRM
            Thu Aug 16 16:04:00 2012
            VKRM started with pid=22, OS id=5816
            replication_dependency_tracking turned off (no async multimaster replication found)
            Starting background process QMNC
            Thu Aug 16 16:04:03 2012
            QMNC started with pid=24, OS id=4092
            Thu Aug 16 16:04:06 2012
            Completed: ALTER DATABASE OPEN
            Thu Aug 16 16:04:14 2012
            Starting background process CJQ0
            Thu Aug 16 16:04:14 2012
            CJQ0 started with pid=33, OS id=4932
            Thu Aug 16 16:04:17 2012
            db_recovery_file_dest_size of 10240 MB is 0.98% 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.
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
            Thu Aug 16 16:04:25 2012
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified


            ......


            Fri Oct 19 15:43:25 2012
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            Fri Oct 19 15:43:28 2012

            ***********************************************************************
            Fatal NI connect error 12638, connecting to:
            (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
            VERSION INFORMATION:
            TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
            Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production
            Time: 19-OCT-2012 15:43:28
            Tracing not turned on.
            Tns error struct:
            ns main err code: 12638

            TNS-12638: Credential retrieval failed
            ns secondary err code: 0
            nt main err code: 0
            nt secondary err code: 0
            nt OS err code: 0
            OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
            O/S-Error: (OS 1) Incorrect function. !
            • 3. Re: OracleServiceXE Won't Start After Active Directory Install
              clcarter
              OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
              O/S-Error: (OS 1) Incorrect function. !
              Very unusual error there, something not right with the memory setup. Was there a change in the physical memory? Have never had the pleasure of installing AD (or aborting an install, either) not sure what AD does with the host. But if its anything like a PDC the only thing you want do with an AD server is ... make sure it stays up. And healthy.

              Also, the tns-12638 is quite unusual as well. Might be helpful to check local users and make sure ORA_DBA group is still in the local users (via Start/run/lusrmgr.msc) maybe AD may has done some rude things with your OS users.
              how to shut down
              Follow the deinstall steps, and run the installer again. A sqlplus sysdba connection is required to do a shutdown. Leave the ...serviceXE running, or you'll get the TNS:protocol error. Open a command box and:

              sqlplus /nolog
              conn /as sysdba;
              ... Connected ...
              shutdown immediate;
              ... Database closed.
              exit

              Copy in the new files, and back to sqlplus:

              sqlplus /nolog
              conn /as sysdba;
              startup mount;
              ... should be OK query a couple view that is available in mount mode ...
              select name from v$datafile;
              ... should be 4 or more ...
              alter database open resetlogs;
              ... database opened ...
              • 4. Re: OracleServiceXE Won't Start After Active Directory Install
                orafad
                clcarter wrote:
                OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                O/S-Error: (OS 1) Incorrect function. !
                Very unusual error there,
                Not very unusual if running on win x64.
                • 5. Re: OracleServiceXE Won't Start After Active Directory Install
                  clcarter
                  Not very unusual if running on win x64.
                  Ahh thanks for the info. Windoze is not my OS of choice ;)
                  • 6. Re: OracleServiceXE Won't Start After Active Directory Install
                    JL09
                    clcarter,

                    Many thanks for your help thus far. I think we're getting close!

                    I first noticed there was no ORA_DBA user. I created one. This allowed me to start the serviceXE however I could not connect to http://127.0.0.1:8080/apex/f?p=4950 so I proceeded with your further suggestions.

                    These are the steps I performed:

                    1. Command prompt
                    2. sqlplus /nolog
                    3. conn /as sysdba;
                    4. shutdown immediate;
                    5. exit
                    6. copied the entire 'C:\oraclexe\app\oracle\oradata\XE' to a safe location
                    7. uninstalled Oracle
                    8. reinstalled Oracle

                    Note: I could connect to http://127.0.0.1:8080/apex/f?p=4950 at this point

                    9. Command prompt
                    10. sqlplus /nolog
                    11. conn /as sysdba;
                    12. shutdown immediate;
                    13. copied in new files

                    14. C:\Users\Administrator.DISMART>sqlplus /nolog
                    SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 31 23:17:20 2012
                    Copyright (c) 1982, 2010, Oracle. All rights reserved.
                    15. SQL> connect /as sysdba;
                    Connected to an idle instance.
                    16. SQL> startup mount;
                    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
                    Database mounted.
                    17. SQL> select name from v$datafile;

                    NAME
                    -------------------------------------------------------------------------------

                    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

                    16. SQL> alter database open resetlogs;
                    alter database open resetlogs
                    *
                    ERROR at line 1:
                    ORA-01139: RESETLOGS option only valid after an incomplete database recovery

                    I cannot connect to http://127.0.0.1:8080/apex/f?p=4950 at this point*

                    Here is a new alert_xe.log

                    (next post)

                    Again, I (and my client) appreciate your help on this.
                    • 7. Re: OracleServiceXE Won't Start After Active Directory Install
                      JL09
                      Wed Oct 31 23:08:30 2012
                      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 =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 client-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\CONFIG\SCRIPTS\INIT.ORA on machine DISMART
                      System parameters with non-default values:
                      sessions = 172
                      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"
                      Wed Oct 31 23:08:40 2012
                      PMON started with pid=2, OS id=4416
                      OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                      Wed Oct 31 23:08:40 2012
                      PSP0 started with pid=3, OS id=4424
                      Wed Oct 31 23:08:40 2012
                      VKTM started with pid=4, OS id=4996 at elevated priority
                      VKTM running at (10)millisec precision with DBRM quantum (100)ms
                      Wed Oct 31 23:08:40 2012
                      GEN0 started with pid=5, OS id=1280
                      Wed Oct 31 23:08:40 2012
                      DIAG started with pid=6, OS id=3760
                      Wed Oct 31 23:08:40 2012
                      DBRM started with pid=7, OS id=3896
                      Wed Oct 31 23:08:40 2012
                      DIA0 started with pid=8, OS id=768
                      Wed Oct 31 23:08:40 2012
                      MMAN started with pid=9, OS id=3132
                      Wed Oct 31 23:08:40 2012
                      DBW0 started with pid=10, OS id=4380
                      Wed Oct 31 23:08:40 2012
                      LGWR started with pid=11, OS id=4092
                      Wed Oct 31 23:08:40 2012
                      CKPT started with pid=12, OS id=3208
                      Wed Oct 31 23:08:40 2012
                      SMON started with pid=13, OS id=4480
                      Wed Oct 31 23:08:40 2012
                      RECO started with pid=14, OS id=3732
                      Wed Oct 31 23:08:40 2012
                      MMON started with pid=15, OS id=4152
                      Wed Oct 31 23:08:40 2012
                      MMNL started with pid=16, OS id=3360
                      Wed Oct 31 23:08:40 2012
                      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
                      Wed Oct 31 23:08:40 2012
                      kcbztek_populate_tbskey: db key in controlfile and datafile 1 is inconsistent..
                      Full restore complete of datafile 3 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF. Elapsed time: 0:00:04
                      checkpoint is 354593
                      Wed Oct 31 23:08:51 2012
                      Full restore complete of datafile 4 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF. Elapsed time: 0:00:11
                      checkpoint is 354593
                      Wed Oct 31 23:09:15 2012
                      Full restore complete of datafile 1 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF. Elapsed time: 0:00:35
                      checkpoint is 354593
                      Wed Oct 31 23:09:31 2012
                      Full restore complete of datafile 2 to datafile copy C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF. Elapsed time: 0:00:51
                      checkpoint is 354593
                      Wed Oct 31 23:09:32 2012
                      Create controlfile reuse set database "XE"
                      MAXINSTANCES 8
                      MAXLOGHISTORY 1
                      MAXLOGFILES 16
                      MAXLOGMEMBERS 3
                      MAXDATAFILES 100
                      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'
                      LOGFILE
                      GROUP 1 SIZE 51200K,
                      GROUP 2 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 release
                      Wed Oct 31 23:09:33 2012
                      Successful mount of redo thread 1, with mount id 2679262956
                      Completed: Create controlfile reuse set database "XE"
                      MAXINSTANCES 8
                      MAXLOGHISTORY 1
                      MAXLOGFILES 16
                      MAXLOGMEMBERS 3
                      MAXDATAFILES 100
                      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'
                      LOGFILE
                      GROUP 1 SIZE 51200K,
                      GROUP 2 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
                      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
                      ARCH: Archival disabled due to shutdown: 1089
                      Shutting down archive processes
                      Archiving is disabled
                      Wed Oct 31 23:09:36 2012
                      Stopping background process VKTM
                      Wed Oct 31 23:09:38 2012
                      Instance shutdown complete
                      Wed Oct 31 23:09:41 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 client-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\CONFIG\SCRIPTS\INITXETEMP.ORA on machine DISMART
                      System parameters with non-default values:
                      sessions = 172
                      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
                      audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
                      db_name = "XE"
                      open_cursors = 300
                      diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
                      Wed Oct 31 23:09:49 2012
                      PMON started with pid=2, OS id=4072
                      OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                      Wed Oct 31 23:09:49 2012
                      PSP0 started with pid=3, OS id=2508
                      Wed Oct 31 23:09:49 2012
                      VKTM started with pid=4, OS id=4068 at elevated priority
                      VKTM running at (10)millisec precision with DBRM quantum (100)ms
                      Wed Oct 31 23:09:49 2012
                      GEN0 started with pid=5, OS id=760
                      Wed Oct 31 23:09:49 2012
                      DIAG started with pid=6, OS id=4400
                      Wed Oct 31 23:09:49 2012
                      DBRM started with pid=7, OS id=4680
                      Wed Oct 31 23:09:49 2012
                      DIA0 started with pid=8, OS id=4592
                      Wed Oct 31 23:09:49 2012
                      MMAN started with pid=9, OS id=4856
                      Wed Oct 31 23:09:49 2012
                      DBW0 started with pid=10, OS id=3524
                      Wed Oct 31 23:09:49 2012
                      LGWR started with pid=11, OS id=4600
                      Wed Oct 31 23:09:49 2012
                      CKPT started with pid=12, OS id=5108
                      Wed Oct 31 23:09:49 2012
                      SMON started with pid=13, OS id=3516
                      Wed Oct 31 23:09:49 2012
                      RECO started with pid=14, OS id=1968
                      Wed Oct 31 23:09:49 2012
                      MMON started with pid=15, OS id=4564
                      Wed Oct 31 23:09:49 2012
                      MMNL started with pid=16, OS id=1120
                      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
                      Wed Oct 31 23:09:49 2012
                      Create controlfile reuse set database "XE"
                      MAXINSTANCES 8
                      MAXLOGHISTORY 1
                      MAXLOGFILES 16
                      MAXLOGMEMBERS 3
                      MAXDATAFILES 100
                      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'
                      LOGFILE
                      GROUP 1 SIZE 51200K,
                      GROUP 2 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 release
                      Successful mount of redo thread 1, with mount id 2679274749
                      Completed: Create controlfile reuse set database "XE"
                      MAXINSTANCES 8
                      MAXLOGHISTORY 1
                      MAXLOGFILES 16
                      MAXLOGMEMBERS 3
                      MAXDATAFILES 100
                      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'
                      LOGFILE
                      GROUP 1 SIZE 51200K,
                      GROUP 2 SIZE 51200K,
                      RESETLOGS
                      Stopping background process MMNL
                      Stopping background process MMON
                      Starting background process MMON
                      Wed Oct 31 23:09:52 2012
                      MMON started with pid=15, OS id=4412
                      Starting background process MMNL
                      Wed Oct 31 23:09:52 2012
                      MMNL started with pid=16, OS id=2308
                      ALTER SYSTEM enable restricted session;
                      alter database "XE" open resetlogs
                      RESETLOGS after incomplete recovery UNTIL CHANGE 354593
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 1 of thread 1
                      Clearing online redo logfile 1 C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_%U_.LOG
                      Clearing online log 1 of thread 1 sequence number 0
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 1 of thread 1
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 1 of thread 1
                      Wed Oct 31 23:09:54 2012
                      Checker run found 1 new persistent data failures
                      Clearing online redo logfile 1 complete
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 2 of thread 1
                      Clearing online redo logfile 2 C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_%U_.LOG
                      Clearing online log 2 of thread 1 sequence number 0
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 2 of thread 1
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 2 of thread 1
                      Wed Oct 31 23:09:55 2012
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_m000_420.trc:
                      ORA-01155: the database is being opened, closed, mounted or dismounted
                      Clearing online redo logfile 2 complete
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 3 of thread 1
                      Clearing online redo logfile 3 C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_0_%U_.LOG
                      Clearing online log 3 of thread 1 sequence number 0
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 3 of thread 1
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_4792.trc:
                      ORA-00313: open failed for members of log group 3 of thread 1
                      Clearing online redo logfile 3 complete
                      Online log C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_893T016L_.LOG: Thread 1 Group 1 was previously cleared
                      Online log C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_893T02W4_.LOG: Thread 1 Group 2 was previously cleared
                      Online log C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_893T048S_.LOG: Thread 1 Group 3 was previously cleared
                      Setting recovery target incarnation to 2
                      Wed Oct 31 23:09:59 2012
                      Assigning activation ID 2679274749 (0x9fb27cfd)
                      Thread 1 opened at log sequence 1
                      Current log# 1 seq# 1 mem# 0: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_893T016L_.LOG
                      Successful open of redo thread 1
                      Wed Oct 31 23:10:00 2012
                      SMON: enabling cache recovery
                      Wed Oct 31 23:10:03 2012
                      [4792] Successfully onlined Undo Tablespace 2.
                      Undo initialization finished serial:0 start:180639548 end:180640234 diff:686 (6 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
                      *********************************************************************
                      Updating character set in controlfile to AL32UTF8
                      Create Relation IPS_PACKAGE_UNPACK_HISTORY
                      Opening with Resource Manager plan: INTERNAL_PLAN_XE
                      Wed Oct 31 23:10:05 2012
                      Starting background process VKRM
                      Wed Oct 31 23:10:05 2012
                      VKRM started with pid=23, OS id=4644
                      **********************************************************
                      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 Oct 31 23:10:09 2012
                      QMNC started with pid=24, OS id=4872
                      LOGSTDBY: Validating controlfile with logical metadata
                      LOGSTDBY: Validation complete
                      Global Name changed to XE
                      Wed Oct 31 23:10:12 2012
                      Starting background process CJQ0
                      Wed Oct 31 23:10:12 2012
                      CJQ0 started with pid=25, OS id=4628
                      Wed Oct 31 23:10:14 2012
                      Completed: alter database "XE" open resetlogs
                      alter database rename global_name to "XE"
                      Completed: alter database rename global_name to "XE"
                      Wed Oct 31 23:10:14 2012
                      Thread 1 advanced to log sequence 2 (LGWR switch)
                      Current log# 2 seq# 2 mem# 0: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_893T02W4_.LOG
                      alter database drop logfile group 3
                      Deleted Oracle managed file C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_893T048S_.LOG
                      Completed: alter database drop logfile group 3
                      ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
                      Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
                      OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                      ALTER SYSTEM disable restricted session;
                      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. !
                      Wed Oct 31 23:10:19 2012
                      Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_j003_4920.trc:
                      ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
                      ORA-06550: line 1, column 807:
                      PLS-00201: identifier 'DBSNMP.BSLN_INTERNAL' must be declared
                      ORA-06550: line 1, column 807:
                      PL/SQL: Statement ignored
                      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. !
                      Wed Oct 31 23:10:23 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. !
                      Wed Oct 31 23:10:28 2012
                      db_recovery_file_dest_size of 10240 MB is 0.98% 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 Oct 31 23:10:31 2012
                      XDB installed.
                      XDB initialized.
                      Wed Oct 31 23:10:33 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. !
                      Wed Oct 31 23:10:43 2012
                      OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                      O/S-Error: (OS 1) Incorrect function. !
                      Wed Oct 31 23:10:45 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 = 6
                      All dispatchers and shared servers shutdown
                      ALTER DATABASE CLOSE NORMAL
                      Wed Oct 31 23:10:48 2012
                      SMON: disabling tx recovery
                      SMON: disabling cache recovery
                      Wed Oct 31 23:10:49 2012
                      Shutting down archive processes
                      Archiving is disabled
                      Archive process shutdown avoided: 0 active
                      Thread 1 closed at log sequence 2
                      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
                      Wed Oct 31 23:10:50 2012
                      Stopping background process VKTM
                      Wed Oct 31 23:10:52 2012
                      Instance shutdown complete
                      Wed Oct 31 23:10:54 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"
                      • 8. Re: OracleServiceXE Won't Start After Active Directory Install
                        JL09
                        Wed Oct 31 23:11:02 2012
                        PMON started with pid=2, OS id=4572
                        OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                        Wed Oct 31 23:11:02 2012
                        PSP0 started with pid=3, OS id=4492
                        Wed Oct 31 23:11:02 2012
                        VKTM started with pid=4, OS id=2232 at elevated priority
                        VKTM running at (10)millisec precision with DBRM quantum (100)ms
                        Wed Oct 31 23:11:02 2012
                        GEN0 started with pid=5, OS id=4824
                        Wed Oct 31 23:11:02 2012
                        DIAG started with pid=6, OS id=3272
                        Wed Oct 31 23:11:02 2012
                        DBRM started with pid=7, OS id=1444
                        Wed Oct 31 23:11:02 2012
                        DIA0 started with pid=8, OS id=3788
                        Wed Oct 31 23:11:02 2012
                        MMAN started with pid=9, OS id=3580
                        Wed Oct 31 23:11:02 2012
                        DBW0 started with pid=10, OS id=4932
                        Wed Oct 31 23:11:02 2012
                        LGWR started with pid=11, OS id=4188
                        Wed Oct 31 23:11:02 2012
                        CKPT started with pid=12, OS id=3436
                        Wed Oct 31 23:11:02 2012
                        SMON started with pid=13, OS id=2800
                        Wed Oct 31 23:11:03 2012
                        RECO started with pid=14, OS id=3572
                        Wed Oct 31 23:11:03 2012
                        MMON started with pid=15, OS id=4472
                        Wed Oct 31 23:11:03 2012
                        MMNL started with pid=16, OS id=1656
                        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
                        Wed Oct 31 23:11:03 2012
                        ALTER DATABASE MOUNT
                        Changing di2dbun from to XE
                        Successful mount of redo thread 1, with mount id 2679282503
                        Database mounted in Exclusive Mode
                        Lost write protection disabled
                        Completed: ALTER DATABASE MOUNT
                        Wed Oct 31 23:11:08 2012
                        ALTER DATABASE OPEN
                        Thread 1 opened at log sequence 2
                        Current log# 2 seq# 2 mem# 0: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_893T02W4_.LOG
                        Successful open of redo thread 1
                        SMON: enabling cache recovery
                        [2004] Successfully onlined Undo Tablespace 2.
                        Undo initialization finished serial:0 start:180708734 end:180709623 diff:889 (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
                        Wed Oct 31 23:11:14 2012
                        Starting background process VKRM
                        Wed Oct 31 23:11:14 2012
                        VKRM started with pid=23, OS id=5024
                        replication_dependency_tracking turned off (no async multimaster replication found)
                        Starting background process QMNC
                        Wed Oct 31 23:11:16 2012
                        QMNC started with pid=24, OS id=4660
                        Wed Oct 31 23:11:19 2012
                        Completed: ALTER DATABASE OPEN
                        Wed Oct 31 23:11:26 2012
                        Starting background process CJQ0
                        Wed Oct 31 23:11:26 2012
                        CJQ0 started with pid=29, OS id=3208
                        Wed Oct 31 23:11:29 2012
                        db_recovery_file_dest_size of 10240 MB is 0.98% 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.
                        OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                        Wed Oct 31 23:11:37 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. !
                        Wed Oct 31 23:11: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. !
                        Wed Oct 31 23:11: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. !
                        Wed Oct 31 23:12:07 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. !
                        Wed Oct 31 23:12:17 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. !
                        Wed Oct 31 23:12:27 2012
                        OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                        O/S-Error: (OS 1) Incorrect function. !
                        Wed Oct 31 23:12:31 2012
                        XDB installed.
                        OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                        O/S-Error: (OS 1) Incorrect function. !
                        XDB initialized.
                        Wed Oct 31 23:12:37 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. !
                        Wed Oct 31 23:12:45 2012
                        Shared IO Pool defaulting to 104MB. Trying to get it from Buffer Cache for process 3372.
                        Wed Oct 31 23:12: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. !
                        Wed Oct 31 23:12: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. !
                        Wed Oct 31 23:13:07 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. !
                        Wed Oct 31 23:13:17 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. !
                        Wed Oct 31 23:13:27 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. !
                        Wed Oct 31 23:13:37 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. !
                        Wed Oct 31 23:13: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. !
                        Wed Oct 31 23:13: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. !
                        Wed Oct 31 23:14:07 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. !
                        Wed Oct 31 23:14:17 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. !
                        Wed Oct 31 23:14:27 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. !
                        Wed Oct 31 23:14:37 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. !
                        Wed Oct 31 23:14: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. !
                        Wed Oct 31 23:14: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. !
                        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. !
                        Wed Oct 31 23:15:07 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. !
                        Wed Oct 31 23:15:17 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. !
                        Wed Oct 31 23:15:27 2012
                        OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
                        O/S-Error: (OS 1) Incorrect function. !
                        Wed Oct 31 23:15:32 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 = 9
                        All dispatchers and shared servers shutdown
                        ALTER DATABASE CLOSE NORMAL
                        Wed Oct 31 23:15:35 2012
                        SMON: disabling tx recovery
                        SMON: disabling cache recovery
                        Wed Oct 31 23:15:36 2012
                        Shutting down archive processes
                        Archiving is disabled
                        Archive process shutdown avoided: 0 active
                        Thread 1 closed at log sequence 2
                        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
                        Wed Oct 31 23:15:37 2012
                        Stopping background process VKTM
                        ARCH: Archival disabled due to shutdown: 1089
                        Shutting down archive processes
                        Archiving is disabled
                        Wed Oct 31 23:15:39 2012
                        Instance shutdown complete
                        Wed Oct 31 23:17:39 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"
                        Wed Oct 31 23:17:48 2012
                        PMON started with pid=2, OS id=4484
                        OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
                        Wed Oct 31 23:17:48 2012
                        PSP0 started with pid=3, OS id=5024
                        Wed Oct 31 23:17:48 2012
                        VKTM started with pid=4, OS id=4572 at elevated priority
                        VKTM running at (10)millisec precision with DBRM quantum (100)ms
                        Wed Oct 31 23:17:48 2012
                        GEN0 started with pid=5, OS id=2232
                        Wed Oct 31 23:17:48 2012
                        DIAG started with pid=6, OS id=4824
                        Wed Oct 31 23:17:48 2012
                        DBRM started with pid=7, OS id=1444
                        Wed Oct 31 23:17:48 2012
                        DIA0 started with pid=8, OS id=4492
                        Wed Oct 31 23:17:48 2012
                        MMAN started with pid=9, OS id=3580
                        Wed Oct 31 23:17:48 2012
                        DBW0 started with pid=10, OS id=4932
                        Wed Oct 31 23:17:48 2012
                        LGWR started with pid=11, OS id=3436
                        Wed Oct 31 23:17:48 2012
                        CKPT started with pid=12, OS id=3572
                        Wed Oct 31 23:17:48 2012
                        SMON started with pid=13, OS id=4188
                        Wed Oct 31 23:17:48 2012
                        RECO started with pid=14, OS id=3788
                        Wed Oct 31 23:17:48 2012
                        MMON started with pid=15, OS id=3272
                        Wed Oct 31 23:17:48 2012
                        MMNL started with pid=16, OS id=2548
                        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
                        Wed Oct 31 23:17:48 2012
                        ALTER DATABASE MOUNT
                        Successful mount of redo thread 1, with mount id 2679260124
                        Database mounted in Exclusive Mode
                        Lost write protection disabled
                        Completed: ALTER DATABASE MOUNT
                        Wed Oct 31 23:18:26 2012
                        alter database open resetlogs
                        ORA-1139 signalled during: alter database open resetlogs...
                        • 9. Re: OracleServiceXE Won't Start After Active Directory Install
                          orafad
                          968294 wrote:
                          I first noticed there was no ORA_DBA user. I created one.
                          You mean ORA_DBA group, not user?
                          This allowed me to start the serviceXE however I could not connect to http://127.0.0.1:8080/apex/f?p=4950 so I proceeded with your further suggestions.
                          How come, when service was able to start, you still decided to reinstall?

                          13. copied in new files
                          What files exactly?

                          From here it looks like you may have forgotten the control file (which is required to open the "previous" database) and possibly spfile.

                          16. SQL> startup mount;
                          16. SQL> alter database open resetlogs;
                          alter database open resetlogs
                          *
                          ERROR at line 1:
                          ORA-01139: RESETLOGS option only valid after an incomplete database recovery

                          I cannot connect to http://127.0.0.1:8080/apex/f?p=4950 at this point*
                          At least the database needs to be open first, before we can expect the "Get started" application to work.
                          • 10. Re: OracleServiceXE Won't Start After Active Directory Install
                            JL09
                            >
                            You mean ORA_DBA group, not user?
                            Correct.

                            How come, when service was able to start, you still decided to reinstall?
                            To try and solve as expeditiously as possible I assume.

                            What files exactly?
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\APEX_1303222700452456.DBF
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEMP.DBF
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
                            C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
                            From here it looks like you may have forgotten the control file (which is required to open the "previous" database) and possibly spfile.
                            At least the database needs to be open first, before we can expect the "Get started" application to work.
                            OK, how can we do that? I feel like we're close. What's next?

                            Thank you for your help.
                            • 11. Re: OracleServiceXE Won't Start After Active Directory Install
                              clcarter
                              how can we do that? I feel like we're close.
                              Yes, if the database startup mount; works the controlfile ought to be OK. In the XE "out of the box" setup controlfile is one of the *dbf files same folder as the datarfiles. To see which one it is, with a system or sysdba connection:

                              show parameter control
                              control_files ... 'c:\oraclexe\...\control.dbf'
                              alter database open;
                              alter system register;

                              The register tells the instance to have a chat with the listener, a command box `lsnrctl status` and `lsnrctl services` should then show the instance has registered with the listener. Also note the Endpoints, you should have the http ... port 8080 one for the Apex web pages.

                              Edited by: clcarter on Nov 1, 2012 10:08 AM
                              add system register stuff
                              • 12. Re: OracleServiceXE Won't Start After Active Directory Install
                                JL09
                                show parameter control
                                C:\Users\Administrator.DISMART>sqlplus /nolog

                                SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 1 10:15:37 2012

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

                                SQL> conn /as sysdba
                                Connected.
                                SQL> show parameter control

                                NAME TYPE VALUE
                                ------------------------------------ ----------- ------------------------------
                                control_file_record_keep_time integer 7
                                control_files string C:\ORACLEXE\APP\ORACLE\ORADATA
                                \XE\CONTROL.DBF
                                control_management_pack_access string NONE
                                SQL> alter database open;
                                alter database open
                                *
                                ERROR at line 1:
                                ORA-01507: database not mounted

                                What next?

                                Please remember I know very little about ORACLE. Try to list steps in 'step-by-step' for this newbie :-)
                                • 13. Re: OracleServiceXE Won't Start After Active Directory Install
                                  clcarter
                                  Something must have changed since the 'startup mount' if it says its not mounted.

                                  Try shutting it down and a regular startup, in sqlplus:

                                  shutdown immediate;
                                  startup;

                                  A startup with no arguments takes the instance from closed (stopped), startup nomount (memory allocation, starts processes), mount (opens controlfile) and then open (open all datafiles and allow database user access).
                                  • 14. Re: OracleServiceXE Won't Start After Active Directory Install
                                    JL09
                                    SQL> shutdown immediate;
                                    ORA-01507: database not mounted


                                    ORACLE instance shut down.
                                    SQL> startup
                                    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
                                    Database mounted.
                                    ORA-03113: end-of-file on communication channel
                                    Process ID: 4880
                                    Session ID: 1 Serial number: 5


                                    SQL> alter database open;
                                    ERROR:
                                    ORA-03114: not connected to ORACLE
                                    1 2 3 Previous Next