Enhancing Security - Expert Oracle and Java Security - page 301

Now change directory to the new parameters file, pfile directory and rename the existing init.ora file
template to init.ora . Then edit the init.ora file.
cd \app\oracle\admin\apver\pfile
ren init.ora.* init.ora
edit init.ora
Search and replace the following strings:
Replace With
======= ====
=orcl =apver
\orcl \apver
Your final file should have parameters like those in Listing 11-41. Your db_domain and directory
names may be different. The local_listener will the same for apver as for the primary database.
Listing 11-41. Initialization File for the apver Instance
db_block_size=8192
open_cursors=300
db_domain=org.com
db_name=apver
control_files=("D:\app\oracle\oradata\apver\control01.ctl",
"D:\app\oracle\flash_recovery_area\apver\control02.ctl")
db_recovery_file_dest=D:\app\oracle\flash_recovery_area
db_recovery_file_dest_size=4039114752
compatible=11.2.0.0.0
diagnostic_dest=D:\app\oracle
memory_target=1288699904
local_listener=LISTENER_Orcl
processes=150
audit_file_dest=D:\app\oracle\admin\apver\adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP) (SERVICE=apverXDB)"
undo_tablespace=UNDOTBS1
We want to copy this init.ora file into its default location. This will come in handy later when we
import the parameter settings into a system parameter file. Execute the copy command:
copy D:\app\oracle\admin\apver\pfile\init.ora %ORACLE_HOME%\DATABASE\INITAPVER.ORA
Create a directory for the secondary control file:
mkdir D:\app\oracle\flash_recovery_area\apver
Also, let's create a directory for our new instance database files:
mkdir D:\app\oracle\oradata\apver
Create a New Oracle Service
Each Oracle Database instance is started, usually on system reboot, by a Service. You can see these
services in Windows by going to your Start menu and running the Computer Management application.