SQL Developer Installation on Ubuntu 12.10

1. Download SQL Developer from the followng URL,
  

​ ​

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
2. Accept License Agreement
3. Other Platforms and Download the file. File name will be sqldeveloper-3.2.20.09.87-no-jre.zip
4. unzip the file to your prefered location, Something like below,
   unzip /home/sirishg/Downloads/sqldeveloper-3.2.20.09.87-no-jre.zip -d /u02/app/
5. cd to /u02/app/sqldevloper
6. Need to add jdk directory in sqldeveloper.conf
7. cd to /u02/app/sqldeveloper/sqldeveloper/bin and edit qldeveloper.conf
8. gedit qldeveloper.conf and update SetJavaHome value to your java home directory location
   SetJavaHome /u02/app/ibm-java-i386-60
9. All done now just go to /u02/app/sqldeveloper and run sqldeveloper.sh

XPath Syntax if we have multiple Namespaces in ProcessData

Reading the XPath if we have multiple namespaces in ProcessData,

ProcessData

<ProcessData>
<RevealPanReply xmlns="http://w3schools.com/account/services/1.0/">
        <MessageHeader>
            <payment:CreateTimestamp xmlns:payment="http://w3schools.com/account/types/1.0/">2013-01-18T17:58:31.204Z</payment:CreateTimestamp>
        </MessageHeader>
        <PaymentAccountNumber>4111111111111111</PaymentAccountNumber>
</RevealPanReply>
</ProcessData>

XPath

/ProcessData//*[local-name()='PaymentAccountNumber']

MySQL Installation and Database creation on Ubuntu 12.10

1. Install mysql on Ubuntu 12.10. (Use apt-get install mysql-server)
2. Log on to mysql as a root user
     $ mysql -u root
     $ mysql -u root -p
       Enter password: ENTER ROOT PASSWORD
3. Create a Database for Sterling Integrator
     mysql> create database SI52;
            Query OK, 1 row affected (0.00 sec)
4. Add User called sterling to SI52 Database
    mysql> grant usage on *.* to sterling@localhost identified by 'password';
    Query OK, 0 rows affected (0.00 sec)
    mysql>GRANT ALL PRIVILEGES ON SI52.* TO sterling@localhost IDENTIFIED BY password WITH GRANT OPTION;
    mysql>FLUSH PRIVILEGES;
5. Grant all priviliges to sterling user on SI52 database
   mysql> grant all privileges on amarokdb.* to amarokuser@localhost ;
   Query OK, 0 rows affected (0.00 sec)
6. Login as sterling user and check the database access to SI52
$ mysql -u sterling -p'password' SI52
    Your MySQL connection id is 12
    Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    mysql>

      

Sirish reddy sent you a SlideShare presentation

The world's largest community for sharing presentations. Start sharing!

Your colleague Sirish reddy sent you this SlideShare presentation "B2B" B2B Framework for IBM Sterling B2B Integrator   B2B Framework for IBM Sterling Integrator - Minimizes development and deployment time for new proje... 864 views 24 downloads View it now

How-to Install and Getting-Started on Oracle 11g R...

Install Climber: How-to Install and Getting-Started on Oracle 11g R...: This is an Easy and Step-by-Step Guide to Install the Oracle 11g R2 x64 Database on Linux Ubuntu 12.10 Quantal Quetzal 64bit Unity Desktop ....

Good Read

A good read...

addicted2success.com/success-advice/the-guideline-to-become-a-winner

LAST Life-Changing Seminar by Sandeep Maheshwari in Hindi - A Must Watch (Full Video)

A must watch one loved it and I started my new year in right direction.

http://www.youtube.com/watch?v=eDiA1p5DlLg

One Paragraph That explains Life...

ONE PARAGRAPH THAT EXPLAINS LIFE!

Arthur Ashe, the legendary Wimbledon player was dying of AIDS which he got due to infected blood he received during a heart surgery in 1983.

From world over, he received letters from his fans, one of which conveyed: "Why does GOD have to select you for such a bad disease"?

To this Arthur Ashe replied:

"The world over -- 50 million  children start playing tennis, 5 million learn to play tennis,

500,000 learn professional tennis, 50,000 come to the circuit, 5000 reach the  grand slam,

50 reach Wimbledon, 4 to semi final, 2 to the finals,

when I was holding a cup I never asked GOD 'Why me?'.

And today in pain I should not be asking GOD 'Why me?' "


"Happiness keeps you Sweet,
Trials keep you Strong,
Sorrow keeps you Human,
Failure keeps you humble and Success keeps you glowing, but only Faith & Attitude Keeps you going...

New Year Resolutions - 2013

I started working on below things, Let's see how long and how far I'll continue,

1. Be at work by sharp 9 AM.
2. Do regular work out.
3. Learn and get expertise in an additional Programming Language.
4. Getting good hands on Ubuntu OS.
5. Read, Read and Read.
6. Polish and enhance on Enterprise Integration skills.

 

