asked on

Oracle not available

While i was install oracle 8i standard edition on windows2000 server the installer asked 2 questions
Global Database Name: and sid: i gived them the name "orcl" after installation, each time i want to log to the sql+ i get 2 errors
1- ORA-01034 : Oracle not Available
2- ORA- 27101 : Shared memory relam does not exist

What can i do ?

fva

Is the instance started? Go to services and check for OracleORCLService (or similar). Should be started.
Also, is the listener started? (unlikely not to, due to the nature of the error, but better to check). The listener is also a service.
How much memory do you have on that machine? Should be above 128 MB.

If all the above are OK, post here the contents of the *.ora files in %oracle_home%\Network\Admin and the string you use to connect.

F.

i020242

Hi,

also check the instance with svrmgr30.

Logon with user that installed Oracle.

Go:
svrmgr30
connect internal
startup

sudhi022299

I guess in 8i its not svrmgr30 but its svrmgrl. So first you need to make sure that the oracleserviceORCL is started and then invoke this tool to manually startup the db.

Bashar

check the value of the init.ora parameter "shared_pool_size".

edvinkv

The problem here is you have not set your ORACLE_SID and ORACLE_HOME
correctly before starting the oracel server.

ORACLE_SID=XXXX
ORACLE_HOME=/opt/oracle

Set these properly before starting the oracle server.

thanks
Edvin.

fadiwilliam

ASKER

the machine i used has 256 mb ram.
i checked the services OracleORCLservice,Oracle OraHome 8tnslistener there are started.
i checked the value of "shared-pool-size" i found it
=31457280
i invoked the svrmgr, i could only connected internally
i found that the ORACLE_SID and ORACLE_HOME =/opt/oracle
are set in the registery files

so what ,...

fva

Try to "post here the contents of the *.ora files in %oracle_home%\Network\Admin and the string you use to connect".

F.

fadiwilliam

ASKER

Here are the files and their contents.
init.ora
#
# Copyright (c) 1991, 2000 by Oracle Corporation
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
#
# NOTE: Parameter values suggested in this file are based on conservative
# estimates for computer memory availability. You should adjust values upward
# for modern machines.
#
###############################################################################

db_name = "ORACLE"

instance_name = ORACLE

service_names = ORACLE

db_files = 1024 # INITIAL
# db_files = 80 # SMALL
# db_files = 400 # MEDIUM
# db_files = 1500 # LARGE

control_files = ("D:\oracle\oradata\ORACLE\control01.ctl", "D:\oracle\oradata\ORACLE\control02.ctl", "D:\oracle\oradata\ORACLE\control03.ctl")

open_cursors = 300
max_enabled_roles = 30
db_file_multiblock_read_count = 8 # INITIAL
# db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
# db_file_multiblock_read_count = 32 # LARGE

db_block_buffers = 2162 # INITIAL
# db_block_buffers = 100 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE

shared_pool_size = 31457280 # INITIAL
# shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE

large_pool_size = 614400
java_pool_size = 20971520

log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800

processes = 150 # INITIAL
# processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200 # LARGE

parallel_max_servers = 5 # SMALL
# parallel_max_servers = 4 x (number of CPUs) # MEDIUM
# parallel_max_servers = 4 x (number of CPUs) # LARGE

log_buffer = 32768 # INITIAL
# log_buffer = 32768 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE

#audit_trail = true # if you want auditing
#timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5M each

# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=D:\oracle\oradata\ORACLE\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )

# If using public rollback segments, define how many
# rollback segments each instance will pick up, using the formula
# # of rollback segments = transactions / transactions_per_rollback_segment
# In this example each instance will grab 40/5 = 8
# transactions = 40
# transactions_per_rollback_segment = 5

# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true

# Edit and uncomment the following line to provide the suffix that will be
# appended to the db_name parameter (separated with a dot) and stored as the
# global database name when a database is created. If your site uses
# Internet Domain names for e-mail, then the part of your e-mail address after
# the '@' is a good candidate for this parameter value.
# db_domain = us.acme.com # global database name is db_name.db_domain

# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true

oracle_trace_collection_name = ""
# define directories to store trace and alert files
background_dump_dest = D:\oracle\admin\ORACLE\bdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = D:\oracle\admin\ORACLE\udump

db_block_size = 8192

remote_login_passwordfile = exclusive

os_authent_prefix = ""

# The following parameters are needed for the Advanced Replication Option
job_queue_processes = 4
job_queue_interval = 10
open_links = 4

distributed_transactions = 500
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"

compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536

LISTENER.ORA
# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = ORACLE)
)
)
Snmp_ro.ora
snmp.visibleservices = (listener, ORACLE.kamena.com)
snmp.shortname.listener = LISTENER
snmp.longname.listener = listener_kamenait.kamena.com
snmp.configfile.listener = D:\oracle\ora81\network\admin\listener.ora
snmp.oraclehome.listener = D:\oracle\ora81
snmp.servicename.listener_kamenait.kamena.com = OracleOraHome81TNSListener
snmp.SID.ORACLE.kamena.com = ORACLE
snmp.oraclehome.ORACLE.kamena.com = d:\oracle\ora81
snmp.address.ORACLE.kamena.com = (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEORACLE)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
snmp.remoteaddress.ORACLE.kamena.com = (DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521)))(CONNECT_DATA=(SID=ORACLE)(SERVER=DEDICATED)))
ifile = D:\oracle\ora81\network\admin\snmp_rw.ora
ifile = D:\oracle\ora81\network\admin\sqlnet.ora

Snmp_rw.ora
snmp.contact.listener = ""
snmp.index.listener = 1
snmp.contact.ORACLE.kamena.com = ""
snmp.index.ORACLE.kamena.com = 2

SQLNET.ORA
# SQLNET.ORA Network Configuration File: D:\oracle\ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = kamena.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

TNSNAMES.ORA
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORACLE)
(PRESENTATION = http://admin)
)
)

ORACLE.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORACLE)
)
)

fva

In a command prompt, run "tnsping oracle".
Does it work? Any messages?

Using SQLPLUSW, try this:

Connect to:
service: ORACLE
user: SYS
password: change_on_install

Does it work? Any messages?

F.

fadiwilliam

ASKER

i tried tnsping oracle,it is worked under dos very quickly and terminated.
i tried to connect using sys i get the same error.
but i tried using internal/oracle it's connected but i get
an experssion "connected to an idle instance" but i couldn't do any command.

fva

Looks like your database cannot be mounted due to some error. Check for errors in %oracle_home%\Admin\Oracle\bdump\orclALRT.log. Maybe the file name is slightly different, but you will figure it.

Other idea:
Use svrmgrl to connect as internal.
run
startup oracle pfile='d:\oracle\admin\oracle\pfile\init.ora';

and check the errors.

F.

ashokskumar

Hi,

You are able to start the instance but not able to mount and open the database. You may check control file names(as specified in init.ora), location, their access permission. The datafiles location and their accessability. You can review through alert.log.

Ashok.

guru_saj

This error has replaced the old ORA-1034 error that indicated the ORACLE_SID was set incorrectly - essentially it can't find a database for the ORACLE_SID you are using to connect.

I suspect that this is due to a problem in your TNSNAMES.ORA file, which you may have configured using the Net8 assistant at installation time. If the name "orcl" isn't defined, or is incorrectly defined, you will get this error message.

Bear in mind :

(a) If you're using UNIX, That the ORACLE_SID is case sensitive on UNIX - do a :

ps -ef|grep smon

This will show a process called ora_smon_NAME where NAME is the SID of your database. If the case specified is incorrect, change it in your environment.

(b)For remote (TCP/listener) connections:

Review the listener.ora currently used to startup the listener and verify the ORACLE_HOME is correct for all listed 8i databases.

If the ORACLE_HOME points to the 8.1.7 software yet the database was created with 8.1.6 or 8.1.5, then this error can occur.

sunrock_in

Try this

on the command prompt

delete alterlog file
svrmgrl
connect internal/oracle
shutdown abort
startup pfile=<the parameter filename>
#if the instance is still in mount stage check the database alter log file and post it here;

Sunrock_in

fadiwilliam

ASKER

hi guru_saj
i reviewed the TNSNAMES.ORA file
i didn't find the name "orcl" in it. here are their contents :

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORACLE)
(PRESENTATION = http://admin)
)
)

ORACLE.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORACLE)
)
)

is the error here.
what changes i have to do to correct the error.

Bashar

change the last entry of the file to:

ORACLE.KAMENA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kamenait)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

This will associate the service "ORACLE" with the database service "orcl" you specified during the installation.

Also check that the ORACLE_SID registry entry is set to "orcl".

Bashar.

ASKER CERTIFIED SOLUTION

fva

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fadiwilliam

ASKER

hi fva i tried all the changes you suggest, but there is no effect.i can't log because of the same error.

fva

I give up. Drop the database and create another one. After all, it's empty.

