RE: Database Instance
k You > > > > Regards, > > Jkean > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > _ > > Do you Yahoo!? > Free > <http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/> > Pop-Up Blocker - Get it now > > __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta 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: Sinardy Xing 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: Database Instance
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!? > Free > <http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/> > Pop-Up Blocker - Get it now > > __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta 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: Sinardy Xing 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: Database Instance
Think of Object Oriented, then 1 db can be an Object, better security, easy to upgrade or downgrade, easy to change any setting as you like. Think of memory, overhead, administration, 1 instance will be better (I think, specially backup and recovery) Think of performance, you can tune each db individually and contention will quite easy to maintain. Think of risk and potential application bug, why your management want to overhaul the system? About the schema that transparent or invisible, you can search Oracle Doc (SQL Plus) with key word "GRANT" or "REVOKE" (If you decide to merge your databases) Merry X'mas Sinardy -Original Message- Sent: 24 December 2003 09:49 To: Multiple recipients of list ORACLE-L Dear : All First and foremost , if i ask stupid question pls forgive me coz i new to oralce. I have a question here. I have a server, and this server contains 5 oracle database. Each database contains 5 web application that are running on live ( production server ). As i understand abt oracle , every database that i created will have 1 instance. So since this server hold 5 database then i will have 5 instances running. Lately, my manager want me to remove all the databases and remain a single instance. I was wondering if i move everything into single database then if one of the application fail due to oracle error , then all other four application will fail also rite ? Each of our web application needs to have 2 schema and both schema have to be transparent to each other. While other application schema will be invisible to each other. Since i have 5 web app then i will need 10 schema.One major problem is all the 10 schema will contain same table name. It will be a mess putting so much app in a single db . Pls correct me if i am wrong and do let me know what are the pro and cons or maybe you can educate me with some of the best practice to setup a proper production server environment. Thank You Regards, Jkean __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta 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: Sinardy Xing 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: Free Memory in v$sgastat
Hi, Those are lines from my friend Oracle University student guide (Original) Sinardy -Original Message- Sent: 16 December 2003 22:34 To: Multiple recipients of list ORACLE-L Sinardy, where does oracle say anything like that about free memory? Please, quote me an article or URL. Second, if you are not using MTS, your PGA is a part of your dedicated server address space, not SGA. It does exist, though. Similarly, UGA goes to shared pool instead. Buy yourself The Book (Practical Oracle 8i) and read all about the architecture. I'll get rich from all commissions I receive. of large pool. On 12/16/2003 12:24:25 AM, Sinardy Xing wrote: > Hi Mladen, > > I try to understand 8i, and I am not using MTS, my current understanding is UGA and > PGA only exists (I mean in use or in the picture) when you are using MTS. > > Oracle themselves said "'free memory' are more properly thought of as wasted space" > > I just wondering why this million dollar RDBMS can't make use of this space? > everything are in terms of Oracle Block, you can release and reuse the blocks. > Well maybe quite difficult to get long continuous blocks, but it still free space, I > am so blur now > > > Sinardy > > -Original Message- > Sent: 16 December 2003 12:54 > To: Multiple recipients of list ORACLE-L > > > Sinardy, you've attended wrong database tuning course. You need free memory in your > shared pool. > There is no such thing as "sga fragmentation" unless there is not enough free memory > to satisfy average > request. While oracle is not monitoring the size of an average shared pool request. > you have things > like session_uga_memory and session_pga_memory in v$mystat. In v9 there is also > "session_stored_procedure_space". > If the instance doesn't have enough room to load the next thing to execute (SQL, > PL/SQL, Java), it will have > to make room. Generally speaking, making room hurts. You want to have enough room > to load your > stuff into the shared pool and then some. That "room" is also known as "free > space". Look into the tuning manual on the > OTN and make sure that your buffer cache hit ratio is high enough (sorry folks, I > couldn't resist). > > > > On 2003.12.15 23:19, Sinardy Xing wrote: > > Hi all, > > > > Why free memory in v$sgastat is a symptom of the fragmentation? > > > > Why these "free memory" are more properly thought of as wasted space? > > > > > > > > Thanks > > > > Sinardy > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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: Sinardy Xing > 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). > Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
RE: alter tablespace offline
Hi Jeroen, What is problem? Error msg or something? Sinardy -Original Message-From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED]Sent: 16 December 2003 18:12To: Multiple recipients of list ORACLE-LSubject: alter tablespace offline Hi, This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and we encountered a strange problem in issueing alter tablespace name offline. I had to reorganize tablespace and when testing this I did this manually and no problem at all. I put the statements in a script. Executing the script put the tablespace offlline with exactly : alter tablespace name offline Moving the file with os and then starting up the database in mount phase lead to the problem it would not do this. Backtracking this to a test environment and rereading the docs lead me to that I should have used alter tablespace name offline normal I cannot remember whether I did this ok in the first tests but I might have copied it wrong into my script. What is the problem in issueing a alter tablespace name offline so without the normal clause? Details: HP-UX11.11, Oracle 9.2.0.4 Regards, Jeroen
RE: Free Memory in v$sgastat
Hi Mladen, I try to understand 8i, and I am not using MTS, my current understanding is UGA and PGA only exists (I mean in use or in the picture) when you are using MTS. Oracle themselves said "'free memory' are more properly thought of as wasted space" I just wondering why this million dollar RDBMS can't make use of this space? everything are in terms of Oracle Block, you can release and reuse the blocks. Well maybe quite difficult to get long continuous blocks, but it still free space, I am so blur now Sinardy -Original Message- Sent: 16 December 2003 12:54 To: Multiple recipients of list ORACLE-L Sinardy, you've attended wrong database tuning course. You need free memory in your shared pool. There is no such thing as "sga fragmentation" unless there is not enough free memory to satisfy average request. While oracle is not monitoring the size of an average shared pool request. you have things like session_uga_memory and session_pga_memory in v$mystat. In v9 there is also "session_stored_procedure_space". If the instance doesn't have enough room to load the next thing to execute (SQL, PL/SQL, Java), it will have to make room. Generally speaking, making room hurts. You want to have enough room to load your stuff into the shared pool and then some. That "room" is also known as "free space". Look into the tuning manual on the OTN and make sure that your buffer cache hit ratio is high enough (sorry folks, I couldn't resist). On 2003.12.15 23:19, Sinardy Xing wrote: > Hi all, > > Why free memory in v$sgastat is a symptom of the fragmentation? > > Why these "free memory" are more properly thought of as wasted space? > > > > Thanks > > Sinardy > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Sinardy Xing 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).
Free Memory in v$sgastat
Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these "free memory" are more properly thought of as wasted space? Thanks Sinardy
RE: Clean temporary tablespace
Hi, Restartup your database if possible. If you set the datafile autoextent on then you have to recreate that tablespace, if you set it to not autoextent on for some query may fail due to not enough sorting space. Sinardy -Original Message- Sent: 12 November 2003 14:24 To: Multiple recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- Поцелуев Виталий Игоревич (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Sinardy Xing 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: Multithreaded server - effect of POOLING=ON option
Hi Peter, pooling is for: user that connected but idle will be disconnected temporary for new incoming or outgoing request. ON or BOTH or YES or TRUE is to turn on OFF or FALSE or NO is default to turn off IN for incoming connection only OUT for outgoing connection only Sinardy -Original Message- Sent: 12 November 2003 13:04 To: Multiple recipients of list ORACLE-L Hi Peter, There are many parameters for this particular option: ON, OFF, YES, NO, IN, OUT, TRUE, FALSE, BOTH (not even sure I've exhausted the entire list here) Used for connection pooling, the values you choose for this parameter impact your idle network connections. For more info, feel free to check out this link: http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/mts.htm#453787 hth, melanie --- "Schauss, Peter" <[EMAIL PROTECTED]> wrote: > Thanks for all of the input on the multi-threaded > server. I have one > more question: > > What is the effect of the POOLING option on the > MTS_DISPATCHERS > specification? > > Thanks, > Peter Schauss > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Schauss, Peter > 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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: Sinardy Xing 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: Antw: RE: I wanna know how Oracle uses file organization in
No I am serious -Original Message- [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 14:49 To: Multiple recipients of list ORACLE-L Hi Sinardy, one little correction: you forgot the winking smiley at the end of your last sentence ;-) Greetings, Guido >>> [EMAIL PROTECTED] 31.10.2003 05.39 Uhr >>> Hi Thai, B-tree is short for binary tree, Indexing method make use of Binary search function to fast retrieve your records, therefore require sorted records. B+ tree (I don't know this one, never heard) Go to www.Oracle.com download the document for free. Reading order: 1. Concept 2. SQLPlus 3. DB Admin 4. Backup and Recovery 5. Network After you finish all of these you have basic skill, you can be an Oracle DBA. Good luck. Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX OT: deleting file starting with --
rm -i ??cart -Original Message- Sent: 31 October 2003 12:44 To: Multiple recipients of list ORACLE-L Hi, How do I delete a file named --cart ? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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: Sinardy Xing 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: I wanna know how Oracle uses file organization in their DB
Hi Thai, B-tree is short for binary tree, Indexing method make use of Binary search function to fast retrieve your records, therefore require sorted records. B+ tree (I don't know this one, never heard) Go to www.Oracle.com download the document for free. Reading order: 1. Concept 2. SQLPlus 3. DB Admin 4. Backup and Recovery 5. Network After you finish all of these you have basic skill, you can be an Oracle DBA. Good luck. Sinardy -Original Message- Sent: 31 October 2003 11:49 To: Multiple recipients of list ORACLE-L Hello all, I am looking for documents saying how Oracle uses file organizations like B-tree, B+ tree, heap file, index file . in their database. If you know where I can get those documentations, could you let me know? Thank you. Thai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thai.Dang-Vu-1 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile ?
Hi, How about do these: 1. Create new tablespace 2. Move all objects from Old tablespace to new tablespace 3. drop old tablespace and delete the files 4. recreate the old tablespace with correct datafiles size 5. move all objects from new tablespace to redesign old tablespace 6. drop new tablespace and delete the files. Only if your database size is small or medium. Sinardy -Original Message- Sent: 29 October 2003 17:24 To: Multiple recipients of list ORACLE-L I don't beelive you can drop a datafile from a tablespace, you have to drop the tablespace, just reaize the datafile to 1M if space is the problem Regards >From: Prem Khanna J <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How to drop a datafile ? >Date: Tue, 28 Oct 2003 22:19:24 -0800 > >doc 111316.1 doesn't mention about using >OEM for the same. > >so i hope it cannot be done with OEM. >am i right LIST ? > >so how do i do it from sqlplus ? > >TIA. >Jp. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Prem Khanna J > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards 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: Sinardy Xing 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: dba interview questions
I ask things like "tell me the thing you've done that you are most proud of" and "tell me your nightmare situation and how did you recover from it" Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Renaming Role
1. create the new role 2. create script spool /tmp/move_role.sql select 'alter user ' || grantee || ' grant new_role;' from dba_users where granted_role = 'OLD_ROLE' host more /tmp/move_role.sql --@/tmp/move_role Sinardy -Original Message- Sent: 23 October 2003 12:49 To: Multiple recipients of list ORACLE-L Dear all, Is it possible to rename a role? If it can't be done, what is the best approach to port all the users in the "old" role to the new "role"? Thanks in advance. Regards, seth. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: setiady 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: Sinardy Xing 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: Can I concatenate several rows without a procedure?
That is post fix binary tree POST FIX, right? -Original Message- Sent: 22 October 2003 10:44 To: Multiple recipients of list ORACLE-L Stephane, Pretty slick trick!!! But I can't believe that you, of all people, didn't throw in an analytic just to confuse things even more, plus, avoid that second pass on sliced_kipling ;-) SQL> l 1 select translate(ltrim(text, '/'), '/', ' ') verse 2 from (select text, row_number() over (partition by verse order by verse, lvl desc) rn 3from (select verse, level lvl, sys_connect_by_path(chunk, '/') text 4 from sliced_kipling 5 connect by verse = prior verse 6 and piece - 1 = prior piece)) 7* where rn = 1 SQL> / VERSE Oh, East is East, and West is West, and never the twain shall meet, Till Earth and Sky stand presently at God's great Judgment Seat; But there is neither East nor West, Border, nor Breed, nor Birth, When two strong men stand face to face, tho' they come from the ends of the earth! And hey, it reduced sorts and consistent gets in this particular case ;-) Ok, my head hurts from dumb SQL tricks, someone else take it further from here ;-) Later, Larry G. Elkins [EMAIL PROTECTED] > SQL> select * from sliced_kipling; > > VERSEPIECE CHUNK > -- -- -- >1 1 Oh, East is East, >1 2 and West is West, >1 3 and never the twain shall meet, >2 1 Till Earth and Sky stand >2 2 presently at God's great Judgment Seat; >3 1 But there is neither East nor West, >3 2 Border, >3 3 nor Breed, >3 4 nor Birth, >4 1 When two strong men stand face to face, >4 2 tho' they come from the ends of the earth! > > 11 rows selected. > > SQL> @magic_query > > VERSE > -- > -- > Oh, East is East, and West is West, and never the twain shall meet, > Till Earth and Sky stand presently at God's great Judgment Seat; > But there is neither East nor West, Border, nor Breed, nor Birth, > When two strong men stand face to face, tho' they come from the ends of > the earth! > > > SQL> l > 1 select translate(ltrim(x.text, '/'), '/', ' ') verse > 2 from (select verse, level lvl, sys_connect_by_path(chunk, '/') text > 3 from sliced_kipling > 4 connect by verse = prior verse > 5 and piece - 1 = prior piece) x, > 6 (select verse, max(piece) piecemax > 7 from sliced_kipling > 8 group by verse) y > 9 where x.verse = y.verse > 10and x.lvl = y.piecemax > 11* order by x.verse > SQL> > > I am not sure though that I satisfy the 'simple SQL' requirement :-). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Sinardy Xing 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: DB Parameters
use bind variable -Original Message- Sent: 09 October 2003 16:29 To: Multiple recipients of list ORACLE-L Hi List , Can you help me please , What are the database parameters that i have to increase or modify in order to increase the speed of my ddl statments ,i have a statment that delete a table with 4 record but it takes about nine hours to accomplish !!! Is their any parameters on the server that i have to check ??,Increase rollback segment is not helpfull at all . Iam runningoracle 9.2.0.1.0 production . Thanks for your help. Bye. ++ This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this message in error please delete it and any files transmitted with it, after notifying [EMAIL PROTECTED] Any opinions expressed in this message may be those of the author and not necessarily those of the Company. The Company accepts no responsibility for the accuracy or completeness of any information contained herein. This message is not intended to create legal relations between the Company and the recipient. Recipients should please note that messages sent via the internet may be intercepted and that caution should therefore be exercised before despatching to the Company any confidential or sensitive information. ++ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati 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: Sinardy Xing 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: consistent gets
yeah rite, i just test u -Original Message- Sent: 08 October 2003 16:29 To: Multiple recipients of list ORACLE-L Hi, Consistent gets means the blocks oracle have to visit , it means the real cost of the SQL.(consisteng gets + db block gets) Reduce SGA size has nothing to do with Consistent gets. TO reduce consistent gets, only Tune the SQL or create proper index etc can help. Zhu Chao. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 08, 2003 3:34 PM If you want to reduce your consistent gets, you can reduce your sga size -Original Message- Sent: 08 October 2003 14:14 To: Multiple recipients of list ORACLE-L Hi, What does the meaning for this consistent gets. Some time my statement return more consistent gets in statistics. How I can reduce this Consistent gets. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao 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: Sinardy Xing 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: Strange Request
ora-600 may result your db down or crash -Original Message- Sent: 08 October 2003 10:09 To: Multiple recipients of list ORACLE-L I want the DB to see and act on an ORA-00600, not just record one in the alertSID.log Thanks, Mike -Original Message- Sent: Tuesday, October 07, 2003 6:54 PM To: Multiple recipients of list ORACLE-L did you just want to see it in an alert.log? or are you working with a dump? joe Vergara, Michael (TEM) wrote: >Ok...strange request time. I want to test a script that I found >on the DBA Village web site. It's supposed to capture some >information whenever there's a DB error. > >Does anybody know how to trigger a 'benign' ORA-600 so I can test >this functionality? > >Thanks, >Mike > > >--- >=== >Michael P. Vergara >Oracle DBA >Guidant Corporation > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Vergara, Michael (TEM) 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: Sinardy Xing 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: Strange Request
:) -Original Message- Sent: 08 October 2003 09:54 To: Multiple recipients of list ORACLE-L did you just want to see it in an alert.log? or are you working with a dump? joe Vergara, Michael (TEM) wrote: >Ok...strange request time. I want to test a script that I found >on the DBA Village web site. It's supposed to capture some >information whenever there's a DB error. > >Does anybody know how to trigger a 'benign' ORA-600 so I can test >this functionality? > >Thanks, >Mike > > >--- >=== >Michael P. Vergara >Oracle DBA >Guidant Corporation > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Sinardy Xing 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: consistent gets
If you want to reduce your consistent gets, you can reduce your sga size -Original Message-From: Sultan Syed [mailto:[EMAIL PROTECTED]Sent: 08 October 2003 14:14To: Multiple recipients of list ORACLE-LSubject: consistent gets Hi, What does the meaning for this consistent gets. Some time my statement return more consistent gets in statistics. How I can reduce this Consistent gets. Thanks in advance.
RE: Table not reusing deleted space
Hi Leng, I have suggestion, "FOR YOU TO TEST ONLY" *CHECK SIZE** 1. EXPORT target tables with COMPRESS = Y parameter 2. DROP target tables *CHECK SIZE** 3. CREATE TABLE (target tables) 4. IMPORT target tables *CHECK SIZE** Good luck Sinardy -Original Message- Sent: 02 October 2003 13:50 To: Multiple recipients of list ORACLE-L Here are the stats if you're interested. I can't run dbms_space on the table because it will lock up the application. This table is accessed ALL the time. It grabbed another 100M today! Extent management is LOCAL with UNIFORM SIZE of 100M. 24th Sep 2003 OWNE SEGMENT_NAME TABLESPACE_NAMEKB NEXTKB EXT[MAX] % Inc - -- CCA CONNECT_TASK[T] CC_TASK_TABS3,891,200 102,400 38[2147483645]0 CCA CONNECT_TASK_CONNECTID[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] 0 CCA CONNECT_TASK_CRN[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] 0 CCA PK_CONNECT_TASK[I]CC_TASK_IDXS 102,400 102,400 1[2147483645] 0 OWNE TABLE_NAME NUM_ROWS AVG_ROW_LEN BLOCKS EMPTY_BLOCKS CHAIN_CNT -- -- --- -- -- CCA CONNECT_TASK 1855834898 484189 2210 1445 2nd Oct 2003 OWNERSEGMENT_NAME TABLESPACE_NAME KB NEXTKB EXT[MAX] - CCA CONNECT_TASK[T] CC_TASK_TABS 4,198,400 102,400 41[2147483645] CCA CONNECT_TASK_CONNECTID[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] CCA CONNECT_TASK_CRN[I] CC_TASK_IDXS 102,400 102,400 1[2147483645] CCA PK_CONNECT_TASK[I]CC_TASK_IDXS 102,400 102,400 1[2147483645] OWNE TABLE_NAME NUM_ROWS AVG_ROW_LEN BLOCKS EMPTY_BLOCKS CHAIN_CNT -- -- --- -- -- CCA CONNECT_TASK 1841134958 51269912100 1528 -------- From: "Sinardy Xing" <[EMAIL PROTECTED]> Date: Wed, 1 Oct 2003 14:51:40 +0800 Subject: RE: Table not reusing deleted space Hi Kaing, Have you check the degree of fragmentation? have you check your extent size? Sinardy -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng 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: Sinardy Xing 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: Table not reusing deleted space
Hi Kaing, Have you check the degree of fragmentation? have you check your extent size? Sinardy -Original Message- Sent: 01 October 2003 14:20 To: Multiple recipients of list ORACLE-L Hello everyone, Env: 8.1.7.4, SunOs 5.8 64 Bit We seem to hitting bug 1262161. The bug seems to imply that tables with triggers behind them do not reuse blocks on the freelist. We have a table that should only use 1G (num_rows * avg_row_len), but is actually using 4.1G and growing in size!! It is subject to high inserts, deletes and updates. But the resultant number of rows is around 200K rows. The insert is just a normal insert, no APPEND hint is used. Updates do not really expand the rows. We've changed PCTUSED from 40 to 70 to no avail. The table does not seem to reuse the deleted space. In trying to prove this error in our environment I've created 5 test scenarios but was never able to reproduce the problem. It only exists on our production database. I'm stumped. Has anyone encountered this problem? Or can someone explain to me why our production database is not reusing the space deleted and placed back on the free list? I should also add that the table in question is a master table of a snapshot. TIA, Leng. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng 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: Sinardy Xing 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: two instances on same box (Suse Linux ES 8)
Title: two instances on same box (Suse Linux ES 8) Hi Helmut, when you do switch user su - newuser use the "-" it will run the .profile of that user, I assume your problem is because the env variables. Otherwise (or) you can open a new telnet windows to startup the other database? btw if you only have one owner (DBA group) then only few variables you need to change: for example: ORACLE_HOME=9.0.1 --- below here are static Make user you reuse the ORACLE_HOME LIBRARY_PATH=$ORACLE_HOME/lib <- i forgot the variable name PATH=$PATH:$ORACLE_HOME/bin:. ORACLE_SID=__ Sinardy -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]Sent: 22 September 2003 17:55To: Multiple recipients of list ORACLE-LSubject: two instances on same box (Suse Linux ES 8) Hi! We are running 2 Oracle instances on one Suse Linux box (under the same Unix oracle user). We have two oracle homes 9.0.1 (/opt/oracle/iasdb) and 9.2.0 (/opt/oracle/loga) The first instance starts up fine, but the second one fails. It seems to me that switching the environments fails. How do I switch between environments? ORAENV and dbhome don't work too well. oratab looks fine. Does anybody have experience with multiple instance on Linux (especially Suse). not sure whether Red Hat is similar... This is 9i on Suse Linux Enterprise Server 8. Thanks, Helmut
RE: minus vs. where not exists, vs. where not in
well superman is poorer than batman
-Original Message-
Sent: 22 September 2003 13:45
To: Multiple recipients of list ORACLE-L
Yeah, Superman had Super powers. Batman just relied on a bunch of gadgets.
Of course my original post was implying the classic "it depends". There
are some scenario's where a specific approach is faster than the other and
there are some scenario's where it doesn't matter because oracle can
rewrite the query effectively anyway. What does matter - "If in doubt test
it out".
"Sinardy Xing"
<[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
omsvc.com> cc:
Sent by: Subject: RE: minus vs. where not
exists, vs. where not in
[EMAIL PROTECTED]
.com
22/09/2003 15:29
Please respond to
ORACLE-L
I think Superman is stroger than Batman
-Original Message-
Sent: 22 September 2003 08:30
To: Multiple recipients of list ORACLE-L
I'm not sure that there is a good answer to that question. The question
sounds like the dilemma: who's stronger, Batman or Superman?
Unfortunately, superheroes do not exist, so we cannot have a real life
comparison. It is exactly the same with not exists vs. minus. Comparisons
make
sense only within a real life application in a real configuration, that is
why both mechanisms are provided. Sort_area_size does influence
performance,
unless memory is slow, system is swapping or something else.
In the world of superheroes, my favorite is Alice and her "fist of death".
On 2003.09.21 19:54, Mark Richard wrote:
>
> I don't have any scientific proof but I imagine the sort_area_size could
be
> different between "not exists" and "minus". When doing "minus" the
entire
> select string would have to be compared for equality, which could be very
> large depending on your string.
>
> Minus is probably an easier way (at least from a coding perspective) of
> comparing every column in a table, or incorporating complexity in the
> select statement.
>
> Having said that. Each statement has it's pros and cons and I guess it
> depends on the volume of the various queries, etc. For example, if the
> have table A with 5 rows and table B with 100 rows executing "select
> a.field from a where not exists (select 1 from b where b.field = a.field)
> will result in 5 quick searches (assuming b.field is indexed) whereas
> "select a.field from a where a.field not in (select b.field from b)" will
> result in a full index read of b, as would "select a.field from a minus
> select b.field from b". Obviously different queries and different
volumes
> will tip the scales in different directions.
>
> Regards,
> Mark.
>
>
>
>
>
> "Ryan"
>
> <[EMAIL PROTECTED]To: Multiple
recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
> >cc:
>
> Sent by: Subject: minus vs. where
not
> exists, vs. where not in
> [EMAIL PROTECTED]
>
> .com
>
>
>
>
>
>
RE: minus vs. where not exists, vs. where not in
gt;>>>>>>>>>>>>>>>>>>>>>>> > > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message (or responsible for > delivery of the message to such person), you may not copy or deliver this > message to anyone. > In such a case, you should destroy this message and kindly notify the sender > by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. > Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message that do not > relate to the official business of Transurban Infrastructure Developments > Limited and CityLink Melbourne Limited shall be understood as neither given > nor endorsed by them. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Sinardy Xing 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).
...
Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by it slef but the wrod as a wlohe. ceehiro
RE: How to keep "root" out?
Hi all, I think as a DBA you should have the root password for the database server. Will this close the case? Sinardy -Original Message- Sent: 03 September 2003 03:09 To: Multiple recipients of list ORACLE-L > Instead of trying to do things in software, which was designed not to resist > the "root" user, > why don't we concentrate on specialized hardware and procedures which exist > for that purpose? > Guns, threats of violence and blackmail are excellent means of keeping the > system administrator > out of the database. After all they're only human and chances are that a One more solution would be to migrate to Windows. Then you won't have any root user. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Sinardy Xing 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: more questions
how to startup oracle after machine is bootup? you must configure your /etc/oratab Ans: add this line your_sid:your_oracle_home:AUTO(auto is keyword) how to shutdown oracle before Unix is shutdown? Ans: I don't think that Oracle provide such feature, but you can write OS script add to your in your init.d or simpler way replace your init binary file with your own for example # init 6 your new init /where is my shutdown script/shutdown oracle.sh /or perhaps you want to shutdown listener too or other application do it here/bla.sh sync sync original_init $1 It seems to me that I cannot multiplex data files. Is that true? Ans: Yes Oracle only allow you to multiplex your control files and redolog files but not your data files, however Oracle do recommend you to do RAID 0 + 1 if you have the $$$. Sinardy -Original Message- Sent: 02 September 2003 11:29 To: Multiple recipients of list ORACLE-L Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHEN,JIN 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: Sinardy Xing 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 client and DNS
Hi John, Have you check your sqlnet.ora parameter? perhaps you want to try to add GLOBAL_DBNAME = hostname in your init.ora? Sinardy -Original Message- Sent: 01 September 2003 16:59 To: Multiple recipients of list ORACLE-L Having problems getting Oracle 8 client working with DNS. I can ping the server hostname from my Windows 2000 client, but I cannot tnsping it Do I need to do anything at the server end. The listener is running on the server. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn 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: Sinardy Xing 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: one question on backup and restore
Hi Zhu Chao, Yes, I think Jin is using shared external storage, otherwise if his server A down how he going to copy all his files from server A to server B. if this is the case what Jin may do is propose an clustering software. Otherwise, he must backup his database into media. Sinardy -Original Message- Sent: 29 August 2003 11:09 To: Multiple recipients of list ORACLE-L Hi, It can be done via cluster software like VCS (Veritas Cluster Server) or Sun Cluster. But one mandetory requrement: you must place your oracle database(control,redo,data etc) on the shared storage, that is , server A and Server B can access the same disk array. If you really do not have shared storage, consider using oracle data guard. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 6:34 AM > Hi Greetings, > > I have such a plan but not sure if it is feasible. Please help! > I install oracle server on two different machine (say A and B). In > general, we run on one instance on server A. If we met any problem > on server A, we copy all data files, control files and redo files > plus spfile.ora to server B. Can server B startup that > instance? > > Is there any restriction on this plan? or it is totally > impossible? Would you please advise why? > > Thanks alot! > Jin > btw, they both are Solaris. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: CHEN,JIN > 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: zhu chao 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: Sinardy Xing 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: more questions
Hi Tanel, I can't remember what is the correct procedure about auto startup Oracle. I think you are right is located in /var/opt/oracle (my clustering software does it for me by comfiguring this oratab) perhaps Jin can read the manual about startup and shutdown, I remember there is one small chapter special for this in DB Administration doc. I read from Unix administration book long ago, the author said something like this replace the rm binary to something like this: cp rm .rm.original echo ".rm.original -i" > rm May be is not a good book, I don't know... Sinardy -Original Message- Sent: 02 September 2003 17:54 To: Multiple recipients of list ORACLE-L Hi! > how to startup oracle after machine > is bootup? > you must configure your /etc/oratab > Ans: > add this line > your_sid:your_oracle_home:AUTO(auto is keyword) Y or N are the keywords. I don't remember that auto has been mentioned anywhere. I didn't find any occurrence it in dbstart either. So where is this coming from? And the OP is using Solaris, thus his oratab file is under /var/opt/oracle. > or simpler way replace your init binary file with your own > for example Yeah right, lets just modify kernel binary instead!? Do you really do this kind of stuff at your work? Really spooky... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep "root" out?
er's sqlnet.ora. Then > >> everyone has to use a password. > >> > >> Tanel. > >> > >> - Original Message - > >> From: Walter K <mailto:[EMAIL PROTECTED]> > >> To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> > >> Sent: Thursday, August 28, 2003 6:34 PM > >> Subject: How to keep "root" out? > >> > >> Just for grins, I'll ask this question... Is there any way to keep the Unix > >> "root" user from logging into the database (i.e. connect internal or / as > >> sysdba)? Currently using 8.1.7.4 on Solaris 8 here. > >> > >> We have a couple people in our Unix admin group that feel the need to "help" > >> by writing their own DB monitoring scripts. Of course, they don't know what > >> they're talking about. They do not have formal logins for the database, but > >> since they are root users they are connecting via "connect internal". This is > >> not only counterproductive but actually a potential security issue--just > >> because someone has root doesn't necessarily entitle them to see the data in > >> the database. What if it is a payroll database? > >> > >> So, I'm curious, is there any way to prevent access via "connect internal" or > >> "/ as sysdba"? > >> > >> Thanks in advance. > >> > >> W > >> > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sinardy Xing > 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: Tanel Poder 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep "root" out?
ist ORACLE-L <mailto:[EMAIL PROTECTED]> > >> Sent: Thursday, August 28, 2003 6:34 PM > >> Subject: How to keep "root" out? > >> > >> Just for grins, I'll ask this question... Is there any way to keep the Unix > >> "root" user from logging into the database (i.e. connect internal or / as > >> sysdba)? Currently using 8.1.7.4 on Solaris 8 here. > >> > >> We have a couple people in our Unix admin group that feel the need to "help" > >> by writing their own DB monitoring scripts. Of course, they don't know what > >> they're talking about. They do not have formal logins for the database, but > >> since they are root users they are connecting via "connect internal". This is > >> not only counterproductive but actually a potential security issue--just > >> because someone has root doesn't necessarily entitle them to see the data in > >> the database. What if it is a payroll database? > >> > >> So, I'm curious, is there any way to prevent access via "connect internal" or > >> "/ as sysdba"? > >> > >> Thanks in advance. > >> > >> W > >> > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sinardy Xing > 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: Tanel Poder 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: Sinardy Xing 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: one question on backup and restore
Hi Tanel, Very good post, because we are using clustering then I think Jin can have easier life with one, everything is like semi automatic. Sinardy -Original Message- Sent: 02 September 2003 17:44 To: Multiple recipients of list ORACLE-L Hi! You can do what you wanted without *any* clustering storage. An Oracle database can copied over and opened on another server, providing that the server has same architecture (e.g. 32bit i386) and the Oracle version used is supported on the operating system you run. For example, it is possible to transport a 8.1.7.0.0 database from PentiumIII running WinNT 4.0 to 8.1.7.0.0 running on Pentium4 Xeon running Win2000. Or from Sparc2 SunOS 2.6 to Sparc3 Solaris8. What you have to worry about is, how to you get your clients to connect to server B after A is down? You can either transfer the IP address (manually or using cluster software) or create your tnsnames.ora files such that clients connect to server B if they can't access server A. Also, it might be problematic to copy your database over if server A has hopelessly crashed. If you want more failure-proof system, look for standby databases (data guard in 9i) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 6:39 AM > Hi Zhu Chao, > > Yes, I think Jin is using shared external storage, otherwise if his server A down how he going to copy all his files from > server A to server B. > if this is the case what Jin may do is propose an clustering software. > > Otherwise, he must backup his database into media. > > Sinardy > > -Original Message- > Sent: 29 August 2003 11:09 > To: Multiple recipients of list ORACLE-L > > > Hi, > It can be done via cluster software like VCS (Veritas Cluster Server) or > Sun Cluster. But one mandetory requrement: you must place your oracle > database(control,redo,data etc) on the shared storage, that is , server A > and Server B can access the same disk array. > If you really do not have shared storage, consider using oracle data > guard. > > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.cnoug.org > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, August 29, 2003 6:34 AM > > > > Hi Greetings, > > > > I have such a plan but not sure if it is feasible. Please help! > > I install oracle server on two different machine (say A and B). In > > general, we run on one instance on server A. If we met any problem > > on server A, we copy all data files, control files and redo files > > plus spfile.ora to server B. Can server B startup that > > instance? > > > > Is there any restriction on this plan? or it is totally > > impossible? Would you please advise why? > > > > Thanks alot! > > Jin > > btw, they both are Solaris. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: CHEN,JIN > > 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: zhu chao > 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: Sinardy Xing > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ---
RE: How to keep "root" out?
I have an idea 1. Use let say My_Tursted_SA schema, write a trigger that will disconnect new login as SYS or SYSTEM 2. If you want to use sys or system, you login as My_Trusted_SA disable the trigger. What do you think? Sinardy -Original Message- Richard Ji Sent: 31 August 2003 13:39 To: Multiple recipients of list ORACLE-L A strange loop eh? You must have read GEB. :) -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Sat 8/30/2003 12:49 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: How to keep "root" out? A... But if you encrypt it, where do you keep the key? How do you retrieve it for use? Don¹t forget to follow the problem to the next step... ...and when you do, you realize that if nobody can be trusted, then the problem of security becomes an Escher print, or a Mobius strip, or the infinity symbol, or the exact value of ³pi²... on 8/29/03 9:29 AM, Richard Ji at [EMAIL PROTECTED] wrote: > We assume the SA don't know much about Oracle. But if some one is > particularly interested in > getting into the database, he might be on this list as well learning all our > defense mechanisms. :) > Or doesn't have to be subscribed to it since this list is mirrored other > places and google is his friend. > I think the bottom line is, if you absolutely don't want the data to be seen, > encrypt it. > > My 2 cents. > > Richard Ji >> -Original Message- >> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] >> Sent: Friday, August 29, 2003 10:31 AM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: How to keep "root" out? >> > Walt, > > Something that has not been suggested - migrate your database to 9.2. Connect > as internal goes away. > > Other than that, I think the best suggestion you got was a conversation, and > granting access to the v$ tables thru a specific account for that person. > > And then put a long trigger in place tracking all connections to the database. > Keep track of all SYS connections. At least you know when things happen. And > periodically review the init.ora file for the database to make sure that > nobody changes anything. > > Good Luck! > > Tom Mercadante > Oracle Certified Professional >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 28, 2003 4:50 PM >> To: Multiple recipients of list ORACLE-L >> Subject: Re: How to keep "root" out? >> >> >> But someone determined to get in the database can simply edit sqlnet.ora >> >> >> >> "Tanel Poder" <[EMAIL PROTECTED]> >> Sent by: [EMAIL PROTECTED] 08/28/2003 10:24 AM >> Please respond to ORACLE-L >> >> To:Multiple recipients of list ORACLE-L >> <[EMAIL PROTECTED]> >> cc: >> Subject:Re: How to keep "root" out? >> >> >> Hi! >> >> Put sqlnet.authentication_services = none in your server's sqlnet.ora. Then >> everyone has to use a password. >> >> Tanel. >> >> - Original Message - >> From: Walter K <mailto:[EMAIL PROTECTED]> >> To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> >> Sent: Thursday, August 28, 2003 6:34 PM >> Subject: How to keep "root" out? >> >> Just for grins, I'll ask this question... Is there any way to keep the Unix >> "root" user from logging into the database (i.e. connect internal or / as >> sysdba)? Currently using 8.1.7.4 on Solaris 8 here. >> >> We have a couple people in our Unix admin group that feel the need to "help" >> by writing their own DB monitoring scripts. Of course, they don't know what >> they're talking about. They do not have formal logins for the database, but >> since they are root users they are connecting via "connect internal". This is >> not only counterproductive but actually a potential security issue--just >> because someone has root doesn't necessarily entitle them to see the data in >> the database. What if it is a payroll database? >> >> So, I'm curious, is there any way to prevent access via "connect internal" or >> "/ as sysdba"? >> >> Thanks in advance. >> >> W >> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Question about Constraint
Hi, Unique(companynumber, type) or you combine 2 columns together CompanyNumber_Type (this can become primary key, I don't think you need the id column, pseudo column rownum is the same) You have lesser indexing 123_1 123_2 Sinardy -Original Message- Sent: 29 August 2003 18:24 To: Multiple recipients of list ORACLE-L Sounds like 'Companynumber' and 'Type' should be either a compound Primary Key, or a unique index. Which begs the question of what 'Id' is doing - perhaps you don't need it. peter -Original Message- Sent: Friday, August 29, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hallo, I would like to gets ome help on this: I have this table IdCompanynumber First Name LastNameType 1 123 Jim Andersson 1 2 234 Tom Perkins 2 3 565 Henry Ford1 I would like to have a constraint so when I try to add and the same companynumber that already exists(for instance 234) I am not allowed to do this if the filed Type has the value 1. So if I add a companynumber which already exists and the Type is 2, then I should be allowed to add this companynumber. Maybe this is simple but woul dreally appreciate some help onhow to write this. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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: Sinardy Xing 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: get sid (session id) and serial#?
Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL> desc v$session SQL> select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by >sqlplus scott/[EMAIL PROTECTED] In this connection, SQL> What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: OT: Hey Jared!! -90 degree OT Joke
Yes, left brain connect to the right part of your body right brain connect to the left part of your body When you do DB design your using more of your right brain. When you have SQL syntax error you use your left brain more. -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: 29 August 2003 01:30To: Multiple recipients of list ORACLE-LSubject: RE: OT: Hey Jared!! -90 degree OT Joke I vaguely remember hearing : * right handed people use left side of brain * that left handed people use right side of brain Correct??? I think right or left just use it. I mean use something. "Orr, Steve" <[EMAIL PROTECTED]> wrote: Hmmm... So you're saying that women aren't in their right mind? Takingit to the off topic list.-Original Message-Sent: Thursday, August 28, 2003 2:59 AMTo: Multiple recipients of list ORACLE-LHi,This is my own theory, you can't find this information from OracleDocument.Well... talking about women and men.I believe most women use their left brain more than right brain and mostmen use their right brain more than left brain.Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2a day to buy a pair of shoe, and not that easy fall in love)- person names- history - words (perhaps this is the reason why women like to readnovels)Function of right brain- response to things (quick decision maker) - this is the reasonwh! y so many 2 minute men in the world- everything in general (see thing in big picture)- person faces- math, 1 + 3 / 7 ^ 53 = X- picturesWell Friends train both side of your brain, and for male DBA use yourleft brain when talk to women, then she is yours.RF tell me if I am wrongPS: Just kidding., going to see Mars tonight I miss my home town. :)Sinardy-Original Message-Sent: 28 August 2003 06:25To: Multiple recipients of list ORACLE-LWomen are also particularily good at remembering small nasty things frompast which you've already forgotten long time ago. Especially duringfights...:)Tanel.- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, August 28, 2003 12:59 AM> Not being sexist in any way, but it's my experience that Women are > much better "generalists" ! than men, but that men are much better > specialists. Thats why I think women do better in school early on, but> once we men get into the University level and pick our speciality, we > kick butt.>> My soon to be ex-wife was frequently much better remembering overallthings> than I was>> RF>>> -Original Message-> To: Multiple recipients of list ORACLE-L> Sent: 8/27/2003 6:44 AM>> c'mon... any virus named "SoBig" has to have been written by a man :)>> (yes, sexist, I know)>>> --- Tanel Poder <[EMAIL PROTECTED]>wrote:> > I've seen only one female in my life who would be capable of writing> > such virus. But that is not the issue (no offence, really). Women > > just don't> > waste their time on stuff like this.> >> > Tanel.> > - Original Message -> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > Sent: Wednesday, August 27, 2003 4:54 AM> >> >> > > "Guy"? You've eliminated 50% of all possible suspects...> > >> > >> > >> > > on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote:> > >> > > > I doubt they will ever find the real guy behind this.> > > >> > > > Tanel.> > > >> > > > - Original Message -> > > > To: "Multiple recipients of list ORACLE-L" > > > > <[EMAIL PROTECTED]>> > > > Sent: Tuesday, August 26, 2003 10:19 PM> > > >> > > >> > > >> For all you virus/worm lovers out there, justice do come:> > > >>> > > >> FBI Subpoenas Arizona ISP ! In Sobig Probe> > > >> Easynews says it's cooperating with the bureau to find the> > person> > > >> who uploaded the virus to a Usenet group it hosts. > > > >> informationweek.com/story/showArticle.jhtml?articleID=13800091> > > >>> > > >>> > > >>> > > >> Dick Goulet> > > >> Senior Oracle DBA> > > >> Oracle Certified 8i DBA> > > >> --> > > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net> > > >> -- > > > >> Author: Goulet, Dick> > > >> INET: [EMAIL PROTECTED]> > > >>> > > >> Fat City Network Services -- 858-538-5051> > http://www.fatcity.com> > > >> San Diego, California -- Mailing list and web hosting> > services> &g! t; > >>> > > > -> > > >> To REMOVE yourself from this mailing list, send an E-Mail> > message> > > >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > > >> and> > in> > > >> the message BODY, i
RE: OT: Hey Jared!! -90 degree OT Joke
Why don't you get an upgrade to Brain 2003, they have promotion this week free goodie bags for first 30 patients. -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: 29 August 2003 06:35To: Multiple recipients of list ORACLE-LSubject: RE: OT: Hey Jared!! -90 degree OT Joke sorry -- I do not read novels, do not respond visually to things, do not do math, do not rememberfaces, do not see details AND do not see the big picture i do eat and sleep a lot. so either I am more lowly evolved or i need a refund or brain transform from those with more of it (someone out there has ma brain) or i need to sue the doctor who said i have brains even showed me a ugly b/w pic of it. Rachel Carmichael <[EMAIL PROTECTED]> wrote: sorry -- I read novels, respond visually to things, do math, rememberfaces but not names, see details AND the big pictureso either I am more highly evolved and use both sides of my brain (nothardly) or the theory needs some modification--- Sinardy Xing <[EMAIL PROTECTED]>wrote:> Hi,> > This is my own theory, you can't find this information from Oracle> Document.> > Well... talking about women and men.> I believe most women use their left brain more than right brain> and most men use their right brain more than left brain.> > Function of left brain > - remember things, > - small thing but detail (this is the reason why women take 1/2 a> day to buy a pair of shoe, and not that easy fall in love)> - person names> - history > - words ! (perhaps this is the reason why women like to read novels)> > Function of right brain> - response to things (quick decision maker) - this is the reason why> so many 2 minute men in the world> - everything in general (see thing in big picture)> - person faces> - math, 1 + 3 / 7 ^ 53 = X> - pictures> > Well Friends train both side of your brain, and for male DBA use your> left brain when talk to women, then she is yours.> > RF tell me if I am wrong> > > PS: Just kidding., going to see Mars tonight I miss my home town.> :)> > > Sinardy> > > > > -Original Message-> Sent: 28 August 2003 06:25> To: Multiple recipients of list ORACLE-L> > > Women are also particularily good at remembering small nasty things> from> past which you've already forgotten long! time ago. Especially during> fights...> :)> > Tanel.> > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> Sent: Thursday, August 28, 2003 12:59 AM> > > > Not being sexist in any way, but it's my experience that Women are> much> > better "generalists" than men, but that men are much better> specialists.> > Thats why I think women do better in school early on, but once we> men get> > into the University level and pick our speciality, we kick butt.> >> > My soon to be ex-wife was frequently much better remembering> overall> things> > than I was> >> > RF> >> >> > -Original Message-> > To: Multiple recipients of list ORACLE-L> > Sent: 8/27/2003 6:44 AM> >> > c'mon.! .. any virus named "SoBig" has to have been written by a man> :)> >> > (yes, sexist, I know)> >> >> > --- Tanel Poder <[EMAIL PROTECTED]>wrote:> > > I've seen only one female in my life who would be capable of> writing> > > such> > > virus. But that is not the issue (no offence, really). Women just> > > don't> > > waste their time on stuff like this.> > >> > > Tanel.> > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > > Sent: Wednesday, August 27, 2003 4:54 AM> > >> > >> > > > "Guy"? You've eliminated 50% of all possible suspects...> > > >> > > >> > > >> > > > on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED]> wrote:> > > >> > > > > I doubt they will ever find the real guy behind this.> > > > >> > > > > Tanel.> > > > >> > > > > - Original Message -> > > > > To: "Multiple recipients of list ORACLE-L"> <[EMAIL PROTECTED]>> > > > > Sent: Tuesday,
RE: V$cache
You don't have enough privilages -Original Message- Sent: 28 August 2003 17:34 To: Multiple recipients of list ORACLE-L Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys . . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Need help with an error ORA-12640
Hi Peter, I think you have to make sure that non - admin user have proper access right to sqlnet.ora(what is the last modified time) tnsnames.ora s.a.b. names.oras.a.b. *.oras.a.b. And of course make sure your listener is started, then check all those *.ora files -IP address, hostname, port (if you are using TCP) then try use tnsping [service_name] to hit the listener. Perhaps you can do a little bit RE to read the patch what kind of changes oracle made to your system, I am not sure about this one, but I think you install that patch with administrator account. You said you install patch then you cannot connect, if this is not Oracle Names Server then I think you can connect from client station because their parameter files are the working version. If this is Oracle Names Server, you client will get the latest changes too most likely cannot connect too. If is not ONS then you can reference your client machine setting. hope this can help you, good luck Sinardy -Original Message- Sent: 28 August 2003 14:19 To: Multiple recipients of list ORACLE-L > Guru: > > I need help with an error ORA-12640. > > I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. > The sqlnet.authentication_services=(NTS) parameter is enabled and we do > not want to change the sqlnet.authentication_services=(NONE). > > The custom SQL application is launched by a Domain User on the Oracle > Server machine. If the Domain user has local administrative privileges, > it works with no error. If the Domain user does not have local > adminstrative privileges, it fails with the above error. > > I am at a lost to explain this. Does anyone has any idea? > > Thank you in advance. > > Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) 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: Sinardy Xing 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: OT: Hey Jared!! -90 degree OT Joke
nformation (like > > subscribing). > > > >> > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Tim Gorman > > > 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: Tanel Poder > > 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! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Sinardy Xing 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: Hey Jared
ng along the > >lines of "if > > > > > you think developers are expensive, go price some lawyers", but it > >certainly > > > > > bounced off him. At the time, I took it as just another colorful > >comment > > > > > from a colorful guy. But he was dead serious, along with his > >CIO/CFO > > > > > brethren, and the passing of Y2K and the dot-com bubble pop has > >expedited > > > > > his prediction... > > > > > > > > I always wondered where does this prejudice against us, computer geeks > >(my > > > > apologies to anyone offended by that expression, but I'm a hard core > >computer > > > > geek) comes from? I must say that this prejudice is very hard to > >understand. > > > > IT people are very well educated, very hard working, regularly willing > >to > > > > work long hours and sacrifice their weekends for the benefit of the > >company. > > > > I found that very same attitude against the "darned geeks" at several > > > > executives and managers of several companies I worked for. Even if > >lawyers > > > > are much more expensive the programmers, system and database > >administrators, > > > > application designers, they are still very willing to make the switch. > > > > I'm not quite sure why are we so hated? Why would anyone want to kill > > > > a nice and seet little wabbit? > > > > > > > > -- > > > > Mladen Gogala > > > > Oracle DBA > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Mladen Gogala > > > > 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: Jared Still > > > 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: Jared Still > > 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). > > _ > Enter for your chance to IM with Bon Jovi, Seal, Bow Wow, or Mary J Blige > using MSN Messenger http://entertainment.msn.com/imastar > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dilip Patel > 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: KENNETH JANUSZ 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: Sinardy Xing 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: Nature of Oracle-l has changed
Hi, This group is kind of boring for me because I don't have chance to answer questions, those gurus are so fast, they reply almost everything. they told you "wasn't so smart" or wasn't so... "smart" :) Sinardy -Original Message- Sent: 25 August 2003 18:00 To: Multiple recipients of list ORACLE-L Jared - a line caught my attention... > > When in school, I was told I would be more popular if I > "wasn't so smart". I was even told that once as an adult. > School?! If someone were to ask me if I had any contemporary knowledge of such damagement behaviour, all I could say would be 'You may think that, but I couldn't possibly comment'. * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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: Sinardy Xing 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: Tough Oracle DBA experience
Hi, 1. Hide sqlplus username/[EMAIL PROTECTED] from ps -ef |grep sqlplus (using unix scripting) 2. All about backup and recovery (Oracle Doc) 3. All about performance tunning (how to turn your Oracle's turbo on) 4. Pay sux, solution: working in progress. 5. If you have metalink access, you can find real problems there + solution. Will you give me one copy of your ebook? Sinardy -Original Message- Sent: 23 August 2003 21:09 To: Multiple recipients of list ORACLE-L Dear All, I am collecting (Just writing in a book ) of all tough problems , great issues handled with Oracle RDBMS as a DBA. Request you kindly send us the Top 5 Problems , Difficult scenarios(the most tough problems , with solution u did.)you faced so far in your DBA life. Hope to see many responses to this , atleast by Monday. Thanks a lot. Regards Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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: Sinardy Xing 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: Software Owner for Oracle8 and Oracle9
Hi, My answer Benefit using different users. 1. If the applications of thoese two databases should not access each other then you have better security, the owner of the instances processes are different. 2. If DBAs that manage those databases are different person than they can change the password without require another DBA to be arround. 3. There must be reasons why they propose this setting, perhaps you want to share why they decide such setting. Benefit using same user. 1. If the Oracle 8 require upgrade you don't have to install Oracle 9 again. 2. A little bit easy to manage. 3. According to Unix book (I don't remember the title of the book) it said "The lesser the users the more secure your system" (I agree with this line) Just my opinion... Sinardy -Original Message-From: Joshua Becker [mailto:[EMAIL PROTECTED]Sent: 25 August 2003 13:35To: Multiple recipients of list ORACLE-LSubject: Software Owner for Oracle8 and Oracle9 Hi all, We have currently a debate ongoing on the Unix side about the issue of having 1 Oracle software owner for both Oracle 8 and 9 versus having a new software owner for 9. What comments you have, w hat might be advantages and disadvantages using one or two users... Thank you in advance, Rgds Joshua Yahoo! Mail - Gratis: 6 MB lagringsutrymme, spamfilter och virusscan
RE: Online Document for Windows XP Home edition Severity 3
Title: Message Hi, Thanks this work. Sinardy -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: 22 August 2003 20:59To: Multiple recipients of list ORACLE-LSubject: RE: Online Document for Windows XP Home edition Severity 3 Sinardy, I've installed the Oracle docs simply by copying all the directories from the CD to my hard drive - no need to perform an installation. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Gudmundur Bjarni Josepsson [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 5:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Online Document for Windows XP Home edition Severity 3 Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinardy XingSent: 21. ágúst 2003 15:01To: Multiple recipients of list ORACLE-LSubject: Online Document for Windows XP Home edition Severity 3 Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oracle fail to run when I click Install/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms to remove the JVM? Can someone help me please.. Thanks Sinardy
RE: Online Document for Windows XP Home edition Severity 3
Title: Message Hi all, Thanks for your input... I am using Oracle 8i On-Line Generic Documentation CD-ROM Part #: A87860-01 The solution: I just copy all the d:\doc to my hd (quite huge) then open the index.htm This is huge man, I only have 30 gig storage Sinardy -Original Message-From: Venu Gopal [mailto:[EMAIL PROTECTED]Sent: 22 August 2003 17:44To: Multiple recipients of list ORACLE-LSubject: RE: Online Document for Windows XP Home edition Severity 3 If you have reached a point where you could press the Install/DeInstall button, it means that you don’t have any problem with your Java installation/settings. Try to troubleshoot in other areas. Also, update the Forum with your success story once you are done. ~Venu -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gudmundur Bjarni JosepssonSent: Friday, August 22, 2003 2:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Online Document for Windows XP Home edition Severity 3 Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinardy XingSent: 21. ágúst 2003 15:01To: Multiple recipients of list ORACLE-LSubject: Online Document for Windows XP Home edition Severity 3 Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oracle fail to run when I click Install/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms to remove the JVM? Can someone help me please.. Thanks Sinardy **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***
Online Document for Windows XP Home edition Severity 3
Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oracle fail to run when I click Install/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms to remove the JVM? Can someone help me please.. Thanks Sinardy
RE: Canada and US friends (YOUR WISH IS COME TRUE)
-Original Message- Sent: 18 August 2003 14:29 To: Multiple recipients of list ORACLE-L Please, please send us some candles and torchlights. If you can, please send in some John Smith Extra Smooth and Bailey's Irish Cream. When I come to think of it, you can skip candles and lights and start sending in the good stuff. On 2003.08.18 00:44, Sinardy Xing wrote: > Hi Canada and US friends, > > Can your systems survive the blackout disaster? > > Do you need recovery? Everything is ok out there? > > > Sinardy > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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:
DIAL 911 -Original Message- Sent: 18 August 2003 17:24 To: Multiple recipients of list ORACLE-L help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe 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: Sinardy Xing 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: HELP
DIAL 911 -Original Message- Sent: 18 August 2003 17:14 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe 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: Sinardy Xing 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: Installation problems (8.1.7 on AIX 5.2)
Hi Zhou, This most likely becoz your OS is incomplete you must install FULL DISTRIBUTION VERSION Upgrade your OS Sinardy -Original Message- Sent: 18 August 2003 17:14 To: Multiple recipients of list ORACLE-L I am trying to install Oracle 8i release 3 (8.1.7.0.0 - as this is the minimum version of Oracle that our products support) onto an IBM Server running AIX 5L. I have followed the instructions in the Oracle installation guide and have proceeded to install the 'typical' installation. Everything was going well in the installation until it got to about 54% complete where it has halted with the following error: "Error in invoking target install of makefile /export/home/oracle/8.1.7/plsql/lib/ins_plsql.mk" It then gives me the option to click on ignore, cancel or retry. When I try ignore it repeats similar messages referring to other .mk files. What could be the problem? regards Tapiwa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe 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: Sinardy Xing 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).
Canada and US friends
Hi Canada and US friends, Can your systems survive the blackout disaster? Do you need recovery? Everything is ok out there? Sinardy
RE: How to make SPFILE in sync with INIT.ORA ?
USE shortcut like soft link for unix -Original Message- Sent: 15 July 2003 10:59 To: Multiple recipients of list ORACLE-L Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQL>startup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQL>startup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQL>startup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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).
SQL need help
Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101 or CustomerNo 1 Total Order For This month = 0 My SQL statement is like this SELECT a.custno, sum(b.total_order) from all_customer a, order b where b.custno (+) = a.custno and to_char(dateorder, 'month') = 'JUNE' (PROBLEM is HERE) group by a.custno When I run this statement for those customer that never order anything, my statement return No row returns How to get something like this CustomerNo 1 Total Order For This month = 0 I tried this nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE' Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Update and Join
Hi Castro, Can you set your font size bigger? You are not lawyer right? may be this can help you UPDATE table SET column = something_new WHERE primary_key_or_just_key in (select foreign_or_primary_key as usual) AND other_key in (other select foreign_or_primary_key as usual); Sinardy -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: 28 June 2003 06:44To: Multiple recipients of list ORACLE-LSubject: Update and Join I am trying to make and update that have a Join. UPDATE ITEMLOC INNER JOIN ITEMMAST ON ITEMLOC.ITEM = ITEMMAST.ITEM SET ITEMLOC.PREFER_BIN='PATEN-A' WHERE (ITEMMAST.INVEN_MAJCL = 'A' AND ITEMLOC.PREFER_BIN='FICTICI') But I don't have the right sintaxis, did some one knows how to do this or if is posible do a join in a update statement? Thanks!!!
RE: service name
connect descriptor is more like it, since you may load balance the listener. what is the different any way with destination address? is this an exam question or what? -Original Message- Sent: 29 June 2003 02:44 To: Multiple recipients of list ORACLE-L Hello list does a service name best represent a connect descriptor or a destination address ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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 RDBMS for Win XP
Hi all, Do you install Oracle RDBMS (maybe personal edition) with Win XP? Will that work? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Anyone using EMC Clarion Cx400 in a RAC environment?
Hi, One incident (first year or usage) the fiber card driver crash and zombie processes occur. IO hang, database down. DB cannot fail over to standby server, primary server cannot shutdown, shutdown abort can't help, physically power off server is require. I don't think is the EMC problem but the fiber card. Sinardy -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: 18 June 2003 01:10To: Multiple recipients of list ORACLE-LSubject: Anyone using EMC Clarion Cx400 in a RAC environment? Looking at purchasing an EMC Clarion Cx400 for our 2 Sun Fire 280R Solaris 9 machines. Wondering if anyone is currently using this Storage system and how it performs. Any outstanding issues/concerns we should know about. Did your system admin attend a class on taking care of this storage solution? We will be running Veritas Database Edition for Oracle 9i R2 RAC. I am gonna attend the Oracle RAC class offered by Oracle and the system administrator will attend the Veritas class. Any help would be greatly appreciated. Many Thanks, -Lizz Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
RE: How to stop script
Hi Chen, My solution will be about the same with previous DBA guru I assume u r using Window (if is unix you just need to change a little bit here and there) I write this script for you. +save as imp.sql++ SET HEAD OFF SET FEEBACK OFF SET PAUSE OFF SET VERIFY OFF SET LINESIZE 250 SPOOL 'C:\temp\~dynamic_imp.bat' SELECT 'imp username/password@' || name || ' full=y file=bla bla other parameter=bla bla bla log=mypath\log' from v$database where name = 'TEST'; SPOOL OFF -- host chmod u+x C:\temp\~dynamic_imp.bat (if you using unix this will prevent you from bug cause by your umask) -- host C:\temp\~dynamic_imp.bat-- uncomment this if you ready to do the import -- host del C:\temp\~dynamic_imp.bat-- uncomment this if your C:\temp\~dynamic_imp.bat is look ok ++= +save as imp.bat*** sqlplus -s someone_can_do_select_v$database/[EMAIL PROTECTED] +++ You can add alot of fancy stuffs but the concept is about like that Sinardy -Original Message- Sent: 17 June 2003 12:39 To: Multiple recipients of list ORACLE-L I have a script and can be run on commandline like: > sqlplus /@TEST @import.sql However, I want to check database name at the beginning of import.sql. I knew "select name from v$database" can obtain database name. But how can I stop the script if I found it is not TEST database? In import.sql, it is like: drop user A cascade; create user A ; host imp A/[EMAIL PROTECTED] file=a.dmp full=yes; // some PL/SQL ... Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: error configuration database oracle 9.2.0 on Redhat
Hi Pomin, This is syntax error, why don't you check your create database syntax including init.ora file and system environment variable. Just my speculation. Sinardy -Original Message-From: pomin [mailto:[EMAIL PROTECTED]Sent: 19 March 2003 09:49To: Multiple recipients of list ORACLE-LSubject: error configuration database oracle 9.2.0 on Redhat hi all,I need your help, I have a problem while configuration database progress.while progress until 46% I got a error message like this :"ORA-12705: invalid or unknown NLS parameter value specified"after that I can continue the configuration.could anybody help me?Thank you Regards, pomin
RE: Inband and Outband Net8 question
Hi, Or may be because IBB is in the queue, that why it seems like not working. Just my speculation Sinardy -Original Message- Sent: 18 March 2003 17:09 To: Multiple recipients of list ORACLE-L Inband breaks are (were) not supported by all protocols and not all implementations of the same protocol on each platform (especially in the early days of SQL*Net). It was clear to the developers that OBB was the most optimal way of implementing break handling but not every platform did support it. So you will use IBB some on weird platforms that don't support OBB break. Anjo. On Tuesday 18 March 2003 07:48, Sinardy Xing wrote: > Hi all, > > I have question about "Inband break", please help me understand this > > Oracle said: > > There are 2 types of breaks: > - Inband breaks: are transmitted as part of regular data traffic using the > normal protocol read and write functions. These breaks are symply queued. - > Outband breaks: are faster as it is send during urgent data messages. These > messages cause signals and take a lot of load of the server. > > These are my questions: > > What is the purpose of Inband break? > when we use it during our day to day activities? > is this break trigger automatically (something like "end" of some > activity)? > > > Thanks, > > Sinardy -- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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: Sinardy Xing 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).
Inband and Outband Net8 question
Hi all, I have question about "Inband break", please help me understand this Oracle said: There are 2 types of breaks: - Inband breaks: are transmitted as part of regular data traffic using the normal protocol read and write functions. These breaks are symply queued. - Outband breaks: are faster as it is send during urgent data messages. These messages cause signals and take a lot of load of the server. These are my questions: What is the purpose of Inband break? when we use it during our day to day activities? is this break trigger automatically (something like "end" of some activity)? Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: It takes too long to shutdown database
Title: It takes too long to shutdown database Hi David, These are what I think first, you are not using shutdown immediate (Oracle waiting user to close the session) - unlikely for this case. or It has been so long you never shutdown your database, Oracle doing housekeeping, your rollback segment, update your data files, things like that or you are using archive log mode with 8.1.6, and legend said bug cause the shutdown took hours (oracle code performing endless loop I quest), I encounter this problem then I did : startup force follow with shutdown immediate (hmm... I think, I am a lousy dba, he he he...) the problem never occur again, and my database life happily ever after. Sinardy -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]Sent: 26 February 2003 09:44To: Multiple recipients of list ORACLE-LSubject: It takes too long to shutdown database I try to bounce database by shutting it down and starting it back up but it just hang in there for almost 45 minutes trying to shut down. It is running on Solaris8, I can press Ctrl+C to interrupt it or issue a kill command to kill it but I hesitate to do so. Do you have any advices and why it takes too long to shutdown database? It usually only takes me about 3 minutes to bounce database. Thanks, David
Unix variable question
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
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: installation / recovery question
Hi, ***Suggestions*** I think your consent is more toward OS backup, >From the DB point of view (assume your databases are created and populated) - Do cold backup (Oracle redundancy set + all parameter files (db and network) + password file + user docs + scripts + everything) - backup the export dump file (compress = n full=y) then reinstall Oracle binary files, this is quite fast, right? Sinardy -Original Message- Sent: 24 February 2003 16:39 To: Multiple recipients of list ORACLE-L Hi all, I have a test installation of Oracle 817 and 902 on my PC - installed completly on a device other than system device. Now my computer is getting buggy (well it's Win2k on it) so the sysadmin want's to reinstall the system device. Is there any way to save the registry entries for Oracle and recover them when the new installtion on system device is done? Can I export the entries in a .reg file and merge that into my new registry when sysadmin is done? Or do I have to reinstall Oracle software and how to I preserve my databases? Any suggestions/hints/warnings are welcome. Regards, Antje Sackwitz Antje Sackwitz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-2 16 fax +49 (0) 43 1-53 53-2 22 email mailto:[EMAIL PROTECTED] web www.ppi.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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).
Alert Log reporting question
Hi all, I am writing a script that can "grep "ORA-" from alert log. I think it will be good if I can grep the time of the error occur, can you please help me? If you are lazy to type please introduce me any related unix function, I will do man "the function" myself. Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Case of the Missing Rows
Title: Case of the Missing Rows I think so too, perhpas you want to include the bad record to capture those bad records make the nesassary changes then load that bad file repeat until all loaded into your db -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: 28 January 2003 08:44To: Multiple recipients of list ORACLE-LSubject: Re: Case of the Missing Rows My guess is that SQL*Loader didn't really load 88,640 rows, but rejected or discarded about 1400 of them? - Original Message - From: Weiss, Rick To: Multiple recipients of list ORACLE-L Sent: Monday, January 27, 2003 4:53 PM Subject: Case of the Missing Rows I have a recurring, repeatable problem I was wondering about its cause. Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4 Step 1 - I do an SQLLDR process that loads 88640 rows to a table Step 2 - SQL*Plus session - SELEC COUNT(*) from the table returns 88640 rows Step 3 - Do an EXP on the table (to allow fall back to this point) - only exports 87257 rows Step 4 - SQL*Plus session again - SELEC COUNT(*) from the table returns 87257 rows No one else has access to the database. There are no unusual entries in the alert log. There is nothing I have found in the UDUMP or BDUMP directories that would help. Has anyone else experienced this?? Thanks Rick Weiss
RE: [Q] create seperate DBA account on 8.1.7 but does NOT work?
Hi, shared memory realm does not exist This must be your /etc/system semaphores setting incomplete. Your oracle is not there yet No such file or directory This must be your environment not set properly your $ORACLE_HOME library may be also your system administrator don't like you. Sinardy -Original Message- Sent: 27 January 2003 23:44 To: Multiple recipients of list ORACLE-L we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN Solaris server. I plan to upgade to 9.2 use "oracle" account and keep 8.1.7 on "ora817" account. I create user "ora817" and assign it to "dba" group. I also setup ORACLE environment similiar to "oracle" account. I tried to startup "sqlplus" but failed. %setenv ORACLE_SID db00 %sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jan 27 10:49:41 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: user1 Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Does anyone know why? Thanks. _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
how about, database link -Original Message- Sent: 17 January 2003 01:46 To: Multiple recipients of list ORACLE-L replication -Original Message- Sent: quinta-feira, 16 de Janeiro de 2003 15:09 To: Multiple recipients of list ORACLE-L List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be "refreshed". It is only the "new data" on one of the servers to move to the other. What is the best and easiest way to do this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Paulo Gomes 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: Sinardy Xing 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: one datafile lost.
Hi Big Planet, They db files are not consistence you can apply the changes with archived redo log since. How you recover your database is depend on how you backup your database. For example you can use old "redundancy set" + latest exported dump file Sinardy -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: 17 January 2003 01:29To: Multiple recipients of list ORACLE-LSubject: one datafile lost. Just wondering what will happen in this condition . supposse I have two tablespaces data_large and data_small . with datafiles data_large01.dbf and data_small01.dbf . some transactions affects tables in both tablespaces . Now one day I lost data_small01.dbf data files . I thought of recovering that data file from one day old backup . when I recover this data data file , will oracle maintain transactio consistency for all transaction happened today . becuase data_large01.dbf is up to date . but data_small01.dbf is one day old . will oracle keep this in mind while applying archived logs at the time of recovery .
RE: Urgent PDF to TXT Convert
Hi all, Thanks for your reply. I find a command pdftotext from Red Hat Use a script run it very fast all my pdf files are now in text files. Enjoy your weekend :) Thank You Sinardy -Original Message- Sent: 10 January 2003 17:59 To: Multiple recipients of list ORACLE-L Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Sinardy Xing 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).
OT: Urgent PDF to TXT Convert
Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: ORA-00600: [2662]
Hi guys, This is what I get from Oracle == Hi Sinardy, I've check several bug looking for the cause of this problem. However, what I've found is that Development could not diagnosis the problem other than the possibily hat there was some memory corruption that gave a bad SCN. Although, they could "sometimes" determine the root cause prior to the problem occurring by using certain parameters were set in the database. Those parameters are: a)_db_block_cache_protect. b)_db_block_checking c)DB_BLOCK_CHECKSUM They also recommended running dbverify on all datafiles tomake sure all files are clean on disk. IMPORTANT == These parameter may help later determine what cause the ORA-600 [2662] (and it's not for certain that a cause can be found). They parameters does have some performance overhead, but unfortunately this is the only way that can help in catching and we have to wait until the problem happens again. So, the bottomline is there is no list of reason for why this error occuring other than the error occurs when a data block SCN is ahead of the current SCN. Sorry Sinardy, we don't have more information. Thanks! Wonda = What can I do, help me please... Sinardy -Original Message- Sent: 07 January 2003 13:09 To: Multiple recipients of list ORACLE-L Sinardy ORA-0600 is really an encoded message from Oracle that reads : 'Thank you for helping find yet another bug in our software. You can now release your sphincter (some herbal tea might help), especially if this has cropped up in production. We suggest you do not try to solve this one by yourself, which is why the arguments are supplied. Kindly call OWWS with your CSI number, tell them exactly which version and platform you ran this on, and if we have encountered this previously, there is a small chance that we could have a patch. If not, please do not hold your breath waiting, while we assign this to an experienced software engineer, or perhaps a recent college grad, in which case, you're toast !' However, we will ask you to ftp up to our ftp site loads of dumps and traces which might prove useful. Seriously though, ORA-0600 are mysteries. Your best chance is to get Tim Gorman to look at it, he has an amazing knowledge of these. And of course, Tim should not work for free either. (Tim, it was 10% commission we agreed on, right ? ) :-) Ferenc Mantfeld -----Original Message- From: Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Subject:ORA-00600: [2662] Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: mantfield 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: Sinardy Xing 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).
ORA-00600: [2662]
Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: The best method for scheduled work
Hi Murat Balkas, 1. Perhaps you want to play around with Oracle's sysdate from dual? 2. If I am you, I will prepare my sql script then using cron (unix) to execute it (Windows has it's own version of scheduler program come with OS) I believe most OS equip with scheduler program Good luck. Sinardy -Original Message- Sent: 06 January 2003 17:04 To: Multiple recipients of list ORACLE-L Hi, I want to move ( insert into select and than delete from ) some records of a table to another one at midnights. It would be very nice if it has logging facility. Do you have any good documantation about * scheduled triggers * executing time based queries using sqlplus Thanks in advance. Murat BALKAS -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MURAT BALKAS 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: Sinardy Xing 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: functions/procedures and commits
Hi John Dunn, My answer is never commit, Oracle will rollback. Are you consider auto commit an implicitly commitment? Sinardy -Original Message- Sent: 02 January 2003 22:14 To: Multiple recipients of list ORACLE-L > Under what circumstances is a COMMIT done implicitly? > > If I call a function or procedure that performs an insert, but does not do > a commit, will a commit be implicitly performed when the function ends? > > i.e. is ... > > begin > > INSERT INTO > ... etc. > > end; > > the same as > > begin > > insert_the_record; > > end; > > where insert_the_record is a procedure that does the insert, but nothing > else. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn 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: Sinardy Xing 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: Help with IMPort
Hi Raja Kumar, If you don't know what are the differences use the parameters touser and fromuser During importation Oracle will recreate those tables I think if you not use the ignore = y you will get error message since Oracle cannot insert due to different table structure Just guessing If you are not require to know those table structure differences then you can drop the tables first. Other Important Note: Make sure your dump file exported with parameter compress = n Sinardy -Original Message- Sent: 06 January 2003 16:34 To: Multiple recipients of list ORACLE-L I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: strange issue with setting transaction
Hi Sony, Commit will slow down your script. (I mean use the reasonable number of transactions per commit) Perhaps you can set your Rollback segment optimal value to null. Your rollback will never shrink : ) Sinardy -Original Message- Sent: 06 January 2003 10:09 To: Multiple recipients of list ORACLE-L Try to commit for every one transaction on your script, it will be helpful. > > > [EMAIL PROTECTED] > > mTo: > [EMAIL PROTECTED] > > Sent by: cc: > > [EMAIL PROTECTED] Subject: strange issue > with setting transaction > > > > > 01/03/2003 12:49 > > PM > > Please respond to > > ORACLE-L > > > > > > > > > > I am running 8.1.6 on solaris 2.8. > > Before running a large update, I tried to set a specific rollback > segment by: > Set transaction use rollback segment RBIG20; > > The transaction runs for a while and fails with: > > ORA-01555: snapshot too old: rollback segment number 29 with name "R27" > too > Small > > Any idea? > > Thank you > > Sergei > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sergei > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ron Thomas > 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: Sony kristanto 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: Sinardy Xing 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: New year humor
Ha ha ha... but what is Chanukah? -Original Message- Sent: 02 January 2003 18:40 To: Multiple recipients of list ORACLE-L Landing at Ben Gurion Airport... So True!!! As the plane settled down at Ben Gurion airport, the voice of the Captain came on: "Please remain seated with your seatbelt fastened until this plane is at a complete standstill and the seat belt signs have been turned off." "To those of you standing in the aisles, we wish you a Happy Chanukah." "To those who have remained in their seats, we wish you a Merry Christmas" Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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: Sinardy Xing 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).
imp table by table
Hi all, I have dump files (1 table 1 dump file, dump filename is tablename) How to create imp scripts that will import all those dump files without any referential problem Something like this: select 'imp system/manager file=./' || object_name || '.dmp || ' fromuser=myuser touser=myuser' from user_objects where object_name = myuser order by creation; do you think this will work ? My problem is with referential Thanks Mery X'Mas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
/opt/oracle/product/jre/1.1.8/bin/jre
Hi all, Can I set this file to r-xr-xr-x ? rwxrwxrwx /opt/oracle/product/jre/1.1.8/bin/jre Thanks 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 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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB
Hi Stephen, Sun Clustering basically quite simple (I think) :) an Oracle user dedicated to this software use to monitor (do query for certain system tables) the existence of the db if anything wrong than this so call fault monitoring will do shutdown abort and release the mount points for second node to do startup pfile= the problem is shutdown abort successful but the mounted points cannot be unmount because of those UNKILLED background processes. I think sun clustering shuold add this if cannot release mount point then do "STOP A" follow by power off, right ? Sinardy -Original Message- Sent: 01 November 2002 23:03 To: Multiple recipients of list ORACLE-L UNKILLAB > -Original Message- > > when I try to "sync" the session hung (init will sync > automatically therefore it hung too) > I have to POWER OFF and POWER ON my SUN BOX to release the mount point > My sun clustering fail to fail over because of this > > there is jargon in unix call zombie process (what is this ?) > What is tampered process, and when it happen ? > A zombie process is a process that was started by a parent process in such a way that it is expected that the child process will exit and the parent will acknowledge the exit; but the parent never did. You used to see this all the time on a Unix box in the past. Now days, the "init" process usually becomes the foster parent so you don't have zombies piling up as time goes on. There was never anything terribly wrong with zombies (as long as it wasn't some ridiculous amount) since the only resource they tied up (at least in theory) was a process ID number; and it made for a messy, disconcerting ps output. I know absolutely nothing about Sun clustering; but I am wondering if you are having trouble with network file system reads and writes. NFS problems can cause hanging. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE
Hi all,
Jared you are right...
kill -9 successful but ps -ef |grep ora_ said the processes are still there (only
LGWR and CKPT, the rest are die)
when I try to startup again lk refuse to mount my database
I guest Oracle not finished the housekeeping job.
when I try to "sync" the session hung (init will sync automatically therefore it hung
too)
I have to POWER OFF and POWER ON my SUN BOX to release the mount point
My sun clustering fail to fail over because of this
there is jargon in unix call zombie process (what is this ?)
What is tampered process, and when it happen ?
Oracle Support said if shutdown abort can't kill the process is your OS problem not
Oracle.
Why Oracle PMON and SMON never do anything about this ?
Sinardy
-Original Message-
Sent: 01 November 2002 06:40
To: Multiple recipients of list ORACLE-L
UNKILLABLE
I'm not new to Solaris or unix in general.
Rebooting to get rid of an unkillable process is not unheard of in unix
land.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/31/2002 02:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Unkillable Background process "SHUTDOWN ABORT LEAVES
UNKILLABLE
Reboot, Yeah-Right. This is Solaris, not Windoze.
I would try having the root user do the "kill -9" after doing a "truss" on
the process it see what it's looking at. Doing a "ipcrm" on the shared
memory segment and semaphores may also help.
Brian
Jared.Still@radis
ys.com To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Unkillable
Background process "SHUTDOWN ABORT LEAVES UNKILLABLE
10/31/02 12:44 PM
Please respond to
ORACLE-L
Reboot and open a TAR.
Jared
"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/31/2002 12:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: Unkillable Background process "SHUTDOWN ABORT
LEAVES UNKILLABLE
PROCESSES"
Hi,
I am using solaris 8
Sinardy
-Original Message-
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L
PROCESSES"
Hi all,
When I do shutdown abort my LGWR and CKPT still around and also kill -9
cannot get rid of them anyone know why ?
because of this my cluster fail to failover
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
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: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE PROCESSES"
Hi, I am using solaris 8 Sinardy -Original Message- Sent: 31 October 2002 15:43 To: Multiple recipients of list ORACLE-L PROCESSES" Hi all, When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ? because of this my cluster fail to failover Thanks 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 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: Sinardy Xing 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).
Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLABLE PROCESSES"
Hi all, When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ? because of this my cluster fail to failover Thanks 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 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: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Hi US friends, How high is your income tax ? 90-110K is this the take home pay ? -Original Message- Sent: 04 October 2002 03:37 To: Multiple recipients of list ORACLE-L Position: Sr. Oracle 8i DBA Location: New York, New York Industry: Publishing, Ecommerce Salary Range: 90-110K-depends on experience plus excellent benefits and bonus plan. *PLEASE DO NOT send your resume for this position UNLESS you already live in the Greater New York City area and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. *Description: This well-established, very successful New York City based Fortune 500 Company is looking for a Senior Oracle 8i Database DBA to assist in the design and development of a database supporting the implementation of an enterprise content management system that will support major new ecommerce initiatives. As a Sr. Oracle 8i Database Administrator, you will assist in the design, development, testing and support of the development and production databases for this brand new, rapidly expanding Ecommerce environment. - Work extensively with various Ecommerce development teams,as well as database developers to assist in the development of various Content Management databases. - Create stored procedures, triggers, and functions. Daily support includes: extensive replication, performance tuning and monitoring, optimization of the databases, patches, upgrades, backups, redo logs, etc. - Perform data modeling, logical and physical design. Build physical databases from logical data model. - Provide support to the production DBA group on an as-needed basis. *Requirements: -BSCS degree or related discipline. -Must have 5+ years Oracle 8i DBA (development and production support) experience. -Must have strong experience working with Unix (Solaris preferred). -Extensive shell scripting experience is required. -Must have experience working in an Ecommerce (Transaction Based) Environment. -Content Management experience is a plus. -Full project life cycle experience required. -MUST HAVE Excellent verbal and written communication skills. -Must possess strong problem solving / analytical skills. -Any 9i experience is a plus. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/New York City//Oracle 8i DBA/Corey (*NYC area candidates only- no exceptions) ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Sinardy Xing 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).
Unix scripting need help
Hi all, For example, my files are like these mylogfile001.log mylogfile002.log I want to initialize my variables with those number, like this i=1 for all_file in `ls -1 /tmp` do file$i=all_file i=i+1 done file_tag1=`unix_command $file1 ` <--- help me here when I do echo $file_tag1 it should give me 001 Thank you 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).
RE: Set unused column to normal
Hi Jared, Noted, thanks. Sinardy -Original Message- Sent: 24 August 2002 03:45 To: Multiple recipients of list ORACLE-L Not only is it not supported, it has been know on occasion to trash a database. I tried it years ago, several procedures could not be recompiled after doing so. An instructor from one Oracle class said he blew away a database by doing this. Caveat emptor. Jared "Sinardy Xing" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/22/2002 07:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Set unused column to normal Hi George, This is the step: 0. SOP = Backup your DB before you make any changes 1a. What is your column name :_ 1b. What is your column name :_ The order of your column that you drop is very important (I mean if they are in the same table) 2. Query dba_unused_col_tabs Take note the information of those unused columns 3. Query col$(obj#, col#, name, intcol#, property) Query tab$(obj#, cols, intcols, property) Optional Query obj$(obj#, name, subname, status) 4. modify col$ If you see name = SYS_bla_bla_bla_bla, property = 32800 then set name = your column_name property = 0 col# = max(col#) + 1 repeat this step if you have more than 1 columns the one your drop first should have smaller rowid compare to the second one 5. modify tab$ select obj# from obj$ where name=your table name select tab$ <- step3 where obj#=the one you get above set cols = max_columns intcols = max_columns property = 0 This is not supported by Oracle make sure you know what you are doing. Check metalink article by Mike Ault Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 22 August 2002 18:41 To: Sinardy Xing Thank you very much for your reply. I did not drop them yet. How can I recover those..? -Original Message- Sent: Wednesday, August 21, 2002 9:18 PM To: [EMAIL PROTECTED] Hi George, Have you drop those columns that you mark unsued? if yes then you cannot recover them check your dba_unsued_col_tabs (count will tell you how many unsued columns you have that we can recover) Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 21 August 2002 04:00 To: Sinardy Xing Hi, I need some help. I set some columns in my table to unused. Is there any way, can I make those back to normal? Thanks -- 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). -- 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: 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).
RE: Hot Backup using EMC /BCV splits
Hi, While your EMC Standard volumes and BCVs are in synchronized mode (not split), both Standard and BCV will be updated at the same time. So is better you split instantly before you end backup your tablespaces. This will ensure your data files in BCV are backup mode data files before you them copy to tape. Sinardy -Original Message- Sent: 20 August 2002 14:34 To: Multiple recipients of list ORACLE-L Hi, The logic should be like this 1. tablespace begin backup 1a. archive log current 2. suspend database (or sleep) 3. EMC synchronized standard volume and bcv 4. after all mount point (datafile) synchronized EMC split 4a. after EMC split you can mount your bcv to another host and then do the media backup. while you can continue step 5 5. resume database 6. tablespace end backup Sinardy -Original Message- Sent: 15 August 2002 22:59 To: Multiple recipients of list ORACLE-L Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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). -- 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).
RE: Hot Backup using EMC /BCV splits
Hi, The logic should be like this 1. tablespace begin backup 1a. archive log current 2. suspend database (or sleep) 3. EMC synchronized standard volume and bcv 4. after all mount point (datafile) synchronized EMC split 4a. after EMC split you can mount your bcv to another host and then do the media backup. while you can continue step 5 5. resume database 6. tablespace end backup Sinardy -Original Message- Sent: 15 August 2002 22:59 To: Multiple recipients of list ORACLE-L Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: Increase size of REDO log
5 days ago ? check your alert log for the date and time of log switch -Original Message- Sent: 09 July 2002 04:14 To: Multiple recipients of list ORACLE-L How about if I use LogMiner to read redo log to check which transaction had been modified in 5 days ago, how do I know which redo log to look at? Thanks, David -Original Message- Sent: Monday, July 08, 2002 1:04 PM To: Multiple recipients of list ORACLE-L First, Check for the one that is not the current one. Select * from V$log; ALTER DATABASE DROP LOGFILE '/u01/oradata/orcl/redo01.log'; delete the file manually ALTER DATABASE ADD LOGFILE '/u01/oradata/orcl/redo01.log' size 30M; Change your size to your desire one. For the other ones do the same. To change the active one. ALTER SYSTEM SWITCH LOGFILE; hth Ramon - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 11:33 AM > How do I increase size of redo logs and how do I create additional redo > logs? > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: DB_FILE_NAME_CONVERT issue
Hi,
I am not using RMAN, This is what I try to do.
I try to create standby database manually
1. Copy all datafiles to new location (so call standby location)
2. create initstandby.ora ("almost" the same with the production)
2.a. DB_FILE_NAME_CONVERT = (production path, standby path) is one of them
2.b. let oracle know where is your initstandby.ora
3. alter database create standby controlfile as 'standbycontrol.ctl';
3. startup nomount pfile = where is your initstandby.ora
4. alter database mount standby database;
5. recover standby database; <- this will apply daily archived log, make sure
your standby up to date.
6. shutdown; <- never open this database
The problem is I don't know how to let Oracle know that my production datafile paths
are more than one.
I think Oracle 9i can do that with DB_FILE_NAME_CONVERT (para1, para2, para3, para4).
I Don't think is very funny if I have to rename all my production data files before I
create standby control file. :(
Thanks
Sinardy
-Original Message-
Sent: 08 July 2002 16:03
To: Multiple recipients of list ORACLE-L
Hi,
I don't know the syntax you are looking for but you could explicitly rename
every file in your RMAN script (set newname for datafile command)
Jack
"Sinardy Xing"
omsvc.com> cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: DB_FILE_NAME_CONVERT
issue
[EMAIL PROTECTED]
08-07-2002 09:28
Please respond to
ORACLE-L
Hi guys,
Anyone that work in ASIA time please help me : )
Sinardy
-Original Message-
Sent: 08 July 2002 12:58
To: Multiple recipients of list ORACLE-L
Hi guys,
I try to create standby database and my datafile are all over my hard disk,
what should I do to my DB_FILE_NAME_CONVERT to let my standby database know
this issue ?
example
/prod_data1/system01.dbf
/prod_data2/user01.dbf
/prod_data3/rbs01.dbf
my standby datafile
/standby_data1/system01.dbf
/standby_data1/user01.dbf
/standby_data2/rbs01.dbf
I try this idiot way but there are no such parameters in v$parameter :+)
DB_FILE_NAME_CONVERT1 = (/prod_data1, /standby_data1)
DB_FILE_NAME_CONVERT2 = (/prod_data2, /standby_data1)
DB_FILE_NAME_CONVERT3 = (/prod_data3, /standby_data2)
Thanks so much.
Oh by the way I am using 8i
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).
--
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 cont
RE: DB_FILE_NAME_CONVERT issue
Hi guys, Anyone that work in ASIA time please help me : ) Sinardy -Original Message- Sent: 08 July 2002 12:58 To: Multiple recipients of list ORACLE-L Hi guys, I try to create standby database and my datafile are all over my hard disk, what should I do to my DB_FILE_NAME_CONVERT to let my standby database know this issue ? example /prod_data1/system01.dbf /prod_data2/user01.dbf /prod_data3/rbs01.dbf my standby datafile /standby_data1/system01.dbf /standby_data1/user01.dbf /standby_data2/rbs01.dbf I try this idiot way but there are no such parameters in v$parameter :+) DB_FILE_NAME_CONVERT1 = (/prod_data1, /standby_data1) DB_FILE_NAME_CONVERT2 = (/prod_data2, /standby_data1) DB_FILE_NAME_CONVERT3 = (/prod_data3, /standby_data2) Thanks so much. Oh by the way I am using 8i 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). -- 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).
DB_FILE_NAME_CONVERT issue
Hi guys, I try to create standby database and my datafile are all over my hard disk, what should I do to my DB_FILE_NAME_CONVERT to let my standby database know this issue ? example /prod_data1/system01.dbf /prod_data2/user01.dbf /prod_data3/rbs01.dbf my standby datafile /standby_data1/system01.dbf /standby_data1/user01.dbf /standby_data2/rbs01.dbf I try this idiot way but there are no such parameters in v$parameter :+) DB_FILE_NAME_CONVERT1 = (/prod_data1, /standby_data1) DB_FILE_NAME_CONVERT2 = (/prod_data2, /standby_data1) DB_FILE_NAME_CONVERT3 = (/prod_data3, /standby_data2) Thanks so much. Oh by the way I am using 8i 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).
RE: Oracle 9i, can't break it?
ha ha... funny -Original Message- Sent: 03 July 2002 03:05 To: Multiple recipients of list ORACLE-L I would say it is unbreakable. Can't break what's already broke. -Original Message- Sent: Tuesday, July 02, 2002 2:49 PM To: Multiple recipients of list ORACLE-L In other words, it is unbreakable. Can't get in... Can't break in... Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 02, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle 9i, can't break it? They made changes to MetaLink over the weekend, I cannot search for my own TARs because of the country code. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject:Oracle 9i, can't break it? Guess who did? MetaLink V2 - Note An error occured while trying to query the system. Please try again later [CODE : -12541 ] Be careful what you wish for, you just might get it!! Dick Goulet -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message originated from the internet. Its originator may not be who they claim to be and the information contained herein my or may not be Accurate. All Messages are Scaned to be Virus Free, by IPM, powered by McAfee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5
RE: !ls from sqlplus
try this command which sqlplus -Original Message- Sent: 13 June 2002 08:09 To: Multiple recipients of list ORACLE-L OS: Solaris 2.7 Database: 8.1.7 On dev server, !ls from sqlplus gives the files of current directory where sqlplus runs. On pro server, !ls from sqlplus goes to the home directory of os user. For example, Login to sqlplus from /u01 on both machines, on dev: SQL> !pwd /u01 on pro: SQL> !pwd /export/oracle What seting affects this ? Thanks, -Li Zhang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: Oracle IAS
Yes -Original Message- Sent: 11 June 2002 15:48 To: Multiple recipients of list ORACLE-L Have Intel P4? -- Alexandre - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 9:13 AM > Hi all, > > I try to install Oracle IAS 8i into my Win 2K SP 2, and the universal installer is hang, any idea (I have huge RAM) > > Thanks > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
