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!

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 ,

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

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,

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

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!