NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

How to Deploy SSL Certificates on Oracle Weblogic

No comments

How to Deploy SSL Certificates on Oracle Weblogic


Oracle Weblogic uses the Java Keystore architecture to manage and deploy SSL Certificates. We need to get the certificate from the certifying authority and download the root certificate, intermediate and main certificate out of that.


Steps to deploy:


1) Set Weblogic Environment

/wlserver_10.3/server/bin/setWLSenv.sh

2) Concatenate Certificate with Root Certificate(s) into 1 file

Sequence would as below

Main Signed Cert + CA Intermediate(s) + CA Root

and Save file as: fullcertificate.crt

3) Import Full Cert into identity.jks Keystore
keytool -import -trustcacerts -alias funoracle -file fullcertificate.crt -keystore identity.jks

4) Create Empty Trust Store
This Trust Store will be used to store the Root and Intermediate certificates alone

keytool -genkey -keyalg RSA -alias dummy -keystore truststore.jks

## Answers DO NOT MATTER you will delete this dummy record next

What is your first and last name?
[Unknown]:
What is the name of your organizational unit?
[Unknown]:
What is the name of your organization?
[Unknown]:
What is the name of your City or Locality?
[Unknown]:
What is the name of your State or Province?
[Unknown]:
What is the two-letter country code for this unit?
[Unknown]:
Is CN=Unknown, OU=Unknown, O=Unknown, L=Unknown, ST=Unknown, C=Unknown correct?
[no]:  yes

Enter key password for
(RETURN if same as keystore password):
Re-enter new password:
 

5) Delete the DUMMY record
Here we remove the “dummy” alias before importing the Trust chain in the next step.

keytool -delete -alias dummy -keystore truststore.jks
 

6) Import the Trust Cert Chain only from the CRT format
CA Intermediate(s) + CA Root

keytool -import -alias root -file inter.crt -keystore truststore.jks
 

7) In Weblogic Console -> Server
Set SSL Listen Port to 443 and disable Listen port for 80 (if you want to force the server to SSL only). Else no action required



8) In Weblogic Console -> Server
Keystore Tab -> Change to Custom Identity and Trust

For Identity set:

Custom Identity Keystore == C:\Oracle\keystore\identity.jks
Custom Identity Keystore Type == JKS
Custom Identity Keystore Passphrase ==
For Trust set:

Custom Trust Keystore == C:\Oracle\keystore\truststore.jks
Custom Trust Keystore Type == JKS
Custom Trust Keystore Passphrase ==

9) In Weblogic Console -> Server
In SSL Tab

Set Private Key Alias == portal
Set Private Key Passphrase ==
In the Advanced Section set Use JSSE SSL on


No comments :

Post a Comment

Query to Check All Concurrent Manager Status

No comments

We can use below query to check all concurrent managers status with node name and number of actual/target processes.



Script:


SELECT   b.user_concurrent_queue_name "Concurrent Manager", a.TARGET_NODE "Node", a.running_processes "ACTUAL Processes", a.max_processes "TARGET Processes"
   ,DECODE (b.control_code
     ,'D', 'Deactivating'
     ,'E', 'Deactivated'
     ,'N', 'Node unavai'
     ,'A', 'Activating'
     ,'X', 'Terminated'
     ,'T', 'Terminating'
     ,'V', 'Verifying'
     ,'O', 'Suspending'
     ,'P', 'Suspended'
     ,'Q', 'Resuming'
     ,'R', 'Restarting'
     ) status
  FROM apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_vl b
    WHERE a.concurrent_queue_id = b.concurrent_queue_id AND a.running_processes = a.max_processes
 ORDER BY a.max_processes DESC;




No comments :

Post a Comment

Introduction to Oracle Data Gaurd - Chapter 2

No comments
In this post I am going to cover the concepts of Oracle Data Gaurd.


Oracle Datagaurd is part of Oracle Maximum Availability Architecture(MAA) which includes various Oracle technologies like RAC,ASM,Flashback, Active DataGaurd and Goldengate.





















Datagaurd is part of MAA and used for Data protection which provides a disaster recovery solution for Oracle Databases. It also be considered as a High Availability Solution*.
For Datagaurd we can  keep the DR on different servers,data centers or geographical location to provide best data protection.



























In the DR environment the source database from where data is synced to target database is called as PRIMARY Database and the target database is know as Standby Database. The above picture represents simple architecture for a basic DR configuration.

DR sends the redo log files to standby database so it is also know as log  shipping based replication.
DR is a unidirectional replication which means that any changes to data made in Primary would only move to standby. No changes can be done at standby side

No comments :

Post a Comment

Oracle DataGaurd Tutorial Series Details-Chapter 1

