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
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
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
interMedia.sql. Creates the Intermedia
context.sql. Creates required support for
spatial.sql. Creates the spatial option.
ultraSearch.sql. Creates the Ultra Search
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