• Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Posts tagged "database"

Tag Archives: database

Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4

Posted on January 30, 2014 by Garth

In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.4) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus

Read More…

Posted in Database | Tags: 11g, database, install, installation, linux, psu | 8 Comments |

OSD-04400: unable to acquire internal semaphore for process and OS 183 (Windows)

Posted on January 22, 2014 by Garth

I hit the following problem with a 9.2.0.8 database running on Windows 2003 this morning (info pulled from the alert log).  The database had failed to restart after a client’s cold backup process 🙄 ALTER DATABASE MOUNT Wed Jan 15 22:32:08 2014 ORA-09341: scumnt: unable to mount database OSD-04400: unable to acquire internal semaphore for

Read More…

Posted in Database, General | Tags: 9.2.0.8, database, mount, ORA-01102, ORA-09341, OS 183, OSD-04400, windows | 2 Comments |

Creating an Oracle 12c Pluggable Database & Container Database using DBCA

Posted on July 4, 2013 by Garth

In this example, I’ve already installed the Oracle Database 12c software on one of my Linux 6.4 machines.  Using the DBCA tool (in advanced mode), I’m going to create a new container database named “cdb” and at the same time create a pluggable database named “pdb”. The idea behind this new “pluggable databases” feature in

Read More…

Posted in Database | Tags: 12c, container, create, database, dbca, pluggable | 1 Comment |

Oracle Database 12c (12.1.0.1.0) installation on Oracle Linux 6.4

Posted on July 2, 2013 by Garth

In this post, I’m installing the Oracle Database 12c Release 1 (12.1.0.1.0) software on Oracle Linux 6.4.  Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before you start, make sure your Linux server meets the minimum

Read More…

Posted in Database | Tags: 12c, database, install, installation, linux | 3 Comments |

Creating an Oracle 11g Database using DBCA (non-ASM)

Posted on May 19, 2013 by Garth

In this example, I’ve already installed the Oracle Database 11gR2 software (11.2.0.4 in this example) on one of my Linux 6.4 machines, and I’m going to create a new database instance simply called ’emrep’ (as it’s going to be used for my EM12c database repository) using the DBCA tool. The data files will be stored under

Read More…

Posted in Database | Tags: 11g, create, database, dbca, emrep, netca | 3 Comments |

Oracle Database 11gR2 (11.2.0.3) installation on Oracle Linux 6.4

Posted on May 17, 2013 by Garth

In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.3) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus

Read More…

Posted in Database | Tags: 11g, database, install, installation, linux, psu | 2 Comments |

Enabling and configuring Database Mail in SQL Server using T-SQL

Posted on April 25, 2013 by Garth

Having had to run through this process again recently, I thought I’d tidy up my notes on all of this, and put together a proper how-to post 🙂 When SQL Server 2005 was released, the added functionality of Database Mail came with it, giving us the ability to use SMTP to send email from SQL Server

Read More…

Posted in SQL Server | Tags: 2000, 2005, 2008, database, mail, notifications, smtp, sql server | 23 Comments |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
Copyright © 2020 SnapDBA.com