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
  • 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? 

  • Upgrading SAP and Oracle DB

    We planning to upgrade SAP 4.6 B to 4.7 C; for that we have to upgrade our DB first. Our DB is Oracle 8.0.6. We have to upgrade to 9.1. Please provide us with the steps and guide us with some relevant documents. 

  • 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? 

  • 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? 

  • Installed Oracle with wrong default language

    I have installed Oracle 9i Server on client but by default it got installed in Dutch. I want to change it to English. I have tried doing alter system set NLS_LANG option but it did not change the setting. Please advise. 

  • 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. 

  • Upgrading database from to 10g

    How do I upgrade database version to 10g? 

  • Installing new servers directly to patched version

    Is there any way to "slipstream" an Oracle base edition and a patchset (e.g., and so we can just install new servers directly to the patched version? 

  • Tools to migrate stored procedures and queries

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

  • IP address of host cannot be determined

    Every time I try to install Oracle 10g on Windows Server 2003, I get an error. It says it's thrown when the IP address of a host cannot be determined.