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

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

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.

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

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

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.

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.

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

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

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

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

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

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

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

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

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

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

Re: Bug, tuning issue or bad sql?

Ed - Sounds like you hit bug 1331849. Check Metalink for more info. Dennis Ed

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,

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