Uninstalling Obiee 11g instance on a linux red hat

Here are the steps followed to uninstall 11g:

1. Take backup of nqsconfig.ini file at following path: (using pftp)

/MiddlewareHome/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/

2. Take back up of instanceconfig.xml file at following path:

/MiddlewareHome/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

3. Take back of RPD OracleBIAnalyticsApps_BI0002.rpd at following path:

/MiddlewareHome/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository

4. Take backup of web catalogue:

/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/EnterpriseBusinessAnalytics

5. Back the patch files for BP2

6. Run deinstaller (Xming should be running for this as this is GUI based):

>cd /MiddlewareHome/Oracle_BI1/oui/bin

>./runInstaller.sh -d

7. Uninstall weblogic and leftovers using brute force (fastest method known to man)

>cd /MiddlewareHome

>rm -rf wlserver_10.3/

8. Remove all directories under /MiddlewareHome

I reinstalled after performing above steps and it worked.

Read More

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 you create a new dashboard under 'Shared Dashboard', it displays a warning, that "This dashboard will not appear in the "Dashboards" menu"

2. To make the dashboard appear in the menu, after you create new dashboard under 'Shared Folders', click  New > Dashboard again, and select newly created dashboard in step one as the folder, then give a name. 

3. Now after you create it second time, it will show up in the list.

Hope that helps

Read More

OBIEE11g Installation

 Here are the steps I have followed:

Environment:

Server OS: Linux red hat -
Client OS: Win XP Proff
Database (for BI repository): Oracle 11g
BI Warehouse database may or may not be the same, it does not matter.

Requirements:

- Linux terminal (putty) and FTP access
- root or sudo root access in Linux
- sysdba access to database (just DBA access will not work)
- All install / patch files downloaded and copied to Linux server
- RCU (repository creation utility) must be downloaded and saved to Client machine.
- Either firewall software must be disabled on Linux box, or all ports required by BI server must be opened before installation



Steps for Installation:

1. Run the RCU on windows client machine (or linux if you have 32 bit server). This installs two schemas on database which store BI server metadata. OBIEE 11g merged tables for BI publisher, usage tracking and iBots all into this schemas, along with several new tables to support BI functionality. This step will fail if you dont have a database ID with sysdba level of access.

• Run rcu.bat file from command prompt
• Select ‘Create Repository’, click Next
• Enter the database connection details where schemas will be installed
• Ignore the warning about the AL32UTF8 character set (not sure who should not ignore)
• Select the components to be installed and specify a prefix, example 'DEV'. We installed two schemas - MDS and BIPLATFORM
• Click Next all the way till its completed

2. On Linux server, create a group 'orainstall', a user 'obi'  and a folder as 'MiddlewareHome'. Following commands will comein handy:

• groupadd oinstall
• /usr/sbin/user add obi -g oinstall
• mkdir -p /MiddlewareHome
• chown -R obi:oinstall /MiddlewareHome
• chmod -R 775 /MiddlewareHome

3. On your client machine, download and install a X-windows server like X Cygwin or Xming. Google this for free installable software. This will be useful to run installation from your desktop. If you have direct access to Linux box, and dont need to use putty, skip this step and go directly to step 8 below.

4.  Login to Linux using terminal and execute command

              xhost + <>
This step will let you view GUI on your windows machine from installer running on linux server (compared to text based terminal / putty window). I am not aware if Linux has something similar to remote desktop connection as in windows. So this should work till we have something like RDC.

5. Open Putty on your windows machine and specify the host name for linux server. Next, click on

         Connections > SSH > X11
    and check 'Enable X11 forwarding'. Also make sure 'MIT-Magic-Cookie-1' is selected in radio button below.

6. Login to linux server using Putty and execute following command

        export DISPLAY= <>
    Replace IP address with that of your windows client machine.

7. Make sure that your windows client is not accepting the connections. To do that, execute command like "xterm" or "firefox" in Putty, and it should open a window for application on your local client. That way, then you start the installation for 11g, the GUI window will open on your windows machine.

8. In putty window, change directory to the folder containing the installer (bishiphome/Disk1)

9. Execute command “./runInstaller”

10. Select the ‘create local inventory option’, when asked to create the oracle inventory.

11. Choose “Enterprise Install”

