Apps DBA Workshop

When i was trying to connect to one of Solaris 10 server using xmanager then it was unable to connect displaying error message "The X11 forwarding request was rejected!" Error screen: cause: In sshd configuration file X11Forwarding option was disabled Solution: step1 cat /etc/ssh/sshd_config | grep X11 # X11 tunneling options X11Forwarding no X11DisplayOffset 10 bash-3.00# cat /etc/ssh/sshd_config | grep ListenAddress # Multiple ListenAddress entries are allowed. #ListenAddress 0.0.0.0 ListenAddress :: #This if for IPV4 and IPv6 change above values as below in /etc/ssh/sshd_config file : X11Forwarding yes #ListenAddress :: #(comment this line) ListenAddress 0.0.0.0 #(uncomment this entry) - if not exist in file add it. Step 2 add -4 option for ssh command: original entry # SMF arguments (start and restart [really "refresh"]) 'start') /usr/lib/ssh/sshd ;; update entry # SMF arguments (start and restart [really "refresh...

I am writing this article to help audience who want to add new language (NLS) to their existing R12.1.1 E-Biz environment. I will add ARABIC as another language to an existing R12 Instance. Steps: Note: Before start NLS make sure your database character set supports NLS language which you are adding. 1)Shutdown and Perform a full backup of your system 2)Startup applications > activate additional language (my case - arabic) via OAM Navigation: Sitemap >> License Manager >> Languages >> screens for navigation: 3)Run Maintain Multi-lingual Tables from ad administration 4) Refer Oracle E-Business Suite NLS Release Notes for your current release level to determine if you need to apply any specific NLS patches. If no patches are applicable then we can skip this step. If you are adding more than one language, and patches are required for each then we can use AD Merge Patch to create a merged driver for additional languages. 5)Download and unzip patch (V16151-01.zip) in a ...

Hi, Usually whenever we try to shutdown an oracle database with immediate option it will wait for some active process to get terminate. This may take long time and it also depends on the number of processes. use below command to find out the active sessions on database: bash-3.00$ ps -ef | grep LOCAL=NO ora11g 17862 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17882 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17854 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17890 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17906 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17848 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17978 1 0 Jun 13 ? 0:03 oracletest (LOCAL=NO) ora11g 17908 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17918 1 0 Jun 13 ? 0:00 oracletest (LOCAL=NO) ora11g 17910 1 0 Jun 13 ? 0:00 oraclet...

I was trying to shutdown one of our ASM Instance but failed to do so because of error "ORA-15097: cannot SHUTDOWN ASM instance with connected client". There are certain active processes accessing and are active on ASM Instance. To shutdown the ASM instance you need to perform either shutdown abort option or kill all the active processes on ASM Instance. Try to find out the active process using ps -ef command. bash-3.00$ sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 08:18:17 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: /as sysasm Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Automatic Storage Management option SQL> shut immediate ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 15628) SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Automatic Storage Management option bash-3.00$ kill ...