Monday, May 14, 2018

What is Smart Scan ?

What is Smart Scan ?


The data search and retrieval processing can be offloaded to the Exadata Storage Servers. This feature is called Smart Scan. Using this Smart Scan, Oracle Database can optimize the performance of operations that perform table and index scans by performing the scans inside Exadata Storage Server, rather than transporting all the data to the database server.

Smart Scan capabilities includes :-
1) Predicate Filtering
2) Column filtering
3) Join Processing

Sunday, May 13, 2018

Unlocking Weblogic Admin User Account

Unlocking Weblogic Admin User Account 


Error:
<Notice> <Security> <BEA-090078> <User xxxxxxx in security realm myrealm has had 5 invalid login attempts, locking account for 30 minutes.>

Cause:
By default WebLogic Server enables the user lockout mechanism which locks a particular user account for 30 minutes, if more than 5 attempts are made to login with wrong password.

Solution:
This behaviour of WebLogic Server can be  modified  and the WLS Admin can disable the user account lockout on invalid login attempts mechanism by using the steps mentioned below.

Solution 1

1)- Login to the WLS console as an admin user.
2)- In the left hand side tree go to Security => Realms => myrealm.
3)- In the right hand pane select User Lockout tab => Uncheck Lockout Enabled option.
4)- Click Apply.
5)- Restart the server.

Solution 2

Unlock the admin user by following below example:

In the following example, an administrator named "Admin" with a password of "welcome1" requests the unlocking of the WebLogic Server listening on port "7001" on machine "localhost"

$java weblogic.Admin -url <host_name:<port> -username <username> -password <adminpasswd> UNLOCK

How to check whether user is unlocked or not.

Administration Console: Select Admin server -> Expand the Monitoring-->Security tab for the server.
This page allows you to monitor user lockout management statistics for this server.
Total Invalid Logins:       14
User Lockout Total Count: 1
Total Login Attempts while Locked:8
Invalid Logins High: 1
Locked Users:    0
Total Users Unlocked:   1



Saturday, May 12, 2018

What is security realm ?

What is security realm ?


A security realm is a mechanism used for protecting WebLogic resources. It gives you the ability to protect a resource with a defined security constraint and then define the user roles that can access the protected resources.

Why we need to create a new user under Oracle WebLogic ?

Why we need to create a new user under Oracle WebLogic ?


Sometimes we need a USER to perform less tasks compare with WebLogic administrator user.

Steps:
Go to Security Realms
Click on myrealm
Create a new user into realm
Click on Users and Group
Create New User and Assign Less roles.

Wednesday, May 9, 2018

Codelines In Release 12 eBusiness Suite ?

Codelines In Release 12 eBusiness Suite ?

In Release 12, Oracle E-Business Suite patches are grouped into codelines. A codeline begins with a point release (for example, Release 12.0) consisting of a unique set of product features, and progresses to include all the patches created to maintain that point release. The initial Release 12.0 point release introduced codeline A. Additional point releases introduce new codelines, each identified by a unique letter. For example, Release 12.1 introduced codeline B, and Release 12.2 is introduced as codeline C.

Codeline A ----- R12.0
Codeline B ----- R12.1     
Codeline C ----- R12.2   

                                               

What is consolidated seed patch and AD and TXK Delta Patches will do and why we need to apply those?

What is consolidated seed patch and  AD and TXK Delta Patches will do and why we need to apply those?

Without the consolidated Seed patches, you will receive seed errors applying future patches.  The AD/TXK patches required are patches which deliver updated AD utilities for patching and maintenance and TXK provides mostly autoconfig templates required for the applications