F.

fadiwilliam

ASKER

i made reinstall for oracle and get the same error
does windows 2000 make problemes with oracle 8i?
the copy i have from oracle support
WINDOWS NT/WINDOWS 2000...

what are your opinions..........

fadiwilliam

ASKER

i arrived to a 50% from the soluation,
without any changes in any files

i can connect to sql+ using internal/oracle and get
"connected to an idle instance", i started the database manually using the command startup then the database started,mounted and opened.
after it's opened manually the database is available

then the problem is the database must be opened manually.
how can i make it start automatically.

note: the serviec ORACLE SERVICE ORACLE started automatically.

sunrock_in

TO start Database automatically

Go START > RUN >regedit

Search for oracleSIDservice

change the variable values to automatic.

Hope it will work

fadiwilliam

ASKER

i didn't find this key oracleSIDservice in regeistry files
can i create it ? where ?

sunrock_in

Hi

If u r using windows 2000 professional the name of the variable will be

ORA_SID_AUTOSTART valid values are TRUE and FALSE for automatic starting and
ORA_SID_SHUTDOWN values are TRUE and FALSE for automatic shutdown.

It will be under Oracle folder with the name of HOMEn i.e usually HOME0. If their is not one with the name u can create a folder with the same name and create variable keys with the same name as above. If u are going to create a new key urself u have to create these additional keys also

ORA_SID_PFILE give the path of ur parameter file.
ORA_SID_SHUTDOWNTYPE valid values are i(for immediate),a(for abort)

ORA_SID_SHUTDOWN_TIMEOUT valid value can be in seconds like 30 ,60 etc.
Hope this will help u .

In case of any syntactic problem pl. post ur problem.

Thanks

fadiwilliam

ASKER

i set the following
ORA_SID_AUTOSTART to TRUE
ORA_SID_SHUTDOWN to TRUE
ORA_SID_PFILE to the path my parameter file.
ORA_SID_SHUTDOWNTYPE to i
ORA_SID_SHUTDOWN_TIMEOUT to 30

but there is no effect.

fadiwilliam

ASKER

can i make a batch file and put it in the startup.
what's the contents of this file to startup the database at the server startup ?

sunrock_in

Hi
There may be something wrong with ur registry
ok here is ur batchfile u can add the parameters to ur autoexec.bat file also

step 1

make a sql file with these parameters for e.g 2ndfile.sql
connect internal/oracle
startup
--------------------------------
step 2

add these parameters to ur autoexec.bat or make a batch file and add to startup

set oracle_sid=<SID>
d:\oracle\ora81\bin\svrmgrl @c:\2ndfile.sql

Thanks

fadiwilliam

ASKER

i get a document from oracle which has a strong relation
to my problem.I'll post it here .please read it and give me your opinion.

From: fmarti@sinfor.fr 24-Nov-99 14:30
Subject: Oracle not available after reboot

RDBMS Version: ORACLE 8.0.4.0.0
Operating System and Version: NT4 SP3
Error Number (if applicable): ORA-01034 : ORACLE NOT AVAILABLE
Product (i.e. SQL*Loader, Import, etc.): Oracle Instance Manager
Product Version: 1.5.0

Oracle not available after reboot

when I reboot my NT server (TMS-SRV), my oracle datase (TMS) is not available and yet all the oracle services are started OracleTNSListener80, OracleServiceTMS, and
OracleStartupTMS) the diffrent files I use are :(you can see the contents below )
c:\orant\database\initTMS.ora
c:\orant\database\strttms.cmd
c:\orant\net80\admin\listener.ora
c:\orant\net80\admin\sqlnet.ora
c:\orant\net80\admin\tnsnames.ora

And yet, when I use a batch with :
set ORACLE_SID=tms
svrmgr30
connect internal/tms
startup
the database is available !!

