Creating a database in 12c standalone

Creating a database

Now we will create global database in the installed server.

For that, do the following steps

1.       Go to Start -> All Programs -> Oracle-OraDB12Home -> Configuration and Migration Tools ->

Database Configuration Assistant (right click on it and Run as Administrator)

2.       Select “Create Database” option and click “Next” button.

3.       Enter database name, password and select database character Set. And then click “Next” button.

4.       Loads Database Configuration Summary, click on “Finish” button

5.       Starts creating database file and loads the following window.

6.       Click “finish” button once database is created.

Yes..!! Now the database is created

Oracle Listener

Oracle Net Listener configuration, stored in the listener.ora file, consists of the following elements:

1.       Name of the listener

2.       Protocol addresses that the listener is accepting connection requests on

3.       Database services

4.       Control parameters

Now let us create listener.. Do the following steps for it.

1.  Go to Start -> All Programs -> Oracle-OraDB12Home -> Configuration and Migration Tools -> Net Configuration Assistant.

2. Select first option “Listener configuration” and click “Next” button.

3. Select first option “Add” then click “Next” button.

4.       By default Listener name will be “LISTENER” will be there, just click on “Next” button

5.       Select needed protocols and click “Next”  button

6.       Use the standard port no 1521 or enter your custom port no. then click “Next” button.

7.       If it alerts by asking of configuration another listener select  “No” and click “Next” button

8.       Loads Listener configuration complete message , click “Next”  button

9.       Click “Finish” button

You did it…!!