Oracle Corporation has announced Oracle Solaris 11, the first cloud OS. User Environment 1)Popular Open Source Software Packages – Java SE 6 and 7, GCC 4.5.2, Python 2.7, Perl 5.12, Ruby 1.8.7, PHP 5.2.17 and complete web stack 2)Enhanced Desktop Environment 3)Default $PATH and User Familiarity 4)Default Shell – bash shell for users 5)Removable Media […]
Oracle announced its new Cloud based Solaris Version 11 Read More »
There are certain keywords in oracle which can be used restrictively only. These values are defined in v$reserved_words table SQL> desc v$reserved_words; Name Null? Type —————————————– ——– —————————- KEYWORD VARCHAR2(30) LENGTH NUMBER RESERVED VARCHAR2(1) RES_TYPE VARCHAR2(1) RES_ATTR VARCHAR2(1) RES_SEMI VARCHAR2(1) DUPLICATE VARCHAR2(1) -A value of column reserved Y means that the keyword cannot be used
Reserved keywords in Oracle Read More »
Many times RMAN session hangs or gave different types of errors. The investigation cannot be done with log files generated. We need to debug rman session in order the performance issues or the errors. With debugging a detailed trace file is generated where we can easily find the performance issue and errors The RMAN Debug
How to debug Oracle RMAN session Read More »
To find total number of open database connections for a given JVM PIDSELECT s.process, Count(*) all_count FROM gv$session s WHERE s.process IN () GROUP BY s.process To find number of database connections per JVM that were inactive for longer then 60 minutes SELECT s.process, Count(*) olderConnection_count FROM gv$session s WHERE s.process IN () and s.last_call_et>=(60*60)
How to find the database session for JVM PID Read More »
Step 1: Prepare the server to be added a) Shared the Database Storage b) Shared the OCR and voting disk c) Check the new box for ssh connectivity Step 2: Run cluvfy cluvfy stage -post hwos -n SUN12OS Step 3: Add node to Cluster using the $ORACLE_HOME/oui/bin/addnode.sh from the node existing in cluster And choose
How to add any node to Oracle RAC cluster in 10g and 11g Read More »
Key Technology changes in E-Business Suite 12.2 There are lots of updates coming in 12.1 release, but from a technology stack perspective, EBS 12.2 will be notable for two things: A) Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11gEBS 12.2 will use WebLogic Server from Fusion Middleware 11g in place ofOC4J 10g
Key Technology changes in E-Business Suite 12.2 Read More »
