29. december 2005 - 10:33Der er
4 kommentarer og 1 løsning
at slå en Oracle Enterprise ned på en Linus maskine
Jeg har en Oracle udviklings database, der er gået i knæ. Den ligger på en Linux maskine. Kan logge på maskinen som oracle (OS-brugeren), men kan ikke logge på selve oracle (jeg ville lave en "shutdown [immediate] [abort]" efterfulgt af "startup"):
[oracle@si002223 oracle]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.4.0 - Production on Tor Dec 29 09:51:14 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR: ORA-09817: Write to audit file failed. Linux Error: 28: No space left on device ORA-01075: you are currently logged on
Jeg syntes hellere du skal se at få ryddet op på de devices der er løbet tør for plads. Databasen kan ikke køre fordi en af de diske den ligger på ikke har mere plads.
Men ellers har du "kill -9" istedet for en kill. Så slår du basen helt ned....
NAME kill - terminate a process SYNOPSIS kill [ -s signal | -p ] [ -a ] [ -- ] pid ... kill -l [ signal ] DESCRIPTION The command kill sends the specified signal to the specified process or process group. If no signal is specified, the TERM signal is sent. The TERM signal will kill processes which do not catch this signal. For other processes, it may be necessary to use the KILL (9) signal, since this signal cannot be caught. Most modern shells have a builtin kill function, with a usage rather similar to that of the command described here. The `-a' and `-p' options, and the possibility to specify pids by command name is a local extension.
OPTIONS pid... Specify the list of processes that kill should signal. Each pid can be one of five things:
n where n is larger than 0. The process with pid n will be signaled. 0 All processes in the current process group are signaled. -1 All processes with pid larger than 1 will be signaled. -n where n is larger than 1. All processes in process group n are signaled. When an argument of the form `-n' is given, and it is meant to denote a process group, either the signal must be specified first, or the argument must be preceded by a `--' option, otherwise it will be taken as the signal to send. commandname All processes invoked using that name will be signaled. -s signal Specify the signal to send. The signal may be given as a signal name or number. -l Print a list of signal names. These are found in /usr/include/linux/signal.h -a Do not restrict the commandname-to-pid conversion to processes with the same uid as the present process. -p Specify that kill should only print the process id (pid) of the named processes, and not send any signals.
hvilken slags (stor) fil skal jeg lede efter ?, - er det et coredump af en slags ? Maskinen bruges ikke til andet, den er nyinstalleret med Redhat 3 og Oracle Enterprise 9i Lige nu er der heller ikke andre, der bruger maskinen :-)
jeg fjernede et stort databasedump fra disken. Problemet er nok at mit usertablespace er meget stort (men ikke fuldt), men de 10 GB der er afsat til det, var der ikke ledig plads til på disken. Tak for hjælpen
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.