Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Changing Oracle parameters (such as db_domain) in duplicating server

    Changing Oracle parameters (such as db_domain) in duplicating server

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    Is it possible to just adjust Oracle parameters (such as db_domain) in duplicating server -- or does Oracle need to be completely reinstalled?

    Answer

    It is not necessary to re-install Oracle in order to make the server address correct within Oracle.
    Though the server address is just "cosmetic", it *can* be confusing to see an incorrect value in a log or elsewhere.

    The following website describes how the ALTER SYSTEM command

    ALTER SYSTEM db_domain=new_value SCOPE=SPFILE

    can be used to change the db_domain:

    http://www.lazydba.com/oracle/0__143118.html

    Another place where the server address appears is the $ORACLE_HOME/network/admin/tnsnames.ora and .listener.ora...

    Additional Information

    * Test Aleph v20 running Red Hat Linux 5.4 installed under VMware.
    * Plan to have identical hardware for the production server.
    * If one of the servers fails, it should be relatively easy to have another server up and running with the same configuration as the failed server.
    In order to test this idea, we were going to duplicate the test server to become the production server.

    I know I have to request the Aleph license for the production server since it is based on IP address. I also know that I have to adjust all the Aleph configuration files to use the new server name. But what about Oracle?

    As we move to higher versions, Oracle is storing more of its configuration in the database itself. For instance, in the alert log:
    db_domain = "libcat-dev.library.abc.edu"

    Category: Installation & Upgrades (500)

    Subject: New Installation (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Changing OPAC start page
      • Changing Oracle user passwords
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Installation & Upgrades (500)
      4. New Installation (500)
      5. Prod:Aleph
      6. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved