Thursday, February 18, 2016

How do I find out my MySQL port number?

How do I find out my MySQL port number?

mysql> SHOW VARIABLES WHERE Variable_name = 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+

1 row in set (0.00 sec)

Monday, January 4, 2016

Find string with file name in Linux


Find string with file name in Linux


     find  -type f -print0 | xargs -0 grep -l "11440159"

Request and Response from Java Web Service

getStub()._getServiceClient().getServiceContext().setCachingOperationContext(true);
OperationContext OperationContext = new OperationContext();
boolean cacheLastOperationContext = true;
OperationContext.setComplete(true); // Enable the Cache value
serviceConxt.setCachingOperationContext(cacheLastOperationContext);
serviceConxt.setLastOperationContext(OperationContext);

//Invoke method to get the response


if (operationContext != null) {
System.out.println("== Request ==");
MessageContext outMessageContext = operationContext.getMessageContext("Out");
operationContext.getMessageContexts();
if (outMessageContext != null) {
System.out.println("OUT SOAP: " + outMessageContext.getEnvelope().toString());
}
System.out.println("== Response ==");

MessageContext inMessageContext = operationContext.getMessageContext("In");
if (inMessageContext != null) {
System.out.println("IN SOAP: " + inMessageContext.getEnvelope().toString());
}
}

Friday, June 21, 2013

ORA-01031: insufficient privileges - ATG

ORA-01031: insufficient privileges

while setting up the CRS application there is a steps to create the OOTB CRS tables via "create scheam" option, when i invoke i got the ORA-01031: insufficient privileges error.

Solution:

Go to command prompt and Log in as sysdba and give the grant access to the schema(s)
C:> sqlplus sys as sysdba
SQL> grant connect, resource, dba, sysdba to <>;

ATG Commerce 10.1 Migration Documentation

 ATG Commerce 10.1 Migration Documentation
All,
we can get migration documentation from oracle support website.

http://docs.oracle.com/cd/E29239_02/index.html

Friday, June 14, 2013

failed to load jni shared library jvm.dll eclipse

failed to load jni shared library jvm.dll eclipse

I recently downloaded the 64 bit version[eclipse-SDK-3.7.1-win32-x86_64] of eclipse Classic( indigo ) for windows 7 .But on whe i tried to run the eclipse.exe file , the following error message was displayed.


” Failed to load the JNI shared library “c:\Program Files(x86)\java\jdk1.6.0_25\bin\..\jre\bin\client\jvm.dll”  

Please check the version bellow..

64 bit OS with 64 bit Java with 64 bit  eclipse, will it work? - yes.
64 bit OS with 32 bit Java with 32 bit  eclipse, will it work? - yes.
64 bit OS with 64 bit Java with 32 bit  eclipse, will it work? - No.
32 bit OS with 32 bit Java with 32 bit  eclipse, will it work? - No.


Goto to eclipse.ini  and add the follwing and restart the eclipse

-vm  
C:\Program Files (x86)\Java\jre1.6.0\bin 

Tuesday, June 11, 2013

lo exception: The Network Adapter could not establish the connection

All,

After installing the Oracle 11g in Windows 7, I have created the new schema(s). Once i created the schema also installed the Oracle Sql Developer.
I created the new connection i entered the connection details but am not able to connect through the Oracle sql developer. I am able to connect through sqlplus.
while try to connect through the oracle sql developer am getting the error. 
lo exception: The Network Adapter could not establish the connection

sql developer was trying to connect to "localhost" (which it always had done successfully in the past), however when I checked my tnsnames.ora file, I noticed the address was my pc's actual windows name. I changed the setting in sql developer from localhost to this name and it not connected.

Solution:
Finally i delete the listener.ora file from <>\app\oracle\product\11.2.0\server\NETWORK\ADMIN and i stop and start the oracle listener(s) in services.

Thanks god :) it works fine. Am amble to create the new connection in oracle sql developer and connected.