OAS (Oracle Analytics Server) Installation ,Administrations

Step1: Download Oracle analytics software comes with bundle of oracle fusion middle ware.  https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html  As you can see below the list of binary needed. Oracle analytics server Oracle Fusion midleware. Oracle Java Developement Kit(JDK) .

 

Step 2: Here is the list of sofrwares downloaded .   -r-xr-xr-x. 1 oracle oinstall 1636007590 Sep 13  2019 fmw_12.2.1.4.0_infrastructure.jar -rw-r--r--. 1 oracle oinstall      10185 Sep 16  2019 fmw_12214_readme.html drwxr-xr-x. 4 oracle oinstall         48 Dec 18 12:36 30657796 -rwxrwxrwx. 1 oracle oinstall 3783191909 Jan 28 23:22 Oracle_Analytics_Server_5.5.0.jar -rw-r--r--. 1 oracle oinstall      64852 Jun 13 07:08 V988922-01oas.zip -rw-r--r--. 1 oracle oinstall 1635717400 Jun 13 07:11 V983368-01oas.zip -rw-r--r--. 1 oracle oinstall 3783463137 Jun 13 07:14 V988574-01oas.zip

 

 

 

 

Step 3: Install Oracle JAVA and set JAVA_HOME as oracle user.   https://deepakoracledba.blogspot.com/p/oracle-java-jdkinstallation.html

 

Step 4: Install Oracle Fusion Middleware server .  https://deepakoracledba.blogspot.com/p/oracle-fusion-middle-ware-installation.html

Step 5: Post Oracle Fusion Middleware server . procceding on Oracle analytics server installtion.   -r-xr-xr-x. 1 oracle oinstall 1636007590 Sep 13  2019 fmw_12.2.1.4.0_infrastructure.jar -rw-r--r--. 1 oracle oinstall      10185 Sep 16  2019 fmw_12214_readme.html drwxr-xr-x. 4 oracle oinstall         48 Dec 18 12:36 30657796 -rwxrwxrwx. 1 oracle oinstall 3783191909 Jan 28 23:22 Oracle_Analytics_Server_5.5.0.jar -rw-r--r--. 1 oracle oinstall      64852 Jun 13 07:08 V988922-01oas.zip -rw-r--r--. 1 oracle oinstall 1635717400 Jun 13 07:11 V983368-01oas.zip -rw-r--r--. 1 oracle oinstall 3783463137 Jun 13 07:14 V988574-01oas.zip   [oracle@xcell Downloads]$ java -jar Oracle_Analytics_Server_5.5.0.jar Launcher log file is /tmp/OraInstall2020-06-13_07-38-17AM/launcher2020-06-13_07-38-17AM.log. Extracting the installer . . . . . . . . . . . . . . . . Done Checking if CPU speed is above 300 MHz.   Actual 1995.312 MHz    Passed Checking swap space: must be greater than 512 MB.   Actual 8191 MB    Passed Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-06-13_07-38-17AM Log: /tmp/OraInstall2020-06-13_07-38-17AM/install2020-06-13_07-38-17AM.log

Step 6: Post analytics server install go to repository creation:   Go to Oracle fusion middle ware directory , under that to Oracle_common folder . And invoke RCU utility   [oracle@xcell fusion_middleware]$ cd oracle_common/ [oracle@xcell oracle_common]$ cd bin [oracle@xcell bin]$ ll total 84 -rwxr-x---. 1 oracle oinstall 4297 Dec 22  2018 chghost.sh -rwxr-x---. 1 oracle oinstall 5633 Aug 12  2019 copyBinary.sh -rwxr-x---. 1 oracle oinstall 2028 Sep  9  2019 libovdadapterconfig.bat -rwxr-x---. 1 oracle oinstall 2046 Sep  9  2019 libovdadapterconfig.sh -rwxr-x---. 1 oracle oinstall 2028 Sep  9  2019 libovdconfig.bat -rwxr-x---. 1 oracle oinstall 2046 Sep  9  2019 libovdconfig.sh -rwxr-x---. 1 oracle oinstall 3634 Sep  9  2019 mkstore -rwxr-x---. 1 oracle oinstall 1882 Sep  9  2019 mkstore.bat -rwxr-x---. 1 oracle oinstall 1016 Mar  9  2019 ocp.sh -rwxr-x---. 1 oracle oinstall 4621 Sep  9  2019 orapki -rwxr-x---. 1 oracle oinstall 2431 Sep  9  2019 orapki.bat -rwxr-x---. 1 oracle oinstall 6801 Aug 12  2019 pasteBinary.sh -rwxr-x---. 1 oracle oinstall  827 Jun 13 07:36 rcu -rwxr-x---. 1 oracle oinstall 7212 Oct 23  2018 rcu_internal.sh -rwxr-x---. 1 oracle oinstall 3199 Oct 23  2018 rcuJDBCEngine -rwxr-x---. 1 oracle oinstall 1334 Aug  1  2019 wallet-manager.sh [oracle@xcell bin]$ ./rcu          RCU Logfile: /tmp/RCU2020-06-13_07-59_2146396857/logs/rcu.log

