ss

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:

galinux2.sh. 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