Oracle Info Hub: December 2018

Friday 14 December 2018

How to create a user in E-Business Suite R12

This document describes how to create EBS user(FND User) in oracle applications 11i/R12.1.x/R12.2.x

1. Assumptions

2. Create user

3. Validate user

1. Assumptions:

We assume that we have installed oracle applications E-Business Suite and ready to create user.

2. Create user:

Step 1:

Step 2:

Go to below navigation and click on "Define" to go "Create user" form.

System Adminstator----> Security----> User -----> Define

Step 3:

Provide below values and save the form.

User Name: Name of the user

Password: Password of the user (Need to give two times)

Description: Description of the user

Email ID: Provide email ID if available

Note: Need to assign respective responsibilities to the user according to the requirement.

3. Validation

Thanks for your patience to view this post................

APEX login page is not coming after APEX fresh installation in EBS database

This document describes how to resolve login page issue after APEX fresh installation in EBS database.

Issue:

APEX login page is not coming after fresh installation/upgrade of APEX 5.0.3 in R12 EBS database using embedded PL/SQL Gateway.

Solution:

Verify shared_servers parameter and make sure that it should not set to "0"

Change the parameter value to non-zero value and retest the issue.

SQL> alter system set shared_servers=1;

System altered.

SQL>

Thanks for your patience to view this post.................

Thursday 13 December 2018

Installation of Oracle APEX(Application Express ) in OEL 6

This document describes how to install Oracle Application Express(APEX) in OEL 6.

What is APEX?

Oracle Application Express (Oracle APEX), is the low code web application development tool for the Oracle database. Application Express enables you to design, develop and deploy beautiful, responsive, database-driven applications, either on-premises or in the cloud.

Using only a web browser and limited programming experience, you can rapidly develop and deploy professional applications that are both fast and secure for any device from desktop to mobile. Oracle Application Express combines the qualities of a low code tool such as productivity, ease of use, and flexibility, with the qualities of an enterprise development tool such as security, integrity, scalability, availability and built for the web.

We can install APEX in two different ways.
1. Full development environment
2. Run time environment

Full development environment: A full development environment provides complete access to the Application Builder environment to develop applications.

Run time environment: A run time environment is an appropriate choice for production implementations in which you want to run applications that cannot be modified.

Reference: https://www.oracle.com/technetwork/testcontent/what-is-apex-099128.html

Installation of Oracle APEX:

1. Assumptions
2. Download Software
3. Prerequisites
4. Installation

1. Assumptions:

We assume that already installed Oracle Database 12.1.0.2 in Oracle Enterprise Linux 6.
Please click here to know how to install 12c database if did not install it before.

2. Download Software:

Click here to download Apex 5.0.3 software.

3. Prerequisites:

1. Free space for Oracle Application Express software files on the file system: 625 MB
2. Free space in SYSTEM tablespace: 100 MB

Oracle XML DB must be installed in the Oracle database which we are using to install APEX. If your database is installed with DBCA the XMLDB installed along with database installation.

If you have done the database installation manually we need to create XML DB manually. To create the XML DB we have to run the below script.

$cd $ORACLE_HOME/rdbms/admin

SQL>@catqm.sql

4. Installation:

Step 1:

Create one tablespace which we can make it as default tablespace while installing APEX.

SQL> create tablespace APEX_DATA datafile '/u02/oradata/SILVER/apex_data01.dbf' size 10m autoextend on maxsize unlimited;

Tablespace created.

SQL>

Step 2:

Change to the directory where downloaded the software and run below script to install APEX.

[oracle@server2 ~]$ cd /u02/softwares/apex

[oracle@server2 apex]$ pwd
/u02/softwares/apex

Connect as sysdba to install APEX.

[oracle@server2 apex]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 13 18:47:00 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

SQL> @apexins.sql <tablespace_Apex> <tablespace_files> <tablespace_temp> /i/

SQL> @apexins.sql APEX_DATA APEX_DATA TEMP /i/

Thank you for installing Oracle Application Express 5.0.3.00.03

Oracle Application Express is installed in the APEX_050000 schema.

The structure of the link to the Application Express administration services is as follows:

http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)

http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

http://host:port/apex/apex_admin (Oracle REST Data Services)

The structure of the link to the Application Express development interface is as follows:

http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)

http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

http://host:port/apex (Oracle REST Data Services)

PL/SQL procedure successfully completed.

1 row selected.

...null1.sql

SYS>

Step 3:

Change "Admin" password using below script.

SYS> @apxchpwd.sql

================================================================================

This script can be used to change the password of an Application Express

instance administrator. If the user does not yet exist, a user record will be

created.

================================================================================

Enter the administrator's username [ADMIN]

User "ADMIN" exists.

Enter ADMIN's email [ADMIN]

Enter ADMIN's password []

Changed password of instance administrator ADMIN.

SYS>

Step 4:

Create APEX_LISTENER and APEX_REST_PUBLIC_USER by running below script.

SQL> @apex_rest_config.sql

Synonym created.

Session altered.

PL/SQL procedure successfully completed.

SQL>

Step 5:

Embedded PL/SQL gateway (EPG) configuration. Use below script to configure PL/SQL Gateway. It loads the images to the database.

SQL> @apex_epg_config.sql <Software base location>

SQL> @apex_epg_config.sql /u02/softwares

PL/SQL procedure successfully completed.

Commit complete.

Directory dropped.

timing for: Load Images

Elapsed: 00:01:37.58

