Skip navigation
CategoryToolsDetail
CI + CD:
Jenkins

Steps

 

 

c:\tools\apache-tomcat-7.0.77\bin  startup.bat

cmd-> cd /

 

 

cd c:/tools

 

 

java -jar jenkins.war --httpPort=9090

 

 

http://localhost:9090/login?from=%2F

Go first at manage Jenkins-> Plugins, install plugins by looking at dependencies

 

 

ant.hpi

credentials (1).hpi

deploy.hpi

git-client.hpi

mapdb-api.hpi

scm-api.hpi

ssh-credentials (1).hpi

ssh-credentials.hpi

structs.hpi

subversion.hpi

wildfly-deployer.hpi

workflow-scm-step.hpi

workflow-step-api.hpi

 

 

 

 

Create and configure Jobs, run it and see the build and deployments happening using ant script.

http://localhost:9092/<appURL>

Code Quality:

 

SonarQube

cd C:\tools\apache-tomcat-7.0.77\bin

StartUp.bat

 

http://localhost:9000

 

admin admin

 

--

How to add project??

https://dzone.com/articles/how-quickly-get-started-sonar

 

https://docs.sonarqube.org/display/SONAR/Get+Started+in+Two+Minutes

install_directory>/conf/sonar-scanner.properties:

#----- Default SonarQube server

#sonar.host.url=http://localhost:9000

 

https://docs.sonarqube.org/display/SCAN/Analyzing+with+SonarQube+Scanner

Google Codepro Analytics:

What CodePro Offers:--

Code Analysis

JUnit Test Generation

Metrics

Code Coverage

Dependency Analysis

Similar Code Analysis

JUnit Test Editor

 

Eclipse->

Go to Help --> Install New Software

codepro - http://dl.google.com/eclipse/inst/codepro/latest/3.6  (installed on Oxygen)   <3.7>  4.2 

 

-

Release         Main Release   Platform version      Projects

Oxygen             June 2017                    

Neon            22 June 2016     4.6               

Mars            24 June 2015     4.5                 Mars Projects

Luna            25 June 2014     4.4                 Luna Projects (Integrated Java 8 support;[36] in the prior version, this was possible via a Java 8 patch plug-in)

Kepler          26 June 2013     4.3                 Kepler Projects

Juno            27 June 2012     4.2                 Juno Projects

Indigo          22 June 2011     3.7                 Indigo projects

Helios          23 June 2010     3.6                 Helios projects

 

More:-

https://help.eclipse.org/neon/index.jsp?topic=%2Forg.eclipse.jdt.doc.user%2FgettingStarted%2Fqs-junit.htm

https://courses.cs.washington.edu/courses/cse143/11wi/eclipse-tutorial/junit.shtml

 

 

http://junit-tools.org/index.php/getting-started

  http://stackoverflow.com/questions/10794008/create-junit-automatically

  http://tirthalpatel.blogspot.com/2014/02/static-code-analyzers-google-codepro-analytix.html

https://dzone.com/articles/codepro-integration-eclipse

http://self-learning-java-tutorial.blogspot.com/2015/06/codepro-tutorial.html

FindbugEclipse MarketPlace
Ecclema

Eclipse MarketPlace

http://marketplace.eclipse.org/content/eclemma-java-code-coverage/metrics#group-screenshots

http://www.jacoco.org/  EclEmma 2.3.3

Other

Configuring IntelliJ IDEA for unit testing with Junit

 

http://stackoverflow.com/questions/4757800/configuring-intellij-idea-for-unit-testing-with-junit

https://plugins.jetbrains.com/plugin/5847-generatetestcases

 

Other

https://randoop.github.io/randoop/

https://sourceforge.net/projects/junitgenerator/  demo.zip

Project TypeProcess(Agile)Tools/ Frameworkscomment
Java, J2EE, DatabaseAgile- Scrum-XP

Oracle Cloud Developer Services/ JIRA/ IBM RTC; TDD- JUnit,mockito, PowerMock;

Code Review- SonarQube;  CI/CD- Jenkins.; Monitoring: NewRelic