12. Enter password for weblogic user. Follow minimum password standard, alphanumeric, atleast 8 characters long. Then click Nexk.

13. Browse or enter Oracle Middleware Home Location (/MiddlewareHone). This should fill out rest of the options for this screen. Hit Next.

14. Select the components you want to install. Not many companies have Real-Time Decisions, so uncheck it if you dont have the license, to save some space. Hit Next

15. On this screen enter database details for BI Platform schema that was created in step 1 above followed by MDS schema in next step.

16. Choose Auto Port Configuration on the next screen

17. Specify email ID on the next screen

18. Hit "Install" to start the installation process.

19. In the middle of the installation it will ask the disks 2,3,4,5. select what ever installation will ask the disks.

Thats it. 

Read More

Starting OBIEE 11g Services on Linux

OBIEE 11g comes with fancy enterprise manager, and weblogic console, however if you have to restart the server for any reason, the services may not start back up on their own (unlike 10g). The checklist below will be helpful if 11g fails to start

1. Start the node manager:

/MiddlewareHome/wlserver_10.3/server/bin/nohup ./startNodeManager.sh &

2. Set WLS (weblogic server) environment:

cd /MiddlewareHome/user_projects/domains/bifoundation_domain/bin

Setting the environment:

./setOBIDomainEnv.sh
./setDomainEnv.sh

3. Start the WLS:

nohup ./startWebLogic.sh -Dweblogic.managment.username=weblogic -Dweblogic.management.password=webdev123 &

Weblogic logs are located at:

/MiddlewareHome/user_projects/domains/bifoundation_domain/servers/AdminServer/logs
The server log file
/MiddlewareHome/user_projects/domains/bifoundation_domain/servers/AdminServer/logs/AdminServer.log

change auto boot file:
/MiddlewareHome/user_projects/domains/bifoundation_domain/servers/AdminServer/security/boot.properties (this is the file as in nohup.out log)
/MiddlewareHome/user_projects/domains/bifoundation_domain/servers/bi_server1/security/boot.properties

4. Login to WLS console:

http://localhost:7001/em

and navigate to :

Farm>WebLogic Domains>bi_cluster.

Click control > Start

4b. Use following command to start BI application from command line :
cd /MiddlewareHome/instances/instance1/bin

./opmnctl status

./opmnctl startall

error log
/MiddlewareHome/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1/console~coreapplication_obips1~1.log

This can be also started from EM

By now, services should be up and running. If not, check log files for error messages and you will need to do troubleshooting.


LOG FILES:

-The server log file. All server side log events will be written to this file:
/MiddlewareHome/user_projects/domains/bifoundation_domain/servers/AdminServer/logs/AdminServer.log

-Presentation server log:
get /MiddlewareHome/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1/sawlog0.log


CONFIG FILES:
-Instance config:
/MiddlewareHome/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

-NQSConfig.ini file:
/MiddlewareHome/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/

Read More

OBIEE11g Timestamp differencess

First Day of the Previous Year

TIMESTAMPADD( SQL_TSI_YEAR , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD removes a year from the returned date for the First Day of the Previous Year.

First Day of the Current Year

TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE) 

This calculation returns the first day of the year by deducting one less than the total number of days in the year.

First Day of the Next Year

TIMESTAMPADD( SQL_TSI_YEAR , 1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD adds a year to the date returned which will give the first day of the next year.

First Day of the Previous Month

TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the Current Month. The second TIMESTAMPADD then subtracts one month from the first day of the Current Month arriving to the First Day of the previous month.

First Day of the Current Month

TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) 

This expression gets the current day of the month and subtracts one less than the current day to arrive at the first day of the month.

First Day of the Next Month

