DBPedias

Your Database Knowledge Community

Oracle

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.

  1. How do you bring GUI from terminal on your pc host

    If you are working database on putty terminal at your pc host, you are thinking like to do configure new database use dbca or any other graphical user method. you may jump into GUI linux machine and do your work like vncviewer. Do you know you can able to do ...

  2. Couldn’t find device with uuid ’6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0′ volume group unknown device

    When i try to increase the size primary volume group , it show following error. [root@testser dev]# pvscan Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'. PV /dev/sda2 VG VolGroup00 lvm2 [24.88 GB / 0 free] PV unknown device VG VolGroup00 lvm2 [4.97 GB / 4.97 GB free] PV ...

  3. dbms_space displaying information about space usage

    Oracle Database provides data dictionary views and PL/SQL packages that allow you to display information about the space usage of schema objects. DBMS_SPACE : refer here Just a example : SQL> VARIABLE total_blocks NUMBER SQL> VARIABLE total_bytes NUMBER SQL> VARIABLE unused_blocks NUMBER SQL> VARIABLE unused_bytes NUMBER SQL> VARIABLE lastextf NUMBER ...

  4. GV$ Function

    I really thought I’d blogged about this before, but it appears not! First of all, this isn’t something I’ve worked out, I’m just recycling something that John Beresniewicz (who seems to be better known as JB) shared during one of his presentations at the UKOUG Conference ...

  5. PROT-1: Failed to initialize ocrconfig

    Today during RAC installation I got the following error while running root.sh on the first node Setting the permissions on OCR backup directory Setting up NS directories PROT-1: Failed to initialize ocrconfig Failed to upgrade Oracle Cluster Registry configuration Then I checked ocrconfig log file and got the following ...

  6. OEM12c Discovery of Exadata Cluster

    dbm_configurator.xls is needed to generate databasemachine.xml file which is needed by OEM 12c to discover an exadata cluster.Following is a step by step process as how to generate databasemachine.xml file to be used with OEM 12c:1) Get the dbm_configurator70.xls file from /opt/oracle.SupportTools ...

  7. Easily connect mapped network using pushd command

    I would like to share this information If you want to connect map network using command prompt in windows , you can use pushd command. C:\Users\mazar>pushd \\10.1.xx.xxx\export Z:\>dir Volume in drive Z has no label. Volume Serial Number is 3CF7-C48C Directory of Z ...

  8. Migrating Jobs in Enterprise Manager 12c- not for the faint of heart… :)

    Tweet These are instructions that allowed me to migrate over a large library of EM12c jobs from an existing, split EM console, (Linux) and OMS Repository(Windows) to a single server environment without requiring me to recreate them new. Disclaimer**The migration is a multi-step process that was performed on ...

  9. Internet Explorer and ADF: Not Friends

    One of the advantages to using commercial, fully supported framework like Oracle Application Development Framework (ADF) is that the vendor supplies a list of supported browsers. If something doesn’t work or doesn’t look right, it’s the vendor’s problem. When we started a recent project, we initially ...

  1. 1
  2. Next ›
  3. Last »