BigdataAgile- Scrum-XPHUE Console; Oracle BigData Lite, JIRA/ IBM RTC;
Support TicketsAgile- Kanbancommon; Jira-Kanban or Jira-Service Desk,
POC, RFPAgile- Leancommon, JIRA/ IBM RTC;
PHP MySQLAgile- Scrum -XPTDD- PHPUnit; Code Review- SonarQube; CI/CD- Jenkins, JIRA/ IBM RTC;
UX/UIAgile-Scrum-XPJSLint; Oracle- OJET, JIRA/ IBM RTC;
Infrastructure AutomationAgile-Scrum-XP-LeanPuppet; Jenkins; BitBucket, JIRA/ IBM RTC;

It was a challenging day to to troubleshoot the issue of cluster configuration failure while setting up 2 Node Oracle 11gR2(11.2.0.4) RAC cluster on Windows Server 2012 R2 operating system for one of our customer. At every attempt Grid Confuguration for cluster was getting failed while Installing Oracle Grid Infrastructure software for cluster.

 

InstallAction log did't have much clue about the GI configuration failure but rootcrs_racnode1.log located at $GRID_HOME\cfgtoollogs\rootcrs_racnode1.log file provided the root cause of cluster configuration failure which reveals that "The driver is not currently installed on this node."

 

Below is the entries from rootcrs_racnode1.log log file from Node 1.

 

 

From Log file : C:\app\11.2.0\grid\cfgtoollogs\rootcrs_racnode1.log

------------------------------------------------------

 

2016-06-09 08:22:36: The 'ROOTCRS_ACFSINST' is either in START/FAILED state

2016-06-09 08:22:36: Executing 'E:\app\11.2.0\grid\bin\acfsroot.bat install'

2016-06-09 08:22:36: Executing cmd: E:\app\11.2.0\grid\bin\acfsroot.bat install

2016-06-09 08:22:37: Command output:

>  ACFS-9300: ADVM/ACFS distribution files found.

>  ACFS-9307: Installing requested ADVM/ACFS software.

>  acfsinstall: ACFS-09420: The driver is not currently installed on this node.

>  acfsinstall: ACFS-09411: CreateService succeeded.

>  acfsinstall: CLSU-00100: Operating System function: StartDriver failed with error data: 31

>  acfsinstall: CLSU-00101: Operating System error message: A device attached to the system is not functioning.

>  acfsinstall: CLSU-00103: error location: StartDriver_

>  acfsinstall: CLSU-00104: additional error information: W

>  acfsinstall: ACFS-09419: StartService failed.

>  acfsinstall: ACFS-09401: Failed to install the driver.

>  ACFS-9340: failed to install OKS driver.

>  acfsinstall: ACFS-09420: The driver is not currently installed on this node.

>  acfsinstall: ACFS-09411: CreateService succeeded.

>  acfsinstall: CLSU-00100: Operating System function: StartDriver failed with error data: 1068

>  acfsinstall: CLSU-00101: Operating System error message: The dependency service or group failed to start.

>  acfsinstall: CLSU-00103: error location: StartDriver_

>  acfsinstall: CLSU-00104: additional error information: J

>  acfsinstall: ACFS-09419: StartService failed.

>  acfsinstall: ACFS-09401: Failed to install the driver.

>  ACFS-9340: failed to install ADVM driver.

>  acfsinstall: ACFS-09420: The driver is not currently installed on this node.

>  acfsinstall: ACFS-09411: CreateService succeeded.

>  acfsinstall: CLSU-00100: Operating System function: StartDriver failed with error data: 1068

>  acfsinstall: CLSU-00101: Operating System error message: The dependency service or group failed to start.

>  acfsinstall: CLSU-00103: error location: StartDriver_

>  acfsinstall: CLSU-00104: additional error information: ]

>  acfsinstall: ACFS-09419: StartService failed.

>  acfsinstall: ACFS-09401: Failed to install the driver.

>  ACFS-9340: failed to install ACFS driver.

>  ACFS-9310: ADVM/ACFS installation failed.

> End Command output

2016-06-09 08:22:37: E:\app\11.2.0\grid\bin\acfsroot.bat install ... failed

2016-06-09 08:22:37: USM driver install status is 0

2016-06-09 08:22:37: USM driver install actions failed

