intermedia?
hi oracle gurus, does anyone knows anything about 'intermedia' ? how can I find materials about it. My client is going to buy it and I want to have a jump start. If you have any documents (electronic ones) ,or know any URL that helps,please send it to me and I'll be grateful. Oracle dba Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 816 ON WIN2000
I have installed 8.1.6, 8.1.6.2 8.1.6.3 all on the same Win2K box one after the other - and have never had a problem with installation, automatic database creation or the services not running as they should. Had a couple of funky ora-600's whilst on 8.1.6.2 but upgrading to 8.1.6.3 (8.1.7) fixed this. No other things jump out to mind that I have come across. There is a patch available for the 8.1.6 version on metalink to fix the ora-600 problem Regards Mark -Original Message- Sent: Friday, April 20, 2001 07:22 To: Multiple recipients of list ORACLE-L The installer hung at network configuration, but I think it's because we launched the installer remotely through a Terminal Services window. The database service does not come up automatically even though it says the service is started. A patch is available for this, but I have not applied it yet. -Original Message- Sent: Friday, April 20, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi List , I am supposed to install oracle 816 on win2K ( I knowI should go for real OS !! ) I am very much of a UNIX bigot and I am looking for any pitfalls and things I should look out for . TIA . Regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
how to install Oracle Developer2000 on Windows98 ?
dear listers, any body knows how to install Oracle Developer2000 on Windows98 ? I installed it on my machine but I can't even connect to my database thanks in advance , regards, bambang Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Idle time
Hi List, I have set idle time as 15 minutes by creating a profile and assigning it to a user. In OEM Oracle Top session the status is sniped. My question is what is considered as idle time . ? No activity on the machine or no statements running in the background or foreground for that particular session. The reason I am putting this question is in the OEM Top sessions the command is select , instead of UNKNOWN . I might have to reconsider my settings. Anyone with any inputs or pointers ? shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to install Oracle Developer2000 on Windows98 ?
Title: RE: how to install Oracle Developer2000 on Windows98 ? Hi Bamabang, Did you check the entry for the database in your tnsnames ora file ? Regards, Karthik Mohan TCS Consultant at GEP (HK) DialComm 3310962 ISD : 852-26290962 -Original Message- From: Bambang Setiawan [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Subject: how to install Oracle Developer2000 on Windows98 ? dear listers, any body knows how to install Oracle Developer2000 on Windows98 ? I installed it on my machine but I can't even connect to my database thanks in advance , regards, bambang Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: How to Automate Procedure Execution
Use "dbms_job" supplied package from Oracle to submit ur jobs to oracle DB with interval time. Rgds, Nirmal. -Original Message- From: abdul latif [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 7:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent: How to Automate Procedure Execution Do you know the syntax? --- "Jamadagni, Rajendra" [EMAIL PROTECTED] wrote: You can use dbms_job to achieve this ... 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 ! * 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: abdul latif INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Free Java dba monitoring tool and Java source code
Andy any luck with installing the tool. I enclose word doc about the tool Any problems with installation, please dont hesitate to contact me. The initial setting up of a Java application is always tricky, but once youve done one, you can get a clear picture. Thanks Sam -Original Message- Sent: Tuesday, April 17, 2001 9:31 PM To: Multiple recipients of list ORACLE-L Hi Sam, As part of my masters dissertation I have developed an SQL monitoring tool using Java/JDBC/thin drivers that allows the DBA to see who is taking up the resources currently in a database. This is not at all a commercial venture, purely academic. Plus if you want to learn about Java/JDBC this can be an invaluable asset/starting point as you know the subject well and you can see how the tool has been built. I'd love to see your Java Oracle DBA Open Source tool, up on a public internet site somewhere for download! :-) Some other Java-Oracle type Open Source links you might want to look at, to help further your own work, are: Apache JServ = http://java.apache.org/jserv/index.html DB Prism, Java/Oracle servlet engine = http://www.plenix.com/dbprism/doc/Home.html Tomcat (replacement for JServ) = http://jakarta.apache.org/tomcat/index.html jDBA, another Java Oracle DBA tool = http://www.jdba.org ViennaSQL, Java/Oracle SQL tool = http://vienna.sourceforge.net jDBA may the one you're most interested in, but using Java as the programming language for Open source projects, including Oracle ones, is growing rapidly in popularity! :-) Hope this is of some use 8) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dictionary information
Hi The view v$fixed_table will give u all x$ table information Brijesh --- Seema Singh [EMAIL PROTECTED] wrote: Hi Which dictionary table is used to see all X$ tables. Thnaks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datafile needs media recovery
Hi Since ur database in in archive log mode you can go for following method also just move your datafile to some other place. This is just for backup. Now create a new datafile based on existing datafile using following command alter database create datafile'old_datafile_name+path' as 'new_datafile_name+path' where old_datafile_name+path will be the path and name of ur orginal datafile which u have renamed and new_datafile_name+path will be the name and path u desire Then perform media recovery for that new datafile using recover datafile 'new_datafile_name+path' This method is basically used to recreate and recover damaged datafile However for this u must have all archive log files since orginal datafile was created Hope so this may help u Brijesh --- "Cale, Rick T (Richard)" [EMAIL PROTECTED] wrote: Hi All, Oracle 8 running in Archivelog One of my coworkers said they did the following: 1. Added a datafile to a tablespace 2. Took datafile offline and renamed at OS 3. ALTER DATABASE RENAME ... to new name 4. Attempted to bring datafile back online and get file needs media recovery. Tried to alter database recover automatic and other options but does not work. This is all the info I have does anyone have any suggestions on why it needs media recovery and how he can get it back online. We cannot drop the tablespace and rebuild. We could maybe export all objects in that tablespace then rebuild. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Reports
Is there a version of Reports that runs on Windows Me? You can download only reports for NT, Sun, and Linux. Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Idle time
Idle means the database didnt have to do anything to service this session, basically, they didn't run any sql hth connor --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi List, I have set idle time as 15 minutes by creating a profile and assigning it to a user. In OEM Oracle Top session the status is sniped. My question is what is considered as idle time . ? No activity on the machine or no statements running in the background or foreground for that particular session. The reason I am putting this question is in the OEM Top sessions the command is select , instead of UNKNOWN . I might have to reconsider my settings. Anyone with any inputs or pointers ? shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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).
RE: Free Java dba monitoring tool and Java source code
Hi Sam, Andy any luck with installing the tool. I enclose word doc about the tool Unfortunately, I've been on the road and living out of suitcases, in hotels, for the last 3 weeks, teaching Perl for Learning Tree. Also, our O'Reilly book, "Oracle and Open Source" has been printed this week, and I've had to write some articles to go with the launch, when it will be available to buy in a week or two, once it gets from the printers to the retail warehouses! Once life has settled down, I'll get onto your tool, and hopefully we'll be able to run a section on it, once you've made it into a Java/Oracle world leader, in our 2nd edition, IF we make it that far. I'm hoping the subscribers to this list, will help make that possible! :-) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Calling Package / Procedure
It is possible to call a package - subprogram without using dot notation? package name = my_package subprogram name = my_subp The only way I get it to work is calling my_package.my_subp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy II INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Peoplesoft (sqr)
SQR needs to be recompiled on your server using a 'C' complier that shipped with your UNIX OS. You only need todo this if you are running an older version of SQR. Which version of SQR you are running? vijay - Original Message - From: Henry Poras To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 18, 2001 2:50 PM Subject: Peoplesoft (sqr) I'm trying to understand what is going on with our sqr install whenmigrating Oracle from 7.3.4 to 8.1.6 (on Sun 2.6). After changing the Oracleversion we tried relinking the sqr executable in order to change the Oracleversion (sqrmake prompts for version information). The relink failed becausewe don't have a c compiler on the server. What I don't understand is why theinitial install doesn't ask for a c compiler but the relink does? Any ideas?Thanks.Henry-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Henry Poras INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
