Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Oracle Service won't start

    Hi, I'm a total newbie to Oracle. I manage a dozen MS SQL databases, but the Oracle guy just walked out on us and I am now responsible (?!?) for about a half dozen Oracle servers as well.

    We have one server (8.1.6, I think) that fails to start the Oracle database when the server is rebooted. We are using Windows 2000 (SP4).

    There are no error messages in the Windows Event logs (System or Application). The only indication that I have that anything is amiss is when I start the database from the DCA, I get a pop-up message asking me to select the parameter file to load.

    If anyone could shed some light on the subject, I would be grateful.

    Regards,

    hmscott

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Check the registry entries for the database:

    hkey_local_machine\software\oracle\home0...
    Look for the key ora_xxx_autostart (xxx is the database sid)

    This should be set to true ... also in here you will find the key for the pfile
    ora_xxx_pfile ... Ensure that this is the correct location of the parameter file

    ... initxxx.ora (again xxx is the sid)...

    Ensure the OracleServicexxx is set for automatic start ... The first reg key
    tells the database to start automatically when the service (in the above line) is started...

    HTH
    Gregg

    ps... if this isn't it, look for the alertxxx.log (usually in \bdump directory)
    Post the last page or so of it if you need to...

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    First, thanks for the prompt response.

    Here's what I saw:

    1. The reg entry for ora_xxx_autostart is set to 'TRUE' (no quotes)
    2. The reg entry for ora_xxx_pfile is set to \path\init.ora (no SID)
    2a. I verified that the path and file name were valid
    3. The OracleServicexxx is set to auto start.

    I have attached the contents of the alert log around the time that the server was last restarted (manually):

    Code:
    Fri Jun 11 13:49:12 2004
    ORACLE V8.1.7.0.0 - Production vsnsta=0
    vsnsql=e vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Starting up ORACLE RDBMS Version: 8.1.7.0.0.
    System parameters with non-default values:
      processes                = 150
      shared_pool_size         = 52428800
      large_pool_size          = 614400
      java_pool_size           = 20971520
      control_files            = E:\oracle\oradata\[SID]\control03.ctl, E:\oracle\oradata\[SID]\control01.ctl, E:\oracle\oradata\[SID]\control02.ctl
      db_block_buffers         = 19200
      db_block_size            = 8192
      compatible               = 8.1.0
      log_archive_dest_1       = LOCATION=E:\oracle\ora81\RDBMS
      log_buffer               = 32768
      log_checkpoint_interval  = 10000
      log_checkpoint_timeout   = 1800
      db_files                 = 1024
      db_file_multiblock_read_count= 8
      max_enabled_roles        = 30
      remote_login_passwordfile= EXCLUSIVE
      global_names             = TRUE
      distributed_transactions = 500
      instance_name            = [SID]
      service_names            = [SID]
      mts_dispatchers          = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
      open_links               = 4
      sort_area_size           = 65536
      sort_area_retained_size  = 65536
      db_name                  = [SID]
      open_cursors             = 300
      os_authent_prefix        = 
      job_queue_processes      = 4
      job_queue_interval       = 10
      parallel_max_servers     = 5
      background_dump_dest     = E:\oracle\admin\[SID]\bdump
      user_dump_dest           = E:\oracle\admin\[SID]\udump
      max_dump_file_size       = 10240
      oracle_trace_collection_name= 
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    SNP0 started with pid=8
    SNP1 started with pid=9
    SNP2 started with pid=10
    SNP3 started with pid=11
    Fri Jun 11 13:49:16 2004
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    Fri Jun 11 13:49:18 2004
    /* OracleOEM */ ALTER DATABASE MOUNT 
    Fri Jun 11 13:49:25 2004
    Successful mount of redo thread 1, with mount id 869422052.
    Fri Jun 11 13:49:25 2004
    Database mounted in Exclusive Mode.
    Completed: /* OracleOEM */ ALTER DATABASE MOUNT
    Fri Jun 11 13:49:25 2004
    /* OracleOEM */ ALTER DATABASE OPEN  
    Beginning crash recovery of 1 threads
    Fri Jun 11 13:49:26 2004
    Thread recovery: start rolling forward thread 1
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 13004 Reading mem 0
      Mem# 0 errs 0: E:\ORACLE\ORADATA\[SID]\REDO02.LOG
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 13005 Reading mem 0
      Mem# 0 errs 0: E:\ORACLE\ORADATA\[SID]\REDO01.LOG
    Fri Jun 11 13:49:26 2004
    Thread recovery: finish rolling forward thread 1
    Thread recovery: 123 data blocks read, 105 data blocks written, 1813 redo blocks read
    Crash recovery completed successfully
    Fri Jun 11 13:49:27 2004
    Thread 1 advanced to log sequence 13006
    Thread 1 opened at log sequence 13006
      Current log# 1 seq# 13006 mem# 0: E:\ORACLE\ORADATA\[SID]\REDO03.LOG
    Successful open of redo thread 1.
    Fri Jun 11 13:49:27 2004
    SMON: enabling cache recovery
    SMON: enabling tx recovery

  4. #4
    Join Date
    Jun 2004
    Posts
    2
    Quote Originally Posted by hmscott
    Hi, I'm a total newbie to Oracle. I manage a dozen MS SQL databases, but the Oracle guy just walked out on us and I am now responsible (?!?) for about a half dozen Oracle servers as well.

    We have one server (8.1.6, I think) that fails to start the Oracle database when the server is rebooted. We are using Windows 2000 (SP4).

    There are no error messages in the Windows Event logs (System or Application). The only indication that I have that anything is amiss is when I start the database from the DCA, I get a pop-up message asking me to select the parameter file to load.

    If anyone could shed some light on the subject, I would be grateful.

    Regards,

    hmscott
    Try startup each step
    First, startup nomount if not success, initSID.ora has problem.
    Second, startup mount if not success, control files have problem.
    Third, startup open if not success, datafiles have problem.
    Oracle should be show any error.

    Best Regards,
    Demerzel

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    It looks like the database is up and running (from the alertlog)... Check to see if you have an initxxx.ora in the \database directory. It may contain IFILE in it... Ensure that it has the same location as the init.ora you found. I may be wrong, but I see to remember a bug in 8.1.6 dealing with the location of the init file... If you don't find an init.ora in the \database directory, copy the one that you did find. ALSO, copy another version of it and rename it to INITsid.ORA and put it in the \database directory also...

    HTH ... Sorry about missing the post yesterday afternoon

    Gregg

  6. #6
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Quote Originally Posted by hmscott
    Hi, I'm a total newbie to Oracle. I manage a dozen MS SQL databases, but the Oracle guy just walked out on us and I am now responsible (?!?) for about a half dozen Oracle servers as well.

    We have one server (8.1.6, I think) that fails to start the Oracle database when the server is rebooted. We are using Windows 2000 (SP4).

    There are no error messages in the Windows Event logs (System or Application). The only indication that I have that anything is amiss is when I start the database from the DCA, I get a pop-up message asking me to select the parameter file to load.

    If anyone could shed some light on the subject, I would be grateful.

    Regards,

    hmscott

    You can try to recreate the OracleService<SID> with the "-startmode a" parameter included. Delete your old service and re-create it by using the oradim utility:

    c:\> oradim -delete -sid <SID>
    c:\> oradim -delete -srvc OracleService<SID>

    c:\> oradim -new -sid <SID> -startmode a -pfile ............... -intpwd ........


    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

  7. #7
    Join Date
    Jun 2004
    Posts
    1

    Thumbs up Oracle Bug

    OK if your server has Xenon processors you have encountered an Oracle Bug !!!

    The kernel you need for automatic shutdown and startup is 8.1.7.4.1

    Cheers

  8. #8
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    Well, guys.

    I'm having the same problem with oracle 9.2.0.1, recently migrated to 9.2.0.5.
    I tried all that is posted here.
    I've recreated the services dozen of times.
    I've tried disabling windows authentication:
    #SQLNET.AUTHENTICATION_SERVICES = (NTS)
    Tried using windows admin user to start the services, creating ORA_DBA role on the server.

    The only solution I've found is to create a .cmd file that is executed at server startup with the following:
    oradim.exe -startup -sid <sid> -usrpwd <password> -starttype srvc,inst -pfile <path_of_init.ora>

    I though there was a problem with the path of init.ora file in the service, but I've recreated them with the correct path and nothing happends.

    I'm still using pfile instead of spfile, do you advice me to use spfile?
    Is that going to help me someway to solve this start up problem?

    Thanks!!

    Saludos from Argentina!

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    For the heck of it ... I've have a couple of clients that I found lately with problems with their service not starting ... I tracked it down to AUTO updates of Windows ... Patch 835732 was the culpret. Once they removed that patch, everything was ok... Check to see if you have this Microsoft patch loaded...

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •