Oracle Info Hub: May 2018

Sunday 27 May 2018

How to change database from Noarchivelog mode to Archivelog mode.

This document describes how to change database log mode from noarchivelog to archivelog.

Step 1: Check the database log mode.

We can check database log mode in below two ways.

SQL> select name,open_mode,log_mode from v$database;

NAME OPEN_MODE LOG_MODE
--------- -------------------- ------------
PRIMARY READ WRITE NOARCHIVELOG

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Current log sequence 10

Step 2: Change log mode from Noarchivelog to Archivelog mode.

Shutdown the database.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

Start the database in mount stage

SQL> startup mount

ORACLE instance started.

Total System Global Area 1560281088 bytes

Fixed Size 2924784 bytes

Variable Size 1006636816 bytes

Database Buffers 536870912 bytes

Redo Buffers 13848576 bytes

Database mounted.

Change database to archivelog mode.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

Check the log mode.

SQL> select name,open_mode,log_mode from v$database;

NAME OPEN_MODE LOG_MODE

--------- -------------------- ------------

PRIMARY READ WRITE ARCHIVELOG

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 8

Next log sequence to archive 10

Current log sequence 10

Saturday 26 May 2018

How to start/stop and check the status of listener.

This doc describes us how to start/stop and check the status of listener.

How to start listener:

Step 1: Find the listener name from listener configuration file. I.e., listener.ora which is under $ORACLE_HOME/network/admin

[oracle@silver ~]$ cd $ORACLE_HOME/network/admin
[oracle@silver admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

OBIEE =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = silver.apps.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

Step 2: Start listener

Syntax: [oracle@silver admin]$ lsnrctl start <Listener Name>

Below is the example.

[oracle@silver admin]$ lsnrctl start OBIEE

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 26-MAY-2018 21:27:51

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias OBIEE
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 26-MAY-2018 21:25:57
Uptime 0 days 0 hr. 1 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/silver/obiee/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=silver.apps.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=silver.apps.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/OBIEE/xdb_walSylet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "OBIEE.apps.com" has 1 instance(s).
Instance "OBIEE", status READY, has 1 handler(s) for this service...
Service "OBIEEXDB.apps.com" has 1 instance(s).
Instance "OBIEE", status READY, has 1 handler(s) for this service...
The command completed successfully

How to stop listener:

Syntax: [oracle@silver admin]$ lsnrctl stop <Listenet Name>

[oracle@silver admin]$ lsnrctl stop OBIEE

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 26-MAY-2018 21:33:47

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=silver.apps.com)(PORT=1521)))

The command completed successfully

How to check the status of listener:

Syntax: [oracle@silver admin]$ lsnrctl status <Listener Name>

[oracle@silver admin]$ lsnrctl status OBIEE

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 26-MAY-2018 21:37:11

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=silver.apps.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias OBIEE

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 26-MAY-2018 21:36:03

Uptime 0 days 0 hr. 1 min. 7 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/silver/obiee/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=silver.apps.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=silver.apps.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/OBIEE/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "OBIEE.apps.com" has 1 instance(s).

Instance "OBIEE", status READY, has 1 handler(s) for this service...

Service "OBIEEXDB.apps.com" has 1 instance(s).

Instance "OBIEE", status READY, has 1 handler(s) for this service...

The command completed successfully

How to check the background process for listener:

[oracle@silver admin]$ ps -ef | grep tns

root 15 2 0 20:28 ? 00:00:00 [netns]

oracle 4659 1 0 21:36 ? 00:00:00 /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr OBIEE -inherit

oracle 4888 3020 0 21:49 pts/0 00:00:00 grep tns

Thanks for you patience to view my post........

Sunday 20 May 2018

Step by Step Installation of OBIEE 12c in Oracle Enterprise Linux 6

Step by Step Installation of OBIEE 12c in Oracle Enterprise Linux 6

Below are the required steps we need to follow to install OBIEE in OEL6

1. Install JDK

2. Install required prerequisite packages

3. Install weblogic

4. Install OBIEE 12c software

5. Install required database tablespaces using RCU.

6. Configure OBIEE with Middleware

Step 1: Install JDK

Download JDK software from below url

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Copy the software to server and install JDK

[root@silver software]# ls -ltr jdk-8u171-linux-x64.rpm
-rwxr-x---. 1 root root 175262413 May 19 20:09 jdk-8u171-linux-x64.rpm
[root@silver software]# rpm -Uvh jdk-8u171-linux-x64.rpm
Preparing... ########################################### [100%]
1:jdk1.8 ########################################### [100%]
Unpacking JAR files...
tools.jar...
plugin.jar...
javaws.jar...
deploy.jar...
rt.jar...
jsse.jar...
charsets.jar...
localedata.jar...

[root@silver software]# java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
[root@silver software]#

Step 2: Install prerequisite packages

Below packages can be installed using yum repository or RPM download.

