mrspax.blogg.se

Let's address the parameters in the initialization file in greaterdepth:ĭB_NAME Must be set to a text string of eight characters orless. Name the copied init.ora file init.ora because this is the default namingconvention that the Oracle server looks for when it tries to start up theinstance.Įdit this file's parameters so that your database and your instance willrun effectively on your system.

Find the one that most closely matches what you intendyour database to be used for, copy it to another name (saving the template forreuse later), and make your specific alterations to the copy. There isone for a regular OLTP database, one for a data warehouse database, and one fora combination database. In the ORACLE_HOME/dbs directory, a set of generic initializationfiles are available for you to copy and customize to your situation.

Step 2: Create the Initialization Parameter File This is what the environment will be set to when your database starts upand shuts down, and what the instance processes will have in their names asunique identifiers. The first step in creating the database is to determine the System Identifier(SID). Step 1: Decide on Your Instance's System Identifier (SID) Learn More Buy Create a Database ManuallyĮven if your company standardizes on using the GUI tools, such as DBCA, itwould be a good idea to create a database manually at least once, not only tohelp you with this test (although it will help you to pass this portion of theexam), but so that you have an idea of what the DBCA is doing behind the scenes.This knowledge will help you to make more informed decisions in creating yourdatabases, going forward, regardless of how you create them.