Tuesday, September 6, 2016

Pluggable Database 12c EM Express configuration

Pluggable Database 12c PDB configuration: 

When you install 12c Database with container database (CDB), by default 12c EM Express PORT configure’ s for only CDB database. 

Creating New Port for PDB: 

Connect to Database: 
sqlplus / as sysdba
            -- default it connects to CDB

View all Ports for PDB's :
            --- to list all PDB instances
select c.name,c.open_mode,e.port 
            from v$pdbs c, xdb.xdb$cdbports e 
            where c.con_id = e.pdb (+);

Change Session to PDB:
            alter session set container = PDB_DB12CR2;
            --session changed PDB,  PDB_DB12CR2 -- PDB instance name

Verify EM Port on PDB: 
            select dbms_xdb_config.gethttpsport() from dual;

Set New Port to PDB: 
            --If above query returns NULL or required to change the PORT, verify PORT availability
            exec dbms_xdb_config.sethttpsport(5501);
            --- 5501 PORT will assign to current PDB

Verify Ports from CDB:
select c.name,c.open_mode,e.port 
            from v$pdbs c, xdb.xdb$cdbports e 
            where c.con_id = e.pdb (+);

Verify listners on new PORT:
snrctl status | grep -i 5501


PDB - Direct Connection TNS Entries: 

Add bellow tns entry into existing tnsnames.ora file, change PDB service name, CDB hostname and PORT number.
$ vi $ORACLE_HOME/network/admin/tnsnames.ora
#PDB Instance details
PDB_DB12CR2 =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = )))
(CONNECT_DATA = (SERVICE_NAME = ) ))

Esc : wq

# save your tns file

Now client SQL Developer/TOAD/SQL Plus can connect directly to PDB database.


PDB - Start Stop Services: 

Startup:
            --from Container Database
ALTER PLUGGABLE DATABASE PDB_DB12CR2 OPEN;
            OR
            ALTER SESSION SET CONTAINER = PDB_DB12CR2;
            STARTUP

Stop:
            --from Container Database
ALTER PLUGGABLE DATABASE PDB_DB12CR2 CLOSE IMMEDIATE;
OR
            ALTER SESSION SET CONTAINER = PDB_DB12CR2;
            SHUTDOWN IMMEDIATE;

Status:
            --from Container Database
            SELECT name, open_mode FROM v$pdbs;

All PDB’s Start & Stop:
            ALTER PLUGGABLE DATABASE ALL OPEN;
ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;

Startup & Stop Except:
            ALTER PLUGGABLE DATABASE ALL EXCEPT pdb_1 OPEN;
ALTER PLUGGABLE DATABASE ALL EXCEPT pdb_1 CLOSE IMMEDIATE;

Automatic PDB Startup:
            --Create trigger on CDB startup
            CREATE OR REPLACE TRIGGER OPEN_ALL_PDBS
            AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';
END OPEN_ALL_PDBS;


     




Tuesday, July 19, 2016

ODI 12c 12.2.1.0 Step by Step Install and Configuration Java EE Agent Oracle Linux 6

Install ODI 12c on OBIEE 12c server- Linux

ODI 12c 12.2.1.0 Installation and Configuration, Adding ODI server to existing Weblogic OBIEE 12c server in single domain. ODI 12c and OBIEE 12c servers are running on single Weblogic domain.
  •     Java Development Kit (JDK 8) - Required Install
  •     Oracle Database 12cR1 - Required Install
  •     Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0) - Required Install
  •     ODI 12c 12.2.1.0.0 - Software Install
  •     RCU - Required Install
  •     ODI 12c Configuration Java EE Agent -- Adding to existing server
  •     ODI 12c STOP and Start Services (With OBIEE Services )
Download software distributives:
         ODI 12.2.1.0.0 12c is published on OTN: download page

Java Development Kit (JDK 8):
         Follow bellow link to install Java 8 on Linux 6 64bit system
         http://sankaramaddi.blogspot.com/2016/07/install-java-8-in-linux-64bit_7.html

 Oracle Database 12cR1:
        Follow bellow link to install Oracle Database 12c on Linux 6 64bit system
        http://sankaramaddi.blogspot.com/2016/07/how-to-install-oracle-database-12cr1-on.html

 Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0.0):
        Follow bellow link to install Weblogic Server 12.2.1.0 (Section -4) on Linux 6 64bit system
        lhttp://sankaramaddi.blogspot.com/2016/07/install-obiee-12c-12210-oracle-linux-6.html

ODI 12.2.1.0 Software Install:
  • Install ODI 12.2.1.0.0 software, If ODI is installing on OBIEE/WebLogic server have to select the existing oracle_home location. In my case /oracle/middleware (where installed Weblogic/OBIEE 12.2.1.0). 
  • Installation Type is "Enterprise Edition" 
  • Verify the JAVA_HOME and version details, follow bellow instruction to install software
