Solved

Oracle DAC error "ORA-12547:TNS:lost contact

Posted on 2007-03-28
11
1,483 Views
Last Modified: 2007-10-18
"ORA-12547:TNS:lost contact" is specifically the error I get , there is also some memory errors in the 2003 windows server event viewer , I dont have the exact error in the windows event viewer but i will post it here soon, could this error be realted to memory errors ?, I have another box that runs this fine and has a very simular config and has no errors at all . the database is a Oracle 10g and has no timeouts set , the connection is  set to NEVER timeout on the oracle side  
0
Comment
Question by:kaos_theory
11 Comments
 
LVL 3

Expert Comment

by:popa_duhu
ID: 18814122
you should post all you have... this can happen for many reasons
0
 
LVL 47

Expert Comment

by:schwertner
ID: 18814362
What is Oracle version?
I have the feeling that 10.2.0.3 is rather bugy.
I also met this error but soon it desapears.
0
 
LVL 27

Expert Comment

by:sujith80
ID: 18815072
Anu restriction for nodes in sqlnet.ora?
0
 
LVL 2

Author Comment

by:kaos_theory
ID: 18815364
no restrictions on sqlnet.ora and the version is 10.2.x oracle ,

what kind of log files ect do i need to post , I am VERY new to Oracle so you will have to forgive me
0
 
LVL 47

Expert Comment

by:schwertner
ID: 18815845
If the error disapears after some time
then ignore it. I have the same situation
with 10.2.0.3 - it happens some times and after 10 minutes the message disapears.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 2

Author Comment

by:kaos_theory
ID: 18820769
what i have here is 3 servers and server A has this issue server B and server C do not . server B and C have a large paging file on the D drive , server A does not it has a small paging file on the c: drive and has the error on it ,

my plan is to further anylize the two servers that work aaginst the one that has the error , what i could use is some advice on what specifically to look for , there is alot of variables to look at oracle versions and parmaters, DAC and JAVA versions , inforamtica versions and configs and then there is system stuff like the paging file and who the hell knows what else the next thing i am going to look at is full duplex on the nic ect points given for ANY SUGGESTION ON WHAT TO LOOK FOR

this server is running oracle DAC, Oracle 10g and informatica has about 12 gb of ram and a faast processor ect.  
0
 
LVL 47

Expert Comment

by:schwertner
ID: 18822095
10.2.x has no meaning.
SQL>select version from v$version;

If this is 10.2.0.3 then be aware that I am unsatisfied by this
version - it causes me too much troubles.
I also run in your problem - but it apears only for 10 minutes and disapears.

>>what i have here is 3 servers and server
Ok, but every Oracle installation hat its own version.
Please share the versions (if you are allowed by internal rules
of youir organization).
0
 
LVL 2

Author Comment

by:kaos_theory
ID: 18823032
ok will do , as soon as I can , right now I am configuring the page file to be the same size
0
 
LVL 2

Author Comment

by:kaos_theory
ID: 18911917
i am not sure who to give the pionts to , but here is the ultimate issue the database  was in a location in boston we are in dc , there was a lot of miscommunication on this fact , but after much digging i fould out this to be at least part of the issue . the servers also ran SAV anti virus , i had stopped the av from scanning in and out bound fiels but did not actully shut the service  off, and this had no effect is stil got the ora errorNext I excluded the dac program files from the sav scan  the ora error what not apperant after this change however some other connectivity related errors started to occur in the DAC. I will post more as i know it .
0
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 18916197
1. Check for firewalls and antiviruses and not only stop them, the antiviruses should be deinstalled.
2. If the installation was done with turned firewall on possibly it is damaged. new installation is the best solution.
3. In LISTENER.ORA you should do STATIC registration of the service. I have posted hundred times how to do this - find me previous postings
4. Try to change the NIC (Network Card) of the computer -  curiously sometimes this helps.

I do not agree to have an Oracle instance in Boston not working properly - my son  graduated Tufts and is working there, so I will help to reinstall the instance but will get it working :))))
0
 
LVL 2

Author Comment

by:kaos_theory
ID: 19059039
thanks step 3 and 4 were helpfull in resolving
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now