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.sqlSQL> @?/rdbms/admin/catproc.sql

catalog.sql creates the data dictionary, catproc.sql creates all structures required for PL/SQL.