[obiee@obiee12c software]$ ls -ltr
drwxr-xr-x. 7 oracle dba       4096 Jun 10  2013 database
-rw-r--r--. 1 oracle dba 1534295400 Oct 12  2015 fmw_12.2.1.0.0_infrastructure.jar
-rw-r--r--. 1 obiee  dba 1969868068 Oct 14  2015 fmw_12.2.1.0.0_odi.jar
-rw-r--r--. 1 obiee  dba  204243433 Oct 14  2015 fmw_12.2.1.0.0_odi2.jar
-rwxrwxrwx. 1 obiee  dba 1424038128 Mar 23 17:22 bi_platform-12.2.1.0.0_linux64-2.zip
-rwxrwxrwx. 1 obiee  dba 2090759452 Mar 23 17:22 bi_platform-12.2.1.0.0_linux64.bin
[obiee@obiee12c software]$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/obiee/bin
[obiee@obiee12c software]$ export JAVA_HOME=/usr/java/jdk1.8.0_91
[obiee@obiee12c software]$ export PATH=$JAVA_HOME/bin:$PATH
[obiee@obiee12c software]$ echo $PATH
/usr/java/jdk1.8.0_91/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:
/usr/sbin:/sbin:/home/obiee/bin
[obiee@obiee12c software]$ java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)
[obiee@obiee12c software]$ /usr/java/jdk1.8.0_91/bin/java -d64 -Xms4g -Xmx4g -cp fmw_12.2.1.0.0_odi2.jar -jar fmw_12.2.1.0.0_odi.jar
   
Follow bellow screens for installation selections:
Welcome Screen: 

 Installation Location:
Use this screen to specify the location of your Oracle home directory. Make sure this should be a Middleware Weblogic server 12.2.1.0 oracle_home location, which was installed for OBIEE 12.2.1.0:

 To create the topology for Java EE or standalone colocated agents, select Enterprise Installation into an existing Oracle Home directory:








RCU Install:
  • To create the Master and Work Repository (ODI_REPO) database schemas using the Repository Creation Utility (RCU).Database schemas creation is required before configure any domain for Oracle Data Integrator agent.
  • Follow the bellow instructions:
        [obiee@obiee12c bin]$ export JAVA_HOME=/usr/java/jdk1.8.0_91
        [obiee@obiee12c bin]$ export PATH=$JAVA_HOME/bin:$PATH
        [obiee@obiee12c bin]$ echo $PATH
        [obiee@obiee12c bin]$ pwd
        /oracle/middleware/oracle_common/bin
        [obiee@obiee12c bin]$ java -version
        java version "1.8.0_91"
        Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
        Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)
        [obiee@obiee12c bin]$ ./rcu
Follow bellow screens for installation selections:




If you are running RCU from an Enterprise installation and OBIE 12.2.1.0 Repositories installed, you will see the following: 









ODI 12c Configuration (Java EE Agent) -- Adding to existing server:
 ODI configuration is very simple process, invoke config.sh for ODI configuration. Do not select create domain check box, follow the screen shots.

        [obiee@obiee12c bin]$ pwd
        /oracle/middleware/oracle_common/common/bin
        [obiee@obiee12c bin]$ ./config.sh
Follow bellow screens for Update configuration selections:
Select "Update an existing domain (Don not create new domain): 
 Select following templates, which are related to ODI:





 Select Only Managed Server to add ODI Server:

ODI Server Listen port is 15101, so all ODI server and console are using 15101 port number:









ODI 12c STOP and Start Services:
  • Scripts are all located in the $ORACLE_HOME/user_projects/domains/bi/bitools/bin directory. The scripts being
·         Start.sh for start services - Starts OBIEE and ODI servers, because ODI server added into existing domain with existing configuration.
·         Stop.sh for stop services - Stops the both servers.
·         Status.sh for Status of the services

   Start Services: 
         [obiee@obiee12c bin]$ pwd
        /oracle/middleware/user_projects/domains/bi/bitools/bin
        [obiee@obiee12c bin]$ ./start.sh



Admin Server with OBIEE and ODI:

 ODI Console:  http://192.168.40.129:15101/odiconsole/

ODI Studio Installed (Software only install) on Window 7 PC: 

Monday, July 11, 2016

OBIEE12c (12.2.1.0) Install Step by Step Configuration on Linux 6 64bit

OBIEE12c (12.2.1.0) Step by Step Install and Configuration on Oracle Linux 6 64bit:

Installation Process:
  •     Java Development Kit (JDK 8) - Install
  •     Oracle Database 12cR1 - Install
  •     Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0) - Install
  •     OBIEE 12c 12.2.1.0.0 - Install 
  •     RCU - Install
  •     OBIEE 12c Configuration
  •     OBIEE12c STOP and Start Services 
Download software distributives:
         OBIEE 12c is published on OTN: download page

