Hello!

I have looked for the solution for this problem in this newsgroup and
tried every possibility but it doesn't work yet.
I install oracle enterprise edition 8.17 on windows 2000 server. The
machine is pentium 4, 2GHz, 512 MB ram.
I just have one database running on this server. Everytime I reboot
the server and I try to connect to the database I get this error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
If I look at control panel/services, the database oracle service and
the listener service are started.
What I can do to be able to connect to the database is to start
Database configuration assistant, select 'Change database
configuration' option and click on next, next, finish.

This is the init.ora

db_name = sfma
db_block_size = 4096
db_files = 10
control_files = (D:\oracle\ora81\database\ctl1sfma.ora,
D:\oracle\ora81\database\ctl2sfma.ora)
rollback_segments = (rb0, rb1, rb2, rb3)

remote_login_passwordfile = shared
global_names = TRUE

text_enable = FALSE
mts_max_servers = 30

optimizer_mode = RULE


# options for advanced replication

parallel_max_servers = 5 # number of processors of server times 5

job_queue_processes = 2
job_queue_interval = 10

# Distributed_Transactions = 5

# settings for memory management

shared_pool_size = 100M

pre_page_sga = TRUE
java_pool_size = 1M
# large_pool_size = 15000K

sort_area_size = 4000000
sort_area_retained_size = 0

processes = 200

dml_locks = 750

db_file_multiblock_read_count = 16

db_block_buffers = 20000

cursor_space_for_time = TRUE

# settings for log file and for creating dumps

log_checkpoint_interval = 10000
log_buffer = 131072

max_dump_file_size = 10240
background_dump_dest=D:\oracle\ora81\otrace\public
user_dump_dest=D:\oracle\ora81\otrace\public

# settings for tkprof/performance tests (temporary only, please!):

timed_statistics = FALSE # for tkprof
# db_block_lru_statistics = TRUE
# db_block_lru_extended_statistics = 4000 # test for db_block_buffers

# automatic archiving

# log_archive_start = TRUE


Thanks a lot in advance.

I have the same problem on some of my W2K servers: The instance does not
open automatically on reboot. You can connect sys as sysdba and manually
startup the instance after reboot or create a script which opens the
instance. This script can then be associated with a scheduled task which
runs at system startup.
Beware of the script option if you have multiple instances on the server
as it may not always open all the instances.

HTH
Anthony Hogan

linda_68 (AT) hotmail (DOT) com (sien) wrote in message news:<31d3e92a.0306232349.59647171 (AT) posting (DOT) google.com>...
I'd guess that you have not installed the 8i Admin Assistant for
NT/W2K.
If you have, use it to "start the instance when the service is
started".
If you have not, edit the registry key:

HKLM\SOFTWARE\ORACLE\HOME0\ORA_%ORACLE_SID%_AUTOST ART = TRUE.

Also - might you be running the base release 8.1.7.0.0?
There is a known issue in that release that was fixed in 8.1.7.0.2.
If you have a metalink account, you can download the patchset.
I'd recommend using at least the 8.1.7.4.1 patchset, and apply the
8.1.7.4.10 patchset if you can afford time for testing on another
server. Multiple security fixes are included in that patchset, but if
you use cursor_sharing = FORCE, do not apply 8.1.7.4.10.

Btw - you're running in archivelog mode but do not have archiving set
to autostart?

Pd

On Tue, 24 Jun 2003 13:02:48 +0100, Anthony Hogan
<ahogan-nospam- (AT) iespana (DOT) es> wrote:

Is this a solution or just a workaround?
You need to identify *why* your database doesn't start by verifying
oradim.log and the alert log, instead of implementing and -even worse-
recommending this crap workaround, which doesn't *solve* anything!


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Sybrand Bakker wrote:
Point taken. I know why the database doesn't start: it's a bug in
8.1.7.0.0 which (sometimes) manifests itself on W2K servers. The
permanent solution is to apply the patches.
Failing this, the workaround does solve the problem of unscheduled
server reboots not bringing up the instance.

Anthony Hogan

timbedford (AT) hotmail (DOT) com (Tim Bedford) wrote in message news:<a411bafb.0306250615.2362f17b (AT) posting (DOT) google.com>...
Tim,

The patchset 8.1.7.0.2 included a fix for this.
As far as your unclean shutdowns, did you reset the following:

HKLM\SOFTWARE\ORACLE\HOMEn\ORA_%ORACLE_SID%_SHUTDO WN_TIMEOUT = 300
HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillSe rviceTimeout = 300000

Also, just to double-check, make sure that the following entry is set:

HKLM\SOFTWARE\ORACLE\HOMEn\ORA_%ORACLE_SID%_AUTOST ART = TRUE

I have not had a problem with this since 8.1.7.0.2.

hth,

Paul

Thanks for all the answers. I will then upgrade to 8.1.7.4

Have a nice day!!



Sybrand Bakker <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote