4 Installing and Configuring Oracle Database for Advanced Management Console

The database for Advanced Management Console provides data storage to host all the data. The database stores information about MSI files, applications, deployment rules, and deployment rule sets. The database also stores information about agents, Java Runtime Environment (JRE) statistics, and Java Installer configurations.

The Installing and Configuring Oracle Database for Advanced Management Console topic contains the following sections that describe software requirements and Oracle Database installation and configuration:

Software Requirements for Oracle Database

To use Oracle Database with Advanced Management Console, download and install a supported version of the Oracle database from Oracle Database Software Downloads.

Installing Oracle Database on Windows

Note:

To install Oracle 11g database, see Oracle 11g Documentation.

This topic describes installation steps for Oracle Database 12c. To install Oracle database for Windows operating system:

  1. Go to Oracle Database Software Downloads in your browser.
  2. Download the 64-bit .zip file. Select the.zip file and right click to select Extract All. Extract both the .zip files to the same folder.
    Don’t extract the archive using unzip command, which may result in an unsuccessful run of the setup.exe.
  3. Run the setup.exe and select the installation options according to your database and Windows user requirements.
  4. In the Specify Database Identifiers screen of the installation process, enter the Global database name (for example, amc2) and the Oracle system identifier, SID (for example, amc2). Don’t select the check box for the option Create as Container database. The Install button gets enabled.
  5. Click Install to install the product.
    Oracle Database is installed on Windows.
  6. Start the SQL Plus application. From the command-line, enter the command SQLPLUS to start SQL Plus.
From Windows Start, click Programs, Oracle-OraHomeName, Application Development, and SQL Plus.

Configuring Oracle Database for Advanced Management Console on Windows

You need to install and configure Oracle database for Advanced Management Console.

  1. Log in to SQL*Plus application with sys as sysdba and the password you opt during the installation process in the Schema Password step.
  2. Create the user (for example, amc2) and grant access to the database (for example, amc2). The database name is the one you chose in step 3 of Installing Oracle Database on Windows.
    SQL> CREATE USER amc2 IDENTIFIED BY amc2 
    DEFAULT TABLESPACE users
    QUOTA UNLIMITED ON users PASSWORD EXPIRE;
    SQL> CREATE ROLE amc2_role;
    SQL> GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, CREATE TRIGGER to amc2_role; 
    SQL> GRANT amc2_role TO amc2;
    

    Configure your Oracle database QUOTA to UNLIMITED to ensure that enough database storage is available to support large BLOB entries, such as MSI binaries. If you encounter an issue with the SQL Create User statement, then log out of SQL*Plus application and repeat step 1 and step 2.

  3. After you successfully create the user, exit the SQL*Plus application and log back into SQL*Plus as user (for example, amc2). You are prompted to set up the password. Set up a strong password.

The Oracle Database user credentials provided in this topic are examples. The Advanced Management Console doesn’t need to know your database user credentials. Oracle database user credentials are only required to configure the DataSource connection in the application server.

Configuring Oracle Database on Linux

Before you begin to install and configure the Oracle database, make sure you can get root authority as the configuration requires root authority. But, you should not start installer with root user.

To install and configure Oracle database:
  1. Connect to server using SSH or VNC as appropriate.
  2. Unzip your database installer. 
  3. In your shell, run the ulimit -s 10240 command . This is the setting for maximum stack size limitation which is required for the database installation. In addition, edit /etc/security/limits.conf file to set nofile, nproc, stack, and memlock values for database user deployment:
    deployment   soft   nofile    1024
     
    deployment   hard   nofile    65536
     
    deployment   soft   nproc    16384
     
    deployment   hard   nproc    16384
     
    deployment   soft   stack    10240
     
    deployment   hard   stack    32768
     
    deployment   hard   memlock    134217728
     
    deployment   soft   memlock    134217728
    
  4. Validate /etc/pam.d/login that contains the following line : session    include      system-auth. If /etc/pam.d/login doesn’t contain the above line, then add the following line :# echo ‘session include system-auth’ >> /etc/pam.d/login.
  5. Validate /etc/pam.d/system-auth that contains the following line: session     required      pam_limits.so. If /etc/pam.d/system-auth doesn’t contain the above line, then add the following line: # echo ‘session     required      pam_limits.so’ >> /etc/pam.d/system-auth.
  6. Validate the shell limits by logging in as the database software owner:
    -bash-4.2$ ulimit -Sn
    1024
     
    -bash-4.2$ ulimit -Hn
    65536
     
    -bash-4.2$ ulimit -Su
    16384
     
    -bash-4.2$ ulimit -Hu
    16384
     
    -bash-4.2$ ulimit -Ss
    10240
     
    -bash-4.2$ ulimit -Hs
    32768
     
    -bash-4.2$
    
  7. Change to directory where your database installer is unzipped. Start the Install wizard by running the ./runInstaller command. Provide the required information and click Next. Use the default selection in this wizard and then click Next.
  8. In the Select System Class page, select Desktop class and click Next.
  9. In the Typical Installation page, specify install location information and then click Next.
  10. In the Create Inventory page, set product inventory location and click Next.
  11. In the Install wizard, click OK. A summary of the prerequisite check is displayed. Click Install.  The database installation starts, ensure to run the scripts during the installation.
  12. Follow the instructions in the wizard and run the scripts. The ENV scripts are copied to /usr/local/bin. You can change the path if you want to.
  13. Click OK in the Installation wizard to continue with the installation.
  14. When the installation is completed, click Close to close the wizard. Run the cat/etc/oratab command to check the installation information.
  15. Run the scripts under scratch/deployment/app/oralInventory.
  16. Switch to database file location and create amc2 directory for PDB.
  17. Use sqlplus connect to the database as sysdba. Use the following command to create PDB: CREATE PLUGGABLE DATABASE amc2 ADMIN USER amc2 identified by "amc2" DEFAULT TABLESPACE USERS DATAFILE '/scratch/deployment/app/deployment/oradata/orcl/amc2/users01.dbf' SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/scratch/deployment/app/deployment/oradata/orcl/pdbseed/', '/scratch/deployment/app/deployment/oradata/orcl/amc2/');
  18. Change the database session to AMC2 and make sure that AMC2is open. Then configure and set authority for user AMC2. Save state of AMC2. The following is the command to grant authority to amc2:  grant CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW; The following is the command to set quota: alter user amc2 quota unlimited on users;
  19. Exit sqlplus. Stop listener first. Use command $ORACLE_HOME/bin/lsnrctl stop.
  20. Make sure listener port is set to 1521. You can edit configuration file $ORACLE_HOME/network/admin/listener.ora as follows:
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = your_host_name)(PORT = 1521))
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
      ) 
    
  21. Make sure to edit the TNS configuration file $ORACLE_HOME/network/admin/tnsnames.ora:
    LISTENER_AMC2 =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
      )
    AMC2 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = your_host_name)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = amc2)
        )
      ) 
    
  22. After setting the 2 configuration files correctly, start listener again with the following command: $ORACLE_HOME/bin/lsnrctl start.
  23. Make sure that the database listener is running using command $ORACLE_HOME/bin/lsnrctl services.
If you are a database administrator, then you need to use ORAchk to check for Oracle database:
  1. Download ORAchk from MOS.

    Note:

    MOS is available at https://support.oracle.com.
  2. Copy orachk.zip on SRVDB and extract.

  3. Run ./orachk as root user to check Oracle database and generate HTML report to create a zip file of report containing HTML file. This report includes issues found and links to MOS notes or documentation to fix the issues.