Step 7: OAS configuation with middleware Go to middleware home –bi/bin location : /u01/app/fusion_middleware/bi/bin rwxr-x---.  5 oracle oinstall   56 Jun 13 07:51 xsd [oracle@xcell bi]$ cd bin [oracle@xcell bin]$ ll total 8 -rw-r-----. 1 oracle oinstall 2098 Dec 16 13:26 config.cmd -rwxr-x---. 1 oracle oinstall 3091 Dec 16 13:26 config.sh [oracle@xcell bin]$ ./config.sh Starting Fusion Middleware Configuration Wizard for BIEE ORACLE_HOME set as /u01/app/fusion_middleware BI_PRODUCT_HOME set as /u01/app/fusion_middleware/bi PATH set as /u01/app/fusion_middleware/bi/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/home/oracle/.local/bin:/home/oracle/bin:/usr/lib/jdk1.8.0_251/bin LD_LIBRARY_PATH set as /u01/app/fusion_middleware/bi/lib -oracle.as.install.engine.install.properties.location /u01/app/fusion_middleware/bi/../oui/mw/bi/metadata/config.properties -distName oa_platform -distVersion 5.5.0.0.0 ../../../../modules/installer-launch.jar:../jlib/ConfigLauncher.jar Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512m; support was removed in 8.0 Current working directory :/u01/app/fusion_middleware/oui/mw/common/framework/bin Log: /u01/app/fusion_middleware/install2020-06-13_08-14-56AM.log Setting Doracle.installer.prereqConfigLoc... Setting Doracle.installer.oui_loc... Setting Doracle.installer.startup_location... Setting Doracle.as.install.engine.install.properties.location... Setting Doracle.as.install.engine.weblogic.config.mode... Setting Doracle.installer.launch_loc... Setting Doracle.installer.extjre... Setting DisNextGen... Setting Doracle.installer.library_loc... Setting Doracle.installer.paramFile... Setting Doracle.installer.scratchPath... Setting Doracle.config.mode... Setting Doracle.as.install.engine.cleanup... Setting Doracle.installer.jre_loc... Setting ORACLE_HOME...

Register standby database using SRVCTL Utility

Error: [oracle@Test2 home]$ srvctl stop database -d colldb

PRCD-1120 : The resource for database colldb could not be found.

PRCR-1001 : Resource ora.colldb.db does not exist

[oracle@Test2 home]$ srvctl config database -d colldb

PRCD-1120 : The resource for database colldb could not be found.

PRCR-1001 : Resource ora.colldb.db does not exist

Solution

[oracle@Test2 home]$ srvctl add database -d colldb -o $ORACLE_HOME -p  $ORACLE_HOME/dbs/spfile$ORACLE_SID

[oracle@Test2 home]$ srvctl config database -d colldb

Database unique name: colldb

Database name:

Oracle home: /u/oracle/server/database203

Oracle user: oracle

Spfile: /u/oracle/server/database203/dbs/spfilecolldb

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Database instance: colldb

Disk Groups:

Services:

