Oracle Application DBA

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 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 appreciated J

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 Liste

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 appreciated J

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 becau