Linux下手动创建数据库

最新推荐文章于 2024-06-26 16:40:03 发布

iteye_3911

最新推荐文章于 2024-06-26 16:40:03 发布

阅读量81

点赞数

分类专栏：软件综合文章标签： Linux Oracle SQL Flash Bash

本文链接：https://blog.csdn.net/iteye_3911/article/details/81894780

版权

软件综合专栏收录该内容

39 篇文章 0 订阅

订阅专栏

[size=large][b]环境：已经存在一个数据库，且运行正常
其他环境设置和检查如下：[/b][/size]
spsuzor01:~ # grep oracle /etc/passwd
oracle:x:1000:1000::/opt/oracle:/bin/bash
spsuzor01:~ # grep oinstall /etc/group
oinstall:!:1000:
spsuzor01:~ # grep dba /etc/group
dba:!:1001:oracle
spsuzor01:~ # su - oracle
oracle@spsuzor01:~> echo $SHELL
/bin/bash
oracle@spsuzor01:~> ORACLE_SID=spsuzdb2
oracle@spsuzor01:~> export ORACLE_SID
oracle@spsuzor01:~>
oracle@spsuzor01:~> ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
oracle@spsuzor01:~> export ORACLE_HOME
oracle@spsuzor01:~>
oracle@spsuzor01:~> ORACLE_BASE=/opt/oracle
oracle@spsuzor01:~> export ORACLE_BASE
oracle@spsuzor01:~>
[size=large][b]create the pfile into the location /opt/oracle/product/10.2.0/db_1/dbs/initspsuzdb2.ora[/b][/size]

[size=large][b]put the spsuzdb2_manually.sql into /opt/oracle[/b][/size]

[size=large][b]please create all the folder and files under user oracle[/b][/size]

/data/oradata/SPSUZDB2/onlinelog/
/opt/oracle/flash_recovery_area/SPSUZDB2/onlinelog
/data/oradata/SPSUZDB2/datafile/
/data/oradata/SPSUZDB2/controlfile/
/opt/oracle/flash_recovery_area/SPSUZDB2/controlfile

[size=large][b]Do as below[/b][/size]
oracle@spsuzor01:~>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 20 15:27:04 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1267236 bytes
Variable Size 318769628 bytes
Database Buffers 922746880 bytes
Redo Buffers 15507456 bytes
SQL> @/opt/oracle/spsuzdb2_manually.sql

Database created.

SQL>@?/rdbms/admin/catalog.sql
SQL>@?/rdbms/admin/catproc.sql
SQL>@?/sqlplus/admin/pupbld.sql
SQL> create spfile from pfile;

File created.

SQL>shutdown
SQL>startup
SQL>@/opt/oracle/DBinit/sp_init.sql
[b][size=large]change below files[/size][/b]
oracle@spsuzor01:~/product/10.2.0/db_1/network/admin> ls
listener.ora samples shrept.lst tnsnames.ora
-- change the listener.ora and tnsnames.ora to add spsuzdb2 instance
spsuzor01:~ # ls -l /etc/oratab
-rw-rw-r-- 1 oracle root 764 Jul 20 17:45 /etc/oratab
spsuzor01:~ #