Oracle database installation, upgrades and patches

Email Alerts

Register now to receive news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Errors after installing Oracle 8.1.7 release 3 patch

    I just installed the Oracle 8.1.7 release 3 patch on Windows 2000 and I can no longer get Oracle to run. I am getting "ORA-02034: Oracle Not available," and the OraDim.log has "ORA-01078: Failure in processing sys parameters" and "ORA-12638: Crediten... 

  • Listener could not resolve SID

    I am new in Oracle. When I try to log in to Oracle SQL*Plus I get the error: "listener could not resolve SID given in connect description." If my computer name is "abc" for example, how do I set listener.ora and tnsnames.ora? 

  • Moving from RBO to CBO

    Our current application is using Oracle with RBO. We are in the process of strategizing the move to CBO. Can you advise on some good articles and things to be wary of? 

  • Allotting enough space for installation

    I get a message that says "The Oracle home that you chose does not have enough disk space for the installation." I'm installing Oracle Workgroup Server SCO v7. on an SCO Open Server 5.0 -- I've verified the space allocated to the /u and most ... 

  • Recovery without media or download of CD

    We are running Oracle 8.1.7 on Windows 2000 Server in our production environment and we do not have the media or a download of the CD. We are planning to upgrade to the current version. I'm concerned with recovery of Oracle and how to reinstall in t... 

  • Using Oracle 9i with 8i optimizer

    We are using Oracle 9i with 8i optimizer. We want to upgrade it to Oracle 9i optimizer. Once we tried this and it was a disaster. Do we need to change any parameters in the database for a smooth run? 

  • Oracle 8.0 and 9i on same machine

    Can we install Oracle 8.0 and Oracle 9i on one standalone machine with Windows XP, both working with the same login with admin privileges? 

  • Can't install Developer 2000 on same machine as 9i

    I have Windows XP and Oracle 9i installed on it. However, whenever I try to install Developer 2000 on it it says that that an Oracle home directory by the name of Ora 9.0 already exists on it. 

  • Tools to migrate stored procedures and queries

    What are the tools available to migrate stored procedures and queries from Oracle 8i to Oracle 10g? 

  • Upgrading database from to 10g

    How do I upgrade database version to 10g?