See Chapter 4 for more information on OFA.
2. Select an Oracle SID to distinguish this instance from any other ones running on this
server. Frequently this is the same as the database name specified in the DB_NAME
initialization parameter. In a Windows command prompt, you will type the following:
set ORACLE_SID=dw
FIGURE A-13 Creating and starting the Oracle instance
650 Oracle Database 11g DBA Handbook
Under Unix, you will use either
export ORACLE_SID=dw
or
setenv ORACLE_SID=dw
depending on your default command shell.
3. Establish an authentication method for connecting privileged users to the database.
Use the orapwd command-line utility to create a password file if you want Oracle to
authenticate the privileged users, and you will set the initialization parameter REMOTE_
LOGIN_PASSWORDFILE to EXCLUSIVE. If you are using operating system authentication,
there is no need for a password file; set REMOTE_LOGIN_PASSWORDFILE to NONE.
4. Create an initialization parameter file and place it in the default location for your platform,
at least initially for the install. Under Unix, the default location is $ORACLE_HOME/dbs;
under Windows it is $ORACLE_HOME\database. Here is an excerpt from the initialization
file created by DBCA when you specify the option to save the database creation scripts:
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=world
db_name=dw
###########################################
# File Configuration
###########################################
db_create_file_dest=+DATA
db_recovery_file_dest=+RECOV
db_recovery_file_dest_size=2147483648
###########################################
# Miscellaneous
###########################################
compatible=11.
Pages:
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954