Manual Database Creation Leave a Comment / Oracle Database / By Database Analyser Index Toggle1. Firstly, export Environment Variables.2. Create parameter file and modify it by setting minimum required parameters:3. Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode.4. Create database script5. Run the scripts necessary to build views, synonyms, and PL/SQL packages6. Shutdown the instance and startup the database.1. Firstly, export Environment Variables.To export EV automatically for every session, do below changes to /home/oracle/.bashrc file:export ORACLE_SID=kamranexport ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib 2. Create parameter file and modify it by setting minimum required parameters: *.db_name=kamran *.db_block_size=8192 *.sga_target=1677721600 *.undo_management=’AUTO’ *.control_files = (‘/home/oracle/oracle/product/10.2.0/control01.ctl’) *.user_dump_dest=’/home/oracle/oracle/product/10.2.0/udump’ *.background_dump_dest=’/home/oracle/oracle/product/10.2.0/bdump’ *.core_dump_dest=’/home/oracle/oracle/product/10.2.0/cdump’After creation of this parameter file, create below folders in /home/oracle/oracle/product/10.2.0/ directory. Three of them are dump folders (needed for trace files and alert.log file). We’re going to keep Control Files and DataFiles in oradata folder. – oradata – udump – bdump – cdump 3. Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode.CREATE SPFILE FROM PFILE=’/home/oracle/oracle/product/10.2.0/init.ora’;STARTUP NOMOUNT Now our instance started, SGA allocated and background processes started4. Create database scriptCREATE DATABASE sunmUSER SYS IDENTIFIED BY oracleUSER SYSTEM IDENTIFIED BY oracleLOGFILE GROUP 1 (‘/SPA4/UndoTemp/ORACLE/sunm/oradata/redo01.log’) SIZE 50M, GROUP 2 (‘/SPA4/UndoTemp/ORACLE/sunm/oradata/redo02.log’) SIZE 50M, GROUP 3 (‘/SPA4/UndoTemp/ORACLE/sunm/oradata/redo03.log’) SIZE 50MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100CHARACTER SET US7ASCIINATIONAL CHARACTER SET AL16UTF16EXTENT MANAGEMENT LOCALDATAFILE ‘/SPA4/UndoTemp/ORACLE/sunm/oradata/system01.dbf’ SIZE 325M REUSESYSAUX DATAFILE ‘/SPA4/UndoTemp/ORACLE/sunm/oradata/sysaux01.dbf’ SIZE 325M REUSEDEFAULT TABLESPACE users DATAFILE ‘/SPA4/UndoTemp/ORACLE/sunm/oradata/users01.dbf’ SIZE 500M REUSE AUTOEXTEND ON MAXSIZE 2GDEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE ‘/SPA4/UndoTemp/ORACLE/sunm/oradata/temp01.dbf’ SIZE 20M REUSEUNDO TABLESPACE undotbs DATAFILE ‘/SPA4/UndoTemp/ORACLE/sunm/oradata/undotbs01.dbf’ SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 2G;5. Run the scripts necessary to build views, synonyms, and PL/SQL packagesCONNECT / AS SYSDBASQL>@$ORACLE_HOME/rdbms/admin/catalog.sqlSQL>@$ORACLE_HOME/rdbms/admin/catproc.sql6. Shutdown the instance and startup the database.Your database is ready for use! Views: 93Share this:Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Telegram (Opens in new window)Click to share on WhatsApp (Opens in new window)Like this:Like Loading...Related
