• Open source integration tool.
• It can be made as centralised server by integrating multiple source like source code management , build tools , deployment environment .
• Complete INTEGRATION TOOL
• Its Java based.
• To automate the repeated task.
• CI/CD ( continuous integration and continuous delivery )
• Even you can do patching.
• In simple , its a centralised server.

Advantages

1. CI/CD
2. Open source
3. Community driven
4. Browser based
5. Supports all Operating system.
6. Distributed build --> Master and Slave node , how ? If you are setting up Jenkins , it uses resource of the system where its installed and accordingly the Jobs will take the RAM , CPU and resources. To avoid this "Distributed build" was introduced , so that "Master and Slave node" with that the load will be distributed.
7. We can increase the scalability of master and slave.

CI/CD Workflow

• Commit
• Build
• Test
• Stage
• Deploy

1. Stages will be different in other CI/CD process. Purpose will be the same.
2. Dedicated branch for each environment it will be a best practice to avoid any confusion here.

Installation & Configuration

sudo apt-get update
java -version

Add the official key of Jenkins and then the repo.

sudo wget -O /usr/share/keyrings/jenkins-keyring.asc \
  https://pkg.jenkins.io/debian-stable/jenkins.io-2023.key
echo "deb [signed-by=/usr/share/keyrings/jenkins-keyring.asc]" \
  https://pkg.jenkins.io/debian-stable binary/ | sudo tee \
  /etc/apt/sources.list.d/jenkins.list > /dev/null
sudo apt-get update
sudo apt-get install jenkins

Now JENKINS had been installed , please check with command also whether its installed or not.

dpkg -l | grep -i jenkins

As we have encountered error , install higher version of Java from 11 to 17 or 21.

sudo systemctl start jenkins
sudo systemctl enable jenkins
sudo systemctl status jenkins

• Now open the console with the IP of the system.

• If you want to know the username , then go to below location.

cat /var/lib/jenkins/users/users.xml
/var/lib/jenkins/users/admin_17980521444909415742

want to change the password , edit and restart the jenkins.

<hudson.security.HudsonPrivateSecurityRealm_-Details> <passwordHash>#jbcrypt:$2a$10$OTYB2osGPi/rasutjHcYOOhByiCoaEZTEQk52CABOwYdrtxeIPnBu</passwordHash>
</hudson.security.HudsonPrivateSecurityRealm_-Details>

• Give no password for jenkins user ( as its a internal user )

• Check whether able to get output without sudo password.

User Management & security

• Manage Jenkins > Security

• Trying to use the OS user for security features , lets try.
• Add the user to the group shadow like below and restart the Jenkins.

• Now its integrated with the OS user (sathishpy1808) , you can even login with the OS users after integrating.

Jenkins own database

• User created in Jenkins only can login , OS users can't.

User creation

• Change to "Jenkins own database" then only you can view the user creation option like below ,

• Go to the ravi user profile and explore.

• Even you can terminate all sessions from the console.
• You can change the password also and delete option is also available.

Authorisation

• what type of authorisation is given to the users , you can see many options in the below screen.

• BY default --> "logged-in users can do anything" its equal to admin access --> its not advisable.
• Try to use with user based ,

• Also ROLE based plugin it will be useful , lets install ( mostly used plugin for role based authorisation )

• Manage & roles won't be available at first , it will come after the plugin installation only.

• Manage roles and assign roles are very important option.
• Lets create a role and then assign the users.
• Pattern based users are created only in "Item Roles". Here if any user starts with word "Manage" , it should the managing job roles.

• Create some Jobs to test this user specification.

• Item roles in "Assign Roles" will be useful for pattern description for users.
• You can see all roles which are added.
• All users are added in this console.

Job Management

• Jobs needs to be created to perform a task.

Build Triggers

• "Trigger builds remotely (e.g., from scripts)" --> it will trigger once some other task gets triggered.
• "GitHub hook trigger for GITScm polling" --> once the code gets committed then only the job needs to be triggered.

Build Environment

Build Steps

• This is the main step , you can add number of steps here.
• Raw commands , shell script , etc.
• Can be added like stages.

Post-build Actions

Notes

1. https://www.jenkins.io/doc/book/installing/linux/ --> In this site , you can get the details of the key and the repo details which we have added in the first of the installation part. [TBD]
2. What is "openjdk-17-jdk-headless package" ?
3. Default port of Jenkins is 8080.
4. jenkins user will be always running.

Commands Used

java -version
locate jdk
whereis java

List of errors

Job for jenkins.service failed because the control process exited with error code.

• Now you can get the details by typing ,

journalctl -xeu jenkins.service

Error clearly says , ( version not supported )