2016-06-09 08:22:37: Running as user Administrator: E:\app\11.2.0\grid\bin\cluutil -ckpt -oraclebase E:\app\Administrator -writeckpt -name ROOTCRS_ACFSINST -state FAIL

2016-06-09 08:22:37: s_run_as_user2: Running E:\app\11.2.0\grid\bin\cluutil -ckpt -oraclebase E:\app\Administrator -writeckpt -name ROOTCRS_ACFSINST -state FAIL

2016-06-09 08:22:37: E:\app\11.2.0\grid\bin\cluutil successfully executed

 

2016-06-09 08:22:37: Succeeded in writing the checkpoint:'ROOTCRS_ACFSINST' with status:FAIL

2016-06-09 08:22:37: CkptFile: E:\app\Administrator\Clusterware\ckptGridHA_win1.xml

2016-06-09 08:22:37: Sync the checkpoint file 'E:\app\Administrator\Clusterware\ckptGridHA_win1.xml'

 

 

 

 

Solutions :

=========

 

As per the logs pasted above, I came about an unpublished BUG 17927204 - ACFS SUPPORT FOR WINDOWS 2012R2  in Oracle Grid Infrastructure version 11.2.0.4 itself so in order to resolve the cluster configuration issue I download the one-off patch (p22839608_112040_MSWIN-x86-64) from MOS to be applied on #GRID_HOME binaries on both nodes in the cluster. And in order to apply the Patch mentioned above, you will have to download relevant Opatch utility (p6880880_112000_MSWIN-x86-64) from MOS.

 

Please refer MOS Doc ID 1987371.1 for its details.

 

 

Once you have downloaded both patches mentioned above please follow the below steps for successful Grid Infrastructure Installation.

 

 

1 - Clean the currently failed run of GI from both nodes (it includes deinstall of GI and removal of all related entries from Windows Registry.)

 

2 - Bounce the nodes once you are done with step 1.

 

3 - Run the GI Installer (setup.exe) for GI installation and choose to install Grid Infrastructure software only.

 

Note :- In step 3 you will have to install GI software on each individual nodes in the cluster as it won't do GI installation on remote nodes at once.

 

4 - Once the GI software(Software only) is installed on both the nodes then replace(or rename the existing Opatch directory in Grid Home. e.g. Opatch_old) Opatch folder in Grid Home with the one you have downloaded above (p6880880_112000_MSWIN-x86-64) on both nodes.

 

5 - Verify the Opatch utility is working fine with : opatch.exe lsinv command and apply the one-off patch(p22839608_112040_MSWIN-x86-64) on Grid Home at both nodes.

 

6 - After successful application of Opatch on both nodes, Start the Grid Infrastructure Configuration for the cluster as mentioned below.

 

Navigate to and run $GRID_HOME/crs/config/config.bat

 

Note : - It will launch GUI of Grid Infrastructure Configuration and proceed as per its steps gets prompted on interface. Please note that if your GI configuration still fails at 33% then don't just cancel the installation, just click OK on the error prompt and click on "Retry" to continue with the installation.

 

 

Hope it wold help to resolve the issue. RAC, ASM & Clusterware Installation

We heard count(1) is faster then count(*).  Lets do a workshop on this .

 

TABLE_STRACTURE.png

Above is Copy_customer table where inserted both null and not null values.

lets execute  the queries   Count(*)  and count(1) and  verify the result  and verify the work load.

count_star

count_1

In both cases query will return the same output. Now lets compare the work load of both the queries.

Let's check for count(*)

count_star_tk

Now Count(1)

count_1_tk

From  the above screen shot its clearly shows both  queries are taking  same amount of  work load to execute.

Now lets verify the same query  output and work load with actual column name instead  of '1' and '*'.

cnt_column-name.png

Now if check the below output it will ignore the null from the result and trace file also using the index.cnt_c_id-tk.png

Here Elapsed time is little more to count(1) and count(*). Because here it also fetches more then 90% record. This article is only to demonstrate count(1) and count(*) are same.

 

Thank you....for eading

Sometimes listener log file grows very large in size and we have to shrink that in order to reclaim space on the mount. I see some people just wonder how they can compress the listener log file while it is currently in use in production system as they can't just stop and start the listener to compress/rename the file as unavailability of listener will cause user connections to fail and that will be encountered as production outage by end user.

 

