Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy the Oracle CD to the hard drive. I copied it to a subfolder directly to C:\Oracle9i 2. Change the file c:\oracle9i\install\ORAPARAM.INI to reflect the actual name of the directories listed in the install directories of the cd I just copied. I did this and next took out some "."s and put the absolute path to the java program and something called the "OUI_LOCATION". JRE_LOCATION=C:/oracle9i/stage/Components/oracleswdjre/13110a/1/DataFiles/Expanded OUI_LOCATION=C:/oracle9i/stage/Components/oracleswdoui/220120/1/DataFiles/Expanded Okay so good so far. This time the installer actually started. The problem occurs in the next few steps, when I click "next" (weiter in German) from the welcome screen- please understand if I translate something wrong here. Then I am shown the installation directory screen, where I select the default listed: Source : C:\Oracle...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard disclaimer: http://www.dbainfopower.com/dbaip_advice_disclaimer.html "kumu" <forlist2001@yahoo.com> wrote in message news:a44abd39.0402161837.6badb9ed@posting.google.com... > Hello All, > I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or > 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? > > Also I had a bad experience with my development server when applying > 9.2.0.3 patchset. Is there anything you recommend before I start > again? > > Thanks > Kumu "Ron" <support@dbainfopower.com> wrote in message news:<QqWdnRM_cMiwWqzdRVn-vg@comcast.com>... > Hello Kumu, > > What is the reason for upgrade? Any specific bugs or issues you > experience? > > You can open TAR as well to get support recommendations for your > situation. > > New patches can introduce new...

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.com> schreef in bericht . > How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 > > 1-what scripts are to be used > 2-Where i can find these scripts. > > Thnks. Hi, I guess oracle dosen't support backword comatibilty.then how it is possible?? Thanks Alok. On 9 Aug 2005 22:05:49 -0700, alok.behria@gmail.com wrote: >Hi, > > I guess oracle dosen't support backword comatibilty.then how it is >possible?? > >Thanks >Alok. Oracle is backwards compatible provided you have the definition of backwards compatible correct. You can connect (again) *lower version client* to a *higher version database* The other way around has nothing to do with backwards compatible, though it usually works, *with the exception of export/import, AS DOCUMENTED* (but I guess no one ever reads the docs) -- Sybrand Bakker, Senior Oracle DBA Hi, ...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, > > does anyone can provide the node document information of step by step > doing it. > > many thanks > > leehi Go to metalink.oracle.com (registration and Oracle support CSI required). Click on Patches and Updates tab. Wait for the whole screen to load. Use one of the search functions to find your patch (note the Quick Links if you are getting something common, like 9206 or 9207). When you finally get to your patch download, click on the readme (the piece-of-paper icon next to the download icon). Read all the instructions. It's a good idea to read the instructions every time you do it, even (or perhaps especially) when you are comfortable doing it. The readme is usually also included with the patch. Download and unzip the patch. Look at what is there in the patch, perhaps there are additional release notes. Look around on metalink for addition...

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

Oracle 9.2 vs. Oracle 9.2.0.4.
I'm using SDK 1.4.2_03 either with an Oracle 9.2 or an Oracle 9.2.0.4 client version. The 9.2 version behaves as expected. My problem only occurs with the 9.2.0.4. version. If I try to process the ResultSet of database query and the selected column data includes leading blanks, the 9.2.0.4 seems to trim these leading blanks. Is this behaviour known or am I doing something wrong ? <code snippet> ResultSet result = null; Connection con = null; Statement stmt = null; Vector vec = new Vector(); try { con = DriverManager.getConnection(dbUrl, dbUser, dbPassword); stmt = con.createStatement(); result = stmt.executeQuery("SELECT DATA FROM CPTMESSAGEDATA";); while (result.next()) { vec.add(result.getString("DATA")); } con.close(); stmt.close(); } catch (SQLException e) { } </code snippet> CPTMessageData.DATA is of type VARCHAR2(50) not nullable with values like: " @20013 @E123 @G123 @ @ @ " " @3700167 @43186 @B50_300 @1 @20013 @1 @OK " Any help is appreciated. Alex ...

oracle 9i (9.2.0.1.0)
Hi! when I call the oracle performance manager I get the following errors: VTM-0002: error when displaying graph java.lang.null.pointerexception at oracle.sysman.vtd.VtdCartridge.lookupClass(VtdCartridge.java:1313) ..... what is my problem? Thanks! ...