No comments
Hello and welcome to the Oracle DataGaurd Tutorial Series of post. In these post I would be sharing the guide to start understanding and working on data gaurd.

You should be having some prior knowledge on 

a) Oracle Database administration Basics
b) Basic of Linux Command
c) Have knowledge of working on virtual box and setting up server.

I will be covering topics related to below in this series.

1) Introduction to Oracle DataGaurd- Understanding the concepts.
2) Create and Manage Physical and Logical Standby database.
3) Understanding and Configuring Data Gaurd Broker and using it to monitor Data Gaurd.
4) How to do role transition (Switch Over and Failover)
5) How to setup Fast-Start Failover(FSFO)
6) How to setup Active Data Gaurd
7) How to setup Snapshot Standy Database
8) Implement Client Failover
9) How to Use RMAN for datagaurd environments

I would be using Oracle Virtual Box to setup the Oracle Data Gaurd Environment.

Environment Requirement

1. Virtual Box software latest version
2. Database software 12cR1(12.1.0.2)
3. Oracle Enterprise Linux 6.4 64 bit
4  Putty or ssh terminal(In case of Linux)
5. Using the above , I have setup two Machines on virtual box.(How to create Virtual Machine and Install Oracle database). I would not separately mention, how to install oracle database as part of this series. I would assume you would have already completed that. In case of any issue, Please mention in comment section.





No comments :

Post a Comment

How to install/configure Oracle EBS R12.2 on Multiple Server/Nodes (Database and Application Separately)

No comments

In this post I am going to share how to install Oracle EBS R12.2 on multiple nodes. Which means Database on one server and Application on one server.


I am using Oracle Virtual Box and configured 2 servers, one for Database and one for Application.

Virtual Server/Machine Details

Database Node
Memory: 6 GB
Harddisk: 200 GB
Hostname: fundb.lab
IP: 192.168.56.80
OSuser: oracle
Stage Area has been created separately on nodes and is non shared

Application Node


Memory: 7 GB

Harddisk: 270 GB
Hostname: funapp.lab
IP: 192.168.56.81
OSuser: applmgr
Stage Area has been created separately on nodes and is non shared

 Please perform all the pre-reqs on both nodes as described in earlier post.

1) user creation
2) rpm installation and limits configuration
3) oraInst.loc

Refer https://www.funoracleapps.com/2017/02/installing-oracle-apps-r122-step-by.html for steps by step pre-installation method setup.

Also make sure hostname are pingable from each other. This can be achieved by putting the entries in /etc/hosts file.

Once both the servers are ready to installation. Please follow below steps

1) Kick-off rapidwiz on Database node first. We need to give all information for our db node and apps node. Once the installation on DB node completes, our database and listener would be ready.
























2) There would be a configuration file created on DB node ($ORACLE_HOME/appsutil/conf_.txt). Please copy it to application node as it would be needed during installation. 

3) Now we need to kickoff rapidwiz on application node.




Please provide the path of configuration file copied in step 2.











This completes our installation of EBS on 2 nodes.



No comments :

Post a Comment

Workflow Services are not Running or Starting in R12 Oracle Apps

No comments
Oracle Workflow Services in Oracle Applications are encountering problems.The workflow components are not starting when I was trying to start up the services from front end web-form using system administrator responsibility.These services appear with a Target value of 1 and an Actual value of 0. Even I tried from Concurrent>Manager>Administer form but still these were not starting.

 Workflow components was not coming  Up and  showing as below


 Target - 1 Actual - 0


Workflow service Components and there shotnames.

Workflow Agent Listener Service - WFALSNRSVC
Workflow Mailer Service - WFMLRSVC
Workflow Document Web Services Service - WFWSSVC

 We can find the same using below query as well.

Workflow Agent Listener Service:

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Agent Listener Service';

CONCURRENT_QUEUE_NAME
------------------------------
WFALSNRSVC


Workflow Mailer Service:

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Mailer Service';

CONCURRENT_QUEUE_NAME
------------------------------
WFMLRSVC


Workflow Document Web Services Service:

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Document Web Services Service';

CONCURRENT_QUEUE_NAME
------------------------------
WFWSSVC



Now to fix the issue we will follow below steps

1) Make the the processes value zero for these services.

UPDATE  fnd_concurrent_queues
SET running_processes = 0, max_processes = 0
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC'); 

3 rows updated.

2) Update Control codes with NULL

UPDATE  fnd_concurrent_queues
SET control_code = NULL
WHERE concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC')
AND control_code not in ('E', 'R', 'X')
AND control_code IS NOT NULL; 

0 rows updated.

3) Make Target node as Null option

UPDATE  fnd_concurrent_queues
SET target_node = null
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC'); 

