• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

Reserved keywords in Oracle

November 10, 2012 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database Tagged With: keywords

How to debug Oracle RMAN session

November 10, 2012 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database Tagged With: How to debug Oracle RMAN session, rman debug

How to find the database session for JVM PID

November 5, 2012 by techgoeasy Leave a Comment

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) […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to find the database session for JVM PID, JDBC connection, PID

How to add any node to Oracle RAC cluster in 10g and 11g

November 3, 2012 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database Tagged With: add any node to Oracle RAC cluster, addnode, cluster, RAC

Key Technology changes in E-Business Suite 12.2

August 15, 2012 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: Key Technology changes in E-Business Suite 12.2

Oracle’s Containers for J2EE (OC4J) in R12

August 11, 2012 by techgoeasy Leave a Comment

Oracle’s Containers for J2EE (OC4J) – OC4J stands for Oracle’s Containers for J2EE. OC4J can execute Servlets, Java Server Pages (JSP), Enterprise Java Beans (EJB)-OC4J replaces the older JServ implementation for running servlets on the web server-Oracle Application Server 10gR3 (10.1.3) is the latest production version-OC4J is based on J2EE standards:Specific directory structure,File requirements (content & naming […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: OC4J R12, R12, R12 includes Oracle's Containers for J2EE

  • « Previous Page
  • Page 1
  • …
  • Page 117
  • Page 118
  • Page 119
  • Page 120
  • Page 121
  • …
  • Page 123
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Move SQL Baseline from One Database to Another in Oracle
  • How to drop the sql baseline in Oracle
  • how to create sql baseline from AWR repository without STS
  • how to create sql baseline from Sql tuning set in Oracle
  • How to create sql baseline from cursor cache in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us
x
x