$whoami
oracle
$cd $oracle_home/dbs
$ls
可以看到参数文件initorcl.ora,spfileorcl.ora.
$cat spfileorcl.ora |more --查看服务器参数文件
$cat initorcl.ore | pg
PFILE文件initorcl.ora不存在
SQL>create pfile from spfile;
$ cat spfileorcl.ora | pg
**********************
SQL>show parameter spfile;
数据库通过spfile启动.
SQL>alter system set sga_max_size =620M scope=spfile;
SQL>shutdown immediate;
SQL>show parameter sga_max_size;
参数被修改
注意:如果数据库是通过PFILE启动,则不能用alter system 调整参数!
******************参数文件的操作pfile和spfile互相可以创建
SQL> create spfile = '/db/oracle/spfileorcl.ora' from
pfile = '/db/oracle/product/10.2.0/db_1/dbs/initorcl.ora';
SQL>create pfile = '/db/oracle/initorcl.ora' from
spfile='/db/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora';
*****************
在Unix无需创建实例,只需指定环境变量,然后输出.所以需要修改oracle用户的概要文件/home/oracle/.profile,内容如下:
ORACLE_SID=sdzy
ORACLE_BASE=/db/oracle
ORACLE_HOME=$ORACLE_HOME/product/10.2.0/db_1
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID ORACLE_BASE ORACLE_HOME PATH
重新以oracle用户登陆,检查其环境变量
$whoami
oracle
$
$env|grep ORACLE
--创建口令文件,名为orapwsdzy
$orapwd file = /db/product/10.2.0/db_1/dbs/orapwsdzy password=oracle
$
$ls /db/product/10.2.0/db_1/dbs/orapwsdzy
/db/product/10.2.0/db_1/dbs/orapwsdzy
创建完毕
--创建目录结构,用来存放各种数据库文件
$mkdir -p /db/admin/sdzy/adump
$mkdir -p /db/admin/sdzy/bdump
$mkdir -p /db/admin/sdzy/cdump
$mkdir -p /db/admin/sdzy/pfile
$mkdir -p /db/admin/sdzy/udump
$mkdir -p /flash_recovery_area
$mkdir -p /db/oradata/sdzy
--创建所需的参数文件
$cd /db/admin/sdzy/pfile
$
$touch init.ora --创建文件
$
使用vi工具将下面内容添加到init.ora中;
db_name=sdzy
db_domain=""
sga_target=285212672
pga_aggregate_target=94371840
db_block_size=8192
db_file_multiblock_read_count=16
open_cursors=300
processes=150
background_dump_dest=/db/admin/sdzy/bdump
core_dump_dest=/db/admin/sdzy/cdump
user_dump_dest=/db/admin/sdzy/udump
audit_file_dest=/db/admin/sdzy/adump
control_file = ("/db/oradata/sdzy/control01.ctl","/db/oradata/sdzy/control02.ctl")
db_recovery_file_dest = /flash_recovery_area
db_recovery_file_dest_size=2147483648
log_archive_format =%t_%s_%r.dbf
compatible=10.2.0.1.0
remote_login_passwordfile=EXCLUSIVE
undo_management=AUTO
undo_tablespace=UNDOTBS1
***启动实例创建数据库
$sqlplus "/as sysdba"
SQL> startup nomount pfile=/db/admin/sdzy/pfile/init.ora
CREATE DATABASE SDZY
DATAFILE 'db/oradata/sdzy/system01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'db/oradata/sdzy/sysaux01.dbf' SIZE 120M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITEND
SMALLFILE DEFAULT TEMPORARY TABLESPACE
TEMP TEMPFILE '/db/oradata/sdzy/temp01.dbf' SIZE 20M RRUSE
AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/db/oradata/sdzy/undotbs01.dbf' SIZE 200 REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/db/oradata/sdzy/redo01.log') SIZE 51200K,
GROUP 2('/db/oradata/sdzy/redo02.log') SIZE 51200K,
GROUP 3('/db/oradata/sdzy/redo03.log') SIZE 51200K
USER SYS INENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle;
SQL> host ls /db/oradata/sdzy
--创建表空间USERS,并设置为数据库默认表空间
SQL>CREATE SMALLFILE TABLESPACE USERS LOGGING DATAFILE 'db/oradata/sdzy/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTEND MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
SQL>ALTER DATABASE DEFAULT TABLESPACE USERS;
--安装数据字典视图
SQL> @ /db/product/10.2.0/db_1/rdbms/admin/catalog.sql;
SQL> @ /db/product/10.2.0/db_1/rdbms/admin/catproc.sql;
--创建PL/SQL资源集
SQL> connect system/oracle
SQL>@ /db/product/10.2.0/db_1/sqlplus/admin/pupbld.sql;
SQL>connect system/oracle
SQL>@ /db/product/10.2.0/db_1/sqlplus/admin/help/hlpbld.sql helpus.sql;
--创建数据库控制器服务
$emca -config dbcontrol db -repos create
一套精简的数据库创建完成
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24214296/viewspace-1035735/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24214296/viewspace-1035735/