aix环境下为oracle数据库新建一个实例, 十万火急!! 怎么在aix环境下为oracle数据库新建一个实例, 比如test,并建立对应的用户(oracle数据库已经装好),十万火急!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 登录操作系统用dbca命令建立数据库,建好数据库后再建立用户 是数据库实例以装好,需要创建数据库吧。在 图形界面下运行 dbca 注:以下步骤只是一个参考实例,参考者注意修改参数值,比如用户名,SID,端口等,切记切记!!!1. 创建数据库用户:ora_billuseradd -d /LCdisk/oradata/bill -g dba ora_billroot:/LCdisk/oradata/bill>passwd ora_billsu – ora_bill2. 创建环境变量ORACLE_SID=testbill;3. 注意以下三个文件创建文件oracle:/home/oracle/product/9.2.0/dbs>more inittestacct.ora>inittestbill.oraroot:/home/oracle/product/9.2.0/dbs>chown ora_bill inittestbill.ora修改该文件内容#cache and I/ODB_BLOCK_SIZE=8192DB_CACHE_SIZE=20971520# Cursors and Library Cache#CURSOR_SHARING=SIMILAROPEN_CURSORS=300# Diagnostics and StatisticsBACKGROUND_DUMP_DEST='/LCdisk/oradata/bill/admin/bdump'CORE_DUMP_DEST=/LCdisk/oradata/bill/admin/cdump#TIMED_STATISTICS=TRUEUSER_DUMP_DEST='/LCdisk/oradata/bill/admin/udump'# Control File Configurationcontrol_files = ("/LCdisk/oradata/bill/ctlfile1", "/LCdisk/oradata/bill/ctlfile2")# ArchiveLOG_ARCHIVE_DEST_1='LOCATION=/LCdisk/oradata/bill/archive'LOG_ARCHIVE_FORMAT=%t_%s.dbfLOG_ARCHIVE_START=FALSE# Shared Server# Uncomment and use first DISPATCHES parameter below when your listener is# configured for SSL# (listener.ora and sqlnet.ora)# DISPATCHERS = "(PROTOCOL=TCPS)(SER=MODOSE)",dispatchers='(PROTOCOL=TCP) (SERVICE=testbillXDB)'# MiscellaneousCOMPATIBLE=9.2.0DB_NAME=testbillINSTANCE_NAME=testbillManually Creating an Oracle Database# PoolsJAVA_POOL_SIZE=31457280LARGE_POOL_SIZE=1048576SHARED_POOL_SIZE=52428800# Processes and SessionsPROCESSES=150# Redo Log and Recovery#FAST_START_MTTR_TARGET=300# Resource Manager#RESOURCE_MANAGER_PLAN=SYSTEM_PLAN# Sort, Hash Joins, Bitmap IndexesSORT_AREA_SIZE=524288# Automatic Undo ManagementUNDO_MANAGEMENT=AUTOUNDO_TABLESPACE=undotbs修改以下文件ora_bill:/home/oracle/product/9.2.0/network/admin>vi listener.ora添加:LISTENER3= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.91)(PORT = 1521)) )SID_LIST_LISTENER3 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = testbill) (ORACLE_HOME = /home/oracle/product/9.2.0) (SID_NAME = testbill) ) )修改文件ora_bill:/home/oracle/product/9.2.0/network/admin>vi tnsnames.ora添加TESTBILL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.91)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = testbill) ) )4. 创建目录ora_bill:/LCdisk/oradata/bill/admin/udump>ora_bill:/LCdisk/oradata/bill/admin/bdump>ora_bill:/LCdisk/oradata/bill/admin/cdump>root:/LCdisk/oradata/bill/admin>chown oracle *root:/LCdisk/oradata/bill>chmod -R 777 adminroot:/LCdisk/oradata/bill/admin>su - ora_bill5. 创建数据库实例ora_bill:/LCdisk>sqlplus /nologSQL> conn / as sysdbaSQL> startup nomountSQL> CREATE DATABASE TESTBILL 2 USER SYS IDENTIFIED BY hncs 3 USER SYSTEM IDENTIFIED BY hncs 4 LOGFILE GROUP 1 ('/LCdisk/oradata/bill/redo01.log') SIZE 256M, 5 GROUP 2 ('/LCdisk/oradata/bill/redo02.log') SIZE 256M, 6 GROUP 3 ('/LCdisk/oradata/bill/redo03.log') SIZE 256M 7 MAXLOGFILES 5 8 CHARACTER SET ZHS16GBK 9 NATIONAL CHARACTER SET AL16UTF16 10 DATAFILE '/LCdisk/oradata/bill/system01.dbf' SIZE 1024M REUSE 11 DEFAULT TEMPORARY TABLESPACE tempts1 12 TEMPFILE '/LCdisk/oradata/bill/temp01.dbf' 13 SIZE 4096M REUSE 14 UNDO TABLESPACE undotbs 15 DATAFILE '/LCdisk/oradata/bill/undotbs01.dbf'16 SIZE 4096M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;Database created.SQL> create user testbill identified by "1234"; 2 /User created.SQL> grant dba to testbill;Grant succeeded.SQL> grant connect to testbill;Grant succeeded.6. 运行脚本(创建系统对象)----------------------------------------------------------------------------------@/home/oracle/product/9.2.0/rdbms/admin/catalog.sql;@/home/oracle/product/9.2.0/rdbms/admin/catexp7.sql;@/home/oracle/product/9.2.0/rdbms/admin/catblock.sql;@/home/oracle/product/9.2.0/rdbms/admin/catproc.sql;@/home/oracle/product/9.2.0/rdbms/admin/catoctk.sql;@/home/oracle/product/9.2.0/rdbms/admin/owminst.plb;connect SYSTEM/manager@/home/oracle/product/9.2.0/sqlplus/admin/pupbld.sql;-----------------------------------------------------------------------connect SYSTEM/manager@/home/oracle/product/9.2.0/sqlplus/admin/help/hlpbld.sql; (param:helpus)--//.sql) 7. 重启数据库SQL> conn / as sysdbaConnected.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 131563864 bytesFixed Size 741720 bytesVariable Size 109051904 bytesDatabase Buffers 20971520 bytesRedo Buffers 798720 bytesDatabase mounted.Database opened.创建OK,以上仅供参考! 今天已建好了~非常谢谢大家,特别是kinglht(爱新觉罗至尊宝) ,好详细啊,不过很多不懂啊,呵呵,还要好好努力~大家可以借助 x-manager or x-win之类的能够显示图形界面的工具连到服务器上运行dbca按提示创建,一般不会出什么错.直接在 aix字符界面输入命令dbca是不会弹出你想要的界面的.其他参数可以在安装好后调整~还有就是调整了db_cache_size这类非动态参数后,要重启数据库才有用. Red Hat enterprise server release 5 (Tikanga)端口如何改? 特殊的月平均人数求法 精通oracle函数的进来看看 怎么截取括号里的内容 请问oracle数据库A用户导B表的权限命令 关于裸设备上的ORACLE问题,十分不解 我都快哭了~~求教 ORACLE8i,9i,10g的安装问题(本问题可达350分) 请教高手关于动态游标的问题? oracle初学者问题! DBLINK创建的奇怪问题。。。 请问谁有metalink的帐号,能否帮忙查查ora-00600[1153][15]错误的解释
在 图形界面下运行 dbca
1. 创建数据库用户:ora_bill
useradd -d /LCdisk/oradata/bill -g dba ora_bill
root:/LCdisk/oradata/bill>passwd ora_bill
su – ora_bill
2. 创建环境变量ORACLE_SID=testbill;
3. 注意以下三个文件
创建文件
oracle:/home/oracle/product/9.2.0/dbs>more inittestacct.ora>inittestbill.ora
root:/home/oracle/product/9.2.0/dbs>chown ora_bill inittestbill.ora
修改该文件内容
#cache and I/O
DB_BLOCK_SIZE=8192
DB_CACHE_SIZE=20971520
# Cursors and Library Cache
#CURSOR_SHARING=SIMILAR
OPEN_CURSORS=300
# Diagnostics and Statistics
BACKGROUND_DUMP_DEST='/LCdisk/oradata/bill/admin/bdump'
CORE_DUMP_DEST=/LCdisk/oradata/bill/admin/cdump
#TIMED_STATISTICS=TRUE
USER_DUMP_DEST='/LCdisk/oradata/bill/admin/udump'
# Control File Configuration
control_files = ("/LCdisk/oradata/bill/ctlfile1", "/LCdisk/oradata/bill/ctlfile2")
# Archive
LOG_ARCHIVE_DEST_1='LOCATION=/LCdisk/oradata/bill/archive'
LOG_ARCHIVE_FORMAT=%t_%s.dbf
LOG_ARCHIVE_START=FALSE
# Shared Server
# Uncomment and use first DISPATCHES parameter below when your listener is
# configured for SSL
# (listener.ora and sqlnet.ora)
# DISPATCHERS = "(PROTOCOL=TCPS)(SER=MODOSE)",
dispatchers='(PROTOCOL=TCP) (SERVICE=testbillXDB)'
# Miscellaneous
COMPATIBLE=9.2.0
DB_NAME=testbill
INSTANCE_NAME=testbill
Manually Creating an Oracle Database
# Pools
JAVA_POOL_SIZE=31457280
LARGE_POOL_SIZE=1048576
SHARED_POOL_SIZE=52428800
# Processes and Sessions
PROCESSES=150
# Redo Log and Recovery
#FAST_START_MTTR_TARGET=300
# Resource Manager
#RESOURCE_MANAGER_PLAN=SYSTEM_PLAN
# Sort, Hash Joins, Bitmap Indexes
SORT_AREA_SIZE=524288
# Automatic Undo Management
UNDO_MANAGEMENT=AUTO
UNDO_TABLESPACE=undotbs修改以下文件
ora_bill:/home/oracle/product/9.2.0/network/admin>vi listener.ora
添加:
LISTENER3=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.91)(PORT = 1521))
)SID_LIST_LISTENER3 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = testbill)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = testbill)
)
)修改文件
ora_bill:/home/oracle/product/9.2.0/network/admin>vi tnsnames.ora
添加
TESTBILL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.91)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testbill)
)
)4. 创建目录
ora_bill:/LCdisk/oradata/bill/admin/udump>
ora_bill:/LCdisk/oradata/bill/admin/bdump>
ora_bill:/LCdisk/oradata/bill/admin/cdump>
root:/LCdisk/oradata/bill/admin>chown oracle *
root:/LCdisk/oradata/bill>chmod -R 777 admin
root:/LCdisk/oradata/bill/admin>su - ora_bill5. 创建数据库实例
ora_bill:/LCdisk>sqlplus /nolog
SQL> conn / as sysdba
SQL> startup nomount
SQL> CREATE DATABASE TESTBILL
2 USER SYS IDENTIFIED BY hncs
3 USER SYSTEM IDENTIFIED BY hncs
4 LOGFILE GROUP 1 ('/LCdisk/oradata/bill/redo01.log') SIZE 256M,
5 GROUP 2 ('/LCdisk/oradata/bill/redo02.log') SIZE 256M,
6 GROUP 3 ('/LCdisk/oradata/bill/redo03.log') SIZE 256M
7 MAXLOGFILES 5
8 CHARACTER SET ZHS16GBK
9 NATIONAL CHARACTER SET AL16UTF16
10 DATAFILE '/LCdisk/oradata/bill/system01.dbf' SIZE 1024M REUSE
11 DEFAULT TEMPORARY TABLESPACE tempts1
12 TEMPFILE '/LCdisk/oradata/bill/temp01.dbf'
13 SIZE 4096M REUSE
14 UNDO TABLESPACE undotbs
15 DATAFILE '/LCdisk/oradata/bill/undotbs01.dbf'
16 SIZE 4096M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
Database created.SQL> create user testbill identified by "1234";
2 /User created.SQL> grant dba to testbill;Grant succeeded.SQL> grant connect to testbill;Grant succeeded.6. 运行脚本(创建系统对象)
----------------------------------------------------------------------------------
@/home/oracle/product/9.2.0/rdbms/admin/catalog.sql;@/home/oracle/product/9.2.0/rdbms/admin/catexp7.sql;@/home/oracle/product/9.2.0/rdbms/admin/catblock.sql;@/home/oracle/product/9.2.0/rdbms/admin/catproc.sql;@/home/oracle/product/9.2.0/rdbms/admin/catoctk.sql;@/home/oracle/product/9.2.0/rdbms/admin/owminst.plb;
connect SYSTEM/manager@/home/oracle/product/9.2.0/sqlplus/admin/pupbld.sql;-----------------------------------------------------------------------
connect SYSTEM/manager@/home/oracle/product/9.2.0/sqlplus/admin/help/hlpbld.sql; (param:helpus)--//.sql) 7. 重启数据库
SQL> conn / as sysdba
Connected.SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL> startup
ORACLE instance started.Total System Global Area 131563864 bytes
Fixed Size 741720 bytes
Variable Size 109051904 bytes
Database Buffers 20971520 bytes
Redo Buffers 798720 bytes
Database mounted.
Database opened.
创建OK,以上仅供参考!
非常谢谢大家,特别是kinglht(爱新觉罗至尊宝) ,好详细啊,不过很多不懂啊,呵呵,还要好好努力~
大家可以借助 x-manager or x-win之类的能够显示图形界面的工具连到服务器上运行dbca按提示创建,一般不会出什么错.
直接在 aix字符界面输入命令dbca是不会弹出你想要的界面的.
其他参数可以在安装好后调整~
还有就是调整了db_cache_size这类非动态参数后,要重启数据库才有用.