Java Development Kit (JDK 8):
         Follow bellow link to install Java 8 on Linux 6 64bit system
         http://sankaramaddi.blogspot.com/2016/07/install-java-8-in-linux-64bit_7.html

 Oracle Database 12cR1:
        Follow bellow link to install Oracle Database 12c on Linux 6 64bit system
        http://sankaramaddi.blogspot.com/2016/07/how-to-install-oracle-database-12cr1-on.html

 Oracle Weblogic Server 12c (Fusion Middleware Infrastructure 12.2.1.0.0):
  • This part of the installation is very easy and fast. The only decision you need to make is to choose an installation directory on the third step. This directory will be used for OBIEE installation. After a full installation (including OBIEE), this directory size on my server is more than 10G.
  • Requried RPM's are innstalled with database installation
Installation Process:
Login to Linux Server with user name ( in my case “obiee” for OBIEE Applications and "oracle"  for Database 12c on same server) and go to software location.
[obiee@obiee12c oracle]$ cd software
[obiee@obiee12c software]$ ls
database  fmw_12.2.1.0.0_infrastructure.jar
[obiee@obiee12c software]$ java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)
[obiee@obiee12c software]$ java -jar fmw_12.2.1.0.0_infrastructure.jar

Follow bellow screens for installation selections, comparatively 12c installation is easy install.


 Select ORACLE_HOME folder, this is different than oracle database ORACLE_HOME, need to careful  if you are installing single node with single user in Linux,









OBIEE 12c Install:

Go to software location, invoke the software installation

[obiee@obiee12c software]$ ls -ltr
drwxr-xr-x. 7 oracle dba       4096 Jun 10  2013 database
-rw-r--r--. 1 oracle dba 1534295400 Oct 12  2015 fmw_12.2.1.0.0_infrastructure.jar
-rwxrwxrwx. 1 obiee  dba 1424038128 Mar 23 17:22 bi_platform-12.2.1.0.0_linux64-2.zip
-rwxrwxrwx. 1 obiee  dba 2090759452 Mar 23 17:22 bi_platform-12.2.1.0.0_linux64.bin
[obiee@obiee12c software]$ ./bi_platform-12.2.1.0.0_linux64.bin

Follow bellow screens for installation selections:


    Select ORACLE_HOME folder, this is different than oracle database ORACLE_HOME, need to careful if you are installing single node with single user in Linux, This one should be same as weblogic server ORACLE_HOME location









 RCU Install:
  • Create the BI repository schemas required by OBIEE.  To do this I will use the RCU – Repository Creation Utility.  In previous releases of OBIEE this was a separate download, but now it is included in the software install.
  • There are five required repository schemas created by the RCU.
·         BIPLATFORM Business Intelligence Platform
·         MDS Metadata Services
·         WLS Weblogic Services
·         STB Common Infrastructure Services
·         OPSS Oracle Platform Security Services
·         Rest of them are optional
  • All of the schemas require a specific prefix (e.g. DEV_), which also allows more than one set of schemas in the same database for use my multiple OBIEE installations.
  • Another difference with OBIEE 12c is that you do not have to create the repositories with the RCU. You can instead let the configuration utility perform this. However the RCU gives you far more control over the configuration of the repositories, allowing you to choose/manage the tablespaces for the schemas.
  • To start the RCU run the rcu from the /oracle_common/bin directory:
    [obiee@obiee12c software]$ cd /oracle/middleware/oracle_common/bin
    [obiee@obiee12c software]$ ./rcu

    Follow bellow screens for installation selections:
     











OBIEE 12c Configuration:


  • /bi/bin contains the one for standard single server installations

  • ORACLE_HOME/oracle_common/common/bin contains the one for enterprise deployments. This is far more comprensive than the single server installation and allows you to configure multiple instances on multiple servers.

  • The script for configuring an OBIEE is located in $ORACLE_HOME/bi/bin directory. In my case, ORACLE_HOME is a /oracle/middleware directory.

[obiee@obiee12c bin]$ pwd
/oracle/middleware/bi/bin
[obiee@obiee12c bin]$ ls -ltr
-rwxr-x---. 1 obiee dba    4379 Sep 25  2015 config.sh
-rw-r-----. 1 obiee dba    3016 Sep 25  2015 config.cmd
-rw-r-----. 1 obiee dba 5673816 Oct  3  2015 vcredist_x64.exe
[obiee@obiee12c bin]$ ./config.sh

  • In here you get to choose which BI components you wish to configure:

·         Business Intelligence Enterprise Edition – the main BI product
·         Business Intelligence Publisher – if you need “pixel perfect” professional formatted output
·         Essbase – if you want to use the BI accelerator to speed up reporting for users

Follow bellow screens for installation selections:












OBIEE 12c: Analytics


OBIEE 12c Admin: 

OBIEE12c STOP and Start Services:

  • This is much simpler than before as there are now single scripts to start, stop and view the status of OBIEE 12c.
  • Scripts are all located in the $ORACLE_HOME/user_projects/domains/bi/bitools/bin directory. The scripts being
·         Start.sh for start services
·         Stop.sh for stop services
·         Status.sh for Status of the services
  • OBIEE 12c all installed, configured and running. There are a lot of differences to earlier versions, not just in functionality and look & feel, but also in the background and how it is deployed within the newer version of Weblogic.