This discussion is archived
1 2 3 Previous Next 39 Replies Latest reply: Nov 6, 2012 3:31 AM by orafad RSS

OracleServiceXE Won't Start After Active Directory Install

971297 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    >
    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 Expert
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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
    971297 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points