XPath Builder Tool

A cool XPath builder tool, I liked it,
http://www.bubasoft.net/Product/XpathBuilder

Setup a SFTP Server on Ubuntu

Yet Another Computing Blog: Ubuntu - Setup a SFTP Server: This procedure will setup a SFTP server, thats FTP over SSH on Ubuntu Server. In this instance the FTP server will be for a group of people...

10 Creative Ways To Make Money Online | Addicted 2 Success

http://addicted2success.com/success-advice/10-creative-ways-to-make-money-online-right-now/

No Shortcuts for Success

This photograph inspired me a lot and I see this picture daily before I go to bed.

There is no shortcut for success. Attitude and Hard Work will get you to Success.

Beautiful Sunset @ King of Prussia

Active and DR sites architecture

Hand Work will lead us to success

Success story of my Babai (father's brother) published in our local
news paper. He inspired me.

Keep going Sesha Reddy Gongal Reddy :)

Remove Custom Service from Sterling Integrator

If we need to uninstall a custom service in IBM B2B Sterling Integrator follow the blow steps. Please note you have to clean from File system and from database as well.

File System Cleanup

C:\Sirish\SterlingIntegrator\install\installed_data\Your Custom Service Name directory.

C:\Sirish\SterlingIntegrator\install\jar\Your Custom Service Name directory.

C:\Sirish\SterlingIntegrator\install\properties\lang\en\Your Custom Service Name_en.properties

C:\Sirish\SterlingIntegrator\install\properties\services\Your Custom Service Name.xml

Database Cleanup

select * from service_def_guid where current_id = 461;

select * from service_def_parms where def_id = 461

select * from service_def where def_lookup_name like '%com.mypackage%';  

Note: 

Please check def_look_up name in service instance page under Development --> Services --> Installation/Setup  

delete from service_def_guid where current_id = 461;

delete from service_def where def_id = 461;

delete from service_def_parms where def_id = 461;

commit;

Note: 461 is my CS unique Id in a database.

IBM B2B Sterling Integrator - Oracle Database User and Table Space creation Scripts

Below process explains how to create Oracle database for Sterling Integrator with all required user permissions.

1. Create a new database using Oracle Database Configuration Assist for Sterling Integrator with all required Initilation perameters. Initilation perameters are very critical so refer installation document very carefully while creating new database.

2. Log on to Database as a Power User (system or sys as sysdba) and create new table space,
       CREATE TABLESPACE SI_TABLESPACE DATAFILE
       '/u01/app/sterling/SI52.DBF' SIZE 2000M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED
        LOGGING
        ONLINE
        PERMANENT
        EXTENT MANAGEMENT LOCAL AUTOALLOCATE
        BLOCKSIZE 8K
        SEGMENT SPACE MANAGEMENT AUTO;

3. Log on to Database as a Power User (system or sys as sysdba) and create new user for Sterling Integrator Database in this case the user is "Sterling". Excute below scripts one by one.

    DROP USER STERLING CASCADE; --Not Required This Statement.
    CREATE USER STERLING IDENTIFIED BY STERLING DEFAULT TABLESPACE SI_TABLESPACE TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
    GRANT EXP_FULL_DATABASE TO STERLING;
    GRANT IMP_FULL_DATABASE TO STERLING;
    GRANT RESOURCE TO STERLING;
    GRANT CONNECT TO STERLING;
    ALTER USER STERLING DEFAULT ROLE ALL;
    GRANT UNLIMITED TABLESPACE TO STERLING;
    GRANT DBA TO STERLING;
    GRANT ALTER SESSION TO STERLING;
    GRANT CREATE PROCEDURE TO STERLING;
    GRANT CREATE SEQUENCE TO STERLING;
    GRANT CREATE SESSION TO STERLING;
    GRANT CREATE SYNONYM TO STERLING;
    GRANT CREATE TABLE TO STERLING;
    GRANT CREATE VIEW TO STERLING;
    GRANT EXECUTE ANY PROCEDURE TO STERLING;
    GRANT INSERT ANY TABLE TO STERLING;
    GRANT UPDATE ANY TABLE TO STERLING;
    GRANT SELECT ANY TABLE TO STERLING;
    GRANT SELECT_CATALOG_ROLE TO STERLING;
    ALTER USER STERLING DEFAULT ROLE "CONNECT", "RESOURCE",SELECT_CATALOG_ROLE;
    GRANT CREATE TRIGGER TO STERLING;
    GRANT CREATE TYPE TO STERLING;
    GRANT EXECUTE ANY TYPE TO STERLING;
    GRANT SELECT ANY TABLE TO STERLING;
    GRANT SELECT ANY DICTIONARY TO STERLING;

4. Connect to Database as new user Sterling just to make sure you don't have any issues while connecting or accessing Sterling Integrator database.

5. You can proceed with the SI installations :)