Re: Questiuon about unix
Try this as following:
cat yourfile | awk -F; ' ( $4 == "") { print $0 }' # $4 means your field number from
beginning; $0 means whole line.
Good luck!
Don
[EMAIL PROTECTED] wrote:
> Hallo everybody,
>
> anyone whom can tell me what the command is to search for an empty field in a unix
> file.
>
> for instance if you want to find the empty spacelines if some lines looklike:
>
> 1;100;Name;;
> 2;200;Test;45;
> 3;300;Name;;
>
> I would like to find out line nr 1 and 3 here above. Anyone whom could suggest any
> good?
>
> Maybe this sounds simple but I have tried with /;; and cant find it. If iI use that
> command then I will get lines with ;; and i just want lines with two ;;
>
> Thanks in advance
>
> Roland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Don Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: UNIX : script help/input
Johan:
Please see the attachment file, which is my script for everyday web
server log file and uses nslookup to process the results. Hope that it
is helpful.
Don
Johan Muller wrote:
> Anybody with a quick and dirty (elegant would be nice too), to munge
> output from a nslookup output file to a delimited file?
>
> 'File content:
>
> Server: dns1.mci.com
> Address: 199.249.19.1
>
> Name:WCOM-4NXZGAPWY5.mcilink.com
> Address: 166.50.73.209
>
> Delimited file should have the following line(s); (using | or
> whatever as delimiter):
>
> '166.50.73.209'|'4NXZGAPWY5.mcilink.com'.
>
> Required for both single and multiple records.
>
>
>
> TIA
#! /bin/ksh
# file name: log_file_parsing
# Date: March 6,2003; Mar 7,2003; Mar 10,2003; Mar 13,2003; May 7,2003; 12 May,2003;
May 15,2003;
# May 20,2003; May 30,2003
#
# Author: Don Y.
# Desc: an example of parsing netTracker related web access from web server
(www.welch.jhu.edu) access
# log file. Extract client IP, access date, and host IP. This script also
transfer client IP
# with alphabet into digital one by issuing nslookup command call. Finally make
nslookup work
# for it outputs a few lines instead of one line.
#
# define output file
WORKING_DIR=$1
OUTPUT_FILE="$WORKING_DIR/log_file_parsing_output.temp"
INPUT_FILE=$WORKING_DIR/$2
TEMP_NAME=$3
SCRIPT_HOME="/export/users/dony/report"
# check input access log file exists or not under $WORKING_DIR
if [ ! -f $WORKING_DIR/$2 ]
then
echo "input access log file doesn't exist at working directory!"
exit 1
fi
# check output file under working directory exist or not :
$WORKING_DIR/log_file_parsing_output.temp
if [ ! -f $WORKING_DIR/log_file_parsing_output.temp ]
then
touch $WORKING_DIR/log_file_parsing_output.temp
chown dony:staff $WORKING_DIR/log_file_parsing_output.temp
fi
# check all temporary files exist or not
if [ -f $WORKING_DIR/log_file_parsing_temp01.temp ]
then
rm $WORKING_DIR/log_file_parsing_temp01.temp
else
# create an empty file with owner status: dony:staff
touch $WORKING_DIR/log_file_parsing_temp01.temp
chown dony:staff $WORKING_DIR/log_file_parsing_temp01.temp
fi
if [ -f $WORKING_DIR/log_file_parsing_temp02.temp ]
then
rm $WORKING_DIR/log_file_parsing_temp02.temp
else
touch $WORKING_DIR/log_file_parsing_temp02.temp
chown dony:staff $WORKING_DIR/log_file_parsing_temp02.temp
fi
# file parsing for NetTracker associated lines
success=0
cat $INPUT_FILE | grep "/cgi-bin/ntlinktrack.cgi" | awk '{print
$1,substr($4,2,11),$7}' | sed 's/\/cgi-bin\/ntlinktrack.cgi?//' >
$WORKING_DIR/log_file_parsing_temp01.temp
let success=success+$?
sed 's/http:\/\/www.welch.jhu.edu\/cgi-bin\/ntlinktrack.cgi?//'
$WORKING_DIR/log_file_parsing_temp01.temp > $WORKING_DIR/log_file_parsing_temp02.temp
let success=success+$?
# get start line number here
whole_parsing_start_line=`cat $OUTPUT_FILE | wc -l`
# change the date format
for arg_each_line in `cat $WORKING_DIR/log_file_parsing_temp02.temp | awk '{ print
$1"==="$2"==="$3 }'`
do
one_line=`echo $arg_each_line | sed 's/===/ /g'`
# debug one line below if enabled
#echo $one_line >> $WORKING_DIR/log_file_parsing_temp03.temp
client_ip=`echo $one_line | awk '{ print $1 }' | sed 's/ //g'`
org_date=`echo $one_line | awk '{ print $2 }' | sed 's/ //g'`
oracle_date=`$SCRIPT_HOME/ldate $org_date`
host_ip=`echo $one_line | awk '{ print $3 }' | sed 's/ //g'`
# transfer client_ip from alphabet to digital
client_addr=`echo "$client_ip" | egrep -i -e [a-z] | sed 's/ //g'`
# get the length of client_addr
LENGTH=`expr "$client_addr" : '.*'`
if [ $LENGTH -gt 8 ]
then
# add pattern of [1-9][1-9] for parsing since nslookup output might be
changed
/usr/sbin/nslookup $client_addr 2> $WORLING_DIR/$TEMP_NAME | awk '{
print $2 }' | egrep -e [0-9]'.'[0-9]'.' > nslookup_result
NSR_LINES=`cat nslookup_result | wc -l`
if [ $NSR_LINES -eq 2 ];then
client_digit=`cat nslookup_result 2> $WORLING_DIR/$TEMP_NAME |
awk '( NR == 2 ) { print $0 }'`
elif [ $NSR_LINES -eq 3 ];then
client_digit=`cat nslookup_result 2> $WORLING_DIR/$TEMP_NAME |
awk '( NR == 3 ) { print $0 }'`
fi
# remove the result file
rm nslookup_result 2> $WORLING_DIR/$TEMP_NAME
# check whether or not the nslookup command gets a result,which it
should be larger than 8
LENGTH=`expr "$client_digit" : '.*'`
if [ $LENGTH -gt 8 ]
then
client_ip=$client_digit
fi
fi
# output the result
echo "$client_ip $oracle_date $host_ip" >> $OUTPUT_FILE
let success=success+$?
done
# get whole NetTracker related lines
whole
Re: Job to run first Wednesday
design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent Help!! FYI
Matthew, Yes. After I execute script as "lsnrctl start" by oracle, everything is the same to my original. But before I try to execute this script as root. I think that I make a big mistake. Many thanks! Don Matthew Zito wrote: > Also, it looks like you're starting the listener as root. Try doing it > as oracle. > > Matt > > -- > Matthew Zito > GridApp Systems > Email: [EMAIL PROTECTED] > Cell: 646-220-3551 > Phone: 212-358-8211 x 359 > http://www.gridapp.com > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Goulet, Dick > > Sent: Friday, July 18, 2003 3:24 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: urgent Help!! FYI > > > > > > In your listener.ora file add the line > > "logging_listener=off". Otherwise make sure > > $ORACLE_HOME/network/log exists and is writable by the Oracle user. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, July 18, 2003 4:10 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, > > > > I need somebody here to help me to start my Oracle listener > > for my Oracle server was power off this morning. Here, when I > > run the lsncrtl start, I get an error message. Please see the > > following message: > > > > # ./lsnrctl start > > > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on > > 18-JUL-2003 15:20:10 > > > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > > NL-00280: error creating log stream > > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > > NL-00278: cannot open log file > > SNL-00016: snlfohd: error opening file > >Solaris Error: 13: Permission denied > > > > Listener failed to start. See the error message(s) above... > > > > Can somebody tell me how to start my Oracle listener? Any > > suggestion are highly appreciated! Many thanks! > > > > > > Don > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Don Yu > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Goulet, Dick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Matthew Zito > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent Help!! FYI
Freeman, Before I change it, listener.ora property is like the following: $ls -al listener.ora -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log After I change it by the following steps, it works fine. $chmod 666 listener.ora lsnrctl start Now Oracle listener starts up. Thank you very much! Don Freeman Robert - IL wrote: > In OH/network/log is there a listener.log file? Who owns it? Who are you > starting the listener as and does that ID have rights to write to the > listener.log? > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 7/18/2003 3:09 PM > > Hi, > > I need somebody here to help me to start my Oracle listener for my > Oracle server was power off this morning. Here, when I run the lsncrtl > start, I get an error message. Please see the following message: > > # ./lsnrctl start > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 > 15:20:10 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > NL-00280: error creating log stream > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > NL-00278: cannot open log file > SNL-00016: snlfohd: error opening file >Solaris Error: 13: Permission denied > > Listener failed to start. See the error message(s) above... > > Can somebody tell me how to start my Oracle listener? Any suggestion are > highly appreciated! > Many thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent Help!! FYI
Dick, It works now after I change the $ORACLE_HOME/network/log/listener.ora to like following: $ls -al listener.log -rw-rw-rw- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log But before the parameter is like following: $ls -al listener.log -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log I just don't know is this file property changed or not? If changed, who changed it. But before power off, it works fine. Thank you very much again! Don "Goulet, Dick" wrote: > In your listener.ora file add the line "logging_listener=off". Otherwise make sure > $ORACLE_HOME/network/log exists and is writable by the Oracle user. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, July 18, 2003 4:10 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I need somebody here to help me to start my Oracle listener for my > Oracle server was power off this morning. Here, when I run the lsncrtl > start, I get an error message. Please see the following message: > > # ./lsnrctl start > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 > 15:20:10 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > NL-00280: error creating log stream > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > NL-00278: cannot open log file > SNL-00016: snlfohd: error opening file >Solaris Error: 13: Permission denied > > Listener failed to start. See the error message(s) above... > > Can somebody tell me how to start my Oracle listener? Any suggestion are > highly appreciated! > Many thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent Help!! FYI
Dick, Before this morning power off, everything is fine with my Oracle server. I think this might be something related to autostart because my solaris server is down. But I will try it. Thanks! Don "Goulet, Dick" wrote: > In your listener.ora file add the line "logging_listener=off". Otherwise make sure > $ORACLE_HOME/network/log exists and is writable by the Oracle user. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, July 18, 2003 4:10 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I need somebody here to help me to start my Oracle listener for my > Oracle server was power off this morning. Here, when I run the lsncrtl > start, I get an error message. Please see the following message: > > # ./lsnrctl start > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 > 15:20:10 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > NL-00280: error creating log stream > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > NL-00278: cannot open log file > SNL-00016: snlfohd: error opening file >Solaris Error: 13: Permission denied > > Listener failed to start. See the error message(s) above... > > Can somebody tell me how to start my Oracle listener? Any suggestion are > highly appreciated! > Many thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Instances not starting up via services
gt; > > :->> from). You may > > > :->> also send the HELP command for other information > > > :->> (like subscribing). > > > :-> > > > :-> > > > :->__ > > > :->Do you Yahoo!? > > > :->SBC Yahoo! DSL - Now only $29.95 per month! > > :->http://sbc.yahoo.com > > > :->-- > > > :->Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > :->-- > > > :->Author: Jose Luis Delgado > > > :-> INET: [EMAIL PROTECTED] > > > :-> > > > :->Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > > :->San Diego, California-- Mailing list and web > > > hosting services > > > :->--- > > > -- > > > :->To REMOVE yourself from this mailing list, send an E-Mail message > > > :->to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in :->the message BODY, include a line > > > containing: UNSUB ORACLE-L :->(or the name of mailing list > > > you want to be removed from). You may :->also send the HELP > > > command for other information (like subscribing). :-> :-> > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Nuala Cullen > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web > > hosting services > > > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > > and in the message BODY, include a line containing: UNSUB > > > ORACLE-L (or the name of mailing list you want to be removed > > > from). You may also send the HELP command for other > > > information (like subscribing). > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Niall Litchfield > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Niall Litchfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
urgent Help!! FYI
Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How can I turn Oracle listener on for Oracle 9i on solaris - FYI
Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shell question
Please see the following text, which comes from my shell script:
for arg_each_line in `cat $WORKING_DIR/log_file_parsing_temp02.temp | awk
'{ pri
nt $1"==="$2"==="$3 }'`
do
one_line=`echo $arg_each_line | sed 's/===/ /g'`
# debug one line below if enabled
#echo $one_line >> $WORKING_DIR/log_file_parsing_temp03.temp
client_ip=`echo $one_line | awk '{ print $1 }' | sed 's/ //g'`
org_date=`echo $one_line | awk '{ print $2 }' | sed 's/ //g'`
oracle_date=`$SCRIPT_HOME/ldate $org_date`
host_ip=`echo $one_line | awk '{ print $3 }' | sed 's/ //g'`
# transfer client_ip from alphabet to digital
client_addr=`echo "$client_ip" | egrep -i -e [a-z] | sed 's/
//g'`
# get the length of client_addr
LENGTH=`expr "$client_addr" : '.*'`
..
done
Hope that it is helpful!
Don
[EMAIL PROTECTED] wrote:
>
> hi all ,
>
> how can I read a text file and print line by line.
>
> Rgds.
> Arslan.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Don Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: How to make SPFILE in sync with INIT.ORA ?
q.net > > > > > > > -- > > > > > > > Author: Prem Khanna J > > > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > > > > > > San Diego, California-- Mailing list and web > > > > > > hosting services > > > > > > > > > > > > > > > > > > > > - > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail > message > > > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > > > > > > in the message BODY, include a line containing: UNSUB ORACLE-L > (or > > > > > > > the name of mailing list you want to be removed from). You may > > > > > > also send > > > > > > > the HELP command for other information (like subscribing). > > > > > > > > > > > > > -- > > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > > > -- > > > > > > Author: Arup Nanda > > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > > > > > San Diego, California-- Mailing list and web hosting > services > > > > > > > > > > > > > - > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > > > > > and in the message BODY, include a line containing: UNSUB > > > > > > ORACLE-L (or the name of mailing list you want to be removed > > > > > > from). You may also send the HELP command for other > > > > > > information (like subscribing). > > > > > > > > > > > > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > > -- > > > > > Author: Niall Litchfield > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > > > San Diego, California-- Mailing list and web hosting > services > > > > > > - > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > > > > name of mailing list you want to be removed from). You may also > send > > > > > the HELP command for other information (like subscribing). > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > > -- > > > > > Author: Molina, Gerardo > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > > > San Diego, California-- Mailing list and web hosting > services > > > > > > - > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > > > > name of mailing list you want to be removed from). You may also > send > > > > > the HELP command for other information (like subscribing). > > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Arup Nanda > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > > San Diego, California-- Mailing list and web hosting services > > > > -
Re: How to make SPFILE in sync with INIT.ORA ?
oved from). You may also send > > > the HELP command for other information (like subscribing). > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Arup Nanda > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > > mailing list you want to be removed from). You may also send the HELP > > command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Molina, Gerardo > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Arup Nanda > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlldr questions
Please look the following text, which works fine everyday for loading my data into oracle 9.2 database. $ORACLE_HOME/bin/sqlldr USERID=your_username/[EMAIL PROTECTED] control=link-summary.ctl log=link-summary.log $ more link-summary.ctl options (rows=9297500, errors=2, bindsize=100, readsize=100) LOAD DATA INFILE '/tmp/log_file_parsing_output.dat' truncate INTO TABLE access_summary FIELDS TERMINATED BY ' ' (CLIENT_IP char(100), ACCESS_DATE char(9), URL char(400)) This is my application. You need to change file name, file path, and table name and its column name as well. Hope it can help you. Don Kirtikumar Deshpande wrote: > An excellent book for SQL Loader new comers, and experienced users as well, is one > by Jonathan > Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. > > Stenphen Andert will agree with me ;) > > - Kirti > > --- John Dunn <[EMAIL PROTECTED]> wrote: > > I'm a sqlldr newbie. Platform is Oracle 9.2. > > > > My question is...can I prevent sqlldr loading any data if there is even a > > single bad record, even if it is, for example, the last record? I am using > > conventional path > > load. > > > > John > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: John Dunn > > INET: [EMAIL PROTECTED] > > > > __ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Kirtikumar Deshpande > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: security without using different usernames
Arup,
My database version is Oracle 9i (9.2.0.1.0). Thanks!
Don
Arup Nanda wrote:
> What is your database version? 9i? If so you are probably using the SPFILE;
> changing the init.ora file wouldn't help.
>
> Shutdown trhe database and startup with the pfile option
>
> startup pfile=init.ora
>
> being in the same directory. You will be able to see the parameter being
> set.
>
> HTH.
>
> Arup Nanda
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 16, 2003 12:09 PM
>
> > Pete,
> >
> > I follow your steps to enable audit_trail = db in init.ora located in
> > ORACLE_HOME/dbs
> > and restart my Oracle database on solaris. After my database is up, I do
> the exact
> > query in your paper and results as followings:
> >
> > SQL> select name,value from v$parameter
> > 2 where name like 'audit%';
> >
> > NAME
> >
> > VALUE
> > --
> --
> > audit_sys_operations
> > FALSE
> >
> > audit_file_dest
> > ?/rdbms/audit
> >
> > audit_trail
> > NONE
> >
> > Please tell me what is possible causes that I fail to enable audit on my
> database.
> > Any comments are appreciated!
> > Many thanks!
> >
> >
> > Don
> >
> >
> > Pete Finnigan wrote:
> >
> > > Hi
> > >
> > > You can get the ip address as follows:
> > >
> > > oracle:jupiter> sqlplus system/[EMAIL PROTECTED]
> > >
> > > SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
> > >
> > > (c) Copyright 2001 Oracle Corporation. All rights reserved.
> > >
> > > Connected to:
> > > Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
> > > With the Partitioning option
> > > JServer Release 9.0.1.0.0 - Production
> > >
> > > SQL> select sys_context('userenv','ip_address') ip,username,machine
> > > 2 from v$session
> > > 3 where sys_context('userenv','sessionid')=audsid;
> > >
> > > IP
> > >
> > >
> > > USERNAME
> > > --
> > > MACHINE
> > >
> > > 172.16.240.11
> > > SYSTEM
> > > jupiter
> > >
> > > SQL>
> > >
> > > you need to provide the service name when you log on otherwise the ip
> > > address is not available using sys_context.
> > >
> > > Also new with 9i as part of application contexts you can use the "using"
> > > clause of create role that a pl/sql package can be used to verify the
> > > user, for example something like this, typed in from memory so check the
> > > syntax!:
> > >
> > > create role some_role identified using sys.confirm_user;
> > >
> > > create or replace procedure confirm_user
> > > authid current user is
> > > lv_ipaddress varchar2(30);
> > > begin
> > > select sys_context('userenv','ip_address')
> > > into lv_ipaddress
> > > from sys.dual;
> > > if lv_ipaddress='172.16.140.1' then
> > > dbms_session.set_role('some_role');
> > > end if;
> > > end;
> > > /
> > >
> > > hth
> > >
> > > kind regards
> > >
> > > Pete
> > > --
> > > Pete Finnigan
> > > email:[EMAIL PROTECTED]
> > > Web site: http://www.petefinnigan.com - Oracle security audit
> specialists
> > > Book:Oracle security step-by-step Guide - see http://store.sans.org for
> details.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Pete Finnigan
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > >
Re: security without using different usernames
Pete,
I follow your steps to enable audit_trail = db in init.ora located in
ORACLE_HOME/dbs
and restart my Oracle database on solaris. After my database is up, I do the exact
query in your paper and results as followings:
SQL> select name,value from v$parameter
2 where name like 'audit%';
NAME
VALUE
audit_sys_operations
FALSE
audit_file_dest
?/rdbms/audit
audit_trail
NONE
Please tell me what is possible causes that I fail to enable audit on my database.
Any comments are appreciated!
Many thanks!
Don
Pete Finnigan wrote:
> Hi
>
> You can get the ip address as follows:
>
> oracle:jupiter> sqlplus system/[EMAIL PROTECTED]
>
> SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
> With the Partitioning option
> JServer Release 9.0.1.0.0 - Production
>
> SQL> select sys_context('userenv','ip_address') ip,username,machine
> 2 from v$session
> 3 where sys_context('userenv','sessionid')=audsid;
>
> IP
>
>
> USERNAME
> --
> MACHINE
>
> 172.16.240.11
> SYSTEM
> jupiter
>
> SQL>
>
> you need to provide the service name when you log on otherwise the ip
> address is not available using sys_context.
>
> Also new with 9i as part of application contexts you can use the "using"
> clause of create role that a pl/sql package can be used to verify the
> user, for example something like this, typed in from memory so check the
> syntax!:
>
> create role some_role identified using sys.confirm_user;
>
> create or replace procedure confirm_user
> authid current user is
> lv_ipaddress varchar2(30);
> begin
> select sys_context('userenv','ip_address')
> into lv_ipaddress
> from sys.dual;
> if lv_ipaddress='172.16.140.1' then
> dbms_session.set_role('some_role');
> end if;
> end;
> /
>
> hth
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:[EMAIL PROTECTED]
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pete Finnigan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Don Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle security question
Ron, I have urgent question. Because I want to shutdown my database, I login as oracle and execute dbshut. But later I found that the process is very slow so I realize that I should type shutdown immediate. Then, I use control-D to stop shutdown command. And I re-execute "shutdown immediate". Now the shutdown command seems to take longer time to finish. Is there something wrong or normal? Any comments are appreciated! Thanks! Don Ron Rogers wrote: > Don, > The users need acces to the data that is in the database or what is > the purpose of the database? > I would change the privileges of the users to "CREATE SESSION" only > and revoke all others. Then I would use "ROLES" that have select > privileges on the tables that they need acces to. By creating roles and > granting the role to a user the user can select from the tables. If > different groups need acces to different tables you can create different > roles and grant them as needed. > Roles are an easy method of controlling acces to table data and if > changes are needed then you change the role's privileges and all users > of the role are effected. > Ron > > >>> [EMAIL PROTECTED] 07/11/03 03:44PM >>> > Hi, > > I have a security question about Oracle database. Recently I have > taken > full control an Oracle database in my department. Now I would like to > make sure that no other people except myself can update data in that > database. Can somebody tell me what it is necessary steps to do that? > Any comments are highly appreciated. Thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle security question
Dear Guang Mei: Thanks for your message. Your suggestion is very helpful. After reviewing all possible uesers, I have locked them. Now I have only one concern that if nobody knows my database's sys and system's password, there should be no way to unlock these accounts. Am I complete right? Thanks! Any comments are appreciated! Don Guang Mei wrote: > select * from all_users; > > to get all users, then change their oracle passwords so that no body can > log in except you. This way you know you are the only one who can change > the data. Next step is see what application can make the data change. > > Hope this helps. > > Guang > > On Fri, 11 Jul 2003, Don Yu wrote: > > > Dennis > > > > Thank you very much. My data in that database is changed three times. The first > > is whole data being delete. The second is over ten thousands records being > > added. The third is whole data related to a month being deleted. I know my > > working environment is very complicated. For this report application, I write > > shell scripts and C/C++ program to parsing Apache web server access log file > > (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which > > are associated with the special pattern as "ntlinktrack.cgi", which is > > associated with Library E-Book,E-Journal, and E-database. Then I need to > > schedule a solaris cron job to process access log daily and load parsed data > > into database. Also I create some log files for saving intermediate information > > from my program. Then I create some ColdFusion pages to post these results into > > website. In my database there are over million records. Oracle DBA is new duty > > for me since I had found that my data was missing. This is the reason I post my > > question on Oracle user group. Now I am trying to read as much as I can but I do > > not have much time. I want to make sure my database is secure as early as I can. > > So what do you think of my reason? > > Thank you very much! > > > > > > Don > > > > > > DENNIS WILLIAMS wrote: > > > > > Don > > > SYS is the owner of the Oracle dictionary tables. It is a username with > > > DBA privilege, so someone who logs in can change data. If you have changed > > > its password, then you are assured that nobody is using that username right > > > now. If you've changed its password, then I wouldn't worry about it right > > > now. > > > Since it sounds as if you are the only person that accesses this > > > database, then you may want to change the username that owns your tables. > > > Hopefully this username is not SYSTEM or SYS. > > > After that, unless you know of other usernames someone might use to > > > access your Oracle database, don't make any more security changes for > > > awhile. Go back to trying to figure out why your data is changing without > > > your changing it. It may well be there is an innocent reason that has > > > nothing to do with someone else. I've had that happen to me when I've > > > started using an unfamiliar system. > > > And don't forget to buy a good Oracle DBA book like the one I suggested. > > > > > > Dennis Williams > > > DBA, 80%OCP, 100% DBA > > > Lifetouch, Inc. > > > [EMAIL PROTECTED] > > > > > > > > > > > > -Original Message- > > > Sent: Friday, July 11, 2003 3:49 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > Dennis: > > > > > > Thanks for your message. Now I have changed sys password by the following > > > command: > > > alter user sys identified by xxx > > > But when I try to login from sql plus window by using sys, I cannot > > > successfully > > > login. Also I get an error message. The message is something like > > > "connection to > > > sys should be as sysdba or sysoper". So my question is what sys for? > > > Thank you very much! > > > > > > Don > > > > > > DENNIS WILLIAMS wrote: > > > > > > > Don > > > >If only you can make updates to your Oracle database, then you must > > > enter > > > > all the data ;-) > > > >From the tone of your posting, I'm going to assume that you are pretty > > > > new to Oracle. You may want to get a good basic administration book like > > > > Oracle9i DBA 101. > > > > > > > http://www.amazon.com/exec/obidos/tg/detail/-/0072
Re: Oracle security question
Dennis Thank you very much. My data in that database is changed three times. The first is whole data being delete. The second is over ten thousands records being added. The third is whole data related to a month being deleted. I know my working environment is very complicated. For this report application, I write shell scripts and C/C++ program to parsing Apache web server access log file (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which are associated with the special pattern as "ntlinktrack.cgi", which is associated with Library E-Book,E-Journal, and E-database. Then I need to schedule a solaris cron job to process access log daily and load parsed data into database. Also I create some log files for saving intermediate information from my program. Then I create some ColdFusion pages to post these results into website. In my database there are over million records. Oracle DBA is new duty for me since I had found that my data was missing. This is the reason I post my question on Oracle user group. Now I am trying to read as much as I can but I do not have much time. I want to make sure my database is secure as early as I can. So what do you think of my reason? Thank you very much! Don DENNIS WILLIAMS wrote: > Don > SYS is the owner of the Oracle dictionary tables. It is a username with > DBA privilege, so someone who logs in can change data. If you have changed > its password, then you are assured that nobody is using that username right > now. If you've changed its password, then I wouldn't worry about it right > now. > Since it sounds as if you are the only person that accesses this > database, then you may want to change the username that owns your tables. > Hopefully this username is not SYSTEM or SYS. > After that, unless you know of other usernames someone might use to > access your Oracle database, don't make any more security changes for > awhile. Go back to trying to figure out why your data is changing without > your changing it. It may well be there is an innocent reason that has > nothing to do with someone else. I've had that happen to me when I've > started using an unfamiliar system. > And don't forget to buy a good Oracle DBA book like the one I suggested. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > > -Original Message- > Sent: Friday, July 11, 2003 3:49 PM > To: Multiple recipients of list ORACLE-L > > Dennis: > > Thanks for your message. Now I have changed sys password by the following > command: > alter user sys identified by xxx > But when I try to login from sql plus window by using sys, I cannot > successfully > login. Also I get an error message. The message is something like > "connection to > sys should be as sysdba or sysoper". So my question is what sys for? > Thank you very much! > > Don > > DENNIS WILLIAMS wrote: > > > Don > >If only you can make updates to your Oracle database, then you must > enter > > all the data ;-) > >From the tone of your posting, I'm going to assume that you are pretty > > new to Oracle. You may want to get a good basic administration book like > > Oracle9i DBA 101. > > > http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8 > > -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846 > > It is also a good idea to always mention your Oracle version and platform > > (Unix, NT, etc.) in your posts. > > First, log in with the SYSTEM username. Then change the password for > SYSTEM > > and SYS with the command: > > ALTER USER SYSTEM IDENTIFIED BY x; > > Where x is your new password. > > You should be able to make these changes without affecting any end users. > > Next you should identify your groups of users and how they access Oracle. > > Basically you need to identify what their access requirements are and then > > audit the usernames they use to ensure the privileges granted are just > what > > is required. This is also a good time to see about changing passwords, but > > first buy the book and read up on the basics of Oracle security. > > > > Dennis Williams > > DBA, 80%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Friday, July 11, 2003 2:45 PM > > To: Multiple recipients of list ORACLE-L > > > > Hi, > > > > I have a security question about Oracle database. Recently I have taken > > full control an Oracle database in my department. Now I would like to > > make sure that no other people except myself can update data in tha
Re: Oracle security question
Dennis: Thanks for your message. Now I have changed sys password by the following command: alter user sys identified by xxx But when I try to login from sql plus window by using sys, I cannot successfully login. Also I get an error message. The message is something like "connection to sys should be as sysdba or sysoper". So my question is what sys for? Thank you very much! Don DENNIS WILLIAMS wrote: > Don >If only you can make updates to your Oracle database, then you must enter > all the data ;-) >From the tone of your posting, I'm going to assume that you are pretty > new to Oracle. You may want to get a good basic administration book like > Oracle9i DBA 101. > http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8 > -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846 > It is also a good idea to always mention your Oracle version and platform > (Unix, NT, etc.) in your posts. > First, log in with the SYSTEM username. Then change the password for SYSTEM > and SYS with the command: > ALTER USER SYSTEM IDENTIFIED BY x; > Where x is your new password. > You should be able to make these changes without affecting any end users. > Next you should identify your groups of users and how they access Oracle. > Basically you need to identify what their access requirements are and then > audit the usernames they use to ensure the privileges granted are just what > is required. This is also a good time to see about changing passwords, but > first buy the book and read up on the basics of Oracle security. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, July 11, 2003 2:45 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I have a security question about Oracle database. Recently I have taken > full control an Oracle database in my department. Now I would like to > make sure that no other people except myself can update data in that > database. Can somebody tell me what it is necessary steps to do that? > Any comments are highly appreciated. Thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle security question
Stephane, Thanks for your message. The reason I ask this question is that now I am responsible for creating some reports based upon this database. But I have found that there are unaccountable data in my database, which is not from my insert script or my cron job program. Thanks! Don Stephane Paquette wrote: > Change the password of all Oracle related users (sys, system,...) > Revoke access from all other users or make sure all other users have select > only privilege on data. > > What is the use of such databases ? > > Stephane Paquette > Administrateur de bases de donnees > Database Administrator > Standard Life > www.standardlife.ca > Tel. (514) 499-7999 7470 and (514) 925-7187 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -Original Message- > Don Yu > Sent: Friday, July 11, 2003 3:45 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I have a security question about Oracle database. Recently I have taken > full control an Oracle database in my department. Now I would like to > make sure that no other people except myself can update data in that > database. Can somebody tell me what it is necessary steps to do that? > Any comments are highly appreciated. Thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Paquette > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle security question
Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that database. Can somebody tell me what it is necessary steps to do that? Any comments are highly appreciated. Thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
