automatic shutdown/startup

Lynn

I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
oracle instances set to automatically startup and shutdown with the
W2K server. Unfortunately, neither is working. Nothing gets logged
in my alert file for the shutdown or startup, however, the databases
are down and when I manually start them up, the alert log reveals a
crash recovery. I've verified the settings in the registry for
automatic shutdown and startup. I've done lots of searching and have
seen where others have had the same problem, but have not found the
solution. Any help would be geatly appreciated.

Jul 19 '05 #1

sybrandb

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...

I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
oracle instances set to automatically startup and shutdown with the
W2K server. Unfortunately, neither is working. Nothing gets logged
in my alert file for the shutdown or startup, however, the databases
are down and when I manually start them up, the alert log reveals a
crash recovery. I've verified the settings in the registry for
automatic shutdown and startup. I've done lots of searching and have
seen where others have had the same problem, but have not found the
solution. Any help would be geatly appreciated.

At this stage the only way to get sensible responses is to post part
of the alert log and the oradim.log in %ORACLE_HOME%\rdbms

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #2

Lynn

Thanks for your reply. On W2K shutdown I get the following entry in
my alert file...
Tue Nov 18 10:28:56 2003
Errors in file d:\oracle\oradata\BNBPT\udump\ORA01120.TRC:
ORA-00600: internal error code, arguments: [12333], [140], [206],
[142], [], [], [], []

I performed a call stack trace search metalink. I found out that
12333 refers to "Fatal Two-Task Protocol Violation" and references
possible NLS issues, but I still haven't been able to determine my
problem. I'm kinda new to this.

Also, my oradim.log entry is as follows...
Tue Nov 18 10:29:04 2003ORA-01041: internal error. hostdef extension
doesn't exist

Any help is greatly appreciated.

sy******@yahoo.com wrote in message news:<a1**************************@posting.google. com>...

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...

I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
oracle instances set to automatically startup and shutdown with the
W2K server. Unfortunately, neither is working. Nothing gets logged
in my alert file for the shutdown or startup, however, the databases
are down and when I manually start them up, the alert log reveals a
crash recovery. I've verified the settings in the registry for
automatic shutdown and startup. I've done lots of searching and have
seen where others have had the same problem, but have not found the
solution. Any help would be geatly appreciated.

At this stage the only way to get sensible responses is to post part
of the alert log and the oradim.log in %ORACLE_HOME%\rdbms

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #3

Lynn

Does the ora_nls33 and NLSRTL33 environment variables need to be set
when running Oracle 8.1.7 on a W2K machine? The ora-600 error refers
to these and mine are not set. However, I've only seen references to
them on NT, not W2K. My nls_lang environment variable is set
correctly.

Thanks,
Lynn
sy******@yahoo.com wrote in message news:<a1**************************@posting.google. com>...

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...

I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
oracle instances set to automatically startup and shutdown with the
W2K server. Unfortunately, neither is working. Nothing gets logged
in my alert file for the shutdown or startup, however, the databases
are down and when I manually start them up, the alert log reveals a
crash recovery. I've verified the settings in the registry for
automatic shutdown and startup. I've done lots of searching and have
seen where others have had the same problem, but have not found the
solution. Any help would be geatly appreciated.

At this stage the only way to get sensible responses is to post part
of the alert log and the oradim.log in %ORACLE_HOME%\rdbms

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #4

Joel Garry

ly*****@cox.net (Lynn) wrote in message news:<cd************************@posting.google.co m>...

Does the ora_nls33 and NLSRTL33 environment variables need to be set
when running Oracle 8.1.7 on a W2K machine? The ora-600 error refers
to these and mine are not set. However, I've only seen references to
them on NT, not W2K. My nls_lang environment variable is set
correctly.
Yes, ora_nls33 needs to be set or you will get a character set
mismatch.

Also see Note:114384.1 and Note:136214.1 on metalink. The solution is
to have a script with oradim for starting up and shutting down, and
don't try to run them automatically. I have one machine where I've
crammed 9iAS and a database on there, and a shutdown abort takes an
hour after a night of memory leaks. Oddly enough, no problem with the
iasdb, just the higher version 9 database.

Also check %ORACLE_HOME%\database for an oradim.log

Thanks,
Lynn
sy******@yahoo.com wrote in message news:<a1**************************@posting.google. com>...

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...

I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
oracle instances set to automatically startup and shutdown with the
W2K server. Unfortunately, neither is working. Nothing gets logged
in my alert file for the shutdown or startup, however, the databases
are down and when I manually start them up, the alert log reveals a
crash recovery. I've verified the settings in the registry for
automatic shutdown and startup. I've done lots of searching and have
seen where others have had the same problem, but have not found the
solution. Any help would be geatly appreciated.

