Thursday 27 August 2015

How to search or find text recursively in all files and folders?

Ideally this works :

 find . -name "*.*" | xargs grep "MyTextToSearch"


But when you have spaces between the file names / folders - this doesn't works in few OS where GNU find is not installed.

In such case, on one of the Solaris Machine the following worked
find . -name "*.*" -exec grep -l "MyTextToSearch" {} \;

How to find bind variables of a SQL-ID ?


SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300

COLUMN sql_text FORMAT A120
COLUMN sql_id FORMAT A13
COLUMN bind_name FORMAT A10
COLUMN bind_value FORMAT A26

SELECT
  sql_id, 
  b.name bind_name,
  b.value_string bind_value
FROM
  v$sql t
JOIN
  v$sql_bind_capture b  using (sql_id)
WHERE
  b.value_string is not null 
AND
  sql_id='&sqlid'

Friday 7 August 2015

How to check CHRON jobs set up on a server?

How to check CHRON jobs set up on a server?

>chron -l


this command will give you the list of chron jobs scheduled on the nox

Tuesday 4 August 2015

BEA-080003 RuntimeException thrown by rmi server: Security:090398 Invalid Subject: principals=[weblogic, Administrators, CrossDomainConnectors]

This error occurred when we "Enabling Trust Between WebLogic -Domains" to solve the BEA-XXX error.

This happened even after verifying / double checking the credentials. Also note that this error was thrown only in one of the managed server. Other managed severs were running fine after the password update. 
Cause:
We then found there was an issue with the managed server folder - which was probably caching the previous wrong password.

Solution:
I took a back up of the managed server folder under the 
/wls_domains/{domain-name}/servers/{managed-server-name}. I then restarted the managed server - the error disappeared and the folder that i deleted was auto created on startup.

BEA-090513 - ServerIdentity failed validation, downgrading to anonymous.>


How to resolve the following Weblogic Error ?

One day we started getting this weird error on Weblogic Managed server start up. I am not 100% sure why this came up sudden-off all  - my guess is that - one of the system that we were interacting did something on their system that caused this error coming up every minute. But the messages were still flowing through. 

<Mmm DD, YYYY HH:MM:SS PM Z> <Error> <Security> <BEA-090513> <ServerIdentity failed validation, downgrading to anonymous.>


Cause
Trust has not been properly established between two domains. If the domains are not configured properly, a hacker could make an attempt to guess the server identity for this domain.


Action
See the documentation on "Enabling Trust Between WebLogic Domains" at