ITPub博客

首页 > 数据库 > Oracle > oracle10.2.0.3 on solaris10(T2000) install

oracle10.2.0.3 on solaris10(T2000) install

原创 Oracle 作者:Basileus1999 时间:2007-10-22 22:30:16 0 删除 编辑

1、用户及组
#groupadd –g 1001 dba
# useradd –u 10001 -d /export/home/oracle -g dba –G dba –s /usr/bin/bash oracle
# passwd oracle
# mkdir /export/home/oracle

2、系统核心参数
vi /etc/system

set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100

3、用户环境变量
vi .profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

# Select the appropriate ORACLE_BASE
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH; export PATH

[@more@]

4、建立安装目录
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle:dba /u01

5、准备软件
#gunzip 10gr2_db_sol.cpio.gz
#cpio –idmv < 10gr2_db_sol.cpio

6、安装
./runInstaller

7、升级到10.2.0.3
$ unzip p5337014_10203_SOLARIS64.zip
su - oracle
% cd patchset_directory/Disk1
% ./runInstaller

8、建数据库

9、配置网络
listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostip)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)

tnsnames.ora,配置后结果如下:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


10、导出和导入数据
Format: expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

Format: impdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/289961/viewspace-978066/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论
  • 博文量
    1
  • 访问量
    84278