RE: 2G trace files - solved...sort of
Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Weird ORA-00060 (deadlock) with pragma autonomous
What version are you on??? There is a bug in 9.2.0.3, I was getting this error regularly on my rman repository db when an rman resync was run. I've patched to 9.2.0.4 and the error has gone away. ...JIM... [EMAIL PROTECTED] 9/8/03 11:09:27 PM We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
java.sql.SQLException: ORA-21243896
DBA's, Has anyone ever seen this: 15:37:19 06/11 [DBUG] [ConnectionPoolC] SvcsConnectionFinished Reading properties horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection SQLException occured while while creating pool for horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection java.sql.SQLException: ORA-21243896: Message 21243896 not found; product=RDBMS; facility=ORA IRIX64 Error: 67108868: Unknown system error This is from the connection pool log in BEA, it show up when re-deploying the application from BEA??? TAI ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test delete
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle position on hints 9.2.0.X
After spending 2 ½ days trying hints, init parameters, re-writing the query, a completely useless TAR, etc. to get a query that runs in 1 second on 8.1.6.X to go faster than 1 minute on 9.2.0.2 I found a new to 9.2.0.X dynamic init parameter optimizer_dynamic_sampling, if I understand it correctly this parameter forces the optimizer to try harder to get an efficient execution plan. Check the FM there are some interesting things that each level causes the optimizer to do. The default is optimizer_dynamic_sampling=1 I've tried optimizer_dynamic_sampling = 5 7. The query in question has several joins across database links. In 8.1.6 the 10046 trace shows 68 I/O's to the remote database in 9.2.0.2 with optimizer_dynamic_sampling =1 10046 shows 1.4 million I/O's to the remote database. With optimizer_dynamic_sampling = 5 the I/O's are back to 68. Check this parameter it saved us from re-writing a bunch of sql... ...JIM... [EMAIL PROTECTED] 3/11/03 7:33:56 AM Hi, We recently upgraded from 7.3.4 to 8.7 (management plans on getting to that Y2K problem shortly ;-) We had an SQL statement that really needed a hint in 7.3.4. After upgrading to 8.7, I removed the hint and it runs much faster without it. I spend some of my spare time testing SQL with hints removed now. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Mark Richard [SMTP:[EMAIL PROTECTED] snip 1) You are limiting functionality when the database is upgraded - I have seen several examples where Oracle went from 7 to 8 and noone looks at every SQL statement to reevaluate the validity of every hint. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: POLL: Database to DBA ratio
31:1 will be 40:1 by the end of the year. I have a second guy in training as the second DBA. 3:1 oracle app servers 23 24X7 medical databases of one type or annother 8 Dev/Test databases 1 production app server 2 dev/test app servers ...JIM... [EMAIL PROTECTED] 3/11/03 8:59:20 AM I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OS/390 Oracle Client TNS-3506
DBA's We are trying to get an Oracle client running on OS/390 so CICS and (pro*COBOL) can connect to a remote Oracle DB. After install we are trying to run TNSPING as a first step to demonstrate something is working, here is the error: TNS-03506: Failed to create address binding Any help would be appreciated, so far the TAR we have open hasn't produced anything. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Teradata baned from IOUG???
DBA's Check the article's comment on Oracle trying to ban Teradata from IOUG Teradata Steals Oracle's Data Mart Users ... Teradata pushes consolidation and woos away Oracle customers. But Oracle strikes back. Sort of. Will bean counters surf the Web with Excel? Will Steve Ballmer and Larry Ellison become immortal? http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Base conversion
to go! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Has anyone ever seen ORA-11928 ???
Stephane, Thanks for the info, an MVS error is interesting??? I'm not on MVS, the source database is V 9.2.0.1 (Solaris), the trigger is updating a V 8.1.7.2 (SGI) db via database link. I may need to increase the DISTRIBUTED_TRANSACTIONS init parameter. It is currently set at 46 and this db gets updated via db link from several other instances. ...JIM... [EMAIL PROTECTED] 1/20/03 3:07:59 PM James Howerton wrote: DBA's We are getting an intermittent ORA-11928 in conjunction with ORA-2063 and ORA-4088 during a batch load that runs every 5 minutes. (See below) It only happens once every few days and at different times. When we re-run the transaction it loads correctly. I also get ORA-11928 in an OEM alert on another database from time to time. The log shows: new connection cannot be established. ora-11928: Message 11928 not found; product=rdbms; facility=ora. However I have never been unable to establish a connection and I get an event cleared the next time OEM checks??? ORA-11928 is not listed in the FM, Metalink, or google. Thoughts anyone. ...JIM... ERROR text... 20030118060618_healthquest_280 java.sql.SQLException: ORA-11928: Message 11928 not found; product=RDBMS; facility=ORA 01/18/2003 06:11:07 ORA-02063: preceding line from ADT_HRZ ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Jim, If you have a look in oraus.msg (the primary source of information for error messages) you will find the following : / 11000 - 11999 Reserved for mvs sql*net errors LU 6.2 strikes again ? I guess that you must be accessing ADT_HRZ through a database link in your trigger. You should have some specific documentation for MVS / SQL*Net somewhere, the error message is likely to be explained into it. You may also find some useful information in sqlnet.log files you may collect here and there. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Has anyone ever seen ORA-11928 ???
DBA's We are getting an intermittent ORA-11928 in conjunction with ORA-2063 and ORA-4088 during a batch load that runs every 5 minutes. (See below) It only happens once every few days and at different times. When we re-run the transaction it loads correctly. I also get ORA-11928 in an OEM alert on another database from time to time. The log shows: new connection cannot be established. ora-11928: Message 11928 not found; product=rdbms; facility=ora. However I have never been unable to establish a connection and I get an event cleared the next time OEM checks??? ORA-11928 is not listed in the FM, Metalink, or google. Thoughts anyone. ...JIM... ERROR text... 20030118060618_healthquest_280 java.sql.SQLException: ORA-11928: Message 11928 not found; product=RDBMS; facility=ORA 01/18/2003 06:11:07 ORA-02063: preceding line from ADT_HRZ ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OAS 4.0.8.1 move
Kurt, If the ip address/hostname are not identical on the new box it won't run, you have to re-install it from cd. All of the network configs are hard coded during install and there is no way to change them. I went through this a couple of years ago when the SA changed the ip address to a 10 .10... on a dev box. ...JIM... [EMAIL PROTECTED] 12/18/02 5:43:42 AM I have a 4.0.8.1 Oracle Application Server implementation on a Solaris 2 .6 box that I am trying to move to a new, presumably identical, box. We are moving it by simply copying all of the datafiles from one box to the other. We can not get it to start! If any one can offer a suggestion, it would be appreciated. Our current problem (after issuing owsctl start) is: - Please wait while the command is being processed on host frog ... Starting ORB process... waiting for ORB to be ready... ORB is not responding. Please restart manually... OWS-20214: The OAS processes can not be started, because the CORBA orb processes can not be started. - there is an associated file, oasoorb674.out, which contains: YDUT-1571, ydcnm.c 789: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 YDUT-1571, ydcnm.c 493: unexpected IDL:omg.org/CORBA/NO_PERMISSION:1.0 from yocdii.c 720 Init function of module ydn returned an error ERROR: load of module ydn failed - The only differences between the boxes are the IP and the 'name resolution'. The source box uses dns first but the target box resolves names locally first and then uses dns. The nodenames are the same. owsctl start -nodemgr works owsctl status -T works Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IOUG 2003
I paid $85 last year, which was suppose to include a hard copy of Select Magazine, I think I got two one at IOUG and one in the mail. ...JIM... [EMAIL PROTECTED] 11/27/02 1:26:39 PM Dues were $75.00 last year. Weaver, Walt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: IOUG 2003 Speaking of IOUG, did anyone else get a membership renewal email recently? Seems to me the annual dues have gone up significantly this year. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, November 27, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Okay, so I'm trying to get costs for conferences etc so my boss can budget for them. I go to the IOUG site and look at costs for the 2003 conference. I see register online so I click on it. They have it set up for speaker registration already, and ask for the email confirmation code you received. Has anyone on this list, who submitted an abstract, actually RECEIVED a response? Either acceptance or rejection? I haven't. How can you set something up to allow people to register if they don't know which way to register? Sheesh. I can't even register for the University Session I want because I don't know what status I should use when registering. Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM can't seem to discover 1 instance
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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman fun :), nightmare and long
On all of my 8.1.7 and below DB's I do a controlfile backup after the level backup and archivelog all delete input is finished. I had problems cloning a database because RMAN back's up the controlfile first and then does the level backup etc. ...JIM... [EMAIL PROTECTED] 10/4/02 8:53:27 AM The controlfile gets backed up automatically when you do a RMAN full backup. I have been having a debate this morning regarding a situation where we do weekly full backups using RMAN and and a daily RMAN archivelog all delete input. I contend we should do a archivelog all delete input INCLUDING controlfile. My colleague states that this is only of value for when all controlfiles are lost. (which we both agree is highly unlikely but possible). I am asured that if we had no controlfile available we could restore controlfile and it would go back to the copy it has which could be 1 week old and then roll forward (after calling restore database). RMAN would apply any changes necessary (of which there would be none in this scenario) and create an updated copy of the current controlfile) So Joe, you only needed a copy of the control file because of the scenario you were running and you would not need to take a specific copy in the normal run of events? Is my understanding correct?. I know that no recovery/DR scenario can be considered normal but I am particularly interested if any situation where we need to recover from the last backup either a full database to a SCN or point in time or recover a single datafile Thanks John -Original Message- Sent: 04 October 2002 12:58 To: Multiple recipients of list ORACLE-L Connor, my problem(fault) was I didnt make a copy of the control file(and in 8.1.7, you don't get it backed up by default like in 9i, right?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: problems creating a context index
Make sure you're LISTENER and tnsnames.ora have PLSExtProc set-up.
I have a separate listener for PLSExtProc:
listener.ora
LISTENER_PLS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER_PLS =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /DEV_ORACLE/bin/app/oracle817/product/8.1.7)
(PROGRAM = extproc)
)
)
tnsnames.ora
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
...JIM...
[EMAIL PROTECTED] 9/12/02 9:33:23 AM
Hello All;
I am being plagued with an error I can't get my hands around when I try
to
recreate a context index. The index existed previously, but when I
tried to
sync new data I got an error, then I attempted rebuilding the index
from
scratch and got the same error (see below). I checked the
$ORACLE_HOME/lib
directory and found the library that the error indicates as missing.
Any help would be greatly appreciated!
sql statements executed:
call Ctx_Ddl.Drop_stoplist ('my_stoplist')
/
call Ctx_Ddl.create_stoplist('my_stoplist')
/
drop index TFNR_DISPLAY_NAME_IDX_C
/
create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name)
indextype is ctxsys.context
parameters ('stoplist my_stoplist')
/
error returned:
Call completed.
Call completed.
drop index TFNR_DISPLAY_NAME_IDX_C
*
ERROR at line 1:
ORA-01418: specified index does not exist
create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-2: ConText error:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open
failed: No
such file or directory
ORA-06512: at CTXSYS.DRUE, line 122
ORA-06512: at CTXSYS.TEXTINDEXMETHODS, line 34
ORA-06512: at line 1
Sebastian DiFelice
DBA/Database Analyst
Thomson
Intelligence Data
(617)856-1587
www.intelligencedata.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DiFelice, Sebastian
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: James Howerton
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).
upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4
DBA's I have to upgrade an 8.1.6.2 DB on Solaris this weekend (so much for a three day weekend). Is there any reason not to go to 8.1.7.4??? Is 8.1.7.3 less buggy, etc??? I hope to upgrade this DB to 9.2.0.1 as soon as the app vendor ok's it, thanks to our Oracle friends we can't go direct from 8.1.6.x to 9.2.0.1... ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Desperately seeking help in deciphering part of sqlnet
Rick, Are you trying to connect across a firewall? Also can you ping both directions client - server, server - client? Here is what I think is important in you're trace file: nttcnp: Validnode Table IN use; err 0x0 nttcnp: exit nttcni: entry nttcni: trying to connect to socket 204. ntt2err: entry ntt2err: soc 204 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 ntt2err: exit nttcni: exit nttcon: exit nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 nsopen: unable to open transport ...JIM... [EMAIL PROTECTED] 8/19/02 3:18:21 PM Hi, I am getting a ORA-12535 timeout error when connecting to server. I can tnsping Ok. The environment is Oracle 8.1.6 using NET8 on Win NT. Below is what I believe is relevant part of trace file. However I cannot determine cause of error. Any helps is appreciated. Thanks Rick nttbnd2addr: using host IP address: 172.31.2.6 nttbnd2addr: exit nsmal: 420 bytes at 0x1364890 nsmal: 1712 bytes at 0x1370d68 nsopen: opening transport... nttcon: entry nttcon: toc = 1 nttcnp: entry ntvlin: entry ntvlin: exit nttcnp: Validnode Table IN use; err 0x0 nttcnp: exit nttcni: entry nttcni: trying to connect to socket 204. ntt2err: entry ntt2err: soc 204 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 ntt2err: exit nttcni: exit nttcon: exit nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 nsopen: unable to open transport nsmfr: 1712 bytes at 0x1370d68 nsmfr: 420 bytes at 0x1364890 nsmfr: 196 bytes at 0x136e540 nsmfr: 140 bytes at 0x1372b68 nladtrm: entry nladtrm: exit nioqper: error from nscall nioqper:nr err code: 0 nioqper:ns main err code: 12535 nioqper:ns (2) err code: 12560 nioqper:nt main err code: 505 nioqper:nt (2) err code: 60 nioqper:nt OS err code: 0 niomapnserror: entry niqme: entry niqme: reporting NS-12535 error as ORA-12535 niqme: exit niomapnserror: returning error 12535 niomapnserror: exit niotns: Couldn't connect, returning 12535 niotns: exit -- 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: James Howerton 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: RMAN recovery stuck
about ready to think it is TAR time.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 14, 2002 2:23 PM
To: '[EMAIL PROTECTED]'
I am trying to perform an RMAN disaster recovery task. While I use an
RMAN
catalog to make backups, I am trying to recover using just the control
file
information.
Oracle 8.1.6, Compaq/HP Tru64
I start RMAN with
rman target sys/password nocatalog
then,
startup mount
run {
set until time to_date('08/11/2002 01:00:00','MM/DD/
HH24:MI:SS');
allocate channel d1 type disk;
restore database;
recover database;
alter database open resetlogs;
}
Everything appears normal for awhile. In the alert log RMAN tries to
find
each file, doesn't find them. Then it successfully recovers 5 data
files
(including system and rollback) and reports success in the alert log.
Then .
. . nothing for hours. RMAN doesn't return an error. The RMAN shadow
processes are still present but with no CPU consumption. Nothing is
written
to the alert log.
I check V$SESSION_WAIT, and the only entry for the RMAN shadow
processes is one is SQL*Net message to client with seconds_in_wait =
0,
state = waited unknown time.
In V$SYSTEM_EVENT, time_waited and average_wait are zero for all
events. The following events have values of total_waits that are
increasing:
Increase in total_waits in
10-minutes
rdbms ipc message 401
pmon timer 57
control file parallel write 56
SQL*Net message to client24
SQL*Net message from client 24
virtual circuit status5
dispatch timer3
smon timer1
Archiving is turned off.
I have attempted this recovery many times using different RMAN backup
sets,
but the system always hangs at this point.
Any ideas would be appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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: James Howerton
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: DENNIS WILLIAMS
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: James Howerton
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: RMAN recovery stuck
Dennis,
This is just a wild guess and I'm probably wrong but I saw in you're
original post this DB was not in archivelog mode, try putting it in
archivelog mode and running the restore again???
...JIM...
[EMAIL PROTECTED] 8/15/02 2:58:31 PM
Okay, I implemented everyone's comments and re-executed the RMAN
recovery.
Here is what I did and the results.
1. Action: Removed alter database open resetlogs from the run
statement.
Result: No change.
2. Action: Added trace=1 to the allocate channel command.
Result: No trace file is produced in udump.
3. Action: Reviewed Note 145624.1
Result: Did not see the solution to my problem. Most of the
suggestions
seem appropriate to backup rather than recovery jobs.
4. Action: Added log and debug trace statements to rman invocation
line.
Result: Produced log and trace file. The trace file at the point of
the
recovery hang contains the following:
krmxrpc: xc=5372006336 kpurpc2 returned 0
krmxrpc: xc=5372006336 RPC #10 completed immediately
RMAN-08523: restoring datafile 6 to /ora05/ams/data0501.dbf
krmxrpc: xc=5372006336 kpurpc2 returned 0
krmxrpc: xc=5372006336 RPC #11 completed immediately
RMAN-08523: restoring datafile 00017 to /ora05/ams/rbs01.dbf
krmxrpc: xc=5372006336 kpurpc2 returned 0
krmxrpc: xc=5372006336 RPC #12 completed immediately
RMAN-08523: restoring datafile 00025 to /ora05/ams/mls_data0401.dbf
krmxrpc: xc=5372006336 kpurpc2 returned 3123
krmxrpc: xc=5372006336 starting longrunning RPC #13 to target:
DBMS_BACKUP_RESTO
RE.RESTOREBACKUPPIECE
krmxr: xc=5372006336 started long running rpc
krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0,
sid=13
krmxr: callback returned TRUE, skipping sleep
krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0,
sid=13
krmxr: sleeping for 1 seconds
krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0,
sid=13
krmxr: sleeping for 2 seconds
krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0,
sid=13
krmxr: sleeping for 4 seconds
krmxpoq: xc=5372006336, action=013 STARTED, col_l=15, ind=0,
sid=13
krmxr: sleeping for 8 seconds
And the trace continues with this statement.
Any suggestions would be appreciated, as are the suggestions to this
point.
I'm about ready to think it is TAR time.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 14, 2002 2:23 PM
To: '[EMAIL PROTECTED]'
I am trying to perform an RMAN disaster recovery task. While I use an
RMAN
catalog to make backups, I am trying to recover using just the control
file
information.
Oracle 8.1.6, Compaq/HP Tru64
I start RMAN with
rman target sys/password nocatalog
then,
startup mount
run {
set until time to_date('08/11/2002 01:00:00','MM/DD/
HH24:MI:SS');
allocate channel d1 type disk;
restore database;
recover database;
alter database open resetlogs;
}
Everything appears normal for awhile. In the alert log RMAN tries to
find
each file, doesn't find them. Then it successfully recovers 5 data
files
(including system and rollback) and reports success in the alert log.
Then .
. . nothing for hours. RMAN doesn't return an error. The RMAN shadow
processes are still present but with no CPU consumption. Nothing is
written
to the alert log.
I check V$SESSION_WAIT, and the only entry for the RMAN shadow
processes is one is SQL*Net message to client with seconds_in_wait =
0,
state = waited unknown time.
In V$SYSTEM_EVENT, time_waited and average_wait are zero for all
events. The following events have values of total_waits that are
increasing:
Increase in total_waits in
10-minutes
rdbms ipc message 401
pmon timer 57
control file parallel write 56
SQL*Net message to client24
SQL*Net message from client 24
virtual circuit status5
dispatch timer3
smon timer1
Archiving is turned off.
I have attempted this recovery many times using different RMAN backup
sets,
but the system always hangs at this point.
Any ideas would be appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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: James Howerton
INET: [EMAIL PROTECTED]
Fat
RE: RMAN recovery stuck
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 New Features: Joins}
All,
Here is a sample of 9i new features. You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.
...JIM...
[EMAIL PROTECTED] 7/15/02 10:48:28 AM
Welcome to the latest installment of 9i new features. This will not be
all exhaustive but just a sample.
Here is the table scripts to build the data for testing purposes.
drop table dept;
drop table emp;
create table dept
( dept_id varchar2(5) not null,
dept_name varchar2(50) not null);
alter table dept add constraint dept_pk
primary key(dept_id);
create table emp
( emp_id number(5) not null,
emp_name varchar2(50) not null,
dept_id varchar2(5) null);
alter table emp add constraint emp_pk
primary key(emp_id);
insert into dept values ('HR','Catbert');
insert into dept values ('PAY','Payroll');
insert into dept values ('IT','Computer Geeks');
insert into dept values ('MANAG','PHB');
insert into dept values ('EXECU','Big Cheeses');
insert into dept values ('SECRE','Secretary Pool');
insert into dept values ('DBAS','Database Admins');
insert into dept values ('SLIME','Slimy Induhviduals');
insert into dept values ('NWORK','Always Blame On');
insert into dept values ('DUH','No Clue People');
insert into emp values(10,'Bubba Jones','EXECU');
insert into emp values(11,'Honcho Man','EXECU');
insert into emp values(12,'Junior','NWORK');
insert into emp values(13,'Help Desk','NWORK');
insert into emp values(14,'Ima Dumb','DUH');
insert into emp values(15,'Dont Be','DUH');
insert into emp values(16,'Bosses Aid','SECRE');
insert into emp values(17,'Doy Doofus','MANAG');
insert into emp values(18,'Keep em Running','DBAS');
insert into emp values(19,'Look at me','SLIME');
insert into emp values(20,'HR Troop','HR');
insert into emp values(21,'Big Pain','USERS');
Ok now we have some test data, lets look at the various joins.
In the old days(and we're NOT going to talk about sub queries), we
really only had equi-joins and a single outer join.
Now we have:
1. Natural join: This is a join between 2 or more tables where the
columns names match between the tables, like in our table, the dept_id
column is the same name between the dept_name AND the same datatype.
OLD: select emp_id, emp_name, dept_name
from dept, emp
where dept.dept_id = emp.dept_id;
NEW: select emp_id, emp_name, dept_name
from emp natural join dept;
Notice the results we get 11 rows but we have 12 rows in emp. A
natural join is an equi-join where you DON'T have to put the join
condition
in the where clause.
There is a bit more to this one, check the using clause also, hint
its used if the column names match but maybe the data types don't, etc.
2. Cross join: Your and my favorite, also known as a cartesian join.
OLD: select emp_id, emp_name, dept_name
from dept, emp;
NEW: select emp_id, emp_name, dept_name
from dept cross join emp;
Useful?, I think thats up for debate :)
3. Outer join: This is where you join two tables and want to see all
of the rows even if there is NO match. You could outer join to the left
or right but not both at the same time. Now you can do left or right
outer and even full outer, examples follow:
Left: We want to see all employees even if they dont belong to a
dept.
OLD: select dept.dept_id, dept.dept_name, emp.emp_id
from emp, dept
where dept.dept_id(+) = emp.dept_id
order by emp_id;
NEW: select dept.dept_id, dept.dept_name, emp.emp_id
from emp left outer join dept
on (emp.dept_id = dept.dept_id)
order by emp.emp_id;
Right: We want to see all depts even if they dont have employees.
OLD: select dept.dept_id, dept.dept_name, emp.emp_id
from emp, dept
where dept.dept_id = emp.dept_id(+)
order by emp_id;
NEW: select dept.dept_id, dept.dept_name, emp.emp_id
from emp right outer join dept
on (dept.dept_id = emp.dept_id)
order by emp.emp_id;
Full: We want to see all emps with or without being assigned to a dept
and all depts with or without employees.
OLD: No such single statement quewry exists, you had to do it via 2
queries
and a union statement like this:
select dept.dept_id, dept.dept_name, emp.emp_id
from emp, dept
where dept.dept_id = emp.dept_id(+)
union
select dept.dept_id, dept.dept_name, emp.emp_id
from emp, dept
where dept.dept_id(+) = emp.dept_id;
NEW: select dept.dept_id, dept.dept_name, emp.emp_id
from emp full outer join dept
on (emp.dept_id = dept.dept_id)
order by emp.emp_id;
Thats about it for today, all hate email to /dev/null, all good stuff
to [EMAIL PROTECTED]
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
CA sues Quest Software for code theft
Busted... Software vendor Computer Associates International is suing competitor Quest Software, alleging that Quest stole code and trade secrets from a CA product. http://computerworld.com/newsletter/0%2C4902%2C72595%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: disk subsystem performance question
John, We have the Hitachi 5800 series with RAID 5. The sales guys also said their system is s fast we need not worry about such minor details. Don't believe them!!! Write speed is SLOW. After we added bare drives for redo log files, archive logs, conrtol files it made a dramatic difference in DB performance. Hitachi some Sa's don't want to set up RAID 1+0 because it makes more work for them than a RAID 5 install. HTH ...JIM... [EMAIL PROTECTED] 4/10/02 10:38:26 AM Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0 and 5. I would like to get the smaller, faster 18GB drives in a RAID 1+0 configuration and stripe our data across the array groups as wide as possible. However, I am running into objections from the Hitachi people that their system is s fast we need not worry about such minor details. I'm having a hard time believing that given our I/O problems on the 7700E. Performance is given a high priority here. What I would like to know is others' experience with disk subsystems - specifically Hitachi but EMC and others as well have you been able to throw the disk in and forget it or have you had success in getting to the dirty details? Have you tested or noticed an improvement with smaller, faster drives in a disk subsystem like the Hitachi or have you traveled that path and found no noticeable improvement? I'm looking for either a) ammunition that my view is correct, or b) I'm wrong and we can get bigger drives which will make Enterprise Planning very happy from a $$$ standpoint because our Hitachi capacity will last longer. We are running Oracle 8.1.7 / AIX 4.3.3 / Peoplesoft Financials version 8. 2 production databases , one 400 GB and the other about 1TB. We've got some other production DBs but these are our big guys. Thanks in advance for any and all input - any help is greatly appreciated. I'd be happy to share any info we have found up to this point and our experiences on the 7700E as well if anyone is interested - despite the fact I will probably bore you to death :-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA -- 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: James Howerton 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: Rman ... what do YOU need
I agree with Ethan. 1. Please give some good examples for working the various storage management products, Veritas, Tivoli, Legato, etc? I've spent a huge ammount of time trying to get the transport layer working properly. 2. Cloning (I can share the scripts I've used) again I had a lot of difficulty getting this to work with Veritas Netbackup. 3. Anything to enhance business continuity, disaster recovery procedures. Thanks ...JIM... [EMAIL PROTECTED] 4/9/02 1:40:39 PM A section on itegration and best practices with various storage management products. In one case I back up to a Tivoli Storage Management server. Storage group said I would need an addtional product to use TSM with RMAN and that I would still not be able to have some functionality. Never cared enough to try to figure it all out. At the moment I have my own hot backup scripts. Would like to know what else is being done and what the limitations are. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: James Howerton 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).
DBA's supporting CERNER
DBA's, If there are any DBA's on the list supporting CERNER medical applications please contact me off list. We are in the decision/planning stages of aquiring this product and I would like to get some advise on how much care and feeding this beast requires. Thanks Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I
keep getting a file not found error:
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential file, handle=EML_L0-EML- 455497207-2852-1, parms=
I'm missing something somewhere???
Origin DB EML on dolphin...
Duplicate DB EMLC on cobra...
rman
RMAN connect target sys/@eml
RMAN connect rcvcat rman/@ds8i
RMAN connect auxiliary /
RMAN the usual file re-definition redo log file descriptions
RMAN run {
RMAN allocate auxiliary channel t type 'sbt_tape' parms
'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1;
5 duplicate target database to EMLC
RMAN }
RTFM no help
Oracle TAR no help
Sun ticket - completely useless (we get our Veritas support from Sun
[ big mistake])
TIA
..JIM...
[EMAIL PROTECTED] 3/6/02 11:53:34 AM
I use RMAN with veritas Netbackup and it is sweet. Recovery is
ridiculously
easy: Even recovering to an alternative host (not as fast as cloning)
is a
doddle and u can apply redo logs to the recovery to bring it up to
current
time: All in all well worth the learning curve to set up
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 9:03 PM
hmmm, the question of the day, a good one! I don't use it now but plan
on
using it. The question is when :)
[EMAIL PROTECTED] 03/06/02 10:48AM
Hi,
I'm in the process of upgrading my database to 9i and I was trying
to
decide whether I wanted to change my backup strategy to use RMAN. Do
most of
you use it? If you use it, what is your opinion of it? If you don't use
it,
why did you decide not to?
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALINF
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Roberts
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: James Howerton
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).
winmail.dat
Re: Oracle Hungry for Money
Scott, We also have a higher ed site liscense, isn't partitioning included in the Enterprise Edition??? ...JIM... [EMAIL PROTECTED] 3/13/02 1:02:33 PM Watch out! I just got off the phone with our Oracle sales rep. He was asking me if I needed information on Partitioning or OLAP for our data warehouse project. I told him that we are on 8.1.7, so the OLAP option isn't available. To keep him from going into a long speil on Partitioning, I told him that I have already implemented that, which is true. He jumped on that and told me that we aren't licensed for it. He followed up with sending me a quote for $23,800 to cover the fact that we are using the option, which we didn't pay for. I was always told that we have a site license (higher ed), and he said that our license was purchased prior to Partioning being available, so that doesn't count. I'm telling everyone about this as a heads-up. It appears that Oracle is digging for money, and I feel that the approach that was used was done to trick me into admitting that I had implemented the feature. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: James Howerton 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: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I
keep getting a file not found error:
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential file, handle=EML_L0-EML- 455497207-2852-1, parms=
I'm missing something somewhere???
Origin DB EML on dolphin...
Duplicate DB EMLC on cobra...
rman
RMAN connect target sys/@eml
RMAN connect rcvcat rman/@ds8i
RMAN connect auxiliary /
RMAN the usual file re-definition redo log file descriptions
RMAN run {
RMAN allocate auxiliary channel t type 'sbt_tape' parms
'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1;
5 duplicate target database to EMLC
RMAN }
RTFM no help
Oracle TAR no help
Sun ticket - completely useless (we get our Veritas support from Sun
[ big mistake])
TIA
...JIM...
[EMAIL PROTECTED] 3/6/02 11:53:34 AM
I use RMAN with veritas Netbackup and it is sweet. Recovery is
ridiculously
easy: Even recovering to an alternative host (not as fast as cloning)
is a
doddle and u can apply redo logs to the recovery to bring it up to
current
time: All in all well worth the learning curve to set up
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 9:03 PM
hmmm, the question of the day, a good one! I don't use it now but plan
on
using it. The question is when :)
[EMAIL PROTECTED] 03/06/02 10:48AM
Hi,
I'm in the process of upgrading my database to 9i and I was trying
to
decide whether I wanted to change my backup strategy to use RMAN. Do
most of
you use it? If you use it, what is your opinion of it? If you don't use
it,
why did you decide not to?
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALINF
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Roberts
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: James Howerton
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: Preperation for OCP 9i
Jason, What do you think of the Oracle 9i : New features book. Is it worth the $20. ...JIM... [EMAIL PROTECTED] 2/12/02 4:03:21 PM Hi I used the book 'Oracle 9i : New features' by Robert Freeman. I had made extensive notes on Oracle 9i new features from Oracle 9i manuals also. If you are interested , I can post it online. The exam is at the same level as Oracle 8i upgrade exam. Thanks Jason --- Mohammad Rafiq [EMAIL PROTECTED] wrote: A quick question..What was the level of this upgarde test,in your opinion, and what level of preparation is required..I am planning to appear it in coming March/April 2002...for 9i OCP upgrade test. Based on your experience for Solaris, it is better to have certification of Solaris, IMH opinion... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 12 Feb 2002 07:33:39 -0800 Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of Solaris experience and 6 months JAVA experience. What do the Oracle gurus at this list think ? Which is better - Sun Solaris administration or JAVA certification ? Thanks Jason __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: James Howerton 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: Remote Compromise in Oracle
Ray, Yes take a look at http://otn.oracle.com/deploy/security/alerts.htm they have workarounds posted with yesterdays date. ...JIM... [EMAIL PROTECTED] 2/7/02 9:55:18 AM The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Oracle Remote Compromise Systems Affected: Oracle 9, 8 Platforms: All Operating Systems Severity: High Risk Vendor URL: http://www.oracle.com/ Author: David Litchfield ([EMAIL PROTECTED]) Date: 6th February 2002 Advisory number: #NISR06022002A Advisory URL: http://www.nextgenss.com/advisories/oraplsextproc.txt Does Oracle Corp have a response on this? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: James Howerton 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).
9iAS and iPlanet LDAP
DBA's 1. Has anyone been able to get 9iAS Apache and/or Portal to work with the iPlanet LDAP sever. I tried following the December 2000 Configuring Oracle 9iAS Portal for LDAP Authentication white paper. No luck. Opened a TAR they suggested I use Oracle's LDAP sync it with iPlanet. We don't want to maintain several separate LDAP's unless there is no other way. Re-linking Apache with mod_auth_ldap is not supported??? 2. Is there a 9iAS listserv similar to this list? TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: INFORMIX 7.3 to ORACLE 8.1.7
Sonja, Start here: http://otn.oracle.com/tech/migration/workbench/content.html ...JIM... [EMAIL PROTECTED] 1/29/02 7:20:33 AM Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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: James Howerton 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).
Add mod_ldap to 9iAS Apache
DBA's Does anyone have instructions for re-compiling apache to include mod_ldap? We need to integrate our existing iplanet ldap into 9iAS for reports and portal. Metalink states re-compiling apache is not supported and the only manuals I've found so far only address OID. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Palladium Consulting
Yep I got one. ...JIM... [EMAIL PROTECTED] 12/19/01 6:50:18 AM Did anyone get an e-mail from Palladium Consulting lately? Just wondering where they got my e-mail address. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: James Howerton 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: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup
Thanks Ron, The SGI install only has $ORACLE_HOME/lib32/ $ORACLE_HOME/lib/ dir's. ...JIM... [EMAIL PROTECTED] 12/13/01 7:40:17 PM James, You need to have the library for the 64 bit of Veritas... on AIX, it is done as follows: ln -s /usr/openwin/netbackup/bin/libobk.a $ORACLE_HOME/lib64/libobk.a You need to be sure that your link command is pointing to $ORACLE_HOME/lib64/ HTH, -Ron- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James Howerton Sent: Thursday, December 13, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup DBA's Has anyone been able to get Veritas Netbackup to work with SGI 64 bit Oracle 8.1.7 The relink fails with ~/lib/libobk.so is o32 I've tried the following relink statements: make -f ins_rdbms.mk ioracle and make -f ins_rdbms.mk PL_FLAGS=-32 both fail Metalink/Oracle support is no help as usual. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Ron Yount 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: James Howerton 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).
relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup
DBA's Has anyone been able to get Veritas Netbackup to work with SGI 64 bit Oracle 8.1.7 The relink fails with ~/lib/libobk.so is o32 I've tried the following relink statements: make -f ins_rdbms.mk ioracle and make -f ins_rdbms.mk PL_FLAGS=-32 both fail Metalink/Oracle support is no help as usual. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup
Thanks Cherie, I've done a lot of searching on Veritas's web site. I think I found the section you mentioned, it doesn't show anything for 8.1.7. I called Veritas sales and they said there wasn't a different client for 64bit, but today I found a patch for V3.4 64 bit, so much for sales knowing what they are selling. We unfortunately purchased Netbackup from Sun and get our maintenance through them, MAJOR WASTE OF TIME. The Sun help desk can't even spell Netbackup. I'll just keep lobbying for direct maint. Thanks again ...JIM... The frustrated DBA [EMAIL PROTECTED] 12/13/01 3:05:26 PM James, Have you tried Veritas's web site? It's at http://support.veritas.com/menu_ddProduct_NETBACKUP.htm Click on advanced search under Knowledge Base in the middle right part of the page. Search on the error message that you get. Try all the error numbers by themselves. You should get a hit that way. I was able to find a very nice article in their Knowledge Base showing how to do the relink libobk.They had a section for 32-bit as well as a section for 64-bit. I can't put my hands on the hard copy I had right now but it might turn up. Email me if you fail to find the article on their website. I have had very little success in troubleshooting RMAN errors related to Veritas via Oracle and/or Metalink. I have had pretty good support from Veritas, though. If nothing else, get their support phone number off of their web site and call their support direct. Their people can be a bit spotty but most of the time I've spoken with someone very good. Cherie Machler Oracle DBA Gelco Information Network James HowertonTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] jhowerton@uab cc: mc.edu Subject: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup Sent by: [EMAIL PROTECTED] om 12/13/01 01:40 PM Please respond to ORACLE-L DBA's Has anyone been able to get Veritas Netbackup to work with SGI 64 bit Oracle 8.1.7 The relink fails with ~/lib/libobk.so is o32 I've tried the following relink statements: make -f ins_rdbms.mk ioracle and make -f ins_rdbms.mk PL_FLAGS=-32 both fail Metalink/Oracle support is no help as usual. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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
Re: event= to capture deadlock debug info
Hi Deepak, Thanks for the info. The situation may not be a deadlock. I checked the alert log, no entries when the lock occured. Also no trace file was generated. On Friday we were unable to simulate the lock condition (proved the database was pretty indestructable). At this point I'm not sure what may have caused the situation. I guess I'll have to wait until it happens again and get the users to wait until I can gather more info befor I fix it. ...JIM... [EMAIL PROTECTED] 10/19/01 1:02:35 PM Hi James, setting an event at init/session level would basically dump the error state into an trc file. ora-60 or deadlock by defualt writes a message in alert file and also dumps a large trace in udump. so why do you want to explicitly set this event? The default behaviour mimicks the same anyways. hth Deepak --- James Howerton [EMAIL PROTECTED] wrote: DBA's Does anyone know of an event= to set to capture a deadlock condition? On two occasions now a user's session has locked up due to a network problem or three finger salute or who knows what(???) blocking other users from adding records to the system. I have to get it fixed quickly to get them working again so I don't have time to study everything in the locked state before killing the offending users session. It has only happened twice, once at night and once on a holliday. I don't have all of my toys at home to get a quick look. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: James Howerton 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).
event= to capture deadlock debug info
DBA's Does anyone know of an event= to set to capture a deadlock condition? On two occasions now a user's session has locked up due to a network problem or three finger salute or who knows what(???) blocking other users from adding records to the system. I have to get it fixed quickly to get them working again so I don't have time to study everything in the locked state before killing the offending users session. It has only happened twice, once at night and once on a holliday. I don't have all of my toys at home to get a quick look. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 help
DBA's, I'm trying to help one of our developers without success. (developmentally challenged DBA;-) Does someone have a good example for inserting data larger than 4000 characters in a CLOB datatype. We tried initializing a row with empty_clob() and then doing an update, still haven't figured it out. The friendly manual is helpfull as usual, IOUG diddn't have anything we could use. We have data being loaded in a 8.1.6.2.1 database via ODBC from a hub(interface) engine. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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).
!! *Very* important Oracle-L message !!
Jared, I'm in for $12. Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: RAID 5/Oracle
I lost the battle. We have Hitachi raid 5 hooked-up to a Sun E10K and write performance does SUCK!!! Maybe THEY will listen next time;-)... ...JIM... [EMAIL PROTECTED] 8/1/01 10:36:01 AM doesn't write performance kind of suck too? KK -Original Message- Jahnke Sent: Wednesday, August 01, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Ravindra Basavaraja schrieb: We are planning to move our database to Sun 4500 with A1000(RAID 5).Our system admin group has been working on this setup and I was told that the A1000 which is having 4 disks will be seen as just as one mount point after configuration.Is this the correct way of confuguration.Don't we see each disk of A1000 as different mount point. Thanks Ravindra Hi, if you setup a group of disks as a RAID5 disk array, they appear as one logical unit. Hence, you only see one single mount point. Advantages: Read access is usually faster, since the data is transparantly distributed to your disks by the RAID system. It's another step towards higher availability since RAID5 usually gives you the feature of replacing a damaged disk while the file system keeps operating. Disadvantage: You don't have that much control over the degree of fragmentation since the data distribution is done by the RAID system. | Regards, | | Stefan Jahnke | | @:D2 Vodafone, Abt.: FBOM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Kevin Kostyszyn 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: James Howerton 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: Metablink .... down again?
Its not you, Metablink is crawling on its knees again. ...JIM... [EMAIL PROTECTED] 7/23/01 9:20:32 AM Is it me or everyone? Is Metablink working for anyone this morning ? 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 ! *1 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. *1 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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).
Oracle 9i orderabls on Metalink
All, Oracle9i EE show's up as orderable on Metalink this morining for Solaris, OS390, HPUX. ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: iAS installation update
am installing based on the iAS installation manual. Hopefully that will work. /begin rant I still wish the Oracle techs could have told me which versions of the various products are concurrent, they just keep insisting that all their products are certified to work together. All I wanted to know was which oracle_home type do the various products use? Forms and Reports 6i requires an 8.0.6. home, Developer6 used an 8.0.5 home, etc. the Metalink techs do not appear to have a list, they didn't understand my question. When I logged a TAR on this I received three e-mails telling me that my TAR had been passed to different people, in the end the last tech told me that products sometimes are released together, but that it is not all that important, because everything is certified to work together. I can't shake the feeling that iAS is a bundle of things that were just slapped together. Seeing the old installer pop up during the installation doesn't help remove that impression. Hopefully when the next release comes out it will install in something other than an (old) Oracle 8.0.6. oracle_home. Since it's called Oracle9i iAS, maybe the Forms and Reports Servers will go into a 9i oracle_home (?). /end rant (this is my impression, not my employer's etc. etc.) Sorry if this comes across as a little harsh. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: James Howerton 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: Seley, Linda 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: James Howerton 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: iAS installation update
Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: James Howerton 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 feedback on 9iAS
While we are on the subject, is there a 9iAS listserv? ...JIM... [EMAIL PROTECTED] 4/27/01 3:25:23 PM Hi Listeners, I'm looking at several Oracle products and have several issues I'm trying to resolve: Oracle 9iAS - IFS web interface configuration JDeveloper - Configuring Application Server for deployment Oracle Forms Reports - Configuring Web server for deployment Portal - Site Building - Deployment to other sites XML - Generation of forms and reports using XML. - Passing the data to and from the database. Any feedback would be greatly appreciated. Thanks, Charles Yuan Oracle dba 918 744 4333 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charles Yuan 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: James Howerton 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: Q: Oracle Year End???
Its true!!! 30 May is the end of the FY. Our salesman has been pushing hard for us to finalize the purchase of some tool sets by the 14th of May. The longer we keep him waiting the lower the price is getting. ...JIM... [EMAIL PROTECTED] 4/26/01 10:41:11 AM I have heard, but have not been able to confirm that May is Oracle's fiscal year-end. Does anyone have any information regarding this? I have also heard that May, being Oracles' year-end is the best month to buy. Has anyone had experience with this? -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: James Howerton 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: Cold Fusion and Oracle
Bill, Do you know if CF is compatible with Oracle 8.1.6.2.1 on Solaris? We can't get them to return our phone calls and we can't get CF to connect. TAI ...JIM... [EMAIL PROTECTED] 4/23/01 7:25:28 AM On Sun, 22 Apr 2001,Cyril Thankappan scribbled on the wall in glitter crayon: - -Hi!.. - - DOes any one here have any information of - where I could possibly find some information - on Cold fusion and Oracle - - Thanks we are using that combination here in several applications, feel free to write me offlist with any questions and i'll try to help. -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Never trust a computer you can't throw out the window. - S. Hunt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: James Howerton 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: Meeting at IOUG
I'm a first timer too. Monday night sounds good. Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 [EMAIL PROTECTED] 4/17/01 10:41:39 AM I'll be there too! It will be my first visit to IOUG and I'm looking forward to meeting the many folks who have contributed to my knowledge [and amusement] through this List. Even though I don't often post questions, your advise to others have been very useful. Keep up the good work. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 9:15 AM I will be there also. Sandra Arnold DBA Strategic Staffing Solutions -Original Message- Sent: Tuesday, April 17, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Arnold, Sandra 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: Bill Gentry 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: James Howerton 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).
How to wrap old sqlplus reports with Java and output html
DBA's developers, We have several reports written in sqlplus with break on statements, calculations, etc. The Java guys are looking for an Oracle tool set or method to wrap the sql in a servlett and produce output in html without re-inventing the reports. They don't want to use 9iAS/Portal if possible. Any suggestions sqlj, XML, etc... TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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).
Slightly off topic SFTP
DBA's, Has anyone been able to automate secure ftp "sftp"? I have several cron jobs that move an ascii file from one box to annother via cron jobs shell scripts. The security gestapo is now making us use ssh and sftp. I haven't been able to figure out the syntax to get sftp automated. Suggestions? TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Metalink customer satisfaction surveys
I had a call from Oracle Support about three weeks ago for a telephone Metalink customer satisfaction survey. What an opportunity;-)... I let them know it was unusably slow, inconsistent (call something the samething throughout what a concept), can't fing basic things like patches, no response on an iTAR for two or three days while the controller was off, etc, etc, etc. It was fun but I don't think the caller liked it very much. So far I don't see any improvement!!! ...JIM... [EMAIL PROTECTED] 3/28/01 7:15:22 AM Have any of you received one of those lately? I remember last year they used to check with us to see whether we were happy with the service, but I have received nothing in a long time. Someone soft closed one of my TARs, saying he had sent me the information I requested, but I can't find anything in my e-mail folders re. that TAR. I got the notices telling me the TAR has been updated, but I didn't receive the information the tech says he sent me -- at least I can't find it anywhere. My question was re. how we can secure the OEM, i.e. how to ensure that the OEM the DBAs use will be the only one in use to access our databases. What's to stop a developer or an end user from downloading the OEM for free, then using it to send jobs to the databases using the intelligent agents? Nothing, as far as I can see, if we go with the default configurations. I would very much like to see the guidelines I requested re. securing the OEM... I updated the TAR myself, maybe they will "un-soft-close" it. There is someone from Oracle development group on the ODTUG listserv, I sure wish there was someone from customer support or from the Oracle engineers group on this listserv. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: James Howerton 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).
pro*c install ?
DBA's, Can anyone give me some tips on installing/configuring pro*c on AIX/8.1.6. I've looked at the install manual, technet, metalink, etc??? ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Speed up import of a 10gb table with a long_raw datatype
Thanks Lee, What is the impst command? I'm not familiar with it. ...JIM... [EMAIL PROTECTED] 2/21/01 10:21:01 AM You could up your buffer size and also use impst. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: James Howerton 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).