Oracle Local Listener Vs Remote Listener

 

        The local_listener init.ora parameter specifies a network name that resolves to an address or address list of Oracle Net local listeners and it is used used ONLY when you have multiple listeners that are running on the same machine as this instance.

       The LOCAL_LISTENER parameter is a component of the cross instance registration technology for Oracle RAC (Real Application Clusters).Cross instance registration needs the local listener to help manage connections across all database instances for load balancing and fail over. The local listener is particularly meaningful for the RAC configuration featured by multiple listeners on cluster nodes.
If your Oracle configuration is not RAC enabled, you may as well remove the LOCAL_LISTENER parameter from your spfile in case for default port 1521 .

SQL> show parameter local_listener

NAME TYPE  VALUE
------------   -----------
local_listener  string

SQL> alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.2.210)(PORT=1521))';
System altered.

SQL> alter system register;
System altered.


To dynamically update the LOCAL_LISTENER parameter, use the SQL statement ALTER SYSTEM SET:

ALTER SYSTEM SET LOCAL_LISTENER='LISTENER_PRIM' scope=both sid='*' ;

If you set the parameter to null with the statement that follows, then the default local address of TCP/IP, port 1521 is assumed.

ALTER SYSTEM SET LOCAL_LISTENER=''

example  : in local host tnsnames.ora file


LISTENER_PRIM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.129)(PORT = 1521)))


    Suppose we have 2-node cluster: host1 and host2, with VIP address host1-vip and host2-vip respectively.One RAC database (orcl) running on this cluster; instace 1 (orcl1) on host1, and instance 2 (orcl2) on host2. we have listener_host1 running on host1, and listener_host2 running on host2.
listener_host1 is considered local listener for orcl1 instance, while listener_host2 is considered remote listener for that same orcl1 instance.similarly, listener_host2 is considered local listener for orcl2 instance, and considered as remote listener for orcl1.

Errors Reported while Creating New Standby using RMAN

 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/27/2013 17:00:50
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name +DATA/colldb/datafile/users.259.832173861 conflicts with a file used by the target database
RMAN-05001: auxiliary file name +DATA/colldb/datafile/undotbs1.258.832173861 conflicts with a file used by the target database
RMAN-05001: auxiliary file name +DATA/colldb/datafile/sysaux.257.832173861 conflicts with a file used by the target database
RMAN-05001: auxiliary file name +DATA/colldb/datafile/system.256.832173859 conflicts with a file used by the target database


Resulution: Use NOFILECHECK IN RMAN SCRIPT;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/26/2013 22:11:28
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy1 channel at 11/26/2013 22:11:28
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server


Resolution: Check both password file

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/26/2013 22:18:24
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925


Resolution : Check audit file location; if not avialble create as like primary /u/oracle/server

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/26/2013 22:20:59
RMAN-05501: aborting duplication of target database
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause


Resolution : stop db remove spfile from stand by start using pfile.

Oracle Pre-Installation Requisites

 ::::: Oracle Preinstallation requirements :::::::

1. create directory for oracle user home location.

( mkdir -p /u/oracle/home)

2. create group oinstall 
  groupadd -g 501 oinstall
groupadd -g 502 dba

3. create user 
 
useradd -u 503 -g oinstall -G dba -d /u/oracle/home -m oracle

4. change ownership for oracle home location 

chown -R oracle:oinstall /u/oracle/home

change permission for oracle home location

chmod -R 775 /u/oracle/home

5. create direcrory for oracle binary location 

mkdir -p /u/oracle/server

6. change ownership for oracle home location 

chown -R oracle:oinstall /u/oracle/server
   change permission for oracle home locatio 
chmod -R 775 /u/oracle/server

7. install required packages for oracle 

binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
glibc-headers-2.5-12
gcc-4.1.1-52
gcc-c++-4.1.1-52
libaio-0.3.106
libaio-devel-0.3.106 
libgcc-4.1.1-52
libstdc++-4.1.1 
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
numactl-devel-0.9.8.i386
sysstat-7.0.0

unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (32 bit) or later

8. change kernel parameter

vi /etc/sysctl.conf

fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

run (/sbin/sysctl.conf -p) to refect in current session


9. change ulimit for oracle

Add the following lines in the /etc/security/limits.conf file:

oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536


10. copy oracle or grid infrastucture  binary to guest system. change ownership and permission to oracle

*** run on root user  #Xhost +

