RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB Use BCP to export data from SQL Server and SQL Load import data into Oracle DB. Brian Chen -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
RE: ORA-03113: end-of-file on communication channel
I had this problem before in our Unix box. I have to use "ipcrm -m id" to remove the oracle process. You must use ipcs to find out the process first. Brian Chen -Original Message-From: John Weatherman [mailto:[EMAIL PROTECTED]]Sent: Monday, May 06, 2002 4:18 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-03113: end-of-file on communication channel All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done (fortunately this is on a development server). I'm still getting the ORA-3113. Anybody seen anything like this and/or have any suggestions for getting the database to open? TIA, John
RE: Oracle.exe taking too much physical ram
Title: Oracle.exe taking too much physical ram We experience the same problem in our production server. We contact Oracle support and upgrade the server from 8.1.6.3.7 to 8.1.6.3.8. The problem did not resolve. They suggest us to upgrade to 8.1.7.3. We have not upgraded yet. Brian Chen Database Administrator Bowne & Co. 345 Hudson Street NY 10014 (212)-931-1878 -Original Message-From: Arslan Dar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle.exe taking too much physical ram Hi gurus, My Production Box has 1Gb Ram with single 933Mhz PIII processor , though the db is not that big (4 GB), the oracle process is taking too much of memory, causing server to slow down on peak times of the day, and even after words, tonight, I looked up the memory which ORACLE.EXE has taken, its almost 900 MB, why is that so ??? The last restart was a month ago as far as I remember, is this an OPERATING SYSTEM tuning problem or database tuning is required? MY pagefile size is almost 2 GB, but the STATISTICS show that only 4-5 MB of physical memory is free, means the most of the physical memory is used in ORACLE processes, The sga size is following, SQL> select * from v$sga NAME VALUE -- Fixed Size 75804 Variable Size 90701824 Database Buffers 65536 Redo Buffers 77824 If db tuning is needed, from what point I should start, Also, I haven't analyzed the schemas from long, The occasion DEAD LOCK problems also show up, Can anybody shed some light, where the choke point is ??? Help and suggestions welcomed, Thanks in Advance, Arslan Zaheer Dar [EMAIL PROTECTED] Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre www.shaukatkhanum.org.pk + 92 (042) 5180725 - 34 Ext: 2323
Oracle.exe memory usage keeps going up.
Hi, We have an Oracle database 8.1.6.3.7 running in NT. We use Oracle Client 8.1.7.3 with OLE DB connect to database. There are two Web server connect to this database. First Web server have 20 constant connections to the database. The second Web Server makes vary connections and always drop connect after the application finish. The memory usage of Oracle.exe process increases when the Second Web server make connections. But after those connections drop, the memory decrease very little. For example, before the second Web server make connections, Oracle.exe uses 200M virtual memory. When the Web server make 20 connections, Oracle.exe uses 300M virtual memory. After those 20 connections drop, the Oracle.exe still uses 260M virtual memory. Over some period, Oracle.exe will run out of memory. Any idea what went wrong? How to solve this problem? Brian Chen (212)-931-1878 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chen, Brian 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: OO4O config
Title: OO4O config Alex, We have an power builder application which can run in Oracle 7.3.4 and Oracle 8.1.6 in the same machine. The Oracle Client need to be installed in separate directory. We use an ini file to define which client is used. Brian -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 13, 2002 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: OO4O config Hello, Friend of mine ask me, if there is a way to do a setup Oracle cliets on Windows (95/98/NT/2000), to be able to use two applications one of which is using OO4O 8.1.5 and other OO4O 8.1.6. Has anybody knows about such setup? Alex.