TIMESTAMPADD(SQL_TSI_MONTH, 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

 From right to left the first TIMESTAMPADD returns the first day of the Current Month. The second TIMESTAMPADD then adds one month from the first day of the Current Month arriving to the First Day of the next month.

Last Day of the Previous Month

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the Current Month. The second TIMESTAMPADD subtracts a month to arrive at the first day of the previous month.

Last Day of Current Month

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD finds the first day of the current Month. The second TIMESTAMPADD adds one month to the date to arrive at the first day of the next month. The final TIMESTAMPADD subtracts one day from the returned date to arrive at the last day of the Current Month.

Last Day of the Next Month

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 2, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD finds the first day of the current Month. The second TIMESTAMPADD adds two months to the date to arrive at the first day of month after next. The final TIMESTAMPADD subtracts one day from the returned date to arrive at the last day of the Next Month.

Last Day of Previous Year

TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1,  CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD subtracts one day to arrive at December 31st of the previous year.

Last Day of Current Year

TIMESTAMPADD(SQL_TSI_YEAR, 1, TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD deducts one day to arrive at December 31 of the previous year. The third TIMESTAMPADD adds a single year to the date to arrive at December 31 of the Current Year.

Last Day of the Next Year

TIMESTAMPADD(SQL_TSI_YEAR, 2, TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD deducts one day to arrive at December 31 of the previous year. The third TIMESTAMPADD adds 2 years to the date to arrive at December 31 of the Next Year.

First Day of Current Quarter
TIMESTAMPADD( SQL_TSI_DAY , DAY_OF_QUARTER( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) 
This was included to show the calculations discussed above can be used with other functions. This is the same expression as the one that returns the first day of the current month except this one uses the DAY_OF_QUARTER property to return the first day of the current quarter.

Last Day of Current Quarter

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_QUARTER , 1, TIMESTAMPADD( SQL_TSI_DAY , DAY_OF_QUARTER( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

Demonstrated using Quarters. From right to left the first TIMESTAMPADD returns the first day of the Current Quarter. The second TIMESTAMPADD returns the first day of the next quarter. The final TIMESTAMPADD subtracts a single day from the date to arrive at the last day of the Current Quarter.

Number of days between First Day of Year and Last Day of Current Month

TIMESTAMPDIFF(SQL_TSI_DAY, CAST('2010/01/01 00:00:00' AS DATE), TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)))) 

For simplicity I hard coded the January 1, 2010 date and CAST it to a date. I could have used the First Day of the Current Year calculation but didn't want to over clutter the example. The second part of the TIMESTAMPDIFF uses Last Day of the Current Month calculation to force the TIMESTAMPDIFF to calculate the number of days between the first day of the year and the last day of the current month.

Read More

DAC11g Installation on Windows Server 2008R2.

DAC11g Installation.

1) Download DAC11g from OTN.
2) Extract the zip file.
3) Open the DAC extracted folder
4) Select DAC setup .exe file Run As Administrator.

5) Click on Next,

6) Specify the Informatica  Location, Click on Next.

7) Here specify the domain.infa file, Click on Next,

8) Here enter the DAC Home location, Click on Next.

9) Here select the create icons for all user check box, Click on Next.

10) Click on Install.

11) Click on Yes to All,

11) Wait untill complete the progress.

12) Your installation is completed successfully, Click on Done.

13) Go to start program files and select dac folder, Click on DAC Client,

Login Page.

14) Now Create dac user in the database and give role to dac user, See the below screenshot .

15) User created in the database.

16) Start DAC client-> Select Configure-> Select new connection.

Enter the connection name : OBIA
Select connection type : oracle(Tin)
Eneter service name : orcl.
Enter host name : kishore
Enter port no : 1521.



17) Select Authentication File -> First time select Create authentication file -> Click on OK.

18) Give the connection name -> click on OK.

19) Give Table owner name : dacuser ->Password : dac password -> Click on Generate radom Encryption Key

It will generate key 24 char key see the screen shot above.

 20) Click on Test connection -> You will see the srccessfully established message->Close -> Click on ok.

21) Click on start client, Select connection from the drop down and enter the credentials first time.

User name : Administrator.
Password : Administrator.

22) Click on Yes, Enter the table owner name and password (table owner means dac repository  username and password) as below screen shot.

23) Specify user name password for regulor login. In My case i am using credential
user name :  Administrator
Password :  obia

24) Close the dac window and login again -> Click on dac client -> In Login page  enter credential
->Click on Login.



25) Click on Setup Tab, DAC System Properties Enter dac repository name and informatica Parameter location. Click on save.

26) Go to toos->DAC server management->repository Configuration

27) Select web mode -> Click on Save (In the new dac11g there is two types security is available 1) web 2) standalone. for web u have to specify url, See the below screen shot).

This option is for when you integrate with weblogic that time you have to specify RUL or else you have to take standalone mode.

28) select standalone mode.

