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 .