rasti.hil@hilandco.com +41 79 367-9677

Creating new user for Oracle Business Intelligence Enterprise Edition 11g Release 1

1) Login into the Administration Console of Oracle BI EE
http://[host]:[port]/console
default port: 7001


2) Click on the "Security Realms" link


3) Click on the "myrealm" link to view all users, groups, and permissions for that security realm.


4) Click on the "Users and Groups" tab


5) Click on the "New" button.


6) After entering the new user's name, description, and password then click on "OK" button.


7) Now we have created new user, but it has no any privilege. So we have to assign it to a group.
At first click on created user:


8) Click on the "Groups" tab


9) If you want to give admin privilege to new user then choose the "Administrators" and "BIAdminsitrators"


10) Login into analytics:
http://[host]:[port]/analytics
default port: 9704

Installing Oracle Business Intelligence 11g

1. Creating Schemas for Oracle BI Publisher 11g using the Repository Creation Utility (RCU)
In this post you can see how to Create Schemas for BIP 11g using the Repository Creation Utility (RCU)

2. Starting Oracle Business Intelligence 11g Installer
Run the following commands in the Disk1 directory:
- Linux: ./runInstaller.sh
- Windows: setup.exe

a. Welcome screen
Click Next


b. Select Installation Type
Choose the Simple Install type and click Next.


c. Prerequisite Checks screen
If an error message appears, fix the error and then click Retry to run the prerequisite check again (recommended). Repeat this until all prerequisite checks conclude with no errors.
Click Next.


d. Specify Installation Location
Click Browse to navigate to the directory and click Next.


e. Administrator Details
Specify the user name and password for the system administrator.
Click Next.


f. Configure Components
By default, all components are configured. Leave all items checked and click Next.


g. Database Details
Specify the database type, the connect string, and the username and password for the Oracle Business Intelligence schemas you created in your database using RCU.
Click Next.


h. Security Updates
Specify your My Oracle Support email address and password (optional).
Click Next.


i. Summary
Click Install


j. Installation Progress
Click Next when the installation is complete.


k. Configuration Progress
Click Next when the configuration concludes without any errors or warnings.


l. Installation Completed Screen
Click Finish.


m. Login into BI Publisher 11g

Oracle Embedded PL/SQL Gateway & listener.ora & tnsnames.ora

I came across a problem that /apex/ DAD doesn't really want to work via EPG,
so i did:

listeners.ora:
SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
            (SID_NAME = ec211gr2)
            (GLOBAL_DBNAME = ec211gr2)
            (ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1)
        )
    )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 8080))
      (PRESENTATION=HTTP)
      (SESSION=RAW)
    )
  )
tnsnames.ora:
EC211GR2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 8080))(Presentation=HTTP)(Session=RAW)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ec211gr2)
    )
  )
some sql as sysdba
alter system set dispatchers=(PROTOCOL=TCP)(SERVICE=ec211gr2XDB) scope booth;
alter system set local_listener=EC211GR2 scope booth;
create pfile from spfile;
shutdown immediate
startup
some bash command as oracle
lsnrctl stop
lsnrctl start

Creating Schemas for Oracle Business Intelligence using the Repository Creation Utility (RCU)

1. Starting the Repository Creation Utility (RCU)
you have to download and extract the RCU .zip file. Run the following commands in the bin directory of RCU_HOME:
- on Linux: ./rcu
- on Windows: rcu.bat

2. Creating Schemas for Oracle Business Intelligence

a. Welcome Screen
Click next


b. Create Repository Screen
Select Create and click Next.


c. Database Connection Details Screen




d. Select Components Screen
Select Create a new Prefix. Click the Business Intelligence check box. This automatically selects the Metadata Services (MDS) and Business Intelligence Platform schemas, which are required by Oracle Business Intelligence.
Click Next.



e. Schema Passwords Screen
Select Use same password for all schemas.
In the Password field, enter a password for accessing the schemas. Enter the password again in the Confirm Password field
Click Next.


f. Map Tablespaces Screen
Click Next. The Creating Tablespaces screen opens. If there are errors, details about the error appear on the Map Tablespaces screen. Fix the errors and click Next again. After the tablespaces are created with no errors, click OK to dismiss the screen.




g. Summary Screen
Click Create. The Create screen opens. If there are errors, details about the errors appear on the Summary screen. Fix the errors and click Next again. After the schemas are created with no errors, click OK to dismiss the screen.



h. Completion Summary Screen
Click Close.