Oracle database installation, upgrades and patches

Email Alerts

Register now to receive SearchOracle.com-related 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 9.2.0.6 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? 

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

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

  • Upgrading database from 9.2.0.7 to 10g

    How do I upgrade database version 9.2.0.7 to 10g? 

  • Installing new servers directly to patched version

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

  • Cross-platform migration of 1 TB database

    We are migrating an Oracle9i database from IBM AIX5.1/5.2 to IBM AIX 5.3. The size of our database is 1 TB. What are the basic steps that we need to follow for migration as this is a cross-platform migration? 

  • Same user for 8i and 9i Oracle homes on same server

    I want to install Oracle 8i and 9i on the same server. I want to know if we have to create two different Oracle users for two versions of Oracle in the OS. If we have the same user for both the Oracle homes, then how can we manage the environment set... 

  • Installing Oracle9i Server on Windows XP Media Center

    I have a P4 3.2 GHZ running on Windows XP Media Center Edition. I want to know if I can install Oracle 9i Server and EM. 

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

  • Can't connect via client

    I have installed Oracle9i in my Windows XP system (laptop). In the same machine I have installed Oracle client(9i). But I am not able to connect to the server through the Oracle client. Do I need to do anything extra?