The web-based Enterprise Manager tool was introduced in Oracle 10g and has significant functionality improvements over previous versions. Even so, it seems there is not a day goes by without someone asking how to solve an Enterprise Manager configuration issue, so this article explains the first things you should look at. It's not meant to be an all encompassing guide. Just a first shot.
First, check the listener is running correctly.
If you get something like the following, your listener is not running and you need to start it using the "lsnrctl start" command.lsnrctl status
$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 13-MAR-2009 13:32:49 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11g.localdomain)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused $
Assuming the console is already running, or fails to start, the next thing to do is to reconfigure Enterprise Manager. This is done using the Enterprise Manager Configuration Assistant (EMCA). For a first attempt, run the following command.emctl start dbconsole
If this fails, then de-configure and configure Enterprise Manager.emca -config dbcontrol db -repos recreate If it all goes well you would expect to see something like this.$ emca -config dbcontrol db -repos recreate STARTED EMCA at Mar 13, 2009 11:32:35 AM EM Configuration Assistant, Version 11.1.0.7.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: DB11G Database Control is already configured for the database DB11G You have chosen to configure Database Control for managing the database DB11G This will remove the existing configuration and the default settings and perform a fresh configuration Do you wish to continue? [yes(Y)/no(N)]: Y Listener port number: 1521 Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.1.0/db_1 Local hostname ................ oel5-11g.localdomain Listener port number ................ 1521 Database SID ................ DB11G Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Mar 13, 2009 11:33:19 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/DB11G/emca_2009_03_13_11_32_35.log. Mar 13, 2009 11:33:20 AM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 5540 is already in use. Mar 13, 2009 11:33:20 AM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 5520 is already in use. Mar 13, 2009 11:33:20 AM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 1158 is already in use. Mar 13, 2009 11:33:20 AM oracle.sysman.emcp.util.PortManager isPortInUse WARNING: Specified port 3938 is already in use. Mar 13, 2009 11:33:20 AM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Mar 13, 2009 11:33:22 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... Mar 13, 2009 11:35:12 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Mar 13, 2009 11:35:12 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Mar 13, 2009 11:40:06 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Mar 13, 2009 11:40:11 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Mar 13, 2009 11:41:01 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Mar 13, 2009 11:41:07 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib INFO: Software library configured successfully. Mar 13, 2009 11:41:07 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Deploying Provisioning archives ... Mar 13, 2009 11:41:16 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO: Provisioning archives deployed successfully. Mar 13, 2009 11:41:16 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Mar 13, 2009 11:41:28 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Mar 13, 2009 11:41:28 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Mar 13, 2009 11:42:31 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Mar 13, 2009 11:42:34 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>> The Database Control URL is https://oel5-11g.localdomain:1158/em <<<<<< Mar 13, 2009 11:42:48 AM oracle.sysman.emcp.EMDBPostConfig invoke WARNING: ************************ WARNING ************************ Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.1.0/db_1/oel5-11g.localdomain_DB11G/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost. *********************************************************** Enterprise Manager configuration completed successfully FINISHED EMCA at Mar 13, 2009 11:42:48 AM $
If this fails, then de-configure and configure Enterprise Manager.emca -deconfig dbcontrol db -repos drop emca -config dbcontrol db -repos create
28 comments:
Hai From the above post I understood that you had a good knowledge on Oracle 11g DBA.. I too had good knowledge on Oracle 11g DBA because i have Oracle 11g DBA online training in 123trainings at hyderabad.. They will provide excellent training.
Very nice article,thanks for sharing
Oracle DBA Online Training institute
Well! The payroll world is extremely crucial and important as well. The only that has deficiencies in knowledge battle to experience along with options. You can either perform QuickBooks Payroll Support Phone Number processing in desktop or cloud, both ways are only just a little different but provde the same results.
We are going to provide full support to you. You are able to cope with the majority of the errors. We need to just coach you on something. Thoughts is broken trained, you're getting QuickBooks Support Number fine.
For the rectification for the issue call QuickBooks Technical Support Number is can help the Quickbooks users are right people to pin point and fix the issue completely. They assure resolution within the minimum wait time that saves you time.
How to contact QuickBooks Payroll support?
Different styles of queries or QuickBooks related issue, then you're way in the right direction. You simply give single ring at our toll-free intuit QuickBooks Desktop Payroll Support Phone Number . we are going to help you right solution according to your issue. We work on the internet and can get rid of the technical problems via remote access not only is it soon seeing that problem occurs we shall fix the same.
Enterprise edition brings along more technical processes and features, including a lot higher capacity to take care of more data and more advanced inventory management tools. But the beauty for this powerful software suit lies in its easy-to-understand graphical user interface and same navigational tools utilized in its lower versions, which make the QuickBooks Enterprise fairly easy to take care of even if you have no account handling experience. Normally sold as an all inclusive package on the market. Our QB Experts are pretty acquainted with most of the versions of QuickBooks Enterprise released on the market till now by Intuit. So whether it is selecting the most appropriate version of QB Enterprise for your needs or assessing the kinds of errors that are usually encountered in the various versions of QB Enterprise, Our QuickBooks EnterprIse Technical Support Number will have no difficulty in delivering the proper guidance and assistance with any issues and errors that users may have with QB Enterprise version.
QuickBooks accounting software is among the topmost, best and a lot of preferred business accounting software for small business owners or entrepreneurs. It really is regarded as the greatest accounting sofware for business management with many advanced services and features. And QuickBooks Payroll application is probably the most useful accounting service that may perform all payroll functions for activating the smooth functioning of the business. But many entrepreneurs in a few critical or troubling situation encounter various sort of error. If you're your small business entrepreneur or have any trouble managing your online business or employes pays, or have any other Quickbooks or accounting related trouble, then immediately contact our Accounting professionals or Quickbooks customer service or Quickbooks payroll support team through our toll-free QuickBooks Payroll Service Phone Number Here you can get the very best support for many Quickbooks functional or technical issue.
In short, the two companies are not related. GetHuman builds free tools and shares information amongst customers of companies like QuickBooks Support Number. For large companies that includes tools such as our GetHuman Phone, which allows you to call a company but skip the part where you wait on the line listening to their call technology music.
QuickBooks Support Phone Number – Inuit Inc has indeed developed an excellent software product to manage the financial needs associated with the small and medium-sized businesses.
Commercial And Finance Operating Bodies Usually Avail The Services Of The QuickBooks Enterprise Support Number As They Are In Continuous Use Of Workbook, Sheets, Account Records, And Payroll Management Sheets. While QuickBooks Offers Multiple Financial Needs And Advantages To Its Users, QuickBooks Enterprise Support Number Helps Its User To Resolve Any Kind Of Issue Generated.
QuickBooks Support Phone Number software makes you feel confident on a regular basis by allowing there is the ball always in your court. You are able to choose as per the norms of the company the rules that suit you best.
QuickBooks Tech Support Number will be the first point of contact to report the issue where you get your entire worries looked after off and assured solutions straight away provides you with complete peace of mind.
QuickBooks Tech Support Phone Number Premier Get built with several of the most brilliant accounting features such as for instance creating a company plan, easy remote access, inventory tracking and more.
Is made from a beautiful lot of accounting versions, viz., QuickBooks Pro, QuickBooks Premier, QuickBooks Enterprise, QuickBooks Help & Support, QuickBooks Mac, QuickBooks Windows, and QuickBooks Payroll, QuickBooks has grown to become a dependable accounting software you could tailor as per your industry prerequisite.
It is possible to put up a PIN to control the program being employed as per your preference. To let our QuickBooks experts, cope with the PIN related issue in QuickBooks, call us at QuickBooks Tech Support Phone Number USA .
QuickBooks Support Phone Number could be contacted to understand the ways to generate an automatic backup to truly save all your employee-related data from getting bugged or lost at any circumstances.
QuickBooks Enterprise features its own awesome features which can make it more reliable and efficient. Let’s see some awesome features which may have caused it is so popular. If you should be also a QuickBooks user and desires to get more information concerning this software you could browse the QuickBooks Enterprise Phone Support.
Comprises of an attractive lot of accounting versions, viz., QuickBooks Pro, QuickBooks Premier, QuickBooks Enterprise, QuickBooks POS, QuickBooks Mac, QuickBooks Windows, and QuickBooks customer Support Phone Number, QuickBooks is becoming a dependable accounting software that one may tailor depending on your industry prerequisite.
Our QuickBooks Support Phone Number is obtainable for 24*7: Call @ QuickBooks Technical Support contact number any time Take delight in with an array of outshined customer service services for QuickBooks via quickbooks technical support contact number at any time and from anywhere. It signifies that one can access our tech support for QuickBooks at any moment. Our backing team is dedicated enough to bestow you with end-to-end QuickBooks solutions when you desire to procure them for every single QuickBooks query.
The locus of your services may be based upon delivering services in shortest span of that time period, without compromising aided by the quality of your services. Our support team is engaged in pre-research to create themselves prepared in advance for the possible errors of QuickBooks. This practice helps them produce you the specified wind up in the given time window. We are there to assist you at QuickBooks Support Phone Number 24*7 as we try not to disassociate ourselves together with your troubles even through the wee hours. Intuit is perhaps all concerning User expertise which explains why they need creating dedicated QuickBooks Payroll Support Number Phone variety; Users will dial the fee number just in case they will have any facilitate in regards to the code.
Working Employees: The basic form of QuickBooks Payroll Tech Support Phone Number is, generally, planned and created for working employees. Tax Calculations: With the help of this, the tax calculations have grown to be a cup of tea. Tax submission has now become a click away.
Give a call at QuickBooks Support Phone Number, if you're encountering any difficulties which can be mentioned previously. If you are facing virtually any problems with your QuickBooks, you'll be able to also make instant calls. Your queries are certain to get resolved with no delays.
QuickBooks Support Phone Number toll free Number advisors are certified Pro-advisors’ and has forte in furnishing any kind of technical issues for QuickBooks. They have been expert and certified technicians of these domains like QuickBooks accounting,QuickBooks Payroll, Point of Sales, QuickBooks Merchant Services and Inventory issues to provide 24/7 service to our esteemed customers.
There are numerous features that produce QuickBooks Support Phone Number Premier standout such as for instance it gives bank security that aids anyone to go with IT maintenance smoothly. It's also possible to add quantity of users that can access company files at multiple locations.
Runtime errors may be annoying and persistent, but it is not totally hopeless, repairs are available. Here are ways to do it. If you would like to learn how to Fix QuickBooks Error 9999, you can continue reading this blog.
Excellent post. Thanks for sharing such great and helpful info with us. Keep it up. I appreciate this informative post. Want to know about QuickBooks Visit here.
QuickBooks enterprises support!
Post a Comment