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

Techgoeasy

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

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
  • New? Start Here
  • About Us
  • Hire me
  • Contact Us

Oracle

Top 40 Oracle RAC interview Questions

December 1, 2019 by techgoeasy Leave a Comment

Question 1. What is Oracle RAC and its uses ? Answer Oracle RAC is a cluster database where multiple instances of Oracle runs multiple nodes sharing a single physical database and have common data & control files Each instance has its own log files and rollback segments (UNDO Tablespace) and can simultaneously execute transactions against […]

Filed Under: Oracle

How to change date format in oracle database

November 30, 2019 by techgoeasy Leave a Comment

We often need to change the date format while checking. Here are some ways which you can use to change date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current value […]

Filed Under: Oracle

How to Create SSH Tunneling or Port Forwarding in Linux to connect with Oracle database on Cloud

November 21, 2019 by techgoeasy Leave a Comment

How to Login to Oracle Cloud Database on port 1521 using SSH tunnel with Linux client $ ssh -i private-key-file -L local-port:target-ip-address:target-port opc@target-ip-address private-key-file is the path to the SSH private key file. local-port is the number of an available port on your Linux system. Specify a port number greater than 1023 and less than […]

Filed Under: Oracle

How to give oracle kill own session privilege to Developers

November 20, 2019 by techgoeasy Leave a Comment

Often developers ask how we can kill our own session as they dont want to wait for the DBA to respond and kill. They want the oracle kill own session privilege. We dont have any privilege like alter system kill session which can be given to the user. We can give alter system privilege but […]

Filed Under: Oracle

How to download Patch from Oracle using Wget

November 16, 2019 by techgoeasy Leave a Comment

Patches can be downloaded using command line download manager utility such as wget. 1.First we need to check if we have wget installed in the system You can use below command which wget or locate wget 2. Make sure it is compiled with SSL option $ wget –help (Below output shows that wget is compiled […]

Filed Under: Oracle

10 Tricks You Must Know When Using Autoconfig In Oracle R12

November 9, 2019 by techgoeasy Leave a Comment

Introduction to Autoconfig in oracle apps R12 -Autoconfig in oracle apps r12 is a tool that supports automated configuration of an Applications instance.-Autoconfig tool is a set of scripts to centralize and simplify E-Business Suite configuration management.-It does so by maintaining a central repository of E-Business Suite environment information in a context file(.xml) on each midtier.-Run […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: Autoconfig

  • Page 1
  • Page 2
  • Page 3
  • …
  • Page 85
  • Next Page »

Primary Sidebar

Top Posts & Pages

  • Top 40 oracle dba interview questions and answers
  • Oracle Indexes and types of indexes in oracle with example
  • 40 Important Weblogic Interview questions
  • Top 30 Most Useful Concurrent Manager Queries
  • 21 awk command in Unix/Linux




Subscribe to our mailing list

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

Recent Posts

  • Top 40 Oracle RAC interview Questions
  • How to change date format in oracle database
  • How to Create SSH Tunneling or Port Forwarding in Linux to connect with Oracle database on Cloud
  • How to give oracle kill own session privilege to Developers
  • How to download Patch from Oracle using Wget

ORA-errors

  1. ORA-06512
  2. ORA-00911
  3. ORA-03113
  4. ORA-29913
  5. ORA-00257
  6. ORA-00054
  7. ORA-27154
  8. ORA-29285
  9. ORA-29280
  10. ORA-29283
  11. ORA-01017
  12. ORA-00900
  13. ORA-00001
  14. ORA-00936
  • Privacy Policy

Copyright © 2019 : TechGoEasy