Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy




Oracle Tips by Burleson 

Database Creation Status Password Management screen.

If all goes as anticipated, the next screen will tell you that the database was successfully created. It will also inform you that the default users are locked and that passwords not set. I suggest selecting the Password Management button at this point.

Successful Database Creation screen.

The Password Management screenallows you to specify passwords and change the locked status of the default database users. Once the passwords and account status are updated, select the OK button.

The Password Management screen.

If you have made it this far, you have successfully created a new Oracle database. Congratulations. If you had problems, you can either restart the process at the beginning after correcting any problems or use the script you hopefully generated earlier to manually create the database. The generated scripts will be located in the $ORACLE_HOME/admin/sid/scripts directory on UNIX or Linux, and on the ORACLE_HOME\admin\sid\scripts on NT4.0 or W2K.

The list of scripts generated during the above database creation contains: Master script that calls the others.

   CreateDB.sql. Creates the database.

   CreateDBFiles.sql. Creates the additional database tablespaces and files.

   CreateDBCatalog.sql. Creates the catalog and procedural options.

   JServer.sql. Creates the JVM.

   ordinst.sql. Installs the ORDSYS tables, views, and packages for handling

 Oracle cartridges.

   interMedia.sql. Creates the Intermedia option.

   context.sql. Creates required support for contexts.

   spatial.sql. Creates the spatial option.

   ultraSearch.sql. Creates the Ultra Search option.

   postDBCreation.sql. Creates the SPFILE; performs a clean shutdown and                startup      

 There may be more or fewer of these scripts depending on the options you chose to install. If your database creation fails, use these scripts to build the database manually.

Alteration of Databases

Even the best-designed database eventually has to be changed. New log group member files may need to be added, data files may need to be renamed or moved, archive logging status may need to be changed, and so on. These tasks are all accomplished through the use of the ALTER DATABASE command. Let’s look at a simplified command format and some of the options.

See Code Depot

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks