Problem solve

Get help with specific problems with your technologies, process and projects.

Oracle database installation upgrades and patches

  • Using DBUA for RAC databases

    I need to upgrade a RAC 9.0.X database to RAC 9.2.X. The upgrade guide doesn't seem to have the info I need for using the Database Upgrade Assistant for RAC databases. When I start DBUA and select the db to be upgraded, I get an "ORA-01034: Oracle ... Continue Reading

  • DIM-00019 error

    I have installed Oracle9i on Windows 2000. When I start the Oracle Database Assistant I am getting the "DIM-00019: message 19 not found" error. Continue Reading

  • Database creation stops at 81%

    I'm trying to install Oracle9i on a Windows XP platform and when I try to create a database, it stops at 81% and gives me an empty message. What is the problem? Continue Reading

  • Upgrading to 10g with minimal downtime

    We are looking to upgrade our database from Oracle on HPUX to Oracle 10gR2 on Linux. Could you make any suggestions as to the best way of doing this with the minimal amount of downtime? Continue Reading

  • Using Data Pump to move a database from HP-UX to Linux

    Because of the high cost of HP-UX machines, we plan to upgrade and move our current 9i database to 10g on a Linux platform. The current production database is about 200GB, and using imp/exp may take a long time in Oracle9i. Therefore, we are ... Continue Reading

  • Upgrading to 10g on Unix Server

    We are going to upgrade from Oracle9i to Oracle 10g on Unix Server. Are there any precautions we should take before migration, and what methods should we follow?Continue Reading

  • Migrating with MatrixOne software

    I want to migrate Oracle8i to Oracle9i using MatrixOne software. Can you please tell me how I can do that?Continue Reading

  • Error in writing to file

    While installing Oracle9i Standard Edition I received the following error: "Error in writing to file d:oracleora90assistantstemplatesTransaction_Processing.dfj." After ignoring this I installed the software but I can't connect to the database with ...Continue Reading

  • Dedicated or shared server mode?

    Where can I find the best resources on Oracle9i installation? While creating a new database after a new installation, which mode do I select, "dedicated server" or "shared server"? The number of clients will be 10 maximum for my application. Is ...Continue Reading

  • Opening database at startup

    I want to open the Oracle database instance at startup -- I have Oracle8i on a Windows 2000 server. The Oracle database service is already at the startup and it is starting automatically, but the database I have to open manually from the db-studio ...Continue Reading

  • End of file on communication channel

    I had to uninstall Oracle9i and reinstall it again, and during that process I encountered a TNS error, but I continued with the installation. After that I logged into PL/SQL to execute some scripts. After the execution it gave an 'end of file on ...Continue Reading

  • Migrating to Oracle 9.2 on AIX

    I have to do a migration from Oracle 7.3.4 to Oracle 9.2 and Oracle 8.1.6 to Oracle 9.2 on an AIX4.3 server to AIX5.3 on a different machine. Please give me a detailed step-by-step procedure to achieve both the processes.Continue Reading

  • Migrate to base release first?

    I would like to know how to migrate from Oracle8i ( to Oracle9i ( Do I have to first do a migration to the Oracle9i base release ( and from here apply a patch (for Or is there a better way to do this task?Continue Reading

  • Giving Oracle more RAM for streams

    We are running Oracle9i. I want to give Oracle more than 4G of RAM for SGA but I cannot. I have read old files in Metalink that suggest hidden parameters and registry hacks but they are all for Oracle 7 and 8. Any ideas? I need the RAM for streams.Continue Reading

  • Error in writing to directory

    I am getting an error message while I am trying to install Oracle9i on my Windows XP machine. It gives me the error message "Oracle Universal Installer: Error in writing to directory. Please ensure that this directory is writable and has at least ...Continue Reading