Oracle 9.2.0.1.0 Install Fail On Win2k
I am attempting to install Oracle 9i (9.2.0.1.0) onto my machine running Windows 2000 Professional which, according to Oracle, is a supported configuration. After selecting my installation type, the installer fails with the following error message: "The procedure entry point SetHandleContext could not be located in the dynamic link library KERNEL32.DLL". From searching the web, I have found comments suggesting that SetHandleContext no longer exists in KERNEL32.DLL on Windows 2000. Is the 9i installer perhaps thinking that I am running NT ? Help in this regard would be greatly appreciated. We are running Oracle 9204 EE on win2k adv. We never had any issue with the installation and running oracle on win2k. In fact, as you pointed out, the problem is to find information on various issues on windows. Oracle will work perfectly on windows but it requires a little self trainning. Keep searching. "StephenMatthews" <steveandemma@matthews2002.freeserve.co.uk> wrote in message news:<bod8c2$ion$1@news7.svr.pol.co.uk>... > I am attempting to install Oracle 9i (9.2.0.1.0) onto my machine running > Windows 2000 Professional which, according to Oracle, is a supported > configuration. After selecting my installation type, the installer fails > with the following error message: "The procedure entry point > SetHandleContext could not be located in the dynamic link library > KERNEL32.DLL". From searching the web, I have foun...

Problem installing Oracle Designer 9.0.2.0.1
Hi everyone, I installed Oracle Database 9.2.0.1.0 on Windows 2000. Now I m trying to install Designer 9.0.2.0.1 but I m getting a message at the beginning of installation and the message is : Dependencies: Oracle 9iAS cannot be installed into an existing Oracle 9.2.0.1.0 or higher Oracle Home. If somebody help I will be really appreciate it. -- Haji Syed, Hassan On Mon, 08 Dec 2003 03:18:13 GMT, "hajisyed" <hajisyed@rogers.com> wrote: >Hi everyone, > >I installed Oracle Database 9.2.0.1.0 on Windows 2000. Now I m trying to >install Designer 9.0.2.0.1 but I m getting a message at the beginning of >installation and the message is : > >Dependencies: >Oracle 9iAS cannot be installed into an existing Oracle 9.2.0.1.0 or higher >Oracle Home. > >If somebody help I will be really appreciate it. You should have installed Designer first. And you need to install Designer in a *different* Oracle home, which can be accomplished by changing Oracle home in the installer. -- Sybrand Bakker, Senior Oracle DBA ...

Setting file permission error on Oracle 9.2 installation on RedHat 9.0 #2
Hi, On installing Oracle 9.2 on RedHat 9.0 and AS 2.1, I encounterd the same following error: Error in setting permissions on file/directory /opt/oracle/jre/1.1.8/LICENSE Could someone tell me why it happened and how to fix it? Your help is much appreciated. Thanks, Rob ...

optimizer_features_enable difference between 9.2.0.1/9..2.0.3/9.2.0.6?
Hi, All, I noticed for this parameter optimizer_features_enable , oracle document says: Syntax OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | 9.2.0} I noticed when I keep it default to 9.2.0 in init.ora, in version 9.2.0.3 and 9.2.0.5 with exact same database and exact same init.ora, oracle CBO did choose different plan. So there is some difference between 9.2.0.X versioin for the CBO. Where can we get such information about the difference? Thanks On 12 Jul 2005 23:37:28 -0700, "chao_ping" <zhuchao@gmail.com> wrote: > So there is some difference between 9.2.0.X versioin for the CBO. >Where can we get such information about the difference? Usually such things are outlined either in the release notes or in the new features documents. Documents that obviously no one reads. -- Sybrand Bakker, Senior Oracle DBA "chao_ping" <zhuchao@gmail.com> wrote in message news:1121236648.759298.79320@g44g2000cwa.googlegroups.com... > Hi, All, > I noticed for this parameter optimizer_features_enable , oracle > document says: > Syntax > OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | > 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | > 9.2.0} > > > I noticed when I keep it default to 9.2.0 in init.ora, in version > 9.2.0.3 and 9.2.0.5 with exact same database and...

Installation of Oracle 9.2.0.1.0 hangs at linking stage...
Hi Friends, I am trying to install Oracle 9.2.0.1. on Solaris 5.10 Installation fails during linking process at 61% & doesnt move ahead. When I abort the the installation & try to run relink all it hangs at the same process. I am installing 9.2.0.1.0 on Sun solaris (sparc - 64 bit). As there any patch is to be apply at Solaris level or any specific parameter for Solaris 10. Thanks in advance. SofDev wrote: > Hi Friends, > > I am trying to install Oracle 9.2.0.1. on Solaris 5.10 > Installation fails during linking process at 61% & doesnt move ahead. > When I abort the the installation & try to run relink all it hangs at > the same process. I am installing 9.2.0.1.0 on Sun solaris (sparc - 64 > bit). As there any patch is to be apply at Solaris level or any > specific parameter for Solaris 10. > > Thanks in advance. Somewhere in the instalation notes there should be a reference to a url with any additional updates for your platform. I would look for this url and check it. I would also double check my OS settings, especially configured swap space, verse the recommended settings listed in the installation manual. HTH -- Mark D Powell -- ...

