Gradle Weblogic Plugin

I'm pleased to announce the arrival of the Gradle Weblogic Plugin. Its been a while in the making, but I've finally got a stable version out with the 6 primary tasks. They are :

• wlDeploy - Deploys or redeploys an application or module.
• wlUndeploy - Stops the deployment unit and removes staged files from target servers.'
• wlCancel - Attempt to cancel a running deployment task.
• wlRedeploy - Redeploys a running application or part of a running application.
• wlStart - Makes a stopped (inactive) application available to clients on target servers.
• wlStop - Makes an application inactive and unavailable administration and client requests.

The latest version is currently:

You can find the source code and README at the following address:
Github - Gradle Weblogic Plugin

and the binaries are hosted at:
Bintray - Gradle Weblogic Plugin

Oracle DB Object - Gists

Select all invalid objects:


Recompile all invalid objects:




One of the really annoying things about Oracle PL/SQL is the way it tells you something is wrong, gives you a line number and then leaves it up to you to find the statement that caused the error. Well, this little piece of SQL gives you the exact line in error plus the lines immediately before and after it. (Acknowledgements to Ken Atkins of ARIS Consulting).

Oracle - Query DB Sessions SQL

I had an error today when trying to create a datasource in Weblogic. The error was:

ORA-27101: shared memory realm does not exist



Cause: Unable to locate shared memory realm


Action: Verify that the realm is accessible

The cause of this error was due to the number of database sessions being outnumbered by the number of Weblogic instances. We set up 7 environments, each with 50 maximum connections but only 100 sessions on the DB side.... as you can imagine we smashed the limit.

You can check the number of sessions using:

 SELECT name, value  
  
 FROM v$parameter 
  
 WHERE name = 'sessions'  

And you can check how many are currently in use using:

 SELECT COUNT(*)  
  
 FROM v$session