Dec 01 22:03:57 meet.sathishpy1808.org jenkins[40153]: Running with Java 11 from /usr/lib/jvm/java-11-openjdk-amd64, which is older than the minimum required version (J>
Dec 01 22:03:57 meet.sathishpy1808.org jenkins[40153]: Supported Java versions are: [17, 21]
Dec 01 22:03:57 meet.sathishpy1808.org jenkins[40153]: See https://jenkins.io/redirect/java-support/ for more information.
Dec 01 22:03:57 meet.sathishpy1808.org systemd[1]: jenkins.service: Main process exited, code=exited, status=1/FAILURE

Access Denied

• change the ownership to the current user,

sudo chown -R sathishpy1808:sathishpy1808 /var/lib/jenkins/
sudo chown $(whoami) /var/lib/jenkins

Dangling meta character '*' near index 0

Lets start to bug the Postgres

https://github.com/syedjaferk/postgres_sample_database/blob/main/dvd_rental/dvdrental.tar

• Above all screenshots are my mistakes , I should use my OS user as POSTGRES then execute all commands.

Select queries

Commands

• to drop the database --> DROP DATABASE ;
• "-\" --> list the database

• Who uses the DB frequently ? Application.

Lets deep dive into Architecture

Post Master

• ஒரு specific portல incoming requestஅ collect பண்ணி வச்சிக்கும். It just re-direct.

• Backend process pool uses RAM & CPU so we can't give any number. It will assigned with a specific value , if all are used then Backend process pool will ask the request to wait until the other request gets completed. Each Backend process pool as separate VIRTUAL memory. it won't all data , but specific information related to request. Even Backend process pool won't execute the request.

• Now Backend process pool ( BP ) will re-direct to Backend workers pool.
• Eg BP - 100 & BW - 100.
• Status of these gets changed like ACTIVE , IDEAL , etc
• Even this Backend workers pool will have separate MEMORY. ( keep in mind )

Query example

• Take an example of the below one,

select * from employee where first_name=john ;

• It will go to the Backend workers pool , then " select * from employee " goes and search in SHARED BUFFER. If its there then it returns the response.
• If the result is not available in SHARED BUFFER , then it goes to DISK.
• Here the catch is , even the SHARED BUFFER size is limited. This can be configured.
• For eg., இப்ப அந்த SHARED BUFFERல 10 mb size allocate பண்ணி இருக்கு , அடுத்த request உள்ள வருது , SHARED BUFFERல இந்த request இல்ல so it goes to DISK and then gets the output of 20 mb file size . இப்ப ஏற்கனவே இருந்த 10 mb size file will be erased and new 20 mb file will be saved in that SHARED BUFFER.
• It will be very fast when the output comes from SHARED BUFFER.
• WORKER Memory will take the order by , sort , etc other than select ( main query ).

Auxiliary Process

WAL WRITER - 1

• Write Ahead Log
• If will take all the backup of the request and the query.
• It as separate buffer space.
• It will also go to DISK.
• The command comes to WAL from two places 1. BACKEND WORKER 2. BACKGROUND WRITER.

DIRTY PAGES

• When the output gets stored in the SHARED BUFFER , at the same time a DIRTY PAGES gets created. why it gets created ? Eg., If there is any update in the query which is stored in SHRED BUFFER , then it updates but this is not saved in DISK.
• If the update or any operation didn't go to main DISK , then it will create a DIRTY PAGES.
• At the same time BACKGROUND WRITER , takes the notes of DIRTY PAGES and asks WAL WRITER to take a not of it.
• The uncommitted task still goes to OS FILE SYSTEM from DIRTY PAGES . Note : still the commit didn't reach the MAIN DISK.

WAL WRITER - 2

• If there is any crash in SHARED BUFFER , then we can get it from WAL WRITER.
• Data won't be recovered but the query can be recovered for the WAL.

WAL ARCHIVER

• WAL WRITER will put all details to WAL ARCHIVER.

CHECK-POINTER

• Whatever comes to OS FILE SYSTEM , CHECK-POINTER will take care to make sure that it reaches the DISK properly.

AUTOVACCUM

• PostgreSQL works in UPPEND method , it takes a clone of the table and then it updates.
• PostgreSQL is Multi-version control.
• It will clean all the STALE process.
• Eg.,

Arun , 24 , 900 - STALE
Raj , 23 , 901
There is an update in Arun Mark ,
Arun , 24 , 910


• இதுல Arunகு மட்டும் updation இருக்கு but இதில் update பண்ணும் போது தனியா ஒரு row create பண்ணி like duplicate and then update takes place.
• AUTOVACCUM will clean all STALE rows.

STARTUP PROCESS

• It will start at first and gets all data from WAL Archive Folder , then only Postgres allows the request.
• Why we need this startup process ? So that all got closed properly.
• This will happen before the "Post Master".

Replica

• Standby unit.
• Its like clone OR Master & Slave concept.
• It receives all details from WAL sender.

Notes

• In windows command path , if you give just "path". It will display all paths which are configured.
• https://miro.com/app/board/uXjVLD2T5os=/

Installation over Oracle Linux

• Version of the Linux Distro which I am using ,

cat /etc/os-release
NAME="Oracle Linux Server"
VERSION="7.9"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Oracle Linux Server 7.9"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:9:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://github.com/oracle/oracle-linux"
ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.9
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.9

• Install the repository RPM,

sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

• Install PostgreSQL,

sudo yum install -y postgresql13-server

Optionally initialize the database and enable automatic start

sudo /usr/pgsql-13/bin/postgresql-13-setup initdb [TBD]
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13


initdb

• This file will create all DB related files , directories & Configuration files.

• Also creation of system catalogs --> what is this ? --> It will store all indexes , roles , etc. --> you can see list of catalogue using below statement.

postgres=# select relname from pg_catalog.pg_class where relkind='r';

sudo -i -u postgres psql

• By default a user , a role and a database will be created.
• All the above 3 will be created in same name "postgres".
• Then how to check the roles ?

postgres=# \du

• Now see the list of databases, ( these 3 are created by postgres by default with the help of template1.

postgres=# \l

• If you try to create a new DB , then it will follow the "template1", its like the blueprint.
• Then why template0 ? --> you can edit template1 but not template0 ( you can't change and its not editable ).
• so in short template0 --> NOT EDITABLE & template1 --> EDITABLE.

WAL

• WRITE AHEAD LOG.
• If the database gets crashed , with this help we can retrieve the data.

Roles

• Librarian , Library member and visitor all these are roles.

• Lets create a dummy role and test ,

• You can see "Cannot login" , that means you can't login as it's not assigned.

• creating one more ROLE,

• Assigning the permissions or roles,

• Here you can't see 'CANNOT LOGIN'.
• If a ROLE can login then he/she is the user.
• User can inherits the parents also.

How it works ?

Postmaster

• All connection request goes first here. ( whatever client ask , server will respond )
• Follows client server architecture.

WAL Writer

• It will be write in a notebook , to keep the track of all.

Checkpoint

• It periodically checks and responed.

Auto Vaccum

• It periodically checks.

Stats Collector

• Gathers all stats Eg., if a table is getting more request then it will collect the information and try to keep it in cache to respond very fast and also check whether index is there for the table.

Archiver

• To backup the data.

Reference

https://www.postgresql.org/download/linux/redhat/ --> This site will provide steps to install in different distro's.

Notes

1. "template0" is called pristine.

Questions

1. what command initialize a PostgresSQL database cluster? initdb
2. which role is automatically created during PostgresSQL installation ? postgres
3. what is the purpose of template0 in PostgresSQL ? Pristine , unmodified template.
4. which PostgresSQL template database is used as the default for creating new databases ? template1
5. how to connect PostgresSQL interactive terminal ? psql
6. List all databases ? \l
7. Architecture of PostgresSQL ? Client Server

• Its nothing but " Bulk Loader Utility ".
• With this concept we can load the data to the table in bulk.
• Main word is LOAD.
• Then comes to your mind , what is the difference between load and insert ? Insert happens one by one.Load happens in one go.
• what data ? which table ? loading script ? Execute --> these are the four things YOU NEED TO KEEP IN MIND.

• Flat files --> csv ( comma separated value ) , txt , dat , excel , etc.
• Always use notepad to load the data.

select employee_id || ',' || first_name || ',' || salary from employees_table where rownum <= 10 ; --> this will fetch only 10 rows.

• save this file in a folder as csv.

select employee_id || ',' || first_name || ',' || salary from employees_table where employee_id between 150 and 170 ; --> this will fetch rows between those values.

• Save this file as txt.

Now coming to table creation

create table sample(id number , name varchar2(25) , salary number);

Now coming to creation of script

• loading script or control file both are same.

load data infile 'path_of_the_file.csv'
infile 'path_of_the_file.txt'
insert into table sample
fields terminated by ','
(id,name,salary)

• create the script and save as ALL FILES ( notepad ) with .ctl file.

Now coming to Execute

sqlldr hr_schema_name/password control='file_location_of_control_file_or_execution_file' direct = true

• here why direct=true --> it will load very fast and it will by-pass all constraints and triggers.
• if direct=false --> constraints and triggers it will check and then it execute.

• In short ,

Excluding one column

• If you some column should not be loaded , then use FILLER.

load data infile 'path_of_the_file.csv'
infile 'path_of_the_file.txt'
insert into table sample
fields terminated by ','
(id,name,salary filler)

load data infile 'path_of_the_file.csv'
infile 'path_of_the_file.txt'
insert into table sample
fields terminated by ','
(id,name filler,salary)

• In above example , salary and name will be empty . It won't load the data.

Condition

• WHEN --> loading data should obey the condition which you give. If the condition fails , then it stores the failed data in DISCARD FILE.
• If there is Oracle error , then it gets captured in BAD FILE.

• WHEN condition should be used here,

load data infile 'path_of_the_file.csv'
infile 'path_of_the_file.txt'
insert into table sample when ?
fields terminated by ','
(id,name filler,salary)

How to get the process summary ?

• It will be stored in log file.
• you can set all the files in the command itself , like below.

sqlldr hr_schema_name/password control='file_location_of_control_file_or_execution_file' log = summary.log bad = sample.bad discard = sample.dsc direct = true

• If you are giving any file name here , then it will generate automatically.
• So Import take here is ,

skip

• If you want to skip the rows while loading , then you can specify in the command itself.

sqlldr hr_schema_name/password control='file_location_of_control_file_or_execution_file' skip = 2 direct = true

• 2 rows will be skipped.

Notes

• SQL loader short key word is sqlldr.
• insert into table sample --> this will work only when the table is EMPTY. If you try to execute again , then it throw below error.

so you can use ,

load data infile 'path_of_the_file.csv'
infile 'path_of_the_file.txt'
append into table sample
fields terminated by ','
(id,name,salary)

• Also you use truncate ( it will delete old data and insert new data again )

load data infile 'path_of_the_file.csv'
infile 'path_of_the_file.txt'
truncate into table sample
fields terminated by ','
(id,name,salary)

Task

1. For a particular column instead of (,) separated it's used as (#) - how to load ?
2. how to load the excel file ?

• Network --> communications between devices.
• IP Address --> unique identifier to each device which is internet protocol address.

IPv4

1. 4th of version of Internet protocol.
2. 32 bit
3. Totally 4 blocks with 8 bit segments each. A , B , C & D.
4. 2 types of IP address.
5. Public ( Mainly using internet routing ) & Private ( Office )
6. Range --> 0 to 255
7. 0 & 255 reserved by system.
8. 127 --> loop-back address. 253 address we can use.
9. Then how to find whether its public or private ? By classes.
10. A, B , C --> Commonly used.
11. D & E --> Multi-casting & Research purpose.
12. Class A --> 0 to 127 Public , Private 10 is only used eg., 10.0.0.1 ( 16 million hosts can be declared )
13. Class B --> 128 to 191 Public , Private 172 is only used eg., 172.16.0.1 to 171.16.255.254 ( 65,536 hosts can be declared ) - Med size networks.
14. Class C --> 192 to 223 Public , Private 192.168.1.1 small network for 254 hosts.
15. Class D --> 224 to 239 for multicast groups.
16. Class E --> 240 - 255 for research purpose.

As a whole , the private range is .

A --> 10.0.0.1
B --> 172.16.0.0
C --> 192.168.0.0

Subnetting

• Slashing the network.

Virtual Network in Azure

• Software based network connects virtual machines.

Subnet in Azure

• Subdivison of VNET.
• we can organise the resources within a network.
• Features as follows ,

Azure Portal

All service >> Networking >> Virtual Networks >> Create

• Gave a wrong IP , then you can see a prompt is coming.

• VNET & Subnet creation

Notes

1. DNS , DHCP & Gateway , 255 Broadcast --> 4 IP's are reserved.

• Install Oracle Virtual Box , Winscip & Putty.
• Load the lab.
• Change the network setting from NAT to Bridged Adapter.

• Click ON & OFF its like restart.
• IP which is assigned 192.168.1.104.
• Assign any IP from 192.168.1.(0 to 255) , so I have assigned as 192.168.1.104. This IP taken from IPv4 in laptop.
• Open Terminal in the screen by right click.

• Ping Google and check whether its working or not.

• Now you can login with your IP which is assigned.

• Now we need to understand the concept of SHARED FOLDER.
• You can share the SOFTWARES to the VM from laptop folder , no need to use WINSCP. Lets explore.

• Lets create directories and unzip the software.

mkdir -p /u01/app/oracle/product/19.0.0.0/dbhome_1
unzip /media/sf_Software/V982063-01-001.zip -d /u01/app/oracle/product/19.0.0.0/dbhome_1

Install all RPM required for DB installation

• Once you install this RPM , oracle user will be created automatically.

• we don't know the password of ORACLE user , now set it.

• password is oracle and user : oracle
• Now run the installer.
• Before that execute xhost + --> Received error , its mainly used to set the DISPLAY.

• Getting error while installing the runinstaller .

• May be because of LOGIN root user. Lets try with new session with ORACLE user.

• Login with VM machine to avoid the DISPLAY issue.

Now lets create Database

• Password is ORACLE

• DB installation is completed.
• How many Oracle Softwares are installed in the servers ? How to check ? oraInventory file will help to do this.

• Now comes the question , how to find the Inventory location ?

• How many databases are created in the server , if this file is changes , complete database may corrupt.

• How many are running in this server , that is the DB server ?

ps -ef|grep pmon
ps -ef|grep smon

• How to start the DB ?

• As I have faced issue with SID , changed completly to new SID and started the server.

Notes

• Oracle Home / Oracle Software / Database Software / Database Home --> All these are same.
• How many Oracle Softwares are installed in the servers ? How to check ? oraInventory file will help to do this.

• Now comes the question , how to find the Inventory location ?

• How many databases are created in the server , if this file is changes , complete database may corrupt.

• How many are running in this server , that is the DB server ?

ps -ef|grep pmon
ps -ef|grep smon

Error & Solution

https://superuser.com/questions/1755254/virtualbox-guest-additions-update-got-error-missing-selinux-target-policy-file

Linux Commands Used

yum install oracle* --skip-broken 
yum -y install oracle-database-ee-19c
yum -y install oracle-database-ee-21c
# groupadd dba
# groupadd oinstall 
# useradd -g oinstall -G oinstall,dba oracle
#chown -R oracle:oinstall /u01

cd /u01/app/oracle/product/19.0.0.0/dbhome_1 --> Tool used to install Oracle Home / Database Home?
./runInstaller
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/bin --> Tool used to create database?
./dbca

cat /u01/app/oraInventory/ContentsXML/inventory.xml
cat /etc/oraInst.loc
cat /etc/oratab
ps -ef|grep smon
ps -ef|grep pmon
su - oracle
. oraenv
env |grep ORA
sqlplus / as sysdba
passwd oracle
xhost +

Sorry GUYS its WINDOWS

• Run as Administrator

Error & Solution

• This is working
  https://stackoverflow.com/questions/78013258/unable-to-launch-jdeveloper-for-missing-msvcr100-dll

• Also try to install this,
  https://learn.microsoft.com/en-gb/cpp/windows/latest-supported-vc-redist?view=msvc-170#latest-microsoft-visual-c-redistributable-version

Notes :

1. If its windows installation then always install via ADMIN user.
2. If you want to set JAVA , do the below but most of the cases its not required.
3. Many issues with Java download , the JDK should have JRE also . Please check after installation of Java.
4. It may take some time please wait patiently.

Null Functions

• nvl
• nvl2
• nullif
• coalease

select 'NULL',null,'',' ' from dual;

• Only 2 & 3 output are the NULL values.

nvl

• if the value is NULL then print the value in the right hand side value.
• Only two arguments are passed. ( Input , what to replace )

select nvl('',0) from dual;
select nvl(NULL,0) , nvl(NULL , 'A') from dual;

• As the left side argument is NOT null then it prints the same value.

nvl2

• 3 arguments.
• ( 'infosys' , 2 , 'B') --> If the first argument is NULL then 3rd arguments will be printed or else second argument will be printed.

select nvl2('A',0,4) from dual;
select nvl2('',0,4) from dual;

nullif

• two arguments
• both should be NULL.

select nullif(1,7) , nullif('aa','aa') from dual;
select nullif(1,7) , nvl(nullif('aa','aa'),'A') from dual;

coalesce

• only one row.
• It prints first NOT NULL Value.
• It accepts n no of arguments, no limit.

select NULL, NULL , 30 , 40 , NULL from dual;
select coalesce(NULL, NULL , 30 , 40 , NULL) from dual;

Conversion Function

• to_char
• to_number
• to_date
• to_timestamp

to_char

select sysdate from dual ;
select to_char(sysdate,'DAY'),to_char(sysdate,'day'),to_char(sysdate,'Day'),to_char(sysdate,'D'),to_char(sysdate,'DD') from dual ;

--select sysdate from dual ;
select to_char(sysdate,'DAY'),to_char(sysdate,'day'),to_char(sysdate,'Day'),to_char(sysdate,'D'),to_char(sysdate,'DD') from dual ;
select to_char(sysdate,'MONTH'),to_char(sysdate,'MONTH'),to_char(sysdate,'Month'),to_char(sysdate,'MM') from dual ;


select to_char(sysdate,'YEAR'),to_char(sysdate,'Year'),to_char(sysdate,'yyyy'),to_char(sysdate,'yy') from dual ;

select to_char(sysdate,'IW'),to_char(sysdate,'W'),to_char(sysdate,'Q') from dual ;

To Number

--select '123' , 123 , to_number('123') from dual ; - how to check its converted to number ?
select '123' , 123 , reverse (to_number('123')) from dual ;

to_date

select '2024/12/24' , to_date('2024/12/24', 'yyyy/mm/dd') from dual ;
select to_date('24-DEC-24', 'MON-YYYY-DD') from dual ; --> Error
select to_date('DEC-2024-24', 'MON-YYYY-DD') from dual ;


to_timestamp

select TO_TIMESTAMP('DEC-2024-24 16:24:00', 'MON-YYYY-DD HH24:MI:SS') from dual ;

Note :

• Anything which is given within single quotes is always STRING.
• Joins , sub query , group functions , Analytics Functions & Set Operators are very import in SQL.
• what is Index , global temp table , Objects , views , sequence ( why we use ? )
• Reverse function will work only for STRING not for Numbers.
• what is the dataype of NULL ? Its NULL only.
• select sysdate , systimestamp from dual; --> Check this

• In SQL plus it will be different :

• RDBMS language.
• Its ANSI --> standard language for operational relational databases.
• Efficient , easy to learn and use.
• Functionally complete.

How SQL Works

• Data Sublanguage.
• works with logical level.
• common language for all relational databases.

SQL Statement types

• Data Manipulation Language DML

• Data Definition Language DDL

• Data Control Language DCL

• Transaction Control Language TCL

Oracle SQL Development Environments

• Below are the Tools used for SQL:
• Oracle SQL Developer --> debug , export , view reports ,etc
• SQL Plus --> Batch query tool.
• Oracle JDeveloper --> Multi-platform tool for web services.
• Oracle Application Express --> Like a web browser.

Oracle SQL Developer

Concept on RDMS ( Relational Database Management Systems )

• Relational Database --> Collection of relations or two-dimensional tables controlled by server processes.
• Before entering RDMS , What is Data Model ?
• Entity Relationship Model --> its business specifications.
• Then Modelling conventions --> its called Entity Relationship Modelling conventions.

• Relating Multiple Tables --> 1. Each row is unique by primary key 2. Logically a foreign key can be related with multiple tables.

HR Schema Model

SQL Statement

• Not case sensitive.
• one line or more lines.
• keywords can't be across lines or it can't be abbreviated.
• Clauses used in separate lines , what is clause here ? The main clauses are SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, INSERT, UPDATE, DELETE, and JOIN. [ TBD ]
• We can use indents so that one have better enhanced readability.

• dualis a table created by Oracle Database and its owned by SYS.
• dual as one column called DUMMY( data type VARCHAR (1)) and contains one row with value x.
• we can use to compute some expressions.

select * from dual;
select sysdate from dual;

Arithmetic Expression

• +
• "-"
• *
• /

• It reads from LEFT to RIGHT. L--->R

• You can see the difference after using Parenthesis.

select first_name,2*(salary+300), 2*salary+300 from hr.employees;

• NULL--> what is the value of it ? its like unavailable , unassigned , unknown or inapplicable.
• NULLis not as same as ZERO or BLANK SPACE.

Column Aliases

• Rename the column headings
• Column followed by AS.
• without AS also you can declare.

• In the column name , it becomes CAPS. To avoid this you can use "" for AS like below,

-- select first_name AS name , last_name as father_name from hr.employees;
select first_name AS "name" , last_name as "father_name" from hr.employees;
select first_name first  , last_name last  from hr.employees;

Concatenation Operators

• To link the column or character strings to other column.
• ||

select first_name||last_name AS "name"  from hr.employees;

Literal Character Strings

• Its a character , number or a date included in the select statement.
• Date & character should be enclosed with single quotation marks.
• Each character string is the output of each row.

select first_name || ' of ' || last_name OUTPUT from hr.employees;

Alternate Quote Operator

• we can use own quotation mark delimiter.
• specified with 'q'.
• To increase the readability.

select department_name || q'[ Departments Name is :]' || manager_id "Department and Manager" from hr.departments ;
select department_name || 'Departments Name is :' || manager_id "Department and Manager" from hr.departments ;

DISTINCT Keyword

• default select query will display all rows irrespective of duplicate rows.
• To eliminate the duplicate we can use DISTINCT keyword.

-- select department_id from hr.employees ;
select distinct department_id from hr.employees ;

DESCRIBE Command

• Its not a KEYWORD.
• To display table structure.
• Alternatively we can see in SQL developer in the column Tabs.

ORACLE QUESTIONS FOR CLEARING THE LEARNING EXAM

General Functions

• case
• decode

case

• its for condition.
• Relation and logical operators will be used when implementing CONDITIONS.
• It needs to have END word while finishing.

-- select first_name , salary , salary*10/100 from hr.employees; 10 % increment but we need only > 10000 ? how to do ?
-- select first_name , salary , CASE WHEN SALARY > 10000 THEN salary*10/100 END from hr.employees;
select first_name , salary , CASE WHEN SALARY > 10000 AND FIRST_NAME LIKE 'A%' THEN salary*10/100 END from hr.employees;

decode

• NO Relation or logical operators will be used when implementing CONDITIONS.
• decode ( input , p1 , p1 , p2 , p2 )
• Read two two.

• select decode (1,2,4,1,0) from dual;

என்னுடைய input வந்து 1 , now read two by two , the next inputs. ‘1’க்கு அடுத்தது ரெண்டு ரெண்டா படிங்க . இதுல input வந்து ஒன்று , என்னுடைய input ‘2’டா இருந்ததுன்னா 4 என்று print பண்ணனும் but our input is ‘1’.
என்னுடைய input ‘1’ இருந்ததுன்னா 0 என்று print பண்ணனும் but our input is ‘1’
So answer is 0.

• select decode (1,2,4,8,0,5) from dual; --> here 5 is else part.

• Now you will get data for all , because you have given else part in the query.

-- select first_name , salary , CASE WHEN SALARY > 10000 AND FIRST_NAME LIKE 'A%' THEN salary*10/100 END from hr.employees;
select first_name , salary , decode ( salary , 24000 , salary*10/100 , 17000 , salary*10/100 ) from hr.employees;

select first_name , salary , decode ( salary , 24000 , salary*10/100 , 17000 , salary*10/100 , salary*5/100 ) from hr.employees; --> Else is implemented.

select first_name , salary , CASE WHEN SALARY > 10000 THEN salary*10/100 
    WHEN SALARY < 10000 THEN salary*9/100 
    ELSE salary*5/100
    END AS BONUS from hr.employees;

-- select first_name , salary , COMMISSION_PCT , CASE WHEN COMMISSION_PCT IS NULL THEN 1.5 END from hr.employees;
select first_name , salary , CASE WHEN COMMISSION_PCT IS NULL THEN 1.5 ELSE COMMISSION_PCT END AS COMMISSION_PCT from hr.employees;

select FIRST_NAME , Hire_date , to_char (Hire_date,'day') from hr.employees;

• To_char used to convert.

Notes:

1. 19c and 23c --> Oracle
2. what is normalisation ?
3. Performance tuning ?
4. how to delete the duplicate ?
5. case is faster than decode , both are general functions .
6. D --> Day

Number Function

• Round
• Trunc
• Mod
• Ceil
• Floor
• Abs
• Sign

Round

• If there is number => 5 after the decimal point , it will round off to the next number otherwise it will remain the same.

select round(67.34) from dual;
select round(67.49) from dual;
select round(67.57) from dual;

Trunc

• It wont see any number after decimal.
• Trunc is used only with the NUMBERS.
• Lets do one more operation with trunc --> trunc(56.89898,2) means it will take the two digit after the decimal.

select trunc(67.7846434) from dual;
select trunc(67.10001) from dual;
select trunc(67.011234) from dual;

select sysdate from dual; --> it will display time also
select trunc(sysdate) from dual;

Mod

• It will give the remainder.

select mod(10,7) from dual;
select mod(61,10) from dual;
select mod(6,2) from dual;

Ceil

• It will go to the next number, whatever may the number.

select ceil(67.7846434) from dual;
select ceil(67.00001) from dual;
select ceil(67.011234) from dual;

Floor

• It will crop the decimal.
• Then what is the use of Trunc ? In trunc we can use, how many decimal can be included. Hope you remember.

select floor(67.7846434) from dual;
select floor(67.00001) from dual;
select floor(67.011234) from dual;

select floor(67.7846434),trunc(67.7846434,1) from dual;
select floor(67.00001),trunc(67.00001) from dual;
select floor(67.011234) , trunc(67.011234,0) from dual;

Abs

• Only + & - are allowed.
• It will remove the sign.
• There is one more function similar to this sign i.e SIGN, it will give 1 & -1.

select abs(67.7846434), abs(-67.7846434), abs(10-15), sign(-10) , sign(+67.89) from dual;

Date Function

• add_months
• months_between
• next_day
• last_day

add_months

• if you want to add MONTHS then this function is used.

select sysdate, sysdate+2 , sysdate+20 , sysdate-10 from dual; -- Days increases
select sysdate from dual;
select add_months(sysdate,1) from dual;
select add_months('01-DEC-2024',1) from dual;
select add_months(sysdate,-1) from dual; -- months increases

select * from hr.employees where hire_date < add_months(sysdate,-276) -- hired before 23 years , 276 is the month

months_between

• Displays the no of months , sometime it will give in negative number that means subtraction happens between months Jan is 1 and Dec is 12.
• Even the date will be considered.

-- select months_between((01-01-20024), (01-12-2024)) from dual;
-- select months_between((01-jan-2024), (01-dec-2024)) from dual;
select months_between(('01-JAN-2024'), ('01-DEC-2024')) , months_between(('01-DEC-2024'), ('01-jan-2024')) from dual;
select months_between(('17-JAN-2024'), ('01-DEC-2024')) , months_between(('01-DEC-2024'), ('25-jan-2024')) from dual;

• If you don't like the decimal , what you can use ? For sure I forgot . Can't remember very quickly . After reading my notes , found its "TRUNC or FLOOR".
• Find my age ? How ?

select months_between(('01-DEC-2024'), ('01-DEC-1989'))/12 from dual;
select months_between(('01-DEC-2024'), ('01-DEC-1989'))/12 AS AGE from dual;

next_day

• Also will order you can specify.
• Sunday --> 1 , Saturday --> 7

select sysdate from dual ;
select next_day(sysdate,'sunday') from dual;
select next_day(sysdate,1) from dual;

last_day

• To find the last day of the month.

select last_day(sysdate) from dual;
select last_day('01-feb-2024') from dual;

General

• greatest
• least
• distinct
• unique
• case
• decode
• concat
• ||

Greatest

select 12,67,98,90,100 from dual;
select greatest(12,67,98,90,100) , least (12,67,98,90,100) from dual;

Least

select 12,67,98,90,100 from dual;
select greatest(12,67,98,90,100) , least (12,67,98,90,100) from dual;

Distinct & Unique

• It will check the duplicate.
• Both will be same .

select unique FIRST_NAME , last_name from hr.employees;
select distinct FIRST_NAME , last_name from hr.employees;

Concat & ||

select concat(concat(FIRST_NAME,LAST_NAME),salary) from hr.employees;
select FIRST_NAME || LAST_NAME ||' '|| salary from hr.employees;

Note

1. In the Date function --> only months_between --> it returns number.

Single Row Function

• 7 types
• Case Manipulation Function : upper , lower & Initcap
• Character Manipulation : Instr , Substr , Length , Replace , Reverse , Translate , Trim , Ltrim , Rtrim , Lpad & Rpad.
• Number
• Date Function
• General Function
• Null
• Conversion

Initcap

• First letter in caps

> -- select * from HR.COUNTRIES;
> -- select * from HR.COUNTRIES where COUNTRY_NAME='BRAZIL'
> -- select * from HR.COUNTRIES where COUNTRY_NAME=Initcap('BRAZIL')
> -- select *, UPPER(COUNTRY_NAME) from HR.COUNTRIES where COUNTRY_NAME=Initcap('BRAZIL')
> -- select HR.COUNTRIES.*, UPPER(COUNTRY_NAME) from HR.COUNTRIES where COUNTRY_NAME=Initcap('BRAZIL')
> -- select HR.COUNTRIES.*, UPPER(COUNTRY_NAME) AS COUNTRY from HR.COUNTRIES where COUNTRY_NAME=Initcap('BRAZIL')
> select C.*, UPPER(COUNTRY_NAME) AS COUNTRY from HR.COUNTRIES C where COUNTRY_NAME=Initcap('BRAZIL')

Instr

• Tells the number of the Position.
• To find Letter position.
• Number as Output.
• Number wont change when to count from front or reverse.
• 1 -- > Front
• -1 --> Reverse
• Last one in the bracket is *OCCURRENCE *.
• instr(letter, which one you need , front or reverse , occurrence )

-- select 'APPLEE' FROM dual;
-- select INSTR('APPLEE','P',1,1) FROM dual;
select INSTR('APPLEE','P',1,2) FROM dual;
select INSTR('APPLEE','P',-1,2) FROM dual;

Substr

• Character as output.
• substr ( 'letter' , start , how many character/letter u need to be displayed )
• substr ( 'letter', 2 ) --> it will print all letters after 2.
• '-' reverse.

select substr('APPLEE',3,2) FROM dual;
select substr('APPLEE',-3,2) FROM dual;

Length

• To find the length of the character.
• For NULL there is no length.
• Space will be considered.

-- select length('brettlee') from dual;
-- select DEPARTMENT_NAME, length(DEPARTMENT_NAME) as no_of_letters from hr.DEPARTMENTS;
select '',length(''),length(null) from dual;
select '',length(' '),length(null) from dual;

Reverse

• Numbers,it won't accept for reverse function.

Replace

• replace the word.
• replace('word','exact_word','replace_with_this');
• If the second argument is not present in the first then replace won't work.
• word to word we need to use 'Replace'.
• character/letter to character/letter use 'Translator'.

-- select replace('hcl technology','technology',techno) from dual;
-- select replace('hcl technology','technology','techno') from dual;
-- select replace('hcl technology','soft','techno') from dual;
-- select replace('hcl technology','technology') from dual;
select translate('hcl','hl','ts') from dual;

Trim

• space can be trimmed.

Lpad

• to add.
• To add in both sides that's the task.

-- select lpad((rpad('infosys','9','&')),'11','&') from dual;
select rpad(lpad('INFOSYS',length('INFOSYS')+2,'*') ,length(lpad('INFOSYS',length('INFOSYS')+2,'**'))+2,'*') from dual;

Notes

• dual is a dummy table
• always single quotes for string.
• Data in the table is sensitive --> always remember.
• Query you can write in any format but data is sensitive.
• Can we put , after * ? Yes , you need to put the table name in the * then there wont be error.
• AS is the column name or alternate name.
• AS can be used only in the select column.
• AS can't be used for table.
• Alias name won't be saved in database.
• Alias = Alternate Name
• String = Group of letters

nmcli - NetworkManager Command Line Interface

• The nmcli utility can be used by both users and scripts for controlling NetworkManager.
• nmcli is a command-line tool which is used for controlling NetworkManager.
• nmcli command can also be used to display network device status, create, edit, activate/deactivate, and delete network connections.

List of commands

nmcli general status

nmcli connection

nmcli connection modify <name> i<tab>

• Once modified & then bring the nmcli UP.
• nmcli connection modify "name" ipv4.addresses 192.12.123.10/10 ipv4.gateway 192.12.123.254 ipv4.dns 192.12.123.254
• Now bring it UP.

nmcli connection up "<name>"

Notes

• Nameserver is also referred as DNS.
• Give the tab always so that option appears , its like what is next command or word.
• IP address , Netmask , Gateway & Nameserver.
• How to assign number after "/" in the IP address --> TBD

Virtual Machine

Physical servers , Virtual Machine & Containers.

Manual and Dynamic allocation can be done in Virtual Machine.
Type 1 : Its like Enterprise --> In Azure , OCI , etc this concept is used.
Type 2: Mostly which we are using eg., laptop.

• Containers is a concept.
• Docker uses containerisation concept.
• Docker Engine is like Kitchen .
• Docker File is like notes for recipe.
• Sambar recipe for all i.e Docker Image . One cup for each person i.e Docker Container.
• Pantry --> Docker Registry --> all images are available.
• Chef --> Docker Daemon --> It will be running continuously.
• Docker Network and Volumes --> Its Dinning Area.

docker        --> To check whether docker is installed or not.
docker images --> List all the images which are present.
docker pull hello-world ( if no version is provided then it will take the latest version only )

docker pull hello-world:nanoserver-1809

Now run the image so that a container will be created ,

docker run hello-world

Check the container list,

docker ps -a
( only ps will show the running container )

To delete the container,

docker rm -f <container-id>

Sites or URL

https://hub.docker.com/r/tensorflow/tensorflow/tags

Notes

1. Image ID will be same for all.
2. Container ID will be created each time which will be a new number.
3. While running any image without version , then it will take the latest one only.
4. If latest image is not there in the server then it will pull and then run the image. So use latest wisely.

Interview Questions

1. What is VM ? A software emulation of a physical computer.
2. What does hypervisor do in a virtualisation ? It allows VM to run on a physical host by managing their resources.
3. What is Docker primarily used for ? Containerising applications to ensure portability.
4. Advantage of using containers ? Containers are portable & can run across different environments.
5. which type of hypervisor runs directly on Physical hardware ? Type - 1.
6. Difference btw VM & Container ? Containers share the host OS , while VM have their won OS.

Need to know

VMware ESXi
vCenter - Server Management Software - vCenter
VMware Workstation

Application Programming Interface

• Its like server/Waiter in a HOTEL refers to API.
• Interface--> Allow control of interaction with obstruction --> API is for Programmers.

• Client & Server --> Can be any language.
• All web application will have API.

1. SOAP-API --> Simple Object Access Protocol --> Function/Method needs to be written so that one can call it . Its like a WRAPPER.
2. REST-API --> REPRESENTATIONAL STATE TRANSFER --> If you know the concept of REST then everyone will write the same.

• CURL ( cURL ) --> Command line CLIENT for testing and developing API.
• Postman ( its a Graphical version based ) --> its a company now. 1 year we can use it for FREE.

Continue with REST

• Method ( GET , POST , PUT/PATCH , DELETE )
• Address / Endpoint (URL)
• Path

• Query/Search Parameters --> Starts with ? followed by KEY & VALUE.
• Authorization
• Header & Body
• Request Body can be sent via JSON Data types, which is default.
• Response --> 200 OK or 404 Not found or 201 created along with Headers and body.
• Layered --> It will have all configured LB & everything.

Why REST is popular ?

1. Simple & Standardised --> Everyone will use the same method to use.
2. Scalable & Stateles. Eg., It wont store anything. Each time it request as fresh request.
3. High Performance & Caching.

CRUD

Continue with REST

• https://api.github.com/users/
• users --> it will be mostly plural , followed by SINGULAR --> username.
• https://jsonplaceholder.typicode.com/todos

• https://jsonplaceholder.typicode.com/todos/1

import requests
api_url = "https://jsonplaceholder.typicode.com/todos/1"
response = requests.get(api_url)
print(response)
response.json()
print(response.json())

All Request

import requests
api_url = "https://jsonplaceholder.typicode.com/todos/"
response = requests.get(api_url)
print(response)
response.json()
print(response.json())

Print in proper format or PrettyPrint

Post method

• For this API , the best example is BANKING with website & Mobile APP. ( Why ? In internet banking you will pass all values and its the DB then gets the response which is obvious BUT think of the APP in your mobile which is lite weight app which will use API calls to DB and does the same operations )

• Web Scraping --> you can get only DATA but you can't update or modify. Each website we need to write different web scraping code. EACH WEBSITE WILL HAVE DIFFERENT CONTROL.

• ? & key = value & key = value

• Now with KEY ,

Important Links

• https://realpython.com/api-integration-in-python/
• https://jsonplaceholder.typicode.com/ --> API playground.
• Free open API for weather --> https://open-meteo.com/ --> curl "https://api.open-meteo.com/v1/forecast?latitude=52.52&longitude=13.41&current=temperature_2m,wind_speed_10m&hourly=temperature_2m,relative_humidity_2m,wind_speed_10m"
• https://tamilpesu.us/en/number/ --> https://tamilpesu.us/en/number/
• https://www.slideshare.net/slideshow/an-introduction-to-rest-api/76492672
• https://speakerdeck.com/cli4d/introduction-to-rest-apis
• https://www.slideshare.net/slideshow/what-is-rest-api-rest-api-concepts-and-examples-edureka/174179563
• https://jiminbyun.medium.com/building-python-scripts-for-rest-api-calls-a-practical-guide-2-9-3ac9ca1d701a
• https://github.com/vinta/awesome-python ( Important Site )

Important Notes

• ''' ... ''' --> Commenting multiple lines.
• pprint --> its like making JSON beautification , for this we need to use " import pprint ".
• curl -X GET https://jsonplaceholder.typicode.com/todos/1
• curl -X POST -d {"userID":101} https://jsonplaceholder.typicode.com/posts
• What is BROWSER automation for sites ?
• Try this and get the output --> https://www.instructables.com/Get-Weather-Data-Using-Python-and-Openweather-API/
• All social media platform expose their service with API.
• Try this also --> http://tamilpesu.us/number/34?type=IN --> website --> https://tamilpesu.us/en/number/
• POSTMAN --> good platform with UI, mostly used.
• https://en.wikipedia.org/api/rest_v1/ --> wikiepedia rest api
• md --> Markdown
• Super Market Example :-) You need to search each and everything, we wont get it immediately. https://github.com/vinta/awesome-python --> this as many codes , so search one by one.

Reference

https://www.youtube.com/watch?v=HW9E4TYoYXU&list=PLiutOxBS1Mizte0ehfMrRKHSIQcCImwHL&index=38

** ACCEPT THE SLOWNESS **

OUTPUT REDIRECTION

Any command in Linux will have 3 data streams ,

1. STDIN --> 0
2. STDOUT --> 1
3. STDERR --> 2

These numbers are called DESCRIPTOR.

>--> Redirection to a file.
>> --> Upend to the last line.
2> --> This will get the error.
2>> --> Upend the error.
&> --> Both output & error will be stored in the file.

PIPE SYMBOL or PIPE REDIRECTION

• First command output is the input to the second command.

• cat file1 | less --> Its like Booklet ( so ENTER ENTER --> it will turn like a page , Down arrow and Up arrow )

• cat file1 | more

PATTERN MATCHING or CLOBBING

• * ? [] ! {}
• touch file{a..z}
• touch file{1..100}
• touch file{11,12,17}
• ls -l file[abcd] --> exact match pattern
• ls -l !(file) --> list files which is not having any name with file. Its just exclude.
• To remove all files in one command rm -r file*
• ls -l ??? --> Single character matching
• ls -l ?file --> Character matching
• ls -l file?
• ls -l /var/log/???

VI

• sudo yum install vim
• :set number
• dd --> delete
• copy & past --> yy & c
• cut & past --> dd & c
• 3 & dd --> it will delete 3 lines from the cursor
• shift + g --> Last line
• :1 --> it will go to the first line

• Patching is in-place NOT Upgrade.
• Oracle release Quarterly Patches

• Base software's( GI Software's & Oracle Software's ) can be downloaded in Oracle Site.
• Patches can be downloaded from Support Site and also it needs a license.
• Patches are applied on top of GI Home & Oracle Home.
• What these Patches contains ?

• Where to check what patches are applied ?
  /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lspatches
  29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
  29517242;Database Release Update : 19.3.0.0.190416 (29517242)
  OPatch succeeded.

• ASM Home

/u01/app/19.0.0.0/grid/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)

• DB Home

/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

• 19.3.0.0.190416 --> 190416 --> 2019 - April - Date.
• Second digit is RU. i.e 19.3
• RU will be increasing 19.2,19.4 etc
• Here : 19.3 is the base release. --> GI Home and ASM Home.
• These are cumulative patches --> all patches are not to be applied one by one , you can jump to any patches.

Overview plan

How to download & Patch details ?

• Search like below, Critical Patch Update (CPU) Program Jan/Apr/Jul/Oct 2023 Patch Availability Document (DB-only)
• Section 3 which is for Oracle Database.
• 3.1.7 --> 3.1.7.3 which is 19c
• GI Patch will contain DB patch also.
• Now go to the READ ME file and check the table 1-2 which will say how many sub patches need to be applied.

OPatch Tool

• We need to patch 3 home ,
• GI Home
• DB Home

• Database Home

• All these home will be patched via OPatch Tool.

Best Practice

• SDLC ( DEV --> UAT --> PROD )
• Don't rollback of any previous patches.
• Check the conflict check for all the patches using below command, ( repeat for all 5 patches or sub patches )

/u01/app/19.0.0.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/19.17/34416665/33575402 -oh /u01/app/19.0.0.0/grid

/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/19.17/34416665/34419443 -oh /u01/app/oracle/product/19.0.0.0/dbhome_1

OPatch Patch

• 6880880 version.
• Upgrade can be done by downloading.

Steps to apply patch

DB Home patching steps

1) Stop DB Home as root user
2) grant permission on patch directory as root user
3) As oracle user do prechks 
Do OPatch version and current lspatches checks
Conflict pre checks:    
System space prechk:
4) Apply Patch:
5) Post verification
6) Start ORACLE_HOME as root user

GI Home patching steps

• Stop the GI home as root user, which means its a HAS --> Standalone.

1) Stop GI Home as root user
2) Unlock the GI Home as root user
3) grant permission patch directory as root user
4) As grid/oracle user do prechks 
Do OPatch version and current lspatches checks
Conflict pre checks:    
System space prechk:
5) Apply Patch:
6) Post verification
7) Lock and start GI 

Prechecks

- backup GI Home --> tar -cvzf grid.tar.gz grid ( cd /u01/app/19.0.0.0/ )
- backup Oracle Home --> tar -cvzf dbhome_1.tar.gz dbhome_1 ( cd /u01/app/oracle/product/19.0.0.0 )

• System space check

/u01/app/19.0.0.0/grid/OPatch/opatch prereq CheckSystemSpace -phBaseDir /u01/patches/19.17/34416665/33575402 -oh /u01/app/19.0.0.0/grid

/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch prereq CheckSystemSpace -phBaseDir /u01/patches/19.17/34416665/34419443 -oh /u01/app/oracle/product/19.0.0.0/dbhome_1

• df -h /u01/app/oracle/product/19.0.0.0/dbhome_1/

Patching

/u01/app/19.0.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0.0/grid -local -silent /u01/patches/19.17/34416665/34419443

