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:
To use Oracle Database with Advanced Management Console, download and install a supported version of the Oracle database from Oracle Database Software Downloads.
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:
.zipfile. Select the
.zipfile and right click to select Extract All. Extract both the
.zipfiles to the same folder.
unzipcommand, which may result in an unsuccessful run of the
setup.exeand select the installation options according to your database and Windows user requirements.
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.
You need to install and configure Oracle database for Advanced Management Console.
sys as sysdbaand the password you opt during the installation process in the Schema Password step.
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
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.
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.
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.
ulimit -s 10240command . This is the setting for maximum stack size limitation which is required for the database installation. In addition, edit
/etc/security/limits.conffile to set
memlockvalues 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
/etc/pam.d/loginthat contains the following line :
session include system-auth. If
/etc/pam.d/logindoesn’t contain the above line, then add the following line :
# echo ‘session include system-auth’ >> /etc/pam.d/login.
/etc/pam.d/system-auththat contains the following line:
session required pam_limits.so.
If /etc/pam.d/system-authdoesn’t contain the above line, then add the following line:
# echo ‘session required pam_limits.so’ >> /etc/pam.d/system-auth.
-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$
./runInstallercommand. Provide the required information and click Next. Use the default selection in this wizard and then click Next.
ENVscripts are copied to
/usr/local/bin. You can change the path if you want to.
cat/etc/oratabcommand to check the installation information.
amc2directory for PDB.
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/');
AMC2and 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;
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = your_host_name)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
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) ) )
Note:MOS is available at https://support.oracle.com.
SRVDB and extract.
./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.