Oracle 9i (9.2.0.1.0) Install link errors
Greetings: I'm trying to install Oracle 9i Enterprise Server and Client on a 64 bit Solaris 8 machine. I encountering link errors as follows: Calling action unixActions2.2.0.6.0 make installMakePath = /usr/ccs/bin/make installMakeFileName = /opt/oracle/product/9.2.0.1.0/network/lib/ins_net_client.mk installTarget = ntcontab.o installArguments = ORACLE_HOME=/opt/oracle/product/9.2.0.1.0, undoMakeFileName = null undoTarget = null undoArguments = null logFile = /opt/oracle/product/9.2.0.1.0/install/make.log Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target ntcontab.o of makefile /opt/oracle/pr oduct/9.2.0.1.0/network/lib/ins_net_client.mk Exception Severity: 1 This was while the OUI was trying to execute the following make command: /usr/ccs/bin/make -f ins_net_client.mk ntcontab.o ORACLE_HOME=/opt/oracle/product/9.2.0.1.0 I can actucally manully execute this on the command line and it seems to work but I'm sure not properly since I'm sure there are some paths that it needs which would have normaly been set in the install script. I believe I have something not set properly prior to starting the Oracle Universal Installer but I'm not sure what (i.e., environment variable, or compiler option). Any advice would be appreciated. Cheers! On Thu, 04 Dec 2003 18:59:29 GMT, "Joseph Dimech" <joe@tsc-corp.com> wrote: &...

Solaris 9 patches for Oracle 9.2.0.5
Hello, I am unable to find the list of required patches on Solaris 9 (64 bit) for Oracle 9.2.0.5 Installation guide on OTN seems to be carrying quite old info. could someone help me with the list or the location where I can find this. Thanks in advance, Gautrak Well Solaris 9 has been out for a long time now so probably the "bare minimum" patches needed for 9i rel 2 or specifically 9.2.0.5 hasn't really changed for a while. Recommended patches from sun are diff from what oracle needs. If it's a dev system then why not go for latest sun patchset then apply 9.2.0.5 which of course relinks. But 9.2.0.5 isn't exactly squeaky clean. johnbhurley@sbcglobal.net (John Hurley) wrote in message news:<d4d6f278.0406291402.65370bbd@posting.google.com>... > Well Solaris 9 has been out for a long time now so probably the "bare > minimum" patches needed for 9i rel 2 or specifically 9.2.0.5 hasn't > really changed for a while. Recommended patches from sun are diff > from what oracle needs. > > If it's a dev system then why not go for latest sun patchset then > apply 9.2.0.5 which of course relinks. But 9.2.0.5 isn't exactly > squeaky clean. Yes, but 9.2.0.6 will fix all of those issues ... that are identified in time, maybe. No wait, :bug_number will be fixed in 10.1.0.3 ... perhaps 10.1.0.4. Pd This will be a production database (non-RAC) upgraded from existing 8.1.7 db of approx 120 GB. which version of 9...

from oracle 9.2.04 to oracle 9.2.05
i'm a newbie, i'd like to guess if anybody knows how can I upgrade my oracle 9.2.04 to 9.2.05. My java_pool_size, shared_pool_size are under 150 MB. How can I set this value? Bye and thx a lot. jakko1982 wrote: > i'm a newbie, i'd like to guess if anybody knows how can I upgrade my > oracle 9.2.04 to 9.2.05. > My java_pool_size, shared_pool_size are under 150 MB. How can I set > this value? > > Bye and thx a lot. 1) Goto http://metalink.oracle.com and download the 9.2.0.5 patchset. You can also goto 9.2.0.6. Patch installation documentation comes with it. Make sure you review the documentation before applying the patchset. 2) Goto http://tahiti.oracle.com and review the "Initialization Parameter" section. If you are using spfile (Server Parameter File) then you can change these parameters online. Search for "spfile" keyword and goto "Administrator's Guide". If you are not using spfile then you need to locate the database init.ora file, modify the parameter values and bounce the database. Regards /Rauf sorry, but I use Spfile. I've searched Spfile keyword and I read the administrator's guide. and now? sorry but Im a newbye jakko1982 wrote: > sorry, but I use Spfile. I've searched Spfile keyword and I read the > administrator's guide. > > and now? sorry but Im a newbye Did you read under heading "Managing Initialization Parameters Using a Server Parameter File"...

