Pages

Tuesday 5 February 2013

OBIEE 11g startup issue :fails to start system components.


While starting system components using opmnctl, it fails with below error.

$ ./opmnctl startall
opmnctl startall: starting opmn and all managed processes...
/orasw/MW_HOME/Oracle_BI1/opmn/bin/opmn: unexpected exit: code 512
opmnctl startall: opmn failed to start.

Reason

Check OPMN logs to find the issue.

cd $INSTANCE_HOME/diagnostics/logs/OPMN/opmn

$ ls -lrt
total 10072
-rw-r----- 1 oracle oinstall       0 Sep 27  2011 debug.log
-rw-r----- 1 oracle oinstall     432 Jan 13 07:06 opmn.out
-rw-r----- 1 oracle oinstall  257891 Jan 22 00:32 logquery~5.log
-rw-r----- 1 oracle oinstall  269575 Jan 22 00:32 logquery~4.log
-rw-r----- 1 oracle oinstall  273531 Jan 22 00:32 logquery~3.log
-rw-r----- 1 oracle oinstall  279896 Jan 22 00:32 logquery~2.log
-rw-r----- 1 oracle oinstall  290644 Jan 22 00:32 logquery~1.log
-rw-r----- 1 oracle oinstall 8894259 Feb  5 00:41 opmn.log


In the log we found that OPMN Local Port and Remote ports are already in use by some other process.

[2013-02-04T04:48:36][opmn][ERROR:1][17][OPMN][code:ons-listener]any: BIND (Address already in use)
[2013-02-04T04:49:50][opmn][NOTIFICATION:1][90][OPMN][code:ons-internal]ONS server initiated
[2013-02-04T04:49:50][opmn][NOTIFICATION:1][522][OPMN][code:pm-internal]PM state directory exists: /orasw/MW_HOME/instances/instance1/config/OPMN/opmn/states
[2013-02-04T04:49:50][opmn][NOTIFICATION:1][675][OPMN][code:pm-internal]OPMN server ready.  Request handling enabled.
[2013-02-04T04:49:50][opmn][ERROR:1][17][OPMN][code:ons-listener]any: BIND (Address already in use)
[2013-02-05T00:41:07][opmn][NOTIFICATION:1][90][OPMN][code:ons-internal]ONS server initiated
[2013-02-05T00:41:07][opmn][NOTIFICATION:1][522][OPMN][code:pm-internal]PM state directory exists: /orasw/MW_HOME/instances/instance1/config/OPMN/opmn/states
[2013-02-05T00:41:07][opmn][NOTIFICATION:1][675][OPMN][code:pm-internal]OPMN server ready.  Request handling enabled.
[2013-02-05T00:41:07][opmn][ERROR:1][17][OPMN][code:ons-listener]any: BIND (Address already in use)

Solution:

1. Go to $INSTANCE_HOME/config/OPMN//opmn.xml and check the ports.
In our case it was 9500 and 9501 ports

2. Check who is using these ports using below command.

$ netstat -an |grep 9500
tcp        0      0 ::ffff:10.241.37.9:9500     :::*                        LISTEN
tcp        0      0 ::ffff:10.241.37.9:9500     ::ffff:10.241.37.9:60741    ESTABLISHED
tcp        0      0 ::ffff:10.241.37.9:60741    ::ffff:10.241.37.9:9500     ESTABLISHED

$ netstat -an |grep 9501
tcp        0      0 :::9501                     :::*                        LISTEN


So both ports are being used.

3. Either terminate processes using these ports or change ports in opmn.xml with ports not in use.

In our case, 9502 and 9503 weren't in use so replaced with these ports in opmn.xml.

4.Start system components now.

cd $INSTANCE_HOME/bin

$ ./opmnctl startall
opmnctl startall: starting opmn and all managed processes...

$ ./opmnctl status

Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
coreapplication_obiccs1          | OracleBIClusterCo~ |   31392 | Alive
coreapplication_obisch1          | OracleBIScheduler~ |   31394 | Alive
coreapplication_obijh1           | OracleBIJavaHostC~ |   31393 | Alive
coreapplication_obips1           | OracleBIPresentat~ |   31391 | Alive
coreapplication_obis1            | OracleBIServerCom~ |   31395 | Alive