/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0.0/dbhome_1 -local -silent /u01/patches/19.17/34416665/34419443

• silent --> default is YES , don't wait for command.

Important Notes

• Don't download patches until you have license , it may be fine as they are unauthorised to download.
• List of patches terms used in Oracle :

https://docs.oracle.com/cd/E24628_01/doc.121/e39376/glossary.htm#BGBCGDDF

Users

1. SYS--> DBA Role + SYSDBA Role ( Startup / Maintenance activity ) --> Super Master User
2. SYSTEM--> DBA Role --> Master users
3. 30 to 35 users will be created in default. desc dba_users; Mostly all will be locked and expired.

• Any users created , DBA will assign System Level Privileges & Object Level Privileges.
• what are all the System Level Privileges ( activities performed at DB side ) ? CREATE SESSION , CREATE TABLE.
• When a user tries to read the data of other user , then object level privilege comes into picture.
• Object Level Privileges --> enables users to access and change data's in the object.

• These System level privileges comes along with ADMIN option.
• These Object level privileges comes along with GRANT option.

grant CREATE SESSION to user1 with ADMIN OPTION; --> which very risky. Because this user can give access to any user.

grant select on USER2.T2 to user1 with GRANT option; --> which very risky. Because this user can give select access to any user.

• If we want to revoke the admin option (System level privileges) for the user which you have given then it will revoke only for that user , it won't revoke for other users. If the user as given access to other friends . So Manually you need to check in the audit and then manually you need to remove the access.

• If we want to revoke the Grant option (Object level privileges) , then it will revoke for that user and also for other user which is granted.

Roles

• Create a role and assign the privileges to the role. Why ? If new users comes in and DBA can't provide privilege for each users who is coming.

create roles ROLE1;
grant select on HR.Employees to ROLE1;
grant select on HR.Regions to ROLE1;
grant select on HR.Locations to ROLE1;
grant ROLE1 to user1;
grant ROLE1 to user2; --> these are new users joining
grant ROLE1 to user3; --> these are new users joining

one more on this ROLE

grant select on HR.JOBS to user1;
.
.
grant select on HR.JOBS to user100;

rather than the above one , we can provide to roles because roles are already assigned to user1,user2,user3

grant select on HR.JOBS to ROLE1;

Profiles & Quotas

• Quotas --> the space usage

• profiles --> we can further more restrictions like the CPU usage a user can use & how much logical reads & password complexity.

desc dba_profiles;

• 20 to 30 resources will be listed down in each profile.

• any user you create "DEFAULT" profile will be associated with the user.

desc dba_users;

• what are the resources ? Each resources you can specify.

create custom profile for users

• Like for DEVELOPERS, DBA's , app users .

• Grant the profile to user1.

Alter user user1 profile dummy;
select username, acccount_status, profile from dba_users where username = 'user1';

• You can increase the complexity for creating the user slowly after getting the knowledge like below :

• Even you can modify using alter user too ,

alter user user1 profile dummy;
alter user user1 quota 2g on users;
alter user user1 default tablespace test1;

Notes

1. sqlplus / as sysdba or sqlplus sys/password as sysdba
2. sqlplus system/password ( no need of any role )

Above both the users are used to perform DB and maintenance activities .

• DBSNMP user mostly used for OEM.
• "---------------------" this is 100 characters , just restrict to 40 letters/characters like " col PROFILE for a40; --> for is format.

Command

show user
set pages 1000 lines 1000
col username for a20 --> for is format
/ --> last command will be executed
grant CREATE SESSION to user1;
grant CREATE TABLE to user1;
create table T1 (SLNO number(10))
insert into T1 value (1);
alter user user1 quota unlimited on USERS; & then commit ;--> UNLIMITED space is allocated.
grant select on USER2.T2 to user1;
grant insert on USER2.T2 to user1;
grant delete on USER2.T2 to user1;

select * FROM DBA_SYS_PRIVS where grantee in ('USER1');
select * FROM DBA_TAB_PRIVS where grantee in ('USER1');
select * FROM DBA_ROLE_PRIVS where grantee in ('USER1');

sqlplus sys/password@service_name as sysdba; --> remote authentication
sqlplus / as sysdba; --> OS authentication

grant sysdba to user1;
grant dba to user1; --> dba is role

• DBA is a role --> system level , object level , roles.

Issues

• Insufficient privilege
• user lacks CREATE SESSION privilege-
• Above two errors are related to missing " System Level Privileges " for the users.
• no insert privilege on tablespace --> assign some quota so that we can assign some values to it.
• Quota exceeds limit.
• Account is locked & timed

Questions

1. What are all the privileges user can have ? System level , Object level & roles.
2. List all the privileges owned by user1 ?
3. List all the privileges owned by user1 & grant some privilege to user2?
4. Create user5 & assign all privilege of user1 ?
5. duplicate user1 as user5 with all privileges ?
6. what is composite limit in the profile ?

• Listener --> server side configuration file --> listener.ora
• TNSnames --> Client side configuration file --> tnsnames.ora

listener.ora

• it contains port.
• on which port the database is listening.
• protocol --> TCP ( on which protocol its running )
• hostname or IP address
• All these can assigned to Listener name, so that we can start and stop the listener ( Alias Name )
• location --> TNS admin ? --> network configuration location.
• This network location will be in $ORACLE_HOME/network/admin
• Listener Base --> Listener related logs will go here, its like a base directory.
• lsnrctl --> listener Control

lsnrctl start name_of_the_listener
lsnrctl status name_of_the_listener

• Change the listener port , now the scenario will be like --> Listener is running in 1522 but the LREG takes the details of DB and then search for 1521 port. Even if you wait for 60 secs it wont happen . So your Listener will never get the update of DB details. " The Listener supports no service " --> That means Listener doesn't have any DB details.
• show parameter local_listener;
• alter system set local_listener = ' ( Address = ... ) ' ;
• Now my LREG is aware where my listener is running.

Static Registration

