Friday, December 24, 2010

Configure Listener

I was bit confused when i first read about listeners but now its very simple for me and here i will explain you how to configure listener and start and stop etc.

Concept :
Listener will simple listen on port specified by you and will accept connections on that port , and finally will connect that connection to started instance of database

client --> LISTENER --> DATABASE INSTANCE (Your started database)

Important Things which you will require while configuring listener

  • ORACLE_HOME
  • ORACLE_SID
  • PORT NUMBER ON WHICH LISTENER WILL LISTEN FOR CLIENT CONNECTIONS

To check your SID on Linux Box :   echo $ORACLE_SID
This SID you will configure in your listener which is currently running instance

Navigate to :
  • cd $ORACLE_HOME
  • cd  network/admin
  • vim listener.ora
Configure listener.ora as follows :

HOST : your ip on which your going to listen
PORT : (Your choice)
ORACLE_HOME , ORACLE_SID check with previous command and enter same here in file.

Thats it!
You simply configured listener names LISTENER (by default name)

How to Start Listener :

$ lsnrctl start LISTENER

How to Check :

$ sqlplus girish/girish@//HOSTNAME:PORT/SID


If everything is proper you should get connected to oracle instance!

Thank You!




Saturday, November 6, 2010

Some Good Things to read about Personality development & Life

Hi,

Here are some of articles and weblinks related to positive attitude, personality , life which may help you get better in your hard time..

http://www.essentiallifeskills.net/thinkpositively.html

I will go on posting more links as i read it ,

Thank You ,

Wednesday, November 3, 2010

Zombie Process UNix/Linux

Hi,

Zombie process is a finished process but whose entry is still there in Process Table , to return exit status to Parent process who started it!

How to list Zombie process  :
------------------------------

ps -auxZ | grep "Z"    --> short way to list Zombie processes

You can kill zombie process by killing its parent process


How to Know parent process of zombie process :
---------------------------------------------------

pstree -p | grep "zombie process name"

and kill parent using

kill -9 parent process



Thank You,
have a nice day!

Learn English Online (Free Videos)

Hi,

Well, my english is not so good and wann learn much , i got this gr8 link for Beginners
Enjoy all videos ,

Here i will post all links for learning English

http://www.engvid.com

Have a nice day
Thank you

Saturday, October 30, 2010

Visual Cert Manager With Oracle Dumps

Hi,
Visual cert is a very good exam simulator ,
you can download full version from here  Download Here

1) Download it and click on registry file to make it full version
2) Start the software and import oracle 1z0-007 file in it and start the test!


Enjoy Simulator!
Thank You,

Monday, October 25, 2010

Could not open virtual machine (Already in use)

Hello ,

I was running Red Hat Enterprise Linux 5 in virtual machine on Windows XP , due to some OS problem i decided to use alternate Windows VISTA which was also installed physically ,
So when i started vista and opend VMware Configuration file , i came across this error .

Solution : (Little problem but very common one)
-----------

Simple go to location where you installed OS and check .lck folder
Delete any .lck files in this folder and its done!

Now you can run your OS without any problem!

Thank You ,
Have a nice day

Thursday, October 21, 2010

WAMP Server: Mysql login Error (Cant open phpmyAdmin)

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

This is very common error encountered while using WAMP server , its because you have not set mySql password and you need to set it first!

Solution :

1) Go to C:\wamp\bin\mysql\mysql5.1.36\bin\
2) mysql.exe -u root -p
3) mysql>
4) Type this query :
     update mysql.user set password=password('1234') where user='root';
5) flush privileges;
6) That's it! now u set password 1234 to mysql.
7) Now whenever you will establish connection with mysql from php pages you will need to provide this password 1234


Thank You,
Have A Nice Day!

Wednesday, October 20, 2010

Command not found (RHEL 5) chkconfig,service,ifconfig

Hi,

