I am unable to start TNSListener service for Oracle10G

oracle10g listener tns
user1466466 picture user1466466 · Sep 17, 2012 · Viewed 24.2k times · Source

I am unable to restart/start/stop TNSListener service. I am getting following error:- "The OracleDb_10gTNSListener Service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and Alerts Service". Please help me

Answer

ikr picture ikr · Jul 11, 2015

Step 1: Check your ip address and copy it.

Step 2: Open (listener.ora) in notepad and replace the HOST ip address with your current ip address.That you copied earlier.

Note: Do not forget to replace the second entry of HOST ip.

Step 3: Now open (tnsnames.ora) with notepad and replace HOST ip address with your current ip address.

Finally start your listner service from windows services or from command prompt. Hope this will work. Worked for me.

Related questions

How to find the privileges and roles granted to a user in Oracle?

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any dictionary permission to the same user. i also granted sysdba and sysoper roles to the same users. Now i want …

Read More
Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select instance from v$thread; but table or view does not exist error is coming. I am using following query for checking …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More