Unable to start HTTP server, error while loading shared libraries: libdb.so.2

Applies to:

Oracle Enterprise Linux – Version: 5.8
Oracle EBS R12.1.3

Description:

After cloning EBS R12 successfully, when I am going to start the services, find that the HTTP_Server is down. I have tried to restart the HTTP service, but could not start. All services of Oracle EBS going to startup normal except HTTP server:

Solution:

Find the following error in HTTP server log file:

There is missing some libraries.
Shutdown all EBS services and create a link for missing library as below:
Find that the library libdb.so.2 not exists. So create the link as below:

Now start all services and retest the issue:

HTTP Server is started normal, Oracle EBS is up and running now.

Your comments, especially which will help us improve the functionality, will be greatly appreciated.

How to reset change SYS user password in Oracle Database

How to reset/change SYS user password in Oracle Database

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11g

Description:

            I want to reset/change SYS user password in Oracle Database 11gR2.

Solution:

            You can reset/change SYS password by following simple steps:

Open a terminal and type the command

Sqlplus /nolog

SQL> connect / as sysdba

Once connected to the Database you can reset/change the SYS user password:

SQL> alter user sys identified by <new_password>;

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

How to Change Default Port of Oracle Database Listener

How to Change Default Port of Oracle Database Listener       

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11gR2

           

Description:

I want to change the default port of Oracle Database Listener.

Solution:

            To change the default port of Oracle Database Listener do the following steps:

1.    Stop Oracle Database Listener

#   lsnrctl stop

2.    Open $ORACLE_HOME/network/admin/listener.ora file and change the port from default 1521 to 1530 or as you wish

3.    Open $ORACLE_HOME/network/admin/tnsnames.ora file and change the port from default 1521 to 1530 or as you wish to change

4.    Re-start the listener

# lsnrctl start

5.    Login to Database as sysdba

# sqlplus / as sysdba

SQL> alter system set local_listener=”(ADDRESS=(PROTOCOL=TCP) (HOST=localhost) (PORT=1530))”;

SQL> alter system register;

Exit;

6.    lsnrctl stop

7.    lsnrctl start

Oracle Database Listener Port has been changed from 1521 to 1530

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

ORA-39213 Metadata processing is not available

ORA-39213 Metadata processing is not available

           

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11gR2

           

Description:

Expdp utility going to failed with following error:

ORA-39213: Metadata processing is not available

After some research I found that it is caused by the XSL stylesheets not setup/load properly.

Solution:

To fix the problem do the following steps:

Connect AS SYSDBA and execute the following to reload the stylesheets:

SQL> execute dbms_metadata_util.load_stylesheets;

Re-test the expdp, now it is working fine.

           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

APPS Login Failed with error HTTP 404

APPS Login Failed with error HTTP 404

           

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle EBS R12.1

           

Description:

Oracle EBS Login page going to fail with error “The webpage cannot be found HTTP 404”. I have restart the services but the problem is same. All services started successfully.

Error Log shows the following: $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/log.xml which reports:
Internal error raised trying to instantiate web-application: html defined in web site OC4J 10g (10.1.3) Default Web Site.

Error compiling :$COMMON_TOP/webapps/oacore/html: Error instantiating compiler: Web service artifact generation failed:java.lang.InstantiationException: IO Error reading WEB-INF/wsdl/wsrp_service.wsdl in $COMMON_TOP/webapps/oacore/html: $ORA_CONFIG_HOME/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl (Permission denied)

Solution:

The problem occurs because the file wsrp_service.wsdl is owned by the ‘root’ user. To fix the problem change the ownership of above file from root to <APPLMGR_USER>

·         Login from root user to change the ownership

·         Chown <APPLMGR_USER>:oinstall $ORA_CONFIG_HOME/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl

·        Login to user <APPLMGR_USER> and start the Middle-Tier services

·        Test the login again it will successful

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