Enterprise Manager 11g FMW Console Hangs While Showing Loading Animation in Oracle Apps R12.2
Enterprise Manager 11g FMW Console Hangs While Showing Loading Animation in Oracle Apps R12.2
- Navigate to the Context Editor in Oracle Applications Manager or edit context file .
- Locate the setting for s_nm_jvm_startup_properties.
- Add the end of the value add the following: -Djava.awt.headless=true.
- Save the changes.
- Run Autoconfig
- Bounce the WLS Admin Server using adadminsrvctl.sh script.
- Connect to Oracle Enterprise Manager 11g FMW console to confirm this not proceeds to expected page.
How to Mount AWS S3 Bucket on Linux (OEL/Centos/Ubuntu)
How to Mount AWS S3 Bucket on Linux (OEL/Centos/Ubuntu)
I am going to use
S3FS solution which is FUSE (File System in User Space). Using this we
can use commands like cp, mv on the system. It will be a normal mount on the
Linux system.
Prerequisites:
Steps:
1: Remove Existing
Packages
Login to your Linux instance.
First of all, check whether you have already installed any
existing fuse or S3FS on your server. In case it exists, then remove it to
avoid conflicts on the server.
For CentOS OR RHEL
Users:
# yum remove fuse
fuse-s3fs
For Ubuntu Users:
$ sudo apt-get remove
fuse
2: Install dependency
Packages.
Now you must install packages that are required for fuse and
s3cmd.
For CentOS or RHEL
users:
# yum install
openssl-devel gcc libstdc++-devel gcc-c++ fuse fuse-devel curl-devel
libxml2-devel mailcap git automake
For Ubuntu Users:
# apt-get install build-essential libcurl4-openssl-dev
libxml2-dev mime-support
3: Download and
Compile Latest Fuse.
Change your directory location to /usr/src using cd command
then download and compile fuse source code. After compiling, add fuse to the kernel. In our example we are using fuse version 3.0.1.
#cd /usr/src/
#wget
https://github.com/libfuse/libfuse/releases/download/fuse-3.0.1/fuse-3.0.1.tar.gz
#tar xzf
fuse-3.0.1.tar.gz
#cd fuse-3.0.1
#./configure
--prefix=/usr/local
#make &&
make install
#export
PKG_CONFIG_PATH=/usr/local/lib/pkgconfig
#ldconfig
#modprobe fuse
4: Download and
Compile Latest S3FS
To download the latest version of s3FS change your directory
to “/usr/src/” along with below list of commands.
#cd /usr/src/
#wget https://github.com/s3fs-fuse/s3fs-fuse/archive/v1.82.tar.gz
#tar xzf v1.82.tar.gz
#cd s3fs-fuse-1.82
#./autogen.sh
#./configure
--prefix=/usr --with-openssl
#make
#make install
5:Setup Access Key
To configure s3fs you need both access key and secret key of
your s3 AWS account I am using root
account to do the setup.
NOTE: Kindly replace the AWS_ACCESS_KEY_ID and
AWS_SECRET_ACCESS_KEY with your actual key values.
# echo AWS_ACCESS_KEY_ID:AWS_SECRET_ACCESS_KEY >
~/.passwd-s3fs
# chmod 600 ~/.passwd-s3fs
6:Mount S3 Bucket on
Linux
The final step would be to mount the s3 bucket on Linux
flavors such as CentOS, RHEL and Ubuntu.
For this example, we are using s3 bucket name as “funmount“
and mount point as /s3mnt_pt.
# mkdir /tmp/cache
# mkdir /s3mount
# chmod 777
/tmp/cache /s3mount
# s3fs -o
use_cache=/tmp/cache funmount /s3mount
Add below entry in fstab to automatically mount after reboot.
s3fs#funmount /s3mount fuse _netdev,rw,nosuid,nodev,allow_other,nonempty,use_cache=/tmp/cache 0 0
How to access your s3
bucket just use normal cd , ls command.
# cd /s3mount
# ll
total 1
d---------. 1 root
root 0 Jan 12 10:37 myfolder
# cd myfolder
# ll
total 1
----------. 1 root
root root an 12 10:39 bucket.rtf
# pwd
/s3mount/myfolder
How to run Opatch in Silent mode without User Interaction
How to run Opatch in Silent mode without User Interaction
Understanding Hard Link and Soft Link in Linux
Understanding Hard Link and Soft Link in Linux
Trying to resume a failed cutover session giving Invalid Credentials in Oracle Apps R12.2
Trying to resume a failed cutover session giving Invalid Credentials in Oracle Apps R12.2
Useful Scripts related to Editioned Database in Oracle Apps
Useful Scripts related to Editioned Database in Oracle Apps
Different Status of Cutover and their Meaning on Oracle Apps R12.2
Different Status of Cutover and their Meaning on Oracle Apps R12.2
How to execute an Empty Patching cycle in Oracle Apps R12.2
How to execute an Empty Patching cycle in Oracle Apps R12.2
How to Install Apache (http) webserver on Linux 7
How to Install Apache (httpd) webserver on Linux 7
Error: The certificate /usr/share/rhn/ULN-CA-CERT is expired on OEL
The certificate /usr/share/rhn/ULN-CA-CERT is expired.
How to Retrieve Forgotten Apps Password in Oracle EBS R12
How to Retrieve Forgotten Apps Password in Oracle EBS R12
sqlplus / as sysdba
2: Create Function to decrypt the encrypted password
SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2
AS
LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
/
3 : Query for Encrypted password
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';
Output
ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A
4: Past the Encrypted password from the above query output into the below query and execute
SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A') from dual;
Output
APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A')
--------------------------------------------------------------------------------
oracle123
5: Test apps password is working or not
SQL> conn apps/oralce123;
Connected.
What is Oracle Data Redaction with Examples (Mask your sensitive Data)
What is Oracle Data Redaction with Examples (Mask your sensitive Data)
You can redact column data by using one of the following methods:
Full redaction. You redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of the column. For example, columns of the NUMBER data type are redacted with a zero (0), and character data types are redacted with a single space.
Partial redaction. You redact a portion of the column data. For example, you can redact a Social Security number with asterisks (*), except for the last 4 digits.
Regular expressions. You can use regular expressions to look for patterns of data to redact. For example, you can use regular expressions to redact email addresses, which can have varying character lengths. It is designed for use with character data only.
Random redaction. The redacted data presented to the querying application user appears as randomly generated values each time it is displayed, depending on the data type of the column.
No redaction. The None redaction type option enables you to test the internal operation of your redaction policies, with no effect on the results of queries against tables with policies defined on them. You can use this option to test the redaction policy definitions before applying them to a production environment.
Oracle Database applies the redaction at runtime when users access the data (that is, at query-execution time). This solution works well in a production system. During the time that the data is being redacted, all of the data processing is performed normally, and the back-end referential integrity constraints are preserved.
How It Works?
We can create redaction policies that specify conditions that must be met before the data gets redacted and returned to the user. During the definition of such policies, the DBA can specify which columns and the type of protection that must be applied.
The package used to create protection rules is called DBMS_REDACT. The package includes five procedures to manage the rules and an additional procedure to change the default value for the full redaction policy.
When to Use Oracle Data Redaction
Use Oracle Data Redaction when you must disguise sensitive data that your applications and application users must access.
Data Redaction enables you to easily disguise the data using several different redaction styles.
Oracle Data Redaction is ideal for situations in which you must redact specific characters out of the result set of queries of Personally Identifiable Information (PII) returned to certain application users. For example, you may want to present a Social Security number that ends with the numbers 4320 as ***-**-4320.
Important Procedures related to DBMS_REDACT
Procedure | Description |
---|---|
| Adds a Data Redaction policy to a table or view |
| Modifies a Data Redaction policy |
| Applies a Data Redaction policy expression to a table or view column |
| Creates a Data Redaction policy expression |
| Disables a Data Redaction policy |
| Drops a Data Redaction policy |
| Drops a Data Redaction policy expression |
| Enables a Data Redaction policy |
| Globally updates the full redaction value for a given data type. You must restart the database instance before the updated values can be used. |
| Updates a Data Redaction policy expression |
It supports the following column data types:
NUMBER, BINARY_FLOAT, BINARY_DOUBLE, CHAR, VARCHAR2, NCHAR, NVARCHAR2, DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, BLOB, CLOB, and NCLOB.
How to check Redaction policies
select * from redaction_policies;
We need to make sure the respective user (in my case apps user) has access to the DBMS_REDACT package.
GRANT EXECUTE ON sys.dbms_redact TO apps;
Example:
let's create a table
CREATE TABLE credit_payment (
id NUMBER NOT NULL,
customer_id NUMBER NOT NULL,
card_no NUMBER NOT NULL,
card_string VARCHAR2(19) NOT NULL,
expiry_date DATE NOT NULL
);
Add some data
INSERT INTO credit_payment VALUES (1, 4000, 1234123412341234, '1234-1234-1234-1234', TRUNC(ADD_MONTHS(SYSDATE,2)));
INSERT INTO credit_payment VALUES (2, 4001, 2345234523452345, '2345-2345-2345-2345', TRUNC(ADD_MONTHS(SYSDATE,4)));
INSERT INTO credit_payment VALUES (3, 4002, 3456345634563456, '3456-3456-3456-3456', TRUNC(ADD_MONTHS(SYSDATE,6)));
INSERT INTO credit_payment VALUES (4, 4003, 4567456745674567, '4567-4567-4567-4567', TRUNC(ADD_MONTHS(SYSDATE,12)));
INSERT INTO credit_payment VALUES (5, 4004, 5678567856785678, '5678-5678-5678-5678', TRUNC(ADD_MONTHS(SYSDATE,9)));
Check the data
Now verify the payment_details table the credit card number would have been masked to 0.
select * from redaction_policies;
These default values can be altered using the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure, but you will need to restart the instance for the updates to be visible.
SQL> COLUMN card_no FORMAT 9999999999999999 SQL> connect apps/apps Connected. SQL> COLUMN card_no FORMAT 9999999999999999 SQL> set lines 200 pages 200 SQL> show user USER is "APPS" SQL> SELECT * FROM apps.payment_details; 2 ID CUSTOMER_ID CARD_NO CARD_STRING EXPIRY_DATE ---------- ----------- ----------------- ------------------- ------------------ 1 4000 1234123412341234 1234-1234-1234-1234 05-MAR-21 2 4001 2345234523452345 2345-2345-2345-2345 05-MAY-21 3 4002 3456345634563456 3456-3456-3456-3456 05-JUL-21 4 4003 4567456745674567 4567-4567-4567-4567 05-JAN-22 5 4004 5678567856785678 5678-5678-5678-5678 05-OCT-21 SQL> grant select on apps.payment_details to ap; Grant succeeded. SQL> connect ap/ap Connected. SQL> SELECT * FROM apps.payment_details; 2 ID CUSTOMER_ID CARD_NO CARD_STRING EXPIRY_DATE ---------- ----------- ----------------- ------------------- ------------------ 1 4000 1111111111111234 ####-####-####-1234 05-MAR-21 2 4001 1111111111112345 ####-####-####-2345 05-MAY-21 3 4002 1111111111113456 ####-####-####-3456 05-JUL-21 4 4003 1111111111114567 ####-####-####-4567 05-JAN-22 5 4004 1111111111115678 ####-####-####-5678 05-OCT-21
Drop an Existing Policy
The DROP_POLICY procedure is used to remove an existing redaction policy. The following example drops the redaction policy and queries the data, showing the redaction is no longer taking place.
BEGIN
DBMS_REDACT.drop_policy (
object_schema => 'apps',
object_name => 'credit_payment',
policy_name => 'redact_card_mask'
);
END;
/
Note: Redaction will not take place if the user has the EXEMPT REDACTION POLICY
system privilege.
Read oracle doc for more options
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/asoag/introduction-to-oracle-data-redaction.html#GUID-57C07734-6D33-497B-A990-1E8F327488B1
Query to find the last access date for a Responsibility in R12
Query to find the last access date for a Responsibility in R12
How can we change the Web Port in EBS 12.2
How can we change the Web Port in EBS 12.2
perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE
Understanding adSyncContext.pl in Oracle Apps R12.2
Understanding adSyncContext.pl in Oracle Apps R12.2
perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE
No comments :
Post a Comment