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:
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.
- Go to Oracle Database Software Downloads in your browser.
- Download the 64-bit
.zipfile. Select the
.zipfile and right click to select Extract All. Extract both the
.zipfiles to the same folder.Don’t extract the archive using
unzipcommand, which may result in an unsuccessful run of the
- Run the
setup.exeand select the installation options according to your database and Windows user requirements.
- 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.
- Click Install to install the product.Oracle Database is installed on Windows.
- Start the SQL Plus application. From the command-line, enter the command SQLPLUS to start SQL Plus.
Configuring Oracle Database on Windows
After installing Oracle database for Advanced Management Console on Windows, you need to configure it.
- Log in to SQL*Plus application with
sys as sysdbaand the password you opt during the installation process in the Schema Password step.
- Create the user (for example,
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
UNLIMITEDto 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.
- 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 Data Source connection in the application server.
Installing and Configuring the Oracle Database on Linux
- Connect to the server by using SSH or VNC, as appropriate.
- Unzip your database installer.
- In your shell, run the
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
- Validate that
/etc/pam.d/logincontains the following line:
session include system-authIf
/etc/pam.d/logindoesn’t it, then add the following line:
# echo ‘session include system-auth’ >> /etc/pam.d/login
- Validate that
/etc/pam.d/system-authcontains the following line:
session required pam_limits.soIf
/etc/pam.d/system-authdoesn’t it, then add the following line:
# echo ‘session required pam_limits.so’ >> /etc/pam.d/system-auth
- Log in as the database software owner and validate the following shell limits:
-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$
- Change to the directory where your database installer is unzipped and start the Install wizard by running the
./runInstallercommand. Provide the required information and then click Next. Use the default selection in this wizard and then click Next.
- On the Select System Class page, select Desktop class and click Next.
- On the Typical Installation page, perform the following:
- Specify the install location information.
- Verify that the Global database name is orcl and then click Next.
- On the Create Inventory page, set the product inventory location and click Next.
- In the Install wizard, click OK. A summary of the prerequisite checks is displayed. Click Install to start the database installation. Ensure that you run the scripts during the installation.
- Follow the instructions in the wizard and run the scripts.The
ENVscripts are copied to
/usr/local/bin. You can change the path if you want to.
- Click OK in the Installation wizard to continue with the installation.
- When installation is completed, click Close to close the wizard, and then run the
cat/etc/oratabcommand to check the installation information.
- Run the scripts under
scratch/deployment/app/oraInventory. If you did not use the default Oracle base location during installation, then change it accordingly.
- Switch to the database file location and create an
amc2directory for PDB.
- Using sqlplus, connect to the database as
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/');
- Change the database session to
AMC2and make sure that
alter session set container=amc2;
alter pluggable database amc2 open;
- Configure and set the authority for user
AMC2.The following is the command to grant authority to
grant CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW to amc2;The following is the command to set the quota:
alter user amc2 quota unlimited on users;
- Save the state of
- Configure and set the authority for user
- Stop the listener and exit sqlplus.To stop the listener, use the following command:
- Make sure the listener port in the configuration file is set to 1521.You can edit the configuration file
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = your_host_name)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
- Edit the TNS configuration file,
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) ) )
- After setting the two configuration files correctly, start the listener again by entering the following command:
- Make sure that the database listener is running by using the following command:
Download ORAchk from MOS.
Note:MOS is available at https://support.oracle.com.
SRVDBand extract it.
./orachkas 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.