3 rows updated.

4) Commit

SQL>commit;

Commit complete.

5) Check Workflow Concurrent Managers

Wait for few minutes, the Internal concurrent manager will bring up services automatically.
We can check the components status using following SQL statements.

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC';

C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
                  1             1

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC';

C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
                  1             1

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFWSSVC';

C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
                  1             1

No comments :

Post a Comment

How to un-link a FND_USER from from SSO in EBS R12

No comments

If we want to unlink any Oracle application user from SSO then we can use below script.



Run the EBS  script

$FND_TOP/patch/115/sql/fndssouu.sql USER_NAME

Apart from setting the FND_USER.USER_GUID value to NULL, this script also flushes the workflow entity cache for the user.

No comments :

Post a Comment

Understanding and Creating Custom Template file for Autoconfig in Oracle Apps R12

No comments


When Autoconfig is executed in EBS/Oracle Apps it creates various configuration files which are created from the template files.
Some time we might need to find the template file associated with these conf file to customize these templates and avoid autoconfig to use the default ones.

Below are the few important points to be remembered.


  • The AutoConfig template file cannot be customized if the "LOCK" keyword appears in the template file.
  • AutoConfig ignores custom template files that are marked with "LOCK”.
  • Customization of Template File must be done on both Patch & Run File system.

How to Determine the Auto Config template file which you want to customize.


Apps Tier: /bin/adtmplreport.sh contextfile=target=

DB Tier: /appsutil/bin/adtmplreport.sh contextfile= target=

Example:

$AD_TOP/bin/adtmplreport.sh contextfile=/u01/TEST/fs1/inst/apps/TEST_funoracleapps/appl/admin/TEST_funoracleapps.xml target=/u01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/security2.conf

It will generate a log file with required information on configuration file and template file like below


TEMPLATE FILE   : /u01/TEST/fs1/EBSapps/appl/fnd/12.0.0/admin/template/security2_conf_FMW.tmp
TARGET FILE     : /u01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/security2.conf


Create Custom Template file

  • Create folder custom in location where template file resides.
  • Copy template file in custom folder and make the required changes. 
  • Verify using adchkcfg script that custom template will change files as you expect them to be.
  • Now whenever Autoconfig will run it will pick custom template file only.

No comments :

Post a Comment

Query to check session details in Oracle Database

No comments
We can use below query to check the session details.

Query:


select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION, s.MODULE, s.TERMINAL,s.sql_id,s.last_call_et,s.event, s.client_info,s.PLSQL_SUBPROGRAM_ID,s.PROGRAM,s.client_identifier
, ( SELECT max( substr( sql_text , 1, 40 )) FROM gv$sql sq WHERE sq.sql_id = s.sql_id ) AS sql_text
, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object
, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram
, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object
, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram
, 'alter system kill session ' || '''' || s.SID || ',' || s.serial# ||',@'|| s.inst_id||''''|| ' immediate;' kill_session
from gv$session s ,gv$process p
where
--client_identifier like '%HIMANSHU.SINGH%'
--s.ecid like '%ZnHWOPoUDWbG%'
-- sid=4361
--p.spid='1196'
--s.program like '%ICM%'
and p.addr=s.paddr
and p.inst_id = s.inst_id
;


Note: Un-comment the condition which ever is required.

No comments :

Post a Comment

How to find Patch Set Level in Oracle E-Business Suite

No comments
We can use below query to find Patch Set Level in Oracle  E-Business Suite.


Query:

select
abbreviation
,codelevel
from
ad_trackable_entities
where
abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
order by

abbreviation;


Note: We can change product in where condition as required.

No comments :

Post a Comment

How to find out the patch level of any product you have installed in E-Business Suite

No comments
We can use below query to  find out the patch level of any product you have installed in e-Business Suite


Query:

sqlplus apps/

 SELECT substr(APPLICATION_SHORT_NAME,1,8) product,
substr(PRODUCT_VERSION,1,14) version,
substr(PATCH_LEVEL,1,11) patch_level
FROM fnd_application a, fnd_product_installations p
WHERE a.application_id = p.application_id
ORDER BY application_short_name;


No comments :

Post a Comment

How to License a new product in R12 E-BUSINESS SUITE

No comments
We have to follow below process to license a new product on existing R12 E-Business Suite.

Steps:
  1. License the product in License Manager.
  2. Generate product related components by ADADMIN.
1. License new product from License Manager:
To license the new product follow the below steps.
  • Login to E-Bisuness Suite.
  • Navigate to Oracle Application Manager > License Manager.
  • Click on ‘Product’ link under ‘License’ tab.
  • Select ‘License Application Product’ and ‘Continue’.
  • Check the product you want to license and complete the action in License manager.
  • Now the product is licensed in system, but not ready to use.