Below I have outlined two steps where we tell listener to stop logging in the listener log file and then rename/compress/purge the listener log file and finally we can tell listener back that it can start logging the info in the listener.log file.

 


Step : 1 - First of all turn off the logging status of listener using below command at lsnrctl prompt.

 

 

LSNRCTL> SET LOG_STATUS OFF Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=rac1.rajdbsolutions.com)(PORT=1522)) LISTENER parameter "log_status" set to OFF The command completed successfully

 

After the above step, go to listener log location and rename the listener.log file to something else e.g. Listener_old.log

 

Again turn back the listener logging ON using below command.

 

 

LSNRCTL> SET LOG_STATUS ON Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=rac1.rajdbsolutions.com)(PORT=1522)) LISTENER parameter "log_status" set to ON The command completed successfully

 

When you turn ON the listener log using above command, a new listener.log file will be created there and it will be used hereafter for database connectivity.

 

 

Hope it would help someone...!!

Sai Janakiram

Sangam15 - Highlights

Posted by Sai Janakiram Oct 12, 2015
  • Sangam is for the Oracle Users community to meet industry experts enhance your new skills and learn new technologies.
  • Sangam is a unique conference comprised of multiple tracks (Database, Applications, Middleware, Developer, Big Data, Oracle VM, Cloud, OS, PeopleSoft, Hands On Lab Sessions)
  • 90+ Speakers (Click here to see Sangam15 Speakers)
  • 2 days with 100+ sessions presented by experts from across the globe. Listen, learn and meet experts & industry leaders.
  • 8 Hands On Lab Sessions (New)
    • Oracle GoldenGate
    • Oracle Performance Tuning
    • Oracle VM/Linux
    • Oracle Big Data
  • Demo stations with Product experts are available to help you.Expert Panel – Unique panel of technology experts are available to answer your queries.
    • Oracle University
    • Oracle Support
    • Oracle VM/Linux
    • Oracle EM
    • Oracle Exadata
  • Sponsor’s Demo Stations – Experience Production solution from various vendors.
  • An estimated 800+ Technology peers from more than 150 companies to network and share ideas/best practices.
  • Closing Keynote Speaker - Dr.Rajdeep Manwani (Motivational Speaker)
  • You'll learn latest technology and experience all of Oracle's innovations in one place.
  • Amazing Venue – Hyderabad International Convention Centre, Novotel & HICC Complex, Hyderabad - five-star property.

AIOUG is a registered non-profit organization and we are all volunteers putting this conference together. To keep the registration costs low we dont use any event management services.  We definitely require all your help in promoting this event.  Remember more attendees at the conference would mean more opportunities to network will have more attendance.

 

Inform your clients/customers to attend this knowledge sharing event.

 

Post the attached icon on Facebook, tweet about the event, display this on your blog and linkedin pages.

 

Speakers... Registered Attendee or our sponsors  ..

 

As a gratitude of helping us promote this event, if you display this on any of the social media sites or blog you will be eligible for a special gift (with proof of display) during Sangam15.

 

Looking forward to your support and a great conference in November

 

http://www.aioug.org/sangam15/images/Ilikelogos/I_Like_This_Sangam15.jpg http://www.aioug.org/sangam15/images/Ilikelogos/I_M_Attending_Sangam15.jpg  http://www.aioug.org/sangam15/images/Ilikelogos/Join_Me.jpg  http://www.aioug.org/sangam15/images/Ilikelogos/See_Me_Here_Sangam15.jpg

 

  http://www.aioug.org/sangam15/images/Ilikelogos/I_M_Speaking_Sangam15.jpg

 

  http://www.aioug.org/sangam15/images/Ilikelogos/I_M_Sponsoring_Sangam15.jpg  http://www.aioug.org/sangam15/images/Ilikelogos/We_re_Sponsoring.jpg

Sai Janakiram

About Sangam15

Posted by Sai Janakiram Oct 12, 2015

Sangam, the largest independent Oracle user’s group conference will feature over 90+ in-depth technical sessions presented by expert speakers from inside and outside of Oracle. Over 800+ database administrators, developers and architects professionals are expected at the conference from November 21st to 22nd 2015 at HICC in Hyderabad. This is our moment of glory and time for you to join us!