I know its very simple issue but important for beginneers ,
Many times some configuration changes in .bash_profile file may lead to these types of errors . .

As all your commands are there in /sbin/ if $PATH variable is not set properly then you may get this error...

Solution :

1) If you are logged in as root
2) cd ~
3) vim .bash_profile
4) export $PATH=/sbin
5) Thats it.! now you specified your system where to check for system commands!

Fireup your fav system command and check the output!

Enjoy!
Have a nice day!

Friday, October 8, 2010

Thursday, October 7, 2010

Advanced File Organizer 3.1

Hi,
A very gud software for those who need software to manage their data instead of moving it from one location to other ....
You can categorize your data like movies,softwares, blah blah blah...

http://www.warez-files.com/show-file-crack-kis11-0-1-400en.html

Download

If any queries then you can simply post me a comment !
Thank You,

Saturday, September 18, 2010

Load and extract XML File data in Oracle

This is really nice thing we can do it in oracle , recently i encountered a situation where data came from XML File and need to load it in Table in oracle 10g , This was a good opportunity to learn this stuff ,

Here i have written a simple tutorial for beginners , how to load XML file data in Oracle 10g , there are others ways to do these things but this is good method to understand it for beginners like us!

You can download Tutorial from here

Download and playout with this data : download

Correct me if am wrong somewhere ,
You can always post your views and suggestions here on this blog ,

Thank You,

Have a nice day ,

Thursday, September 9, 2010

Oracle Installation Problem : X11 problem

Most probably you will see this line in your error " X11 window server using '192.168.1.2:0.0' as the value of the DISPLAY variable "


This clearly says that problem is related to X11 . . .




Steps :
---------
1) Try executing xeyes as root and check wheather it shows or not . . 
2) now login as your oracle account as ,

    su - oracle


3) Try executing xeyes again if error pops up something like this :


    Xlib: connection to ":0.0" refused by server
    Xlib: No protocol specified
    Error: Can't open display: :0.0

4) Go ahed by firing :  xterm and you will see TERMINAL OPENED 
5) thats it now you can fire xeyes from that terminal 
6) run your oracle installer as  ./runInstaller

Thats It !


Monday, September 6, 2010

can't drop table

drop table xyz;

ORACLE SAYS : exact fetch returns more than requested number of rows ? ? ? how come . . .

yea, once i was playing with dual table and i inserted new row in a dual table which is why i can't drop this table xyz

to Add Rows in Dual table connect to sysdba

1) conn / as sysdba
2) insert into dual values('Z');


Now if you try to drop any table you will get above error to solve it just delete one row from dual table
as

delete from dual where dummy='Z'

Thats it! Now you can drop any table you want without any errors!
Thank You!

Monday, August 30, 2010

Servlet Simple Tutorial

Today 31st August , from many days i was not paying much attention towards Servlet technology as i used to hate it , coz of its compilation and execution but finally today me and my sir was just trying to solve some problems related to this servlet and finally decided to write simple tutorial about executing servlet application!

Creating and executing a servlet is not at all a difficult task once you understand it !

View My Tutorial here

I hope you will get to know about compilation and execution of servlet from this little handy tutorial!
Let me know if am wrong somewhere ,

Thank You ,
Have a pleasant stay!

Sunday, August 29, 2010

Wednesday, August 18, 2010

10g say's Database not open . . .tackle ORA-01219


SQL> startup mount
ORACLE instance started.

Total System Global Area  126951228 bytes
Fixed Size                            454460 bytes
Variable Size                       109051904 bytes
Database Buffers               16777216 bytes
Redo Buffers                      667648 bytes
Database mounted.

SQL> select * from dba_users;
select * from dba_users
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


Now what ? ? ? ? ? ? ?

To check the Database mode :

1) fire up : select open_mode from v$database
2) If its mounted then you need to fire up : alter database open
3) Thats it now you can fire any query you want . . . .

Enjoy 10g ,
Thank You

M.C.A (Pune University)