2. Generate product related files.
To generate product related files in system follow below steps.
  • Login to Application server with applmgr user.
  • Set environment file.
  • Run ADADMIN and choose below options:
  • Option 1 – generate Application Files Menu >
                                        1. Generate Message Files
                                        2. Generate Forms Files
                                        3. Generate Report Files
                                        4. Generate Product JAR Files
  • Return to Main Menu and choose Option 3 – Compile/Reload Applications Database Entities Menu >
                                        1. Compile APPS Schema
                                        2. Compile Menu Information
                                        3. Compile Flexfields
  • Return to Main Menu and exit from ADADMIN.
  • Run autoconfig.
Now we can successfully use the new product.

No comments :

Post a Comment

How to enable India Localization in Oracle Apps R12

No comments
We have to follow below steps for enabling India Localization.

STEPS

1. Click System Administrator ---> Oracle Applications Manager -->License Manager ---> Country-specific Functionalities ----> Select Singapore ----> Click Next ----> Click Submit ----> Click Ok.

2. Check the India Localization licensed or Not
Click Syatem Administrator ---> Oracle Applications Manager --> Licensed Products ---> check Status of JA-Asia/Pacific Localizations licensed or Not. If status is licensed means India localization is enabled

3.
Go to $JA_TOP/patch/115/driver/
[oracle@funoracleapps driver]$ pwd
/u01/TEST/apps/apps_st/appl/ja/12.0.0/patch/115/driver
[oracle@funoracleapps driver]$ ls
ja12axdo.drvx jai5188052.drv


4.  Enable the triggers
Go to /u01/TEST/apps/apps_st/appl/ja/12.0.0/patch/115/sql
Compile the files (Path: $JA_TOP/patch/115/sql)

                              a. jai_enable_trg.sql
                        
Connect sqlplus apps user
SQL> @jai_enable_trg.sql

PL/SQL procedure successfully completed.




No comments :

Post a Comment

How to Install SQL Developer on Linux Mint

No comments
In this post I am going to share the steps for installation of SQL Developer on Linux Mint OS or Ubuntu.

SQL developer will require to jdk as pre-requisites.

Steps:

1. Install jdk 8 or above. 

sudo apt-get install openjdk-8-jdk

It will be installed in below folder

/usr/lib/jvm/java-8-openjdk-amd64

2. SQL Developer which we wil download from Oracle Website would in rpm format. I am going to use alien tool to covert it in debian(deb) format.

sudo apt-get install -y alien

3. Convert the SQL developer rpm to debain format.

himanshu@himanshu-ThinkPad-T430 ~/Downloads $ ls -ltr sqldeveloper-19.2.1.247.2212.noarch.rpm
-rw-rw-r-- 1 himanshu himanshu 420128668 Sep 18 23:46 sqldeveloper-19.2.1.247.2212.noarch.rpm


himanshu@himanshu-ThinkPad-T430 ~/Downloads $ sudo alien sqldeveloper-19.2.1.247.2212.noarch.rpm

Once done we can see below deb file.

himanshu@himanshu-ThinkPad-T430 ~/Downloads $ ls -ltr sqldeveloper_19.2.1-248.2212_all.deb

-rw-r--r-- 1 root root 416469574 Sep 19 00:02 sqldeveloper_19.2.1-248.2212_all.deb


4. Install SQL Developer package now.

You can user GUI to install the package 



or 

Run below command on terminal

himanshu@himanshu-ThinkPad-T430 ~/Downloads $ sudo dpkg -i sqldeveloper_19.2.1-248.2212_all.deb
Selecting previously unselected package sqldeveloper.
(Reading database ... 256436 files and directories currently installed.)
Preparing to unpack sqldeveloper_19.2.1-248.2212_all.deb ...
Unpacking sqldeveloper (19.2.1-248.2212) ...
Setting up sqldeveloper (19.2.1-248.2212) ...
Processing triggers for libc-bin (2.23-0ubuntu11) ...


5. Open SQL Developer, First time it will ask for jdk path, please provide same path as done in step 1


himanshu@himanshu-ThinkPad-T430 /usr/local/bin $ ls -ltr sqldeveloper
-rwxr-xr-x 1 root root 34 Sep  5 03:58 sqldeveloper


himanshu@himanshu-ThinkPad-T430 /usr/local/bin $ ./sqldeveloper

 Oracle SQL Developer
 Copyright (c) 2005, 2018, Oracle and/or its affiliates. All rights reserved.

Default JDK not found
Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/himanshu/.sqldeveloper/19.2.1/product.conf
/usr/lib/jvm/java-8-openjdk-amd64



No comments :

Post a Comment