TNS Listener Starting Problem | Listener Not Working

TNS Listener Starting Problem in oracle, How to resolve TNS Listener Service not starting problem

Some times you may find that TNS listener is not working or TNS Listener service not found ...

Let Me Explain Briefly and precisely ...

How to Add Listener ?

1. Go to Listener configuration option and click add listener and then finish creating the Listener.

How to check whether the Listener service is started or not ?

1. Go to "Net Manager" in Oracle and open the drop down one by one. If the listener is listed then no problem in Listener service.

If not ??? !!!

Just do this simple steps to add your listener.

1. Right Click My computer

2. Go to advanced settings

3. Then click Environment Variables

4. Add Path name= PATH, And Value = "Your oralce "db_home1"" folder location.

If already a path name exists just add you folder location and place a semi colon. 

Your problem will be solved ... Any doubts regarding this feel free to comment here :)

Thank youu.

imdp not recognized as internal or external Command | Error in importing dump oracle

imdp not recognized as internal or external Command | Oracle Error

When We try to import an oracle dump file we may get this error , The most probably the reason  for such error is simple. 

Consider the following command,

" <sql> impdp username/password dumpfile=dump_file.dmp log=impdpas.log schemas=schema_name "

When You execute that command, you will get the following error

'imdp' is not recognized as an internal or external command,
operable program or batch file.

Solution is that you are not supposed to execute the command in "SQL"command prompt.
You Should exit SQL command prompt and execute that in Normal CMD (windows command Prompt)

C:\Windows\system32>  impdp username/password dumpfile=dump_file.dmp log=impdpas.log schemas=schema_name

Hope This will help you to resolve your issue.

Subscribe to me for more updates :)