Dedicated to all M.C.A's of Pune University

  1. M.C.A. Syllabus Download
Will soon upload M.C.A study guide here on site.
Keep visiting,
Thank You,
: Girish . . .

Interview Questions

Hello friends , here you will get some good sites for interview preparation post me your fav sites  . . . .


  1. http://kyapoocha.com/

Monday, August 16, 2010

Mysql Basic

  1. Start mysql from start menu
  2. It will ask you password just enter whatever you specified while installing mysql.
  3. you get mysql> prompt
  4. To view available databases fire up : show databases;
  5. To select database fire up : use databasename;
  6. To show created tables in mysql fire up : show tables;
Very small introduction for connecting to mysql database! rest you can execute your own queries there on prompt...


My SQL Frequent commands :

Reset MySQL password

Some days back  i just forget this password for Mysql and there is very easy way to reset this password, simply follow below steps : (Windows XP)

  1. Go to control panel > administrative tasks > services
  2. Select mysql service from right pane
  3. right click on it and 'STOP' the service
  4. There is a way to start the server with special init file which you can create as follows :
UPDATE mysql.user SET Password=PASSWORD('girish') WHERE User='root';
FLUSH PRIVILEGES;

  • Copy above 2 lines and paste it in notepad and save this file as  : mysqlpwdreset.txt 
  • Now fire up : C:\mysql\bin\mysqld-nt --init-file=C:\\mysqlpwdreset.txt
For More Information Click here
Thats it! Now Fire up your mysql and enter this new password !
Thank You,

Thursday, August 5, 2010

My Typing 2010

Typing speed with perfection is very much import in our IT! I just practice online to improve my speed and am now very much closer to 60 words per minute . . . 


 I hope to increase my typo speed to more than 60 words per minutes.

Online Typo Speed Calculator




Happy Typing !

Saturday, July 31, 2010

Windows XP Commands Not Working

Many Times due to some Environment variable setting in system values of path variable changes . . .which leads to this type of problems.

Ex.

1) If you open command prompt cmd and type any command as 'ipconfig' you get output as :

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Girish> Ipconfig
'Ipconfig' is not recognized as an internal or external command,
operable program or batch file.


2) Now simple thing you have to do is : change path variable value.

Steps :


1) right click on my computer > properties > Advanced > Environment Variable > System Variable
2) Select PATH variable and click on Edit 
3) Add at the End :   ";C:\WINDOWS\SYSTEM32" without quotes.

That's it now you can fetch any commands in XP you want !

Tuesday, July 27, 2010

Ajax Very Basic Tutorial

Hi, friends here i will explain you some little things about AJAX its absolutely for Beginners!!!! If you are advanced AJAX programmer then please correct me if am wrong!...

Fine . . . .Enough now lets start with AJAX!!

AJAX = Asynchronous JavaScript and XML.......

Its not at all a programming language but a new way to use existing Web Technology Standards. still wondering what it is ? ? ? ok . . .lemee explain you...You might be familiar with social engineering websites like orkut.com...when you click on next button of your photo album you can 

Check out this picture . . . when you click on next button of Album in orkut it loads new image without loading whole page, instead  


Monday, July 19, 2010

Shakira waka waka for (this time for africa) lyrics

Oooeeeeeeeeeeeeeeeehh 

You're a good soldier 
Choosing your battles 
Pick yourself up 
And dust yourself off 
Get back in the saddle 

You're on the front line 
Everyone's watching 
You know it's serious 
We are getting closer 
This isn't over 

The pressure is on 
You feel it 
But you got it all 
Believe it 

When you fall get up, oh oh 
If you fall get up, eh eh 
Tsamina mina zangalewa 
Cuz this is Africa 
Tsamina mina, eh eh 
Waka waka, eh eh 
Tsamina mina zangalewa 
This time for Africa 

Listen to your God 
This is our motto 
Your time to shine 
Don't wait in line 
Y vamos por todo 

