Monday, March 26, 2018

How to Change weblogic Server Password


changing weblogic passwords
----------------------
take a back of below all mentioned directory inside files
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\data
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\oracledi\nodemanager
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\security
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\security

node manager password
->C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\oracledi\nodemanager
nm_password.properties in this file
hashed={Algorithm\=SHA-256}kjx+pETIjTE/hao3pSBONtYL6ChYf8YJDq0k7MdSfRE\=
remove above line and add below two password and username
password=Admin123
username=weblogic

weblogic main admin server:
----------------------
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\security
boot.properties   change the password
password=Admin123
username=weblogic

Changing password in Weblogic Console
----------------------------------
Go to: Security Realm -> myrealm > Users and Groups >weblogic -> Passwords
change the password

Changing the Nodemanager password in the Weblogic Console:
----------------------------------------------
Go to Domain -> General -> Security -> Advanced
change the password.

Or Changing the password from Command line using below command
------------------------------------------------------

java weblogic.security.utils.AdminAccount  weblogic welcome123 .

after this new security file will be created in
C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\security

DefaultAuthenticatorInit.ldift

Wednesday, March 21, 2018

SQL Performance Tuning 2 and tips

Oracle SQL Performance Tuning 1

PL/SQL Tutorial : PLSQL Interview Questions and answers

SQL Tutorial 6 : SQL ORDER BY Clause

OBIEE 12c : OBIEE 12c Installations Part 1 on Windows 10

OBIEE 12c : OBIEE 12c Installations part 2 on Windows 10

SQL Tutorial 5 : SQL Operators Precedence

SQL 12c Tutorial 20 : SQL 12c Creating Multiple Indexes on column

SQL 12c Tutorial 19 : SQL IDENTITY Column for generating Sequence Valu...

SQL 12c Tutorial 18 : SQL Invisible Column options in SQL 12c New Feat...

SQL 12c Tutorial 17 : SQL Inline View Sub-Queries examples

SQL 12c Tutorial 16 : SQL Correlated Sub Queries

SQL 12c Tutorial : SQL Sub Queries IN , ANY, ALL

SQL 12c Tutorial 14 : SQL Set Operators UNION, UNION ALL, INTERSECT an...

SQL Tutorial 13 : SQL General Functions NVL , NVL2, NULLIF and COALESCE

SQL Tutorial 11 : SQL Numeric Functions ROUND TRUNC MOD

SQL Tutorial 10 : SQL Single Row Character Functions

SQL Tutorial 7 : SQL 12c ROW Limiting Clause

SQL Tutorial 8 : SQL Substitution variables

SQL Tutorial 9 : SQL DEFINE , UNDEFINE & SET VERIFY Commands

SQL 12c Tutorial 21 : SQL 12c Features APPROX_COUNT_DISTINCT

SQL Tutorial 12 : SQL Date Manipulation functions