This is the first article about administrating Oracle Database. I'm really new to this and I've never installed and administrated Oracle Database before. I won't describe in depth how to work with it, because there are already a lot of information. I'll describe basic installation and write some articles about management. Maybe someone will find it useful.

Installation of the Database

In this article I'll describe how to install Oracle 11g EE Database to the Windows Server 2012 (so this guide can be used for Windows 7, Windows 8 and Windows 10). You can use Enterpraise Edition of the database for development purpose for free, so first of all go to the official website and download database files. There are two parts of the database installer in two archives, but it's important to understand, that there are to separate archives, not the one archive with two parts. So you'll need to unpack them one by one into the directory, because installation will gave you an error if you forget to unpack second archive.

Now you can start installation. You could install it on your own or you can follow this guide from start to end. Enumeration could change it future versions.

  1. Configure Security Updates is important if you are using database for production, otherwise you can skip it.
  2. Installation Option => Create and configure database.
  3. System Class. I've chosen Server Class, as I've installed it on Windows Server. Also, it has a lot options, so I think you could install this class into desktop computer.
  4. Grid installation options. Single instance database. Obvious, because if you can handle cluster you don't need guides.
  5. Choose advanced install and than you'll get some options. All of them obvious. I'll explain some of them:
    • I haven't touch Oracle Base and Software location, but you should specify it like C:\Oracle or something like it, because custom names could give you some problems with your team in future if you have or planning to get it.
    • Configuration type - General purpose.
    • Database identifiers. It's really important to choose. You should remember, because you'll need to connect to database. It's index of whole system. If you'll need data to place into different locations you should create Schema (Users).
    • In Configuration options it's important to pay attention to Character set. I've chosen UTF-8.
    • Database Storage. Where you'll store database. I think there could be some cloud options in future.
    • Backups. Enable or disable. But, you know, it will be you worst day, when you break database and have no backups. So, I've chosen this option, because it will be useful to me, until I learn how to work with Oracle Database... and later.
    • Database password. Choose one for all schemas (users).

Listeners

You have two possible ways to create listener.

First is to use Net Configuration Assistant. Listener Configuration -> Add -> Create listener name -> Select protocol -> Select port number. That's all. Listener created.

More advanced way to manage it with Net Manager. Here you can create, delete and modify listeners. There are two things we will need Listener Locations tab where you can add connection information (port and ip address of the server or localhost if you're going to use it locally) and Database Services where you can specify following:

  1. Global database name, same as SID
  2. Oracle home where you've installed your database
  3. SID, same as database identifier from point 5 of previous chapter.

Now you should restart listener. Use LSNRCTL command in command prompt and get access to listener control. Then you'll need to use STOP LISTENER and START LISTENER to restart it. Now you could get access from remote computer. You could test it by using database connector in every IDE.