MANUAL DATABASE CREATION IN 11G ON WINDOW INVIRONMENT
=========================================================
Create Directory folder under admin, oradata, and flash_recovery_area
D:\app\oracle\admin\nashim\pfile\
D:\app\oracle\admin\nashim\udump
D:\app\oracle\admin\nashim\cdump
D:\app\oracle\admin\nashim\dpdump
D:\app\oracle\admin\nashim\adump
D:\app\oracle\oradata\nashim
D:\app\oracle\flash_recovery_area\nashim
Startup the database to nomount stage with sample parameter file
sample pfile:---
=============
nashim.__db_cache_size=213909504
nashim.__java_pool_size=4194304
nashim.__large_pool_size=4194304
nashim.__oracle_base='D:\app\oracle'#ORACLE_BASE set from environment
nashim.__pga_aggregate_target=251658240
nashim.__sga_target=369098752
nashim.__shared_io_pool_size=0
nashim.__shared_pool_size=138412032
nashim.__streams_pool_size=0
*.audit_file_dest='D:\app\oracle\admin\nashim\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='D:\app\oracle\oradata\nashim\control01.ctl',
'D:\app\oracle\flash_recovery_area\nashim\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='nashim'
*.db_recovery_file_dest='D:\app\oracle\flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='D:\app\oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=nashimXDB)'
*.memory_target=620756992
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
=========================================================
Create Instance service in window environment
Deletion:-
===========
C:\Windows\system32>oradim -delete -sid nashim
Instance deleted.
Creation:-
===========
C:\Windows\system32>oradim -NEW -SID nashim -STARTMODE AUTO -usrpwd manager -PFI
LE D:\app\oracle\admin\nashim\pfile\initnashim.ora
Instance created.
C:\Windows\system32>
C:\Windows\system32>set ORACLE_SID=nashim
C:\Windows\system32>set ORACLE_UNQNAME=nashim
C:\Windows\system32>sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 2 12:57:25 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> show parameter instance;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string nashim
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string D:\APP\ORACLE\ORADATA\NASHIM\C
ONTROL01.CTL, D:\APP\ORACLE\FL
ASH_RECOVERY_AREA\NASHIM\CONTR
OL02.CTL
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> ed
Wrote file afiedt.buf
1 CREATE DATABASE nashim
2 USER SYS IDENTIFIED BY manager
3 USER SYSTEM IDENTIFIED BY manager
4 LOGFILE GROUP 1 ('d:\app\oracle\oradata\nashim\redo01.log') SIZE 100M,
5 GROUP 2 ('d:\app\oracle\oradata\nashim\redo02.log') SIZE 100M,
6 GROUP 3 ('d:\app\oracle\oradata\nashim\redo03.log') SIZE 100M
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 MAXINSTANCES 1
12 CHARACTER SET US7ASCII
13 NATIONAL CHARACTER SET AL16UTF16
14 DATAFILE 'd:\app\oracle\oradata\nashim\system01.dbf' SIZE 325M REUSE
15 EXTENT MANAGEMENT LOCAL
16 SYSAUX DATAFILE 'd:\app\oracle\oradata\nashim\sysaux01.dbf' SIZE 325M R
EUSE
17 DEFAULT TEMPORARY TABLESPACE temp1
18 TEMPFILE 'd:\app\oracle\oradata\nashim\temp01.dbf'
19 SIZE 20M REUSE
20 UNDO TABLESPACE UNDOTBS1
21 DATAFILE 'd:\app\oracle\oradata\nashim\undotbs01.dbf'
22* SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
SQL> /
Database created.
SQL>
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> create spfile from pfile='d:\app\oracle\admin\nashim\pfile\initnashim.ora';
SQL> shutdown immediate
SQL> startup
Create password files.
C:\> export ORACLE_SID=nashim
C:\> orapwd file=${ORACLE_HOME}\database\orapw${ORACLE_SID} password=sys entries=10