29 comments:

  1. Appreciation for nice Updates, I found something new and folks can get useful info about BEST obiee ONLINE TRAINING

    ReplyDelete
  2. 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.

    ReplyDelete
  3. I appreciate you sharing this article. Really thank you! Much obliged.
    This is one awesome blog article. Much thanks again.

    oracle online training
    sap sd online training
    sap-crm-online-training
    hadoop online training

    ReplyDelete
  4. Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!

    sap online training
    sap fico online training
    dotnet online training
    qa-qtp-software-testing-training-tutorial

    ReplyDelete
  5. Hi, thanks for sharing such an informative blog. I have read your blog and I gathered some needful information from your blog. Keep update your blog. Awaiting for your next update. sap abap crm training

    ReplyDelete
  6. The user can surely get generate real-time basis advanced reports by using QuickBooks. If one is certainly not known of the feature, then, you are able to call our QuickBooks Support. They're going to surely provide you with the necessary information to you.

    ReplyDelete
  7. Our QB Experts are pretty knowledgeable about most of the versions of QuickBooks Enterprise released on the market till now by Intuit. So whether it's seeking the most appropriate form of QB Enterprise for your requirements or assessing the sorts of errors that are usually encountered into the various versions of QB Enterprise, Our QuickBooks Enterprise Technical Support Number could have no difficulty in delivering the proper guidance and help with any issues and errors that users may have with QB Enterprise version.

    ReplyDelete
  8. With the aid of QuickBooks Desktop Payroll Support Phone Number, you can easily create employee payment on time. In any case, you are facing some problem when making use of QuickBooks payroll such as issue during installation, data integration error, direct deposit issue, file taxes, and paychecks errors, installation or up-gradation or perhaps about just about any than you don’t panic, we provide quality QuickBooks Desktop Payroll Support Phone Number.

    ReplyDelete
  9. This installation related problem may be solved by letting the executives that are handling the QuickBooks Help Number know the details linked to your license and the date of purchase for the product to instantly solve the put up related issue.

    ReplyDelete
  10. Issues like these and all sorts of the other complex ones are very easily resolved by our team at QuickBooks Support Phone Number. Our customer care executives are experienced, talented, hardworking an efficient. They put their hundred percent efforts and then make certain to have you avail their 24*7 assistance. Contact us at our toll-free number or drop us a mail.

    ReplyDelete
  11. QuickBooks accounting software is integrated with different products like QuickBooks Enterprise(developed by Intuit) and tools like QuickBooks file doctor. Also it offers a number of incredible features (Business plans, cash flow projections, and advanced inventory ) which make it unique off their Quickbooks product. It is most suitable for small to medium businesses though it is incredibly expensive. Without doubt, it offers good compatibility with nearly every type of Windows OS, Mac OS, iOS, and Android. Yet you may require a simple yet effective QuickBooks Enterprise Support Number to address payroll management, account management, inventory, along with other accounting activities. AccountWizy provides you an ideal and efficient QuickBooks Enterprise Customer service to really make it all possible.

    ReplyDelete
  12. Our support, as covered by QuickBooks Enterprise Support Experts at, includes most of the functional and technical aspects from the QuickBooks Enterprise. They include all QuickBooks errors encountered during the running of QuickBooks Enterprise and all sorts of issues faced during Installation, update, and also the backup of QB Enterprise.

    ReplyDelete
  13. Problems are inevitable and they also usually do not come with a bang. Our team at QuickBooks Support Phone Number is ready beforehand to provide you customer-friendly assistance if you talk to an issue using QuickBooks Pro. Most of us is skilled, talented, knowledgeable and spontaneous. Without taking most of your time, our team gets you rid of most unavoidable errors of this software.

    ReplyDelete
  14. After after the above troubleshooting steps, you can actually fix printer problem in QuickBooks. However, if you're facing any trouble or not able to perform the troubleshooting steps on your own own, avail our QuickBooks Support telephone number available twenty-four hours a day to solve any QuickBooks Support Phone Number related issues instantly.

    ReplyDelete
  15. amongst individuals and thus they find approaches to invent alternatives for daily tasks. If you are a small business owner, you need to be aware of the fact that Payroll calculation does demands large amount of time and man force. Then came into existence QuickBooks Tech Support Number Customer Support telephone number team.

    ReplyDelete
  16. The guide may have helped you understand
    QuickBooks Tech Support Phone Number file corruption and methods to resolve it accordingly. If you'd like gain more knowledge on file corruption or any other accounting issues, then we welcome you at our professional support center.

    ReplyDelete
  17. But sometimes due to not enough technical knowledge or proficiency in QuickBooks Tech Support Number accounting customers face various type of technical error or issues. When you yourself have any trouble in managing transaction,

    ReplyDelete
  18. You are able to choose for any QuickBooks versions looking on the desires. QuickBooks are often generally split into 2 categories: QuickBooks Support Phone Number version and QuickBooks Desktop version.

    ReplyDelete
  19. A business must notice salaries, wages, incentives, commissions, etc., it has paid into the employees in a period period. Above all is the tax calculations must be correct and according to the federal and state law. Our Quickbooks Support will surely guide you in dealing with all this.

    ReplyDelete
  20. QuickBooks software is helpful for managing the work flow flawless and smooth by prints the payroll components and exchange report are necessary for the modern bookkeepers etc. It is according to application or the cloud based service. Its versions such as:, QuicKbooks Customer Tech Support Phone Number, Contractor , Enterprises and Pro Advisor which helps the countless small company world wide .

    ReplyDelete
  21. Amended income tracker, pinned notes, better registration process and understandings on homepage are among the list of general alterations for most versions of QuickBooks 2015. It can help for QuickBooks Enterprise Support USA to obtain technical help & support for QuickBooks.

    ReplyDelete
  22. QuickBooks Payroll Support Phone Number is an end to end business, advanced competitive accounting software. But since it is reasonably limited software with many advanced functions, taking support when it comes to software is a better solution to run this impressive software without any technical issue.

    ReplyDelete
  23. So if you feel something went wrong with your QuickBooks Tech Support Number accounting software and know about QuickBooks loan manager, so for the reason that case, you can just get tech support team from our amazing expert’s team, day time and night to easily solve any issues or errors pertaining to QuickBooks.

    ReplyDelete
  24. Every business wishes to obtain revenues on a regular basis. But, not all of you will be capable. Do you realize why? QuickBooks Support Number really is as a result of not enough support service.

    ReplyDelete
  25. Your PC often crashes with QuickBooks Error 9999 when running the same program. If you would like to learn how to Troubleshoot Quickbooks Error 9999, you can continue reading this blog.

    ReplyDelete