RE: 9i D/l
I think you just have to keep trying. Maybe at different times. I experienced the same as you but with the 9i for Linux download. HTH Gerardo -Original Message- Sent: Monday, September 17, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Hi List Have any of you been successful in d/lng 9i for NT from technet ?? I am getting Server not found. Is there any other mirror fromwhich I can d/l ?? TIA Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VeniVas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
ORA-00600
Hi I get this error ORA-00600 when i try to execute a stored procedure. The stored procedure gets compiled perfectly but gives this error at run-time while executing it from a java code. This is what i found in the alert log. Tue Sep 18 04:57:14 2001 Errors in file /usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc: ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707], [1049600], [1], [], [], [] Can someone tell me how to deal with this problem, Thanx, Sirisha. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sirisha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Way off topic - Volunteering
Also Enlisted as volunteer Being Physically in INDIA , may NOT be of much help -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 10:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: Way off topic - Volunteering Kevin, I received following information from a different listserv and hope it helps: For information on how to offer IT assistance or support to businesses in New York's World Trade Center, please visit our Web site at www.computerworld.com http://www.computerworld.com , where you can register to help through our IT Volunteers database (click on the red Volunteer IT banner). If your services are needed by businesses affected by Tuesday's attack, you will be contacted. Jessie Kevin Bachelder kbachelder@mindsTo: Multiple recipients of list ORACLE-L pring.com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Way off topic - Volunteering 09/17/2001 07:10 AM Please respond to ORACLE-L Hi everyone, I am looking to find a way to volunteer my time to assist non-profits or similar organizations that need technical assistance or maybe be a technical tutor or resource at a community center, etc. I knows this sounds crazy but my early attempts to find these opportunities near my local community have come up empty. Does anyone have any suggestions on how they have gone about this or similar things. Take care, Kevin -- Kevin Bachelder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Subtract 1 month from current date
select ADD_MONTHS(trunc(your_date),-1) from dual; -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 17:40 To: Multiple recipients of list ORACLE-L Subject: Subtract 1 month from current date Can someone tell me how to subtract 1 month from the current date? Also, where can I find answers and examples to this type of coding question? Thanks! Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Perl code example
A good solution might be to read the eviromental parameters of the UNIX
session. In there you can set the SID and username/password.
From within the Perl code then do:
$data_source=dbi:Oracle: . $ENV{SID};
$dbbscs = DBI-connect($data_source,$ENV{username},$ENV{passwd});
$sqlstmt_tmcode = select ... from ...;
$stmt_tmcode = $dbbscs-prepare($sqlstmt_tmcode) || die Couldn't prepare
the tmcode statement!\n;
$stmt_tmcode-execute || die Couldn't execute the tmcode statement!\n;
Regards,
Hatzistavrou Yannis
-Original Message-
From: Hagedorn, Linda [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 01:00
To: Multiple recipients of list ORACLE-L
Subject: Perl code example
Hello,
I'm looking for a Perl example passing parameters.
The code below has the userids and passwords hardcoded in clear text in
the system line, parms 3 and 5 (five lines from the bottom), and the
Oracle sid is hardcoded also. The code has to be changed to 1) read .pwd1
and .pwd2 files containing the passwords, and set a literal for the SID
and substitute it at in the code.
I'm not a Perl coder, and would appreciate any information, hints, or
links to the manual.
Thanks, Linda
#!/usr/local/bin/perl
#
use CGI qw(:standard);
#
$| = 1;
($sec,$min,$hour,$mday,$mmonth,$myear,$wday,$yday,$isdst) =
localtime(time);
if ($myear 99) {
$myear++;
}
$myear += 1900;
$mmonth += 1;
print header;
if (!param()) {
print start_html('dev02 QRX4 DB Refresh'),
h1('centerdev02 QRX4 DB Refresh for Formulary qRx Version 4.0'),
hr,
body bgcolor=\#66\ text=\#00\br,
Enter a date to start the Oracle database refresh script,br,
then hit iSubmit/i to kick off the refresh for that
date.p,
start_form,
Enter the target refresh date: ,
textfield('day',$mday,2),
textfield('month',$mmonth,2),
textfield('year',$myear,4),
p, submit('Submit'),
end_form,
hr;
} else {
#print You entered :p;
$dy = param('day');
$mo = param('month');
$yr = param('year');
print You are transferring all data modified on or after , $dy, -,
$mo,-, $yr, to update;
print \n;
print QRX4: Starting script with
/opt/oracle/scripts/staging/cerebellum/refresh.sh $dy-$mo-$yr\n;
print A HREF=
http://parietal.corpdc.epocrates.com/cgi-bin/staging/productionDater_dev0
2.plReturn to previous page/A,hr;
print pre;
system /opt/oracle/scripts/staging/refresh.sh gui4 pwd1 qrx4 pwd2
$dy-$mo-$yr dev02;
print /prehr;
print A HREF=
http://parietal.corpdc.epocrates.com/cgi-bin/staging/productionDater_dev0
2.plReturn to previous page/A,hr;
print end_html;
}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hatzistavrou Giannis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: The DBA in the IS organization
Satar, I'm afraid that I'm going to have to take issue with this. Bad English food is, I agree, fairly grim, but the same could be said of bad food everywhere. Have you ever been to New Jersey? All they eat there are chicken parm subs! London is one of the great places in the world if you like eating, altho' quite expensive compared to Paris or Amsterdam. If you can get the Sunday Times where you are, try reading the A A Gill column every week for an idea of some good places to go. Incidentally, one of the VPs at my last job was a friend of A A Gill's girlfriend (aka The Blonde), but I never did get to meet him. Now back onto the subject. Here, I count as part of the development team, with simply a slightly different skill set to everyone else (SQL rather than C++). It works pretty well. Of course, we are a software house, and don't do much by the way of running 24/7 operations (altho' of course our clients do). Cheers, g -Original Message- Sent: Monday, September 17, 2001 10:48 PM To: Multiple recipients of list ORACLE-L As for me, this is my 3rd job as an Oracle DBA. My first job was working for a Porno Company based out of Beverly Hills, CA. It was a small company (130 internal employees and 200 outside employees aka phone actress and actors) that owned the majority of the phone sex lines (over 10,000 lines coming in). As the DBA, I reported to the owner. I supported and worked closely with the developers and network admins. But my major tasks were to automate business practices and to suggest ways to improve perversion efficiency. My Second job was working for a national VAR (value added reseller) company which had strong ties to Sun Microsystems, IBM, HP, SGI, etc. I reported to the Co-owner of the company. My job role was to work closely with the system admins to implement enterprise solutions for major corporations. My current job involves a large international Manufacturing company. As the DBA, I report to the CIO of the company. Each division has a MIS manager. My role is to provide support to each division (which sucks because I have to travel a lot, especially to the UK...no offense to the people of the UK, but the only good thing about the UK that I like are the PUBS!!! The weather, some people and food is another story). My major tasks are to consolidate the companies on a data level, which means I work closely witht the ERP developers. I also make hardware and software suggestions to ease operations. Hope this helps! As far as being with the developers, you will need to be with them regardless, either at the beginning of development to make sure they don't mess up the database or after development to fix the problems that they did mess up. Regards, Satar Please remember that TRUE muslims do not advocate violence. Please do not displace your anger on innocent muslims living in your local area. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-00600
Hi sirisha, ORA-00600 ORA-00600internal message code, arguments: [num], [?], [?], [?], [?], [?] Cause:This is a catch-all internal message for ORACLE program exceptions. It indicates that a process has met a low-level, unexpected condition. Various causes of this message include: ·time-outs ·file corruption ·failed data checks in memory ·hardware, memory, or I/O messages ·incorrectly restored files The first argument is the internal message number; other arguments are various numbers, names, and character strings. (See section Reporting a Problem to Worldwide Customer Support on page 1-12 for more information.) The numbers may change meanings between different versions of the ORACLE Server. Action:Report this error to Worldwide Customer Support after gathering the following information: ·events that led up to the error ·the operations that were attempted that led to the error ·the conditions of the operating system and database at the time of the error ·any unusual circumstances that occurred prior to receiving the ORA-00600 message. ·contents of any trace files generated by the error ·the relevant portions of the Alert file NOTE: The cause of this error may manifest itself as different errors at different times. Be aware of the history of errors that occurred prior to this internal error. *** Hope that this would help you, REgards, lamriN. Hi I get this error ORA-00600 when i try to execute a stored procedure. The stored procedure gets compiled perfectly but gives this error at run-time while executing it from a java code. This is what i found in the alert log. Tue Sep 18 04:57:14 2001 Errors in file /usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc: ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707], [1049600], [1], [], [], [] Can someone tell me how to deal with this problem, Thanx, Sirisha. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sirisha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
7 step guide to constructing a Disaster Recovery Plan
The site below contains a 7 step guide to constructing a Disaster Recovery Plan. Enjoy =:-0 http://www.w2knews.com/rd/rd.cfm?id=091301-SevenDRPsteps Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Determining Oracle status
Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Turning off output when running pl/sql
Hi, I'm running a block of PL/SQL in SQL Plus (8.1.7), and when its completed it says the usual: PL/SQL procedure successfully completed. at the end. I'm spooling the output of the PL/SQL block to a file using dbms_put.put_line but I want to get rid of the above line. Anyone know how I can do this? Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Perl code example
-- Hagedorn, Linda [EMAIL PROTECTED] on 09/17/01 15:00:22 -0800
I'm looking for a Perl example passing parameters.
The code below has the userids and passwords hardcoded in clear text in
the system line, parms 3 and 5 (five lines from the bottom), and the
Oracle sid is hardcoded also. The code has to be changed to 1) read
.pwd1 and .pwd2 files containing the passwords, and set a literal for the
SID and substitute it at in the code.
I'm not a Perl coder, and would appreciate any information, hints, or
links to the manual.
Prepared queries can use placeholders (?) in the SQL. You can
start out with something like:
my $dbh = DBI-connect( %connect_args );
...
my $sth = $dbh-prepare( 'select blah blah blah where foo = ?' );
...
if( $sth-execute( $value_for_foo_here )
{
my $result = $sth-fetchall_arrayref;
}
...
This would avoid all hard-coding and leave you with a re-usable $sth.
Try perldoc DBI as a good starting place for info on DBI.
You might also want to check out the dbi mailing list or O'Reilly
Press' DBI manual.
sl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Determining Oracle status
here is a snippet i use to determine if the db is up. u can use any sql script, i
choose to get the db name and compare to sid.
if [ `which sqlplus | grep no sqlplus | wc -l` -eq 0 ]
[ `print \n\n\n | sqlplus -s guest/guest@$sid @$ORABIN/db_get_dbname | grep
Instance_Name | awk '{print $2}'` = $sid ]
then
db is up stuff...
fi
[EMAIL PROTECTED] 09/18/01 11:45AM
Hi all,
I am trying to write a script in unix that determines if a specific oracle
instance is available. I'm trying to avoid using the 'ps' command, so I
thought the easiest method would be to connect via sqlplus - If it connects
its up, if it doesn't then its unavailable. However, the problem is that
when it isn't up, the script hangs and does not return anything - I think
that this is because sqlplus by default gives you 3 attempts to logon, so
even though the logon attempt failed, it is waiting for you to try again, so
unfortunately I'm not getting a failed return code.
If anybody could tell me how to change this so that it only allows 1 login
attempt before 'kicking you out' or whether there is a better method to
finding out the status of an instance, I would be extremely grateful to hear
from you.
TIA for any responses.
Best Regards,
Barry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Turning off output when running pl/sql
set feedback off Jared Steven Hovington steven.hovington@proce To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ssion.comcc: Sent by: Subject: Turning off output when running pl/sql [EMAIL PROTECTED] 09/18/01 10:05 AM Please respond to ORACLE-L Hi, I'm running a block of PL/SQL in SQL Plus (8.1.7), and when its completed it says the usual: PL/SQL procedure successfully completed. at the end. I'm spooling the output of the PL/SQL block to a file using dbms_put.put_line but I want to get rid of the above line. Anyone know how I can do this? Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Accept statement
I'm am trying to use an accept statement to grab some info from the user in an SQL script, and then use that in a subsequent PL/SQL block. I can do the Accept ok, but can't sem to access the variable onside the block. Can anyone point me in the right direction? Thanks in advance. Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 9i D/l
You know, this list is the greatest! I specifically submitted my name to the OTN site, to be told *apparently* as soon as the version I am interested in is released - which was 9i for Win2K. Guess what? The first I hear of this being released was HERE!! Still haven't heard anything from Oracle!! Now all I have to do is log on for 3 weeks to try and download it over my 56k modem :) RANT I can't believe that that the download is over a GIG in size!! 8.1.7 was only close to 600 or so meg! We can't get Broadband services here either! In a CITY! Though I hear of people all around the country (even residencies) and small TOWNS etc. that can get ADSL, but here we are in a CITY and a BUSINESS wanting to get the service, and BT can't supply it to us!! Neither can NTL, because BT haven't installed it in our exchange!! Did I mention we are in a CITY?!?! Grumble grumble, moan, grumble, humph... /RANT Mark -Original Message- Gerardo Sent: Tuesday, September 18, 2001 08:05 To: Multiple recipients of list ORACLE-L I think you just have to keep trying. Maybe at different times. I experienced the same as you but with the 9i for Linux download. HTH Gerardo -Original Message- Sent: Monday, September 17, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Hi List Have any of you been successful in d/lng 9i for NT from technet ?? I am getting Server not found. Is there any other mirror fromwhich I can d/l ?? TIA Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VeniVas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Deta_default value not getting imported...
Title: Deta_default value not getting imported... We did full export of a database and then imported the same in another database. The issue is that none of the data_default values have been imported. Has anyone encountered this before. Any links, bugs, actions to point to? Oracle: 8.1.7 EXP IMP: 8.1.7 rgds amar
Materialized View/dbms_mview.refresh Question
I have a materialized view created by user A in schema
A. The view consists of simple table joins and union
statements. I want user B to be able to execute the
refresh on the MV using dbms_mview.refresh.
I've granted select on all the tables to user B along
with creating public synonyms for the tables. I've
also granted all privileges on the MV to user B and
granted REWRITE privs to user B.
When I exec dbms_mview.refresh('A.MVIEW_NAME', 'A');
as user B, I get the following error:
ORA-01031: Insufficent privileges
ORA-06512: at SYS.DBMS_SNAPSHOT, line 610
ORA-06512: at SYS.DBMS_SNAPSHOT, line 667
ORA-06512: at SYS.DBMS_SNAPSHOT, line 647
ORA-06512: at line 1
Any thoughts?
Thanks
__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Looking for 24 X 7 Design Considerations
7.3.4.5? Ok, Charlie, now you're too far the other direction. :) Jared Charlie Mengler To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] charliem@mwh. cc: com Subject: RE: Looking for 24 X 7 Design Considerations Sent by: [EMAIL PROTECTED] om 09/17/01 06:35 PM Please respond to ORACLE-L Just so folks do NOT get the wrong idea, let me clarify. Please note I said a production database. It is not THE Production Database; which is still firmly planted in V7.3.4.5. I've taken a few limited activity tablespaces up to 9i to take advantage of 8i features; such as partitioning. I, too would be hesitant to move into Production code that makes use of 9i Bleeding Edge features. However I am perfectly comfortable with moving V7 code onto a tested 9i DB. Since our tests showed a stable DB, I moved directly to 9i to avoid doing multiple upgrades over the next 6 - 12 months. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Internal troublemaker
Hi all, How to ensure our scripts are not changeable by other user, unix and sql script. I remember some unix guru said I need Pro C Can I use embedded Java Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Re: The DBA in the IS organization
I wrote: So what perks if any do you get for being called in on a Saturday?. The longer I hang around in this DBA field the more it seems to be like a vocation ;) Rachel Replied: From: Rachel Carmichael [EMAIL PROTECTED] Date: Mon, 17 Sep 2001 13:07:08 + Subject: Re: The DBA in the IS organization Perks for being a DBA? You jest. If you do your job right, and nothing goes wrong, they don't understand why they need you and why they pay you what they do. If something goes wrong, they get upset because why didn't you know it was going to happen and fix it to begin with? Okay, for real: I get thanks from people when I make their stuff work fast (the best comment from a programmer was Rachel, now it flies like the wind!), thanks from end users when I dig the data out for them or straighten out the mess that the programmers made. And I like what I do. Hhhhm. Rachel seems to me you've found your vocation in life ;) I like to separate perks from vocation, unless of course they happen to be one in the same!!! Now back to my Oracle afternoon prayer book.. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Barry, A while ago, when I wrote a script to do this for a site, I attempted to login with a bogus userid/password and then checked for the Oracle error message. Thereby, eliminating a security hole, and not hugely impacting Oracle by logging in for a simple check. Also, I was poking around Steve Adams's site and came across his script to do this, which is more through. So I would check his site. This link should take to the misc page on his website, then scroll down to the bottom... http://www.ixora.com.au/scripts/misc.htm HTH Chris May Oracle be with you...always -Original Message- Sent: Tuesday, September 18, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RDA from OWS - anyone used it?
Has anyone implemented and used RDA? (It's a diagnostic tool from OWS.) It might be semi-cool ;-) ...Comments? Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Ora-03121
Hi listers , I am getting this error while trying to connect to Oracle Designer2000(1.3.2) on Oracle 8.0.5 -Plattform NT4 : Ora-03121 : No interface driver connected-function not performed Does this thing requires the installation of some Oracle patches Any help would be appreciated ... TIA Gholam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Good/Cheap Backup Agent?
Hi, We're looking for an inexpensive backup agent for our databases. The databases are 8i and are on Sun boxes but we're looking to have the agent/client hosted from an NT box (because it appears to be cheaper that way). What are your recommendations? Do all of the agents work through RMAN these days? Are there any features or caveats I should look for? Thanks! -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Accept statement
Tuesday, September 18, 2001, 1:30:17 PM, you wrote: SH I'm am trying to use an accept statement to grab some info from the user in SH an SQL script, SH and then use that in a subsequent PL/SQL block. I can do the Accept ok, but SH can't sem to SH access the variable onside the block. Can anyone point me in the right SH direction? Can you post the part of your script in which you are doing this? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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-L Digest -- Volume 2001, Number 261
http://pnnonline.org/ ... [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Hi Barry!
We use the Oracle supplied program tnsping
as in the following shell script snippet :
-
#!/bin/sh
PATH=/bin:/usr/bin:/$ORACLE_HOME/bin
export PATH
# get SQL*NET alias from first argument or use ORCL as default
oradb=${1:ORCL}
if $ORACLE_HOME/bin/tnsping $oradb /dev/null 21
then
echo database $oradb is up
else
echo database $oradb is down ( tnsping returned $?)
fi
-
Hope this helps,
Andreas
--
Von: Barry Deevey[SMTP:[EMAIL PROTECTED]]
Gesendet: Dienstag, 18. September 2001 17:45
An: Multiple recipients of list ORACLE-L
Betreff: Determining Oracle status
Hi all,
I am trying to write a script in unix that determines if a specific oracle
instance is available. I'm trying to avoid using the 'ps' command, so I
thought the easiest method would be to connect via sqlplus - If it
connects
its up, if it doesn't then its unavailable. However, the problem is that
when it isn't up, the script hangs and does not return anything - I think
that this is because sqlplus by default gives you 3 attempts to logon, so
even though the logon attempt failed, it is waiting for you to try again,
so
unfortunately I'm not getting a failed return code.
If anybody could tell me how to change this so that it only allows 1 login
attempt before 'kicking you out' or whether there is a better method to
finding out the status of an instance, I would be extremely grateful to
hear
from you.
TIA for any responses.
Best Regards,
Barry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Haunschmidt Andreas VASL/FAS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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:Determining Oracle status
Barry, Do you get the IOUG-A mag? There was a piece of Pro*C code therein (I'm the author) that did exactly what you want, but does not use SQL*Plus. There is also 'oiconnect' that should be in $ORACLE_HOME/bin. Dick Goulet Reply Separator Author: Barry Deevey [EMAIL PROTECTED] Date: 9/18/2001 7:45 AM Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dump Oracle Tables To ASCII/Comma Delimited File ..Summary
Hi All, Here is the summary of all the mails I have recieved to Convert an oracle table into ASCII/Comma delimeted file. 1. Using sqlplus Set head off set pages 1000 spool result.lis Select col1 ||','|| col2 ||','|| col3 from table; spool off or 2. Set colsep , spool result.lis set head off set pages 1000 select * from table; spool off 3. Using Jump.sql from jared site http://www.cybcon.com/~jkstill/util/util_master.html This is a very good utility. 4. Toad also can be used for this Purpose. download from www.toadsoft.com 5. Tabexp is a very good utility that can be downloaded from www.materialdreams.com/product.html Thanks to all who has replied for my qyery. regds deepender -- Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailto:[EMAIL PROTECTED] and delete this mail from your records. --
RE: Determining Oracle status
We tried that but we had times that tnsping would work but the client could
not connect to the database and return data. We changed to a sqlplus call
which read the v$database view. If we could read that, everyone should be
able to connect. That doesn't solve the timeout problem though.
Ron
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L
Hi Barry!
We use the Oracle supplied program tnsping
as in the following shell script snippet :
-
#!/bin/sh
PATH=/bin:/usr/bin:/$ORACLE_HOME/bin
export PATH
# get SQL*NET alias from first argument or use ORCL as default
oradb=${1:ORCL}
if $ORACLE_HOME/bin/tnsping $oradb /dev/null 21
then
echo database $oradb is up
else
echo database $oradb is down ( tnsping returned $?)
fi
-
Hope this helps,
Andreas
--
Von: Barry Deevey[SMTP:[EMAIL PROTECTED]]
Gesendet: Dienstag, 18. September 2001 17:45
An: Multiple recipients of list ORACLE-L
Betreff: Determining Oracle status
Hi all,
I am trying to write a script in unix that determines if a specific oracle
instance is available. I'm trying to avoid using the 'ps' command, so I
thought the easiest method would be to connect via sqlplus - If it
connects
its up, if it doesn't then its unavailable. However, the problem is that
when it isn't up, the script hangs and does not return anything - I think
that this is because sqlplus by default gives you 3 attempts to logon, so
even though the logon attempt failed, it is waiting for you to try again,
so
unfortunately I'm not getting a failed return code.
If anybody could tell me how to change this so that it only allows 1 login
attempt before 'kicking you out' or whether there is a better method to
finding out the status of an instance, I would be extremely grateful to
hear
from you.
TIA for any responses.
Best Regards,
Barry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Haunschmidt Andreas VASL/FAS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: ORA-00600
call support. joe Sirisha wrote: Hi I get this error ORA-00600 when i try to execute a stored procedure. The stored procedure gets compiled perfectly but gives this error at run-time while executing it from a java code. This is what i found in the alert log. Tue Sep 18 04:57:14 2001 Errors in file /usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc: ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707], [1049600], [1], [], [], [] Can someone tell me how to deal with this problem, Thanx, Sirisha. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sirisha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Title: RE: Determining Oracle status tnsping $ORACLE_SID works pretty well... Nick -Original Message- From: Barry Deevey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: Determining Oracle status Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
AW: test schema from prod
Syntax is imp user/pw@instance file=export.dmp fromuser=PORDSCHEMA touser=TESTSCHEMA log=import.log If you call imp help=y you can see all import parameters. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 17. September 2001 19:10 An: Multiple recipients of list ORACLE-L Betreff: RE: test schema from prod import fromuser touser? -Original Message- Sent: Monday, September 17, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate your time. TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
tnsping does not check for database up, its nothing more than a ping to a
listener, they only sure way to see if the database is up is to connect to
it.
and its still that way in 9i.
joe
[EMAIL PROTECTED] 09/18/01 02:40PM
Hi Barry!We use the Oracle supplied program tnsping
as in the following shell script snippet
:-#!/bin/shPATH=/bin:/usr/bin:/$ORACLE_HOME/binexport
PATH# get SQL*NET alias from first argument or use ORCL as
defaultoradb=${1:ORCL}if $ORACLE_HOME/bin/tnsping $oradb
/dev/null 21 then echo "database $oradb
is up"else echo
"database $oradb is down ( tnsping returned
$?)"fi-Hope
this helps, Andreas -- Von:
Barry Deevey[SMTP:[EMAIL PROTECTED]] Gesendet:
Dienstag, 18. September 2001 17:45 An:
Multiple recipients of list ORACLE-L Betreff:
Determining Oracle status Hi all,
I am trying to write a script in unix that determines if a specific
oracle instance is available. I'm trying to avoid using the 'ps'
command, so I thought the easiest method would be to connect via sqlplus
- If it connects its up, if it doesn't then its unavailable.
However, the problem is that when it isn't up, the script hangs and does
not return anything - I think that this is because sqlplus by default
gives you 3 attempts to logon, so even though the logon attempt failed,
it is waiting for you to try again, so unfortunately I'm not
getting a failed return code. If anybody could tell me how to change
this so that it only allows 1 login attempt before 'kicking you out' or
whether there is a better method to finding out the status of an
instance, I would be extremely grateful to hear from you.
TIA for any responses. Best Regards,
Barry.-- Please see the official
ORACLE-L FAQ: http://www.orafaq.com
-- Author: Barry Deevey INET:
[EMAIL PROTECTED] Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public
Internet access / Mailing Lists
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.com-- Author:
Haunschmidt Andreas VASL/FAS INET:
[EMAIL PROTECTED]Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
RE: Accept statement
Hi, Use variable -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Steven Hovington [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:30 AM To: Multiple recipients of list ORACLE-L Subject: Accept statement I'm am trying to use an accept statement to grab some info from the user in an SQL script, and then use that in a subsequent PL/SQL block. I can do the Accept ok, but can't sem to access the variable onside the block. Can anyone point me in the right direction? Thanks in advance. Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Materialized View/dbms_mview.refresh Question
Just solved it...Duh!
as sys
grant alter any materialized view to User_B;
--- mohammed bhatti [EMAIL PROTECTED] wrote:
I have a materialized view created by user A in
schema
A. The view consists of simple table joins and
union
statements. I want user B to be able to execute the
refresh on the MV using dbms_mview.refresh.
I've granted select on all the tables to user B
along
with creating public synonyms for the tables. I've
also granted all privileges on the MV to user B and
granted REWRITE privs to user B.
When I exec dbms_mview.refresh('A.MVIEW_NAME', 'A');
as user B, I get the following error:
ORA-01031: Insufficent privileges
ORA-06512: at SYS.DBMS_SNAPSHOT, line 610
ORA-06512: at SYS.DBMS_SNAPSHOT, line 667
ORA-06512: at SYS.DBMS_SNAPSHOT, line 647
ORA-06512: at line 1
Any thoughts?
Thanks
__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: mohammed bhatti
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
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).
__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Good/Cheap Backup Agent?
Write your own scripts. Not inexpensive considering the labor cost, but highly satisfactory. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Walter K alden14004@ya To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hoo.com cc: Sent by: Subject: Good/Cheap Backup Agent? [EMAIL PROTECTED] om 09/18/2001 02:05 PM Please respond to ORACLE-L Hi, We're looking for an inexpensive backup agent for our databases. The databases are 8i and are on Sun boxes but we're looking to have the agent/client hosted from an NT box (because it appears to be cheaper that way). What are your recommendations? Do all of the agents work through RMAN these days? Are there any features or caveats I should look for? Thanks! -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Good/Cheap Backup Agent?
Go for it! Rman is cheap (free with Oracle) and works well. You can either run it from OEM (Backup Manager) or directly from the rman prompt or using shell scripts. Good luck, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 3:05 PM Hi, We're looking for an inexpensive backup agent for our databases. The databases are 8i and are on Sun boxes but we're looking to have the agent/client hosted from an NT box (because it appears to be cheaper that way). What are your recommendations? Do all of the agents work through RMAN these days? Are there any features or caveats I should look for? Thanks! -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: The DBA in the IS organization
I have done a couple DBA trips to the UK. For food, I always skip the restaurants and goto the pubs, the food has always been fresh and just great!! I usually order the special for the day, just to try different things. As for people, everyone has always been very polite and friendly. On one trip, a buddy and I were trying to figure out on a map how to get from the train station to a hotel. The chap sitting across from us on the train offered to walk us to the hotel. We discovered that we had walked a mile and in the opposite direction that he lives from the train station, so we just had to buy him a beer. I look forward to being forced to goto the UK on another assignment... -Original Message- Sent: Monday, September 17, 2001 5:48 PM To: Multiple recipients of list ORACLE-L As for me, this is my 3rd job as an Oracle DBA. My first job was working for a Porno Company based out of Beverly Hills, CA. It was a small company (130 internal employees and 200 outside employees aka phone actress and actors) that owned the majority of the phone sex lines (over 10,000 lines coming in). As the DBA, I reported to the owner. I supported and worked closely with the developers and network admins. But my major tasks were to automate business practices and to suggest ways to improve perversion efficiency. My Second job was working for a national VAR (value added reseller) company which had strong ties to Sun Microsystems, IBM, HP, SGI, etc. I reported to the Co-owner of the company. My job role was to work closely with the system admins to implement enterprise solutions for major corporations. My current job involves a large international Manufacturing company. As the DBA, I report to the CIO of the company. Each division has a MIS manager. My role is to provide support to each division (which sucks because I have to travel a lot, especially to the UK...no offense to the people of the UK, but the only good thing about the UK that I like are the PUBS!!! The weather, some people and food is another story). My major tasks are to consolidate the companies on a data level, which means I work closely witht the ERP developers. I also make hardware and software suggestions to ease operations. Hope this helps! As far as being with the developers, you will need to be with them regardless, either at the beginning of development to make sure they don't mess up the database or after development to fix the problems that they did mess up. Regards, Satar Please remember that TRUE muslims do not advocate violence. Please do not displace your anger on innocent muslims living in your local area. --- O'Neill, Sean [EMAIL PROTECTED] wrote: From: Farnsworth, Dave [EMAIL PROTECTED] Date: Sat, 15 Sep 2001 05:49:20 -0500 Subject: The DBA in the IS organization I am wondering how my fellow DBA's fit into their IS organization. My situation is this. I was hired just a little over a year ago as a DBA but my official title is network programmer. Except for some job scripting I have not done any coding. I am the only DBA for 5 Oracle databases and 4 SQL Server installations. Currently my boss is the head of development. I work with the developers and with the network admins equally. I sometimes feel a bit of a conflict with me being under the developers. I have been thinking about approaching the VP of IS about having me be under him rather than being under development. I feel I need to have equal footing with the development managers and with the network admins. Right now I am kind in limbo with no real authority. So anyway, I am just wondering where you fit in your organization and what is the appropriate place for the DBA. And yes I got called into work. Sucks to be me today. :o) FWIW, I as the only DBA report directly to the IS Manager. We don't do much in-house development preferrring to purchase OTS solutions. We have 2 folk managing the Network and Server Admin one of whom reports directly to the IS Manager. We have some information analysts who also report directly to the IS Manager. We're an NT house. I have local admin rights on servers which host Oracle databases 6 in all with 10 databases. I share an office with the NT admin folk. I would have thought that you being separate from developers from a reporting point of view would be an advantage. Being amoung them is an advantage in that you might get to raise matters of concern before they go too far down the line. I would think you'd need autonomy to defend amoungst other topics issues relating to database performance potentially with developers and/or adminstrators. So what perks if any do you get for being called in on a Saturday?. The longer I hang around in this DBA field the more it seems to be like a vocation ;) Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA
Deploying middle-tier on unix.
We use 3-tier architecture to run our application, the middle tier being an OAS. How many of you have the middle tier on UNIX platform? I want to know the pros and cons of having my executables kept on unix server which are then being accessed from a windows based client. Most of the links I have visited talk about middle tier being on an NT machine. I would appreciate any kind of information on this. rgds amar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amar Kumar Padhi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Barry, Depending on your shell, start a timer (korn supports TMOUT). If you don't get a valid response within N seconds (trap the signal), you've got a problem. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Barry Deevey Barry.Deevey@se To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fas.co.uk cc: Sent by: Subject: Determining Oracle status [EMAIL PROTECTED] 09/18/2001 10:45 AM Please respond to ORACLE-L Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Lots and lots of redo logs
Out of curiosity and as a test I scrubbed my 16Mb RAID1 array and set it up again with 5 x 50Mb redo groups. I ran the following script to generate lots of redo: begin for i in 1..1500 loop insert into test_table values (mod(i,10)); delete from test_table where anumber = (mod(i+1,10)); commit; end loop; end; ARCHIVELOG mode was on and the archive destination (on another disk) was initially empty. There were 239 log switches and the test completed in 2 hours 56 minutes. I then added a further 250 50Mb redo groups, cleared the archive destination and ran the test again. Again it completed in exactly 2 hours 56 minutes, this time 240 log switches (difference of 1, I guess due to whereabouts in the first log it was when the test started). v$session_wait shows permanent log file parallel write for LGWR while the test runs. Any suggestions why I failed to see any slow down when I (almost) filled the disk with redo groups? (This server wasn't doing anything else and the time of the test). The RAID1 array had a Linux ext2 filesystem on it and I had disabled the write cache. Thanks again, - Bill. At 08:40 14/09/01 -0800, you wrote: !! Please do not post Off Topic to this List !! Generally IDE shows this problem much more than scsi, but on IDE you can see as much as 50% performance degrading, I haven't really tested the difference. If you put the logs on, then fill the rests of the disks with a empty file of that size, you can make sure that the end of the disk is filled with junk and the logs will never pull blocks from that area. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 14, 2001 12:15 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! How big a performance issue is the location of the log file on disk? Even if I create the minimum of 2 archive log groups, how can I be sure the controller hasn't put these on the outer platters anyway? Since these are log files then the writes will be sequential anyway (does that make a difference?) - showing my hardware ignorance here! As you said: But in my opinion here is my priorities. 1. Recoverability 2. Performance I would have thought that having lots of archive log groups (normally) not overwritten for a few days in addition to properly archived logs would boost my recoverability with negligible impact on performance. (Incidentally the MAXLOGFILES maximum value is 255, on Linux anyway). Thanks - Bill. At 07:10 14/09/01 -0800, you wrote: !! Please do not post Off Topic to this List !! It is very common for people to see all that free space and want to fill it. Avoid the desire, fill it with a blank file. Disks are cheap and if you store things on the outer platters performance will suffer. Redo logs and other things in oracle waste disk space as drives get bigger, it is unavoidable. But using the space for something totally defeats the purpose of good configurations. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 14, 2001 10:35 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hi Thanks. That's a very good point. I agree that ARCHIVELOG mode will be needed. However, I still have this big disk just for redo logs, so I'm tempted to fill it anyway. This will be a sort of supplementary backup in case the archive disk (+ database disks) crash before the backup. Of course it is only sort of because, as you say, a runaway process will cycle the logs if it generates lots of redo. However, this seems better use of the disk space than just having a few log groups and leaving the rest of the array empty and unused. Unless there are any other implications? Thanks - Bill. Hi Yes you can untill the day that you have this runaway process that creates 20Gb of redo and than crashes your database 5 minutes before the daily offline backup should kick in. But you are only mirroring, why not put your database in archivelogmode. You do not have so much redo per day that your disks/archiver can't handle it. Now if your archive directory is full oracle won't crash, but just stop untill you free up some space (I believe this is the behaviour anyway). Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan
Re:Determining Oracle status
Dick, I haven't seen oiconnect since v7x. I used to use it (as we've discussed here previously, tnsping and grepping processes for smon, pmon and the like won't provide you with a definitive answer for a variety of reasons), but have since switched to actually logging into the database via a script, running a stored procedure and logging out. If it fails, I'm alerted. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re:Determining Oracle status om 09/18/2001 01:50 PM Please respond to ORACLE-L Barry, Do you get the IOUG-A mag? There was a piece of Pro*C code therein (I'm the author) that did exactly what you want, but does not use SQL*Plus. There is also 'oiconnect' that should be in $ORACLE_HOME/bin. Dick Goulet Reply Separator Author: Barry Deevey [EMAIL PROTECTED] Date: 9/18/2001 7:45 AM Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: ORA-00600
What version of Oracle are you running? I've seen this ORA-00600 mentioned in two different patchset fixes (but I guess the bugs weren't public, 'cause I couldn't view any details on them, so I can't be sure that the other arguments in the 600 are referring to the same type of error you're having). Hopefully these might help you narrow it down some so that maybe you can figure out some kind of workaround for the interim. Bug 590783 (fixed in 8.0.4.x patch sets) -- occurred when dereferencing large VARRAYS Bug(s) 1610791, 1620278 (fixed in 8.1.7.x patch sets) -- occurred when selecting from an IOT via a secondary index Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, September 18, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Hi I get this error ORA-00600 when i try to execute a stored procedure. The stored procedure gets compiled perfectly but gives this error at run-time while executing it from a java code. This is what i found in the alert log. Tue Sep 18 04:57:14 2001 Errors in file /usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc: ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707], [1049600], [1], [], [], [] Can someone tell me how to deal with this problem, Thanx, Sirisha. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sirisha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Jeffery Stevenson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Alternatives to roles in procedures?
Surely, my good man, you jest! I'm just happy that I convinced peoples that SELECT ANY TABLE, DELETE ANY TABLE, etc were BAD for app accounts. That's why I need to do all the GRANTs. Waiting for that first accidental drop of a SYS object... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, September 17, 2001 15:52 To: [EMAIL PROTECTED] Cc: Jesse, Rich Short answer: No When using procedures to allow access to a schema, you really should consider using 3 schemas, not 2. The C schema gets execute access to the procs in Schema B. No users will have access to the tables this way. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DB Names in multiple oracle installs
Title: Message Sujatha: I've never done this myself, but I would think if you set us a second listener on a different port, it should work from a SQL*Net point of view. However, you'd probably have problems in the ORATAB file and in the local environment itself with things like svrmgrl. On NT I'm sure it's not possible as the names of the db services would be identical. So, I don't think it's possible from every aspect. But I'm curious now if someone else has better ideas than I. Jon Walthour -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 9:05 PMTo: Multiple recipients of list ORACLE-LSubject: DB Names in multiple oracle installs Hi, Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7. Thanks Sujatha
time synchronization
Hi List, we have about 2 min difference between the time on our db server and the rest boxes in our network. Actually, the time on DB server is 2min slow than the network time.It causes real pain to us. I think about the following order of time synchronization: 1. Normal shutdown the DB and listener 2. immediate cold backup 2. setup time synchronization on the unix level 3. startup the DB and listener 4. Normal shutdown DB and listener 5. immediate cold backup 6. startup DB and listener Is this correct ? Any possible troubles? Any good links? Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Here's mine. Substitute 'user/pass' for 'internal' when running against external
instances...
if sqlplus -s EOF | grep -q XOK
internal
select dummy||'OK' from dual;
EOF
then echo Oracle Instance ${ORACLE_SID} is up.
else echo Oracle Instance ${ORACLE_SID} is down.
fi
-Original Message-
Sent: Tuesday, September 18, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I am trying to write a script in unix that determines if a specific oracle
instance is available. I'm trying to avoid using the 'ps' command, so I
thought the easiest method would be to connect via sqlplus - If it connects
its up, if it doesn't then its unavailable. However, the problem is that
when it isn't up, the script hangs and does not return anything - I think
that this is because sqlplus by default gives you 3 attempts to logon, so
even though the logon attempt failed, it is waiting for you to try again, so
unfortunately I'm not getting a failed return code.
If anybody could tell me how to change this so that it only allows 1 login
attempt before 'kicking you out' or whether there is a better method to
finding out the status of an instance, I would be extremely grateful to hear
from you.
TIA for any responses.
Best Regards,
Barry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Glenn Travis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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).
Need assistance with a 'VIEW'.
I have been given the nice task of creating a view of some data in our database. This doesn't seem like a major task, but after 2 days of work, I am stumped. Given table 'table1' code1, code2, date, value1, value2 I need to produce a view showing code1, code2, sum(value1), sum(value2) where date 'user input date' I have not been able to get the view to prompt for the date to limit the sum by. Specifics: Oracle RDMBS 7.3.4 Server: Unix What else can I say, but I am totally stumped. HELP! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: Need Hardware advice under Linux
Title: OT: Need Hardware advice under Linux Hi List, I want so setup new oracle server (for developement) under linux. I will install RedHat 7.1. What I like to know is what processor should I choose AMD Athlon 1,4 Ghz or Intel 1,5 Ghz, I would prefer AMD. Are there any know problems with AMD and RedHat 7.1? TIA Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de
Need assistance with a 'VIEW'.
I have been given the nice task of creating a view of some data in our database. This doesn't seem like a major task, but after 2 days of work, I am stumped. Given table 'table1' code1, code2, date, value1, value2 I need to produce a view showing code1, code2, sum(value1), sum(value2) where date 'user input date' I have not been able to get the view to prompt for the date to limit the sum by. Specifics: Oracle RDMBS 7.3.4 Server: Unix What else can I say, but I am totally stumped. HELP! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Copy Oracle's binary.
Your were right. If you want to upgrade the copied Oracle, you would have problem. What we didwas move the executables from environment to environment, so we only do one time install on development machine, and copy the executables to all others (test and product). Jun -Original Message-From: Kimberly Smith [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 7:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Copy Oracle's binary. Have you upgraded those databases? Its no longer possible to just copy ORACLE_HOME and expect to be able to upgrade it. That being said, I never did bother to identify the other directories as I felt it was just as easy to install the software. You could do a full system copy though. -Original Message-From: Feng, Jun [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 3:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Copy Oracle's binary. Sure. We have done that many times. Jun -Original Message-From: Thanh-truc Nguyen [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 6:31 PMTo: Multiple recipients of list ORACLE-LSubject: Copy Oracle's binary. Hello, I've two machines (with the same unix's configuration on Sun Solaris). On hasOracle 8.1.7. installed and a database. Do you think it'spossible to copy Oracle's binary and the database onUnix level to the new serveur instead of installing and cloning the db ? Thank you very much. Thanh-truc Nguyen
RE: 9i D/l
Been getting that error for a long time when I tried getting the Linux version. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 2:15 AM To: Multiple recipients of list ORACLE-L Hi List Have any of you been successful in d/lng 9i for NT from technet ?? I am getting Server not found. Is there any other mirror fromwhich I can d/l ?? TIA Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VeniVas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Looking for 24 X 7 Design Considerations
Only a little over 4 years here and a sys admin for 7, but I completely agree 100%. What a lot of people neglect is the bugs that he mentioned, yeah it may test well under development, or under certain testing, and may even run fine for a while even months, but when one of those new bugs come up out of no where, and no one is familiar with it, it can cripple you. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 17, 2001 8:55 PM To: Multiple recipients of list ORACLE-L Sure i've hit the undo management bug that wiped out my SAND box database just last week, db got hung up, had to shutdown abort and then redo logs/undo management tablespace couldnt be mounted so it was screwed. Sorry but I've been an oracle dba since version 5 almost 10 years ago and my personal opinion is i'd never put a x.0 version of oracle in production mode before its been out for 12 months. joe Paul Baumgartel wrote: I agree with you, Charlie. The fact that an Oracle release is relatively new doesn't mean it's riddled with bugs (although that was once the case); neither does the fact that it's been out for 12 months or so mean that there aren't any show-stoppers lurking within. I've made the case before that 9i should be considered more as if it were 8.2. Yes, it's new, and yes, you should test and verify carefully, but it's not as large a leap as going from Oracle7 to Oracle8, for example. Paul Baumgartel --- Charlie Mengler [EMAIL PROTECTED] wrote: I guess then I'm nutso, because I have a 9i DB in production. Any independently verifiable substantiation for your claim would be welcomed. This 9i instance has had flawless performance for the last two months; which is how long it has been in production. Original Message Subject: RE: Looking for 24 X 7 Design Considerations Date: Mon, 17 Sep 2001 12:40:18 -0800 From: JOE TESTA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Anyone contemplating upgrading anything more important than a sandbox database to 9i is nutso. 9i is ready for development playing around in 6-8 months, production no earlier than 12-18 months is my estimation. joe __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT RE: The DBA in the IS organization
*How* is this related to oracle? There is an OFF-TOPIC list for this list for these kinds of posts.. Please keep them there. Michael B, Who is not afraid to ask people to keep off-topic stuff off this list. At 07:46 AM 9/18/01 -0800, Grabowy, Chris wrote: I have done a couple DBA trips to the UK. For food, I always skip the restaurants and goto the pubs, the food has always been fresh and just -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 8.1.7.2.1 patch for hp-ux 64 bit
I have no problem to download this patch for AIX. I used winzip to unzip it. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 interpret Alert.Log Trace files...
Sometimes you can resolve ORA-600 messages, there are a few documented ones (not by oracle of course). But generally I would say it to be very good practice to call Oracle and have a tar in place for it, they do very little to document ORA-600 messages, there are many combinations. Although, I must say, Metalink occasionally does come up with some good results, granted the message may not have the same numbers, but reading the description you may find an exact match of what your doing and get in the area. But it is hit or miss. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, August 24, 2001 3:22 PM To: Multiple recipients of list ORACLE-L Denmark, I am not an expert but from everything I have read is that when you get ORA-00600 errors you should probably open a TAR with Oracle. It may not be much but why take the chance. I would be interested in that tuning script that you downloaded. Cound you send it to me directly or let me know where you downloaded it from? Thanks, Dave -Original Message- Sent: Friday, August 24, 2001 1:53 PM To: Multiple recipients of list ORACLE-L Hi DBA's I'm currently monitoring the Oracle SIDALRT.LOG and *.TRC files in $ORACLE_HOME/RDBMS80/TRACE on our production Oracle 805 database. I've observed the following files being used by Oracle in that directory: SIDP000.TRC 5MB SIDP001.TRC 5MB SIDP002.TRC 5MB SIDP003.TRC 5MB SIDP004.TRC Current Trace file Other trace files exist in the directory with the following naming convention: Ora9.trc One is generated everytime I run the BACKUP CONTROLFILE TO TRACE command. However, I notice that each Ora9.trc generated with the CONTROLFILE TRACE has other trace dumps in it as well from previous events. For example, the last CONTROLFILE Trace written (Ora00479.trc) (8 Aug 2001 8:03 AM) has this entry at the beginning: Dump file e:\orant\rdbms80\trace\ORA00479.TRC Tue Aug 07 16:38:30 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: prod Redo thread mounted by this instance: 1 Oracle process number: 38 pid: 1df *** 2001.08.07.16.38.30.976 *** SESSION ID:(28.1790) 2001.08.07.16.38.30.945 FATAL ERROR IN TWO-TASK SERVER: error = 12571 *** 2001.08.07.16.38.30.976 ksedmp: internal or fatal error - Call Stack Trace - ... ...Dump file e:\orant\rdbms80\trace\ORA00479.TRC Fri Aug 24 08:03:32 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: prod Redo thread mounted by this instance: 1 Oracle process number: 11 pid: 1df *** SESSION ID:(12.39) 2001.08.24.08.03.32.433 *** 2001.08.24.08.03.32.433 # The following commands will create a new control file and use it # to open the database. # Data used by the recovery manager will be lost. Additional logs may # be required for media recovery of offline data files. Use this # only if the current version of all online logs are available. STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE ORCL NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 618 LOGFILE GROUP 1 'E:\ORANT\DATABASE\LOGPROD1.ORA' SIZE 1M, GROUP 2 'E:\ORANT\DATABASE\LOGPROD2.ORA' SIZE 1M DATAFILE 'E:\ORANT\DATABASE\SYS1PROD.ORA', 'E:\ORANT\DATABASE\RBS1PROD.ORA', 'E:\ORANT\DATABASE\USR1PROD.ORA', 'E:\ORANT\DATABASE\TMP1PROD.ORA', 'E:\ORANT\DATABASE\INDX1PROD.ORA', 'E:\ORANT\DATABASE\IRDBASEPROD.ORA', 'E:\ORANT\DATABASE\ROLL1PROD.ORA' ; # Recovery is required if any of the datafiles are restored backups, # or if the last shutdown was not normal or immediate. RECOVER DATABASE # All logs need archiving and a log switch is needed. ALTER SYSTEM ARCHIVE LOG ALL; # Database can now be opened normally. ALTER DATABASE OPEN; ** ** Now to get to my questions. I'm noticing the following entries in the PRODALRT.LOG. Below is a paste of the entries logged since this morning: Completed: alter tablespace SYSTEM end backup Fri Aug 24 08:03:26 2001 Thread 1 advanced to log sequence 3880 Current log# 2 seq# 3880 mem# 0: E:\ORANT\DATABASE\LOGPROD2.ORA Thread 1 advanced to log sequence 3881 Current log# 1 seq# 3881 mem# 0: E:\ORANT\DATABASE\LOGPROD1.ORA Fri Aug 24 08:03:31 2001 alter database backup controlfile to 'CTL1PROD.8am' Fri Aug 24 08:03:32 2001 Completed: alter database backup controlfile
OT: Web Logic Server
Title: OT: Web Logic Server Greetings to all. Are there any Web Logic Guru's out there? Does anyone know of any forums/lists or url's that deal with web logic issues. Searching google seems to only point to bea's site. Anyone out there running 4.5.1? We're having some complications here that I just can't figure out and searching and reading from docs.bea.com isn't helping. Thanks
RE: any body come across, decreasing db_block_size.
Yes, it would work both ways. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 7:25 AM To: Multiple recipients of list ORACLE-L Hi lists have any body come across, decreasing db_block_size. we know that the db_block_size can be increased. to do this, usual way is export full db. create new db with new increased db_block_size and import the data into it. will this work for decrease db_block_size. my present size is 8 k now that should be decreased to 4K srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Barry:
I've seen responses saying to use TNSPING, but all that does is tell you if
the listener is running on the destination machine. If the listener is up
and no databases are up you will still get a positive response from TNSPING.
So, here's what we do. This ksh function snippet requires that your
remote database be defined in your TNSNAMES.ORA file. This function
attempts
to login with a completely invalid user id and password. If Oracle returns
a ORA-01017 (invalid username/password; logon denied), then the database
is available. Any other message and the database is not available.
I didn't write this, but I use it a lot.
Cheers,
Mike
#---
IsTheDatabaseUp()
{
STAT=`sqlplus -silent EOF
dumusr/dumpass@$1
exit
EOF`
echo ${STAT} | grep ORA-01017 /dev/null 21
if [ $? = 0 ]
then
DBUP=T
echo `date` (: $1 UP ${OUTPUT}/logs/${BASEFILE}.log 21
else
DBUP=F
echo `date` (: $1 DOWN ${OUTPUT}/logs/${BASEFILE}.log 21
fi
return
}
#---
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304
-Original Message-
Sent: Tuesday, September 18, 2001 8:46 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I am trying to write a script in unix that determines if a specific oracle
instance is available. I'm trying to avoid using the 'ps' command, so I
thought the easiest method would be to connect via sqlplus - If it connects
its up, if it doesn't then its unavailable. However, the problem is that
when it isn't up, the script hangs and does not return anything - I think
that this is because sqlplus by default gives you 3 attempts to logon, so
even though the logon attempt failed, it is waiting for you to try again, so
unfortunately I'm not getting a failed return code.
If anybody could tell me how to change this so that it only allows 1 login
attempt before 'kicking you out' or whether there is a better method to
finding out the status of an instance, I would be extremely grateful to hear
from you.
TIA for any responses.
Best Regards,
Barry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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).
Info request for installing Ora 7.3 on AIX 4.1
Hi Dba's, in my company they told me to create a DB on an IBM AIX box. I'm new on the AIX environment (I come from VMS) and I have only found the Oracle installation manual (Oracle7 Installation and Configuration Guide for IBM RS/6000 ) that seems to me a little confusing. There is someone, experienced in these tasks, that can suggest me some more practical hints to accomplish the task? ( a check-list or a document or a link to a document; after the creation of DB I have also to import a production DB ). Many thanks, Francesco -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Resources for Gateway to MQ Series
Good morning, I am investigating Procedural Gateway for IBM's MQ Series. Documentation seems to be hard to find.Can anyone suggest a resource (links, books, etc) that would help in this area? Thanks, Mike
Re: Good/Cheap Backup Agent?
I neglected to mention that we're trying to backup to tape. I'm not sure what is involved with configuring a media manager for Oracle that will allow Rman to work with a tape drive but it would seem to me at that point I'm into a 3rd party solution anyway. Yes? No? What does it take to get a tape drive to work with RMAN? If a 3rd party solution is better, then I'm back to inquiring about an inexpensive, but useful, solution. Thanks. -w --- Ruth Gramolini [EMAIL PROTECTED] wrote: Go for it! Rman is cheap (free with Oracle) and works well. You can either run it from OEM (Backup Manager) or directly from the rman prompt or using shell scripts. Good luck, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 3:05 PM Hi, We're looking for an inexpensive backup agent for our databases. The databases are 8i and are on Sun boxes but we're looking to have the agent/client hosted from an NT box (because it appears to be cheaper that way). What are your recommendations? Do all of the agents work through RMAN these days? Are there any features or caveats I should look for? Thanks! -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Don't know how to change it to only 1 login attempt. But I would do a select sysdate from dual; after connect via sqlplus. This way if the 1st login failed, the SQL statement will cause the next two attemt fail as well and sqlplus will exit. Richard Ji [EMAIL PROTECTED] 09/18/01 11:45AM Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: truncating snapshots
Henry, OK, I think I see what you're trying to accomplish. By truncating the snapshot between refreshes, the refresh is essentially populating the snapshot with only the changed rows from the master site. Probably not supported, but I can't see that it would cause any real problems. The way the refresh mechanism works, the missing rows on the snapshot site shouldn't be a problem. I see a couple of potential problems, however. 1. The refresh will pull over all changed rows on the master site, in your case inserts AND updates. So if a row does get updated on the master site, then it will get refreshed to the snapshot site and your counts will be off since you'll be treating the update of an existing row as a newly inserted row. It all depends on how critical the numbers are for the developers, because I can assure you it's only a matter of time before someone updates rows on a table that should only have inserts ;) 2. If a fast refresh fails this requires that the next refresh is a complete refresh, or the snapshot is recreated, so you will not have a way of getting just the set of changed rows. Your procedure will need to be able to detect this and perform the joins against the entire table again. In the long run you're probably much better off developing your own trigger to populate another table or setting a flag, as you mentioned. Just because it works today doesn't mean that it will work in a newer release if they change the refresh mechanism. HTH, -- Anita --- Henry Poras [EMAIL PROTECTED] wrote: Guess I wasn't too clear. Here's the scoop (there is probably a much easier way to do this, but I just can't get there from here). There is a 10million row table on a remote database. Each week, there is a change in about 5-10,000 rows (inserts). Currently this table is brought over to a local database. A convoluted query is then run to keep our developers happy and the result set is entered into another table. The query, though convoluted, does not use any aggregate functions, just a mess of joins. Right now this query is run on the complete 10 million row table brought over from the remote database. What I would like to do is to run the query on just the new rows, appending this result to the existing data. Since the snapshot log used for a fast refresh already keeps track of this for me I thought it might be a nice way to go. (I guess I could always flip a flag field, but why do extra work if Oracle already does it for me?) So my plan was to create a procedure which will manually take a fast refresh, run the query, check for success, truncate the table underlying the snapshot view. Since the underlying structure is just a table, and the master log data transfer is strictly in one direction, it looks like it should work, but are there any gothchas? It seems to be OK on a test system. Thanks again. Henry -Original Message- Sent: Sunday, September 16, 2001 9:38 AM To: [EMAIL PROTECTED]; Henry Poras Henry, I'm not sure what you're trying to accomplish by truncating the snapshot. The whole point of the refresh process is to keep the snapshot in sync with the master site. Presumably you are doing a CTAS off of the snapshot to do your manipulations, so what is the point in truncating the snapshot? I don't have a db handy to test whether Oracle detects that the snapshot has been truncated and does a complete refresh, but if the snapshot is very large it would probably be faster to drop and recreate it than to do a complete refresh. A more detailed explanation of the process would help. HTH, -- Anita --- Henry Poras [EMAIL PROTECTED] wrote: !! Please do not post Off Topic to this List !! I need to move the changes in a table from one database to another. It seemed that fast snapshots would be a good way to do this as the database will automatically keep track of the changes for me. The question is that once I move the data to the snapshot side, I need to manipulate it, move it into another table, and start the cycle again. This means truncating the snapshot between refreshes. I tried this on a test system and it seesm to work, but I don't think Oracle supports it. I don't want updatable snapshots as this is strictly one way movement of data. Has anyone else tried this? Are there any potential problems? I think I am just truncating a table underlying the snapshot view so I don't see what could go wrong. Thanks. Henry __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet
RE: ORA-00600
Call 1-800-223-1711, give them your CSI and tell them that I sent you. -Original Message- From: Sirisha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 2:25 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00600 Hi I get this error ORA-00600 when i try to execute a stored procedure. The stored procedure gets compiled perfectly but gives this error at run-time while executing it from a java code. This is what i found in the alert log. Tue Sep 18 04:57:14 2001 Errors in file /usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc: ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707], [1049600], [1], [], [], [] Can someone tell me how to deal with this problem, Thanx, Sirisha. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sirisha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
## 7.3.4 to 8.1.6 Migration issue
I am migrating from 7.3.4 to 8.1.6 (Enterprise Edition) on Solaris 2.8 Before running the migration I took all the tablespaces except SYSTEM and Rollback offline as recommended. When I issued Alter database open resetlogs; I got the following message for almost every file in the database: File #3 is offline, but part of an online tablespace. Successfully brought file #3 online. Can anyone explain this error please? Oracle support is saying that all the files should have been offline, and if not the migration must be restarted. TIA!! Stephen Warkentien Senior Database Administrator, Information Technology Northrop Grumman Guidance and Control Systems Division 5500 Canoga Avenue M/S W91 Woodland Hills CA 91367-6698 818-715-2860 voice 818-715-2617 FAX mailto:[EMAIL PROTECTED] http://sonworshipper.net/techpage.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Warkentien, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Perl code example
I'm looking for a Perl example passing parameters.
The code below has the userids and passwords hardcoded in clear text in the
system line, parms 3 and 5 (five lines from the bottom), and the Oracle sid
is hardcoded also. The code has to be changed to 1) read .pwd1 and .pwd2
files containing the passwords, and set a literal for the SID and
substitute it at in the code.
Linda,
Here's a cheap lightweight password server.
Put the files pwd.pm and pwd.pl into a directory
and try as is.
Follow the example of the template in pwd.pm and fill
in with your own wervers/instances/usernames.
Copy the file 'pwd.pm' to some secure location, and change
the line use lib './ to use lib 'full_path_to_pwd.pm.
You can cut and paste pwd.pl into your code.
When 'Perl for Oracle DBA's' comes out ( or whatever we
eventually call it it will have a network password
server in it, with encrypted transmissions.
This one should suffice though.
Jared
PS. the power of Perl demonstrated. this took 30 minutes. :)
pwd.pl
#!/usr/bin/perl
use lib './';
use pwd;
use Getopt::Long;
my %optctl;
GetOptions( \%optctl,
username:s,
instance:s,
server:s,
z|h|help = \$help
);
if ( $help ) {
usage();
exit 1;
}
$optctl{server} || do { usage();exit 2};
$optctl{instance} || do { usage();exit 3};
$optctl{username} || do { usage();exit 4};
my $password = pwd::password(
$optctl{server},
$optctl{instance},
$optctl{username}
);
print Password: $password\n;
sub usage {
print qq{
pwd.pl
--server
--instance
--username
};
}
h
pwd.pm
package pwd;
$PKG = pwd;
=head1
stuff between '=head1' and '=cut' is comments
here's an example
my %passwd = (
server = {
instance = {
username = 'password',
username = 'password'
}
}
);
=cut
%passwd = (
venus = {
db1 = {
system = 'foxtrot',
sys = 'over_the_hedge'
},
db2 = {
system = 'user_friendly',
sys = 'gpf-comics'
}
},
mars = {
db1 = {
system = 'ubersoft',
sys = 'get_fuzzy'
},
db3 = {
system = 'schlock',
sys = 'mercenary'
}
}
);
sub password {
my ( $server, $instance, $username ) = @_;
use Carp;
$server || croak Please specify server in $PKG\n;
$instance || croak Please specify instance in $PKG\n;
$username || croak Please specify username in $PKG\n;
$passwd{$server}{$instance}{$username};
}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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).
sizeiof table!!!
Hi gurus, I need get the size in bytes of any table!!! thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
List of changed objects in the DB
Hi all, is it possible to identify only those objects that have changed since a given date? Wait ... I know last_ddl_timestamp but we would like to EXCLUDE stored code which has been recompiled and INCLUDE only those procedures/ functions/ packages that were created. any ideas? TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Need assistance with a 'VIEW'.
William, Views can't prompt the User for values. Maybe a stored function or procedure would be better? An application interface could store a User-provided Date in a public packaged variable, which could be referenced in the Where clause of the view. Do you want to Group By just Code1,Code2 or Group By Code1,Code2,Date? In other words, do you want just one resultant row representing the aggregate of all rows with Date InputDate, or a resultant row for every Date? We need more info. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Rogge Sent: Tuesday, September 18, 2001 10:47 AM To: Multiple recipients of list ORACLE-L I have been given the nice task of creating a view of some data in our database. This doesn't seem like a major task, but after 2 days of work, I am stumped. Given table 'table1' code1, code2, date, value1, value2 I need to produce a view showing code1, code2, sum(value1), sum(value2) where date 'user input date' I have not been able to get the view to prompt for the date to limit the sum by. Specifics: Oracle RDMBS 7.3.4 Server: Unix What else can I say, but I am totally stumped. HELP! -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
I don't how to stop after 1st failed attempt, but here is a script that I use to check if database is up or not. #!/usr/bin/ksh # # dbcheck : Script to check if datbase is up and accessible. #It tries to connect via SQL*Net (Net8) using a non-existing userid and password. # # Author : Kirti Deshpande #--- echo Enter Name of the Database SID to check if it is accessible read DB sqlplus -s EOF /tmp/$$.1 whenever sqlerror exit aaa/aaa@$DB exit; EOF egrep 'ORA-121|ORA-01034' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is _NOT_ Accessible\n else grep 'ORA-01017' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is UP and Accessible\n else echo - '$DB' is _NOT_ Accessible\n fi fi rm /tmp/$$.1 # --- End of File HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Barry Deevey [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Subject: Determining Oracle status Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Turning off output when running pl/sql
Just SET FEEDBACK OFF.
SQL set feedback off serveroutput on size 2
SQL begin
2 dbms_output.put_line('Foo');
3 end;
4 /
Foo
--- Steven Hovington [EMAIL PROTECTED] wrote:
Hi,
I'm running a block of PL/SQL in SQL Plus (8.1.7), and when its
completed
it says the usual:
PL/SQL procedure successfully completed.
at the end.
I'm spooling the output of the PL/SQL block to a file using
dbms_put.put_line
but I want to get rid of the above line. Anyone know how I can do
this?
Thanks in advance,
Steven H.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Hovington
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
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).
__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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:Accept statement
Steve, Is that 'inside the block' or 'outside the block'? I assume inside. therefore try: accept var_a char prompt 'Insert your variable' declare local_var varchar2(100) := var_a; begin end; / Dick Goulet Reply Separator Author: Steven Hovington [EMAIL PROTECTED] Date: 9/18/2001 9:30 AM I'm am trying to use an accept statement to grab some info from the user in an SQL script, and then use that in a subsequent PL/SQL block. I can do the Accept ok, but can't sem to access the variable onside the block. Can anyone point me in the right direction? Thanks in advance. Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Looking for 24 X 7 Design Considerations
Man, that was one of their most stable releases. Missing some nice features mind you. I wish I could bring one of my databases up to that level. I have one on a very buggy release of 7.3.3 but the vendor application that runs on it is not supported higher then that. -Original Message- Sent: Tuesday, September 18, 2001 10:45 AM To: Multiple recipients of list ORACLE-L 7.3.4.5? Ok, Charlie, now you're too far the other direction. :) Jared Charlie Mengler To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] charliem@mwh. cc: com Subject: RE: Looking for 24 X 7 Design Considerations Sent by: [EMAIL PROTECTED] om 09/17/01 06:35 PM Please respond to ORACLE-L Just so folks do NOT get the wrong idea, let me clarify. Please note I said a production database. It is not THE Production Database; which is still firmly planted in V7.3.4.5. I've taken a few limited activity tablespaces up to 9i to take advantage of 8i features; such as partitioning. I, too would be hesitant to move into Production code that makes use of 9i Bleeding Edge features. However I am perfectly comfortable with moving V7 code onto a tested 9i DB. Since our tests showed a stable DB, I moved directly to 9i to avoid doing multiple upgrades over the next 6 - 12 months. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Alternatives to roles in procedures?
Interesting! However, if I had shown a real-world example, I think it would've poked a hole in your excellent idea. Add schema C (and D and E) onto this example that schema B also needs to access. Ain't no way in hell the devs are gonna rewrite all of their code to accommodate Jeff T's environment, either. Thanks for the suggestions, but I'm looking at the brute force method, methinks. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: rm -rf /bin/laden -Original Message- Sent: Monday, September 17, 2001 21:55 To: Multiple recipients of list ORACLE-L um, create the procedures in schema A and grant execute to schema B? removes the need for direct grants on the tables. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Alternatives to roles in procedures? Date: Mon, 17 Sep 2001 12:30:24 -0800 So, there we are, in 8.1.7 on HP/UX 11.0. We have several dozen tables in schema A that need to be accessed from procedures in schema B. We had previously been using a role to grant access to these tables but now with the procedures, this ain't an option. Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc on each table to schema B? TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Use sqlplus internal, although this goes away with 9i Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RDA from OWS - anyone used it?
Steve, I've used it a couple of times on NT against a test instance. It seemed to produce some useful information re wait events, tablespace sizings etc but probably nothing that you wouldn't be collecting anyway. It does however put them into a nice html report. Would be useful I imagine for Oracle support to ensure that who they are talking to can provide them with the information they want. I also will be interested in other's comments. Bruce Reardon -Original Message- Sent: Wednesday, 19 September 2001 5:30 Has anyone implemented and used RDA? (It's a diagnostic tool from OWS.) It might be semi-cool ;-) ...Comments? Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Determining Oracle status
Check out the following script. *** SCRIPT STARTS HERE* #!/usr/bin/sh ### # # Auther : Raj Sakthi # # Modification History: # 02/23/01: Network Connectivity Checking was added . # # *** THIS SCRIPT CHECKS FOR THE AVAILABILITY OF INSTANCE ALONG WITH THE # *** NETWORK CONNECTIVITY # # Usage : Pass SID as parameter. # Example : sid_run orcl # export CHECK_CONNECT=$$.CHECK_CONNECT export READY=$$.ready SID=$1 rm -f $READY print connect a/aa@$SID host touch $READY exit | sqlplus /nolog $CHECK_CONNECT # # Next we use a timer to check the sqlplus hanging. # ((timeout = 60)) while ((timeout -= 1)) [[ ! -r $READY ]] do sleep 1 done # # If the file Doesn't exist then we check for internal connectivity .. # if [ ! -f $READY ] then print connect internal exit | sqlplus /nolog $SID_connect.log egrep 'Connected' $SID_connect.log /dev/null if [ $? = 0 ] then echo Problem in Network connectivity of $SID else echo Instance $SID is not responding # # Here we decide that Database is unavailable Due to SQLPLUS hanging . #--- exit 86 fi fi egrep 'ORA-01034|ORA-12224|ORA-12154' $CHECK_CONNECT /dev/null if [[ $? = 0 ]]; then echo Instance '$SID' is NOT accessible, or invalid ORACLE_SID rm $CHECK_CONNECT rm $READY # # Here instance is not availablestaight and simple..: ) #- exit 86 else # # Check for INSTANCE availability by the specific ORACLE error..slick ..eh?! #- grep 'ORA-01017' $CHECK_CONNECT /dev/null if [[ $? = 0 ]]; then echo Instance '$SID' is UP and Accessible else # #To catch any other error . # echo Instance '$SID' is HAVING UNKNOWN ERROR. \n Verify Instance internal state fi fi rm $CHECK_CONNECT rm $READY END regards, RS --- Barry Deevey [EMAIL PROTECTED] wrote: Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Re: time synchronization
Oracle is designed to handle time changes. For example switching to and from daylight savings. This is because the archive logging is not dependent on a date. It has its own sequence. Therefore changing the date and time even while oracle is up is no problem. I have done this many times for testing. The only thing to watch for is if you are using DBMS_JOBS. Changing the time may cause a job not to execute or to run when you don't want it to. Just make sure there is no time conflict with any of these jobs and also 'cron' jobs and go ahead and change the time. I believe your backup strategy is an overkill which I personally would not do but you decide if you would feel safer with the backups, then go ahead with your plan. HTH, John [EMAIL PROTECTED] 09/18/01 08:46AM Hi List,we have about 2 min difference between the time on our db server and therest boxes in our network.Actually, the time on DB server is 2min slow than the network time.It causesreal pain to us.I think about the following order of time synchronization:1. Normal shutdown the DB and listener2. immediate cold backup2. setup time synchronization on the unix level3. startup the DB and listener4. Normal shutdown DB and listener5. immediate cold backup6. startup DB and listenerIs this correct ? Any possible troubles? Any good links?Thanks in advance,Ed-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: List of changed objects in the DB
Title: RE: List of changed objects in the DB you might want to take a look at Schema Manager from Quest Software (www.quest.com)... it will not only show you what has changed since the last time you used it... but also build you the code to apply and rollback those changes to different systems... for use when migrating changes from dev to test to pilot and then on to production. It's a great product for change management. Nick -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Subject: List of changed objects in the DB Hi all, is it possible to identify only those objects that have changed since a given date? Wait ... I know last_ddl_timestamp but we would like to EXCLUDE stored code which has been recompiled and INCLUDE only those procedures/ functions/ packages that were created. any ideas? TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
need an 8.0.5 client and an 8.1.7 client on same machine
I need to get an 8.0.5 client and an 8.1.7 client working on the same machine. Currently, the 8.1.7 is the only one installed. This is an NT winframe/metaframe server running NT 4.0. Some apps use the 8.1.7 client and some will require the 8.0.5. Any suggestions before I start the surgery? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Need assistance with a 'VIEW'.
A view is simply an SQL statement. In your case you want the user to be able to specify a specific date. The problem is quite specific: Each different date makes a new SQL statement. But a view is based on a single SQL statement, not multiple SQL statements. It's like saying you want to sew a jacket, but you want to sew it in such a way that people of different sizes will be able to change the size when they put it on so it will fit them perfectly. There is no way to sew a single jacket that will do that. Why not make a simple SQL*Plus script that uses ACCEPT to get a variable from a user. Then the SQL will be modified each time to include the date the user specifies. Apparently the reason for wanting to create a view is you want users to then be able to select against it. That can be accomplished by using ACCEPT to get values from the users for those columns, too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Need assistance with a 'VIEW'.
And you want be able to do it. Views do not prompt, do not execute anything and do not run marathons. Views are static views of data. Please, read the fine manual. -Original Message- From: William Rogge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Subject: Need assistance with a 'VIEW'. I have been given the nice task of creating a view of some data in our database. This doesn't seem like a major task, but after 2 days of work, I am stumped. Given table 'table1' code1, code2, date, value1, value2 I need to produce a view showing code1, code2, sum(value1), sum(value2) where date 'user input date' I have not been able to get the view to prompt for the date to limit the sum by. Specifics: Oracle RDMBS 7.3.4 Server: Unix What else can I say, but I am totally stumped. HELP! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Deploying middle-tier on unix.
Amar, I've use OAS on both platforms. The unix variety is easier to maintain for the most part. The only unix specific difficulties I ran into were caused by case sensitivity. Many forms were calling other modules with inconsistent case, and I had to find these and modify them before the forms could be successfully compiled on unix. If your programmers have good habits, you shouldn't run into that. If all they have ever worked on is Windoze, then you will probably be doing some error correction before compiling. ;) Jared Amar Kumar PadhiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TS2017@emirat cc: es.com Subject: Deploying middle-tier on unix. Sent by: [EMAIL PROTECTED] om 09/18/01 08:46 AM Please respond to ORACLE-L We use 3-tier architecture to run our application, the middle tier being an OAS. How many of you have the middle tier on UNIX platform? I want to know the pros and cons of having my executables kept on unix server which are then being accessed from a windows based client. Most of the links I have visited talk about middle tier being on an NT machine. I would appreciate any kind of information on this. rgds amar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amar Kumar Padhi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RDA from OWS - anyone used it?
Bruce and List, probably nothing that you wouldn't be collecting anyway Yup, it's pretty lightweight as a database monitoring tool... but I don't think that was the intent. When you consider everything they've brought together it makes a decent system documentation tool... especially from a support perspective. It balls everything up into a zipped tar file which you can move to a web server or upload to Oracle for analysis. With this info an OWS dweeb (or other user) can point and click and see a ton of info about your server configuration and site performance. Since Oracle has made this available via Metalink should we anticipate that it will become an often used and sometimes required component of support? They wouldn't call it Remote Diagnostic AGENT for nothing. Of course there's nothing conspiratorial here since Oracle has our interests at heart. Are the Unix/Linux implementations similar to the Windows implementation? For Unix/Linux the rda.sh script generates HTML with expandable javascript menus for: 1) OS Setup with 12 expandable links or sub-menus; 2) Network, 10 expandable links; 3) Performance, 3 links (and pretty weak); 4) Web Server, 8 links; and 5) RDBMS, 14 links. The links point to other files also generated by the rda.sh script and some of these reports are fairly extensive. I've looked at the scripts developed by Oracle and I don't like the fact that it stores a DBA password in an ascii file. Comments in Oracle's code indicate that it is meant to modular so it can be further built upon. In other words, it sounds like Oracle is committed to an ongoing development effort for the RDA toolset. I also will be interested in other's comments. Yeah, me too. I guess there hasn't been much feedback on this post because RDA is so new. Take a look at what's coming down the road fellow DBA's. Of course they want us to beta test it for them. :-) Steve Orr -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:32 PM To: '[EMAIL PROTECTED]' Cc: Orr, Steve Steve, I've used it a couple of times on NT against a test instance. It seemed to produce some useful information re wait events, tablespace sizings etc but probably nothing that you wouldn't be collecting anyway. It does however put them into a nice html report. Would be useful I imagine for Oracle support to ensure that who they are talking to can provide them with the information they want. I also will be interested in other's comments. Bruce Reardon -Original Message- Sent: Wednesday, 19 September 2001 5:30 Has anyone implemented and used RDA? (It's a diagnostic tool from OWS.) It might be semi-cool ;-) ...Comments? Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Renaming GLOBAL_NAME
I tried all the suggestions and the only one that worked was updating the global name directly to the table. Mario Alberto Ramos [EMAIL PROTECTED] 17/09/01 16:35 Thank you all for your replies. I bounced the database and still it has the same problem. Regards, Prasad Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] carmichr@hotcc: mail.comSubject: Re: Renaming GLOBAL_NAME Sent by: root@fatcity. com 09/17/2001 03:30 PM Please respond to ORACLE-L you need to reboot your database, changing the init.ora parameter to global_name to false: SQL select value from v$parameter where name like 'global_name%'; VALUE -- FALSE SQL select * from global_name; GLOBAL_NAME -- UREGPROD From: Paul Baumgartel [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Renaming GLOBAL_NAME Date: Mon, 17 Sep 2001 10:05:20 -0800 I don't think you can do this. GLOBAL_NAME by definition consists of the database name and database domain, which defaults to WORLD. Paul Baumgartel --- [EMAIL PROTECTED] wrote: Hi All, I am trying to rename the global_name from SIMSNT7B.WORLD to SIMSNT7B. I issued the following command to change the global_name. ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B; Still it is showing SIMSNT7B.WORLD when I query the global_name view. SQL select * from global_name; GLOBAL_NAME -- SIMSNT7B.WORLD Values for the following parameters in v$parameter view, GLOBAL_NAMES parameter value is FALSE and DB_DOMAIN parameter value is NULL. We are not using Oracle Names server. I renamed SQLNET.ORA file in network\admin location. Init.ora file has global_names set to false. How do I change to SIMSNT7B? This database is on Windows NT and it is 8.1.6. Thanks in advance for your help. Best regards Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Sqlplus tunning
Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Alternatives to roles in procedures?
isn't it still simpler to let the schema owner own procedures that access tables in that schema, and grant execute on the procedures rather grant SIUD on all tables owned by each schema owner? I'd think there would be fewer procedures than tables in each schema From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Alternatives to roles in procedures? Date: Tue, 18 Sep 2001 11:20:28 -0800 Interesting! However, if I had shown a real-world example, I think it would've poked a hole in your excellent idea. Add schema C (and D and E) onto this example that schema B also needs to access. Ain't no way in hell the devs are gonna rewrite all of their code to accommodate Jeff T's environment, either. Thanks for the suggestions, but I'm looking at the brute force method, methinks. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer:rm -rf /bin/laden -Original Message- Sent: Monday, September 17, 2001 21:55 To: Multiple recipients of list ORACLE-L um, create the procedures in schema A and grant execute to schema B? removes the need for direct grants on the tables. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Alternatives to roles in procedures? Date: Mon, 17 Sep 2001 12:30:24 -0800 So, there we are, in 8.1.7 on HP/UX 11.0. We have several dozen tables in schema A that need to be accessed from procedures in schema B. We had previously been using a role to grant access to these tables but now with the procedures, this ain't an option. Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc on each table to schema B? TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Compiling package
Hello guru I need help on this , I got 2 database reside in 2 server , 1 is a AIX -server , another is a winnt server , everything go smooth when I compile my package( which consist of 10 procedure , 10 function inside)in the winnt server , but when I move my package to another testing server , once I open the package my TOAD slow for a while ,and further when I compile the whole package ..it look stop for 5-10 minute and refresh back to normal status. When I ask my DBA , he compile it straight from sqlplus and under Enterprise manage console , directly w/o any delay . I ask him to try on my user name also the same...fast... He said it might be my TOAD problem , I try to install again my TOAD..it still work back the same ? Any idea how can I troubleshoot it ? Best Regard Raymond Lee ' If you are given an open-book exam, you will forget your book.' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: need an 8.0.5 client and an 8.1.7 client on same machine
Doug, I wrote the below without noticing that it was a winframe server. I haven't used a winframe server before. So, if it was a normal PC I would do what is below. I would probably do the same thing on a winframe server - I would just want to try it on a test server first. 805 on NT is not multiple-home compliant. So, you need to install 805 before you install 817 (install them into separate homes). So what I would do is: Backup Oracle configuration files Do a total remove of Oracle off the client (ie registry, files, icons etc) Install 8.0.5 (eg into \oracle\product\805) Install 8.1.7 into its own home (eg into \oracle\product\817) I would maintain only 1 set of Oracle networking files. eg create d:\oracle\admin\tns_admin Create a system environment variable tns_admin with a value of d:\oracle\admin\tns_admin Put sqlnet.ora and tnsnames.ora into d:\oracle\admin\tns_admin Regards, Bruce Reardon -Original Message- Sent: Wednesday, 19 September 2001 10:49 I need to get an 8.0.5 client and an 8.1.7 client working on the same machine. Currently, the 8.1.7 is the only one installed. This is an NT winframe/metaframe server running NT 4.0. Some apps use the 8.1.7 client and some will require the 8.0.5. Any suggestions before I start the surgery? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Sqlplus tunning
Try to use Index for big table ITEM To avoid full table scan. Create index item_index on item(no); This will speed the process... --- Sinardy [EMAIL PROTECTED] wrote: Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Lots and lots of redo logs
Bill Buchan wrote: Out of curiosity and as a test I scrubbed my 16Mb RAID1 array and set it up again with 5 x 50Mb redo groups. I ran the following script to generate lots of redo: begin for i in 1..1500 loop insert into test_table values (mod(i,10)); delete from test_table where anumber = (mod(i+1,10)); commit; end loop; end; ARCHIVELOG mode was on and the archive destination (on another disk) was initially empty. There were 239 log switches and the test completed in 2 hours 56 minutes. I then added a further 250 50Mb redo groups, cleared the archive destination and ran the test again. Again it completed in exactly 2 hours 56 minutes, this time 240 log switches (difference of 1, I guess due to whereabouts in the first log it was when the test started). v$session_wait shows permanent log file parallel write for LGWR while the test runs. Any suggestions why I failed to see any slow down when I (almost) filled the disk with redo groups? (This server wasn't doing anything else and the time of the test). The RAID1 array had a Linux ext2 filesystem on it and I had disabled the write cache. Thanks again, - Bill. Bill, Is there any chance that you had the following: - dictionary-managed USERS tablespace with small extent size (lots of recursize SQL) - RBS, SYSTEM, USERS datafiles on same storage volume - indexes on test_table, with INDEXES on same storage - log_buffer at default value of 32K (or some other small value) It seems likely that the bottleneck was not in the LGWR process. As others here would likely indicate, what were the other I/O-related v$system_event waits? Since I don't see version info, is it possible that you do not have a dedicated CKPT process? Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
CLOB trigger problem
Dear listers, I am trying to copy an updated CLOB from a table in one database (let's call it A) to the equivalent table in another database (called B just to be original). I have written triggers and procedures to do this (one package on each database), and I am passing the contents of the CLOB to the remote update procedure as VARCHAR fields in a PL/SQL table. Everything works perfectly well when I run an update against table A. I am connecting via TOAD and am logged on to Oracle as the schema owner. The contents of the CLOB are retrieved, passed across and used to update the remote table. When the client updates the CLOB in table A, however, the select statement in my package on database A which 'locates' the CLOB, retrieves a CLOB of zero length. No exception occurs in the Select statement. The client's update succeeds on table A, and my package sends an empty PL/SQL table to the remote procedure (and the CLOB on the remote table is duly erased). The client is connecting through an ASP-driven web interface via IIS, which as far as I can tell is also logging on to Oracle as the schema owner. Anyone encountered this sort of behaviour before? I've just about run out of ideas. If I can't solve this by direct means I can probably do something kludgy like launch the remote update as a background process via DBMS_JOB.SUBMIT, but I'd far rather have it under transactional control. Oracle version is 8.1.6.3 on both databases. Can supply contents of triggers etc. if needed. Cheers, James Campbell [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Campbell, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Sqlplus tunning
try nested query in place of sort join method... - Original Message - Date: Wednesday, September 19, 2001 11:10 am Try to use Index for big table ITEM To avoid full table scan. Create index item_index on item(no); This will speed the process... --- Sinardy [EMAIL PROTECTED] wrote: Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - 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). -- Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailto:[EMAIL PROTECTED] and delete this mail from your records. --
