Need Help on Operational Data Store
Greetings - I need some help with building an Operational Data Store. I know there are a lot of confusion in ODS vs. DW but I belong to the camp of 'ODS should be used only for operational reporting, not decision support'. So while Kimball talks a lot about building a DW in his books, he does not cover ODS much. Are there any books/websites/third parties that deal with building an ODS? TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need Help on Operational Data Store
After reading literature from Kimball, Inmon and some other experts, it seems to me that we should have a 3-tier architecture - Tier 1 - operational data Tier 2 - ODS which contains integrated, cleansed, transformed operational detail data, or staging area in relational schema Tier3 - star schema Data marts The question/contention here is tier 2 - should we provide reporting capability for this? According to Kimball, staging area should not be accessible to end users for direct reporting. But Inmon seems to disagree with him on this one. If ODS is an integrated, authoritative data source of the enterprise, I don't see why we can't create ad-hoc reports against it. Of course since it is relational, we might need reporting tools and heavy IS involvement. So IMHO it depends on what the user needs are to decide what tier2 should look like and be used for. Anybody cares to commend on this? Thanks Dennis Meng Database Administrator Focal Communications Corp. Jared Still jkstill@cybcon. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: Re: Need Help on Operational Data Store [EMAIL PROTECTED] 11/08/2002 11:19 AM Please respond to ORACLE-L Dennis, I think you got it wrong right off when you stated that there's a lot of confusion in ODS vs. DW . It isn't that issue at all. No two people can agree on what an ODS is at all, much less compare it to a DW. To me for instance, an ODS is a place to stage data for the final stages of some other process, be it a DW, or anything else. An ODS is a rather generic term, and therefor whatever you want it to be. Jared On Friday 08 November 2002 07:59, [EMAIL PROTECTED] wrote: Greetings - I need some help with building an Operational Data Store. I know there are a lot of confusion in ODS vs. DW but I belong to the camp of 'ODS should be used only for operational reporting, not decision support'. So while Kimball talks a lot about building a DW in his books, he does not cover ODS much. Are there any books/websites/third parties that deal with building an ODS? TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
Re: ora-1017 invalid username/password when trying to login as internal
I had this problem before and the cause was traced to sqlnet.ora. After commenting out a line ( sorry don't remember which line ) in that file the issue went away. Dennis Meng Database Administrator Focal Communications Corp. Rick_Cale@teamhe alth.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ora-1017 invalid username/password when trying to login as internal 08/29/02 03:38 PM Please respond to ORACLE-L Hi All, Oracle 8.1.6/WinNT I get ora-1017 invalid username/password when trying to connect as internal. I have recreated password file many times to no avail. Usually this all I have had to do in the past for this error. I have tried all combinations of remote_login_passwordfile. I was getting connected earlier. I had to a shutdown but cannot get server up. Luckily it is a relatively used development server. Any ideas on how to correct? Thanks Rick -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Corp. move to India
I would not treat this snip of news in such a light-hearted manner. Comparing to couple of years ago, the IT job market has slumped completely from a sellers market to a buyer's market. I am not a greedy person by any means and all I asking for is a decent salary and some job security. But if this trend of massive exports of IT jobs overseas continues, I am not sure how many of us will be able to have that. BTW, before firing the slingshots at this E-mail, please note that I am pro-globalization and have heard the arguments about fair market/competition etc. But bear in mind that we are standing on uneven grounds when competing with third world programmers because of the huge housing and living expense differences. Dennis Meng Database Administrator Focal Communications Corp. Gogala, Mladen [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: RE: Oracle Corp. move to India [EMAIL PROTECTED] 07/31/02 03:15 PM Please respond to ORACLE-L Is Larry Ellison learning how to speak Hindi? -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:40 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Corp. move to India Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
Foxbase to Oracle
Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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: Foxbase to Oracle
Thanks all who replied. I agree that for this app SQL Server might be more suitable. My main concern is the application code that enforces business logic. How do we migrate the source code into the new application without re-rewriting? I will definitely look into the tool recommended by Mike. But if we are to go with SQL Server or Access, what do we do with the application code? Thanks again Dennis Meng Database Administrator Focal Communications Corp. Mark Leith mark@cool-tools To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .co.uk cc: Sent by: Subject: RE: Foxbase to Oracle [EMAIL PROTECTED] 07/30/02 11:28 AM Please respond to ORACLE-L Not sure if Oracle provides one, but another solution is available here: http://www.kumaran.com/xbaseconverter.asp If it is such a small app though - why not just stick it in (dare I say this) something like Access or SQLServer.. -Original Message- [EMAIL PROTECTED] Sent: 30 July 2002 17:09 To: Multiple recipients of list ORACLE-L Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: Foxbase to Oracle - Thanks
Looks like most of the replies point to VFP. I will present this to my manager. Thanks to all who replied! Dennis Meng Database Administrator Focal Communications Corp. Karniotis, Stephen Stephen_Karniotis@com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] puware.comcc: Sent by: Subject: RE: Foxbase to Oracle [EMAIL PROTECTED] 07/30/02 12:44 PM Please respond to ORACLE-L Dennis: Foxbase was originally called 10-base before Fox Systems change the name. Foxbase was changed to FoxPro and then purchased by Microsoft and called Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly recommend investigating the MSFT solution. Sorry guys, but this is a realistic solution. Oracle, for eight users, will probably cost too much for the implementation. If you need to convert to Oracle, do the following: 1. Convert to FoxPro 2. Bridge Visual FoxPro to SQLServer and use the Data Transformation Services (DTS) to migrate the data to Oracle. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct:(248) 865-4350 Mobile:(248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
delete from table question
Hi All - I am trying to delete from a table that has 24 child tables. Because the constraints are not 'cascade delete', I am hitting the following: ORA-02292: integrity constraint (NVALET.FK_TOPOGROUPMEMBERNE2) violated - child record found If I want to go ahead and delete the child records as well, there seem to be 2 options: 1. Write a sql/plsql procedure to delete the child records first before each deleting each record from the parent table. 2. Recreate the constraints with 'cascade delete' and delete the records from parent table. After that recreate the constraints again without cascade delete. Either option requires some work. Does anybody have a better idea? Also can anybody have a script to recreate all constraints to share? TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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).
Database startup problems
Good day all - I had a strange problem yesterday after the unix admin installed a new disk drive to mirror existing disk. When trying to start the database from svrmgrl or sqlplus, it would say 'database opened'. But when I try to query against it, it said database not available, which is true because from the OS level there is no oracle background processes running. Mysteriously after about 10minutes the database finally started. The unix admin said he did not do anything. Has anybody experienced this before? TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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).
ad-hoc update check
Hi folks - I have received a stream of requests from developers/production support ( yep, same group, dont ask ) to do ad-hoc data massaging in the production databases. Since I don't know the applications that well, it's hard for me to push back these requests when told that if the script don't get run today, marketing department won't be able to use the system etc. I wonder if other people on the list have the same problem and I am thinking about coming up with a document for the developers to fill out making sure the request won't hose up the database. I wonder how other shops deal with issues like these and can you let me know what you can do to check for potential issues with a sql script. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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).
How to populate many-to-many
I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate this association table. It seems to me that we have to create a separate screen for this table to have the users manually enter the data. Right now this table has only three columns - ( server_software_id, server_id, software_id ). Bonus question - if we are going to use Access to manually enter data, is there any way we can avoid entering the raw numbers ( the association table columns are all numeric ). I remember with Oracle Forms you can set up some kind of drop down list where you pick the text value and the ids get populated behind the scene. I am not a fan of Access, can we do something similar? TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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: Datawarehousing help
Hi Jared - I am a little confused about this - 1. A DW may be a true 'warehouse' of enterprise data from which DM may be built. This is a full blown DW architecture though, and you may only wish to start with some DM to get your feet wet, or maybe that's all that is actually needed. So DM first or DW first? The first statement seems to suggest DW, but the second seems to suggest DM. 2. A DW may in fact very much resemble an OLTP database, with a temporal component thrown in to track changes to data over time. So DW is not star-schema but DM is? Can you elaborate a little on how DW resemble an OLTP. I am very interested in data warehousing and please let me know if you have any good pointers. TIA Dennis Meng Database Administrator Focal Communications Corp. Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: Datawarehousing help com 05/06/02 01:23 PM Please respond to ORACLE-L A DW is not simply a collection of data marts. A DW may be a true 'warehouse' of enterprise data from which DM may be built. Extracts go to the DW, DW is used to build DM. A DW may in fact very much resemble an OLTP database, with a temporal component thrown in to track changes to data over time. Users are not (generally) allowed acces to the DW. This is a full blown DW architecture though, and you may only wish to start with some DM to get your feet wet, or maybe that's all that is actually needed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/06/2002 06:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Datawarehousing help Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being collected, I can see them wanting data aggregated hourly. I greatly doubt the tech people will allow adhoc queries, they seem to do things right here. What will happen is that they will be contacted by marketing with an I need this new report NOW request, but tech will generate it. But *my* problem is that the data warehouse will supposedly be only a small part of what I'm responsible for, I don't think they understand the scope of what they are asking for, as yet. They will, I'll make sure of it. Right now, as this is a new internal group, I'm still collecting information on which databases I will be responsible for. Then I just have to remember that when I set deadliines, I am prone to underestimation. :) Rachel |+--- || | || | || DWILLIAMS@lif| || etouch.com | || | || 05/03/2002 | || 08:48 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help| | Rachel - I always find it helpful to understand something if I know
PL/SQL Mail Question
Hi All - I am in the process of developing a PL/SQL procedure to monitor all production databases and run into a road block: The PL/SQL procedure is supposed to run my monitoring sql scripts and use the UTL_SMTP package to send the output ( list of invalid objects, near extent limits etc ) to the DBA. I tested sending a dummy message to me using the UTL_SMTP and it works, now how do I send the output of a query as part of the E-mail message? Any pointers would be appreciated. Or can I spool the sql output to a file and mail it as an attachment, but somehow I think the first solution is cleaner. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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: monitoring multiple databases using PL/SQL -- follow-up question
Thanks all who replied to my E-mail. Right now I am still leaning toward having a centralized monitoring script running in a admin database because - 1. Ease of administration 2. We don't need anything fancy, don't need application level monitorin, so the requirements for different databases are similar. 3. If we use PL/SQL jobs and monitoring tables then all of our scripts can be backed up as part of the database backup. So if anything happens to the monitoring server/db all we have to do is recovering the database. We can even restore the monitoring database to another server if we need to. I am not certain if point 3 is correct so any thoughts on this? Dennis Meng Database Administrator Focal Communications Corp. Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sfaroult@oricc: ole.com Subject: Re: monitoring multiple databases using PL/SQL Sent by: root@fatcity. com 04/23/02 08:03 PM Please respond to ORACLE-L Ypu may find the following paper of interest: http://www.oriole.com/papers/monitor.html A few years old, but sits somewhere in the middle as Chris suggests. And you can use all of his scripts :-). Grabowy, Chris wrote: Dennis, True, but you should also consider... In a decentralized configuration, the monitoring software or scripts reside with the database. This complicates maintenance, but allows for higher monitoring availability. I believe that your better off somewhere in the middle. You can host a set of PL/SQL procs in a monitoring schema on each database server to check the basics of the database, and report back to you. In this configuration, you can enhance and add features to the development version, and make sure it works, before updating all the databases. Du'oh!! Configuration Management!!! And then you can host specific are you up/bogus login scripts on a central host. Generally, your Oracle database stays up...since it's not SQL Server...du'oh!!! The majority of the database problems are in the database, ie. maxextents, no space, performance, blah, blah...there is a list in my paper. Don't forget to collect all this monitoring data in some table(s), as it will become useful. And be sure to CC your boss on all the benefits your monitoring services provide you. Hopefully, some funding will eventually be thrown your way to get a decent monitoring product. Also, recently I saw a demo of a monitoring product called AutoDBA. It is very slick, almost like having a junior DBA doing all the boring, monitoring, dirty work. Except it doesn't get your coffee for you...or wash your car...or... HTH. Chris Grabowy DISCLAIMER: I am not in any way associated with the makers of AutoDBA. My paper also includes a list of other monitoring products. -Original Message- Sent: Tuesday, April 23, 2002 1:53 PM To: Multiple recipients of list ORACLE-L From 'Oracle Database Monitoring for the Beginner' (pdf) - Chris Grabowy In a centralized configuration, the monitoring software scripts reside on one server. This obviously makes maintenance easier, but if the hosting server fails then there is no (more) monitoring of the databases regards Madhu From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of
monitoring multiple databases using PL/SQL
Greetings - I am planning to centralize our Oracle monitoring process by using one PL/SQL procedure to query database extents, invalid objects, alert logs etc through database links. I wonder if anybody has done it before and if there is any cons with it. The pros would be ease of administration, ease of standardization etc. TIA Dennis -- 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).
User Logon Auditing
Greetings, I have a request from my boss to come up with a list of users for a particular database. Since this is 805 database logon trigger is not an option. Turning on audit trail will be an overkill and not sure if performance will be acceptable if we do that. Other than querying v$session periodically and hoping to get everybody, is there a better way to do this? DBA_USERS view is not going to work because there are too many duplicate and obsolete entries. TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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).
Data Warehouse Tools
Hi All - This is for DBAs who have participated in a DW project: what kind of tools did you use for design, ETL, Query etc. I know Oracle has a data warehouse builder but it doesn't seem to be widely used. What is the most popular tools out there for DW construction and what is the trend? TIA Dennis -- 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: Bug, tuning issue or bad sql?
Ed - Sounds like you hit bug 1331849. Check Metalink for more info. Dennis Ed mrclark@xnetTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: Bug, tuning issue or bad sql? root@fatcity. com 02/27/02 09:23 AM Please respond to ORACLE-L Oracle 8.1.6.0 NT 4.0 I'm having a problem with a query which is basically just a bunch of UNION ALL's that I want sorted in a certain way. The query runs flawlessly when I limit the result set with a where clause, but when I remove it, the query crashes when sorting (in the order by at the far bottom). If I remove the ORDER BY, the query runs beautifully. The max rows returned by this is about 12,000. I am confident that the values returned are consistant across each of the UNION's. Here's the error returned: trans_demographic td * ERROR at line 257: ORA-00600: internal error code, arguments: [5213], [], [], [], [], [], [], [] In other words: 1. Query runs with no ORDER BY. 2. Query runs with ORDER BY, when limiting rows returned. 3. When limiting rows returned, I can use any value in the full range (in this case poe_assoc_id), and everything works as long as the total rows returned are less than around 3,000. I have tested every range of data, and I can use any set of valid values as long as I do it in pieces. So my question is: is the sql bad somehow (I don't think so). Is this a tuning issue on the database itself? Is this a bug in 8.1.6.0? Thanks in advance! Ed P.S. Here's the big ole query: select ae_email_addr, ae_assoc_id, poe_assoc_id, table_type, poe, adds, changes, drops, ae_name from (select a.assoc_id poe_assoc_id, a.poe poe, 'Member' table_type, SUM(DECODE(tm.record_change_type,'A',1,0)) adds, SUM(DECODE(tm.record_change_type,'C',1,0)) + SUM(DECODE(tm.record_change_type,'T',1,0)) changes, SUM(DECODE(tm.record_change_type,'D',1,0)) drops, a.ae_email_addr ae_email_addr, a.ae_name ae_name, a.ae_assoc_id ae_assoc_id from(select a.assoc_id, poe_am.mem_id poe, ae_m.first_name||' '||ae_m.last_name ae_name, ae_am.assoc_id ae_assoc_id, NVL(ae_m.email_addr,'[EMAIL PROTECTED]') ae_email_addr from ASSOCIATION a, ASSOCIATION_MEMBER poe_am, MEMBER poe_m, ASSOCIATION_MEMBER ae_am, MEMBER ae_m where a.assoc_type = 'L' anda.assoc_status_cd = 'A' anda.assoc_id = poe_am.assoc_id andpoe_am.relation_type = 'POE' andpoe_am.mem_id = poe_m.mem_id andpoe_m.primary_assoc_id = ae_am.assoc_id andae_am.relation_type = 'EO_ID' andae_am.mem_id = ae_m.mem_id) a, TRANS_MEMBER tm wherea.assoc_id = tm.primary_assoc_id(+) and a.poe = tm.sender_id(+) and tm.last_changed_dt(+) BETWEEN '01-JUN-2001' AND '30-JUN-2001' GROUP BY a.assoc_id, a.poe, a.ae_email_addr, a.ae_name, a.ae_assoc_id UNION ALL SELECT a.assoc_id poe_assoc_id, a.poe poe, 'Member Supplemental' table_type, SUM(DECODE(tms.record_change_type,'A',1,0)) adds, SUM(DECODE(tms.record_change_type,'C',1,0)) changes,
NT Monitoring Scripts
Greetings, We recently implemented an Oracle 8.1.7 database on NT4.0. Since this is the first for our company, I need some help setting up the monitoring procedure. On the unix side I have a Korn script that parses the alert log and page/E-mail me if errors are found. But NT is a different beast and I don't know much about the scripting side of things ( other than it's pretty lame :) ). So does anyone out there have a script/tool handy? I think I have better things to do than picking up an NT scripting book just for this one database. Also, does anyone have good experience with MKS? Our NT administrator is not crazy about installing it on our production server. TIA Dennis -- 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).
11i and cc
Hi All, I am doing a test installation of Apps11.5.5 and ran into a problem during pre-install check: There is an alert saying the system utility 'cc' is not found. I asked our SA to install it but was told that we did not have license for 'cc', we only have 'gcc' which is free. Now can we get away with 'gcc' here or do we have to buy 'cc'? TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
Centralized Alert Log Monitoring
Hi All, Currently I am the only DBA for the 15 productin databases in our company. I have written shell scripts on all database servers to parse the alert.log file and look for Oracle errors and send page/E-mail if problems are found. While this works it is sometimes painful to maintain - if I want to change something I have to go to different servers to change the scripts one by one. I figure it would be nice if we can have a centralized solution where I can monitor alert logs remotely and don't have to hop from server to server. Are there any tools/scripts that enable DBAs to do this? I know OEM can do that with the Advanced Events but now you have to buy the Diagnostics pack for that. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Centralized Alert Log Monitoring
Thanks all for the reply. To make the problem more challenging, I would like to add that ( sorry for not mentioning about this in my original E-mail ) our shop has both NT and Unix. Any ideas? Dennis Meng Database Administrator Focal Communications 847-954-8328 Brian Haas bhaas@musiciansfTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] riend.com cc: Sent by: Subject: Re: Centralized Alert Log Monitoring [EMAIL PROTECTED] 01/07/02 01:27 PM Please respond to ORACLE-L Dennis, I'm not sure if you have any NT boxes or not, but for the unix side have you considered setting up an NFS share? You could store one copy of the script there and mount that share on the db servers. Then just schedule it like you normally would (cron,at). Depending how your script works, you may need to abstract out hard coded values, and pass them as command line parameters for file locations, sid, etc. We do this for our web site code and all of our utility scripts. It makes maintenence much easier. HTH, -Brian On Mon, 7 Jan 2002 [EMAIL PROTECTED] wrote: Hi All, Currently I am the only DBA for the 15 productin databases in our company. I have written shell scripts on all database servers to parse the alert.log file and look for Oracle errors and send page/E-mail if problems are found. While this works it is sometimes painful to maintain - if I want to change something I have to go to different servers to change the scripts one by one. I figure it would be nice if we can have a centralized solution where I can monitor alert logs remotely and don't have to hop from server to server. Are there any tools/scripts that enable DBAs to do this? I know OEM can do that with the Advanced Events but now you have to buy the Diagnostics pack for that. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Centralized Alert Log Monitoring
Hi Ruth, Thanks for the reply. This tool does sound promising. I checked their website and read up a little bit on it but didn't see any scripting/paging capability. Are you using the tools right now and is there anyway for it to scan all the alert logs and send pages if errors are found? Thanks again Dennis Meng Database Administrator Focal Communications 847-954-8328 Ruth Gramolini [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ate.vt.uscc: Sent by: Subject: Re: Centralized Alert Log Monitoring [EMAIL PROTECTED] 01/07/02 01:15 PM Please respond to ORACLE-L Try AlertView, it's free, a gui tool for monitoring as many database alert.logs as you want. Go to www.zephyrus.com to download it. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 07, 2002 1:57 PM Hi All, Currently I am the only DBA for the 15 productin databases in our company. I have written shell scripts on all database servers to parse the alert.log file and look for Oracle errors and send page/E-mail if problems are found. While this works it is sometimes painful to maintain - if I want to change something I have to go to different servers to change the scripts one by one. I figure it would be nice if we can have a centralized solution where I can monitor alert logs remotely and don't have to hop from server to server. Are there any tools/scripts that enable DBAs to do this? I know OEM can do that with the Advanced Events but now you have to buy the Diagnostics pack for that. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Monitoring Big Deletes
Greetings, We have a third party application that has processes that delete millions of rows from a big table without a commit in the interim. Is there anyway we can monitor how many rows have been deleted? Since we can't change the code to make it commit, the easy option of 'select count(*) ' is out of the question. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
Anybody using Incentive
Hi all - We purchased Incentive about 6months ago and it has been a nightmare for our DBA group: the application would generate millions of rows overnight and then try to delete millions of rows from a big table called PAYEEADJTASK without a interim commit. Our database has only about 2 gigs of data but has 7 gigs of rollback segment to accomodate the big deletes. Also it takes days to run some of their processes. Our company has only about 350 sales people to pay. According to Incentive, this is all normal. Has anyone on this list used this app before and care to share some tips on how to deal with it? I want to keep my full head of hair through this Christmas... Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
Flat File vs. Database
Hi all, We are proposing a project to convert applications that use flat files to Oracle databases. An essential piece of this proposal is to present to the management the advantages of databases over flat files. Are there any websites, whitepapers that talk about this? I know this probably is a no-brainer for most of you but we just want to have all of our ducks in a row so that we can make a strong case. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
Apps Login Error
Hi List - After installing Apps 11.5.2 I am attempting to login for the first time. I can login as sysadmin through 'personal homepage' without a problem. But when I try to access individual modules by clicking on the links under 'application', I get the following: APP-FND-01508: Failed to connect I click OK and it takes me to the next error: There are no valid navigations for this responsibility Anybody knows what the problem could be? TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
8.1.6 to 8.1.7 upgrade
We are about to do an 'emergency' upgrade from 8.1.6 to 8.1.7 on NT 4.0. Since this is the first time we are doing this on NT, I am wondering if anybody on the list who has been there, done that, and let us know what kind of caveats we might run into or just outline the steps we should go through. I know Oracle provide a GUI tool for this but I don't know if it's that reliable. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: rman question
Joan, I don't know about about cold backups but I have done this successfully with hot backups. What you can do is restore your hot backups ( could be old ones ) and do a point in time database recovery using rman 'duplicate database' command. It 's fairly straightforward. Dennis Meng Database Administrator Focal Communications 847-954-8328 Joan Hsieh joan.hsieh@tTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ufts.educc: Sent by: Subject: Re: rman question root@fatcity. com 07/13/01 09:10 AM Please respond to ORACLE-L Janardhana, Thanks, another question is that on same production machine we have FM online production instance and reporting instance. We refresh reporting database everynight. (shutdown production, cp datafiles..) Can I use rman to restore all datafiles and redo files to reporting database and recreate control file to rename the reporting database? How rman deal with redo files if we use cold backup? (you know, I can do OS image copy for those files) Is that a tag name can include all the datafiles, control files and redo files image copies)? Joan Janardhana Babu wrote: You may try duplicate database with the dbname the same as test database using RMAN. You may need to use the tag command while backing up sothat you can specify the tag while restoring, but, if more than one backupset available with the same tag (it is in most cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Subject: rman question Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
DB Backup Question
Hi all, We are running into tape capacity problems and unix admin came to me asking if we could skip backing up some drives. Right now we are doing hot backups on all production databases to disk and then the whole server get backed up to tape. Since the backups for open database files are not valid, the unix admin asked if we could only backup the drives that has the backup dumps. One side of me says this can be done but another nagging side of me is not sure about this. So I am posting this to the list and see what other folks think of this one. Thanks Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
Apps Connection Problem
Greetings, I have just finished installing Apps11.5.2 on our test box running Solaris 2.7. After I logged on from the personal homepage as sysadmin, I tried to access individual modules and got the following error: APP-FND-01508:Failed to Connect Cause: AOL was unable to connect to the Oracle database All the services were started successfully. Database and listener is up and running and no error in the alert log. Can anyone tell me what gives... Thanks Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
FRM-92090 Error
Hi All, We just installed Apps 11.5.2 on one of our Solaris 2.7 servers and were able to start up all the processes sucessfully. After loggin on through the apps logon front end I encountered the following error when clicking on any one of the application modules: FRM-92090: An unexpected error occurred. Details... Java Exception: java.lang.NullPointerException at oracle.forms.net.HTTPStream.getResponse(Compiled Code) at oracle.forms.netHTTPStream.flush(Compiled Code) at oracle.forms.engine.Main.createRunform(Unknown Source) at oracle.forms.engine.Main.start(Unknown Source) at sun.applet.JinitAppletPanel.run(Compiled Code ) at java.lang.Thread.run(Thread.java:466) Anybody has a clue of what is going on? TIA! Dennis Meng Database Administrator Focal Communications 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB Link Between Prod and Test?
Bill, Thanks for the info. You just provided me some ammo to shoot this one down :) Dennis Meng Database Administrator Focal Communications 847-954-8328 Thater, William To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ThaterW@telecc: rgy.net Subject: Re: DB Link Between Prod and Test? Sent by: root@fatcity. com 05/15/01 02:46 PM Please respond to ORACLE-L On Tue, 15 May 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -One of our development DBAs suggested today to build a private database -link between production and test database so that he can run some -queries against both at the same time. I am a little concerned because he -might make a mistake and accidentally corrupt the prod database. Anybody -out there who is doing the same thing? Are there any other potential -ramifications? Don't go there. Been there, done that, got bit bad. Yes you can mess with the production data. Might work if the user on the production side lived in it's own tablespace and only had select privs on the production data. But I don't like the precedent. YMMV, yadda, yadda, yadda. -- Bill Thater Certifiable 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. ~~ Random access is the optimum of the mass storages. -- 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). -- 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).
PL/SQL Question
I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).