Vishwa Krishna

Wednesday, April 19, 2017

Oracle Database 12c installation and configuration on Oracle Linux-OEL6

Note.1: JDK version should be 1.8+

1. Set the JAVA_HOME

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

$JAVA_HOME=/home/oracle/jdk/jdk1.8.0_131

$export JAVA_HOME

2. Install all required libraries. For e.g compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) gcc-4.1.2 gcc-c++-4.1.2 but in OEL-6 most of them have or can be updated by $yum install updates.

3. Assuming you have downloaded Oracle database 12c (files: linuxamd64_12102_database_1of2.zip & linuxamd64_12102_database_2of2.zip)

4. Go to database where you have unzipped linuxamd64_12102_database_1of2.zip & linuxamd64_12102_database_2of2.zip files.

In above screen shot, you should un-check “I wish to -----“

5. Select the “create and configure a database”

6. Select Desktop class

7. Create a ORACLE_HOME=/home/oracle/12c-database (create your own convenience)

8. Summery page as below.

9. Once it reaches at ~80% then ask for to run oraInventory commands in ‘root’ user.

[oracle@vishwa ~]$ sqlplus / as sysdba

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 from v$database;

NAME

---------

ORCL

SQL>

Hope this helps!

Many Thanks

Vishwa

Tuesday, March 21, 2017

Integration of OAM with JDE (JD Edwards)

Thanks for visiting here J

Please follow the below link -

http://docs.oracle.com/cd/E17984_01/doc.898/e14717/sso_thru_oam_11g.htm

See this section for an overview:

16.2 Setting Up Oracle Access Manager Single Sign-On for JD Edwards EnterpriseOne

=> To configure Oracle Access Manager single sign-on for JD Edwards EnterpriseOne, you must register the Oracle Access Manager 11g WebGate Agent for JD Edwards EnterpriseOne HTML Server. This configuration includes the following tasks:

1. Creating a host identifier for the JD Edwards EnterpriseOne HTTP Server.

2. Creating an application domain template with resources, authentication and authorization policies.

3. Creating the JDE resources such as /JDE and /…/* and added them to the authorization policies.

4. Adding the JDE_SSO_UID Header field to responses section.

5. Copying the Agent files from the Oracle Access Manager 11g WebGate Agent to the JD Edwards EnterpriseOne Server.

Please note the important step that modify the response header to provide the userid to JDE:

On the Responses tab, complete the following fields in the header row:

· Name: JDE_SSO_UID

· Type: Header

· Value: $user.userid

Thanks

Vishwa

Saturday, September 26, 2015

Installing Oracle Linux 7

1. Download Oracle Linux 7 (Named binary V74844-01.iso) from Oracle e-Delivery cloud.

2. Start your Oracle Virtual Box and create New image ( As its all initial basics, I have not elaborated here)

During partition, select ‘Manually configure’ and select ‘Standard Partition’

Once its compete then click reboot option.

Thank you for visiting my blog!!

Good Luck

Vishwa