Oracle Application DBA

How to Configure Tiger VNC Server on Linux 7 Applies to:             Oracle Enterprise Linux – Version: 7 Description:             After successful installation of Oracle Linux 7, I need to configure VNC for remote access. Solution:             To configure Tiger VNC server on Oracle Linux 7 follow the simple steps:             To check the required rpm’s: [root@testora ~]# rpm –qa |grep tigervnc Install tigervnc-server [root@testora ~]# yum install tigervnc-server –y               To create a user for VNC: [root@testora ~]# adduser vncuser [root@testora ~]# passwd vncuser   [root@testora ~]# su - vncuser [vncuser@testora ~]$ vncpasswd Password: Verify: [vncuser@testora ~]$ exit [root@testora ~]# Copy the following file: [root@testora ~]# cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@\:1.service Edit the copied file. [root@testora ~]# vi /etc/systemd/system/vncserver@\:1.service At the end of the file,

How to Recreate Oracle Enterprise Manager - Database Control Repository Applies to:             Enterprise Linux – Version: 5             Oracle Database 11gR1             Oracle EBS R12.1 Description:             After Cloning of EBS, Oracle Enterprise Manager is not started. Solution:             To recreate the Database Control Repository do the following simple steps:                         Make sure that the Database environment is properly set.             To check ORACLE_HOME and ORACLE_SID values properly set:                          [oraprod@ebsdev ~]$  echo $ORACLE_HOME              /d01/oracle/TEST/db/tech_st/11.1.0              [oraprod@ebsdev ~]$  echo $ORACLE_SID             TEST              [oraprod@ebsdev ~]$  sqlplus / as sysdba SQL> drop user sysman cascade; SQL> drop role mgmt_user; SQL> drop user mgmt_view cascade; SQL> drop public synonym mgmt_target_blackouts; SQL> drop public synonym setemv

Error Message PRVF-7532 Missing Packages elfutils-libelf-devel and pdksh Applies to:             Oracle Enterprise Linux – Version: 7 64-bit             Oracle Database 11gR2 11.2.0.4 Description:             I am going to install Oracle Database 11gR2 on OEL-7 64-bit but Oracle Universal Installer going to fail with following error messages in installAction.log file: Error Message: PRVF-7532: Package “elfutils-libelf-devel” is missing Error Message: PRVF-7532: Package “pdksh” is missing Solution:             You can resolved the above issue by following simple steps: ·          Copy the Oracle Database source media from DVD to local Disk <path>/database ·          Go to the path: cd <path>/database/stage/cvu/cv/admin ·          Backup cvu_config file: cp cvu_config cvu_config_bak ·          Edit the cvu_config file and change the following line: CV_ASSUME_DISTID=OEL4 To CV_ASSUME_DISTID=OEL6 ·          Save the cvu_config file

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