RE: LISTENER ON LINUX
A simple ps -ef|grep lsnr will work. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, July 11, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: Ball, Terry 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: DataGuard & Logical Standby Benchmark
I don't have any great answers other than there is good docs on MetaLink. However, one word of warning. We have been attempting to install DataGuard here and have encountered bugs. We have open bugs for release 9.2.0.1, 9.2.0.2 and 9.2.0.3. The bugs are supposed to be fixed in 9.2.0.4, but then again, they were supposed to have been fixed in 9.2.0.3 too. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Tuesday, July 01, 2003 12:19 AM To: Multiple recipients of list ORACLE-L We are Looking to do an In-house small Benchmark on DataGuard in it's various modes & Logical Standby Database Oracle 9.2 Solaris 8 Any experiences of people , approach methodology , dos don'ts , Good Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle on Linux on Sparc hardware
One of the SAs here has asked my to find out if Oracle is supported on Linix on Sparc hardware. He is specifically interested in 9i versions. With him standing over my shoulder, I looked on Metalink, and could not find anything that indicates this specific a combination. Has anyone tried this or know of anyone who has. And is is plausible? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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).
64-bit upgrade
We currently have a database on Solaris 8. The database is 8.1.7.4 32-bit. The vendor wants us to upgrade to 9.2 and change to 64-bit. In reading the documentation from Metalink, I find that I have to do the upgrade seperate from the change to 64-bit. Does anyone have any recommendations for the order of this. Should I change 8.1.7.4 to 64-bit and then upgrade to 9.2? Or should I upgrade to 9.2 and then switch to 64-bit. Any insights, horror stories, etc. are appreciated. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Followup to jobs not running
That did not help. It takes longer to error out, but it is still failing. I can set the same jobs up for the sys user and they run without problems. I am not sure why the system user is the owner of the jobs and since I am the only DBA here this afternoon, I will have to wait until next week to find out if there is a reason for not moving them to sys. If anyone else has any ideas, I am still open to suggestions. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 1:42 PM To: Ball, Terry GRANT ANALYZE ANY TO SYSTEM; "Ball, Terry" <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Followup to jobs not running 03/28/2003 11:13 AM Please respond to ORACLE-L I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Ball, Terry 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: Followup to jobs not running
Yes. System is the job owner/creator. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Privileges should be granted to the user, who created the job. Was it "system"? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 2:13 PM > I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ball, Terry > 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: Igor Neyman 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: Ball, Terry 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).
Followup to jobs not running
I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but whether I run the job manually or the job_queue runs the job, it is still failing. The error I see is insuffient privileges, but I have tried specifically granting execute on dbms_stats to system. Is there anything else I should look for? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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 Jobs not restarting after upgrade
That was it. Thanks. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, March 28, 2003 12:24 PM To: Ball, Terry Terry: Any chance the job_queue_processes parameter got set to 0 on the new database?? Barb --- "Ball, Terry" <[EMAIL PROTECTED]> wrote: > Date: Fri, 28 Mar 2003 09:08:40 -0800 > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > From: "Ball, Terry" <[EMAIL PROTECTED]> > Subject: Oracle Jobs not restarting after upgrade > > Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 > > We are testing an upgrade of Oracle from 8.1.6 to > 9.2. There are several oracle jobs scheduled on > this DB. Before we started the upgrade, all the > jobs were broken (execute dbms_job.broken(201, > true). The upgrade to 8.1.7 was done and then the > migrate/upgrade to 9.2.0 was done. The jobs were > then unbroken execute dbms_job.broken(201, false). > But the jobs are not running. A select shows that > the jobs are no longer broken, but is also shows > that the last date they ran was just before the > upgrade, with the next_date showing as the time it > would have been scheduled before the upgrade. (I.e, > if it ran on the first and was a daily job, it's > next_date would be the second). We have tried > issuing a change for the next date, but all that > does is show a new next_date, it does not make the > jobs run. > > Is there a way to make these jobs start running > again. I have looked in the manuals, but either I > am missing something obvious, or am not looking in > the right place. Any help or suggestions are > appreciated. TIA. > > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Ball, Terry > 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). > ______ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Jobs not restarting after upgrade
Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done. The jobs were then unbroken execute dbms_job.broken(201, false). But the jobs are not running. A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade. (I.e, if it ran on the first and was a daily job, it's next_date would be the second). We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run. Is there a way to make these jobs start running again. I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place. Any help or suggestions are appreciated. TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Standby errors
Actually, the command to force the switch is: alter system switch logfile; alter system archive log all; I did not set the script up, I just inherited it. THe thinking is, since a hot backup and log switch is going to be done anyway, why not ftp the archive logs after the switch, but as part of the same process. Unfortunately, we did not get the upgrade completed this weekend. The log files were the same size on the production database as on the standby (i.e. too small). We did another hot backup as soon as it was discovered, so that we would not be without a recoverable backup, but wanted to know what had caused the archive log process to create logs that it couldn't read. -Original Message- Sent: Friday, March 14, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Why does the copying of archive logs to the standby have anything to do with a hot backup on the primary? They seem like unrelated events. The reason you are getting an incomplete log is that you are using 'alter system switch logfile'. This command returns before archival, so your copy can commence and finish before archival is complete. The correct command to use is 'alter system archive log current'. This command will not return until the current log is fully archived. Than your copy can proceed safely. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 14 Mar 2003, Ball, Terry wrote: > Oracle 8.1.6 on Solaris 5.8. > > We have a read-only standby database for one of our production databases. > Each night, the standby is shutdown and the previous days archive logs from > production are applied. Then the database is brought backup in read-only > mode. To get the archive logs, a hot backup is done on the production > database. As the last step is the hot backup, a log switch is done and then > the archive logs are ftp'd to the server where the standby is. > > After the hot backup completed yesterday, the log switch occurred, and the > logs sent, but when an attempt was made to apply the archive logs we got an > error: > > ORA-00332: archived log is too small - may be incompletely archived > ORA-00334: archived log: '/orabackup/archive/TBSPRD/arch1352.arc' > ORA-332 signalled during: ALTER DATABASE RECOVER > > In looking at the archive log, both on the production and standby servers, > they are the same size - 16k (the block size for the db is 8k). The next > log is 8k in size and then there is another that is 16k before we see any > that are normal sized. These would have been the first logs _after_ the hot > backup the night before. > > In the alert log for the production db, it appears the log 1353 was archived > _before_ 1352. > > Has anyone seen this behavior before? Does anybody have any idea why it > happened in the first place? Is there something we can do to make sure it > never happens again? > > > P.S. We are upgrading to 9.2 this weekend, if that makes any difference. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Ball, Terry 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).
Standby errors
Oracle 8.1.6 on Solaris 5.8. We have a read-only standby database for one of our production databases. Each night, the standby is shutdown and the previous days archive logs from production are applied. Then the database is brought backup in read-only mode. To get the archive logs, a hot backup is done on the production database. As the last step is the hot backup, a log switch is done and then the archive logs are ftp'd to the server where the standby is. After the hot backup completed yesterday, the log switch occurred, and the logs sent, but when an attempt was made to apply the archive logs we got an error: ORA-00332: archived log is too small - may be incompletely archived ORA-00334: archived log: '/orabackup/archive/TBSPRD/arch1352.arc' ORA-332 signalled during: ALTER DATABASE RECOVER In looking at the archive log, both on the production and standby servers, they are the same size - 16k (the block size for the db is 8k). The next log is 8k in size and then there is another that is 16k before we see any that are normal sized. These would have been the first logs _after_ the hot backup the night before. In the alert log for the production db, it appears the log 1353 was archived _before_ 1352. Has anyone seen this behavior before? Does anybody have any idea why it happened in the first place? Is there something we can do to make sure it never happens again? P.S. We are upgrading to 9.2 this weekend, if that makes any difference. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: BMC Patrol
We are currently using Patrol. We just upgraded to version 3.4 so that we could be 9i compatable. We experience less than 2% impact at the worst of times. Most of the time, it just hums along. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Wednesday, March 12, 2003 3:45 PM To: Multiple recipients of list ORACLE-L We are in the process of implementing BMC Patrol for monitoring our databases. This is a good thing since we have hundreds of database across several states. Monitoring from a single location with one tool makes sense. However, the question has arisen about the actual load that Patrol will put on the databases. To read Patrol's data, there are words such as, 'negligible' or 'minimal' but they offer no solid metrics. In the not too distant past, BMC's Perform and Predict product literally consumed all of the memory on our database machines and ground them to a halt. It took several weeks before BMC was able to correctly diagnose the problem and come up with a fix. Rather than repeat this experience I would like to hear from others using Patrol. If anyone has any hands on experience with performance problems resulting from implementing the Patrol KMs for Oracle, SQL Server or Sybase, I would appreciate hearing about them. Thanks, = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett 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: Ball, Terry 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: Upgrading from 8.1.5 to 8.1.6
What we do is rename the 8.1.5 directory to indicate it is the old directory (i.e, 8.1.5_old). If nothing breaks after a week or two, then the directory and its contents are removed. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Monday, February 24, 2003 9:34 AM To: Multiple recipients of list ORACLE-L After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is created to store new version's files and the old directory of old version 8.1.5 is still there. Is is safe to remove the old directory to save disk spaces on the disk? Is there any files being linked to the old version after upgrading? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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: Ball, Terry 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: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
I am not currently working in an AIX environment; but when I did (and it was 4.3 with 8.1.6/7) we always set timed_statistics=true with no adverse effects. -Original Message- Sent: Thursday, February 06, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3: Do you have TIMED_STATISTICS = true? Have you encountered any problems with it? The databases I inherited have this set false all over the place, hence my tuning efforts are really limited. However I don't want to change it without checking around first. And a tuning question: This environment (peoplesoft) is very very low on memory. When the app servers and databases are up there's less than 50MB of memory free. Adding hardware is not a choice here. The databases have 100MB set for the SGA. It really looks like not much thought went into some of the parm settings. What I've read about tuning says that you must have a goal in mind. Well, afaik nothing is "broken", nothing is suffering - then again, no one really paid much attention to Oracle. It was up, fine, move on. Am I on the wrong path if my goal for tuning is to figure out if I can reduce the size of the SGA and redo logs without adversely affecting performance? Any comments are appreciated. Thanks everyone Lisa Koivu Oracle Dingbat Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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).
DataGuard
I am going to be taking over the implementation of DataGuard for 9.2. Before I do, I'd like to learn as much about it as I can. Have any books been written about DataGuard? Or do any books out there have portions addressing DataGuard? Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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).
RMAN
I am trying to create an instance on Oracle 8.1.7.4.0 (Solaris 5.8). I am trying to run RMAN to back it up, but the RMAN instance is still at 8.1.7.0.0. I am getting a bunch of errors. Is it possible to run RMAN in this scenario, or does the RMAN instance need to be upgraded. I'd check Metalink, but it is down for maintenance. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Faking an ORA-600
Thanks for the replies. I was able to test sucessfully. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, December 19, 2002 2:52 PM To: Multiple recipients of list ORACLE-L We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Ball, Terry 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).
Faking an ORA-600
We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry 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: Anybody There?
Thanks to all who responded. I had got caught up in a block for funnytaf.com. I quess there is too much similarity between words that both have an f and a t in them. -Original Message- Sent: Tuesday, October 22, 2002 4:19 AM To: Multiple recipients of list ORACLE-L On Monday 21 October 2002 18:38, Ball, Terry wrote: > I haven't recieved anything from this list since friday evening. I know > there usually isn't as much traffic on the weekend, but there is some. And > there has been nothing at all this morning either. > > Terry Ball, DBA Hi, even some new readers are here. I use this message to introduce myself as a new reader(and maybe writer) of this list. My name is Joerg Jost, i am from Paderborn in Germany. I work as a DBA in a company, that produces an ERP - Software. Jörg Jost -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joerg Jost 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: Ball, Terry 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).
Anybody There?
I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: CA's AutoSys
Oh, I don't know about that. At one of the places you used to work, they _finally_ got it to work, but it did need at least one full-time, dedicated employee to monitor, maintain and massage it. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, October 18, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Run Screaming in the opposite direction. Product was a semi-disaster at two previous job sites. Failed to run jobs when scheduled, failed to detected when dependent jobs failed. Just plain didn't work well. Of course this was when Platinum owned the product, who knows, maybe CA improved it. (although I would doubt it). Matt Adams - GE Appliances - [EMAIL PROTECTED] Write a poem about a haircut! But lofty, noble, tragic, full of love, treachery, retribution, quiet heroism in the face of certain doom! Six lines, cleverly rhymed, and every word beginning with the letter s! -Original Message- Sent: Friday, October 18, 2002 11:50 AM To: Multiple recipients of list ORACLE-L To All, I'll admit this is somewhat off-topic, but since the project is going to handle all scheduled batch jobs that bang on our PeopleSoft Oracle database, I figured I'd ask if anyone has an opinion preferably from experience using the product. The Complete A^^holes are here today to do a demo install so any input you all have would be appreciated. Thanks in advance Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com <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: Ball, Terry 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: IMPORT sloooowwww
Bingo. It was the grants, as I had tried w/o indexes/constraints. There were some 1800+ grants per table. With grants set to no, an import which creates constraints and indexes is flying. It has been so long since I worked with a product where each user is given direct grants rather than thru a role, that I forgot that it was possible to have that many grants on a single table Thanks again. -Original Message- Sent: Thursday, August 29, 2002 12:39 PM To: Multiple recipients of list ORACLE-L and indexes, too! do the indexes, constraints, grants, etc after the table data imports! -bill -Original Message- Sent: Thursday, August 29, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Creating grants and synonyms on each table? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > > In looking at how long it takes, the table imports in a second or less, but > it takes 3 minutes + to start the import of the next table. I'm not sure > what it is doing for 3 minutes after the table imports. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto 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: Magaliff, Bill 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: Ball, Terry 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: IMPORT sloooowwww
I tried this at your suggestion (though it didn't look like it was analyzing as there were not status on the tables). This didn't help. I even tried turning off archiving and no joy. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, August 29, 2002 11:18 AM To: [EMAIL PROTECTED] Sounds strange and I can't give you any good reason but I do have one idea. Have you tried: analyze=n Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and import. Besides, the DB is small - less than 2G. The export was done with compress=n. There are 200+ tables to be imported. It is taking 3+ minutes per table for the import, even on tables that have 0 rows. (Though it does take longer than that for the few tables with over 50K rows). I have tried: 1) Simple import. 2) Import with indexes=n 3) Import with table and constraints (but not indexes) pre-created and indexes=n ignore=y 4) All of the above with the buffer set to 8M (This actually slows the import down, taking 5+ minutes per table). 5) Increasing the sort_area_size for the DB to twice as large as it was and trying the above. In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes after the table imports. Does anyone have any ideas how I can speed this up? 10 hours to import a 2G. DB is extreme and unacceptable. TIA. Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Ball, Terry 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).
IMPORT sloooowwww
Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and import. Besides, the DB is small - less than 2G. The export was done with compress=n. There are 200+ tables to be imported. It is taking 3+ minutes per table for the import, even on tables that have 0 rows. (Though it does take longer than that for the few tables with over 50K rows). I have tried: 1) Simple import. 2) Import with indexes=n 3) Import with table and constraints (but not indexes) pre-created and indexes=n ignore=y 4) All of the above with the buffer set to 8M (This actually slows the import down, taking 5+ minutes per table). 5) Increasing the sort_area_size for the DB to twice as large as it was and trying the above. In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes after the table imports. Does anyone have any ideas how I can speed this up? 10 hours to import a 2G. DB is extreme and unacceptable. TIA. Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Strange experience
I finally got the SAs to turn on and check trace files. It is indicating that the file system that contains both the TEMP tablespace and the RBS tablespace is 99 - 100% busy during the 15 minutes prior to 15 minutes after the alert log warning. I am looking at seperating the two tablespaces. But would it help to make the logs smaller? They are currently at 20M each. Any other options I should look at? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, August 23, 2002 3:27 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent on behalf of a colleague... Are there any messages in /var/adm/messages (or wherever they have syslogd pointing to)? What about the volume manager logs? It may be related in some way to some other bugs: Check problems: 4501030 and 4341008 in this patch http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fpatches%2F108528&zone_32=Or acle%20aiowait http://sunsolve.sun.com/pub-cgi/findPatch.pl?patchId=109688&rev=01 http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert%2F23633&zone_32=asyn c%20I%2FO&wholewords=on http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert%2F28311&zone_32=Orac le%20aiowait Other things that might be interesting to you/others: http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F45203&zone_32=async% 20I%2FO&wholewords=on http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F40043&zone_32=Oracle %20I%2FO http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F27049&zone_32=Oracle %20I%2FO http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F27574&zone_32=Oracle %20I%2FO -Original Message- Sent: Friday, August 23, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Users hadn't even noticed it was happening. The only reason it was caught was because we have BMC's Patrol setup to monitor the DB and when this happens, Patrol alarms. -Original Message- Sent: Friday, August 23, 2002 1:37 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I've never encountered this particular problem, but I would be strongly inclined to turn off async IO and use multiple db writers. Your statement that "the database isn't crashing" is highly subjective. Ask your users if they agree. Jraed "Ball, Terry" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/23/2002 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Strange experience Oracle 8.1.7.4 on Solaris 8. We upgraded from 8.1.6.3 to 8.1.7.4 last month. Since the upgrade, we have seen the occasional strange problem since. At approx. the same time (but not daily), there will be an entry in the alert.log WARNING: aiowait timed out 1 times At the same time as the warning is entered into the alert log, all of the sql connections to the database are dropped. The background processes stay active, but the any other processes die. According to Metalink, this error should also be followed by a DB crash, which is _not_ what is happening. Metalink also says that Async IO should be turned off and multiple DBWRs should be started. SInce the database isn't crashing, there is some reluctance to turn off Async IO. Has anyone else seen anything like this? And if so, how have you handled it? TIA for any help that can be provided. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Ball, Terry 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:
RE: SQLLDR question SOLVED
Thanks for all the help. It turns out there was a problem with the data and the field seperator was part of the data in one of the fields. -Original Message- Sent: Friday, July 26, 2002 10:33 AM To: Multiple recipients of list ORACLE-L I am trying to load data via sqlldr (8.1.6.3 on Solaris 8). A couple of records keep kicking out. Because on the commonality between the records that are kicked out, I have a question. Does sqlldr treat an & the same way that sqlplus does. In other words, if one of the fields in a records has an & embedded in it, will sqlldr reject the record? If so, is there a way around this? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Ball, Terry 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).
Rollback segment shrinks
Oracle 8.1.6.3 on Sun Solaris 2.6. The rollback tablespace filled up last night and the rollback segments became full. I added space to the tablespace and tried shrinking the rollback segments. They remained full, so I altered them offline and online. The extents are increasing, but I still can not get a shrink to work. If they don't stop increasing, my tablespace will fill up again and I can't keep throwing disk at it. Since this is a production system, bouncing is not an option. Any ideas? TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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).
SQL*Loader question
Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Platinum Fastunloader
Where I used to work, they had it will it was still Platinum (before CA took over). It was a decent product, but CA did not provide good support and was always YEARS behind. When we wanted to upgrade the DB from 7.3.4 to 8.1.6 (in late 2000), we found out that CA did not have a version of FastUnload certified to work with any version of Oracle 8. Granted, that was over a year and a half ago, but I'd bet they don't have a version for 9 ready yet either. If you go with it, good luck on getting decent support from CA. -Original Message- Sent: Friday, May 17, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee 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: Ball, Terry 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: comming down the pipe
I alway thought it was pipeline. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, April 11, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Wasn't that expression originally "coming down the pike", as in turnpike? :-) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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 programmers tune SQL?
Names change to protect the innocent/guilty, maybe? -Original Message- Sent: Monday, April 01, 2002 10:19 AM To: Multiple recipients of list ORACLE-L I wouldn't put it past him. But I don't recognize his name on any of those questions :) --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Rachel Carmichael wrote: > > > My last shop we had one programmer who not only expected me to tune > his > > SQL, he expected me to WRITE his SQL for me. I got emails "I need a > > query that returns this information from these tables". > > This guy seems to be trying a new tactic these days: DBA mailing > lists. > -- > Regards, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > 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!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.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 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: Ball, Terry 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 restores
Here are the errors I am seeing. RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03002: failure during compilation of command RMAN-03013: command type: IRESTORE RMAN-06026: some targets not found - aborting restore RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 27 scn 34 923 This lists all the logs EXCEPT the most recent. No logs are found in the archive log directory and the database does not recover thru RMAN. I can not recover the database manually, because the archive logs can not be found. (The backup script removes the archive logs after they have been (hopefully) backed up. -Original Message- Sent: Monday, March 25, 2002 12:36 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Terry, When you say that Rman does not restore the archive log files, what exactly are you expecting? Maybe Rman does not need to restore any archive logs, depending on what point-in-time you are restoring to. It could just restore the db files, and use the current redo logs to catch them up? Below is a point-in-time restore script that I have used - the syntax has not changed much since 816. run { allocate channel t1 type 'SBT_TAPE' parms 'BLKSIZE=2097152'; set until time "to_date('2001-06-22:13:25:00','-mm-dd:hh24:mi:ss')"; restore (database); recover database; release channel t1; sql 'alter database open resetlogs'; } reset database; Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 25, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4 We are trying to use the same RMAN scripts that worked for us in 8.0.5 and 8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do an incremental 1 backup, but when we try to do the restore, it does not restore the archive logs. The lists does show the correct archive logs, so I'm reasonabley certain that the logs are getting backed up, but they do NOT restore. I am working with Oracle on this, but because it is just testing at this point, WWW is not in any hurry to get back to me. Does any one have any scripts they use for 8.1.7 that work for them? I'd like to do a comparison and see if there is something we are missing. TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Ball, Terry 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).
RMAN restores
Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4 We are trying to use the same RMAN scripts that worked for us in 8.0.5 and 8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do an incremental 1 backup, but when we try to do the restore, it does not restore the archive logs. The lists does show the correct archive logs, so I'm reasonabley certain that the logs are getting backed up, but they do NOT restore. I am working with Oracle on this, but because it is just testing at this point, WWW is not in any hurry to get back to me. Does any one have any scripts they use for 8.1.7 that work for them? I'd like to do a comparison and see if there is something we are missing. TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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).
Sightly OT: Unix scripting
Environment: Oracle 8.1.6.3 on Solaris 5.8 I am not a Unix Guru by any strech of the imagination, so I can use all the help I can get. I am trying to write a shell script to execute sqlldr of a file whose name includes yesterday's 2 digit year and julian day in the format: file_yyjjj.csv. I can get today's date fine by setting a variable to be DATE=`date '+%y%j'` But when I try to get DATE -1 it strips the leading 0 (since it is currently 02). Does anyone have any suggestions as to how I can retain the leading 0 and still get yesterday's date? TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Exports and performance
Just one comment. Back on O7, some testing was done by one of the DBAs where I used to work. He determined that the consistency was within a schema, not the whole export. SO if you had cross references between schemas, you could experience problems on imports. I don't know if this "functionality" continued to 8, 8i or 9i. -Original Message- Sent: Wednesday, March 20, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Hi Ron: Comments inline HTH greetings Diego Cutrone - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 1:18 PM > This has probably been discussed before but I would like to know if a full > database > export could affect either Oracle or server performance. Of course it can affect performance, but I think it depends on your hardware and the system activity in the moment of the export as well > > Also, does a consistent=y export only mean that each table is consistent or > is the > entire database consistent? It means that the tables exported are consistent to each other. (The data within a table exported is always consistent independientely of the "consistent" option used.) > > Ron Smith > DBA > Kerr-McGee Corp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone 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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Gold Support/ iTARs
My problem is the opposite. When I log an iTar, my first mode of contact is phone. I ALWAYS get e-mail contact instead. -Original Message- Sent: Tuesday, March 19, 2002 7:58 AM To: Multiple recipients of list ORACLE-L I have yet to log an iTar and not have an Analyst phone me. Much to my annoyance actually. My first form of contact is e-mail. However, they have this ability to determine when I step away from my desk and then phone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Fav. Urban Legend... Hot vs Cold
pplications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve > Mercy - NOT getting something we deserve > > Click on 'http://www.needhim.org' for Grace and Mercy that is freely > available! > > ** The opinions and statements above are entirely my own and > not those of my > employer or clients ** > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > 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: Freeman, Robert > 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: John Kanagaraj 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: Freeman, Robert 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: Ball, Terry 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: UPGRADATION
I wanted to do this at my last job. I called WWS and was told it was their best recommendation to put it in a new home. They would not support installing into the old home and if you have problems, you are on your own. Terry -Original Message- Sent: Tuesday, February 26, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Hi I am running oracle 8i standared edition.I want to upgrade to oracle 8i enterprise edition.IS this possible on same oracle home? If not then can I install oracle 8i enterprise edition into another oracle home? Thx _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Ball, Terry 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: DBA Vs Apps DBA
-Original Message- Sent: Monday, January 21, 2002 2:41 PM To: Multiple recipients of list ORACLE-L The DBA has more responsibility, usually more experience (this usually translates into higher pay as well) than Apps DBA. Well, yes and no. I have seen many orginizations pay the Apps DBA more, because of the "Specailized" knowledge they have. Jon Baker Database Architect <[EMAIL PROTECTED]> www.netsec.net Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Ftp command
Try prompt before issuing the mget or mput command. Terry -Original Message- Sent: 21 January 2002 14:55 To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- 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). 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: Robertson Lee - lerobe 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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE : Table partition on part of a field
One thing to consider is adding a field to the table for the three positions and have a trigger fire to insert the substr from the other field. It will slow things down, but would give you the field needed to do the partioning. Terry > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 16, 2002 3:06 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE : Table partition on part of a field > > > I thought about it, but there are many update programs > and my first inclination is to leave the design as is. > We are talking about PORTING application and I do not want > to add design changes as well. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] > > Sent: Tue, January 15, 2002 11:02 PM > > To: Multiple recipients of list ORACLE-L > > Subject:RE : Table partition on part of a field > > > > > > Make it two fields 6 & 3 > > Partition on 3 > > And create a view to concatenate the two fields into one > > > > Regards, > > Waleed > > > > -Original Message- > > Sent: Tuesday, January 15, 2002 12:50 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hello All > > > > I need to create a partitioned table base on the last three > digits on 9 > > digits number. > > > > Create table test (zip_and_city_code number(9)); > > > > The zip code is 6 digits and the city code is 3 digits. > > > > The design is from an application that used btrieve and is > now ported to > > Oracle. > > (I would not allow this design if it was a new system). > > > > I want to group every city records into its own partition. > > > > First I tried to use range partitioning based on a function > on the field > > and > > it does not work. > > > > Then I thought about using hash partitioning using my own > hash function > > but > > could not find > > where I can use my own hash function. > > > > Any help to implement this @#$% design will be really appreciated. > > > > Yechiel Adar, Mehish Computer Services > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > > 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: Khedr, Waleed > > 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). > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > This e-mail was scanned by the eSafe Mail Gateway > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > 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 li
Determining Striping
Is there a UNIX command to determine what, if any, striping was used when setting up a server and it's disk? Sun Solaris 6, 7 and 8 are what I'm specifically interested in. TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: simple SQL
create table test1 tablespace test1 as select from test2; tablespace goes right after the new table_name. Terrry -Original Message- Sent: Friday, December 07, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Hi Gurus, Iam creating table from one tablespace to another tablespace, Iam getting error!!! create table test1 as select * from test2 tablespace TEST1; What is the problem with statement?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: UTL_FILE_DIR problem
It seems to me, I remember something like this. If I do remember correctly, you need the execute permissions for the directory, so it would need to be 775. Terry -Original Message- Sent: Monday, December 03, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi all, I got one problem about UTL_FILE_DIR. My oracle version is 8i 8.1.6 Platform is unix sun solaris. I have set UTL_FILE_DIR to : /customer/ShopA and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA When I execute the PL/SQL job through SQLPLUS, I hit error message saying that I can't write to the directory. the /customer/ShopA directory permission is set to 664. Let's say owner is A, and the group is A1 Can I tell the program to access the directory and write to the file as another user ? If I'm not wrong, the program will try to write into the directory using oracle unix account. Note : I don't want to set the write permission to other group. I have tried to include oracle in A1 group using secondary group, but it couldn't work. Can somebody tell me how to let oracle write into the directory and the file as well without changing the directory / file permission. if I set UTL_FILE_DIR = * would there be any security issue ? Any help will be greatly appreciated. Thanks & Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio 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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: ORA-03113
Try doing: ps -ef|grep pmon|grep It will look something like oracle 20065 1 0 Nov 11 ?0:07 ora_pmon_BI Issue the kill against the PPID that is returned, in this case 20065. The kill command would look like: kill -9 20065 Terry -Original Message- Sent: Thursday, November 29, 2001 11:21 AM To: Multiple recipients of list ORACLE-L If I'll apply this command it's will take all oracle processes down for every instance in this box? Thanks. >>> [EMAIL PROTECTED] 11/29 10:35 AM >>> Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate? Go ahead and issue Mladen's command and restart the database. It's the only way you can bring it down if you can't connect with svrmgrl or sqlplus. Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Greg Faktor [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 10:05 AM > To: Multiple recipients of list ORACLE-L > Subject: ORA-03113 > > Hi All! > I tried shutdown immediate and get ORA-03113. > Now I can't connect to database. How I can take instance down? On this HP > box 10 different databases. > This command was posted some time back by Mladen: > > ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 > It's will take all oracle processes and listeners down > which I don't want to do. I'm on Oracle 8.1.6. > Thanks. > Greg. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Faktor > 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: Greg Faktor 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: Ball, Terry 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: Altering Indexes
You can't do it en-mass. Why not write a script to do this. select 'alter index '||index_name||' rebuild ;' from user_indexes; or somthing similar. Terry -Original Message- Sent: Tuesday, November 27, 2001 8:25 AM To: Multiple recipients of list ORACLE-L I have this large DB (approx. 250 tables) that has the tables and indexes in the same tablespace (not my design). Is there a way I can move all of the indexes to a separate tablespace en-mass? I know I can move them one at a time with the alter index command, but that would be rather time consuming. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Ball, Terry 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).
ftp tools
Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Sqlloader - important
(KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", ^^^ No comma seperating the '98' and the !' Should probably read: (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", -Original Message- Sent: Tuesday, November 13, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- 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: Ball, Terry 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).