Steps for Upgrading Oracle DB 11.2.0.1 to 11.2.0.3

Step by Step installing Apache Subversion

Prerequisite:

Httpd:

Installing Subversion:

Configuring Subversion with HTTP:

Save and close the file.

Creating the SVN repository:

Creating users for authentication:

Restart the httpd server:

Accessing Repository in the browser:

Steps for Decrypting forgotten weblogic password

Note: This method works only if we have boot.properties file in our domain home

Starting wlst command prompt:

Navigate through MW_HOME\oracle_common\common\bin and

run the wlst command as below

Defining domain, service and encryption:

In the wlst command prompt define domain, service and encryption as below

domain = "MW_HOME/user_projects/domains/base_domain/"

service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)

encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)

Decrypting the encrypted password:

Note: Copy the encrypted password from boot.properties file

boot.properties location= DOMAIN_HOME\servers\Adminserver\security

Use print command as below to print the encrypted password

Syntax:

print "Weblogic server Admin password: %s" %encryption.decrypt<boot.properties_encrypted_password")

Example:

Print "Weblogic server Admin password: %s" %encryption.decrypt("{AES}0RFlBNYhFEoAroSAQaeYNY8wl9nxuToZSg39ZpM1QZo=")

It will print the decrypted password.

Steps for installing odi 12c standalone agent

Installing ODI in standalone mode:

Start the installation as below:

In the welcome screen click on Next

Select skip auto updates and click on Next

Provide the home directory to install and click on Next

Select Standalone installation and click on Next

If the prerequisite checks got completed successfully click on Next

In the installation summary screen click on Install

If the installation progress got completed successfully click on Next

Click on Finish.

Configuring domain for the ODI standalone agent:

Run the config utility as below

Select create the domain and provide domain location and click on Next

Select Oracle Data Integrator – Standalone Agent – 12.2.1.3.0 [odi] and click on Next

Click on Next

Provide the database and schema details and click on get rcu configuration

If rcu configuration got successfully click on Next

Select all the component schemas and click on Next

If the connections got tested successfully click on Next

Click on Next

Provide the details and click on Next

Select per-domain default location and provide credentials and click on Next

Click on Create

If the configuration progress got completed, click on Next

Click on Finish

Configuring ODI studio:

Open the studio as below

Create new repository connection as below

Click on ok to open the newly created repository connection

Create New Agent as below

Provide the details and save the Agent

Starting Node manager and Agent:

Starting Node manager:

Start the node manager as below

Starting Agent:

Start the Agent as below

It asks for the password provide it

The agent started successfully.

Testing the agent in the ODI studio:

Test the agent in ODI studio as below

Test the agent URL:

Test the agent in the browser with the below URL

http://localhost:20910/oraclediagent