Manual database creation in RHEL 6.2x64 Oracle 11g

The name of the database to be created is dbshop 1: create the required directory export oracle_sid = dbshopmkdir-p $ oracle_base/oradata/$ export-p $ oracle_base/admin/$ oracle_sid/adumpmkdir-p $ oracle_base/admin/$ oracle_sid/bdumpmkdir- p $ oracle_base/admin/$ oracle_sid/cdumpmkdir-p $ oracle_base/admin/$ oracle_sid/udumpmkdir-p $ oracle_base/admin/$ oracle_sid/pfile created in the $ ORACLE_HOME/DBS directory the parameter file initsid of oracle. ora, You can first copy the init. ora file, in the modify CP init. ora init $ Run the VI command to edit the init $ oracle_sid.ora file. Modify the file as follows: db_name = 'dbshop' memory _ target = 700 mprocesses = 150audit_file_dest = '/u01/Oracle/admin/dbshop/adump 'audit _ trail = 'db' dB _ block_size = 8192db_domain =' 'db _ recovery_file_dest = '/u01/Oracle/flash_recovery_area' dB _ recovery_file_dest_size = 2gdiagnostic_dest = '/u01/Oracle' dispatchers = '(Protocol = TCP) (service = dbshop) 'open _ cursors = 300remote_login_passwordfile = 'exclusi Ve 'undo _ tablespace = 'undomains1' # You may be want to ensure that control files are created on separate physical # devicescontrol_files = ('/u01/Oracle/oradata/dbshop/control01.ctl ', '/u01/Oracle/oradata/dbshop/control02.ctl', '/u01/Oracle/oradata/dbshop/control03.ctl') compatible = '11. 2.0 'create a password file: orapwd file = $ ORACLE_HOME/dbs/orapw $ oracle_sid Password = sys entries = 5 force = y create a database Script:/u01/createdb. the SQL content is as follows: CREA Te database dbshopmaxinstances 1 maxloghistory 1 maxlogfiles 5 maxlogmembers 5 maxdatafiles 100 datafile '/u01/Oracle/oradata/dbshop/system01.dbf 'size 100 m reuse autoextend on next 1 m your datafile'/u01/ oracle/oradata/dbshop/syaux01.dbf 'size 100 m reuse autoextend on next 1 m maxsize unlimiteddefault temporary tablespace temp tempfile'/u01/Oracle/oradata/dbshop/temp01.dbf' size 20 m Reuse autoextend on next 64 K maxsize unlimitedundo tablespace undotbs1 datafile '/u01/Oracle/oradata/dbshop/comment 'size 20 m reuse autoextend on next 5 m maxsize unlimitedlogfilegroup 1 ('/u01/ oracle/oradata/dbshop/redo01.dbf ') size 10 m, group 2 ('/u01/Oracle/oradata/dbshop/redo02.dbf') Size 10 m, group 3 ('/u01/Oracle/oradata/dbshop/redo03.dbf ') size 10 mcharacter set zhs16gbknational character se T al16utf16 log on to the database Su-oraclesqlplus/As sysdba and execute SQL> startup nomountsql> @/u01/createdb. sqlsql> @? /Rdbms/admin/CATALOG. sqlsql> @? /Rdbms/admin/catproc. sqlsql> @? /Rdbms/admin/catexp. SQL -- Note :@? $ ORACLE_HOME