|
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. | |
Share:
| 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 | | |
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 | | |
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 | | | 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 | | |
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 | | | 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 | | |
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 | | This discussion thread is closed Replies have been disabled for this discussion. Similar topics
9 posts
views
Thread by Buddy Ackerman |
last post: by
|
reply
views
Thread by kelvlam |
last post: by
|
3 posts
views
Thread by tbone |
last post: by
|
5 posts
views
Thread by Benny |
last post: by
|
7 posts
views
Thread by Peter S. |
last post: by
|
58 posts
views
Thread by Jorge Peixoto de Morais Neto |
last post: by
| | |
7 posts
views
Thread by Lynn |
last post: by
| | | | | | | | | | |