PL/SQL procedure successfully completed.

Commit complete.

SQL>

Step 6:

Unlock "ANONYMOUS" user account.

SQL> alter user anonymous account unlock;

User altered.

SQL>

Step 7:

Change XML DB protocol port to non "0" value if it is set to "0"

SYS> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT

-----------

SYS>

SQL> exec DBMS_XDB.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL>

Validation:

http://server2.apps.com:8080/apex

Workspace: INTERNAL

Username: admin

Password: <admin user password>

Thanks for your patience to view this post..............

Thursday 6 December 2018

Step by Step Oracle Enterprise Manager(OEM) 13C installation

Oracle Enterprise Manger 13c installation on OEL 6

This document describes step by steps how to install Oracle Enterprise Manger 13C in OEL 6

1. Assumptions

2. Download Required Softwares

3. 12.1.0.2 Binaries Installation

4. 12.1.0.2 Database Installation using template

5. 13c OEM installation

1. Assumptions:

We assume that already installed Oracle Enterprise Linux 6 in virtual box. Please Click Here to know how to install OEL 6 in virtualbox if did not install it before.

2. Download Required Softwares

2a. Click Here to download Oracle 12.1.0.2 software

2b. Click Here to download Oracle 12.1.0.2 database with 13c templates.

2c. Click Here to download Oracle Enterprise Manger 13c software.

3. 12.1.0.2 Binaries Installation

Installation Prerequisites

We can use the Oracle provided package to install prerequisites. ( if our server has internet connection)

# yum install oracle-rdbms-server-12cR1-preinstall –y

Otherwise we have to install prerequisites using below manual process.

1. Go to /etc/sysctl.conf and set the below parameters.

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65000

2. Go to /etc/security/limits.conf and set below parameters

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

3. Install below packages.

yum install make -y

yum install binutils -y

yum install gcc -y

yum install libaio -y

yum install glibc-common -y

yum install libstdc++ -y

yum install libXtst -y

yum install sysstat -y

yum install glibc -y

yum install glibc-devel -y

yum install glibc-devel.i686 -y

4. Disable firewall.

root@oem ~]# service iptables stop

[root@oem ~]# chkconfig iptables off

5. Users and groups creation

[root@oem ~]# groupadd orinstall

[root@oem ~]# groupadd dba

[root@oem ~]# useradd -g oinstall -G oinstall,dba oracle

[root@oem ~]# passwd oracle

6. Create directory structure for Oracle Home.

[oracle@oem ~]$ mkdir -p /u02/app/oracle/product/12.1.0.2/db_1

[root@oem database]# chown -R oracle:oinstall /u02

[root@oem database]# chown -R 775 /u02

Oracle Binaries Installation:

Step 1:

Go to downloaded software location and start runInstaller to install oracle 12.1.0.2 binaries.

[oracle@oem database]$ ./runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 7312 MB Passed

Checking swap space: must be greater than 150 MB. Actual 8199 MB Passed

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-12-06_11-17-45AM. Please wait ...[oracle@oem database]$

Uncheck "oracle updates" and click "Next"

Click "Yest" to continue

Select "Install database software only" and click "Next"

Select "Single instance database installation" and click "Next"

Click "Next"

Select "Enterprise Edition" and click "Next"

Provide base and home location. Click "Next"

Click "Next"

Click "Install"

Execute above mentioned scripts as root user and click "OK"

]

[root@oem ~]# /u02/app/oraInventory/orainstRoot.sh

Changing permissions of /u02/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u02/app/oraInventory to oinstall.

The execution of the script is complete.

[root@oem ~]#

[root@oem ~]# /u02/app/oracle/product/12.1.0.2/db_1/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u02/app/oracle/product/12.1.0.2/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

[root@oem ~]#

Click on "Close"

4. 12.1.0.2 Repository Database creation using template.

Copy downloaded 12.1.0.2 database template zip file to $ORACLE_HOME/assistants/dbca/templates and unzip it.

[oracle@oem templates]$ pwd

/u02/app/oracle/product/12.1.0.2/db_1/assistants/dbca/templates

[oracle@oem templates]$ ls -ltr 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Linux_x64.zip

-rwxr-xr-x. 1 oracle oinstall 376876746 Dec 6 14:19 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Linux_x64.zip

Unzip above zip file and create database using dbca.

[oracle@oem bin]$ ./dbca

Click "Next"

Select "Advanced Mode" and click "Next"

Select "12.1.0.2.0 database template for EM13.2.0.0 Large deployment" and click "Next"

Provide database name (SID) and click "Next"

Uncheck "Configure Enterprise Manager (EM) Database Express" and click "Next"

Provide password for sys and system account and click "Next"

Provide listener name, port and click "Next"

Provide datafiles location, fast recovery area location, select check box for enabling archive mode and click "Next"

Click "Next"

Click on "Finish"

Click on "Close"

[oracle@oem bin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 6 15:11:18 2018

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

GRIDDB READ WRITE

SQL>

5. 13c OEM installation

Go to downloaded 13c software location and start the installation by executing "em13200_linux64.bin". We no need to unzip the downloaded zip file. Installer takes care of it as part of installation.

Note: Make sure we have minimum 10GB free space under /tmp.

Create directory structure for Middleware home and agent.

[oracle@oem ~]$ mkdir -p /u01/app/oracle/Middleware

[oracle@oem ~]$ mkdir -p /u01/app/oracle/agent

[oracle@oem 13C_EM]$ ./em13200_linux64.bin