7.0

VMware, Inc. 23
Chapter 2 Installing ADM
GROUP 3 '/opt/oracle/app/oracle/oradata/nlayers/redo3.log' SIZE 10M
DATAFILE '/opt/oracle/app/oracle/oradata/nlayers/system01.dbf' size
850m autoextend off
sysaux datafile '/opt/oracle/app/oracle/oradata/nlayers/sysaux01.dbf'
size 700M
undo tablespace undotbs
datafile '/opt/oracle/app/oracle/oradata/nlayers/undo01.dbf' size 100M
reuse autoextend on
maxsize unlimited
default temporary tablespace temp tempfile
'/opt/oracle/app/oracle/oradata/nlayers/temp01.dbf' size 100M reuse
CHARACTER SET WE8ISO8859P1;
CREATE TABLESPACE users LOGGING
DATAFILE '/opt/oracle/app/oracle/oradata/nlayers/users01.dbf'
SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
3 Navigateto:
/opt/oracle/app/oracle/product/11.2.0/db_1/dbs/
4 Createafile,initnlayers.ora,withthefollowingcontent:
*.audit_file_dest='/opt/oracle/app/oracle/admin/nlayers/adump'
*.compatible='11.2.0.0.0'
*.control_files='/opt/oracle/app/oracle/oradata/nlayers/control01.ctl',
'/opt/oracle/app/oracle/oradata/nlayers/control02.ctl','/opt/oracle/app/oracle
/oradata/nlayers/control03.ctl'
*.core_dump_dest='/opt/oracle/app/oracle/admin/nlayers/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='nlayers'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=nlayers)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/opt/oracle/app/oracle/admin/nlayers/archive'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=1073741824
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1073741824
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.db_recovery_file_dest='/opt/oracle/app/oracle/admin/nlayers/backup'
*.db_recovery_file_dest_size=2147483648
*.utl_file_dir='/var/log/nlayers/db'
NOTEEnsurethatthehighlightedsectionofthecommandisenteredonasingleline.
5LogintotheOracleserverwithuserasoracle.
6Logintothedatabasebyrunningthefollowingcommand.
$ sqlplus / as sysdba
7InSQLPlus,runthefollowingcommands:
SQL> startup pfile=/opt/oracle/app/oracle/product/11.2.0/db_1/dbs/initnlayers.ora nomount
SQL> @/opt/oracle/app/oracle/product/11.2.0/db_1/bin/create_nlayers_db.sql
SQL> @/opt/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql
SQL> @/opt/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catproc.sql
8Aftercompletion,runthefollowingqueryandensurethereturnvalueisNLAYERS.
SQL> select name from v$database;
NAME
---------
NLAYERS
9ExitSQLPlus.