Create the database

1. Documentation in Tahiti -> 2 Day DBA -> (2) Installing Oracle Database and Creating a Database -> Creating and Managing a Database With DBCA

2. Sign in with the user oracle

3. Run the wizard to create databases

 dbca 

Click “Next” “>4. To advance to the next screen -> Click “Next”

Click “Next” “>5. Select “Create a Database” -> Click “Next”

Click “Next” “>6. selecccionar “Custom Database” -> Click “Next”

7. Enter the “Global Database Name” and SID

Global Database Name = “CMO”
SID = “CMO”
Click “Next”

Click “Next” “>8. deselect “Set Enterpris Manager” -> Click “Next”

9. Select “Use the Same Password for All Administrative Account”

Password = “xxxxxx”
Confirm Password = “xxxxxx”
Click “Next”
10. For the storage type:
Storage Type = “File System”
Select “Use Common Location for All Database Files”
Database Files Location = “{ORACLE_BASE} / oradata”
Click “Next”

Seleccionamos “Enable Archiving” -> Click “Next” “>11. We leave default settings Flash / Fast Recovery Area -> select “Enable Archiving” -> Click “Next”

Click “Next” “>12. We leave the default selected components -> Click “Next”

13. Select the Unicode character set, other options default

Click tab “Character Sets”
Click “Use Unicode (AL32UTF8)
Click “Next”

Click “Next” “>14. In the window “Database Storage” -> Click “Next”

Click “Next” “>15. Activate the boxes “Create Database” and “Generate Database Creation Scripts” -> Click “Next”

Click “OK” “>16. We confirm the summary (Summary) -> Click “OK”

Click “OK” “>17. We will get confirmation that has generated the build script BD -> Click “OK”

Click “Exit” “>18. After the installation -> Click “Exit”

19. Not only will put the database in ARCHIVELOG mode, also took the opportunity to activate the FLASHBACK.
The FLASHBACK mode allows the BD us back to earlier points in time.

sqlplus / as sysdba
1 SHUTDOWN IMMEDIATE;
2 STARTUP MOUNT;
3 ALTER DATABASE ARCHIVELOG;
4 ALTER DATABASE FLASHBACK ON;
5 ALTER DATABASE OPEN;

20. We found that is well configured

1 sqlplus / as sysdba
1 SELECT NAME, LOG_MODE, FLASHBACK_ON FROM V $ DATABASE;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.