Manually creating database

Tags

Manual database creation in windows

This document cannot be downloaded due to copyright protection

be first to review

Anonymous

MANUALLY CREATING DATABASE (WINDOWS) By CHIRAG PANKHAWALA, software research group Inc. 1. Create the directory structure You may also need to create following directories, 2. Declare an oracle SID name. C:\>set ORACLE_SID=testdb 3. Create a windows service and password file C:\>oradim -new -sid %ORACLE_SID% -intpwd sysdba -startmode M Instance created. The Oracle testdb VSS Writer Service service is starting. The Oracle testdb VSS Writer Service service was started successfully. Important :Before starting instance you need to shutdown all services for previous database. In this example, I have stopped “ OracleServiceORCL” and started “OracleServicetestdb”. 4. Create the init.ora file DIRECTORY: C:\app\Chirag\admin\testdb\pfile\inittestdb.ora # # $Header: init.ora 11-sep-2007.12:09:54 ysarig Exp $ # # Copyright (c) 1991, 1997, 1998 by Oracle Corporation # NAME # init.ora # FUNCTION # NOTES # MODIFIED # # # # # # # # # # # ysarig ysarig 08/13/07 - Fixing the sample for 11g 09/11/07 - XbranchMerge ysarig_bug-6334195 from main atsukerm 08/06/98 - fix for 8.1. hpiao 06/05/97 - fix for 803 glavash 05/12/97 - add oracle_trace_enable comment hpiao 04/22/97 - remove ifile=, events=, etc. alingelb 09/19/94 - remove vms-specific stuff dpawson 07/07/93 - add more comments regarded archive start maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE jloaiza 03/07/92 - change ALPHA to BETA danderso 02/26/92 - change db_block_cache_protect to _db_block_cache_p # # # # # # # # # ghallmar 02/03/92 - db_directory -> db_domain maporter 01/12/92 - merge changes from branch 1.8.308.1 maporter 12/21/91 - bug 76493: Add control_files parameter wbridge 12/03/91 - use of %c in archive format is discouraged ghallmar 12/02/91 - add global_names=true, db_directory=us.acme.com thayes 11/27/91 - Change default for cache_clone merge changes from branch 1.7.100.1 add debug stuff removal of char_is_varchar2 jloaiza 08/13/91 jloaiza 07/31/91 rlim 04/29/91 - # Bridge # Wijaya # 03/12/91 - log_allocation no longer exists 02/05/91 - remove obsolete parameters ############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you start by providing # a starting point to customize your RDBMS installation for your site. # # NOTE: The values that are used in this file are only intended to be used # as a starting point. You may want to adjust/tune those values to your # specific hardware and needs. You may also consider using Database # Configuration Assistant tool (DBCA) to create INIT file and to size your # initial set of tablespaces based on the user input. ############################################################################### # Change '' to point to the oracle base (the one you specify at # install time) db_name='testdb' instance_name=testdb log_archive_dest_1='LOCATION=C:\app\Chirag\admin\testdb\archive' background_dump_dest=C:\app\Chirag\admin\testdb\bdump core_dump_dest=C:\app\Chirag\admin\testdb\cdump user_dump_dest=C:\app\Chirag\admin\testdb\udump control_files = ("C:\app\Chirag\oradata\testdb\control01.ctl", "C:\app\Chirag\oradata\testdb\control02.ctl", "C:\app\Chirag\oradata\testdb\control03.ctl") undo_management = auto db_block_size = 8192 db_domain='' db_recovery_file_dest='C:\app\Chirag\flash_recovery_area' db_recovery_file_dest_size=2G diagnostic_dest='C:\app\Chirag\product\11.1.0\db_2\database\oracle_base' dispatchers='(PROTOCOL=TCP) (SERVICE=OracleServicetestdb)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='undo' # You may want to ensure that control files are created on separate physical # devices control_files = ("C:\app\Chirag\product\11.1.0\db_2\database\ora_control1", "C:\app\Chirag\product\11.1.0\db_2\database\ora_control2") compatible ='11.1.0' 5. Start the instance in nomount mode C:\>echo %ORACLE_SID% testdb SQL> connect Enter user-name: sys/sysdba as sysdba Connected to an idle instance. SQL> startup nomount pfile=C:\app\Chirag\admin\testdb\pfile\inittestdb.ora ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecated ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated ORACLE instance started. Total System Global Area 150667264 bytes Fixed Size Variable Size Database Buffers Redo Buffers 1331740 bytes 92278244 bytes 50331648 bytes 6725632 bytes 6. Use the Create database command SQL> create database testdb 2 logfile group 1 ('C:\app\Chirag\oradata\testdb\redo1.log') size 10M, 3 group 2 ('C:\app\Chirag\oradata\testdb\redo2.log') size 10M, 4 group 3 ('C:\app\Chirag\oradata\testdb\redo3.log') size 10M 5 character set WE8ISO8859P1 6 national character set utf8 7 datafile 'C:\app\Chirag\oradata\testdb\system.dbf' size 50M autoextend on next 10M maxsize unlimited 8 extent management local 9 sysaux datafile 'C:\app\Chirag\oradata\testdb\sysaux.dbf' size 10M autoextend on next 10M maxsize unlimited 10 undo tablespace undo 11 datafile 'C:\app\Chirag\oradata\testdb\undo.dbf' size 10M autoextend on 12 default temporary tablespace temp 13 tempfile 'C:\app\Chirag\oradata\testdb\temp.dbf' size 10M autoextend on; Database created. 7. Create Data Dictionary scripts for creating the data dictionary are under ORACLE_HOME\rdbms\admin. sql> @?\rdbms\admin\catalog.sql sql> @?\rdbms\admin\catproc.sql (this two scripts may take a while) -----------------------------------------------------------------------------------------------------------------------------------------Two database running on same machineSql> connect sys@db_name as sysdba

Traditional Copyright:All rights reserved

downloads:0

rating:not rated

reviews:0

posted:7/2/2008

language:English

Manually creating database

manual_creation_of_database_in_wind ows_with_oracle9i

Creation of a National Wind Database

Creation of a National Wind Database

Creation of a National Wind Database

Oracle Database 11g Architecture on Windows

Oracle Database on Windows Vista - Statement of Direction

Scripts to backup Oracle database on Windows NT

Creation of PM Database in Support of NAAQS Monitoring Rule Proposals

Create Oracle 10g database manual

Student Database

Creating partitions manually

Database change

STD Performance Measures Online Database Grantee User Manual