See Unix profiles, Web Services, How to Statspack, How to install, patch and interim for folders permissions First of all you need an instance, please refer to how to create an instance
Suppose db name is reposit, $ORACLE_BASE is /opt/ora9, init parameter undo_tablespace='UNDOTBS1'
Character set #Remember that a character set of a database can be determined using: select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET' |
|
Bring database to nomount state, and issue CREATE DATABASE reposit
|
Create Dictionary Views
as sys launch: nohup sqlplus "/ as sysdba" @?/rdbms/admin/catalog.sql & nohup sqlplus "/ as sysdba" @?/rdbms/admin/catproc.sql & nohup sqlplus "/ as sysdba" @?/rdbms/admin/catblock.sql & #install text indexes, <ctxsys pwd> <tbs> nohup sqlplus "/ as sysdba" @?/ctx/admin/catctx.sql ctxsys context temp nolock & #install default localized option US sqlplus ctxsys/ctxsys @?/ctx/admin/defaults/drdefus.sql #caution, be sure to view this log, init.ora may be underestimated nohup sqlplus "/ as sysdba" @?/javavm/install/initjvm.sql & #Optional install Web Services as system launch the script to permit connectivity with Oracle7 versions: @?/sqlplus/admin/pupbld.sql I recommend to sql an ALTER DATABASE FORCE LOGGING; alter database archivelog; #if needed Now we add a tablespace for user data sql>create tablespace "USER" logging datafile '/opt/ora9/oradata/reposit/USER.dbf' size 5M extent management local segment space management auto; sql>alter database datafile '/opt/ora9/oradata/reposit/USER.dbf' autoextend on next 1M; Install PERFSTAT How to Statspack