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. This chapter contains the following sections that describe software requirements for the Oracle Database as well as installation and configuration procedures:
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.
.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.
After installing Oracle database for Advanced Management Console on Windows, you need to configure it.
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 that you set inInstalling 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 Data Source connection in the application server.
ulimit -s 10240command . This is the setting for maximum stack size limitation, which is required for the database installation. In addition, edit the
/etc/security/limits.conffile to set the following
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/logincontains the following line:
session include system-auth.
/etc/pam.d/logindoesn’t it, then add the following line:
# echo ‘session include system-auth’ >> /etc/pam.d/login
/etc/pam.d/system-authcontains the following line:
session required pam_limits.so
/etc/pam.d/system-authdoesn’t it, 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 then click Next. Use the default selection in this wizard and then click Next.
orcland 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.
scratch/deployment/app/oraInventory. If you did not use the default Oracle base location during installation, then change it accordingly.
amc2directory for PDB.
sysdbaand enter 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
alter session set container=amc2;
alter pluggable database amc2 open;
grant CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW to amc2;
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 it.
./orachk as a root user to check the Oracle database and generate HTML report. This creates a zip file of the report that contains an HTML file. The report includes any issues that were found along with links to MOS notes or documentation to fix the issues.