Aix Oracle 12154,aix下oracle数据库管理

$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@]