前摇

```
奇数为服务  偶数为管理managerment
建库需要看好建设在哪
```
###配置登陆显示
```
vi $ORACLE_HOME/sqlplus/admin/glogin.sql

define _editor='vi'
set sqlprompt "_user'@'_connect_identifier>"
```

###环境变量
```bash
export ORACLE_HOME=$ORACLE_BASE//product/11.2.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=PROD3
export path=$ORACLE_HOME/bin
```

###修改启动文件
```
cd $ORACLE_HOME/dbs
cat init.ora |grep -v \# |grep -v ^$ > initPROD3.ora

修改参数
db_name='PROD3'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/PROD3/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=PROD3XDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS'
control_files = (/u01/app/oracle/oradata/PROD3/ora_control1, /u01/app/oracle/oradata/PROD3/ora_control2)
compatible ='11.2.0'

创建所需目录
```
###创建密码文件
```
orapwd file=orapwPROD3 password=oracle entries=30
```

###建库
```
CREATE DATABASE PROD3
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD3/redo01a.log','/u01/app/oracle/oradata/PROD3//redo01b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/u01/app/oracle/oradata/PROD3/redo02a.log','/u01/app/oracle/oradata/PROD3//redo02b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/app/oracle/oradata/PROD3/redo03a.log','/u01/app/oracle/oradata/PROD3//redo03b.log') SIZE 100M BLOCKSIZE 512
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u01/app/oracle/oradata/PROD3/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD3/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/u01/app/oracle/oradata/PROD3/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/app/oracle/oradata/PROD3/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/u01/app/oracle/oradata/PROD3/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
```
### 脚本
```
vi 1.sh
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql

@1.sql
```
###表空间
```
create tablespace altp datafile '/u01/oracle/app/oracle/oradata/orcl/altp.dbf' 
size 48M extents management local  uniform seze 2M segment space management auto;

alter system set undo_retention=5400;
```
###管理undo
```
show parameter undo

select tablespace_name,file_id,autoextensible from dba_data_files where tablespace_name='undotbs1';

alter database datafile 3 antoextend on;

alter system set processes=120 scope=spfile;

alter system set job_queue_processes=15;

shutdown IMMEDIATE

startup

show parameter processes

```

DBLOG

导航1234

最近发表

友情链接