• Static registration with SID OR Service name.
• Forcing the listener to register the DB details ( don't worry about the status of the DB , but just register )
• UNKNOWN is the static registration.
• What is the purpose of registering with Static registration ? --> Its used in Data Guard Build for online mode is one of the use case.

tnsnames.ora

• Its a client side configuration file.
• The client may connect from any application.
• Inside the file we need : Port , protocol , hostname or IP address , service name ( name of the DB will be equal to service name , most of the time )
• All these 4 details are required.
• The client will connect with these parameters along with username and password. -Each time all these details to be passed , to avoid this , Oracle came up with ALIAS NAME in the tnsnames.ora file which is inside the network admin file.

sqlnet.ora

• Both server and client side file.
• It can be used for many purposes.
• If there is any miss-match in version at any side , client or server side , at that time this HERO will come into picture. OR at TDE / Wallet usage.
• In simple terms , its used in : ( search in internet "sqlnet.ora" )

lower client version
wallet location
AD/LDAP
Connect Timeout ( Client to server connectivity )
40 or > 40 parameters can be defined.

NOTE

1. Oracle_home will be more or less like --> /u01/app/oracle/product/19.0.0.1/dbhome_1
2. Listener supports no service.
3. For every 60 secs these pmon goes to listener and registers its details. what details ? DB details . This is as per 11g.
4. LREG in 12c --> Listener register , every 60 secs it registers the DB details with the LISTENER. This registration happens only when the DB is running with 1521 PORT.
5. Listener is a dynamic parameter.
6. What is UNKNOWN ? when we check the listener status ? [TBD] --> Ready or Unknown. READY --> Dynamic Registration , UNKNOWN --> Static Registration --> we have the DB details in the listener configuration file and forcing the listener to register the DB details and don't worry about the DB status.

Commands

su - oracle
. oraenv
env | grep ORA
ps -ef|grep tns
ps -ef|grep lreg
sqlplus / as sysdba
telnet host 1521
netstats -anp | grep 1521
ps -ef|grep smon
startup
sqlplus user/password
sqlplus user/password@"(DESCRIPTION ...)
select instance_name from v$instance;
show user;
sqlplus user/password@alias_name;

Issues

1. Firewall Issues.
2. Listener may be wrong.
3. Port may be wrong.
4. Listener may be down.

Questions

1. Can we setup a secured listener ? This can be done at the Protocol parameter.
2. what is the difference between SID or service name ?
3. TNS_ADMIN --> location of the network configuration files.
4. What are the network configuration files ?

listener.ora
tnsnames.ora
sqlnet.ora

1. Client software's like Oracle Client download , netca , netmgr , OEM , JDBC , ODBC , toad app , sql developer , linux , windows etc

1. Backup & Recovery software's --> rubrik , Tivoli Storage Manager database - IBM.

Reference

https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html

https://www.oracle.com/in/database/technologies/instant-client/downloads.html

• Format in next line

• Do you need "quotation marks" when printing numbers? --> No

• Multiplication

• How do you print the value of a variable name which is set to “Syed Jafer” or Your name?

• How do you print the variables name, age, and city with labels “Name:”, “Age:”, and “City:”?

• How do you concatenate and print the strings greeting (“Hello”) and target (“world”) with a space between them?

• How do you print three lines of text with the strings “Line1”, “Line2”, and “Line3” on separate lines?

• How do you print the string He said, "Hello, world!" including the double quotes?

• How do you print the string C:\Users\Name without escaping the backslashes?

• How do you print the string “Hello” followed by a space, and then print “world!” on the same line?

• How do you print the value of a boolean variable is_active which is set to True?

TBD

• How do you print the string “Hello ” three times in a row?

• How do you print the sentence The temperature is 22.5 degrees Celsius. using the variable temperature?

• How do you print the value of pi (3.14159) rounded to two decimal places in the format The value of pi is approximately 3.14?

• How do you print the words “left” and “right” with “left” left-aligned and “right” right-aligned within a width of 10 characters each?

with open ( " file.txt " , "w" ) as f;
print ( file is to open " , file=f)

• prints only blank line.
• to determine joints element with as " it will join ".

Print()

• This is a function.
• Whatever you declare inside the print , it will be printed.
• Any number strings can be given inside.

Eg.,

• If there is a function then you can send n number of parameters.
• what is parameter here ? (a & b are the parameter ,its an example)

• sep ---> separator
• default value of sep is space , so you can see a space in the above screenshot result.

• printing to next line

• horizontal tab

String concatination

• 2 objects.
• what is objects ? CAR --> maruti , volvo ( these are objects )

End function

• when a sentence ends we can use that.
• Eg.,

Escape sequence

• see properly , these are used inside the double quotes.

Raw string

• slashes gets changed in windows , at that time you can use this.
• it will print whatever you give inside.
• see carefully the examples , the slash is missing in the first output so we are using "r".

Type Casting

• Trying to change the type of it so that it will work.

• Changed it.

Printing quotes inside the string

Triple quotes / Multi Line Strings

• it will print as its.
• eg.,

String Multiplication

Format

• variable assigment.
• Object & Methods.
• Object will have many methods.
• get all methods for the object , by using below.

• I used type casting here, but the usage of this will not be coding method but its not wrong.

• Using method we can get the output.

• Its taking care the typecasting on its own.

• Using positioning or indexing we can pass the value.

F string format

Notes

• In print statement we are using both numeric & also string --> the output will always be STRING. So in a nutshell , anything which is coming out of print statement is STRING.
• In other words , return type of print function is STRING.
• String will always be in double quotes.

Notable Questions

Reference

https://www.youtube.com/watch?v=zr3skBHzbAI

• Database --> Its a software to store data in a structured way.

• SQL --> Structure Query Language - Its a language used to store data in database.

• RDBMS --> Its management software used to connect the data database.

Now coming to MYSQL : Its a RDBMS software , Free software under GPL.

• It as server and client.
• MYSQL Client --> Front end Tool / Console Prompt in windows / Shell prompt, we type the command here.
• MYSQL Server --> Will take the command from client and execute in server , which we can't see.It just gives the result.

Things MYSQL client does ,

1. Authentication for password check.
2. SQL queries will be changed to tokens , that tokens will be given to MYSQL server.
3. To monitor the Encrypt and compress network.
4. Then it gets the response from server and displays to the front end tool.

Things MYSQL Server does ,

1. Gets the request from client and then sends the response . _Management Layer & Storage Engine _ are responsible for this. ( Memory , Disk & Network are interconnected to these layer mentioned above )

Management Layer

Gets the request from client and கீழ இருக்கிற எல்லா வேலையும் பண்ணும் ,

1. connection decrypt or encode.
2. Queries check and parse them.
3. Get the Catched queries from Query cache
4. Then it sends to Storage Engine.
5. Disk and memory logs are its responsibility.

Storage Engine Layer

1. Database, tables , indexes are taken care here or managing.
2. Above related logs are taken care.
3. It also sends data to other MYSQL servers via network is also done.

INSTALLATION

sudo apt-get install mysql-server mysql-client

sudo mysql_secure_installation

Gave y & 0

In short , remove the anonymous user , only root can be executed only in localhost & remove the test database.

CONFIGURATION

cat /etc/mysql/my.cnf --> எல்லா configurationனும் இங்க தான் இருக்கும். OR /etc/mysql/mysql.conf.d/mysqld.cnf

create a backup file of the configuration like below,

sudo cp my.cnf my.cnf_bk_june172024 [ TBD , change in the config location ? ]

port = 3306
user = mysql
data dir = /var/lib/mysql
bind-address = 127.0.0.1
log_error = /var/log/mysql/error.log

[ Parameters to be seen ]

Query Cache [ TBD , where to put these values ? ]

All the queries which are executed in MYSQL Server , results are stored in cache.

query_cache_limit = 1m
query_cache_size = 16m

m --> MB
This m can be raised or decreased depends on the RAM.

Server Stop & Start

sudo service mysql restart
sudo service mysql stop
sudo service mysql start

MYSQL Client Installation

There are many in market,

sudo apt-get install MySQL-workbench --> second mostly used
sudo apt-get install MySQL-navigator
sudo apt-get install emma
sudo apt-get install MySQL-admin
sudo apt install phpmyadmin -y --> Best in market --> 1st

Notes :

1. GPL --> General Public License.
2. RDBMS --> Relational Database Management System
3. Control + l --> Top of the screen in Linux
4. Note , if any changes in my.cnf MYSQL server needs to be restarted.
5. Configuration file is in /etc/mysql/mysql.conf.d/mysqld.cnf
6. sudo find / -name "*.cnf"
7. https://www.tecmint.com/mysql-gui-tools-for-linux/

Reference

https://freetamilebooks.com/download/%e0%ae%8e%e0%ae%b3%e0%ae%bf%e0%ae%af-%e0%ae%a4%e0%ae%ae%e0%ae%bf%e0%ae%b4%e0%ae%bf%e0%ae%b2%e0%af%8d-mysql-a4-pdf/?tmstv=1712985924

https://kaniyam.com/ebooks/

• Redirection meanings What ? Changing something.
• Instead of putting the output to the screen instead redirect to the file.
• ">" redirect and over write
• ">>" will always append.

#!/bin/bash
read -p "Enter ur name: " name
echo " Welcome to BOMBAY $name !!"

Also , you can choose which line needs to , go to the file.

#!/bin/bash
read -p "Enter ur name: " name 
echo " Welcome to BOMBAY $name !!" > log.txt
echo " Vanakam THozha " >> log.txt
echo " -- EOL -- "

/dev/null

• it will make it as NULL
• it will work only for the regular consoles.

1 --> console output ( By default it works only for standard console output ) eg., > or >>
2 --> Error

nohup

• script will run in background.
• the process will run behind us and it won't show in the console.
• it creates nohup.out
• & --> run it in the background.

#!/bin/bash
num=1
while [0]
do 
    echo "Number is $num"
    num = `expr $num + 1`
done

nohup file.sh 2>&1 &

Capturing

• back ticks var = ls | wc -l ``or
• $(command) var = $( ls | wc -l )

Both will return the value.

• One problem with backtick is " it wont support nested parameters ".

so use $()

DDL --> Alter , truncate , Create , rename , drop --> These will auto -commit.
DCL --> Grant , Revoke
DML --> No instruction , same as SQL.
Transaction Control Language --> Commit , rollback.

What is VARIABLE ? Its like a BOX , according to size I can vary the size of it.Also USED TO STORE DATA TEMPORARILY.
It can be changed so its called as VARIABLE.
If its constant , at the beginning , IT CAN'T BE CHANGED.

begin
.
.
end:
/

--> This is called execution block / PLSQL block / anonymous block or unnamed block.

PLSQL program can be stored in OBJECT, This is called STORED PROCEDURE.

If you want to store any data in PLSQL then only way is VARIABLE. If you know this then you are the master of it.

I WANT TO STORE DATE ? How ?

declare
d date; -- declaration
begin
dbms_output.put_line(d); 
d := sysdate; -- definition
dbms_output.put_line(d);
d := d+10; -- value of variable changes here
dbms_output.put_line(d);
end;
/

:= --> Assignment operator

declare
d date;
begin
dbms_output.put_line(d); 
d := 'Oracle';
dbms_output.put_line(d);
d := d+10; 
dbms_output.put_line(d);
end;
/

Issue/Error : non-numeric character found where numeric is expected.

declare
d varchar2(3);
begin
dbms_output.put_line(d); 
d := 'Oracle';
dbms_output.put_line(d);
d := d+10; 
dbms_output.put_line(d);
end;
/

Issue/Error : Character string buffer too small

declare
d varchar2(10);
begin
dbms_output.put_line(d); 
d := 'RHEL'; -- no error here
dbms_output.put_line(d);
d := d+10;  -- error here 
dbms_output.put_line(d);
end;
/

Issue/Error : string + 10 --> character to number conversion error

declare
d varchar2(10);
begin
dbms_output.put_line(nvl(d,0)); 
d := 'RHEL'; 
dbms_output.put_line(d);
d := 'Linux';  
dbms_output.put_line(d);
end;
/

To check NULL ?

declare
d varchar2(10);
begin
dbms_output.put_line(d); 
d := 'RHEL'; 
dbms_output.put_line(d);
d := 'Linux';  
dbms_output.put_line(d);
end;
/

Can I use the same variable again ? Is it possible ?

declare
d varchar2(10);
d numbers;
begin
dbms_output.put_line(d); 
d := 'RHEL'; 
dbms_output.put_line(d);
d := 'Linux';  
dbms_output.put_line(d);
end;
/

Error / Issue : at most one declaration for D is permitted

Declared but not used ? Will it throw error ?

declare
d varchar2(10);
e numbers;
begin
dbms_output.put_line(d); 
d := 'RHEL'; 
dbms_output.put_line(d);
d := 'Linux';  
dbms_output.put_line(d);
end;
/

Error / Issue : NO ERROR WILL BE THROWN

Lets debug yesterday class :

declare
a departements%rowtype;
begin
select * into a from departments where rownum=1;
dbms_output.put_line(a.departement_name);
end;
/

declare
a departements%rowtype;
begin
select * into a from departments where rownum=1;
dbms_output.put_line(a.departement_name ||''|| a.location_id);
end;
/

Using the Column Data type and store in Variable :

declare
b locations.city%type;
begin
select city into b from locations where rownum=1;
dbms_output.put_line(b);
end;
/

Multiple column values :

declare
v1 employees.first_name%type;
v2 employees.salary%type;
v3 employees.hire_date%type;
begin
select first_name,salary,hire_date into v1,v2,v3 from employees where employee_id= 120;
dbms_output.put_line(v1||''||v2||''||v3);
end;
/

Multiple column values to ONE Value :

• record.( grouping of customized datatype )

declare
type v is record ( v1 employees.first_name%type , v2 employees.salary%type , v3 employees.hire_date%type ) ;
v4 v;
begin
select first_name,salary,hire_date into v4 from employees where employee_id= 120;
dbms_output.put_line(v4.v1||''||v4.v2||''||v4.v3);
end;
/

How to enter the value in screen ?

declare
type v is record ( v1 employees.first_name%type , v2 employees.salary%type , v3 employees.hire_date%type ) ;
v4 v;
begin
select first_name,salary,hire_date into v4 from employees where employee_id= **_&id_**;
dbms_output.put_line(v4.v1||''||v4.v2||''||v4.v3);
end;
/

IT WILL ASK FOR THE PEOPLE TO ENTER THE VALUE

NOTES:

1. Select query can be saved in Views.
2. cl scr
3. Single quotes --> it will consider as string.
4. set serveroutput on --> dbms output option will be enabled in sql
5. / --> last statement will be executed in sql
6. 1 variable = 1 value only can be store , if you wnat to store means we need to use COLLECTION.
7. Predefined datatype will store only 1 value to the variable.
8. UDT --> User Defined Type --> collection
9. nvl ???
10. If you handle VARIABLE , you are a programmer man.
11. How many variables can be declared ? Any count ? --> Nothing like that.
12. rownum = 1 ??? It will give one row.
13. Why we are writing always select query with one row output ? because variable will store only one value.
14. Prompt --> substitution variable --> &id --> shift+7
15. set verify off --> it won't display any data in the screen.
16. %type , %rowtype , %recordtype --> these are called Anchored types

Procedural Language Structured Query Language

Why we need PLSQL ?

In short it reduces the network traffic. How ?

1. Delete
2. Insert
3. Select

These each query will provide feedback from when its get executed each time like " 1 row inserted " , " 1 row deleted " all these REPLY is nothing but FEEDBACK.
This is called NETWORK TRAFFIC , if it happens 100 times means think about the TRAFFIC.
So if you write in PLSQL then it will give a feedback " ONLY 1 REPLY OR FEEDBACK ".

sql --> 100 statement = 100 feedback ;
plsql --> 100 statement = 1 feedback ;

Its also called EXTENSION TO SQL.

begin
.
.
end;
/

Print statement in PLSQL --> dbms_output.put_line('Hi'); --> this is called DBMS output --> Printing statement --> Case INSENSITIVE LANGUAGE.

begin
dbms_output.put_line('Hi');
dbms_output.put_line(123);
dbms_OUTPUT.put_Line(123);
DBMS_OUTPUT.put_Line(123);
end;
/

Below one will throw error ,

begin
end;
/

Below is basic block for PLSQL ,

begin
null;
end;
/

DCL commands --> Grant , Revoke --> Rule is there in PLSQL
DCL command can't be used directly within the procedure , as mentioned earlier , we need to use " KEY WORDS BEFORE THAT " followed by SINGLE QUOTES.
execute immediate 'grant ....'
These key words are called " Dynamic SQL "

begin
execute immediate 'grant select on t1 to user2';
end;
/

DDL ( Create , Alter , rename , drop ) also needs to be executed with keywords ONLY.

DRL

• Select statement
• INTO CLAUSE needs to be used.
• Here comes another hero , Variable --> Temporary space
• Variables needs to be declared with Data types.Eg., C EMPLOYEE%ROWTYPE; Syntax --> Variable_Name TABLENAME%DATATYPE.
• Also each variable will store only 1 row.
• Collection --> Day 1 we can't learn now :-)

DECLARE
C EMPLOYEE%ROWTYPE;
BEGIN
SELECT * INTO C FROM EMPLOYEE WHERE ID=100;
DBMS_OUTPUT.PUT_LINE(C.COLUMN1||C.COLUMN2);
END;
/

DBMS_OUTPUT.PUT_LINE(C.COLUMN1||C.COLUMN2); If you needs space means add single quotes like this --> DBMS_OUTPUT.PUT_LINE(C.COLUMN1||' '||C.COLUMN2);

Notes :

1. -- --> comment.
2. DCL & DDL uses keywords.
3. If you use "Select Statement" then all these error's are expected --> no data found , exact fetch issue , into clause is expected in select statement.
4. DBMS output accepts only ONE arguments or columns .
5. end statement of sql is ";".
6. end statement of plsql is "/".

DESIGNER

1. Target and Source Metadata.
2. Here import from DB

MODELS

• New Model Folder
• Give any name , like Oracle i.e whatever the name you want.
• After giving the name you wont see anything while you expand.

• Now create new model ,

• Metadata taken from ORACLE DB here scott schema.
• Map the Logical schema name here.
• Write the description so that you will understand in future, why this Designer is created.

Reverse Engineering

• Types of object to reverse engineering.

Selective Reverse Engineering

• Difference between New Datastores & Existing Datastores. ( if you want to reimport the table again which the reverse engineering is done , that time you can enable the EXISTING DATASTORE )
• Click the Reverse Engineering here.

• See the difference carefully for " New Datastores & Existing Datastores "

• It will overwrite the existing one , but here is the super question . If my table as 5 columns at first --> reverse engineering is done --> There is some update in the table where the column is reduced to 4 --> if I click the reverse engineering what will happen ? ANSWER is --> It will replace completely . Can I create multiple copies here ?

• Create the Model for the target too like below.

PROJECTS

• New Projects --> Give any name.
• Once created , you will see

First Folder - Variables - Sequences - User Functions - Knowledge Module - Markers

• You can even create NEW FOLDERS also.
• Goto the MAPPINGS --> New Mappings --> Mapping Name.
• What is CREATE EMPTY DATASET ? It will create a EMPTY PANEL to drag and drop the source and target.
• Drag and drop the TARGET & SOURCE from the MODEL.

KNOWLEDGE MODULES

• Once the Target and Source are drag and dropped , now go to the KM.

• Select the KM.
• Here , Oracle to Oracle won't be there , so select SQL TO SQL as Oracle supports SQL.
• What is LKM & RKM , IKM ?

MAPPING

• Map the Source to Target in the Logical panel.

• Now goto PHYSICAL,source and target will be visible.
• Once you click the Default in the Target , select the LKM.
• LKM will create a TEMP table.
• FALSE means it will keep the TEMP date. Tell me will it consume more space in the target ?

• Keep an EYE ON THE INDEXES , if you need enable it.

• If the TARGET doesn't have the table , then enable this below options.

• Validate the mapping.
• RUN the Project.

• What is SIMULATION here ?
• Below option should be disabled , ( this is an option in the Oracle DB )

• Once the execution completed , go to Operation Tab.

OPERATION

• You can view the execution.

• Constrains --> Unique / Foreign keys.
• You can create NEW TASK also here , in future if you want to add.

QUESTIONS

1. What is LKM & IKM ?

REPOSITORY

1. WORK
2. MASTER

• Work is always attached to Master. one to one relation.
• Master to work is One to Many.

Agent --> Once the Job needs to be executed , this agent will go from the Designer to Scheduler by the agent , and agent will ask details of the job from the Repo ( get the META DATA ) and then give to the Operator.

STUDIO PANEL

1. Designer
2. Operator
3. Security
4. Topology

STUDIO

TOPOLOGY

Physical Architecture

1. How the Work Repository gets created at first ?
2. JDBC connection is made to connect the Master and Work Repo.
3. 40+ Technologies are used to get the Meta Data / Schema Eg. Oracle DB , File , etc
4. If I have Oracle DB , then in TOPOLOGY add the the DB - here always referred to DATASERVER.
5. For Eg., SOURCE & TARGET SCOTT --> This is the Table --> which as DATA --> connect in the DATARERVER in TOPOGOLY ( Physical Architecture )
6. Data Server always as replacement for Target or Source.
7. Once loaded , create a PHYSICAL SCHEMA.
8. In Physical Schema , what is the difference between Schema and Work Schema ? Is it like Individual Schema you are trying to connect is referred as SCHEMA ? where this is WORK SCHEMA stored ?
9. Data Server is nothing but YOU ARE SAYING , you have been connected to one ORACLE DB.
10. WORK TABLE PREFIX --> this will help to identify where it failed and we can check the error in DB by using the PREFIX.
11. Why $ is specified in those ?
12. New Physical Schema is created under the DATASERVER.

CONTEXT

Logical Architecture

1. Click ORACLE , it will show only to create LOGICAL SCHEMA.
2. MAP the Logical Schema with the Physical Schema which is created against the GLOBAL CONTEXT. This Physical Schema name is " Complete Name " give to the PHYSICAL, not the schema and work schema.
3. Below SS will show the connection of Physical & Logical Relation.

Therefor , hereafter LOGICAL schema will be referred in the DESIGNER tab. NO NEED TO TOUCH PHYSICAL SCHEMA.

Questions

1. whether all PROD , DEV & UAT will have only one Master Repo?
2. W1 To M1 But W1 To M2 is not possible.

Important Commands

1. select * from v$instance; --> This will give the DB version.

Installation of Java

https://www.oracle.com/java/technologies/downloads/#java8

sudo update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/jdk1.8.0_401/bin/java" 1
sudo update-alternatives --set java /usr/lib/jvm/jdk1.8.0_401/bin/java
readlink -f $(which java)
java -version

export JAVA_HOME=/usr/lib/jvm/jdk1.8.0_401/bin/
export PATH=$JAVA_HOME/bin:$PATH

Installation of ODI

https://www.oracle.com/middleware/technologies/data-integrator-downloads.html#

/usr/lib/jvm/jdk1.8.0_401/bin/java -jar /media/sathishpy1808/Windows-SSD/ODI/softwares/fmw_12.2.1.4.0_odi.jar

Below is the installation done ,

Starting File Copy
Copying files for: oracle.fmwconfig.wls.shared 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.wls.shared.external 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.wls.external 12.2.1.4.0
Copying files for: oracle.nlsoramapping.jrf 19.3.0.0.0
Copying files for: oracle.nlsrtl.jrf 19.3.0.0.0
Copying files for: oracle.xdk.jrf.jaxp 12.2.1.4.0
Copying files for: oracle.rdbms.jrf 19.3.0.0.0
Copying files for: oracle.glcm.logging 1.6.4.0.0
Copying files for: oracle.glcm.comdev 7.8.4.0.0
Copying files for: oracle.glcm.dependency 1.8.4.0.0
Copying files for: oracle.glcm.xmldh 3.4.4.0.0
Copying files for: oracle.glcm.wizard 7.8.4.0.0
Copying files for: oracle.jse.dms 12.2.1.4.0
Copying files for: oracle.jrf.dms.common 12.2.1.4.0
Copying files for: oracle.thirdparty.maven 3.2.5.0.0
Copying files for: oracle.jrf.maven.plugins.sync 12.2.1.4.0
Copying files for: oracle.oamclient.core 12.2.1.4.0
Copying files for: oracle.oamclient.wls 12.2.1.4.0
Copying files for: oracle.odi.sdk 12.2.1.4.0
Copying files for: oracle.odi.agent 12.2.1.4.0
Copying files for: oracle.ant.contrib.ant.contrib.vb 1.0.0.0.3
Copying files for: oracle.bsf.bsf 2.4.0.0.0
Copying files for: oracle.cglib.cglib.nodep 3.2.5.0.0
Copying files for: oracle.com.fasterxml_classmate 1.3.1.0.0
Copying files for: oracle.com.fasterxml.jackson.core.jackson.annotations 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.core.jackson.core 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.core.jackson.databind 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.dataformat.jackson.dataformat.xml 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.base 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.json.provider 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.module.jackson.module.jaxb.annotations 2.9.9.0.0
Copying files for: oracle.com.fasterxml.jackson.module.jackson.module.jsonschema 2.9.9.0.0
Copying files for: oracle.com.fasterxml.woodstox.woodstox.core 5.2.0.0.0
Copying files for: oracle.com.google.guava.failureaccess 1.0.1.0.0
Copying files for: oracle.com.google.guava.guava 27.1.0.0.0
Copying files for: oracle.com.googlecode.owasp_java.html.sanitizer.owasp_java.html.sanitizer 20190325.1.0.0.0
Copying files for: oracle.com.ibm.jbatch.com.ibm.jbatch.container 1.0.3.0.0
Copying files for: oracle.com.ibm.jbatch.com.ibm.jbatch.spi 1.0.3.0.0
Copying files for: oracle.com.jayway.jsonpath.json.path 2.2.0.0.0
Copying files for: oracle.com.jcraft.jsch 0.1.54.0.0
Copying files for: oracle.com.jcraft.jsch.com.jcraft.jsch 0.1.53.0.0
Copying files for: oracle.com.jcraft.jzlib.com.jcraft.jzlib 1.0.7.0.0
Copying files for: oracle.com.miglayout.miglayout 4.0.0.0.0
Copying files for: oracle.com.trilead.trilead.ssh2.v_build 1.0.0.0.221
Copying files for: oracle.commons.cli.commons.cli 1.3.1.0.0
Copying files for: oracle.commons.codec.commons.codec 1.11.0.0.0
Copying files for: oracle.commons.discovery.commons.discovery 0.5.0.0.0
Copying files for: oracle.commons.fileupload.commons.fileupload 1.4.0.0.0
Copying files for: oracle.commons.httpclient.commons.httpclient 3.1.0.0.0
Copying files for: oracle.commons.io.commons.io 2.6.0.0.0
Copying files for: oracle.commons.lang.commons.lang 2.6.0.0.0
Copying files for: oracle.commons.logging.commons.logging 1.2.0.0.1
Copying files for: oracle.commons.net.commons.net 3.5.0.0.0
Copying files for: oracle.de.regnis.q.sequence.sequence.library 1.0.4.0.0
Copying files for: oracle.france.telecom.org.objectweb.asm.all 5.0.1.0.0
Copying files for: oracle.jdesktop.jxlayer 4.0.0.0.0
Copying files for: oracle.joda.time.joda.time 2.10.0.0.0
Copying files for: oracle.log4j.log4j 2.11.1.0.0
Copying files for: oracle.net.sourceforge.nekohtml.nekohtml 1.9.16.0.0
Copying files for: oracle.org.apache.ant.ant 1.9.8.0.0
Copying files for: oracle.org.apache.ant.ant.bundle 1.10.5.0.0
Copying files for: oracle.org.apache.ant.ant.launcher 1.9.8.0.0
Copying files for: oracle.org.apache.commons.commons.compress 1.9.0.0.0
Copying files for: oracle.org.apache.commons.commons.digester3 3.2.0.0.0
Copying files for: oracle.org.apache.commons.commons.lang3 3.8.1.0.0
Copying files for: oracle.org.apache.commons.commons.vfs2 2.2.0.0.0
Copying files for: oracle.org.apache.extras.beanshell.bsh.vb 2.0.0.0.6
Copying files for: oracle.org.apache.httpcomponents.httpclient 4.5.6.0.0
Copying files for: oracle.org.apache.httpcomponents.httpclient.cache 4.5.1.0.0
Copying files for: oracle.org.apache.httpcomponents.httpcore 4.4.10.0.0
Copying files for: oracle.org.apache.jakarta.commons.el 1.0.0.0.0
Copying files for: oracle.org.apache.ws.commons.schema_xmlschema 1.4.7.0.0
Copying files for: oracle.org.apache.xmlgraphics.batik.all 1.11.0.0.1
Copying files for: oracle.org.apache.xmlgraphics.batik.bundle 1.11.0.0.1
Copying files for: oracle.org.bouncycastle.bcpkix.jdk15on 1.60.0.0.0
Copying files for: oracle.org.bouncycastle.bcprov.ext.jdk15on 1.60.0.0.0
Copying files for: oracle.org.bouncycastle.bcprov.jdk15on 1.60.0.0.0
Copying files for: oracle.org.codehaus.groovy.groovy.all 2.5.6.0.0
Copying files for: oracle.org.codehaus.jackson.jackson.core.asl 1.9.13.0.0
Copying files for: oracle.org.codehaus.jackson.jackson.jaxrs 1.9.13.0.0
Copying files for: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.13.0.0
Copying files for: oracle.org.codehaus.jackson.jackson.xc 1.9.13.0.0
Copying files for: oracle.org.codehaus.woodstox.stax2.api 4.2.0.0.0
Copying files for: oracle.org.codehaus.woodstox.wstx.asl 3.2.9.0.0
Copying files for: oracle.org_dom4j_dom4j 2.1.1.0.0
Copying files for: oracle.org.eclipse.equinox.org.eclipse.equinox.common.vv 3.6.0.0.20100503
Copying files for: oracle.org.eclipse.jetty.jetty.jndi.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.plus.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jgit.org.eclipse.jgit.v_r 5.2.0.201812061821.0
Copying files for: oracle.org.eclipse.org.eclipse.osgi.singleton 3.9.1.0.0
Copying files for: oracle.org.hsqldb.hsqldb 2.4.1.0.0
Copying files for: oracle.org.jboss.logging.jboss.logging.vfinal 3.3.0.0.0
Copying files for: oracle.org.jfree.jfreechart 1.5.0.0.0
Copying files for: oracle.org.owasp.esapi.esapi 2.1.0.1.0
Copying files for: oracle.org.python.jython.standalone 2.7.1.0.1
Copying files for: oracle.org.slf4j.slf4j.api 1.7.26.0.0
Copying files for: oracle.org.slf4j.slf4j.simple 1.7.26.0.0
Copying files for: oracle.org.springframework.spring.aop.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.aspects.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.beans.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.context.indexer.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.context.support.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.context.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.core.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.expression.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.instrument.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.jcl.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.jdbc.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.jms.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.messaging.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.orm.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.oxm.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.test.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.tx.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.web.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.webflux.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.webmvc.vrelease 5.1.3.0.0
Copying files for: oracle.org.springframework.spring.websocket.vrelease 5.1.3.0.0
Copying files for: oracle.org.tmatesoft.sqljet.sqljet 1.1.12.0.0
Copying files for: oracle.org.tmatesoft.svnkit.svnkit 1.10.0.0.0
Copying files for: oracle.oro.oro 2.0.8.0.0
Copying files for: oracle.osgi.alliance.osgi.cmpn 4.2.0.200908310645.0
Copying files for: oracle.osgi.alliance.osgi.core 5.0.0.201203141902.0
Copying files for: oracle.xerces.xercesimpl 2.12.0.0.0
Copying files for: oracle.xml.apis.xml.apis.ext 1.3.04.0.0
Copying files for: oracle.org.antlr.antlr.runtime 4.1.0.0.0
Copying files for: oracle.wls.inst.only 12.2.1.4.0
Copying files for: oracle.wls.shared.with.inst 12.2.1.4.0
Copying files for: oracle.jrf.dms 12.2.1.4.0
Copying files for: oracle.bali.share 12.2.1.4.0
Copying files for: oracle.bali.jewt 12.2.1.4.0
Copying files for: oracle.bali.ice 12.2.1.4.0
Copying files for: oracle.help.share 12.2.1.4.0
Copying files for: oracle.help.ohj 12.2.1.4.0
Copying files for: oracle.fmw.common.wizard.resources 12.2.1.0.0
Copying files for: oracle.wls.security.core.sharedlib 12.2.1.4.0
Copying files for: oracle.wls.jrf.tenancy.ee.only.sharedlib 12.2.1.4.0
Copying files for: oracle.xdk.jrf.xmlparserv2 12.2.1.4.0
Copying files for: oracle.xdk.jrf.fmw 12.2.1.4.0
Copying files for: oracle.xdk.jrf 12.2.1.4.0
Copying files for: oracle.jrf.thirdparty.toplink 12.2.1.4.0
Copying files for: oracle.wls.thirdparty.javax.json 12.2.1.4.0
Copying files for: oracle.jrf.toplink 12.2.1.4.0
Copying files for: oracle.mysql 8.0.14.0.0
Copying files for: oracle.datadirect 12.2.1.4.0
Copying files for: oracle.rsa.crypto 12.2.1.4.0
Copying files for: oracle.pki 12.2.1.4.0
Copying files for: oracle.osdt.core 12.2.1.4.0
Copying files for: oracle.glcm.encryption 2.7.4.0.0
Copying files for: oracle.java.jaxws 12.2.1.4.0
Copying files for: oracle.java.xml.bind 2.3.0.0.0
Copying files for: oracle.java.activation 12.2.1.4.0
Copying files for: oracle.glcm.opatch.common.api 13.9.4.0.0
Copying files for: oracle.nginst.common 13.9.4.0.0
Copying files for: oracle.nginst.core 13.9.4.0.0
Copying files for: oracle.nginst.thirdparty 13.9.4.0.0
Copying files for: oracle.jaxb.tools 2.3.0.0.0
Copying files for: oracle.jaxb.impl 2.3.0.0.0
Copying files for: oracle.jaxb.core 2.3.0.0.0
Copying files for: oracle.toplink.coherence 12.2.1.4.0
Copying files for: oracle.toplink.dbwslib 12.2.1.4.0
Copying files for: oracle.toplink.doc 12.2.1.4.0
Copying files for: oracle.toplink.developer 12.2.1.4.0
Copying files for: oracle.wls.libraries 12.2.1.4.0
Copying files for: oracle.rcu.ciestb 12.2.1.4.0
Copying files for: oracle.commons.cli.commons.cli 1.2.0.0.0
Copying files for: oracle.javavm.jrf 19.3.0.0.0
Copying files for: oracle.coherence.discovery 12.2.1.4.0
Copying files for: oracle.coherence 12.2.1.4.0
Copying files for: oracle.jrf.adfrt.help 12.2.1.4.0
Copying files for: oracle.jrf.adfrt.batik 12.2.1.4.0
Copying files for: oracle.jrf.adfrt.javatools 12.2.1.4.0
Copying files for: oracle.swd.opatch 13.9.4.2.1
Copying files for: oracle.rda 19.3.19.8.2
Copying files for: oracle.wls.jrf.tenancy.common 12.2.1.4.0
Copying files for: oracle.as.install.common.help 12.2.1.4.0
Copying files for: oracle.as.install.common.prerequisite.files 12.2.1.4.0
Copying files for: oracle.as.install.ui.framework 12.2.1.4.0
Copying files for: org.codehaus.woodstox 4.2.0.0.0
Copying files for: oracle.webservices.orawsdl 12.2.1.4.0
Copying files for: oracle.http_client 12.2.1.4.0
Copying files for: oracle.webservices.base 12.2.1.4.0
Copying files for: oracle.as.install.odi 12.2.1.4.0
Copying files for: oracle.as.install.odi.prerequisite 12.2.1.4.0
Copying files for: oracle.org.codehaus.jackson.jackson.core.asl 1.9.11.0.0
Copying files for: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.11.0.0
Copying files for: com.bea.core.xml.xmlbeans 2.6.0.6.0
Copying files for: oracle.wls.security.core 12.2.1.4.0
Copying files for: oracle.wls.common.cam 12.2.1.4.0
Copying files for: oracle.wls.common.nodemanager 12.2.1.4.0
Copying files for: oracle.wls.common.cam.wlst 12.2.1.4.0
Copying files for: oracle.wls.shared.with.cam 12.2.1.4.0
Copying files for: oracle.webservices.wls 12.2.1.4.0
Copying files for: oracle.wls.shared.with.inst.sharedlib 12.2.1.4.0
Copying files for: oracle.wls.jrf.tenancy.common.sharedlib 12.2.1.4.0
Copying files for: oracle.wsm.common 12.2.1.4.0
Copying files for: oracle.wsm.agent.fmw 12.2.1.4.0
Copying files for: oracle.webservices.jrf 12.2.1.4.0
Copying files for: oracle.webservices.jaxrs.jrf 12.2.1.4.0
Copying files for: oracle.ide.usages.tracking 12.2.1.4.0
Copying files for: oracle.jrf.tenancy 12.2.1.4.0
Copying files for: oracle.jrf.tenancy.se 12.2.1.4.0
Copying files for: oracle.glcm.opatchauto.core 13.9.4.2.0
Copying files for: oracle.jrf.tenancy.ee 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.shared 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.config.shared 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.wls.help 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.wls.shared.internal 12.2.1.4.0
Copying files for: oracle.fmw.upgrade.fmwconfig 12.2.1.4.0
Copying files for: oracle.owasp.jrf 12.2.1.4.0
Copying files for: oracle.glcm.schema.version.registry 12.2.1.4.0
Copying files for: oracle.rcu.doc 12.2.1.4.0
Copying files for: oracle.sysman.rcu 12.2.1.4.0
Copying files for: oracle.common.rcu.config 12.2.1.4.0
Copying files for: oracle.wls.rcu 12.2.1.4.0
Copying files for: oracle.wls.core.app.server 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.cam.shared 12.2.1.4.0
Copying files for: oracle.rcu.shared 12.2.1.4.0
Copying files for: oracle.fmwconfig.wls 12.2.1.4.0
Copying files for: oracle.fmwconfig.common.wls.internal 12.2.1.4.0
Copying files for: oracle.odi.jse.template 12.2.1.4.0
Copying files for: oracle.wls.evaluation.database 12.2.1.4.0
Copying files for: oracle.velocity.velocity.v_dev 1.4.0.0.0
Copying files for: oracle.org.apache.httpcomponents.httpmime 4.5.1.0.0
Copying files for: oracle.fmwconfig.common.cam 12.2.1.4.0
Copying files for: oracle.rcu.opss 12.2.1.4.0
Copying files for: oracle.rcu.iau 12.2.1.4.0
Copying files for: oracle.java.servlet 12.2.1.4.0
Copying files for: oracle.jrf.adfrt 12.2.1.4.0
Copying files for: oracle.wls.shared.with.coh.standalone 12.2.1.4.0
Copying files for: oracle.wls.wlsportable.mod 12.2.1.4.0
Copying files for: oracle.wls.core.app.server.tier1nativelib 12.2.1.4.0
Copying files for: oracle.wls.clients 12.2.1.4.0
Copying files for: oracle.wls.cam.wlst 12.2.1.4.0
Copying files for: oracle.org_javassist_javassist.v_ga 3.20.0.0.0
Copying files for: oracle.org.eclipse.jetty.jetty.xml.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.webapp.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.util.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.servlet.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.server.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.security.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.io.vv 9.2.2.0.20140723
Copying files for: oracle.org.eclipse.jetty.jetty.http.vv 9.2.2.0.20140723
Copying files for: oracle.commons.io.commons.io 2.2.0.0.0
Copying files for: oracle.commons.collections.commons.collections 3.2.2.0.0
Copying files for: oracle.commons.cli.commons.cli 1.1.0.0.0
Copying files for: oracle.com.google.code.gson.gson 2.6.2.0.0
Copying files for: oracle.odi.tp 12.2.1.4.0
Copying files for: oracle.fmwplatform.fmwprov 12.2.1.4.0
Copying files for: oracle.fmwplatform.ocp 12.2.1.4.0
Copying files for: oracle.glcm.opatchauto.fmw 13.9.4.2.0
Copying files for: oracle.commons.beanutils.commons.beanutils 1.9.3.0.0
Copying files for: oracle.apache.commons.lang.mod 2.6.0.0.2
Copying files for: oracle.apache.commons.collections.mod 3.2.0.0.2
Copying files for: oracle.jersey 12.1.3.0.0
Copying files for: oracle.nlspdk 12.2.1.4.0
Copying files for: oracle.nlsgdk 12.2.1.4.0
Copying files for: oracle.jrf.j2ee 12.2.1.4.0
Copying files for: oracle.jrf.infra.common 12.2.1.4.0
Copying files for: oracle.jrf.thirdparty.jee 12.2.1.4.0
Copying files for: oracle.jrf.iau 12.2.1.4.0
Copying files for: oracle.ids.core 12.2.1.4.0
Copying files for: oracle.opss.core 12.2.1.4.0
Copying files for: oracle.jmx 12.2.1.4.0
Copying files for: oracle.jsp 12.2.1.4.0
Copying files for: oracle.legacy_oc4j_xml_schemas 12.2.1.4.0
Copying files for: oracle.rdbms.ras 12.1.0.2.0
Copying files for: oracle.opss.wls 12.2.1.4.0
Copying files for: oracle.fmw.upgrade 12.2.1.4.0
Copying files for: oracle.fmw.upgrade.help 12.2.1.4.0
Copying files for: oracle.ons.generic 12.2.1.4.0
Copying files for: oracle.diagnostics.common 12.2.1.4.0
Copying files for: oracle.wls.workshop.code.completion.support 12.2.1.4.0
Copying files for: oracle.wls.admin.console.en 12.2.1.4.0
Copying files for: oracle.wls.http.pubsub.server 12.2.1.4.0
Copying files for: oracle.wls.weblogic.sca 12.2.1.4.0
Copying files for: oracle.wls.admin.console.nonen 12.2.1.4.0
Copying files for: oracle.ide.vhv 12.2.1.4.0
Copying files for: oracle.ide.fcp 12.2.1.4.0
Copying files for: oracle.ide.help.extras 12.2.1.4.0
Copying files for: oracle.ide.modeler 12.2.1.4.0
Copying files for: oracle.ide.diagram 12.2.1.4.0
Copying files for: oracle.ide.xmlef 12.2.1.4.0
Copying files for: oracle.ide.java 12.2.1.4.0
Copying files for: oracle.org.antlr.antlr 4.1.0.0.0
Copying files for: oracle.ide.groovy 12.2.1.4.0
Copying files for: oracle.org.json.json 20131018.0.0.0.0
Copying files for: oracle.glcm.fmw.chghost 12.2.1.4.0
Copying files for: oracle.mds.dumputil 12.2.1.4.0
Copying files for: oracle.rcu.mds 12.2.1.4.0
Copying files for: oracle.rcu.ucs.messaging 12.2.1.3.0
Copying files for: oracle.wsm.console.core 12.2.1.4.0
Copying files for: oracle.jgroups 12.2.1.0.0
Copying files for: oracle.jsch 12.2.1.0.0
Copying files for: oracle.bali.ewt 12.2.1.4.0
Copying files for: oracle.pwdgen.jrf 12.2.1.4.0
Copying files for: oracle.jrf.infra.fmw.common 12.2.1.4.0
Copying files for: oracle.jrf.applcore 12.2.1.4.0
Copying files for: oracle.wsm.pmlib 12.2.1.4.0
Copying files for: oracle.wsm.jrf 12.2.1.4.0
Copying files for: oracle.ids.jrf 12.2.1.4.0
Copying files for: oracle.opss.jrf 12.2.1.4.0
Copying files for: oracle.osdt.jrf 12.2.1.4.0
Copying files for: oracle.sslconfig.jrf 12.2.1.4.0
Copying files for: oracle.ldap.jrf 12.2.1.4.0
Copying files for: oracle.sdp.messaging 12.2.1.3.0
Copying files for: oracle.help.ohw.rcf 12.2.1.4.0
Copying files for: oracle.help.ohw.share 12.2.1.4.0
Copying files for: oracle.help.ohw.uix 12.2.1.4.0
Copying files for: oracle.webcenter.wccore 12.2.1.4.0
Copying files for: oracle.bali.cabo 12.2.1.4.0
Copying files for: oracle.ide.rescat2 12.2.1.4.0
Copying files for: oracle.ide.db.connection 12.2.1.4.0
Copying files for: oracle.ide.webservice.analyzer 12.2.1.4.0
Copying files for: oracle.jrf.infra.fmw.wls 12.2.1.4.0
Copying files for: oracle.wsm.agent.wls 12.2.1.4.0
Copying files for: oracle.soa.all.client 12.2.1.4.0
Copying files for: oracle.sysman.fmw.core 12.2.1.4.0
Copying files for: oracle.sysman.fmw.as 12.2.1.4.0
Copying files for: oracle.sysman.fmw.agent 12.2.1.4.0
Copying files for: oracle.log4j.log4j 1.2.17.16.0
Copying files for: oracle.org.codehaus.groovy.groovy.all 2.4.17.0.0
Copying files for: oracle.odi.oggstudio 12.2.1.4.0
Copying files for: oracle.odi.studio 12.2.1.4.0
Copying files for: oracle.datadirect.odi 12.2.1.4.0
Copying files for: oracle.as.install.onlinedoc.shortcut 12.2.1.4.0
Copying files for: oracle.odi.km 12.2.1.4.0
Copying files for: oracle.as.customqna.jdkqna 12.2.1.4.0
File Copy Completed
Starting Creation of Libraries
Creating Libraries: glcm_common_lib
Creating Libraries: com.oracle.db.xdk-no-jaxp
Creating Libraries: ant-contrib.vb
Creating Libraries: cglib-nodep_3.2.5.0.0
Creating Libraries: com.oracle.db.xdb
Creating Libraries: cglib-nodep
Creating Libraries: bsf
Creating Libraries: ant-contrib.vb_1.0.0.0.3
Creating Libraries: classmate
Creating Libraries: classmate_1.3.1.0.0
Creating Libraries: com.oracle.db.nlsrtl
Creating Libraries: bsf_2.4.0.0.0
Creating Libraries: glcm_common_logging_lib
Creating Libraries: jackson-annotations_2.9.9.0.0
Creating Libraries: jackson-annotations
Creating Libraries: jackson-core_2.9.9.0.0
Creating Libraries: jackson-core
Creating Libraries: jackson-databind_2.9.9.0.0
Creating Libraries: jackson-databind
Creating Libraries: jackson-dataformat-xml_2.9.9.0.0
Creating Libraries: jackson-dataformat-xml
Creating Libraries: jackson-jaxrs-base_2.9.9.0.0
Creating Libraries: jackson-jaxrs-base
Creating Libraries: jackson-jaxrs-json-provider_2.9.9.0.0
Creating Libraries: jackson-jaxrs-json-provider
Creating Libraries: jackson-module-jaxb-annotations_2.9.9.0.0
Creating Libraries: jackson-module-jaxb-annotations
Creating Libraries: jackson-module-jsonschema_2.9.9.0.0
Creating Libraries: jackson-module-jsonschema
Creating Libraries: woodstox-core_5.2.0.0.0
Creating Libraries: woodstox-core
Creating Libraries: failureaccess_1.0.1.0.0
Creating Libraries: failureaccess
Creating Libraries: guava_27.1.0.0.0
Creating Libraries: guava
Creating Libraries: owasp-java-html-sanitizer_20190325.1.0.0.0
Creating Libraries: owasp-java-html-sanitizer
Creating Libraries: com.ibm.jbatch.container_1.0.3.0.0
Creating Libraries: com.ibm.jbatch.container
Creating Libraries: com.ibm.jbatch.spi_1.0.3.0.0
Creating Libraries: com.ibm.jbatch.spi
Creating Libraries: json-path_2.2.0.0.0
Creating Libraries: json-path
Creating Libraries: jsch_0.1.54.0.0
Creating Libraries: jsch
Creating Libraries: com.jcraft.jsch_0.1.53.0.0
Creating Libraries: com.jcraft.jsch
Creating Libraries: com.jcraft.jzlib_1.0.7.0.0
Creating Libraries: com.jcraft.jzlib
Creating Libraries: miglayout_4.0.0.0.0
Creating Libraries: miglayout
Creating Libraries: trilead-ssh2.v_build_1.0.0.0.221
Creating Libraries: trilead-ssh2.v_build
Creating Libraries: commons-cli_1.3.1.0.0
Creating Libraries: commons-cli
Creating Libraries: commons-codec_1.11.0.0.0
Creating Libraries: commons-codec
Creating Libraries: commons-discovery_0.5.0.0.0
Creating Libraries: commons-discovery
Creating Libraries: commons-fileupload_1.4.0.0.0
Creating Libraries: commons-fileupload
Creating Libraries: commons-httpclient_3.1.0.0.0
Creating Libraries: commons-httpclient
Creating Libraries: commons-io_2.6.0.0.0
Creating Libraries: commons-io
Creating Libraries: commons-lang_2.6.0.0.0
Creating Libraries: commons-lang
Creating Libraries: commons-logging_1.2.0.0.1
Creating Libraries: commons-logging
Creating Libraries: commons-net_3.5.0.0.0
Creating Libraries: commons-net
Creating Libraries: sequence-library_1.0.4.0.0
Creating Libraries: sequence-library
Creating Libraries: org.objectweb.asm.all_5.0.1.0.0
Creating Libraries: org.objectweb.asm.all
Creating Libraries: jxlayer_4.0.0.0.0
Creating Libraries: joda-time_2.10.0.0.0
Creating Libraries: jxlayer
Creating Libraries: joda-time
Creating Libraries: log4j_2.11.1.0.0
Creating Libraries: log4j
Creating Libraries: net.sourceforge.nekohtml.nekohtml_1.9.16.0.0
Creating Libraries: net.sourceforge.nekohtml.nekohtml
Creating Libraries: ant_1.9.8.0.0
Creating Libraries: ant
Creating Libraries: ant_bundle_1.10.5.0.0
Creating Libraries: ant_bundle
Creating Libraries: ant-launcher_1.9.8.0.0
Creating Libraries: ant-launcher
Creating Libraries: commons-compress_1.9.0.0.0
Creating Libraries: commons-compress
Creating Libraries: commons-digester3_3.2.0.0.0
Creating Libraries: commons-digester3
Creating Libraries: commons-lang3_3.8.1.0.0
Creating Libraries: commons-lang3
Creating Libraries: commons-vfs2_2.2.0.0.0
Creating Libraries: commons-vfs2
Creating Libraries: bsh.vb_2.0.0.0.6
Creating Libraries: bsh.vb
Creating Libraries: org.apache.httpcomponents.httpclient_4.5.6.0.0
Creating Libraries: org.apache.httpcomponents.httpclient
Creating Libraries: httpclient-cache_4.5.1.0.0
Creating Libraries: httpclient-cache
Creating Libraries: httpcore_4.4.10.0.0
Creating Libraries: httpcore
Creating Libraries: jakarta-commons-el_1.0.0.0.0
Creating Libraries: jakarta-commons-el
Creating Libraries: org.apache.ws.commons.schema.xmlschema_1.4.7.0.0
Creating Libraries: org.apache.ws.commons.schema.xmlschema
Creating Libraries: batik-all_1.11.0.0.1
Creating Libraries: batik-all
Creating Libraries: batik_bundle_1.11.0.0.1
Creating Libraries: batik_bundle
Creating Libraries: bcpkix-jdk15on_1.60.0.0.0
Creating Libraries: bcpkix-jdk15on
Creating Libraries: bcprov-ext-jdk15on_1.60.0.0.0
Creating Libraries: bcprov-ext-jdk15on
Creating Libraries: bcprov-jdk15on_1.60.0.0.0
Creating Libraries: bcprov-jdk15on
Creating Libraries: groovy-all_2.5.6.0.0
Creating Libraries: groovy-all
Creating Libraries: jackson-core-asl_1.9.13.0.0
Creating Libraries: jackson-core-asl
Creating Libraries: jackson-jaxrs_1.9.13.0.0
Creating Libraries: jackson-jaxrs
Creating Libraries: jackson-mapper-asl_1.9.13.0.0
Creating Libraries: jackson-mapper-asl
Creating Libraries: jackson-xc_1.9.13.0.0
Creating Libraries: jackson-xc
Creating Libraries: stax2-api_4.2.0.0.0
Creating Libraries: stax2-api
Creating Libraries: org.codehaus.woodstox.wstx-asl_3.2.9.0.0
Creating Libraries: org.codehaus.woodstox.wstx-asl
Creating Libraries: org.dom4j.dom4j_2.1.1.0.0
Creating Libraries: org.dom4j.dom4j
Creating Libraries: org.eclipse.equinox.common.vv_3.6.0.0.20100503
Creating Libraries: org.eclipse.equinox.common.vv
Creating Libraries: jetty-jndi.vv_9.2.2.0.20140723
Creating Libraries: jetty-jndi.vv
Creating Libraries: jetty-plus.vv_9.2.2.0.20140723
Creating Libraries: jetty-plus.vv
Creating Libraries: org.eclipse.jgit.v_r
Creating Libraries: org.eclipse.jgit.v_r_5.2.0.201812061821.0
Creating Libraries: org.eclipse.org.eclipse.osgi-singleton_3.9.1.0.0
Creating Libraries: org.eclipse.org.eclipse.osgi-singleton
Creating Libraries: org.hsqldb.hsqldb_2.4.1.0.0
Creating Libraries: org.hsqldb.hsqldb
Creating Libraries: jboss-logging.vfinal_3.3.0.0.0
Creating Libraries: jboss-logging.vfinal
Creating Libraries: jfreechart_1.5.0.0.0
Creating Libraries: jfreechart
Creating Libraries: esapi_2.1.0.1.0
Creating Libraries: esapi
Creating Libraries: jython-standalone_2.7.1.0.1
Creating Libraries: jython-standalone
Creating Libraries: slf4j-api_1.7.26.0.0
Creating Libraries: slf4j-api
Creating Libraries: slf4j-simple_1.7.26.0.0
Creating Libraries: slf4j-simple
Creating Libraries: spring-aop.vrelease_5.1.3.0.0
Creating Libraries: spring-aop.vrelease
Creating Libraries: spring-aspects.vrelease_5.1.3.0.0
Creating Libraries: spring-aspects.vrelease
Creating Libraries: spring-beans.vrelease_5.1.3.0.0
Creating Libraries: spring-beans.vrelease
Creating Libraries: spring-context-indexer.vrelease_5.1.3.0.0
Creating Libraries: spring-context-indexer.vrelease
Creating Libraries: spring-context-support.vrelease_5.1.3.0.0
Creating Libraries: spring-context-support.vrelease
Creating Libraries: spring-context.vrelease_5.1.3.0.0
Creating Libraries: spring-context.vrelease
Creating Libraries: spring-core.vrelease_5.1.3.0.0
Creating Libraries: spring-core.vrelease
Creating Libraries: spring-expression.vrelease_5.1.3.0.0
Creating Libraries: spring-expression.vrelease
Creating Libraries: spring-instrument.vrelease_5.1.3.0.0
Creating Libraries: spring-instrument.vrelease
Creating Libraries: spring-jcl.vrelease_5.1.3.0.0
Creating Libraries: spring-jcl.vrelease
Creating Libraries: spring-jdbc.vrelease_5.1.3.0.0
Creating Libraries: spring-jdbc.vrelease
Creating Libraries: spring-jms.vrelease_5.1.3.0.0
Creating Libraries: spring-jms.vrelease
Creating Libraries: spring-messaging.vrelease_5.1.3.0.0
Creating Libraries: spring-messaging.vrelease
Creating Libraries: spring-orm.vrelease_5.1.3.0.0
Creating Libraries: spring-orm.vrelease
Creating Libraries: spring-oxm.vrelease_5.1.3.0.0
Creating Libraries: spring-oxm.vrelease
Creating Libraries: spring-test.vrelease_5.1.3.0.0
Creating Libraries: spring-test.vrelease
Creating Libraries: spring-tx.vrelease_5.1.3.0.0
Creating Libraries: spring-tx.vrelease
Creating Libraries: spring-web.vrelease_5.1.3.0.0
Creating Libraries: spring-web.vrelease
Creating Libraries: spring-webflux.vrelease_5.1.3.0.0
Creating Libraries: spring-webflux.vrelease
Creating Libraries: spring-webmvc.vrelease_5.1.3.0.0
Creating Libraries: spring-webmvc.vrelease
Creating Libraries: spring-websocket.vrelease_5.1.3.0.0
Creating Libraries: spring-websocket.vrelease
Creating Libraries: sqljet_1.1.12.0.0
Creating Libraries: sqljet
Creating Libraries: svnkit_1.10.0.0.0
Creating Libraries: svnkit
Creating Libraries: oro_2.0.8.0.0
Creating Libraries: oro
Creating Libraries: osgi.cmpn_4.2.0.200908310645.0
Creating Libraries: osgi.cmpn
Creating Libraries: osgi.core_5.0.0.201203141902.0
Creating Libraries: osgi.core
Creating Libraries: xercesimpl_2.12.0.0.0
Creating Libraries: xercesimpl
Creating Libraries: xml-apis-ext_1.3.04.0.0
Creating Libraries: xml-apis-ext
Creating Libraries: antlr-runtime_4.1.0.0.0
Creating Libraries: antlr-runtime
Creating Libraries: org.apache.httpcomponents.httpclient_4.5.1.0.0
Creating Libraries: httpcore_4.4.3.0.0
Creating Libraries: adf.runtime.war
Creating Libraries: oxquery.xmlbeans_dependencies
Creating Libraries: oxquery.ee_dependencies
Creating Libraries: oxquery.xqjapi_dependencies
Creating Libraries: oracle.xdk.xmlparserv2_dependencies
Creating Libraries: javax_json_dependencies
Creating Libraries: mySqlJdbcDrivers
Creating Libraries: dataDirectJdbcDrivers
Creating Libraries: wlsThirdPartyJdbcDrivers
Creating Libraries: com.oracle.orapki
Creating Libraries: orapki.lib
Creating Libraries: glcm_encryption_lib
Creating Libraries: oracle.java.classpath
Creating Libraries: oracle.glcm.opatch.common.api.classpath
Creating Libraries: lib_jaxb
Creating Libraries: cieCfg_common_rcu_lib
Creating Libraries: commons-cli_1.2.0.0.0
Creating Libraries: lib_thirdparty_groovy_thirdparty
Creating Libraries: com.oracle.db.jdbc7-no-dms
Creating Libraries: com.oracle.db.jdbc7-dms
Creating Libraries: com.oracle.db.jdbc-no-dms
Creating Libraries: com.oracle.db.jdbc-dms
Creating Libraries: jdbcdms_dependencies
Creating Libraries: coherence_dependencies
Creating Libraries: webservices_dependencies
Creating Libraries: glassfish.gmbal_dependencies
Creating Libraries: jackson-core-asl_1.9.11.0.0
Creating Libraries: jackson-mapper-asl_1.9.11.0.0
Creating Libraries: lib_jdev_webservice_analyzer_thirdparty
Creating Libraries: xmlbeans_lib
Creating Libraries: com.oracle.webservices.wls.wls-classpath
Creating Libraries: webservices.jaxrpc_dependencies
Creating Libraries: lib_bouncyCastle_thirdparty
Creating Libraries: lib_jdev_usagetracking_thirdparty
Creating Libraries: webservices.impl_dependencies
Creating Libraries: mt_se.lib
Creating Libraries: oracle.glcm.opatchauto.core.classpath
Creating Libraries: oracle.glcm.opatchauto.core.binary.classpath
Creating Libraries: oracle.glcm.opatchauto.core.actions.classpath
Creating Libraries: oracle.glcm.opatchauto.core.wallet.classpath
Creating Libraries: mt_ee.lib
Creating Libraries: oracle.glcm.logging
Creating Libraries: cieCfg_common_lib
Creating Libraries: svctbl_lib
Creating Libraries: com.bea.core.binxml_dependencies
Creating Libraries: svctbl_jmx_client
Creating Libraries: cieCfg_wls_shared_lib
Creating Libraries: lib_owasp_thirdparty
Creating Libraries: glcm.schema.foh.lib
Creating Libraries: SchemaVersion
Creating Libraries: rcuapi_lib
Creating Libraries: rcu_core_lib
Creating Libraries: coherence.intg_dependencies
Creating Libraries: velocity.dep_dependencies
Creating Libraries: cieCfg_cam_lib
Creating Libraries: cieCfg_cam_external_lib
Creating Libraries: cieCfg_cam_impl_lib
Creating Libraries: cieCfg_wls_lib
Creating Libraries: cieCfg_wls_external_lib
Creating Libraries: cieCfg_wls_impl_lib
Creating Libraries: rcu_dependencies_lib
Creating Libraries: velocity.v_dev_1.4.0.0.0
Creating Libraries: httpmime_4.5.1.0.0
Creating Libraries: lib_jrf_adfrt_thirdparty
Creating Libraries: lib_jdev_fcp_thirdparty
Creating Libraries: wlthint3client
Creating Libraries: adf.runtime.ear
Creating Libraries: adf.runtime.war
Creating Libraries: com.oracle.webservices.wls.jaxws-wlswss-client
Creating Libraries: com.oracle.webservices.wls.jaxrpc-client
Creating Libraries: wlsafclient
Creating Libraries: jrmpclient
Creating Libraries: wl-j2ee-client
Creating Libraries: wlnmclient
Creating Libraries: wlsaft3client
Creating Libraries: wlconnector
Creating Libraries: wls-api
Creating Libraries: wlclient
Creating Libraries: wljmsclient
Creating Libraries: wljmxclient
Creating Libraries: glassfish.jersey.core_dependencies
Creating Libraries: glassfish.jersey_dependencies
Creating Libraries: weblogic.sca.engine_dependencies
Creating Libraries: javax.ws.rs.api_dependencies
Creating Libraries: jackson.client_dependencies
Creating Libraries: javax.management.j2ee
Creating Libraries: lib_spring_framework_thirdparty
Creating Libraries: wlstt3client
Creating Libraries: javassist.v_ga_3.20.0.0.0
Creating Libraries: jetty-xml.vv_9.2.2.0.20140723
Creating Libraries: jetty-webapp.vv_9.2.2.0.20140723
Creating Libraries: jetty-util.vv_9.2.2.0.20140723
Creating Libraries: jetty-servlet.vv_9.2.2.0.20140723
Creating Libraries: jetty-server.vv_9.2.2.0.20140723
Creating Libraries: jetty-security.vv_9.2.2.0.20140723
Creating Libraries: jetty-io.vv_9.2.2.0.20140723
Creating Libraries: jetty-http.vv_9.2.2.0.20140723
Creating Libraries: commons-io_2.2.0.0.0
Creating Libraries: commons-collections_3.2.2.0.0
Creating Libraries: commons-cli_1.1.0.0.0
Creating Libraries: gson_2.6.2.0.0
Creating Libraries: lib_odi_thirdparty
Creating Libraries: oracle.fmwplatform.fmwprov_lib
Creating Libraries: fmwplatform-wlst-dependencies
Creating Libraries: oracle.fmwplatform.ocp_lib
Creating Libraries: oracle.fmwplatform.ocp_plugin_lib
Creating Libraries: oracle.glcm.opatchauto.fmw.actions.classpath
Creating Libraries: commons-beanutils_1.9.3.0.0
Creating Libraries: springframework_dependencies
Creating Libraries: dom4j_dependencies
Creating Libraries: wlst.wls.classpath
Creating Libraries: maven.wls.classpath
Creating Libraries: wlst.cam.classpath
Creating Libraries: org.antlr.antlr_4.1.0.0.0
Creating Libraries: lib_jdev_groovy_thirdparty
Creating Libraries: org.json.json_20131018.0.0.0.0
Creating Libraries: com.oracle.webservices.fmw.ws-assembler
Creating Libraries: sdpmessaging_dependencies
Creating Libraries: sdpclient_dependencies
Creating Libraries: com.oracle.jersey.fmw.client
Creating Libraries: com.oracle.webservices.fmw.client
Creating Libraries: oracle.jrf.wls.classpath
Creating Libraries: oracle.jrf.wlst
Creating Libraries: fmwshare-wlst-dependencies
Creating Libraries: oracle.fmwshare.pyjar
Creating Libraries: soa_com.bea.core.binxml_dependencies
Creating Libraries: log4j_1.2.17.16.0
Creating Libraries: groovy-all_2.4.17.0.0
Creating Libraries: odi_coherence_dependencies
Creating Libraries: odi_glassfish.jersey.core_dependencies
Creating Libraries: odi_jersey_fmw_dependencies
Creating Libraries: odi_glassfish.jersey_dependencies
Creating Libraries: odi_glassfish.gmbal_dependencies
Creating Libraries: odi_adf_groovy_dependencies
Creating Libraries: odi_osdt_pki_dependencies
Creating Libraries: odi_opss_dependencies
Creating Libraries: odi_pki_dependencies
Creating Libraries: odi_datadirect_dependencies
Creating Libraries: odi_http_dependencies
Creating Libraries: odi_glcm_schema_dependencies
Creating Libraries: odi_jdbcdms_dependencies
Creating Libraries: odi_jdbc7dms_dependencies
Creating Libraries: odi_mysql_dependencies
Creating Libraries: odi_toplink_dependencies
Creating Libraries: odi_orawsdl_dependencies
Creating Libraries: odi_codehaus_dependencies
Creating Libraries: odi_wls_dependencies
Creating Libraries: odi_bali_dependencies
Creating Libraries: odi_nlsrtl_dependencies
Creating Libraries: odi_wls_base_dependencies
Creating Libraries: odi_wls_portable_dependencies
Creating Libraries: odi_webservices_fmw_dependencies
Creating Libraries: odi_wls_jrf_tenancy_dependencies
Creating Libraries: odi_wls_libraries_dependencies
Creating Libraries: odi_wls_inst_dependencies
Creating Libraries: odi_webservices_wls_wls-classpath_dependencies
Creating Libraries: odi_ant_dependencies
Creating Libraries: odi_xdk_dependencies
Creating Libraries: odi_jackson_dependencies
Creating Libraries: odi_dms_dependencies
Creating Libraries: odi_javax_json_dependencies
Creating Libraries: odi_common_collect_dependencies
Creating Libraries: odi_jmx_dependencies
Creating Libraries: odi_jsch_dependencies
Creating Libraries: odi_jservlet_dependencies
Creating Libraries: wljmsclient
Creating Libraries: wljmxclient
Library Creation Completed
Starting String Substitution of files
Performing String Substitutions: oracle.fmwconfig.wls.shared 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.wls.shared.external 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.wls.external 12.2.1.4.0
Performing String Substitutions: oracle.nlsoramapping.jrf 19.3.0.0.0
Performing String Substitutions: oracle.nlsrtl.jrf 19.3.0.0.0
Performing String Substitutions: oracle.xdk.jrf.jaxp 12.2.1.4.0
Performing String Substitutions: oracle.rdbms.jrf 19.3.0.0.0
Performing String Substitutions: oracle.glcm.logging 1.6.4.0.0
Performing String Substitutions: oracle.glcm.comdev 7.8.4.0.0
Performing String Substitutions: oracle.glcm.dependency 1.8.4.0.0
Performing String Substitutions: oracle.glcm.xmldh 3.4.4.0.0
Performing String Substitutions: oracle.glcm.wizard 7.8.4.0.0
Performing String Substitutions: oracle.jse.dms 12.2.1.4.0
Performing String Substitutions: oracle.jrf.dms.common 12.2.1.4.0
Performing String Substitutions: oracle.thirdparty.maven 3.2.5.0.0
Performing String Substitutions: oracle.jrf.maven.plugins.sync 12.2.1.4.0
Performing String Substitutions: oracle.oamclient.core 12.2.1.4.0
Performing String Substitutions: oracle.oamclient.wls 12.2.1.4.0
Performing String Substitutions: oracle.odi.sdk 12.2.1.4.0
Performing String Substitutions: oracle.odi.agent 12.2.1.4.0
Performing String Substitutions: oracle.ant.contrib.ant.contrib.vb 1.0.0.0.3
Performing String Substitutions: oracle.bsf.bsf 2.4.0.0.0
Performing String Substitutions: oracle.cglib.cglib.nodep 3.2.5.0.0
Performing String Substitutions: oracle.com.fasterxml_classmate 1.3.1.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.core.jackson.annotations 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.core.jackson.core 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.core.jackson.databind 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.dataformat.jackson.dataformat.xml 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.base 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.json.provider 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.module.jackson.module.jaxb.annotations 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.jackson.module.jackson.module.jsonschema 2.9.9.0.0
Performing String Substitutions: oracle.com.fasterxml.woodstox.woodstox.core 5.2.0.0.0
Performing String Substitutions: oracle.com.google.guava.failureaccess 1.0.1.0.0
Performing String Substitutions: oracle.com.google.guava.guava 27.1.0.0.0
Performing String Substitutions: oracle.com.googlecode.owasp_java.html.sanitizer.owasp_java.html.sanitizer 20190325.1.0.0.0
Performing String Substitutions: oracle.com.ibm.jbatch.com.ibm.jbatch.container 1.0.3.0.0
Performing String Substitutions: oracle.com.ibm.jbatch.com.ibm.jbatch.spi 1.0.3.0.0
Performing String Substitutions: oracle.com.jayway.jsonpath.json.path 2.2.0.0.0
Performing String Substitutions: oracle.com.jcraft.jsch 0.1.54.0.0
Performing String Substitutions: oracle.com.jcraft.jsch.com.jcraft.jsch 0.1.53.0.0
Performing String Substitutions: oracle.com.jcraft.jzlib.com.jcraft.jzlib 1.0.7.0.0
Performing String Substitutions: oracle.com.miglayout.miglayout 4.0.0.0.0
Performing String Substitutions: oracle.com.trilead.trilead.ssh2.v_build 1.0.0.0.221
Performing String Substitutions: oracle.commons.cli.commons.cli 1.3.1.0.0
Performing String Substitutions: oracle.commons.codec.commons.codec 1.11.0.0.0
Performing String Substitutions: oracle.commons.discovery.commons.discovery 0.5.0.0.0
Performing String Substitutions: oracle.commons.fileupload.commons.fileupload 1.4.0.0.0
Performing String Substitutions: oracle.commons.httpclient.commons.httpclient 3.1.0.0.0
Performing String Substitutions: oracle.commons.io.commons.io 2.6.0.0.0
Performing String Substitutions: oracle.commons.lang.commons.lang 2.6.0.0.0
Performing String Substitutions: oracle.commons.logging.commons.logging 1.2.0.0.1
Performing String Substitutions: oracle.commons.net.commons.net 3.5.0.0.0
Performing String Substitutions: oracle.de.regnis.q.sequence.sequence.library 1.0.4.0.0
Performing String Substitutions: oracle.france.telecom.org.objectweb.asm.all 5.0.1.0.0
Performing String Substitutions: oracle.jdesktop.jxlayer 4.0.0.0.0
Performing String Substitutions: oracle.joda.time.joda.time 2.10.0.0.0
Performing String Substitutions: oracle.log4j.log4j 2.11.1.0.0
Performing String Substitutions: oracle.net.sourceforge.nekohtml.nekohtml 1.9.16.0.0
Performing String Substitutions: oracle.org.apache.ant.ant 1.9.8.0.0
Performing String Substitutions: oracle.org.apache.ant.ant.bundle 1.10.5.0.0
Performing String Substitutions: oracle.org.apache.ant.ant.launcher 1.9.8.0.0
Performing String Substitutions: oracle.org.apache.commons.commons.compress 1.9.0.0.0
Performing String Substitutions: oracle.org.apache.commons.commons.digester3 3.2.0.0.0
Performing String Substitutions: oracle.org.apache.commons.commons.lang3 3.8.1.0.0
Performing String Substitutions: oracle.org.apache.commons.commons.vfs2 2.2.0.0.0
Performing String Substitutions: oracle.org.apache.extras.beanshell.bsh.vb 2.0.0.0.6
Performing String Substitutions: oracle.org.apache.httpcomponents.httpclient 4.5.6.0.0
Performing String Substitutions: oracle.org.apache.httpcomponents.httpclient.cache 4.5.1.0.0
Performing String Substitutions: oracle.org.apache.httpcomponents.httpcore 4.4.10.0.0
Performing String Substitutions: oracle.org.apache.jakarta.commons.el 1.0.0.0.0
Performing String Substitutions: oracle.org.apache.ws.commons.schema_xmlschema 1.4.7.0.0
Performing String Substitutions: oracle.org.apache.xmlgraphics.batik.all 1.11.0.0.1
Performing String Substitutions: oracle.org.apache.xmlgraphics.batik.bundle 1.11.0.0.1
Performing String Substitutions: oracle.org.bouncycastle.bcpkix.jdk15on 1.60.0.0.0
Performing String Substitutions: oracle.org.bouncycastle.bcprov.ext.jdk15on 1.60.0.0.0
Performing String Substitutions: oracle.org.bouncycastle.bcprov.jdk15on 1.60.0.0.0
Performing String Substitutions: oracle.org.codehaus.groovy.groovy.all 2.5.6.0.0
Performing String Substitutions: oracle.org.codehaus.jackson.jackson.core.asl 1.9.13.0.0
Performing String Substitutions: oracle.org.codehaus.jackson.jackson.jaxrs 1.9.13.0.0
Performing String Substitutions: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.13.0.0
Performing String Substitutions: oracle.org.codehaus.jackson.jackson.xc 1.9.13.0.0
Performing String Substitutions: oracle.org.codehaus.woodstox.stax2.api 4.2.0.0.0
Performing String Substitutions: oracle.org.codehaus.woodstox.wstx.asl 3.2.9.0.0
Performing String Substitutions: oracle.org_dom4j_dom4j 2.1.1.0.0
Performing String Substitutions: oracle.org.eclipse.equinox.org.eclipse.equinox.common.vv 3.6.0.0.20100503
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.jndi.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.plus.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jgit.org.eclipse.jgit.v_r 5.2.0.201812061821.0
Performing String Substitutions: oracle.org.eclipse.org.eclipse.osgi.singleton 3.9.1.0.0
Performing String Substitutions: oracle.org.hsqldb.hsqldb 2.4.1.0.0
Performing String Substitutions: oracle.org.jboss.logging.jboss.logging.vfinal 3.3.0.0.0
Performing String Substitutions: oracle.org.jfree.jfreechart 1.5.0.0.0
Performing String Substitutions: oracle.org.owasp.esapi.esapi 2.1.0.1.0
Performing String Substitutions: oracle.org.python.jython.standalone 2.7.1.0.1
Performing String Substitutions: oracle.org.slf4j.slf4j.api 1.7.26.0.0
Performing String Substitutions: oracle.org.slf4j.slf4j.simple 1.7.26.0.0
Performing String Substitutions: oracle.org.springframework.spring.aop.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.aspects.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.beans.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.context.indexer.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.context.support.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.context.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.core.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.expression.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.instrument.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.jcl.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.jdbc.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.jms.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.messaging.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.orm.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.oxm.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.test.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.tx.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.web.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.webflux.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.webmvc.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.springframework.spring.websocket.vrelease 5.1.3.0.0
Performing String Substitutions: oracle.org.tmatesoft.sqljet.sqljet 1.1.12.0.0
Performing String Substitutions: oracle.org.tmatesoft.svnkit.svnkit 1.10.0.0.0
Performing String Substitutions: oracle.oro.oro 2.0.8.0.0
Performing String Substitutions: oracle.osgi.alliance.osgi.cmpn 4.2.0.200908310645.0
Performing String Substitutions: oracle.osgi.alliance.osgi.core 5.0.0.201203141902.0
Performing String Substitutions: oracle.xerces.xercesimpl 2.12.0.0.0
Performing String Substitutions: oracle.xml.apis.xml.apis.ext 1.3.04.0.0
Performing String Substitutions: oracle.org.antlr.antlr.runtime 4.1.0.0.0
Performing String Substitutions: oracle.wls.inst.only 12.2.1.4.0
Performing String Substitutions: oracle.wls.shared.with.inst 12.2.1.4.0
Performing String Substitutions: oracle.jrf.dms 12.2.1.4.0
Performing String Substitutions: oracle.bali.share 12.2.1.4.0
Performing String Substitutions: oracle.bali.jewt 12.2.1.4.0
Performing String Substitutions: oracle.bali.ice 12.2.1.4.0
Performing String Substitutions: oracle.help.share 12.2.1.4.0
Performing String Substitutions: oracle.help.ohj 12.2.1.4.0
Performing String Substitutions: oracle.fmw.common.wizard.resources 12.2.1.0.0
Performing String Substitutions: oracle.wls.security.core.sharedlib 12.2.1.4.0
Performing String Substitutions: oracle.wls.jrf.tenancy.ee.only.sharedlib 12.2.1.4.0
Performing String Substitutions: oracle.xdk.jrf.xmlparserv2 12.2.1.4.0
Performing String Substitutions: oracle.xdk.jrf.fmw 12.2.1.4.0
Performing String Substitutions: oracle.xdk.jrf 12.2.1.4.0
Performing String Substitutions: oracle.jrf.thirdparty.toplink 12.2.1.4.0
Performing String Substitutions: oracle.wls.thirdparty.javax.json 12.2.1.4.0
Performing String Substitutions: oracle.jrf.toplink 12.2.1.4.0
Performing String Substitutions: oracle.mysql 8.0.14.0.0
Performing String Substitutions: oracle.datadirect 12.2.1.4.0
Performing String Substitutions: oracle.rsa.crypto 12.2.1.4.0
Performing String Substitutions: oracle.pki 12.2.1.4.0
Performing String Substitutions: oracle.osdt.core 12.2.1.4.0
Performing String Substitutions: oracle.glcm.encryption 2.7.4.0.0
Performing String Substitutions: oracle.java.jaxws 12.2.1.4.0
Performing String Substitutions: oracle.java.xml.bind 2.3.0.0.0
Performing String Substitutions: oracle.java.activation 12.2.1.4.0
Performing String Substitutions: oracle.glcm.opatch.common.api 13.9.4.0.0
Performing String Substitutions: oracle.nginst.common 13.9.4.0.0
Performing String Substitutions: oracle.nginst.core 13.9.4.0.0
Performing String Substitutions: oracle.nginst.thirdparty 13.9.4.0.0
Performing String Substitutions: oracle.jaxb.tools 2.3.0.0.0
Performing String Substitutions: oracle.jaxb.impl 2.3.0.0.0
Performing String Substitutions: oracle.jaxb.core 2.3.0.0.0
Performing String Substitutions: oracle.toplink.coherence 12.2.1.4.0
Performing String Substitutions: oracle.toplink.dbwslib 12.2.1.4.0
Performing String Substitutions: oracle.toplink.doc 12.2.1.4.0
Performing String Substitutions: oracle.toplink.developer 12.2.1.4.0
Performing String Substitutions: oracle.wls.libraries 12.2.1.4.0
Performing String Substitutions: oracle.rcu.ciestb 12.2.1.4.0
Performing String Substitutions: oracle.commons.cli.commons.cli 1.2.0.0.0
Performing String Substitutions: oracle.javavm.jrf 19.3.0.0.0
Performing String Substitutions: oracle.coherence.discovery 12.2.1.4.0
Performing String Substitutions: oracle.coherence 12.2.1.4.0
Performing String Substitutions: oracle.jrf.adfrt.help 12.2.1.4.0
Performing String Substitutions: oracle.jrf.adfrt.batik 12.2.1.4.0
Performing String Substitutions: oracle.jrf.adfrt.javatools 12.2.1.4.0
Performing String Substitutions: oracle.swd.opatch 13.9.4.2.1
Performing String Substitutions: oracle.rda 19.3.19.8.2
Performing String Substitutions: oracle.wls.jrf.tenancy.common 12.2.1.4.0
Performing String Substitutions: oracle.as.install.common.help 12.2.1.4.0
Performing String Substitutions: oracle.as.install.common.prerequisite.files 12.2.1.4.0
Performing String Substitutions: oracle.as.install.ui.framework 12.2.1.4.0
Performing String Substitutions: org.codehaus.woodstox 4.2.0.0.0
Performing String Substitutions: oracle.webservices.orawsdl 12.2.1.4.0
Performing String Substitutions: oracle.http_client 12.2.1.4.0
Performing String Substitutions: oracle.webservices.base 12.2.1.4.0
Performing String Substitutions: oracle.as.install.odi 12.2.1.4.0
Performing String Substitutions: oracle.as.install.odi.prerequisite 12.2.1.4.0
Performing String Substitutions: oracle.org.codehaus.jackson.jackson.core.asl 1.9.11.0.0
Performing String Substitutions: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.11.0.0
Performing String Substitutions: com.bea.core.xml.xmlbeans 2.6.0.6.0
Performing String Substitutions: oracle.wls.security.core 12.2.1.4.0
Performing String Substitutions: oracle.wls.common.cam 12.2.1.4.0
Performing String Substitutions: oracle.wls.common.nodemanager 12.2.1.4.0
Performing String Substitutions: oracle.wls.common.cam.wlst 12.2.1.4.0
Performing String Substitutions: oracle.wls.shared.with.cam 12.2.1.4.0
Performing String Substitutions: oracle.webservices.wls 12.2.1.4.0
Performing String Substitutions: oracle.wls.shared.with.inst.sharedlib 12.2.1.4.0
Performing String Substitutions: oracle.wls.jrf.tenancy.common.sharedlib 12.2.1.4.0
Performing String Substitutions: oracle.wsm.common 12.2.1.4.0
Performing String Substitutions: oracle.wsm.agent.fmw 12.2.1.4.0
Performing String Substitutions: oracle.webservices.jrf 12.2.1.4.0
Performing String Substitutions: oracle.webservices.jaxrs.jrf 12.2.1.4.0
Performing String Substitutions: oracle.ide.usages.tracking 12.2.1.4.0
Performing String Substitutions: oracle.jrf.tenancy 12.2.1.4.0
Performing String Substitutions: oracle.jrf.tenancy.se 12.2.1.4.0
Performing String Substitutions: oracle.glcm.opatchauto.core 13.9.4.2.0
Performing String Substitutions: oracle.jrf.tenancy.ee 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.shared 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.config.shared 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.wls.help 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.wls.shared.internal 12.2.1.4.0
Performing String Substitutions: oracle.fmw.upgrade.fmwconfig 12.2.1.4.0
Performing String Substitutions: oracle.owasp.jrf 12.2.1.4.0
Performing String Substitutions: oracle.glcm.schema.version.registry 12.2.1.4.0
Performing String Substitutions: oracle.rcu.doc 12.2.1.4.0
Performing String Substitutions: oracle.sysman.rcu 12.2.1.4.0
Performing String Substitutions: oracle.common.rcu.config 12.2.1.4.0
Performing String Substitutions: oracle.wls.rcu 12.2.1.4.0
Performing String Substitutions: oracle.wls.core.app.server 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.cam.shared 12.2.1.4.0
Performing String Substitutions: oracle.rcu.shared 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.wls 12.2.1.4.0
Performing String Substitutions: oracle.fmwconfig.common.wls.internal 12.2.1.4.0
Performing String Substitutions: oracle.odi.jse.template 12.2.1.4.0
Performing String Substitutions: oracle.wls.evaluation.database 12.2.1.4.0
Performing String Substitutions: oracle.velocity.velocity.v_dev 1.4.0.0.0
Performing String Substitutions: oracle.org.apache.httpcomponents.httpmime 4.5.1.0.0
Performing String Substitutions: oracle.fmwconfig.common.cam 12.2.1.4.0
Performing String Substitutions: oracle.rcu.opss 12.2.1.4.0
Performing String Substitutions: oracle.rcu.iau 12.2.1.4.0
Performing String Substitutions: oracle.java.servlet 12.2.1.4.0
Performing String Substitutions: oracle.jrf.adfrt 12.2.1.4.0
Performing String Substitutions: oracle.wls.shared.with.coh.standalone 12.2.1.4.0
Performing String Substitutions: oracle.wls.wlsportable.mod 12.2.1.4.0
Performing String Substitutions: oracle.wls.core.app.server.tier1nativelib 12.2.1.4.0
Performing String Substitutions: oracle.wls.clients 12.2.1.4.0
Performing String Substitutions: oracle.wls.cam.wlst 12.2.1.4.0
Performing String Substitutions: oracle.org_javassist_javassist.v_ga 3.20.0.0.0
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.xml.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.webapp.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.util.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.servlet.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.server.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.security.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.io.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.org.eclipse.jetty.jetty.http.vv 9.2.2.0.20140723
Performing String Substitutions: oracle.commons.io.commons.io 2.2.0.0.0
Performing String Substitutions: oracle.commons.collections.commons.collections 3.2.2.0.0
Performing String Substitutions: oracle.commons.cli.commons.cli 1.1.0.0.0
Performing String Substitutions: oracle.com.google.code.gson.gson 2.6.2.0.0
Performing String Substitutions: oracle.odi.tp 12.2.1.4.0
Performing String Substitutions: oracle.fmwplatform.fmwprov 12.2.1.4.0
Performing String Substitutions: oracle.fmwplatform.ocp 12.2.1.4.0
Performing String Substitutions: oracle.glcm.opatchauto.fmw 13.9.4.2.0
Performing String Substitutions: oracle.commons.beanutils.commons.beanutils 1.9.3.0.0
Performing String Substitutions: oracle.apache.commons.lang.mod 2.6.0.0.2
Performing String Substitutions: oracle.apache.commons.collections.mod 3.2.0.0.2
Performing String Substitutions: oracle.jersey 12.1.3.0.0
Performing String Substitutions: oracle.nlspdk 12.2.1.4.0
Performing String Substitutions: oracle.nlsgdk 12.2.1.4.0
Performing String Substitutions: oracle.jrf.j2ee 12.2.1.4.0
Performing String Substitutions: oracle.jrf.infra.common 12.2.1.4.0
Performing String Substitutions: oracle.jrf.thirdparty.jee 12.2.1.4.0
Performing String Substitutions: oracle.jrf.iau 12.2.1.4.0
Performing String Substitutions: oracle.ids.core 12.2.1.4.0
Performing String Substitutions: oracle.opss.core 12.2.1.4.0
Performing String Substitutions: oracle.jmx 12.2.1.4.0
Performing String Substitutions: oracle.jsp 12.2.1.4.0
Performing String Substitutions: oracle.legacy_oc4j_xml_schemas 12.2.1.4.0
Performing String Substitutions: oracle.rdbms.ras 12.1.0.2.0
Performing String Substitutions: oracle.opss.wls 12.2.1.4.0
Performing String Substitutions: oracle.fmw.upgrade 12.2.1.4.0
Performing String Substitutions: oracle.fmw.upgrade.help 12.2.1.4.0
Performing String Substitutions: oracle.ons.generic 12.2.1.4.0
Performing String Substitutions: oracle.diagnostics.common 12.2.1.4.0
Performing String Substitutions: oracle.wls.workshop.code.completion.support 12.2.1.4.0
Performing String Substitutions: oracle.wls.admin.console.en 12.2.1.4.0
Performing String Substitutions: oracle.wls.http.pubsub.server 12.2.1.4.0
Performing String Substitutions: oracle.wls.weblogic.sca 12.2.1.4.0
Performing String Substitutions: oracle.wls.admin.console.nonen 12.2.1.4.0
Performing String Substitutions: oracle.ide.vhv 12.2.1.4.0
Performing String Substitutions: oracle.ide.fcp 12.2.1.4.0
Performing String Substitutions: oracle.ide.help.extras 12.2.1.4.0
Performing String Substitutions: oracle.ide.modeler 12.2.1.4.0
Performing String Substitutions: oracle.ide.diagram 12.2.1.4.0
Performing String Substitutions: oracle.ide.xmlef 12.2.1.4.0
Performing String Substitutions: oracle.ide.java 12.2.1.4.0
Performing String Substitutions: oracle.org.antlr.antlr 4.1.0.0.0
Performing String Substitutions: oracle.ide.groovy 12.2.1.4.0
Performing String Substitutions: oracle.org.json.json 20131018.0.0.0.0
Performing String Substitutions: oracle.glcm.fmw.chghost 12.2.1.4.0
Performing String Substitutions: oracle.mds.dumputil 12.2.1.4.0
Performing String Substitutions: oracle.rcu.mds 12.2.1.4.0
Performing String Substitutions: oracle.rcu.ucs.messaging 12.2.1.3.0
Performing String Substitutions: oracle.wsm.console.core 12.2.1.4.0
Performing String Substitutions: oracle.jgroups 12.2.1.0.0
Performing String Substitutions: oracle.jsch 12.2.1.0.0
Performing String Substitutions: oracle.bali.ewt 12.2.1.4.0
Performing String Substitutions: oracle.pwdgen.jrf 12.2.1.4.0
Performing String Substitutions: oracle.jrf.infra.fmw.common 12.2.1.4.0
Performing String Substitutions: oracle.jrf.applcore 12.2.1.4.0
Performing String Substitutions: oracle.wsm.pmlib 12.2.1.4.0
Performing String Substitutions: oracle.wsm.jrf 12.2.1.4.0
Performing String Substitutions: oracle.ids.jrf 12.2.1.4.0
Performing String Substitutions: oracle.opss.jrf 12.2.1.4.0
Performing String Substitutions: oracle.osdt.jrf 12.2.1.4.0
Performing String Substitutions: oracle.sslconfig.jrf 12.2.1.4.0
Performing String Substitutions: oracle.ldap.jrf 12.2.1.4.0
Performing String Substitutions: oracle.sdp.messaging 12.2.1.3.0
Performing String Substitutions: oracle.help.ohw.rcf 12.2.1.4.0
Performing String Substitutions: oracle.help.ohw.share 12.2.1.4.0
Performing String Substitutions: oracle.help.ohw.uix 12.2.1.4.0
Performing String Substitutions: oracle.webcenter.wccore 12.2.1.4.0
Performing String Substitutions: oracle.bali.cabo 12.2.1.4.0
Performing String Substitutions: oracle.ide.rescat2 12.2.1.4.0
Performing String Substitutions: oracle.ide.db.connection 12.2.1.4.0
Performing String Substitutions: oracle.ide.webservice.analyzer 12.2.1.4.0
Performing String Substitutions: oracle.jrf.infra.fmw.wls 12.2.1.4.0
Performing String Substitutions: oracle.wsm.agent.wls 12.2.1.4.0
Performing String Substitutions: oracle.soa.all.client 12.2.1.4.0
Performing String Substitutions: oracle.sysman.fmw.core 12.2.1.4.0
Performing String Substitutions: oracle.sysman.fmw.as 12.2.1.4.0
Performing String Substitutions: oracle.sysman.fmw.agent 12.2.1.4.0
Performing String Substitutions: oracle.log4j.log4j 1.2.17.16.0
Performing String Substitutions: oracle.org.codehaus.groovy.groovy.all 2.4.17.0.0
Performing String Substitutions: oracle.odi.oggstudio 12.2.1.4.0
Performing String Substitutions: oracle.odi.studio 12.2.1.4.0
Performing String Substitutions: oracle.datadirect.odi 12.2.1.4.0
Performing String Substitutions: oracle.as.install.onlinedoc.shortcut 12.2.1.4.0
Performing String Substitutions: oracle.odi.km 12.2.1.4.0
Performing String Substitutions: oracle.as.customqna.jdkqna 12.2.1.4.0
String Substitution Completed
Starting Link Phase
Linking: oracle.fmwconfig.wls.shared 12.2.1.4.0
Linking: oracle.fmwconfig.common.wls.shared.external 12.2.1.4.0
Linking: oracle.fmwconfig.common.wls.external 12.2.1.4.0
Linking: oracle.nlsoramapping.jrf 19.3.0.0.0
Linking: oracle.nlsrtl.jrf 19.3.0.0.0
Linking: oracle.xdk.jrf.jaxp 12.2.1.4.0
Linking: oracle.rdbms.jrf 19.3.0.0.0
Linking: oracle.glcm.logging 1.6.4.0.0
Linking: oracle.glcm.comdev 7.8.4.0.0
Linking: oracle.glcm.dependency 1.8.4.0.0
Linking: oracle.glcm.xmldh 3.4.4.0.0
Linking: oracle.glcm.wizard 7.8.4.0.0
Linking: oracle.jse.dms 12.2.1.4.0
Linking: oracle.jrf.dms.common 12.2.1.4.0
Linking: oracle.thirdparty.maven 3.2.5.0.0
Linking: oracle.jrf.maven.plugins.sync 12.2.1.4.0
Linking: oracle.oamclient.core 12.2.1.4.0
Linking: oracle.oamclient.wls 12.2.1.4.0
Linking: oracle.odi.sdk 12.2.1.4.0
Linking: oracle.odi.agent 12.2.1.4.0
Linking: oracle.ant.contrib.ant.contrib.vb 1.0.0.0.3
Linking: oracle.bsf.bsf 2.4.0.0.0
Linking: oracle.cglib.cglib.nodep 3.2.5.0.0
Linking: oracle.com.fasterxml_classmate 1.3.1.0.0
Linking: oracle.com.fasterxml.jackson.core.jackson.annotations 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.core.jackson.core 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.core.jackson.databind 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.dataformat.jackson.dataformat.xml 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.base 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.json.provider 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.module.jackson.module.jaxb.annotations 2.9.9.0.0
Linking: oracle.com.fasterxml.jackson.module.jackson.module.jsonschema 2.9.9.0.0
Linking: oracle.com.fasterxml.woodstox.woodstox.core 5.2.0.0.0
Linking: oracle.com.google.guava.failureaccess 1.0.1.0.0
Linking: oracle.com.google.guava.guava 27.1.0.0.0
Linking: oracle.com.googlecode.owasp_java.html.sanitizer.owasp_java.html.sanitizer 20190325.1.0.0.0
Linking: oracle.com.ibm.jbatch.com.ibm.jbatch.container 1.0.3.0.0
Linking: oracle.com.ibm.jbatch.com.ibm.jbatch.spi 1.0.3.0.0
Linking: oracle.com.jayway.jsonpath.json.path 2.2.0.0.0
Linking: oracle.com.jcraft.jsch 0.1.54.0.0
Linking: oracle.com.jcraft.jsch.com.jcraft.jsch 0.1.53.0.0
Linking: oracle.com.jcraft.jzlib.com.jcraft.jzlib 1.0.7.0.0
Linking: oracle.com.miglayout.miglayout 4.0.0.0.0
Linking: oracle.com.trilead.trilead.ssh2.v_build 1.0.0.0.221
Linking: oracle.commons.cli.commons.cli 1.3.1.0.0
Linking: oracle.commons.codec.commons.codec 1.11.0.0.0
Linking: oracle.commons.discovery.commons.discovery 0.5.0.0.0
Linking: oracle.commons.fileupload.commons.fileupload 1.4.0.0.0
Linking: oracle.commons.httpclient.commons.httpclient 3.1.0.0.0
Linking: oracle.commons.io.commons.io 2.6.0.0.0
Linking: oracle.commons.lang.commons.lang 2.6.0.0.0
Linking: oracle.commons.logging.commons.logging 1.2.0.0.1
Linking: oracle.commons.net.commons.net 3.5.0.0.0
Linking: oracle.de.regnis.q.sequence.sequence.library 1.0.4.0.0
Linking: oracle.france.telecom.org.objectweb.asm.all 5.0.1.0.0
Linking: oracle.jdesktop.jxlayer 4.0.0.0.0
Linking: oracle.joda.time.joda.time 2.10.0.0.0
Linking: oracle.log4j.log4j 2.11.1.0.0
Linking: oracle.net.sourceforge.nekohtml.nekohtml 1.9.16.0.0
Linking: oracle.org.apache.ant.ant 1.9.8.0.0
Linking: oracle.org.apache.ant.ant.bundle 1.10.5.0.0
Linking: oracle.org.apache.ant.ant.launcher 1.9.8.0.0
Linking: oracle.org.apache.commons.commons.compress 1.9.0.0.0
Linking: oracle.org.apache.commons.commons.digester3 3.2.0.0.0
Linking: oracle.org.apache.commons.commons.lang3 3.8.1.0.0
Linking: oracle.org.apache.commons.commons.vfs2 2.2.0.0.0
Linking: oracle.org.apache.extras.beanshell.bsh.vb 2.0.0.0.6
Linking: oracle.org.apache.httpcomponents.httpclient 4.5.6.0.0
Linking: oracle.org.apache.httpcomponents.httpclient.cache 4.5.1.0.0
Linking: oracle.org.apache.httpcomponents.httpcore 4.4.10.0.0
Linking: oracle.org.apache.jakarta.commons.el 1.0.0.0.0
Linking: oracle.org.apache.ws.commons.schema_xmlschema 1.4.7.0.0
Linking: oracle.org.apache.xmlgraphics.batik.all 1.11.0.0.1
Linking: oracle.org.apache.xmlgraphics.batik.bundle 1.11.0.0.1
Linking: oracle.org.bouncycastle.bcpkix.jdk15on 1.60.0.0.0
Linking: oracle.org.bouncycastle.bcprov.ext.jdk15on 1.60.0.0.0
Linking: oracle.org.bouncycastle.bcprov.jdk15on 1.60.0.0.0
Linking: oracle.org.codehaus.groovy.groovy.all 2.5.6.0.0
Linking: oracle.org.codehaus.jackson.jackson.core.asl 1.9.13.0.0
Linking: oracle.org.codehaus.jackson.jackson.jaxrs 1.9.13.0.0
Linking: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.13.0.0
Linking: oracle.org.codehaus.jackson.jackson.xc 1.9.13.0.0
Linking: oracle.org.codehaus.woodstox.stax2.api 4.2.0.0.0
Linking: oracle.org.codehaus.woodstox.wstx.asl 3.2.9.0.0
Linking: oracle.org_dom4j_dom4j 2.1.1.0.0
Linking: oracle.org.eclipse.equinox.org.eclipse.equinox.common.vv 3.6.0.0.20100503
Linking: oracle.org.eclipse.jetty.jetty.jndi.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.plus.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jgit.org.eclipse.jgit.v_r 5.2.0.201812061821.0
Linking: oracle.org.eclipse.org.eclipse.osgi.singleton 3.9.1.0.0
Linking: oracle.org.hsqldb.hsqldb 2.4.1.0.0
Linking: oracle.org.jboss.logging.jboss.logging.vfinal 3.3.0.0.0
Linking: oracle.org.jfree.jfreechart 1.5.0.0.0
Linking: oracle.org.owasp.esapi.esapi 2.1.0.1.0
Linking: oracle.org.python.jython.standalone 2.7.1.0.1
Linking: oracle.org.slf4j.slf4j.api 1.7.26.0.0
Linking: oracle.org.slf4j.slf4j.simple 1.7.26.0.0
Linking: oracle.org.springframework.spring.aop.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.aspects.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.beans.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.context.indexer.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.context.support.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.context.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.core.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.expression.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.instrument.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.jcl.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.jdbc.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.jms.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.messaging.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.orm.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.oxm.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.test.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.tx.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.web.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.webflux.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.webmvc.vrelease 5.1.3.0.0
Linking: oracle.org.springframework.spring.websocket.vrelease 5.1.3.0.0
Linking: oracle.org.tmatesoft.sqljet.sqljet 1.1.12.0.0
Linking: oracle.org.tmatesoft.svnkit.svnkit 1.10.0.0.0
Linking: oracle.oro.oro 2.0.8.0.0
Linking: oracle.osgi.alliance.osgi.cmpn 4.2.0.200908310645.0
Linking: oracle.osgi.alliance.osgi.core 5.0.0.201203141902.0
Linking: oracle.xerces.xercesimpl 2.12.0.0.0
Linking: oracle.xml.apis.xml.apis.ext 1.3.04.0.0
Linking: oracle.org.antlr.antlr.runtime 4.1.0.0.0
Linking: oracle.wls.inst.only 12.2.1.4.0
Linking: oracle.wls.shared.with.inst 12.2.1.4.0
Linking: oracle.jrf.dms 12.2.1.4.0
Linking: oracle.bali.share 12.2.1.4.0
Linking: oracle.bali.jewt 12.2.1.4.0
Linking: oracle.bali.ice 12.2.1.4.0
Linking: oracle.help.share 12.2.1.4.0
Linking: oracle.help.ohj 12.2.1.4.0
Linking: oracle.fmw.common.wizard.resources 12.2.1.0.0
Linking: oracle.wls.security.core.sharedlib 12.2.1.4.0
Linking: oracle.wls.jrf.tenancy.ee.only.sharedlib 12.2.1.4.0
Linking: oracle.xdk.jrf.xmlparserv2 12.2.1.4.0
Linking: oracle.xdk.jrf.fmw 12.2.1.4.0
Linking: oracle.xdk.jrf 12.2.1.4.0
Linking: oracle.jrf.thirdparty.toplink 12.2.1.4.0
Linking: oracle.wls.thirdparty.javax.json 12.2.1.4.0
Linking: oracle.jrf.toplink 12.2.1.4.0
Linking: oracle.mysql 8.0.14.0.0
Linking: oracle.datadirect 12.2.1.4.0
Linking: oracle.rsa.crypto 12.2.1.4.0
Linking: oracle.pki 12.2.1.4.0
Linking: oracle.osdt.core 12.2.1.4.0
Linking: oracle.glcm.encryption 2.7.4.0.0
Linking: oracle.java.jaxws 12.2.1.4.0
Linking: oracle.java.xml.bind 2.3.0.0.0
Linking: oracle.java.activation 12.2.1.4.0
Linking: oracle.glcm.opatch.common.api 13.9.4.0.0
Linking: oracle.nginst.common 13.9.4.0.0
Linking: oracle.nginst.core 13.9.4.0.0
Linking: oracle.nginst.thirdparty 13.9.4.0.0
Linking: oracle.jaxb.tools 2.3.0.0.0
Linking: oracle.jaxb.impl 2.3.0.0.0
Linking: oracle.jaxb.core 2.3.0.0.0
Linking: oracle.toplink.coherence 12.2.1.4.0
Linking: oracle.toplink.dbwslib 12.2.1.4.0
Linking: oracle.toplink.doc 12.2.1.4.0
Linking: oracle.toplink.developer 12.2.1.4.0
Linking: oracle.wls.libraries 12.2.1.4.0
Linking: oracle.rcu.ciestb 12.2.1.4.0
Linking: oracle.commons.cli.commons.cli 1.2.0.0.0
Linking: oracle.javavm.jrf 19.3.0.0.0
Linking: oracle.coherence.discovery 12.2.1.4.0
Linking: oracle.coherence 12.2.1.4.0
Linking: oracle.jrf.adfrt.help 12.2.1.4.0
Linking: oracle.jrf.adfrt.batik 12.2.1.4.0
Linking: oracle.jrf.adfrt.javatools 12.2.1.4.0
Linking: oracle.swd.opatch 13.9.4.2.1
Linking: oracle.rda 19.3.19.8.2
Linking: oracle.wls.jrf.tenancy.common 12.2.1.4.0
Linking: oracle.as.install.common.help 12.2.1.4.0
Linking: oracle.as.install.common.prerequisite.files 12.2.1.4.0
Linking: oracle.as.install.ui.framework 12.2.1.4.0
Linking: org.codehaus.woodstox 4.2.0.0.0
Linking: oracle.webservices.orawsdl 12.2.1.4.0
Linking: oracle.http_client 12.2.1.4.0
Linking: oracle.webservices.base 12.2.1.4.0
Linking: oracle.as.install.odi 12.2.1.4.0
Linking: oracle.as.install.odi.prerequisite 12.2.1.4.0
Linking: oracle.org.codehaus.jackson.jackson.core.asl 1.9.11.0.0
Linking: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.11.0.0
Linking: com.bea.core.xml.xmlbeans 2.6.0.6.0
Linking: oracle.wls.security.core 12.2.1.4.0
Linking: oracle.wls.common.cam 12.2.1.4.0
Linking: oracle.wls.common.nodemanager 12.2.1.4.0
Linking: oracle.wls.common.cam.wlst 12.2.1.4.0
Linking: oracle.wls.shared.with.cam 12.2.1.4.0
Linking: oracle.webservices.wls 12.2.1.4.0
Linking: oracle.wls.shared.with.inst.sharedlib 12.2.1.4.0
Linking: oracle.wls.jrf.tenancy.common.sharedlib 12.2.1.4.0
Linking: oracle.wsm.common 12.2.1.4.0
Linking: oracle.wsm.agent.fmw 12.2.1.4.0
Linking: oracle.webservices.jrf 12.2.1.4.0
Linking: oracle.webservices.jaxrs.jrf 12.2.1.4.0
Linking: oracle.ide.usages.tracking 12.2.1.4.0
Linking: oracle.jrf.tenancy 12.2.1.4.0
Linking: oracle.jrf.tenancy.se 12.2.1.4.0
Linking: oracle.glcm.opatchauto.core 13.9.4.2.0
Linking: oracle.jrf.tenancy.ee 12.2.1.4.0
Linking: oracle.fmwconfig.common.shared 12.2.1.4.0
Linking: oracle.fmwconfig.common.config.shared 12.2.1.4.0
Linking: oracle.fmwconfig.common.wls.help 12.2.1.4.0
Linking: oracle.fmwconfig.common.wls.shared.internal 12.2.1.4.0
Linking: oracle.fmw.upgrade.fmwconfig 12.2.1.4.0
Linking: oracle.owasp.jrf 12.2.1.4.0
Linking: oracle.glcm.schema.version.registry 12.2.1.4.0
Linking: oracle.rcu.doc 12.2.1.4.0
Linking: oracle.sysman.rcu 12.2.1.4.0
Linking: oracle.common.rcu.config 12.2.1.4.0
Linking: oracle.wls.rcu 12.2.1.4.0
Linking: oracle.wls.core.app.server 12.2.1.4.0
Linking: oracle.fmwconfig.common.cam.shared 12.2.1.4.0
Linking: oracle.rcu.shared 12.2.1.4.0
Linking: oracle.fmwconfig.wls 12.2.1.4.0
Linking: oracle.fmwconfig.common.wls.internal 12.2.1.4.0
Linking: oracle.odi.jse.template 12.2.1.4.0
Linking: oracle.wls.evaluation.database 12.2.1.4.0
Linking: oracle.velocity.velocity.v_dev 1.4.0.0.0
Linking: oracle.org.apache.httpcomponents.httpmime 4.5.1.0.0
Linking: oracle.fmwconfig.common.cam 12.2.1.4.0
Linking: oracle.rcu.opss 12.2.1.4.0
Linking: oracle.rcu.iau 12.2.1.4.0
Linking: oracle.java.servlet 12.2.1.4.0
Linking: oracle.jrf.adfrt 12.2.1.4.0
Linking: oracle.wls.shared.with.coh.standalone 12.2.1.4.0
Linking: oracle.wls.wlsportable.mod 12.2.1.4.0
Linking: oracle.wls.core.app.server.tier1nativelib 12.2.1.4.0
Linking: oracle.wls.clients 12.2.1.4.0
Linking: oracle.wls.cam.wlst 12.2.1.4.0
Linking: oracle.org_javassist_javassist.v_ga 3.20.0.0.0
Linking: oracle.org.eclipse.jetty.jetty.xml.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.webapp.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.util.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.servlet.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.server.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.security.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.io.vv 9.2.2.0.20140723
Linking: oracle.org.eclipse.jetty.jetty.http.vv 9.2.2.0.20140723
Linking: oracle.commons.io.commons.io 2.2.0.0.0
Linking: oracle.commons.collections.commons.collections 3.2.2.0.0
Linking: oracle.commons.cli.commons.cli 1.1.0.0.0
Linking: oracle.com.google.code.gson.gson 2.6.2.0.0
Linking: oracle.odi.tp 12.2.1.4.0
Linking: oracle.fmwplatform.fmwprov 12.2.1.4.0
Linking: oracle.fmwplatform.ocp 12.2.1.4.0
Linking: oracle.glcm.opatchauto.fmw 13.9.4.2.0
Linking: oracle.commons.beanutils.commons.beanutils 1.9.3.0.0
Linking: oracle.apache.commons.lang.mod 2.6.0.0.2
Linking: oracle.apache.commons.collections.mod 3.2.0.0.2
Linking: oracle.jersey 12.1.3.0.0
Linking: oracle.nlspdk 12.2.1.4.0
Linking: oracle.nlsgdk 12.2.1.4.0
Linking: oracle.jrf.j2ee 12.2.1.4.0
Linking: oracle.jrf.infra.common 12.2.1.4.0
Linking: oracle.jrf.thirdparty.jee 12.2.1.4.0
Linking: oracle.jrf.iau 12.2.1.4.0
Linking: oracle.ids.core 12.2.1.4.0
Linking: oracle.opss.core 12.2.1.4.0
Linking: oracle.jmx 12.2.1.4.0
Linking: oracle.jsp 12.2.1.4.0
Linking: oracle.legacy_oc4j_xml_schemas 12.2.1.4.0
Linking: oracle.rdbms.ras 12.1.0.2.0
Linking: oracle.opss.wls 12.2.1.4.0
Linking: oracle.fmw.upgrade 12.2.1.4.0
Linking: oracle.fmw.upgrade.help 12.2.1.4.0
Linking: oracle.ons.generic 12.2.1.4.0
Linking: oracle.diagnostics.common 12.2.1.4.0
Linking: oracle.wls.workshop.code.completion.support 12.2.1.4.0
Linking: oracle.wls.admin.console.en 12.2.1.4.0
Linking: oracle.wls.http.pubsub.server 12.2.1.4.0
Linking: oracle.wls.weblogic.sca 12.2.1.4.0
Linking: oracle.wls.admin.console.nonen 12.2.1.4.0
Linking: oracle.ide.vhv 12.2.1.4.0
Linking: oracle.ide.fcp 12.2.1.4.0
Linking: oracle.ide.help.extras 12.2.1.4.0
Linking: oracle.ide.modeler 12.2.1.4.0
Linking: oracle.ide.diagram 12.2.1.4.0
Linking: oracle.ide.xmlef 12.2.1.4.0
Linking: oracle.ide.java 12.2.1.4.0
Linking: oracle.org.antlr.antlr 4.1.0.0.0
Linking: oracle.ide.groovy 12.2.1.4.0
Linking: oracle.org.json.json 20131018.0.0.0.0
Linking: oracle.glcm.fmw.chghost 12.2.1.4.0
Linking: oracle.mds.dumputil 12.2.1.4.0
Linking: oracle.rcu.mds 12.2.1.4.0
Linking: oracle.rcu.ucs.messaging 12.2.1.3.0
Linking: oracle.wsm.console.core 12.2.1.4.0
Linking: oracle.jgroups 12.2.1.0.0
Linking: oracle.jsch 12.2.1.0.0
Linking: oracle.bali.ewt 12.2.1.4.0
Linking: oracle.pwdgen.jrf 12.2.1.4.0
Linking: oracle.jrf.infra.fmw.common 12.2.1.4.0
Linking: oracle.jrf.applcore 12.2.1.4.0
Linking: oracle.wsm.pmlib 12.2.1.4.0
Linking: oracle.wsm.jrf 12.2.1.4.0
Linking: oracle.ids.jrf 12.2.1.4.0
Linking: oracle.opss.jrf 12.2.1.4.0
Linking: oracle.osdt.jrf 12.2.1.4.0
Linking: oracle.sslconfig.jrf 12.2.1.4.0
Linking: oracle.ldap.jrf 12.2.1.4.0
Linking: oracle.sdp.messaging 12.2.1.3.0
Linking: oracle.help.ohw.rcf 12.2.1.4.0
Linking: oracle.help.ohw.share 12.2.1.4.0
Linking: oracle.help.ohw.uix 12.2.1.4.0
Linking: oracle.webcenter.wccore 12.2.1.4.0
Linking: oracle.bali.cabo 12.2.1.4.0
Linking: oracle.ide.rescat2 12.2.1.4.0
Linking: oracle.ide.db.connection 12.2.1.4.0
Linking: oracle.ide.webservice.analyzer 12.2.1.4.0
Linking: oracle.jrf.infra.fmw.wls 12.2.1.4.0
Linking: oracle.wsm.agent.wls 12.2.1.4.0
Linking: oracle.soa.all.client 12.2.1.4.0
Linking: oracle.sysman.fmw.core 12.2.1.4.0
Linking: oracle.sysman.fmw.as 12.2.1.4.0
Linking: oracle.sysman.fmw.agent 12.2.1.4.0
Linking: oracle.log4j.log4j 1.2.17.16.0
Linking: oracle.org.codehaus.groovy.groovy.all 2.4.17.0.0
Linking: oracle.odi.oggstudio 12.2.1.4.0
Linking: oracle.odi.studio 12.2.1.4.0
Linking: oracle.datadirect.odi 12.2.1.4.0
Linking: oracle.as.install.onlinedoc.shortcut 12.2.1.4.0
Linking: oracle.odi.km 12.2.1.4.0
Linking: oracle.as.customqna.jdkqna 12.2.1.4.0
Linking Completed
Setting Up Installed Components
Setting Up: oracle.fmwconfig.wls.shared 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.wls.shared.external 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.wls.external 12.2.1.4.0
Setting Up: oracle.nlsoramapping.jrf 19.3.0.0.0
Setting Up: oracle.nlsrtl.jrf 19.3.0.0.0
Setting Up: oracle.xdk.jrf.jaxp 12.2.1.4.0
Setting Up: oracle.rdbms.jrf 19.3.0.0.0
Setting Up: oracle.glcm.logging 1.6.4.0.0
Setting Up: oracle.glcm.comdev 7.8.4.0.0
Setting Up: oracle.glcm.dependency 1.8.4.0.0
Setting Up: oracle.glcm.xmldh 3.4.4.0.0
Setting Up: oracle.glcm.wizard 7.8.4.0.0
Setting Up: oracle.jse.dms 12.2.1.4.0
Setting Up: oracle.jrf.dms.common 12.2.1.4.0
Setting Up: oracle.thirdparty.maven 3.2.5.0.0
Setting Up: oracle.jrf.maven.plugins.sync 12.2.1.4.0
Setting Up: oracle.oamclient.core 12.2.1.4.0
Setting Up: oracle.oamclient.wls 12.2.1.4.0
Setting Up: oracle.odi.sdk 12.2.1.4.0
Setting Up: oracle.odi.agent 12.2.1.4.0
Setting Up: oracle.ant.contrib.ant.contrib.vb 1.0.0.0.3
Setting Up: oracle.bsf.bsf 2.4.0.0.0
Setting Up: oracle.cglib.cglib.nodep 3.2.5.0.0
Setting Up: oracle.com.fasterxml_classmate 1.3.1.0.0
Setting Up: oracle.com.fasterxml.jackson.core.jackson.annotations 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.core.jackson.core 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.core.jackson.databind 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.dataformat.jackson.dataformat.xml 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.base 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.jaxrs.jackson.jaxrs.json.provider 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.module.jackson.module.jaxb.annotations 2.9.9.0.0
Setting Up: oracle.com.fasterxml.jackson.module.jackson.module.jsonschema 2.9.9.0.0
Setting Up: oracle.com.fasterxml.woodstox.woodstox.core 5.2.0.0.0
Setting Up: oracle.com.google.guava.failureaccess 1.0.1.0.0
Setting Up: oracle.com.google.guava.guava 27.1.0.0.0
Setting Up: oracle.com.googlecode.owasp_java.html.sanitizer.owasp_java.html.sanitizer 20190325.1.0.0.0
Setting Up: oracle.com.ibm.jbatch.com.ibm.jbatch.container 1.0.3.0.0
Setting Up: oracle.com.ibm.jbatch.com.ibm.jbatch.spi 1.0.3.0.0
Setting Up: oracle.com.jayway.jsonpath.json.path 2.2.0.0.0
Setting Up: oracle.com.jcraft.jsch 0.1.54.0.0
Setting Up: oracle.com.jcraft.jsch.com.jcraft.jsch 0.1.53.0.0
Setting Up: oracle.com.jcraft.jzlib.com.jcraft.jzlib 1.0.7.0.0
Setting Up: oracle.com.miglayout.miglayout 4.0.0.0.0
Setting Up: oracle.com.trilead.trilead.ssh2.v_build 1.0.0.0.221
Setting Up: oracle.commons.cli.commons.cli 1.3.1.0.0
Setting Up: oracle.commons.codec.commons.codec 1.11.0.0.0
Setting Up: oracle.commons.discovery.commons.discovery 0.5.0.0.0
Setting Up: oracle.commons.fileupload.commons.fileupload 1.4.0.0.0
Setting Up: oracle.commons.httpclient.commons.httpclient 3.1.0.0.0
Setting Up: oracle.commons.io.commons.io 2.6.0.0.0
Setting Up: oracle.commons.lang.commons.lang 2.6.0.0.0
Setting Up: oracle.commons.logging.commons.logging 1.2.0.0.1
Setting Up: oracle.commons.net.commons.net 3.5.0.0.0
Setting Up: oracle.de.regnis.q.sequence.sequence.library 1.0.4.0.0
Setting Up: oracle.france.telecom.org.objectweb.asm.all 5.0.1.0.0
Setting Up: oracle.jdesktop.jxlayer 4.0.0.0.0
Setting Up: oracle.joda.time.joda.time 2.10.0.0.0
Setting Up: oracle.log4j.log4j 2.11.1.0.0
Setting Up: oracle.net.sourceforge.nekohtml.nekohtml 1.9.16.0.0
Setting Up: oracle.org.apache.ant.ant 1.9.8.0.0
Setting Up: oracle.org.apache.ant.ant.bundle 1.10.5.0.0
Setting Up: oracle.org.apache.ant.ant.launcher 1.9.8.0.0
Setting Up: oracle.org.apache.commons.commons.compress 1.9.0.0.0
Setting Up: oracle.org.apache.commons.commons.digester3 3.2.0.0.0
Setting Up: oracle.org.apache.commons.commons.lang3 3.8.1.0.0
Setting Up: oracle.org.apache.commons.commons.vfs2 2.2.0.0.0
Setting Up: oracle.org.apache.extras.beanshell.bsh.vb 2.0.0.0.6
Setting Up: oracle.org.apache.httpcomponents.httpclient 4.5.6.0.0
Setting Up: oracle.org.apache.httpcomponents.httpclient.cache 4.5.1.0.0
Setting Up: oracle.org.apache.httpcomponents.httpcore 4.4.10.0.0
Setting Up: oracle.org.apache.jakarta.commons.el 1.0.0.0.0
Setting Up: oracle.org.apache.ws.commons.schema_xmlschema 1.4.7.0.0
Setting Up: oracle.org.apache.xmlgraphics.batik.all 1.11.0.0.1
Setting Up: oracle.org.apache.xmlgraphics.batik.bundle 1.11.0.0.1
Setting Up: oracle.org.bouncycastle.bcpkix.jdk15on 1.60.0.0.0
Setting Up: oracle.org.bouncycastle.bcprov.ext.jdk15on 1.60.0.0.0
Setting Up: oracle.org.bouncycastle.bcprov.jdk15on 1.60.0.0.0
Setting Up: oracle.org.codehaus.groovy.groovy.all 2.5.6.0.0
Setting Up: oracle.org.codehaus.jackson.jackson.core.asl 1.9.13.0.0
Setting Up: oracle.org.codehaus.jackson.jackson.jaxrs 1.9.13.0.0
Setting Up: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.13.0.0
Setting Up: oracle.org.codehaus.jackson.jackson.xc 1.9.13.0.0
Setting Up: oracle.org.codehaus.woodstox.stax2.api 4.2.0.0.0
Setting Up: oracle.org.codehaus.woodstox.wstx.asl 3.2.9.0.0
Setting Up: oracle.org_dom4j_dom4j 2.1.1.0.0
Setting Up: oracle.org.eclipse.equinox.org.eclipse.equinox.common.vv 3.6.0.0.20100503
Setting Up: oracle.org.eclipse.jetty.jetty.jndi.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.plus.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jgit.org.eclipse.jgit.v_r 5.2.0.201812061821.0
Setting Up: oracle.org.eclipse.org.eclipse.osgi.singleton 3.9.1.0.0
Setting Up: oracle.org.hsqldb.hsqldb 2.4.1.0.0
Setting Up: oracle.org.jboss.logging.jboss.logging.vfinal 3.3.0.0.0
Setting Up: oracle.org.jfree.jfreechart 1.5.0.0.0
Setting Up: oracle.org.owasp.esapi.esapi 2.1.0.1.0
Setting Up: oracle.org.python.jython.standalone 2.7.1.0.1
Setting Up: oracle.org.slf4j.slf4j.api 1.7.26.0.0
Setting Up: oracle.org.slf4j.slf4j.simple 1.7.26.0.0
Setting Up: oracle.org.springframework.spring.aop.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.aspects.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.beans.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.context.indexer.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.context.support.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.context.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.core.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.expression.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.instrument.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.jcl.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.jdbc.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.jms.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.messaging.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.orm.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.oxm.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.test.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.tx.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.web.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.webflux.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.webmvc.vrelease 5.1.3.0.0
Setting Up: oracle.org.springframework.spring.websocket.vrelease 5.1.3.0.0
Setting Up: oracle.org.tmatesoft.sqljet.sqljet 1.1.12.0.0
Setting Up: oracle.org.tmatesoft.svnkit.svnkit 1.10.0.0.0
Setting Up: oracle.oro.oro 2.0.8.0.0
Setting Up: oracle.osgi.alliance.osgi.cmpn 4.2.0.200908310645.0
Setting Up: oracle.osgi.alliance.osgi.core 5.0.0.201203141902.0
Setting Up: oracle.xerces.xercesimpl 2.12.0.0.0
Setting Up: oracle.xml.apis.xml.apis.ext 1.3.04.0.0
Setting Up: oracle.org.antlr.antlr.runtime 4.1.0.0.0
Setting Up: oracle.wls.inst.only 12.2.1.4.0
Setting Up: oracle.wls.shared.with.inst 12.2.1.4.0
Setting Up: oracle.jrf.dms 12.2.1.4.0
Setting Up: oracle.bali.share 12.2.1.4.0
Setting Up: oracle.bali.jewt 12.2.1.4.0
Setting Up: oracle.bali.ice 12.2.1.4.0
Setting Up: oracle.help.share 12.2.1.4.0
Setting Up: oracle.help.ohj 12.2.1.4.0
Setting Up: oracle.fmw.common.wizard.resources 12.2.1.0.0
Setting Up: oracle.wls.security.core.sharedlib 12.2.1.4.0
Setting Up: oracle.wls.jrf.tenancy.ee.only.sharedlib 12.2.1.4.0
Setting Up: oracle.xdk.jrf.xmlparserv2 12.2.1.4.0
Setting Up: oracle.xdk.jrf.fmw 12.2.1.4.0
Setting Up: oracle.xdk.jrf 12.2.1.4.0
Setting Up: oracle.jrf.thirdparty.toplink 12.2.1.4.0
Setting Up: oracle.wls.thirdparty.javax.json 12.2.1.4.0
Setting Up: oracle.jrf.toplink 12.2.1.4.0
Setting Up: oracle.mysql 8.0.14.0.0
Setting Up: oracle.datadirect 12.2.1.4.0
Setting Up: oracle.rsa.crypto 12.2.1.4.0
Setting Up: oracle.pki 12.2.1.4.0
Setting Up: oracle.osdt.core 12.2.1.4.0
Setting Up: oracle.glcm.encryption 2.7.4.0.0
Setting Up: oracle.java.jaxws 12.2.1.4.0
Setting Up: oracle.java.xml.bind 2.3.0.0.0
Setting Up: oracle.java.activation 12.2.1.4.0
Setting Up: oracle.glcm.opatch.common.api 13.9.4.0.0
Setting Up: oracle.nginst.common 13.9.4.0.0
Setting Up: oracle.nginst.core 13.9.4.0.0
Setting Up: oracle.nginst.thirdparty 13.9.4.0.0
Setting Up: oracle.jaxb.tools 2.3.0.0.0
Setting Up: oracle.jaxb.impl 2.3.0.0.0
Setting Up: oracle.jaxb.core 2.3.0.0.0
Setting Up: oracle.toplink.coherence 12.2.1.4.0
Setting Up: oracle.toplink.dbwslib 12.2.1.4.0
Setting Up: oracle.toplink.doc 12.2.1.4.0
Setting Up: oracle.toplink.developer 12.2.1.4.0
Setting Up: oracle.wls.libraries 12.2.1.4.0
Setting Up: oracle.rcu.ciestb 12.2.1.4.0
Setting Up: oracle.commons.cli.commons.cli 1.2.0.0.0
Setting Up: oracle.javavm.jrf 19.3.0.0.0
Setting Up: oracle.coherence.discovery 12.2.1.4.0
Setting Up: oracle.coherence 12.2.1.4.0
Setting Up: oracle.jrf.adfrt.help 12.2.1.4.0
Setting Up: oracle.jrf.adfrt.batik 12.2.1.4.0
Setting Up: oracle.jrf.adfrt.javatools 12.2.1.4.0
Setting Up: oracle.swd.opatch 13.9.4.2.1
Setting Up: oracle.rda 19.3.19.8.2
Setting Up: oracle.wls.jrf.tenancy.common 12.2.1.4.0
Setting Up: oracle.as.install.common.help 12.2.1.4.0
Setting Up: oracle.as.install.common.prerequisite.files 12.2.1.4.0
Setting Up: oracle.as.install.ui.framework 12.2.1.4.0
Setting Up: org.codehaus.woodstox 4.2.0.0.0
Setting Up: oracle.webservices.orawsdl 12.2.1.4.0
Setting Up: oracle.http_client 12.2.1.4.0
Setting Up: oracle.webservices.base 12.2.1.4.0
Setting Up: oracle.as.install.odi 12.2.1.4.0
Setting Up: oracle.as.install.odi.prerequisite 12.2.1.4.0
Setting Up: oracle.org.codehaus.jackson.jackson.core.asl 1.9.11.0.0
Setting Up: oracle.org.codehaus.jackson.jackson.mapper.asl 1.9.11.0.0
Setting Up: com.bea.core.xml.xmlbeans 2.6.0.6.0
Setting Up: oracle.wls.security.core 12.2.1.4.0
Setting Up: oracle.wls.common.cam 12.2.1.4.0
Setting Up: oracle.wls.common.nodemanager 12.2.1.4.0
Setting Up: oracle.wls.common.cam.wlst 12.2.1.4.0
Setting Up: oracle.wls.shared.with.cam 12.2.1.4.0
Setting Up: oracle.webservices.wls 12.2.1.4.0
Setting Up: oracle.wls.shared.with.inst.sharedlib 12.2.1.4.0
Setting Up: oracle.wls.jrf.tenancy.common.sharedlib 12.2.1.4.0
Setting Up: oracle.wsm.common 12.2.1.4.0
Setting Up: oracle.wsm.agent.fmw 12.2.1.4.0
Setting Up: oracle.webservices.jrf 12.2.1.4.0
Setting Up: oracle.webservices.jaxrs.jrf 12.2.1.4.0
Setting Up: oracle.ide.usages.tracking 12.2.1.4.0
Setting Up: oracle.jrf.tenancy 12.2.1.4.0
Setting Up: oracle.jrf.tenancy.se 12.2.1.4.0
Setting Up: oracle.glcm.opatchauto.core 13.9.4.2.0
Setting Up: oracle.jrf.tenancy.ee 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.shared 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.config.shared 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.wls.help 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.wls.shared.internal 12.2.1.4.0
Setting Up: oracle.fmw.upgrade.fmwconfig 12.2.1.4.0
Setting Up: oracle.owasp.jrf 12.2.1.4.0
Setting Up: oracle.glcm.schema.version.registry 12.2.1.4.0
Setting Up: oracle.rcu.doc 12.2.1.4.0
Setting Up: oracle.sysman.rcu 12.2.1.4.0
Setting Up: oracle.common.rcu.config 12.2.1.4.0
Setting Up: oracle.wls.rcu 12.2.1.4.0
Setting Up: oracle.wls.core.app.server 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.cam.shared 12.2.1.4.0
Setting Up: oracle.rcu.shared 12.2.1.4.0
Setting Up: oracle.fmwconfig.wls 12.2.1.4.0
Setting Up: oracle.fmwconfig.common.wls.internal 12.2.1.4.0
Setting Up: oracle.odi.jse.template 12.2.1.4.0
Setting Up: oracle.wls.evaluation.database 12.2.1.4.0
Setting Up: oracle.velocity.velocity.v_dev 1.4.0.0.0
Setting Up: oracle.org.apache.httpcomponents.httpmime 4.5.1.0.0
Setting Up: oracle.fmwconfig.common.cam 12.2.1.4.0
Setting Up: oracle.rcu.opss 12.2.1.4.0
Setting Up: oracle.rcu.iau 12.2.1.4.0
Setting Up: oracle.java.servlet 12.2.1.4.0
Setting Up: oracle.jrf.adfrt 12.2.1.4.0
Setting Up: oracle.wls.shared.with.coh.standalone 12.2.1.4.0
Setting Up: oracle.wls.wlsportable.mod 12.2.1.4.0
Setting Up: oracle.wls.core.app.server.tier1nativelib 12.2.1.4.0
Setting Up: oracle.wls.clients 12.2.1.4.0
Setting Up: oracle.wls.cam.wlst 12.2.1.4.0
Setting Up: oracle.org_javassist_javassist.v_ga 3.20.0.0.0
Setting Up: oracle.org.eclipse.jetty.jetty.xml.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.webapp.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.util.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.servlet.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.server.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.security.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.io.vv 9.2.2.0.20140723
Setting Up: oracle.org.eclipse.jetty.jetty.http.vv 9.2.2.0.20140723
Setting Up: oracle.commons.io.commons.io 2.2.0.0.0
Setting Up: oracle.commons.collections.commons.collections 3.2.2.0.0
Setting Up: oracle.commons.cli.commons.cli 1.1.0.0.0
Setting Up: oracle.com.google.code.gson.gson 2.6.2.0.0
Setting Up: oracle.odi.tp 12.2.1.4.0
Setting Up: oracle.fmwplatform.fmwprov 12.2.1.4.0
Setting Up: oracle.fmwplatform.ocp 12.2.1.4.0
Setting Up: oracle.glcm.opatchauto.fmw 13.9.4.2.0
Setting Up: oracle.commons.beanutils.commons.beanutils 1.9.3.0.0
Setting Up: oracle.apache.commons.lang.mod 2.6.0.0.2
Setting Up: oracle.apache.commons.collections.mod 3.2.0.0.2
Setting Up: oracle.jersey 12.1.3.0.0
Setting Up: oracle.nlspdk 12.2.1.4.0
Setting Up: oracle.nlsgdk 12.2.1.4.0
Setting Up: oracle.jrf.j2ee 12.2.1.4.0
Setting Up: oracle.jrf.infra.common 12.2.1.4.0
Setting Up: oracle.jrf.thirdparty.jee 12.2.1.4.0
Setting Up: oracle.jrf.iau 12.2.1.4.0
Setting Up: oracle.ids.core 12.2.1.4.0
Setting Up: oracle.opss.core 12.2.1.4.0
Setting Up: oracle.jmx 12.2.1.4.0
Setting Up: oracle.jsp 12.2.1.4.0
Setting Up: oracle.legacy_oc4j_xml_schemas 12.2.1.4.0
Setting Up: oracle.rdbms.ras 12.1.0.2.0
Setting Up: oracle.opss.wls 12.2.1.4.0
Setting Up: oracle.fmw.upgrade 12.2.1.4.0
Setting Up: oracle.fmw.upgrade.help 12.2.1.4.0
Setting Up: oracle.ons.generic 12.2.1.4.0
Setting Up: oracle.diagnostics.common 12.2.1.4.0
Setting Up: oracle.wls.workshop.code.completion.support 12.2.1.4.0
Setting Up: oracle.wls.admin.console.en 12.2.1.4.0
Setting Up: oracle.wls.http.pubsub.server 12.2.1.4.0
Setting Up: oracle.wls.weblogic.sca 12.2.1.4.0
Setting Up: oracle.wls.admin.console.nonen 12.2.1.4.0
Setting Up: oracle.ide.vhv 12.2.1.4.0
Setting Up: oracle.ide.fcp 12.2.1.4.0
Setting Up: oracle.ide.help.extras 12.2.1.4.0
Setting Up: oracle.ide.modeler 12.2.1.4.0
Setting Up: oracle.ide.diagram 12.2.1.4.0
Setting Up: oracle.ide.xmlef 12.2.1.4.0
Setting Up: oracle.ide.java 12.2.1.4.0
Setting Up: oracle.org.antlr.antlr 4.1.0.0.0
Setting Up: oracle.ide.groovy 12.2.1.4.0
Setting Up: oracle.org.json.json 20131018.0.0.0.0
Setting Up: oracle.glcm.fmw.chghost 12.2.1.4.0
Setting Up: oracle.mds.dumputil 12.2.1.4.0
Setting Up: oracle.rcu.mds 12.2.1.4.0
Setting Up: oracle.rcu.ucs.messaging 12.2.1.3.0
Setting Up: oracle.wsm.console.core 12.2.1.4.0
Setting Up: oracle.jgroups 12.2.1.0.0
Setting Up: oracle.jsch 12.2.1.0.0
Setting Up: oracle.bali.ewt 12.2.1.4.0
Setting Up: oracle.pwdgen.jrf 12.2.1.4.0
Setting Up: oracle.jrf.infra.fmw.common 12.2.1.4.0
Setting Up: oracle.jrf.applcore 12.2.1.4.0
Setting Up: oracle.wsm.pmlib 12.2.1.4.0
Setting Up: oracle.wsm.jrf 12.2.1.4.0
Setting Up: oracle.ids.jrf 12.2.1.4.0
Setting Up: oracle.opss.jrf 12.2.1.4.0
Setting Up: oracle.osdt.jrf 12.2.1.4.0
Setting Up: oracle.sslconfig.jrf 12.2.1.4.0
Setting Up: oracle.ldap.jrf 12.2.1.4.0
Setting Up: oracle.sdp.messaging 12.2.1.3.0
Setting Up: oracle.help.ohw.rcf 12.2.1.4.0
Setting Up: oracle.help.ohw.share 12.2.1.4.0
Setting Up: oracle.help.ohw.uix 12.2.1.4.0
Setting Up: oracle.webcenter.wccore 12.2.1.4.0
Setting Up: oracle.bali.cabo 12.2.1.4.0
Setting Up: oracle.ide.rescat2 12.2.1.4.0
Setting Up: oracle.ide.db.connection 12.2.1.4.0
Setting Up: oracle.ide.webservice.analyzer 12.2.1.4.0
Setting Up: oracle.jrf.infra.fmw.wls 12.2.1.4.0
Setting Up: oracle.wsm.agent.wls 12.2.1.4.0
Setting Up: oracle.soa.all.client 12.2.1.4.0
Setting Up: oracle.sysman.fmw.core 12.2.1.4.0
Setting Up: oracle.sysman.fmw.as 12.2.1.4.0
Setting Up: oracle.sysman.fmw.agent 12.2.1.4.0
Setting Up: oracle.log4j.log4j 1.2.17.16.0
Setting Up: oracle.org.codehaus.groovy.groovy.all 2.4.17.0.0
Setting Up: oracle.odi.oggstudio 12.2.1.4.0
Setting Up: oracle.odi.studio 12.2.1.4.0
Setting Up: oracle.datadirect.odi 12.2.1.4.0
Setting Up: oracle.as.install.onlinedoc.shortcut 12.2.1.4.0
Setting Up: oracle.odi.km 12.2.1.4.0
Setting Up: oracle.as.customqna.jdkqna 12.2.1.4.0
Setup Completed
Saving the inventory
Saving the inventory completed

Reference

https://docs.datastax.com/en/jdk-install/doc/jdk-install/installOracleJdkDeb.html

• After surfing the internet , found --> its due to one parameter.
• its nothing but PEERDNS.

Definition

The ifcfg parameter PEERDNS determines if the file /etc/resolv. conf is modified or not. If it is set to "yes", then the parameters DOMAIN, DNS1 and DNS2 will be used to set the search and nameserver entries in the file. If PEERDNS is set to "no", the file is not modified.

• Lets add and check,

$ cat /etc/sysconfig/network-scripts/ifcfg-eth1
TYPE=Ethernet
DEVICE=eth1
BOOTPROTO=dhcp
PEERDNS=no

• By default (so without further configuration/modification) overwrite /etc/resolv.confas soon as any network interfaces use DHCP. Depending on the exact version if initscripts/NetworkManager, "RESOLV_MODS=no" or "PEERDNS=no" in the relevant /etc/sysconfig/network-scripts/ifcfg-* files can prevent this.

• Implementation Pending.

Reference

https://support.hpe.com/hpesc/public/docDisplay?docId=kc0110350en_us&docLocale=en_US

https://serverfault.com/questions/934641/my-etc-resolv-conf-is-getting-reset-every-time-i-restart-the-network

Download Site

https://support.google.com/chrome/a/answer/9025926?hl=en&ref_topic=9025817&sjid=9687412310203740272-AP

https://www.google.com/chrome/?platform=linux

Downloaded File

google-chrome-stable_current_amd64.deb

Installation Steps

sudo dpkg -i google-chrome-stable_current_amd64.deb

UN-Install Chrome

sudo apt purge google-chrome-stable

TYPES

• Variable --> to store value.

• strongly typed language.

INT

• These are used to declare INTEGER values.

• upending two string in INT

• Testing with Negative values

FLOAT

STRING

COMPLEX

• It provides the real and imaginary value.

package main
import (
    "fmt"
)
func main() {
    var i complex64 = 2
    fmt.Println(i)
}

BOOLEAN

• Default value is FALSE.

package main
import (
    "fmt"
)
func main() {
    var i bool
    fmt.Println(i)
}

• Where it's used ? We can test with Condition.

package main
import (
    "fmt"
)
func main() {
    var i bool = 4 > 2
    fmt.Println(i)
}

CONSTANT

• You can define , and it can't be changed.

TYPE CONVERSION

• It can convert from one type to another type.

Notes

1. 1 byte = 8 bit ( high bit will be allocated to --> signature , 2 power 7 = 0 to 127 --> it accepts , range = -127 to +127 ) Eg., var i int8
2. uint --> Reservation will be ignored. So 0 to 128 , also negative value will not be assigned. --> unsigned Integer
3. 1 byte = uint8
4. rune = int32
5. Typed system is important because of the allocation of the memory.
6. Eg., Bank Balance can be negative, if you take loan && The element with the lowest freezing point is helium, which freezes at a temperature of approximately -272.2 degrees.
7. The Two’s Complement has unaltered positive numbers just like Sign-and-Magnitude and One’s Complement methods. The negative number is obtained by first determining the one’s complement of the relevant positive number and then adding “1” to it. The range of numbers is -128 to 0 to +127 and includes only one zero in the range.

Reference & Important Sites

https://go.dev/tour/basics/1
https://forums.tamillinuxcommunity.org/t/lets-learn-golang/1725/2
https://gitlab.com/mohan43u/letslearngolangdocs/-/blob/master/week0.org
https://go.dev/tour/list

To debug the shell script , you can use the below command.

v --> Verbose
x --> Debugging

set -vx

Variables

1. why we need ? A place in the memory in which the value is stored and can be used when you want.
2. Its like an address
3. Define the variable ? Where you want to store the value ? Defining the address --> variable_name=value
4. You can store number & string value.
5. variable_name -> No special character is allowed. only "_"
6. If you are storing string values , it needs to be in "".
7. How to retrieve ? $variable_name

Local Variable : It can be overridden.
Env Variable : which is available inside the script and also in parent shell.i.e Terminal = Parent Shell , every time you run a script it creates a child shell --> You need to remember this. --> EXPORT

If the variable is created in parent shell , all the child shell can receive it or access it. Those are called Env Variables.

If the variable created in child it wont be available in parent shell.

Special Variables

Command Line Arguments :

• $0 name of the script.
• Take max of 9 values.
• *$ * followed by something --> it will print something. that's the literal meaning.
• There is a concept called " NEGATION" --> you are forcing the linux not to consider the $. Eg., \$0 --> Hello Linux DONT CONSIDER AS $ and print , you just ignore or negate it.

$# *--> Total no of arguments used.
*$@ --> Display all the arguments.

$? --> Exit status of the previous command.

$$ --> Process ID of the current shell

shift --> arguments gets shifted each time.

List of API's

https://github.com/fawazahmed0/currency-api#readme
https://api.chucknorris.io/
https://github.com/public-apis/public-apis?tab=readme-ov-file#social

How to start ?

Json output

https://httpbin.org/get

Code

cat http_bin.py

import requests
mydata = requests.get("https://httpbin.org/get")
print(mydata)
data = mydata.json()
print(data)
result=data['headers']["Host"]
print(result)

Output

Links :

https://gitlab.com/parameshwar_a/pyfordevops/-/tree/main?ref_type=heads
https://gitlab.com/parameshwar_a/pyfordevops