11. Use grid infrastructure or oracle for standlone server or cluster servers

*** run on oracle user $./runInstaller

    Use password for asm (if Grid installation ) for Sys pass (if Oracle installation) 

oracle base : /u/oracle/server
     oracle home : /u/oracle/gri203 or database203
     oracle inventory : /u/oracle/server/oraInventory

12. complete installation 

13. Run post installation scripts on root and oracle user as per the instruction will find while installation.

Data guard Broker Configuration

: Data Guard Broker :

       The Oracle Data Guard broker  is a distributed  management  framework that automates and centralizes the creation, maintenance, and   monitoring  of  Data Guard configurations. The  following  describes  some of the operations the broker automates and simplifies 

I.) Adding  additional  new  or  existing (physical, snapshot, logical, RAC or non-RAC)  standby databases to  an existing Data Guard configuration, for a total of one primary database, and from 1 to 30 standby databases(in Oracle 11g) in the same configuration.

II.) Managing  an entire Data Guard configuration, including  all databases, redo transport services, and log apply services, through a client connection to any database in the configuration.

III.) Managing the protection mode for the broker configuration.

IV.) Invoking switchover or failover with a single command to initiate and control complex role changes across all databases in the configuration.

V.) Configuring failover to occur automatically upon loss of the primary database, increasing availability without manual intervention.

VI.) Monitoring the status of the entire configuration, capturing diagnostic information, reporting statistics such as the redo apply rate and the redo generation rate, and detecting problems quickly with centralized monitoring, testing, and performance tools.

Step by Step How to Create Dataguard Broker Configuration

1. Set the parameter dg_broker_config_file1 and dg_broker_config_file2 on all instances of primary and standby.

Default location of broker configuration file is $ORACLE_HOME/dbs or $ORACLE_HOME/database.

In case if you want broker configuration files in non default location, set these parameters.

In case of RAC database, set broker configuration file location to shared location and same value on all the instances.

ALTER SYSTEM SET dg_broker_config_file1 = '\U01\oradata\dr1mfg.dat' scope=both sid='*';

ALTER SYSTEM SET dg_broker_config_file2 = '\U01\oradata\dr2mfg.dat' scope=both sid='*';

OR in case of ASM file system use:

ALTER SYSTEM SET dg_broker_config_file1 = '+DATA/mfg/dr1mfg.dat' scope=both sid='*';

ALTER SYSTEM SET dg_broker_config_file2 = '+DATA/mfg/dr2mfg.dat' scope=both sid='*';

If you want the broker configuration files in default location, then you can ignore this step- 1

2. Enable broker on both primary and standby:

SQL>ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid='*';

3. Connect to DGMGRL on primary: (from instance one in case of RAC)

$dgmgrl

DGMGRL for Linux: Version 10.2.0.3.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> CONNECT sys/<password>;

Connected.

4. Create configuration on primary:

DGMGRL> CREATE CONFIGURATION 'COLDB_CONF' AS PRIMARY DATABASE IS 'colldb_pm' CONNECT IDENTIFIER IS colldb_pm;

Configuration "COLDB_CONF" created with primary database "COLLDB_PM"

5. Add standby in the configuration:

DGMGRL> ADD DATABASE 'colldb_st' AS CONNECT IDENTIFIER IS colldb_st MAINTAINED AS PHYSICAL;

Database "COLLDB_ST" added

6. Enable Configuration:

DGMGRL> ENABLE CONFIGURATION;

Enabled.

Use the SHOW command to verify that the configuration and databases were successfully enabled and brought online:

DGMGRL> SHOW CONFIGURATION;

Configuration

Name: PRODCONF

Enabled: YES

Protection Mode: MaxPerformance

Fast-Start Failover: DISABLED

Databases:

PROD10G - Primary database

STDBY10G - Physical standby database

Current status for "PRODCONF"

SUCCESS

IF ANYONE WANT TO RECONFIGURE AGAIN THE USE BELOW STEPS.

1. DGMGRL> CONNECT SYS/MANAGER

2. DGMGRL> DISABLE CONFIGURATION;

Disabled.

3. DGMGRL> remove CONFIGURATION;

Removed configuration

4. Continue Step 3