Performing Oracle Advanced Recovery - OCP: Oracle Database 12c Administrator Certified Professional - page 296

e xeRCiSe 7.1 (continued)
4. Create the password file for the neworcl instance:
C:\>orapwd file=c:\oracle\product\12.1.0\db_1\database\pwdneworcl.ora
Enter password for SYS:
5. Create a temporary pfile for the neworcl auxiliary instance using your editor of
choice. The pfile should be contained in the ORACLE_HOME\database directory of the
auxiliary instance and should be named initneworcl.ora . The pfile should contain
these parameters:
db_name=neworcl
memory_target=300m
control_files='c:\oracle\oradata\neworcl\control01.ctl',
'c:\oracle\oradata\neworcl\control02.ctl'
You will do the actual file-location conversions during the duplication.
6. Create the directory c:\oracle\oradata\neworcl :
mkdir c:\oracle\oradata\neworcl
7. Start up the auxiliary instance:
C:\oracle\product\11.1.0\db_1\database>set oracle_sid=neworcl
C:\oracle\product\11.1.0\db_1\database>sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Oct 4 23:09:52 2013
Copyright (c) 1982, 2012, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1332892 bytes
Variable Size 192940388 bytes
Database Buffers 113246208 bytes
Redo Buffers 6340608 bytes
8. Configure service name resolution for your new auxiliary database. The method of
this configuration will vary based on your site. In our case, we created an entry in the
tnsnames.ora file on our server that looked like this:
NEWORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.2)(PORT = 1521))
(CONNECT_DATA =