At this stage the only way to get sensible responses is to post part
of the alert log and the oradim.log in %ORACLE_HOME%\rdbms

Sybrand Bakker
Senior Oracle DBA

jg
--
@home.com is bogus.
http://www.theinquirer.net/?article=12727

Jul 19 '05 #5

Lynn

Thanks for your suggestions. I have set the ora_nls33 environment
variable and verified all settings referred to in both Notes mentioned
below. However, the problem still persists. The problem is that I
need the databases to shutdown and startup automatically when the
server is rebooted. Are you saying that this just doesn't work? From
what I've seen it's supposed to work for 8.1.7, but doesn't appear to
all the time. I have startup and shutdown scripts that can be ran,
however, the network admins may need to reboot while I'm not around
and would prefer to not have to run a script. Any suggestions?

Thanks again,
Lynn

jo********@home.com (Joel Garry) wrote in message news:<91**************************@posting.google. com>...

ly*****@cox.net (Lynn) wrote in message news:<cd************************@posting.google.co m>...

Does the ora_nls33 and NLSRTL33 environment variables need to be set
when running Oracle 8.1.7 on a W2K machine? The ora-600 error refers
to these and mine are not set. However, I've only seen references to
them on NT, not W2K. My nls_lang environment variable is set
correctly.

Yes, ora_nls33 needs to be set or you will get a character set
mismatch.

Also see Note:114384.1 and Note:136214.1 on metalink. The solution is
to have a script with oradim for starting up and shutting down, and
don't try to run them automatically. I have one machine where I've
crammed 9iAS and a database on there, and a shutdown abort takes an
hour after a night of memory leaks. Oddly enough, no problem with the
iasdb, just the higher version 9 database.

Also check %ORACLE_HOME%\database for an oradim.log

Thanks,
Lynn
sy******@yahoo.com wrote in message news:<a1**************************@posting.google. com>...

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...
> I'm running Oracle 8.1.7.4.1 on W2K and have the services for my
> oracle instances set to automatically startup and shutdown with the
> W2K server. Unfortunately, neither is working. Nothing gets logged
> in my alert file for the shutdown or startup, however, the databases
> are down and when I manually start them up, the alert log reveals a
> crash recovery. I've verified the settings in the registry for
> automatic shutdown and startup. I've done lots of searching and have
> seen where others have had the same problem, but have not found the
> solution. Any help would be geatly appreciated.

At this stage the only way to get sensible responses is to post part
of the alert log and the oradim.log in %ORACLE_HOME%\rdbms

Sybrand Bakker
Senior Oracle DBA

jg

Jul 19 '05 #6

Joel Garry

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...

Thanks for your suggestions. I have set the ora_nls33 environment
variable and verified all settings referred to in both Notes mentioned
below. However, the problem still persists. The problem is that I
need the databases to shutdown and startup automatically when the
server is rebooted. Are you saying that this just doesn't work? From
what I've seen it's supposed to work for 8.1.7, but doesn't appear to
all the time. I have startup and shutdown scripts that can be ran,
however, the network admins may need to reboot while I'm not around
and would prefer to not have to run a script. Any suggestions?

Open a support call with Oracle. They will direct you to metalink
notes that describe how to startup and shutdown automatically. Lean
on them if the notes are not helpful. Ask about Note: 231495.1 and
bug 1638610.

jg
--
@home.com is bogus.
http://economictimes.indiatimes.com/...ow?msid=288549

Jul 19 '05 #7

Lynn

Thanks Joel. After days of searching I finally found a document on
Metalink that covered the issue I was having. Bug # 1570136 -
Database does not start on NT when using DES/DES40 encryption.
Following guidance from this I was able to resolve my issue.
Everything's working fine now.

Thanks,
Lynn
jo********@home.com (Joel Garry) wrote in message news:<91**************************@posting.google. com>...

ly*****@cox.net (Lynn) wrote in message news:<cd*************************@posting.google.c om>...

Thanks for your suggestions. I have set the ora_nls33 environment
variable and verified all settings referred to in both Notes mentioned
below. However, the problem still persists. The problem is that I
need the databases to shutdown and startup automatically when the
server is rebooted. Are you saying that this just doesn't work? From
what I've seen it's supposed to work for 8.1.7, but doesn't appear to
all the time. I have startup and shutdown scripts that can be ran,
however, the network admins may need to reboot while I'm not around
and would prefer to not have to run a script. Any suggestions?

Open a support call with Oracle. They will direct you to metalink
notes that describe how to startup and shutdown automatically. Lean
on them if the notes are not helpful. Ask about Note: 231495.1 and
bug 1638610.

jg

Jul 19 '05 #8