Skip to main content
pdf?stylesheet=default
Blackboard Help

Change Database Ports in an Oracle Environment

You might need to change the default port number on a Blackboard Learn Instance installed on Oracle. This might be because a port number conflicts with another TCP/IP default port that is being used by another process, or you need to use a non-default port for some other reason.

How to Change Database Ports on a Learn Instance Installed on Oracle

  1. Stop all services related to Blackboard Learn. To learn more, see Starting and Stopping Services in an Oracle Environment
  2. Stop the Oracle listener using the following command:

    [oracle@r5x64o11-px019 ~]$ lsnrctl stop

  3. Change the port number in the Oracle listener.ora file. For example, from the default port 1522 to 1521.
  4. Change the port number in the tnsnames.ora file as in the following example,where host_name is your host name and server_name is your server name.

    [root@r5x64o11-px019 ~]# cd /usr/local/oracle/server_name/network/admin
    [root@r5x64o11-px019 admin]# more listener.ora
    # listener.ora Network Configuration File: /usr/local/oracle/server_name/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1522))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    )
     
    [root@r5x64o11-px019 admin]# more tnsnames.ora
    # tnsnames.ora Network Configuration File: /usr/local/oracle/server_name/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.
     
    ENG11R1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1522))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ENG11R1)
    )
    )

  5. Restart the Oracle listener using the following command:

    [oracle@r5x64o11-px019 ~]$ lsnrctl start

  6. Change the port to which the database is listening:

    sqlplus / as sysdba
    > alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))";
    > alter system register;

  7. In the bb-config.properties file, change the bbconfig.database.server.portnumber value from 1521 to 1522. For steps to edit the bb-config.properties file, see bb-config.properties File.
  8. Run PushConfigUpdate in blackboard/tool/admin/. To learn more, see PushConfigUpdates.