int((9.2-9.0)*10) is 1, int((9.21-9.0)*10) is 2, why?
Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)] on win32 The following line of code describes an funny question・３校 >>> int((9.2-9.0)*10) 1 >>> int((9.21-9.0)*10) 2 >>> int((9.1-9.0)*10) 0 >>> int((9.11-9.0)*10) 1 >>> int((8.2-8.0)*10) 1 >>> int((8.23-8.0)*10) 2 why? anybody can explain it? On Sep 5, 11:12 pm, bcm <bluecrysta...@gmail.com> wrote: > Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit > (Intel)] on win32 > The following line of code describes an funny que...

restoring 9.2.0.6 datafiles with 9.2.0.7 Oracle
Hello Is there potential problem ? we want to use old datafiles in 9.2.0.6 with a patched oracle in 9.2.0.7... Thank you nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... > > Thank you No, you don't want to do that. You want to solve some problem, for which you believe that to be the solution. What is the problem you are trying to solve? In answer to your question -- yes, I'd think there would be disasterous problems. So, again -- what is the problem you are trying to solve? nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... That really describes a usual step in applying the 9.2.0.7 patchset. The database files are still at ( whatever ) the old patch level was .... say 9.2.0.6. You have to use the patched oracle binaries to open the database. But then the next step should be to follow the steps in the 9.2.0.7 for patching existing databases ... startup migrate and run the script to move the database files up to 9.2.0.7 ... Is that what you are attempting to do? Have you read the readme ( installation instructions ) for the 9.2.0.7 patchset? ...

Installing patchset 9.2.0.8 on 9.2.0.1 error
The following running services need to be shutdown before continuing: Automatic Updates Background Intelligent Transfer Server COM+ Event System Cryptographic Services DCOM Server Process Launcher DHCP Client DNS Client Distributed Link Tracking Client Error Reporting Service Help and Support Messenger Network Connections Network Location Awareness(NLA) Remote Access Connection Manager Remote Procedure Call (RPC) Remote Registry Secondary Logon Server Shell Hardware Detection System Event Notification System Restore Service TCP/IP NetBIOS Helper Task Scheduler Telephony Terminal Services Themes WebClient Windows Audio Windows Management Instrumentation Windows Time Wireless Zero Configuration Workstation What should I do, while installing patchset 9.2.0.8 on WINDOWS XP, I am getting above error. "peter" <hhh.database@gmail.com> schreef in bericht news:1168424525.937552.232840@k58g2000hse.googlegroups.com... > The following running services need to be shutdown before continuing: > > Automatic Updates > Background Intelligent Transfer Server > COM+ Event System > Cryptographic Services > DCOM Server Process Launcher > DHCP Client > DNS Client > Distributed Link Tracking Client > Error Reporting Service > Help and Support > Messenger > Network Connections > Network Location Awareness(NLA) > Remote Access Connection Manager > Remote Procedure Call (RPC) > Remote Registry > Secondary Logon > Server ...

Where to get oracle patch 9.2.0.4 and 9.2.0.5
I'm doing an install for work on a windows xp (32bit) development station. To mimik the production systems I need to install 9.2.0.1.0 and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 and I have a disk for the patches but it is corrupted. Where can I get these patches? I've tried google to no avail. Thanks in advance! On 29 Jun 2006 15:13:24 -0700, "David.E.M....@gmail.com" <David.E.Murphy@gmail.com> wrote: >I'm doing an install for work on a windows xp (32bit) development >station. To mimik the production systems I need to install 9.2.0.1.0 >and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 >and I have a disk for the patches but it is corrupted. Where can I get >these patches? I've tried google to no avail. Thanks in advance! Patches are available on Metalink. And, yes, you need to have a paid support contract for that. -- Sybrand Bakker, Senior Oracle DBA David.E.M....@gmail.com wrote: > I'm doing an install for work on a windows xp (32bit) development > station. To mimik the production systems I need to install 9.2.0.1.0 > and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 > and I have a disk for the patches but it is corrupted. Where can I get > these patches? I've tried google to no avail. Thanks in advance! You get the patches from oracle http://www.oracle.com then go to the support link then metalink ... I&#...