People are raising 
Their expectations 
Go on and feed them 
This is your moment 
No hesitations 

Today's your day 
I feel it 
You paved the way 
Believe it 

If you get down get up, oh oh 
When you get down get up, eh eh 
Tsamina mina zangalewa 
This time for Africa 
Tsamina mina, eh eh 
Waka waka, eh eh 
Tsamina mina zangalewa 
Anawa a a 
Tsamina mina, eh eh 
Waka waka, eh eh 
Tsamina mina zangalewa 
This time for Africa 

Awela Majoni Biggie Biggie Mama One A To Zet 
Athi sithi LaMajoni Biggie Biggie Mama From East To West 
Bathi . . . Waka Waka Ma Eh Eh Waka Waka Ma Eh Eh 
Zonke zizwe mazi buye 
Cuz this is Africa 

Voice: Tsamina mina, Anawa a a 
Tsamina mina 
Tsamina mina, Anawa a a 

Tsamina mina, eh eh 
Waka waka, eh eh 
Tsamina mina zangalewa 
Anawa a a 
Tsamina mina, eh eh 
Waka waka, eh eh 
Tsamina mina zangalewa 
This time for Africa 

Django eh eh 
Django eh eh 
Tsamina mina zangalewa 
Anawa a a 

Django eh eh 
Django eh eh 
Tsamina mina zangalewa 
Anawa a a 

(2x) This time for Africa 

(2x) We're all Africa

Friday, July 16, 2010

Simple Oracle Java Connection

import java.io.*;
import java.sql.*;

class oraclecon
{

public static void main(String argsp[])
{
try
{

Connection con = null;

Class.forName("oracle.jdbc.driver.OracleDriver");

con=DriverManager.getConnection("jdbc:oracle:thin:@snk:1521:database_name","scott","tiger");

Statement s=con.createStatement();

s.execute("select * from emp");

s.close();




}
catch(Exception e)
{


}


}



}



Thank You,

Wednesday, July 14, 2010

Send Free Sms to India








Free SMS to India

Fifa 2010 mp3 and lyrics

Helloo Friends , Spain Rocks This time !








Download Fifa 2010 Mp3 for free download

Lyrics : 

Song Title: Wavin Flag
By K'Naan y David Bisbal

Oooooo Woooooo...Oooooo Woooooo...

Give me freedom, give me fire
Give me reason, take me higher
See the champions take the field now
You define us make us feel proud

In the streets are, as a lifting
As we lose our inhibition
Celebration is surround us
Every nation all around us

Singing forever young
Singing songs underneath the sun
Let's rejoice in the beautiful game
And together at the end of the day

We all say

When I get older I will be stronger
They'll call me freedom
Just like the a waving flag
And then it goes back [4x]

When I get older I will be stronger
They'll call me freedom
Just like the a waving flag
And then it goes back [4x]

Oooooo Woooooo...Oooooo Woooooo...

Give you freedom, give you fire
Give you reason, take you higher
See the champions, take the field now
You define us, make us feel proud

In the streets are, as a lifting
As we lose our inhibition
Celebration is surround us
Every nation all around us

Singing forever young
Singing songs underneath that sun
Let's rejoice in the beautiful game
And together at the end of the day

We all say

When I get older I will be stronger
They'll call me freedom
Just like the a waving flag
And then it goes back [4x]

When I get older I will be stronger
They'll call me freedom
Just like the a waving flag
And then it goes back [4x]

Oooooo Woooooo...Oooooo Woooooo...

We all say

When I get older I will be stronger
They'll call me freedom
Just like the a waving flag
And then it goes back [4x]

When I get older I will be stronger
They'll call me freedom
Just like the a waving flag
And then it goes back [4x]

Oooooo Woooooo...Oooooo Woooooo...
And everybody will be singing it

Oooooo Woooooo...Oooooo Woooooo...
And we all will be singing it


