automatic shutdown/startup

**sybrandb@yahoo.com** · Jun 27 '08, 05:32 PM

Re: automatic shutdown/startup

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311171242.4386d 4cc@posting.goo gle.com>...

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%\r dbms

Sybrand Bakker
Senior Oracle DBA

**Lynn** · Jun 27 '08, 05:32 PM

Re: automatic shutdown/startup

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\orada ta\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.

sybrandb@yahoo. com wrote in message news:<a1d154f4. 0311180039.4725 602b@posting.go ogle.com>...

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311171242.4386d 4cc@posting.goo gle.com>...

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%\r dbms
>
Sybrand Bakker
Senior Oracle DBA

**Lynn** · Jun 27 '08, 05:32 PM

Re: automatic shutdown/startup

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
sybrandb@yahoo. com wrote in message news:<a1d154f4. 0311180039.4725 602b@posting.go ogle.com>...

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311171242.4386d 4cc@posting.goo gle.com>...

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%\r dbms
>
Sybrand Bakker
Senior Oracle DBA

**Joel Garry** · Jun 27 '08, 05:32 PM

Re: automatic shutdown/startup

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311180936.11de2 34@posting.goog le.com>...

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%\d atabase for an oradim.log

>
Thanks,
Lynn
sybrandb@yahoo. com wrote in message news:<a1d154f4. 0311180039.4725 602b@posting.go ogle.com>...

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311171242.4386d 4cc@posting.goo gle.com>...

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%\r dbms

Sybrand Bakker
Senior Oracle DBA

jg
--
@home.com is bogus.

http://www.theinquirer.net/?article=12727

**Lynn** · Jun 27 '08, 05:33 PM

Re: automatic shutdown/startup

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

joel-garry@home.com (Joel Garry) wrote in message news:<91884734. 0311181738.678c b8ce@posting.go ogle.com>...

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311180936.11de2 34@posting.goog le.com>...

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%\d atabase for an oradim.log
>

Thanks,
Lynn
sybrandb@yahoo. com wrote in message news:<a1d154f4. 0311180039.4725 602b@posting.go ogle.com>...

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311171242.4386d 4cc@posting.goo gle.com>...
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%\r dbms
>
Sybrand Bakker
Senior Oracle DBA

>
jg

**Joel Garry** · Jun 27 '08, 05:33 PM

Re: automatic shutdown/startup

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311190836.53336 21d@posting.goo gle.com>...

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/cms.dll/articleshow?msid=288549

**Lynn** · Jun 27 '08, 05:33 PM

Re: automatic shutdown/startup

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
joel-garry@home.com (Joel Garry) wrote in message news:<91884734. 0311201613.49a4 d8e9@posting.go ogle.com>...

lynn344@cox.net (Lynn) wrote in message news:<cd7c2c1.0 311190836.53336 21d@posting.goo gle.com>...

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

automatic shutdown/startup

automatic shutdown/startup

Comment

Comment

Comment

Comment

Comment

Comment

Comment