failed to open service error 1060 oracle Harpster Ohio

Address 906 Rogers St, Bucyrus, OH 44820
Phone (419) 834-9484
Website Link

failed to open service error 1060 oracle Harpster, Ohio

share|improve this answer answered Nov 20 '10 at 22:33 JOTN 4,65811621 add a comment| up vote 1 down vote I ran into the same issue when I rebuilt a database server. Re: TNS-12560: TNS:protocol adapter error and TNS-00530: Protocol adapter e OrionNet Dec 14, 2008 5:57 AM (in response to 673322) So now listener is running but it doesn't support any service. when started the listener iam getting the error that "The listener supports no services" As per the oracle documentation i configured my listener.ora file with values, newDB = (DESCRIPTION_LIST = (DESCRIPTION Required fields are marked *Comment Notify me of followup comments via e-mail Name * Email * Website TagsACC ATG bcc bugs configuration Cygwin debug dreamhost dsp Eclipse ecommerce emacs facebook

For example, if you install the Oracle RDBMS Software and then the Oracle Agent, the Oracle Agent will be first in the PATH and the first place Windows will look. Correct path for listener.ora and tnsnames.ora path is also same C:\oracle\ANK\102\NETWORK\ADMIN.I think you need to check all files 1 by 1 & point it to correct ones. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.

Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of What exists that I don't know about? Then you can connect sqlplus scott/[email protected] sqlplus scott/[email protected] -- good idea to keep your instance name Did you try creating listener using netca again? what clues exist within alert_{SID}.log file about the status of the DB?

Cookies helfen uns bei der Bereitstellung unserer Dienste. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. More discussions in Database Installation All PlacesDatabaseGeneral Database DiscussionsDatabase Installation This discussion is archived 1 2 Previous Next 17 Replies Latest reply on Dec 14, 2008 6:38 AM by OrionNet TNS-12560: Re: TNS-12560: TNS:protocol adapter error and TNS-00530: Protocol adapter e 673322 Dec 14, 2008 5:50 AM (in response to OrionNet) i deleted the old listener and restarted the machine and the

oracle share|improve this question asked Nov 20 '10 at 12:31 sdsds 42134 1 Have you checked the log? You're now being signed in. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> startStarting tnslsnr: please wait...Failed to open service , error 1060.Failed to start service, error 1060.TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter errorRegards,Ankit C:\oracle\NETWORK\ADMIN is also correct?No.

i want to connect from sqlplusw9i to sqlplusw10g. I have attached the alert_scott.txt In that database I have given scott, still some other error, it is showing. Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

Original IPs were changed and listener was using the old IP. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Just please remember to start it back up again after you are done! Re: TNS-12560: TNS:protocol adapter error and TNS-00530: Protocol adapter e 673322 Dec 14, 2008 5:30 AM (in response to 673322) when i added that tns entry and did ?lsnrctl start it

You can not post a blank message. ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor Enter user-name: -- With Regards Prasad Reply With Quote 05-05-2006,02:59 AM #5 varaprasad_1261 View Profile View Forum Posts Junior Member Its my personal laptop. Bibliografische InformationenTitelOracle Net8 Configuration and TroubleshootingOreilly SeriesAutorenHugo Toledo, Jonathan GennickAusgabeillustriertVerlagIdea Group Inc (IGI), 2001ISBN1565927532, 9781565927537Länge387 Seiten  Zitat exportierenBiBTeXEndNoteRefManÜber Google Books - Datenschutzerklärung - AllgemeineNutzungsbedingungen - Hinweise für Verlage - Problem melden -

Bookmark the permalink. 12 thoughts on “Oracle TNS Listener service not starting” Null on June 14, 2010 at 8:34 PM said: Thank you! Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? It started the listener successfully.

If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Following is my listener.ora created using netca LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = computer2)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) Is it possible to have a planet unsuitable for agriculture? Use tasklist /m to find the Owner of any Open DLLs If the Oracle installer or OPatch reports a specific DLL being open, you can find out what has that DLL

Is your database started? Can Communism become a stable economic strategy? Another possibility, specific to windows, is a registry setting is incorrect. Errata?

It may also be used to connect database servers to one another, allowing communication between distributed databases.This practical guide provides the information that readers, especially database administrators, need to know in Please turn JavaScript back on and reload this page. Why are empty blocks not all the same size? This file is actually generated by netca.

Top This thread has been closed due to inactivity. Sum of neighbours Why would a password requirement prohibit a number in the last character? leave blank?