Steps for Recovering or Decrypting the forgotten WebLogic Server Admin Password

Note: We can do this only if we have boot.properties file under $DOMAIN_HOME/servers/AdminServer/security

Create a script decrypt_password.py in $DOMAIN_HOME/security directory 

Copy and paste the below code into it and save the file:

from weblogic.security.internal import *

from weblogic.security.internal.encryption import *

encryptionService = SerializedSystemIni.getEncryptionService(".")

clearOrEncryptService = ClearOrEncryptedService(encryptionService)

# Take encrypt password from user

pwd = raw_input("Paste encrypted password ({AES}fk9EK...): ")

# Delete unnecessary escape characters

preppwd = pwd.replace("\\", "")

# Display password

print "Decrypted string is: " + clearOrEncryptService.decrypt(preppwd)

Save and close the file

Set the environment variables as below:

Get encrypted username and password from boot.properties file of AdminServer as below:

Username: 

Password:

Copy this encrypted password and keep it with you

Decrypting the weblogic server admin password:

Navigate to $DOMAIN_HOME/security directory and run the following command to start decryption:

It will ask us to paste the encrypted password,

Paste the encrypted password we get above and click enter

We will get the decrypted password as below:

Step by step oracle golden gate integrated extract

Creating OGGUSER and granting permissions:

Creating OGGSRC and granting permissions:

Creating OGGTRG and granting permissions:

Altering database supplemental log data:

Applying patch:

Creating parameter file:

OGG Extract:

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

When we tried to start ggsci prompt in oracle golden gate some times we got the below error

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

To resolve this create a soft link as below

Now again try to start the manager

Step by step installing oracle golden gate

Download and stage the software
Oracle GoldenGate 12.2.0.2.2 for Oracle on Linux x86-64 (584 MB)

Installing required rpms:

Installing the Oracle Golden Gate software for the replication source

Login as oracle user

Create a directory for installing ogg for source as below

Change to software directory and run the installer as below

Select database and click Next

Provide the details and click next

Click on install

Click close to finish the installation

Installing the Oracle Golden Gate software for the replication target

Create a directory for installing ogg for target as below

Change to software directory and run the installer as below

Click next

Provide details and click next

Click install

Click close to complete the installation

Starting manager:

Login to ggsci prompt

Now start the manager as below

Sudo User: Steps To Add and Grant Sudo Privileges to Users in Linux

In order to add the user to sudoers file please find the steps below:

Logged in as root run the visudo command:

When we type this command, we will be taken into a text editor session with the file that defines sudo privileges pre-loaded. We will have to add our user to this file to grant our desired access rights.

Save and close the file

Now, when you are logged in as your oracle user, you can execute a certain command with root privileges by typing:

sudo "command"

Steps for preventing Oracle SQL Developer sessions from being killed

In general when we leave the database connection opened for a while in oracle sql developer, It will throw a "connection timeout" message when we tried to run a query next time.
We have to reconnect the connection for running the query.

To keep the database connection alive in sql developer please follow the below steps:

For Oracle SQL Developer 3 Versions:

1. Download oracle.sqldeveloper.keepalive.jar from this link " https://454e35d1-a-62cb3a1a-s-sites.googlegroups.com/site/keepaliveext/oracle.sqldeveloper.keepalive.jar?attachauth=ANoY7cp8U9ULxrRvTu3b-96lNNGvQAyh_LQ_kRfPmskJS0-qDvLfvoEeyd1jVFkbTRsso4wMuH65pMFVrXECLpUsFXj7D9wxGbYZrBffFy6FNAVRpCVy-j5vJ9h84DdMl_tCBGHaI3_GJzjx2OwutMk2b-bdCvOV_lgSy7_Kb3J2T2CjCR9hg9o_Bk_3f5roc86Vr6XxkncVkpZ87XsphHtEmZveLTVzdHcqf1_a9QEKY77koOcbkKU%3D&attredirects=0"

2. Copy the downloaded jar file to the below location

%SQLDEVELOPER_HOME%\sqldeveloper\extensions

3. Open sql developer and right click on a connection and go to Keep-Alive and select Active

4. Enter the user and password details of the connection if it is not already connected

5. We will get a success keep alive message

6. Now check again for the session time out issue.

For Oracle SQL Developer 4 Versions:

1. Navigate to %SQLDEVELOPER_HOME%\sqldeveloper\bin

2. Open sqldeveloper.conf file

3. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.

4. Open sqldeveloper-nondebug.conf file

5. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.

6. Open sql developer and connect to the database and check for session time out