How to open a tcp port 1031 in redhat linux?

Open the iptables file and add the line and restart the iptable service .

vi /etc/sysconfig/iptables
add below entry
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1031 -j ACCEPT
:wq


To stop iptables
++++++++++
service iptables stop

To start iptables
++++++++++
service iptables start

To check status
++++++++++
service iptables status

Also we can do restart
++++++++++++++
service iptables restart

ORA-29339: tablespace block size 16384 does not match configured block sizes

When running a script in OTM got failed with below error .


Issue
++++++
BEGIN create_tablespace.create_all_ts('/u01/app/otmuser/oradata/OTM/', '200M','2G'); END;

*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes
ORA-06512: at "SYS.CREATE_TABLESPACE", line 133
ORA-06512: at "SYS.CREATE_TABLESPACE", line 530
ORA-06512: at "SYS.CREATE_TABLESPACE", line 219
ORA-06512: at "SYS.CREATE_TABLESPACE", line 158
ORA-06512: at line 1

Cause
+++++
If you attempt to create a tablespace with a non-standard blocksize, say 16K, you get an exception like this:In order to create the tablespace, you'll need first to allocate a specific buffer for these blocks and this can be done online:

Solution
++++++++
SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=16M SCOPE=BOTH;

System altered.

SQL>

run the script .

error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Issue
++++++

After the complete 12.1.1 installation , apache is not coming up and below is error message .

[appsdemo@appsdba scripts]$ adopmnctl.sh status

You are running adopmnctl.sh version 120.6

Checking status of OPMN managed processes...

Processes in Instance: TEST_appsdba.appsdba.user.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |    9697 | Alive
OC4JGroup:default_group          | OC4J:forms         |    9626 | Alive
OC4JGroup:default_group          | OC4J:oacore        |    9543 | Alive
HTTP_Server                      | HTTP_Server        |     N/A | Down


[appsdemo@appsdba scripts]$ adapcctl.sh start

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
================================================================================
opmn id=appsdba.user.com:6207
    0 of 1 processes started.

ias-instance id=TEST_appsdba.appsdba.user.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/

Error
--> Process (index=1,uid=886842578,pid=10277)
    failed to start a managed process after the maximum retry limit
    Log:
    /d01/apps/inst/apps/TEST_appsdba/logs/ora/10.1.3/opmn/HTTP_Server~1.log


adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /d01/apps/inst/apps/TEST_appsdba/logs/appl/admin/log/adapcctl.txt for more information ...


[appsdemo@appsdba scripts]$ cat /d01/apps/inst/apps/TEST_appsdba/logs/ora/10.1.3/opmn/HTTP_Server~1.log

--------
15/05/24 16:54:14 Start process
--------
/d01/apps/inst/apps/TEST_appsdba/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/apps/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

--------
15/05/24 16:54:16 Start process
--------
/d01/apps/inst/apps/TEST_appsdba/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/apps/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

--------
15/05/24 16:58:19 Start process
--------
/d01/apps/inst/apps/TEST_appsdba/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/apps/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

--------
15/05/24 16:58:21 Start process
--------
/d01/apps/inst/apps/TEST_appsdba/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/apps/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
[appsdemo@appsdba scripts]$


Cause:

http web server unable to start due to missing library.

Solution:

1) Shutdown all application services.
2) create link for library file as below


[root@appsdba ~]# ls -ltrh /usr/lib/libgdbm.so.2.0.0
-rwxr-xr-x 1 root root 24K Jun  5  2007 /usr/lib/libgdbm.so.2.0.0
[root@appsdba ~]# ls -ltrh /usr/lib/libdb.so.2
ls: /usr/lib/libdb.so.2: No such file or directory
[root@appsdba ~]# ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2
[root@appsdba ~]#




[appsdemo@appsdba scripts]$ adopmnctl.sh status

You are running adopmnctl.sh version 120.6

Checking status of OPMN managed processes...

