Re: strange oracle problem - please help!!

Thanks for offering your help. I checked thru and thru on all the tnsnames.ora, listener.ora, etc.. all to no avail. the server entries in the tnsnames are IP address oriented (i am also the web programmer, system analyst, web administrator and system administrator .. sheesh).

Actually, I got one major suspect right now, my oracle 8.0.6.0.0 on NT has a sga size at 100mb but all the connecting profiles have unlimited resources set. At any one time, I got 100+ connections all running at dedicated server modes. Just 3 weeks ago, the db ran into big problems whereby all the web application
servers had reported errors in running a common entry save stored procedure. Then I got alot of records missings in the db which the users claimed that they have filed in, system reported the records is saved but log out and log in again, the record disappeared. The backups that I did , export, did not capture the saved data, but it seems to appear after 5 days later. I strongly suspect that I didn't size up the sga enough. I checked at the free memory at the v$sgastat and there's about 18Mb left.. gotta be this.... oracle and vendor both can't help at all and they blamed each other for it.

CK

Gordon Cartwright wrote in message <3A8328AA.96327B09_at_yahoo.co.uk>...
>Can you post the tnsnames.ora from the web server box and the listener.ora
 from
>the prod and dev servers? Also, if the tnsnames.ora does not specify IP
>addresses, but uses machine names can you give details of the name
 resolution
>methods (DNS, WINS etc).
>
>When the system is up an running, have you had a look at the connections
 from
>the web server? Can you see the sessions against database?
>
>WCK wrote:
>
>> yes.. i have checked all possibilities.. tnsnames, odbc, listener, etc.
>> all to no avail. my vendor is baffled and oracle support has given up on
 my
>> side.
>> what can possibly happen that can cause this type of strange problem?
>>
>> is it possible that the data somehow never get committed throughout the
>> entire 4 days?
>>
>> Gordon Cartwright wrote in message <3A810148.13C46DD2_at_yahoo.co.uk>...
>> >You don't say what makes you think the .99 database is affected, or
 where
 the
>> >webserver software runs. Assuming the web server is on a different
 machine,
>> >check the config on that box to see which DB it is connecting to.
>> >
>> >WCK wrote:
>> >
>> >> My oracle 8.0.6 is running all on NT 4.0 SP6a.
>> >>
>> >> my environment is like this;
>> >> 190.1.1.99 - production environment; PROD instance and database.
>> >> 190.1.1.201 - develop environment; PROD instance and database.
>> >>
>> >> when I am doing shutdown on 190.1.1.201 via svrmgr30, it seems to
 affect
 the
>> >> .99. any idea why this happen? i thought the svrmgr30 affect the local
>> >> database environment, even the tnsnames.ora on the .201 doesn't have
 an
>> >> entry for the PROD production but is referred as 99PROD.
>> >>
>> >> I think it cause a massive connection misdirection as my web server
>> >> applications reported alot of errors and seems to respond to the work
 that
>> >> I was doing in the development environment.
>> >>
>> >> How can this be explained? listener? network? spoofing?
>> >>
>> >> Please help. I am out of ideas already.
>> >> abramswee_at_yahoo.com
>> >
>
Received on Sun Feb 11 2001 - 07:13:19 CST