RE: OT : linux flavors
I have to say I use Redhat 7.0 and apart from being a tad over-engineered it's relatively simple to setup. The only problem I encountered was getting the X environment setup (LCD monitor with GeForce card). You get a lot for your money with RedHat and plenty of training courses too. (Although you pay for that through the nose if you go to RedHat!!)... K. -Original Message- Sent: 08 November 2001 17:08 To: Multiple recipients of list ORACLE-L For starters, I'd recomend redhat, it's quite friendly. HTH --Yohans On Thu, 8 Nov 2001, Andrey Bronfin wrote: Dear list ! I've got a question that i realize has no correct answer. I want to install Linux at home on my lousy PC. I have NO-WHATSOEVER experience with Linux , although have some knowledge of Solaris HP-UX. I want to pick up a linux flavor that is : 1) Pretty frequently used one , so i can get tutorials , and there are many experienced users to ask questions , and many answers can be found on the web. 2) Closest one to Solaris (or HP-UX or other big UNIX) . 3) Can run on a PC with little memeory . Than U very much in advance for your time. DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yohans Mendoza INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: blowing out rollbacks on select statements?
An TX lock implies that the session have an slot in the rollback segment. TX are usually exclusive lock: 6 code. Regards. --- Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] wrote: Is the TX lock against the local rollback segment a shared or exclusive lock? Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 12:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: blowing out rollbacks on select statements? Christian, I read the note on MetaLink. Is it just me, or does the explanation given just not make any sense? Jared Doc ID: Note:74811.1 PURPOSE To explain why a distributed query uses local rollback segments. SCOPE APPLICATION For DBA's and Oracle Support Analysts. RELATED DOCUMENTS [BUG:702754] [BUG:262277] When a select from a remote table is issued a TX lock out is taken out on a local rollback segment. This lock is only released by issuing a COMMIT, ROLLBACK or logoff. For example: select empno,ename from emp@remotedb; This is documented behaviour in [BUG:262277]. The explanation given is: When we start a transaction which is to be executed remotely, since at that time we are not sure what is going to happen locally while the query is being executed remotely, a TX lock is taken out on a local rollback segment even if the query is only a select. The reason for this is that a remote select is like a two phase commit in that it sends out the query over the network and waits for it to return a successful result. If you check v$transaction during the transaction, you will see used_ublk show 1 block of rollback being used during this update and a TX lock against the rollback segment. The following is an example of a remote query using a local rollback segment: SQL SELECT t.xidusn RBS Name, t.used_ublk Used Blocks, s.username User Name, l.type Lock Type FROM v$transaction t, v$session s, v$lock l WHERE t.ses_addr=s.saddr AND s.sid = l.sid / no rows selected SQL SELECT * FROM scott.emp; ENAME SALARY -- -- Mike 1000 Nick 500 Pete 400 Dave 2000 SQL SELECT t.xidusn, t.used_ublk, s.username, l.type 2 FROM v$transaction t, v$session s, v$lock l 3 WHERE t.ses_addr=s.saddr AND s.sid = l.sid ; no rows selected SQL SELECT * FROM scott.emp@suppaix1_v805; ENAME SALARY -- -- Mike 1000 Nick 500 Pete 400 Dave 2000 SQL SELECT t.xidusn, t.used_ublk, s.username, l.type 2 FROM v$transaction t, v$session s, v$lock l 3 WHERE t.ses_addr=s.saddr AND s.sid = l.sid 4 / XIDUSN USED_UBLK USERNAME TYPE -- -- - 3 1 SCOTT TX SQL COMMIT; Commit complete. SQL SELECT t.xidusn, t.used_ublk 2 FROM v$transaction t, v$session s 3 WHERE t.ses_addr=s.saddr AND s.username='SYSTEM' 4 / no rows selected Christian Trassens To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ctrassens@yah cc: oo.com Subject: Re: blowing out rollbacks on select statements? Sent by: [EMAIL PROTECTED] om 11/08/01 08:10
Re: HP-UX 11/8.1.6/Cache Buffers Chains
try steve adams ixora.com --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Where can I find definitive information about the 'cache buffers chains' latch? The 'statsrep' report from Statspack shows this... Get Spin Latch Name Requests Misses Sleeps Sleeps 1-4 --- -- - cache buffers chains1,861,232,551 14,888,739 28,424 14861067/26993/631/48/0 ...as the top latch sleeper and I'm wondering what to do about it. This is a data mart instance. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
session marked for kill
Title: session marked for kill Hi! I got a call from one of our developers and was told that his app was hung on the dev box. So I issued an alter system kill session command. It took about 30 seconds then I got the message: session marked for kill. But the connection still showed up in v$session, even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance. Any idea what was going on? Why did it take so long? Was it all rollback activity? This is 8.1.7 on sun Solaris. Thanks, Helmut
ORA-01720 while trying to grant select on a view
Hi DBA Gurus, I am getting the below error while trying to grant select privileges on a view owned by a user by name GCSS to another user by name etldev: ORA-01720: grant option does not exist for 'SYS.V_$INSTANCE' I even granted select on sys.v_$instance to etldev. Still the problem persists. What could be the problem? Anybody can throw some light on this? Thanks and Regards, KR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath, Krishnaswamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP-UX 11/8.1.6/Cache Buffers Chains
try steve adams ixora.com --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Where can I find definitive information about the 'cache buffers chains' latch? The 'statsrep' report from Statspack shows this... Get Spin Latch Name Requests Misses Sleeps Sleeps 1-4 --- -- - cache buffers chains1,861,232,551 14,888,739 28,424 14861067/26993/631/48/0 ...as the top latch sleeper and I'm wondering what to do about it. This is a data mart instance. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Raw partition Vs File System
If you're using a volume manager (veritias, or disk suite), then raw is pretty much just as easy as file systems. You could always do this incrementally - for example, high io stuff (typically redo, temp, possibly rollback) on raw, and all the rest of file systems etc. hth connor --- Vasu Ramasamy [EMAIL PROTECTED] wrote: Hello Gurus, I am trying to install Oracle Server in the environment as given below. I am in the processes of laying out Physical Database layout. I would like to know the pros and cons of going with Raw partition. The environment : Solaris 2.6 Oracle 8.1.7 Size of database - 60GB No. of tables - 3000 (approx.) Max size of few tables - 3 GB to 5 GB. Thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vasu Ramasamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-01720 while trying to grant select on a view
Hi DBA Gurus, I am getting the below error while trying to grant select privileges on a view owned by a user by name GCSS to another user by name etldev: ORA-01720: grant option does not exist for 'SYS.V_$INSTANCE' I even granted select on sys.v_$instance to etldev. Still the problem persists. What could be the problem? Anybody can throw some light on this? Thanks and Regards, KR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath, Krishnaswamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: session marked for kill
Yes, it was because of rollback activity done it by PMON. You needed to shutdown abort because an immediate do rollback too. Your case is an example of deferred transaction recovery. After startup SMON will do the work that PMON has left. Regards. --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! I got a call from one of our developers and was told that his app was hung on the dev box. So I issued an alter system kill session command. It took about 30 seconds then I got the message: session marked for kill. But the connection still showed up in v$session, even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance. Any idea what was going on? Why did it take so long? Was it all rollback activity? This is 8.1.7 on sun Solaris. Thanks, Helmut = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-01720 while trying to grant select on a view
You must grant with grant option to give permission for granting an object. I mean as sys you should: grant select on v_$instance to gcss with grant option And the other grant. Regards. --- Ranganath, Krishnaswamy [EMAIL PROTECTED] wrote: Hi DBA Gurus, I am getting the below error while trying to grant select privileges on a view owned by a user by name GCSS to another user by name etldev: ORA-01720: grant option does not exist for 'SYS.V_$INSTANCE' I even granted select on sys.v_$instance to etldev. Still the problem persists. What could be the problem? Anybody can throw some light on this? Thanks and Regards, KR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath, Krishnaswamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
v$session_wait event
Anyone any idea what I am waiting for here. I know it seems obviousbut I don;t know exactly what it means. Anyone who knows about such things care to enlighten me on where to dig next. This has been sitting like this for 2 days and I believe it maybe at the root of the long running SQL problem I have had here. What do I know? ??. 1 select event, sql_text, s.sid, serial#, s.last_call_et, wait_time, seconds_in_wait, state 2 from v$session s,v$session_wait w, v$sqlarea sa 3 where s.sql_address = sa.address 4 and s.sql_hash_value = sa.hash_value 5 and w.sid = s.sid 6 and w.event != 'Null event' and 7w .event != 'rdbms ipc message' and 8 w.event != 'pipe get' and 9 w.event != 'virtual circuit status' and10 w.event not like '%timer%' and11 w.event not like 'SQL*Net message %'12 and s.audsid != 013 and s.sid = 1214* order by last_call_etSQL / EVENTSQL_TEXT SID SERIAL# LAST_CALL_ET WAIT_TIME SECONDS_IN_WAITS TATE-- -- -- --- ---SQL*Net more data from clientsavepoint begin_row 12 9001 0 0 0 WAITING Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: ORA-01720 while trying to grant select on a view
You need to: grant select on sys.v_$instance to GCSS with grant option; This will allow GCSS to grant select on views based on v_$instance to other users. - Bill. At 01:35 09/11/01 -0800, you wrote: Hi DBA Gurus, I am getting the below error while trying to grant select privileges on a view owned by a user by name GCSS to another user by name etldev: ORA-01720: grant option does not exist for 'SYS.V_$INSTANCE' I even granted select on sys.v_$instance to etldev. Still the problem persists. What could be the problem? Anybody can throw some light on this? Thanks and Regards, KR -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import questions
If you want the objects to end up in the same tablespaces, then the names must be exactly the same (otherwise the default tablespace is used). If the filesystem and layout on box x is the same as box y then the full import will create the tablespaces using the datafile specs. in the dump file. If the filesystem is different then you should pre-create the tablespaces you need before doing the import. It is probably best to do this anyway (even if the filesystem matches) as you can be sure that the datafiles are where you want them to be and there will be no surprises like running out of disk space. When you do this the import will not try to create the tablespaces, since ones with the same name already exist. - Bill. At 11:40 08/11/01 -0800, you wrote: Hi Is it necessary to create exactly same tablespace name when I want to FULL import of database structure? Let i have one instance A on x box. I have created one instance A on Y box I want to full import structore of database on box Y. Thanks Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
__ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-01720 while trying to grant select on a view
Title: RE: ORA-01720 while trying to grant select on a view See the Metalink Note below Subject: grant select on view with grant option RDBMS Version: 81511 Operating System and Version: nt 4 sp 5 Error Number (if applicable): ora-1720 Product (i.e. SQL*Loader, Import, etc.): Product Version: grant select on view with grant option I am having a problem with a grant. Here is the scenario. User A has created view V in user A's schema. View V is based on table T in schema B. User A and C have select privs on table T in schema B via ROLE R. User A tries to grant select on view V to user C and gets the following error: ORA-01720 grant option does not exist for 'B.T' It is true that user A does not have select on B.T with grant option, but user C already has select privs on table T. I do want to grant with grant option to users as it is to much maintenance. Is there another way to deal with this kind of a situtation? From: Ramesh Bala 12-Jul-01 22:42 Subject: Re : grant select on view with grant option Hi Jonathan, If your view is based on an underlying table from one schema just like what you described, you can create the view in the same schema and grant select on the view to users. That is create View V in schema B instead of user A and grant select on view V to both A C. If your view depends on tables from multiple schemas (like View V is based on B.T1 and D.T2) then you may be better off creating this view in an administrative user's schema which has privileges to both B.T1 and D.T2. Then grant view V to users A C from the admin user who owns this view. In this case, only the admin user needs to have grant option for the underlying tables. - Ramesh From: Oracle, Reem Munakash 13-Jul-01 18:57 Subject: Re : grant select on view with grant option If userA wants to grant userC access to it's view, it will need 'with grant option' on the base table. This is even true if the table grant is made to PUBLIC. When userA goes to issue the grant, all we do is see if he has the privilges, we don't make that extra check to see if the grantee already has access to the object. There is no way around this unless you have UserB create the view. Reem Munakash Electronic Support From: Chan McMurray 13-Jul-01 19:36 Subject: Re : grant select on view with grant option thank you, Reem. that confirms what I found. -Original Message- From: Ranganath, Krishnaswamy [mailto:[EMAIL PROTECTED]] Sent: 09 November 2001 09:35 To: Multiple recipients of list ORACLE-L Subject: ORA-01720 while trying to grant select on a view Hi DBA Gurus, I am getting the below error while trying to grant select privileges on a view owned by a user by name GCSS to another user by name etldev: ORA-01720: grant option does not exist for 'SYS.V_$INSTANCE' I even granted select on sys.v_$instance to etldev. Still the problem persists. What could be the problem? Anybody can throw some light on this? Thanks and Regards, KR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath, Krishnaswamy INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
[no subject]
__ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Another Oracle DBA gets The Bullet in the UK - Seeking an O
good people skills -- you leave them smiling even when you tell them no they can't have what they want. You are not arbitrary about decisions, you explain WHY something won't work and offer an alternative that will. You smile at people, get to their work as quickly as you can, explain delays when you can't. Oh, and you ask how are you and LISTEN for the answer :) Rachel --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Rachel - Thanks for sharing some tips. I think that in hard times it is worth considering how valuable you are considered by the people that pay your salary. Aside for the objective or true value of the DBA to the organization, I think there are two other aspects. 1. How perceptive your manager is. We can't pick our boss (usually) and can't control their technical background or their perceptiveness. I have had some non-technical managers that were remarkably perceptive. 2. Most of us didn't become DBA's because we had excellent communication skills. Most of us picked a technical career because we noticed in school that we were better at figuring out technical puzzles. Often we tend to concentrate on resolving the puzzles as quickly as possible and ignore the communication aspect, assuming that everyone will see that we are busy and will assume that we are doing really important stuff that nobody else is smart enough to figure out. However, these assumptions don't always pan out. Recently my company made a larger commitment to Oracle (not in terms of the DBA staff, I'm still soloing). I thought this was great because I interpreted it as more job security. However, suddenly there was more emphasis on ability to communicate. I am now working on ways to enhance my people skills. The book I have found that speaks in simple enough terms for me is Dale Carnegie's classic How to Win Friends and Influence People. Any other resources along these lines would be appreciated. Most of the current self-help books are more along the lines of how to get rich. Gave that idea up a long time ago. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 07, 2001 2:15 PM To: Multiple recipients of list ORACLE-L O my boss asked me to stop including him on all the emails etc. he says if I don't say anything to you then you are doing a good job I say I need you to be my boss we are a small group and everyone seems to speak at mega-volume. Everyone knows what everyone else's problem is and who fixed it and how. My teammates know what I do -- I tell them they don't really need me, but that's because we have it under control. They tell me I'm nuts -- and I have to say, it's gratifying to hear thank goodness you are back whenever I come back from vacation. --- Kimberly Smith [EMAIL PROTECTED] wrote: The way around that is to actually let them know what preventative stuff you did. I provide my manager with a weekly report and in there is a section called application maintenance and administration. I even put in there when I spend time with a developer showing them some SQL or PL/SQL tricks. Now, my teammates think I do nothing. Even after I sit there for an hour helping them out. Just cause I do my job right the first time and there really are no issues. But they don't really count. -Original Message- Sent: Tuesday, November 06, 2001 7:50 PM To: Multiple recipients of list ORACLE-L O my $0.02 the problem is, if we do our jobs properly, they don't have problems. And if they don't have
RE: good workaround for a ORA-2016?
I like your naming conventions :) but shouldn't it be from a_table_in_this_database ? --- Jeffery Stevenson [EMAIL PROTECTED] wrote: ...and you created the view on the other side of the database link where none of the tables are remote tables? Basically, on the remote system you would create a view like this: create view call_this_from_somewhere_else as select this and that from a table in this database start with primary key in (select same datatype from another table b,c,d(several other tables) connect by prior etc., hierarchy ...and then from the other system you'd call: select * from call_this_from_somewhere_else@remote_db; Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:50 PM To: Multiple recipients of list ORACLE-L That doesn't work.. same error. It doesn't like remote tables in the start with clause whether it's a view or not. On Thu, 08 Nov 2001 07:50:29 -0800, you wrote: If all the remote tables are on the same database and you have privileges to create a view on that remote database, then create a view at that end and then just select * from view@remotedb; and be done with it. This is also a good trick to remember for some of the slower running remote queries out there. Anyways, just and idea... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does anyone know a good workaround for an ORA-2016? :cannot use a subquery in a start with on a remote database? Query is essentially something like: select this and that from a remote table over a database link start with primary key in (select same datatype from another remote table b,c,d(several other remote tables) connect by prior etc., hierarchy Anyway.. the way they've worked around it is to run the subquery by itself and then pump the values 1000 at a time into an IN clause. This is horrible for parsing. There must be a better way. I was thinking there may be away to pump the values into a array of number or something. Or, possibly someone else has a better idea.. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffery Stevenson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: GMT TIME
Thank you Raj. My point stands wwhether using the old GMT mnemonic or the new UTC. -Original Message- Rajendra Sent: 08 November 2001 19:04 To: Multiple recipients of list ORACLE-L Actually one should use UTC ... instead of GMT for reference Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linux file locking question (semi-off topic)
Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- Weaver, Walt [EMAIL PROTECTED] wrote: Alright, I sent out a totally innocent question to the list and didn't get a single suggestion. I'm very disappointed in you people. So, let me say that I figured it out without your help. And I ain't saying what I did. So there. PPPHHT!!! -- Walt (my RAM disk is working great) Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 08, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Okay, this doesn't have much to do with Oracle other than the fact that I have been assigned with figuring out why this problem is occurring. We have a live chat application on Linux that uses Tomcat to manage its java servlets. A log is written to by the java processes, and this log can get rather large. Problem is, these java processes keep some sort of a write lock on the log and we can't clear the log out. Using lsof, I can get a listing of the java processes holding a lock on the log. One such process looks like this: java 32180 root6w REG 48,1 186487009 18036 /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log Bottom line is, how can I clear these write locks without killing the java processes? Somebody must know how. I couldn't possibly the first person on earth to encounter this problem. Thanks, --Walt (learnin about chattr()) Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
Now, that was very informative! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 09, 2001 7:10 AM __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 like your style, first it was the polar bear in the snowstorm now we get the airline jet in the snowstorm. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux file locking question (semi-off topic)
and chocolate obviously !! -Original Message- Sent: 09 November 2001 13:31 To: Multiple recipients of list ORACLE-L Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- Weaver, Walt [EMAIL PROTECTED] wrote: Alright, I sent out a totally innocent question to the list and didn't get a single suggestion. I'm very disappointed in you people. So, let me say that I figured it out without your help. And I ain't saying what I did. So there. PPPHHT!!! -- Walt (my RAM disk is working great) Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 08, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Okay, this doesn't have much to do with Oracle other than the fact that I have been assigned with figuring out why this problem is occurring. We have a live chat application on Linux that uses Tomcat to manage its java servlets. A log is written to by the java processes, and this log can get rather large. Problem is, these java processes keep some sort of a write lock on the log and we can't clear the log out. Using lsof, I can get a listing of the java processes holding a lock on the log. One such process looks like this: java 32180 root6w REG 48,1 186487009 18036 /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log Bottom line is, how can I clear these write locks without killing the java processes? Somebody must know how. I couldn't possibly the first person on earth to encounter this problem. Thanks, --Walt (learnin about chattr()) Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE:
I must your, your posts have left me feeling kind of empty lately! :) -Original Message- Sent: 09 November 2001 12:10 To: Multiple recipients of list ORACLE-L __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ftp
Follow up... My SA says we you have Washington Univ version of FTP you can restrict the users from navigating... Is it the only way Suren -Original Message- Sent: Thursday, November 08, 2001 8:30 AM To: Multiple recipients of list ORACLE-L Hi List, I think, sometime back, there was a thread on ftp, but I am not sure what was discussed in that. Can anyone please let me know if there is anyway to control users coming into the system through ftp from navigating to other directories? I am using .netrc for my ftp processes and I would like to have something apart from setting permisions on directories. Env is: HP-UX 10.01, as you know it is unsupported and I don't have option of installing any patches/tools etc... Thanks, Suren Consultant DBA HRIS, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent Fail Safe Question
Huh? Jared, did your search reveal that OFS is available for platforms other then Windows? The white papers and doc that I read stated Windows only because it's tied into Microsoft Cluster Server. IMHO, I think the Oracle folks took a look at MS Cluster Server and realized that it wouldn't be that hard to setup Oracle in MS Cluster Server. IMHO2, if you knew enough about MS Cluster Server you could probably setup Oracle in the cluster without OFS. But OFS makes it so much easier. -Original Message- Sent: Friday, November 09, 2001 12:55 AM To: Multiple recipients of list ORACLE-L On Thursday 08 November 2001 11:20, you wrote: I just recently installed Oracle Fail Safe 3.1.2 on W2K, Oracle 8.1.7 for a ... It is for Windows only, because it ties into Microsoft Cluster Server. And it was very cool, we failed each node back and forth many times with no problems. Granted there was no real load on the database. I thought so too. A search on MetaLink shows Fail Safe for several platforms. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle the best
Prasad, Is the database running on MTS mode? Rao -Original Message- Sent: Friday, November 09, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Hi, All of us believe Oracle is the best database server. We can keep our application data on Oracle and just forget the rest. I strongly believe I can do anything I want, with Oracle. We have a problem with Oracle. Ours is a small application with most hits. Lot of people will be using our solution and each hit results in database access. We have limitation on the maximum number of connections that can be made from Java application(servlet). We are accessing from 16 servlet machines to the database and making around 500 connections. We are using a connection pool from Javaexchange(DbConnectionBroker). When the application reaches beyond 500(I think the number is still less) connections, the database stops responding. Database machine's CPU usage goes 100%. And any requests from servlets at this point, will wait for a long time to get response from oracle. We are using Oracle 8.1.7, on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor. We are using CLOB very frequently. Thanks in advance for your suggestion on tuning. Regards, Prasad BAV. __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
I just submitted OEM feedback
FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and 8.1.7.2.1 (on NT). I had at least thirty events configured, and planned to try using jobs. Not going to happen for a while yet... Oracle Support and I have been dancing around for weeks now, they absolutely refuse to tell me how to clean up the repository without having to rebuild it. Instead they just give me the same procedure to clean up the agent directories, etc. but the problem is not at the remote hosts, it is in the repository. The problem I ran into is twofold. 1) The OEM repository reported a referential integrity error, some records in a child table do not have corresponding entries in their parent table. This is a repository corruption problem, has nothing to do with the agents on remote hosts. 2) I have a number of events stuck in de-registration pending mode, which prevents me from de-registering the events and removing the nodes from the Navigation pane. Yes, I have shut down the agents, removed all the files in the /agent directories, shut down the console, stopped and restarted the management server, but the events are still there. I asked them to build into the next version of the OEM a utility that can scan the repository, look for bad entries, and remove them. There is no need to force people to spend hours rebuilding the repository and re-configuring everything just because of a few events being stuck in de-registration pending mode. If anyone else has encountered this problem and know a way to clean up the repository without having to rebuild it, please let me know, I would appreciate it. Other problems so far with the OEM: - The Oracle Expert this morning declared it cannot log into the Oracle Management Server, even though I can start up a console. The error I get is: org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]. I haven't looked in MetaLink yet, will do that. One more problem to look up re. the OEM. - The Forms listener event does not communicate properly with the Forms Server. - The Change Manager does not see tablespaces, tables, indexes from one of my NT servers (8.1.7.2.1). Oracle Support could not reproduce the problem. Next thing for me to try: rebuild the three databases on that machine, to see if that will fix the problem. Something I would rather not do. - The agent on my Tru64 UNIX server cannot talk to the databases on that machine, Oracle Support told me that there is probably a problem with the agent and they suggested I upgrade. We are upgrading that server soon, so I only used the node and TNS Listener events for the groups pane. The events for db up/down against this machine are stuck in de-registration pending mode. Finally, a funny anecdote: yesterday I ran the Oracle Expert against one of the three databases on that NT server I mentioned above. The Oracle Expert as part of its recommendations told me to take non-system objects out of the SYSTEM tablespace. All these objects were created when the databases were created, using Oracle's own GUI tools. I moved them out of there this morning using the script generated by the Oracle Expert, which was nice. If you find any problems with the OEM, I encourage you to submit them with Oracle. I am starting to think now that I should go into the repository manually and clean up the tables with invalid records. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O
Raj, One small suggestion: If maintaining many db's leaves you with less time to attend to the developer's questions or developers' requirements, bring up this case to your boss. Put it to him in such a way that the company requires another DBA. In that way, you would be doing two services in this troubled times. 1. You would be providing a job to a guy. 2. You would be left free to attend to your production tasks. Due to financial constraints, if your company could not appoint another DBA, then, at least your boss and the management would be aware WHY you could not attend to the developers requests quickly. In my experience, I found that having good relationships in the company with as many as you can, would give you advantage when you most require it. Do not leave anybody with an empty feeling that his/her request isn't important. Even if it is not important, try to explain your priorities to them. Over a period of time, very quickly the developers would start understanding your problems and they would start respecting you and appreciate the job you do. Rao -Original Message- Sent: Friday, November 09, 2001 8:31 AM To: Multiple recipients of list ORACLE-L O good people skills -- you leave them smiling even when you tell them no they can't have what they want. You are not arbitrary about decisions, you explain WHY something won't work and offer an alternative that will. You smile at people, get to their work as quickly as you can, explain delays when you can't. Oh, and you ask how are you and LISTEN for the answer :) Rachel --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms6
On occasion we'd like to be able to broadcast a message to folks who are accessing the database via a GUI forms interface; either thick or thin client. What are some possible ways of implementing this feature? Since we own/write the application we are free to modify it any way we desire. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858-831-2229San Diego, CA 92131 Extraordinary DBA - Design on the Fly Just In Time Programming -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:session marked for kill
Rollback is one definite possibility, so is the Duhveloper shutting down the process on his/her client machine. In either case, finding the process id and killing that process at the Unix level will also release stuff a lot faster. Dick Goulet Reply Separator Author: Daiminger; Helmut [EMAIL PROTECTED] Date: 11/9/2001 1:45 AM Hi! I got a call from one of our developers and was told that his app was hung on the dev box. So I issued an alter system kill session command. It took about 30 seconds then I got the message: session marked for kill. But the connection still showed up in v$session, even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance. Any idea what was going on? Why did it take so long? Was it all rollback activity? This is 8.1.7 on sun Solaris. Thanks, Helmut !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEsession marked for kill/TITLE /HEAD BODY PFONT SIZE=2 FACE=ArialHi!/FONT /P PFONT SIZE=2 FACE=ArialI got a call from one of our developers and was told that his app was hung on the dev box. So I issued an quot;alter system kill sessionquot; command. It took about 30 seconds then I got the message: session marked for kill./FONT/P PFONT SIZE=2 FACE=ArialBut the connection still showed up in v$session, even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance./FONT/P PFONT SIZE=2 FACE=ArialAny idea what was going on? Why did it take so long? Was it all rollback activity?/FONT /P PFONT SIZE=2 FACE=ArialThis is 8.1.7 on sun Solaris./FONT /P PFONT SIZE=2 FACE=ArialThanks,/FONT BRFONT SIZE=2 FACE=ArialHelmut/FONT /P BR /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O
Randy , I am sourly lacking in people's skills..thats the point I was trying to make..(which didn't work..Obviously..!!). When I am working 42 hours continuously I don't have time to think about hurting somebody's delicate feelings. RS --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Rachel - Thanks for sharing some tips. I think that in hard times it is worth considering how valuable you are considered by the people that pay your salary. Aside for the objective or true value of the DBA to the organization, I think there are two other aspects. 1. How perceptive your manager is. We can't pick our boss (usually) and can't control their technical background or their perceptiveness. I have had some non-technical managers that were remarkably perceptive. 2. Most of us didn't become DBA's because we had excellent communication skills. Most of us picked a technical career because we noticed in school that we were better at figuring out technical puzzles. Often we tend to concentrate on resolving the puzzles as quickly as possible and ignore the communication aspect, assuming that everyone will see that we are busy and will assume that we are doing really important stuff that nobody else is smart enough to figure out. However, these assumptions don't always pan out. Recently my company made a larger commitment to Oracle (not in terms of the DBA staff, I'm still soloing). I thought this was great because I interpreted it as more job security. However, suddenly there was more emphasis on ability to communicate. I am now working on ways to enhance my people skills. The book I have found that speaks in simple enough terms for me is Dale Carnegie's classic How to Win Friends and Influence People. Any other resources along these lines would be appreciated. Most of the current self-help books are more along the lines of how to get rich. Gave that idea up a long time ago. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 07, 2001 2:15 PM To: Multiple recipients of list ORACLE-L O my boss asked me to stop including him on all the emails etc. he says if I don't say anything to you then you are doing a good job I say I need you to be my boss we are a small group and everyone seems to speak at mega-volume. Everyone knows what everyone else's problem is and who fixed it and how. My teammates know what I do -- I tell them they don't really need me, but that's because we have it under control. They tell me I'm nuts -- and I have to say, it's gratifying to hear thank goodness you are back whenever I come back from vacation. --- Kimberly Smith [EMAIL PROTECTED] wrote: The way around that is to actually let them know what preventative stuff you did. I provide my manager with a weekly report and in there is a section called application maintenance and administration. I even put in there when I spend time with a developer showing them some SQL or PL/SQL tricks. Now, my teammates think I do nothing. Even after I sit there for an hour helping them out. Just cause I do my job right the first time and there really are no issues. But they don't really count. -Original Message- Sent: Tuesday, November 06, 2001 7:50 PM To: Multiple recipients of list ORACLE-L O my $0.02 the problem is, if we do our jobs properly, they don't have problems. And if they don't have problems they figure nothing ever goes wrong with the database, why do I need the DBA? except of course, that
checking users's password
Hi Everyone, Can anyone provide/share with me a script that will check the users password against their username. We are trying to verify that no one is using his/her username as the password. Thanks for any help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Weatherspoon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 just submitted OEM feedback
Bad RI? Unhandled, hanging events? This is a tool that people use? Boy, and i was *just* starting to consider reviewing it again... *sigh*.. Thanks, Patrice. Great post. Truly helpful. ross -Original Message- Sent: Friday, November 09, 2001 10:10 AM To: Multiple recipients of list ORACLE-L FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and 8.1.7.2.1 (on NT). I had at least thirty events configured, and planned to try using jobs. Not going to happen for a while yet... Oracle Support and I have been dancing around for weeks now, they absolutely refuse to tell me how to clean up the repository without having to rebuild it. Instead they just give me the same procedure to clean up the agent directories, etc. but the problem is not at the remote hosts, it is in the repository. The problem I ran into is twofold. 1) The OEM repository reported a referential integrity error, some records in a child table do not have corresponding entries in their parent table. This is a repository corruption problem, has nothing to do with the agents on remote hosts. 2) I have a number of events stuck in de-registration pending mode, which prevents me from de-registering the events and removing the nodes from the Navigation pane. Yes, I have shut down the agents, removed all the files in the /agent directories, shut down the console, stopped and restarted the management server, but the events are still there. I asked them to build into the next version of the OEM a utility that can scan the repository, look for bad entries, and remove them. There is no need to force people to spend hours rebuilding the repository and re-configuring everything just because of a few events being stuck in de-registration pending mode. If anyone else has encountered this problem and know a way to clean up the repository without having to rebuild it, please let me know, I would appreciate it. Other problems so far with the OEM: - The Oracle Expert this morning declared it cannot log into the Oracle Management Server, even though I can start up a console. The error I get is: org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]. I haven't looked in MetaLink yet, will do that. One more problem to look up re. the OEM. - The Forms listener event does not communicate properly with the Forms Server. - The Change Manager does not see tablespaces, tables, indexes from one of my NT servers (8.1.7.2.1). Oracle Support could not reproduce the problem. Next thing for me to try: rebuild the three databases on that machine, to see if that will fix the problem. Something I would rather not do. - The agent on my Tru64 UNIX server cannot talk to the databases on that machine, Oracle Support told me that there is probably a problem with the agent and they suggested I upgrade. We are upgrading that server soon, so I only used the node and TNS Listener events for the groups pane. The events for db up/down against this machine are stuck in de-registration pending mode. Finally, a funny anecdote: yesterday I ran the Oracle Expert against one of the three databases on that NT server I mentioned above. The Oracle Expert as part of its recommendations told me to take non-system objects out of the SYSTEM tablespace. All these objects were created when the databases were created, using Oracle's own GUI tools. I moved them out of there this morning using the script generated by the Oracle Expert, which was nice. If you find any problems with the OEM, I encourage you to submit them with Oracle. I am starting to think now that I should go into the repository manually and clean up the tables with invalid records. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: Forms6
If you are running forms in client-server mode, then there is no easy solution, but if you have web deployment, then you could use PJC and hook into dbms_alert. This way, if you send a dbms_alert, you will be able to capture it at forms and display appropriate message. Now only if I could remember where I saw this implementation example . must be OTN ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
RE: good workaround for a ORA-2016?
For a second there I thought it was Cobol. -Original Message- Sent: Friday, November 09, 2001 5:36 AM To: Multiple recipients of list ORACLE-L I like your naming conventions :) but shouldn't it be from a_table_in_this_database ? --- Jeffery Stevenson [EMAIL PROTECTED] wrote: ...and you created the view on the other side of the database link where none of the tables are remote tables? Basically, on the remote system you would create a view like this: create view call_this_from_somewhere_else as select this and that from a table in this database start with primary key in (select same datatype from another table b,c,d(several other tables) connect by prior etc., hierarchy ...and then from the other system you'd call: select * from call_this_from_somewhere_else@remote_db; Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:50 PM To: Multiple recipients of list ORACLE-L That doesn't work.. same error. It doesn't like remote tables in the start with clause whether it's a view or not. On Thu, 08 Nov 2001 07:50:29 -0800, you wrote: If all the remote tables are on the same database and you have privileges to create a view on that remote database, then create a view at that end and then just select * from view@remotedb; and be done with it. This is also a good trick to remember for some of the slower running remote queries out there. Anyways, just and idea... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does anyone know a good workaround for an ORA-2016? :cannot use a subquery in a start with on a remote database? Query is essentially something like: select this and that from a remote table over a database link start with primary key in (select same datatype from another remote table b,c,d(several other remote tables) connect by prior etc., hierarchy Anyway.. the way they've worked around it is to run the subquery by itself and then pump the values 1000 at a time into an IN clause. This is horrible for parsing. There must be a better way. I was thinking there may be away to pump the values into a array of number or something. Or, possibly someone else has a better idea.. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffery Stevenson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Oracle Database Group Manager Needed in Boston
Boston, MA, Financial services company is looking for an Oracle Database Group Manager who MUST be a senior ORACLE database professional. The selected candidate will report to the Manager of Enterprise Technologies/Global Operations. *Candidates who are in the Greater Boston area only can be considered.. no relocation assistance is provided. This is a full time staff position so no sub-contractors or third parties. Description: The Database Group Manager is responsible for the team which is in turn responsible for the database architecture, database application support and database administration. These responsibilities include coordination of implementation, support, and maintenance of the client's database environments. The Database Group Manager provides leadership and vision, and direction of the database environment, ensuring support of business objectives and requirements. Responsibilities include: The coordination of efforts required in supporting database centric application development. Monitoring database space usage, Backup and recovery procedures, Performance tuning and monitoring, Disaster Recovery, Database Security. Requirements: Potential candidates MUST HAVE a Minimum of 10 years overall experience as a Oracle Database Administrator with support of enterprise critical databases. Potential candidate MUST have a minimum of 8 years of management leadership experience in the support of ORACLE in a UNIX environment. MUST HAVE: Experience with ORACLE development tools. MUST HAVE a BS in Computer Science or a related discipline, MS preferred. MUST HAVE experience in end user of vendor experience within the Financial Services Industry. U.S. citizenship or permanent residency also required. This position is with a company that offers : * Quality Work Environment * Salary D.O.E.--85-98K NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume to: Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code: One/Boston/Oracle Group Mgr/Barbara All inquires held 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 OraStaff, Inc-The Proven Connection To Oracle Opportunity -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 just submitted OEM feedback
Actually, I am not having any issues. My only issue with the tool is I cannot page someone else if I don't fix the problem but we are just going to direct the pages to Unicenter and leave it at that. Also, you cannot set a priority level. For example, there are times where I just want an email instead of a page but everything is an emergency in its mind. -Original Message- Sent: Friday, November 09, 2001 8:26 AM To: Multiple recipients of list ORACLE-L Bad RI? Unhandled, hanging events? This is a tool that people use? Boy, and i was *just* starting to consider reviewing it again... *sigh*.. Thanks, Patrice. Great post. Truly helpful. ross -Original Message- Sent: Friday, November 09, 2001 10:10 AM To: Multiple recipients of list ORACLE-L FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and 8.1.7.2.1 (on NT). I had at least thirty events configured, and planned to try using jobs. Not going to happen for a while yet... Oracle Support and I have been dancing around for weeks now, they absolutely refuse to tell me how to clean up the repository without having to rebuild it. Instead they just give me the same procedure to clean up the agent directories, etc. but the problem is not at the remote hosts, it is in the repository. The problem I ran into is twofold. 1) The OEM repository reported a referential integrity error, some records in a child table do not have corresponding entries in their parent table. This is a repository corruption problem, has nothing to do with the agents on remote hosts. 2) I have a number of events stuck in de-registration pending mode, which prevents me from de-registering the events and removing the nodes from the Navigation pane. Yes, I have shut down the agents, removed all the files in the /agent directories, shut down the console, stopped and restarted the management server, but the events are still there. I asked them to build into the next version of the OEM a utility that can scan the repository, look for bad entries, and remove them. There is no need to force people to spend hours rebuilding the repository and re-configuring everything just because of a few events being stuck in de-registration pending mode. If anyone else has encountered this problem and know a way to clean up the repository without having to rebuild it, please let me know, I would appreciate it. Other problems so far with the OEM: - The Oracle Expert this morning declared it cannot log into the Oracle Management Server, even though I can start up a console. The error I get is: org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]. I haven't looked in MetaLink yet, will do that. One more problem to look up re. the OEM. - The Forms listener event does not communicate properly with the Forms Server. - The Change Manager does not see tablespaces, tables, indexes from one of my NT servers (8.1.7.2.1). Oracle Support could not reproduce the problem. Next thing for me to try: rebuild the three databases on that machine, to see if that will fix the problem. Something I would rather not do. - The agent on my Tru64 UNIX server cannot talk to the databases on that machine, Oracle Support told me that there is probably a problem with the agent and they suggested I upgrade. We are upgrading that server soon, so I only used the node and TNS Listener events for the groups pane. The events for db up/down against this machine are stuck in de-registration pending mode. Finally, a funny anecdote: yesterday I ran the Oracle Expert against one of the three databases on that NT server I mentioned above. The Oracle Expert as part of its recommendations told me to take non-system objects out of the SYSTEM tablespace. All these objects were created when the databases were created, using Oracle's own GUI tools. I moved them out of there this morning using the script generated by the Oracle Expert, which was nice. If you find any problems with the OEM, I encourage you to submit them with Oracle. I am starting to think now that I should go into the repository manually and clean up the tables with invalid records. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
RE: checking users's password
Deborah: I don't have a script, but it should be fairly easy to create. In pseudo-script: For all Users Loop select current_password, current_profile into temp_var1, temp_var2; alter user profile default; alter user identified by username; select current_password into temp_var3; if temp_var1 = temp_var3 then send nasty_gram to user; end if; alter user identified by values 'temp_var1'; alter user profile temp_var2; End loop; If you're using 8i or above, you can create a PL/SQL block that performs verification of passwords over and above the validation process built into Oracle. The one I use even logs the change to the alert_SID.log file so I can audit password changes. HTH, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Friday, November 09, 2001 8:26 AM To: Multiple recipients of list ORACLE-L Hi Everyone, Can anyone provide/share with me a script that will check the users password against their username. We are trying to verify that no one is using his/her username as the password. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: I just submitted OEM feedback
Oracle Support called me, I resolved the events stuck in de-registration mode. There was a misunderstanding, they were telling me in writing that I had to shut down the agents on the nodes, and then remove the nodes. I thought that meant I had to do it for ALL the nodes, not just the ones with the bad events. Good thing they called me, sometimes person-to-person communication is better than just Web TARs. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
pass a value from a shell script to a store procedure
Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: checking users's password
Funny, I wrote a perl script to do this same thing the other day. It is a perl script, runs under UNIX, and not only checks for defaults, but the default Oracle passwords as well. I was kinda proud of it, so I thought I'd pass it along. Not Jared-Still-Perl-Evangelist quality, but I'm happy. Brian Deborah Weatherspoon wrote: Hi Everyone, Can anyone provide/share with me a script that will check the users password against their username. We are trying to verify that no one is using his/her username as the password. Thanks for any help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Weatherspoon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- check_dftpwd.pl Description: Perl program
RE: pass a value from a shell script to a store procedure
So long as you embed your call to Oracle within your program, the program can pass variables to Oracle all day long. #!/bin/ksh DATE=`date - 1` DBA=`Anne Yu` sqlplus EOF system/incredibly_secret_password select $DATE,$DBA from dual; exit EOF echo Done! -Original Message- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 just submitted OEM feedback
I agree. Too bad you have to pitch a fit these days to get that personal communication. Boivin, Patrice J wrote: Oracle Support called me, I resolved the events stuck in de-registration mode. There was a misunderstanding, they were telling me in writing that I had to shut down the agents on the nodes, and then remove the nodes. I thought that meant I had to do it for ALL the nodes, not just the ones with the bad events. Good thing they called me, sometimes person-to-person communication is better than just Web TARs. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 just submitted OEM feedback
still, Patrice, reboot the agents is not the way this should be handled. That's very old-school Microsofty... -Original Message- Sent: Friday, November 09, 2001 11:53 AM To: Multiple recipients of list ORACLE-L Oracle Support called me, I resolved the events stuck in de-registration mode. There was a misunderstanding, they were telling me in writing that I had to shut down the agents on the nodes, and then remove the nodes. I thought that meant I had to do it for ALL the nodes, not just the ones with the bad events. Good thing they called me, sometimes person-to-person communication is better than just Web TARs. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Another Oracle DBA gets The Bullet in the UK - Seeking an O
RS It's very difficult to deal with people when you're kept s busy and isolated! I know that I can get very focused and forget about other people around me and their menial jobs when mine is the important job since I'm the DBA! Randy Kirkpatrick (303)772-7467 -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject:RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Randy , I am sourly lacking in people's skills..thats the point I was trying to make..(which didn't work..Obviously..!!). When I am working 42 hours continuously I don't have time to think about hurting somebody's delicate feelings. RS --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Rachel - Thanks for sharing some tips. I think that in hard times it is worth considering how valuable you are considered by the people that pay your salary. Aside for the objective or true value of the DBA to the organization, I think there are two other aspects. 1. How perceptive your manager is. We can't pick our boss (usually) and can't control their technical background or their perceptiveness. I have had some non-technical managers that were remarkably perceptive. 2. Most of us didn't become DBA's because we had excellent communication skills. Most of us picked a technical career because we noticed in school that we were better at figuring out technical puzzles. Often we tend to concentrate on resolving the puzzles as quickly as possible and ignore the communication aspect, assuming that everyone will see that we are busy and will assume that we are doing really important stuff that nobody else is smart enough to figure out. However, these assumptions don't always pan out. Recently my company made a larger commitment to Oracle (not in terms of the DBA staff, I'm still soloing). I thought this was great because I interpreted it as more job security. However, suddenly there was more emphasis on ability to communicate. I am now working on ways to enhance my people skills. The book I have found that speaks in simple enough terms for me is Dale Carnegie's classic How to Win Friends and Influence People. Any other resources along these lines would be appreciated. Most of the current self-help books are more along the lines of how to get rich. Gave that idea up a long time ago. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 07, 2001 2:15 PM To: Multiple recipients of list ORACLE-L O my boss asked me to stop including him on all the emails etc. he says if I don't say anything to you then you are doing a good job I say I need you to be my boss we are a small group and everyone seems to speak at mega-volume. Everyone knows what everyone else's problem is and who fixed it and how. My teammates know what I do -- I tell them they don't really need me, but that's because we have it under control. They tell me I'm nuts -- and I have to say, it's gratifying to hear thank goodness you are back whenever I come back from vacation. --- Kimberly Smith [EMAIL PROTECTED] wrote: The way around that is to actually let them know what preventative stuff you did. I provide my manager with a weekly report and in there is a section called application maintenance and administration. I even put in there when I spend time with a developer showing them some SQL or PL/SQL tricks. Now, my teammates think I do nothing. Even after I sit there for an hour
RE: pass a value from a shell script to a store procedure
Thank you so much for response to my email. I know we can do: Date= `date` but not `date -1`. -Original Message- Sent: Friday, November 09, 2001 11:14 AM To: Multiple recipients of list ORACLE-L So long as you embed your call to Oracle within your program, the program can pass variables to Oracle all day long. #!/bin/ksh DATE=`date - 1` DBA=`Anne Yu` sqlplus EOF system/incredibly_secret_password select $DATE,$DBA from dual; exit EOF echo Done! -Original Message- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: session marked for kill
Title: RE: session marked for kill Could be a bunch of things. Here's one thing I noticed in a development database yesterday (8.1.7.1.1 on Windows 2000) Stored procedure issues an analyze table compute statistics. In the alert log there was an ORA-00600 caused by the analyze (and also a trace file in udump.) However the procedure never returned the ORA-00600 and was hung all night. When I came in the next morning and checked session waits (using the session_times.sql script from the ixora website) I saw that it was waiting on library cache load lock. An alter system kill session returned ORA-00031 (session marked for kill) but the numbers for the libary cache load lock wait kept on going up and the sesson didn't disappear. I had to use orakill at the OS level to stop the session. -Original Message- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] I got a call from one of our developers and was told that his app was hung on the dev box. So I issued an alter system kill session command. It took about 30 seconds then I got the message: session marked for kill. But the connection still showed up in v$session, even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance. Any idea what was going on? Why did it take so long? Was it all rollback activity? This is 8.1.7 on sun Solaris.
Error during 9i installation
Hi, We r trying to install 9i on sun 2.8 and getting error : error in writing to file /opt/oracle/OraHome1/Apache.jdk/bin/java_wrapper What might be the cause? Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: I just submitted OEM feedback
Not 30, about half that. That can't be a big setup! What do banks and multinational coporations do, if 15 servers is a big setup? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Subject:RE: I just submitted OEM feedback KS - what is the size of the environment that you are using OEM to monitor? Patrice has it on 30 odd servers, across several OSes, with double digit events set...a biggish layout, methinks. Me, I'd have a 'baby' install at first...a few instances under one unix OS. I guess it would likely be pretty quiet Best, - RM (still struggling on 5.7's :-) ) -Original Message- Sent: Friday, November 09, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Actually, I am not having any issues. My only issue with the tool is I cannot page someone else if I don't fix the problem but we are just going to direct the pages to Unicenter and leave it at that. Also, you cannot set a priority level. For example, there are times where I just want an email instead of a page but everything is an emergency in its mind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
OEM and Veritas backup agent for Oracle
Anyone using this combination to do their regular backups? If yes, I would be interested in hearing your experiences. Here we are doing colds and hots, doing incrementals would be nice. It might make enough difference to justify the cost of purchasing those Veritas agents. Sorry, I am on an OEM theme today. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
SET ORACLE-L NOMAIL --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Memory Windows for HP-UX
I've had no problems with TNS, dblinks, etc. The only thing to watch out for is some monitoring packages (can't remember which ones) read the SGA structures directly from memory. They need to be started from the correct memory window. Never had the pleasure of MC ServiceGuard. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] ujitsu.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: RE: Memory Windows for HP-UX 11/08/01 05:20 PM Please respond to ORACLE-L Do you do anything like dblinks in these 10 instances? I will have 4 instances which all have dblinks to each other in one way or another. From what I read I don't think its a problem but I am not really sure either. I also have no idea how MC ServiceGuard will come into play but I put that one out on the HP forum. -Original Message- Sent: Thursday, November 08, 2001 3:55 PM To: Multiple recipients of list ORACLE-L I believe any system running hpux 11.0 or above can utilize this functionality. See http://docs.hp.com/hpux/onlinedocs/os/memwn1_4.pdf I've been using it on our L2000 box. It was the only way to get 10 instances running at once. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] ujitsu.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: Memory Windows for HP-UX 11/08/01 03:20 PM Please respond to ORACLE-L Is anyone familiar with using memory windows to better utilize their memory when running 32-bit Oracle? I am thinking of going this route instead of upgrading to 64-bit and am looking for info on it. Any HP docs that I can be pointed to would be great. I have a doco from Oracle on how it works and how I get Oracle to use it but nothing that tells me which HP boxes I can use it on. Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: I just submitted OEM feedback
I don't know about this one. A couple of months ago I would agree but lately when I open a Metalink tar I always get a phone call. Even when I don't really need one. I am rarely at my desk to get it but they leave a very nice voice mail. As much as I like to complain about Oracle Support (actually I could have stopped after complain) I feel they are making strides in providing better support. They do deal with a lot of people asking questions that they could easily have gotten the answer out of book from and that is not really what Oracle Support was meant for. The ability to search the books online has been improved and there is really no excuse. So when you get delays in responses from Oracle think of all the lazy folks that got to them before you that they have to deal with. -Original Message- Sent: Friday, November 09, 2001 9:13 AM To: Multiple recipients of list ORACLE-L I agree. Too bad you have to pitch a fit these days to get that personal communication. Boivin, Patrice J wrote: Oracle Support called me, I resolved the events stuck in de-registration mode. There was a misunderstanding, they were telling me in writing that I had to shut down the agents on the nodes, and then remove the nodes. I thought that meant I had to do it for ALL the nodes, not just the ones with the bad events. Good thing they called me, sometimes person-to-person communication is better than just Web TARs. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pass a value from a shell script to a store procedure
I'm sorry, I misunderstood. Were you trying to get Oracle to tell Unix what yesterday was? #!/bin/ksh sqlplus EOF system/incredibly_secret_password_but_this_is_probably_overkill_why_not_use_ scott_tiger select 'YESTERDAY=||sysdate-1||'' from dual set pages 0 set sqlprompt spool date_def / spool off exit EOF . ./date_def echo Yesterday was $YESTERDAY -Original Message- Sent: Friday, November 09, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Thank you so much for response to my email. I know we can do: Date= `date` but not `date -1`. -Original Message- Sent: Friday, November 09, 2001 11:14 AM To: Multiple recipients of list ORACLE-L So long as you embed your call to Oracle within your program, the program can pass variables to Oracle all day long. #!/bin/ksh DATE=`date - 1` DBA=`Anne Yu` sqlplus EOF system/incredibly_secret_password select $DATE,$DBA from dual; exit EOF echo Done! -Original Message- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 just submitted OEM feedback
OOPS! Got the EVENT count and the SERVER count confused. thx -Original Message- Sent: Friday, November 09, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Not 30, about half that. That can't be a big setup! What do banks and multinational coporations do, if 15 servers is a big setup? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pass a value from a shell script to a store procedure
Why not just call the stored procedure with SYSDATE - 1? I don't think Unix's date command makes finding yesterday's date particularly easy. g -Original Message- Sent: 09 November 2001 16:56 To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM and Veritas backup agent for Oracle
Hi Patrice, For some time now we've been using RMAN, staging to disk, then using Netbackup to backup to tape. Works fine. Now, after a struggle, we've got RMAN backing up to tape directly via the Veritas Netbackup MML API stuff. We have a Linux Netbackup client and a Solaris Netbackup server and we don't use OEM. For testing I duhveloped a script to blow away data and recover it for the following recovery scenarios: 1) loss of a datafile; 2) loss of multiple datafiles for a single tablespace; 3) loss of multiple datafiles for a multiple tablespaces; 4) loss of RBS tablespace/datafiles; 5) loss of the system tablespace; 6) complete DB resptore. I script automated this as a monthly exercise just to have fun. I prefer to use scripts. I'll confess to having used OEM a couple years ago. (I used Legato at the time.) In essence OEM was just a not-so-pretty GUI wrapping over RMAN *.rcv scripts. The problem with it is that you get insulated from what's going on under the covers not to mention the persnickity nature of OEM. (I've always been interested in what goes on under the covers.) After a while I just scripted it. You can have OEM generate the *.rcv scripts and use them outside of OEM. I did this in an HPUX environment and now on Linux. I also had some NT servers to backup and *.cmd scripted it using NT's at command (and another 3rd party thingy). Looking back now it seems like it was faster to type up the scripts than it was to point and click thru OEM. Maybe, maybe not but it felt better. If you do choose to go the OEM-only route then make sure you test several recovery scenarios before putting it into production. Can't recall the details but had had a problem with an OEM-only recovery that I ended up having to do it manually anyway and this is what prompted me to script it. At the time Oracle shipped with a limited use verson of Legato which worked just fine for me. Is there still a free limited use MML from Oracle? If there is then you might want to play with that before buying Veritas. Quote for damagement: Backup solutions may be costly but it's much cheaper than losing data. IMHO, Steve Orr Bozeman, MT -Original Message- Sent: Friday, November 09, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Anyone using this combination to do their regular backups? If yes, I would be interested in hearing your experiences. Here we are doing colds and hots, doing incrementals would be nice. It might make enough difference to justify the cost of purchasing those Veritas agents. Sorry, I am on an OEM theme today. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux file locking question (semi-off topic)
well duh the answer to EVERYTHING is 42 --- Orr, Steve [EMAIL PROTECTED] wrote: OK... it's 42! Nice kitty... -Original Message- Sent: Friday, November 09, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- Weaver, Walt [EMAIL PROTECTED] wrote: Alright, I sent out a totally innocent question to the list and didn't get a single suggestion. I'm very disappointed in you people. So, let me say that I figured it out without your help. And I ain't saying what I did. So there. PPPHHT!!! -- Walt (my RAM disk is working great) Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 08, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Okay, this doesn't have much to do with Oracle other than the fact that I have been assigned with figuring out why this problem is occurring. We have a live chat application on Linux that uses Tomcat to manage its java servlets. A log is written to by the java processes, and this log can get rather large. Problem is, these java processes keep some sort of a write lock on the log and we can't clear the log out. Using lsof, I can get a listing of the java processes holding a lock on the log. One such process looks like this: java 32180 root6w REG 48,1 186487009 18036 /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log Bottom line is, how can I clear these write locks without killing the java processes? Somebody must know how. I couldn't possibly the first person on earth to encounter this problem. Thanks, --Walt (learnin about chattr()) Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael
Oracle software on RAID 5
We are in the process of reorganizing and reconfiguring of our disk space in preparation for an Oracle 8.1.6 upgrade in production, and my sys admin wants to use RAID 5 for the drive on which the Oracle 8.1.6 software will be installed. Anyone know of a reason why RAID 5 would not be OK for the software? We are on Digital Tru64 UNIX V4.0G. Thanks in advance, Catherine A. LeBlanc Database Analyst Bates College -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Catherine LeBlanc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Forms6
How about using the create_timer built-in and a when-timer-expired trigger? Gary Kirsh Next Extent, Inc -Original Message- Sent: Friday, November 09, 2001 10:55 AM To: Multiple recipients of list ORACLE-L On occasion we'd like to be able to broadcast a message to folks who are accessing the database via a GUI forms interface; either thick or thin client. What are some possible ways of implementing this feature? Since we own/write the application we are free to modify it any way we desire. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858-831-2229San Diego, CA 92131 Extraordinary DBA - Design on the Fly Just In Time Programming -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kirsh, Gary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: good workaround for a ORA-2016?
Not to mention select this,that :) -Original Message- Sent: Friday, November 09, 2001 8:36 AM To: Multiple recipients of list ORACLE-L I like your naming conventions :) but shouldn't it be from a_table_in_this_database ? --- Jeffery Stevenson [EMAIL PROTECTED] wrote: ...and you created the view on the other side of the database link where none of the tables are remote tables? Basically, on the remote system you would create a view like this: create view call_this_from_somewhere_else as select this and that from a table in this database start with primary key in (select same datatype from another table b,c,d(several other tables) connect by prior etc., hierarchy ...and then from the other system you'd call: select * from call_this_from_somewhere_else@remote_db; Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:50 PM To: Multiple recipients of list ORACLE-L That doesn't work.. same error. It doesn't like remote tables in the start with clause whether it's a view or not. On Thu, 08 Nov 2001 07:50:29 -0800, you wrote: If all the remote tables are on the same database and you have privileges to create a view on that remote database, then create a view at that end and then just select * from view@remotedb; and be done with it. This is also a good trick to remember for some of the slower running remote queries out there. Anyways, just and idea... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does anyone know a good workaround for an ORA-2016? :cannot use a subquery in a start with on a remote database? Query is essentially something like: select this and that from a remote table over a database link start with primary key in (select same datatype from another remote table b,c,d(several other remote tables) connect by prior etc., hierarchy Anyway.. the way they've worked around it is to run the subquery by itself and then pump the values 1000 at a time into an IN clause. This is horrible for parsing. There must be a better way. I was thinking there may be away to pump the values into a array of number or something. Or, possibly someone else has a better idea.. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffery Stevenson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: good workaround for a ORA-2016?
Unfortunately, I don't think I can do that.. they query itself has a limiting factor in the start with clause.. i.e. start with key = (select something from table_over_here,table_over_here2,table_over_here3,table_over_here4 where a bunch_of_stuff and x=:avaluethatchanges) I can't make a view like that.. On Thu, 08 Nov 2001 23:15:17 -0800, you wrote: ...and you created the view on the other side of the database link where none of the tables are remote tables? Basically, on the remote system you would create a view like this: create view call_this_from_somewhere_else as select this and that from a table in this database start with primary key in (select same datatype from another table b,c,d(several other tables) connect by prior etc., hierarchy ...and then from the other system you'd call: select * from call_this_from_somewhere_else@remote_db; Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:50 PM To: Multiple recipients of list ORACLE-L That doesn't work.. same error. It doesn't like remote tables in the start with clause whether it's a view or not. On Thu, 08 Nov 2001 07:50:29 -0800, you wrote: If all the remote tables are on the same database and you have privileges to create a view on that remote database, then create a view at that end and then just select * from view@remotedb; and be done with it. This is also a good trick to remember for some of the slower running remote queries out there. Anyways, just and idea... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, November 08, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does anyone know a good workaround for an ORA-2016? :cannot use a subquery in a start with on a remote database? Query is essentially something like: select this and that from a remote table over a database link start with primary key in (select same datatype from another remote table b,c,d(several other remote tables) connect by prior etc., hierarchy Anyway.. the way they've worked around it is to run the subquery by itself and then pump the values 1000 at a time into an IN clause. This is horrible for parsing. There must be a better way. I was thinking there may be away to pump the values into a array of number or something. Or, possibly someone else has a better idea.. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle software on RAID 5
-- Catherine LeBlanc [EMAIL PROTECTED] Anyone know of a reason why RAID 5 would not be OK for the software? It works rather nicely if you tune the raid stripe to match the system page (usually 4k or 8k). A 4k page works nicely w/ 8 x 512byte chunks or 4 x 1K chunks, for example. RAID5 will avoid data loss in the event of a disk failure. It will not allow you to keep running as though the disk had not failed; only mirroring allows that. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 software on RAID 5
We use raid 5 for everything, haven't come across any problems yet. As for performance, I am not sure, as we don't encounter the same loads as most bigger organizations probably encounter. We are running oracle 8.0.5, 8.1.7, on clustered tru64 4.0f connected to a SAN (HSG80) Darren -Original Message- Sent: November 9, 2001 10:35 AM To: Multiple recipients of list ORACLE-L We are in the process of reorganizing and reconfiguring of our disk space in preparation for an Oracle 8.1.6 upgrade in production, and my sys admin wants to use RAID 5 for the drive on which the Oracle 8.1.6 software will be installed. Anyone know of a reason why RAID 5 would not be OK for the software? We are on Digital Tru64 UNIX V4.0G. Thanks in advance, Catherine A. LeBlanc Database Analyst Bates College -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Catherine LeBlanc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linux file locking question (semi-off topic)
NOTE. According to Tony Jambu author of Oracle's New Pricing, Oracle 9i Features and Some Good Utilities article in the 4qtr 2001 issue of Select. Page 42 (ironic about the page number) The answer is 50 not 42 (for those HGTTG fans, you know what I mean). Just another spin in the galaxy. ROR mô¿ôm [EMAIL PROTECTED] 11/09/01 01:28PM well duh the answer to EVERYTHING is 42 --- Orr, Steve [EMAIL PROTECTED] wrote: OK... it's 42! Nice kitty... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Pull NEXTVAL thru a DB_LINK
Is there any way to get the next value of a sequence via a db_link. I tried select some_seq.nextval from dual@db_link but it told me the sequence didn't exist. I went to the database where the sequence exists and, using the userid that is in the db_link, I was able to get the next value, so it isn't a permissions problem. Do I have the wrong syntax or is it just not possible? TIA -- 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).
Checkpoint Duration
I have LOG_CHECKPOINTS_TO_ALERT set in my init.ora file and according to my alert log they are generally taking about 30 minutes to complete, sometimes only a couple minutes. Does that sound right? The database is about 20G and doesn't have much transaction activity. It's a development database and export/import is run several times during the day. The DB is RAID-5 but the I/O wait is usually very low. Any feedback/suggestions are appreciated. Thanks! -w __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to get user lastname and first name when you have user logon
Title: How to get user lastname and first name when you have user logon id Unix Guru, I'd like to get all the user lastname and first name, and I can get the login id from the command who /var/adm/wtmp Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 11:37 AM To: Multiple recipients of list ORACLE-L Subject: SET ORACLE-L NOMAIL --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Pull NEXTVAL thru a DB_LINK
You just selected the next value from a local sequence called some_seq using the dual table located on the link. What you have to do is to select the next value from the sequence located on the link using the dual table from the local database. select some_seq.nextval@db_link from dual; I tried it . It works. Kevin -Original Message- Sent: Friday, November 09, 2001 1:20 PM To: Multiple recipients of list ORACLE-L Is there any way to get the next value of a sequence via a db_link. I tried select some_seq.nextval from dual@db_link but it told me the sequence didn't exist. I went to the database where the sequence exists and, using the userid that is in the db_link, I was able to get the next value, so it isn't a permissions problem. Do I have the wrong syntax or is it just not possible? TIA -- 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linux file locking question (semi-off topic)
Wait...so...you got the SDS stuff goingand it works...but you can't tell if it's faster? Aching for results, etc. -Original Message- Sent: Friday, November 09, 2001 2:35 PM To: Multiple recipients of list ORACLE-L (Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off weekend and is probably flying around somewhere as I write. We have a 4X10 schedule and we get to arrange the days to maximize our weekends. Hmmm... I was the one who made out the schedule so how is it that Walt got the 4 day weekend? Oh well, I get a 3 dayer for my B-Day next Friday.) ANYWAY... We got the RAM disk running just fine but we haven't developed any comparative benchmarks just yet. We have this home built utility and Walt used it to simulate 1,000 users doing stuff a couple of days ago. (The utility was called pounder but has been enhanced and renamed to hell bore.) We loaded sample data from one of our largest sites for our first test and everything worked fine even when we submitted a report from hades with a query that returns 2.2 million rows. (Don't ask!) For a first pass we put the redo on the RAM disk together with a tablespace dedicated to some particularly busy indexes. Maybe we'll get some time to be more thorough about this and do some before and after comparisons but probably not... NUMBERS! We need numbers! Sigh... Will keep you advised on this. Clueless in Montana, Steve Orr -Original Message- Sent: Friday, November 09, 2001 11:28 AM To: Multiple recipients of list ORACLE-L well duh the answer to EVERYTHING is 42 --- Orr, Steve [EMAIL PROTECTED] wrote: OK... it's 42! Nice kitty... -Original Message- Sent: Friday, November 09, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- Weaver, Walt [EMAIL PROTECTED] wrote: Alright, I sent out a totally innocent question to the list and didn't get a single suggestion. I'm very disappointed in you people. So, let me say that I figured it out without your help. And I ain't saying what I did. So there. PPPHHT!!! -- Walt (my RAM disk is working great) Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 08, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Okay, this doesn't have much to do with Oracle other than the fact that I have been assigned with figuring out why this problem is occurring. We have a live chat application on Linux that uses Tomcat to manage its java servlets. A log is written to by the java processes, and this log can get rather large. Problem is, these java processes keep some sort of a write lock on the log and we can't clear the log out. Using lsof, I can get a listing of the java processes holding a lock on the log. One such process looks like this: java 32180 root6w REG 48,1 186487009 18036 /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log Bottom line is, how can I clear these write locks without killing the java processes? Somebody must know how. I couldn't possibly the first person on earth to encounter this problem. Thanks, --Walt (learnin about chattr()) Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Find a job, post your resume. http://careers.yahoo.com -- Please see
index size calculation
Hi All! I need to calculate/estimate index size for database. In 8.0.5 I used formula from Administrator Guide to calculate index size. Now this formula was removed because of it accuracy (see Metalink). Does some one has formula for 8i ? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT : RE: Linux file locking question (semi-off topic)
pounder, hell bore. report from hades sounds like an interesting place to work. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, November 09, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Wait...so...you got the SDS stuff goingand it works...but you can't tell if it's faster? Aching for results, etc. -Original Message- Sent: Friday, November 09, 2001 2:35 PM To: Multiple recipients of list ORACLE-L (Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off weekend and is probably flying around somewhere as I write. We have a 4X10 schedule and we get to arrange the days to maximize our weekends. Hmmm... I was the one who made out the schedule so how is it that Walt got the 4 day weekend? Oh well, I get a 3 dayer for my B-Day next Friday.) ANYWAY... We got the RAM disk running just fine but we haven't developed any comparative benchmarks just yet. We have this home built utility and Walt used it to simulate 1,000 users doing stuff a couple of days ago. (The utility was called pounder but has been enhanced and renamed to hell bore.) We loaded sample data from one of our largest sites for our first test and everything worked fine even when we submitted a report from hades with a query that returns 2.2 million rows. (Don't ask!) For a first pass we put the redo on the RAM disk together with a tablespace dedicated to some particularly busy indexes. Maybe we'll get some time to be more thorough about this and do some before and after comparisons but probably not... NUMBERS! We need numbers! Sigh... Will keep you advised on this. Clueless in Montana, Steve Orr -Original Message- Sent: Friday, November 09, 2001 11:28 AM To: Multiple recipients of list ORACLE-L well duh the answer to EVERYTHING is 42 --- Orr, Steve [EMAIL PROTECTED] wrote: OK... it's 42! Nice kitty... -Original Message- Sent: Friday, November 09, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- Weaver, Walt [EMAIL PROTECTED] wrote: Alright, I sent out a totally innocent question to the list and didn't get a single suggestion. I'm very disappointed in you people. So, let me say that I figured it out without your help. And I ain't saying what I did. So there. PPPHHT!!! -- Walt (my RAM disk is working great) Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 08, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Okay, this doesn't have much to do with Oracle other than the fact that I have been assigned with figuring out why this problem is occurring. We have a live chat application on Linux that uses Tomcat to manage its java servlets. A log is written to by the java processes, and this log can get rather large. Problem is, these java processes keep some sort of a write lock on the log and we can't clear the log out. Using lsof, I can get a listing of the java processes holding a lock on the log. One such process looks like this: java 32180 root6w REG 48,1 186487009 18036 /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log Bottom line is, how can I clear these write locks without killing the java processes? Somebody must know how. I couldn't possibly the first person on earth to encounter this problem. Thanks, --Walt (learnin about chattr()) Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
DBASSIST in 9i
Hi, We just install the custom 9i without the database option. But Now when we want to create database using dbassist we are not able to find the binary. Did the location changes in 9i or there is some tool now. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: index size calculation
Greg, I usually insist on that information from the development group then I can charge it off to their budget when it expands beyond the original space. Seriously, I build a table and indexes with init and next the DBBLOCK size and load a controlled amount of data. That will give you a good starting point for quesstimating the space requirements over the provected life of the project. I used the dbblock size to eliminate Oracle rounding up to even blocks. ROR mª¿ªm [EMAIL PROTECTED] 11/09/01 02:56PM Hi All! I need to calculate/estimate index size for database. In 8.0.5 I used formula from Administrator Guide to calculate index size. Now this formula was removed because of it accuracy (see Metalink). Does some one has formula for 8i ? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT : RE: Linux file locking question (semi-off topic)
I still like the bit about the Tower Controller knowing Walt. -Original Message- Sent: Friday, November 09, 2001 3:26 PM To: Multiple recipients of list ORACLE-L pounder, hell bore. report from hades sounds like an interesting place to work. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 just submitted OEM feedback
Patrice, You're reinforcing my already low opinion of OEM. At a previous job we had one very competent DBA that spent quite a bit of time on OEM, and it would never work properly. I'm still sold on homebrew monitoring, in Perl, ksh, or whatever you're comfortable with. One tool that I thought was impressive was BMC Patrol. Anything you could think of, it already did. Quite expensive and difficult to install I understand. Never got the opportunity to use it. Jared On Friday 09 November 2001 07:10, Boivin, Patrice J wrote: FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and 8.1.7.2.1 (on NT). I had at least thirty events configured, and planned to try using jobs. Not going to happen for a while yet... Oracle Support and I have been dancing around for weeks now, they absolutely refuse to tell me how to clean up the repository without having to rebuild it. Instead they just give me the same procedure to clean up the agent directories, etc. but the problem is not at the remote hosts, it is in the repository. The problem I ran into is twofold. 1)The OEM repository reported a referential integrity error, some records in a child table do not have corresponding entries in their parent table. This is a repository corruption problem, has nothing to do with the agents on remote hosts. 2)I have a number of events stuck in de-registration pending mode, which prevents me from de-registering the events and removing the nodes from the Navigation pane. Yes, I have shut down the agents, removed all the files in the /agent directories, shut down the console, stopped and restarted the management server, but the events are still there. I asked them to build into the next version of the OEM a utility that can scan the repository, look for bad entries, and remove them. There is no need to force people to spend hours rebuilding the repository and re-configuring everything just because of a few events being stuck in de-registration pending mode. If anyone else has encountered this problem and know a way to clean up the repository without having to rebuild it, please let me know, I would appreciate it. Other problems so far with the OEM: - The Oracle Expert this morning declared it cannot log into the Oracle Management Server, even though I can start up a console. The error I get is: org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]. I haven't looked in MetaLink yet, will do that. One more problem to look up re. the OEM. - The Forms listener event does not communicate properly with the Forms Server. - The Change Manager does not see tablespaces, tables, indexes from one of my NT servers (8.1.7.2.1). Oracle Support could not reproduce the problem. Next thing for me to try: rebuild the three databases on that machine, to see if that will fix the problem. Something I would rather not do. - The agent on my Tru64 UNIX server cannot talk to the databases on that machine, Oracle Support told me that there is probably a problem with the agent and they suggested I upgrade. We are upgrading that server soon, so I only used the node and TNS Listener events for the groups pane. The events for db up/down against this machine are stuck in de-registration pending mode. Finally, a funny anecdote: yesterday I ran the Oracle Expert against one of the three databases on that NT server I mentioned above. The Oracle Expert as part of its recommendations told me to take non-system objects out of the SYSTEM tablespace. All these objects were created when the databases were created, using Oracle's own GUI tools. I moved them out of there this morning using the script generated by the Oracle Expert, which was nice. If you find any problems with the OEM, I encourage you to submit them with Oracle. I am starting to think now that I should go into the repository manually and clean up the tables with invalid records. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
RE: I just submitted OEM feedback
Not familiar with BMC Patrol but I like I/Watch from Quest Software. I believe they are pretty similar though, especially in price. -Original Message- Sent: Friday, November 09, 2001 12:55 PM To: Multiple recipients of list ORACLE-L Patrice, You're reinforcing my already low opinion of OEM. At a previous job we had one very competent DBA that spent quite a bit of time on OEM, and it would never work properly. I'm still sold on homebrew monitoring, in Perl, ksh, or whatever you're comfortable with. One tool that I thought was impressive was BMC Patrol. Anything you could think of, it already did. Quite expensive and difficult to install I understand. Never got the opportunity to use it. Jared On Friday 09 November 2001 07:10, Boivin, Patrice J wrote: FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and 8.1.7.2.1 (on NT). I had at least thirty events configured, and planned to try using jobs. Not going to happen for a while yet... Oracle Support and I have been dancing around for weeks now, they absolutely refuse to tell me how to clean up the repository without having to rebuild it. Instead they just give me the same procedure to clean up the agent directories, etc. but the problem is not at the remote hosts, it is in the repository. The problem I ran into is twofold. 1)The OEM repository reported a referential integrity error, some records in a child table do not have corresponding entries in their parent table. This is a repository corruption problem, has nothing to do with the agents on remote hosts. 2)I have a number of events stuck in de-registration pending mode, which prevents me from de-registering the events and removing the nodes from the Navigation pane. Yes, I have shut down the agents, removed all the files in the /agent directories, shut down the console, stopped and restarted the management server, but the events are still there. I asked them to build into the next version of the OEM a utility that can scan the repository, look for bad entries, and remove them. There is no need to force people to spend hours rebuilding the repository and re-configuring everything just because of a few events being stuck in de-registration pending mode. If anyone else has encountered this problem and know a way to clean up the repository without having to rebuild it, please let me know, I would appreciate it. Other problems so far with the OEM: - The Oracle Expert this morning declared it cannot log into the Oracle Management Server, even though I can start up a console. The error I get is: org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]. I haven't looked in MetaLink yet, will do that. One more problem to look up re. the OEM. - The Forms listener event does not communicate properly with the Forms Server. - The Change Manager does not see tablespaces, tables, indexes from one of my NT servers (8.1.7.2.1). Oracle Support could not reproduce the problem. Next thing for me to try: rebuild the three databases on that machine, to see if that will fix the problem. Something I would rather not do. - The agent on my Tru64 UNIX server cannot talk to the databases on that machine, Oracle Support told me that there is probably a problem with the agent and they suggested I upgrade. We are upgrading that server soon, so I only used the node and TNS Listener events for the groups pane. The events for db up/down against this machine are stuck in de-registration pending mode. Finally, a funny anecdote: yesterday I ran the Oracle Expert against one of the three databases on that NT server I mentioned above. The Oracle Expert as part of its recommendations told me to take non-system objects out of the SYSTEM tablespace. All these objects were created when the databases were created, using Oracle's own GUI tools. I moved them out of there this morning using the script generated by the Oracle Expert, which was nice. If you find any problems with the OEM, I encourage you to submit them with Oracle. I am starting to think now that I should go into the repository manually and clean up the tables with invalid records. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: I just submitted OEM feedback
Jared Still wrote: One tool that I thought was impressive was BMC Patrol. Anything you could think of, it already did. Quite expensive and difficult to install I understand. Never got the opportunity to use it. i've gotten OEM to work, mostly anyway. i never got Patrol going even with BMC here to help. YMMV, MHO, yadda yadda yadda -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Absence is to love what wind is to fire; it extinguishes the small, it enkindles the great. - Comte de Bussy-Rabutin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle software on RAID 5
We have some Oracle 8.0.5 DBs on a RAID5 set on our OpenVMS server. It works fine, but there is really not a lot of writes going to our DBs (read-only legacy data). You don't mention the type of database (OLTP/DW/Hybrid) or it's size, number of concurrent users, etc., so I'll be generic. Writes *will* be sloww. Creating new datafiles will bring DB writes to a halt. Mildly heavy transactions will cause the DBWRs to go nuts. You will probably have the most problems with your online redo logs. We've been able to compensate somewhat by increasing the size of our redo log buffer. But then again, we're not heavy on the transactions. Good luck! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, November 09, 2001 12:35 To: Multiple recipients of list ORACLE-L We are in the process of reorganizing and reconfiguring of our disk space in preparation for an Oracle 8.1.6 upgrade in production, and my sys admin wants to use RAID 5 for the drive on which the Oracle 8.1.6 software will be installed. Anyone know of a reason why RAID 5 would not be OK for the software? We are on Digital Tru64 UNIX V4.0G. Thanks in advance, Catherine A. LeBlanc Database Analyst Bates College -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent Fail Safe Question
I must have been hallucinating, I can't find it now. Here are some interesting links I came across while looking: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=107487.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=133253.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=131775.1 Jared On Friday 09 November 2001 07:05, Grabowy, Chris wrote: Huh? Jared, did your search reveal that OFS is available for platforms other then Windows? The white papers and doc that I read stated Windows only because it's tied into Microsoft Cluster Server. IMHO, I think the Oracle folks took a look at MS Cluster Server and realized that it wouldn't be that hard to setup Oracle in MS Cluster Server. IMHO2, if you knew enough about MS Cluster Server you could probably setup Oracle in the cluster without OFS. But OFS makes it so much easier. -Original Message- Sent: Friday, November 09, 2001 12:55 AM To: Multiple recipients of list ORACLE-L On Thursday 08 November 2001 11:20, you wrote: I just recently installed Oracle Fail Safe 3.1.2 on W2K, Oracle 8.1.7 for a ... It is for Windows only, because it ties into Microsoft Cluster Server. And it was very cool, we failed each node back and forth many times with no problems. Granted there was no real load on the database. I thought so too. A search on MetaLink shows Fail Safe for several platforms. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pass a value from a shell script to a store procedure
Thank you so much for your help. I was trying to pass 'yesterday's date' from unix thru a cron to a package. I took Guy's advise and created a procedure to call this pkg. It was easy and quick. Thank you again. -Original Message- Sent: Friday, November 09, 2001 11:51 AM To: Multiple recipients of list ORACLE-L I'm sorry, I misunderstood. Were you trying to get Oracle to tell Unix what yesterday was? #!/bin/ksh sqlplus EOF system/incredibly_secret_password_but_this_is_probably_overkill_why_not_use_ scott_tiger select 'YESTERDAY=||sysdate-1||'' from dual set pages 0 set sqlprompt spool date_def / spool off exit EOF . ./date_def echo Yesterday was $YESTERDAY -Original Message- Sent: Friday, November 09, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Thank you so much for response to my email. I know we can do: Date= `date` but not `date -1`. -Original Message- Sent: Friday, November 09, 2001 11:14 AM To: Multiple recipients of list ORACLE-L So long as you embed your call to Oracle within your program, the program can pass variables to Oracle all day long. #!/bin/ksh DATE=`date - 1` DBA=`Anne Yu` sqlplus EOF system/incredibly_secret_password select $DATE,$DBA from dual; exit EOF echo Done! -Original Message- Sent: Friday, November 09, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hey List, I need to pass a value `date - 1` to a store procedure from a shell script. Really appreciate if anyone can help. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent Fail Safe Question
Hmmm...doesn't that mean someone owes me a beer? -Original Message- Sent: Friday, November 09, 2001 4:27 PM To: [EMAIL PROTECTED]; Grabowy, Chris I must have been hallucinating, I can't find it now. Here are some interesting links I came across while looking: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=107487.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=133253.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=131775.1 Jared On Friday 09 November 2001 07:05, Grabowy, Chris wrote: Huh? Jared, did your search reveal that OFS is available for platforms other then Windows? The white papers and doc that I read stated Windows only because it's tied into Microsoft Cluster Server. IMHO, I think the Oracle folks took a look at MS Cluster Server and realized that it wouldn't be that hard to setup Oracle in MS Cluster Server. IMHO2, if you knew enough about MS Cluster Server you could probably setup Oracle in the cluster without OFS. But OFS makes it so much easier. -Original Message- Sent: Friday, November 09, 2001 12:55 AM To: Multiple recipients of list ORACLE-L On Thursday 08 November 2001 11:20, you wrote: I just recently installed Oracle Fail Safe 3.1.2 on W2K, Oracle 8.1.7 for a ... It is for Windows only, because it ties into Microsoft Cluster Server. And it was very cool, we failed each node back and forth many times with no problems. Granted there was no real load on the database. I thought so too. A search on MetaLink shows Fail Safe for several platforms. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Partnership Program
My company is an Oracle Partner (from the Oracle Partnership Program, OPP) and damagement got an invite to a 1/2 day speel about OPP during OOW. Since I'll be at OOW it's thought that maybe I could see if there's any OPP opportunities we should know about. I'm skeptical that Oracle could actually help us market our product/service without extracting a pound of flesh but who knows? Has anyone participated in any of the OPP stuff and is it worthwhile? Candid opinions please. Anyway, it's been a long, long time since I was in damagement and had PL responsibilities but I thought I might come out of the closet for a while and dust off the MBA, put on a jacket and tie (YUCK!) and pretend to be a business/marketing drone for a few hours. Or would I be just wasting my time? Still a DBA and Still Clueless in Montana, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Warehouse Raid-5 Shark Environment
Anyone out there have any experience running an Oracle Data Warehouse on an IBM P660 (6M1) over a Shark/RAID-5/SAN environment? Work great? Any horror stories? Any gotchas? My concern in us potentially converting to this environment (from an AIX-SP/mirrored environment) has mostly to do with the RAID-5 aspect of the configuration, (especially for writes). But our loads are mostly during off-hours. Are there other things I should be concerned about? Any input would be appreciated!!! Wayne Bellefeuille -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellefeuille, Wayne S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: I just submitted OEM feedback
Jared/Patrice, We found that for its price, OEM was pretty good. I do agree that Perl/Ksh/SQL*Plus scripts is still more solid than OEM and its agents, but OEM 2.2 has come a long way since OEM 1.0. While there are many things that I do NOT like about OEM (i.e. stuck 'deregistrations', cumbersome repository, lack of Oracle Support's understanding, etc.) what I do like about OEM are *some* of it's add-ons. In particular: Management Pack for Oracle Apps, TopSessions, Change Manager, Capacity Manager. I tend to ignore any advice that these generate, but draw my own conclusions. Having to host the repository is a necessary evil :) Really good stuff: You can customize the counters (from v$sesstat) to check in TopSessions, sorting based on different parameters is useful, Baseline comparison in Change Manager are a cinch, Top resource/waiting Reports in Oracle Apps is useful when we meet the users about performance problems, On-screen automatic/manual refresh allows you to spot changes/waits quickly, etc... And the nicer part is that all the latest versions are supported when you take up the Repository/Agent that comes along with that version. We were really stuck with long lead times for Agents with HP-OV/OpC and BMC Patrol. (Don't know about Quest lead times). We had BMC Patrol installed (both here and in a previous gig), but at least in the 3.x version the agent went haywire and grabbed 100% of a CPU. Replacing this by OEM (mainly to satisfy the PHBs) solved the problem since the difference (between OEM and BMC agentwise) was that the OEM Agent went out to capture stats when prompted by the Repository which in turn was based on the Events and their scheduling, while the BMC Agent just kept collecting stats. We were not able to figure out a way of toning this down. The issue was the same with HP's OpC (Operations Centre)/OpenView. What I am trying to say is this: I am not an OEM fan, but parts of OEM have impressed even an old command line geezer like myself. Don't throw away your scripts, though - they are your suspenders that back up your belt! FWIW! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 12:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: I just submitted OEM feedback Patrice, You're reinforcing my already low opinion of OEM. At a previous job we had one very competent DBA that spent quite a bit of time on OEM, and it would never work properly. I'm still sold on homebrew monitoring, in Perl, ksh, or whatever you're comfortable with. One tool that I thought was impressive was BMC Patrol. Anything you could think of, it already did. Quite expensive and difficult to install I understand. Never got the opportunity to use it. Jared On Friday 09 November 2001 07:10, Boivin, Patrice J wrote: FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and 8.1.7.2.1 (on NT). I had at least thirty events configured, and planned to try using jobs. Not going to happen for a while yet... Oracle Support and I have been dancing around for weeks now, they absolutely refuse to tell me how to clean up the repository without having to rebuild it. Instead they just give me the same procedure to clean up the agent directories, etc. but the problem is not at the remote hosts, it is in the repository. The problem I ran into is twofold. 1) The OEM repository reported a referential integrity error, some records in a child table do not have corresponding entries in their parent table. This is a repository corruption problem, has nothing to do with the agents on remote hosts. 2) I have a number of events stuck in de-registration pending mode, which prevents me from de-registering the events and removing the nodes from the Navigation pane. Yes, I have shut down the agents, removed all the files in the /agent directories, shut down the console, stopped and restarted the management server, but the events are still there. I asked them to build into the next version of the OEM a utility that can scan the repository, look for bad entries, and remove them. There is no need to force people to spend hours rebuilding the repository and re-configuring everything just because of a few events being stuck in de-registration pending mode. If anyone else has encountered this problem and know a way to clean up the repository without having to rebuild it,
Re: index size calculation
we generally go for 50% tablesize for indexes .. works for most of our medium sized game databases. for very large tables .. i go with 20% sise of table per index Deepak --- Ron Rogers [EMAIL PROTECTED] wrote: Greg, I usually insist on that information from the development group then I can charge it off to their budget when it expands beyond the original space. Seriously, I build a table and indexes with init and next the DBBLOCK size and load a controlled amount of data. That will give you a good starting point for quesstimating the space requirements over the provected life of the project. I used the dbblock size to eliminate Oracle rounding up to even blocks. ROR mª¿ªm [EMAIL PROTECTED] 11/09/01 02:56PM Hi All! I need to calculate/estimate index size for database. In 8.0.5 I used formula from Administrator Guide to calculate index size. Now this formula was removed because of it accuracy (see Metalink). Does some one has formula for 8i ? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-04030 - Is it CLOB problem?
Hi List, We are using Oracle 8.1.7 on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor. We are getting sometimes problem with the error ORA-04030. Our DBA says this is the problem because of bug with Oracle 8.1.7 in Windows 2000 with CLOB datatype. We have developed our application with lot of CLOB usage. Is that true? Do we have an alternative to avoid that error? Or do we have to change the data type? Please suggest us. Thanks in advance, Regards, Prasad BAV. __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).