29) Enter the dac server host name : kishore and port no : 3141. Click on Save.

30)  To start server if it is web mode ->Go to toos->DAC Server Management->
start DAC Server. 
Stop DAC Server.
Stop DAC Server.

31)

32) DAC server setup. -> Tools -> DAC Server Management -> DAC Server Setup.

Click on Yes.

33) Select connection type as Oracle (Thin).
Server nam : Orcl
Host name : kishore
Post no : 1521.
select Populate from preconfigured client connection

34) Click on Test Connection. It will give connection pass message -> Close ->Click on Save.

35) Import Applications ->Tools -> DAC Repository Management ->Import
(To import application before u have copy those files from OBIEE_HOME\Oracle_BI1\bifoundation\biapps\dwrep\dac_client\server ->open exprot folder and copy all applications and move to DAC_HOME\dac\export.)
select the applications based on your ERP version in my case it EBS12.1.3

36)  Click on OK.

37) Now create a new container to modify the parameters in dac. After import completed u have to create the new container as a existing container, Because if you want to modify any thig in the dac it will not allow you , You have to created new container. See the below screen shot for more details.





38) Container Id : 11
     Container Name : EBS_R12.1.3
     Select Existing Container.

Click on OK.

Container created successfully.

39) Email Configuration.
       User Name : kishore
      Password : xxxxxx
      Email Server : smtp:gmail.com
      Port No : 465
      Email id : kishore1188@gmail.com

Click on Send Test Email. Done.

40) Enter Informatica details to integrate informatic server and dac server.

Integration service 
Service Name : info_is
Domain Name : Domain_kishore
User name : Administrator
Password : Administrator
Repository Name : info_rep

Click on Test connection, Click on Save. 

41) Enter informatica repository details to integrate informatica server and dac server.

Service Name : INFO_REP
Type : Informatic
Host Name: kishore
Port No : 6005
User Name : Administrator
Password : Administrator
Repository Name : INFO_REP.

Click on Test Connectionn -> Click on Save.

42) Generate the warehousing tables in the database. Using dac client.
Tools -> ETL Management -> Configure Source system

Select  : Generate create statement for data warehousing Tables

Click on Next.

43) Select Execute check box.
Select Physical Data Source type Datawarehouse
Click on start.

44) Data warehouse tables are created in the database., You will get success message at the end.

45) To check the Repository Stamp -> Help -> Login details

Here you can see all information related to dac repository.

46) In the new version of DAC11g You have keep generated 24 chra lenght key safetly, If you for get password , If you want to create new connection that time u have user this key again. or else you cont login to dac . it will give error key is not matched in the repository.

Read More

BI Apps 7.9.6.4 Installation in widows server 2008R2

Step 1:  Download the software from OTN, And unzip the software file.

Step 2:  Open the unzipped folder

• change compatibility ->Right click on setup file and select properties, 
• change the combustibility to service pack 2.
• click OK. 
• Run as Administrator, don't as run as a user (Because some security issues will come while starting service's)

Step 3: Double click on setup file.

Step 4 : Click on Next

Bi HOME : C:\OBIEE_HOME\Oracle_BI1
Instance Location : C:\OBIEE_HOME\instance\instance1
Domain Location :  C:\OBIEE_HOME\user_projects\domains\bifoundation_domain

Step 5 : Click on Next.

Here you have to specify the weblogic port no and weblogic user name and password

Step 6 : Click on Next.

Select applications  what you want to deploy (Or) leave as default.

Step 7 : Click on Next.

Step 8 : Click Next.

Wait until complete 100% Process, And it will stop bi server and start bi server automatically while installing

Step 9 : Once it will complete Click on Next.

Step 10 : Click on Finish.


After installation, Open the dwrep folder in the OBIEE_HOME\Oracle_BI1\biapps\Repository folder.

1) Copy Enterprise rpd and move to Bi Repository location (E:\OBIEE_HOME\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository).

2) Extract the catalog 
EnterpriseBusinessAnalytics from this location (E:\OBIEE_HOME\Oracle_BI1\biapps\catalog)

After extration move to the below location.

E:\OBIEE_HOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

Step 11 : Open the Enterprise Manager (http://hostname:7001/em)

Once you login, Deploye rpd and catalog. Now you have OBIA 7.9.6.4.

Read More