startup nomount pfile=/u01/oracle/product/11.2.0.1/db1/dbs/initcrm.ora;
create database crm
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile '/u01/oracle/oradata/system01.dbf' size 1024m reuse
extent management local
sysaux datafile '/u01/oracle/oradata/sysaux01.dbf' size 500m reuse
smallfile default temporary tablespace temp tempfile '/u01/oracle/oradata/temp01.dbf' size 20m reuse
smallfile undo tablespace undotbs1 datafile '/u01/oracle/oradata/undo01.dbf' size 300m reuse
character set zhs16gbk
national character set al16utf16
logfile group 1 ('/u01/oracle/oradata/log01.dbf') size 50m,
group 2 ('/u01/oracle/oradata/log02.dbf') size 50m,
group 3 ('/u01/oracle/oradata/log03.dbf') size 50m;
创建users表空间
create smallfile tablespace users logging datafile '/u01/app/oradata/user01.dbf' size 1000m reuse extent management local segment space management auto;
alter database default tablespace users;
------------------------------------------
sql> create spfile from pfile;
file created.
-----------------------------------------
sqlplus / as sysdba
sql> show user;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catalog.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catblock.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catproc.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catoctk.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/owminst.plb;
使用system用户编译
@/u01/oracle/product/11.2.0.1/db1/sqlplus/admin/pupbld.sql;
@/u01/oracle/product/11.2.0.1/db1/sqlplus/admin/help/hlpbld.sql helpus.sql;
使用sys用户编译
@/u01/oracle/product/11.2.0.1/db1/javavm/install/initjvm.sql;
@/u01/oracle/product/11.2.0.1/db1/xdk/admin/initxml.sql;
@/u01/oracle/product/11.2.0.1/db1/xdk/admin/xmlja.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catjava.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catexf.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catqm.sql change_on_install sysaux temp yes;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catxdbj.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catrul.sql;
spool /oracle/admin/edidb/scripts/ordinst.log append
@/u01/oracle/product/11.2.0.1/db1/ord/admin/ordinst.sql sysaux sysaux;
spool off
spool /u01/oracle/admin/ora11g/scripts/intermedia.log append
@/u01/oracle/product/11.2.0.1/db1/ord/im/admin/iminst.sql;
spool off
set echo on
spool /oracle/admin/edidb/scripts/lockaccount.log append
begin
for item in ( select username from dba_users where account_status in ('open', 'locked', 'expired') and username not in (
'sys','system') )
loop
dbms_output.put_line('locking and expiring: ' || item.username);
execute immediate 'alter user ' ||
sys.dbms_assert.enquote_name(
sys.dbms_assert.schema_name(
item.username),false) || ' password expire account lock' ;
end loop;
end;
/
spool off
到此，数据库实例建立完毕。
6.配置tns与listenser /u01/oracle/product/11.2.0.1/db1/network/admin/下
tnsnames.ora
crm = (description =
(address_list = (address =
(protocol = tcp) (host = 127.0.0.1)(port = 1521)
)
)
(connect_data = (service_name = crm)
)
)
listener.ora 监听方式有多种，要求不高的话建议复用原监听，，好处是变动小，缺点是不同实例公用监听，可能会不方便。
listener.ora
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = orcl)
(oracle_home = /u01/oracle/product/11.2.0.1/db1)
(program = extproc)
)
(sid_desc =
(global_dbname = crm)
(oracle_home = /u01/oracle/product/11.2.0.1/db1)
(sid_name = crm)
)
)
单配监听：