The Daily Insight

Connected.Informed.Engaged.

general

How to change hostname in oracle database 11g

Writer Caleb Butler

Prerequisite Steps:

  1. Check that all servers of the OpenPages deployment are able to connect to the hostname that has been changed. Remove all OpenPages server applications, including that of the deployment administrator (if necessary).
  2. Each reporting server within your deployment shut down your IBM Cognos service. If your installation includes a Global Search server, disable its services. If your deployment contains a workflow server, shut down your IBM Business Process Manager services which include the deploy manager.

Adjust the Setup User’s address:

Silky Terrier Dog Breed Playing Aro... Silky Terrier Dog Breed Playing Around

To run a server on:

  1. Open the file /src/deployment/ /deploy.properties in an editor for text, which is where you will find the installer files as well as is the name that you will use for your configuration is the name of your deployment OpenPages Installer.
  2. Update the host property of the section [db] with the hostname that is the current hostname for the database server. After that, transfer the data into the data server. Update the Hostname on the Database Server

Follow the steps below to your databases server:

Note: If you own the Oracle database server as well as an Oracle client on the same machine the steps above should be followed for the database server.

  1. Shut down and shut down the Oracle listener service as well as the Oracle database.
  2. Open the file /network/admin/tnsnames.ora in a text editor. Edit the hostname in the file to the hostname of the new hostname and back up the file.
  3. Open the file /network/admin/listener.ora in a text editor. Change the hostname of the file to match the new hostname and copy the files.
  4. Then restart the Oracle database as well as the Oracle listener service.

Change the hostname of the Deployment Management Server

If the OpenPages version is older than 8.2 hosting your OpenPages management of deployment:

  1. Open the file /temp/preinstall/install.properties in a text editor,In a text editor, open a file /temp/preinstall/install.properties and write the address of your OpenPages setup.. Change the following properties with the hostname of your database server that is new and save the data file.
    • OP_JDBC_DB_URL
    • DATABASE_SERVER_NAME
  2. Open the file /aurora/conf/aurora.properties in a text editor. Change the property database.URL with the latest hostname of the database server, then copy the data to.
  3. Open the file /network/admin/tnsnames.ora in a text editor. Edit the hostname in the file to reflect the new hostname for the database server then save the document. (Note that if the computer is equipped with both the Oracle database server as well as an Oracle client this step must be carried out on behalf of the client as well.)
  4. Begin by launching the deployment manager and using the command /bin/startManager.sh|.bat
  5. Visit the WebSphere-based Integrated Solutions Console to access OpenPages Deployment Manager server: Age server and This is the WebSphere port assigned in this WebSphere installation. The default port number is 9060.
  6. Log in to the IBM WebSphere integrated solutions console using the administrator’s account.
  7. Go through Resources JDBC > > Data Sources > CWTxDataSourceXA
  8. Make changes to the URL property with the latest hostname for the database server.
  9. Click Apply, and then save.