Installation and Database Creation Guide: Oracle 11g

Posted by Developer's Programming Tips at 2:05 AM Read our previous post

Creating a Listener and Setting Up Service

1. Open the Net Configuration Assistant
   
   
2. Select listener configuration then click next
   
   
   
3. Select Add and click next
   

4. Name your listener and click next
   
   
   
5. Just choose TCP then click next
   

6. Use the standard port number 1521 and click next
   
   
   
7. Select no then click next
   

8. The listener creation is now complete. Click next
   
   
   
   
   
   
   
9. Select the Local Net Service Name Configuration
   

10. Select add and click next
    
    
    
11. Enter the service name, this would be also the database name that we’ll be using on creating a database. Click next
    

12. Select TCP and click next
    
    
    
13. Host name should be your IP address and just use the standard port number. Click next
    
    
    

14. Select do not test and click next
    
    
    
15. Enter your database name and click next
    

16. Select no and click next
    
    
    
17. Net service name configuration is now complete. Click next
    

18. Click finish
    
    
    

   Database Creation

1. Open Database Configuration Assistant and click next
   
   
   
2. Select Create a Database and click next
   

3. Select General Purpose or Transaction Processing and click next
   
   
   
4. Name the database with the same name on the Listener Setup part and click next
   
   
   

5. Leave the choices on default and click next
   
   
   
6. Select the Use the same administrative password for all accounts. For this example I’ve used password123 as password. Click next
   

7. If a prompt about password complexity pops up just click Yes
   
   
   
8. Select Use Database File Locations from Template and click Finish
   

9. A summary of the configuration would pop-up. Click OK
   
   
   
10. Wait for the process to finish
    

11. The database setup is now finished. Take note of the Database Control URL. Click exit
    

 Testing the Database Connection

1. Open the Oracle SQL Developer
   
   
   
2. Click on the New Connection icon on the upper left side
   

3. Key in the values on the screenshot. Password is password123 and the ip is your ip address.
   
   
4. Click on the test button. If the test is successful it means that the configuration of the database and listener are correct.
   
   
5. Click connect
   
   
   
6. Connection is successful.
   
   
   
   
   
   Creating a New Database User
   
   

1. Go to the web address, that was shown at the last part of the database setup.
   
   
2. Login as System with password password123
   
3. Go to the Server tab and click users on the Security Column
   
4. Click the Create button
   
5. Enter the name and password. Password for the example is password123
   

6. On the system privileges tab click on Edit List button
   
7. Click on the Move All button and click OK
   

8. Click OK to create the User
   
9. The user is now created.
   

10. Refer to the part III of the guide to create another connection for the user that has been created with the details below.