compat-libcap1-1.10-1.x86_64
compat-libstdc++-33-3.2.3-69.el6.x86_64
libgcc-4.4.7-18.0.7.el6_9.2.x86_64
libstdc++-4.4.7-18.0.7.el6_9.2.x86_64
libstdc++-devel-4.4.7-18.0.7.el6_9.2.x86_64
sysstat-9.0.4-33.el6_9.1.x86_64
gcc-c++-4.4.7-18.0.7.el6_9.2.x86_64
glibc-2.12-1.209.0.3.el6_9.2.x86_64
glibc-devel-2.12-1.209.0.3.el6_9.2.x86_64

libaio-0.3.107-10.el6.x86_64

Step 3: Install Weblogic

Download Weblogic software (Fusion Middleware Infrastructure Installer) from below url.

http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html

Install Weblogic:

[oracle@silver OBIEE]$ java -jar fmw_12.2.1.0.0_infrastructure.jar

Launcher log file is /tmp/OraInstall2018-05-19_09-13-36PM/launcher2018-05-19_09-13-36PM.log.

Extracting files........................................

Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz. Actual 2903.996 MHz Passed

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Checking swap space: must be greater than 512 MB. Actual 6999 MB Passed

Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)

Checking temp space: must be greater than 300 MB. Actual 3967 MB Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2018-05-19_09-13-36PM

Log: /tmp/OraInstall2018-05-19_09-13-36PM/install2018-05-19_09-13-36PM.log

Click "Next"

Select "Skip Auto Updates" and click "Next"

Select Middleware home location and click "Next"

Select "Fusion Middleware Infrastructure with Examples" and click "Next"

Click "Next"

Deselect security updates option and click "Next"

Click on "Yes"

Click on "Install"

Click on "Next"

Click "Finish".

Step 4: Install OBIEE 12c Software

[oracle@silver OBIEE]$ ./bi_platform-12.2.1.0.0_linux64.bin

0%...................................................................................................100%

Launcher log file is /tmp/OraInstall2018-05-19_09-51-18PM/launcher2018-05-19_09-51-18PM.log.

Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz. Actual 2903.996 MHz Passed

Checking swap space: must be greater than 512 MB. Actual 6999 MB Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2018-05-19_09-51-18PM

Log: /tmp/OraInstall2018-05-19_09-51-18PM/install2018-05-19_09-51-18PM.log

Click "Next"

Select "Skip Auto Updates" and click "Next"

Select BI home location and click on "Next"

Select "BI Platform Distribution with Samples" and click "Next"

Click "Next"

Click on "Install"

Click "Next"

Click "Finish"

Step 5: Install required database tablespaces using RCU

We can run RCU tool from either windows or linux.

Running RCU.......

[oracle@silver bin]$ pwd

/u01/software/OBIEE/RCU/rcuHome/bin

[oracle@silver bin]$ ./rcu

Click "Next"

Select "Create" and click "Next"

Provide server name where database running , port number, service_name of database and click on "Next"

Click "OK"

Select "Business Intelligence" related components and click "Next"

Click "OK"

Provide password for schemas. Make a note of this passwod.

Click "Next"

Click on "OK"

Click on "Create"

Click on "Close"

Step 6: Configure OBIEE with Middleware

Configure OBIEE by running config.sh which is under ORACLE_HOME/bi/bin

[oracle@silver bin]$ pwd

/u01/app/Middleware/Oracle_Home/bi/bin

[oracle@silver bin]$ ls

config.cmd config.sh vcredist_x64.exe

[oracle@silver bin]$ ./config.sh

Starting Fusion Middleware Configuration Wizard for BIEE

ORACLE_HOME set as /u01/app/Middleware/Oracle_Home

BI_PRODUCT_HOME set as /u01/app/Middleware/Oracle_Home/bi

PATH set as /u01/app/Middleware/Oracle_Home/bi/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin

LD_LIBRARY_PATH set as /u01/app/Middleware/Oracle_Home/bi/lib

INSTALL_PROPERTIES /u01/app/Middleware/Oracle_Home/bi/../oui/mw/bi/metadata/config.properties

INSTALL_INVOCATION /u01/app/Middleware/Oracle_Home/bi/bin/../../oui/bin/launch.sh -clone ORACLE_HOME=/u01/app/Middleware/Oracle_Home -invPtrLoc /u01/app/Middleware/Oracle_Home/oraInst.loc -J-Doracle.as.install.engine.weblogic.config.mode=true -J-Doracle.config.mode=true -J-Doracle.as.install.engine.install.properties.location=/u01/app/Middleware/Oracle_Home/bi/../oui/mw/bi/metadata/config.properties -J-DSHIPHOME_STAGE_DIR=/u01/app/Middleware/Oracle_Home/bi/../oui/mw/bi

Launcher log file is /tmp/OraInstall2018-05-19_11-28-16PM/launcher2018-05-19_11-28-16PM.log.

Starting Oracle Universal Installer

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Checking swap space: must be greater than 500 MB. Actual 6999 MB Passed

Checking if this platform requires a 64-bit JVM. Actual 64 Passed

Log: /u01/app/oraInventory/logs/install2018-05-19_11-28-16PM.log