Re: Database autostart after reboot (10g issue)

Christophe Bonte wrote:

> 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

 > optimizer_features_enable= 8.1.5
I'm sorry ... what was the question again?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---