Solved

TNS-12535: TNS:operation timed out

Posted on 2009-03-31
4
1,117 Views
Last Modified: 2012-06-27
My problem seems to be the exact replica of the question already discussed on " Title:UNABLE TO CONNECT TO DATABASE".
I am posting this question again, as, there was no solution found for this question in that thread. Please redirect me, if there is another thread, which I can refer to fix my issue.

To briefly summarize the issue i am facing:

[1] Installed Microsoft Loopback Adapter
[2] Installed Oracle 10g on my laptop (Windows XP) => ORACLE_HOME = C:\Oracle10g\product\10.2.0\db_1
[3] Global Database Name: WMLOCAL / Pwd: wmlocal
[4] At the end of the installation, an error was displayed that EM Cannot be started.
[5] Changed all the password to a common one = wmlocal
[6] Installation completed.

Now, when I try to perform:
[a] tnsping wmlocal => I get TNS-12535: TNS:operation timed out
[b] Try to Start the Service "OracleDBConsolewmlocal" => Fails with timeout. (Screenshot attached)
[c] lsnrctl stop & start worked without any exception
[d] lsnrctl status => File Attached with the output.
[e] sqlplus system/wmlocal@wmlocal as sysdba => ORA-12170: TNS:Connect timeout occurred (output attached)

Note 1: Attached are my tnsnames.ora, listener.ora & sqlnet.ora files
Note 2: Already re-installed couple of times from scratch, but no luck.

Your inputs/help is very much appreciated.

Regards,
Amitabh.
ListenerStatus.txt
OracleDBConsolewmlocal-startup-e.JPG
sqlplus-system-as-sysdba.txt
tnsnames.txt
sqlnet.txt
listener.txt
0
Comment
Question by:amitabhob
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 24032238
Try to remove the line       (GLOBAL_DBNAME = WMLOCAL) from LISTENER.ORA file.
Seems you use Virtual machine. You have to check the IP this machine uses.

The loopback adapter should be the first adapter in the list.
You should follow strictly the manual that describe this at
http://download-west.oracle.com/docs/html/B10130_02/reqs.htm#BABDJJFF

Finally when you install Oracle and running it you should TURN OFF the default Windows FIREWALL and all other firewalls (often there are more then one firewall on the computer).

The fact that components couldn't start shows that the installation is not good.
0
 
LVL 2

Accepted Solution

by:
QTH earned 150 total points
ID: 24032260
Hello Amitabh,

It sounds like the listener service could not find the host.  I guess BHATTA2-L24.ent.core.medtronic.com is the name of your PC?  Have you tried using 127.0.0.1 instead?

Rgds,

QTH
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 150 total points
ID: 24032300
After installation with running firewall the only option is to delete the installed product and to begin from scratch.

In listener.ora change the line

(ADDRESS = (PROTOCOL = TCP)(HOST = BHATTA2-L24.ent.core.medtronic.com)(PORT = 1521))

with
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

and try to start the Listener service.
0
 

Author Comment

by:amitabhob
ID: 24032739
Thanks a lot for your quick help.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question