oracle手动建库脚本

-------------
mkdir -p /opt/oracle/admin/vobpod/utils
mkdir -p /opt/oracle/admin/vobpod/audit
mkdir -p /opt/oracle/admin/vobpod/cdump
mkdir -p /opt/oracle/admin/vobpod/create
mkdir -p /opt/oracle/admin/vobpod/change
mkdir -p /opt/oracle/admin/vobpod/log
mkdir -p /opt/oracle/admin/vobpod/ctl
mkdir -p /opt/oracle/admin/vobpod/pfile
mkdir -p /opt/oracle/admin/vobpod/udump
mkdir -p /opt/oracle/admin/vobpod/bdump
----------------------
mkdir -p /app/oradata/vobpoddb/control
mkdir -p /app/oradata/vobpoddb/redo
mkdir -p /app/oradata/vobpoddb/undo
mkdir -p /app/oradata/vobpoddb/temp
mkdir -p /app/oradata/vobpoddb/data
mkdir -p /app/oradata/vobpoddb/flashback
--------
chown -R oracle:dba /opt/oracle
chmod -R 775 /opt/oracle
chown -R oracle:dba /app/oradata
chmod -R 775 /app/oradata
----create dir
----copy the "passwordfile" and "pfile.ora" to $ORACLE_HOME/dbs

sqlplus /nolog
conn /as sysdba
startup nomount pfile='/opt/oracle/pfile.ora'

set echo on
spool  /opt/oracle/admin/vobpod/create/create_DB.log

CREATE DATABASE vobpoddb --- change DB name
MAXINSTANCES 1
MAXLOGHISTORY 2000
MAXLOGFILES 100
MAXLOGMEMBERS 3
MAXDATAFILES 1000
CHARACTER SET AL32UTF8 -- The default character set is ¡°US7ASCII¡±
EXTENT MANAGEMENT LOCAL
DATAFILE '/app/oradata/vobpoddb/data/system01.dbf' SIZE 1024M
SYSAUX DATAFILE '/app/oradata/vobpoddb/data/sysaux01.dbf' SIZE 1024M
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/app/oradata/vobpoddb/temp/temp01.dbf' SIZE 1024M
UNDO TABLESPACE "UNDOTBS"
 DATAFILE '/app/oradata/vobpoddb/undo/undotbs01.dbf' SIZE 1024M
LOGFILE
GROUP 1 ('/app/oradata/vobpoddb/redo/redo_01a.log',
 '/app/oradata/vobpoddb/redo/redo_01b.log') SIZE 512M,
GROUP 2 ('/app/oradata/vobpoddb/redo/redo_02a.log',
 '/app/oradata/vobpoddb/redo/redo_02b.log') SIZE 512M,
GROUP 3 ('/app/oradata/vobpoddb/redo/redo_03a.log',
 '/app/oradata/vobpoddb/redo/redo_03b.log') SIZE 512M,
GROUP 4 ('/app/oradata/vobpoddb/redo/redo_04a.log',
 '/app/oradata/vobpoddb/redo/redo_04b.log') SIZE 512M
USER SYS IDENTIFIED BY manager USER SYSTEM IDENTIFIED BY manager;

Spool off
--------------------------------
spool  /opt/oracle/admin/vobpod/create/createdbcatalog.log
@?/rdbms/admin/catalog.sql;
@?/rdbms/admin/catblock.sql;
@?/rdbms/admin/catproc.sql;
@?/rdbms/admin/catoctk.sql;
@?/rdbms/admin/owminst.plb;
Spool off
--------------------------------
Sql> alter user SYSTEM default tablespace SYSAUX;

Connect  system/manager;

spool  /opt/oracle/admin/vobpod/log/pupbld.log
@?/sqlplus/admin/pupbld.sql
Spool off;
--------------------

Connect / as sysdba

  spool  /opt/oracle/admin/vobpod/log/create_TS.log

create tablespace TOOLS datafile '/app/oradata/vobpoddb/data/tools.01.dbf' size 1024M       
extent management local  uniform size 128k
segment space management auto;

create tablespace USERS datafile '/app/oradata/vobpoddb/data/users.01.dbf' size 4096M       
extent management local uniform size 128k
segment space management auto;

spool off
----------------------Installing Java and Other Components
spool  /opt/oracle/admin/vobpod/log/Instaljava.log
Sql>select count (obj#) from obj$ where type#=28 or type#=29 or type#=30 or namespace=32;

Sql>@?/javavm/install/initjvm.sql

Sql>select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;

Sql>@?/xdk/admin/initxml.sql

 Sql>select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;

Sql>@?/xdk/admin/xmlja.sql
 
select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;

sql>@?/rdbms/admin/catjava.sql
sql>select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;
spool off
 
Spool  /opt/oracle/admin/vobpod/log/Mesaagegateway.log
Sql>@?/mgw/admin/catmgw.sql
 spool off
spool /opt/oracle/admin/vobpod/log/full_xmldb.log
sql>@?/rdbms/admin/catqm  &xmldb_password &ts_for_xmldb &temporart_tablespace
spool off
Note: Please assign tools as the default tablespace for schema XDB

 

-------------------------

--------------
alter user SYS identified by &new_sys_password account unlock;
alter user SYSTEM identified by &new_system_password account unlock;
alter user DBSNMP identified by &new_dbsnmp_password account unlock

----------
Using “utlrp” script recompile the invalid objects.
@?/rdbms/admin/utlrp.sql

-----------

alter user OUTLN default tablespace SYSAUX;
alter user DIP default tablespace SYSAUX;
alter user TSMSYS  default tablespace SYSAUX;
alter user DBSNMP default tablespace SYSAUX;