Oracle Listener Error 1067 The Process Terminated Unexpectedly
Contents |
a comment Recently, we faced an issue with listener service on Windows Server. We were oracle xe tns listener not starting windows 7 trying to start listener service but received error 1067. Tried all
The Oraclexetnslistener Service On Local Computer Started And Then Stopped
kind of RnD; drop and recreate listener, permission nothing worked. Then went deep into oracle_home, came to windows could not start the oraclexetnslistener service on local computer know there were two oracle_home on the same server. Checked Path in Environment Variable, it was pointing to right oracle_home. But interestingly the environment variable of oracle_home
System Error 1067 Has Occurred Oracle
was pointing to wrong location. Which is why we encountered this error. The oracle_home location in Environment variable was then changed to the correct/required location and tried starting the listener service. The listener service was up and able to connect remotely. Share this:PrintEmailFacebookLinkedInTwitterGoogleLike this:Like Loading... Related Post navigation ← Previous post Next post → error 1067 the process terminated unexpectedly oracle service Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. March 2012 M T W T F S S « Feb May » 1234 567891011 12131415161718 19202122232425 262728293031 CategoriesCategories Select Category Administration(5) Backup And Recovery(5) Clone(1) Dataguard(5) Datapump(2) Materialized Views(1) Migration(1) ORA-(8) Oracle 11gR1(5) Oracle 11gR2(1) Oracle 12c(2) Oracle Webinars(12) Patches(1) Performance Tuning(5) RMAN(5) Scripts(7) Table partition(1) Troubleshooting(20) Uncategorized(7) Unkonwn(2) Events & Webinars Events & Webinars Blogroll AristaDBA's Oracle Blog - Aman Sharma asktom Charles Hooper's Oracle Notes Coskan's Approach To Oracle Gwen Shapira Hemant's Oracle DBA Blog Insight Technology Blog Kamran Agayev's Oracle Blog Karl Arao'
This Site Careers Other all forums Forum: Oracle/OAS Unable to connect to oracle instance using listener faisal khan Ranch Hand Posts:
Oracleservicexe Not Starting Automatically
47 posted 11 years ago I have problem in getting
Oraclexetnslistener Doesn't Start
connection with oracle instance on my local PC. My instance named 'faisal' started successfuly from Windows oracle tns listener service on local computer started and stopped 2000 server 'Serivces' menu. But when I start 'OracleOraHome90TNSListener' from windows 2000 server 'services' menu, it starts but stop. If i start and stop by myself https://shrikantrao.wordpress.com/2012/03/23/error-1067-the-process-terminated-unexpectedly-with-listener/ then following exception was shown. --------------------------- Microsoft Management Console --------------------------- Could not stop the OracleOraHome90TNSListener service on Local Computer.Error 1067: The process terminated unexpectedly. --------------------------- So, I am unable to connect with oracle instance. Following is "tnsnames.ora" file content. # TNSNAMES.ORA Network Configuration File: G:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. INST1_HTTP = https://coderanch.com/t/80706/Oracle-OAS/Unable-connect-oracle-instance-listener (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = faisal)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) FAISAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = faisal)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = faisal) ) ) Following is "listener.ora" file contents # LISTENER.ORA Network Configuration File: G:\oracle\ora90\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = faisal)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = G:\oracle\ora90) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = faisal) (ORACLE_HOME = G:\oracle\ora90) (SID_NAME = faisal) ) ) kindly help me in this regard. Its urgent now.
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX http://sap.ittoolbox.com/groups/technical-functional/sap-basis/error-1607-the-process-terminated-unexpectedly-3088598 Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold http://juststuffreally.blogspot.com/2008/06/tnsno-listener-error-proves-no-match.html Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct error 1067 View All Topics View All Members View All Companies Toolbox for IT Topics SAP Groups Ask a New Question SAP Basis The SAP Basis group is for the discussion of specific configuration and development issues that arise when utilizing the SAP Basis & System Administration. Home | Invite Peers | More SAP Groups Your account is ready. You're now being signed in. Solve problems - It's service on local 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. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error 1607 the process terminated unexpectedly elaya raja asked Oct 30, 2009 | Replies (7) Hi After restarting 10 G oracle server , the listener is not started. the error is ..... error 1607 the process terminated unexpectedly pl help this issue anyone Thanks & regards raja Join this group Best Answer Updated html error Hi Raja, What is your OS? Regards Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Always respect the original author. Edits are subject to review by community moderators. Original answer by David Caddick Oct 30, 2009 Contributors: Top Hi Raja, What is your OS? Regards Reply from David Caddick | Oc
a few changes to my network I found that Oracle no longer started. The first step to checking things was to use super-useful Oracle command #1: "tnsping". If you have the Oracle bin in your path, you can run this from anywhere:tnsping mybaseTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-JUN-2008 11:14:42Copyright (c) 1997, 2005, Oracle. All rights reserved.Used parameter files:C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.198)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mybase)))TNS-12535: TNS:operation timed outSo, first problem is that the host name I'm using is hard-coded in there to be "10.0.1.1". A quick check of "ipconfig /all" reveals that, with my network tinkering, my IP address has changed. In fact, I'm running XP on a virtual machine and not using a static IP address so the IP address was going to change sometime anyway. So we'll replace my IP address with my new IP address instead. To modify this setting, find your "tnsnames.ora" file; for me it lives at C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora.OK, so now a "tnsping" gives me the lovely "TNS-12541: TNS:no listener" message. Checking my Windows Services, I can see that the Oracle TNS Listener service (OracleOraDb10g_home1TNSListener) is stopped. If I try to start it I get a nice generic Windows Service message "Error 1067: The process terminated unexpectedly."So, how do I find out what is happening with the listener? By using super-useful Oracle command #2: "lsnrctl". Again you can find this in your Oracle bin directory. You can now check the listener status via "lsnrctl status". Again, this revealed the same "10.0.1.198" IP address hard-coded in the listener