Enjoy Fifa 2010!!!!!

Have a nice day!

Tuesday, July 13, 2010

Boot into Single usermode with Read Write Access to root

Why you want read write access to your system in Single User Mode ? ? Why ? ? Ofcourse its bad practice but we want rw access to bash in some situations like in Maintenance Mode ? ? ? still why ? ? ? ok . . . .lemme explain you . . .

Imagine you are doing LVM (I hope u know LVM) and you already activates USER QUOTA (Hope you know it) Now If this is the situation and you forgot to Disable USER QUOTA before reducing LVM size then probably after restart you will simply lang to maintenance mode!!!
Now what ? ? In this situation you must edit /etc/fstab which is must , to start back your Red Hat!!!! And for this you need to have write access to these files which is not by default!!

Method 1:

When you will boot you will see something like this :

module /vmlinuz-2.6.18-8.el5xen ro root=LABEL=/ rhgb quiet

Here a little modifications can land you to bash prompt with read write access

module /vmlinuz-2.6.18-8.el5xen rw root=LABEL=/ rhgb quiet

Method 2:

You can normally boot in single user mode as :

module /vmlinuz-2.6.18-8.el5xen ro root=LABEL=/ rhgb quiet single

or

module /vmlinuz-2.6.18-8.el5xen ro root=LABEL=/ rhgb quiet 1

you get bash prompt as :

bash# (type here)
bash# mount -o remount /,rw --> which provides read write access to root

Thats how we can get out of maintenance mode . . .

Thank You . . .

Enjoy RHEL

Saturday, July 10, 2010

My DC++

Home IP's :

10.46.104.173:55555
10.46.104.9:12100
10.40.100.198:11211
10.46.102.22
10.46.98.105:11211

Home Setting :

ip - 10.46.102.XXX nythin betweent 0-255
subnet - 255.255.255.0
gateway - 10.46.102.1

dns = 172.31.6.5

2nd dns = 172.31.6.125

Sunday, July 4, 2010

My RHCE Experiance

Hi Friends ,

It's not at all a different thing i have done , many of you might have already passed RHCE some of you might have passed RHCSS and blah blah . . .but everyone have their own experience about their certification. So here i will share few things about my experience of being an RHCE.

It was 29th June 2010 , Tuesday

This time Red Hat had a scheme , 11000 for First Shot + 2000 for next shot! Personally don't wann waste money , and no one will rt???So just woke up by 7 and my exam center was Focus Training Institute Pune , which was not close from my place soo was in hurry to reach there on time , Finally reached by 8:15 AM and exam was supposed to be conducted at 9:30 AM , as usual it was not on time because of System Problems.After and hour examiner came there and started formatting pc's , they have some procedure to format each and every machine atleast 5-6 times and then they think they can start exam.So it's very good procedure which i saw there and one thing is that examiner is really a geek and solves any problems that arises in a system quickly, a very talented student of their batch i guess! Don't mind if you are one of them!!!
I was outside the lab and was observing what's going on there on systems and finally figured out that there was Some SELinux service problem and coz of that our exam started late there at center.Ohhhhh! Again we all became restless coz we were just wanted to get rid of exam fast! Finally somehow he was able to solve all of problems in a system . . it was Good as well as bad news for all of us because exam was about to start in few minutes !

