Oracle Bi Solutions

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Saturday, 19 January 2013

[OBIEE11g] - Fixing Weblogic and bi_server1 startup issues due to corrupted files

Posted on 23:53 by Unknown

  1. Enter into the directory: C:OracleFMWuser_projectsdomainsbifoundation_domainserversAdminServersecurity
  2. make a copy of boot.properties rename the copy to boot.properties.ORG
  3. edit the boot.properties and make sure the below is entered, here “administrator1″ is the original password used to login before the corruption happened:
  4. Enter into the directory: C:OracleFMWuser_projectsdomainsbifoundation_domainserversAdminServerdata
  5. rename the ldap folder to ldap.ORG
  6. make a new folder with the name “ldap”
  7. You need to repeat the above steps for changing the boot.properties and creating new ldap folder for the Managed “bi_server1″ also under the directories:
    C:OracleFMWuser_projectsdomainsbifoundation_domainserversbi_server1security
    and
    C:OracleFMWuser_projectsdomainsbifoundation_domainserversbi_server1data
  8. Open up the command prompt then “cd” to C:OracleFMWuser_projectsdomainsbifoundation_domainbin and execute “startManagedWebLogic.cmd” command.
  9. Start the nodemanager service if it is not running, by going to the “Control Panel” -> “System and Security” -> “Administrative Tools” then open up the “Services” and start the the service : “Oracle WebLogic NodeManager (C_OracleFMW_wlserver_10.3)”
  10. Now open the location in a browser“http://localhost:7001/console” and login with the new user and password i.e weblogic/administrator1
  11. on the left side in the “Domain Structure” go to bifoundation_domain -> Environment -> Servers.
  12. On the right “Summary of Servers” Pane click the “Control” tab.
  13. Select the “bi_server1″ then click the “Start” button.
  14. Click “Yes” when asked: “You have selected the following servers to be started. Press ‘Yes’ to continue or ‘No’ to cancel”
  15. Once your “bi_server1″ Managed Server is started and you see the “State” and “RUNNING”, this you can be refreshing the page by clicking on the “Servers” link under bifoundation_domain -> Environment -> Servers.
  16. We now need to shutdown both the “AdminServer(admin)” and “bi_server1″.
  17. Goto the “Control” Tab and select the “bi_server1″ and select “Shutdown” -> “Force Shutdown Now”
  18. Click the “Yes” button when asked: “You have selected the following servers to be immediately shut down. Press ‘Yes’ to continue or ‘No’ to cancel.”
  19. Goto the “Control” Tab and select the “AdminServer” and select “Shutdown” -> “Force Shutdown Now”
  20. Click the “Yes” button when asked: “You have selected the following servers to be immediately shut down. Press ‘Yes’ to continue or ‘No’ to cancel.”
  21. Now you can use the below to start back your OBIEE 11g services:
    C:OracleFMWinstancesinstance1bifoundationOracleBIApplicationcoreapplicationStartStopServices.cmd
    start_all shortcut
    OR
    use the ./opmnctl startall
  22. Open the http://localhost:7001/em and goto “Farm_bifoundation_domain” -> “Weblogic_Domain” -> bifoundation_domain.
  23. On the right side pane select “Weblogic Domain” -> Security -> Credentials.
  24. Expand the oracle.bi.system and select the system.user and click the Edit link
  25. Keep the defaults and only change the password to a new password. as show below:
  26. Click Ok.
  27. Goto the http://localhost:7001/em location in your web browser.
  28. Goto the “Farm_bifoundation_domain” -> “Business Intelligence” -> coreapplication.
  29. On the right pane select the “Deployment” tab then the “Repository” tab and note the repository being used in this case it is: BISAMPLE_BI0014.
  30. Now stop all the OBIEE processes. with ./opmnctl stopall or the “Stop BI Servcies” shortcut
  31. Open the “Oracle BI Administration Tool” and open the BISAMPLE_BI0014.rpd in offline mode
  32. Goto Manage -> Identity and under “Identity Management” -> “BI Repository” delete all the users i.e weblogic or any other admin users.
  33. Come out of the “Identity Manager” and save your changes and close the “Administration Tool”.
  34. Now restart all your servcies with the “Start BI Services”
  35. Now try to login into http://localhost:9704/analytics
