一共分为8步:
1、设置实例名:
修改/home/oracle/.bash_profile文件,添加下列这行内容。
export ORACLE_SID=orcl
修改之后使用命令source /home/oracle/.bash_profile让它生效。
2、创建相关目录:
mkdir /u01/app/oracle/oradata/orcl
mkdir /u01/app/oracle/admin/orcl
mkdir /u01/app/oracle/admin/orcl/adump
mkdir /u01/app/oracle/admin/orcl/bdump
mkdir /u01/app/oracle/admin/orcl/cdump
mkdir /u01/app/oracle/admin/orcl/udump
3、创建密码文件:
cd /u01/app/oracle/product/10.2.0/db_1/dbs
orapwd file=orapworcl password=oracle entries=10 force=y
4、创建参数文件:
cd /u01/app/oracle/product/10.2.0/db_1/dbs
cat init.ora|grep -v ^#|grep -v ^$>initorcl.ora
修改initorcl.ora文件,内容如下:
db_name=orcl
db_block_size=8192
undo_management=auto
undo_tablespace=undotbs
sga_target=500m
control_files=('/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl')
audit_file_dest='/u01/app/oracle/admin/orcl/adump'
background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
user_dump_dest='/u01/app/oracle/admin/orcl/udump'
5、生成spfile文件,并启动到nomount状态:
sqlplus / as sysdba
create spfile from pfile;
startup nomount;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12961536/viewspace-764483/ ,如需转载,请注明出处,否则将追究法律责任。