Oracle server Upgrade from 9.0 to 9.2 on Windows 2003
Hi All, I am trying to upgrade an Oracle server running 9.0 on Win 2003. I do not want to keep 2 Oracle Homes for 9.0 and 9.2. I would rather uninstall 9.0 using oui. I will import the data from production database from export files. What will be my best (easy, hassle free) course of action: 1. Shutdown the current 9.0 instance 2. Drop the current 9.0 db 3. Uninstall the current 9.0 executibls using oui 4. Install the 9.2 executibles 5. Create new db instance 6. Import the data from export files Is this a good idea? Or should I have 2 Oracle Homes by installing 9.2 and upgrade the 9.0 db using dbua? Only problem is I cant find the dbua in the current 9.0 setup. Your advice / experience / feedback will really appreciated. Thanx in advance. Personally, I'd install 9.2 in a second Oracle Home and then upgrade the database. Once it is all done, feel free to remove the 9.0 software in that home. You'll use the DBUA in the 9.2 home, not the 9.0 one! HTH, Brian Wade Chy wrote: > > Hi All, > I am trying to upgrade an Oracle server running 9.0 on Win 2003. I do > not want to keep 2 Oracle Homes for 9.0 and 9.2. I would rather > uninstall 9.0 using oui. I will import the data from production > database from export files. What will be my best (easy, hassle free) > course of action: > > 1. Shutdown the current 9.0 instance > 2. Drop the current 9.0 db > 3. Uninstall the current 9.0 executibls using oui > 4. Install the 9.2 executibles &...

massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
The performance of some complex PL/SQL functions has dropped dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out, that Oracle 9i performance on a multi processor CPU machine (our server has 4 XEON CPUs, Hyperthreading is disabled in BIOS) is highly dependent on init.ora parameters; unfortunately our trial and error approach to find the proper settings (we searched Oracle Tech Net (OTN) and google groups without success) did not help so far. We are testing performance behaviour with some business critical PL/SQL procedures that do authorization calculations for our application. Simplified these functions do a lot of inserts, deletes and selects in/from tables (being used as temp tables in lack of in memory temp table support of oracle 9i). We can monitor the progress within the stored procedure by using UTL_FILE functions to write a log file into the file system of the server; we real time monitor the log file using "tail -f". <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); [...] When setting "CPU_COUNT = 1" in init.ora the function will typically run up to 10 seconds, when setting "CPU_COUNT = 4" it will take more than 2 minutes (!!!) We experimented with the following other parameters so far: db_writer_processes (set to 4 in combination with cpu_count = 4) fast_start_parall...

Oracle9i DB 9.2, Oracle9i DS 9.0.2, Oracle9i AS 1.0.2.2.1(Forms, Reports) on Fedora Core 1
I have installed Oracle9i DB 9.2, Oracle9i DS 9.0.2, Oracle9i AS 1.0.2.2.1(Forms6i, Reports6i) on Fedora Core 1 the 8th November 2003. All is running OK. Denis ALEXANDRE Assistant Manager, Banque Saradar France http://www.alexnet.fr/ P.S. I am using Oracle and Unix to create an Integrated Banking System since 1987. This banking system is installed in more than 25 other banks. alex@alexnet.fr wrote: > I have installed > Oracle9i DB 9.2, Oracle9i DS 9.0.2, Oracle9i AS 1.0.2.2.1(Forms6i, Reports6i) > on Fedora Core 1 > the 8th November 2003. All is running OK. > > Denis ALEXANDRE > Assistant Manager, Banque Saradar France > http://www.alexnet.fr/ > > P.S. I am using Oracle and Unix to create an Integrated Banking System since 1987. > This banking system is installed in more than 25 other banks. > > Great - after this coming out in the open, do you care to explain how you installed Portal Rel 1 in a 9.2 instance? -- Regards, Frank van Bortel Frank wrote: > alex@alexnet.fr wrote: > >> I have installed >> Oracle9i DB 9.2, Oracle9i DS 9.0.2, Oracle9i AS 1.0.2.2.1(Forms6i, >> Reports6i) >> on Fedora Core 1 >> the 8th November 2003. All is running OK. >> >> Denis ALEXANDRE >> Assistant Manager, Banque Saradar France >> http://www.alexnet.fr/ >> >> P.S. I am using Oracle and Unix to create an Integrated Banking System >> since 1987. >...

Linux: Oracle9i DB 9.2, Oracle9i DS 9.0.2, Oracle9i AS 1.0.2.2.1(Forms, Reports) on Fedora Core 1
I have installed with Philippe ALEXANDRE on a laptop Oracle9i DB 9.2, Oracle9i DS 9.0.2, Oracle9i AS 1.0.2.2.1(Forms6i, Reports6i) on Fedora Core 1 the 8th November 2003. All is running OK. Denis ALEXANDRE Assistant Manager, Banque Saradar France http://www.alexnet.fr/ P.S. I am using Oracle and Unix to create an Integrated Banking System since 1987. This banking system is installed in more than 25 other banks. ...