Bored!!!
Dear Audrey, Change your employer, go some place where you have N number of platforms and N types of DB's. I am sure u will soon say the opposite. Regards __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data dictionary for function
Sorry the below should have read dba/all _source table Ravinder_Bahadur@singapore air.com.sgTo: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Re: Data dictionary for function 29-Jun-2001 01:50 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book dba_all_source Regards Sinardy Xing SinardyXing@bcs-aTo: Multiple recipients of list ORACLE-L ch.com.sg[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Data dictionary for function 29-Jun-2001 12:20 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi all, Do you know what data dictionary store information about all user function, store procedure ? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- 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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data dictionary for function
dba_all_source Regards Sinardy Xing SinardyXing@bcs-aTo: Multiple recipients of list ORACLE-L ch.com.sg[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Data dictionary for function 29-Jun-2001 12:20 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi all, Do you know what data dictionary store information about all user function, store procedure ? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Common Oracle RDBMS Misconceptions
I guess so .. as when I told the new guys at my place about they very much went into defensive mode on this one. Christopher Spence To: Multiple recipients of list ORACLE-L cspence@Fuel[EMAIL PROTECTED] Spot.comcc: Sent by: Subject: RE: Common Oracle RDBMS root@fatcity.Misconceptions com 27-Jun-2001 01:30 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book I think he was shocked by the fact he had a completely different opinion, and many as well as oracle preach similar opinions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 7:15 AM To: Multiple recipients of list ORACLE-L well whats wrong with the article. It is true. It is the way Oracle Handles the HOT Backup. Ravinder Vladimir Begun [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L crimea.ua [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions 26-Jun-2001 06:33 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained If this is true then I may be a victim of a disease called 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK style) Please help me. If some one has few more articles like this enlighten me What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- 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,
Re: EMN0 process problem
Could it be that your OEM is starting the event monitor process. Just guessing Ravinder Stephane FaroultTo: Multiple recipients of list ORACLE-L sfaroult@oriol[EMAIL PROTECTED] ecorp.com cc: Sent by: Subject: Re: EMN0 process problem [EMAIL PROTECTED] m 27-Jun-2001 01:30 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi Gurus Some times one of instance is shutdown.When I checked alert log found following error message. Mon Jun 18 09:04:21 2001 Restarting dead background process EMN0 EMN0 started with pid=15 Mon Jun 18 09:04:24 2001 The similar kind of problem I faced when I shutdown the database by shutdown immediate option.I couldn't find much information on metalink.Let me know what could be problem.Any one have faced similar kind of problem? Thanks -Seema EMN0, of which I had never heard before, is according to V$BGPROCESS an 'even monitor process' (guess it's a kind of sub-pmon or sub-smon). It doesn't seem to be started by default. If I were you, I would first look in background_dump_dest for a trace, because if it died it probably didn't die without a last phrase. If the trace file is not clear enough (likely), send it to the Oracle Support to keep them busy and in the mean time try to find out what makes the b*y EMN0 start and check whether you really need it. HTH, Stephane Faroult Oriole Corporation - Performance tools for Oracle ® http://www.oriole.com/ -- 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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db_file_multiblock_read_count
Nice colour choice .. Guy Hammond guy.hammond@To: Multiple recipients of list ORACLE-L avt.co.uk [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: db_file_multiblock_read_count com 25-Jun-2001 11:27 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi Lisa, IIRC, the first line of vmstat gives you cumulative values since system boot. And 2 10 means every 2 seconds, 10 times (on Solaris, at any rate). Cheers, g -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 3:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: db_file_multiblock_read_count 2. vmstat - look at the two columns that start with pg. Read the man page and it will explain it to you in detail. Also, when you use vmstat be sure to give it an interval (like vmstat 2 10 - this means display stats once every 2 seconds for a duration of 10 seconds). The first line returned by vmstat will always be garbage (same with iostat). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MTS problem
Ivo, I guess it should look like this in you init file mts_listener_address=(address =(protocol=tcp)(host=10.17.150.5)(port=1521)) mts_service=ORASIDa mts_dispatchers=(ADDRESS =(PARTIAL=TRUE)(protocol=tcp)(host=10.17.150.5))(dispatchers=5) mts_max_dispatchers=10 mts_servers=5 mts_max_servers=20 Ravinder Libal, Ivo ivo.libal@knapp-syTo: Multiple recipients of list ORACLE-L stems.com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: MTS problem 26-Jun-2001 01:00 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hello I've got a problem with MTS. When I start database then the service is registered to listener as a next dedicated server instead of connecting as dispatcher and if I force the client to use shared connection I get an error :ORA-12519 / TNS-12519 Text: TNS:no appropriate service handler found If I made lsnrctl services I got 2xdedicated server . Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PROD)) Services Summary... PROD has 2 service handler(s) DEDICATED SERVER established:2290 refused:3 LOCAL SERVER DEDICATED SERVER established:0 refused:0 LOCAL SERVER extproc has 1 service handler(s) DEDICATED SERVER established:311 refused:0 LOCAL SERVER The MTS part of my init.ora is: mts_max_dispatchers=10 mts_max_servers=20 mts_servers=5 mts_listener_address=(ADDRESS =(PROTOCOL=TCP)(host=10.17.150.5)(port=1521)) mts_dispatchers=(protocol=TCP) large_pool_size=1000 The oracle is 8.1.7 on Suse 7.0. Have you ever had such a problems? Are there any know bugs? What else should I check? Any Ideas? Could it be a problem with automatic_ipc=true ? Kind regads Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Common Oracle RDBMS Misconceptions
well whats wrong with the article. It is true. It is the way Oracle Handles the HOT Backup. Ravinder Vladimir Begun [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L crimea.ua [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Common Oracle RDBMS Misconceptions 26-Jun-2001 06:33 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained If this is true then I may be a victim of a disease called 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK style) Please help me. If some one has few more articles like this enlighten me What a help do you need? -- Vladimir Begun | The best things in life are for a fee. http://vbegun.net/ | http://vbegun.net/wap/ | [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Questions for Oracle creation Backup
Meng Fangtao m.fangtao@geneTo: Multiple recipients of list ORACLE-L sis.co.nz [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Questions for Oracle creation Backup m 25-Jun-2001 12:45 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Dear Sir/Madam, We will migrate Mysql to Oracle soon. Now I have some questions. 1. We have 5 databases in one instance in Mysql. Do we need to create 5 databases in Oracle, or only one? We have to start 5 instances and assign different sizes of RAM to them If we create 5 databases. There are two ways of doing this. One is as explained by you the other is to create diffrent tablespaces and schema's for each of the applications and use only one instance. 2. How do you do daily backup for Oracle? Do you use RMAN and recovery catalog ? The Oracle version we purchase is standard edition. Does It support incremenetal backup? No at my work place we do not have any RMAN work. Guess they dont believe in using this tool so we use the old, tried and tested method of offline and online backups using the host commands . 3. How do you deal with archived redo log at daytime? Is the archived redo log written into a tape or disk? Well we have a separate backup plan for archived redo logs. They are backed up and purged. The frequency of the backup is done based upon the frequency of the archiving. Thanks in advance. Meng -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meng Fangtao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Griping about auditing (not the Oracle Kind)
In this I would always make sure that a hard copy and an email was sent for such a request and when the application is rejected ask him to reply thru mail. So you have documented proof that your suggestions were rejected in the first place. I only see one reason why the manager would like to do this. It is because he is one of those who says why the hell did this little pip squeak think of this before me.. So before anyone comes to know ( especially his boss ) he would rather present the request from his side and get a upper hand with his boss before he will approve. Ravinder = Rachel Carmichael To: Multiple recipients of list ORACLE-L carmichr@hot[EMAIL PROTECTED] mail.comcc: Sent by: Subject: RE: Griping about auditing (not the root@fatcity.Oracle Kind) com 26-Jun-2001 09:50 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book in situations like that, you can and should document the fact that you made the proactice request and had it turned down. and then call that person's manager at 2AM to get permission to fix the problem when it becomes an emergency From: Bowes, Chris [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Griping about auditing (not the Oracle Kind) Date: Mon, 25 Jun 2001 13:05:46 -0800 In a perfect world or even a sucky world, yes. But the nightmare scenerio that was laid out wouldn't allow proactivity on their part. The inconvenient time thing was due to the fact that the proactive items they wanted to to do were rejected. They had a table that was diagnosed with too small extents and they wanted a bigger extent size. They submitted paperwork and a non-tech management type said 'no'. Does he disobey the rules and risk getting fired? They made other requests for day-to-day events and possible problems. They were rejected because you cannot do that many changes. Do they risk their jobs and do what is needed, knowing eventually someone *WILL* find out and at that point they can/will be terminated for insubordination and failure to follow process or at least slapped down big for it? In all situations I had seen until here, I would say, yes, proactivity is a must and I know that we can look at any one item and get around rules that get our way. When it becomes a corporate culture, you really need to get the policy eliminated. The way to do that is to allow the people who can make these stupid decisions suffer. He simply said OK, if that's the way you want to play it, then I'll do what you say. I will follow your rules and not fix things I see wrong because *you say I can't*. Of course, you wouldn't know a database problem if it jumped up and bit you and said, 'Hi I am a database problem', but that's irrelevant. I will do it your way and fix it when it breaks and you're franticly signing off on the same paperwork you rejected x days/months ago. Just don't expect a friendly call at 2 am when it happens... I agree, we need to be proactive, however, the
Re: Deadlock Detection
Try to look at the latch waits and session waits events. Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED][EMAIL PROTECTED] ate.ny.us cc: Sent by:Subject: Deadlock Detection [EMAIL PROTECTED] 22-Jun-2001 09:35 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book All, My current application (still under development) is experiencing Oracle deadlock problems. The applications people are performing stress testing where the application is being repeatedly called simulating actual users hitting the database. The application is written using VB thru ADO and COM, Oracle 816 on NT. My problem is that, while I can review the trace file produced, I can't figure out what the actual deadlock is occurring on. I have seen deadlock trace files that clearly state table blah, but in this case, I get: *** 2001-06-21 14:32:03.841 *** SESSION ID:(27.31211) 2001-06-21 14:32:03.810 DEADLOCK DETECTED Deadlock graph: -Blocker(s) -Waiter(s)- Resource Name process session holds waits process session holds waits DX-003b-22 18 X 24 27 X session 18: DID 0001-0018-003Csession 27: DID 0001-0018-003C Rows waited on: Session 27: no row *** 2001-06-21 14:32:03.857 ksedmp: internal or fatal error ORA-00060: deadlock detected while waiting for resource Is there something like TKPROF that will process the trace file and give me more info on what is happening? It looks like I am waiting for a resource to be freed, but which one is the question. thanks for any help. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: Backup Address
Try the connect_timeout_SID parameter in the listener file. Bellefeuille, Wayne S To: Multiple recipients of list ORACLE-L Wayne.Bellefeuille@a[EMAIL PROTECTED] llina.com cc: Sent by: Subject: FW: Backup Address [EMAIL PROTECTED] 22-Jun-2001 10:26 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Sorry, it looks like ADDRESS LIST does work. It is just that it takes about 2 minutes before it recognizes that the first one failed before it tries the second one. Any ideas how to speed that up. I am assuming it is some kind of timeout feature dealing with Pinging an IP address; (maybe at the UNIX level?) Wayne -Original Message- From: Bellefeuille, Wayne S Sent: Friday, June 22, 2001 7:51 AM To: ORACLE-L@fatcity. Com (E-mail) Subject: Backup Address We have the following situation here. On an AIX SP I need to connect from one SP node (that just has the Oracle client) to another SP node (that has the Oracle database). There are actually three IP addresses I can put in the client's tnsnames.ora; one that uses the normal backbone, one that uses a highspeed switch, and one that uses the external IP address. Normally I use the normal backbone IP address, but sometimes that goes down, which causes a TNS error (of course). What I am looking for is a way to list multiple ADDRESSes in tnsnames.ora and have it do the following: If the normal backbone fails, try the highspeed switch IP address. And if the highspeed switch IP address fails, us the external IP address. I tried using ADDRESS LIST in tnsnames.ora, but if I put the normal backbone IP address first and the normal backbone is down, then it doesn't try the next one. Any ideas? Wayne -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellefeuille, Wayne S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Use sql*loader
Check your bad file and your error log file for sqlldr it should explain what happend. Ngo BaDu ngo_duy@fmaiTo: Multiple recipients of list ORACLE-L l.vnn.vn[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Use sql*loader com 22-Jun-2001 03:50 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Dear all, I have a text file of 70 rows. After using sql*loader to load it into my table, I select * from my table it only show 802 rows. Some people told me that's because of buffer. Who would like to show me how I ought to do? Thanks you and sorry for my bad english. BaoDuy __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql o/p to Excel
Dear Ravindra , You can use this output itself. Just select the fixed width option instead of the delimited option. Then put you own column lines where you want them to be. Regards Ravindra Basavaraja To: Multiple recipients of list ORACLE-L ravindra@sen[EMAIL PROTECTED] tica.comcc: Sent by: Subject: sql o/p to Excel root@fatcity. com 22-Jun-2001 10:10 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book I have a sql script to generate a dialy report like this. 01-JUN-200107 84 17 18 11 *** - MAXIMUM No. 11 TOTAL 15 04-JUN-200108 92 10 111 11 122 12 133 13 14 16 14 154 17 182 18 192 *** - MAXIMUM No. 16 TOTAL 32 I want to present this output in excel so that I can draw graphs.I am not able to open the file in excel in alligned format ie each column must appear in different columns in excel.How can I do that. Is that possible? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database in archivelog mode
Well there is no need to specify the alter system archive log start as you have already done this by specifying the log_archive_start=true in the init.ora. Try 'alter system switch logfile' command a couple of times and see if anything is written to disk. Check using 'archive log list' command it should show u the status of archive. Regards murosa@bankin ter.es To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] root@fatcity.cc: com Subject: Database in archivelog mode 22-Jun-2001 01:15 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi folks. I have a very strange behavour in a database. I want to put database inarchivelogmode, I've changed log_archive_start to true, log_archive_dest_1 to a location where I can write and log_archive_start to true. Then I follow next sequence: shutdown immediate; startup mount alter database archivelog; alter database open; alter system archive log start; In third step I get: ERROR at line 1: ORA-01126: database must be mounted EXCLUSIVE and not open for this operation. Next two sentence are executed correctly. When I select * from v$instance; I've got SQL select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --- HOST_NAME VERSION STARTUP_T STATUS PARTHREAD# ARCHIVE LOG_SWITCH_ - - --- --- -- --- --- LOGINS SHU DATABASE_STATUS INSTANCE_ROLE -- --- - -- 2 webspher2 ebkppr02 8.1.6.3.0 21-JUN-01 OPENYES 2 STARTED ALLOWEDNO ACTIVEPRIMARY_INSTANCE in both instance, because is an OPS. Initalization parameter remote_login_password is exclusive. I know that I have an error but I don't know which and why, but it doesn't work in archivelog mode. Anybody can help me?. Thank you very much in advance. Miguel Urosa. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- 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
Re: EXPORT questions
Dear Seema, If you take export using sys user you will be exporting the base tables also which is not good when recreating your database from scratch and using import to transfer database accross. To avoid this we use the system user which only exports the views and not the base tables. Regards Seema Singh oracledbam@hoTo: Multiple recipients of list ORACLE-L tmail.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: EXPORT questions om 19-Jun-2001 03:48 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book hi What is diffrent between the full export taken by sys user and system user? Why people prefer the system user to take full export? If any one can take full export with sys user in FGAC case then how to import incase of recovery means from sys user itself likefollowing command. imp userid=sys/chane-on-install file=test.exp fromuser=one touser=one Thanks in advance. -Seema _ Get your FREE download of MSN Explorer at http://explorer.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). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql*Loader and assign a ROLLBACK segment
Phillipe: Try setting the other rollback segments temporarily offline so that the loader only finds the big segment for use. Regards adm-unix@eram et-sln.ncTo: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] root@fatcity.cc: com Subject: Sql*Loader and assign a ROLLBACK segment 19-Jun-2001 08:50 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hello, I have a sql*loader script which failed due to the non possibility to extend a rollback segment in the TBS ROLLBACK_DATA. Oracle version 8.1.6.2 on AIX 4.3.3. I have a huge rollback segment in the TBS ROLLBACK_DATA, but how tell to sql*loader to use this rollback segment ? I have not found any option to assign a rollback segment in the doc. I just found the UNRECOVERABLE option and i will try with it. Any other ideas, suggestions welcome. Best regards Philippe -- 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). __ Visit us at www.singaporeair.com. __ -- 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).