Re: Database autostart after reboot (10g issue)

From: Christophe Bonte <chrbonte_at_hotmail.com>
Date: Tue, 11 Jan 2005 15:34:57 +0100
Message-ID: <41e3e492$0$24420$4d4efb8e@news.be.uu.net>

Hi. Thanks for your time fellas

Apparently, it works now like 1 out of 4 times. I don't really understand why. Let me explain what I did.

First of all sqlnet.ora contains
* SQLNET.AUTHENTICATION_SERVICES= (none) * NAMES.DIRECTORY_PATH= (TNSNAMES) Here below is the oradim command that I used to create my instance at first  --> oradim -NEW -SID CYBER10G -SYSPWD oracle -startmode AUTO -pfile %CYBER10G_DATABASE_HOME%\conf\initcyber10g.ora

Here below the logging of oradim.log that I have everytime after a reboot. Database is in nomount mode.
--> D:\oracle10g\bin\oradim.exe -startup -sid cyber10g -usrpwd * -pfile
D:\cyberlabdb10g\conf\initcyber10g.ora -log oradim.log -nocheck 0 Tue Jan 11 09:23:47 2005
ORA-01012: not logged on

First of all, I can't seem to find anything in the documentation (oradim help) about the -usrpwd parameter. Why do I see a * as value for that parameter in the logging? After a while I recreated my instance with the difference that I added the usrpwd parameter with as value 'oracle'.
--> oradim -NEW -SID CYBER10G -SYSPWD oracle -USRPWD oracle -startmode
AUTO -pfile %CYBER10G_DATABASE_HOME%\conf\initcyber10g.ora

It seemed to have worked 2 times out of 6 reboots. When it doesn't work it's again the same thing in oradim.log.

Here below the contents of alert_cyber10g.log when the pc starts up

---

Tue Jan 11 15:26:13 2005
ORACLE V10.1.0.2.0 - Production vsnsta=0 vsnsql=13 vsnxtr=3
Windows 2000 Version V5.0 Service Pack 4

CPU             : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P)    : PH:327M/511M, PG:669M/863M, VA:1953M/2047M
Tue Jan 11 15:26:13 2005

Starting ORACLE instance (normal)
Tue Jan 11 15:26:14 2005
System parameter db_block_buffers enabled without VLM on. LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle10g\RDBMS Autotune of undo retention is turned on. Dynamic strands is set to TRUE
Running with 1 shared and 24 private strand(s). Zero-copy redo is FALSE IMODE=BR
ILAT =24
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0. System parameters with non-default values:

  processes                = 200
  shared_pool_size         = 104857600
  control_files            = D:\CYBERLABDB10G\DATA\CONTROL1.CTL, 
D:\CYBERLABDB10G\DATA\CONTROL2.CTL
  db_block_buffers         = 5000
  db_block_size            = 8192
  db_file_multiblock_read_count= 8
  undo_management          = AUTO
  undo_tablespace          = UNDO_DATA
  remote_login_passwordfile= SHARED
  hash_area_size           = 8388608
  optimizer_features_enable= 8.1.5
  sort_area_size           = 1048576
  db_name                  = cyber10g
  optimizer_mode           = choose

  parallel_threads_per_cpu = 4
  query_rewrite_enabled = true

DBW0 started with pid=4, OS id=1832
SMON started with pid=7, OS id=1848
RECO started with pid=8, OS id=1852
PMON started with pid=2, OS id=1824
MMAN started with pid=3, OS id=1828
LGWR started with pid=5, OS id=1840
CKPT started with pid=6, OS id=1844

---

It stops here after a reboot. It doesn't continue with opening the database. Let me emphasize the fact that I it worked twice after I recreated the instance with the usrpwd parameter. But now it doesn't anymore. I'm confused.

Thanks in advance for further help.

Christophe Received on Tue Jan 11 2005 - 08:34:57 CST