Funda 1 > Man_database - 25th May

sql> sql> ------ first create the folder in the admin folder with database name sql> sql> ----- inside the database name folder create folder for admim,udump,bdump sql> sql> sql> ----- then copy the pfile from the working database and change the database name... sql> sql> ---- again go to the oradat data folder and create the folder in the database name... sql> sql> ------- go to the command prompt sql> sql> sql> --------- try to create teh password file sql> sql> ---- orapwd file=d:\oracle\ora92\database\pwsdb_name.ora' password=oracle entries=5 sql> sql> ------ then create a service for the database sql> sql> ---then sql> sql> sql> shutdown immediate; database closed. database dismounted. oracle instance shut down. sql> - then start in pfile for ata db sp2-0734: unknown command beginning "- then sta..." - rest of line ignored. sql> sql> startup nomount pfile='d:\oracle\admin\velu\pfile\init.ora'; oracle instance started. total system global area fixed size variable size database buffers redo buffers sql> sql> 2 3 4 5 6 7 8 9 10 11 12

135338868 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

create database pop1 maxlogfiles 10 maxlogmembers 5 maxdatafiles 20 maxinstances 4 maxloghistory 100 datafile 'd:\oracle\oradata\velu\system01.dbf' size 100m undo tablespace undotbs datafile 'd:\oracle\oradata\velu1\undotbs01.dbf' size 20m default temporary tablespace temp tempfile 'd:\oracle\oradata\velu\temp01.dbf' size 10m logfile group 1('d:\oracle\oradata\velu\redo01.log') size 5m,

13 group 2('d:\oracle\oradata\velu\redo02.log') size 5m 14 noarchivelog 15 ; create database pop1

* error at line 1: ora-01501: create database failed ora-01504: database name 'pop1' does not match parameter db_name 'velu' sql> ed wrote file afiedt.buf 1 create database velu 2 maxlogfiles 10 3 maxlogmembers 5 4 maxdatafiles 20 5 maxinstances 4 6 maxloghistory 100 7 datafile 'd:\oracle\oradata\velu\system01.dbf' size 100m 8 undo tablespace undotbs 9 datafile 'd:\oracle\oradata\velu1\undotbs01.dbf' size 20m 10 default temporary tablespace temp 11 tempfile 'd:\oracle\oradata\velu\temp01.dbf' size 10m 12 logfile group 1('d:\oracle\oradata\velu\redo01.log') size 5m, 13 group 2('d:\oracle\oradata\velu\redo02.log') size 5m 14* noarchivelog 15 / create database velu * error at line 1: ora-01092: oracle instance terminated. disconnection forced sql> sql> sql> ed wrote file afiedt.buf 1 create database velu 2 maxlogfiles 10 3 maxlogmembers 5 4 maxdatafiles 20 5 maxinstances 4 6 maxloghistory 100 7 datafile 'd:\oracle\oradata\velu\system01.dbf' size 100m 8 undo tablespace undotbs 9 datafile 'd:\oracle\oradata\velu1\undotbs01.dbf' size 20m 10 default temporary tablespace temp 11 tempfile 'd:\oracle\oradata\velu\temp01.dbf' size 10m 12 logfile group 1('d:\oracle\oradata\velu\redo01.log') size 5m, 13 group 2('d:\oracle\oradata\velu\redo02.log') size 5m 14* noarchivelog 15 / create database velu * error at line 1: ora-03114: not connected to oracle

sql> conn sys/oracle@velu as sysdba error: ora-12154: tns:could not resolve service name sql> shutdown immediate ora-01041: internal error. hostdef extension doesn't exist sql> sql> sql> sql> sql> --------- to create a service oradim -new -sid pop1 -pfile 'd:\oracle\admin\pop1\pfile\init.ora' -startmode a sql> sql> sql> after creating the manual dataabase we want to run the two script sp2-0734: unknown command beginning "after crea..." - rest of line ignored. sql> sql> sql> sql> --------- \oracl\ora92\rdbms\admin\catalog.sql' sql> sql> --------- \oracle\or92\rdbms\admin\catproc.sql' sql> sql> sql> spool off