Sunday, February 17, 2013
Saturday, February 16, 2013
SQL Developer Installation on Ubuntu 12.10
1. Download SQL Developer from the followng URL,
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
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html2. 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
Wednesday, February 13, 2013
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']
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>
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>
Friday, February 8, 2013
Sirish reddy sent you a SlideShare presentation
The world's largest community for sharing presentations. Start sharing! |
| |||||||||||||||||||||||||||||||
Wednesday, January 30, 2013
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 ....
Wednesday, January 9, 2013
Saturday, January 5, 2013
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
http://www.youtube.com/watch?v=eDiA1p5DlLg
Friday, January 4, 2013
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...
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,
- Be at work by sharp 9 AM.
- Do regular work out.
- Learn and get expertise in an additional Programming Language.
- Getting good hands on Ubuntu OS.
- Read, Read and Read.
- Polish and enhance on Enterprise Integration skills.
Thursday, January 3, 2013
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...
Subscribe to:
Posts (Atom)