Finally he called up names of students one by one , gave one blank paper to everyone , and told me to sit on 3rd machine . Machine was looking scary to me at first site , but as time proceed it was very friendly with me.Finally we started filling a form and signed a NDA (Non Discloser Agreement) So we can't expose questions in exam. Exam started and first 1 and half hour was very gud for me as i could solve all questions except 2 questions related to NIS and SAMBA I thought i can solve it later soo i left those questions and completed my exam paper.But later words i came to know i was in a big trouble!!! Suddenly i saw one BIG SILLY MISTAKE! They were told to create COMMON directory and i created COMMAN directory which was wrong!! Total 3 questions were dependent on this DIRECTORY Ohhhh gOD! Finally had to stop all that 3 services and had to configure NFS,Mount partition and had to set permissions on that again! Now only 20 Minutes left , i thought now its better to reboot system once and did that and what i saw was astonishing once again . . . All my FIREWALL (iptables) rules got deleted coz of my silly mistake of RESTORECON . . . 15 minutes . . . then again was in hurry and applied that firewalls quickly but something was WRONG! 1 rule ! ! ! ohh god...10 minutes . . .started entering commands deleted rule ! ohh my godddddddd but which one? ? it was not one which i want . . correct rule got deleted and wrong remains there only ! 5 minutes . . . again Fast typing and finally each and every entry was correct and then saved it using RESTORECON and rebooted my Server and as soon as login screen came , examiner told me to stop ! ! ! Exam finished!!!
. . . . . .
. . . . . .
. . . . . .
1 and half day was waiting for result and finally i got my Dream Result on 30th June 2010
evening 8:30 Pm
Got a mail from Red Hat Certification Ce.

RHCT components score: 77.8
RHCE components score: 84.4

RHCE Certification: PASS

Thats GreaT!! I was soooooooooooooooooooooooooooooooo happy that day wow! Now i can go for next certification ! This was all about my personal experience of RHCE . . .
Thanx a lot for visiting my web!

Saturday, June 19, 2010

Software Download Links



List Will be updateed soon Keep VisitinG!

Thank You!

nrg to iso converter

Here is cute little nrg to iso converter for u guys . . .

Link : Download

Please let'me know if link is broken!

Thank You!

Bharat Operating System Solutions (BOSS) OS

We Indian's always been using Operating System imported from Outside India , Now first time in India C-DAC has launched Bharat Operating System Solutions (BOSS) OS Derived from Debian , improving the use of Open Source Software in India.
BOSS GNU/Linux advanced server has unique features such as Web server, proxy server, Database server, Mail server, Network server, File and Print server, SMS server, LDAP server. BOSS GNU/Linux advanced server is comprised with administration tool such as webmin which is a web based interface, Gadmin, PHP myadmin, PHP LDAP admin, PG admin.


Bharat Operating System Solutions
BOSS GNU/Linux logo
BOSS screenshot 1.jpg
BOSS 3.0 (Tejas)
Company / developerNRCFOSS / CDAC, India
OS familyUnix-like
Working stateCurrent
Source modelFree and open source software
Initial releaseJanuary 10, 2007
Latest stable release3.0 / September 5, 2008
Marketing targetGeneral purpose
Available language(s)Multilingual (more than 18)
Package managerdpkg
Supported platformsi386, AMD64[1]
Kernel typeMonolithic (Linux)
UserlandGNU
Default user interfaceGNOME and KDE
LicenseGNU GPL & Various others.
Official websitewww.bosslinux.in

Features of BOSS Linux

Graphical mode installer;
Faster system startup and login;
Simplified menu organization;
Easy access to power management settings;
Improved support for video playback;
3D Desktop;
BharatheeyaaOO (Localised OpenOffice.org 2.0.1 � currently in Tamil and Hindi);
Enhanced Removable Media support;
Plug & Play support for devices;
Multimedia support;
TV Tuner support;
Bluetooth support;
Optional Network Manager for convenient roaming between different wireless and wired networks;
Migration Tool – Bulk Document converter;
Input Method – SCIM with Remington Keyboard Layout for Tamil, Hindi, Punjabi,and Marati;
Dual Boot Facility;
Automount of existing Hard Disk partitions.

Popular applications inside BOSS Linux:

GNOME Desktop
Liferea – RSS/RDF Reader
Totem
XMMS
GNOME Power Manager
Bonfire
Evolution Mail Client
Firefox
Gaim
Xchat
Alacarte
KeyJnote


Thank You ,
Have a Pleasant Stay!