Preparing an Oracle database

Before installing TADDM with a remote Oracle database, you must first prepare the database by creating the Oracle user IDs required by the TADDM server.

You must first install the Oracle software on the database server.
  • When creating the Oracle database, select the Unicode character set (AL32UTF8) in the Database Character Set field. Otherwise, data that is in languages other than English might not display correctly. If you see the Oracle message OALL8 is in inconsistent state, TADDM cannot access some of the national language-specific text in your database. Re-create your database with the correct character set.
  • For Oracle RAC, complete the following steps for one of its nodes. Select the locally running SID as script parameter.

To prepare an Oracle database, complete the following steps:

  1. From the product DVD, copy the following file to the system where the Oracle database is installed:
    • Linux® and UNIX systems: support/bin/make_ora_user.sh
    • Windows systems: support\bin\make_ora_user.bat
  2. Complete one of the following procedures to run the make_ora_user script on the system where the Oracle database is installed:
    • Linux and UNIX systems:
      1. Log in as the Oracle user or the user that was used to install the Oracle database (typically oracle).
        Note:

        When performing new 7.3 TADDM installation with Oracle 18C or 19C, the TADDM installers allow only ojdbc6.jar during installation. To proceed, add following in the sqlnet.ora file located at ${ORACLE_HOME}/network/admin and then proceed with the creation of users as steps given below.

        SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

      2. Run the following command: 
        make_ora_user.sh sid cmdb_usr cmdb_pwd archive_usr archive_pwd
        sid
        Oracle System Identification Database
        cmdb_usr
        Primary Oracle user ID
        cmdb_pwd
        Primary Oracle user password
        archive_usr
        Secondary (archive) user ID
        archive_pwd
        Secondary (archive) user password
    • Windows systems:
      1. At a command prompt, run the following command: 
        make_ora_user.bat sid cmdb_usr cmdb_pwd archive_usr archive_pwd
        sid
        Oracle System Identification Database
        cmdb_usr
        Primary Oracle user ID
        cmdb_pwd
        Primary Oracle user password
        archive_usr
        Secondary (archive) user ID
        archive_pwd
        Secondary (archive) user password