Processes in Instance: TEST_appsdba.appsdba.user.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   11203 | Alive
OC4JGroup:default_group          | OC4J:forms         |   11132 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   11048 | Alive
HTTP_Server                      | HTTP_Server        |   10991 | Alive


adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /d01/apps/inst/apps/TEST_appsdba/logs/appl/admin/log/adopmnctl.txt for more information ...

[appsdemo@appsdba scripts]$

Unable to find an Output Post Processor service to post-process request xxxxxxxx

User has submitted a request (OLM Course Evaluation Report) and it got failed with below error .

Issue
++++
Unable to find an Output Post Processor service to post-process request xxxxxxxx

Solution
+++++++
Check OPP service is running and actual and target must be same .
1)Concurrent:GSM Enabled=yes

2)If your production environment is pcp and you cloned the instance from production to test instance and your request got failed with above error means you have OPP managers are running.
1)Either you can disable it.
2)Define the work shift for second OPP .

checking operating system version: must be redhat-2.1AS, redhat-3 or redhat-4

Issue
++++++

Cause
+++++
runInstaller unable to find the actual OS version in a file called oraparam.ini .

Solution
+++++
find the oraparam.ini file which comes with software or patch and add the entry of your OS version and invoke runInstaller and issue will get fix .


[apptest@erptest install]$ diff oraparam.ini oraparam.ini_backup
46c46
< Linux=redhat-2.1AS,redhat-3,redhat-4,redhat-5
---
> Linux=redhat-2.1AS,redhat-3,redhat-4
[apptest@erptest install]$

Opatch: This patch is not suitable for this operating system

Last Friday 29May2015 , I was doing TechStack and opatch failed with below errors .

Opatch logfile
++++++++

OPatch detects your platform as 46 while this patch 16275529 supports platforms:
   226 (Linux x86-64)

This patch is not suitable for this operating system.
Please contact support for the correct patch.

ERROR: OPatch failed during prerequisite check.

Cause
+++++
OPatch detects your platform as 46 while this patch 16275529 supports platforms:
   226 (Linux x86-64)

46 (Linux Intel)

226 (Linux x86-64)

Solution :

+++++++++

[apptest@erptest 16275529]$ export OPATCH_PLATFORM_ID=226
[apptest@erptest 16275529]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home           : /u01/CRP2/apps/tech_st/10.1.2
Oracle Home Inventory : /u01/CRP2/apps/tech_st/10.1.2/inventory
Central Inventory     : /u04/app/CRP2/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /u01/CRP2/apps/tech_st/10.1.2/oui
OUI shared library    : /u01/CRP2/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so
Java location         : /u01/CRP2/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /u01/CRP2/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/u01/CRP2/apps/tech_st/10.1.2/.patch_storage/16275529/Apply_16275529_05-29-2015_17-22-26.log"

Invoking fuser to check for active processes.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
Oracle Configuration Manager has been installed but not configured. OCM enables
Oracle to provide superior, proactive support for our customers. Oracle
strongly recommends customers configure OCM. To complete the configuration of
OCM, refer to the OCM Installation and Administration Guide
(http://www.oracle.com/technology/documentation/ocm.html).
Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/CRP2/apps/tech_st/10.1.2)
Is this system ready for updating?
Please respond Y|N >
Y
Applying patch 16275529...

Patching jar files...

Patching copy files...

Running make for target client_sharedlib.



Inventory is good and does not have any dangling patches.


Updating inventory...

Verifying patch...
Backing up comps.xml ...


OPatch succeeded.
[apptest@erptest 16275529]$ 

Installation OBIEE 11.1.1.7.0 on Linux

Install Oracle database11gr2                          
Run "rcu" to create schemas in the database for OBIEE
Install JDK Minimum requirement is 1.6 .
Install OBIEE 11.1.1.7.0 

 

Installing Oracle Database 11gr2