Note:
You might need to delete the “cacheduserinfo” and “cacheduserinfo.atr” files under:
C:OracleFMWinstancesinstance1bifoundationOracleBIPresentationServicesComponentcoreapplication_obips1catalogSampleAppLiterootusersweblogic_prefs
and also you might have to fiddle with the other steps mentioned in the doc:
OBIEE 11g6: Deleting and Re-Creating Users in Weblogic LDAP Server
to get your OBIEE analytics to be able to log you in.
Summary:
  1. With the many changing features in the OBIEE 11g security model, the below are the few things to keep in mind while debbugging login issues:
  2. Make sure that your both URLs are tried:http://localhost:9704/analytics and http://<Local-IP>:9704/analytics.
  3. Make sure that GUIDs are properly refreshed with changes in NQSConfig.ini and instantconfig.xml files with a restart of OBIEE processes.
  4. Make sure that the BISystemUser credentials are updated in thehttp://localhost:7001/em page.
  5. Make sure that the currently deployed “.rpd” file has the stale “weblogic” user reference deleted and redeployed if neccessary.
  6. Lastly you can create a user BISystemUser in yourhttp://localhost:7001/console and add “Administrators” Group and repeat step 4 under Summary, restart all services and login to analytics again.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in OBIEE | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • [ODI] - Frequently Asked Questions (FAQ)
    Here is a list of FAQs about Oracle Data Integrator 1) What is Oracle Data Integrator (ODI)? 2) What is E-LT? 3) What components make up Ora...
  • Upper Function
    In Oracle/PLSQL, the  upper function  converts all letters in the specified string to uppercase. If there are characters in the string that ...
  • OBIEE 11g not showing new dashboard in the drop down menu
    When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu. 1. When ...
  • OBIEE 11g Hide/Show Sections based on Dashboard Prompt
    allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly...
  • [OBIEE11g] - OBIEE Dashboard for Informatica Metadata Reporting
    The metadata that Informatica Power Center 8 retains in its repository can be exposed via OBIEE reports and dashboards. This metadata includ...
  • Data Modeling: Schema Generation Issue with ERwin Data Modeler 7.3
    We are using Computer Associate’s ERwin Data Modeler 7.3 for data modeling. In one of our engagements, we are pushing data model changes to ...
  • Informatica Powercenter Workflow Manager Repository Navigator docking float issue
    In case you’re also experiencing where your Repository Navigator is not dock or attached and it seems just floating within Workflow Manager ...
  • To_Char Function
    In Oracle/PLSQL, the  to_char function  converts a number or date to a string. Syntax The syntax for the  to_char function  is: to_char( val...
  • OBIEE 11g - State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46118] Out of disk space. (HY000)
    Error Details Error Codes: AAD5E5X3:OPR4ONWY:U9IM8TAC Odbc driver returned an error (SQLFetchScroll). State: HY000. Code: 10058. [NQODBC] [S...
  • OBIEE 11g - Query Limit
    Query limit and number of minutes a query can run per physical layer database connection, follow the below steps. > Login to Repository u...

Categories

  • BI Publisher
  • DAC
  • DataWarehouse
  • Hyperion
  • Informatica
  • OBIEE
  • ODI
  • Oracle Applications EBS 12.1.3
  • Oracle Database
  • PL/SQL
  • SQL
  • Unix/Linux

Blog Archive

  • ▼  2013 (500)
    • ►  November (8)
    • ►  October (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (15)
    • ►  April (24)
    • ►  March (43)
    • ►  February (73)
    • ▼  January (323)
      • Uninstalling Obiee 11g instance on a linux red hat
      • OBIEE 11g not showing new dashboard in the drop d...
      • OBIEE11g Installation
      • Starting OBIEE 11g Services on Linux
      • OBIEE11g Timestamp differencess
      • DAC11g Installation on Windows Server 2008R2.
      • BI Apps 7.9.6.4 Installation in widows server 2008R2
      • [OBIEE11g] - Eventually succeeded, but encountered...
      • [OBIEE11g] - Blue Screen Error While Login With Bi...
      • [OBIEE11g] - No Log Found Error
      • [OBIEE11g] - Stream Closed Error when Click on cor...
      • OBIA 7.9.6.4 RPD And Catalog Shared
      • [OBIEE11g] - Destination Path too Long error while...
      • [OBIEE11G] - Lookup table is a new feature in obie...
      • [OBIEE11g] - Create Veriable in OBIEE11g.
      • [OBIEE11g] - Configuring LDAP Server to provide OB...
      • [OBIEE11g] - Authentication Failure in OBIEE 11g
      • [OBIEE11g] - Bing Map Integration with OBIEE 11g
      • [OBIEE11g] - OBIEE Dashboard for Informatica Metad...
      • Informatica PowerCenter Upgrading from Version 8.6...
      • Data Modeling: Schema Generation Issue with ERwin ...
      • [OBIEE11g] - DAC Reporting in OBIEE11g
      • [OBIEE11g] - Publisher 11g – Performance Monitorin...
      • [OBIEE11g] - Auto Start OBIEE 11g using Windows Se...
      • [OBIEE11g] - Upgrade OBIEE 11.1.1.5 To Latest Vers...
      • OBIEE11g - User Right Click Interaction Control w...
      • [OBIEE11g] - Customizing Prompts ‘All Column Value...
      • [OBIEE11g] - Choosing the Right OBIEE Visualization
      • OBIEE11g - 11.1.1.6 New Features
      • [OBIEE11g] - Certification with Siebel Marketing f...
      • [OBIEE11g] - Creating a Stacked Bar Chart.
      • [BI EE11g] – Managing Host Name Changes
      • [DAC] - Multi Source Loads With OBIA
      • [Informatica] - ERROR CODES: [CNX_53021 ],[DOM_100...
      • [Informatica] - Informatica PowerCenter Repository...
      • [Informatica] - Processing UNICODE Characters in I...
      • [Linux] - Unix/Linix Commands
      • [DAC] - Full Load Vs Incremental Load
      • [Informatica] - Installation of Informatica 9.0.1 ...
      • [Informatica] - SF_34004- Service initialization ...
      • [Oracle Database] - Linux OS and Oracle database S...
      • [Oracle Database] - Installion Oracle database11g ...
      • [Informatica] - RR_4053 : Row error occurred while...
      • [OBIEE11g] - Change the placement of currency name
      • [OBIEE11g] - Exception Occuring During OBIEE 11.1....
      • What is Indexing in a Database
      • [OBIEE11g] - Setting up OBIEE11g Admin Tool for OD...
      • [OBIEE11g] - Getting Top-N Sales Reps Using the TO...
      • [OBIEE11g] - Getting Top-N Sales Reps Using Result...
      • [OBIEE11g] - Getting Top-N Sales Reps for Year and...
      • [OBIEE11g] - Analyzing Sales for “N Years Top-10 S...
      • [OBIEE11g] - Drill Down to Sub Reports Passing Mul...
      • [OBIEE11g[ - Configuring BI Scheduler for iBots on...
      • [OBIEE 11g] - How Application Roles, Groups and Us...
      • [OBIEE11g] - Setting up Access Permissions to Repo...
      • [OBIEE11g] - Fixing Weblogic and bi_server1 startu...
      • [OBIEE11g] - Deleting and Re-Creating Users in We...
      • [OBIEE 11g] - Backup and Restore of OBIEE Filesyst...
      • [OBIEE11g] - Creating Effective Bar Graphs
      • [OBIEE] - Useful SQL statements in Business Intell...
      • [OBIEE11g] - Creating Dashboard Traversing Throug...
      • [OBIEE11g] - Database Connection Failure while cr...
      • [DAC] - Admin password recovery
      • [Oracle 11g] - Oracle Database 11g installation on...
      • [OBIEE11g] - Variables in Oracle OBIEE 11g
      • [OBIEE11g] - Installing OBIEE 11g on Linux Fedora 17
      • [OBIEE11g] - Table view Date Column controlled by...
      • [OBIEE11g] - Adding Tooltips and conditional colo...
      • [OBIEE11g] - Show top-N Sales Persons in BI Publi...
      • [OBIEE11g] - Creating Scrolling Ticker Views
      • [OBIEE11g] - Authentication first with LDAP then ...
      • [OBIEE11g] - Relocation of OBIEE MetaData Reposit...
      • [OBIEE11g] - Hierarchical Roll-Up and Individual T...
      • [OBIEE11g] - Creation of Sales Reps Hierarchy wit...
      • [OBIEE11g] - Using external table to Filter BI Ans...
      • [OBIEE11g] - Configuring of RPD deployed on Linux...
      • [OBIEE11g] - Configuring an ODBC DSN for the Oracl...
      • [ODI] - Frequently Asked Questions (FAQ)
      • [OBIA] - Oracle BI Applications - Frequently Asked...
      • [OBIEE 11g] - Maps - Frequently Asked Questions (FAQ)
      • [OBIEE11g] - The 11g Features You Maybe Didn't Know!
      • [OBIEE11g] - New Features with OBIEE 11.1.1.6
      • [OBIEE11g] - Dashboard Prompt - "Prompt User"
      • [OBIEE11g] - [46153] The configuration file (O:\us...
      • [Informatica] - Multiple Chart of Accounts Configu...
      • [OBIEE11g] - Customizing Pivot Table Error
      • [OBIEE11g] - How to get Month Start Date and Month...
      • [OBIEE11g] - How to get Week Start Date and Week E...
      • [OBIEE11g] - How to rename My Dashboard
      • Table Organization in OBAW (Oracle Business Analyt...
      • [OBIEE11g] Uninstall OBIEE 11g
      • [OBIEE11g] - Command Line Merging in OBIEE 10g/11g
      • BI Publisher report is showing incorrect date(Show...
      • [OBIEE11g] - Connectivity issue from OBIEE (in Sol...
      • [OBIEE 11g] - Installation on Red Hat Linux
      • [OBIEE11g] - Different ToolTip for different rows ...
      • [OBIEE11g] - Integrating OBIEE 11g with EPM worksp...
      • [DAC] Fail to create indices during DAC execution ...
      • [DAC] Oracle DAC issue in 64 Bit Machine
      • [OBIEE11g] Connection Pool Select Button is Disabl...
Powered by Blogger.

About Me

Unknown
View my complete profile