After the first year of registering as a user group and getting to understand the interests of Oracle user community in India, through technology days (TechDay) and technology nights (TechNight) in various cities around the country, we launched a user conference calling speakers from around the world to share their knowledge and experience with users in India. Our first conference was Sangam09 held in September 2009 in Bangalore. We invited Tom Kyte to provide three, half day seminar series. Along with the seminar by Tom Kyte, we also invited key speakers from inside and outside Oracle to do sessions for the remaining period of the day. This was the first event conducted by us at such a large scale. We had a lot to learn from the interests of attendees and how to reach out to those who could not attend. Our second conference Sangam10 was held in September 2010 in Hyderabad. We invited Jonathan Lewis to provide two, half day seminar series. Along with the seminar by Jonathan Lewis, we also invited key speakers from inside and outside Oracle to do sessions for the remaining period of the day. Based on a survey we conducted at Sangam09 and Sangam10, we discovered that Oracle users in India preferred to have this event towards the end of the week/weekend. So they could use their personal time to learn and educate themselves. Sangam11 which was hosted on Friday and Saturday was an outcome of this survey and request from our users.


Our previous key speakers

Sangam14 - Tom Kyte, Maria Colgan, Jim Viscusi

Sangam13 – Arup Nanda

Sangam12 – Tom Kyte, Andrew Holdsworth, Graham Wood

Sangam11 – Arup Nanda

Sangam10 – Jonathan Lewis

Sangam09 – Tom Kyte


Please have a look at our previous Sangam events:

Sangam14 – Day1, Day2, Day3

Sangam13 – Day1, Day2

Sangam12 – Day1, Day2

Sangam11 – Day1, Day2, Video1, video2

Sangam10 – Day1, Day2

Sangam09 – Day1, Day2, Day3

 

Agenda

As part of the survey in Sangam15, we asked attendees who they would like to listen to and learn from in 2014. Apart from key sessions, we had breakout sessions from various key speakers from around the world. We had a great response from several Oracle experts from around the world. To ensure that the papers selected match our user’s interests, we requested attendees from previous Sangam conference to help us with the selection process. Through a ranking system with 1 being the low and 10 being the high we requested our volunteers to rank the various abstracts and thus the papers with the highest scores were selected.

  • Be part of the largest Oracle Users group conference in India - Your one stop shop for knowledge on Oracle where you can learn from the experts from around the globe.
  • Build your network - A not-to-be-missed opportunity to meet in-person with your Oracle experts from across continents community with countless networking opportunities, you'll get to share thoughts and hear success stories all in person.
  • Learn best practices - Learn how to make the best of Oracle
  • Carry back the knowledge - Return from this conference with a confidence of knowledge gain that you can apply right back at your work. With the knowledge you gain you can retrain your colleagues and showcase the best you can do with Oracle.
  • To expand your knowledge and get the answers you need all in just two days.
  • Share the knowledge - Meet the fellow Oracle folks and share your knowledge in various discussions in a session or over a coffee in the hallway. There is no restriction on where you talk about what you know or what you want to learn.
  • Be the first to know - See the first look of new features in Oracle. This helps you with the knowledge to leverage the new features right away out of the conference.

Who Should Attend!

Sangam, the largest independent Oracle user’s group conference has over 90+ sessions maximize your Oracle learning experience. If you are working with Oracle Database & Application in any aspect of Administration, Development this is a must attend conference for you. Over the two days of the conference you get to meet and learn from the Oracle experts around the world at a single place. You discuss, ask questions, socialize, share knowledge and meet the fellow Oracle enthusiasts.

The event will be led in multiple tracks to target all the professionals at all levels to make the most of the event. You still want more? It doesn’t stop there. You can meet and discuss with the Oracle experts out of the sessions after hours if you are not satisfied with the daylong sessions.

Oracle

  • Database Administrator
  • Developers
  • Technical Consultants
  • Functional Consultants
  • Data Scientists
  • System Administrator
  • Architects
  • Middleware Administrators
  • Operations Manager
  • Application Managers
  • Business Analysts