Jump to content


How to solve ORA 12170 Error in oracle form developer 10 g


  • Please log in to reply
3 replies to this topic

#1 sarajabeen

sarajabeen

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 17 August 2010 - 10:52 AM

I have installed oracle 10 g form developer suite on windows 7.But when i tried to connect i m facing error 12170 tns connection time out.I Tried a lot of things like changing registry from TNS to none.changing tnsnames.ora with & sql.ora file.
Please figure out some solution
  • 0

#2 plumbum

plumbum

    Newbie

  • Members
  • Pip
  • 16 posts
  • Gender:Male
  • Location:Poland

Posted 10 September 2010 - 10:17 PM

I have installed oracle 10 g form developer suite on windows 7.But when i tried to connect i m facing error 12170 tns connection time out.I Tried a lot of things like changing registry from TNS to none.changing tnsnames.ora with & sql.ora file.
Please figure out some solution


Too small informations.
12170 can be for many reasons, f.e. listener not running, instance not running, firewall on network card, listener doesn't know about instance or isn't registered with instance bacause listener working on nondefault port, wrong ip address on listener configuration, wrong tnsnames and/or sqlnet configuration.
Using commandline you can test resolve connection to listener using tnsping. This programm can check that tnsnames resolve good ip address, port and the name of service your database.
Good luck.
  • 0

#3 sarajabeen

sarajabeen

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 05 October 2010 - 03:54 AM

Too small informations.
12170 can be for many reasons, f.e. listener not running, instance not running, firewall on network card, listener doesn't know about instance or isn't registered with instance bacause listener working on nondefault port, wrong ip address on listener configuration, wrong tnsnames and/or sqlnet configuration.
Using commandline you can test resolve connection to listener using tnsping. This programm can check that tnsnames resolve good ip address, port and the name of service your database.
Good luck.


  • 0

#4 sarajabeen

sarajabeen

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 05 October 2010 - 03:59 AM

Dear,
I again installed the oracle 10g on windows 7.When i was installing it i encountered the error 12546 in oracle database configuration assistant saying TNS permission denied.Does any body have idea ,how to resolve this error.Kindly explain the process in detail as i am new to oracle.
Thanks
Tc.
  • 0





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users