Solved

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

Posted on 2007-03-28
11
1,536 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
[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
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 48

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
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!

 
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 48

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
 
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 48

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 48

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

Industry Leaders: 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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

734 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