(using oradim80 -startup doesn't work
using svrmgr30 instead of oradim80 in strttms.cmd doesn't work either)

=> could you tell me why it doesnt automatically work when I reboot my server ??
****************************
strttms.cmd content :
****************************
c:\orant\bin\oradim80.exe -startup -sid tms -usrpwd tms -starttype srvc,inst -pfile c:\orant\database\inittms.ora

****************************
inittms.ora content :
****************************
db_name = TMS
db_files = 1020
control_files = (D:\tms\oracle\Init\ctl1TMS.ora, D:\tms\oracle\Init\ctl2TMS.ora)
db_file_multiblock_read_count = 16
db_block_buffers = 550
shared_pool_size = 9000000
log_checkpoint_interval = 8000
processes = 100
dml_locks = 200
log_buffer = 32768
sequence_cache_entries = 30
sequence_cache_hash_buckets = 23
#audit_trail = true
#timed_statistics = true
background_dump_dest = D:\tms\oracle\Trace
user_dump_dest = D:\tms\oracle\Trace
db_block_size =2048
compatible = 8.0.4.0.0
sort_area_size = 65536
log_checkpoint_timeout = 0
remote_login_passwordfile = shared
max_dump_file_size = 10240

****************************
listner.ora content :
****************************
# C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration
File:C:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = TMS.world))
(ADDRESS = (PROTOCOL = TCP)(Host = TMS-SRV)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = TMS-SRV)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
)

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0

SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = TMS-SRV)
(SID_NAME = TMS) ) )

PASSWORDS_LISTENER= (oracle)

****************************
sqlnet.ora content :
****************************
# C:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration
File:C:\orant\net80\admin\sqlnet.ora
# Generated by Oracle Net8 Assistant

NAME.DEFAULT_ZONE = world
NAMES.DEFAULT_DOMAIN = world
#sqlnet.authentication_services = (NONE)
SQLNET.EXPIRE_TIME = 0
SQLNET.ENCRYPTION_SERVER = requested
SQLNET.ENCRYPTION_CLIENT = requested
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

****************************
tnsnames.ora content :
****************************
# C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration
File:C:\orant\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

tms.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TMS-SRV)(PORT = 1521))
(CONNECT_DATA = (SID = TMS)) )
--------------------------------------------------------------------------------

From: Paul Swart 24-Nov-99 15:05
Subject: Re : Oracle not available after reboot

I have had a similar problem when creating a Oracle 8i instance.
My solution was to change the oradim80 command with the startup parameter in 2 lines:

-- first one --
c:\orant\bin\oradim80.exe -startup -sid tms -usrpwd tms -starttype srvc -pfile c:\orant\database\inittms.ora

-- second one --
c:\orant\bin\oradim80.exe -startup -sid tms -usrpwd tms -starttype inst -pfile c:\orant\database\inittms.ora

-end-

This worked in my case.

I also would like to know where this difference (to 7.x) is coming from.

--------------------------------------------------------------------------------

From: Oracle, Melissa Holman 30-Nov-99 17:58
Subject: Re : Oracle not available after reboot

The OracleStartSID service is what performs the automatic startup and it executes %oracle_home%\database\strtSID.cmd. Typically, there is a problem with the strtSID.cmd file which causes the startup to fail.
It is normal for the OracleStartSID service to show started since the status of this service does not accurately reflect the status of the database.

Use the following document to troubleshoot why your automatic startup is not working correctly.

Troubleshooting Tips: Database Not Autostarting 62006.1

Melissa Holman
Oracle Support

--------------------------------------------------------------------------------

From: Sangeeta Agarwal 12-Sep-00 01:39
Subject: Re : Oracle not available after reboot

I was having the same problem and I recreated the services still it didn't work. In our case, we were putting the archives on another server. If we had the oracle<SID>service to be started as 'system' or login as 'system' user, it was not liking the location of archives. Thus, we had to change it to 'ADministrator'. The oracle<SID>start was still using 'system' to login. Thus changed that too to 'ADministrator' and now it works fine.

Hope it helps those who have similar situation.
From: Oracle, Melissa Holman 13-Sep-00 17:31
Subject: Re : Re : Oracle not available after reboot

Thanks Sangeeta for posting this information. In your case you would have been receiving an error starting your database because the user that the OracleService as logging in as does not have privileges to write to remote drives. Changing your service to logon as administrator would correct that problem.

Melissa Holman
Oracle Support

--------------------------------------------------------------------------------

From: Mike Kolacsky 01-Nov-00 14:46
Subject: Re : Oracle not available after reboot

On NT, if you change the system password after creating the instatnce, the NT service that starts the instance is not updated. The location of the file is orant\database\strt(instance).cmd
--------------------------------------------------------------------------------

From: Oracle, Melissa Holman 01-Nov-00 18:24
Subject: Re : Re : Oracle not available after reboot

Mike,
Yes you are correct that the strtSID.cmd file is not modified when the password is changed. However, the USRPWD value in the strtSID.cmd is not the SYSTEM password, it is the INTERNAL password which is needed for startup.

In Oracle8i, the automatic startup is accomplished without the strtSID.cmd so it isn't a problem anymore.

Melissa Holman
Oracle Support
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.

amp072397