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.
7  6929  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 thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Buddy Ackerman |
last post by:
I need to create a utility to shutdown another running application. I know you can get a Process object and execute the
Exit method but that only works for apps that have a main window, mine does...
|
by: kelvlam |
last post by:
I have written a service that is depending on mysqld. The service
startup just fine, but I would like to have my service *always*
shutdown first before mysqld does. That way I can add some log...
|
by: tbone |
last post by:
In trying to improve the throughput of a classic ASP app I wrote a few
years ago, I added monitoring to the application and session start and
end methods. I'm counting the total number of sessions...
|
by: Benny |
last post by:
I have a ASP.NET webservice and it is configured to run in a web garden with
multiple processes.
Whan a process in the garden is launched, I want the process to create a
background thread. When...
|
by: Peter S. |
last post by:
I currently have created a C# program that automatically updates
an SQL database once everyday. It's an application that I manually
start. I want make it so that if the (Windows 2003) server...
|
by: Jorge Peixoto de Morais Neto |
last post by:
I was reading the code of FFmpeg and it seems that they use malloc
just too much. The problems and dangers of malloc are widely known.
Malloc also has some overhead (although I don't know what is...
|
by: shaileshkumar |
last post by:
iam able to startup & shutdown tomcat server from the bin directory.
But when i have copied the same files on to the desktop,iam unable to do so.
my operating system is xp.
(i have copied...
|
by: theands |
last post by:
Hello everyone
I was wondering if someone can assist me. I just installed a fresh copy of debian etch on a server that was previously running windows. Startup time of the server is roughly an...
|
by: Lynn |
last post by:
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...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
