Database Technologies‎ > ‎Oracle‎ > ‎

creating oracle database

oradim -new -sid karl -intpwd oracle123$

set oracle_sid=karl

sqlplus "/ as sysdba"

Connected to an idle instance


Create Parameter file sample given below

class.__db_cache_size=25165824
class.__java_pool_size=4194304
class.__large_pool_size=4194304
class.__shared_pool_size=58720256
class.__streams_pool_size=0
*.audit_file_dest='C:\~\~\class\adump'
*.background_dump_dest='C:\~\~\class\bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\~\~\class\control01.ctl','C:\~\~\class\control02.ctl'
*.core_dump_dest='C:\~\~\class\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='class'
*.db_recovery_file_dest='C:\~\oracle\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=class)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=10485760
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=100663296
*.undo_management='MANUAL'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\~\~\class\udump'


SQL> startup nomount pfile='\path\to\the\init.ora'

After this the database is to be created.

SQl> create database karl
     character set WE8ISO8859P1
     national character set utf8
     datafile 'S:\Karldb\df\system.dbf'
     size 100m
     sysaux datafile 'S:\Karldb\df\sysaux.dbf'
     size 20m
     undo tablespace UNDOTBS1
     datafile 'S:\Karldb\df\undo1.dbf'
     size 20m
     default temporary tablespace temp
     tempfile 'S:\Karldb\df\temp.dbf'
     size 20m
     LOGFILE GROUP 1 ('S:\Karldb\lgs\redo01.log') SIZE 5120K,
     GROUP 2 ('S:\Karldb\lgs\redo02.log') SIZE 5120K,
     GROUP 3 ('S:\Karldb\lgs\redo03.log') SIZE 10240K
;

SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
catalog.sql creates the data dictionary,  catproc.sql creates all structures required for PL/SQL.



Comments