Dear All,
i am not able to start the 9i oracle database because of the following problems.
I log in into unix
and then into sqlplus
Code:
export oracle_sid=SATEST
Code:
startup nomount
i am getting the following errors
Code:
ORA-27300: OS system dependent operation:semget failed with status:28
ORA-27154:post/wait create failed
ORA-27301:OS failure message:no space left on device
ORA-27302:failure occured at:sskgpbitsper
please help me on this regard as it of high priority.
Hi All,
I have to make the following changes in shell script:
When the data file is being created, an “ORA” error occurs in it. I have to remove this ORA error from data file and put it in log file.
I am “ -n grip command” to find the ORA error and get the line number,
How do I delete it... (1 Reply)
Hi:
i have writen a script that needs a finishing
Pourpouse is to find a particular error in a file after we enter file name
and the return msg would describe if >there is a error -> "Contact DBA"
if there is no oracle error ->"No ora error found."
for the same i have written a script... (6 Replies)
It is related to Linux, Oracle 9.2.0. I am new to Oracle.
I am trying to connect to Oracle database say A, but as I am running this command dbstart the error is
“ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor”
I have successfully started lsnrctl. Here... (3 Replies)
Recently I was struggling to resolve ORA-12514 error, after I solved that there is a another error "TNS-12535: TNS: operation timed out". For your information in my machine I have disabled firewall & also added SQLNET.EXPIRE_TIME = 10. But the problem is still persists. Again all your help is... (2 Replies)
1 #!/bin/ksh
2 ################################################################
3 # Written by Johnson 12/03/2008
4 # Version 1.0
5 # This script executes some SQL to provide Spike Check Report to TNS team.
6 ... (3 Replies)
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
I have code to update some records in MyTable1 in sql which I am calling from ksh file (unix script).
I am getting below error -
MyTable1 TABLE UPDATE FAILED : UPDATE MyTable1 SET ph_nr = '+44 (0)20 8960
1233' , update_dts = sysdate WHERE ID = 499037
ORA-00600: internal error code,... (2 Replies)
HI All ,
I am using oracle 10g and HP AIX . I am getting the below error while running the package.
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "DW_APP.PKG_ASS_FVC", line 595
ORA-06512: at line 2
... (4 Replies)
Hi,
User claim that job is running slow from their end.
I DBA found in database the below errors in alert log file.
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
LEARN ABOUT DEBIAN
grokevt-addlog
grokevt-addlog(1)grokevt-addlog(1)NAME
grokevt-addlog - A tool for adding a raw event log to an existing GrokEVT database.
SYNOPSIS
grokevt-addlog database-dir evt-file new-type base-type .SH DESCRIPTION grokevt-addlog takes a raw event log (.evt file) and adds it to a
pre-built database generated by grokevt-builddb(1). This new log file will be set up to use the message templates of another log, as deter-
mined by the user.
This tool is primarily useful for processing deleted logs and log fragments found on a system. While it is possible to use the database
generated from one system with the logs of another, this is not recommended for investigations unless no alternatives exist.
ARGUMENTS
grokevt-addlog uses the following arguments:
database-dir
The base directory for the database generated previously by grokevt-builddb(1).
evt-file
The file to be added to the database.
new-type
The new log type/name that evt-file will take on. This is the name that will need to be used later with grokevt-parselog(1) to
access the new log. This type must not already exist in the database.
base-type
The existing log type that this new log will be based on. The message templates from this type will be used with the new log when
parsing. This type must exist in the current database.
BUGS
Probably several. This particular script has not been extensively tested.
CREDITS
Written by Timothy D. Morgan.
Copyright (C) 2006-2007 Timothy D. Morgan
LICENSE
Please see the file "LICENSE" included with this software distribution.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License version 2 for more details.
SEE ALSO grokevt(7)grokevt-builddb(1)grokevt-dumpmsgs(1)grokevt-findlogs(1)grokevt-parselog(1)grokevt-ripdll(1)File Conversion Utilities 20 March 2008 grokevt-addlog(1)