Download the oracle software form edelivery.oracle.com.
Once the download has been finished ,Please unzip the two files.
When you unzip the files you will get Database directory .
Go to Database directory and run the "runInstaller" which is shown below in the screen shot.

Make sure you meet all OS pre requisite's ,before you invoke the runInstaller.

 

If we have oracle support email id we could mention with this step or just deselect the option click 'Yes' with the warning screen and click 'Next' with the below step

 

Click on Yes .

If you select "Create and Configure Database" .
It will copy the oracle software , configure the database and configure the listener on free port or available port.

Select Server Class and Click on Next to proceed .

Type of installation
Click on Single instance and click on Next .

Select Advanced Installation .
 if you didn't select Advance installation ,By default it take OLTP database and other character
set that is WMS18 something .
If you select wrong character set ,you rcu will fail for obiee .

Just Click Next

Select Enterprise Edition and Click on Next .

Provide ORACLE_BASE and ORACLE SOFTWARE location .

Most of the people will make mistake in selecting the type of database .
If you are installing database for OBIEE ,make sure that you select it Dataware housing .

Provide services name and GDB NAME.
 It is best practice that you keep global database name and sid same .
after the installation i was facing some issue ,so i changed the global database name to
same as sid.

Set SGA .

 

Select the Character set .

Datafiles location ,if you want you can customize it ..

Provide password for sys and system user .

Click on finish .

Click on Next and proceed .

It is asking to you run below script with root user .

Click on Close button to finish with installation of oracle database 11gr2 !!! :)

Installation has been finished ..

Installing JDK 1745

I was having installed JDK on my other server ,just i did scp to my server .
In my next up coming post , i will show you step by step procedure to install OBIEE 11.1.1.7.0 on linux.

Please check this link ,how to install JDK on linux .



Thanks for visiting my blog .


Quote of the day !!!
------------------
People usually change for two reasons,either they have learnt a lot or they have been hurt a lot .

OBIEE RCU 11.1.17.0

 

Select "Create" button to create schema in the database .

  

Select type of the database,database port,service name,username ,password for sysdba .

Click on Next to proceed .

 Click on OBIEE check box and rest of the schema's get selected automatically .

Provide password for below schema that is MDS and PLATFORM .

Creating tablespaces for the above schemas .

Click on create button !!!

Above is the summary page .
Click on Close button .

 

OBIEE rcu installation has been finished ....

When I am installing OBIEE 11.1.1.7.0 on Linux getting error as ORACLE_HOME variable is set .

You have already set the ORACLE_HOME that is for oracle database 11g and OBIEE expecting 

OBIEE HOME location.

You could try below one .

unset ORACLE_HOME

 ./runInstaller

OBIEE 11.1.1.7.0 Step by Step Installation on Linux .

This post will guide us through the  step by step installation of OBIEE 11.1.1.7.0. Here I don't find any difference in RCU installation between in previous version with this version.


Step1:

Download the OBIEE 11g software version from oracle e-delivery site and extract all the four disk.

Go to Disk1 and run the "runInstaller" which will invoke the GUI .

Universal Installer  will start and will check for the initial set up and system requirement.

After the successful precheck the first step of our OBIEE 11.1.1.7.0 starts with the below window. Just Click 'Next'

 

If you have oracle Support username and password then update then use that in this step or just select first option 'Skip Software updates' and click 'Next'

 

Select the type of installation which you want to do it .

I am selecting "simple installation".

 This step will just check operating system certification and physical memory. Just click 'Next' after the check passed through.

 Provide the Middleware home directory path .

 Please choose the name of the database.

Connecting string in this format hostname:portno:sid 

Provide OBIDEV_PLATFORM SCHEMA password .

Please choose the name of the database.

Connecting string in this format hostname:portno:sid

Provide OBIDEV_MDS SCHEMA password .

If we have oracle support email id we could mention with this step or just deselect the option click 'Yes' with the warning screen and click 'Next' with the below step

 Just click on yes and proceed !!.

 

Just click on yes and it will proceed .

 

Click on install button .