• June 06, 2006 06 Jun'06

    Copying table from production to test server

    I took the full database export backup in an 11i apps database and tried to import a table from a production server to the same setup in the test server. I would like to know the reason why the row count doubled in the test environment after ...  Continue Reading

  • June 05, 2006 05 Jun'06

    Migrate to 9.2.0.7 first or directly to 10g?

    We are currently running Oracle 9i (9.2.0.1). We are considering going to 10g. Can we migrate directly to 10g or do we have to go to 9.2.0.4 or 9.2.0.7 before we go to 10g? Also, our current applications don't really need any of the new ...  Continue Reading

  • June 05, 2006 05 Jun'06

    Have to reinstall Oracle8i on Windows XP each time I restart

    Whenever I install Oracle8i on my computer when in the Windows XP OS, it works well, but only for that time until I shut down my computer, after which it disconnects and I have to re-install it again, every time I start the computer. How should I ...  Continue Reading

  • June 05, 2006 05 Jun'06

    Upgrading from 9.2.0.1 to 9.2.0.5

    I have Oracle 9.2.0.1 on my Windows 2004 Server. I want to upgrade it to 9.2.0.5 . Please tell me all the related patch numbers and method to do this.  Continue Reading

  • June 05, 2006 05 Jun'06

    Upgrading client machines

    Before upgrading our database to Oracle 10g, we are slowly upgrading the 200 client workstations to 10g using the Oracle9i database. Are there scripts to monitor the sessions from the 10g client machines to see if everything is OK?  Continue Reading

  • June 05, 2006 05 Jun'06

    Unsure how to apply patch

    I have downloaded patch #2973634 for Windows 2000 Advanced Server for Oracle 9.2.0.3, and I have installed Oracle 9.2.0.1 on my machine. Now my problem is how to apply this patch? I have upgraded my OUI as per readme.txt but now I am not able to ...  Continue Reading

  • June 05, 2006 05 Jun'06

    Upgrading from 8i to 10g with import utility

    I would like to upgrade from 8.1.7 to 10g. How to use the import utility to import the 8i dump to the 10g database?  Continue Reading

  • June 05, 2006 05 Jun'06

    Upgrading production databases

    I want to upgrade Oracle 9.2.0.4 to 9.2.0.7 on HP-Unix 9000 64-bit. I have five production databases in Oracle 9.2.0.4. Please let me know the procedure/process.  Continue Reading

  • June 05, 2006 05 Jun'06

    What do we do after installing patch 9.2.0.6.0?

    After installation of patch 9.2.0.6.0 which SQL command do we need to run?  Continue Reading

  • June 05, 2006 05 Jun'06

    Using export/import to upgrade to 9i Rel 2

    Currently I'm using Oracle DB 8.1.6. I want to upgrade this to 9i Rel 2. Can I use export/import for this?  Continue Reading

  • June 05, 2006 05 Jun'06

    Is 9.2.0.7 just a patched version of 9.2.0.6?

    We are upgrading our Oracle DB from 8i to 9i. Our testing was done with 9.2.0.6, but now a different group in our company has found a problem and is going to 9.2.0.7. My questions: Is 9.2.0.7 just a patched version of 9.2.0.6? When was 9.2.0.7 ...  Continue Reading

  • June 05, 2006 05 Jun'06

    Info on starttype option

    I am running 9.2.0.7.0 and am wondering how to tell if the stsrttype=srvc,inst. The registry key ORA_<instance>_AUTOSTART=TRUE for each instance on the box and the ORA_<instance>_pfile points to the appropriate pfile for each DB. Is ...  Continue Reading

  • June 05, 2006 05 Jun'06

    9i install hangs at 23%

    My Oracle 9i rel 2 (9.2.0.1.0) on Windows XP Pro hangs at 23% trying to install OLTP starter database. Can someone help with this issue?  Continue Reading

  • June 05, 2006 05 Jun'06

    Configuring RAC on Windows laptop

    I would like to configure Oracle 9i RAC on my Windows XP laptop. I already have three 9i personal instances running on there. I do not have any external hard drive. Let me know how to go about this.  Continue Reading

  • June 05, 2006 05 Jun'06

    Import failing

    I have tried importing five times using Telnet, and I have received the below message every time, even though I have exported succesfully again using the same Telnet login to the database server. Then importing resulted in the same message. The DB ...  Continue Reading

  • June 05, 2006 05 Jun'06

    Packet writer failure

    I am getting this error: "ORA-12571: TNS:Packet writer failure." The problem does not happen all the time. The sqlnet.ora file only says "sqlnet.expire_time = 5."  Continue Reading

  • June 05, 2006 05 Jun'06

    Files are in use by another application

    I have the same problem as already reported earlier on your Web site: "I am trying to install Oracle patch 9.2.0.6.0 to Oracle 9.2.0.4.0. I keep getting error messages that say some files that need to be changed are in use by another application. I ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close